eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AMS.AMS_EVENT_REGISTRATIONS

Object Details

Object Name:	AMS_EVENT_REGISTRATIONS
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_EVENT_REGISTRATIONS
Subobject Name:
Status:	VALID

AMS_EVENT_REGISTRATIONS stores all enrollment information for an event. You enroll a contact for an event during an interaction. One to many persons registers for an event. The table keep the name of the person registering and the name of the person actually supposed to attend.
Each event will have a maximum number of attendees specified for it along with an overbooking percentage. These numbers are used to control the number and type of rows created in AMS_EVENT_REGISTRATIONS for each event. If he maximum number of attendees has been exceeded, then no more rows with a status of 'Confirmed' can be created. Any more rows you create for this event must be created with a status or 'Wait List'.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_EVENT_REGISTRATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	EVENT_REGISTRATION_ID
AMS_EVENT_REGISTRATIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPLICATION_ID
AMS_EVENT_REGISTRATIONS_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_STATUS_ID
AMS_EVENT_REGISTRATIONS_N11	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_OFFER_ID
AMS_EVENT_REGISTRATIONS_N12	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANT_ACCOUNT_ID
AMS_EVENT_REGISTRATIONS_N13	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REGISTRANT_ACCOUNT_ID
AMS_EVENT_REGISTRATIONS_N14	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_LINE_ID
AMS_EVENT_REGISTRATIONS_N15	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORDER_HEADER_ID
AMS_EVENT_REGISTRATIONS_N16	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LAST_UPDATE_DATE
AMS_EVENT_REGISTRATIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANT_LANGUAGE
AMS_EVENT_REGISTRATIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REGISTRANT_PARTY_ID
AMS_EVENT_REGISTRATIONS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANT_PARTY_ID
AMS_EVENT_REGISTRATIONS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REGISTRANT_CONTACT_ID
AMS_EVENT_REGISTRATIONS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANT_CONTACT_ID
AMS_EVENT_REGISTRATIONS_U2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONFIRMATION_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_REGISTRATION_ID	NUMBER		Yes	Event Registration Unique Identifier
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes. A way to implement Optimistic Locking.
APPLICATION_ID	NUMBER	(15)	Yes	Application Identifier.
OWNER_USER_ID	NUMBER		Yes	The person who took the registration. This is the user ID of the person who recorded the registration in the System.
CONFIRMATION_CODE	VARCHAR2	(30)	Yes	If the registration is confirmed, this field holds the Confirmation Code.
EVENT_OFFER_ID	NUMBER		Yes	Event Offer ID of the Event Offering for which this registration is done.
ACTIVE_FLAG	VARCHAR2	(1)	Yes	This is the flag to indicate a deleted record. We do only soft-deletes in the system. The Select statements pull up only those records for which the ACTIVE_FLAG is 'Y'.
DATE_REGISTRATION_PLACED	DATE		Yes	Date on which this Registration was done.
USER_STATUS_ID	NUMBER		Yes	This field keeps track of the System Status for this Registration Record. This field gets updated as and when the Registration proceeds from Waitlisted to Confirmed Registration to Cancelled Registration.
SYSTEM_STATUS_CODE	VARCHAR2	(30)	Yes	This field ties in with the USER_STATUS_ID. Added to this table for ease of reporting.
LAST_REG_STATUS_DATE	DATE		Yes	This field ties in with USER_STATUS_ID. This date is the date when the USER_STATUS_ID was last changed.
REG_SOURCE_TYPE_CODE	VARCHAR2	(30)		The source of the registration. This tells which type of party this registration has come from. Is this a partner or a reseller?
REGISTRATION_SOURCE_ID	NUMBER	(15)		This field ties in with the REG_SOURCE_TYPE_CODE. This ID is of the registration source. It could be party_id or vendor_id.
SOURCE_CODE	VARCHAR2	(30)		Source Code of the source which led to this registration. Example, an event source code.
REGISTRATION_GROUP_ID	NUMBER			ID of the Group registering for the Event Offering.
REGISTRANT_PARTY_ID	NUMBER		Yes	ID of the Party registering for the Event Offering.
REGISTRANT_ACCOUNT_ID	NUMBER			Account ID of the Registrant, as defined in the Customer Model.
REGISTRANT_CONTACT_ID	NUMBER		Yes	Contact ID of the registrant as defined in the Customer Model.
ATTENDANT_PARTY_ID	NUMBER			Part ID of the attendant as defined in the Customer Model.
ATTENDANT_ACCOUNT_ID	NUMBER			Account ID of the Attendant as defined in the Customer Model.
ATTENDANT_CONTACT_ID	NUMBER		Yes	Contact ID of the Attendant as defined in the Customer Model.
ORIGINAL_REGISTRANT_CONTACT_ID	NUMBER		Yes	This field us used when we substitute another Party for the current Registrant. We hold on to the contact ID of the original Registrant. This contact ID is as defined in the Customer Model.
PROSPECT_FLAG	VARCHAR2	(1)	Yes	Whether this registrant is a Prospect.
ATTENDED_FLAG	VARCHAR2	(1)	Yes	Whether the registrant has attended the Event Offering.
CONFIRMED_FLAG	VARCHAR2	(1)	Yes	For OSM upgrade. Tells whether the Registration is confirmed.
EVALUATED_FLAG	VARCHAR2	(1)	Yes	Whether the attendant returned the Evaluation Sheet or is there any evaluation obtained from this registrant.
ATTENDANCE_RESULT_CODE	VARCHAR2	(4000)		Attendance Result Code. These values are seeded.
WAITLISTED_PRIORITY	NUMBER	(15)		Waitlist priority number if this registrant was on the waitlist for this Event Offering.
TARGET_LIST_ID	NUMBER			List ID of the list from which the Registrant was taken from. This could have been an Invitee List.
INBOUND_MEDIA_ID	NUMBER			Channel through which the Inbound Call came in.
INBOUND_CHANNEL_ID	NUMBER			ID of the channel.
CANCELLATION_CODE	VARCHAR2	(30)		Cancellation Code.
CANCELLATION_REASON_CODE	VARCHAR2	(30)		Reason for Cancellation. The values are seeded.
ATTENDANCE_FAILURE_REASON	VARCHAR2	(30)		Reason why the registrant could not attend.
ATTENDANT_LANGUAGE	VARCHAR2	(4)		Language code of the Attendant's language.
SALESREP_ID	NUMBER			ID of the Salesrep who referred the Registrant.
ORDER_HEADER_ID	NUMBER			Order Header ID. This is the link to the order, which was placed when this Registrant registered for this Event Offering.
ORDER_LINE_ID	NUMBER			Ties in with the Order Header ID.
DESCRIPTION	VARCHAR2	(4000)		General description or comments.
MAX_ATTENDEE_OVERRIDE_FLAG	VARCHAR2	(1)		Whether the Cal Center can override the MAXIMUM ATTENDEE in order to register the registrant. Can he / she be registered even if the Maximum Capacity has been reached?
INVITE_ONLY_OVERRIDE_FLAG	VARCHAR2	(1)		Can a person who is not on Invitee List be registered for this Invite-Only Event Offering?
PAYMENT_STATUS_CODE	VARCHAR2	(30)		Currently this is a seed value, the values are FREE and PAID.
AUTO_REGISTER_FLAG	VARCHAR2	(1)		Move from waitlisted to registered status automatically.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfiled structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
REQUEST_ID	NUMBER			TCA party Merge Concurrent program Id
PROGRAM_APPLICATION_ID	NUMBER			Application Id of the Concurrent program. Used for TCA Party Merge
PROGRAM_ID	NUMBER			Identifier of the Program
PROGRAM_UPDATE_DATE	DATE			Concurrent program run Date
ATTENDEE_ROLE_TYPE	VARCHAR2	(30)		Role_ type of the Attendees
NOTIFICATION_TYPE	VARCHAR2	(30)		Type of Notification supported
LAST_NOTIFIED_TIME	DATE			Time when last notification sent out
EVENT_JOIN_TIME	DATE			Time when the person joined the meeting
EVENT_EXIT_TIME	DATE			time when the person left the meeting
MEETING_ENCRYPTION_KEY_CODE	VARCHAR2	(150)		Password encryption key for the registrant used by iMeeting

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EVENT_REGISTRATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      APPLICATION_ID
,      OWNER_USER_ID
,      CONFIRMATION_CODE
,      EVENT_OFFER_ID
,      ACTIVE_FLAG
,      DATE_REGISTRATION_PLACED
,      USER_STATUS_ID
,      SYSTEM_STATUS_CODE
,      LAST_REG_STATUS_DATE
,      REG_SOURCE_TYPE_CODE
,      REGISTRATION_SOURCE_ID
,      SOURCE_CODE
,      REGISTRATION_GROUP_ID
,      REGISTRANT_PARTY_ID
,      REGISTRANT_ACCOUNT_ID
,      REGISTRANT_CONTACT_ID
,      ATTENDANT_PARTY_ID
,      ATTENDANT_ACCOUNT_ID
,      ATTENDANT_CONTACT_ID
,      ORIGINAL_REGISTRANT_CONTACT_ID
,      PROSPECT_FLAG
,      ATTENDED_FLAG
,      CONFIRMED_FLAG
,      EVALUATED_FLAG
,      ATTENDANCE_RESULT_CODE
,      WAITLISTED_PRIORITY
,      TARGET_LIST_ID
,      INBOUND_MEDIA_ID
,      INBOUND_CHANNEL_ID
,      CANCELLATION_CODE
,      CANCELLATION_REASON_CODE
,      ATTENDANCE_FAILURE_REASON
,      ATTENDANT_LANGUAGE
,      SALESREP_ID
,      ORDER_HEADER_ID
,      ORDER_LINE_ID
,      DESCRIPTION
,      MAX_ATTENDEE_OVERRIDE_FLAG
,      INVITE_ONLY_OVERRIDE_FLAG
,      PAYMENT_STATUS_CODE
,      AUTO_REGISTER_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTENDEE_ROLE_TYPE
,      NOTIFICATION_TYPE
,      LAST_NOTIFIED_TIME
,      EVENT_JOIN_TIME
,      EVENT_EXIT_TIME
,      MEETING_ENCRYPTION_KEY_CODE
FROM AMS.AMS_EVENT_REGISTRATIONS;

Dependencies

[top of page]

AMS.AMS_EVENT_REGISTRATIONS does not reference any database object

AMS.AMS_EVENT_REGISTRATIONS is referenced by following:

AMS: AMS_EVENT_REGISTRATIONS#