Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PRSAGHEAD FILE

                      Step & Grade Schedule Header

The Step and Grade Schedule Header file stores the type and description of
the schedule. The system creates a record for each schedule and each effective
date. The header file of a schedule can have many associated detail records.
These header and detail files are used with both step and grade and grade
range schedules.

REFERENCED BY

HC01.1    HC02.1    HR15.1    HR155     HR170     HR206
HR511     HR54.1    HR55.2    HR650     HR70.1    HRS1.1
HRSC.1    HSGD.1    PA16.1    PA242     PA295     PA311
PA42.1    PA502     PA513     PA54.1    TR22.1    TR500
HS01.1    PR13.1    PR13.5    PR13.6    PR13.8    AC541
AC542     BN100     BN101     BN102     BN103     BN105
BN145     BN150     BN245     BN31.1    BN31.2    BN32.1
BN32.2    BN32.3    BN45.1    BN531     BN65.1    BN71.1
BN72.1    BS13.1    BS14.1    BS15.1    BS32.1    HCEM.1
HCOP.1    HCSC.1    HR211     HRCL.1    HSGH.1    PA202
PA290     PA360     PR128     PR131     PR132     PR134
PR136     PR216     PR24.1    PR32.2    PR32.1    PR33.2
PR33.3    PR35.1    PR35.2    PR35.3    PR35.4    PR35.5
PR35.6    PR35.8    PR36.1    PR530     PR82.1    PR89.1
UK102     UK120

UPDATED BY

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

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

SGH-INDICATOR        Alpha 1                                     PA95.1  PR116
Indicator            Indicates whether this schedule is a        PR16.1
                     step and grade schedule or a grade range
                     schedule. You cannot use the same
                     schedule name for both kinds of
                     schedules.
                     G = Grade Range
                     S = Step and Grade

SGH-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.

SGH-EFFECT-DATE      Numeric 8  (yyyymmdd)                       PA95.1  PR116
Effective Date       Contains the date when the step and         PR16.1
                     grade or grade range schedule goes into
                     effect.

SGH-DESCRIPTION      Alpha 30  (Lower Case)                      PA311   PA95.1
Description          Contains the user-defined description       PR116   PR16.1
                     of the schedule.

SGH-SALARY-CLASS     Alpha 1                                     PA95.1  PR116
Salary Class         Indicates if the table is used for          PR16.1
                     salaried or hourly schedules.
                     H = Hourly
                     S = Salaried

SGH-LST-GRADE-SEQ    Numeric 4                                   PA95.1  PR116
Last Grade Sequence  Contains the last number used for a         PR16.1
Number               grade sequence number in the detail
                     file.

SGH-STATUS           Numeric 1                                   PA95.1  PR116
Status               Contains the status of a given              PR16.1
                     transaction.
                     0 = New schedule - must run PR110
                     1 = Changed schedule - Run PR110
                     2 = Current schedule - Updated
                     3 = No longer in use - History
                     5 = Grade Range Schedule

SGH-STATUS-1         Derived
Status 1

SGH-CURRENCY-CODE    Alpha 5                                     PA95.1  PR116
Currency Code        Contains the currency in which the          PR16.1
                     salary is recorded.

SGH-CURR-ND          Numeric 1                                   PA95.1  PR116
Currency Number of   Represents the number of decimals           PR16.1
Decimals             defined for the currency of the object.

SGH-BASE-CURRENCY    Alpha 5                                     PA95.1  PR116
Base Currency        Contains the company base currency.         PR16.1

SGH-BASE-ND          Numeric 1                                   PA95.1  PR116
Base Number Of       The number of decimal positions defined     PR16.1
Decimals             for the company base currency.

                         PRSAGHEAD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SGHSET1   COMPANY                                                HC01.1  HC02.1
          INDICATOR                                              HR00.1  HR01.1
          SCHEDULE                                               HR15.1  HR155
          EFFECT-DATE                                            HR170   HR206
                                                                 HR511   HR54.1
                                                                 HR55.2  HR650
                                                                 HR70.1  HRS1.1
                                                                 HRSC.1  HSGD.1
                                                                 PA16.1  PA242
                                                                 PA295   PA311
                                                                 PA42.1  PA502
                                                                 PA513   PA54.1
                                                                 PA95.1  TR22.1
                                                                 TR500   HS01.1
                                                                 PR116   PR13.1
                                                                 ...

SGHSET2   COMPANY                                                AC541   AC542
          INDICATOR                                              BN100   BN101
          SCHEDULE                                               BN102   BN103
          EFFECT-DATE*                                           BN105   BN145
                                                                 BN150   BN245
                                                                 BN31.1  BN31.2
                                                                 BN32.1  BN32.2
                                                                 BN32.3  BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 HCEM.1  HCOP.1
                                                                 HCSC.1  HR206
                                                                 HR211   HR511
                                                                 ...

SGHSET3   COMPANY       Subset                                   PR32.1  PR32.2
          EFFECT-DATE*  Where STATUS = Zeroes                    PR35.1  PR35.2
          INDICATOR     Or    STATUS = 1                         PR36.1
          SCHEDULE

                         PRSAGHEAD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Base Currency  CUCODES      Required
                            When (SGH-CURRENCY-CODE != Spaces )

                            SGH-BASE-CURRENCY    -> CUC-CURRENCY-CODE

Company        PRSYSTEM     Required

                            SGH-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Currency       CUCODES      Required
                            When (SGH-CURRENCY-CODE != Spaces )

                            SGH-CURRENCY-CODE    -> CUC-CURRENCY-CODE

                         PRSAGHEAD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employees      PATHFIND

                            SGH-COMPANY          -> PTF-COMPANY
                            590                  -> PTF-FLD-NBR
                            SGH-SCHEDULE         -> PTF-FLD-VALUE
                                                    PTF-EMPLOYEE
                                                    PTF-POS-LEVEL

Rate           PRSAGDTL

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