RAE_EVTSESRE_VW

(SQL View)
 Index Back

Events Session Resource

Events - view of resources assigned to an events sessions

SELECT A.BUSINESS_UNIT , A.RAE_EVENT_ID , A.RAE_EVT_SESSION_ID , A.RAE_RESOURCE_SEQNO , A.RAE_RESOURCE_TYPE , CASE WHEN C.BO_NAME_DISPLAY <> ' ' THEN %Substring(C.BO_NAME_DISPLAY, 1, 50) WHEN D.DESCR <> ' ' THEN D.DESCR ELSE A.RAE_RESOURCE_NAME END , A.DESCR254 FROM PS_RAE_EVENT_RESR A LEFT OUTER JOIN PS_BO_NAME C ON (A.BO_ID_WRKR = C.BO_ID) LEFT OUTER JOIN PS_RA_CONTENT D ON (A.RA_CONTENT_ID = D.RA_CONTENT_ID) , PS_RAE_EVT_SESSION B 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

  • Related Language Record: RAE_EVTSESR_LVW

    • # 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 RAE_RESOURCE_TYPE Character(4) VARCHAR2(4) NOT NULL Resource Type XLat Field
    COLL=Collateral
    EXSP=External Participant
    OTHR=Other
    WRKR=Internal Participant
    6 RAE_RESOURCE_NAME Character(50) VARCHAR2(50) NOT NULL Session Name - field containing the name of the sub event session
    7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254