EODP_QRY_RFLVW

(SQL View)
 Index Back

Query Referencec View

Query References View

SELECT A.EODP_QUERYNAME , A.EODP_QUERY_TYPE , (CASE WHEN A.EODP_OPRID = ' ' THEN ( SELECT J.MESSAGE_TEXT FROM PSMSGCATLANG J WHERE J.MESSAGE_SET_NBR = 124 AND J.MESSAGE_NBR = 322 AND J.LANGUAGE_CD = A1.LANGUAGE_CD) ELSE A.EODP_OPRID END) , A.RECNAME , A.FIELDNAME , A1.LANGUAGE_CD , B.EODP_CTGRY_CD , B.EODP_CLFNCD , B.EODP_PERS_IDFR , B.EODP_SNSTV , C1.EODP_PROD_DESCR , A1.EODP_QRY_INFO FROM PS_EODP_RECFIELD B , PS_EODP_QRY_REFLNG A1, PS_EODP_QRY_REF A LEFT OUTER JOIN PS_EODP_QRY_RF_LVW C1 ON A.EODP_QUERYNAME = C1.EODP_QUERYNAME WHERE A.RECNAME = B.RECNAME AND A.FIELDNAME = B.FIELDNAME AND A.EODP_OPRID = A1.EODP_OPRID AND A.EODP_QUERYNAME = A1.EODP_QUERYNAME AND A.EODP_QUERY_TYPE = A1.EODP_QUERY_TYPE AND A.RECNAME = A1.RECNAME AND A.FIELDNAME = A1.FIELDNAME

  • Related Language Record for EODP_QRY_REFVW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 EODP_CTGRY_CD Character(6) VARCHAR2(6) NOT NULL Category Code

    Prompt Table: EODP_CTGRY_CODE

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

    Prompt Table: EODP_CLSFCN_VW

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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