UPG_BN_RATES (SQL Table)	Index Back
Upgrade: Benefits Rates This is an upgrade work record used for converting benefit rates from the four existing individual rate tables into the new consolidated rate architecture for HCM 9.

UPG_BN_RATES

(SQL Table)

Upgrade: Benefits Rates

This is an upgrade work record used for converting benefit rates from the four existing individual rate tables into the new consolidated rate architecture for HCM 9.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RATE_TBL_ID Character(6) VARCHAR2(6) NOT NULL This is used as the record key that identifies a specific set of benefit rates.

2 RATE_TYPE Character(4) VARCHAR2(4) NOT NULL This is used to identify the type of benefit rate in use - the keys, usage, and high-level attributes the govern how a rate behaves.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RATE_TBL_ID	Character(6)	VARCHAR2(6) NOT NULL	This is used as the record key that identifies a specific set of benefit rates.
2	RATE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	This is used to identify the type of benefit rate in use - the keys, usage, and high-level attributes the govern how a rate behaves.