PTRECFLDLBLLGVW

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 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).
    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    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