BN_PGMRATE_VW (SQL View)	Index Back
Benefit Rate Prompt This view is used in the Benefit Program Definition component as a prompt for a Benefit Rate ID, specifically when the Rate Type is such that the Rate usage is "Percent of Base". It filters its results by the Rate Type selected. Note that in this prompt the Currency used by the Program is not considered, since percent-based rates do not have a concept of currency.

BN_PGMRATE_VW

(SQL View)

Benefit Rate Prompt

This view is used in the Benefit Program Definition component as a prompt for a Benefit Rate ID, specifically when the Rate Type is such that the Rate usage is "Percent of Base". It filters its results by the Rate Type selected. Note that in this prompt the Currency used by the Program is not considered, since percent-based rates do not have a concept of currency.

SELECT RATE_TYPE ,RATE_TBL_ID ,EFFDT ,DESCR FROM PS_BN_RATE_TBL

Related Language Record: BN_PGMRATVW_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 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.
Prompt Table: BN_RATE_TYPE

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

3 EFFDT Date(10) DATE Effective Date
Default Value: %date

4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	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. Prompt Table: BN_RATE_TYPE
2	RATE_TBL_ID	Character(6)	VARCHAR2(6) NOT NULL	This is used as the record key that identifies a specific set of benefit rates.
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description