EMTATRANS – Emp Time Accrual Transactions

System
Event Management (TA)
Prefix
ETT
Primary key
COMPANY, EMPLOYEE, PLAN-NAME, DATE, SEQ-NBR
Fields
13
Updated by
12 programs
Referenced by
16 programs

EMTATRANS is the Emp Time Accrual Transactions table in Lawson Event Management (prefix ETT). It is indexed by COMPANY, EMPLOYEE, PLAN-NAME, DATE, SEQ-NBR (ETTSET1); alternate indexes: ETTSET2, ETTSET3, ETTSET4, ETTSET5 and ETTSET6. It is related 1:1 to PRSYSTEM, EMPLOYEE, EMTAMASTR and PLANMASTER. It is updated by TA148, TA300, TA310, TA340, TA341, TA42.1, TA542, TA570 and 4 more and referenced by HR170, HR70.1, LP900, PR160, PR180, PR80.2, TA147, TA175 and 8 more. The table has 13 fields, 6 indexes and 4 documented relations.

About EMTATRANS

Contains time accrual transactions for each plan for an employee.

Fields (13)

Column = COBOL field name without the ETT- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
ETT-COMPANY PK
COMPANY		Numeric 4Contains the number that represents an established company.TA148, TA300, TA340, TA42.1, TA542, TA570, TA70.1, TA70.2 +2 more
ETT-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number which is used to correlate all information related to the employee.TA148, TA300, TA340, TA42.1, TA542, TA570, TA70.1, TA70.2 +2 more
ETT-PLAN-NAME PK
PLAN_NAME		Alpha 10Contains the plan name. This is verified in the Time Accrual Plan file.TA148, TA300, TA340, TA42.1, TA542, TA570, TA70.1, TA70.2 +2 more
ETT-DATE PK
DATE		Numeric 8 (yyyymmdd)Contains the date of the transaction. The transaction date can default from the end date of the payroll period, the last eligible date, or the eligible limit date defined for the plan.TA148, TA300, TA340, TA42.1, TA542, TA570, TA70.1, TA70.2 +2 more
ETT-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains a sequence number that keeps records unique. It is automatically assigned when records are created.TA148, TA300, TA340, TA42.1, TA542, TA570, TA70.1, TA70.2 +2 more
ETT-TYPE
TYPE		Alpha 2Contains the transaction type.
  • A Accrual Hours
  • B Beginning balance from Purge
  • LA Lost Accrual
  • LE Lost Eligible
  • MA Manual Accrual
  • ME Manual Eligible
  • TA Transfer Accrual
  • TE Transfer Eligible
  • U Usage Hours
  • X Accrued and Eligible Hours
  • MV CA Manual Vac
  • XV CA Eligible Vac
  • UV CA Used Vac
  • BV CA Beg Bal Vac
  • LV CA Lost Vac
TA148, TA300, TA340, TA42.1, TA542, TA570, TA70.1, TA70.2 +2 more
ETT-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the transaction description.TA148, TA300, TA340, TA42.1, TA542, TA570, TA70.1, TA70.2 +2 more
ETT-TA-HOURS
TA_HOURS		Signed 9.4Contains the hours associated with the transaction.PR80.2, TA148, TA300, TA340, TA42.1, TA542, TA570, TA65.3 +4 more
ETT-STATUS
STATUS		Numeric 1Contains the transaction status.
  • 0 Unprocessed (Created in TA70)
  • 2 Processed (Ran TA170)
  • 9 Closed (Ran TA199)
TA148, TA300, TA340, TA42.1, TA542, TA570, TA70.1, TA70.2 +2 more
ETT-TA-DOLLARS
TA_DOLLARS		Signed 12.2—PR80.2, TA148, TA340, TA42.1, TA542, TA81.1
ETT-VAC-PAY-CLASS
VAC_PAY_CLASS		Alpha 3——
ETT-VAC-PAY-CODE
VAC_PAY_CODE		Alpha 4——
ETT-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).TA148, TA42.1, TA542, TA70.1, TA70.2, TA81.1

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
ETTSET1COMPANY, EMPLOYEE, PLAN-NAME, DATE, SEQ-NBRPrimaryHR170, HR70.1, ZH230, PR160, PR180, PR80.2, TA241, TA300 +4 more
ETTSET2COMPANY, PLAN-NAME, EMPLOYEE, DATE, SEQ-NBRTA147, TA148
ETTSET3COMPANY, COUNTRY-CODE, PLAN-NAME, EMPLOYEE, DATE, SEQ-NBRSubsetWhere STATUS = 2 Or STATUS = ZeroesLP900, TA42.1, TA70.1
ETTSET4COMPANY, COUNTRY-CODE, EMPLOYEE, PLAN-NAME, DATE, SEQ-NBRSubsetWhere STATUS = 2 Or STATUS = ZeroesTA175, TA270, TA70.2, TA80.1, TA81.1
ETTSET5COMPANY, COUNTRY-CODE, EMPLOYEE, PLAN-NAME, DATE, SEQ-NBRTA265, TA290, TA300, TA340, TA65.3
ETTSET6COMPANY, COUNTRY-CODE, PLAN-NAME, EMPLOYEE, DATE, SEQ-NBRTA310

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredETT-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequiredETT-COMPANY → EMP-COMPANY, ETT-EMPLOYEE → EMP-EMPLOYEE
Employee PlanEMTAMASTRRequiredETT-COMPANY → ETM-COMPANY, ETT-EMPLOYEE → ETM-EMPLOYEE, ETT-PLAN-NAME → ETM-PLAN-NAME
PlanPLANMASTERRequiredETT-COMPANY → PLM-COMPANY, ETT-PLAN-NAME → PLM-PLAN-NAME

Programs

Updated by (12)

Referenced by (16)