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

Field / columnTypeDescription & valuesUpdated by
#TTR-COMPANY PK
COMPANY		Numeric 4Contains the company number.LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
#TTR-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains 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 10Contains the absence plan name.LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
#TTR-EMPLOYEE-GROUP PK
EMPLOYEE_GROUP		Alpha 10Contains 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 12Contains 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 4Contains 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 2Contains 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 2Determines 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 SET6
TA_TYPE		Numeric 2Contains 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.6Contains 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.6Contains 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 5Contains 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.2Contains 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 1Contains 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 12This 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 SET6
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 10Contains 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 SET5
HM_PROC_LEVEL		Alpha 5Contains the employee's home process level.LP130, LP131, LP138, LP140, LP145, LP180, LP370, LP570 +3 more
#TTR-CREATE-DATE SET10
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 SET10
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 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
TTRSET1
  1. COMPANY
  2. EMPLOYEE
  3. PLAN
  4. EMPLOYEE-GROUP
  5. POSITION
  6. DATE
  7. SEQ-NBR
PrimaryHR11.1, HR511, HS17.1, LT101, LT111, LP100, LP101, LP102 +18 more
TTRSET10
  1. COMPANY
  2. CREATE-DATE ↓
  3. DATE-STAMP ↓
  4. EMPLOYEE
  5. PLAN
  6. EMPLOYEE-GROUP
  7. POSITION
  8. DATE
  9. SEQ-NBR
KeyChange—
TTRSET2
  1. COMPANY
  2. EMPLOYEE
  3. PLAN
  4. EMPLOYEE-GROUP
  5. POSITION
  6. DATE
  7. SEQ-NBR
SubsetWhere STATUS = ZeroesLP140, LP270, LP80.1
TTRSET3
  1. COMPANY
  2. PLAN
  3. EMPLOYEE-GROUP
  4. EMPLOYEE
  5. POSITION
  6. DATE
  7. SEQ-NBR
LP145
TTRSET4
  1. COMPANY
  2. EMPLOYEE
  3. PLAN
  4. EMPLOYEE-GROUP
  5. POSITION
  6. DATE
  7. SEQ-NBR
SubsetWhere STATUS = 2LP131, LP140, LP145, LP240, PR160, PR180, PR80.2
TTRSET5
  1. COMPANY
  2. HM-PROC-LEVEL
  3. EMPLOYEE
  4. PLAN
  5. EMPLOYEE-GROUP
  6. POSITION
  7. DATE
  8. SEQ-NBR
KeyChangeLP130
TTRSET6
  1. COMPANY
  2. EMPLOYEE
  3. PLAN
  4. EMPLOYEE-GROUP
  5. POSITION
  6. TA-TYPE
  7. RESET-DATE
  8. DATE ↓
  9. SEQ-NBR
KeyChangeLP198
TTRSET7
  1. COMPANY
  2. EMPLOYEE
  3. PLAN
  4. EMPLOYEE-GROUP
  5. POSITION
  6. DATE ↓
  7. SEQ-NBR ↓
HS706, LP64.1
TTRSET8
  1. COMPANY
  2. EMPLOYEE
  3. PLAN
  4. EMPLOYEE-GROUP
  5. POSITION
  6. DATE
  7. SEQ-NBR
SubsetWhere STATUS = 2 Or STATUS = 3LP197
TTRSET9
  1. COMPANY
  2. EMPLOYEE
  3. PLAN
  4. EMPLOYEE-GROUP
  5. POSITION
  6. DATE ↓
  7. SEQ-NBR
SubsetWhere ((TRAN-TYPE <= 12) Or (TRAN-TYPE >= 81 And TRAN-TYPE <= 85)) And (STATUS <= 2)LP70.1, LP70.2

Relations

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

One to one (10) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
TTR-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen TTR-CURRENCY-CODE != Spaces
TTR-CURRENCY-CODE→CUC-CURRENCY-CODE
EmployeeEMPLOYEERequired
TTR-COMPANY→EMP-COMPANY
TTR-EMPLOYEE→EMP-EMPLOYEE
Employee GroupPERSGROUPRequired
TTR-COMPANY→PRG-COMPANY
TTR-EMPLOYEE-GROUP→PRG-GROUP-NAME
Employee MastrTAEEMASTERRequired
TTR-COMPANY→TEM-COMPANY
TTR-EMPLOYEE→TEM-EMPLOYEE
TTR-PLAN→TEM-PLAN
TTR-EMPLOYEE-GROUP→TEM-EMPLOYEE-GROUP
TTR-POSITION→TEM-POSITION
Hm Proc LevelPRSYSTEMRequiredWhen TTR-HM-PROC-LEVEL != Spaces
TTR-COMPANY→PRS-COMPANY
TTR-HM-PROC-LEVEL→PRS-PROCESS-LEVEL
PaemployeePAEMPLOYEERequired
TTR-COMPANY→PEM-COMPANY
TTR-EMPLOYEE→PEM-EMPLOYEE
PcodesPCODESRequiredWhen TTR-TRAN-CODE != Spaces
"LC"→PCO-TYPE
TTR-TRAN-CODE→PCO-CODE
PlanTAPLANRequired
TTR-COMPANY→TAP-COMPANY
TTR-PLAN→TAP-PLAN
TatransumTATRANSUMRequired
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

RelationTableRulesConditionField map
PositionPAPOSITIONValid When TTR-POSITION != Spaces
TTR-COMPANY→POS-COMPANY
TTR-POSITION→POS-POSITION
—→POS-EFFECT-DATE
TastructurTASTRUCTUR
TTR-COMPANY→TST-COMPANY
TTR-EMPLOYEE-GROUP→TST-EMPLOYEE-GROUP
TTR-PLAN→TST-PLAN
—→TST-BEGIN-DATE

Programs

Updated by (22)

Referenced by (14)