EMTAMASTR FILE
Employee Time Accrual Master
Contains a record for each plan in which an employee is enrolled, the dates
needed for accrual and eligible hours, and time accrual balances.
TA125 (Employee Enrollment Update) and TA60.1 (Employee Plan) update this
file.
REFERENCED BY
AC550 BN100 BN101 BN102 BN103 BN105
BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN531 BN65.1 BN71.1 BN72.1 BS13.1 BS14.1
BS15.1 BS32.1 HR170 HR650 HR70.1 PA502
PR13.1 PR13.5 PR13.6 PR13.8 PR134 PR135
PR32.2 PR35.1 PR35.2 PR35.6 PR36.1 PR530
PR82.1 PR85.1 TA175 TA195 TA260 TA265
TA290 TA300 TA65.2 TA65.3 TA65.1 TA20.1
TA20.2
UPDATED BY
BN138 HR511 TA125 TA170 TA180 TA199
TA310 TA570 TA60.1 TA70.1 TA70.2 TA80.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ETM-COMPANY Numeric 4 HR511 TA125
Company Contains the number that represents an TA180 TA60.1
established company. TA80.1
ETM-EMPLOYEE Numeric 9 HR511 TA125
Employee Contains the employee number which is TA180 TA60.1
used to correlate all information TA80.1
related to the employee.
ETM-PLAN-NAME Alpha 10 HR511 TA125
From Plan Name Contains the plan name. This is TA180 TA60.1
verified in the Time Accrual Plan file. TA80.1
ETM-PL-ENTRY-DATE Numeric 8 (yyyymmdd) TA170 TA180
Plan Entry Date Contains the date the employee enrolled TA60.1 TA80.1
in the plan.
ETM-PL-END-DATE Numeric 8 (yyyymmdd) TA180 TA60.1
Plan End Date Contains the date the employee is no TA80.1
longer enrolled in the plan.
ETM-RUN-DATE Numeric 8 (yyyymmdd) TA180 TA199
Program Run Date Contains the last pay period end date TA80.1
the plan was processed through TA199
(Time Accrual Close).
ETM-FST-ACR-DATE Numeric 8 (yyyymmdd) TA180 TA199
First Accrual Date Contains the first date the employee TA60.1
can accrue hours. It is updated from the
temporary first accrual date by TA199
(Time Accrual Close).
ETM-LST-ACR-DATE Numeric 8 (yyyymmdd) TA170 TA180
Last Accrual Date Contains the last date the employee TA199 TA80.1
received accrual hours. TA199 (Time
Accrual Close) updates this field using
the temporary last accrual.
ETM-ACR-LMT-DATE Numeric 8 (yyyymmdd) TA199
Accrual Limit Date Contains the last date accrual limits
were checked. TA199 (Time Accrual Close)
updates this field from the temporary
accrual limit date.
ETM-FST-ELIG-DATE Numeric 8 (yyyymmdd) TA180 TA199
First Eligible Date Contains the first date the employee TA60.1
can have eligible hours or begin
transferring accrual hours. TA199 (Time
Accrual Close) updates this field from
the temporary first eligible date.
ETM-LST-ELIG-DATE Numeric 8 (yyyymmdd) TA180 TA199
Last Eligible Date Contains the last date the employee
received eligible hours. TA199 (Time
Accrual Close) updates this field from
the temporary last eligible date.
ETM-ELIG-LMT-DATE Numeric 8 (yyyymmdd) TA199
Eligible Limit Date Contains the last date eligible limits
were checked. TA199 (Time Accrual Close)
updates this field from the temporary
eligible limit date.
ETM-ACR-BALANCE Signed 9.4 TA180 TA199
Accrual Balance Contains the employee's accrual TA80.1
balance. TA199 (Time Accrual Close)
updates this field from the temporary
accrual balance.
ETM-ELIG-BALANCE Signed 9.4 TA180 TA199
Eligible Balance Contains the employee's eligible TA80.1
balance. TA199 (Time Accrual Close)
updates this field from the temporary
eligible balance.
ETM-T-RUN-DATE Numeric 8 (yyyymmdd) TA170 TA199
Temporary Run Date Contains the date TA170 (Time Accrual
Update) was run.
This field is the period end date from
PR140 (Earnings and Deductions
Calculation).
ETM-T-FST-AC-DATE Numeric 8 (yyyymmdd) TA170 TA199
Temporary First Contains the first date the employee
Accrual Date can accrue hours.
ETM-T-LST-AC-DATE Numeric 8 (yyyymmdd) TA170 TA199
Temporary Last Contains the last date the employee
Accrual Date received accrual hours.
ETM-T-AC-LMT-DATE Numeric 8 (yyyymmdd) TA170 TA199
Temporary Accrual Contains the last date accrual limits
Lim Run Date were checked.
ETM-T-FST-EL-DATE Numeric 8 (yyyymmdd) TA170 TA199
Temporary First Contains the first date the employee
Eligibl Date can have eligible hours or start
transferring from accrual.
ETM-T-LST-EL-DATE Numeric 8 (yyyymmdd) TA170 TA199
Temporary Last Contains the last date the employee
Eligible Date received eligible hours.
ETM-T-EL-LMT-DATE Numeric 8 (yyyymmdd) TA170 TA199
Temporary Eligible Contains the last date eligible hours
Lim Date were checked for limits.
ETM-T-ACR-BALANCE Signed 9.4 TA170 TA199
Temporary Accrual Contains the employee's accrual balance.
Balance
ETM-T-ELG-BALANCE Signed 9.4 TA170 TA199
Temporary Eligible Contains the employee's eligible
Balance balance.
ETM-ACR-DIST-CO Numeric 4 TA60.1 TA80.1
Acr Dist Co
ETM-ACR-ACCT-UNIT Alpha 15 TA60.1 TA80.1
Accrual Accounting Contains the GL Interface File accrual
Unit accounting unit.
ETM-ACR-ACCOUNT Numeric 6 TA60.1 TA80.1
Accrual Account Contains the GL Interface File accrual
Number account.
ETM-ACR-SUB-ACCT Numeric 4 TA60.1 TA80.1
Accrual Subaccount Contains the GL Interface File accrual
Number subaccount.
ETM-EXP-DIST-CO Numeric 4 TA60.1 TA80.1
Exp Dist Co
ETM-EXP-ACCT-UNIT Alpha 15 TA60.1 TA80.1
Expense Accounting Contains the GL Interface File expense
Unit accounting unit.
ETM-EXP-ACCOUNT Numeric 6 TA60.1 TA80.1
Expense Account Contains the GL Interface File expense
account.
ETM-EXP-SUB-ACCT Numeric 4 TA60.1 TA80.1
Depr Expense Contains the GL Interface File expense
Subaccount subaccount.
ETM-LST-SEQ-NBR Numeric 4 BN138 TA170
Last Sequence Number Contains the sequence number of the TA180 TA570
last time accrual transaction record TA70.1 TA70.2
created for the employee in the plan TA80.1
for.
ETM-TRANSFER-FLAG Alpha 1 TA170 TA80.1
Transfer Flag Contains the value that indicates if
the transaction was a transfer from
another plan. The value changes to No
after you run TA170 (Time Accrual
Update).
Y = Yes
N = No
EMTAMASTR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ETMSET1 COMPANY AC550 BN100
EMPLOYEE BN101 BN102
PLAN-NAME BN103 BN105
BN138 BN245
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR170
HR511 HR650
HR70.1 PA502
PR13.1 PR13.5
PR13.6 PR13.8
...
ETMSET2 COMPANY TA170 TA175
PLAN-NAME TA180 TA20.1
EMPLOYEE TA20.2 TA310
TA65.1
EMTAMASTR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Accrual Acct GLMASTER Required
When ETM-ACR-ACCT-UNIT != Spaces
Or ETM-ACR-ACCOUNT != Zeroes
ETM-COMPANY -> GLM-COMPANY
ETM-ACR-ACCT-UNIT -> GLM-ACCT-UNIT
ETM-ACR-ACCOUNT -> GLM-ACCOUNT
ETM-ACR-SUB-ACCT -> GLM-SUB-ACCOUNT
Company PRSYSTEM Required
ETM-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
ETM-COMPANY -> EMP-COMPANY
ETM-EMPLOYEE -> EMP-EMPLOYEE
Expense Acct GLMASTER Required
When ETM-EXP-ACCT-UNIT != Spaces
Or ETM-EXP-ACCOUNT != Zeroes
ETM-COMPANY -> GLM-COMPANY
ETM-EXP-ACCT-UNIT -> GLM-ACCT-UNIT
ETM-EXP-ACCOUNT -> GLM-ACCOUNT
ETM-EXP-SUB-ACCT -> GLM-SUB-ACCOUNT
Plan PLANMASTER Required
ETM-COMPANY -> PLM-COMPANY
ETM-PLAN-NAME -> PLM-PLAN-NAME
Plan Class PLANCLASS Not Required
ETM-COMPANY -> PLC-COMPANY
PLM-PLAN-CLASS -> PLC-PLAN-CLASS
EMTAMASTR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Plan Trans EMTATRANS Delete Restricted
ETM-COMPANY -> ETT-COMPANY
ETM-EMPLOYEE -> ETT-EMPLOYEE
ETM-PLAN-NAME -> ETT-PLAN-NAME
ETT-DATE
ETT-SEQ-NBR
Trans Summary EMTATRNSUM Delete Cascades
ETM-COMPANY -> EMT-COMPANY
ETM-EMPLOYEE -> EMT-EMPLOYEE
ETM-PLAN-NAME -> EMT-PLAN-NAME
EMT-YEAR
|
