BN_CURRATVW_LNG

(SQL View)
 Index Back

Benefit Rate Prompt - Rel Lang

This related language 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 R.RATE_TYPE ,R.CURRENCY_CD ,R.RATE_TBL_ID ,R.EFFDT ,L.LANGUAGE_CD ,L.DESCR FROM PS_BN_RATE_TBL R , PS_BN_RATE_TBL_LNG L WHERE L.RATE_TBL_ID=R.RATE_TBL_ID

  • Related Language Record for BN_CURRATE_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description