EODP_RPT_REF_VW

(SQL View)
 Index Back

Report Ref Page View


SELECT RP.REPORT_DEFN_ID , RP.RECNAME , RP.FIELDNAME ,'BIP' ,RD.DS_TYPE ,RD.DS_ID ,RD.DESCR ,RF.EODP_CTGRY_CD , RF.EODP_CLFNCD ,RF.EODP_PERS_IDFR , RF.EODP_SNSTV ,RD.OBJECTOWNERID FROM PS_EODP_REPORT_REF RP LEFT OUTER JOIN PSXPRPTDEFN RD ON RP.REPORT_DEFN_ID = RD.REPORT_DEFN_ID , PS_EODP_RECFLDDB RF WHERE RP.RECNAME = RF.RECNAME AND RP.FIELDNAME = RF.FIELDNAME UNION SELECT SP.EODP_SQR_NAME , SP.RECNAME , SP.FIELDNAME ,'SQR' ,'' ,'' ,PF.DESCR ,RF.EODP_CTGRY_CD , RF.EODP_CLFNCD ,RF.EODP_PERS_IDFR , RF.EODP_SNSTV ,'' FROM PS_EODP_SQR_REF SP LEFT OUTER JOIN PS_PRCSDEFN PF ON SP.EODP_SQR_NAME = PF.PRCSNAME , PS_EODP_RECFLDDB RF WHERE SP.RECNAME = RF.RECNAME AND SP.FIELDNAME = RF.FIELDNAME

  • Related Language Record: EODP_RPT_RE_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: EODP_RPT_RDF_VW

    2 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

    Prompt Table: EODP_RECORD_VW

    3 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

    Prompt Table: EODP_FIELD_VW

    4 EODP_REP_TYPE Character(3) VARCHAR2(3) NOT NULL Report Type
    BIP=BIP
    SQR=SQR
    5 DS_TYPE Character(3) VARCHAR2(3) NOT NULL Data Source Type
    CPQ=Composite Query
    CQR=Connected Query
    QRY=Query
    RST=Rowset
    XMD=XMLDoc Object
    XML=XML File

    Default Value: QRY

    6 DS_ID Character(30) VARCHAR2(30) NOT NULL Data Source ID
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 EODP_CTGRY_CD Character(6) VARCHAR2(6) NOT NULL Category Code

    Prompt Table: EODP_CTGRY_CODE

    9 EODP_CLFNCD Number(3,0) SMALLINT NOT NULL Classification Code

    Prompt Table: EODP_CLSFCN_VW

    10 EODP_PERS_IDFR Character(1) VARCHAR2(1) NOT NULL Personal Identifier
    A=All
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    11 EODP_SNSTV Character(1) VARCHAR2(1) NOT NULL Sensitive
    A=All
    N=No
    Y=Yes

    Y/N Table Edit

    Default Value: N

    12 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier