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 NameField TypeColumn TypeDescription
    PTADSNAMECharacter(30)VARCHAR2(30) NOT NULLData Set Name (see PSADSDEFN).

    Prompt Table: PSADSDEFN

    RECNAMECharacter(15)VARCHAR2(15) NOT NULLRecord (Table) Name (see PSRECDEFN).

    Prompt Table: PSRECDEFN

    FIELDNAMECharacter(18)VARCHAR2(18) NOT NULLField Name (see PSDBFIELD).

    Prompt Table: PSDBFIELD

    LABEL_IDCharacter(18)VARCHAR2(18) NOT NULLLABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
    PTADSFIELDLABELCharacter(30)VARCHAR2(30) NOT NULLField Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19