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.

Field / column	Type	Description & values	Updated by
`EMT-COMPANY` PK COMPANY	Numeric 4	Contains the number that represents an established company.	TA148, TA80.1, TA81.1
`EMT-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains 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 10	Contains the plan name. This is verified in the Time Accrual Plan file.	TA148, TA80.1, TA81.1
`EMT-YEAR` PK YEAR	Numeric 4	Contains the year during which the summarized transactions occurred.	TA148, TA80.1, TA81.1
`EMT-YTD-ACR-HRS` YTD_ACR_HRS	Signed 9.4	Contains 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.4	Contains 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.4	Contains 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.4	Contains 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.2	Contains the total eligible hours the employee used.	PR80.2
`EMT-LOST-ELIG-HRS` LOST_ELIG_HRS	Signed 9.4	Contains 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` COUNTRY_CODE	Alpha 2	The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).	TA148, TA81.1

Indexes (4)

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

Index	Keys	Flags	Used in
`EMTSET1`	`COMPANY`, `EMPLOYEE`, `PLAN-NAME`, `YEAR`	Primary	HR170, HR70.1, PR160, PR180, PR80.2, TA148, TA260, TA290 +5 more
`EMTSET2`	`COMPANY`, `PLAN-NAME`, `EMPLOYEE`, `YEAR`		TA148
`EMTSET3`	`COMPANY`, `COUNTRY-CODE`, `EMPLOYEE`, `PLAN-NAME`, `YEAR`		TA290, TA65.2
`EMTSET4`	`COMPANY`, `COUNTRY-CODE`, `PLAN-NAME`, `EMPLOYEE`, `YEAR`		TA310

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Company	PRSYSTEM	Required	`EMT-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required	`EMT-COMPANY` → `EMP-COMPANY`, `EMT-EMPLOYEE` → `EMP-EMPLOYEE`
Employee Plan	EMTAMASTR	Required	`EMT-COMPANY` → `ETM-COMPANY`, `EMT-EMPLOYEE` → `ETM-EMPLOYEE`, `EMT-PLAN-NAME` → `ETM-PLAN-NAME`
Plan	PLANMASTER	Required	`EMT-COMPANY` → `PLM-COMPANY`, `EMT-PLAN-NAME` → `PLM-PLAN-NAME`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Transactions	EMTATRANS	Delete Cascades		`EMT-COMPANY` → `ETT-COMPANY`, `EMT-EMPLOYEE` → `ETT-EMPLOYEE`, `EMT-PLAN-NAME` → `ETT-PLAN-NAME`, → `ETT-DATE`, → `ETT-SEQ-NBR`

Programs

Updated by (7)

TA148 Canada Vacation Rollover
TA310 Employee Plan Purge
TA341 Canada Vacation Employee Plan Purge
TA50.1 Canada Employee Vacation Plan
TA60.1 Employee Plan Inquiry
TA80.1 Plan Transfer
TA81.1 Canada Vacation Plan Transfer

Referenced by (8)

HR170 Human Resource Writer Report Request
HR70.1 Human Resource Writer Inquiry
PR160 Payment Print
PR180 Manual Payment Print
PR80.2 Manual Payment Print
TA260 Employee Plan Listing
TA290 Transaction History Report
TA65.2 Yearly Activity Inquiry