This file contains the table name, effective dates, and rules for eligibility.
REFERENCED BY
UK52.1 | PA50.1 |
UK02.1 | UK10.1 | UK102 | UK110 | UK210 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
---|---|---|---|---|
PGP-COMPANY Element: Company Hr | Numeric 4 |
|
||
PGP-REC-TYPE Element: Rec Type | Alpha 1 Defines whether this is a progressive pay rate record or a bonus accrual record. B = Bonus Pay |
|
||
PGP-TABLE Element: Table | Alpha 10 User defined table definition. |
|
||
PGP-DESCRIPTION Element: Description | Alpha 30 (Lower Case) Contains a further description of the table. |
|
||
PGP-EFFECT-DATE Element: Effect Date | Numeric 8 (yyyymmdd) Contains the date this table is effective. |
|
||
PGP-END-DATE Element: End Date | Numeric 8 (yyyymmdd) The end date for this effort period. |
|
||
PGP-ACTION-CODE Element: Action Code | Alpha 10 This field contains the personnel action code. |
|
||
PGP-GROUP-NAME Element: Group Name | Alpha 10 Defines which group of employees is eligible for this table. |
|
||
PGP-SALARY-CLASS Element: Salary Class | Alpha 1 Further defines which employees are eligible for this table. Also defines if the rates entered are hourly or salary amounts. H = Hourly S = Salaried |
|
||
PGP-ENT-FROM-DATE Element: Ent From Date | Alpha 2 Defines the date or the starting point from which other eligibility criteria may be used to determine if the employee is eligible for this table. HI = Hire Date AJ = Adjusted Hire Date AN = Anniversary Date SN = Seniority Date X = Custom Calculation |
|
||
PGP-ENT-UNITS Element: Ent Units | Numeric 5 Contains the number of units. |
|
||
PGP-ENT-UNITS-TYPE Element: Ent Units Type | Alpha 1 Contains the type of units entered. H = Hours D = Days M = Months |
|
||
PGP-ENT-PAY-CLASS Element: Ent Pay Class | Alpha 3 Contains the pay class entered to select specific types of hours to be used in determining eligibility. |
|
||
PGP-ENT-POINT-TYPE Element: Ent Point Type | Numeric 1 Defines which entry point is used to determine eligibility. 0 = None 1 = Prior entry point 2 = Next entry point 3 = Prior pay period 4 = Next pay period 5 = Prior work period 6 = Next work period |
|
||
PGP-END-FROM-DATE Element: End From Date | Alpha 2 Defines the starting point from which other criteria may be used to determine when the eligibility for this table ends. HI = Hire Date AJ = Adjusted Hire Date AN = Anniversary Date SN = Seniority Date X = Custom Calculation |
|
||
PGP-END-UNITS Element: End Units | Numeric 5 Contains the number of units. |
|
||
PGP-END-UNITS-TYPE Element: End Units Type | Alpha 1 Defines the type of units entered. H = Hours D = Days M = Months |
|
||
PGP-END-PAY-CLASS Element: End Pay Class | Alpha 3 Contains the pay class entered to select specific types of hours to be used in determining eligibility. |
|
||
PGP-END-POINT-TYPE Element: End Point Type | Numeric 1 Defines which entry point is used to determines eligibility. 0 = None 1 = Prior entry point 2 = Next entry point 3 = Prior pay period 4 = Next pay period 5 = Prior work period 6 = Next work period |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PGPSET1 |
COMPANY REC-TYPE TABLE EFFECT-DATE |
|
| ||||||||||||||
PGPSET2 |
COMPANY GROUP-NAME REC-TYPE TABLE EFFECT-DATE END-DATE |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Action | PERSACTYPE |
Required
| ||||||
Company | PRSYSTEM |
Required
| ||||||
Employee Group | PERSGROUP |
Required
| ||||||
End Pay Class | PAYCLASS |
Required
| ||||||
Ent Pay Class | PAYCLASS |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Progpayend | PROGPAYEND |
Delete Cascades
| ||||||||||||||||||
Progpayent | PROGPAYENT |
Delete Cascades
| ||||||||||||||||||
Prograte | PROGRATE |
|
All trademarks and registered trademarks are the property of their
respective owners.