PROGPAY

This file contains the table name, effective dates, and rules for eligibility.

REFERENCED BY
UK52.1


UPDATED BY
UK02.1 UK10.1 PA50.1 UK102 UK110 UK210

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGP-COMPANY
Element: Company Hr
Numeric 4
UK02.1 UK10.1
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
UK02.1 UK10.1
PGP-TABLE
Element: Table
Alpha 10
User defined table definition.
UK02.1 UK10.1
PGP-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
Contains a further description of the table.
UK02.1 UK10.1
PGP-EFFECT-DATE
Element: Effect Date
Numeric 8 (yyyymmdd)
Contains the date this table is effective.
UK02.1 UK10.1
PGP-END-DATE
Element: End Date
Numeric 8 (yyyymmdd)
The end date for this effort period.
UK02.1 UK10.1
PGP-ACTION-CODE
Element: Action Code
Alpha 10
This field contains the personnel action code.
UK10.1
PGP-GROUP-NAME
Element: Group Name
Alpha 10
Defines which group of employees is eligible for this table.
UK02.1 UK10.1
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
UK10.1
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
UK10.1
PGP-ENT-UNITS
Element: Ent Units
Numeric 5
Contains the number of units.
UK10.1
PGP-ENT-UNITS-TYPE
Element: Ent Units Type
Alpha 1
Contains the type of units entered.
H = Hours
D = Days
M = Months
UK10.1
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.
UK10.1
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
UK10.1
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
UK10.1
PGP-END-UNITS
Element: End Units
Numeric 5
Contains the number of units.
UK10.1
PGP-END-UNITS-TYPE
Element: End Units Type
Alpha 1
Defines the type of units entered.
H = Hours
D = Days
M = Months
UK10.1
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.
UK10.1
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
UK10.1


PROGPAY FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGPSET1 COMPANY
REC-TYPE
TABLE
EFFECT-DATE
PA50.1 UK02.1
UK10.1 UK10.4
UK102 UK110
UK210 UK52.1
PGPSET2 COMPANY
GROUP-NAME
REC-TYPE
TABLE
EFFECT-DATE
END-DATE
KeyChange


PROGPAY FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Wed Jun 08 20:51:11 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.