PTRECFLDLBLLGVW

(SQL View)
 Index Back

Lang field label ID and label

Query field label ID and label name for a record, mulitple languages

SELECT R.RECNAME , R.FIELDNAME , LL.LANGUAGE_CD , R.FIELDNUM , D.RECDESCR , L.LABEL_ID , LL.LONGNAME FROM PSRECFIELDDB R JOIN PSRECDEFNLANG D ON R.RECNAME=D.RECNAME JOIN PSDBFLDLABL L ON L.FIELDNAME = R.FIELDNAME JOIN PSDBFLDLABLLANG LL ON L.FIELDNAME=LL.FIELDNAME AND L.LABEL_ID=LL.LABEL_ID AND D.LANGUAGE_CD=LL.LANGUAGE_CD WHERE (R.LABEL_ID=' ' AND L.DEFAULT_LABEL = 1 AND L.LABEL_ID<>' ') OR (R.LABEL_ID <> ' ' AND R.LABEL_ID=L.LABEL_ID)

  • Related Language Record for PTRECFLDLBLNMVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    5 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
    6 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    7 PTADSFIELDLABEL Character(30) VARCHAR2(30) NOT NULL Field Label