AP_CLAIM_PROGRAM_HISTORY
Description:
This table tracks the history of changes to the Value Based Programs associated with medical claims.

Primary Key
Column Name Ordinal Position
CLAIM_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 CLAIM_ID NUMERIC No
The unique identifier for the claim info 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 UPDATE_PROGRAM_ID NUMERIC No
The Value Based Program that was modified.
4 UPDATE_PROGRAM_ID_RECORD_NAME VARCHAR No
The name of the program record.
5 UPDATE_INSTANT_DTTM DATETIME (Local) No
The local instant when the Value Based Program was modified.
6 CLAIM_PROG_HX_ACTION_C_NAME VARCHAR No
The action that modified the Value Based Program.
May contain organization-specific values: No
Category Entries:
Added
Updated
Deactivated
Removed
Sent
7 UPDATE_INSTANT_UTC_DTTM DATETIME (UTC) No
The Coordinated Universal Time (UTC) instant when the Value Based Program was modified.
8 VBP_HX_SENT_DXO_ID NUMERIC No
The DXO ID to which this claim was sent.
9 VBP_HX_SENT_DXO_ID_EXTERNAL_NAME VARCHAR No
Organization's external name used as the display name on forms and user interfaces.