Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
Company              Contains the number that represents an      TA40.1
                     established company.

ATL-PLAN-NAME        Alpha 10                                    TA20.3  TA20.5
From 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
Limit Type           Contains accrual and eligible limit         TA40.1
                     types.
                     A = Accrual
                     E = Eligibile

ATL-THRU-LIM-CYC     Numeric 7                                   TA20.3  TA20.5
Thru Limit Cycle     Contains the last limit cycle for which
                     the accrual limit is effective.

ATL-MAX-BALANCE      Signed 9.4                                  TA20.3  TA20.5
Maximum 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