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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
TSR-COMPANY PKCOMPANY | Numeric 4 | — | LP03.1 |
TSR-SERVICE-RULE PKSERVICE_RULE | Alpha 10 | — | LP03.1 |
TSR-DESCRIPTIONDESCRIPTION | Alpha 30 (Lower Case) | — | LP03.1 |
TSR-SRV-DT-CDSRV_DT_CD | Numeric 2 | —
| LP03.1 |
TSR-SRV-USER-DTSRV_USER_DT | Alpha 2 | — | LP03.1 |
TSR-WAIT-STARTWAIT_START | Numeric 2 | —
| LP03.1 |
TSR-WAIT-PERIODWAIT_PERIOD | Numeric 5 | — | LP03.1 |
TSR-WAIT-UNITWAIT_UNIT | Numeric 2 | —
| LP03.1 |
TSR-WAIT-SRV-CLSWAIT_SRV_CLS | Alpha 3 | — | LP03.1 |
TSR-HOURS-TYPEHOURS_TYPE | Numeric 2 | Contains the units of measure for the summarized totals.
| LP03.1 |
TSR-SRV-DT-FLAGSRV_DT_FLAG | Numeric 1 | —
| LP03.1 |
TSR-NEAREST-POINTNEAREST_POINT | Numeric 1 | —
| LP03.1 |
TSR-SRV-POINTSRV_POINT | Numeric 4 (mmdd) Occurs 13 Times ×13 | — | LP03.1 |
TSR-DATE-STAMPDATE_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-STAMPTIME_STAMP | Numeric 6 (hhmmss) | Contains the server time (hour, minute, and second) when the record was last changed. | LP03.1 |
TSR-USER-IDUSER_ID | Alpha 10 (Lower Case) | — | LP03.1 |
TSR-SRV-DATESRV_DATE | Numeric 8 (yyyymmdd) | — | LP03.1 |
TSR-PAY-CYCLE-ADJPAY_CYCLE_ADJ | Numeric 1 | —
| LP03.1 |
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 |
|---|---|---|---|---|
TSRSET1 | COMPANY, SERVICE-RULE | Primary | HR04.4, HR04.5, HR04.6, LP02.1, LP03.1, LP08.1, LP102, LP140 +2 more |
Relations
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 |