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 / columnTypeDescription & valuesUpdated by
TSR-COMPANY PK
COMPANY
Numeric 4LP03.1
TSR-SERVICE-RULE PK
SERVICE_RULE
Alpha 10LP03.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 2LP03.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 5LP03.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 3LP03.1
TSR-HOURS-TYPE
HOURS_TYPE
Numeric 2Contains 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 ×13LP03.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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TSRSET1COMPANY, SERVICE-RULEPrimaryHR04.4, HR04.5, HR04.6, LP02.1, LP03.1, LP08.1, LP102, LP140 +2 more

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredTSR-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL
Srv User DtHRUSERFLDSRequiredWhen (TSR-SRV-USER-DT != Spaces)TSR-SRV-USER-DTHRU-FIELD-KEY
Wait Srv ClsTASERVCLSSRequiredWhen (TSR-WAIT-SRV-CLS != Spaces)TSR-COMPANYTSL-COMPANY, TSR-WAIT-SRV-CLSTSL-SERVICE-CLASS

Programs

Updated by (2)

Referenced by (8)