PRSAGDTL – Step & Grade Schedule Detail

System
Human Resources (HR)
Prefix
SGD
Primary key
COMPANY, SCHEDULE, EFFECT-DATE, PAY-GRADE, PAY-STEP
Fields
9
Updated by
8 programs
Referenced by
185 programs

PRSAGDTL is the Step & Grade Schedule Detail table in Lawson Human Resources (prefix SGD). It is indexed by COMPANY, SCHEDULE, EFFECT-DATE, PAY-GRADE, PAY-STEP (SGDSET1); alternate indexes: SGDSET2 and SGDSET3. It is related 1:1 to PRSYSTEM and PRSAGHEAD. It is updated by HR00.1, HR01.1, LP130, LP198, PA95.1, PR110, PR116 and PR16.1 and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN150, BN232 and 177 more. The table has 9 fields, 3 indexes and 3 documented relations.

About PRSAGDTL

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.

Fields (9)

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

Field / columnTypeDescription & valuesUpdated by
SGD-COMPANY PK
COMPANY		Numeric 4Contains the number that represents an established company and is entered on all functions.PA95.1, PR116, PR16.1
SGD-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
SGD-EFFECT-DATE PK
EFFECT_DATE		Numeric 8 (yyyymmdd)Contains the date that the step and grade or the grade range schedule is effective.PA95.1, PR116, PR16.1
SGD-PAY-GRADE PK
PAY_GRADE		Alpha 3Contains the grade.PA95.1, PR116, PR16.1
SGD-PAY-STEP PK
PAY_STEP		Numeric 2Contains the step if this is a step and 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.PA95.1, PR116, PR16.1
SGD-GRADE-SEQ
GRADE_SEQ		Numeric 4Contains the sequence number that keeps the grades in order. Grades are alphanumeric but are not necessarily in alphabetical order.PA95.1, PR116, PR16.1
SGD-PAY-RATE
PAY_RATE		Signed 13.4Contains the pay rate from the Employee file if using step and grade. If using a grade range schedule, this is either the minimum, midpoint, or maximum.PA95.1, PR116, PR16.1
SGD-OLD-PAY-RATE
OLD_PAY_RATE		Signed 13.4Contains the old pay rate. When a change is made, the old pay rate defaults into this field. This field is not used with grade range schedules.PA95.1, PR110, PR116, PR16.1
SGD-BASE-PAY-RATE
BASE_PAY_RATE		Signed 13.4Contains the pay rate in the company's base currency.PA95.1, PR116, 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
SGDSET1COMPANY, SCHEDULE, EFFECT-DATE, PAY-GRADE, PAY-STEPPrimaryBN150, BN305, HCDL.1, HCHP.1, HCSC.1, HR00.1, HR01.1, HR06.1 +22 more (list truncated in source)
SGDSET2COMPANY, SCHEDULE, EFFECT-DATE, GRADE-SEQ, PAY-STEPPA295, PA95.1, PR116, PR16.1, PR216
SGDSET3COMPANY, SCHEDULE, PAY-GRADE, PAY-STEP, EFFECT-DATE*BN100, BN101, BN102, BN103, BN105, BN145, BN150, BN232 +22 more (list truncated in source)

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredSGD-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
Sag HeadPRSAGHEADRequiredSGD-COMPANY → SGH-COMPANY, "S" → SGH-INDICATOR, SGD-SCHEDULE → SGH-SCHEDULE, SGD-EFFECT-DATE → SGH-EFFECT-DATE
Sag Head GPRSAGHEADNot RequiredSGD-COMPANY → SGH-COMPANY, "G" → SGH-INDICATOR, SGD-SCHEDULE → SGH-SCHEDULE, SGD-EFFECT-DATE → SGH-EFFECT-DATE

Programs

Updated by (8)

Referenced by (185)