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:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_BIS - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_PERSON_NAME - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
SynonymPER_APPRAISALS
ViewPER_PEOPLE_X
SynonymPER_RATING_LEVELS
SynonymPER_RATING_LEVELS_TL

APPS.HRFV_APPRAISAL_DETAILS is not referenced by any database object