DW_CXS_OPPORTUNITY_CF

Opportunity Fact

Details

Module:

Key Columns

OPPORTUNITY_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
OPPORTUNITY_ID NUMBER 38 0 True Primary key
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. Unique Identifier
OWNER_RESOURCE_PARTY_ID NUMBER 38 0 Sales resource marked as the owner for the opportunity DW_CXS_RESOURCE_D RESOURCE_ID
COMMENTS VARCHAR2 999 comments about this opportunity
OPPORTUNITY_NAME VARCHAR2 512 Opportunity Name
CUSTOMER_PARTY_ID NUMBER 38 0 Customer party ID maps to Sales Account created DW_CXS_SALES_ACCOUNT_D PARTY_ID
SALES_ACCOUNT_ID NUMBER 38 0 Sales Account Identifier maps to the sales account in use for the opportunity DW_CXS_SALES_ACCOUNT_D SALES_ACCOUNT_ID
PRIMARY_COMPETITOR_PARTY_ID NUMBER 38 0 Primary Competitor DW_CXS_COMPETITOR_D COMPETITOR_ID
PRIMARY_CONTACT_PARTY_ID NUMBER 38 0 Primary Contact for the opportunity associated with the sales account DW_CXS_CONTACT_D CONTACT_ID
PRIMARY_PARTNER_PARTY_ID NUMBER 38 0 Primary Partner asociated with the opportunity DW_CXS_PARTNER_D PARTNER_ID
BUSINESS_UNIT_ID NUMBER 38 0 (Internal Organization) to which this Opportunity belongs. DW_BUSINESS_UNIT_D_TL BUSINESS_UNIT_ID
OPPORTUNITY_CREATION_TIMESTAMP TIMESTAMP Opportunity creation date for functional use.
OPPORTUNITY_CREATION_DATE DATE Truncated Opportunity creation date for functional use.Can be used for DATE dimension join
OPPORTUNITY_NUMBER VARCHAR2 32 Opportunity number - system generated
BUDGETED_FLAG VARCHAR2 16 Indicates if the opportunity target has budgeted for buying the solution proposed by this opportunity.
ACTUAL_CLOSE_DATE DATE when opty is closed (status category in win/loss/no sale) then it is equal to effective date else null
STATUS_CODE VARCHAR2 64 User configurable status of Opportunit Stores Values such as Open Won Lost and No Sale DW_CXS_STATUS_CODE_D_TL CODE
SALES_METHOD_ID NUMBER 38 0 Sales Method associated to an opportunity gives information about various stages that opportunity will go through DW_CXS_SALES_METHOD_D_TL SALES_METHOD_ID
CURRENT_SALES_STAGE_ID NUMBER 38 0 Current Sales Stage and Stores Values such as 'Short List', 'Negotiation', 'Closed', 'Discovery',' Discovery',' Solution Presentation', 'Short List' DW_CXS_SALES_STAGE_D_TL SALES_STAGE_ID
REASON_WON_LOST_CODE VARCHAR2 64 Reason for won or lost. And Which Stores Values such as 'Customer not ready', 'Good lead', 'Install base', 'Lost to competition', 'Lost to internal development', 'Lost to no decision', 'No budget' DW_CXS_REASON_WON_LOST_CODE_D_TL CODE
SALES_CHANNEL_CODE VARCHAR2 64 Sales channel from which the opportunity originates DW_CXS_SALES_CHANNEL_CODE_D_TL CODE
LINE_OF_BUSINESS_CODE VARCHAR2 32 The line of business that is responsible for the opportunity DW_CXS_LINE_OF_BUSINESS_CODE_D_TL CODE
STATUS_CATEGORY VARCHAR2 32 Status Category of the Opportunity Status DW_CXS_STATUS_CATEGORY_D_TL CODE
PREDICTED_WIN_PROBABILITY NUMBER Opportunity AI predicted win probability
STRATEGIC_VALUE_CODE VARCHAR2 64 Strategy for the opportunity and Stores Values Such as 'High', 'Low', 'Medium' DW_CXS_STRATEGIC_VALUE_CODE_D_TL CODE
RISK_LEVEL_CODE VARCHAR2 64 Risk Level for the opportunity. And Stores Values Such as 'High', 'Low', 'None' DW_CXS_RISK_LEVEL_CODE_D_TL CODE
DECISION_LEVEL_CODE VARCHAR2 64 Decision level for the opportunity. And Stores values such as 'CEO', 'CIO', 'Director', 'Manager', 'Other', 'VP' DW_CXS_DECISION_LEVEL_CODE_D_TL CODE
DEAL_HORIZON_CODE VARCHAR2 64 Deal Horizon for the opportunity. And Stores values such as 'Greater than 120 days', 'Less than 15 days','15 - 30 days','31 - 60 days','61 - 120 days' DW_CXS_DEAL_HORIZON_CODE_D_TL CODE
LAST_UPDATE_TIMESTAMP TIMESTAMP User last Updated Date
LAST_UPDATE_DATE DATE Truncated User last Updated Date,can be used for DATE Dimension join
EXPECTED_CLOSE_DATE DATE Expected close date unless the opportunity is closed. When opportunity closed then actual close date.
LOST_FLAG VARCHAR2 16 LOST_FLAG is set to Y when status is lost else N
CLOSED_FLAG VARCHAR2 16 CLOSED_FLAG is set to Y when status is close else N
OPPORTUNITY_CREATED_BY VARCHAR2 128 Opportunity Created by user
DESCRIPTION VARCHAR2 999 Opportunity Description
SUMMARY_REVENUE_ID NUMBER 38 0 Sum revenue ID for this Opty
OPPORTUNITY_AMOUNT NUMBER Revenue amount at Opportunity Header level
OPPORTUNITY_CURRENCY_CODE VARCHAR2 16 Opportunity revenue amount currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
CRM_CURRENCY_CODE VARCHAR2 16 CRM common currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
CRM_CONVERSION_RATE NUMBER This rate is used for the conversion of the revenue amount to the crm common currency for the Revenue Forecast Metrics if the currency of the revenue line is different.This is the amount that one currency can be exchanged for at a specific point of time.
CRM_CONVERSION_RATE_TYPE VARCHAR2 32 currency conversion rate type for extensibility DW_CXS_CURRENCY_CONVERSION_RATE_TYP_D_TL CODE
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global currency code. DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
CREATION_TIMESTAMP TIMESTAMP Creation Date - Audit column
CREATION_DATE DATE Creation Date - Audit column, will be used for Date dimension join
FISCAL_PERIOD_SET_NAME VARCHAR2 16 Name of the accounting calendar.
FISCAL_PERIOD_TYPE VARCHAR2 16 Accounting period type. Examples are Weekly Quarterly.
CRM_OPPORTUNITY_AMOUNT NUMBER Opportunity amount converted to CRM currency equivalent
GLOBAL_OPPORTUNITY_AMOUNT NUMBER Opportunity amount converted to Global currency equivalent
BUDGET_AMOUNT NUMBER Amount budgeted for this opportunity from customer/prospect side.
CRM_CURRENCY_BUDGET_AMOUNT NUMBER Amount budgeted for this opportunity from customer/prospect side in CRM currency
GLOBAL_BUDGET_AMOUNT NUMBER Amount budgeted for this opportunity from customer/prospect side in Global currency
CAMPAIGN_ID NUMBER 38 0 Campaign Identifier
CAMPAIGN_ACTUAL_COST NUMBER Amount of money spent to run the campaign.
CAMPAIGN_BUDGETED_COST NUMBER Amount of money budgeted for the campaign.
CAMPAIGN_CURRENCY_CODE VARCHAR2 16 Currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
CAMPAIGN_OWNER_RESOURCE_PARTY_ID NUMBER 38 0 Owner of the campaign row. DW_CXS_RESOURCE_D RESOURCE_ID
CAMPAIGN_CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
CAMPAIGN_REGION_CODE VARCHAR2 128 Region code of the Campaign.
CAMPAIGN_NAME VARCHAR2 128 Name of the campaign
CAMPAIGN_START_DATE DATE Starting Date for the campaign
CAMPAIGN_END_DATE DATE Ending date for the campaign. Responses received after this date are still counted
CAMPAIGN_PRODUCT_DESCRIPTION VARCHAR2 128 Product Name on the Campaign.
CAMPAIGN_STATUS_CODE VARCHAR2 32 Status code of the Campaign created. ('ORA_DRAFT', 'ORA_COMPLETED, ORA_ACTIVE') DW_CXM_CAMPAIGN_STATUS_D_TL CODE
CAMPAIGN_TYPE_CODE VARCHAR2 32 Type of campaign. ( 'ORA_EVENT','ORA_BLOG_POST') DW_CXM_CAMPAIGN_TYPE_D_TL CODE
CAMPAIGN_DESCRIPTION VARCHAR2 999 Description of the campaign
CAMPAIGN_ACTIVE_FLAG VARCHAR2 16 Indicates whether the campaign is active('Y') or not ('N')
GLOBAL_CURRENCY_CAMPAIGN_ACTUAL_COST NUMBER Campaign actual cost in global currency
GLOBAL_CURRENCY_CAMPAIGN_BUDGETED_COST NUMBER Campaign budgeted cost in global currency
SOURCED_FROM_CAMPAIGN_FLAG VARCHAR2 16 Flag to identifiy if an opportunity is linked to any marketing campaign
CAMPAIGN_CREATION_DATE DATE Who column: indicates the date of the creation of the row.
WIN_PROBABILITY NUMBER Win probability
CREATED_BY_MODULE VARCHAR2 32 Created By Module, it will be used to identify the opportunities converted from leads
OPPORTUNITY_TYPE_CODE VARCHAR2 32 The different types of opportunities such as new, renewal, and expansion. DW_CXS_OPPORTUNITY_TYPE_D_TL CODE
RENEWAL_PROCESS_CODE VARCHAR2 32 The renewal process can be manual, do not renew, or automatic renewal. DW_CXS_RENEWAL_PROCESS_D_TL CODE
QUOTES_ASSOCIATION_FLAG VARCHAR2 16 Opporunity quote assoisction flag
PRIMARY_CAMPAIGN_ID NUMBER 38 0 Primary Campaign Id of the Opportunity. Reference Key to Campaign object.