EMTATRANS FILE
Emp Time Accrual Transactions
Contains time accrual transactions for each plan for an employee.
REFERENCED BY
HR170 HR650 HR70.1 TA175 TA265 TA290
TA60.1 TA65.3 TA270
UPDATED BY
BN138 TA170 TA180 TA199 TA300 TA310
TA570 TA70.1 TA70.2 TA80.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ETT-COMPANY Numeric 4 BN138 TA170
Company Contains the number that represents an TA180 TA300
established company. TA570 TA70.1
TA70.2 TA80.1
ETT-EMPLOYEE Numeric 9 BN138 TA170
Employee Contains the employee number which is TA180 TA300
used to correlate all information TA570 TA70.1
related to the employee. TA70.2 TA80.1
ETT-PLAN-NAME Alpha 10 BN138 TA170
From Plan Name Contains the plan name. This is TA180 TA300
verified in the Time Accrual Plan file. TA570 TA70.1
TA70.2 TA80.1
ETT-DATE Numeric 8 (yyyymmdd) BN138 TA170
Date Contains the date of the transaction. TA180 TA300
The transaction date can default from TA570 TA70.1
the end date of the payroll period, the TA70.2 TA80.1
last eligible date, or the eligible
limit date defined for the plan.
ETT-SEQ-NBR Numeric 4 BN138 TA170
Sequence Number Contains a sequence number that keeps TA180 TA300
records unique. It is automatically TA570 TA70.1
assigned when records are created. TA70.2 TA80.1
ETT-TYPE Alpha 2 BN138 TA170
Type Contains the transaction type. TA180 TA300
A = Accrual Hours TA570 TA70.1
B = Beginning balance from Purge TA70.2 TA80.1
LA = Lost Accrual
LE = Lost Eligible
MA = Manual Accrual
ME = Manual Eligible
TA = Transfer Accrual
TE = Transfer Eligible
U = Usage Hours
X = Accrued and Eligible Hours
ETT-DESCRIPTION Alpha 30 (Lower Case) BN138 TA170
Description Contains the transaction description. TA180 TA300
TA570 TA70.1
TA70.2 TA80.1
ETT-TA-HOURS Signed 9.4 BN138 TA170
Ta Hours Contains the hours associated with the TA180 TA300
transaction. TA570 TA65.3
TA70.1 TA70.2
TA80.1
ETT-STATUS Numeric 1 BN138 TA170
Status Contains the transaction status. TA180 TA199
0 = Unprocessed (Created in TA70) TA300 TA570
2 = Processed (Ran TA170) TA70.1 TA70.2
9 = Closed (Ran TA199) TA80.1
EMTATRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ETTSET1 COMPANY HR170 HR650
EMPLOYEE HR70.1 TA175
PLAN-NAME TA180 TA265
DATE TA290 TA300
SEQ-NBR TA60.1 TA65.3
ETTSET2 COMPANY TA310
PLAN-NAME
EMPLOYEE
DATE
SEQ-NBR
ETTSET3 COMPANY Subset TA180 TA199
PLAN-NAME Where STATUS = 2 TA70.1
EMPLOYEE Or STATUS = Zeroes
DATE
SEQ-NBR
ETTSET4 COMPANY Subset TA170 TA270
EMPLOYEE Where STATUS = 2 TA70.2 TA80.1
PLAN-NAME Or STATUS = Zeroes
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
|
