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
BN100 BN101 BN102 BN103 BN105 BN145
BN150 BN245 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN320 BN45.1 BN531 BN65.1 BN66.1
BN71.1 BN72.1 BS13.1 BS14.1 BS15.1 BS32.1
ZB10.1 ZB31.1 ZB31.2 ZB32.1 ZB32.2 ZB32.3
HLTM.1 PR521 EXI2.1 EXI4.1 LP130 LP198
PA103 PA182 PA290 PR128 PR130 PR131
PR132 PR134 PR135 PR136 PR137 PR139
PR140 PR189 PR195 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 PR89.1 UK102 UK560
ZP530 TA146 TA147 TA175 TA195 TA199
HCHP.1 HRCL.1 HSGD.1 PRBA.1 SNEM.1


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

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 HR28.1
HR506 HR511
HRCL.1 LT101
PR521 ZH230
ZH510 EXI2.1
EXI4.1 LP130
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA295 PA42.1
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 BS13.1
BS14.1 BS15.1
BS32.1 ZB10.1
ZB31.1 ZB31.2


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 11:15:30 2016

Home
Contact Us



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