TATRANSUM – No description in the Lawson data dictionary

System: Absence Management (LP)
Prefix: TTS
Primary key: COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, TA-TYPE, RESET-DATE
Fields: 45
Updated by: 8 programs
Referenced by: 2 programs

TATRANSUM is a Lawson Absence Management table (prefix TTS); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE, PLAN, EMPLOYEE-GROUP, POSITION, TA-TYPE, RESET-DATE (TTSSET1); alternate indexes: TTSSET2 and TTSSET3. It is related 1:1 to PRSYSTEM, CUCODES, EMPLOYEE, PERSGROUP, TAEEMASTER, PAEMPLOYEE and TAPLAN and 1:M to PAPOSITION, TAEMPTRANS and TASTRUCTUR. It is updated by LP102, LP140, LP197, LP264, LP331, PR160, PR180 and PR80.2 and referenced by LP180 and LP64.2. The table has 45 fields, 3 indexes and 11 documented relations.

About TATRANSUM

No description in the Lawson data dictionary.

Fields (45)

Column = COBOL field name without the TTS- 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 / column	Type	Description & values	Updated by
#`TTS-COMPANY` PK COMPANY	Numeric 4	Contains the company number.	LP102, LP197
#`TTS-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number.	LP102, LP197
#`TTS-PLAN` PK PLAN	Alpha 10	—	LP102, LP197
#`TTS-EMPLOYEE-GROUP` PK EMPLOYEE_GROUP	Alpha 10	—	LP102, LP197
#`TTS-POSITION` PK POSITION	Alpha 12	Contains the position code of the employee if plan balances are held at the position code level.	LP102, LP197
#`TTS-TA-TYPE` PK TA_TYPE	Numeric 2	Contains the units of measure for the summarized totals. `01` Hours `02` Earnings	LP102, LP197
#`TTS-RESET-DATE` PK RESET_DATE	Numeric 8 (yyyymmdd)	—	LP102, LP197
#`TTS-CURRENCY-CODE` CURRENCY_CODE	Alpha 5	Contains the currency code for earnings summary transactions (TA-Type = 2). This will be blank for hours summary transactions (TA-Type = 1).	LP102, LP197
#`TTS-HM-PROC-LEVEL` SET3 HM_PROC_LEVEL	Alpha 5	—	LP102, LP197
#`TTS-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	LP102, LP197
#`TTS-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LP102, LP197
#`TTS-USER-ID` USER_ID	Alpha 10 (Lower Case)	Contains the user ID of the person who last updated this record.	LP102, LP197
#`TTS-BEG-ACCR-BAL` BEG_ACCR_BAL	Signed 18.6	TTR-BALANCE-TYPE = 1	LP102, LP197
#`TTS-YTD-ACCRUAL` YTD_ACCRUAL	Signed 18.6	TTR-Tran-Type = 1,21	LP102, LP197
#`TTS-YTD-ACCR-TRAN` YTD_ACCR_TRAN	Signed 18.6	TTR-Tran-Type = 31	LP102, LP197
#`TTS-YTD-LSTACCROL` YTD_LSTACCROL	Signed 18.6	TTR-Tran-Type = 42	LP102, LP197
#`TTS-END-ACCR-BAL` END_ACCR_BAL	Signed 18.6	—	LP102, LP197
#`TTS-BEG-ALLOT-BAL` BEG_ALLOT_BAL	Signed 18.6	TTR-Balance-Type = 2	LP102, LP197
#`TTS-YTD-ALLOT` YTD_ALLOT	Signed 18.6	TTR-Tran-Type = 2,22,51,52	LP102, LP197
#`TTS-YTD-ALLOT-TRAN` YTD_ALLOT_TRAN	Signed 18.6	TTR-Tran-Type = 32	LP102, LP197
#`TTS-YTD-LSTALLOTOL` YTD_LSTALLOTOL	Signed 18.6	TTR-Tran-Type = 43	LP102, LP197
#`TTS-END-ALLOT-BAL` END_ALLOT_BAL	Signed 18.6	—	LP102, LP197
#`TTS-BEG-AVAIL-BAL` BEG_AVAIL_BAL	Signed 18.6	TTR-Balance-Type = 3	LP102, LP197
#`TTS-YTD-ADJ-AVAIL` YTD_ADJ_AVAIL	Signed 18.6	TTR-Tran-Type = 3	LP102, LP197
#`TTS-YTD-AVL-ACCR` YTD_AVL_ACCR	Signed 18.6	TTR-Tran-Type = 33	LP102, LP197
#`TTS-YTD-AVL-ALLOT` YTD_AVL_ALLOT	Signed 18.6	TTR-Tran-Type = 34	LP102, LP197
#`TTS-YTD-PURC-AVL` YTD_PURC_AVL	Signed 18.6	TTR-Tran-Type = 12	LP102, LP197
#`TTS-YTD-SELL-AVL` YTD_SELL_AVL	Signed 18.6	TTR-Tran-Type = 11	LP102, LP197
#`TTS-YTD-LSTAVLCL` YTD_LSTAVLCL	Signed 18.6	TTR-Tran-Type = 44	LP102, LP197
#`TTS-YTD-LSTAVLCP` YTD_LSTAVLCP	Signed 18.6	TTR-Tran-Type = 45	LP102, LP197
#`TTS-YTD-USE-AVAIL` YTD_USE_AVAIL	Signed 18.6	TTR-Tran-Type = 61	LP102, LP197, PR80.2
#`TTS-END-AVAIL-BAL` END_AVAIL_BAL	Signed 18.6	—	LP102, LP197
#`TTS-BEG-RESV-BAL` BEG_RESV_BAL	Signed 18.6	TTR-Balance-Type = 4	LP102, LP197
#`TTS-YTD-ADJ-RESV` YTD_ADJ_RESV	Signed 18.6	TTR-Tran-Type = 4	LP102, LP197
#`TTS-YTD-USE-RESV` YTD_USE_RESV	Signed 18.6	TTR-Tran-Type = 61	LP102, LP197
#`TTS-END-RESV-BAL` END_RESV_BAL	Signed 18.6	—	LP102, LP197
#`TTS-BEG-CARRY-BAL` BEG_CARRY_BAL	Signed 18.6	TTR-Balance-Type = 5	LP102, LP197
#`TTS-YTD-ADJ-CARRY` YTD_ADJ_CARRY	Signed 18.6	TTR-Tran-Type = 5	LP102, LP197
#`TTS-YTD-USE-CARRY` YTD_USE_CARRY	Signed 18.6	TTR-Tran-Type = 61	LP102, LP197
#`TTS-YTD-LSTCARRYCL` YTD_LSTCARRYCL	Signed 18.6	TTR-Tran-Type = 46	LP102, LP197
#`TTS-END-CARRY-BAL` END_CARRY_BAL	Signed 18.6	—	LP102, LP197
#`TTS-ADJ-ACCRUE` ADJ_ACCRUE	Derived	—	—
#`TTS-ADJ-ALLOT` ADJ_ALLOT	Derived	—	—
#`TTS-ADJ-AVAIL` ADJ_AVAIL	Derived	—	—
#`TTS-LOST-AVAIL` LOST_AVAIL	Derived	—	—

