[Home] [Help] [Dependency Information]
Object Name: | BSC_SYS_MEASURES |
---|---|
Object Type: | TABLE |
Owner: | BSC |
FND Design Data: | BSC.BSC_SYS_MEASURES |
Subobject Name: | |
Status: | VALID |
BSC_SYS_MEASURES stores information about measures such as measure identifier, measure column, operation and random limit data for prototype mode.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
BSC_SYS_MEASURES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | MEASURE_ID |
BSC_SYS_MEASURES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | MEASURE_COL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MEASURE_ID | NUMBER | (5) | Yes | Measure identifier |
MEASURE_COL | VARCHAR2 | (320) | Yes | Measure column |
OPERATION | VARCHAR2 | (5) | Yes | Measure operation (SUM,AVG,MIN,..) |
TYPE | NUMBER | (3) | Yes | Measure type |
MIN_ACTUAL_VALUE | NUMBER | Random -Minimum Value | ||
MAX_ACTUAL_VALUE | NUMBER | Random -Maximum Value | ||
MIN_BUDGET_VALUE | NUMBER | Random -Minimum Budget Value | ||
MAX_BUDGET_VALUE | NUMBER | Random -Maximum budget Value | ||
RANDOM_STYLE | NUMBER | (3) | Random style | |
EDW_FLAG | NUMBER | (1) | Flag that indicates if the measure is EDW | |
EDW_FACT_ID | NUMBER | EDW fact table identifier | ||
EDW_MEAS_ID | NUMBER | EDW measure identifier | ||
S_COLOR_FORMULA | VARCHAR2 | (4000) | Simulation Tree color formula | |
SHORT_NAME | VARCHAR2 | (30) | Short name | |
SOURCE | VARCHAR2 | (10) | Source | |
CREATED_BY | NUMBER | (15) | Standard Who column | |
CREATION_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who column | |
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT MEASURE_ID
, MEASURE_COL
, OPERATION
, TYPE
, MIN_ACTUAL_VALUE
, MAX_ACTUAL_VALUE
, MIN_BUDGET_VALUE
, MAX_BUDGET_VALUE
, RANDOM_STYLE
, EDW_FLAG
, EDW_FACT_ID
, EDW_MEAS_ID
, S_COLOR_FORMULA
, SHORT_NAME
, SOURCE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM BSC.BSC_SYS_MEASURES;
BSC.BSC_SYS_MEASURES does not reference any database object
BSC.BSC_SYS_MEASURES is referenced by following:
|
|
|