 |
Lawson Insight Technical Documentation |
|
EMTATRANS FILE
Emp Time Accrual Transactions
Contains time accrual transactions for each plan for an employee.
REFERENCED BY
HR170 HR650 HR70.1 PR160 PR180 PR80.2
TA196 TA241 TA50.1 TA60.1 TA147 TA270
TA175 TA265 TA290 TA65.3
UPDATED BY
BN138 PR130 TA146 TA148 TA170 TA180
TA181 TA198 TA199 TA300 TA310 TA340
TA341 TA42.1 TA542 TA570 TA70.1 TA70.2
TA80.1 TA81.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ETT-COMPANY Numeric 4 BN138 PR130
Company Contains the number that represents an TA146 TA148
established company. TA170 TA180
TA181 TA300
TA340 TA42.1
TA542 TA570
TA70.1 TA70.2
TA80.1 TA81.1
ETT-EMPLOYEE Numeric 9 BN138 PR130
Employee Contains the employee number which is TA146 TA148
used to correlate all information TA170 TA180
related to the employee. TA181 TA300
TA340 TA42.1
TA542 TA570
TA70.1 TA70.2
TA80.1 TA81.1
ETT-PLAN-NAME Alpha 10 BN138 PR130
From Plan Name Contains the plan name. This is TA146 TA148
verified in the Time Accrual Plan file. TA170 TA180
TA181 TA300
TA340 TA42.1
TA542 TA570
TA70.1 TA70.2
TA80.1 TA81.1
ETT-DATE Numeric 8 (yyyymmdd) BN138 PR130
Date Contains the date of the transaction. TA146 TA148
The transaction date can default from TA170 TA180
the end date of the payroll period, the TA181 TA300
last eligible date, or the eligible TA340 TA42.1
limit date defined for the plan. TA542 TA570
TA70.1 TA70.2
TA80.1 TA81.1
ETT-SEQ-NBR Numeric 4 BN138 PR130
Sequence Number Contains a sequence number that keeps TA146 TA148
records unique. It is automatically TA170 TA180
assigned when records are created. TA181 TA300
TA340 TA42.1
TA542 TA570
TA70.1 TA70.2
TA80.1 TA81.1
ETT-TYPE Alpha 2 BN138 PR130
Type Contains the transaction type. TA146 TA148
A = Accrual Hours TA170 TA180
B = Beginning balance from Purge TA181 TA300
LA = Lost Accrual TA340 TA42.1
LE = Lost Eligible TA542 TA570
MA = Manual Accrual TA70.1 TA70.2
ME = Manual Eligible TA80.1 TA81.1
TA = Transfer Accrual
TE = Transfer Eligible
U = Usage Hours
X = Accrued and Eligible Hours
MV = CA Manual Vac
XV = CA Eligible Vac
UV = CA Used Vac
BV = CA Beg Bal Vac
ETT-DESCRIPTION Alpha 30 (Lower Case) BN138 PR130
Description Contains the transaction description. TA146 TA148
TA170 TA180
TA181 TA300
TA340 TA42.1
TA542 TA570
TA70.1 TA70.2
TA80.1 TA81.1
ETT-TA-HOURS Signed 9.4 BN138 PR130
Ta Hours Contains the hours associated with the PR80.2 TA146
transaction. TA148 TA170
TA180 TA181
TA300 TA340
TA42.1 TA542
TA570 TA65.3
TA70.1 TA70.2
TA80.1 TA81.1
ETT-STATUS Numeric 1 BN138 PR130
Status Contains the transaction status. TA146 TA148
0 = Unprocessed (Created in TA70) TA170 TA180
2 = Processed (Ran TA170) TA181 TA198
9 = Closed (Ran TA199) TA199 TA300
TA340 TA42.1
TA542 TA570
TA70.1 TA70.2
TA80.1 TA81.1
ETT-TA-DOLLARS Signed 12.2 PR130 PR80.2
Ta Dollars TA146 TA148
TA181 TA340
TA42.1 TA542
TA81.1
ETT-VAC-PAY-CLASS Alpha 3 TA146
Vac Pay Class
ETT-VAC-PAY-CODE Alpha 4 PR130 TA146
Vac Pay Code
ETT-COUNTRY-CODE Alpha 2 PR130 TA146
Country Code The country code. Required for VAT and TA148 TA181
intrastat reporting. Must be defined in TA42.1 TA542
IN01.1 (Country Maintenance). TA70.1 TA70.2
TA81.1
EMTATRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ETTSET1 COMPANY HR170 HR650
EMPLOYEE HR70.1 PR130
PLAN-NAME PR160 PR180
DATE PR80.2 TA180
SEQ-NBR TA181 TA196
TA241 TA300
TA340 TA341
TA50.1 TA60.1
ETTSET2 COMPANY PR130 TA147
PLAN-NAME TA148
EMPLOYEE
DATE
SEQ-NBR
ETTSET3 COMPANY Subset TA180 TA181
COUNTRY-CODE Where STATUS = 2 TA199 TA42.1
PLAN-NAME Or STATUS = Zeroes TA70.1
EMPLOYEE
DATE
SEQ-NBR
ETTSET4 COMPANY Subset PR130 TA146
COUNTRY-CODE Where STATUS = 2 TA170 TA198
EMPLOYEE Or STATUS = Zeroes TA270 TA70.2
PLAN-NAME TA80.1 TA81.1
DATE
SEQ-NBR
ETTSET5 COMPANY TA175 TA265
COUNTRY-CODE TA290 TA300
EMPLOYEE TA340 TA65.3
PLAN-NAME
DATE
SEQ-NBR
ETTSET6 COMPANY TA310
COUNTRY-CODE
PLAN-NAME
EMPLOYEE
DATE
SEQ-NBR
EMTATRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
ETT-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
ETT-COMPANY -> EMP-COMPANY
ETT-EMPLOYEE -> EMP-EMPLOYEE
Employee Plan EMTAMASTR Required
ETT-COMPANY -> ETM-COMPANY
ETT-EMPLOYEE -> ETM-EMPLOYEE
ETT-PLAN-NAME -> ETM-PLAN-NAME
Plan PLANMASTER Required
ETT-COMPANY -> PLM-COMPANY
ETT-PLAN-NAME -> PLM-PLAN-NAME
|