RAE_EVENT_RESR (SQL Table)	Index Back
Event Resource This table for Event Resources - or resources that are assigned to a Session

RAE_EVENT_RESR

(SQL Table)

Event Resource

This table for Event Resources - or resources that are assigned to a Session

Related Language Record: RAE_EVNT_RR_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
Prompt Table: SP_BU_RA_NONVW

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_RESOURCE_SEQNO Number(5,0) INTEGER NOT NULL Sequence Number for Resouce

4 RAE_EVT_SESSION_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Session Identification field. Character field that will contain a generated Session ID .
Prompt Table: RB_DROPDOWN

5 RAE_RESOURCE_NAME Character(50) VARCHAR2(50) NOT NULL Session Name - field containing the name of the sub event session

6 RAE_RESOURCE_TYPE Character(4) VARCHAR2(4) NOT NULL Resource Type XLat Field
COLL=Collateral
EXSP=External Participant
OTHR=Other
WRKR=Internal Participant

7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

8 RA_CONTENT_ID Character(15) VARCHAR2(15) NOT NULL Marketing - Content ID
Prompt Table: RA_CONTENT

9 BO_ID_WRKR Signed Number(32,0) DECIMAL(31) NOT NULL Worker BO_ID for Change Management

10 BO_ROLE_TYPE_ID Number(12,0) DECIMAL(12) NOT NULL BO_ROLE_TYPE_ID

11 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

12 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

13 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

14 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

15 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

16 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Prompt Table: SP_BU_RA_NONVW
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_RESOURCE_SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number for Resouce
4	RAE_EVT_SESSION_ID	Character(15)	VARCHAR2(15) NOT NULL	Marketing - Session Identification field. Character field that will contain a generated Session ID . Prompt Table: RB_DROPDOWN
5	RAE_RESOURCE_NAME	Character(50)	VARCHAR2(50) NOT NULL	Session Name - field containing the name of the sub event session
6	RAE_RESOURCE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Resource Type XLat Field COLL=Collateral EXSP=External Participant OTHR=Other WRKR=Internal Participant
7	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
8	RA_CONTENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Marketing - Content ID Prompt Table: RA_CONTENT
9	BO_ID_WRKR	Signed Number(32,0)	DECIMAL(31) NOT NULL	Worker BO_ID for Change Management
10	BO_ROLE_TYPE_ID	Number(12,0)	DECIMAL(12) NOT NULL	BO_ROLE_TYPE_ID
11	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
12	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
13	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
14	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
15	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
16	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time