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
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. |
|
||||
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 |
|
||||
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. |
|
||||
SGH-EFFECT-DATE Element: Effect Date | Numeric 8 (yyyymmdd) Contains the date when the step and grade or grade range schedule goes into effect. |
|
||||
SGH-DESCRIPTION Element: Description | Alpha 30 (Lower Case) Contains the user-defined description of the schedule. |
|
||||
SGH-SALARY-CLASS Element: Salary Class | Alpha 1 Indicates if the table is used for salaried or hourly schedules. H = Hourly S = Salaried |
|
||||
SGH-LST-GRADE-SEQ Element: Lst Grade Seq | Numeric 4 Contains the last number used for a grade sequence number in the detail file. |
|
||||
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 |
|
||||
SGH-STATUS-1 Element: Status 1 | Derived |
|
||||
SGH-CURRENCY-CODE Element: Currency Code | Alpha 5 Contains the currency in which the salary is recorded. |
|
||||
SGH-CURR-ND Element: Acct Nd | Numeric 1 The number of decimals assigned to a particular account as determined by the account currency. |
|
||||
SGH-BASE-CURRENCY Element: Base Currency | Alpha 5 Contains the company base currency. |
|
||||
SGH-BASE-ND Element: Base Nd | Numeric 1 The number of decimal positions defined for the company base currency. |
|
||||
SGH-ACTIVE-FLAG Element: Numeric Flag | Numeric 1 1 = Active 2 = Inactive |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SGHSET1 |
COMPANY INDICATOR SCHEDULE EFFECT-DATE |
|
|||||||||||||||||||||||||||
SGHSET2 |
COMPANY INDICATOR SCHEDULE EFFECT-DATE* |
|
|||||||||||||||||||||||||||
SGHSET3 |
COMPANY EFFECT-DATE* INDICATOR SCHEDULE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
Base Currency | CUCODES |
Required
| |||||||||
Company | PRSYSTEM |
Required
| |||||||||
Currency | CUCODES |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Employees | PATHFIND |
| |||||||||||||||
Rate | PRSAGDTL |
|
All trademarks and registered trademarks are the property of their
respective owners.