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

TABLE: BSC.BSC_SYS_OBJECTIVE_COLORS

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

Table to store the color of the Objectives

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_SYS_OBJECTIVE_COLORS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAB_ID
ColumnINDICATOR
ColumnDIM_LEVEL1
ColumnDIM_LEVEL2
ColumnDIM_LEVEL3
ColumnDIM_LEVEL4
ColumnDIM_LEVEL5
ColumnDIM_LEVEL6
ColumnDIM_LEVEL7
ColumnDIM_LEVEL8
ColumnPERIOD_ID
Columns
Name Datatype Length Mandatory Comments
TAB_ID NUMBER (5) Yes Scorecard Id
INDICATOR NUMBER (5) Yes Objective Id
DIM_LEVEL1 VARCHAR2 (400) Yes Dimension Level1 Value
DIM_LEVEL2 VARCHAR2 (400) Yes Dimension Level2 Value
DIM_LEVEL3 VARCHAR2 (400) Yes Dimension Level3 Value
DIM_LEVEL4 VARCHAR2 (400) Yes Dimension Level4 Value
DIM_LEVEL5 VARCHAR2 (400) Yes Dimension Level5 Value
DIM_LEVEL6 VARCHAR2 (400) Yes Dimension Level6 Value
DIM_LEVEL7 VARCHAR2 (400) Yes Dimension Level7 Value
DIM_LEVEL8 VARCHAR2 (400) Yes Dimension Level8 Value
PERIOD_ID NUMBER (5) Yes Period Id
OBJ_COLOR NUMBER (8) Yes Color of the Objective
OBJ_TREND NUMBER

Trend Id of the Objective
DRIVING_KPI_MEASURE_ID NUMBER

The KPI Measure Id based on which Objective color is derived.
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
,      OBJ_COLOR
,      OBJ_TREND
,      DRIVING_KPI_MEASURE_ID
FROM BSC.BSC_SYS_OBJECTIVE_COLORS;

Dependencies

[top of page]

BSC.BSC_SYS_OBJECTIVE_COLORS does not reference any database object

BSC.BSC_SYS_OBJECTIVE_COLORS is referenced by following:

SchemaAPPS
SynonymBSC_SYS_OBJECTIVE_COLORS