TALIMIT – Absence Plan Limit Rule
- System
- Absence Management (LP)
- Prefix
TLM- Primary key
COMPANY,LIMIT-RULE- Fields
- 29
- Updated by
- 11 programs
- Referenced by
- 22 programs
TALIMIT is the Absence Plan Limit Rule table in Lawson Absence Management (prefix TLM). It is indexed by COMPANY, LIMIT-RULE (TLMSET1). It is related 1:1 to PRSYSTEM and 1:M to TATABLE. It is updated by HR00.1, HR01.1, LP03.4, LP04.2, LP04.3, LP04.4, LP04.5, LP04.6 and 3 more and referenced by HR11.1, HR511, LP02.1, LP100, LP101, LP102, LP103, LP131 and 14 more. The table has 29 fields, 1 index and 17 documented relations.
About TALIMIT
Limit Rules define maximums for ongoing balance, annual accrual and carryover amounts. Limit Rules also define when accrual totals are reset, and if the carryover amount is available for a limited period of time (carryover period). A plan structure must have an annual reset point or date to determine when totals are reset, but maximums are optional. The ongoing balance limit has an additional option to check maximums by plan category (balance limit type).
Fields (29)
Column = COBOL field name without the TLM- 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 |
|---|---|---|---|
#TLM-COMPANY PKCOMPANY | Numeric 4 | — | LP03.4 |
#TLM-LIMIT-RULE PKLIMIT_RULE | Alpha 10 | — | LP03.4 |
#TLM-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | — | LP03.4 |
#TLM-RESET-DT-CDRESET_DT_CD | Numeric 2 | —
| LP03.4 |
#TLM-RESET-POINTRESET_POINT | Numeric 4 (mmdd) | — | LP03.4 |
#TLM-BAL-HRS-TBLBAL_HRS_TBL | Alpha 10 | — | LP03.4 |
#TLM-BAL-ERN-TBLBAL_ERN_TBL | Alpha 10 | — | LP03.4 |
#TLM-BAL-LIMIT-TYPEBAL_LIMIT_TYPE | Numeric 2 | Contains the units of measure for the summarized totals.
| LP03.4 |
#TLM-BAL-BYPASS-FLGBAL_BYPASS_FLG | Numeric 1 | —
| LP03.4 |
#TLM-ACRLIM-HRS-TBLACRLIM_HRS_TBL | Alpha 10 | — | LP03.4 |
#TLM-ACRLIM-ERN-TBLACRLIM_ERN_TBL | Alpha 10 | — | LP03.4 |
#TLM-ACR-LIMIT-TYPEACR_LIMIT_TYPE | Numeric 2 | Contains the units of measure for the summarized totals.
| LP03.4 |
#TLM-CARRY-HRS-TBLCARRY_HRS_TBL | Alpha 10 | — | LP03.4 |
#TLM-CARRY-ERN-TBLCARRY_ERN_TBL | Alpha 10 | — | LP03.4 |
#TLM-CARRY-PERIODCARRY_PERIOD | Numeric 4 | — | LP03.4 |
#TLM-CARRYOVER-UNITCARRYOVER_UNIT | Numeric 2 | —
| LP03.4 |
#TLM-RSV-HRS-TBLRSV_HRS_TBL | Alpha 10 | — | — |
#TLM-RSV-ERN-TBLRSV_ERN_TBL | Alpha 10 | — | — |
#TLM-PAYOUT-HRS-TBLPAYOUT_HRS_TBL | Alpha 10 | — | — |
#TLM-PAYOUT-ERN-TBLPAYOUT_ERN_TBL | Alpha 10 | — | — |
#TLM-DON-HRS-TBLDON_HRS_TBL | Alpha 10 | — | — |
#TLM-DON-ERN-TBLDON_ERN_TBL | Alpha 10 | — | — |
#TLM-PURCH-HRS-TBLPURCH_HRS_TBL | Alpha 10 | — | — |
#TLM-PURCH-ERN-TBLPURCH_ERN_TBL | Alpha 10 | — | — |
#TLM-GIFT-HRS-TBLGIFT_HRS_TBL | Alpha 10 | — | — |
#TLM-GIFT-ERN-TBLGIFT_ERN_TBL | Alpha 10 | — | — |
#TLM-DATE-STAMPDATE_STAMP | Numeric 8 (yyyymmdd) | This field contains the server date (month, date, and year) of the last change to this record. | LP03.4 |
#TLM-TIME-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | LP03.4 |
#TLM-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | LP03.4 |
Indexes (1)
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 |
|---|---|---|---|---|
TLMSET1 |
| Primary | HR00.1, HR01.1, HR11.1, HR511, LT101, LT111, LP02.1, LP03.4 +22 more (list truncated in source) |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Company | PRSYSTEM | Required |
|
One to many (16) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Acrlim Ern Tbl | TATABLE | Valid When TLM-ACRLIM-ERN-TBL != Spaces |
| ||||||||||
| Acrlim Hrs Tbl | TATABLE | Valid When TLM-ACRLIM-HRS-TBL != Spaces |
| ||||||||||
| Bal Ern Tbl | TATABLE | Valid When TLM-BAL-ERN-TBL != Spaces |
| ||||||||||
| Bal Hrs Tbl | TATABLE | Valid When TLM-BAL-HRS-TBL != Spaces |
| ||||||||||
| Carry Ern Tbl | TATABLE | Valid When TLM-CARRY-ERN-TBL != Spaces |
| ||||||||||
| Carry Hrs Tbl | TATABLE | Valid When TLM-CARRY-HRS-TBL != Spaces |
| ||||||||||
| Don Ern Tbl | TATABLE | Valid When TLM-DON-ERN-TBL != Spaces |
| ||||||||||
| Don Hrs Tbl | TATABLE | Valid When TLM-DON-HRS-TBL != Spaces |
| ||||||||||
| Gift Ern Tbl | TATABLE | Valid When TLM-GIFT-ERN-TBL != Spaces |
| ||||||||||
| Gift Hrs Tbl | TATABLE | Valid When TLM-GIFT-HRS-TBL != Spaces |
| ||||||||||
| Payout Ern Tbl | TATABLE | Valid When TLM-PAYOUT-ERN-TBL != Spaces |
| ||||||||||
| Payout Hrs Tbl | TATABLE | Valid When TLM-PAYOUT-HRS-TBL != Spaces |
| ||||||||||
| Purch Ern Tbl | TATABLE | Valid When TLM-PURCH-ERN-TBL != Spaces |
| ||||||||||
| Purch Hrs Tbl | TATABLE | Valid When TLM-PURCH-HRS-TBL != Spaces |
| ||||||||||
| Rsv Ern Tbl | TATABLE | Valid When TLM-RSV-ERN-TBL != Spaces |
| ||||||||||
| Rsv Hrs Tbl | TATABLE | Valid When TLM-RSV-HRS-TBL != Spaces |
|
Programs
Updated by (11)
- HR00.1 Company
- HR01.1 Process Level
- LP03.4 Limit Rule
- 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
Referenced by (22)
- HR11.1 Employee
- HR511 Employee Conversion
- LP02.1 Plan Structure
- 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
- LP201 Absence Plan Listing
- LP203 Absence Plan Rules 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