RAE_EVTATND_VW (SQL View)	Index Back
Count of Attended for Event Count of attended participants on an event - used by metric determining attendance rate.

RAE_EVTATND_VW

(SQL View)

Count of Attended for Event

Count of attended participants on an event - used by metric determining attendance rate.

SELECT BUSINESS_UNIT , RAE_EVENT_ID , COUNT(*) FROM PS_RAE_EVENT_LIST WHERE RAE_ATTENDED_YN = 'Y' GROUP BY BUSINESS_UNIT, RAE_EVENT_ID

# 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_ATTENDED_COUNT Number(9,0) DECIMAL(9) NOT NULL Count of Participants that attended

#	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_ATTENDED_COUNT	Number(9,0)	DECIMAL(9) NOT NULL	Count of Participants that attended