[Home] [Help] [Dependency Information]
Object Name: | HRIBV_SUPV_HRCHY_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view allows Supervisor hierarchy Include Subordinate queries for all historic Supervisor Hierarchies
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPERVISOR_NAME | VARCHAR2 | (240) | Supervisor's Name | |
SUPERVISOR_LEVEL | NUMBER | (15) | Yes | Level of the Supervisor |
SUPERVISOR_EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee number of the supervisor | |
SUBORDINATE_NAME | VARCHAR2 | (240) | Reportee's name | |
SUBORDINATE_LEVEL | NUMBER | (15) | Yes | Level of the subordinate |
SUBORDINATE_EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee number of the subordinate | |
EFFECTIVE_START_DATE | DATE | Yes | Effective start date of the person | |
EFFECTIVE_END_DATE | DATE | Yes | Effective end date of the person | |
SUBORDINATE_RELATIVE_LEVEL | NUMBER | Yes | Relative level of the subordinate | |
SUPERVISOR_INVALID_FLAG_CODE | VARCHAR2 | (30) | Invalid Flag code of supervisor | |
SUBORDINATE_INVALID_FLAG_CODE | VARCHAR2 | (30) | Invalid code of the subordinate | |
SUPERVISOR_ID | NUMBER | (15) | Yes | Supervisors's person id |
SUPERVISOR_ASSIGNMENT_ID | NUMBER | (15) | Yes | Supervisors's assignment id |
SUBORDINATE_ID | NUMBER | (15) | Yes | Subordinate's person id |
SUBORDINATE_ASSIGNMENT_ID | NUMBER | (15) | Yes | Subordinate Assignment Id |
Cut, paste (and edit) the following text to query this object:
SELECT SUPERVISOR_NAME
, SUPERVISOR_LEVEL
, SUPERVISOR_EMPLOYEE_NUMBER
, SUBORDINATE_NAME
, SUBORDINATE_LEVEL
, SUBORDINATE_EMPLOYEE_NUMBER
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, SUBORDINATE_RELATIVE_LEVEL
, SUPERVISOR_INVALID_FLAG_CODE
, SUBORDINATE_INVALID_FLAG_CODE
, SUPERVISOR_ID
, SUPERVISOR_ASSIGNMENT_ID
, SUBORDINATE_ID
, SUBORDINATE_ASSIGNMENT_ID
FROM APPS.HRIBV_SUPV_HRCHY_V;
APPS.HRIBV_SUPV_HRCHY_V is not referenced by any database object
|
|
|