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: BIM.EDW_BIM_EVENTS_M

Object Details

Object Name:	EDW_BIM_EVENTS_M
Object Type:	TABLE
Owner:	BIM
FND Design Data:	BIM.EDW_BIM_EVENTS_M
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
EDW_BIM_EVENTS_M_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	L2_EVTOFFER_PK L2_EVTOFFER_PK_KEY
EDW_BIM_EVENTS_M_U2	NORMAL	UNIQUE	APPS_TS_ARCHIVE	L2_EVTOFFER_PK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
L2_EVTOFFER_PK_KEY	NUMBER		Yes	System generated unique identifier for event offering .
L1_EVENT_PK_KEY	NUMBER			System generated unique identifier for event header .
L0_ALL_PK_KEY	NUMBER			System generated unique identifier for all level .
L0_ALL_PK	VARCHAR2	(40)		Unique identifier for all level .
L0_NAME	VARCHAR2	(80)		Reserved for future use in Express .
L1_EVENT_PK	VARCHAR2	(320)		Unique identifier for event header .
L1_EVENT_DP	VARCHAR2	(240)		Field for discoverer so customers can have a display column that identifies all records uniquely .
L1_NAME	VARCHAR2	(320)		Reserved for future use in Express .
L1_EVENT_HEADER_ID	NUMBER
L1_PARENT_EVENT_HEADER_ID	NUMBER
L1_EVENT_LEVEL	VARCHAR2	(40)		'MAIN' or 'SUB'. MAIN for the Master Event Row. SUB for the Agenda Row.
L1_EVENT_TYPE_CODE	VARCHAR2	(40)		Type of the Event. For example, Seminar / Exhibition / Trade Show. These values are seeded. This value gets copied to corresponding Event Offerings. The Marketer can change it at the Event Offering level.
L1_USER_STATUS_ID	NUMBER			This field keeps track of the System Status for this Event. This field gets updated as and when the Event proceeds in the approval chain.
L1_SYSTEM_STATUS_CODE	VARCHAR2	(40)		This field ties in with the USER_STATUS_ID .
L1_LAST_STATUS_DATE	DATE			This field ties in with USER_STATUS_ID. This date is the date when the USER_STATUS_ID was last changed.
L1_REG_REQUIRED_FLAG	VARCHAR2	(20)		Marks whether Registration is required for this Event. For Open-door, walk-in events this flag will be equal to 'N'.
L1_REG_INVITED_ONLY_FLAG	VARCHAR2	(20)		This flag indicates whether the Registration is open for only those on the Invitee List.
L1_REG_CHARGE_FLAG	VARCHAR2	(20)		This flag indicates whether the Registrant / Attendee needs to pay for the Event.
L1_EVENT_STANDALONE_FLAG	VARCHAR2	(20)		This flag indicates whether this is Standalone which means a One-time Only Event. For a Standalone Event, the marketer will not see any difference between the Master Event and the corresponding Event Offering.
L1_REG_MINIMUM_CAPACITY	NUMBER			Registration Minimum Capacity defined at the Master Event level. This field gets copied to the corresponding Event Offerings. The Marketer will be able to change the Minimum Registration Capacity for each of the Event Offerings.
L1_REG_MAXIMUM_CAPACITY	NUMBER			Registration Maximum Capacity defined at the Master Event level. This field gets copied to the corresponding Event Offerings. The Marketer will be able to change the Maximum Registration Capacity for each of the Event Offerings.
L1_SOURCE_CODE	VARCHAR2	(40)		Master Event Source Code. This is mainly to track Responses to the Source. The Responses for this Event will specify this Source Code.
L1_DURATION	NUMBER			Event Duration. This is just a number. It makes sense when it is tied with the DURATION_UOM_CODE.
L1_DURATION_UOM_CODE	VARCHAR2	(20)		Ties in with the DURATION_UOM. This is the Unit of Measure for the Duration of the Event.
L1_DAY_OF_EVENT	VARCHAR2	(40)		Not used in warehouse .
L1_COORDINATOR_ID	NUMBER			Not used in warehouse .
L1_OWNER_USER_ID	NUMBER			User ID of the Owner of the Master Event.
L1_INVENTORY_ITEM_ID	NUMBER			This is the Inventory Item ID for the Master Event when this Master Event is charged for and the orders will then come against this Inventory Item ID. This is part of the Order Capture Integration.
L1_ORG_ID	NUMBER			This is for the multi-org. Organization ID.
L1_CERT_CREDIT_TYPE_CODE	VARCHAR2	(40)		If this Event is part of one of the Certification Programs, this field denotes the Caertification Credit Type for this event.
L1_CERTIFICATION_CREDITS	NUMBER			If this Event is part of one of the Certification Programs, this field denotes the number of Certification Credits the attendee will get after completely attending this Event.
L1_STREAM_TYPE_CODE	VARCHAR2	(40)		Not used in warehouse .
L1_PARTNER_FLAG	VARCHAR2	(20)		This field is not used in this release. This is for the future use.
L1_OVERFLOW_FLAG	VARCHAR2	(20)		Flag to indicate whether it is OK to allow more registrations than the number of currently available seats. This flag allows Marketer to schedule another offering of the same event if Overflow is allowed.
L1_MAIN_LANGUAGE_CODE	VARCHAR2	(20)		Main Language Code for the Master Event.
L1_CANCELLATION_REASON_CODE	VARCHAR2	(320)		When the Master Event is cancelled, the cancellation reason is recorded here. These values are seeded in OLTP .
L1_PRIORITY_TYPE_CODE	VARCHAR2	(320)		Master Event Priority. This value is just recorded. There is no business logic around it.
L1_AGENDA_START_TIME	DATE			Not used in warehouse .
L1_AGENDA_END_TIME	DATE			Not used in warehouse .
L1_ACTIVE_FROM_DATE	DATE			This is the date when the Master Event will be active from.
L1_ACTIVE_TO_DATE	DATE			This is the date till which the Master Event will be active .
L1_INBOUND_SCRIPT_NAME	VARCHAR2	(320)		The name of the questionaire which must be filled up by the call center when a customer calls in for this Master Event. This field gets copied to the corresponding Event Offerings. The Marketer can change it for each Event Offering.
L1_EMAIL	VARCHAR2	(320)		Email ID associated with this Master Event. Customers can send emails to this email address to gain more information about the Event. This field gets copied to the corresponding Event Offerings. The Marketer can change it for each Event Offering.
L1_PHONE	VARCHAR2	(320)		Phone number for the customers to call in for this Master Event. This field gets copied to the corresponding Event Offerings. The Marketer can change it for each Event Offering.
L1_URL	VARCHAR2	(4000)		URL associated with the Master Event. This could be for the web site created for this Master Event. This field gets copied to the corresponding Event Offerings. The Marketer can change it for each Event Offering.
L1_EVENT_MKTG_MESSAGE	VARCHAR2	(4000)		Marketing message of the event header .
L1_EVENT_HEADER_NAME	VARCHAR2	(320)		Name of the event header .
L1_DESCRIPTION	VARCHAR2	(4000)		Long description of the event header .
L1_INSTANCE	VARCHAR2	(40)		Instance identifier .
L1_USER_ATTRIBUTE1	VARCHAR2	(240)		User Attribute .
L1_USER_ATTRIBUTE2	VARCHAR2	(240)		User Attribute .
L1_USER_ATTRIBUTE3	VARCHAR2	(240)		User Attribute .
L1_USER_ATTRIBUTE4	VARCHAR2	(240)		User Attribute .
L1_USER_ATTRIBUTE5	VARCHAR2	(240)		User Attribute .
L2_EVTOFFER_PK	VARCHAR2	(320)		Unique identifier for event offering .
L2_EVTOFFER_DP	VARCHAR2	(240)		Field for discoverer so customers can have a display column that identifies all records uniquely .
L2_NAME	VARCHAR2	(320)		Reserved for future use in Express .
L2_LEVEL_NAME	VARCHAR2	(80)		Indicates whether record is an Event Header or an Event Offering .
L2_EVTOFFER_ID	NUMBER			OLTP System Generated Unique Identifier for Event Offering .
L2_PARENT_EVENT_OFFER_ID	NUMBER			Not used in warehouse .
L2_EVENT_HEADER_ID	NUMBER			OLTP System Generated Unique Identifier for the Event Header .
L2_EVENT_LEVEL	VARCHAR2	(40)		'MAIN' for the Event Offering rows. 'SUB' for the Event Offering Agenda Rows.
L2_EVENT_TYPE_CODE	VARCHAR2	(40)		Type of the Event Offering. For example, Seminar / Exhibition / Trade Show. These values are seeded. This value gets copied from the corresponding Master Event. The Marketer can change it.
L2_USER_STATUS_ID	NUMBER			This field keeps track of the User Status for this Event. This field gets updated as and when the Event proceeds in the approval chain.
L2_LAST_STATUS_DATE	DATE			This field ties in with USER_STATUS_ID. This date is the date when the USER_STATUS_ID was last changed.
L2_SYSTEM_STATUS_CODE	VARCHAR2	(40)		System Status Code corresponding to USER_STATUS_ID .
L2_TIMEZONE_ID	NUMBER			Timezone under which the Event Offering location falls in.
L2_REG_WAITLIST_PCT	NUMBER			If REG_WAITLIST_ALLOWED_FLAG is 'Y', this field defines what is the percentage of entries allowed in the waitlist. This percentage is with respect to the REG_MAXIMUM_CAPACITY.
L2_REG_OVERBOOK_PCT	NUMBER			If REG_OVERBOOK_ALLOWED_FLAG is 'Y'. This field defines the percentage of allowed Overbooking.
L2_REG_MINIMUM_CAPACITY	NUMBER			Registration Minimum Capacity defined at the Event Offering level.
L2_REG_MAXIMUM_CAPACITY	NUMBER			Registration Maximum Capacity defined at the Event Offering level.
L2_REG_EFFECTIVE_CAPACITY	NUMBER			This is a derived field. It tells the Effective Capacity, after looking at the REG_MAXIMUM_CAPACITY, REG_OVERBOOK_ALLOWED_FLAG and REG_OVERBOOK_PCT.
L2_PRICELIST_LINE_ID	NUMBER			Ties in with the Pricelist Header ID.
L2_PRICELIST_HEADER_ID	NUMBER			Pricelist Header ID of the Base Pricelist generated for this Event Offering.
L2_OWNER_USER_ID	NUMBER			User ID of the Owner of the Event Offering.
L2_ORG_ID	NUMBER			This is for the multi-org. Organization Identifier.
L2_INVENTORY_ITEM_ID	NUMBER			This is the Inventory Item ID for the Event Offering when this Event Offering is charged for and the orders will then come against this Inventory Item ID. This is part of the Order Capture Integration.
L2_EVENT_LOCATION_ID	NUMBER			Location for the Event Offering.
L2_EVENT_DURATION	NUMBER			Event Offering Duration. This is just a number. It makes sense when it is tied with the EVENT_DURATION_UOM_CODE.
L2_EVENT_DELIVERY_METHOD_ID	NUMBER			Channel which is same as the 'Delivery Method' through which this Event Offering is to be delivered to the customers.
L2_COORDINATOR_ID	NUMBER			Not used in warehouse .
L2_CERTIFICATION_CREDITS	NUMBER			If this Event Offering is part of one of the Certification Programs, this field denotes the number of Certification Credits the attendee will get after completely attending this Event Offering.
L2_WAITLIST_ACTION_TYPE_CODE	VARCHAR2	(40)		Action Type to be used when the Waitlist is prioritized. For example, it could be first-come-First-served.
L2_STREAM_TYPE_CODE	VARCHAR2	(40)		Not used in warehouse .
L2_SOURCE_CODE	VARCHAR2	(40)		Event Offering Source Code. This is mainly to track Responses to the Source. The Responses for this Event Offering will specify this Source Code.
L2_REG_WAITLIST_ALLOWED_FLAG	VARCHAR2	(20)		Flag to indicate whether Wait-list is allowed for this Event Offering.
L2_REG_START_TIME	DATE			The time on the Registration Start Date, when the Registration can start.
L2_REG_REQUIRED_FLAG	VARCHAR2	(20)		Marks whether Registration is required for this Event Offering. For Open-door, walk-in events. This flag will be equal to 'N'.
L2_REG_OVERBOOK_ALLOWED_FLAG	VARCHAR2	(20)		Tells whether it is OK to overbook this Event Offering.
L2_REG_INVITED_ONLY_FLAG	VARCHAR2	(20)		This flag indicates whether the Registration is open for only those on the Invitee List.
L2_REG_FROZEN_FLAG	VARCHAR2	(20)		Indicates whether registration for this Event Offering is frozen. If this flag is 'Y', no more registration will be allowed.
L2_REG_END_TIME	DATE			The Time on the REG_END_DATE when the Registration should stop.
L2_REG_CHARGE_FLAG	VARCHAR2	(20)		This flag indicates whether the Registrant / Attendee needs to pay for the Event.
L2_PRIORITY_TYPE_CODE	VARCHAR2	(40)		Priority of the Event Offering. This value is just recorded. There is no business logic arround it.
L2_PARTNER_FLAG	VARCHAR2	(20)		Not used in this release .
L2_OVERFLOW_FLAG	VARCHAR2	(20)		Flag to indicate whether it is OK to allow more registrations than the number of currently available seats. This flag allows Marketer to schedule another offering if Overflow is allowed.
L2_EVENT_START_DATE_TIME	DATE			Not used in warehouse .
L2_EVENT_STANDALONE_FLAG	VARCHAR2	(20)		This flag indicates whether this is Standalone which means a One-time Only Event. For a Standalone Event, the marketer will not see any difference between the Master Event and the corresponding Event Offering.
L2_EVENT_REQUIRED_FLAG	VARCHAR2	(20)		Not Used .
L2_EVENT_LANGUAGE_CODE	VARCHAR2	(40)		Main language for this Event Offering.
L2_EVENT_FULL_FLAG	VARCHAR2	(20)		Indicates whether the Event is filled to the capacity.
L2_EVENT_END_DATE_TIME	DATE			Not used in warehouse .
L2_EVENT_DURATION_UOM_CODE	VARCHAR2	(20)		Ties in with the EVENT_ DURATION. This is the Unit of Measure for the Duration of the Event Offering.
L2_CERT_CREDIT_TYPE_CODE	VARCHAR2	(40)		If this Event Offering is part of one of the Certification Programs, this field denotes the Caertification Credit Type for this event offering.
L2_CANCELLATION_REASON_CODE	VARCHAR2	(40)		If this Event Offering is cancelled for some reason, the cancellation reason is recorded here. The values are seeded.
L2_INBOUND_SCRIPT_NAME	VARCHAR2	(320)		The name of the questionaire which must be filled up by the call center when a customer calls in for this Event Offering. This field gets copied from the corresponding Master Event. The Marketer can change it.
L2_EMAIL	VARCHAR2	(320)		Email ID associated with this Event Offering. Customers can send emails to this email address to gain more information about the Event Offering. This field gets copied from the corresponding Master Event. The Marketer can change it.
L2_PHONE	VARCHAR2	(320)		Phone number for the customers to call in for this Event Offering. This field gets copied from the corresponding Master Event. The Marketer can change it.
L2_URL	VARCHAR2	(4000)		URL associated with the Event Offering. This could be for the web site created for this Event Offering. This field gets copied from the corresponding Master Event. The Marketer can change it.
L2_AUTO_REGISTER_FLAG	VARCHAR2	(20)		Indicates whether registration is automatic .
L2_EVENT_VENUE_ID	NUMBER			Not used in warehouse .
L2_REG_START_DATE	DATE			Date when the Registrations Can start for this Event Offering.
L2_REG_MINIMUM_REQ_BY_DATE	DATE			Date by which the Minimum Registration Capacity must be filled.
L2_REG_END_DATE	DATE			The Date when the Registration must stop.
L2_EVENT_START_DATE	DATE			Start Date of Event Offering .
L2_EVENT_END_DATE	DATE			End Date of Event Offering .
L2_EVENT_MKTG_MESSAGE	VARCHAR2	(320)		Marketing Message for the Event Offering .
L2_EVENT_OFFER_NAME	VARCHAR2	(320)		Name of the Event Offering .
L2_DESCRIPTION	VARCHAR2	(4000)		Long Description of the Event Offering .
L2_INSTANCE	VARCHAR2	(40)		Instance identifier .
L2_USER_ATTRIBUTE1	VARCHAR2	(240)		User attribute .
L2_USER_ATTRIBUTE2	VARCHAR2	(240)		User attribute .
L2_USER_ATTRIBUTE3	VARCHAR2	(240)		User attribute .
L2_USER_ATTRIBUTE4	VARCHAR2	(240)		User attribute .
L2_USER_ATTRIBUTE5	VARCHAR2	(240)		User attribute .
L2_LAST_UPDATE_DATE	DATE			Standard Who Column .
L2_CREATION_DATE	DATE			Standard Who Column .
SECURITY_GROUP_ID	NUMBER			Standard Who Column .
CREATION_DATE	DATE		Yes
LAST_UPDATE_DATE	DATE		Yes

