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

TABLE: BIM.BIM_R_EVEN_LOAD

Object Details
Object Name: BIM_R_EVEN_LOAD
Object Type: TABLE
Owner: BIM
Subobject Name:
Status: VALID


AMS_R_CAMP_DAILY_FACTS will keep Event daily facts for analytical reports


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
EVENT_DAILY_TRANSACTION_ID NUMBER
Yes unique identifier
CREATION_DATE DATE
Yes standard who column
CREATED_BY NUMBER
Yes standard who column
LAST_UPDATE_DATE DATE
Yes standard who column
LAST_UPDATED_BY NUMBER
Yes standard who column
LAST_UPDATE_LOGIN NUMBER

standard who column
EVENT_HEADER_ID NUMBER

event header id for event
EVENT_OFFER_ID NUMBER

event offer id for event
PARENT_ID NUMBER

parent id for event
EVENT_TYPE VARCHAR2 (30)
event type for event
EVENT_OFFER_TYPE VARCHAR2 (30)
event offer type for event
HDR_SOURCE_CODE VARCHAR2 (30)
header source code for event
SOURCE_CODE VARCHAR2 (30)
event source code for event
BUSINESS_UNIT_ID NUMBER

business unit id
COUNTRY NUMBER (30)
country where event was held
STATUS VARCHAR2 (30)
status of event
EVENT_BUDGET_AMT_FC NUMBER

event budget amount forecasted
OFFER_BUDGET_AMT_FC NUMBER

event offer budget amount forecast
START_DATE DATE

event start date
END_DATE DATE

event end date
EVENT_VENUE_ID NUMBER

event venue id for event
REGISTRATIONS NUMBER

number of registrations for event
CANCELLATIONS NUMBER

number of cancellations for event
LEADS_QUALIFIED NUMBER

number leads qualified for event
LEADS_QUALIFIED_AMT NUMBER

amount of leads qualified for event
LEADS_UNQUALIFIED NUMBER

number of leads unqualified for event
LEADS_UNQUALIFIED_AMT NUMBER

amount of leads qualified for event
OPPORTUNITIES NUMBER

number of event opportunites
OPPORTUNITY_AMT NUMBER

amount of event opportunites
ATTENDANCE NUMBER

number of attendance for event
FORECASTED_COST NUMBER

amount of forecasted cost for events
ACTUAL_COST NUMBER

amount of actual cost for event
REVENUE NUMBER

amount of revenue for event
ORDER_AMT NUMBER

amount of order for event
BUDGET_REQUESTED NUMBER

amount of budget requested for event
BUDGET_APPROVED NUMBER

amount of budget approved for event
CUSTOMER NUMBER

number of customer for event
CURRENCY_CODE VARCHAR2 (15)
currency code
TRANSACTION_CREATE_DATE DATE
Yes Creation date of the transaction.
ASSOCIATED_OBJECT_TYPE VARCHAR2 (30)
associated object type for event
ASSOCIATED_OBJECT_ID NUMBER

associated object id for event
DELETE_FLAG VARCHAR2 (1)
delete flag are used when records need to be deleted
SECURITY_GROUP_CODE NUMBER

This column is used in hosted environments
SECURITY_GROUP_ID NUMBER

This column is used in hosted environments
LOAD_DATE DATE

This column provides the week end date of the transaction create date.
ORG_ID NUMBER

organization id
MONTH VARCHAR2 (30)
Fiscal Period Month
QTR VARCHAR2 (30)
Fiscal Period Quarter
YEAR VARCHAR2 (30)
Fiscal Period Year
ACTUAL_REVENUE NUMBER

Actual Revenue
FORECASTED_REVENUE NUMBER

Forecasted Revenue
BOOKED_ORDERS NUMBER

Number of Orders Booked
BOOKED_ORDERS_AMT NUMBER

Booked Orders Amount
LEADS_OPEN NUMBER

Number of Leads Open
LEADS_OPEN_AMT NUMBER

Total Budget of the Open Leads
LEADS_CLOSED NUMBER

Number of Leads Closed
LEADS_CLOSED_AMT NUMBER

Total Budget of the Leads Closed
LEADS_NEW NUMBER

Number of new leads
LEADS_NEW_AMT NUMBER

Total amount of new leads
LEADS_HOT NUMBER

Number of hot leads
LEADS_CONVERTED NUMBER

Number of leads converted to oppertunity
METRIC1 NUMBER

additional metrics column
METRIC2 NUMBER

additional metrics column
METRIC3 NUMBER

additional metrics column
METRIC4 NUMBER

additional metrics column
METRIC5 NUMBER

additional metrics column
METRIC6 NUMBER

additional metrics column
METRIC7 NUMBER

additional metrics column
METRIC8 NUMBER

additional metrics column
METRIC9 NUMBER

additional metrics column
METRIC10 NUMBER

additional metrics column
METRIC11 NUMBER

additional metrics column
METRIC12 NUMBER

additional metrics column
METRIC13 NUMBER

additional metrics column
METRIC14 NUMBER

additional metrics column
METRIC15 NUMBER

additional metrics column
Query Text

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


SELECT EVENT_DAILY_TRANSACTION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      EVENT_HEADER_ID
,      EVENT_OFFER_ID
,      PARENT_ID
,      EVENT_TYPE
,      EVENT_OFFER_TYPE
,      HDR_SOURCE_CODE
,      SOURCE_CODE
,      BUSINESS_UNIT_ID
,      COUNTRY
,      STATUS
,      EVENT_BUDGET_AMT_FC
,      OFFER_BUDGET_AMT_FC
,      START_DATE
,      END_DATE
,      EVENT_VENUE_ID
,      REGISTRATIONS
,      CANCELLATIONS
,      LEADS_QUALIFIED
,      LEADS_QUALIFIED_AMT
,      LEADS_UNQUALIFIED
,      LEADS_UNQUALIFIED_AMT
,      OPPORTUNITIES
,      OPPORTUNITY_AMT
,      ATTENDANCE
,      FORECASTED_COST
,      ACTUAL_COST
,      REVENUE
,      ORDER_AMT
,      BUDGET_REQUESTED
,      BUDGET_APPROVED
,      CUSTOMER
,      CURRENCY_CODE
,      TRANSACTION_CREATE_DATE
,      ASSOCIATED_OBJECT_TYPE
,      ASSOCIATED_OBJECT_ID
,      DELETE_FLAG
,      SECURITY_GROUP_CODE
,      SECURITY_GROUP_ID
,      LOAD_DATE
,      ORG_ID
,      MONTH
,      QTR
,      YEAR
,      ACTUAL_REVENUE
,      FORECASTED_REVENUE
,      BOOKED_ORDERS
,      BOOKED_ORDERS_AMT
,      LEADS_OPEN
,      LEADS_OPEN_AMT
,      LEADS_CLOSED
,      LEADS_CLOSED_AMT
,      LEADS_NEW
,      LEADS_NEW_AMT
,      LEADS_HOT
,      LEADS_CONVERTED
,      METRIC1
,      METRIC2
,      METRIC3
,      METRIC4
,      METRIC5
,      METRIC6
,      METRIC7
,      METRIC8
,      METRIC9
,      METRIC10
,      METRIC11
,      METRIC12
,      METRIC13
,      METRIC14
,      METRIC15
FROM BIM.BIM_R_EVEN_LOAD;

Dependencies

[top of page]

BIM.BIM_R_EVEN_LOAD does not reference any database object

BIM.BIM_R_EVEN_LOAD is referenced by following:

SchemaAPPS
SynonymBIM_R_EVEN_LOAD