RDT_FDLBVW_LANG

(SQL View)
 Index Back

Field Labels Related Language

This view is used to display the default labels of fields in the field grid of the section template page.

SELECT A.FIELDNAME , A.LANGUAGE_CD , A.LONGNAME , A.SHORTNAME , B.DESCRLONG FROM PSDBFLDLABLLANG A , PSDBFIELDLANG B , PSDBFLDLABL C WHERE A.FIELDNAME = B.FIELDNAME AND A.FIELDNAME = C.FIELDNAME AND C.DEFAULT_LABEL = 1

  • Related Language Record for RDT_FLD_LBL_VW

    • # 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
    4 SHORTNAME Character(15) VARCHAR2(15) NOT NULL Field Short Name
    5 DESCRLONG Long Character CLOB Long Description