Lead Fact
Module:
OPPORTUNITY_LEAD_ID
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. | |||||
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, 2024, Oracle and/or its affiliates.