Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRSHIFTTBL


                            PRSHIFTTBL FILE

This detail file contains shift differential rates by shift code and can be
assigned by job code, grade range schedule, and step and grade schedule. The
shift differential rates can be defined as amounts or percents.

REFERENCED BY

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     PR195     PR197
PR85.1

UPDATED BY

PR24.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PSB-COMPANY            Numeric 4                                 PR24.1
Element: Company Hr    Contains the company number.

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

PSB-EFFECT-DATE        Numeric 8  (yyyymmdd)                     PR24.1
Element: Effect Date   Contains the date the shift takes
                       effect.

PSB-OBJ-ID             Numeric 12                                PR24.1
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

PSB-SHIFT              Numeric 1                                 PR24.1
Element: Shift         Contains the shift number associated
                       with the pay.

PSB-JOB-CODE           Alpha 9                                   PR24.1
Element: Job Code      Contains a user-defined code that
                       represents a type of job.

PSB-INDICATOR          Alpha 1                                   PR24.1
Element: Indicator     Indicates whether pay for this shift is
                       based on a grade range or a step and
                       grade schedule.
                       G = Grade Range
                       S = Step and Grade

PSB-SCHEDULE           Alpha 9                                   PR24.1
Element: Schedule      Contains the shift's schedule.

PSB-PAY-GRADE          Alpha 3                                   PR24.1
Element: Pay Grade     Contains the pay grade.

PSB-PAY-STEP           Numeric 2                                 PR24.1
Element: Pay Step      Contains the pay step.

PSB-RATE               Signed 13.4                               PR24.1
Element: Rate          Contains a flat rate or percentage that
                       the shift differential rate is based on.


PSB-PERCENT-OF         Numeric 1                                 PR24.1
Element: Percent Of    Indicates whether the shift
                       differential percentage should be based
                       on the minimum, midpoint, or maximum
                       rate for the shift.
                       1 = Minimum
                       2 = Midpoint
                       3 = Maximum

PSB-SH-ACCOUNT         Numeric 6                                 ET530   PR195
Element: Account       Contains the account to which shift       PR197   PR24.1
                       expenses should be posted.                PR82.1  PR85.1

PSB-SH-SUB-ACCT        Numeric 4                                 ET530   PR195
Element: Sub Acct      Contains the subaccount to which the      PR197   PR24.1
                       shift expenses should be posted.          PR82.1  PR85.1

                         PRSHIFTTBL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PSBSET1   COMPANY                                                PR24.1
          SHIFT-CODE
          EFFECT-DATE
          OBJ-ID

PSBSET2   COMPANY       KeyChange                                PR220   PR24.1
          SHIFT-CODE
          EFFECT-DATE
          SHIFT
          JOB-CODE
          INDICATOR
          SCHEDULE
          PAY-GRADE
          PAY-STEP

PSBSET3   COMPANY       KeyChange                                BN150   ET530
          SHIFT-CODE                                             ETI2.1  LP130
          SHIFT                                                  PR128   PR130
          EFFECT-DATE                                            PR131   PR132
          JOB-CODE                                               PR134   PR136
          INDICATOR                                              PR189   PR29.1
          SCHEDULE                                               PR32.2  PR33.2
          PAY-GRADE                                              PR33.3  PR35.1
          PAY-STEP                                               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
                                                                 ...

PSBSET4   OBJ-ID                                                 ET530   PR195
                                                                 PR197   PR82.1
                                                                 PR85.1

                         PRSHIFTTBL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PSB-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Job Code       JOBCODE      Required

                            PSB-COMPANY        -> JBC-COMPANY
                            PSB-JOB-CODE       -> JBC-JOB-CODE

Shift Header   PRSHIFTHDR   Required

                            PSB-COMPANY        -> PSH-COMPANY
                            PSB-SHIFT-CODE     -> PSH-SHIFT-CODE
                            PSB-EFFECT-DATE    -> PSH-EFFECT-DATE

                         PRSHIFTTBL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Step And Grade PRSAGHEAD

                            PSB-COMPANY        -> SGH-COMPANY
                            PSB-INDICATOR      -> SGH-INDICATOR
                            PSB-SCHEDULE       -> SGH-SCHEDULE
                                                  SGH-EFFECT-DATE

Step Grade Dtl PRSAGDTL

                            PSB-COMPANY        -> SGD-COMPANY
                            PSB-SCHEDULE       -> SGD-SCHEDULE
                            PSB-PAY-GRADE      -> SGD-PAY-GRADE
                            PSB-PAY-STEP       -> SGD-PAY-STEP
                                                  SGD-EFFECT-DATE