DW_CXS_LEAD_OPPORTUNITY_CF

Lead Fact

Details

Module:

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 This column is for Oracle Internal use only. 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.
FIRST_TOUCH_LEAD_INDICATOR NUMBER 38 0 Flag Dervied from FAW
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 64 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 64 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 64 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 64 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 64 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 64 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 64 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.