PROGRATE FILE
This file contains the progressive pay rates based on rules.
REFERENCED BY
UK110 UK210 UK102
UPDATED BY
UK02.1 UK10.1 UK10.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGA-COMPANY Numeric 4 UK02.1 UK10.4
Company The company number represents an
established company and is entered on
all function codes.
PGA-REC-TYPE Alpha 1 UK02.1 UK10.4
Record Type Defines whether this is a progressive
pay rate record or a bonus accrual
record.
B = Bonus Pay
PGA-TABLE Alpha 10 UK02.1 UK10.4
Table Contains the user defined table
definition.
PGA-EFFECT-DATE Numeric 8 (yyyymmdd) UK02.1 UK10.4
Effective Date Contains the date this table is
effective.
PGA-PAY-GROUP-NAME Alpha 10 UK02.1 UK10.4
Pay Group Name Defines which employees are eligible
for the pay rate table. Can be different
than the employee group defined for
eligibility.
PGA-AMT-PCT Alpha 1 UK10.4
Amt Pct Defines if the rates being entered are
amounts of percents. An amount is an
actual rate of pay. If a percent is
entered, the system performs a
calculation to determine the current
rate of pay.
A = Amount
P = Percent
PGA-FROM-DATE Alpha 2 UK02.1 UK10.4
From Date Contains the point at which the system
starts determining which pay level the
employee is at.
HI = Hire Date
AJ = Adjusted Hire Date
AN = Anniversary Date
SN = Seniority Date
X = Custom Calculation
PGA-FROM-UNITS-DSP Numeric 5 UK02.1 UK10.4
From Units Dsp Contains the number of units.
PGA-FROM-UNITS Numeric 8 UK02.1 UK10.4
From Units If different unit types are defined,
the units are converted to the lowest
common denominator and stored here. This
is used to display units in their proper
order.
PGA-FROM-UNIT-TYPE Alpha 1 UK02.1 UK10.4
From Unit Type Contains the type of units.
H = Hours
D = Days
M = Months
PGA-TO-UNITS-DSP Numeric 5
To Units Dsp Not used at this time.
PGA-TO-UNITS Numeric 8
To Units Not used at this time.
PGA-TO-UNIT-TYPE Alpha 1
To Unit Type Not used at this time.
H = Hours
D = Days
M = Months
PGA-PAY-CLASS Alpha 3 UK10.4
Payment Class Contains the pay class entered to
select specific types of hours to be
used in determining eligibility.
PGA-RATE Signed 13.4 UK10.4
Rate Contains the percentage rate.
PGA-BONUS-RATE Signed 13.4 UK02.1
Bonus Rate Contains the rate to be used to
calculate the bonus accrual amount.
PGA-CURRENCY-CODE Alpha 5
Currency Code This field contains the company base
currency code established in Company
(GL10.1 ).
PGA-CURR-ND Numeric 1
Currency Number of Represents the number of decimals
Decimals defined for the currency of the object.
PROGRATE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGASET1 COMPANY UK02.1 UK10.1
REC-TYPE UK10.4 UK110
TABLE UK210
EFFECT-DATE
PAY-GROUP-NAME
FROM-UNITS
PGASET2 COMPANY UK102 UK110
REC-TYPE
TABLE
EFFECT-DATE
PAY-GROUP-NAME
FROM-UNITS*
PROGRATE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
PGA-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Pay Class PAYCLASS Required
PGA-COMPANY -> PCL-COMPANY
PGA-PAY-CLASS -> PCL-PAY-CLASS
Pay Emp Group PERSGROUP Required
PGA-COMPANY -> PRG-COMPANY
PGA-PAY-GROUP-NAME -> PRG-GROUP-NAME
Progpay PROGPAY Required
PGA-COMPANY -> PGP-COMPANY
PGA-REC-TYPE -> PGP-REC-TYPE
PGA-TABLE -> PGP-TABLE
PGA-EFFECT-DATE -> PGP-EFFECT-DATE
|
