PTRECFLDLBLNMVW

 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 Field Type Column Type Description
    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number
    RECDESCR Character(30) VARCHAR2(30) NOT NULL Record Description
    LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    PTADSFIELDLABEL Character(30) VARCHAR2(30) NOT NULL Field Label
    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20