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_APPRAISALS

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_APPRAISALS_PK

APPRAISAL_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_APPRAISALS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPRAISAL_ID
PER_APPRAISALS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PER_APPRAISALS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPRAISAL_TEMPLATE_ID
PER_APPRAISALS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OVERALL_PERFORMANCE_LEVEL_ID
PER_APPRAISALS_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPRAISEE_PERSON_ID
PER_APPRAISALS_FK5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	APPRAISER_PERSON_ID
PER_APPRAISALS_FK6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MAIN_APPRAISER_ID
PER_APPRAISALS_FK7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EVENT_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PER_APPRAISALS	HR_ALL_ORGANIZATION_UNITS	PER_APPRAISALS BUSINESS_GROUP_ID
PER_APPRAISALS	PER_APPRAISAL_TEMPLATES	PER_APPRAISALS APPRAISAL_TEMPLATE_ID
PER_APPRAISALS	PER_RATING_LEVELS	PER_APPRAISALS OVERALL_PERFORMANCE_LEVEL_ID
PER_ASSESSMENTS	PER_APPRAISALS	PER_ASSESSMENTS APPRAISAL_ID
PER_OBJECTIVES	PER_APPRAISALS	PER_OBJECTIVES APPRAISAL_ID
PER_PERFORMANCE_RATINGS	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
RETENTION_POTENTIAL	VARCHAR2	(30)		Retention Potential
SHOW_PARTICIPANT_COMMENTS	VARCHAR2	(30)		Stores whether the participant comment would be shown.

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
,      RETENTION_POTENTIAL
,      SHOW_PARTICIPANT_COMMENTS
FROM HR.PER_APPRAISALS;

Dependencies

[top of page]

HR.PER_APPRAISALS does not reference any database object

HR.PER_APPRAISALS is referenced by following:

HR: PER_APPRAISALS#