Lawson Insight Technical Documentation

                            PROTPAYPRD FILE

                          Overtime Pay Periods

This file contains the pay plans with the start and end dates of the pay
periods within the plans.

REFERENCED BY

BN100     BN101     BN102     BN103     BN105     BN145
BN245     BN31.1    BN31.2    BN32.1    BN32.2    BN32.3
BN45.1    BN531     BN66.1    BN71.1    BN72.1    BS12.1
BS13.1    BS14.1    BS15.1    BS32.1    HS03.1    PR139
PR195     PR221     PR89.1    HR650     PR282     PR32.1
PR32.2    PREN.1

UPDATED BY

PR21.1    PR21.3    PR999

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PRY-COMPANY          Numeric 4                                   PR21.1  PR999
Company              The company number represents an
                     established company and is entered on
                     all function codes.

PRY-PLAN-CODE        Alpha 4                                     PR21.1  PR999
Plan                 Contains the user-defined code that
                     represents a pay plan.

PRY-EFFECT-DATE      Numeric 8  (yyyymmdd)                       PR21.1  PR999
Effective Date       Contains the effective date of the pay
                     plan.

PRY-PAY-START-DATE   Numeric 8  (yyyymmdd)                       PR21.1  PR999
Pay Start Date       Contains the pay period start date.

PRY-PAY-END-DATE     Numeric 8  (yyyymmdd)                       PR21.1  PR999
Pay End Date         Contains the pay period end date.

PRY-STD-COST-HRS     Signed 7.2                                  PR21.3
Std Cost Hrs

                         PROTPAYPRD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRYSET1   COMPANY                                                BN100   BN101
          PLAN-CODE                                              BN102   BN103
          EFFECT-DATE                                            BN105   BN145
          PAY-START-DATE                                         BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN45.1  BN531
                                                                 BN66.1  BN71.1
                                                                 BN72.1  BS12.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 HS03.1  PR139
                                                                 PR195   PR21.1
                                                                 PR21.2  PR21.3
                                                                 PR221   PR89.1

PRYSET2   COMPANY                                                HR650
          PLAN-CODE
          EFFECT-DATE*
          PAY-START-DATE*

PRYSET3   COMPANY       KeyChange                                PR21.2  PR282
          PLAN-CODE                                              PR32.1  PR32.2
          EFFECT-DATE                                            PR999   PREN.1
          PAY-START-DATE*

                         PROTPAYPRD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PRY-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Overtime Plan  PROVERTIME   Required

                            PRY-COMPANY        -> PRO-COMPANY
                            PRY-PLAN-CODE      -> PRO-PLAN-CODE
                            PRY-EFFECT-DATE    -> PRO-EFFECT-DATE