[Home] [Help] [Dependency Information]
Object Name: | BSC_SYS_OBJECTIVE_COLORS |
---|---|
Object Type: | TABLE |
Owner: | BSC |
FND Design Data: | BSC.BSC_SYS_OBJECTIVE_COLORS |
Subobject Name: | |
Status: | VALID |
Table to store the color of the Objectives
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BSC_SYS_OBJECTIVE_COLORS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TAB_ID
INDICATOR DIM_LEVEL1 DIM_LEVEL2 DIM_LEVEL3 DIM_LEVEL4 DIM_LEVEL5 DIM_LEVEL6 DIM_LEVEL7 DIM_LEVEL8 PERIOD_ID |
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. |
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;
BSC.BSC_SYS_OBJECTIVE_COLORS does not reference any database object
BSC.BSC_SYS_OBJECTIVE_COLORS is referenced by following:
|
|
|