[Home] [Help] [Dependency Information]
Object Name: | BIM_I_SGMT_FACTS |
---|---|
Object Type: | TABLE |
Owner: | BIM |
Subobject Name: | |
Status: | VALID |
Segment Fact table
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BIM_I_SGMT_FACTS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TRANSACTION_CREATE_DATE
METRIC_TYPE SEGMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_CREATE_DATE | DATE | Transaction Create Date | ||
SEGMENT_ID | NUMBER | Segment ID | ||
METRIC_TYPE | VARCHAR2 | (10) | Metric Type | |
SEGMENT_SIZE | NUMBER | Segment Size | ||
SEGMENT_STATUS | VARCHAR2 | (30) | Segment Status | |
CUST_COUNT_WEEK | NUMBER | Active Customer count for the week | ||
CUST_COUNT_MONTH | NUMBER | Active Customer count for the month | ||
CUST_COUNT_QTR | NUMBER | Active Customer count for the quarter | ||
CUST_COUNT_YEAR | NUMBER | Active Customer count for the year | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_CREATE_DATE
, SEGMENT_ID
, METRIC_TYPE
, SEGMENT_SIZE
, SEGMENT_STATUS
, CUST_COUNT_WEEK
, CUST_COUNT_MONTH
, CUST_COUNT_QTR
, CUST_COUNT_YEAR
, CREATION_DATE
, LAST_UPDATE_DATE
, CREATED_BY
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM BIM.BIM_I_SGMT_FACTS;
BIM.BIM_I_SGMT_FACTS does not reference any database object
BIM.BIM_I_SGMT_FACTS is referenced by following:
|
|
|