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.