DW_CXS_OPPORTUNITY_CF

Opportunity Fact

Details

Module: Opportunity Management

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     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.    

Copyright © 2019, 2023, Oracle and/or its affiliates.