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_LEVELS

Object Details

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

BIS_LEVELS lists all the terms which can be used to define a level of partitioning along a particular dimension. For example, "month", "quarter" and "year" are all levels at which records can grouped in the time domension.
Levels for the geography dimesion would include "city", "state" and "country".

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIS_LEVELS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LEVEL_ID
BIS_LEVELS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHORT_NAME
BIS_LEVELS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEVEL_VALUES_VIEW_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
LEVEL_ID	NUMBER		Yes	Dimension Level ID
SHORT_NAME	VARCHAR2	(30)	Yes	Dimension Level Short Name
DIMENSION_ID	NUMBER		Yes	Dimension ID. The dimension that the level belongs to.
LEVEL_VALUES_VIEW_NAME	VARCHAR2	(30)		View associated to the Level. This view provides the data from the source system for the level.
WHERE_CLAUSE	VARCHAR2	(2000)		No Longer Used
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).
SOURCE	VARCHAR2	(30)	Yes	Source system type for the dimension level, such as OLTP or EDW.
COMPARISON_LABEL_CODE	VARCHAR2	(30)		Comparison Label Code
ATTRIBUTE_CODE	VARCHAR2	(30)		Attribute Code
APPLICATION_ID	NUMBER			Application Id
VIEW_OBJECT_NAME	VARCHAR2	(255)		View Object Name
DEFAULT_VALUES_API	VARCHAR2	(255)		Default Values API
DEFAULT_SEARCH	VARCHAR2	(480)		Default Search
LONG_LOV	VARCHAR2	(1)		Long LOV
MASTER_LEVEL	VARCHAR2	(30)		Master Level
ENABLED	VARCHAR2	(1)		Enabled , T or F
DRILL_TO_FORM_FUNCTION	VARCHAR2	(480)		Drill To Form Function
HIDE_IN_DESIGN	VARCHAR2	(1)

Query Text

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


SELECT LEVEL_ID
,      SHORT_NAME
,      DIMENSION_ID
,      LEVEL_VALUES_VIEW_NAME
,      WHERE_CLAUSE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SOURCE
,      COMPARISON_LABEL_CODE
,      ATTRIBUTE_CODE
,      APPLICATION_ID
,      VIEW_OBJECT_NAME
,      DEFAULT_VALUES_API
,      DEFAULT_SEARCH
,      LONG_LOV
,      MASTER_LEVEL
,      ENABLED
,      DRILL_TO_FORM_FUNCTION
,      HIDE_IN_DESIGN
FROM BIS.BIS_LEVELS;

Dependencies

[top of page]

BIS.BIS_LEVELS does not reference any database object

BIS.BIS_LEVELS is referenced by following:

APPS: BIS_LEVELS