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

TABLE: BSC.BSC_KPI_DIM_LEVEL_PROPERTIES

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


BSC_KPI_DIM_LEVEL_PROPERTIES stores information about dimension level properties.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
BSC_KPI_DIM_LEVEL_PROPERTI_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINDICATOR
ColumnDIM_SET_ID
ColumnDIM_LEVEL_ID
Columns
Name Datatype Length Mandatory Comments
INDICATOR NUMBER (5) Yes Indicator code
DIM_SET_ID NUMBER (3) Yes Dimension set identifier
DIM_LEVEL_ID NUMBER (5) Yes Dimension level identifier
POSITION NUMBER (3) Yes 0= Normal, 1= top-corner, 2= hide
TOTAL0 NUMBER (3)
If there is a code zero in DB
LEVEL_DISPLAY NUMBER (3)
To disable other dimension level index
DEFAULT_KEY_VALUE VARCHAR2 (400)
Default key value item
USER_LEVEL0 NUMBER (3)
Visibility status for level 0
USER_LEVEL1 NUMBER (3)
Visibility status for level 1
USER_LEVEL1_DEFAULT NUMBER (3)
Visibility default status for level 1
USER_LEVEL2 NUMBER (3)
Visibility status for level 2
USER_LEVEL2_DEFAULT NUMBER (3)
Visibility default status for level 2
TARGET_LEVEL NUMBER (1)
Target Level
Query Text

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


SELECT INDICATOR
,      DIM_SET_ID
,      DIM_LEVEL_ID
,      POSITION
,      TOTAL0
,      LEVEL_DISPLAY
,      DEFAULT_KEY_VALUE
,      USER_LEVEL0
,      USER_LEVEL1
,      USER_LEVEL1_DEFAULT
,      USER_LEVEL2
,      USER_LEVEL2_DEFAULT
,      TARGET_LEVEL
FROM BSC.BSC_KPI_DIM_LEVEL_PROPERTIES;

Dependencies

[top of page]

BSC.BSC_KPI_DIM_LEVEL_PROPERTIES does not reference any database object

BSC.BSC_KPI_DIM_LEVEL_PROPERTIES is referenced by following:

SchemaAPPS
SynonymBSC_KPI_DIM_LEVEL_PROPERTIES