Auditing Data Changes

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

Table 1. Auditing Data Changes

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.

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.