DBA Data[Home] [Help] [Dependency Information]

TABLE: BIM.BIM_I_LEAD_FACTS

Object Details
Object Name: BIM_I_LEAD_FACTS
Object Type: TABLE
Owner: BIM
Subobject Name:
Status: VALID


This table provides daily facts summary information for Lead Management DBI.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_CREATE_DATE DATE

Transaction Create Date
LEAD_CREATION_DATE DATE

Lead Creation Date
LEAD_TOUCHED_DATE DATE

Lead Touched Date
LEAD_CONVERTED_DATE DATE

Lead Converted Date
LEAD_DEAD_DATE DATE

Lead Dead Date
LEAD_CLOSED_DATE DATE

Lead Closed Date
METRIC_TYPE VARCHAR2 (15)
Type of the Metric
LEAD_ID NUMBER

Sales Lead ID
LEAD_LINE_ID NUMBER

Sales Lead Line ID
GROUP_ID NUMBER

Sales Group ID
RESOURCE_ID NUMBER

Resource ID that Generated the Lead
LEAD_RANK_ID NUMBER

Rank ID of the Lead
LEAD_SOURCE VARCHAR2 (30)
Source of the Lead
LEAD_STATUS VARCHAR2 (30)
Status of the Lead
OPEN_FLAG VARCHAR2 (30)
Yes if Lead Status is Open, otherwise No
LEAD_REGION VARCHAR2 (30)
Region of the Lead Origin
LEAD_COUNTRY VARCHAR2 (30)
Countryof the Lead Origin
PRODUCT_CATEGORY_ID NUMBER

Product Category ID
ITEM_ID NUMBER

Item ID
ORGANIZATION_ID NUMBER

Oraganization ID
SOURCE_CODE_ID NUMBER

Source code id
OBJECT_TYPE VARCHAR2 (30)
'CAMP' or 'EVEH'
OBJECT_ID NUMBER

Campaign ID or Event ID
CHILD_OBJECT_TYPE VARCHAR2 (30)
'CSCH', 'CAMP', 'EVEH' or 'EVEO'
CHILD_OBJECT_ID NUMBER

Schedule ID or Offer ID
OBJECT_REGION VARCHAR2 (30)
Campaign's or Event's Region
OBJECT_COUNTRY VARCHAR2 (30)
Campaign's or Eventls Country
OBJECT_STATUS VARCHAR2 (30)
Campaign's or Event's Status
OBJECT_PURPOSE VARCHAR2 (240)
Campaign's or Event's Purpose
CHILD_OBJECT_REGION VARCHAR2 (30)
Schedule's or Offer's Region
CHILD_OBJECT_COUNTRY VARCHAR2 (30)
Schedule's or Offer's Country
CHILD_OBJECT_STATUS VARCHAR2 (30)
Schedule's or Offer's Status
CHILD_OBJECT_PURPOSE VARCHAR2 (240)
Schedule's or Offer's Purpose
BUSINESS_UNIT_ID NUMBER

Business Unit ID
OBJECT_CATEGORY_ID NUMBER

Object Category ID
LEADS NUMBER

Leads ( ALL - DEAD)
LEADS_OPEN NUMBER

Open Leads
LEADS_CLOSED NUMBER

Closed Leads
LEADS_NEW NUMBER

New Leads
LEADS_DEAD NUMBER

Dead Leads
LEADS_DECLINED NUMBER

Declined Leads
LEADS_CHANGED NUMBER

Changed Leads
LEADS_UNCHANGED NUMBER

Unchanged Leads
LEADS_ASSIGNED NUMBER

Assigned Leads
OPPORTUNITIES NUMBER

Opportunities
OPPORTUNITIES_OPEN NUMBER

Open Opportunities
OPPORTUNITY_AMT NUMBER

Opportunity Amount
QUOTES NUMBER

Quotes
QUOTES_OPEN NUMBER

Quotes Open
ORDERS_BOOKED NUMBER

Booked Orders
ORDERS_BOOKED_AMT NUMBER

Booked Orders Amount
METRIC1 NUMBER

Currently Unused
METRIC2 NUMBER

Currently Unused
METRIC3 NUMBER

Currently Unused
METRIC4 NUMBER

Currently Unused
METRIC5 NUMBER

Currently Unused
METRIC6 NUMBER

Currently Unused
METRIC7 NUMBER

Currently Unused
METRIC8 NUMBER

Currently Unused
METRIC9 NUMBER

Currently Unused
METRIC10 NUMBER

Currently Unused
METRIC11 NUMBER

Currently Unused
METRIC12 NUMBER

Currently Unused
METRIC13 NUMBER

Currently Unused
METRIC14 NUMBER

