Auditing Data Changes

The following audit columns are used in a uniform fashion for many Oracle Health Insurance Component’s entity objects in the database:

Column	Usage
CREATED_BY	Reference to the user that created the row
CREATION_DATE	Date the row was created
LAST_UPDATED_BY	Reference to the user that last updated the row
LAST_UPDATED_DATE	Date the row was last updated

table class = content

Dynamic Fields are the exception to this rule: these are considered to be extensions to their base entities and do not have their own audit columns. If a Dynamic Field is changed, the LAST_UPDATED_BY and LAST_UPDATED_DATE audit columns of the base object are changed.