|
|
PRSAGHEAD FILE
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
BN305 HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR06.1 HR11.1 HR11.2 HR15.1 HR155 HR170
HR206 HR506 HR511 HR515 HR54.1 HR55.2
HR70.1 HRS1.1 HRSC.1 HSGD.1 LP100 LP101
PA02.1 PA100 PA102 PA115 PA13.1 PA13.2
PA16.1 PA20.1 PA21.1 PA22.1 PA24.1 PA242
PA27.1 PA295 PA311 PA34.1 PA35.1 PA36.1
PA38.1 PA502 PA513 PA52.1 PA52.3 PA52.4
PA52.5 PA520 PA54.1 TR21.1 TR22.1 TR26.1
TR500 HS01.1 PR113 PR120 PR13.1 PR13.5
PR13.6 PR13.8 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 BS13.1 BS14.1
BS15.1 BS32.1 ET530 ETI2.1 HCDL.1 HCEM.1
HCSC.1 HR211 HRCL.1 HSGH.1 LP130 LP198
PA103 PA202 PA290 PA360 PA42.1 PA42.3
PA535 PR128 PR130 PR131 PR132 PR134
PR136 PR189 PR216 PR24.1 PR29.1 PR32.2
PR32.1 PR33.2 PR33.3 PR35.1 PR35.2 PR35.3
PR35.4 PR35.5 PR35.6 PR35.8 PR35.9 PR36.1
PR45.1 PR529 PR530 PR560 PR80.1 PR82.1
PR89.1 UK102 UK560 TA147
UPDATED BY
PA95.1 PR110 PR116 PR16.1 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SGH-COMPANY Numeric 4 PA95.1 PR116
Element: Company Hr Contains the number that represents an PR16.1
established company and is entered on
all functions.
SGH-INDICATOR Alpha 1 PA95.1 PR116
Element: Indicator Indicates whether this schedule is a PR16.1
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
SGH-SCHEDULE Alpha 9 PA95.1 PR116
Element: Schedule Contains a set of steps and grades for PR16.1
a step and grade schedule, or a set of
grades and minimum, midpoint, and
maximum values for a grade range
schedule.
SGH-EFFECT-DATE Numeric 8 (yyyymmdd) PA95.1 PR116
Element: Effect Date Contains the date when the step and PR16.1
grade or grade range schedule goes into
effect.
SGH-DESCRIPTION Alpha 30 (Lower Case) PA311 PA95.1
Element: Description Contains the user-defined description PR116 PR16.1
of the schedule.
SGH-SALARY-CLASS Alpha 1 PA95.1 PR116
Element: Salary Class Indicates if the table is used for PR16.1
salaried or hourly schedules.
H = Hourly
S = Salaried
SGH-LST-GRADE-SEQ Numeric 4 PA95.1 PR116
Element: Lst Grade Seq Contains the last number used for a PR16.1
grade sequence number in the detail
file.
SGH-STATUS Numeric 1 PA95.1 PR110
Element: Status Contains the status of a given PR116 PR16.1
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
SGH-STATUS-1 Derived
Element: Status 1
SGH-CURRENCY-CODE Alpha 5 PA95.1 PR116
Element: Currency Code Contains the currency in which the PR16.1
salary is recorded.
SGH-CURR-ND Numeric 1 PA95.1 PR116
Element: Acct Nd The number of decimals assigned to a PR16.1
particular account as determined by the
account currency.
SGH-BASE-CURRENCY Alpha 5 PA95.1 PR116
Element: Base Currency Contains the company base currency. PR16.1
SGH-BASE-ND Numeric 1 PA95.1 PR116
Element: Base Nd The number of decimal positions defined PR16.1
for the company base currency.
PRSAGHEAD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SGHSET1 COMPANY BN305 HAP3.1
INDICATOR HEP4.1 HPOS.1
SCHEDULE HPQC.1 HPRS.1
EFFECT-DATE HR00.1 HR01.1
HR06.1 HR11.1
HR11.2 HR15.1
HR155 HR170
HR206 HR506
HR511 HR515
HR54.1 HR55.2
HR70.1 HRS1.1
HRSC.1 HSGD.1
LP100 LP101
PA02.1 PA100
PA102 PA115
...
SGHSET2 COMPANY BN100 BN101
INDICATOR BN102 BN103
SCHEDULE BN105 BN145
EFFECT-DATE* 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 ET530
ETI2.1 HCDL.1
HCEM.1 HCSC.1
...
SGHSET3 COMPANY Subset PR110 PR32.1
EFFECT-DATE* Where STATUS = Zeroes PR32.2 PR35.1
INDICATOR Or STATUS = 1 PR35.2 PR36.1
SCHEDULE
PRSAGHEAD FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME 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
|
