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: HR.PER_ORG_HRCHY_SUMMARY

Object Details

Object Name:	PER_ORG_HRCHY_SUMMARY
Object Type:	TABLE
Owner:	HR
Subobject Name:
Status:	VALID

Collect table for the Organization Hierarchy, the table is populated by the concurrent process, PER LOAD ALL GENERIC HIERARCHY VERSIONS.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_ORG_HRCHY_SUMMARY_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_STRUCTURE_ID ORGANIZATION_ID SUB_ORG_RELATIVE_LEVEL
PER_ORG_HRCHY_SUMMARY_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORG_STRUCTURE_VERSION_ID SUB_ORGANIZATION_ID
PER_ORG_HRCHY_SUMMARY_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORG_STRUCTURE_VERSION_ID ORGANIZATION_LEVEL
PER_ORG_HRCHY_SUMMARY_U1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORG_STRUCTURE_VERSION_ID ORGANIZATION_ID SUB_ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORGANIZATION_STRUCTURE_ID	NUMBER		Yes	Organization Structure Id
ORG_BUSINESS_GROUP_ID	NUMBER	(15)		Org Business Group Id
ORG_STRUCTURE_VERSION_ID	NUMBER	(15)	Yes	Org Structure Version Id
ORGANIZATION_ID	NUMBER	(15)	Yes	Organization Id
ORGANIZATION_LEVEL	NUMBER	(15)	Yes	Organization Level
SUB_ORG_BUSINESS_GROUP_ID	NUMBER	(15)		Sub Org Business Group Id
SUB_ORGANIZATION_ID	NUMBER	(15)	Yes	Sub Org Business Group Id
SUB_ORGANIZATION_LEVEL	NUMBER	(15)	Yes	Sub Organization Level
SUB_ORG_RELATIVE_LEVEL	NUMBER		Yes	Sub Org Relative Level
LAST_PTNTL_CHANGE	DATE			Standard WHO Column
CREATED_BY	NUMBER	(15)		Standard WHO Column
CREATION_DATE	DATE			Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)		Standard WHO Column
LAST_UPDATE_DATE	DATE			Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORGANIZATION_STRUCTURE_ID
,      ORG_BUSINESS_GROUP_ID
,      ORG_STRUCTURE_VERSION_ID
,      ORGANIZATION_ID
,      ORGANIZATION_LEVEL
,      SUB_ORG_BUSINESS_GROUP_ID
,      SUB_ORGANIZATION_ID
,      SUB_ORGANIZATION_LEVEL
,      SUB_ORG_RELATIVE_LEVEL
,      LAST_PTNTL_CHANGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM HR.PER_ORG_HRCHY_SUMMARY;

Dependencies

[top of page]

HR.PER_ORG_HRCHY_SUMMARY does not reference any database object

HR.PER_ORG_HRCHY_SUMMARY is referenced by following:

APPS: PER_ORG_HRCHY_SUMMARY; PER_ORG_HRCHY_SUMMARY_WHO
PUBLIC: PER_ORG_HRCHY_SUMMARY