Currently Unused
METRIC15 NUMBER

Currently Unused
SECURITY_GROUP_ID NUMBER

Security Group ID
CREATION_DATE DATE
Yes Who column
LAST_UPDATE_DATE DATE
Yes Who column
CREATED_BY NUMBER
Yes Who column
LAST_UPDATED_BY NUMBER
Yes Who column
LAST_UPDATE_LOGIN NUMBER

Who column
QUALIFIED_FLAG VARCHAR2 (1)
Qualified Flag
ACCEPT_FLAG VARCHAR2 (1)
Accept Flag
CHANNEL_CODE VARCHAR2 (30)
Channel Code
CLOSE_REASON VARCHAR2 (30)
Close Reason
CUST_CATEGORY VARCHAR2 (30)
Customer Category
CUSTOMER_FLAG VARCHAR2 (1)
Customer Flag
CUSTOMER_ID NUMBER

Customer ID
SOURCE_PRIMARY_REFERENCE VARCHAR2 (240)
Source Primary Reference
SOURCE_SECONDARY_REFERENCE VARCHAR2 (240)
Source Secondary Reference
LEAD_AMOUNT NUMBER

Lead Amount
STATUS_OPEN_FLAG VARCHAR2 (1)
Status Open Flag
LEAD_RANK_SCORE NUMBER

Lead Rank Score
EXPIRATION_DATE DATE

Expiration Date
LEAD_NAME VARCHAR2 (2000)
Lead Description
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TRANSACTION_CREATE_DATE
,      LEAD_CREATION_DATE
,      LEAD_TOUCHED_DATE
,      LEAD_CONVERTED_DATE
,      LEAD_DEAD_DATE
,      LEAD_CLOSED_DATE
,      METRIC_TYPE
,      LEAD_ID
,      LEAD_LINE_ID
,      GROUP_ID
,      RESOURCE_ID
,      LEAD_RANK_ID
,      LEAD_SOURCE
,      LEAD_STATUS
,      OPEN_FLAG
,      LEAD_REGION
,      LEAD_COUNTRY
,      PRODUCT_CATEGORY_ID
,      ITEM_ID
,      ORGANIZATION_ID
,      SOURCE_CODE_ID
,      OBJECT_TYPE
,      OBJECT_ID
,      CHILD_OBJECT_TYPE
,      CHILD_OBJECT_ID
,      OBJECT_REGION
,      OBJECT_COUNTRY
,      OBJECT_STATUS
,      OBJECT_PURPOSE
,      CHILD_OBJECT_REGION
,      CHILD_OBJECT_COUNTRY
,      CHILD_OBJECT_STATUS
,      CHILD_OBJECT_PURPOSE
,      BUSINESS_UNIT_ID
,      OBJECT_CATEGORY_ID
,      LEADS
,      LEADS_OPEN
,      LEADS_CLOSED
,      LEADS_NEW
,      LEADS_DEAD
,      LEADS_DECLINED
,      LEADS_CHANGED
,      LEADS_UNCHANGED
,      LEADS_ASSIGNED
,      OPPORTUNITIES
,      OPPORTUNITIES_OPEN
,      OPPORTUNITY_AMT
,      QUOTES
,      QUOTES_OPEN
,      ORDERS_BOOKED
,      ORDERS_BOOKED_AMT
,      METRIC1
,      METRIC2
,      METRIC3
,      METRIC4
,      METRIC5
,      METRIC6
,      METRIC7
,      METRIC8
,      METRIC9
,      METRIC10
,      METRIC11
,      METRIC12
,      METRIC13
,      METRIC14
,      METRIC15
,      SECURITY_GROUP_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      QUALIFIED_FLAG
,      ACCEPT_FLAG
,      CHANNEL_CODE
,      CLOSE_REASON
,      CUST_CATEGORY
,      CUSTOMER_FLAG
,      CUSTOMER_ID
,      SOURCE_PRIMARY_REFERENCE
,      SOURCE_SECONDARY_REFERENCE
,      LEAD_AMOUNT
,      STATUS_OPEN_FLAG
,      LEAD_RANK_SCORE
,      EXPIRATION_DATE
,      LEAD_NAME
FROM BIM.BIM_I_LEAD_FACTS;

Dependencies

[top of page]

BIM.BIM_I_LEAD_FACTS does not reference any database object

BIM.BIM_I_LEAD_FACTS is referenced by following:

SchemaAPPS
Materialized ViewBIM_I_LD_HEADER_MV
SynonymBIM_I_LEAD_FACTS
Materialized ViewBIM_I_LP_ITEM_MV
Materialized ViewIBW_CART_BASE_MV
Materialized ViewIBW_REFANALYSIS_MV