VIEW: BIM.BIM_R_CAMP_DAILY_FACTS#

Source

View Text - Preformatted

select CAMPAIGN_DAILY_TRANSACTION_ID CAMPAIGN_DAILY_TRANSACTION_ID, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CAMPAIGN_ID CAMPAIGN_ID, SCHEDULE_ID SCHEDULE_ID, PARENT_CAMPAIGN_ID PARENT_CAMPAIGN_ID, CAMPAIGN_REGION CAMPAIGN_REGION, SCHEDULE_REGION SCHEDULE_REGION, CAMPAIGN_COUNTRY CAMPAIGN_COUNTRY, SCHEDULE_COUNTRY SCHEDULE_COUNTRY, CAMPAIGN_SOURCE_CODE CAMPAIGN_SOURCE_CODE, SCHEDULE_SOURCE_CODE SCHEDULE_SOURCE_CODE, START_DATE START_DATE, END_DATE END_DATE, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, CAMPAIGN_TYPE CAMPAIGN_TYPE, SCHEDULE_ACTIVITY_TYPE SCHEDULE_ACTIVITY_TYPE, SCHEDULE_ACTIVITY_ID SCHEDULE_ACTIVITY_ID, CAMPAIGN_PURPOSE CAMPAIGN_PURPOSE, SCHEDULE_PURPOSE SCHEDULE_PURPOSE, CAMPAIGN_STATUS CAMPAIGN_STATUS, CAMPAIGN_BUDGET_FC CAMPAIGN_BUDGET_FC, SCHEDULE_BUDGET_FC SCHEDULE_BUDGET_FC, SCHEDULE_STATUS SCHEDULE_STATUS, LEADS_QUALIFIED LEADS_QUALIFIED, LEADS_QUALIFIED_AMT LEADS_QUALIFIED_AMT, LEADS_UNQUALIFIED LEADS_UNQUALIFIED, LEADS_UNQUALIFIED_AMT LEADS_UNQUALIFIED_AMT, OPPORTUNITIES OPPORTUNITIES, OPPORTUNITY_AMT OPPORTUNITY_AMT, ORDERS ORDERS, ORDERS_ACTIVE ORDERS_ACTIVE, ORDERS_ACTIVE_AMT ORDERS_ACTIVE_AMT, ORDERS_CANCELLED ORDERS_CANCELLED, ORDERS_CANCELLED_AMT ORDERS_CANCELLED_AMT, POSITIVE_RESPONSES POSITIVE_RESPONSES, FORECASTED_COST FORECASTED_COST, ACTUAL_COST ACTUAL_COST, REVENUE REVENUE, TARGETED_CUSTOMERS TARGETED_CUSTOMERS, BUDGET_REQUESTED BUDGET_REQUESTED, BUDGET_APPROVED BUDGET_APPROVED, NEW_CUSTOMERS NEW_CUSTOMERS, CURRENCY_CODE CURRENCY_CODE, RELATED_EVENT_TYPE RELATED_EVENT_TYPE, RELATED_EVENT_ID RELATED_EVENT_ID, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE, DELETE_FLAG DELETE_FLAG, ORG_ID ORG_ID, SECURITY_GROUP_CODE SECURITY_GROUP_CODE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LOAD_DATE LOAD_DATE, MONTH MONTH, QTR QTR, YEAR YEAR, FORECASTED_REVENUE FORECASTED_REVENUE, ACTUAL_REVENUE ACTUAL_REVENUE, FORECASTED_RESPONSES FORECASTED_RESPONSES, ORDERS_BOOKED ORDERS_BOOKED, ORDERS_BOOKED_AMT ORDERS_BOOKED_AMT, LEADS_OPEN LEADS_OPEN, LEADS_OPEN_AMT LEADS_OPEN_AMT, LEADS_CLOSED LEADS_CLOSED, LEADS_CLOSED_AMT LEADS_CLOSED_AMT, LEADS_NEW LEADS_NEW, LEADS_NEW_AMT LEADS_NEW_AMT, LEADS_HOT LEADS_HOT, LEADS_CONVERTED LEADS_CONVERTED, METRIC1 METRIC1, METRIC2 METRIC2, METRIC3 METRIC3, METRIC4 METRIC4, METRIC5 METRIC5, METRIC6 METRIC6, METRIC7 METRIC7, METRIC8 METRIC8, METRIC9 METRIC9, METRIC10 METRIC10, METRIC11 METRIC11, METRIC12 METRIC12, METRIC13 METRIC13, METRIC14 METRIC14, METRIC15 METRIC15 from "BIM"."BIM_R_CAMP_DAILY_FACTS"

View Text - HTML Formatted

