EMTAMASTR

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
HR170 HR70.1 ZH230 PR134 PR135 PR160
PR180 PR32.2 PR33.2 PR33.3 PR35.1 PR35.2
PR35.3 PR35.4 PR35.5 PR35.6 PR35.8 PR35.9
PR36.1 PR36.4 PR530 TA147 TA175 TA265
TA290 TA65.3 TA65.2 TA65.1 TA20.1 TA20.2
TA241 TA242 TA40.1 TA260 TA300 TA340


UPDATED BY
BN66.1 PR140 PR189 PR195 PR80.1 PR80.4
PR89.1 PRAT.1 TA148 TA310 TA341 TA42.1
TA50.1 TA542 TA570 TA60.1 TA70.1 TA70.2
TA80.1 TA81.1 HR11.1 PA115

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ETM-COMPANY
Element: Company Hr		Numeric 4
Contains the number that represents an established company.
TA50.1 TA60.1
TA80.1 TA81.1
ETM-EMPLOYEE
Element: Employee		Numeric 9
Contains the employee number which is used to correlate all information related to the employee.
TA50.1 TA60.1
TA80.1 TA81.1
ETM-PLAN-NAME
Element: Plan Name		Alpha 10
Contains the plan name. This is verified in the Time Accrual Plan file.
TA50.1 TA60.1
TA80.1 TA81.1
ETM-PL-ENTRY-DATE
Element: Pl Entry Date		Numeric 8 (yyyymmdd)
Contains the date the employee enrolled in the plan.
TA50.1 TA60.1
TA80.1 TA81.1
ETM-PL-END-DATE
Element: Pl End Date		Numeric 8 (yyyymmdd)
Contains the date the employee is no longer enrolled in the plan.
TA50.1 TA60.1
TA80.1 TA81.1
ETM-RUN-DATE
Element: Run Date		Numeric 8 (yyyymmdd)
Contains the last pay period end date the plan was processed through TA199 (Time Accrual Close).
TA80.1 TA81.1
ETM-FST-ACR-DATE
Element: Fst Acr Date		Numeric 8 (yyyymmdd)
Contains the first date the employee can accrue hours. It is updated from the temporary first accrual date by TA199 (Time Accrual Close).
TA60.1
ETM-LST-ACR-DATE
Element: Lst Acr Date		Numeric 8 (yyyymmdd)
Contains the last date the employee received accrual hours. TA199 (Time Accrual Close) updates this field using the temporary last accrual.
TA80.1
ETM-ACR-LMT-DATE
Element: Acr Lmt Date		Numeric 8 (yyyymmdd)
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
Element: Fst Elig Date		Numeric 8 (yyyymmdd)
Contains the first date the employee can have eligible hours or begin transferring accrual hours. TA199 (Time Accrual Close) updates this field from the temporary first eligible date.
TA50.1 TA60.1
TA81.1
ETM-LST-ELIG-DATE
Element: Lst Elig Date		Numeric 8 (yyyymmdd)
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
Element: Elig Lmt Date		Numeric 8 (yyyymmdd)
Contains the last date eligible limits were checked. TA199 (Time Accrual Close) updates this field from the temporary eligible limit date.
ETM-ACR-BALANCE
Element: Acr Balance		Signed 9.4
Contains the employee's accrual balance. TA199 (Time Accrual Close) updates this field from the temporary accrual balance.
TA80.1
ETM-ELIG-BALANCE
Element: Elig Balance		Signed 9.4
Contains the employee's eligible balance. TA199 (Time Accrual Close) updates this field from the temporary eligible balance.
TA148 TA80.1
TA81.1
ETM-T-RUN-DATE
Element: T Run Date		Numeric 8 (yyyymmdd)
Contains the date TA170 (Time Accrual Update) was run. This field is the period end date from PR140 (Earnings and Deductions Calculation).
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
ETM-T-FST-AC-DATE
Element: T Fst Ac Date		Numeric 8 (yyyymmdd)
Contains the first date the employee can accrue hours.
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
ETM-T-LST-AC-DATE
Element: T Lst Ac Date		Numeric 8 (yyyymmdd)
Contains the last date the employee received accrual hours.
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
ETM-T-AC-LMT-DATE
Element: T Ac Lmt Date		Numeric 8 (yyyymmdd)
Contains the last date accrual limits were checked.
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
ETM-T-FST-EL-DATE
Element: T Fst El Date		Numeric 8 (yyyymmdd)
Contains the first date the employee can have eligible hours or start transferring from accrual.
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
ETM-T-LST-EL-DATE
Element: T Lst El Date		Numeric 8 (yyyymmdd)
Contains the last date the employee received eligible hours.
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
ETM-T-EL-LMT-DATE
Element: T El Lmt Date		Numeric 8 (yyyymmdd)
Contains the last date eligible hours were checked for limits.
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
ETM-T-ACR-BALANCE
Element: T Acr Balance		Signed 9.4
Contains the employee's accrual balance.
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
ETM-T-ELG-BALANCE
Element: T Elg Balance		Signed 9.4
Contains the employee's eligible balance.
BN66.1 PR140
PR189 PR195
PR80.1 PR80.4
PR89.1 PRAT.1
TA42.1
ETM-ACR-DIST-CO
Element: Company		Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
TA60.1
ETM-ACR-ACCT-UNIT
Element: Acct Unit		Alpha 15
Contains the GL Interface File accrual accounting unit.
TA60.1
ETM-ACR-ACCOUNT
Element: Account		Numeric 6
Contains the GL Interface File accrual account.
TA60.1
ETM-ACR-SUB-ACCT
Element: Sub Acct		Numeric 4
Contains the GL Interface File accrual subaccount.
TA60.1
ETM-EXP-DIST-CO
Element: Company		Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
TA60.1
ETM-EXP-ACCT-UNIT
Element: Acct Unit		Alpha 15
Contains the GL Interface File expense accounting unit.
TA60.1
ETM-EXP-ACCOUNT
Element: Account		Numeric 6
Contains the GL Interface File expense account.
TA60.1
ETM-EXP-SUB-ACCT
Element: Sub Acct		Numeric 4
Contains the GL Interface File expense subaccount.
TA60.1
ETM-LST-SEQ-NBR
Element: Lst Seq Nbr		Numeric 4
Contains the sequence number of the last time accrual transaction record created for the employee in the plan for.
TA148 TA42.1
TA542 TA570
TA70.1 TA70.2
TA80.1 TA81.1
ETM-TRANSFER-FLAG
Element: Transfer Flag		Alpha 1
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
TA80.1
ETM-TA-DOLLARS
Element: Ta Dollars		Signed 12.2
TA148 TA81.1
ETM-T-TA-DOLLARS
Element: T Ta Dollars		Signed 12.2
TA42.1
ETM-EMPL-PERCENT
Element: Empl Percent		Signed 5.2
TA50.1
ETM-EMPL-VAC-HRS
Element: Empl Vac Hrs		Numeric 7
TA50.1
ETM-COUNTRY-CODE
Element: Country Code		Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
TA50.1 TA81.1


