Lead Fact
Module:
LEAD_ID
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 | 999 | 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. | |||||
CREATION_TIMESTAMP | TIMESTAMP | who column for Creation Date of the lead. | |||||
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 | 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 | 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. |
Copyright © 2019, 2023, Oracle and/or its affiliates.