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

BN305     HAP3.1    HEP4.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
HR70.1    HRS1.1    HRSC.1    HSGD.1    LP100     LP101
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    BN100     BN101     BN102     BN103
BN105     BN145     BN150     BN232     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    ET530     ETI2.1    HCDL.1    HCEM.1
HCSC.1    HR211     HRCL.1    HSGH.1    LP130     LP198
PA103     PA202     PA290     PA360     PA42.1    PA42.3
PA535     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    PR35.9    PR36.1
PR45.1    PR529     PR530     PR560     PR80.1    PR82.1
PR89.1    UK102     UK560     TA147

UPDATED BY

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


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SGH-COMPANY            Numeric 4                                 PA95.1  PR116
Element: Company Hr    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: Effect 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
Element: Lst Grade Seq Contains the last number used for a       PR16.1
                       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
Element: Acct Nd       The number of decimals assigned to a      PR16.1
                       particular account as determined by the
                       account currency.


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

SGH-BASE-ND            Numeric 1                                 PA95.1  PR116
Element: Base Nd       The number of decimal positions defined   PR16.1
                       for the company base currency.

                         PRSAGHEAD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SGHSET1   COMPANY                                                BN305   HAP3.1
          INDICATOR                                              HEP4.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
                                                                 HR70.1  HRS1.1
                                                                 HRSC.1  HSGD.1
                                                                 LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 ...

SGHSET2   COMPANY                                                BN100   BN101
          INDICATOR                                              BN102   BN103
          SCHEDULE                                               BN105   BN145
          EFFECT-DATE*                                           BN150   BN232
                                                                 BN245   BN305
                                                                 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  ET530
                                                                 ETI2.1  HCDL.1
                                                                 HCEM.1  HCSC.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
                            136                  -> 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