Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PRSAGDTL FILE

                      Step & Grade Schedule Detail

Contains the Step and Grade Schedule Detail file that corresponds with the
Step and Grade Schedule Header file. These two files are used with grade range
schedules as well as step and grade schedules. You can define a step and grade
schedule instead of a pay rate on the employee record.

When used for step and grade, this file stores a specific pay rate that
corresponds with a schedule, effective date, step and grade. This file also
has a field for the old pay rate, which PR110 (Step and Grade Audit) uses when
logging the changes of an employee's pay in the logfile. The system uses this
file in any program that requires the employee's pay rate. These include
programs in the Lawson Payroll, Personnel Administration, Benefits, and Time
Accrual systems.

When used for a grade range schedule, this file stores the minimum, midpoint,
and maximum pay rates for the grade range. These correspond with a step of 1,
2, and 3, respectively.

REFERENCED BY

AC541     AC542     BN150     HCSC.1    HR206     HR511
HRCL.1    PA295     PA42.1    PA502     PA513     PR128
PR131     PR132     PR134     PR136     PR216     PR32.2
PR33.2    PR33.3    PR35.1    PR35.2    PR35.3    PR35.4
PR35.5    PR35.6    PR35.8    PR36.1    PR530     PR82.1
UK102     UK120     BN100     BN101     BN102     BN103
BN105     BN145     BN232     BN242     BN245     BN31.1
BN31.2    BN32.1    BN32.2    BN32.3    BN350     BN45.1
BN531     BN65.1    BN66.1    BN71.1    BN72.1    BS13.1
BS14.1    BS15.1    BS32.1    HR15.1    HR155     HR170
HR211     HR54.1    HR55.2    HR650     HR70.1    HRS1.1
HRSC.1    HSGD.1    PA16.1    PA242     PA262     PA272
PA290     PA370     PA391     PA53.1    PA54.1    PA64.1
PA64.2    PA66.3    TR22.1    TR500     HS01.1    PR13.1
PR13.5    PR13.6    PR13.8    PR195     PR24.1    PR89.1
PRBA.1    TA175     TA195     TA199

UPDATED BY

PA95.1    PR116     PR16.1    HR00.1    HR01.1    PR197

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SGD-COMPANY          Numeric 4                                   PA95.1  PR116
Company              Contains the number that represents an      PR16.1
                     established company and is entered on
                     all functions.

SGD-SCHEDULE         Alpha 9                                     PA95.1  PR116
Schedule             Contains a set of steps and grades for      PR16.1
                     a step and grade schedule or a set of
                     grades and minimum, midpoint, and
                     maximum values for a grade range
                     schedule.

SGD-EFFECT-DATE      Numeric 8  (yyyymmdd)                       PA95.1  PR116
Effective Date       Contains the date that the step and         PR16.1
                     grade or the grade range schedule is
                     effective.

SGD-PAY-GRADE        Alpha 3                                     PA95.1  PR116
Grade                Contains the grade.                         PR16.1

SGD-PAY-STEP         Numeric 2                                   PA95.1  PR116
Step                 Contains the step if this is a step and     PR16.1
                     grade schedule. For grade range
                     schedules, step 1 is the minimum, step 2
                     is the midpoint, and step 3 is the
                     maximum pay rate for the grade.

SGD-GRADE-SEQ        Numeric 4                                   PA95.1  PR116
Pay Grade Internal   Contains the sequence number that keeps     PR16.1
Sequence             the grades in order.  Grades are
                     alphanumeric but are not necessarily in
                     alphabetical order.

SGD-PAY-RATE         Signed 13.4                                 PA95.1  PR116
Rate of Pay          Contains the pay rate from the Employee     PR16.1
                     file if using step and grade. If using a
                     grade range schedule, this is either the
                     minimum, midpoint, or maximum.

SGD-OLD-PAY-RATE     Signed 13.4                                 PA95.1  PR116
Old Pay Rate         Contains the old pay rate. When a           PR16.1
                     change is made, the old pay rate
                     defaults into this field. This field is
                     not used with grade range schedules.

SGD-BASE-PAY-RATE    Signed 13.4                                 PA95.1  PR116
Base Pay Rate        Contains the pay rate in the company's      PR16.1
                     base currency.

                         PRSAGDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SGDSET1   COMPANY                                                AC541   AC542
          SCHEDULE                                               BN150   HCSC.1
          EFFECT-DATE                                            HR00.1  HR01.1
          PAY-GRADE                                              HR206   HR511
          PAY-STEP                                               HRCL.1  PA295
                                                                 PA42.1  PA502
                                                                 PA513   PA95.1
                                                                 PR116   PR128
                                                                 PR131   PR132
                                                                 PR134   PR136
                                                                 PR16.1  PR197
                                                                 PR216   PR32.2
                                                                 PR33.2  PR33.3
                                                                 PR35.1  PR35.2
                                                                 PR35.3  PR35.4
                                                                 ...

SGDSET2   COMPANY                                                PA295   PA95.1
          SCHEDULE                                               PR116   PR16.1
          EFFECT-DATE                                            PR216
          GRADE-SEQ
          PAY-STEP

SGDSET3   COMPANY                                                BN100   BN101
          SCHEDULE                                               BN102   BN103
          PAY-GRADE                                              BN105   BN145
          PAY-STEP                                               BN232   BN242
          EFFECT-DATE*                                           BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN350   BN45.1
                                                                 BN531   BN65.1
                                                                 BN66.1  BN71.1
                                                                 BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  HR15.1
                                                                 HR155   HR170
                                                                 HR211   HR511
                                                                 ...

                         PRSAGDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            SGD-COMPANY        -> PRS-COMPANY
                            Spaces             -> PRS-PROCESS-LEVEL

Sag Head       PRSAGHEAD    Required

                            SGD-COMPANY        -> SGH-COMPANY
                            "S"                -> SGH-INDICATOR
                            SGD-SCHEDULE       -> SGH-SCHEDULE
                            SGD-EFFECT-DATE    -> SGH-EFFECT-DATE

Sag Head G     PRSAGHEAD    Not Required

                            SGD-COMPANY        -> SGH-COMPANY
                            "G"                -> SGH-INDICATOR
                            SGD-SCHEDULE       -> SGH-SCHEDULE
                            SGD-EFFECT-DATE    -> SGH-EFFECT-DATE