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.