RYEDOC_SRCH_VW

(SQL View)
 Index Back

Document Search View

Document Search View - RY_DOC_SRCH component

SELECT A.RY_DOC_ID , A.SETID , B.RY_NAME254 , B.RY_DOC_TYPE , C.DESCR80 , D.RY_DIALOG_NAME , A.ROW_ADDED_OPRID , %DatePart(A.ROW_ADDED_DTTM) , E.OPRID FROM PS_RYEDOC A LEFT OUTER JOIN PS_RYEDIALOG D ON (A.DIALOG_ID = D.DIALOG_ID) LEFT OUTER JOIN PS_RY_DOC_SCRTY_VW E ON (A.RY_DOC_ID=E.RY_DOC_ID) , PS_RYEDOC_VAR B , PS_RYEDOC_TYPE_REF C WHERE A.RY_MD_ID = B.RY_MD_ID AND B.RY_DOC_TYPE = C.RY_DOC_TYPE

  • Related Language Record: RYEDOC_SRCHL_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RY_DOC_ID Number(18,0) DECIMAL(18) NOT NULL Document ID - Dialog Document Main Sys ID
    2 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.

    Default Value: OPR_DEF_TBL_RB.SETID

    Prompt Table: SP_SETID_NONVW

    3 RY_NAME254 Character(254) VARCHAR2(254) NOT NULL 254 character name field for names.
    4 RY_DOC_TYPE Number(4,0) SMALLINT NOT NULL Document Type for Dialog Document, Either Email or Web
    5 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.
    6 RY_DIALOG_NAME Character(254) VARCHAR2(254) NOT NULL Field is used to capture a Dialog Name.
    7 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    8 ROW_ADDED_DT Date(10) DATE Date Added label added for Wealth Management.
    9 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).