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

TABLE: BIM.BIM_R_CAMP_DAILY_FACTS

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


AMS_R_CAMP_DAILY_FACTS will keep Campaign daily facts for analytical reports


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_R_CAMP_DAILY_FACTS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCAMPAIGN_DAILY_TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
CAMPAIGN_DAILY_TRANSACTION_ID NUMBER
Yes Unique Identifier.
CREATION_DATE DATE
Yes standard who column
LAST_UPDATE_DATE DATE
Yes standard who column
CREATED_BY NUMBER
Yes standard who column
LAST_UPDATED_BY NUMBER
Yes standard who column
LAST_UPDATE_LOGIN NUMBER

standard who column
CAMPAIGN_ID NUMBER

Id for the campaign
SCHEDULE_ID NUMBER

campaign schedule id for the campaign
PARENT_CAMPAIGN_ID NUMBER

parent id for campaign
CAMPAIGN_REGION VARCHAR2 (30)
region where campaign is held
SCHEDULE_REGION VARCHAR2 (30)
this column specified the region where the campaign schedule is held
CAMPAIGN_COUNTRY NUMBER (30)
this column specified the country where the campaign is held
SCHEDULE_COUNTRY NUMBER (30)
this column specified the country where the campaign schedule is held
CAMPAIGN_SOURCE_CODE VARCHAR2 (30)
Source Code of campaign
SCHEDULE_SOURCE_CODE VARCHAR2 (30)
source code of campaign schedule
START_DATE DATE

start date of campaign
END_DATE DATE

end date of campaign
BUSINESS_UNIT_ID NUMBER

Business unit id for campaign
CAMPAIGN_TYPE VARCHAR2 (30)
this column specified the type for campaign
SCHEDULE_ACTIVITY_TYPE VARCHAR2 (30)
Activity type for campaign schedule
SCHEDULE_ACTIVITY_ID NUMBER

Activity id for campaign schedule
CAMPAIGN_PURPOSE VARCHAR2 (240)
this column give a detailed campaign purpose
SCHEDULE_PURPOSE VARCHAR2 (240)
this column give a detailed campaign schedule purpose
CAMPAIGN_STATUS VARCHAR2 (30)
this column specify the status of campaign
CAMPAIGN_BUDGET_FC NUMBER

budget forecast for campaign
SCHEDULE_BUDGET_FC NUMBER

budeget forecase for campaign schedule
SCHEDULE_STATUS VARCHAR2 (30)
status for campaign schedule
LEADS_QUALIFIED NUMBER

number of lead qualified for campaign
LEADS_QUALIFIED_AMT NUMBER

amount of lead qualified for campaign
LEADS_UNQUALIFIED NUMBER

number of leads unqualied for campaign
LEADS_UNQUALIFIED_AMT NUMBER

amount of leads unqualified for campaign
OPPORTUNITIES NUMBER

number of opportunites for campaign
OPPORTUNITY_AMT NUMBER

amount of opportunity for campaign
ORDERS NUMBER

number of orders for campaign
ORDERS_ACTIVE NUMBER

number of orders active for campaign
ORDERS_ACTIVE_AMT NUMBER

amount of orders active of campaign
ORDERS_CANCELLED NUMBER

number of cancelled orders of campaign
ORDERS_CANCELLED_AMT NUMBER

amount of cancelled orders of campaign
POSITIVE_RESPONSES NUMBER

positive responses of campaign
FORECASTED_COST NUMBER

amount of forecasted cost of campaign
ACTUAL_COST NUMBER

amount of actual cost of campaign
REVENUE NUMBER

amount of revenue for campaign
TARGETED_CUSTOMERS NUMBER

number of targeted customers for campaign
BUDGET_REQUESTED NUMBER

budget requested for campaign
BUDGET_APPROVED NUMBER

budget approved for campaign
NEW_CUSTOMERS NUMBER

