BN_RTKEY_VW_LNG

(SQL View)
Index Back

Rate KeyField View Rel Lang

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

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

  • Related Language Record for BN_RTKEY_VW
  • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name