PSADSRECDSCRLVW

index back

Data Set Record Descriptions


SELECT A.PTADSNAME , A.RECNAME , L.LANGUAGE_CD , %Coalesce( ( SELECT %Substring(GL.PTGRPLONGNAME,1,30) FROM PSADSGROUPLANG GL WHERE GL.PTADSNAME = A.PTADSNAME AND GL.PTGROUPNAME = A.RECNAME AND GL.LANGUAGE_CD = L.LANGUAGE_CD AND GL.PSGROUPCONT = 'R' AND GL.PTGRPLONGNAME IS NOT NULL AND GL.PTGRPLONGNAME <> ' ') , ( SELECT %Substring(G.PTGRPLONGNAME,1,30) FROM PSADSGROUP G WHERE G.PTADSNAME = A.PTADSNAME AND G.PTGROUPNAME = A.RECNAME AND G.PSGROUPCONT = 'R' AND G.PTGRPLONGNAME IS NOT NULL AND G.PTGRPLONGNAME <> ' ') , ( SELECT RL.RECDESCR FROM PSRECDEFNLANG RL WHERE RL.RECNAME = A.RECNAME AND RL.LANGUAGE_CD = L.LANGUAGE_CD AND RL.RECDESCR <> ' '), ( SELECT R.RECDESCR FROM PSRECDEFNLANG R WHERE R.RECNAME = A.RECNAME AND R.LANGUAGE_CD = L.LANGUAGE_CD AND R.RECDESCR <> ' '), A.RECNAME) FROM PSADSDEFNITEM A , PSLANGUAGES L WHERE L.INSTALLED = 1

  • Related language record for PSADSRECDESCRVW
  • 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

    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    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