eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HRI.HRI_SUPV_HRCHY_SUMMARY

Object Details

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'.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

HRI.HRI_SUPV_HRCHY_SUMMARY does not reference any database object

HRI.HRI_SUPV_HRCHY_SUMMARY is referenced by following:

APPS: HRI_SUPV_HRCHY_SUMMARY; HRI_SUPV_HRCHY_SUMMARY_WHO