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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET3 SET4 SET5 SET6
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 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
ETTSET1
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-NAME
  4. DATE
  5. SEQ-NBR
PrimaryHR170, HR70.1, ZH230, PR160, PR180, PR80.2, TA241, TA300 +4 more
ETTSET2
  1. COMPANY
  2. PLAN-NAME
  3. EMPLOYEE
  4. DATE
  5. SEQ-NBR
TA147, TA148
ETTSET3
  1. COMPANY
  2. COUNTRY-CODE
  3. PLAN-NAME
  4. EMPLOYEE
  5. DATE
  6. SEQ-NBR
SubsetWhere STATUS = 2 Or STATUS = ZeroesLP900, TA42.1, TA70.1
ETTSET4
  1. COMPANY
  2. COUNTRY-CODE
  3. EMPLOYEE
  4. PLAN-NAME
  5. DATE
  6. SEQ-NBR
SubsetWhere STATUS = 2 Or STATUS = ZeroesTA175, TA270, TA70.2, TA80.1, TA81.1
ETTSET5
  1. COMPANY
  2. COUNTRY-CODE
  3. EMPLOYEE
  4. PLAN-NAME
  5. DATE
  6. SEQ-NBR
TA265, TA290, TA300, TA340, TA65.3
ETTSET6
  1. COMPANY
  2. COUNTRY-CODE
  3. PLAN-NAME
  4. EMPLOYEE
  5. DATE
  6. SEQ-NBR
TA310

Relations

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

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
ETT-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
ETT-COMPANY→EMP-COMPANY
ETT-EMPLOYEE→EMP-EMPLOYEE
Employee PlanEMTAMASTRRequired
ETT-COMPANY→ETM-COMPANY
ETT-EMPLOYEE→ETM-EMPLOYEE
ETT-PLAN-NAME→ETM-PLAN-NAME
PlanPLANMASTERRequired
ETT-COMPANY→PLM-COMPANY
ETT-PLAN-NAME→PLM-PLAN-NAME

Programs

Updated by (12)

Referenced by (16)