Auditing Data Changes

Many Oracle Health Insurance application entity objects use the following audit columns uniformly in the database:

Column Usage

Column	Usage
`CREATED_BY`	Reference to the user that creates the row.
`CREATION_DATE`	The date when the user creates the row.
`LAST_UPDATED_BY`	Reference to the user that last updated the row.
`LAST_UPDATED_DATE`	The date the users last updates the row.

CREATED_BY

Reference to the user that creates the row.

CREATION_DATE

The date when the user creates the row.

LAST_UPDATED_BY

Reference to the user that last updated the row.

LAST_UPDATED_DATE

The date the users last updates the row.

Dynamic fields are the exception to this rule. These are extensions to their base entities and do not have their audit columns. If a dynamic field changes, the LAST_UPDATED_BY and LAST_UPDATED_DATE audit columns of the base object also change.