TAACCRUAL – Absence Plan Accrual Rule

System
Absence Management (LP)
Prefix
TAR
Primary key
COMPANY, ACCRUAL-RULE
Fields
47
Updated by
12 programs
Referenced by
28 programs

TAACCRUAL is the Absence Plan Accrual Rule table in Lawson Absence Management (prefix TAR). It is indexed by COMPANY, ACCRUAL-RULE (TARSET1). It is related 1:1 to HRUSERFLDS, TASERVCLSS and PRSYSTEM and 1:M to TATABLE. It is updated by HR00.1, HR01.1, LP03.2, LP04.2, LP04.3, LP04.4, LP04.5, LP04.6 and 4 more and referenced by HR04.4, HR04.5, HR04.6, HR11.1, HR511, LP02.1, LP100, LP101 and 20 more. The table has 47 fields, 1 index and 9 documented relations.

About TAACCRUAL

Accrual Rules define the accrual and allotment rules for each employee accrual record. "Accruals" are calculated over time, whereas "allotments" are calculated up front, and may or may not be adjusted over time.

Fields (47)

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

Field / columnTypeDescription & valuesUpdated by
TAR-COMPANY PK
COMPANY
Numeric 4LP03.2
TAR-ACCRUAL-RULE PK
ACCRUAL_RULE
Alpha 10LP03.2
TAR-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)LP03.2
TAR-ACCR-DT-CD
ACCR_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
LP03.2
TAR-ACCR-USER-DT
ACCR_USER_DT
Alpha 2LP03.2
TAR-ACCR-WAIT-STRT
ACCR_WAIT_STRT
Numeric 2
  • 01 Hire Date
  • 02 Adjusted Hire Date
  • 03 Plan Entry Date
  • 04 Service Begin Date
  • 05 Accrual Requirement Date
LP03.2
TAR-ACCR-WAIT-PER
ACCR_WAIT_PER
Numeric 5LP03.2
TAR-ACCR-WAIT-UNIT
ACCR_WAIT_UNIT
Numeric 2
  • 01 Hours
  • 02 Days
  • 03 Weeks
  • 04 Semi months
  • 05 Months
LP03.2
TAR-ACCR-W-SRV-CLS
ACCR_W_SRV_CLS
Alpha 3LP03.2
TAR-ACCR-W-HRS-TYP
ACCR_W_HRS_TYP
Numeric 2Contains the units of measure for the summarized totals.
  • 01 Plan
  • 02 Plan; employee group
  • 03 Plan; emp group; position
  • 04 All hours
LP03.2
TAR-ACCR-DT-FLAG
ACCR_DT_FLAG
Numeric 1
  • 1 Earliest date met
  • 2 Latest date met
LP03.2
TAR-ACCR-NEAR-PT
ACCR_NEAR_PT
Numeric 1
  • 1 After requirements are met
  • 2 Before requirements are met
LP03.2
TAR-ACCR-W-POINT
ACCR_W_POINT
Numeric 4 (mmdd) Occurs 13 Times ×13LP03.2
TAR-PAY-CYCLE-ADJ
PAY_CYCLE_ADJ
Numeric 1
  • 0 No
  • 1 Yes
LP03.2
TAR-ACCR-BEGIN-OPT
ACCR_BEGIN_OPT
Numeric 1
  • 1 Accrual Start Date
  • 2 Accrual Requirement Date
LP03.2
TAR-ACCR-PARTIAL
ACCR_PARTIAL
Numeric 1
  • 01 No
  • 12 Yes
TAR-ACCR-HRS-TBL
ACCR_HRS_TBL
Alpha 10LP03.2
TAR-ACCR-ERN-TBL
ACCR_ERN_TBL
Alpha 10LP03.2
TAR-ALLOT-DT-CD
ALLOT_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
LP03.2
TAR-ALLOT-USER-DT
ALLOT_USER_DT
Alpha 2LP03.2
TAR-ALLOT-DATE
ALLOT_DATE
Numeric 8 (yyyymmdd)LP03.2
TAR-ALLT-WAIT-STRT
ALLT_WAIT_STRT
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 Requirement Date
LP03.2
TAR-ALLOT-WAIT-PER
ALLOT_WAIT_PER
Numeric 5LP03.2
TAR-ALLT-WAIT-UNIT
ALLT_WAIT_UNIT
Numeric 2
  • 01 Hours
  • 02 Days
  • 03 Weeks
  • 04 Semi months
  • 05 Months
LP03.2
TAR-ALLT-W-SRV-CLS
ALLT_W_SRV_CLS
Alpha 3LP03.2
TAR-ALLT-W-HRS-TYP
ALLT_W_HRS_TYP
Numeric 2Contains the units of measure for the summarized totals.
  • 01 Plan
  • 02 Plan; employee group
  • 03 Plan; emp group; position
  • 04 All hours
LP03.2
TAR-ALLOT-DT-FLAG
ALLOT_DT_FLAG
Numeric 1
  • 1 Earliest date met
  • 2 Latest date met
LP03.2
TAR-ALLOT-NEAR-PT
ALLOT_NEAR_PT
Numeric 1
  • 1 After requirements are met
  • 2 Before requirements are met
