[Home] [Help] [Dependency Information]
Object Name: | HRFV_REVIEWERS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | PER.HRFV_REVIEWERS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows employees who have acted as reviewers in employee reviews, or
are scheduled to act as reviewers in the future.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
REVIEWEE_NAME | VARCHAR2 | (240) | ||
REVIEWEE_EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
REVIEWEE_ASSIGNMENT_NUMBER | VARCHAR2 | (30) | ||
REVIEW_TYPE | VARCHAR2 | (4000) | ||
PLANNED_REVIEW_DATE | DATE | Yes | ||
REVIEWEE_CURRENT_EMPLOYEE_FLAG | VARCHAR2 | (4000) | ||
REVIEWER_NAME | VARCHAR2 | (240) | ||
REVIEWER_EMPLOYEE_NUMBER | VARCHAR2 | (30) | ||
_DF | CHAR | (24) | ||
BUSINESS_GROUP_ID | NUMBER | (15) | ||
EMPLOYEE_REVIEW_ID | NUMBER | (15) | Yes | |
EMPLOYEE_REVIEWER_ID | NUMBER | (15) | Yes | |
REVIEWEE_ASSIGNMENT_ID | NUMBER | (10) | ||
REVIEWEE_PERSON_ID | NUMBER | (10) | Yes | |
REVIEWER_PERSON_ID | NUMBER | (10) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, REVIEWEE_NAME
, REVIEWEE_EMPLOYEE_NUMBER
, REVIEWEE_ASSIGNMENT_NUMBER
, REVIEW_TYPE
, PLANNED_REVIEW_DATE
, REVIEWEE_CURRENT_EMPLOYEE_FLAG
, REVIEWER_NAME
, REVIEWER_EMPLOYEE_NUMBER
, _DF
, BUSINESS_GROUP_ID
, EMPLOYEE_REVIEW_ID
, EMPLOYEE_REVIEWER_ID
, REVIEWEE_ASSIGNMENT_ID
, REVIEWEE_PERSON_ID
, REVIEWER_PERSON_ID
FROM APPS.HRFV_REVIEWERS;
|
|
|