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_AUDITS

Object Details

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

HR_AUDITS holds records of the transactions that are carried out on an
audited DateTracked table. The rows of this table are created by
running the package PY_AUDIT_REP_PKG which inserts into the HR_AUDITS
table and HR_AUDIT_COLUMNS table from the DateTracked tables shadow
table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	20
PCT Used:

Primary Key: HR_AUDITS_PK

AUDIT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
HR_AUDITS_PK	NORMAL	UNIQUE	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	Primary key from sequence HR_AUDITS_S.
COMMIT_ID	NUMBER	(9)	Yes	Commit reference for the audited transaction.
CURRENT_SESSION_ID	NUMBER		Yes	Current session id of the audit process.
PRIMARY_KEY	VARCHAR2	(30)	Yes	Primary key column name of the audited table.
PRIMARY_KEY_VALUE	NUMBER	(15)	Yes	ID of the primary key for the audited table.
SEQUENCE_ID	NUMBER	(9)	Yes	Sequence of the transaction within a commit unit.
SESSION_ID	NUMBER		Yes	ORACLE session ID of the audited process.
TABLE_NAME	VARCHAR2	(30)	Yes	Name of audited table.
TIMESTAMP	DATE		Yes	Date and time the audited transaction took place.
TRANSACTION	VARCHAR2	(30)	Yes	Description of the audited transaction.
TRANSACTION_TYPE	VARCHAR2	(30)	Yes	Type of audit transaction, (I)nsert, (U)pdate or (D)elete.
USER_NAME	VARCHAR2	(100)	Yes	Name of user performing the transaction.
EFFECTIVE_END_DATE	DATE			Effective end date value of the audited transaction.
EFFECTIVE_START_DATE	DATE			Effective start date value of the audited transaction.

Query Text

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


SELECT AUDIT_ID
,      COMMIT_ID
,      CURRENT_SESSION_ID
,      PRIMARY_KEY
,      PRIMARY_KEY_VALUE
,      SEQUENCE_ID
,      SESSION_ID
,      TABLE_NAME
,      TIMESTAMP
,      TRANSACTION
,      TRANSACTION_TYPE
,      USER_NAME
,      EFFECTIVE_END_DATE
,      EFFECTIVE_START_DATE
FROM HR.HR_AUDITS;

Dependencies

[top of page]

HR.HR_AUDITS does not reference any database object

HR.HR_AUDITS is referenced by following:

HR: HR_AUDITS#