Emp Time Accrual Transactions

Contains time accrual transactions for each plan for an employee.

REFERENCED BY

PR160

PR180

PR80.2

TA196

LP900

UPDATED BY

BN138	HR170	HR70.1	ZH230	PR130	TA146
TA147	TA148	TA170	TA175	TA180	TA181
TA198	TA199	TA241	TA265	TA270	TA290
TA300	TA310	TA340	TA341	TA42.1	TA50.1
TA542	TA570	TA60.1	TA65.3	TA70.1	TA70.2
TA80.1	TA81.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
ETT-COMPANY Element: Company Hr	Numeric 4 Contains the number that represents an established company.	BN138 PR130 TA146 TA148 TA170 TA180 TA181 TA300 TA340 TA42.1 TA542 TA570 TA70.1 TA70.2 TA80.1 TA81.1
ETT-EMPLOYEE Element: Employee	Numeric 9 Contains the employee number which is used to correlate all information related to the employee.	BN138 PR130 TA146 TA148 TA170 TA180 TA181 TA300 TA340 TA42.1 TA542 TA570 TA70.1 TA70.2 TA80.1 TA81.1
ETT-PLAN-NAME Element: Plan Name	Alpha 10 Contains the plan name. This is verified in the Time Accrual Plan file.	BN138 PR130 TA146 TA148 TA170 TA180 TA181 TA300 TA340 TA42.1 TA542 TA570 TA70.1 TA70.2 TA80.1 TA81.1
ETT-DATE Element: Date	Numeric 8 (yyyymmdd) Contains the date of the transaction. The transaction date can default from the end date of the payroll period, the last eligible date, or the eligible limit date defined for the plan.	BN138 PR130 TA146 TA148 TA170 TA180 TA181 TA300 TA340 TA42.1 TA542 TA570 TA70.1 TA70.2 TA80.1 TA81.1
ETT-SEQ-NBR Element: Seq Nbr	Numeric 4 Contains a sequence number that keeps records unique. It is automatically assigned when records are created.	BN138 PR130 TA146 TA148 TA170 TA180 TA181 TA300 TA340 TA42.1 TA542 TA570 TA70.1 TA70.2 TA80.1 TA81.1
ETT-TYPE Element: Type	Alpha 2 Contains the transaction type. A = Accrual Hours B = Beginning balance from Purge 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 MV = CA Manual Vac XV = CA Eligible Vac UV = CA Used Vac BV = CA Beg Bal Vac LV = CA Lost Vac	BN138 PR130 TA146 TA148 TA170 TA180 TA181 TA300 TA340 TA42.1 TA542 TA570 TA70.1 TA70.2 TA80.1 TA81.1
ETT-DESCRIPTION Element: Description	Alpha 30 (Lower Case) Contains the transaction description.	BN138 PR130 TA146 TA148 TA170 TA180 TA181 TA300 TA340 TA42.1 TA542 TA570 TA70.1 TA70.2 TA80.1 TA81.1
ETT-TA-HOURS Element: Ta Hours	Signed 9.4 Contains the hours associated with the transaction.	BN138 PR130 PR80.2 TA146 TA148 TA170 TA180 TA181 TA300 TA340 TA42.1 TA542 TA570 TA65.3 TA70.1 TA70.2 TA80.1 TA81.1
ETT-STATUS Element: Status	Numeric 1 Contains the transaction status. 0 = Unprocessed (Created in TA70) 2 = Processed (Ran TA170) 9 = Closed (Ran TA199)	BN138 PR130 TA146 TA148 TA170 TA180 TA181 TA198 TA199 TA300 TA340 TA42.1 TA542 TA570 TA70.1 TA70.2 TA80.1 TA81.1
ETT-TA-DOLLARS Element: Ta Dollars	Signed 12.2	PR130 PR80.2 TA146 TA148 TA181 TA340 TA42.1 TA542 TA81.1
ETT-VAC-PAY-CLASS Element: Vac Pay Class	Alpha 3	TA146
ETT-VAC-PAY-CODE Element: Vac Pay Code	Alpha 4	PR130 TA146
ETT-COUNTRY-CODE Element: Country Code	Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	PR130 TA146 TA148 TA181 TA42.1 TA542 TA70.1 TA70.2 TA81.1

EMTATRANS FILE INDEX

EMTATRANS FILE RELATIONS

ONE TO ONE RELATIONS

All trademarks and registered trademarks are the property of their respective owners.