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]

VIEW: APPS.HRFV_APPRAISAL_DETAILS

Object Details

Object Name:	HRFV_APPRAISAL_DETAILS
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

The view lists the details of appraisals and their respective ratings

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
BUSINESS_GROUP_NAME	VARCHAR2	(240)	Yes	Translated name of the organization
DEPARTMENT	VARCHAR2	(240)	Yes	Translated name of the organization
APPRAISEE	VARCHAR2	(240)
APPRAISER	VARCHAR2	(240)
MAIN_APPRAISER	VARCHAR2	(240)
APPRAISAL_DATE	DATE			The date on which the appraisal takes place
APPRAISAL_START_DATE	DATE		Yes	The date on which the review period started
APPRAISAL_END_DATE	DATE		Yes	The date on which the review period ended
NEXT_APPRAISAL_DATE	DATE			The proposed date of the next appraisal
APPRAISAL_COMMENTS	VARCHAR2	(2000)		General comments about the appraisal
RATING_LEVEL_NAME	VARCHAR2	(80)		A description of the rating level that the step indicates e.g. Poor, Average, Excellent
STEP_VALUE	NUMBER	(15)		The sequence number of the rating scale used for ordering the steps
APPRAISAL_TYPE_M	VARCHAR2	(4000)
APPRAISAL_STATUS_M	VARCHAR2	(4000)
APPRAISEE_ACCESS_M	VARCHAR2	(4000)
APPRAISAL_TYPE	VARCHAR2	(30)
APPRAISAL_STATUS	VARCHAR2	(30)
APPRAISEE_ACCESS	VARCHAR2	(30)
CREATION_DATE	DATE			The date on which the appraisal takes place
LAST_UPDATE_DATE	DATE			The date on which the appraisal takes place
_DF:APR	CHAR	(26)
APPRAISAL_ID	NUMBER	(15)	Yes
BUSINESS_GROUP_ID	NUMBER	(15)	Yes
APPRAISAL_TEMPLATE_ID	NUMBER	(15)	Yes
APPRAISEE_PERSON_ID	NUMBER	(15)	Yes
APPRAISER_PERSON_ID	NUMBER	(15)	Yes
GROUP_INITIATOR_ID	NUMBER	(9)
OVERALL_PERFORMANCE_LEVEL_ID	NUMBER	(15)
MAIN_APPRAISER_ID	NUMBER	(15)
ASSIGNMENT_ID	NUMBER	(15)
EVENT_ID	NUMBER	(15)
RATING_SCALE_ID	NUMBER	(9)
COMPETENCE_ID	NUMBER	(15)
ORGANIZATION_ID	NUMBER	(15)	Yes

Query Text

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


SELECT BUSINESS_GROUP_NAME
,      DEPARTMENT
,      APPRAISEE
,      APPRAISER
,      MAIN_APPRAISER
,      APPRAISAL_DATE
,      APPRAISAL_START_DATE
,      APPRAISAL_END_DATE
,      NEXT_APPRAISAL_DATE
,      APPRAISAL_COMMENTS
,      RATING_LEVEL_NAME
,      STEP_VALUE
,      APPRAISAL_TYPE_M
,      APPRAISAL_STATUS_M
,      APPRAISEE_ACCESS_M
,      APPRAISAL_TYPE
,      APPRAISAL_STATUS
,      APPRAISEE_ACCESS
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      _DF:APR
,      APPRAISAL_ID
,      BUSINESS_GROUP_ID
,      APPRAISAL_TEMPLATE_ID
,      APPRAISEE_PERSON_ID
,      APPRAISER_PERSON_ID
,      GROUP_INITIATOR_ID
,      OVERALL_PERFORMANCE_LEVEL_ID
,      MAIN_APPRAISER_ID
,      ASSIGNMENT_ID
,      EVENT_ID
,      RATING_SCALE_ID
,      COMPETENCE_ID
,      ORGANIZATION_ID
FROM APPS.HRFV_APPRAISAL_DETAILS;

Dependencies

[top of page]

APPS.HRFV_APPRAISAL_DETAILS references the following:

APPS: HR_ALL_ORGANIZATION_UNITS_TL; HR_BIS - show dependent code; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; PER_APPRAISALS; PER_PEOPLE_X; PER_RATING_LEVELS; PER_RATING_LEVELS_TL

APPS.HRFV_APPRAISAL_DETAILS is referenced by following:

PUBLIC: HRFV_APPRAISAL_DETAILS