PRSAGDTL FILE
Step & Grade Schedule Detail
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.
REFERENCED BY
AC541 AC542 BN150 HCSC.1 HR206 HR511
HRCL.1 PA295 PA42.1 PA502 PA513 PR128
PR131 PR132 PR134 PR136 PR216 PR32.2
PR33.2 PR33.3 PR35.1 PR35.2 PR35.3 PR35.4
PR35.5 PR35.6 PR35.8 PR36.1 PR530 PR82.1
UK102 UK120 BN100 BN101 BN102 BN103
BN105 BN145 BN232 BN242 BN245 BN31.1
BN31.2 BN32.1 BN32.2 BN32.3 BN350 BN45.1
BN531 BN65.1 BN66.1 BN71.1 BN72.1 BS13.1
BS14.1 BS15.1 BS32.1 HR15.1 HR155 HR170
HR211 HR54.1 HR55.2 HR650 HR70.1 HRS1.1
HRSC.1 HSGD.1 PA16.1 PA242 PA262 PA272
PA290 PA370 PA391 PA53.1 PA54.1 PA64.1
PA64.2 PA66.3 TR22.1 TR500 HS01.1 PR13.1
PR13.5 PR13.6 PR13.8 PR195 PR24.1 PR89.1
PRBA.1 TA175 TA195 TA199
UPDATED BY
PA95.1 PR116 PR16.1 HR00.1 HR01.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SGD-COMPANY Numeric 4 PA95.1 PR116
Company Contains the number that represents an PR16.1
established company and is entered on
all functions.
SGD-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.
SGD-EFFECT-DATE Numeric 8 (yyyymmdd) PA95.1 PR116
Effective Date Contains the date that the step and PR16.1
grade or the grade range schedule is
effective.
SGD-PAY-GRADE Alpha 3 PA95.1 PR116
Grade Contains the grade. PR16.1
SGD-PAY-STEP Numeric 2 PA95.1 PR116
Step Contains the step if this is a step and PR16.1
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.
SGD-GRADE-SEQ Numeric 4 PA95.1 PR116
Pay Grade Internal Contains the sequence number that keeps PR16.1
Sequence the grades in order. Grades are
alphanumeric but are not necessarily in
alphabetical order.
SGD-PAY-RATE Signed 13.4 PA95.1 PR116
Rate of Pay Contains the pay rate from the Employee PR16.1
file if using step and grade. If using a
grade range schedule, this is either the
minimum, midpoint, or maximum.
SGD-OLD-PAY-RATE Signed 13.4 PA95.1 PR116
Old Pay Rate Contains the old pay rate. When a PR16.1
change is made, the old pay rate
defaults into this field. This field is
not used with grade range schedules.
SGD-BASE-PAY-RATE Signed 13.4 PA95.1 PR116
Base Pay Rate Contains the pay rate in the company's PR16.1
base currency.
PRSAGDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SGDSET1 COMPANY AC541 AC542
SCHEDULE BN150 HCSC.1
EFFECT-DATE HR00.1 HR01.1
PAY-GRADE HR206 HR511
PAY-STEP HRCL.1 PA295
PA42.1 PA502
PA513 PA95.1
PR116 PR128
PR131 PR132
PR134 PR136
PR16.1 PR197
PR216 PR32.2
PR33.2 PR33.3
PR35.1 PR35.2
PR35.3 PR35.4
...
SGDSET2 COMPANY PA295 PA95.1
SCHEDULE PR116 PR16.1
EFFECT-DATE PR216
GRADE-SEQ
PAY-STEP
SGDSET3 COMPANY BN100 BN101
SCHEDULE BN102 BN103
PAY-GRADE BN105 BN145
PAY-STEP BN232 BN242
EFFECT-DATE* BN245 BN31.1
BN31.2 BN32.1
BN32.2 BN32.3
BN350 BN45.1
BN531 BN65.1
BN66.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 HR15.1
HR155 HR170
HR211 HR511
...
PRSAGDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
SGD-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Sag Head PRSAGHEAD Required
SGD-COMPANY -> SGH-COMPANY
"S" -> SGH-INDICATOR
SGD-SCHEDULE -> SGH-SCHEDULE
SGD-EFFECT-DATE -> SGH-EFFECT-DATE
Sag Head G PRSAGHEAD Not Required
SGD-COMPANY -> SGH-COMPANY
"G" -> SGH-INDICATOR
SGD-SCHEDULE -> SGH-SCHEDULE
SGD-EFFECT-DATE -> SGH-EFFECT-DATE
|
