EMTATRANS

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ETTSET1 COMPANY
EMPLOYEE
PLAN-NAME
DATE
SEQ-NBR
HR170 HR70.1
ZH230 PR130
PR160 PR180
PR80.2 TA180
TA181 TA196
TA241 TA300
TA340 TA341
TA50.1 TA60.1
ETTSET2 COMPANY
PLAN-NAME
EMPLOYEE
DATE
SEQ-NBR
PR130 TA147
TA148
ETTSET3 COMPANY
COUNTRY-CODE
PLAN-NAME
EMPLOYEE
DATE
SEQ-NBR
Subset
WhereSTATUS =2
OrSTATUS =Zeroes
LP900 PR130
TA180 TA181
TA199 TA42.1
TA70.1
ETTSET4 COMPANY
COUNTRY-CODE
EMPLOYEE
PLAN-NAME
DATE
SEQ-NBR
Subset
WhereSTATUS =2
OrSTATUS =Zeroes
PR130 TA146
TA170 TA175
TA198 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 11:29:10 2016

Home
Contact Us



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