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

TABLE: BSC.BSC_KPI_DATA_TABLES

Object Details
Object Name: BSC_KPI_DATA_TABLES
Object Type: TABLE
Owner: BSC
FND Design Data: TableBSC.BSC_KPI_DATA_TABLES
Subobject Name:
Status: VALID


BSC_KPI_DATA_TABLES stores information about data table configuration by indicator.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_KPI_DATA_TABLES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINDICATOR
ColumnPERIODICITY_ID
ColumnDIM_SET_ID
ColumnLEVEL_COMB
BSC_KPI_DATA_TABLES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTABLE_NAME
BSC_KPI_DATA_TABLES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMV_NAME
Columns
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
Query Text

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;

Dependencies

[top of page]

BSC.BSC_KPI_DATA_TABLES does not reference any database object

BSC.BSC_KPI_DATA_TABLES is referenced by following:

SchemaAPPS
SynonymBSC_KPI_DATA_TABLES