AP_CLM_RX_PROGRAM_INFO

Description: |
This table contains information about the program that a pharmacy claim is associated with.

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 | PROGRAM_ID | NUMERIC | No |
This item contains the external ID of a Value Based Program record or records representing the programs that the claim is associated with.
4 | PROGRAM_ID_RECORD_NAME | VARCHAR | No |
The name of the program record.
5 | CLAIM_PROG_LINK_STATUS_C_NAME | VARCHAR | No |
Indicates the current status of the Value Based Program, whether it is active, inactive, or planned to be removed (loaded in error).
May contain organization-specific values: No
Category Entries:
Active
Inactive
Removed
6 | PROGRAM_MOD_DTTM | DATETIME (Local) | No |
The local instant when the claim was last modified for the Value Based Plan.
7 | PROGRAM_MOD_UTC_DTTM | DATETIME (UTC) | No |
The UTC instant when the claim was last modified for the Value Based Plan.