DW_CXS_LEAD_OPPORTUNITY_CF

Lead Fact

Details

Module: Opportunity Management

Key Columns

OPPORTUNITY_LEAD_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
OPPORTUNITY_LEAD_ID NUMBER 38 0 True Primary key    
SOURCE_RECORD_ID VARCHAR2 256     Unique Identifier    
OPPORTUNITY_ID NUMBER 38 0   Opportunity Identifier    
LEAD_NUMBER VARCHAR2 64     Lead number. Public surrogate key for this table.    
CREATION_TIMESTAMP TIMESTAMP       Accepted Date. Date the lead was accepted.    
LEAD_ID NUMBER 38 0   Lead Identifier    
LEAD_NAME VARCHAR2 256     Lead Name used for identifying the lead.    
LEAD_ACCEPTED_TIMESTAMP TIMESTAMP       Accepted Date. Date the lead was accepted.    
LEAD_ACCEPTED_DATE DATE       Accepted Date. Date the lead was accepted.    
LEAD_ACCEPTED_FLAG VARCHAR2 32     Lead Accepted Flag. Indicator for whether the lead is accepted    
LEAD_ASSIGNMENT_STATUS_CODE VARCHAR2 32     Assignment Status Code. Tracks the current assignment related status for the lead ('ASSIGNED','REJECTED') DW_CXS_LEAD_ASSIGNMENT_STATUS_D_TL CODE
LEAD_CHANNEL_TYPE_CODE VARCHAR2 32     Channel type of the lead('FAX','WIRELESS','EMAIL','WEB','DIRECT_MAIL','PHONE') DW_CXS_LEAD_CHANNEL_D_TL CODE
LEAD_CONVERSION_TIMESTAMP TIMESTAMP       Converted Time . Indicates when the lead was converted to an opportunity.    
LEAD_CONVERSION_DATE DATE       Converted Time . Indicates when the lead was converted to an opportunity.    
LEAD_CREATION_TIMESTAMP TIMESTAMP       Lead Creation Date.Business specific creation date of the lead.    
LEAD_CREATION_DATE DATE       Lead Creation Date.Business specific creation date of the lead.    
LEAD_QUALIFIED_DATE DATE       Qualified Date. Stores the date the lead was qualified.    
LEAD_QUALITY_CODE VARCHAR2 32     Quality code of the lead.('5-Poor','2-Very High','3-High','1-Excellent','4-Fair')    
LEAD_RETIRE_REASON_CODE VARCHAR2 32     Retire Reason Code . Tracks the reason this lead was retired.('DUPLICATE_LEAD','NOT_INTERESTED','Opportunity Created','OPPORTUNITY_CREATED') DW_CXS_LEAD_RETIRE_REASON_D_TL CODE
LEAD_STATUS_CODE VARCHAR2 32     Status Code . Denotes the current status of the lead.('UNQUALIFIED','CONVERTED','RETIRED','QUALIFIED') DW_CXS_LEAD_STATUS_D_TL CODE
LEAD_SOURCE_FLAG VARCHAR2 32     Dervied Column from FAW end    
LEAD_QUALIFICATION_SCORE NUMBER 38 0   Qualification Score of the lead.    
LEAD_RANK_CODE VARCHAR2 32     Rank of the lead.('COOL','HOT','WARM') DW_CXS_LEAD_RANK_D_TL CODE
LEAD_ESTIMATED_CLOSE_DATE DATE       Estimated close date of the deal .    
LEAD_TIME_FRAME_CODE VARCHAR2 32     Time frame code that specifies the time within which lead should be processed. ('3 Months','6 Months','9 Months','30 Days') DW_CXS_LEAD_TIMEFRAME_D_TL CODE
LEAD_EXPIRATION_DATE DATE       Expiration Date of the deal.    
NEXT_FOLLOW_UP_DATE DATE       Followup Time . Indicates when the lead was followed up on.    
SALES_CHANNEL_CODE VARCHAR2 32     Sales Channel is the channel through which the deploying company conducts the sales. Direct channel means that the sales force employed by the deploying company is used whereas indirect channel means that the partners of the deploying company are used.('ZPM_DIRECT_CHANNEL_TYPES','ZPM_PARTNER_CHANNEL_TYPES') DW_CXS_SALES_CHANNEL_CODE_D_TL CODE
PRIMARY_CONTACT_ID NUMBER 38 0   Primary Contact Id . Denormalized column from lead contacts table.    
CUSTOMER_PARTY_ID NUMBER 38 0   Customer Id. It is a reference to the customer record    
CONTACT_COUNTRY_CODE VARCHAR2 32     Lead Contact Country.('UG','IE','AE','US')    
CUSTOMER_NEED_DESCRIPTION VARCHAR2 32     Customer Need    
CUSTOMER_PARTY_TYPE VARCHAR2 32     Party Type of the Account associated to Lead. DW_CXS_CUSTOMER_PARTY_TYPE_D_TL CODE
CUSTOMER_ORGANIZATION_SIZE_CODE VARCHAR2 32     Lead Customer Organization Size.('LARGE','SMALL','VERY_SMALL','VERY_LARGE','MEDIUM') DW_CXS_LEAD_ORGANIZATION_SIZE_D_TL CODE
CUSTOMER_ORGANIZATION_TYPE_CODE VARCHAR2 32     Lead Customer Organization Type.('ORGANIZATION','A: Health; T: Health','A: Commercial; T: Higher Ed','A: Commercial; T: Health','A: Commercial; T: PS-SL','PUBLIC_COMPANY') DW_CXS_ORGANIZATION_TYPE_CODE_D_TL CODE
CUSTOMER_EXISTING_FLAG VARCHAR2 32     Customer Existing Flag    
DECISION_MAKER_IDENTIFIED_FLAG VARCHAR2 32     Decision Maker Identified Flag.    
INDUSTRY_CLASSIFICATION_CODE VARCHAR2 64     Lead Customer Industry.('Aerospace & Defense','Automotive','Chemicals','Communications','Consumer Goods')    
OWNER_RESOURCE_PARTY_ID NUMBER 38 0   Owner resource id for lead    
LAST_OWNER_ASSIGNED_DATE DATE       Last Owner Assign Time    
LEAD_REASSIGN_REASON_CODE VARCHAR2 32     Reassign Reason Code. Tracks the reason this lead got reassigned.('INACTIVITY','OTHER','WORKLOAD','AUTO_ASSGMNT') DW_CXS_LEAD_REASSIGN_REASON_D_TL CODE
LEAD_REASSIGN_COMMENT VARCHAR2 999     Reassign Comment Text. Descriptive text input when the lead is reassigned.    
LEAD_REJECT_BY_USER_ID NUMBER 38 0   Reject by User . Identifies the user rejecting the lead.    
LEAD_REJECT_REASON_CODE VARCHAR2 32     Reject Reason Code. Tracks the reason this lead was rejected.('ALREADY OWNS PRODUCT','DO NOT CONTACT AGAIN','DUPLICATE_LEAD','FAILED_TO_REACH','Incorrect data','Duplicate lead') DW_CXS_LEAD_REJECT_REASON_D_TL CODE
LEAD_REJECTED_DATE DATE       Rejected Time. Indicates the time when the lead was rejected.    
LEAD_RETIRED_DATE DATE       Retired Time. Indicates the time when the lead was Retired    
PARTNER_ID NUMBER 38 0   Partner Party Id    
PARTNER_TYPE_CODE VARCHAR2 256     Partner Type. Indicates the type of partner stamped on the lead.('Systems integrator','Support services provider','Value added distributor','Reseller','Business process owner') DW_CXS_LEAD_PARTNER_D_TL CODE
PRIMARY_PRODUCT_ITEM_ID NUMBER 38 0   Primary Inventory Item Primy Id    
PRIMARY_INVENTORY_ORGANIZATION_ID NUMBER 38 0   Primary Inventory Organization Primy Id    
PRIMARY_PRODUCT_GROUP_ID NUMBER 38 0   Primary Product Group Primy Id    
PRIMARY_PRODUCT_ID NUMBER 38 0   Product Identifier for the Product or Product Group    
PRODUCT_ITEM_OR_PRODUCT_GROUP VARCHAR2 16     Is this a item or a product group. ('ITEM','PRODUCT_GROUP')    
LEAD_BUDGET_STATUS_CODE VARCHAR2 32     Budget Status.('PENDING','APPROVED') DW_CXS_LEAD_BUDGET_D_TL CODE
LEAD_BUDGET_AMOUNT NUMBER       Budget Amount.    
LEAD_BUDGET_CURRENCY_CODE VARCHAR2 32     Budget Currency Code    
LEAD_AMOUNT NUMBER       Deal size for the lead.    
LEAD_CURRENCY_CODE VARCHAR2 32     Currency code for the lead.('USD','GBP','INR','EUR')    
CURRENCY_CONVERSION_DATE DATE       Currency Conversion: Indicates the currency conversion date.    
CRM_CURRENCY_CODE VARCHAR2 32     Corporate Currency Code('USD','GBP','INR','EUR')    
CRM_CURRENCY_EXCHANGE_RATE NUMBER       Crm Corportate Currency Exchange Rate    
CRM_CURRENCY_LEAD_AMOUNT NUMBER       Deal size convtered to CRM Currency    
GLOBAL_CURRENCY_CODE VARCHAR2 32     Global Currency Code('USD','GBP','INR','EUR')    
GLOBAL_CURRENCY_LEAD_AMOUNT NUMBER       Deal size convtered to Global Currency    
GLOBAL_CURRENCY_BUDGET_AMOUNT NUMBER       Converting Budget Amount in To Global Currency    
LEAD_BUSINESS_UNIT_ID NUMBER 38 0   Business Unit Id stamped on the lead for tracking.    
OPPORTUNITY_NAME VARCHAR2 512     Opportunity Name    
OPPORTUNITY_NUMBER VARCHAR2 32     Opportunity number - system generated    
OPPORTUNITY_BUSINESS_UNIT_ID NUMBER 38 0   (Internal Organization) to which this Opportunity belongs. DW_BUSINESS_UNIT_D_TL BUSINESS_UNIT_ID
OPPORTUNITY_CREATION_DATE DATE       Truncated Opportunity creation date for functional use.Can be used for DATE dimension join    
OPPORTUNITY_EXPECTED_CLOSE_DATE DATE       Expected close date unless the opportunity is closed. When opportunity closed then actual close date.    
OPPORTUNITY_ACTUAL_CLOSE_DATE DATE       when opportunity is closed (status category in win/loss/no sale) then it is equal to effective date else null    
OPPORTUNITY_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
OPPORTUNITY_STATUS_CATEGORY VARCHAR2 32     Status Category of the Opportunity Status Eg: Open, Won, Lost DW_CXS_STATUS_CATEGORY_D_TL CODE
OPPORTUNITY_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
OPPORTUNITY_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
OPPORTUNITY_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
OPPORTUNITY_SALES_CHANNEL_CODE VARCHAR2 64     Sales channel from which the opportunity originates Eg: ('ZPM_DIRECT_CHANNEL_TYPES', 'ZPM_PARTNER_CHANNEL_TYPES') DW_CXS_SALES_CHANNEL_CODE_D_TL CODE
OPPORTUNITY_WIN_PROBABILITY NUMBER       Opportunity win probability    
OPPORTUNITY_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
OPPORTUNITY_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
OPPORTUNITY_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
OPPORTUNITY_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
OPPORTUNITY_CUSTOMER_PARTY_ID NUMBER 38 0   Customer party ID maps to Sales Account created DW_CXS_SALES_ACCOUNT_D PARTY_ID
OPPORTUNITY_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
OPPORTUNITY_PRIMARY_CONTACT_PARTY_ID NUMBER 38 0   Primary Contact for the opportunity associated with the sales account DW_CXS_CONTACT_D CONTACT_ID
OPPORTUNITY_PRIMARY_COMPETITOR_PARTY_ID NUMBER 38 0   Primary Competitor DW_CXS_COMPETITOR_D COMPETITOR_ID
OPPORTUNITY_PRIMARY_PARTNER_PARTY_ID NUMBER 38 0   Primary Partner asociated with the opportunity DW_CXS_PARTNER_D PARTNER_ID
OPPORTUNITY_OWNER_RESOURCE_PARTY_ID NUMBER 38 0   Sales resource marked as the owner for the opportunity DW_CXS_RESOURCE_D RESOURCE_ID
OPPORTUNITY_CURRENCY_CODE VARCHAR2 16     Opportunity revenue amount currency code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
OPPORTUNITY_AMOUNT NUMBER       Revenue amount at Opportunity Header level    
CRM_OPPORTUNITY_AMOUNT NUMBER       Opportunity amount converted to CRM currency equivalent    
GLOBAL_OPPORTUNITY_AMOUNT NUMBER       Opportunity amount converted to Global currency equivalent    
OPPORTUNITY_BUDGETED_FLAG VARCHAR2 16     Indicates if the opportunity target has budgeted for buying the solution proposed by this opportunity.    
OPPORTUNITY_BUDGET_AMOUNT NUMBER       Amount budgeted for this opportunity from customer/prospect side.    
CRM_CURRENCY_OPPORTUNITY_BUDGET_AMOUNT NUMBER       Amount budgeted for this opportunity from customer/prospect side in CRM currency    
GLOBAL_OPPORTUNITY_BUDGET_AMOUNT NUMBER       Amount budgeted for this opportunity from customer/prospect side in Global currency    
CREATED_BY_MODULE VARCHAR2 32     Created By Module    
LAST_ASSIGNMENT_DATE DATE       Lead AssignmentDate    
LEAD_ORIGIN VARCHAR2 32     Value for the origin of Sales lead DW_CXS_LEAD_ORIGIN_D_TL CODE
LEAD_LAST_UPDATE_DATE DATE       Business specific Last Date of the lead.    
LEAD_LAST_UPDATE_TIMESTAMP TIMESTAMP       Business specific Last Date and time of the lead.    

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