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_TARGET_VALUES

Object Details

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

BIS_TARGET_VALUES holds the values that a user had entered as a performance target for a particular measure and target level.
For example, if a manager projects turnover in the Denver office for the month on Marh 1999 for clerical staff to be 2, then an entry must be defined in BIS_TARGET_VALUES which ties all these paremters into a target value.
Several business plans may specify different values for the same target.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIS_TARGET_VALUES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TARGET_ID
BIS_TARGET_VALUES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TARGET_LEVEL_ID ORG_LEVEL_VALUE TIME_LEVEL_VALUE PLAN_ID DIMENSION1_LEVEL_VALUE DIMENSION2_LEVEL_VALUE DIMENSION3_LEVEL_VALUE DIMENSION4_LEVEL_VALUE DIMENSION5_LEVEL_VALUE DIMENSION6_LEVEL_VALUE DIMENSION7_LEVEL_VALUE

Columns

Name	Datatype	Length	Mandatory	Comments
TARGET_ID	NUMBER		Yes	Target ID
TARGET_LEVEL_ID	NUMBER		Yes	Target Level ID Column
PLAN_ID	NUMBER		Yes	Business plan ID
ORG_LEVEL_VALUE	VARCHAR2	(80)		No Longer Used
TIME_LEVEL_VALUE	VARCHAR2	(80)		No Longer Used
DIMENSION1_LEVEL_VALUE	VARCHAR2	(80)		Dimension1 Level Value ID
DIMENSION2_LEVEL_VALUE	VARCHAR2	(80)		Dimension2 Level Value ID
DIMENSION3_LEVEL_VALUE	VARCHAR2	(80)		Dimension3 Level Value ID
DIMENSION4_LEVEL_VALUE	VARCHAR2	(80)		Dimension4 Level Value ID
DIMENSION5_LEVEL_VALUE	VARCHAR2	(80)		Dimension5 Level Value ID
TARGET	NUMBER			Value for the target
RANGE1_LOW	NUMBER			Percentage of the first lower range
RANGE1_HIGH	NUMBER			Percentage of the first upper range
RANGE2_LOW	NUMBER			Percentage of the second lower range
RANGE2_HIGH	NUMBER			Percentage of the second upper range
RANGE3_LOW	NUMBER			Percentage of the third lower range
RANGE3_HIGH	NUMBER			Percentage of the third upper range
ROLE1_ID	NUMBER			Workflow role ID for the owner for the first range
ROLE2_ID	NUMBER			Workflow role ID for the owner for the second range
ROLE3_ID	NUMBER			Workflow role ID for the owner for the third range
ROLE1	VARCHAR2	(100)		Workflow role for the owner for the first range
ROLE2	VARCHAR2	(100)		Workflow role for the owner for the second range
ROLE3	VARCHAR2	(100)		Workflow role for the owner for the third range
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).
DIMENSION6_LEVEL_VALUE	VARCHAR2	(80)		Dimension6 Level Value ID
DIMENSION7_LEVEL_VALUE	VARCHAR2	(80)		Dimension7 Level Value ID

Query Text

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


SELECT TARGET_ID
,      TARGET_LEVEL_ID
,      PLAN_ID
,      ORG_LEVEL_VALUE
,      TIME_LEVEL_VALUE
,      DIMENSION1_LEVEL_VALUE
,      DIMENSION2_LEVEL_VALUE
,      DIMENSION3_LEVEL_VALUE
,      DIMENSION4_LEVEL_VALUE
,      DIMENSION5_LEVEL_VALUE
,      TARGET
,      RANGE1_LOW
,      RANGE1_HIGH
,      RANGE2_LOW
,      RANGE2_HIGH
,      RANGE3_LOW
,      RANGE3_HIGH
,      ROLE1_ID
,      ROLE2_ID
,      ROLE3_ID
,      ROLE1
,      ROLE2
,      ROLE3
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DIMENSION6_LEVEL_VALUE
,      DIMENSION7_LEVEL_VALUE
FROM BIS.BIS_TARGET_VALUES;

Dependencies

[top of page]

BIS.BIS_TARGET_VALUES does not reference any database object

BIS.BIS_TARGET_VALUES is referenced by following:

APPS: BIS_TARGET_VALUES