Lawson Insight Technical Documentation |
|
TAEMPTRANS
TAEMPTRANS FILE
This file contains the accrual plan transactions for each plan structure for
an employee.
REFERENCED BY
HR11.1 HR511 LP100 LP101 LP264 LP31.1
PA100 PA52.4 LP270 LP240 PR160 PR180
PR80.2 LP64.1
UPDATED BY
LP130 LP138 LP140 LP145 LP180 LP197
LP198 LP331 LP370 LP570 LP70.1 LP70.2
LP80.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
TTR-COMPANY Numeric 4 LP130 LP138
Element: Company Hr Contains the company number. LP140 LP145
LP180 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-EMPLOYEE Numeric 9 LP130 LP138
Element: Employee Contains the employee number. Each LP140 LP145
person employed by the company is LP180 LP370
assigned a unique number. The system LP570 LP70.1
uses the employee number to correlate LP70.2 LP80.1
all of the information related to that
person.
TTR-PLAN Alpha 10 LP130 LP138
Element: Ta Plan Contains the absence plan name. LP140 LP145
LP180 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-EMPLOYEE-GROUP Alpha 10 LP130 LP138
Element: Group Name Contains the accrual employee group LP140 LP145
which, when attached to a plan, LP180 LP370
represents an absence plan structure. LP570 LP70.1
LP70.2 LP80.1
TTR-POSITION Alpha 12 LP130 LP138
Element: Position Contains the position code of the LP140 LP145
employee if plan balances are held at LP180 LP370
the position code level. LP570 LP70.1
LP70.2 LP80.1
TTR-DATE Numeric 8 (yyyymmdd) LP130 LP138
Element: Ta Tran Date Contains the date of the transaction. LP140 LP145
For events, the transaction date is LP180 LP370
determined based on the date of the LP570 LP70.1
event. Otherwise, the transaction date LP70.2 LP80.1
is based on the plan cycle frequency or
the pay period end date of service
records processed.
TTR-SEQ-NBR Numeric 4 LP130 LP138
Element: Seq Nbr Contains a unique sequence number that LP140 LP145
keeps records unique. It is LP180 LP370
automatically assigned when records are LP570 LP70.1
created. LP70.2 LP80.1
TTR-TRAN-TYPE Numeric 2 LP130 LP138
Element: Ta Type Contains the transaction type. LP140 LP145
LP180 LP370
Transaction type 11 and 12 are created LP570 LP70.1
by LP138. LP70.2 LP80.1
01 = Manual Accrual
02 = Manual Allotment
03 = Manual Available
04 = Manual Reserve
05 = Manual Carryover
11 = Sell from Available
12 = Purchase for Available
21 = Accrual
22 = Allotment
31 = Transfer from Accrual
32 = Transfer from Allotment
33 = Transfer to Avail from Accr
34 = Transfer to Avail from Allot
35 = Creation of carryover balance
42 = Lost Accr-Ongoing Limit
43 = Lost Allot-Ongoing Limit
44 = Lost Avail-Carryover Limit
45 = Lost Avail-Carry Period Limit
46 = Lost Carry-Period Limit
47 = Reset Carry-Carryover Recalc
51 = Allotment Adj for Factor Chgs
52 = Allotment Adj for Accruals
61 = Use
63 = Payout
81 = Transfer Accrual Bal
82 = Transfer Allotment Bal
83 = Transfer Available Bal
84 = Transfer Reserve Bal
85 = Transfer Carryover Bal
91 = Purge Accrual Bal
92 = Purge Allotment Bal
93 = Purge Available Bal
94 = Purge Reserve Bal
95 = Purge Carryover Bal
TTR-BALANCE-TYPE Numeric 2 LP130 LP138
Element: Ta Type Determines which TAEEMASTER balance to LP140 LP145
adjust. LP180 LP370
01 = Accrual LP570 LP70.1
02 = Allotment LP70.2 LP80.1
03 = Available
04 = Reserve
05 = Carryover
TTR-DESCRIPTION Alpha 30 (Lower Case) LP130 LP138
Element: Ta DescriptionContains the transaction description. LP140 LP145
LP180 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-TA-TYPE Numeric 2 LP130 LP138
Element: Ta Type Contains the transaction units of LP140 LP145
measure. LP180 LP370
01 = Hours LP570 LP70.1
02 = Earnings LP70.2 LP80.1
TTR-TA-HOURS Signed 18.6 LP130 LP138
Element: Ta Amount Contains the hours associated with the LP140 LP145
transaction. Used with TA-Type = 1 LP180 LP370
(Hours). LP570 LP70.1
LP70.2 LP80.1
PR80.2
TTR-TA-EARNINGS Signed 18.6 LP130 LP138
Element: Ta Amount Contains the earnings associated with LP140 LP145
the transaction. Used with TA-Type = 2 LP180 LP370
(Earnings). LP570 LP70.1
LP70.2 LP80.1
PR80.2
TTR-CURRENCY-CODE Alpha 5 LP130 LP138
Element: Currency Code Contains the currency code for the LP140 LP145
transaction. Used with TA-Type = 2 LP180 LP370
(Earnings). LP570 LP70.1
LP70.2 LP80.1
TTR-TA-LOS-CALC Signed 9.2 LP130 LP138
Element: Ta Los Calc Contains the length of service hours or LP140 LP145
cycles used to determine the amount of LP180 LP370
this transaction.
TTR-STATUS Numeric 1 LP130 LP138
Element: Ta Status Contains the the status of the LP140 LP145
transaction. Updated by TA140, TA197. LP180 LP197
0 = Unprocessed LP370 LP570
2 = Processed LP70.1 LP70.2
3 = Transferred LP80.1
9 = Closed
TTR-TA-OBJ-ID Numeric 12 LP130 LP138
Element: Obj Id This object ID will associate LP370
transactions created by LP138 to
specific benefit plan enrollments and
balances in BNTAEMPBAL.
TTR-PROCESS-DATE Numeric 8 (yyyymmdd) LP130 LP138
Element: Ta Tran Date Contains the process through date of the LP140 LP145
LP140 job that processed this LP370
transaction.
TTR-RESET-DATE Numeric 8 (yyyymmdd) LP130 LP138
Element: Ta Reset Date Contains the Reset Date determined by LP140 LP145
the Reset Point. This is the first date LP197 LP370
of the limit year. This will be the
date used by LP197 when accumulating
transactions into TATRANSUM file by
reset date.
TTR-PLAN-CATEGORY Alpha 10 LP130 LP138
Element: Ta Category Contains the category for the plan. This LP140 LP145
is needed for limit check by plan LP180 LP370
category that will read open TAEMPTRANS
record.
TTR-ALLOT-PER-BEG Numeric 8 (yyyymmdd) LP130 LP138
Element: Ta Tran Date For allotments, contains the beginning LP140 LP145
date of the allotment period. LP370
TTR-ALLOT-PER-END Numeric 8 (yyyymmdd) LP130 LP138
Element: Ta Tran Date For allotments, contains the end date of LP140 LP145
the allotment period. LP370
TTR-ALLOT-CYCLE-DT Numeric 8 (yyyymmdd) LP130 LP138
Element: Ta Tran Date For cycle based allotments, contains the LP140 LP145
cycle date. LP370
TTR-CLOSE-DATE Numeric 8 (yyyymmdd) LP130 LP138
Element: Ta Tran Date Contains the system date that LP197 LP197 LP370
closed this transaction.
TTR-GL-POST-DATE Numeric 8 (yyyymmdd) LP130 LP138
Element: Ta Tran Date For non reversing entries, this LP198 LP370
references the GL Post Date used on
LP198.
TTR-HM-PROC-LEVEL Alpha 5 LP130 LP138
Element: Process Lev HrContains the employee's home process LP140 LP145
level. LP180 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-CREATE-DATE Numeric 8 (yyyymmdd) LP130 LP138
Element: Date Stamp Holds the server date this record was LP140 LP145
originally created. LP180 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-CREATE-TIME Numeric 6 (hhmmss) LP130 LP138
Element: Time Stamp Holds the server time this record was LP140 LP145
originally created. LP180 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-CREATE-USER-ID Alpha 10 (Lower Case) LP130 LP138
Element: User Contains the user ID of the person who LP140 LP145
originally created this record. LP180 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-DATE-STAMP Numeric 8 (yyyymmdd) LP130 LP138
Element: Date Stamp This field contains the server date LP140 LP145
(month, date, and year) of the last LP180 LP197
change to this record. LP198 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-TIME-STAMP Numeric 6 (hhmmss) LP130 LP138
Element: Time Stamp Contains the server time (hour, minute, LP140 LP145
and second) when the record was last LP180 LP197
changed. LP198 LP370
LP570 LP70.1
LP70.2 LP80.1
TTR-USER-ID Alpha 10 (Lower Case) LP130 LP138
Element: User Contains the user ID of the person who LP140 LP145
last updated this record. LP180 LP197
LP198 LP370
LP570 LP70.1
LP70.2 LP80.1
TAEMPTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
TTRSET1 COMPANY HR11.1 HR511
EMPLOYEE LP100 LP101
PLAN LP130 LP140
EMPLOYEE-GROUP LP145 LP180
POSITION LP197 LP264
DATE LP31.1 LP331
SEQ-NBR LP370 LP70.1
LP70.2 LP80.1
PA100 PA52.4
TTRSET2 COMPANY Subset LP140 LP270
EMPLOYEE Where STATUS = Zeroes LP80.1
PLAN
EMPLOYEE-GROUP
POSITION
DATE
SEQ-NBR
TTRSET3 COMPANY LP145 LP70.2
PLAN
EMPLOYEE-GROUP
EMPLOYEE
POSITION
DATE
SEQ-NBR
TTRSET4 COMPANY Subset LP140 LP145
EMPLOYEE Where STATUS = 2 LP240 PR160
PLAN PR180 PR80.2
EMPLOYEE-GROUP
POSITION
DATE
SEQ-NBR
TTRSET5 COMPANY KeyChange LP130
HM-PROC-LEVEL
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
DATE
SEQ-NBR
TTRSET6 COMPANY KeyChange LP198
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
TA-TYPE
RESET-DATE
DATE*
SEQ-NBR
TTRSET7 COMPANY LP64.1
EMPLOYEE
PLAN
EMPLOYEE-GROUP
POSITION
DATE*
SEQ-NBR*
TTRSET8 COMPANY Subset LP197
EMPLOYEE Where STATUS = 2
PLAN Or STATUS = 3
EMPLOYEE-GROUP
POSITION
DATE
SEQ-NBR
TAEMPTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
TTR-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Currency CUCODES Required
When TTR-CURRENCY-CODE != Spaces
TTR-CURRENCY-CODE -> CUC-CURRENCY-CODE
Employee EMPLOYEE Required
TTR-COMPANY -> EMP-COMPANY
TTR-EMPLOYEE -> EMP-EMPLOYEE
Employee Group PERSGROUP Required
TTR-COMPANY -> PRG-COMPANY
TTR-EMPLOYEE-GROUP -> PRG-GROUP-NAME
Employee Mastr TAEEMASTER Required
TTR-COMPANY -> TEM-COMPANY
TTR-EMPLOYEE -> TEM-EMPLOYEE
TTR-PLAN -> TEM-PLAN
TTR-EMPLOYEE-GROUP -> TEM-EMPLOYEE-GROUP
TTR-POSITION -> TEM-POSITION
Hm Proc Level PRSYSTEM Required
When TTR-HM-PROC-LEVEL != Spaces
TTR-COMPANY -> PRS-COMPANY
TTR-HM-PROC-LEVEL -> PRS-PROCESS-LEVEL
Paemployee PAEMPLOYEE Required
TTR-COMPANY -> PEM-COMPANY
TTR-EMPLOYEE -> PEM-EMPLOYEE
Plan TAPLAN Required
TTR-COMPANY -> TAP-COMPANY
TTR-PLAN -> TAP-PLAN
Tatransum TATRANSUM Required
TTR-COMPANY -> TTS-COMPANY
TTR-EMPLOYEE -> TTS-EMPLOYEE
TTR-PLAN -> TTS-PLAN
TTR-EMPLOYEE-GROUP -> TTS-EMPLOYEE-GROUP
TTR-POSITION -> TTS-POSITION
TTR-TA-TYPE -> TTS-TA-TYPE
TTR-RESET-DATE -> TTS-RESET-DATE
TAEMPTRANS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION
Valid When TTR-POSITION != Spaces
TTR-COMPANY -> POS-COMPANY
TTR-POSITION -> POS-POSITION
POS-EFFECT-DATE
Tastructur TASTRUCTUR
TTR-COMPANY -> TST-COMPANY
TTR-EMPLOYEE-GROUP -> TST-EMPLOYEE-GROUP
TTR-PLAN -> TST-PLAN
TST-BEGIN-DATE
|