TAEMPTRANS – This file contains the accrual plan transactions for each plan structure for an employee.

System: Absence Management (LP)
Prefix: TTR
Primary key: COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, DATE, SEQ-NBR
Fields: 36
Updated by: 22 programs
Referenced by: 14 programs

TAEMPTRANS is the This file contains the accrual plan transactions for each plan structure for an employee. table in Lawson Absence Management (prefix TTR). It is indexed by COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, DATE, SEQ-NBR (TTRSET1); alternate indexes: TTRSET10, TTRSET2, TTRSET3, TTRSET4, TTRSET5, TTRSET6, TTRSET7, TTRSET8 and 1 more. It is related 1:1 to PRSYSTEM, CUCODES, EMPLOYEE, PERSGROUP, TAEEMASTER, PAEMPLOYEE, PCODES, TAPLAN and 1 more and 1:M to PAPOSITION and TASTRUCTUR. It is updated by HS17.1, HS706, LP102, LP130, LP131, LP138, LP140, LP145 and 14 more and referenced by HR11.1, HR511, LP100, LP101, LP103, LP240, LP264, LP31.1 and 6 more. The table has 36 fields, 10 indexes and 12 documented relations.

About TAEMPTRANS

This file contains the accrual plan transactions for each plan structure for an employee.

Fields (36)

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

