Emp Time Accrual Transactions

Contains time accrual transactions for each plan for an employee.

REFERENCED BY

PR160

PR180

PR80.2

TA196

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	HR170	HR70.1	TA241	TA50.1
TA60.1	XT795	TA147	LP900	TA175	TA270
TA265	TA290	TA65.3

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.