Opportunity Fact
Module: Opportunity Management
OPPORTUNITY_ID
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 | 2048 | 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 | 2048 | 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 | 2048 | 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 |