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 BN305 HCDL.1 HCHP.1 HCSC.1 HR06.1
HR11.1 HR11.2 HR11.4 HR206 HR28.1 HR506
HR511 HRCL.1 LT101 LT111 PR521 ZH230
ZH510 EXI2.1 EXI4.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 ZE532 PR113 PR12.6 PR120 PR128
PR13.1 PR13.5 PR13.6 PR13.8 PR13.9 PR131
PR132 PR134 PR135 PR136 PR137 PR189
PR216 PR29.1 PR30.2 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 PR36.4
PR37.1 PR45.1 PR512 PR529 PR530 PR560
PR582 PR80.1 PR80.4 PR82.1 UK102 TA147
BN100 BN101 BN102 BN103 BN105 BN145
BN232 BN245 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN320 BN350 BN45.1 BN531 BN65.1
BN66.1 BN71.1 BN72.1 BS10.1 BS12.1 BS13.1
BS14.1 BS15.1 BS32.1 ZB10.1 ZB31.1 ZB31.2
ZB32.1 ZB32.2 ZB32.3 HAP3.1 HCRE.1 HEP4.1
HLTM.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 LT11.5 LT13.5
ZH156 LP100 LP101 PA103 PA113 PA16.1
PA182 PA20.1 PA21.1 PA22.1 PA24.1 PA242
PA262 PA27.1 PA272 PA290 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 PR139 PR140
PR195 PR24.1 PR296 PR89.1 PRAT.1 PRBA.1
ZP139 ZP296 ZP554 SNEM.1 TA175


UPDATED BY
PA95.1 PR110 PR116 PR16.1 HR00.1 HR01.1
LP130 LP198

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
HR11.4 HR206
HR28.1 HR506
HR511 HRCL.1
LT101 LT111
PR521 ZH230
ZH510 EXI2.1
EXI4.1 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
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 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB10.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: Thu Jun 09 02:16:55 2016

Home
Contact Us



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