PSADSRECFLBLVW

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 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

    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 Description
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19