Auditing Data Changes
Many Oracle Health Insurance application entity objects use the following audit columns uniformly in the database:
Column | Usage |
---|---|
|
Reference to the user that creates the row. |
|
The date when the user creates the row. |
|
Reference to the user that last updated the row. |
|
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.