RAE_EVTSESR_LVW

(SQL View)
 Index Back

Events Session Resource

Events - view of resources assigned to an events sessions

SELECT C.BUSINESS_UNIT , C.RAE_EVENT_ID , A.RAE_EVT_SESSION_ID , C.RAE_RESOURCE_SEQNO , C.LANGUAGE_CD , C.DESCR254 FROM PS_RAE_EVENT_RESR A , PS_RAE_EVT_SESSION B , PS_RAE_EVNT_RR_LNG C 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 C.BUSINESS_UNIT=A.BUSINESS_UNIT AND C.RAE_EVENT_ID=A.RAE_EVENT_ID AND C.RAE_RESOURCE_SEQNO =A.RAE_RESOURCE_SEQNO

  • Related Language Record for RAE_EVTSESRE_VW

    • # 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 RAE_RESOURCE_SEQNO Number(5,0) INTEGER NOT NULL Sequence Number for Resouce
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254