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

Object Details

Object Name:	GHR_BREAKDOWN_RESULTS
Object Type:	TABLE
Owner:	HR
FND Design Data:	GHR.GHR_BREAKDOWN_RESULTS
Subobject Name:
Status:	VALID

GHR_BREAKDOWN_RESULTS is a temporary table used to produce the
breakdown report. It groups the people by sex and ethnic origin and
for the given criteria counts how many in each category and then gives
totals and percentages. It can be broken 'by' something and then
further 'within' something and the 'for' something.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Primary Key: GHR_BREAKDOWN_RESULTS_PK

SESSION_ID
BREAKDOWN_RESULT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
GHR_BREAKDOWN_RESULTS_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	SESSION_ID BREAKDOWN_RESULT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
GHR_BREAKDOWN_RESULTS		GHR_BREAKDOWN_CRITERIA	GHR_BREAKDOWN_RESULTS BREAKDOWN_CRITERIA_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER	(9)	Yes	Oracle generated unique Id for each session.
BREAKDOWN_RESULT_ID	NUMBER	(15)	Yes	System-generated primary key from GHR_BREAKDOWN_RESULTS
BREAKDOWN_CRITERIA_ID	NUMBER	(15)		Foreign key to GHR_BREAKDOWN_CRITERIA.
SEX	VARCHAR2	(30)	Yes	Sex
ETHNIC_ORIGIN	VARCHAR2	(30)	Yes	Ethnic origin.
FOR_CLAUSE	VARCHAR2	(150)		For clause.
WITHIN_CLAUSE	VARCHAR2	(150)		Within clause.
BY_CLAUSE	VARCHAR2	(150)		By clause.
LAST_UPDATE_DATE	DATE		Yes	Standard who column.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column.
LAST_UPDATE_LOGIN	NUMBER			Standard who column.
CREATED_BY	NUMBER		Yes	Standard who column.
CREATION_DATE	DATE		Yes	Standard who column.

Query Text

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


SELECT SESSION_ID
,      BREAKDOWN_RESULT_ID
,      BREAKDOWN_CRITERIA_ID
,      SEX
,      ETHNIC_ORIGIN
,      FOR_CLAUSE
,      WITHIN_CLAUSE
,      BY_CLAUSE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.GHR_BREAKDOWN_RESULTS;

Dependencies

[top of page]

HR.GHR_BREAKDOWN_RESULTS does not reference any database object

HR.GHR_BREAKDOWN_RESULTS is referenced by following:

APPS: GHR_BREAKDOWN_RESULTS; GHR_BREAKDOWN_RESULTS_WHO
PUBLIC: GHR_BREAKDOWN_RESULTS