UPG_BN_RATE_DTA (SQL Table)	Index Back
Benefit Rate Data This table holds the individual rates for a Benefits Rate Table ID. This includes all tax class components for rate amounts or percentages.

UPG_BN_RATE_DTA

(SQL Table)

Benefit Rate Data

This table holds the individual rates for a Benefits Rate Table ID. This includes all tax class components for rate amounts or percentages.

Parent record: BN_RATE_TBL

# 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.
Prompt Table: BN_RATE_TBL

2 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

3 BN_RATE_KEY01 Character(20) VARCHAR2(20) NOT NULL This field is used as a generic key into a benefits rate table. The key can take on different contexts depending on the Rate Type definition associated with the Rate Table.

4 BN_RATE_KEY02 Character(20) VARCHAR2(20) NOT NULL This field is used as a generic key into a benefits rate table. The key can take on different contexts depending on the Rate Type definition associated with the Rate Table.

5 BN_RATE_KEY03 Character(20) VARCHAR2(20) NOT NULL This field is used as a generic key into a benefits rate table. The key can take on different contexts depending on the Rate Type definition associated with the Rate Table.

6 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

7 SQL_TEXT1 Character(254) VARCHAR2(254) NOT NULL SQL Text 1

8 BN_EMPL_RATE Number(12,5) DECIMAL(11,5) NOT NULL This is used to define the Employee component of a benefit rate. The tax class assigned to this component (Before-tax or After-tax) is determined dynamically during the deduction calculation process based on the tax classes defined in the Deduction Code being processed.

9 BN_EMPLR_RATE Number(12,5) DECIMAL(11,5) NOT NULL This is used to define the Employer component of a benefit rate. The tax class assigned to this component (Before-tax or After-tax) is determined dynamically during the deduction calculation process based on the tax classes defined in the Deduction Code being processed.

10 BN_B_TAX_RATE Number(12,5) DECIMAL(11,5) NOT NULL This is used to specifically define the Before-tax (Employee) component of a benefit rate, when the rate will have individual tax classes defined for it.

11 BN_A_TAX_RATE Number(12,5) DECIMAL(11,5) NOT NULL This is used to specifically define the After-tax (Employee) component of a benefit rate, when the rate will have individual tax classes defined for it.

12 BN_N_TAX_RATE Number(12,5) DECIMAL(11,5) NOT NULL This is used to specifically define the Non-taxable (Employer) component of a benefit rate, when the rate will have individual tax classes defined for it.

13 BN_T_TAX_RATE Number(12,5) DECIMAL(11,5) NOT NULL This is used to specifically define the Taxable (Employer) component of a benefit rate, when the rate will have individual tax classes defined for it.

14 BN_P_TAX_RATE Number(12,5) DECIMAL(11,5) NOT NULL This is used to define the Non-Taxable Before-Tax Benefit component of a benefit rate

#	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. Prompt Table: BN_RATE_TBL
2	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
3	BN_RATE_KEY01	Character(20)	VARCHAR2(20) NOT NULL	This field is used as a generic key into a benefits rate table. The key can take on different contexts depending on the Rate Type definition associated with the Rate Table.
4	BN_RATE_KEY02	Character(20)	VARCHAR2(20) NOT NULL	This field is used as a generic key into a benefits rate table. The key can take on different contexts depending on the Rate Type definition associated with the Rate Table.
5	BN_RATE_KEY03	Character(20)	VARCHAR2(20) NOT NULL	This field is used as a generic key into a benefits rate table. The key can take on different contexts depending on the Rate Type definition associated with the Rate Table.
6	MESSAGE_NBR	Number(5,0)	INTEGER NOT NULL	Message Number. This field refers to the Message Number in the Message Catalog.
7	SQL_TEXT1	Character(254)	VARCHAR2(254) NOT NULL	SQL Text 1
8	BN_EMPL_RATE	Number(12,5)	DECIMAL(11,5) NOT NULL	This is used to define the Employee component of a benefit rate. The tax class assigned to this component (Before-tax or After-tax) is determined dynamically during the deduction calculation process based on the tax classes defined in the Deduction Code being processed.
9	BN_EMPLR_RATE	Number(12,5)	DECIMAL(11,5) NOT NULL	This is used to define the Employer component of a benefit rate. The tax class assigned to this component (Before-tax or After-tax) is determined dynamically during the deduction calculation process based on the tax classes defined in the Deduction Code being processed.
10	BN_B_TAX_RATE	Number(12,5)	DECIMAL(11,5) NOT NULL	This is used to specifically define the Before-tax (Employee) component of a benefit rate, when the rate will have individual tax classes defined for it.
11	BN_A_TAX_RATE	Number(12,5)	DECIMAL(11,5) NOT NULL	This is used to specifically define the After-tax (Employee) component of a benefit rate, when the rate will have individual tax classes defined for it.
12	BN_N_TAX_RATE	Number(12,5)	DECIMAL(11,5) NOT NULL	This is used to specifically define the Non-taxable (Employer) component of a benefit rate, when the rate will have individual tax classes defined for it.
13	BN_T_TAX_RATE	Number(12,5)	DECIMAL(11,5) NOT NULL	This is used to specifically define the Taxable (Employer) component of a benefit rate, when the rate will have individual tax classes defined for it.
14	BN_P_TAX_RATE	Number(12,5)	DECIMAL(11,5) NOT NULL	This is used to define the Non-Taxable Before-Tax Benefit component of a benefit rate