Field / column	Type	Description & values	Updated by
`TTR-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
`TTR-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.	LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
`TTR-PLAN` PK PLAN	Alpha 10	Contains the absence plan name.	LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
`TTR-EMPLOYEE-GROUP` PK EMPLOYEE_GROUP	Alpha 10	Contains the accrual employee group which, when attached to a plan, represents an absence plan structure.	LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
`TTR-POSITION` PK POSITION	Alpha 12	Contains the position code of the employee if plan balances are held at the position code level.	LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
`TTR-DATE` PK DATE	Numeric 8 (yyyymmdd)	Contains the date of the transaction. For events, the transaction date is determined based on the date of the event. Otherwise, the transaction date is based on the plan cycle frequency or the pay period end date of service records processed.	LP130, LP131, LP138, LP140, LP145, LP151, LP180, LP370 +4 more
`TTR-SEQ-NBR` PK SEQ_NBR	Numeric 4	Contains a unique sequence number that keeps records unique. It is automatically assigned when records are created.	LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
`TTR-TRAN-TYPE` TRAN_TYPE	Numeric 2	Contains the transaction type. Transaction type 11 and 12 are created by LP138. `01` Manual Accrual `02` Manual Allotment `03` Manual Available `04` Manual Reserve `05` Manual Carryover `10` Restore Used Available `11` Sell from Available `12` Purchase for Available `21` Accrual `22` Allotment `23` Allotment Adj for Rounding `31` Transfer from Accrual `32` Transfer from Allotment `33` Transfer to Avail from Accr `34` Transfer to Avail from Allot `35` Creation of carryover balance `42` Lost Accr-Ongoing Limit `43` Lost Allot-Ongoing Limit `44` Lost Avail-Carryover Limit `45` Lost Avail-Carry Period Limit `46` Lost Carry-Period Limit `47` Reset Carry-Carryover Recalc `51` Allotment Adj for Factor Chgs `52` Allotment Adj for Accruals `61` Use `63` Payout `71` Zero Accrual `72` Zero Allotment `73` Zero Available `74` Zero Reserve `75` Zero Carryover `81` Transfer Accrual Bal `82` Transfer Allotment Bal `83` Transfer Available Bal `84` Transfer Reserve Bal `85` Transfer Carryover Bal `91` Purge Accrual Bal `92` Purge Allotment Bal `93` Purge Available Bal `94` Purge Reserve Bal `95` Purge Carryover Bal `48` Lost Avail-Ongoing Limit	LP130, LP131, LP138, LP140, LP145, LP151, LP180, LP370 +4 more
`TTR-BALANCE-TYPE` BALANCE_TYPE	Numeric 2	Determines which TAEEMASTER balance to adjust. `01` Accrual `02` Allotment `03` Available `04` Reserve `05` Carryover	LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
`TTR-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	Contains the transaction description.	LP130, LP131, LP138, LP140, LP145, LP151, LP180, LP370 +4 more
`TTR-TA-TYPE` TA_TYPE	Numeric 2	Contains the transaction units of measure. `01` Hours `02` Earnings	LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
`TTR-TA-HOURS` TA_HOURS	Signed 18.6	Contains the hours associated with the transaction. Used with TA-Type = 1 (Hours).	LP130, LP131, LP138, LP140, LP145, LP151, LP180, LP370 +6 more
`TTR-TA-EARNINGS` TA_EARNINGS	Signed 18.6	Contains the earnings associated with the transaction. Used with TA-Type = 2 (Earnings).	LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +5 more
`TTR-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	Contains the currency code for the transaction. Used with TA-Type = 2 (Earnings).	LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
`TTR-TA-LOS-CALC` TA_LOS_CALC	Signed 9.2	Contains the length of service hours or cycles used to determine the amount of this transaction.	LP130, LP138, LP140, LP145, LP180, LP370
`TTR-STATUS` STATUS	Numeric 1	Contains the the status of the transaction. Updated by TA140, TA197. `0` Unprocessed `2` Processed `3` Transferred `9` Closed	LP130, LP131, LP138, LP140, LP145, LP151, LP180, LP197 +5 more
`TTR-TA-OBJ-ID` TA_OBJ_ID	Numeric 12	This object ID will associate transactions created by LP138 to specific benefit plan enrollments and balances in BNTAEMPBAL.	LP130, LP138, LP370
`TTR-PROCESS-DATE` PROCESS_DATE	Numeric 8 (yyyymmdd)	Contains the process through date of the LP140 job that processed this transaction.	LP130, LP138, LP140, LP145, LP370
`TTR-RESET-DATE` RESET_DATE	Numeric 8 (yyyymmdd)	Contains the Reset Date determined by the Reset Point. This is the first date of the limit year. This will be the date used by LP197 when accumulating transactions into TATRANSUM file by reset date.	LP102, LP130, LP138, LP140, LP145, LP180, LP197, LP370
`TTR-PLAN-CATEGORY` PLAN_CATEGORY	Alpha 10	Contains the category for the plan. This is needed for limit check by plan category that will read open TAEMPTRANS record.	LP130, LP138, LP140, LP145, LP180, LP370
`TTR-ALLOT-PER-BEG` ALLOT_PER_BEG	Numeric 8 (yyyymmdd)	For allotments, contains the beginning date of the allotment period.	LP130, LP138, LP140, LP145, LP370
`TTR-ALLOT-PER-END` ALLOT_PER_END	Numeric 8 (yyyymmdd)	For allotments, contains the end date of the allotment period.	LP130, LP138, LP140, LP145, LP370
`TTR-ALLOT-CYCLE-DT` ALLOT_CYCLE_DT	Numeric 8 (yyyymmdd)	For cycle based allotments, contains the cycle date.	LP130, LP138, LP140, LP145, LP370
`TTR-CLOSE-DATE` CLOSE_DATE	Numeric 8 (yyyymmdd)	Contains the system date that LP197 closed this transaction.	LP130, LP138, LP197, LP370
`TTR-GL-POST-DATE` GL_POST_DATE	Numeric 8 (yyyymmdd)	For non reversing entries, this references the GL Post Date used on LP198.	LP130, LP138, LP198, LP370
`TTR-HM-PROC-LEVEL` HM_PROC_LEVEL	Alpha 5	Contains the employee's home process level.	LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
`TTR-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	Holds the server date this record was originally created.	LP130, LP131, LP138, LP140, LP145, LP151, LP180, LP370 +4 more
`TTR-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	Holds the server time this record was originally created.	LP130, LP131, LP138, LP140, LP145, LP151, LP180, LP370 +4 more
`TTR-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	Contains the user ID of the person who originally created this record.	LP130, LP131, LP138, LP140, LP145, LP151, LP180, LP370 +4 more
`TTR-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	LP130, LP131, LP138, LP140, LP145, LP151, LP180, LP197 +6 more
`TTR-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LP130, LP131, LP138, LP140, LP145, LP151, LP180, LP197 +6 more
`TTR-USER-ID` USER_ID	Alpha 10 (Lower Case)	Contains the user ID of the person who last updated this record.	LP130, LP131, LP138, LP140, LP145, LP151, LP180, LP197 +6 more
`TTR-TA-ACCR-RATE` TA_ACCR_RATE	Signed 18.6	—	—
`TTR-ORIG-RESET-DT` ORIG_RESET_DT	Numeric 8 (yyyymmdd)	—	LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
`TTR-TRAN-CODE` TRAN_CODE	Alpha 10	—	LP570, LP70.1, LP70.2
`TTR-ABN-OBJ-ID` ABN_OBJ_ID	Numeric 12	—	LP140

Indexes (10)

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

Index	Keys	Flags	Condition	Used in
`TTRSET1`	`COMPANY`, `EMPLOYEE`, `PLAN`, `EMPLOYEE-GROUP`, `POSITION`, `DATE`, `SEQ-NBR`	Primary		HR11.1, HR511, HS17.1, LT101, LT111, LP100, LP101, LP102 +18 more
`TTRSET10`	`COMPANY`, `CREATE-DATE`, `DATE-STAMP`, `EMPLOYEE`, `PLAN`, `EMPLOYEE-GROUP`, `POSITION`, `DATE`, `SEQ-NBR`	KeyChange		—
`TTRSET2`	`COMPANY`, `EMPLOYEE`, `PLAN`, `EMPLOYEE-GROUP`, `POSITION`, `DATE`, `SEQ-NBR`	Subset	Where STATUS = Zeroes	LP140, LP270, LP80.1
`TTRSET3`	`COMPANY`, `PLAN`, `EMPLOYEE-GROUP`, `EMPLOYEE`, `POSITION`, `DATE`, `SEQ-NBR`			LP145
`TTRSET4`	`COMPANY`, `EMPLOYEE`, `PLAN`, `EMPLOYEE-GROUP`, `POSITION`, `DATE`, `SEQ-NBR`	Subset	Where STATUS = 2	LP131, LP140, LP145, LP240, PR160, PR180, PR80.2
`TTRSET5`	`COMPANY`, `HM-PROC-LEVEL`, `EMPLOYEE`, `PLAN`, `EMPLOYEE-GROUP`, `POSITION`, `DATE`, `SEQ-NBR`	KeyChange		LP130
`TTRSET6`	`COMPANY`, `EMPLOYEE`, `PLAN`, `EMPLOYEE-GROUP`, `POSITION`, `TA-TYPE`, `RESET-DATE`, `DATE*`, `SEQ-NBR`	KeyChange		LP198
`TTRSET7`	`COMPANY`, `EMPLOYEE`, `PLAN`, `EMPLOYEE-GROUP`, `POSITION`, `DATE`, `SEQ-NBR`			HS706, LP64.1
`TTRSET8`	`COMPANY`, `EMPLOYEE`, `PLAN`, `EMPLOYEE-GROUP`, `POSITION`, `DATE`, `SEQ-NBR`	Subset	Where STATUS = 2 Or STATUS = 3	LP197
`TTRSET9`	`COMPANY`, `EMPLOYEE`, `PLAN`, `EMPLOYEE-GROUP`, `POSITION`, `DATE*`, `SEQ-NBR`	Subset	Where ((TRAN-TYPE <= 12) Or (TRAN-TYPE >= 81 And TRAN-TYPE <= 85)) And (STATUS <= 2)	LP70.1, LP70.2

Relations

One to one (10) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`TTR-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Currency	CUCODES	Required	When TTR-CURRENCY-CODE != Spaces	`TTR-CURRENCY-CODE` → `CUC-CURRENCY-CODE`
Employee	EMPLOYEE	Required		`TTR-COMPANY` → `EMP-COMPANY`, `TTR-EMPLOYEE` → `EMP-EMPLOYEE`
Employee Group	PERSGROUP	Required		`TTR-COMPANY` → `PRG-COMPANY`, `TTR-EMPLOYEE-GROUP` → `PRG-GROUP-NAME`
Employee Mastr	TAEEMASTER	Required		`TTR-COMPANY` → `TEM-COMPANY`, `TTR-EMPLOYEE` → `TEM-EMPLOYEE`, `TTR-PLAN` → `TEM-PLAN`, `TTR-EMPLOYEE-GROUP` → `TEM-EMPLOYEE-GROUP`, `TTR-POSITION` → `TEM-POSITION`
Hm Proc Level	PRSYSTEM	Required	When TTR-HM-PROC-LEVEL != Spaces	`TTR-COMPANY` → `PRS-COMPANY`, `TTR-HM-PROC-LEVEL` → `PRS-PROCESS-LEVEL`
Paemployee	PAEMPLOYEE	Required		`TTR-COMPANY` → `PEM-COMPANY`, `TTR-EMPLOYEE` → `PEM-EMPLOYEE`
Pcodes	PCODES	Required	When TTR-TRAN-CODE != Spaces	`"LC"` → `PCO-TYPE`, `TTR-TRAN-CODE` → `PCO-CODE`
Plan	TAPLAN	Required		`TTR-COMPANY` → `TAP-COMPANY`, `TTR-PLAN` → `TAP-PLAN`
Tatransum	TATRANSUM	Required		`TTR-COMPANY` → `TTS-COMPANY`, `TTR-EMPLOYEE` → `TTS-EMPLOYEE`, `TTR-PLAN` → `TTS-PLAN`, `TTR-EMPLOYEE-GROUP` → `TTS-EMPLOYEE-GROUP`, `TTR-POSITION` → `TTS-POSITION`, `TTR-TA-TYPE` → `TTS-TA-TYPE`, `TTR-RESET-DATE` → `TTS-RESET-DATE`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Position	PAPOSITION		Valid When TTR-POSITION != Spaces	`TTR-COMPANY` → `POS-COMPANY`, `TTR-POSITION` → `POS-POSITION`, → `POS-EFFECT-DATE`
Tastructur	TASTRUCTUR			`TTR-COMPANY` → `TST-COMPANY`, `TTR-EMPLOYEE-GROUP` → `TST-EMPLOYEE-GROUP`, `TTR-PLAN` → `TST-PLAN`, → `TST-BEGIN-DATE`

