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_DM_DT_DELETES

Object Details

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

This table holds the information for the deletion of date tracked data. This table is also used to hold participant data information of data that has been downloaded but not been uploaded.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Primary Key: HR_DM_DT_DELETES_PK

DT_DELETE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_DM_DT_DELETES_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	DT_DELETE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DT_DELETE_ID	NUMBER	(15)	Yes	System-generated primary key column.
TABLE_NAME	VARCHAR2	(30)	Yes	The name of the table
DATA_TYPE	VARCHAR2	(1)	Yes	The type of date tracked date referred to, either D for Delete or P for Pre-existing data.
ID_VALUE	NUMBER	(15)		The value of the primary key of the table. For a composite primary key, this value is that of the primary key column(s) not including EFFECTIVE_START_DATE and EFFECTIVE_END_DATE.
PK_COLUMN_1	VARCHAR2	(1000)		The non-surrogate primary key can consist of several columns, each of which may be non-numeric.
PK_COLUMN_2	VARCHAR2	(1000)		The non-surrogate primary key can consist of several columns, each of which may be non-numeric.
PK_COLUMN_3	VARCHAR2	(1000)		The non-surrogate primary key can consist of several columns, each of which may be non-numeric.
PK_COLUMN_4	VARCHAR2	(1000)		The non-surrogate primary key can consist of several columns, each of which may be non-numeric.
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.
SECURITY_GROUP_ID	NUMBER	(15)		Foreign Key to FND_SECURITY_GROUPS.

Query Text

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


SELECT DT_DELETE_ID
,      TABLE_NAME
,      DATA_TYPE
,      ID_VALUE
,      PK_COLUMN_1
,      PK_COLUMN_2
,      PK_COLUMN_3
,      PK_COLUMN_4
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SECURITY_GROUP_ID
FROM HR.HR_DM_DT_DELETES;

Dependencies

[top of page]

HR.HR_DM_DT_DELETES does not reference any database object

HR.HR_DM_DT_DELETES is referenced by following:

APPS: HR_DM_DT_DELETES; HR_DM_DT_DELETES_WHO
PUBLIC: HR_DM_DT_DELETES