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
HAP3.1 HCRE.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR06.1 HR15.1 HR155 HR156 HR170 HR206
HR506 HR515 HR54.1 HR55.2 HR70.1 HRS1.1
HRSC.1 HSGD.1 ZH156 LP100 LP101 PA16.1
PA20.1 PA21.1 PA22.1 PA24.1 PA242 PA27.1
PA295 PA311 PA34.1 PA35.1 PA36.1 PA38.1
PA520 PA54.1 TR21.1 TR22.1 TR26.1 TR500
HS01.1 BN100 BN101 BN102 BN103 BN105
BN145 BN150 BN232 BN245 BN31.1 BN31.2
BN32.1 BN32.2 BN32.3 BN320 BN45.1 BN531
BN65.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 HCDL.1 HCEM.1 HCSC.1
HR211 HRCL.1 HSGH.1 PR521 ZH230 EXI2.1
EXI4.1 PA103 PA202 PA290 PA360 PA42.1
PA42.3 PA535 ZE532 PR128 PR131 PR132
PR134 PR135 PR136 PR137 PR189 PR216
PR24.1 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 PR36.4 PR37.1
PR45.1 PR529 PR530 PR560 PR582 PR80.1
PR80.4 PR82.1 PR89.1 UK102 TA147


UPDATED BY
PA95.1 PR110 PR116 PR16.1 BN305 HR00.1
HR01.1 HR11.1 HR11.2 HR11.4 HR28.1 HR511
LT101 LT111 ZH510 PA02.1 PA100 PA102
PA115 PA13.1 PA13.2 PA502 PA513 PA52.1
PA52.3 PA52.4 PA52.5 PR113 PR12.6 PR120
PR13.1 PR13.5 PR13.6 PR13.8 PR13.9 PR30.2
PR512 LP130 LP198

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
SGH-ACTIVE-FLAG
Element: Numeric Flag
Numeric 1

1 = Active
2 = Inactive
PA95.1 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
HR11.4 HR15.1
HR155 HR156
HR170 HR206
HR28.1 HR506
HR511 HR515
HR54.1 HR55.2
HR70.1 HRS1.1
HRSC.1 HSGD.1
LT101 LT111
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 BS10.1
BS12.1 BS13.1
BS14.1 BS15.1
BS32.1 ZB10.1
ZB31.1 ZB31.2
SGHSET3 COMPANY
EFFECT-DATE*
INDICATOR
SCHEDULE
Subset
WhereSTATUS =Zeroes
OrSTATUS =1
PR110 PR32.1
PR32.2 PR35.1
PR35.2 PR36.1
PR36.4


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 02:16:55 2016

Home
Contact Us



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