EMTATRNSUM – Emp TA Transaction Summary

System
Event Management (TA)
Prefix
EMT
Primary key
COMPANY, EMPLOYEE, PLAN-NAME, YEAR
Fields
19
Updated by
7 programs
Referenced by
8 programs

EMTATRNSUM is the Emp TA Transaction Summary table in Lawson Event Management (prefix EMT). It is indexed by COMPANY, EMPLOYEE, PLAN-NAME, YEAR (EMTSET1); alternate indexes: EMTSET2, EMTSET3 and EMTSET4. It is related 1:1 to PRSYSTEM, EMPLOYEE, EMTAMASTR and PLANMASTER and 1:M to EMTATRANS. It is updated by TA148, TA310, TA341, TA50.1, TA60.1, TA80.1 and TA81.1 and referenced by HR170, HR70.1, PR160, PR180, PR80.2, TA260, TA290 and TA65.2. The table has 19 fields, 4 indexes and 5 documented relations.

About EMTATRNSUM

Contains a summary of the transactions that occurred during the calendar year for the plan, by employee.

Fields (19)

Column = COBOL field name without the EMT- 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
#EMT-COMPANY PK
COMPANY		Numeric 4Contains the number that represents an established company.TA148, TA80.1, TA81.1
#EMT-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number which is used to correlate all information related to the employee.TA148, TA80.1, TA81.1
#EMT-PLAN-NAME PK
PLAN_NAME		Alpha 10Contains the plan name. This is verified in the Time Accrual Plan file.TA148, TA80.1, TA81.1
#EMT-YEAR PK
YEAR		Numeric 4Contains the year during which the summarized transactions occurred.TA148, TA80.1, TA81.1
#EMT-YTD-ACR-HRS
YTD_ACR_HRS		Signed 9.4Contains the calendar year-to-date accrued hours. If this is the current year, these hours were last updated when TA199 (Time Accrual Close) was run.TA80.1
#EMT-YTD-ELIG-HRS
YTD_ELIG_HRS		Signed 9.4Contains the calendar year-to-date eligible hours. If this is the current year, these hours were last updated when TA199 (Time Accrual Close) was run.TA148, TA50.1, TA80.1, TA81.1
#EMT-END-ACR-HRS
END_ACR_HRS		Signed 9.4Contains the balance of accrued hours for this calendar year. If this is the current year, these hours were last updated when TA199 (Time Accrual Close) was run.TA80.1
#EMT-END-ELIG-HRS
END_ELIG_HRS		Signed 9.4Contains the eligible hours year-end balance. If current year, these hours were last updated when TA199 (Time Accrual Close) was run.TA80.1, TA81.1
#EMT-HRS-USED
HRS_USED		Signed 7.2Contains the total eligible hours the employee used.PR80.2
#EMT-LOST-ELIG-HRS
LOST_ELIG_HRS		Signed 9.4Contains the total eligible hours that exceeded the eligible limit. The employee loses these hours.—
#EMT-YTD-ACCR-DOL
YTD_ACCR_DOL		Signed 12.2——
#EMT-YTD-ELIG-DOL
YTD_ELIG_DOL		Signed 12.2—TA148, TA50.1, TA81.1
#EMT-END-ACCR-DOL
END_ACCR_DOL		Signed 12.2——
#EMT-END-ELIG-DOL
END_ELIG_DOL		Signed 12.2—TA81.1
#EMT-YTD-DOL-USED
YTD_DOL_USED		Signed 12.2—PR80.2
#EMT-BEG-BAL-DOL
BEG_BAL_DOL		Signed 12.2—TA148, TA81.1
#EMT-BEG-ACR-HRS
BEG_ACR_HRS		Signed 9.4——
#EMT-BEG-ELIG-HRS
BEG_ELIG_HRS		Signed 9.4—TA148, TA81.1
#EMT-COUNTRY-CODE SET3 SET4
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).TA148, 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
EMTSET1
  1. COMPANY
  2. EMPLOYEE
  3. PLAN-NAME
  4. YEAR
PrimaryHR170, HR70.1, PR160, PR180, PR80.2, TA148, TA260, TA290 +5 more
EMTSET2
  1. COMPANY
  2. PLAN-NAME
  3. EMPLOYEE
  4. YEAR
TA148
EMTSET3
  1. COMPANY
  2. COUNTRY-CODE
  3. EMPLOYEE
  4. PLAN-NAME
  5. YEAR
TA290, TA65.2
EMTSET4
  1. COMPANY
  2. COUNTRY-CODE
  3. PLAN-NAME
  4. EMPLOYEE
  5. YEAR
TA310

Relations

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

One to one (4) — lookups and parents

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

One to many (1) — child tables

RelationTableRulesConditionField map
TransactionsEMTATRANSDelete Cascades
EMT-COMPANY→ETT-COMPANY
EMT-EMPLOYEE→ETT-EMPLOYEE
EMT-PLAN-NAME→ETT-PLAN-NAME
—→ETT-DATE
—→ETT-SEQ-NBR

Programs

Updated by (7)

Referenced by (8)