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
BN100 BN101 BN102 BN103 BN105 BN245
BN31.1 BN31.2 BN32.1 BN32.2 BN32.3 BN531
BN65.1 BN71.1 BN72.1 BN729 BN991 BS13.1
BS14.1 BS15.1 BS32.1 PR160 PR180 TA265
TA290


UPDATED BY
BN138 BN66.1 HR11.1 HR11.2 HR511 PA100
PA52.4 PA52.1 PA52.3 PA52.5 PR130 PR140
PR189 PR195 PR80.1 PR80.4 PR89.1 TA125
TA145 TA146 TA148 TA170 TA180 TA181
TA198 TA199 TA310 TA341 TA42.1 TA50.1
TA542 TA570 TA60.1 TA70.1 TA70.2 TA80.1
TA81.1 BN305 HR170 HR70.1 PA02.1 PA102
PA115 PA13.1 PA13.2 PA502 PA513 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR134 PR135 PR32.2 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR35.9 PR36.1 PR530 PR82.1 PR85.1
TA147 TA175 TA65.1 XT795 TA20.1 TA20.2
TA241 TA242 TA40.1 TA195 TA196 TA260
TA300 TA340

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ETM-COMPANY
Element: Company Hr		Numeric 4
Contains the number that represents an established company.
HR11.1 HR511
PA100 PA52.4
TA125 TA145
TA180 TA181
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.
HR11.1 HR511
PA100 PA52.4
TA125 TA145
TA180 TA181
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.
HR11.1 HR511
PA100 PA52.4
TA125 TA145
TA180 TA181
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.
TA145 TA170
TA180 TA181
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.
TA180 TA181
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).
TA180 TA181
TA198 TA199
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).
TA180 TA199
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.
TA170 TA180
TA199 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.
TA199
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.
TA145 TA180
TA199 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.
TA180 TA199
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.
TA199
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.
TA180 TA199
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 TA180
TA181 TA198
TA199 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 PR130
PR140 PR189
PR195 PR80.1
PR80.4 PR89.1
TA146 TA170
TA198 TA199
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 TA170
TA199
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 TA170
TA199
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 TA170
TA199
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 TA170
TA199
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 TA170
TA199
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 TA170
TA199
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 TA170
TA199
ETM-T-ELG-BALANCE
Element: T Elg Balance		Signed 9.4
Contains the employee's eligible balance.
BN66.1 PR130
PR140 PR189
PR195 PR80.1
PR80.4 PR89.1
TA146 TA170
TA198 TA199
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.
BN138 PR130
TA146 TA148
TA170 TA180
TA181 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
TA170 TA180
TA80.1
ETM-TA-DOLLARS
Element: Ta Dollars		Signed 12.2
TA148 TA181
TA198 TA81.1
ETM-T-TA-DOLLARS
Element: T Ta Dollars		Signed 12.2
PR130 TA146
TA198 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).
HR11.1 HR511
PA100 PA52.4
TA145 TA181
TA50.1 TA81.1


EMTAMASTR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ETMSET1 COMPANY
EMPLOYEE
PLAN-NAME
...
BN100 BN101
BN102 BN103
BN105 BN138
BN245 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN531
BN65.1 BN66.1
BN71.1 BN72.1
BN729 BN991
BS13.1 BS14.1
BS15.1 BS32.1
HR11.1 HR11.2
HR170 HR511
HR70.1 PA02.1
ETMSET2 COMPANY
PLAN-NAME
EMPLOYEE
PR130 TA147
TA148 TA170
TA180 TA181
TA20.1 TA20.2
TA241 TA242
TA310 TA341
TA40.1 TA65.2
ETMSET3 COMPANY
COUNTRY-CODE
EMPLOYEE
PLAN-NAME
TA146 TA170
TA195 TA196
TA198 TA199
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: Wed Jun 08 20:51:41 2016

Home
Contact Us



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