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

TABLE: BIM.BIM_I_MARKETING_FACTS_STG

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


Staging table for marketing facts program


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

who column
TRANSACTION_CREATE_DATE DATE

Transaction Create Date
METRIC_TYPE VARCHAR2 (15)
Type of the metric
LEAD_ID NUMBER

Sales Lead ID
SOURCE_CODE_ID NUMBER

Source Code ID
OBJECT_TYPE VARCHAR2 (30)
Top Level Object like ECAM,EVEH etc.
OBJECT_ID NUMBER

Object Id like Campaign Id.
CHILD_OBJECT_TYPE VARCHAR2 (30)
ex. Campaign schedule or event offer
CHILD_OBJECT_ID NUMBER

like Schedule Id.
OBJECT_COUNTRY VARCHAR2 (30)
country where object was launched.
LEAD_RANK_ID NUMBER

ranking id for the lead generated.
OBJECT_REGION VARCHAR2 (30)
region where the object was launched.
CHILD_OBJECT_COUNTRY VARCHAR2 (30)
country where the child object was launched.
CHILD_OBJECT_REGION VARCHAR2 (30)
region where the child object was launched.
BUSINESS_UNIT_ID NUMBER

business unit id
START_DATE DATE

Object active date
END_DATE DATE

object end date
OBJECT_STATUS VARCHAR2 (30)
object status
CHILD_OBJECT_STATUS VARCHAR2 (30)
child object status
OBJECT_PURPOSE VARCHAR2 (240)
object purpose.
CHILD_OBJECT_PURPOSE VARCHAR2 (240)
child object purpose.
ACTIVITY_ID NUMBER

activity id
CATEGORY_ID NUMBER

Category ID
FROM_CURRENCY VARCHAR2 (30)
From Currency
CONVERSION_RATE NUMBER

Conversion Rate
CONVERSION_RATE_S NUMBER

For secondary currency
LEADS NUMBER

Number of Leads generated for the transaction create date.
OPPORTUNITIES NUMBER

opportunities.
OPPORTUNITY_AMT NUMBER

opportunity amount
OPPORTUNITY_AMT_S NUMBER

For secondary currency
OPPORTUNITIES_OPEN NUMBER

Number of Open opportunities.
ACTIVITY_TYPE VARCHAR2 (30)
Activity type.
ORDERS_BOOKED NUMBER

Number of orders booked.
ORDERS_BOOKED_AMT NUMBER

total amount generated by the orders booked.
ORDERS_BOOKED_AMT_S NUMBER

For secondary currency
REVENUE_FORECASTED NUMBER

Forecasted revenue.
REVENUE_FORECASTED_S NUMBER

For secondary currency
REVENUE_ACTUAL NUMBER

actual revenue
REVENUE_ACTUAL_S NUMBER

For secondary currency
COST_ACTUAL NUMBER

Actual Cost
COST_ACTUAL_S NUMBER

For secondary currency
BUDGET_APPROVED NUMBER

Approved Budget.
BUDGET_APPROVED_S NUMBER

For secondary currency
BUDGET_REQUESTED NUMBER

Requested Budget.
BUDGET_REQUESTED_S NUMBER

For secondary currency
RESPONSES_FORECASTED NUMBER

Forecasted Responses.
RESPONSES_POSITIVE NUMBER

Positive responses.
CUSTOMERS_NEW NUMBER

Number of New customers.
CUSTOMERS_TARGETED NUMBER

Targeted Customers
COST_FORECASTED NUMBER

Forecasted cost
COST_FORECASTED_S NUMBER

For secondary currency
REGISTRATIONS NUMBER

Number of People registered.
CANCELLATIONS NUMBER

Number of Cancellations
ATTENDANCE NUMBER

Number of People attended.
METRIC1 NUMBER

Metric1
METRIC2 NUMBER

Metric2
METRIC3 NUMBER

Metric3
METRIC4 NUMBER

Metric4
METRIC5 NUMBER

Metric5
METRIC6 NUMBER

Metric6
METRIC7 NUMBER

Metric7
METRIC8 NUMBER

Metric8
METRIC9 NUMBER

Metric9
METRIC10 NUMBER

Metric10
METRIC11 NUMBER

Metric11
METRIC12 NUMBER

Metric12
METRIC13 NUMBER

Metric13
METRIC14 NUMBER

Metric14
METRIC15 NUMBER

Metric15
SECURITY_GROUP_ID NUMBER

Security Group Id
Query Text

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


SELECT CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANSACTION_CREATE_DATE
,      METRIC_TYPE
,      LEAD_ID
,      SOURCE_CODE_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      CHILD_OBJECT_TYPE
,      CHILD_OBJECT_ID
,      OBJECT_COUNTRY
,      LEAD_RANK_ID
,      OBJECT_REGION
,      CHILD_OBJECT_COUNTRY
,      CHILD_OBJECT_REGION
,      BUSINESS_UNIT_ID
,      START_DATE
,      END_DATE
,      OBJECT_STATUS
,      CHILD_OBJECT_STATUS
,      OBJECT_PURPOSE
,      CHILD_OBJECT_PURPOSE
,      ACTIVITY_ID
,      CATEGORY_ID
,      FROM_CURRENCY
,      CONVERSION_RATE
,      CONVERSION_RATE_S
,      LEADS
,      OPPORTUNITIES
,      OPPORTUNITY_AMT
,      OPPORTUNITY_AMT_S
,      OPPORTUNITIES_OPEN
,      ACTIVITY_TYPE
,      ORDERS_BOOKED
,      ORDERS_BOOKED_AMT
,      ORDERS_BOOKED_AMT_S
,      REVENUE_FORECASTED
,      REVENUE_FORECASTED_S
,      REVENUE_ACTUAL
,      REVENUE_ACTUAL_S
,      COST_ACTUAL
,      COST_ACTUAL_S
,      BUDGET_APPROVED
,      BUDGET_APPROVED_S
,      BUDGET_REQUESTED
,      BUDGET_REQUESTED_S
,      RESPONSES_FORECASTED
,      RESPONSES_POSITIVE
,      CUSTOMERS_NEW
,      CUSTOMERS_TARGETED
,      COST_FORECASTED
,      COST_FORECASTED_S
,      REGISTRATIONS
,      CANCELLATIONS
,      ATTENDANCE
,      METRIC1
,      METRIC2
,      METRIC3
,      METRIC4
,      METRIC5
,      METRIC6
,      METRIC7
,      METRIC8
,      METRIC9
,      METRIC10
,      METRIC11
,      METRIC12
,      METRIC13
,      METRIC14
,      METRIC15
,      SECURITY_GROUP_ID
FROM BIM.BIM_I_MARKETING_FACTS_STG;

Dependencies

[top of page]

BIM.BIM_I_MARKETING_FACTS_STG does not reference any database object

BIM.BIM_I_MARKETING_FACTS_STG is referenced by following:

SchemaAPPS
SynonymBIM_I_MARKETING_FACTS_STG