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_CS_PRSN_TYP_CTGRY_CT

Object Details

Object Name:	HRI_CS_PRSN_TYP_CTGRY_CT
Object Type:	TABLE
Owner:	HRI
Subobject Name:
Status:	VALID

Collected Table for the person type classification, the table is populated by the concurrent process 'HRI Load All Person Type Classification'.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HRI_CS_PRSN_TYP_CTGRY_CT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_TYPE_ID

Columns

Name	Datatype	Length	Comments
PERSON_TYPE_ID	NUMBER		PERSON_TYPE_ID
PRSN_TYP_CTGRY_CD	VARCHAR2	(30)	PRSN_TYP_CTGRY_CD
USED_FOR_SUMMARIZATION	VARCHAR2	(30)	USED_FOR_SUMMARIZATION
LAST_UPDATE_DATE	DATE		LAST_UPDATE_DATE
LAST_UPDATED_BY	NUMBER		LAST_UPDATED_BY
LAST_UPDATE_LOGIN	NUMBER		LAST_UPDATE_LOGIN
CREATED_BY	NUMBER		CREATED_BY
CREATION_DATE	DATE		CREATION_DATE

Query Text

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


SELECT PERSON_TYPE_ID
,      PRSN_TYP_CTGRY_CD
,      USED_FOR_SUMMARIZATION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HRI.HRI_CS_PRSN_TYP_CTGRY_CT;

Dependencies

[top of page]

HRI.HRI_CS_PRSN_TYP_CTGRY_CT does not reference any database object

HRI.HRI_CS_PRSN_TYP_CTGRY_CT is referenced by following:

HRI: HRI_CS_PRSN_TYP_CTGRY_CT#