DW_CXS_LEAD_CF

Lead Fact

Details

Module: Opportunity Management

Key Columns

LEAD_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
LEAD_ID NUMBER 38 0 True Primary key    
SOURCE_RECORD_ID VARCHAR2 256     Unique Identifier    
LEAD_NAME VARCHAR2 256     Lead Name used for identifying the lead.    
LEAD_NUMBER VARCHAR2 64     Lead number. Public surrogate key for this table.    
LEAD_ACCEPTED_DATE DATE       Date when the lead was accepted.    
LEAD_ACCEPTED_TIMESTAMP TIMESTAMP       Date and time when 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_DESCRIPTION VARCHAR2 2048     Description Text. Verbose description about the lead.    
LEAD_CONVERSION_DATE DATE       Converted date Indicates when the lead was converted to an opportunity.    
LEAD_CONVERSION_TIMESTAMP TIMESTAMP       Converted date and time Indicates when the lead was converted to an opportunity.    
LEAD_CREATION_DATE DATE       Business specific Creation Date of the lead.    
LEAD_CREATION_TIMESTAMP TIMESTAMP       Business specific Creation Date and time of the lead.    
LEAD_QUALIFIED_DATE DATE       Date when 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_LEAD_SALES_CHANNEL_D_TL CODE
PRIMARY_CONTACT_ID NUMBER 38 0   Primary Contact Id . Denormalized column from lead contacts table. DW_CXS_CONTACT_D CONTACT_ID
CUSTOMER_PARTY_ID NUMBER 38 0   Customer Id. It is a reference to the customer record DW_CXS_SALES_ACCOUNT_D PARTY_ID
CONTACT_COUNTRY_CODE VARCHAR2 32     Lead Contact Country.('UG','IE','AE','US') DW_COUNTRY_D_TL COUNTRY
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') DW_CXS_INDUSTRY_TYPE_CODE_D_TL CODE
OWNER_RESOURCE_PARTY_ID NUMBER 38 0   Owner resource id for lead DW_CXS_RESOURCE_D RESOURCE_ID
LAST_OWNER_ASSIGNED_DATE DATE       Last Owner Assign Date    
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 1024     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       Date when the lead was rejected.    
LEAD_RETIRED_DATE DATE       Date and time when the lead was Retired    
PARTNER_ID NUMBER 38 0   Partner Party Id DW_CXS_PARTNER_D PARTNER_ID
PARTNER_TYPE_CODE VARCHAR2 32     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')    
BUDGET_STATUS_CODE VARCHAR2 32     Budget Status.('PENDING','APPROVED') DW_CXS_LEAD_BUDGET_D_TL CODE
BUDGET_AMOUNT NUMBER       Budget Amount.    
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    
APPROVAL_DATE DATE       Approval date of the deal. This is a deal specific attribute.    
APPROVER_ID NUMBER 38 0   Approver Id. Foreign key to TCA party Id of resource who approved lead registration.    
PRIMARY_CONTACT_NAME VARCHAR2 512     Lead Contact Full Name.    
LAST_ACTIVITY_DATE DATE            
WIN_PROBABILITY NUMBER            
CUSTOMER_NAME VARCHAR2 512     Lead Customer Name.    
LEAD_BUSINESS_UNIT_ID NUMBER 38 0   Business Unit Id stamped on the lead for tracking.    
LAST_ASSIGNMENT_DATE DATE       Lead AssignmentDate    
LAST_ASSIGNMENT_TIMESTAMP TIMESTAMP       Lead Assignment TimeStamp    
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.