Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACTRLIMIT


                             ACTRLIMIT FILE

                       Accrual Transaction Limit

The Accrual Transaction Limit file is used with the Time Accrual Plan file to
establish accrual and eligible hours limits.

REFERENCED BY

TA146     TA170     TA220

UPDATED BY

TA20.3    TA20.5    TA20.1    TA40.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ATL-COMPANY            Numeric 4                                 TA20.3  TA20.5
Element: Company Hr    Contains the number that represents an    TA40.1
                       established company.

ATL-PLAN-NAME          Alpha 10                                  TA20.3  TA20.5
Element: Plan Name     Contains the plan name. This is           TA40.1
                       verified in the Time Accrual Plan file.

ATL-LIMIT-TYPE         Alpha 1                                   TA20.3  TA20.5
Element: Limit Type    Contains accrual and eligible limit       TA40.1
                       types.
                       A = Accrual
                       E = Eligibile

ATL-THRU-LIM-CYC       Numeric 7                                 TA20.3  TA20.5
Element: Thru Lim Cyc  Contains the last limit cycle for which
                       the accrual limit is effective.

ATL-MAX-BALANCE        Signed 9.4                                TA20.3  TA20.5
Element: Max Balance   Contains the maximum number of hours      TA40.1
                       employees can have in their accrual
                       balance during the limit cycle.

                         ACTRLIMIT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ATLSET1   COMPANY                                                TA146   TA170
          PLAN-NAME                                              TA20.1  TA20.3
          LIMIT-TYPE                                             TA20.5  TA220
          THRU-LIM-CYC                                           TA40.1

                         ACTRLIMIT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            ATL-COMPANY      -> PRS-COMPANY
                            Spaces           -> PRS-PROCESS-LEVEL

Plan Name      PLANMASTER   Required

                            ATL-COMPANY      -> PLM-COMPANY
                            ATL-PLAN-NAME    -> PLM-PLAN-NAME