|
|
PROGPAY FILE
UK Progressive Pay Table
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 = User Exit
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 eligibilty.
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 = User Exit
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 eligibilty.
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, Duplicates
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
|