TATABLE – No description in the Lawson data dictionary

System: Absence Management (LP)
Prefix: TBL
Primary key: COMPANY, TABLE, EFFECTIVE-DATE
Fields: 14
Updated by: 11 programs
Referenced by: 31 programs

TATABLE is a Lawson Absence Management table (prefix TBL); no description in the lawson data dictionary. It is indexed by COMPANY, TABLE, EFFECTIVE-DATE (TBLSET1); alternate indexes: TBLSET2, TBLSET3 and TBLSET4. It is related 1:1 to PRSYSTEM and TASERVCLSS and 1:M to TATABLEX. It is updated by HR00.1, HR01.1, LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7 and 3 more and referenced by HR11.1, HR511, LP02.1, LP03.1, LP03.2, LP03.3, LP03.4, LP03.5 and 23 more. The table has 14 fields, 4 indexes and 3 documented relations.

About TATABLE

No description in the Lawson data dictionary.

Fields (14)

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

Field / column	Type	Description & values	Updated by
`TBL-COMPANY` PK COMPANY	Numeric 4	—	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBL-TABLE` PK TABLE	Alpha 10	—	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBL-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	—	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBL-EFFECTIVE-DATE` PK EFFECTIVE_DATE	Numeric 8 (yyyymmdd)	—	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBL-TABLE-TYPE` TABLE_TYPE	Numeric 2	Contains the units of measure for the summarized totals. `01` Hours `02` Earnings	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBL-TABLE-BASIS` TABLE_BASIS	Numeric 1	— `1` Cycle `2` Hours	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBL-RULE-TYPE` RULE_TYPE	Numeric 2	Contains the units of measure for the summarized totals. `01` Accrual `02` Allotment `03` Limit `04` GL	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBL-CYCLE-FREQ` CYCLE_FREQ	Numeric 2	— `01` Weekly `02` Biweekly `03` Semimonthly `04` Four weekly `05` Monthly `06` Bimonthly `07` Quarterly `08` Four monthly `09` Semiannually `10` Annually	LP04.2, LP04.3, LP04.4, LP04.5
`TBL-CYCLE-SRV-TYPE` CYCLE_SRV_TYPE	Numeric 2	Contains the units of measure for the summarized totals. `01` Plan `02` Plan; employee group `03` Plan; emp grp; position	LP04.2, LP04.3, LP04.4, LP04.5
`TBL-HOURS-SRV-CLS` HOURS_SRV_CLS	Alpha 3	—	LP04.6, LP04.7, LP04.8, LP04.9
`TBL-HOURS-SRV-TYPE` HOURS_SRV_TYPE	Numeric 2	Contains the units of measure for the summarized totals. `01` LTD plan `02` LTD plan; employee group `03` LTD plan; emp grp; position `04` All LTD `11` YTD plan `12` YTD plan; employee group `13` YTD plan; emp grp; position `14` All YTD `21` PYT plan `22` PYT plan; employee group `23` PYT plan; emp grp; position `24` All PYT	LP04.6, LP04.7, LP04.8, LP04.9
`TBL-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBL-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBL-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9

Indexes (4)

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
`TBLSET1`	`COMPANY`, `TABLE`, `EFFECTIVE-DATE*`	Primary		HR00.1, HR01.1, HR11.1, HR511, LT101, LT111, LP02.1, LP03.1 +22 more (list truncated in source)
`TBLSET2`	`COMPANY`, `TABLE-TYPE`, `TABLE`, `EFFECTIVE-DATE*`			LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9
`TBLSET3`	`COMPANY`, `TABLE-BASIS`, `TABLE`, `EFFECTIVE-DATE*`	Subset	Where (TABLE-BASIS = 1)	LP04.2, LP04.3, LP04.4, LP04.5
`TBLSET4`	`COMPANY`, `TABLE-BASIS`, `TABLE`, `EFFECTIVE-DATE*`	Subset	Where (TABLE-BASIS = 2)	LP04.6, LP04.7, LP04.8, LP04.9, LP188

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`TBL-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Hours Srv Cls	TASERVCLSS	Required	When (TBL-HOURS-SRV-CLS != Spaces)	`TBL-COMPANY` → `TSL-COMPANY`, `TBL-HOURS-SRV-CLS` → `TSL-SERVICE-CLASS`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Tatablex	TATABLEX	Delete Cascades		`TBL-COMPANY` → `TBX-COMPANY`, `TBL-TABLE` → `TBX-TABLE`, `TBL-EFFECTIVE-DATE` → `TBX-EFFECTIVE-DATE`, → `TBX-FROM`

Programs

Updated by (11)

HR00.1 Company
HR01.1 Process Level
LP04.2 Cycle Based Accrual Table
LP04.3 Cycle Based Allotment Table
LP04.4 Cycle Based Limit Table
LP04.5 Cycle Based GL Liability Table
LP04.6 Hours Based Accrual Table
LP04.7 Hours Based Allotment Table
LP04.8 Hours Based Limit Table
LP04.9 Hours Based GL Liability Table
LP08.1 Service Class

Referenced by (31)

HR11.1 Employee
HR511 Employee Conversion
LP02.1 Plan Structure
LP03.1 Service Rule
LP03.2 Accrual Rule
LP03.3 Eligibility Rule
LP03.4 Limit Rule
LP03.5 Payroll Rule
LP03.6 General Ledger Rule
LP07.1 Calculation
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LP102 Employee Master Update
LP103 Mass Absence Plan Termination
LP131 Zero Balance Update
LP140 Employee Absence Plan Calculation
LP145 Allotment Adjustment Calculation
LP151 FMLA Rolling 12 Month Update
LP180 Mass Absence Plan Transfer
LP188 Length of Service Hours Update
LP197 Absence Plan Close
LP198 General Ledger Liability Update
LP201 Absence Plan Listing
LP203 Absence Plan Rules Listing
LP204 Rules Tables Listing
LP31.1 Employee Absence Plan Master
LP80.1 Employee Absence Plan Transfer
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA100 Action Update
PA52.4 Hire an Applicant