Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PRSAGHEAD


                             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    HGLM.1    HPOS.1    HPQC.1    HPRS.1
HR06.1    HR11.1    HR11.2    HR15.1    HR155     HR170
HR206     HR506     HR511     HR515     HR54.1    HR55.2
HR650     HR70.1    HRS1.1    HRSC.1    HSGD.1    PA02.1
PA100     PA102     PA115     PA13.1    PA13.2    PA16.1
PA20.1    PA21.1    PA22.1    PA24.1    PA242     PA27.1
PA295     PA311     PA34.1    PA35.1    PA36.1    PA38.1
PA502     PA513     PA52.1    PA52.3    PA52.4    PA52.5
PA520     PA54.1    TR21.1    TR22.1    TR26.1    TR500
HS01.1    PR113     PR120     PR13.1    PR13.5    PR13.6
PR13.8    PRSC.1    AC541     AC542     BN100     BN101
BN102     BN103     BN105     BN145     BN150     BN245
BN31.1    BN31.2    BN32.1    BN32.2    BN32.3    BN320
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
PA42.1    PR128     PR130     PR131     PR132     PR134
PR136     PR189     PR216     PR24.1    PR29.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    PR45.1
PR529     PR530     PR560     PR80.1    PR82.1    PR89.1
UK102     UK560     TA147     UK120

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

SGH-INDICATOR          Alpha 1                                   PA95.1  PR116
Element: 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
Element: 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
Element: 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
Element: Description   Contains the user-defined description     PR116   PR16.1
                       of the schedule.

SGH-SALARY-CLASS       Alpha 1                                   PA95.1  PR116
Element: 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  PR110
Element: Status        Contains the status of a given            PR116   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
Element: Status 1

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

SGH-CURR-ND            Numeric 1                                 PA95.1  PR116
Account Currency                                                 PR16.1
Code

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

SGH-BASE-ND            Numeric 1                                 PA95.1  PR116
Account Currency                                                 PR16.1
Code

                         PRSAGHEAD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SGHSET1   COMPANY                                                HC01.1  HC02.1
          INDICATOR                                              HGLM.1  HPOS.1
          SCHEDULE                                               HPQC.1  HPRS.1
          EFFECT-DATE                                            HR00.1  HR01.1
                                                                 HR06.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR170
                                                                 HR206   HR506
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR650   HR70.1
                                                                 HRS1.1  HRSC.1
                                                                 HSGD.1  PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.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  BN320
                                                                 BN45.1  BN531
                                                                 BN65.1  BN71.1
                                                                 BN72.1  BS13.1
                                                                 BS14.1  BS15.1
                                                                 BS32.1  HCEM.1
                                                                 HCOP.1  HCSC.1
                                                                 HR06.1  HR11.1
                                                                 ...

SGHSET3   COMPANY       Subset                                   PR110   PR32.1
          EFFECT-DATE*  Where STATUS = Zeroes                    PR32.2  PR35.1
          INDICATOR     Or    STATUS = 1                         PR35.2  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