BN_RTKEY_VW

(SQL View)
 Index Back

Benefit Rate KeyField View

This is a prompt view for selecting Benefit Rate Key fields.

SELECT K.FIELDNAME , L.LONGNAME FROM PS_BN_RATE_KEYS K , PSDBFLDLABL L WHERE K.LABEL_ID=' ' AND L.FIELDNAME=K.FIELDNAME AND L.DEFAULT_LABEL=1 UNION SELECT K.FIELDNAME , L.LONGNAME FROM PS_BN_RATE_KEYS K , PSDBFLDLABL L WHERE K.LABEL_ID<>' ' AND L.FIELDNAME=K.FIELDNAME AND L.LABEL_ID=K.LABEL_ID

  • Related Language Record: BN_RTKEY_VW_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: BN_RATE_KEYS

    2 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name