CRF_AUDIT_HISTORY
Description:
Audit History Data Model for Claim Reference Data records.

Primary Key
Column Name Ordinal Position
REF_DATA_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 REF_DATA_ID NUMERIC No
The unique identifier for the Claim Reference Data record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 CHANGE_UTC_DTTM DATETIME (UTC) No
The instant of the audit history event.
4 CHANGE_USER_ID VARCHAR No
The ID of the user responsible for the record event logged in the Audit History.
5 CHANGE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
6 CHANGE_ACTION_C_NAME VARCHAR No
The action type of the event in the record Audit History.
May contain organization-specific values: No
Category Entries:
Create Record
Edit Item
Void Primary Record
Soft-Delete Record
Cancel Record
Submit Release of Information
Update Claim Status Subscription
Set Items to Support 275 Claim Status Request
Set Items to Support 276 Claim Status Request
7 CHANGE_ITEM INTEGER No
The item changed in the event of the record Audit History.
8 PREVIOUS_RAW_VALUE VARCHAR No
The previous raw value of the edited item in the record.
9 NEW_RAW_VALUE VARCHAR No
The new raw value of the edited item in the record.
10 PREVIOUS_VENDOR_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
11 NEW_VENDOR_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
12 PREVIOUS_CLAIM_ID NUMERIC No
The claim which was previously associated with the CRF record before the audit history event.
13 NEW_CLAIM_ID NUMERIC No
The claim which is newly associated with the CRF record after the audit history event.
14 NEW_ROI_ID VARCHAR No
The release record which was created using the CRF record during the audit history event.
15 NEW_IS_CANCELLED_BY_PROV_C_NAME VARCHAR No
The new is cancelled flag which was updated during the audit history event.
May contain organization-specific values: No
Category Entries:
Yes