OLM_EVNTPART_VW (SQL View)	Index Back
Event Participant Profile Event Participant view used in profile definition

OLM_EVNTPART_VW

(SQL View)

Event Participant Profile

Event Participant view used in profile definition

SELECT BO_ID ,IND_SYSID ,RAE_EVENT_ID ,RAE_INVITED_YN ,RAE_ATTENDED_YN ,RAE_FUTNOTFY_YN ,RAE_REG_REASON_CD FROM PS_RAE_EVENT_LIST

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BO_ID Signed Number(32,0) DECIMAL(31) NOT NULL Business Object ID

2 RA_ATTRIB_SEQ Number(31,0) DECIMAL(31) NOT NULL Profile / attribute sequence numbers

3 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.

4 RAE_INVITED_YN Character(1) VARCHAR2(1) NOT NULL Events - invited status y/n indicator
N=No
Y=Yes

5 RAE_ATTENDED_YN Character(1) VARCHAR2(1) NOT NULL Yes / No field used to mark attended on a participant of an Event
N=No
Y=Yes

6 RAE_FUTNOTFY_YN Character(1) VARCHAR2(1) NOT NULL Events - future notification status y/n indicator
N=No
Y=Yes

7 RAE_REG_REASON_CD Character(4) VARCHAR2(4) NOT NULL Marketing Events - Registration Reason Code
DCLN=Declined
RGST=Registered
WAIT=Waitlisted

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BO_ID	Signed Number(32,0)	DECIMAL(31) NOT NULL	Business Object ID
2	RA_ATTRIB_SEQ	Number(31,0)	DECIMAL(31) NOT NULL	Profile / attribute sequence numbers
3	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.
4	RAE_INVITED_YN	Character(1)	VARCHAR2(1) NOT NULL	Events - invited status y/n indicator N=No Y=Yes
5	RAE_ATTENDED_YN	Character(1)	VARCHAR2(1) NOT NULL	Yes / No field used to mark attended on a participant of an Event N=No Y=Yes
6	RAE_FUTNOTFY_YN	Character(1)	VARCHAR2(1) NOT NULL	Events - future notification status y/n indicator N=No Y=Yes
7	RAE_REG_REASON_CD	Character(4)	VARCHAR2(4) NOT NULL	Marketing Events - Registration Reason Code DCLN=Declined RGST=Registered WAIT=Waitlisted