Additional Auditing Columns for Claims
In Claims equips CLA_CLAIMS
and OHI_AUTHORIZATIONS
entities 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 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.