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

TABLE: BIM.BIM_R_LEAD_DAILY_FACTS

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


This table stores the Lead facts


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BIM_R_LEAD_DAILY_FACTS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANSACTION_CREATE_DATE
BIM_R_LEAD_DAILY_FACTS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROUP_ID
ColumnTRANSACTION_CREATE_DATE
ColumnLEAD_RANK_ID
ColumnLEAD_SOURCE
ColumnOBJECT_TYPE
ColumnOBJECT_ID
ColumnREGION
ColumnCOUNTRY
Columns
Name Datatype Length Mandatory Comments
LEAD_DAILY_TRANSACTION_ID NUMBER
Yes Unique Identifier
CREATION_DATE DATE

Who Column
LAST_UPDATE_DATE DATE

Who Column
CREATED_BY NUMBER

Who Column
LAST_UPDATED_BY NUMBER

Who Column
LAST_UPDATE_LOGIN NUMBER

Who Column
TRANSACTION_CREATE_DATE DATE

The date transacted
GROUP_ID NUMBER

Group where the lead belongs
LEAD_RANK_ID NUMBER

Rank of the Lead
LEAD_SOURCE VARCHAR2 (30)
Source through wich lead is generated
LEAD_STATUS VARCHAR2 (30)
Status of the Lead
OPEN_FLAG VARCHAR2 (3)
Flag to determine if the lead is open or not
OBJECT_TYPE VARCHAR2 (30)
Type of object generating the lead (Campaign or Event)
OBJECT_ID NUMBER

Object identifier (Campaign Id Or Event Id)
REGION VARCHAR2 (30)
Region in which Lead is generated
COUNTRY VARCHAR2 (30)
Country in which Lead is generated
BUSINESS_UNIT_ID NUMBER

Business Unit of the object (Campaign or Event)
YEAR VARCHAR2 (30)
Year of the transaction
QTR VARCHAR2 (30)
Fiscal Quarter in which lead is generated
MONTH VARCHAR2 (30)
Fiscal Month in which lead is generated
LEADS_OPEN NUMBER

Number of leads in open status
LEADS_CLOSED NUMBER

Number of leads in closed status
LEADS_NEW NUMBER

Number of leads in new status
LEADS_DEAD NUMBER

Number of leads in dead status
LEADS_CHANGED NUMBER

Leads being processed by assignee
LEADS_UNCHANGED NUMBER

Leads not processed by assignee
LEADS_ASSIGNED NUMBER

Leads assigned to sales rep
OPPORTUNITIES NUMBER

No. of oppertunities
OPPORTUNITIES_OPEN NUMBER

No of open oppertunities
QUOTES NUMBER

No of quotes
QUOTES_OPEN NUMBER

No of quotes in open status
ORDERS NUMBER

No of orders in Booked status
WEEKEND_DATE DATE

Next saturday
METRIC1 NUMBER

future usage
METRIC2 NUMBER

Future usage
METRIC3 NUMBER

Future usage
METRIC4 NUMBER

Future usage
METRIC5 NUMBER

Future usage
METRIC6 NUMBER

Future usage
METRIC7 NUMBER

Future usage
METRIC8 NUMBER

Future usage
METRIC9 NUMBER

Future usage
METRIC10 NUMBER

Future usage
METRIC11 NUMBER

Future usage
METRIC12 NUMBER

Future usage
METRIC13 NUMBER

Future usage
METRIC14 NUMBER

Future usage
METRIC15 NUMBER

Future usage
SECURITY_GROUP_ID NUMBER

Used in hosted environments
Query Text

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


SELECT LEAD_DAILY_TRANSACTION_ID
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      TRANSACTION_CREATE_DATE
,      GROUP_ID
,      LEAD_RANK_ID
,      LEAD_SOURCE
,      LEAD_STATUS
,      OPEN_FLAG
,      OBJECT_TYPE
,      OBJECT_ID
,      REGION
,      COUNTRY
,      BUSINESS_UNIT_ID
,      YEAR
,      QTR
,      MONTH
,      LEADS_OPEN
,      LEADS_CLOSED
,      LEADS_NEW
,      LEADS_DEAD
,      LEADS_CHANGED
,      LEADS_UNCHANGED
,      LEADS_ASSIGNED
,      OPPORTUNITIES
,      OPPORTUNITIES_OPEN
,      QUOTES
,      QUOTES_OPEN
,      ORDERS
,      WEEKEND_DATE
,      METRIC1
,      METRIC2
,      METRIC3
,      METRIC4
,      METRIC5
,      METRIC6
,      METRIC7
,      METRIC8
,      METRIC9
,      METRIC10
,      METRIC11
,      METRIC12
,      METRIC13
,      METRIC14
,      METRIC15
,      SECURITY_GROUP_ID
FROM BIM.BIM_R_LEAD_DAILY_FACTS;

Dependencies

[top of page]

BIM.BIM_R_LEAD_DAILY_FACTS does not reference any database object

BIM.BIM_R_LEAD_DAILY_FACTS is referenced by following:

SchemaAPPS
SynonymBIM_R_LEAD_DAILY_FACTS