BN_CURRATE_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. It filters its results by the Rate Type selected and by the Currency used by the Program.

BN_CURRATE_VW

(SQL View)

Benefit Rate Prompt

This view is used in the Benefit Program Definition component as a prompt for a Benefit Rate ID. It filters its results by the Rate Type selected and by the Currency used by the Program.

SELECT RATE_TYPE ,CURRENCY_CD ,RATE_TBL_ID ,EFFDT ,DESCR FROM PS_BN_RATE_TBL

Related Language Record: BN_CURRATVW_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 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY
Prompt Table: CURRENCY_CD_TBL

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

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

5 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	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL
3	RATE_TBL_ID	Character(6)	VARCHAR2(6) NOT NULL	This is used as the record key that identifies a specific set of benefit rates.
4	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
5	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description