Additional Auditing Columns for Claims

In Claims equips CLA_CLAIMS and OHI_AUTHORIZATIONS entities with additional auditing columns:

Table 1. Additional Auditing Columns for Claims
Column Usage

OBJECT_LAST_UPDATED_BY

Reference to the user who last updated the Claim entity or updated an entity within the context of the Claim.

OBJECT_LAST_UPDATED_DATE

Date of the last update to the Claim entity or to an entity within the context of the Claim.

These keep track of changes to the Claim or authorization entity itself or any of its details.
This allows for simple 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.

The OBJECT_LAST_UPDATED_BY and OBJECT_LAST_UPDATED_DATE of the Claim reflect that changes to any one of the detail entities of a Claim. The LAST_UPDATED_BY and LAST_UPDATED_DATE of the Claim do not update If change is in one of the detail of a Claim but not the Claim entity itself.