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

TABLE: BSC.BSC_COLOR_TYPE_PROPS

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

This table stores the Color Ranges for the KPI Measures and Objectives. We kept this separate so as to allow multiple threshold ranges for the same KPI Measure (or Objective) for different color types. For WA calculation for the Objective, KPI_MEASURE_ID will be NULL.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_COLOR_TYPE_PROPS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINDICATOR
BSC_COLOR_TYPE_PROPS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnKPI_MEASURE_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Yes Objective Id
KPI_MEASURE_ID NUMBER

KPI Measure Id
COLOR_TYPE VARCHAR2 (30)
Indicates the type of color calculations for a KPI. Can have any values of: PERCENT_OF_TARGET, PERCENT_OF_KPI, CONSTANT
COLOR_RANGE_ID NUMBER

The Color Range Id for the KPI and the Objective.
CREATION_DATE DATE
Yes Creation Date
CREATED_BY NUMBER (15) Yes Created By
LAST_UPDATE_DATE DATE
Yes Last Update Date
LAST_UPDATED_BY NUMBER (15) Yes Last Updated By
LAST_UPDATE_LOGIN NUMBER (15)
Last Update Login
PROPERTY_VALUE NUMBER

Generic column to be used in conjunction with Indicator and KPI Measure Id for storing any property.
Query Text

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


SELECT INDICATOR
,      KPI_MEASURE_ID
,      COLOR_TYPE
,      COLOR_RANGE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROPERTY_VALUE
FROM BSC.BSC_COLOR_TYPE_PROPS;

Dependencies

[top of page]

BSC.BSC_COLOR_TYPE_PROPS does not reference any database object

BSC.BSC_COLOR_TYPE_PROPS is referenced by following:

SchemaAPPS
SynonymBSC_COLOR_TYPE_PROPS