DBA Data[Home] [Help] [Dependency Information]


TABLE: HR.PER_OBJECTIVES

Object Details
Object Name: PER_OBJECTIVES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_OBJECTIVES
Subobject Name:
Status: VALID


An objective is a target or goal which may be evaluated during an
appraisal (performance review). An objective is for a specific person.
Objectives may change over time.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_OBJECTIVES_PK
  1. ColumnOBJECTIVE_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_OBJECTIVES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECTIVE_ID
PER_OBJECTIIVES_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPRAISAL_ID
PER_OBJECTIVES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_OBJECTIVES_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOWNING_PERSON_ID
PER_OBJECTIVES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSCORECARD_ID
PER_OBJECTIVES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnALIGNED_WITH_OBJECTIVE_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_OBJECTIVES PER_OBJECTIVES_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_OBJECTIVES BUSINESS_GROUP_ID
PER_OBJECTIVES PER_OBJECTIVES_FK2 TablePER_APPRAISALS PER_OBJECTIVES APPRAISAL_ID
Columns
Name Datatype Length Mandatory Comments
OBJECTIVE_ID NUMBER (15) Yes Primary key of the Objective
NAME VARCHAR2 (400) Yes The title of of the objective
TARGET_DATE DATE

The date on which the objective is targetteg to be achieved
START_DATE DATE
Yes Start date of the objective
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER NUMBER (9) Yes System-generated version of row. Increments by one with each update.
OWNING_PERSON_ID NUMBER (15) Yes Foreign key to PER_ALL_PEOPLE_F
ACHIEVEMENT_DATE DATE

The date on which the objective is achieved
DETAIL VARCHAR2 (4000)
A detailed definition of the objective
COMMENTS VARCHAR2 (4000)
General comments about the objective
SUCCESS_CRITERIA VARCHAR2 (4000)
The success criteria or performance metrics used for the objective.
APPRAISAL_ID NUMBER (15)
Primary key of Appraisals
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.
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.
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.
SCORECARD_ID NUMBER (15)
The personal scorecard to which the objective belongs.
COPIED_FROM_LIBRARY_ID NUMBER (15)
When this objective is created by eligibility, this is the ID of the library objective from which it was copied.
COPIED_FROM_OBJECTIVE_ID NUMBER (15)
When this objective is copied from another, this is the ID of the objective from which it was copied.
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)
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.
COMPLETE_PERCENT NUMBER (15)
The percentage complete.
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.
VERIFIED_FLAG VARCHAR2 (30)
Uses the lookup type YES_NO to indicate whether the objective's achievement has been verified against the measure.
TARGET_VALUE NUMBER

The target measure, either a Maximum target or a Minimum target, depending on the measure_type.
ACTUAL_VALUE NUMBER

The actual quantity achieved against the target measure.
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.
ALIGNED_WITH_OBJECTIVE_ID NUMBER (15)
An objective that this objective contributes towards.
SHARING_ACCESS_CODE VARCHAR2 (30)
Uses the lookup type HR_WPM_OBJECTIVE_SHARING to define the objective's access permissions.
Query Text

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


SELECT OBJECTIVE_ID
,      NAME
,      TARGET_DATE
,      START_DATE
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      OWNING_PERSON_ID
,      ACHIEVEMENT_DATE
,      DETAIL
,      COMMENTS
,      SUCCESS_CRITERIA
,      APPRAISAL_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      SCORECARD_ID
,      COPIED_FROM_LIBRARY_ID
,      COPIED_FROM_OBJECTIVE_ID
,      NEXT_REVIEW_DATE
,      GROUP_CODE
,      PRIORITY_CODE
,      APPRAISE_FLAG
,      WEIGHTING_PERCENT
,      COMPLETE_PERCENT
,      MEASUREMENT_STYLE_CODE
,      MEASURE_NAME
,      VERIFIED_FLAG
,      TARGET_VALUE
,      ACTUAL_VALUE
,      UOM_CODE
,      MEASURE_TYPE_CODE
,      MEASURE_COMMENTS
,      ALIGNED_WITH_OBJECTIVE_ID
,      SHARING_ACCESS_CODE
FROM HR.PER_OBJECTIVES;

Dependencies

[top of page]

HR.PER_OBJECTIVES does not reference any database object

HR.PER_OBJECTIVES is referenced by following:

SchemaHR
ViewPER_OBJECTIVES#