RAE_SESSNOTE_VW

(SQL View)
 Index Back

Session (Notes) View

This is a view to relate Notes to a Session (Sub Event)

SELECT A.BUSINESS_UNIT , A.RAE_EVENT_ID , A.RAE_EVT_SESSION_ID , B.NOTE_SEQ_NBR , A.RAE_EVT_SESSN_NAME , B.RA_NOTE_SUMMARY ,B.ROW_ADDED_OPRID ,B.ROW_ADDED_DTTM ,C.BO_NAME_DISPLAY ,' ' FROM PS_RAE_EVT_SESSION A , PS_RAE_EVENT_NOTE B , PS_RD_PERSON_NAME C , PSOPRALIAS D WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.RAE_EVENT_ID=B.RAE_EVENT_ID AND A.RAE_EVT_SESSION_ID =B.RAE_EVT_SESSION_ID AND RAE_NOTE_TYPES='SESS' AND B.ROW_ADDED_OPRID=D.OPRID AND D.PERSON_ID=C.PERSON_ID AND C.PRIMARY_IND='Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 RAE_EVENT_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Campaign Identification field. Character field that will contain a generated campaign or free form entered campaign id.
3 RAE_EVT_SESSION_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Session Identification field. Character field that will contain a generated Session ID .
4 NOTE_SEQ_NBR Number(6,0) INTEGER NOT NULL Note ID
5 RAE_SUB_EVENT_NAME Character(50) VARCHAR2(50) NOT NULL sub event Name - field containing the name of the sub event
6 RA_NOTE_SUMMARY Character(80) VARCHAR2(80) NOT NULL Note summary field
7 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
8 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
9 BO_NAME_DISPLAY Character(80) VARCHAR2(80) NOT NULL Full name of the Business Object
10 RAE_SUB_EVENT_ID Character(15) VARCHAR2(15) NOT NULL Marketing - SUB EVENTIdentification field. Character field that will contain a generated EVENT ID .