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

TABLE: HR.PER_APPRAISALS

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


An appraisal is a record of an evaluation of a person by others for
the purposes of
1. reviewing performance with respect to work performed and objectives
that have been set previously
2. setting new objectives for a future period
3. determining personal development requirements
4. determining action items that will be undertaken to assist in
personal development and future performance
An assessment may have an overall performance rating held against it.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PER_APPRAISALS_PK
  1. ColumnAPPRAISAL_ID
Indexes
Index Type Uniqueness Tablespace Column
PER_APPRAISALS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPRAISAL_ID
PER_APPRAISALS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PER_APPRAISALS_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPRAISAL_TEMPLATE_ID
PER_APPRAISALS_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOVERALL_PERFORMANCE_LEVEL_ID
PER_APPRAISALS_FK4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPRAISEE_PERSON_ID
PER_APPRAISALS_FK5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAPPRAISER_PERSON_ID
PER_APPRAISALS_FK6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnMAIN_APPRAISER_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PER_APPRAISALS PER_APPRAISALS_FK1 TableHR_ALL_ORGANIZATION_UNITS PER_APPRAISALS BUSINESS_GROUP_ID
PER_APPRAISALS PER_APPRAISALS_FK2 TablePER_APPRAISAL_TEMPLATES PER_APPRAISALS APPRAISAL_TEMPLATE_ID
PER_APPRAISALS PER_APPRAISALS_FK3 TablePER_RATING_LEVELS PER_APPRAISALS OVERALL_PERFORMANCE_LEVEL_ID
TablePER_ASSESSMENTS PER_ASSESSMENTS_FK4 PER_APPRAISALS PER_ASSESSMENTS APPRAISAL_ID
TablePER_OBJECTIVES PER_OBJECTIVES_FK2 PER_APPRAISALS PER_OBJECTIVES APPRAISAL_ID
TablePER_PERFORMANCE_RATINGS PER_PERFORMANCE_RATINGS_FK2 PER_APPRAISALS PER_PERFORMANCE_RATINGS APPRAISAL_ID
Columns
Name Datatype Length Mandatory Comments
APPRAISAL_ID NUMBER (15) Yes Primary key of Appraisals
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.
APPRAISAL_TEMPLATE_ID NUMBER (15) Yes Primary key of Appraisal Template
APPRAISEE_PERSON_ID NUMBER (15) Yes Foreign key to PER_ALL_ASSIGNMENTS_F, holds the ID of the person on whom the appraisal is being performed.
APPRAISER_PERSON_ID NUMBER (15) Yes Foreign key to PER_ALL_ASSIGNMENTS_F, holds the ID of the person performing the appraisal.
APPRAISAL_DATE DATE

The date on which the appraisal takes place
GROUP_DATE DATE

The date the group was created on.
GROUP_INITIATOR_ID NUMBER (9)
The ID of the user who created the group.
APPRAISAL_PERIOD_END_DATE DATE
Yes The date on which the review period ended
APPRAISAL_PERIOD_START_DATE DATE
Yes The date on which the review period started
TYPE VARCHAR2 (30)
The type of appraisal being performed e.g. Annual Review
NEXT_APPRAISAL_DATE DATE

The proposed date of the next appraisal
STATUS VARCHAR2 (30)
The status of the appraisal within an approval process. e.g. awai
COMMENTS VARCHAR2 (2000)
General comments about the appraisal
OVERALL_PERFORMANCE_LEVEL_ID NUMBER (15)
Unique identifier of the Rating Level
OPEN VARCHAR2 (30)
Denotes whether the appraisal can be modified or not.
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.
SYSTEM_TYPE VARCHAR2 (30)
Appraisal System Type as defined in lookup APPRAISAL_SYS_TYPE
APPRAISAL_SYSTEM_STATUS VARCHAR2 (30)
Denotes the current system status of Appraisal
SYSTEM_PARAMS VARCHAR2 (500)
Appraisal System Parameters containing Approval process name, Function customization information, Approvals Enabled
APPRAISEE_ACCESS VARCHAR2 (30)
Contains Accesswhich determines the information that will be shown to the Appraisee
MAIN_APPRAISER_ID NUMBER (15)
Foreign key to PER_ALL_PEOPLE_F, holds the ID of the person who is the Main Appraiser and is the one who gives Final Ratings for the Appraisal
ASSIGNMENT_ID NUMBER (15)
Foreign key to PER_ALL_ASSIGNMENTS_F, holds the ID of the Assignment on which this Appraisal is performed.
ASSIGNMENT_START_DATE DATE

