PROGPAY FILE
This file contains the table name, effective dates, and rules for eligibility.
REFERENCED BY
PA50.1 UK102 UK110 UK210 UK52.1
UPDATED BY
UK02.1 UK10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGP-COMPANY Numeric 4 UK02.1 UK10.1
Company The company number represents an
established company and is entered on
all function codes.
PGP-REC-TYPE Alpha 1 UK02.1 UK10.1
Record Type Defines whether this is a progressive
pay rate record or a bonus accrual
record.
B = Bonus Pay
PGP-TABLE Alpha 10 UK02.1 UK10.1
Table User defined table definition.
PGP-DESCRIPTION Alpha 30 (Lower Case) UK02.1 UK10.1
Description Contains a further description of the
table.
PGP-EFFECT-DATE Numeric 8 (yyyymmdd) UK02.1 UK10.1
Effective Date Contains the date this table is
effective.
PGP-END-DATE Numeric 8 (yyyymmdd) UK02.1 UK10.1
Ending Date The ending date in a range of dates.
PGP-ACTION-CODE Alpha 10 UK10.1
Action Code This field contains the personnel
action code.
PGP-GROUP-NAME Alpha 10 UK02.1 UK10.1
Group Name Defines which group of employees is
eligible for this table.
PGP-SALARY-CLASS Alpha 1 UK10.1
Salary Class 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 Alpha 2 UK10.1
Ent From Date 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 Numeric 5 UK10.1
Ent Units Contains the number of units.
PGP-ENT-UNITS-TYPE Alpha 1 UK10.1
Ent Units Type Contains the type of units entered.
H = Hours
D = Days
M = Months
PGP-ENT-PAY-CLASS Alpha 3 UK10.1
Ent Pay Class Contains the pay class entered to
select specific types of hours to be
used in determining eligibility.
PGP-ENT-POINT-TYPE Numeric 1 UK10.1
Ent Point Type 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 Alpha 2 UK10.1
End From Date 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 Numeric 5 UK10.1
End Units Contains the number of units.
PGP-END-UNITS-TYPE Alpha 1 UK10.1
End Units Type Defines the type of units entered.
H = Hours
D = Days
M = Months
PGP-END-PAY-CLASS Alpha 3 UK10.1
End Pay Class Contains the pay class entered to
select specific types of hours to be
used in
determining eligibility.
PGP-END-POINT-TYPE Numeric 1 UK10.1
End Point Type 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
PROGPAY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGPSET1 COMPANY PA50.1 UK02.1
REC-TYPE UK10.1 UK10.4
TABLE UK102 UK110
EFFECT-DATE UK210 UK52.1
PGPSET2 COMPANY KeyChange
GROUP-NAME
REC-TYPE
TABLE
EFFECT-DATE
END-DATE
PROGPAY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Action PERSACTYPE Required
PGP-COMPANY -> PAT-COMPANY (PATSET1)
PGP-ACTION-CODE -> PAT-ACTION-CODE
Company PRSYSTEM Required
PGP-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Employee Group PERSGROUP Required
PGP-COMPANY -> PRG-COMPANY
PGP-GROUP-NAME -> PRG-GROUP-NAME
End Pay Class PAYCLASS Required
PGP-COMPANY -> PCL-COMPANY
PGP-END-PAY-CLASS -> PCL-PAY-CLASS
Ent Pay Class PAYCLASS Required
PGP-COMPANY -> PCL-COMPANY
PGP-ENT-PAY-CLASS -> PCL-PAY-CLASS
PROGPAY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Progpayend PROGPAYEND Delete Cascades
PGP-COMPANY -> PED-COMPANY
PGP-TABLE -> PED-TABLE
PGP-EFFECT-DATE -> PED-EFFECT-DATE
PED-ENDING-DATE
Progpayent PROGPAYENT Delete Cascades
PGP-COMPANY -> PET-COMPANY
PGP-TABLE -> PET-TABLE
PGP-EFFECT-DATE -> PET-EFFECT-DATE
PET-ENTRY-DATE
Prograte PROGRATE
PGP-COMPANY -> PGA-COMPANY
PGP-REC-TYPE -> PGA-REC-TYPE
PGP-TABLE -> PGA-TABLE
PGP-EFFECT-DATE -> PGA-EFFECT-DATE
PGA-PAY-GROUP-NAME
PGA-FROM-UNITS
|
