EMTAMASTR – Employee Time Accrual Master

System
Event Management (TA)
Prefix
ETM
Primary key
COMPANY, EMPLOYEE, PLAN-NAME
Fields
38
Updated by
22 programs
Referenced by
36 programs

EMTAMASTR is the Employee Time Accrual Master table in Lawson Event Management (prefix ETM). It is indexed by COMPANY, EMPLOYEE, PLAN-NAME (ETMSET1); alternate indexes: ETMSET2, ETMSET3 and ETMSET4. It is related 1:1 to GLMASTER, PRSYSTEM, EMPLOYEE, PLANMASTER and PLANCLASS and 1:M to EMTATRANS, TAEEMASTER and EMTATRNSUM. It is updated by BN66.1, HR11.1, PA115, PR140, PR189, PR195, PR80.1, PR80.4 and 14 more and referenced by HR170, HR70.1, PR134, PR135, PR160, PR180, PR32.2, PR33.2 and 28 more. The table has 38 fields, 4 indexes and 9 documented relations.

About EMTAMASTR

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.

Fields (38)

Column = COBOL field name without the ETM- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#ETM-COMPANY PK
COMPANY		Numeric 4Contains the number that represents an established company.TA50.1, TA60.1, TA80.1, TA81.1
#ETM-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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 PK
PLAN_NAME		Alpha 10Contains the plan name. This is verified in the Time Accrual Plan file.TA50.1, TA60.1, TA80.1, TA81.1
#ETM-PL-ENTRY-DATE
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
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
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
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
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
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
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
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
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
ACR_BALANCE		Signed 9.4Contains the employee's accrual balance. TA199 (Time Accrual Close) updates this field from the temporary accrual balance.TA80.1
#ETM-ELIG-BALANCE
ELIG_BALANCE		Signed 9.4Contains 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
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
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
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
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
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
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
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
T_ACR_BALANCE		Signed 9.4Contains the employee's accrual balance.BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1
#ETM-T-ELG-BALANCE
T_ELG_BALANCE		Signed 9.4Contains the employee's eligible balance.BN66.1, PR140, PR189, PR195, PR80.1, PR80.4, PR89.1, PRAT.1 +1 more
#ETM-ACR-DIST-CO
ACR_DIST_CO		Numeric 4Identifies 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
ACR_ACCT_UNIT		Alpha 15Contains the GL Interface File accrual accounting unit.TA60.1
#ETM-ACR-ACCOUNT
ACR_ACCOUNT		Numeric 6Contains the GL Interface File accrual account.TA60.1
#ETM-ACR-SUB-ACCT
ACR_SUB_ACCT		Numeric 4Contains the GL Interface File accrual subaccount.TA60.1
#ETM-EXP-DIST-CO
EXP_DIST_CO		Numeric 4Identifies 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
EXP_ACCT_UNIT		Alpha 15Contains the GL Interface File expense accounting unit.TA60.1
#ETM-EXP-ACCOUNT
EXP_ACCOUNT		Numeric 6Contains the GL Interface File expense account.TA60.1
#ETM-EXP-SUB-ACCT
EXP_SUB_ACCT		Numeric 4Contains the GL Interface File expense subaccount.TA60.1
#ETM-LST-SEQ-NBR
LST_SEQ_NBR		Numeric 4Contains 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
TRANSFER_FLAG		Alpha 1Contains 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
TA_DOLLARS		Signed 12.2—TA148, TA81.1
#ETM-T-TA-DOLLARS
T_TA_DOLLARS		Signed 12.2—TA42.1
#ETM-EMPL-PERCENT
EMPL_PERCENT		Signed 5.2—TA50.1
#ETM-EMPL-VAC-HRS
EMPL_VAC_HRS		Numeric 7—TA50.1
#ETM-COUNTRY-CODE SET3 SET4
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).TA50.1, TA81.1

Indexes (4)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ETMSET1
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-NAME
PrimaryBN66.1, HR11.1, HR170, HR70.1, ZH230, PA115, PR134, PR135 +22 more (list truncated in source)
ETMSET2
  1. COMPANY
  2. PLAN-NAME
  3. EMPLOYEE
TA147, TA148, TA20.1, TA20.2, TA241, TA242, TA310, TA341 +2 more
ETMSET3
  1. COMPANY
  2. COUNTRY-CODE
  3. EMPLOYEE
  4. PLAN-NAME
TA241, TA260, TA300, TA340, TA50.1, TA60.1
ETMSET4
  1. COMPANY
  2. COUNTRY-CODE
  3. PLAN-NAME
  4. EMPLOYEE
TA175, TA65.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLMASTERPRSYSTEMEMPLOYEEPLANMASTERPLANCLASSEMTATRANSTAEEMASTEREMTATRNSUMEMTAMASTR

One to one (6) — lookups and parents

RelationTableRulesConditionField map
Accrual AcctGLMASTERRequiredWhen 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
CompanyPRSYSTEMRequired
ETM-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
ETM-COMPANY→EMP-COMPANY
ETM-EMPLOYEE→EMP-EMPLOYEE
Expense AcctGLMASTERRequiredWhen 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
PlanPLANMASTERRequired
ETM-COMPANY→PLM-COMPANY
ETM-PLAN-NAME→PLM-PLAN-NAME
Plan ClassPLANCLASSNot Required
ETM-COMPANY→PLC-COMPANY
PLM-PLAN-CLASS→PLC-PLAN-CLASS

One to many (3) — child tables

RelationTableRulesConditionField map
Plan TransEMTATRANSDelete Restricted
ETM-COMPANY→ETT-COMPANY
ETM-EMPLOYEE→ETT-EMPLOYEE
ETM-PLAN-NAME→ETT-PLAN-NAME
—→ETT-DATE
—→ETT-SEQ-NBR
TaeemasterTAEEMASTER
ETM-COMPANY→TEM-COMPANY
—→TEM-EMPLOYEE
—→TEM-PLAN
—→TEM-EMPLOYEE-GROUP
—→TEM-POSITION
Trans SummaryEMTATRNSUMDelete Cascades
ETM-COMPANY→EMT-COMPANY
ETM-EMPLOYEE→EMT-EMPLOYEE
ETM-PLAN-NAME→EMT-PLAN-NAME
—→EMT-YEAR

Programs

Updated by (22)

Referenced by (36)