LP03.2
TAR-ALLOT-W-POINT
ALLOT_W_POINT
Numeric 4 (mmdd) Occurs 13 Times ×13LP03.2
TAR-ALLOT-POINT
ALLOT_POINT
Numeric 4 (mmdd)LP03.2
TAR-ALLOT-PERIOD
ALLOT_PERIOD
Numeric 4LP03.2
TAR-ALLOT-UNIT
ALLOT_UNIT
Numeric 2
  • 01 Weeks
  • 02 Two weeks
  • 03 Semi months
  • 04 Four weeks
  • 05 Months
  • 06 Two months
  • 07 Quarters
  • 08 Four months
  • 09 Semi years
  • 10 Years
LP03.2
TAR-ALLOT-OCCUR
ALLOT_OCCUR
Numeric 2
  • 01 Annual
  • 02 One time
LP03.2
TAR-ALLOT-PARTIAL
ALLOT_PARTIAL
Numeric 1
  • 01 No
  • 12 Yes
TAR-ALLOT-PRORATE
ALLOT_PRORATE
Numeric 1
  • 01 No(do not prorate for service)
  • 12 Yes (prorate for service)
TAR-ALLOT-ADJUST
ALLOT_ADJUST
Numeric 1
  • 01 No (do not adjust for change)
  • 12 Yes (adjust for change)
LP03.2
TAR-ALLOT-ACCR-REL
ALLOT_ACCR_REL
Numeric 1
  • 11 Independent of accrual tables
  • 22 First allotment ends accruals
  • 33 Adjust allotment by accruals
LP03.2
TAR-ALLOT-ELIG-REL
ALLOT_ELIG_REL
Numeric 1
  • 1 Independent of eligibility
  • 2 Apply Eligibility Begin Date
LP03.2
TAR-ALLOT-HRS-TBL
ALLOT_HRS_TBL
Alpha 10LP03.2
TAR-ALLOT-ERN-TBL
ALLOT_ERN_TBL
Alpha 10LP03.2
TAR-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.2
TAR-TIME-STAMP
TIME_STAMP
Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.LP03.2
TAR-USER-ID
USER_ID
Alpha 10 (Lower Case)LP03.2
TAR-ROUND-METH-HRS
ROUND_METH_HRS
Numeric 1
  • 0 None
  • 1 Normal
  • 2 High
  • 3 Low
LP03.2
TAR-ROUND-TO-HRS
ROUND_TO_HRS
Signed 18.6LP03.2
TAR-ROUND-METH-ERN
ROUND_METH_ERN
Numeric 1
  • 0 None
  • 1 Normal
  • 2 High
  • 3 Low
LP03.2
TAR-ROUND-TO-ERN
ROUND_TO_ERN
Signed 18.6LP03.2

Indexes (1)

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

IndexKeysFlagsConditionUsed in
TARSET1COMPANY, ACCRUAL-RULEPrimaryHR00.1, HR01.1, HR04.4, HR04.5, HR04.6, HR11.1, HR511, LT101 +22 more (list truncated in source)

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
Accr User DtHRUSERFLDSRequiredWhen (TAR-ACCR-USER-DT != Spaces)TAR-ACCR-USER-DTHRU-FIELD-KEY
Accr W Srv ClsTASERVCLSSRequiredWhen TAR-ACCR-W-SRV-CLS != SpacesTAR-COMPANYTSL-COMPANY, TAR-ACCR-W-SRV-CLSTSL-SERVICE-CLASS
Allot User DtHRUSERFLDSRequiredWhen (TAR-ALLOT-USER-DT != Spaces)TAR-ALLOT-USER-DTHRU-FIELD-KEY
Allt W Srv ClsTASERVCLSSRequiredWhen TAR-ALLT-W-SRV-CLS != SpacesTAR-COMPANYTSL-COMPANY, TAR-ALLT-W-SRV-CLSTSL-SERVICE-CLASS
CompanyPRSYSTEMRequiredTAR-COMPANYPRS-COMPANY, SpacesPRS-PROCESS-LEVEL

One to many (4) — child tables

RelationTableRulesConditionField map
Accr Ern TblTATABLEValid When (TAR-ACCR-ERN-TBL != Spaces)TAR-COMPANYTBL-COMPANY, TAR-ACCR-ERN-TBLTBL-TABLE, TBL-EFFECTIVE-DATE
Accr Hrs TblTATABLEValid When (TAR-ACCR-HRS-TBL != Spaces)TAR-COMPANYTBL-COMPANY, TAR-ACCR-HRS-TBLTBL-TABLE, TBL-EFFECTIVE-DATE
Allot Ern TblTATABLEValid When (TAR-ALLOT-ERN-TBL != Spaces)TAR-COMPANYTBL-COMPANY, TAR-ALLOT-ERN-TBLTBL-TABLE, TBL-EFFECTIVE-DATE
Allot Hrs TblTATABLEValid When (TAR-ALLOT-HRS-TBL != Spaces)TAR-COMPANYTBL-COMPANY, TAR-ALLOT-HRS-TBLTBL-TABLE, TBL-EFFECTIVE-DATE

Programs

Updated by (12)

Referenced by (28)