PROGRATE

This file contains the progressive pay rates based on rules.
UPDATED BY
UK02.1 UK10.1 UK10.4 UK110 UK210 UK102

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PGA-COMPANY
Element: Company Hr		Numeric 4
UK02.1 UK10.4
PGA-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.4
PGA-TABLE
Element: Table		Alpha 10
Contains the user defined table definition.
UK02.1 UK10.4
PGA-EFFECT-DATE
Element: Effect Date		Numeric 8 (yyyymmdd)
Contains the date this table is effective.
UK02.1 UK10.4
PGA-PAY-GROUP-NAME
Element: Pay Group Name		Alpha 10
Defines which employees are eligible for the pay rate table. Can be different than the employee group defined for eligibility.
UK02.1 UK10.4
PGA-AMT-PCT
Element: Amt Pct		Alpha 1
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
UK10.4
PGA-FROM-DATE
Element: From Date		Alpha 2
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
UK02.1 UK10.4
PGA-FROM-UNITS-DSP
Element: From Units Dsp		Numeric 5
Contains the number of units.
UK02.1 UK10.4
PGA-FROM-UNITS
Element: From Units		Numeric 8
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.
UK02.1 UK10.4
PGA-FROM-UNIT-TYPE
Element: From Unit Type		Alpha 1
Contains the type of units.
H = Hours
D = Days
M = Months
UK02.1 UK10.4
PGA-TO-UNITS-DSP
Element: To Units Dsp		Numeric 5
Not used at this time.
PGA-TO-UNITS
Element: To Units		Numeric 8
Not used at this time.
PGA-TO-UNIT-TYPE
Element: To Unit Type		Alpha 1
Not used at this time.
H = Hours
D = Days
M = Months
PGA-PAY-CLASS
Element: Pay Class		Alpha 3
Contains the pay class entered to select specific types of hours to be used in determining eligibility.
UK10.4
PGA-RATE
Element: Rate		Signed 13.4
Contains the percentage rate.
UK10.4
PGA-BONUS-RATE
Element: Bonus Rate		Signed 13.4
Contains the rate to be used to calculate the bonus accrual amount.
UK02.1
PGA-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
PGA-CURR-ND
Element: Acct Nd		Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.


PROGRATE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PGASET1 COMPANY
REC-TYPE
TABLE
EFFECT-DATE
PAY-GROUP-NAME
FROM-UNITS
UK02.1 UK10.1
UK10.4 UK110
UK210
PGASET2 COMPANY
REC-TYPE
TABLE
EFFECT-DATE
PAY-GROUP-NAME
FROM-UNITS*
UK10.4 UK102
UK110


PROGRATE FILE RELATIONS


ONE TO ONE RELATIONS

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

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

Home
Contact Us



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