Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCRSCHED


                             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
Element: Company Hr    Contains the number that represents an
                       established company.

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

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

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

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

ACS-MAX-ACCRUAL        Signed 9.4                                TA20.2
Element: Maximum AccruaContains 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