Query Text

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


SELECT L2_EVTOFFER_PK_KEY
,      L1_EVENT_PK_KEY
,      L0_ALL_PK_KEY
,      L0_ALL_PK
,      L0_NAME
,      L1_EVENT_PK
,      L1_EVENT_DP
,      L1_NAME
,      L1_EVENT_HEADER_ID
,      L1_PARENT_EVENT_HEADER_ID
,      L1_EVENT_LEVEL
,      L1_EVENT_TYPE_CODE
,      L1_USER_STATUS_ID
,      L1_SYSTEM_STATUS_CODE
,      L1_LAST_STATUS_DATE
,      L1_REG_REQUIRED_FLAG
,      L1_REG_INVITED_ONLY_FLAG
,      L1_REG_CHARGE_FLAG
,      L1_EVENT_STANDALONE_FLAG
,      L1_REG_MINIMUM_CAPACITY
,      L1_REG_MAXIMUM_CAPACITY
,      L1_SOURCE_CODE
,      L1_DURATION
,      L1_DURATION_UOM_CODE
,      L1_DAY_OF_EVENT
,      L1_COORDINATOR_ID
,      L1_OWNER_USER_ID
,      L1_INVENTORY_ITEM_ID
,      L1_ORG_ID
,      L1_CERT_CREDIT_TYPE_CODE
,      L1_CERTIFICATION_CREDITS
,      L1_STREAM_TYPE_CODE
,      L1_PARTNER_FLAG
,      L1_OVERFLOW_FLAG
,      L1_MAIN_LANGUAGE_CODE
,      L1_CANCELLATION_REASON_CODE
,      L1_PRIORITY_TYPE_CODE
,      L1_AGENDA_START_TIME
,      L1_AGENDA_END_TIME
,      L1_ACTIVE_FROM_DATE
,      L1_ACTIVE_TO_DATE
,      L1_INBOUND_SCRIPT_NAME
,      L1_EMAIL
,      L1_PHONE
,      L1_URL
,      L1_EVENT_MKTG_MESSAGE
,      L1_EVENT_HEADER_NAME
,      L1_DESCRIPTION
,      L1_INSTANCE
,      L1_USER_ATTRIBUTE1
,      L1_USER_ATTRIBUTE2
,      L1_USER_ATTRIBUTE3
,      L1_USER_ATTRIBUTE4
,      L1_USER_ATTRIBUTE5
,      L2_EVTOFFER_PK
,      L2_EVTOFFER_DP
,      L2_NAME
,      L2_LEVEL_NAME
,      L2_EVTOFFER_ID
,      L2_PARENT_EVENT_OFFER_ID
,      L2_EVENT_HEADER_ID
,      L2_EVENT_LEVEL
,      L2_EVENT_TYPE_CODE
,      L2_USER_STATUS_ID
,      L2_LAST_STATUS_DATE
,      L2_SYSTEM_STATUS_CODE
,      L2_TIMEZONE_ID
,      L2_REG_WAITLIST_PCT
,      L2_REG_OVERBOOK_PCT
,      L2_REG_MINIMUM_CAPACITY
,      L2_REG_MAXIMUM_CAPACITY
,      L2_REG_EFFECTIVE_CAPACITY
,      L2_PRICELIST_LINE_ID
,      L2_PRICELIST_HEADER_ID
,      L2_OWNER_USER_ID
,      L2_ORG_ID
,      L2_INVENTORY_ITEM_ID
,      L2_EVENT_LOCATION_ID
,      L2_EVENT_DURATION
,      L2_EVENT_DELIVERY_METHOD_ID
,      L2_COORDINATOR_ID
,      L2_CERTIFICATION_CREDITS
,      L2_WAITLIST_ACTION_TYPE_CODE
,      L2_STREAM_TYPE_CODE
,      L2_SOURCE_CODE
,      L2_REG_WAITLIST_ALLOWED_FLAG
,      L2_REG_START_TIME
,      L2_REG_REQUIRED_FLAG
,      L2_REG_OVERBOOK_ALLOWED_FLAG
,      L2_REG_INVITED_ONLY_FLAG
,      L2_REG_FROZEN_FLAG
,      L2_REG_END_TIME
,      L2_REG_CHARGE_FLAG
,      L2_PRIORITY_TYPE_CODE
,      L2_PARTNER_FLAG
,      L2_OVERFLOW_FLAG
,      L2_EVENT_START_DATE_TIME
,      L2_EVENT_STANDALONE_FLAG
,      L2_EVENT_REQUIRED_FLAG
,      L2_EVENT_LANGUAGE_CODE
,      L2_EVENT_FULL_FLAG
,      L2_EVENT_END_DATE_TIME
,      L2_EVENT_DURATION_UOM_CODE
,      L2_CERT_CREDIT_TYPE_CODE
,      L2_CANCELLATION_REASON_CODE
,      L2_INBOUND_SCRIPT_NAME
,      L2_EMAIL
,      L2_PHONE
,      L2_URL
,      L2_AUTO_REGISTER_FLAG
,      L2_EVENT_VENUE_ID
,      L2_REG_START_DATE
,      L2_REG_MINIMUM_REQ_BY_DATE
,      L2_REG_END_DATE
,      L2_EVENT_START_DATE
,      L2_EVENT_END_DATE
,      L2_EVENT_MKTG_MESSAGE
,      L2_EVENT_OFFER_NAME
,      L2_DESCRIPTION
,      L2_INSTANCE
,      L2_USER_ATTRIBUTE1
,      L2_USER_ATTRIBUTE2
,      L2_USER_ATTRIBUTE3
,      L2_USER_ATTRIBUTE4
,      L2_USER_ATTRIBUTE5
,      L2_LAST_UPDATE_DATE
,      L2_CREATION_DATE
,      SECURITY_GROUP_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM BIM.EDW_BIM_EVENTS_M;

Dependencies

[top of page]

BIM.EDW_BIM_EVENTS_M does not reference any database object

BIM.EDW_BIM_EVENTS_M is referenced by following:

APPS: EDW_BIM_EVENTS_M