Lawson Insight Technical Documentation

                            PRSHIFTHDR FILE

Contains the shift table code definitions.

REFERENCED BY

PR20.4    PR220     AC541     AC542     BN150     PR128
PR130     PR131     PR132     PR134     PR136     PR189
PR29.1    PR32.2    PR33.2    PR33.3    PR35.1    PR35.2
PR35.3    PR35.4    PR35.5    PR35.6    PR35.8    PR36.1
PR45.1    PR529     PR530     PR560     PR80.1    PR82.1
UK102     TA147     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*                                           PR130   PR131
                                                                 PR132   PR134
                                                                 PR136   PR189
                                                                 PR20.4  PR220
                                                                 PR29.1  PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR36.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 ...

                         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