DW_CXS_OPPORTUNITY_SNAPSHOT_F

Opportunity Snapshot Fact

Details

Module:

Key Columns

OPPORTUNITY_SNAPSHOT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
OPPORTUNITY_SNAPSHOT_ID NUMBER 38 0 True Primary key
SOURCE_RECORD_ID VARCHAR2 256 This column is for Oracle Internal use only. System Generated Unique Identifier
PREVIOUS_OPPORTUNITY_SNAPSHOT_ID NUMBER 38 0 previous opporunity snapshot id
SNAPSHOT_DATE DATE Snapshot date
OPPORTUNITY_ID NUMBER 38 0 Opportunity id
OWNER_RESOURCE_PARTY_ID NUMBER 38 0 Sales Representative 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 ID DW_CXS_SALES_ACCOUNT_D PARTY_ID
SALES_ACCOUNT_ID NUMBER 38 0 Sales Account ID 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 DW_CXS_CONTACT_D CONTACT_ID
PRIMARY_PARTNER_PARTY_ID NUMBER 38 0 Primary Partner 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 time
OPPORTUNITY_CREATION_DATE DATE Truncated Opportunity creation date for functional use.Can be used for DATE dimension join
OPPORTUNITY_NUMBER VARCHAR2 32 Opty number other than ID
BUDGETED_FLAG VARCHAR2 16 Customer has budget
STATUS_CODE VARCHAR2 64 Status of Opportunity DW_CXS_STATUS_CODE_D_TL CODE
SALES_METHOD_ID NUMBER 38 0 Sales Method DW_CXS_SALES_METHOD_D_TL SALES_METHOD_ID
CURRENT_SALES_STAGE_ID NUMBER 38 0 Current Sales Stage DW_CXS_SALES_STAGE_D_TL SALES_STAGE_ID
REASON_WON_LOST_CODE VARCHAR2 64 Reason for won or lost. DW_CXS_REASON_WON_LOST_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
STRATEGIC_VALUE_CODE VARCHAR2 64 Strategy for the opportunity DW_CXS_STRATEGIC_VALUE_CODE_D_TL CODE
RISK_LEVEL_CODE VARCHAR2 64 Risk Level for the opportunity DW_CXS_RISK_LEVEL_CODE_D_TL CODE
DECISION_LEVEL_CODE VARCHAR2 64 Decision level for the opportunity DW_CXS_DECISION_LEVEL_CODE_D_TL CODE
DEAL_HORIZON_CODE VARCHAR2 64 Decision level for the opportunity DW_CXS_DEAL_HORIZON_CODE_D_TL CODE
LAST_UPDATE_TIMESTAMP TIMESTAMP User last Updated Date Time
EXPECTED_CLOSE_DATE DATE Expected close date unless the opportunity is closed. When opportunity closed then actual close date.
LAST_UPDATE_DATE DATE Truncated User last Updated Date,can be used for DATE Dimension join
OPPORTUNITY_CREATED_BY VARCHAR2 128 Who Column : indicates the user who created the Opportunity
DESCRIPTION VARCHAR2 999 Opportunity Description
SUMMARY_REVENUE_ID NUMBER 38 0 Added for Opportunity Management (Revenue Schedule Item). It refers to the summary revenue item created in MOO_REVN, i.e. the primary revenue item for this opportunity. Though every opportunity will have a summary revenue. This column should not be made mandatory to avoid circular dependency.
CURRENCY_CODE VARCHAR2 32 currency code for the extensibility 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.
SNAPSHOT_ID NUMBER 38 0 Snapshot id DW_CXS_SNAPSHOTS_D SNAPSHOT_ID
BUDGET_AMOUNT NUMBER Budget Amount
PREVIOUS_EXPECTED_CLOSE_DATE DATE previous expected close date
IS_EXPECTED_CLOSE_DATE_CHANGED NUMBER 38 0 Is expected close date changed
CURRENT_EXPECTED_CLOSE_DATE_MONTH_CODE VARCHAR2 16 Current expected close date month code (YYYY/MM)
PREVIOUS_EXPECTED_CLOSE_DATE_MONTH_CODE VARCHAR2 16 Previous expected close date month code (YYYY/MM)
IS_EXPECTED_CLOSE_DATE_MONTH_CHANGED NUMBER 38 0 Is expected close date month changed
CURRENT_EXPECTED_CLOSE_DATE_QUARTER_CODE VARCHAR2 16 Current expected close date Quarter code (YYYY Q1)
PREVIOUS_EXPECTED_CLOSE_DATE_QUARTER_CODE VARCHAR2 16 Previous expected close date Quarter code (YYYY Q1)
IS_EXPECTED_CLOSE_DATE_QUARTER_CHANGED NUMBER 38 0 Is expected close date quarter changed
CURRENT_EXPECTED_CLOSE_DATE_YEAR_CODE VARCHAR2 16 Current expected close date Year code (YYYY)
PREVIOUS_EXPECTED_CLOSE_DATE_YEAR_CODE VARCHAR2 16 Previous expected close date Year code(YYYY)
IS_EXPECTED_CLOSE_DATE_YEAR_CHANGED NUMBER 38 0 Is expected close date year changed