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: BIS.BIS_INDICATORS

Object Details

Object Name:	BIS_INDICATORS
Object Type:	TABLE
Owner:	BIS
FND Design Data:	BIS.BIS_INDICATORS
Subobject Name:
Status:	VALID

BIS_INDICATORS stores the names and IDs of various performance measures that users will want to calculate and view in order to track company performance. The names indicator and performance measure are used interchangeably in this documentation.
Different database functions are defined in the BIS product to calculate the performance measure for each target level.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIS_INDICATORS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INDICATOR_ID
BIS_INDICATORS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHORT_NAME
BIS_INDICATORS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	DATASET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INDICATOR_ID	NUMBER		Yes	Performance Measure ID
SHORT_NAME	VARCHAR2	(30)	Yes	Performance Measure Short Name
UOM_CLASS	VARCHAR2	(10)		UOM_CLASS (Unit of Measure Class) describes the physical quantity being measured by the performance measure: e.g. time, count, money, dimensionless ratio. (The word "dimension" is typically ised to describe the same concept, but in this documentation we use "dimension" to refer to aggregation criteria, and UOM Class to refer to physical dimension.)
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ACTUAL_DATA_SOURCE_TYPE	VARCHAR2	(30)		Actual Data Source Type
ACTUAL_DATA_SOURCE	VARCHAR2	(240)		Actual Data Source
FUNCTION_NAME	VARCHAR2	(480)		Function Name
COMPARISON_SOURCE	VARCHAR2	(240)		Comparison Source
INCREASE_IN_MEASURE	VARCHAR2	(1)		Increase In Measure Is
ENABLE_LINK	VARCHAR2	(1)		Enable Link
DATASET_ID	NUMBER	(5)		Dataset id
ENABLED	VARCHAR2	(1)		Enabled Flag
OBSOLETE	VARCHAR2	(1)		Obsolete Flag
MEASURE_TYPE	VARCHAR2	(30)		MEASURE_TYPE

Query Text

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


SELECT INDICATOR_ID
,      SHORT_NAME
,      UOM_CLASS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ACTUAL_DATA_SOURCE_TYPE
,      ACTUAL_DATA_SOURCE
,      FUNCTION_NAME
,      COMPARISON_SOURCE
,      INCREASE_IN_MEASURE
,      ENABLE_LINK
,      DATASET_ID
,      ENABLED
,      OBSOLETE
,      MEASURE_TYPE
FROM BIS.BIS_INDICATORS;

Dependencies

[top of page]

BIS.BIS_INDICATORS does not reference any database object

BIS.BIS_INDICATORS is referenced by following:

APPS: BIS_INDICATORS