ACCRSCHED – Activity Accrual Schedule

System
Event Management (TA)
Prefix
ACS
Primary key
COMPANY, PLAN-NAME, THRU-CYCLE
Fields
6
Updated by
2 programs
Referenced by
3 programs

ACCRSCHED is the Activity Accrual Schedule table in Lawson Event Management (prefix ACS). It is indexed by COMPANY, PLAN-NAME, THRU-CYCLE (ACSSET1). It is related 1:1 to TAFORMULA, PRSYSTEM and PLANMASTER and 1:M to TAEEMASTER. It is updated by TA20.1 and TA20.2 and referenced by TA220, TA30.1 and TA30.2. The table has 6 fields, 1 index and 4 documented relations.

About ACCRSCHED

The Accrual Schedule file is used to determine - when hours begin to accrue, - whether the accrual cycle adjusts to the payroll cycle, and - whether the accrual cycle is based on hours or a formula.

Fields (6)

Column = COBOL field name without the ACS- 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 / columnTypeDescription & valuesUpdated by
#ACS-COMPANY PK
COMPANY		Numeric 4Contains the number that represents an established company.TA20.2
#ACS-PLAN-NAME PK
PLAN_NAME		Alpha 10Contains the plan name. This is verified in the Time Accrual Plan file.TA20.2
#ACS-THRU-CYCLE PK
THRU_CYCLE		Numeric 7Contains the number of cycles in the accrual cycle.TA20.2
#ACS-HOURS-TO-ACR
HOURS_TO_ACR		Signed 9.4Contains the number of hours that accrue in the cycle. This field works with the Thru Cycle field.TA20.2
#ACS-CALC-NAME
CALC_NAME		Alpha 10Contains the calculation for the accrual cycle. This field works with the Thru Cycle field.TA20.2
#ACS-MAX-ACCRUAL
MAX_ACCRUAL		Signed 9.4Contains the maximum hours employees can accrue during this accrual cycle. This field is used only when a calculation has been selected.TA20.2

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.

IndexKeysFlagsConditionUsed in
ACSSET1
  1. COMPANY
  2. PLAN-NAME
  3. THRU-CYCLE
PrimaryTA20.1, TA20.2, TA220, TA30.1, TA30.2

Relations

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

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Calc NameTAFORMULARequiredWhen ACS-CALC-NAME != Spaces
ACS-COMPANY→TAF-COMPANY
ACS-CALC-NAME→TAF-CALC-NAME
CompanyPRSYSTEMRequired
ACS-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Plan NamePLANMASTERRequired
ACS-COMPANY→PLM-COMPANY
ACS-PLAN-NAME→PLM-PLAN-NAME

One to many (1) — child tables

RelationTableRulesConditionField map
TaeemasterTAEEMASTER
ACS-COMPANY→TEM-COMPANY
—→TEM-EMPLOYEE
—→TEM-PLAN
—→TEM-EMPLOYEE-GROUP
—→TEM-POSITION

Programs

Updated by (2)

Referenced by (3)