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.

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` 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 marked * are descending. 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

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