Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRSHIFTHDR


                            PRSHIFTHDR FILE

Contains the shift table code definitions.

REFERENCED BY

PR20.4    PR220     BN150     ET530     ETI2.1    LP130
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
PR35.9    PR36.1    PR45.1    PR529     PR530     PR560
PR80.1    PR82.1    UK102     UK560     TA147

UPDATED BY

PR24.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PSH-COMPANY            Numeric 4                                 PR24.1
Element: Company Hr

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

PSH-EFFECT-DATE        Numeric 8  (yyyymmdd)                     PR24.1
Element: Effect Date   Contains 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
Element: Acct Nd       The number of decimals assigned to a
                       particular account as determined by the
                       account currency.


                         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   ET530
          SHIFT-CODE                                             ETI2.1  LP130
          EFFECT-DATE*                                           PR128   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
                                                                 PR35.9  PR36.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 ...

                         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