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.