PSADSRECDESCRVW

index back

Data Set Record Descriptions


SELECT A.PTADSNAME , A.RECNAME , CASE WHEN G.PTADSNAME IS NOT NULL THEN %Substring(G.PTGRPLONGNAME, 1, 30) WHEN R.RECNAME IS NOT NULL THEN R.RECDESCR ELSE A.RECNAME END FROM PSADSDEFNITEM A LEFT JOIN PSRECDEFN R ON R.RECNAME = A.RECNAME AND R.RECDESCR <> ' ' LEFT JOIN PSADSGROUP G ON G.PTADSNAME = A.PTADSNAME AND G.PTGROUPNAME = A.RECNAME AND G.PSGROUPCONT = 'R' AND G.PTGRPLONGNAME IS NOT NULL AND G.PTGRPLONGNAME <> ' '

  • Related language record: PSADSRECDSCRLVW
  • 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

    RECDESCRCharacter(30)VARCHAR2(30) NOT NULLRecord Description
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19