PRSAGHEAD

Step & Grade Schedule Header

The Step and Grade Schedule Header file stores the type and description of the schedule. The system creates a record for each schedule and each effective date. The header file of a schedule can have many associated detail records. These header and detail files are used with both step and grade and grade range schedules.

REFERENCED BY
BN150 BN305 HCDL.1 HCEM.1 HAP3.1 HCRE.1
HEP4.1 HPOS.1 HPQC.1 HPRS.1 HR15.1 HR155
HR156 HR170 HR28.1 HR515 HR54.1 HR55.2
HR70.1 HRS1.1 HRSC.1 PR521 ZH156 ZH510
EXI2.1 EXI4.1 LP100 LP101 LP130 LP198
PA115 PA16.1 PA20.1 PA21.1 PA22.1 PA24.1
PA27.1 PA311 PA34.1 PA35.1 PA36.1 PA38.1
PA520 PA54.1 TR21.1 TR22.1 TR26.1 TR500
ZE521 ZE540 PR113 PR12.6 PR120 PR128
PR13.1 PR13.5 PR13.6 PR13.8 PR13.9 PR130
PR131 PR132 PR134 PR135 PR136 PR137
PR189 PR29.1 PR30.2 PR33.1 PR33.2 PR33.3
PR37.1 PR45.1 PR529 PR530 PR560 PR582
PR80.1 PR80.4 PR82.1 PR89.1 UK102 UK560
ZP530 TA147 HSGD.1 HRCL.1 HSGH.1


UPDATED BY
BN100 BN101 BN102 BN103 BN105 BN145
BN232 BN245 BN31.1 BN31.2 BN32.1 BN32.2
BN32.3 BN320 BN45.1 BN531 BN65.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 HCSC.1
HR00.1 HR01.1 HR06.1 HR11.1 HR11.2 HR206
HR211 HR506 HR511 LT101 ZH230 PA02.1
PA100 PA102 PA103 PA13.1 PA13.2 PA202
PA242 PA290 PA295 PA360 PA42.1 PA42.3
PA502 PA513 PA52.1 PA52.4 PA52.5 PA535
PA95.1 ZE531 ZE532 HS01.1 PR110 PR116
PR16.1 PR216 PR24.1 PR32.1 PR32.2 PR35.1
PR35.2 PR36.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SGH-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
SGH-INDICATOR
Element: Indicator
Alpha 1
Indicates whether this schedule is a step and grade schedule or a grade range schedule. You cannot use the same schedule name for both kinds of schedules.
G = Grade Range
S = Step and Grade
PA95.1 PR116
PR16.1
SGH-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
SGH-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the date when the step and grade or grade range schedule goes into effect.
PA95.1 PR116
PR16.1
SGH-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
Contains the user-defined description of the schedule.
PA311 PA95.1
PR116 PR16.1
SGH-SALARY-CLASS
Element: Salary Class
Alpha 1
Indicates if the table is used for salaried or hourly schedules.
H = Hourly
S = Salaried
PA95.1 PR116
PR16.1
SGH-LST-GRADE-SEQ
Element: Lst Grade Seq
Numeric 4
Contains the last number used for a grade sequence number in the detail file.
PA95.1 PR116
PR16.1
SGH-STATUS
Element: Status
Numeric 1
Contains the status of a given transaction.
0 = New schedule - must run PR110
1 = Changed schedule - Run PR110
2 = Current schedule - Updated
3 = No longer in use - History
5 = Grade Range Schedule
PA95.1 PR110
PR116 PR16.1
SGH-STATUS-1
Element: Status 1
Derived
SGH-CURRENCY-CODE
Element: Currency Code
Alpha 5
Contains the currency in which the salary is recorded.
PA95.1 PR116
PR16.1
SGH-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
PA95.1 PR116
PR16.1
SGH-BASE-CURRENCY
Element: Base Currency
Alpha 5
Contains the company base currency.
PA95.1 PR116
PR16.1
SGH-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
PA95.1 PR116
PR16.1


PRSAGHEAD FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SGHSET1 COMPANY
INDICATOR
SCHEDULE
EFFECT-DATE
...
BN305 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 HR28.1
HR506 HR511
HR515 HR54.1
HR55.2 HR70.1
HRS1.1 HRSC.1
HSGD.1 LT101
ZH156 ZH510
SGHSET2 COMPANY
INDICATOR
SCHEDULE
EFFECT-DATE*
...
BN100 BN101
BN102 BN103
BN105 BN145
BN150 BN232
BN245 BN305
BN31.1 BN31.2
BN32.1 BN32.2
BN32.3 BN320
BN45.1 BN531
BN65.1 BN71.1
BN72.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
ZB32.1 ZB32.2
SGHSET3 COMPANY
EFFECT-DATE*
INDICATOR
SCHEDULE
Subset
WhereSTATUS =Zeroes
OrSTATUS =1
PR110 PR32.1
PR32.2 PR35.1
PR35.2 PR36.1


PRSAGHEAD FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Base Currency CUCODES Required
When (SGH-CURRENCY-CODE !=Spaces )
SGH-BASE-CURRENCY->CUC-CURRENCY-CODE
Company PRSYSTEM Required
SGH-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Currency CUCODES Required
When (SGH-CURRENCY-CODE !=Spaces )
SGH-CURRENCY-CODE->CUC-CURRENCY-CODE


PRSAGHEAD FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Employees PATHFIND
SGH-COMPANY->PTF-COMPANY
136->PTF-FLD-NBR
SGH-SCHEDULE->PTF-FLD-VALUE
  PTF-EMPLOYEE
  PTF-POS-LEVEL
Rate PRSAGDTL
SGH-COMPANY->SGD-COMPANY
SGH-SCHEDULE->SGD-SCHEDULE
SGH-EFFECT-DATE->SGD-EFFECT-DATE
  SGD-PAY-GRADE
  SGD-PAY-STEP


File created: Thu Jun 09 11:15:30 2016

Home
Contact Us



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