EODP_QRYRF_E_VW

(SQL View)
 Index Back

Query References view

Query References View

SELECT A.EODP_QUERYNAME , Q1.EODP_QRY_CHILD , D.EODP_QUERY_DESCR , A2.XLATLONGNAME , (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 , CTG.EODP_CTGRY_DESC , CLS.EODP_CFCN_NAME , B.EODP_PERS_IDFR , B.EODP_SNSTV , C.EODP_PROD_DESCR , A.EODP_QRY_INFO FROM PS_EODP_RECFLDDB B , PS_EODP_CTGRY_CODE CTG , PS_EODP_CLSFCN CLS , PSXLATITEM A2, PS_EODP_QRYDSCR_VW D, PS_EODP_QRY_REF A LEFT OUTER JOIN PS_EODP_QRYDTL_REF Q1 ON A.EODP_OPRID = Q1.EODP_OPRID AND A.EODP_QUERYNAME = Q1.EODP_QUERYNAME AND A.EODP_QUERY_TYPE = Q1.EODP_QUERY_TYPE AND A.RECNAME = Q1.RECNAME AND A.FIELDNAME = Q1.FIELDNAME 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 AND A.EODP_QUERYNAME = D.EODP_QUERYNAME AND B.EODP_CTGRY_CD = CTG.EODP_CTGRY_CD AND B.EODP_CLFNCD = CLS.EODP_CLFNCD AND A2.FIELDNAME = 'EODP_QUERY_TYPE' AND A2.FIELDVALUE = A.EODP_QUERY_TYPE AND %EffdtCheck(PSXLATITEM A3, A2, %CurrentDateIn)

  • Related Language Record: EODP_QRYRFE_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EODP_QUERYNAME Character(30) VARCHAR2(30) NOT NULL Query Name Field
    2 EODP_QRY_CHILD Character(30) VARCHAR2(30) NOT NULL Child Query Name
    3 EODP_QUERY_DESCR Character(30) VARCHAR2(30) NOT NULL Query Description
    4 EODP_QRY_TYP_DSC Character(30) VARCHAR2(30) NOT NULL Query Type
    5 EODP_OWNER Character(30) VARCHAR2(30) NOT NULL Field for Query Owner
    PUB=Public
    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_QRY_INFO Character(254) VARCHAR2(254) NOT NULL Information