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: TablePER.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PER_OBJECTIVES_LIBRARY_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECTIVE_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:

SchemaHR
ViewPER_OBJECTIVES_LIBRARY#