Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACCRSCHED FILE

                       Activity Accrual Schedule

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.

REFERENCED BY

TA170     TA220

UPDATED BY

TA20.2    TA20.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ACS-COMPANY          Numeric 4                                   TA20.2
Company              Contains the number that represents an
                     established company.

ACS-PLAN-NAME        Alpha 10                                    TA20.2
From Plan Name       Contains the plan name. This is
                     verified in the Time Accrual Plan file.

ACS-THRU-CYCLE       Numeric 7                                   TA20.2
Thru Cycle           Contains the number of cycles in the
                     accrual cycle.

ACS-HOURS-TO-ACR     Signed 9.4                                  TA20.2
Hours to Accrue      Contains the number of hours that
                     accrue in the cycle. This field works
                     with the Thru Cycle field.

ACS-CALC-NAME        Alpha 10                                    TA20.2
Calculation Name     Contains the calculation for the
                     accrual cycle. This field works with the
                     Thru Cycle field.

ACS-MAX-ACCRUAL      Signed 9.4                                  TA20.2
Maximum Accrual      Contains the maximum hours employees
                     can accrue during this accrual cycle.
                     This field is used only when a
                     calculation has been selected.

                         ACCRSCHED FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ACSSET1   COMPANY                                                TA170   TA20.1
          PLAN-NAME                                              TA20.2  TA220
          THRU-CYCLE

                         ACCRSCHED FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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