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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#TBL-COMPANY PKCOMPANY | Numeric 4 | — | LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9 |
#TBL-TABLE PKTABLE | Alpha 10 | — | LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9 |
#TBL-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | — | LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9 |
#TBL-EFFECTIVE-DATE PKEFFECTIVE_DATE | Numeric 8 (yyyymmdd) | — | LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9 |
#TBL-TABLE-TYPE SET2TABLE_TYPE | Numeric 2 | Contains the units of measure for the summarized totals.
| LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9 |
#TBL-TABLE-BASIS SET3 SET4TABLE_BASIS | Numeric 1 | —
| LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9 |
#TBL-RULE-TYPERULE_TYPE | Numeric 2 | Contains the units of measure for the summarized totals.
| LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9 |
#TBL-CYCLE-FREQCYCLE_FREQ | Numeric 2 | —
| LP04.2, LP04.3, LP04.4, LP04.5 |
#TBL-CYCLE-SRV-TYPECYCLE_SRV_TYPE | Numeric 2 | Contains the units of measure for the summarized totals.
| LP04.2, LP04.3, LP04.4, LP04.5 |
#TBL-HOURS-SRV-CLSHOURS_SRV_CLS | Alpha 3 | — | LP04.6, LP04.7, LP04.8, LP04.9 |
#TBL-HOURS-SRV-TYPEHOURS_SRV_TYPE | Numeric 2 | Contains the units of measure for the summarized totals.
| LP04.6, LP04.7, LP04.8, LP04.9 |
#TBL-DATE-STAMPDATE_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-STAMPTIME_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-IDUSER_ID | Alpha 10 (Lower Case) | — | LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9 |
Indexes (4)
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 | Condition | Used in |
|---|---|---|---|---|
TBLSET1 |
| Primary | HR00.1, HR01.1, HR11.1, HR511, LT101, LT111, LP02.1, LP03.1 +22 more (list truncated in source) | |
TBLSET2 |
| LP04.2, LP04.3, LP04.4, LP04.5, LP04.6, LP04.7, LP04.8, LP04.9 | ||
TBLSET3 |
| Subset | Where (TABLE-BASIS = 1) | LP04.2, LP04.3, LP04.4, LP04.5 |
TBLSET4 |
| 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 |
| |||||||
| Hours Srv Cls | TASERVCLSS | Required | When (TBL-HOURS-SRV-CLS != Spaces) |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Tatablex | TATABLEX | Delete Cascades |
|
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