Additional Auditing Columns for Claims

In OHI Claims Adjudication and Pricing, 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/authorization entity itself or any of its details. This allows for easy change tracking of changes to a claim/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.