EODP_RPT_DWN_VW

(SQL View)
 Index Back

Report reference Dowbload View


SELECT RR.REPORT_DEFN_ID ,RP.DESCR ,RR.DS_ID ,QD1.EODP_QUERY_DESCR , RR.RECNAME , RR.FIELDNAME ,CT.EODP_CTGRY_DESC , CL.EODP_CFCN_NAME ,RF.EODP_PERS_IDFR , RF.EODP_SNSTV ,PD.EODP_PROD_DESCR ,RL.EODP_QUERYNAME ,QD.EODP_QUERY_DESCR FROM PS_EODP_REPORT_REF RR LEFT OUTER JOIN PS_EODP_RPRT_DTL RL ON RR.REPORT_DEFN_ID = RL.REPORT_DEFN_ID AND RR.DS_ID = RL.DS_ID AND RR.RECNAME = RL.RECNAME AND RR.FIELDNAME = RL.FIELDNAME LEFT OUTER JOIN PS_EODP_QRYDSCR_VW QD ON QD.EODP_QUERYNAME = RL.EODP_QUERYNAME LEFT OUTER JOIN PS_EODP_QRYDSCR_VW QD1 ON QD1.EODP_QUERYNAME = RR.DS_ID , PS_EODP_RECFLDDB RF LEFT OUTER JOIN PS_EODP_CLSFCN CL ON RF.EODP_CLFNCD = CL.EODP_CLFNCD LEFT OUTER JOIN PS_EODP_CTGRY_CODE CT ON RF.EODP_CTGRY_CD = CT.EODP_CTGRY_CD , PSXPRPTDEFN RP LEFT OUTER JOIN PS_EODP_RPT_PRD_VW PD ON RP.REPORT_DEFN_ID = PD.REPORT_DEFN_ID WHERE RR.RECNAME = RF.RECNAME AND RR.FIELDNAME = RF.FIELDNAME AND RR.REPORT_DEFN_ID = RP.REPORT_DEFN_ID

  • Related Language Record: EODP_RPT_DW_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).
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 QRYNAME Character(30) VARCHAR2(30) NOT NULL Query Name
    4 EODP_DSID_DESCR Character(30) VARCHAR2(30) NOT NULL Query Description
    5 EODP_RECNAME Character(15) VARCHAR2(15) NOT NULL Record Name
    6 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    7 EODP_CTGRY_DESC Character(100) VARCHAR2(100) NOT NULL Category
    8 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification
    9 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
    A=All
    N=No
    Y=Yes
    10 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
    A=All
    N=No
    Y=Yes
    11 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description
    12 EODP_QUERYNAME Character(30) VARCHAR2(30) NOT NULL Query Name Field
    13 EODP_QUERY_DESCR Character(30) VARCHAR2(30) NOT NULL Child Query Description