PSADSRECFLBLVW

(SQL View)
 Index Back

Data Set Record Field Labels


SELECT A.PTADSNAME , R.RECNAME , R.FIELDNAME , L.LABEL_ID , CASE WHEN (F.LABEL_ID IS NOT NULL AND F.PTLABELTYPE = 'S') THEN L.SHORTNAME ELSE L.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))

  • Related Language Record: PSADSRECFLBLLVW

    • # 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 LABEL_ID Character(18) VARCHAR2(18) NOT NULL LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    5 PTADSFIELDLABEL Character(30) VARCHAR2(30) NOT NULL Field Description