EODP_RPT_DW_LVW

(SQL View)
 Index Back

Report reference Dowbload View


SELECT RR.REPORT_DEFN_ID ,RP.LANGUAGE_CD ,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 , PS_EODP_RECFLDDB RF , PSXPRPTDEFNLNG RP LEFT OUTER JOIN PS_EODP_RPT_PRDLVW PD ON RP.REPORT_DEFN_ID = PD.REPORT_DEFN_ID AND PD.LANGUAGE_CD = RP.LANGUAGE_CD ,PS_EODP_QRYDSC_LVW QD ,PS_EODP_QRYDSC_LVW QD1 ,PS_EODP_CLSFCN_LNG CL ,PS_EODP_CTR_CD_LNG CT WHERE RR.RECNAME = RF.RECNAME AND RR.FIELDNAME = RF.FIELDNAME AND RR.REPORT_DEFN_ID = RP.REPORT_DEFN_ID AND QD.EODP_QUERYNAME = RL.EODP_QUERYNAME AND QD.LANGUAGE_CD = RP.LANGUAGE_CD AND QD1.EODP_QUERYNAME = RR.DS_ID AND QD1.LANGUAGE_CD = RP.LANGUAGE_CD AND RF.EODP_CLFNCD = CL.EODP_CLFNCD AND RP.LANGUAGE_CD = CL.LANGUAGE_CD AND RF.EODP_CTGRY_CD = CT.EODP_CTGRY_CD AND RP.LANGUAGE_CD = CT.LANGUAGE_CD

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