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: TablePAY.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 20
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HR_AUDIT_COLUMNS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnAUDIT_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
HR_AUDIT_COLUMNS HR_AUDIT_COLUMNS_FK1 TableHR_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:

SchemaHR
ViewHR_AUDIT_COLUMNS#