Lawson Insight Technical Documentation

                            PRSHIFTHDR FILE

Contains the shift table code definitions.

REFERENCED BY

PR20.4    PR220     BN150     PR128     PR130     PR131
PR132     PR134     PR136     PR29.1    PR32.2    PR33.2
PR33.3    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR35.9    PR36.1    PR45.1    PR529
PR530     PR560     PR82.1    UK102     TA147     TP135

UPDATED BY

PR24.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PSH-COMPANY            Numeric 4                                 PR24.1
Element: Company Hr    Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

PSH-EFFECT-DATE        Numeric 8  (yyyymmdd)                     PR24.1
Element: Effective DateContains the date the shift takes
                       effect.

PSH-GRADE-RNG-PCT      Alpha 1                                   PR24.1
Element: 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
Element: Description   Contains the shift description.

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

PSH-CURR-ND            Numeric 1                                 PR24.1
Account Currency       Represents the number of decimals
Code                   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                                                BN150   PR128
          SHIFT-CODE                                             PR130   PR131
          EFFECT-DATE*                                           PR132   PR134
                                                                 PR136   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
                                                                 PR35.9  PR36.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR82.1  UK102
                                                                 TA147   TP135

                         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