[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) | Person Name of the Supervisor | |
SUPERVISOR_LEVEL | NUMBER | (15) | Yes | Level of the Supervisor in the Supervisor Hierarchy |
SUPERVISOR_EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee number of the Supervisor | |
SUBORDINATE_NAME | VARCHAR2 | (240) | Name of the subordinate | |
SUBORDINATE_LEVEL | NUMBER | (15) | Yes | Level of the Supervised Person Assignment in the Supervisor Hierarchy |
SUBORDINATE_EMPLOYEE_NUMBER | VARCHAR2 | (30) | Employee number of subordinate | |
EFFECTIVE_START_DATE | DATE | Yes | Effective Start Date | |
EFFECTIVE_END_DATE | DATE | Yes | Effective End Date | |
SUBORDINATE_RELATIVE_LEVEL | NUMBER | Yes | Subordinate Relative Level | |
SUPERVISOR_INVALID_FLAG_CODE | VARCHAR2 | (30) | Supervisor Invalid Flag Code | |
SUBORDINATE_INVALID_FLAG_CODE | VARCHAR2 | (30) | Subordinate Invalid Flag | |
SUPERVISOR_ID | NUMBER | (15) | Yes | Supervisor Person Id |
SUPERVISOR_ASSIGNMENT_ID | NUMBER | (15) | Yes | Assignment Identifier of the Supervisor Person Assignment |
SUBORDINATE_ID | NUMBER | (15) | Yes | Person Identifier of the Supervised Person Assignment |
SUBORDINATE_ASSIGNMENT_ID | NUMBER | (15) | Yes | Assignment Identifier of the Supervised Person Assignment |
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;
|
|
|