Start Date of the Assignment which is copied from the ASSIGNMENT_ID of this Appraisal.
ASSIGNMENT_BUSINESS_GROUP_ID NUMBER (15)
Business Group Id which is copied from PER_ALL_ASSIGNMENTS_F corresponding to the ASSIGNMENT_ID and ASSIGNMENT_START_DATE of this Appraisal.
ASSIGNMENT_ORGANIZATION_ID NUMBER (15)
Organization Id which is copied from PER_ALL_ASSIGNMENTS_F corresponding to the ASSIGNMENT_ID and ASSIGNMENT_START_DATE of this Appraisal.
ASSIGNMENT_JOB_ID NUMBER (15)
Job Id which is copied from PER_ALL_ASSIGNMENTS_F corresponding to the ASSIGNMENT_ID and ASSIGNMENT_START_DATE of this Appraisal.
ASSIGNMENT_POSITION_ID NUMBER (15)
Position Id which is copied from PER_ALL_ASSIGNMENTS_F corresponding to the ASSIGNMENT_ID and ASSIGNMENT_START_DATE of this Appraisal.
ASSIGNMENT_GRADE_ID NUMBER (15)
Grade Id which is copied from PER_ALL_ASSIGNMENTS_F corresponding to the ASSIGNMENT_ID and ASSIGNMENT_START_DATE of this Appraisal.
POTENTIAL_READINESS_LEVEL VARCHAR2 (30)
Readiness Level of the Appraisee given during Final Ratings. Uses the lookup READINESS_LEVEL for the values.
POTENTIAL_SHORT_TERM_WORKOPP VARCHAR2 (240)
Potential Short Term Work Opportunity for the Appraisee given during Final Ratings.
POTENTIAL_LONG_TERM_WORKOPP VARCHAR2 (240)
Potential Long Term Work Opportunity for the Appraisee given during Final Ratings.
POTENTIAL_DETAILS VARCHAR2 (2000)
Potential Details for the Appraisee given during Final Ratings.
EVENT_ID NUMBER (15)
Foreign key to PER_EVENTS. Refers to the Event recorded for this Appraisal. The event can be used to refer to PER_PERFORMANCE_REVIEWS to get the Performance Rating for the Appraisal.
SHOW_COMPETENCY_RATINGS VARCHAR2 (30)
Show Competency Ratings
SHOW_QUESTIONNAIRE_INFO VARCHAR2 (30)
Show Questionnaire Information
SHOW_OVERALL_RATINGS VARCHAR2 (30)
Show Overall Ratings
SHOW_OVERALL_COMMENTS VARCHAR2 (30)
Show Overall Comments
UPDATE_APPRAISAL VARCHAR2 (30)
Update Appraisal
PROVIDE_OVERALL_FEEDBACK VARCHAR2 (30)
Provide Overall Feeback
SHOW_OBJECTIVE_RATINGS VARCHAR2 (30)
Show Objective Ratings
SHOW_PARTICIPANT_DETAILS VARCHAR2 (30)
Show Participant Details
SHOW_PARTICIPANT_NAMES VARCHAR2 (30)
Show Participant Names
SHOW_PARTICIPANT_RATINGS VARCHAR2 (30)
Show Participant Ratings
APPRAISEE_COMMENTS VARCHAR2 (2000)
Appraisee Comments
PLAN_ID NUMBER (15)
Foreign key to PER_PERF_MGMT_PLANS
OFFLINE_STATUS VARCHAR2 (30)
Tracks offline status of the appraisal
Query Text

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


SELECT APPRAISAL_ID
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      APPRAISAL_TEMPLATE_ID
,      APPRAISEE_PERSON_ID
,      APPRAISER_PERSON_ID
,      APPRAISAL_DATE
,      GROUP_DATE
,      GROUP_INITIATOR_ID
,      APPRAISAL_PERIOD_END_DATE
,      APPRAISAL_PERIOD_START_DATE
,      TYPE
,      NEXT_APPRAISAL_DATE
,      STATUS
,      COMMENTS
,      OVERALL_PERFORMANCE_LEVEL_ID
,      OPEN
,      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
,      SYSTEM_TYPE
,      APPRAISAL_SYSTEM_STATUS
,      SYSTEM_PARAMS
,      APPRAISEE_ACCESS
,      MAIN_APPRAISER_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_START_DATE
,      ASSIGNMENT_BUSINESS_GROUP_ID
,      ASSIGNMENT_ORGANIZATION_ID
,      ASSIGNMENT_JOB_ID
,      ASSIGNMENT_POSITION_ID
,      ASSIGNMENT_GRADE_ID
,      POTENTIAL_READINESS_LEVEL
,      POTENTIAL_SHORT_TERM_WORKOPP
,      POTENTIAL_LONG_TERM_WORKOPP
,      POTENTIAL_DETAILS
,      EVENT_ID
,      SHOW_COMPETENCY_RATINGS
,      SHOW_QUESTIONNAIRE_INFO
,      SHOW_OVERALL_RATINGS
,      SHOW_OVERALL_COMMENTS
,      UPDATE_APPRAISAL
,      PROVIDE_OVERALL_FEEDBACK
,      SHOW_OBJECTIVE_RATINGS
,      SHOW_PARTICIPANT_DETAILS
,      SHOW_PARTICIPANT_NAMES
,      SHOW_PARTICIPANT_RATINGS
,      APPRAISEE_COMMENTS
,      PLAN_ID
,      OFFLINE_STATUS
FROM HR.PER_APPRAISALS;

Dependencies

[top of page]

HR.PER_APPRAISALS does not reference any database object

HR.PER_APPRAISALS is referenced by following:

SchemaAPPS
SynonymPER_APPRAISALS
TriggerPER_APPRAISALS_WHO
SchemaPUBLIC
SynonymPER_APPRAISALS