PSADSRECFLBLLVW

index back

Data Set Record Field Labels


SELECT A.PTADSNAME , R.RECNAME , R.FIELDNAME , LL.LANGUAGE_CD , CASE WHEN (F.LABEL_ID IS NOT NULL AND F.PTLABELTYPE = 'S') THEN LL.SHORTNAME ELSE LL.LONGNAME END FROM PSADSDEFNITEM A JOIN PSRECFIELDDB R ON R.RECNAME = A.RECNAME LEFT JOIN PSADSRECFLDOVW F ON F.PTADSNAME = A.PTADSNAME AND F.RECNAME = R.RECNAME AND F.FIELDNAME = R.FIELDNAME JOIN PSDBFLDLABL L ON L.FIELDNAME = R.FIELDNAME AND ((F.LABEL_ID IS NOT NULL AND L.LABEL_ID = F.LABEL_ID) OR (F.LABEL_ID IS NULL AND R.LABEL_ID IS NOT NULL AND R.LABEL_ID <> ' ' AND L.LABEL_ID = R.LABEL_ID) OR (F.LABEL_ID IS NULL AND (R.LABEL_ID IS NULL OR R.LABEL_ID = ' ') AND L.DEFAULT_LABEL = 1)) JOIN PSDBFLDLABLLANG LL ON LL.FIELDNAME = L.FIELDNAME AND LL.LABEL_ID = L.LABEL_ID

  • Related language record for PSADSRECFLBLVW
  • PeopleSoft Field Name Field Type Column Type Description
    PTADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name (see PSADSDEFN).

    Prompt Table: PSADSDEFN

    RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code translate values
    PTADSFIELDLABEL Character(30) VARCHAR2(30) NOT NULL Field Description
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19