number new customers of campaign
CURRENCY_CODE VARCHAR2 (15)
currency code
RELATED_EVENT_TYPE VARCHAR2 (30)
this column specify the type for related campaign event
RELATED_EVENT_ID NUMBER

this column specify the id for related campaign event
TRANSACTION_CREATE_DATE DATE
Yes Creation date of the transaction.
DELETE_FLAG VARCHAR2 (1)
delete flag are used when records need to be deleted
ORG_ID NUMBER

organizaion id
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.
MONTH VARCHAR2 (30)
Fiscal period Month
QTR VARCHAR2 (30)
Fiscal period Quarter
YEAR VARCHAR2 (30)
Fiscal period Year
FORECASTED_REVENUE NUMBER

Forecasted Revenue
ACTUAL_REVENUE NUMBER

Actual Revenue
FORECASTED_RESPONSES NUMBER

Forecasted Responses
ORDERS_BOOKED NUMBER

Number of Orders booked
ORDERS_BOOKED_AMT NUMBER

Total value of the orders booked during the period
LEADS_OPEN NUMBER

Open Leads during the period
LEADS_OPEN_AMT NUMBER

Total budget of the open leads
LEADS_CLOSED NUMBER

Closed Leads during the period
LEADS_CLOSED_AMT NUMBER

Total budget of the closed leads
LEADS_NEW NUMBER

Number of new leads
LEADS_NEW_AMT NUMBER

Total budget 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 CAMPAIGN_DAILY_TRANSACTION_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CAMPAIGN_ID
,      SCHEDULE_ID
,      PARENT_CAMPAIGN_ID
,      CAMPAIGN_REGION
,      SCHEDULE_REGION
,      CAMPAIGN_COUNTRY
,      SCHEDULE_COUNTRY
,      CAMPAIGN_SOURCE_CODE
,      SCHEDULE_SOURCE_CODE
,      START_DATE
,      END_DATE
,      BUSINESS_UNIT_ID
,      CAMPAIGN_TYPE
,      SCHEDULE_ACTIVITY_TYPE
,      SCHEDULE_ACTIVITY_ID
,      CAMPAIGN_PURPOSE
,      SCHEDULE_PURPOSE
,      CAMPAIGN_STATUS
,      CAMPAIGN_BUDGET_FC
,      SCHEDULE_BUDGET_FC
,      SCHEDULE_STATUS
,      LEADS_QUALIFIED
,      LEADS_QUALIFIED_AMT
,      LEADS_UNQUALIFIED
,      LEADS_UNQUALIFIED_AMT
,      OPPORTUNITIES
,      OPPORTUNITY_AMT
,      ORDERS
,      ORDERS_ACTIVE
,      ORDERS_ACTIVE_AMT
,      ORDERS_CANCELLED
,      ORDERS_CANCELLED_AMT
,      POSITIVE_RESPONSES
,      FORECASTED_COST
,      ACTUAL_COST
,      REVENUE
,      TARGETED_CUSTOMERS
,      BUDGET_REQUESTED
,      BUDGET_APPROVED
,      NEW_CUSTOMERS
,      CURRENCY_CODE
,      RELATED_EVENT_TYPE
,      RELATED_EVENT_ID
,      TRANSACTION_CREATE_DATE
,      DELETE_FLAG
,      ORG_ID
,      SECURITY_GROUP_CODE
,      SECURITY_GROUP_ID
,      LOAD_DATE
,      MONTH
,      QTR
,      YEAR
,      FORECASTED_REVENUE
,      ACTUAL_REVENUE
,      FORECASTED_RESPONSES
,      ORDERS_BOOKED
,      ORDERS_BOOKED_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_CAMP_DAILY_FACTS;

Dependencies

[top of page]

BIM.BIM_R_CAMP_DAILY_FACTS does not reference any database object

BIM.BIM_R_CAMP_DAILY_FACTS is referenced by following:

SchemaAPPS
SynonymBIM_R_CAMP_DAILY_FACTS