RAE_SUB_EVENT

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit Default Value: OPR_DEF_TBL_RB.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. Prompt Table: RAE_EVENT
3	RAE_SUB_EVENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Marketing - SUB EVENTIdentification field. Character field that will contain a generated EVENT ID .
4	RAE_SUB_EVENT_NAME	Character(50)	VARCHAR2(50) NOT NULL	sub event Name - field containing the name of the sub event
5	START_DATE	Date(10)	DATE NOT NULL	Campaign Start Date
6	START_TIME	Time(15)	TIMESTAMP	Start of Shift
7	END_DATE	Date(10)	DATE NOT NULL	End date field to store an end date.
8	END_TIME	Time(15)	TIMESTAMP	End of Shift
9	RA_BUDGET_AMT	Number(18,2)	DECIMAL(17,2) NOT NULL	Campaign Budget Amount
10	RAE_CAPACITY	Number(9,0)	DECIMAL(9) NOT NULL	Events / Sub Events Capacity field
11	RAE_ATTENDANCE	Number(9,0)	DECIMAL(9) NOT NULL	Events / Sub Events attendance field
12	RAE_FEE_AMOUNT	Number(9,2)	DECIMAL(8,2) NOT NULL	Fee amount for events and participant fees
13	RAE_SUBVEN_LOCTN	Character(50)	VARCHAR2(50) NOT NULL	Sub Venue or Location
14	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254