[Home] [Help] [Dependency Information]

VIEW: APPS.HRFV_REVIEWS

Object Details

Object Name:	HRFV_REVIEWS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.HRFV_REVIEWS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

This view shows employee performance reviews for both current and ex-employee. A Review is considered to be any employee interview, e.g. performance reviews, disciplinary hearings.

[View Source]

Columns

Query Text

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

SELECT BUSINESS_GROUP_NAME
,      PERSON_NAME
,      EMPLOYEE_NUMBER
,      ASSIGNMENT_NUMBER
,      REVIEW_TYPE
,      REVIEW_DATE
,      PERFORMANCE_REVIEW_DATE
,      PERFORMANCE_RATING
,      NEXT_PERFORMANCE_REVIEW_DATE
,      CURRENT_EMPLOYEE_FLAG
,      REVIEW_LOCATION
,      _DF
,      ASSIGNMENT_ID
,      BUSINESS_GROUP_ID
,      EMPLOYEE_REVIEW_ID
,      LOCATION_ID
,      PERFORMANCE_REVIEW_ID
,      PERSON_ID
FROM APPS.HRFV_REVIEWS;

Dependencies

[top of page]

APPS

HR_ALL_ORGANIZATION_UNITS_TL

HR_BIS - show dependent code

HR_GENERAL - show dependent code

HR_LOCATIONS_ALL_TL

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

PER_ALL_ASSIGNMENTS_F

PER_EVENTS

PER_PEOPLE_X

PER_PERFORMANCE_REVIEWS

PUBLIC

HRFV_REVIEWS