Indexes (3)

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.

Index	Keys	Flags	Used in
`TTSSET1`	`COMPANY` `EMPLOYEE` `PLAN` `EMPLOYEE-GROUP` `POSITION` `TA-TYPE` `RESET-DATE`	Primary	LP102, LP140, LP180, LP197, LP264, LP331, PR160, PR180 +1 more
`TTSSET2`	`COMPANY` `EMPLOYEE` `PLAN` `EMPLOYEE-GROUP` `POSITION` `TA-TYPE` `RESET-DATE` ↓		LP102, LP197, LP64.2
`TTSSET3`	`COMPANY` `HM-PROC-LEVEL` `EMPLOYEE` `PLAN` `EMPLOYEE-GROUP` `POSITION` `TA-TYPE` `RESET-DATE`		LP102, LP197

Relations

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

One to one (8) — lookups and parents

Relation Table Rules Condition Field map

Company

PRSYSTEM

Required

`TTS-COMPANY`	→	`PRS-COMPANY`
`Spaces`	→	`PRS-PROCESS-LEVEL`

Currency Code

CUCODES

Required

When TTS-CURRENCY-CODE != Spaces

TTS-CURRENCY-CODE → CUC-CURRENCY-CODE

Employee

EMPLOYEE

Required

`TTS-COMPANY`	→	`EMP-COMPANY`
`TTS-EMPLOYEE`	→	`EMP-EMPLOYEE`

