PSADSRECFLBLLVW

(SQL View)
 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 PeopleSoft Field Type Database Column Type Description
    1 PTADSNAME Character(30) VARCHAR2(30) NOT NULL Data Set Name (see PSADSDEFN).

    Prompt Table: PSADSDEFN

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

    Prompt Table: PSRECDEFN

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

    Prompt Table: PSDBFIELD

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 PTADSFIELDLABEL Character(30) VARCHAR2(30) NOT NULL Field Description