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_AUDIT_COLUMNS

Object Details

Object Name:	HR_AUDIT_COLUMNS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.HR_AUDIT_COLUMNS
Subobject Name:
Status:	VALID

HR_AUDITS_COLUMNS holds details of the transactions that apply to
specific columns in audited tables that are DateTracked. It is
populated by running the PY_AUDIT_REP_PKG package which inserts rows
into HR_AUDITS and HR_AUDIT_COLUMNS from the standard shadow tables
for DateTracked entities.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_AUDIT_COLUMNS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AUDIT_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
HR_AUDIT_COLUMNS		HR_AUDITS	HR_AUDIT_COLUMNS AUDIT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AUDIT_ID	NUMBER	(15)	Yes	Foreign key to HR_AUDITS.
COLUMN_ID	NUMBER	(9)	Yes	Foreign key to FND_COLUMNS.
COLUMN_NAME	VARCHAR2	(30)	Yes	Name of the audited column subject to a change.
NEW_VALUE	VARCHAR2	(240)		New value of the column after the change.
OLD_VALUE	VARCHAR2	(240)		Old value of the column before the change.

Query Text

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


SELECT AUDIT_ID
,      COLUMN_ID
,      COLUMN_NAME
,      NEW_VALUE
,      OLD_VALUE
FROM HR.HR_AUDIT_COLUMNS;

Dependencies

[top of page]

HR.HR_AUDIT_COLUMNS does not reference any database object

HR.HR_AUDIT_COLUMNS is referenced by following:

APPS: HR_AUDIT_COLUMNS
PUBLIC: HR_AUDIT_COLUMNS