EODP_SQR_DW_LVW

(SQL View)
 Index Back

Report reference Dowbload View


SELECT SR.EODP_SQR_NAME ,PF.LANGUAGE_CD ,PF.DESCR , SR.RECNAME , SR.FIELDNAME ,CT.EODP_CTGRY_DESC , CL.EODP_CFCN_NAME ,RF.EODP_PERS_IDFR , RF.EODP_SNSTV ,SV.EODP_RUNCNTLCMP ,SL.DESCR ,PR.EODP_PROD_DESCR ,SL.PORTAL_NAVPATH FROM PS_EODP_SQR_REF SR LEFT OUTER JOIN PS_PRCSDEFNLANG 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_SQR_RC_LVW SL ON SV.REPORT_DEFN_ID = SL.REPORT_DEFN_ID LEFT OUTER JOIN PS_EODP_RCPRD1_LVW PR ON PR.OBJECTOWNERID = SV.OBJECTOWNERID AND PF.LANGUAGE_CD = SL.LANGUAGE_CD , 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 for EODP_SQR_DWN_VW

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