eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: BSC.BSC_SYS_MEASURES

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

BSC.BSC_SYS_MEASURES does not reference any database object

BSC.BSC_SYS_MEASURES is referenced by following:

APPS: BSC_SYS_MEASURES