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

TABLE: BIM.BIM_R_KPI_FACTS

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


This table stores the kpi facts


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

Standard who column
CREATED_BY NUMBER

Standard who column
LAST_UPDATE_DATE DATE

Standard who column
LAST_UPDATED_BY NUMBER

Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
OBJECT_ID NUMBER

Campaign, Campaign Schedule, Event, Event Offer Identifier
OBJECT_TYPE VARCHAR2 (4)
Campaign, Campaign Schedule, Event, Event Offer Type
REGION VARCHAR2 (30)
Region corresponding to this object
COUNTRY NUMBER

Country of this object
BUSINESS_UNIT NUMBER

Business Unit Identifier
START_DATE DATE

Start date of the object
END_DATE DATE

End date of the Object
STATUS VARCHAR2 (30)
Status of the Object
PERIOD_TYPE VARCHAR2 (15)
Period type
CALCULATION_TYPE VARCHAR2 (15)
Type of calculation
COST_CUR_PERIOD NUMBER

Cost per Current period
COST_PRE_PERIOD NUMBER

Cost in the previous period
LEADS_CUR_PERIOD NUMBER

Leads generated in the current period
LEADS_PRE_PERIOD NUMBER

Leads generated in the previous period
REG_CUR_PERIOD NUMBER

Number of registrations in the current period
REG_PRE_PERIOD NUMBER

Number of registrations in the previous period
REV_CUR_PERIOD NUMBER

Revenue in the current period
REV_PRE_PERIOD NUMBER

Revenue in the previous period
ORDERS_CUR_PERIOD NUMBER

Number of the orders in the current period
ORDERS_PRE_PERIOD NUMBER

Number of the orders in the previous period
RES_CUR_PERIOD NUMBER

Number of the responses in the current period
RES_PRE_PERIOD NUMBER

Number of the responses in the previous period
ALEADS_CUR_PERIOD NUMBER

Number of hot leads in current period
ALEADS_PRE_PERIOD NUMBER

Number of hot leads in current period
Query Text

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


SELECT CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_ID
,      OBJECT_TYPE
,      REGION
,      COUNTRY
,      BUSINESS_UNIT
,      START_DATE
,      END_DATE
,      STATUS
,      PERIOD_TYPE
,      CALCULATION_TYPE
,      COST_CUR_PERIOD
,      COST_PRE_PERIOD
,      LEADS_CUR_PERIOD
,      LEADS_PRE_PERIOD
,      REG_CUR_PERIOD
,      REG_PRE_PERIOD
,      REV_CUR_PERIOD
,      REV_PRE_PERIOD
,      ORDERS_CUR_PERIOD
,      ORDERS_PRE_PERIOD
,      RES_CUR_PERIOD
,      RES_PRE_PERIOD
,      ALEADS_CUR_PERIOD
,      ALEADS_PRE_PERIOD
FROM BIM.BIM_R_KPI_FACTS;

Dependencies

[top of page]

BIM.BIM_R_KPI_FACTS does not reference any database object

BIM.BIM_R_KPI_FACTS is referenced by following:

SchemaAPPS
SynonymBIM_R_KPI_FACTS