PRSAGHEAD – Step & Grade Schedule Header

System
Human Resources (HR)
Prefix
SGH
Primary key
COMPANY, INDICATOR, SCHEDULE, EFFECT-DATE
Fields
14
Updated by
39 programs
Referenced by
131 programs

PRSAGHEAD is the Step & Grade Schedule Header table in Lawson Human Resources (prefix SGH). It is indexed by COMPANY, INDICATOR, SCHEDULE, EFFECT-DATE (SGHSET1); alternate indexes: SGHSET2 and SGHSET3. It is related 1:1 to CUCODES and PRSYSTEM and 1:M to PATHFIND and PRSAGDTL. It is updated by BN305, HR00.1, HR01.1, HR11.1, HR11.2, HR11.4, HR28.1, HR511 and 31 more and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN150, BN232 and 123 more. The table has 14 fields, 3 indexes and 5 documented relations.

About PRSAGHEAD

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.

Fields (14)

Column = COBOL field name without the SGH- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
SGH-COMPANY PK
COMPANY		Numeric 4Contains the number that represents an established company and is entered on all functions.PA95.1, PR116, PR16.1
SGH-INDICATOR PK
INDICATOR		Alpha 1Indicates whether this schedule is a 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
PA95.1, PR116, PR16.1
SGH-SCHEDULE PK
SCHEDULE		Alpha 9Contains a set of steps and grades for a step and grade schedule, or a set of grades and minimum, midpoint, and maximum values for a grade range schedule.PA95.1, PR116, PR16.1
SGH-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the date when the step and grade or grade range schedule goes into effect.PA95.1, PR116, PR16.1
SGH-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Contains the user-defined description of the schedule.PA311, PA95.1, PR116, PR16.1
SGH-SALARY-CLASS
SALARY_CLASS		Alpha 1Indicates if the table is used for salaried or hourly schedules.
  • H Hourly
  • S Salaried
PA95.1, PR116, PR16.1
SGH-LST-GRADE-SEQ
LST_GRADE_SEQ		Numeric 4Contains the last number used for a grade sequence number in the detail file.PA95.1, PR116, PR16.1
SGH-STATUS
STATUS		Numeric 1Contains the status of a given 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
PA95.1, PR110, PR116, PR16.1
SGH-STATUS-1
STATUS_1		Derived——
SGH-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the currency in which the salary is recorded.PA95.1, PR116, PR16.1
SGH-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.PA95.1, PR116, PR16.1
SGH-BASE-CURRENCY
BASE_CURRENCY		Alpha 5Contains the company base currency.PA95.1, PR116, PR16.1
SGH-BASE-ND
BASE_ND		Numeric 1The number of decimal positions defined for the company base currency.PA95.1, PR116, PR16.1
SGH-ACTIVE-FLAG
ACTIVE_FLAG		Numeric 1—
  • 1 Active
  • 2 Inactive
PA95.1, PR16.1

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SGHSET1COMPANY, INDICATOR, SCHEDULE, EFFECT-DATEPrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR00.1 +22 more (list truncated in source)
SGHSET2COMPANY, INDICATOR, SCHEDULE, EFFECT-DATE*BN100, BN101, BN102, BN103, BN105, BN145, BN150, BN232 +22 more (list truncated in source)
SGHSET3COMPANY, EFFECT-DATE*, INDICATOR, SCHEDULESubsetWhere STATUS = Zeroes Or STATUS = 1PR110, PR32.1, PR32.2, PR35.1, PR35.2, PR36.1, PR36.4

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
Base CurrencyCUCODESRequiredWhen (SGH-CURRENCY-CODE != Spaces)SGH-BASE-CURRENCY → CUC-CURRENCY-CODE
CompanyPRSYSTEMRequiredSGH-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
CurrencyCUCODESRequiredWhen (SGH-CURRENCY-CODE != Spaces)SGH-CURRENCY-CODE → CUC-CURRENCY-CODE

One to many (2) — child tables

RelationTableRulesConditionField map
EmployeesPATHFINDSGH-COMPANY → PTF-COMPANY, 136 → PTF-FLD-NBR, SGH-SCHEDULE → PTF-FLD-VALUE, → PTF-EMPLOYEE, → PTF-POS-LEVEL
RatePRSAGDTLSGH-COMPANY → SGD-COMPANY, SGH-SCHEDULE → SGD-SCHEDULE, SGH-EFFECT-DATE → SGD-EFFECT-DATE, → SGD-PAY-GRADE, → SGD-PAY-STEP

Programs

Updated by (39)

Referenced by (131)