[Home] [Help] [Dependency Information]
Object Name: | BISBV_PERFORMANCE_MEASURES |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIS.BISBV_PERFORMANCE_MEASURES |
Subobject Name: | |
Status: | VALID |
MultiLingual view (a language resolved view of the data.)
BISBV_PERFORMANCE_MEASURES is the business view which provides information about the entity BIS_INDICATORS.
Business Views are intended to provide a consistent interface for ad-hoc queries by providing simple table joins for over-normalized data and plain english column names for hard to understand columns.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MEASURE_ID | NUMBER | Yes | Performance Measure ID | |
MEASURE_SHORT_NAME | VARCHAR2 | (30) | Yes | Performance Measure Short Name |
MEASURE_NAME | VARCHAR2 | (255) | Yes | Long Name for the Performance Measure |
DESCRIPTION | VARCHAR2 | (1024) | Description for the Performance Measure | |
DIMENSION1_ID | NUMBER | Dimension1 ID | ||
DIMENSION2_ID | NUMBER | Dimension2 ID | ||
DIMENSION3_ID | NUMBER | Dimension3 ID | ||
DIMENSION4_ID | NUMBER | Dimension4 ID | ||
DIMENSION5_ID | NUMBER | Dimension5 ID | ||
DIMENSION6_ID | NUMBER | Dimension6 ID | ||
DIMENSION7_ID | NUMBER | Dimension7 ID | ||
UNIT_OF_MEASURE_CLASS | VARCHAR2 | (10) | Unit Of Measure | |
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 | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT MEASURE_ID
, MEASURE_SHORT_NAME
, MEASURE_NAME
, DESCRIPTION
, DIMENSION1_ID
, DIMENSION2_ID
, DIMENSION3_ID
, DIMENSION4_ID
, DIMENSION5_ID
, DIMENSION6_ID
, DIMENSION7_ID
, UNIT_OF_MEASURE_CLASS
, ACTUAL_DATA_SOURCE_TYPE
, ACTUAL_DATA_SOURCE
, FUNCTION_NAME
, COMPARISON_SOURCE
, INCREASE_IN_MEASURE
, ENABLE_LINK
, DATASET_ID
, ENABLED
, OBSOLETE
, MEASURE_TYPE
FROM APPS.BISBV_PERFORMANCE_MEASURES;
|
|
|