EODP_QRY_REFVW

(SQL View)
 Index Back

Query References view

Query References View

SELECT A.EODP_QUERYNAME , A.EODP_QUERY_TYPE , (CASE WHEN A.EODP_OPRID = ' ' THEN ( SELECT MESSAGE_TEXT FROM PSMSGCATDEFN WHERE MESSAGE_SET_NBR = 124 AND MESSAGE_NBR = 322 ) ELSE A.EODP_OPRID END) , A.RECNAME , A.FIELDNAME , B.EODP_CTGRY_CD , B.EODP_CLFNCD , B.EODP_PERS_IDFR , B.EODP_SNSTV , C.EODP_PROD_DESCR , A.EODP_QRY_INFO FROM PS_EODP_RECFLDDB B , PS_EODP_QRY_REF A LEFT OUTER JOIN PS_EODP_QRY_REF_VW C ON A.EODP_QUERYNAME = C.EODP_QUERYNAME WHERE A.RECNAME = B.RECNAME AND A.FIELDNAME = B.FIELDNAME

  • Related Language Record: EODP_QRY_RFLVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EODP_QUERYNAME Character(30) VARCHAR2(30) NOT NULL Query Name Field
    2 EODP_QUERY_TYPE Character(4) VARCHAR2(4) NOT NULL Query Type field
    COMP=Composite Query
    CONN=Connected Query
    STD=Standard Query
    3 EODP_OWNER Character(30) VARCHAR2(30) NOT NULL Field for Query Owner
    PUB=Public
    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_CD Character(6) VARCHAR2(6) NOT NULL Category Code

    Prompt Table: EODP_CTGRY_CODE

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

    Prompt Table: EODP_CLSFCN_VW

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

    10 EODP_PROD_DESCR Character(30) VARCHAR2(30) NOT NULL Product Description
    11 EODP_QRY_INFO Character(254) VARCHAR2(254) NOT NULL Information