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: HR.PER_OBJECTIVES_LIBRARY

Object Details

Object Name:	PER_OBJECTIVES_LIBRARY
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_OBJECTIVES_LIBRARY
Subobject Name:
Status:	VALID

PER_OBJECTIVES_LIBRARY holds a library of reusable objectives that can contain eligibility to automatically allocate objectives to people.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_OBJECTIVES_LIBRARY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECTIVE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECTIVE_ID	NUMBER	(15)	Yes	System generated objective primary key from PER_OBJECTIVES_LIBRARY_S.
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	System-generated version of row. Increments by one with each update.
OBJECTIVE_NAME	VARCHAR2	(400)	Yes	A short reference to summarize the objective.
VALID_FROM	DATE			The date from which the objective is valid.
VALID_TO	DATE			The date when the objective is no longer valid.
TARGET_DATE	DATE			The date by when the objective should be met.
NEXT_REVIEW_DATE	DATE			Informational-only date to indicate when the objective should next be reviewed.
GROUP_CODE	VARCHAR2	(30)		Uses the lookup type HR_WPM_GROUP to categorize objectives.
PRIORITY_CODE	VARCHAR2	(30)		Uses the lookup type HR_WPM_PRIORITY to provide a default priority.
APPRAISE_FLAG	VARCHAR2	(30)	Yes	Uses the lookup type YES_NO to provide a default for whether this objective should be appraised.
WEIGHTING_PERCENT	NUMBER	(15)		Provides a default weighting for this objective, used to score overall appraisal ratings.
MEASUREMENT_STYLE_CODE	VARCHAR2	(30)	Yes	Uses the lookup type HR_WPM_MEASUREMENT_STYLE to indicate the style of measurement.
MEASURE_NAME	VARCHAR2	(240)		The measure by which this objective's completion should be scored against.
TARGET_VALUE	NUMBER			The target measure, either a Maximum target or a Minimum target, depending on the measure_type.
UOM_CODE	VARCHAR2	(30)		Uses the lookup type HR_WPM_MEASURE_UOM to determine the measure's unit of measure.
MEASURE_TYPE_CODE	VARCHAR2	(30)		Uses the lookup type HR_WPM_MEASURE_TYPE to determine whether the target measure is a minimum or maximum.
MEASURE_COMMENTS	VARCHAR2	(4000)		Comments regarding the measure and target.
ELIGIBILITY_TYPE_CODE	VARCHAR2	(30)	Yes	Uses the lookup type HR_WPM_ELIGIBILITY to determine the type of eligibility used.
DETAILS	VARCHAR2	(4000)		Provides further objective details.
SUCCESS_CRITERIA	VARCHAR2	(4000)		Additional criteria that determines the success of this objective.
COMMENTS	VARCHAR2	(4000)		General comments about this objective.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE21	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE22	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE23	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE24	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE25	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE26	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE27	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE28	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE29	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE30	VARCHAR2	(150)		Descriptive flexfield column.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.

Query Text

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


SELECT OBJECTIVE_ID
,      OBJECT_VERSION_NUMBER
,      OBJECTIVE_NAME
,      VALID_FROM
,      VALID_TO
,      TARGET_DATE
,      NEXT_REVIEW_DATE
,      GROUP_CODE
,      PRIORITY_CODE
,      APPRAISE_FLAG
,      WEIGHTING_PERCENT
,      MEASUREMENT_STYLE_CODE
,      MEASURE_NAME
,      TARGET_VALUE
,      UOM_CODE
,      MEASURE_TYPE_CODE
,      MEASURE_COMMENTS
,      ELIGIBILITY_TYPE_CODE
,      DETAILS
,      SUCCESS_CRITERIA
,      COMMENTS
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_OBJECTIVES_LIBRARY;

Dependencies

[top of page]

HR.PER_OBJECTIVES_LIBRARY does not reference any database object

HR.PER_OBJECTIVES_LIBRARY is referenced by following:

APPS: PER_OBJECTIVES_LIBRARY; PER_OBJECTIVES_LIBRARY_WHO
PUBLIC: PER_OBJECTIVES_LIBRARY