|
|
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
AC750 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 HR70.1 PA02.1 PA102
PA502 PR13.1 PR134 PR135 PR160 PR180
PR32.2 PR35.1 PR35.2 PR35.6 PR36.1 PR530
PR80.1 PR80.2 PR82.1 PR85.1 TA175 TA195
TA260 TA265 TA290 TA300 TA65.2 TA65.3
TA65.1 TA20.1 TA20.2
UPDATED BY
BN138 HR11.1 HR511 PA100 PA52.4 PR140
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 HR11.1 HR511
Company Contains the number that represents an PA100 PA52.4
established company. TA125 TA180
TA60.1 TA80.1
ETM-EMPLOYEE Numeric 9 HR11.1 HR511
Employee Contains the employee number which is PA100 PA52.4
used to correlate all information TA125 TA180
related to the employee. TA60.1 TA80.1
ETM-PLAN-NAME Alpha 10 HR11.1 HR511
From Plan Name Contains the plan name. This is PA100 PA52.4
verified in the Time Accrual Plan file. TA125 TA180
TA60.1 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) PR140 TA170
Temporary Run Date Contains the date TA170 (Time Accrual TA199
Update) was run.
This field is the period end date from
PR140 (Earnings and Deductions
Calculation).
ETM-T-FST-AC-DATE Numeric 8 (yyyymmdd) PR140 TA170
Temporary First Contains the first date the employee TA199
Accrual Date can accrue hours.
ETM-T-LST-AC-DATE Numeric 8 (yyyymmdd) PR140 TA170
Temporary Last Contains the last date the employee TA199
Accrual Date received accrual hours.
ETM-T-AC-LMT-DATE Numeric 8 (yyyymmdd) PR140 TA170
Temporary Accrual Contains the last date accrual limits TA199
Lim Run Date were checked.
ETM-T-FST-EL-DATE Numeric 8 (yyyymmdd) PR140 TA170
Temporary First Contains the first date the employee TA199
Eligibl Date can have eligible hours or start
transferring from accrual.
ETM-T-LST-EL-DATE Numeric 8 (yyyymmdd) PR140 TA170
Temporary Last Contains the last date the employee TA199
Eligible Date received eligible hours.
ETM-T-EL-LMT-DATE Numeric 8 (yyyymmdd) PR140 TA170
Temporary Eligible Contains the last date eligible hours TA199
Lim Date were checked for limits.
ETM-T-ACR-BALANCE Signed 9.4 PR140 TA170
Temporary Accrual Contains the employee's accrual balance. TA199
Balance
ETM-T-ELG-BALANCE Signed 9.4 PR140 TA170
Temporary Eligible Contains the employee's eligible TA199
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 AC750 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 HR11.1
HR170 HR511
HR70.1 PA02.1
PA100 PA102
PA502 PA52.1
...
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
|