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

Object Details

Object Name:	HR_SUMMARY
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.HR_SUMMARY
Subobject Name:
Status:	VALID

HR_SUMMARY holds all data for the Generic Summary Process. This table stores summarized statistical data that is used by specific Oracle Reports and Discoverer. It also holds the method by which the statistics were accumulated.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_SUMMARY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID_VALUE
HR_SUMMARY_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FK_VALUE1
HR_SUMMARY_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FK_VALUE2
HR_SUMMARY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TYPE BUSINESS_GROUP_ID TEXT_VALUE1

Columns

Name	Datatype	Length	Mandatory	Comments
ID_VALUE	NUMBER	(15)	Yes	System-generated primary key column.
TYPE	VARCHAR2	(30)		The name of the information type.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER	NUMBER	(9)		System-generated version of the row. Increments by one with each update.
FK_VALUE1	NUMBER	(15)		Foreign Key to id_value in HR_SUMMARY of different TYPE.
FK_VALUE2	NUMBER	(15)		Foreign Key to id_value in HR_SUMMARY of different TYPE.
FK_VALUE3	NUMBER	(15)		Foreign Key to id_value in HR_SUMMARY of different TYPE.
TEXT_VALUE1	VARCHAR2	(240)		Text column.
TEXT_VALUE2	VARCHAR2	(240)		Text column.
TEXT_VALUE3	VARCHAR2	(240)		Text column.
TEXT_VALUE4	VARCHAR2	(240)		Text column.
TEXT_VALUE5	VARCHAR2	(240)		Text column.
TEXT_VALUE6	VARCHAR2	(4000)		Text column.
TEXT_VALUE7	VARCHAR2	(240)		Text column.
NUM_VALUE1	NUMBER	(22)		Numeric column.
NUM_VALUE2	NUMBER	(22)		Numeric column.
NUM_VALUE3	NUMBER	(22)		Numeric column.
DATE_VALUE1	DATE			Date column.
DATE_VALUE2	DATE			Date column.
DATE_VALUE3	DATE			Date column.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.

Query Text

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


SELECT ID_VALUE
,      TYPE
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      FK_VALUE1
,      FK_VALUE2
,      FK_VALUE3
,      TEXT_VALUE1
,      TEXT_VALUE2
,      TEXT_VALUE3
,      TEXT_VALUE4
,      TEXT_VALUE5
,      TEXT_VALUE6
,      TEXT_VALUE7
,      NUM_VALUE1
,      NUM_VALUE2
,      NUM_VALUE3
,      DATE_VALUE1
,      DATE_VALUE2
,      DATE_VALUE3
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.HR_SUMMARY;

Dependencies

[top of page]

HR.HR_SUMMARY does not reference any database object

HR.HR_SUMMARY is referenced by following:

APPS: HR_SUMMARY; HR_SUMMARY_WHO
PUBLIC: HR_SUMMARY