Programs

Updated by (22)

HS17.1 LP Balances on Paychecks
HS706 HRM Time Off Planner Interface
LP102 Employee Master Update
LP130 Absence Plan Payout
LP131 Zero Balance Update
LP138 Absence Plan Hours Update
LP140 Employee Absence Plan Calculation
LP145 Allotment Adjustment Calculation
LP151 FMLA Rolling 12 Month Update
LP180 Mass Absence Plan Transfer
LP197 Absence Plan Close
LP198 General Ledger Liability Update
LP270 Open Manual Transactions
LP331 Employee Absence Plan Purge
LP370 Employee Absence Transaction Consolidation
LP570 Manual Transaction Conversion
LP70.1 Manual Transactions by Employee
LP70.2 Manual Transactions by Plan Structure
LP80.1 Employee Absence Plan Transfer
PR160 Payment Print
PR180 Manual Payment Print
PR80.2 Manual Payment Print

Referenced by (14)

HR11.1 Employee
HR511 Employee Conversion
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LP103 Mass Absence Plan Termination
LP240 Employee Plan Transaction Report
LP264 Employee Transaction History Report
LP31.1 Employee Absence Plan Master
LP64.1 Employee Transaction Detail Inquiry
LP64.3 Employee Transaction Detail Balance Inquiry
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA100 Action Update
PA52.4 Hire an Applicant