TASERVRULE – Absence Plan Service Rule

System: Absence Management (LP)
Prefix: TSR
Primary key: COMPANY, SERVICE-RULE
Fields: 18
Updated by: 2 programs
Referenced by: 8 programs

TASERVRULE is the Absence Plan Service Rule table in Lawson Absence Management (prefix TSR). It is indexed by COMPANY, SERVICE-RULE (TSRSET1). It is related 1:1 to PRSYSTEM, HRUSERFLDS and TASERVCLSS. It is updated by LP03.1 and LP08.1 and referenced by HR04.4, HR04.5, HR04.6, LP02.1, LP102, LP140, LP201 and LP203. The table has 18 fields, 1 index and 3 documented relations.

About TASERVRULE

No description in the Lawson data dictionary.

Fields (18)

Column = COBOL field name without the TSR- 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
#`TSR-COMPANY` PK COMPANY	Numeric 4	—	LP03.1
#`TSR-SERVICE-RULE` PK SERVICE_RULE	Alpha 10	—	LP03.1
#`TSR-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	—	LP03.1
#`TSR-SRV-DT-CD` SRV_DT_CD	Numeric 2	— `01` Hire Date `02` Adjusted Hire Date `03` Anniversary Date `04` Seniority Date `05` First Day Worked `06` Birthdate `11` Benefit Date 1 `12` Benefit Date 2 `13` Benefit Date 3 `14` Benefit Date 4 `15` Benefit Date 5 `31` Plan Entry Date	LP03.1
#`TSR-SRV-USER-DT` SRV_USER_DT	Alpha 2	—	LP03.1
#`TSR-WAIT-START` WAIT_START	Numeric 2	— `01` Hire Date `02` Adjusted Hire Date `03` Plan Entry Date `04` Service Requirement Date	LP03.1
#`TSR-WAIT-PERIOD` WAIT_PERIOD	Numeric 5	—	LP03.1
#`TSR-WAIT-UNIT` WAIT_UNIT	Numeric 2	— `01` Hours `02` Days `03` Weeks `04` Semi months `05` Months	LP03.1
#`TSR-WAIT-SRV-CLS` WAIT_SRV_CLS	Alpha 3	—	LP03.1
#`TSR-HOURS-TYPE` HOURS_TYPE	Numeric 2	Contains the units of measure for the summarized totals. `01` Plan `02` Plan; employee group `03` Plan; emp grp; position `04` All hours	LP03.1
#`TSR-SRV-DT-FLAG` SRV_DT_FLAG	Numeric 1	— `1` Earliest date met `2` Latest date met	LP03.1
#`TSR-NEAREST-POINT` NEAREST_POINT	Numeric 1	— `1` After requirements are met `2` Before requirements are met	LP03.1
#`TSR-SRV-POINT` SRV_POINT	Numeric 4 (mmdd) Occurs 13 Times ×13	—	LP03.1
#`TSR-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.1
#`TSR-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	LP03.1
#`TSR-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	LP03.1
#`TSR-SRV-DATE` SRV_DATE	Numeric 8 (yyyymmdd)	—	LP03.1
#`TSR-PAY-CYCLE-ADJ` PAY_CYCLE_ADJ	Numeric 1	— `0` No `1` Yes	LP03.1

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
`TSRSET1`	`COMPANY` `SERVICE-RULE`	Primary		HR04.4, HR04.5, HR04.6, LP02.1, LP03.1, LP08.1, LP102, LP140 +2 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)

One to one (3) — lookups and parents

Relation Table Rules Condition Field map

Company

PRSYSTEM

Required

`TSR-COMPANY`	→	`PRS-COMPANY`
`Spaces`	→	`PRS-PROCESS-LEVEL`

Srv User Dt

HRUSERFLDS

Required

When (TSR-SRV-USER-DT != Spaces)

TSR-SRV-USER-DT → HRU-FIELD-KEY

Wait Srv Cls

TASERVCLSS

Required

When (TSR-WAIT-SRV-CLS != Spaces)

`TSR-COMPANY`	→	`TSL-COMPANY`
`TSR-WAIT-SRV-CLS`	→	`TSL-SERVICE-CLASS`

Programs

Updated by (2)

LP03.1 Service Rule
LP08.1 Service Class

Referenced by (8)

HR04.4 Alphanumeric User Fields
HR04.5 Numeric User Fields
HR04.6 Date User Fields
LP02.1 Plan Structure
LP102 Employee Master Update
LP140 Employee Absence Plan Calculation
LP201 Absence Plan Listing
LP203 Absence Plan Rules Listing

TASERVRULE – Absence Plan Service Rule

About TASERVRULE

Fields (18) Copy as SQL

Indexes (1)

Relations

One to one (3) — lookups and parents

Programs

Updated by (2)

Referenced by (8)

Fields (18)