EODP_RPT_RDF_VW

(SQL View)
 Index Back

SELECT REPORT_DEFN_ID , DESCR FROM PSXPRPTDEFN WHERE DS_TYPE IN ('CQR','QRY') UNION SELECT %Upper(SP.EODP_SQR_NAME) , PF.DESCR FROM PS_EODP_SQR_REF SP LEFT OUTER JOIN PS_PRCSDEFN PF ON %Upper(SP.EODP_SQR_NAME) = PF.PRCSNAME

  • Related Language Record: EODP_RPT_RD_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 REPORT_DEFN_ID Character(12) VARCHAR2(12) NOT NULL Report Name (see PSXPRPTDEFN).

    Prompt Table: PSXPRPTDEFN

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description