EMTATRANS

Emp Time Accrual Transactions

Contains time accrual transactions for each plan for an employee.

REFERENCED BY
HR170 HR70.1 ZH230 PR160 PR180 PR80.2
TA241 TA50.1 TA60.1 TA147 LP900 TA175
TA270 TA265 TA290 TA65.3


UPDATED BY
TA148 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
Element: Company Hr		Numeric 4
Contains the number that represents an established company.
TA148 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.
TA148 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.
TA148 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.
TA148 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.
TA148 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
TA148 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.
TA148 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.
PR80.2 TA148
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)
TA148 TA300
TA340 TA42.1
TA542 TA570
TA70.1 TA70.2
TA80.1 TA81.1
ETT-TA-DOLLARS
Element: Ta Dollars		Signed 12.2
PR80.2 TA148
TA340 TA42.1
TA542 TA81.1
ETT-VAC-PAY-CLASS
Element: Vac Pay Class		Alpha 3
ETT-VAC-PAY-CODE
Element: Vac Pay Code		Alpha 4
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).
TA148 TA42.1
TA542 TA70.1
TA70.2 TA81.1


EMTATRANS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ETTSET1 COMPANY
EMPLOYEE
PLAN-NAME
DATE
SEQ-NBR
HR170 HR70.1
ZH230 PR160
PR180 PR80.2
TA241 TA300
TA340 TA341
TA50.1 TA60.1
ETTSET2 COMPANY
PLAN-NAME
EMPLOYEE
DATE
SEQ-NBR
TA147 TA148
ETTSET3 COMPANY
COUNTRY-CODE
PLAN-NAME
EMPLOYEE
DATE
SEQ-NBR
Subset
WhereSTATUS =2
OrSTATUS =Zeroes
LP900 TA42.1
TA70.1
ETTSET4 COMPANY
COUNTRY-CODE
EMPLOYEE
PLAN-NAME
DATE
SEQ-NBR
Subset
WhereSTATUS =2
OrSTATUS =Zeroes
TA175 TA270
TA70.2 TA80.1
TA81.1
ETTSET5 COMPANY
COUNTRY-CODE
EMPLOYEE
PLAN-NAME
DATE
SEQ-NBR
TA265 TA290
TA300 TA340
TA65.3
ETTSET6 COMPANY
COUNTRY-CODE
PLAN-NAME
EMPLOYEE
DATE
SEQ-NBR
TA310


EMTATRANS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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

File created: Thu Jun 09 02:32:51 2016

Home
Contact Us



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