DW_CXS_LEAD_CF

Lead Fact

Details

Module:

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 This column is for Oracle Internal use only. 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 64 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 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_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 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 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 64 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.
LEAD_CREATED_BY VARCHAR2 128 128
CREATED_BY VARCHAR2 128 128