EODP_SQR_DWN_VW

(SQL View)
 Index Back

Report reference Dowbload View


SELECT SR.EODP_SQR_NAME ,PF.DESCR , SR.RECNAME , SR.FIELDNAME ,CT.EODP_CTGRY_DESC , CL.EODP_CFCN_NAME ,RF.EODP_PERS_IDFR , RF.EODP_SNSTV ,SV.EODP_RUNCNTLCMP ,SV.DESCR ,PR.EODP_PROD_DESCR ,SV.PORTAL_NAVPATH FROM PS_EODP_SQR_REF SR LEFT OUTER JOIN PS_EODP_RPT_PRD_VW PD ON SR.EODP_SQR_NAME = PD.REPORT_DEFN_ID LEFT OUTER JOIN PS_PRCSDEFN PF ON SR.EODP_SQR_NAME = PF.PRCSNAME LEFT OUTER JOIN PS_EODP_SQR_RCT_VW SV ON SV.REPORT_DEFN_ID = SR.EODP_SQR_NAME AND SV.RECNAME = SR.RECNAME AND SV.FIELDNAME = SR.FIELDNAME LEFT OUTER JOIN PS_EODP_RECPRD1_VW PR ON PR.OBJECTOWNERID = SV.OBJECTOWNERID , 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 WHERE SR.RECNAME = RF.RECNAME AND SR.FIELDNAME = RF.FIELDNAME

  • Related Language Record: EODP_SQR_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 EODP_RECNAME Character(15) VARCHAR2(15) NOT NULL Record Name
    4 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    5 EODP_CTGRY_DESC Character(100) VARCHAR2(100) NOT NULL Category
    6 EODP_CFCN_NAME Character(100) VARCHAR2(100) NOT NULL Classification
    7 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
    A=All
    N=No
    Y=Yes
    8 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
    A=All
    N=No
    Y=Yes
    9 EODP_RUNCNTLCMP Character(18) VARCHAR2(18) NOT NULL Run Control Component Name
    10 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    11 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description
    12 PORTAL_NAVPATH Long Character CLOB Navigation Path