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

UPDATED BY

PR24.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PSB-COMPANY            Numeric 4                                 PR24.1
Element: Company       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: Date          Contains the date the shift takes
                       effect.

PSB-OBJ-ID             Numeric 12                                PR24.1
Object                 This is the object identifier. It is
Identification         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: Grade         Contains the pay grade.

PSB-PAY-STEP           Numeric 2                                 PR24.1
Element: 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                                 AC542   PR195
Element: Sh Account    Contains the account to which shift       PR197   PR24.1
                       expenses should be posted.                PR82.1  PR85.1

PSB-SH-SUB-ACCT        Numeric 4                                 AC542   PR195
Element: Sh 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                                AC541   AC542
          SHIFT-CODE                                             BN150   PR128
          SHIFT                                                  PR130   PR131
          EFFECT-DATE                                            PR132   PR134
          JOB-CODE                                               PR136   PR189
          INDICATOR                                              PR29.1  PR32.2
          SCHEDULE                                               PR33.2  PR33.3
          PAY-GRADE                                              PR35.1  PR35.2
          PAY-STEP                                               PR35.3  PR35.4
                                                                 PR35.5  PR35.6
                                                                 PR35.8  PR36.1
                                                                 PR45.1  PR529
                                                                 PR530   PR560
                                                                 PR80.1  PR82.1
                                                                 UK102   UK560
                                                                 ...

PSBSET4   OBJ-ID                                                 AC542   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