PRSHIFTHDR FILE

                           Shift Table Header

Contains the shift table code definitions.

REFERENCED BY

PR20.4    PR220     BN150     PR128     PR131     PR132
PR134     PR136     PR137     PR140     PR150     PR195
PR199     PR32.1    PR32.2    PR33.1    PR33.2    PR33.3
PR35.1    PR35.2    PR35.3    PR35.4    PR35.5    PR35.6
PR35.8    PR36.1    PR37.1    PR45.1    PR530     PR80.1
PR82.1    PR85.1    UK102     UK330     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.

                         PRSHIFTHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

PSHSET2   COMPANY                                                BN150   PR128
          SHIFT-CODE                                             PR131   PR132
          EFFECT-DATE*                                           PR134   PR136
                                                                 PR137   PR140
                                                                 PR150   PR195
                                                                 PR199   PR20.4
                                                                 PR220   PR32.1
                                                                 PR32.2  PR33.1
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR36.1
                                                                 PR37.1  PR45.1
                                                                 PR530   PR80.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