eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BSC.BSC_SYS_KPI_COLORS

Object Details

Object Name:	BSC_SYS_KPI_COLORS
Object Type:	TABLE
Owner:	BSC
FND Design Data:	BSC.BSC_SYS_KPI_COLORS
Subobject Name:
Status:	VALID

BSC_SYS_KPI_COLORS stores kpi color by tab. Each row includes values that identify the particular indicator information in the tab such as color, actual data, budget data, trend flag by tab and dimension level in the List Button.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BSC_SYS_KPI_COLORS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TAB_ID INDICATOR KPI_MEASURE_ID DIM_LEVEL1 DIM_LEVEL2 DIM_LEVEL3 DIM_LEVEL4 DIM_LEVEL5 DIM_LEVEL6 DIM_LEVEL7 DIM_LEVEL8 PERIOD_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TAB_ID	NUMBER	(5)	Yes	Tab identifier
INDICATOR	NUMBER	(5)	Yes	Indicator code
DIM_LEVEL1	VARCHAR2	(400)	Yes	Dimension level 1
DIM_LEVEL2	VARCHAR2	(400)	Yes	Dimension level 2
DIM_LEVEL3	VARCHAR2	(400)	Yes	Dimension level 3
DIM_LEVEL4	VARCHAR2	(400)	Yes	Dimension level 4
DIM_LEVEL5	VARCHAR2	(400)	Yes	Dimension level 5
DIM_LEVEL6	VARCHAR2	(400)	Yes	Dimension level 6
DIM_LEVEL7	VARCHAR2	(400)	Yes	Dimension level 7
DIM_LEVEL8	VARCHAR2	(400)	Yes	Dimension level 8
PERIOD_ID	NUMBER	(5)	Yes	Period identifier
KPI_COLOR	NUMBER	(11)	Yes	Indicator color
USER_COLOR	NUMBER	(11)	Yes	Customize color
ACTUAL_DATA	NUMBER			Actual data
BUDGET_DATA	NUMBER			Budget data
TREND_FLAG	NUMBER	(1)		Trend Flag
KPI_TREND	NUMBER			Trend Id of the KPI Measure
KPI_MEASURE_ID	NUMBER			KPI Measure Id

Query Text

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


SELECT TAB_ID
,      INDICATOR
,      DIM_LEVEL1
,      DIM_LEVEL2
,      DIM_LEVEL3
,      DIM_LEVEL4
,      DIM_LEVEL5
,      DIM_LEVEL6
,      DIM_LEVEL7
,      DIM_LEVEL8
,      PERIOD_ID
,      KPI_COLOR
,      USER_COLOR
,      ACTUAL_DATA
,      BUDGET_DATA
,      TREND_FLAG
,      KPI_TREND
,      KPI_MEASURE_ID
FROM BSC.BSC_SYS_KPI_COLORS;

Dependencies

[top of page]

BSC.BSC_SYS_KPI_COLORS does not reference any database object

BSC.BSC_SYS_KPI_COLORS is referenced by following:

APPS: BSC_SYS_KPI_COLORS