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.