PRSAGDTL

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
BN150 PR521 EXI2.1 EXI4.1 LP130 LP140
PR128 PR130 PR131 PR132 PR134 PR135
PR136 PR137 PR189 PR29.1 PR32.1 PR32.2
PR33.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR37.1 PR45.1 PR529 PR530 PR560 PR582
PR80.1 PR80.4 PR82.1 UK102 UK560 TA147
BN100 BN101 BN102 BN103 BN105 BN145
BN245 BN31.1 BN31.2 BN32.1 BN32.2 BN32.3
BN320 BN45.1 BN531 BN65.1 BN66.1 BN71.1
BN72.1 BN729 BN991 BS13.1 BS14.1 BS15.1
BS32.1 HLTM.1 PA103 PA182 PA290 PR139
PR140 PR195 PR89.1 PRBA.1 TA146 TA175
TA195 TA199


UPDATED BY
PA95.1 PR110 PR116 PR16.1 BN305 HCDL.1
HCHP.1 HCSC.1 HR00.1 HR01.1 HR06.1 HR11.1
HR11.2 HR206 HR506 HR511 HRCL.1 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA295
PA42.1 PA42.3 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PA535 PR113 PR120 PR13.1
PR13.5 PR13.6 PR13.8 PR13.9 PR216 BN232
BN350 HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1
HPRS.1 HR15.1 HR155 HR156 HR170 HR211
HR515 HR54.1 HR55.2 HR70.1 HRS1.1 HRSC.1
HSGD.1 LP100 LP101 PA113 PA16.1 PA20.1
PA21.1 PA22.1 PA24.1 PA242 PA262 PA27.1
PA272 PA34.1 PA35.1 PA36.1 PA370 PA38.1
PA391 PA520 PA53.1 PA54.1 PA64.1 PA64.2
PA65.2 PA66.3 TR21.1 TR22.1 TR26.1 TR500
HS01.1 PR24.1 PR296 SNEM.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SGD-COMPANY
Element: Company Hr
Numeric 4
Contains the number that represents an established company and is entered on all functions.
PA95.1 PR116
PR16.1
SGD-SCHEDULE
Element: Schedule
Alpha 9
Contains 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
Element: 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
Element: Grade
Alpha 3
Contains the grade.
PA95.1 PR116
PR16.1
SGD-PAY-STEP
Element: Pay Step
Numeric 2
Contains 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
Element: Grade Seq
Numeric 4
Contains 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
Element: Pay Rate
Signed 13.4
Contains 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
Element: Pay Rate
Signed 13.4
Contains 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
Element: Pay Rate
Signed 13.4
Contains the pay rate in the company's base currency.
PA95.1 PR116
PR16.1


PRSAGDTL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SGDSET1 COMPANY
SCHEDULE
EFFECT-DATE
PAY-GRADE
PAY-STEP
...
BN150 BN305
HCDL.1 HCHP.1
HCSC.1 HR00.1
HR01.1 HR06.1
HR11.1 HR11.2
HR206 HR506
HR511 HRCL.1
PR521 EXI2.1
EXI4.1 LP130
LP140 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA295
PA42.1 PA42.3
PA502 PA513
SGDSET2 COMPANY
SCHEDULE
EFFECT-DATE
GRADE-SEQ
PAY-STEP
PA295 PA95.1
PR116 PR16.1
PR216
SGDSET3 COMPANY
SCHEDULE
PAY-GRADE
PAY-STEP
EFFECT-DATE*
...
BN100 BN101
BN102 BN103
BN105 BN145
BN150 BN232
BN245 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN350 BN45.1
BN531 BN65.1
BN66.1 BN71.1
BN72.1 BN729
BN991 BS13.1
BS14.1 BS15.1
BS32.1 HCDL.1


PRSAGDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:49:16 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.