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.

Field / column	Type	Description & values	Updated by
`TLM-COMPANY` PK COMPANY	Numeric 4	—	LP03.4
`TLM-LIMIT-RULE` PK LIMIT_RULE	Alpha 10	—	LP03.4
`TLM-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	—	LP03.4
`TLM-RESET-DT-CD` RESET_DT_CD	Numeric 2	— `01` Hire Date `02` Adjusted Hire Date `03` Plan Entry Date `04` Service Begin Date `05` Accrual From Date `06` Allotment Start Date `07` Allotment Begin Date `08` Eligibility Begin Date	LP03.4
`TLM-RESET-POINT` RESET_POINT	Numeric 4 (mmdd)	—	LP03.4
`TLM-BAL-HRS-TBL` BAL_HRS_TBL	Alpha 10	—	LP03.4
`TLM-BAL-ERN-TBL` BAL_ERN_TBL	Alpha 10	—	LP03.4
`TLM-BAL-LIMIT-TYPE` BAL_LIMIT_TYPE	Numeric 2	Contains the units of measure for the summarized totals. `01` Plan `02` Plan employee group `03` Plan; emp grp; position `04` Plan category	LP03.4
`TLM-BAL-BYPASS-FLG` BAL_BYPASS_FLG	Numeric 1	— `0` No bypass `1` Bypass hours limit `2` Bypass earnings limit `3` Bypass both limits	LP03.4
`TLM-ACRLIM-HRS-TBL` ACRLIM_HRS_TBL	Alpha 10	—	LP03.4
`TLM-ACRLIM-ERN-TBL` ACRLIM_ERN_TBL	Alpha 10	—	LP03.4
`TLM-ACR-LIMIT-TYPE` ACR_LIMIT_TYPE	Numeric 2	Contains the units of measure for the summarized totals. `01` Plan `02` Plan; employee group `03` Plan; emp group; position `04` Plan category	LP03.4
`TLM-CARRY-HRS-TBL` CARRY_HRS_TBL	Alpha 10	—	LP03.4
`TLM-CARRY-ERN-TBL` CARRY_ERN_TBL	Alpha 10	—	LP03.4
`TLM-CARRY-PERIOD` CARRY_PERIOD	Numeric 4	—	LP03.4
`TLM-CARRYOVER-UNIT` CARRYOVER_UNIT	Numeric 2	— `02` Days `03` Weeks `04` Semi months `05` Months	LP03.4
`TLM-RSV-HRS-TBL` RSV_HRS_TBL	Alpha 10	—	—
`TLM-RSV-ERN-TBL` RSV_ERN_TBL	Alpha 10	—	—
`TLM-PAYOUT-HRS-TBL` PAYOUT_HRS_TBL	Alpha 10	—	—
`TLM-PAYOUT-ERN-TBL` PAYOUT_ERN_TBL	Alpha 10	—	—
`TLM-DON-HRS-TBL` DON_HRS_TBL	Alpha 10	—	—
`TLM-DON-ERN-TBL` DON_ERN_TBL	Alpha 10	—	—
`TLM-PURCH-HRS-TBL` PURCH_HRS_TBL	Alpha 10	—	—
`TLM-PURCH-ERN-TBL` PURCH_ERN_TBL	Alpha 10	—	—
`TLM-GIFT-HRS-TBL` GIFT_HRS_TBL	Alpha 10	—	—
`TLM-GIFT-ERN-TBL` GIFT_ERN_TBL	Alpha 10	—	—
`TLM-DATE-STAMP` DATE_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-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LP03.4
`TLM-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LP03.4

Indexes (1)

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
`TLMSET1`	`COMPANY`, `LIMIT-RULE`	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		`TLM-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`

One to many (16) — child tables

Relation	Table	Condition	Field map
Acrlim Ern Tbl	TATABLE	Valid When TLM-ACRLIM-ERN-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-ACRLIM-ERN-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Acrlim Hrs Tbl	TATABLE	Valid When TLM-ACRLIM-HRS-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-ACRLIM-HRS-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Bal Ern Tbl	TATABLE	Valid When TLM-BAL-ERN-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-BAL-ERN-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Bal Hrs Tbl	TATABLE	Valid When TLM-BAL-HRS-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-BAL-HRS-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Carry Ern Tbl	TATABLE	Valid When TLM-CARRY-ERN-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-CARRY-ERN-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Carry Hrs Tbl	TATABLE	Valid When TLM-CARRY-HRS-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-CARRY-HRS-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Don Ern Tbl	TATABLE	Valid When TLM-DON-ERN-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-DON-ERN-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Don Hrs Tbl	TATABLE	Valid When TLM-DON-HRS-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-DON-HRS-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Gift Ern Tbl	TATABLE	Valid When TLM-GIFT-ERN-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-GIFT-ERN-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Gift Hrs Tbl	TATABLE	Valid When TLM-GIFT-HRS-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-GIFT-HRS-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Payout Ern Tbl	TATABLE	Valid When TLM-PAYOUT-ERN-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-PAYOUT-ERN-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Payout Hrs Tbl	TATABLE	Valid When TLM-PAYOUT-HRS-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-PAYOUT-HRS-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Purch Ern Tbl	TATABLE	Valid When TLM-PURCH-ERN-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-PURCH-ERN-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Purch Hrs Tbl	TATABLE	Valid When TLM-PURCH-HRS-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-PURCH-HRS-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Rsv Ern Tbl	TATABLE	Valid When TLM-RSV-ERN-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-RSV-ERN-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`
Rsv Hrs Tbl	TATABLE	Valid When TLM-RSV-HRS-TBL != Spaces	`TLM-COMPANY` → `TBL-COMPANY`, `TLM-RSV-HRS-TBL` → `TBL-TABLE`, → `TBL-EFFECTIVE-DATE`

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