[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EDW_BIM_EVNT_EVTOFFERS_LSTG |
|---|---|
| Object Type: | TABLE |
| Owner: | BIM |
| FND Design Data: |  BIM.EDW_BIM_EVNT_EVTOFFERS_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_EVTOFFERS_LSTG_N1 | NORMAL | NONUNIQUE |
APPS_TS_ARCHIVE
|
 EVTOFFER_PK
|
| EDW_BIM_EVNT_EVTOFFERS_LSTG_N2 | NORMAL | NONUNIQUE |
APPS_TS_ARCHIVE
|
COLLECTION_STATUS
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| EVTOFFER_PK | VARCHAR2 | (320) | Unique Identifier for Event Offering | |
| ROW_ID | ROWID | (10) | Row Identifier | |
| EVENT_FK | VARCHAR2 | (320) | Foreign Key to Event Header Level | |
| EVENT_FK_KEY | NUMBER | System Generated Foreign Key to Event Header Level . | ||
| EVTOFFER_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 | |
| LEVEL_NAME | VARCHAR2 | (80) | Indicates whether record is an Event Header or an Event Offering | |
| EVTOFFER_ID | NUMBER | OLTP System Generated Unique Identifier for Event Offering . | ||
| PARENT_EVENT_OFFER_ID | NUMBER | Not used in warehouse . | ||
| EVENT_HEADER_ID | NUMBER | OLTP System Generated Unique Identifier for the Event Header | ||
| EVENT_LEVEL | VARCHAR2 | (40) | 'MAIN' for the Event Offering rows. 'SUB' for the Event Offering Agenda Rows. | |
| 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. | |
| 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. | ||
| 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. | ||
| SYSTEM_STATUS_CODE | VARCHAR2 | (40) | System Status Code corresponding to USER_STATUS_ID | |
| TIMEZONE_ID | NUMBER | Timezone under which the Event Offering location falls in. | ||
| 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. | ||
| REG_OVERBOOK_PCT | NUMBER | If REG_OVERBOOK_ALLOWED_FLAG is 'Y'. This field defines the percentage of allowed Overbooking. | ||
| REG_MINIMUM_CAPACITY | NUMBER | Registration Minimum Capacity defined at the Event Offering level. | ||
| REG_MAXIMUM_CAPACITY | NUMBER | Registration Maximum Capacity defined at the Event Offering level. | ||
| 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. | ||
| PRICELIST_LINE_ID | NUMBER | Ties in with the Pricelist Header ID. | ||
| PRICELIST_HEADER_ID | NUMBER | Pricelist Header ID of the Base Pricelist generated for this Event Offering. | ||
| OWNER_USER_ID | NUMBER | User ID of the Owner of the Event Offering. | ||
| ORG_ID | NUMBER | This is for the multi-org. Organization Identifier. | ||
| 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. | ||
| EVENT_LOCATION_ID | NUMBER | Location for the Event Offering. | ||
| EVENT_DURATION | NUMBER | Event Offering Duration. This is just a number. It makes sense when it is tied with the EVENT_DURATION_UOM_CODE. | ||
| 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. | ||
| COORDINATOR_ID | NUMBER | Not used in warehouse . | ||
| 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. | ||
| 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. | |
| STREAM_TYPE_CODE | VARCHAR2 | (40) | Not used in warehouse | |
| 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. | |
| REG_WAITLIST_ALLOWED_FLAG | VARCHAR2 | (20) | Flag to indicate whether Wait-list is allowed for this Event Offering. | |
| REG_START_TIME | DATE | The time on the Registration Start Date, when the Registration can start. | ||
| 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'. | |
| REG_OVERBOOK_ALLOWED_FLAG | VARCHAR2 | (20) | Tells whether it is OK to overbook this Event Offering. | |
| REG_INVITED_ONLY_FLAG | VARCHAR2 | (20) | This flag indicates whether the Registration is open for only those on the Invitee List. | |
| 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. | |
| REG_END_TIME | DATE | The Time on the REG_END_DATE when the Registration should stop. | ||
| REG_CHARGE_FLAG | VARCHAR2 | (20) | This flag indicates whether the Registrant / Attendee needs to pay for the Event. | |
| PRIORITY_TYPE_CODE | VARCHAR2 | (40) | Priority of the Event Offering. This value is just recorded. There is no business logic arround it. | |
| PARTNER_FLAG | VARCHAR2 | (20) | Not used in this release . | |
| 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. | |
| EVENT_START_DATE_TIME | DATE | Not Used in Warehouse . | ||
| 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. | |
| EVENT_REQUIERED_FLAG | VARCHAR2 | (20) | ||
| EVENT_LANGUAGE_CODE | VARCHAR2 | (40) | Main language for this Event Offering. | |
| EVENT_FULL_FLAG | VARCHAR2 | (20) | Indicates whether the Event is filled to the capacity. | |
| EVENT_END_DATE_TIME | DATE | Not Used in Warehouse . | ||
| EVENT_DURATION_UOM_CODE | VARCHAR2 | (20) | Ties in with the EVEN_ DURATION. This is the Unit of Measure for the Duration of the Event Offering. | |
| 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. | |
| CANCELLATION_REASON_CODE | VARCHAR2 | (40) | If this Event Offering is cancelled for some reason, the cancellation reason is recorded here. The values are seeded. | |
| 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. | |
| 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. | ||
| 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. | |
| 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. | |
| AUTO_REGISTER_FLAG | VARCHAR2 | (20) | Indicates whether registration is automatic | |
| EVENT_VENUE_ID | NUMBER | Not used in warehouse | ||
| REG_START_DATE | DATE | Date when the Registrations Can start for this Event Offering. | ||
| REG_MINIMUM_REQ_BY_DATE | DATE | Date by which the Minimum Registration Capacity must be filled. | ||
| REG_END_DATE | DATE | The Date when the Registration must stop. | ||
| EVENT_START_DATE | DATE | Start Date of Event Offering . | ||
| EVENT_END_DATE | DATE | End Date of Event Offering . | ||
| EVENT_MKTG_MESSAGE | VARCHAR2 | (320) | Marketing Message for the Event Offering . | |
| EVENT_OFFER_NAME | VARCHAR2 | (320) | Name of the Event Offering . | |
| DESCRIPTION | VARCHAR2 | (4000) | Long Description of the Event Offering . | |
| 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 | |
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| CREATION_DATE | DATE | Standard Who Column | ||
| 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 | ||
| EVENT_REQUIRED_FLAG | VARCHAR2 | (20) | Not Used . |
Cut, paste (and edit) the following text to query this object:
SELECT EVTOFFER_PK
, ROW_ID
, EVENT_FK
, EVENT_FK_KEY
, EVTOFFER_DP
, NAME
, LEVEL_NAME
, EVTOFFER_ID
, PARENT_EVENT_OFFER_ID
, EVENT_HEADER_ID
, EVENT_LEVEL
, EVENT_TYPE_CODE
, USER_STATUS_ID
, LAST_STATUS_DATE
, SYSTEM_STATUS_CODE
, TIMEZONE_ID
, REG_WAITLIST_PCT
, REG_OVERBOOK_PCT
, REG_MINIMUM_CAPACITY
, REG_MAXIMUM_CAPACITY
, REG_EFFECTIVE_CAPACITY
, PRICELIST_LINE_ID
, PRICELIST_HEADER_ID
, OWNER_USER_ID
, ORG_ID
, INVENTORY_ITEM_ID
, EVENT_LOCATION_ID
, EVENT_DURATION
, EVENT_DELIVERY_METHOD_ID
, COORDINATOR_ID
, CERTIFICATION_CREDITS
, WAITLIST_ACTION_TYPE_CODE
, STREAM_TYPE_CODE
, SOURCE_CODE
, REG_WAITLIST_ALLOWED_FLAG
, REG_START_TIME
, REG_REQUIRED_FLAG
, REG_OVERBOOK_ALLOWED_FLAG
, REG_INVITED_ONLY_FLAG
, REG_FROZEN_FLAG
, REG_END_TIME
, REG_CHARGE_FLAG
, PRIORITY_TYPE_CODE
, PARTNER_FLAG
, OVERFLOW_FLAG
, EVENT_START_DATE_TIME
, EVENT_STANDALONE_FLAG
, EVENT_REQUIERED_FLAG
, EVENT_LANGUAGE_CODE
, EVENT_FULL_FLAG
, EVENT_END_DATE_TIME
, EVENT_DURATION_UOM_CODE
, CERT_CREDIT_TYPE_CODE
, CANCELLATION_REASON_CODE
, INBOUND_SCRIPT_NAME
, EMAIL
, PHONE
, URL
, AUTO_REGISTER_FLAG
, EVENT_VENUE_ID
, REG_START_DATE
, REG_MINIMUM_REQ_BY_DATE
, REG_END_DATE
, EVENT_START_DATE
, EVENT_END_DATE
, EVENT_MKTG_MESSAGE
, EVENT_OFFER_NAME
, DESCRIPTION
, INSTANCE
, USER_ATTRIBUTE1
, USER_ATTRIBUTE2
, USER_ATTRIBUTE3
, USER_ATTRIBUTE4
, USER_ATTRIBUTE5
, LAST_UPDATE_DATE
, CREATION_DATE
, REQUEST_ID
, OPERATION_CODE
, ERROR_CODE
, COLLECTION_STATUS
, SECURITY_GROUP_ID
, EVENT_REQUIRED_FLAG
FROM BIM.EDW_BIM_EVNT_EVTOFFERS_LSTG;
BIM.EDW_BIM_EVNT_EVTOFFERS_LSTG does not reference any database object
BIM.EDW_BIM_EVNT_EVTOFFERS_LSTG is referenced by following:
APPS
EDW_BIM_EVNT_EVTOFFERS_LSTG
|
|
|
|