Additional Auditing Columns for Claims
In Claims, the CLA_CLAIMS and OHI_AUTHORIZATIONS entity is equipped with additional auditing columns:
Column | Usage |
---|---|
OBJECT_LAST_UPDATED_BY |
Reference to the user who last updated the claim entity or updated an entity within context of the claim |
OBJECT_LAST_UPDATED_DATE |
Date of the last update to the claim entity or to an entity within context of the claim |
These keep track of changes to the claim or authorization entity itself or any of its details. This allows for easy change tracking of changes to a claim or authorization, without having to query all details of it.
Examples of details of a claim include CLA_CLAIM_MESSAGES, CLA_CLAIM_LINES and CLA_CLAIM_SUB_LINES.
If one of the detail entities of a claim is changed the OBJECT_LAST_UPDATED_BY and OBJECT_LAST_UPDATED_DATE of the claim reflect that change. If one of the details of a claim is changed but the claim entity itself is not, the LAST_UPDATED_BY and LAST_UPDATED_DATE of the claim are not updated.