[Home] [Help] [Dependency Information]
Object Name: | HRI_SUPV_HRCHY_SUMMARY |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.HRI_SUPV_HRCHY_SUMMARY |
Subobject Name: | |
Status: | VALID |
Collected Table for the Supervisor Hierarchy, the table is populated by the concurrent process 'HRI Load Supervisor Hierarchy History'.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_SUPV_HRCHY_SUMMARY_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
SUPV_BUSINESS_GROUP_ID
SUPV_PERSON_ID SUPV_ASSIGNMENT_ID SUB_PERSON_ID SUB_ASSIGNMENT_ID |
HRI_SUPV_HRCHY_SUMMARY_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SUPV_ASSIGNMENT_ID |
HRI_SUPV_HRCHY_SUMMARY_N3 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SUPV_PERSON_ID |
HRI_SUPV_HRCHY_SUMMARY_N4 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SUPV_LEVEL |
HRI_SUPV_HRCHY_SUMMARY_N5 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SUB_BUSINESS_GROUP_ID |
HRI_SUPV_HRCHY_SUMMARY_N6 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SUB_PERSON_ID |
HRI_SUPV_HRCHY_SUMMARY_N7 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SUB_ASSIGNMENT_ID |
HRI_SUPV_HRCHY_SUMMARY_N8 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY | SUB_LEVEL |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPV_BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group ID of the Supervisor |
SUPV_PERSON_ID | NUMBER | (15) | Yes | Person ID of the Supervisor |
SUPV_ASSIGNMENT_ID | NUMBER | (15) | Yes | Assignment ID of the Supervisor |
SUPV_LEVEL | NUMBER | (15) | Yes | Level of the Supervisor in the Supervisor Hierarchy |
SUB_BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group ID of the Supervised Person Assignment |
SUB_PERSON_ID | NUMBER | (15) | Yes | Person ID of the Supervised Person Assignment |
SUB_ASSIGNMENT_ID | NUMBER | (15) | Yes | Assignment ID of the Supervised Person Assignment |
SUB_PRIMARY_ASG_FLAG | VARCHAR2 | (1) | Yes | Primary Assignment Flag of the Supervised Person Assignment |
SUB_LEVEL | NUMBER | (15) | Yes | Level of the Subordinate in the Supervisor Hierarchy |
CREATION_DATE | DATE | Yes | Standard WHO Column | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
SUPV_LAST_PTNTL_CHANGE | DATE | Supv Last Ptntl Change | ||
SUB_LAST_PTNTL_CHANGE | DATE | Last Ptntl Change Date |
Cut, paste (and edit) the following text to query this object:
SELECT SUPV_BUSINESS_GROUP_ID
, SUPV_PERSON_ID
, SUPV_ASSIGNMENT_ID
, SUPV_LEVEL
, SUB_BUSINESS_GROUP_ID
, SUB_PERSON_ID
, SUB_ASSIGNMENT_ID
, SUB_PRIMARY_ASG_FLAG
, SUB_LEVEL
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, SUPV_LAST_PTNTL_CHANGE
, SUB_LAST_PTNTL_CHANGE
FROM HRI.HRI_SUPV_HRCHY_SUMMARY;
HRI.HRI_SUPV_HRCHY_SUMMARY does not reference any database object
HRI.HRI_SUPV_HRCHY_SUMMARY is referenced by following:
|
|
|