PTRECFLDLBLNMVW

(SQL View)
 Index Back

Query field label ID and label

Query field label ID and label name for a record

SELECT R.RECNAME , R.FIELDNAME , R.FIELDNUM , D.RECDESCR , L.LABEL_ID , L.LONGNAME FROM PSRECFIELDDB R JOIN PSRECDEFN D ON R.RECNAME=D.RECNAME JOIN PSDBFLDLABL L ON L.FIELDNAME = R.FIELDNAME 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: PTRECFLDLBLLGVW

    • # 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 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    4 RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
    5 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    6 PTADSFIELDLABEL Character(30) VARCHAR2(30) NOT NULL Field Label