[Home] [Help] [Dependency Information]
Object Name: | BSC_KPI_DATA_TABLES |
---|---|
Object Type: | TABLE |
Owner: | BSC |
FND Design Data: | BSC.BSC_KPI_DATA_TABLES |
Subobject Name: | |
Status: | VALID |
BSC_KPI_DATA_TABLES stores information about data table configuration by indicator.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BSC_KPI_DATA_TABLES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
INDICATOR
PERIODICITY_ID DIM_SET_ID LEVEL_COMB |
BSC_KPI_DATA_TABLES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TABLE_NAME |
BSC_KPI_DATA_TABLES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MV_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INDICATOR | NUMBER | (5) | Yes | Indicator code |
PERIODICITY_ID | NUMBER | (5) | Yes | Periodicity identifier |
DIM_SET_ID | NUMBER | (3) | Yes | Dimensiot set identifier |
LEVEL_COMB | VARCHAR2 | (30) | Yes | Dimension level combination. Each character (?,0,1) represents a dimension level. |
TABLE_NAME | VARCHAR2 | (30) | System data table name | |
FILTER_CONDITION | VARCHAR2 | (240) | Condition. Each dimension level is represented as D<#> | |
MV_NAME | VARCHAR2 | (30) | It stores the MV name to be used by KPI | |
PROJECTION_SOURCE | NUMBER | Projection source | ||
DATA_SOURCE | VARCHAR2 | (10) | It stores data source | |
SQL_STMT | VARCHAR2 | (4000) | It stores Sql Statement to be used by KPI | |
PROJECTION_DATA | VARCHAR2 | (30) | Projection data |
Cut, paste (and edit) the following text to query this object:
SELECT INDICATOR
, PERIODICITY_ID
, DIM_SET_ID
, LEVEL_COMB
, TABLE_NAME
, FILTER_CONDITION
, MV_NAME
, PROJECTION_SOURCE
, DATA_SOURCE
, SQL_STMT
, PROJECTION_DATA
FROM BSC.BSC_KPI_DATA_TABLES;
BSC.BSC_KPI_DATA_TABLES does not reference any database object
BSC.BSC_KPI_DATA_TABLES is referenced by following:
|
|
|