EMTAMASTR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ETMSET1 COMPANY
EMPLOYEE
PLAN-NAME
...
BN66.1 HR11.1
HR170 HR70.1
ZH230 PA115
PR134 PR135
PR140 PR160
PR180 PR189
PR195 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
PR35.5 PR35.6
PR35.8 PR35.9
PR36.1 PR36.4
PR530 PR80.1
PR80.2 PR80.4
ETMSET2 COMPANY
PLAN-NAME
EMPLOYEE
TA147 TA148
TA20.1 TA20.2
TA241 TA242
TA310 TA341
TA40.1 TA65.2
ETMSET3 COMPANY
COUNTRY-CODE
EMPLOYEE
PLAN-NAME
TA241 TA260
TA300 TA340
TA50.1 TA60.1
ETMSET4 COMPANY
COUNTRY-CODE
PLAN-NAME
EMPLOYEE
TA175 TA65.1


EMTAMASTR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Accrual Acct GLMASTER Required
When ETM-ACR-ACCT-UNIT !=Spaces
OrETM-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
OrETM-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
NAME		 RELATED 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
Taeemaster TAEEMASTER
ETM-COMPANY->TEM-COMPANY
  TEM-EMPLOYEE
  TEM-PLAN
  TEM-EMPLOYEE-GROUP
  TEM-POSITION
Trans Summary EMTATRNSUM Delete Cascades
ETM-COMPANY->EMT-COMPANY
ETM-EMPLOYEE->EMT-EMPLOYEE
ETM-PLAN-NAME->EMT-PLAN-NAME
  EMT-YEAR

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

Home
Contact Us



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