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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
ACS-COMPANY PKCOMPANY | Numeric 4 | Contains the number that represents an established company. | TA20.2 |
ACS-PLAN-NAME PKPLAN_NAME | Alpha 10 | Contains the plan name. This is verified in the Time Accrual Plan file. | TA20.2 |
ACS-THRU-CYCLE PKTHRU_CYCLE | Numeric 7 | Contains the number of cycles in the accrual cycle. | TA20.2 |
ACS-HOURS-TO-ACRHOURS_TO_ACR | Signed 9.4 | Contains the number of hours that accrue in the cycle. This field works with the Thru Cycle field. | TA20.2 |
ACS-CALC-NAMECALC_NAME | Alpha 10 | Contains the calculation for the accrual cycle. This field works with the Thru Cycle field. | TA20.2 |
ACS-MAX-ACCRUALMAX_ACCRUAL | Signed 9.4 | Contains 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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
ACSSET1 | COMPANY, PLAN-NAME, THRU-CYCLE | Primary | TA20.1, TA20.2, TA220, TA30.1, TA30.2 |
Relations
One to one (3) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Calc Name | TAFORMULA | Required | When ACS-CALC-NAME != Spaces | ACS-COMPANY → TAF-COMPANY, ACS-CALC-NAME → TAF-CALC-NAME |
| Company | PRSYSTEM | Required | ACS-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL | |
| Plan Name | PLANMASTER | Required | ACS-COMPANY → PLM-COMPANY, ACS-PLAN-NAME → PLM-PLAN-NAME |
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Taeemaster | TAEEMASTER | ACS-COMPANY → TEM-COMPANY, TEM-EMPLOYEE, TEM-PLAN, TEM-EMPLOYEE-GROUP, TEM-POSITION |