SEC_CF_LANG

(SQL View)
 Index Back

Field Related Lang View

This view is used as the RLR for fields prompt views. Do not add an criteria to the view as this is used as the RLR for several prompt views.

SELECT FIELDNAME , LANGUAGE_CD , LONGNAME FROM PSDBFLDLBLLNG_V

  • Related Language Record for CF_EXP_FLD2_VW CF_EXP_FLD_VW EDR_CFDEFN_VW EDR_CF_VW OI_TFLDS_VW OI_TFLDS_VW1 OI_TFLT_FLD_VW SEC_CFAFFIL_VW SEC_CF_VW SEC_CF_VW2 SEC_FIELDS_VW SEC_FIELDS_VW2 SEC_FIELDS_VW3

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name