[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;
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_ALL_ASSIGNMENTS_F
PER_ALL_PEOPLE_F
PER_BOOKINGS
PER_EVENTS
PER_PEOPLE_X
APPS.HRFV_REVIEWERS is not referenced by any database object
|
|
|
|