BN_PGMRATVW_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, 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 R.RATE_TYPE ,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_PGMRATE_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 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description