RY_IND_OEMAILVW

(SQL View)
 Index Back

Individual Doc Report Search.

Search view for Individual Document Report.

SELECT A.BAS_SYSID , A.BO_ID , A.ROLE_TYPE_ID , B.DIALOG_ID , B.RY_DOC_ID ,E.RY_NAME254 ,RY_EMAIL_TO_ADDR ,INTERACTION_ID ,CONTACTED_DTTM , A.NAME , D.BO_NAME_DISPLAY ,B.RY_RECORD_ID ,B.RY_MAILER_TYPE ,H.OPRID FROM PS_BO_BASIC_IND A , PS_RY_EMAIL_HIS_VW B , PS_BO_NAME_PRIM_VW D , PS_RY_DOC C LEFT OUTER JOIN PS_RY_DOC_SCRTY_VW H ON (C.RY_DOC_ID=H.RY_DOC_ID) , PS_RY_DOC_VAR E WHERE A.BAS_SYSID = B.RY_IND_ID AND A.BO_ID = D.BO_ID AND B.RY_DOC_ID = C.RY_DOC_ID AND C.RY_MD_ID = E.RY_MD_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BAS_SYSID Number(18,0) DECIMAL(18) NOT NULL Basic Data System ID
2 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID
3 ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL Role Type ID
4 DIALOG_ID Number(18,0) DECIMAL(18) NOT NULL Dialog ID field to identify both design time and run time dialog.
5 RY_DOC_ID Number(18,0) DECIMAL(18) NOT NULL Document ID - Dialog Document Main Sys ID
6 RY_NAME254 Character(254) VARCHAR2(254) NOT NULL 254 character name field for names.
7 RY_EMAIL_TO_ADDR Character(254) VARCHAR2(254) NOT NULL Email To Address field to use email history
8 INTERACTION_ID Character(15) VARCHAR2(15) NOT NULL interaction id
9 CONTACTED_DTTM DateTime(26) TIMESTAMP Contacted On
10 NAME Character(50) VARCHAR2(50) NOT NULL Name
11 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
12 RY_RECORD_ID Number(18,0) DECIMAL(18) NOT NULL Field used by Online Marketing.
13 RY_MAILER_TYPE Character(1) VARCHAR2(1) NOT NULL Field used by Online Marketing. Only include the Signle and Bulk emailer
B=Broadcast
S=Single
14 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).