SELECT CAMPAIGN_DAILY_TRANSACTION_ID CAMPAIGN_DAILY_TRANSACTION_ID
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CAMPAIGN_ID CAMPAIGN_ID
, SCHEDULE_ID SCHEDULE_ID
, PARENT_CAMPAIGN_ID PARENT_CAMPAIGN_ID
, CAMPAIGN_REGION CAMPAIGN_REGION
, SCHEDULE_REGION SCHEDULE_REGION
, CAMPAIGN_COUNTRY CAMPAIGN_COUNTRY
, SCHEDULE_COUNTRY SCHEDULE_COUNTRY
, CAMPAIGN_SOURCE_CODE CAMPAIGN_SOURCE_CODE
, SCHEDULE_SOURCE_CODE SCHEDULE_SOURCE_CODE
, START_DATE START_DATE
, END_DATE END_DATE
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, CAMPAIGN_TYPE CAMPAIGN_TYPE
, SCHEDULE_ACTIVITY_TYPE SCHEDULE_ACTIVITY_TYPE
, SCHEDULE_ACTIVITY_ID SCHEDULE_ACTIVITY_ID
, CAMPAIGN_PURPOSE CAMPAIGN_PURPOSE
, SCHEDULE_PURPOSE SCHEDULE_PURPOSE
, CAMPAIGN_STATUS CAMPAIGN_STATUS
, CAMPAIGN_BUDGET_FC CAMPAIGN_BUDGET_FC
, SCHEDULE_BUDGET_FC SCHEDULE_BUDGET_FC
, SCHEDULE_STATUS SCHEDULE_STATUS
, LEADS_QUALIFIED LEADS_QUALIFIED
, LEADS_QUALIFIED_AMT LEADS_QUALIFIED_AMT
, LEADS_UNQUALIFIED LEADS_UNQUALIFIED
, LEADS_UNQUALIFIED_AMT LEADS_UNQUALIFIED_AMT
, OPPORTUNITIES OPPORTUNITIES
, OPPORTUNITY_AMT OPPORTUNITY_AMT
, ORDERS ORDERS
, ORDERS_ACTIVE ORDERS_ACTIVE
, ORDERS_ACTIVE_AMT ORDERS_ACTIVE_AMT
, ORDERS_CANCELLED ORDERS_CANCELLED
, ORDERS_CANCELLED_AMT ORDERS_CANCELLED_AMT
, POSITIVE_RESPONSES POSITIVE_RESPONSES
, FORECASTED_COST FORECASTED_COST
, ACTUAL_COST ACTUAL_COST
, REVENUE REVENUE
, TARGETED_CUSTOMERS TARGETED_CUSTOMERS
, BUDGET_REQUESTED BUDGET_REQUESTED
, BUDGET_APPROVED BUDGET_APPROVED
, NEW_CUSTOMERS NEW_CUSTOMERS
, CURRENCY_CODE CURRENCY_CODE
, RELATED_EVENT_TYPE RELATED_EVENT_TYPE
, RELATED_EVENT_ID RELATED_EVENT_ID
, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE
, DELETE_FLAG DELETE_FLAG
, ORG_ID ORG_ID
, SECURITY_GROUP_CODE SECURITY_GROUP_CODE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LOAD_DATE LOAD_DATE
, MONTH MONTH
, QTR QTR
, YEAR YEAR
, FORECASTED_REVENUE FORECASTED_REVENUE
, ACTUAL_REVENUE ACTUAL_REVENUE
, FORECASTED_RESPONSES FORECASTED_RESPONSES
, ORDERS_BOOKED ORDERS_BOOKED
, ORDERS_BOOKED_AMT ORDERS_BOOKED_AMT
, LEADS_OPEN LEADS_OPEN
, LEADS_OPEN_AMT LEADS_OPEN_AMT
, LEADS_CLOSED LEADS_CLOSED
, LEADS_CLOSED_AMT LEADS_CLOSED_AMT
, LEADS_NEW LEADS_NEW
, LEADS_NEW_AMT LEADS_NEW_AMT
, LEADS_HOT LEADS_HOT
, LEADS_CONVERTED LEADS_CONVERTED
, METRIC1 METRIC1
, METRIC2 METRIC2
, METRIC3 METRIC3
, METRIC4 METRIC4
, METRIC5 METRIC5
, METRIC6 METRIC6
, METRIC7 METRIC7
, METRIC8 METRIC8
, METRIC9 METRIC9
, METRIC10 METRIC10
, METRIC11 METRIC11
, METRIC12 METRIC12
, METRIC13 METRIC13
, METRIC14 METRIC14
, METRIC15 METRIC15
FROM "BIM"."BIM_R_CAMP_DAILY_FACTS"