GPUS_BN_RATE_VW (SQL View)	Index Back
GPUS Benefit Rate Data This view holds the individual rates for a Benefits Rate Table ID

GPUS_BN_RATE_VW

(SQL View)

GPUS Benefit Rate Data

This view holds the individual rates for a Benefits Rate Table ID

SELECT RATE_TBL_ID , EFFDT , BN_RATE_KEY01 , BN_RATE_KEY02 , %Sql(HR_CHARTOINT,%COALESCE(%TrimSubstr(BN_RATE_KEY03,1,20),'0')) , BN_EMPL_RATE , BN_EMPLR_RATE FROM PS_BN_RATE_DATA WHERE BN_RATE_KEY03 <> ' '

# 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

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 AGE Number(3,0) SMALLINT NOT NULL Age

6 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.

7 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.

#	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
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	AGE	Number(3,0)	SMALLINT NOT NULL	Age
6	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.
7	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.