[Home] [Help] [Dependency Information]
Object Name: | EDW_BIM_EVNT_EVENTS_LSTG |
---|---|
Object Type: | TABLE |
Owner: | BIM |
FND Design Data: | BIM.EDW_BIM_EVNT_EVENTS_LSTG |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
EDW_BIM_EVNT_EVENTS_LSTG_N1 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | EVENT_PK |
EDW_BIM_EVNT_EVENTS_LSTG_N2 | NORMAL | NONUNIQUE | APPS_TS_ARCHIVE | COLLECTION_STATUS |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EVENT_PK | VARCHAR2 | (320) | Unique Identifier for Event | |
ROW_ID | ROWID | (10) | Row Identifier | |
ALL_FK | VARCHAR2 | (40) | Foreign Key to All Level of the Event Dimension | |
ALL_FK_KEY | NUMBER | System Generated Foreign Key to All Level of Event Dimension | ||
EVENT_DP | VARCHAR2 | (240) | Field for discoverer so customers can have a display column that identifies all records uniquely | |
NAME | VARCHAR2 | (320) | Reserved for future use in Express | |
EVENT_HEADER_ID | NUMBER | OLTP System Generated Unique Identifier for Event | ||
PARENT_EVENT_HEADER_ID | NUMBER | Not used in warehouse . | ||
EVENT_LEVEL | VARCHAR2 | (40) | 'MAIN' or 'SUB'. MAIN for the Master Event Row. SUB for the Agenda Row. | |
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. | |
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. | ||
SYSTEM_STATUS_CODE | VARCHAR2 | (40) | This field ties in with the USER_STATUS_ID . | |
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. | ||
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'. | |
REG_INVITED_ONLY_FLAG | VARCHAR2 | (20) | This flag indicates whether the Registration is open for only those on the Invitee List. | |
REG_CHARGE_FLAG | VARCHAR2 | (20) | This flag indicates whether the Registrant / Attendee needs to pay for the Event. | |
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. | |
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. | ||
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. | ||
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. | |
DURATION | NUMBER | Event Duration. This is just a number. It makes sense when it is tied with the DURATION_UOM_CODE. | ||
DURATION_UOM_CODE | VARCHAR2 | (20) | Ties in with the DURATION_UOM. This is the Unit of Measure for the Duration of the Event. | |
DAY_OF_EVENT | VARCHAR2 | (40) | Not used in warehouse . | |
COORDINATOR_ID | NUMBER | Not used in warehouse . | ||
OWNER_USER_ID | NUMBER | User ID of the Owner of the Master Event. | ||
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. | ||
ORG_ID | NUMBER | This is for the multi-org. Organization ID. | ||
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. | |
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. | ||
STREAM_TYPE_CODE | VARCHAR2 | (40) | Not used in warehouse . | |
PARTNER_FLAG | VARCHAR2 | (20) | This field is not used in this release. This is for the future use. | |
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. | |
MAIN_LANGUAGE_CODE | VARCHAR2 | (20) | Main Language Code for the Master Event. | |
CANCELLATION_REASON_CODE | VARCHAR2 | (320) | When the Master Event is cancelled, the cancellation reason is recorded here. These values are seeded in OLTP . | |
PRIORITY_TYPE_CODE | VARCHAR2 | (320) | Master Event Priority. This value is just recorded. There is no business logic around it. | |
AGENDA_START_TIME | DATE | Not used in warehouse . | ||
AGENDA_END_TIME | DATE | Not used in warehouse . | ||
ACTIVE_FROM_DATE | DATE | This is the date when the Master Event will be active from. | ||
ACTIVE_TO_DATE | DATE | This is the date till which the Master Event will be active . | ||
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. | |
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. | ||
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. | |
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. | |
EVENT_MKTG_MESSAGE | VARCHAR2 | (4000) | Marketing message of the event header . | |
EVENT_HEADER_NAME | VARCHAR2 | (320) | Name of the event header . | |
DESCRIPTION | VARCHAR2 | (4000) | Long description of the event header . | |
INSTANCE | VARCHAR2 | (40) | Instance identifier . | |
USER_ATTRIBUTE1 | VARCHAR2 | (240) | User Attribute . | |
USER_ATTRIBUTE2 | VARCHAR2 | (240) | User Attribute . | |
USER_ATTRIBUTE3 | VARCHAR2 | (240) | User Attribute . | |
USER_ATTRIBUTE4 | VARCHAR2 | (240) | User Attribute . | |
USER_ATTRIBUTE5 | VARCHAR2 | (240) | User Attribute . | |
REQUEST_ID | NUMBER | Standard Who Column . | ||
OPERATION_CODE | VARCHAR2 | (40) | Code used during warehouse collection . | |
ERROR_CODE | VARCHAR2 | (2000) | Code used to store error messages . | |
COLLECTION_STATUS | VARCHAR2 | (40) | Collection status code for the record . | |
SECURITY_GROUP_ID | NUMBER | Standard Who Column . |
Cut, paste (and edit) the following text to query this object:
SELECT EVENT_PK
, ROW_ID
, ALL_FK
, ALL_FK_KEY
, EVENT_DP
, NAME
, EVENT_HEADER_ID
, PARENT_EVENT_HEADER_ID
, EVENT_LEVEL
, EVENT_TYPE_CODE
, USER_STATUS_ID
, SYSTEM_STATUS_CODE
, LAST_STATUS_DATE
, REG_REQUIRED_FLAG
, REG_INVITED_ONLY_FLAG
, REG_CHARGE_FLAG
, EVENT_STANDALONE_FLAG
, REG_MINIMUM_CAPACITY
, REG_MAXIMUM_CAPACITY
, SOURCE_CODE
, DURATION
, DURATION_UOM_CODE
, DAY_OF_EVENT
, COORDINATOR_ID
, OWNER_USER_ID
, INVENTORY_ITEM_ID
, ORG_ID
, CERT_CREDIT_TYPE_CODE
, CERTIFICATION_CREDITS
, STREAM_TYPE_CODE
, PARTNER_FLAG
, OVERFLOW_FLAG
, MAIN_LANGUAGE_CODE
, CANCELLATION_REASON_CODE
, PRIORITY_TYPE_CODE
, AGENDA_START_TIME
, AGENDA_END_TIME
, ACTIVE_FROM_DATE
, ACTIVE_TO_DATE
, INBOUND_SCRIPT_NAME
, EMAIL
, PHONE
, URL
, EVENT_MKTG_MESSAGE
, EVENT_HEADER_NAME
, DESCRIPTION
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, REQUEST_ID
, OPERATION_CODE
, ERROR_CODE
, COLLECTION_STATUS
, SECURITY_GROUP_ID
FROM BIM.EDW_BIM_EVNT_EVENTS_LSTG;
BIM.EDW_BIM_EVNT_EVENTS_LSTG does not reference any database object
BIM.EDW_BIM_EVNT_EVENTS_LSTG is referenced by following:
|
|
|