Lawson Insight Technical Documentation

                            PRSHIFTHDR FILE

Contains the shift table code definitions.

REFERENCED BY

PR20.4    PR220     AC541     AC542     BN150     PR128
PR131     PR132     PR134     PR136     PR32.2    PR33.2
PR33.3    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR36.1    PR530     PR82.1    UK102
UK120

UPDATED BY

PR24.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

PSH-SHIFT-CODE       Alpha 4                                     PR24.1
Shift Code           Contains the shift table.

PSH-EFFECT-DATE      Numeric 8  (yyyymmdd)                       PR24.1
Effective Date       Contains the date the shift takes
                     effect.

PSH-GRADE-RNG-PCT    Alpha 1                                     PR24.1
Grade Rng Pct        Indicates whether the rates are a
                     percent of grade range.
                     Y = Yes
                     N = No

PSH-DESCRIPTION      Alpha 30  (Lower Case)                      PR24.1
Description          Contains the shift description.

PSH-CURRENCY-CODE    Alpha 5                                     PR24.1
Currency Code        This field contains the company base
                     currency code established in Company
                     (GL10.1 ).

PSH-CURR-ND          Numeric 1                                   PR24.1
Currency Number of   Represents the number of decimals
Decimals             defined for the currency of the object.

                         PRSHIFTHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PSHSET1   COMPANY                                                PR20.4  PR220
          SHIFT-CODE                                             PR24.1
          EFFECT-DATE

PSHSET2   COMPANY                                                AC541   AC542
          SHIFT-CODE                                             BN150   PR128
          EFFECT-DATE*                                           PR131   PR132
                                                                 PR134   PR136
                                                                 PR20.4  PR220
                                                                 PR32.2  PR33.2
                                                                 PR33.3  PR35.1
                                                                 PR35.2  PR35.3
                                                                 PR35.4  PR35.5
                                                                 PR35.6  PR35.8
                                                                 PR36.1  PR530
                                                                 PR82.1  UK102
                                                                 UK120

                         PRSHIFTHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PSH-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

                         PRSHIFTHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Shift Table    PRSHIFTTBL   Delete Cascades

                            PSH-COMPANY        -> PSB-COMPANY
                            PSH-SHIFT-CODE     -> PSB-SHIFT-CODE
                            PSH-EFFECT-DATE    -> PSB-EFFECT-DATE
                                                  PSB-SHIFT
                                                  PSB-JOB-CODE
                                                  PSB-INDICATOR
                                                  PSB-SCHEDULE
                                                  PSB-PAY-GRADE
                                                  PSB-PAY-STEP