Employee Group

PERSGROUP

Required

`TTS-COMPANY`	→	`PRG-COMPANY`
`TTS-EMPLOYEE-GROUP`	→	`PRG-GROUP-NAME`

Employeemaster

TAEEMASTER

Required

`TTS-COMPANY`	→	`TEM-COMPANY`
`TTS-EMPLOYEE`	→	`TEM-EMPLOYEE`
`TTS-PLAN`	→	`TEM-PLAN`
`TTS-EMPLOYEE-GROUP`	→	`TEM-EMPLOYEE-GROUP`
`TTS-POSITION`	→	`TEM-POSITION`

Hm Proc Level

PRSYSTEM

Required

When TTS-HM-PROC-LEVEL != Spaces

`TTS-COMPANY`	→	`PRS-COMPANY`
`TTS-HM-PROC-LEVEL`	→	`PRS-PROCESS-LEVEL`

Paemployee

PAEMPLOYEE

Required

`TTS-COMPANY`	→	`PEM-COMPANY`
`TTS-EMPLOYEE`	→	`PEM-EMPLOYEE`

Plan

TAPLAN

Required

`TTS-COMPANY`	→	`TAP-COMPANY`
`TTS-PLAN`	→	`TAP-PLAN`

One to many (3) — child tables

Relation Table Rules Condition Field map

Position

PAPOSITION

Valid When TTS-POSITION != Spaces

`TTS-COMPANY`	→	`POS-COMPANY`
`TTS-POSITION`	→	`POS-POSITION`
—	→	`POS-EFFECT-DATE`

Ta Trans

TAEMPTRANS

Delete Cascades

`TTS-COMPANY`	→	`TTR-COMPANY`
`TTS-EMPLOYEE`	→	`TTR-EMPLOYEE`
`TTS-PLAN`	→	`TTR-PLAN`
`TTS-EMPLOYEE-GROUP`	→	`TTR-EMPLOYEE-GROUP`
`TTS-POSITION`	→	`TTR-POSITION`
`TTS-TA-TYPE`	→	`TTR-TA-TYPE`
`TTS-RESET-DATE`	→	`TTR-RESET-DATE`
—	→	`TTR-DATE`
—	→	`TTR-SEQ-NBR`

Tastructur

TASTRUCTUR

`TTS-COMPANY`	→	`TST-COMPANY`
`TTS-EMPLOYEE-GROUP`	→	`TST-EMPLOYEE-GROUP`
`TTS-PLAN`	→	`TST-PLAN`
—	→	`TST-BEGIN-DATE`

Programs

Updated by (8)

LP102 Employee Master Update
LP140 Employee Absence Plan Calculation
LP197 Absence Plan Close
LP264 Employee Transaction History Report
LP331 Employee Absence Plan Purge
PR160 Payment Print
PR180 Manual Payment Print
PR80.2 Manual Payment Print

Referenced by (2)

LP180 Mass Absence Plan Transfer
LP64.2 Employee Transaction Summary Inquiry

TATRANSUM – No description in the Lawson data dictionary

About TATRANSUM

Fields (45) Copy as SQL

Indexes (3)

Relations

One to one (8) — lookups and parents

One to many (3) — child tables

Programs

Updated by (8)

Referenced by (2)

Fields (45)