TAELIGIBLE – Absence Plan Eligibility Rule

System
Absence Management (LP)
Prefix
TEG
Primary key
COMPANY, ELIGIBLE-RULE
Fields
18
Updated by
4 programs
Referenced by
8 programs

TAELIGIBLE is the Absence Plan Eligibility Rule table in Lawson Absence Management (prefix TEG). It is indexed by COMPANY, ELIGIBLE-RULE (TEGSET1). It is related 1:1 to PRSYSTEM, HRUSERFLDS and TASERVCLSS. It is updated by HR00.1, HR01.1, LP03.3 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 TAELIGIBLE

Eligibility Rules define when accruals and/or allotments become eligible for use.

Fields (18)

Column = COBOL field name without the TEG- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
TEG-COMPANY PK
COMPANY		Numeric 4—LP03.3
TEG-ELIGIBLE-RULE PK
ELIGIBLE_RULE		Alpha 10—LP03.3
TEG-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)—LP03.3
TEG-ELIG-DT-CD
ELIG_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
  • 32 Service Begin Date
  • 33 Accrual From Date
  • 34 Accrual Start Date
  • 35 Allotment Begin Date
LP03.3
TEG-ELIG-USER-DT
ELIG_USER_DT		Alpha 2—LP03.3
TEG-WAIT-START
WAIT_START		Numeric 2—
  • 01 Hire Date
  • 02 Adjusted Hire Date
  • 03 Plan Entry Date
  • 04 Service Begin Date
  • 05 Accrual From Date
  • 06 Accrual Start Date
  • 07 Allotment Begin Date
  • 08 Eligibility Requirement Date
LP03.3
TEG-WAIT-PERIOD
WAIT_PERIOD		Numeric 5—LP03.3
TEG-WAIT-UNIT
WAIT_UNIT		Numeric 2—
  • 01 Hours
  • 02 Days
  • 03 Weeks
  • 04 Semi months
  • 05 Months
LP03.3
TEG-WAIT-SRV-CLS
WAIT_SRV_CLS		Alpha 3—LP03.3
TEG-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.3
TEG-ELIG-DT-FLAG
ELIG_DT_FLAG		Numeric 1—
  • 1 Earliest date met
  • 2 Latest date met
LP03.3
TEG-NEAREST-POINT
NEAREST_POINT		Numeric 1—
  • 1 After requirements are met
  • 2 Before requirements are met
LP03.3
TEG-ELIG-POINT
ELIG_POINT		Numeric 4 (mmdd) Occurs 13 Times ×13—LP03.3
TEG-PAY-CYCLE-ADJ
PAY_CYCLE_ADJ		Numeric 1—
  • 0 No
  • 1 Yes
LP03.3
TEG-ELIG-OCCUR
ELIG_OCCUR		Numeric 2—
  • 01 Weekly
  • 02 Biweekly
  • 03 Semimonthly
  • 04 Four weekly
  • 05 Monthly
  • 06 Bimonthy
  • 07 Quarterly
  • 08 Four monthly
  • 09 Semiannually
  • 10 Annually
  • 99 As accrued
  • 00 None
LP03.3
TEG-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.3
TEG-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.LP03.3
TEG-USER-ID
USER_ID		Alpha 10 (Lower Case)—LP03.3

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TEGSET1COMPANY, ELIGIBLE-RULEPrimaryHR00.1, HR01.1, HR04.4, HR04.5, HR04.6, LP02.1, LP03.3, LP08.1 +4 more

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredTEG-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Elig User DtHRUSERFLDSRequiredWhen (TEG-ELIG-USER-DT != Spaces)TEG-ELIG-USER-DT → HRU-FIELD-KEY
Wait Srv ClsTASERVCLSSRequiredWhen (TEG-WAIT-SRV-CLS != Spaces)TEG-COMPANY → TSL-COMPANY, TEG-WAIT-SRV-CLS → TSL-SERVICE-CLASS

Programs

Updated by (4)

Referenced by (8)