FIN_ASST_TRKR_MED_UPD_HX

Description: |
This table contains a history of the edits made to the list of medications attached to a medication assistance program tracker.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
FIN_ASST_TRACKER_ID | 1 |
GROUP_LINE | 2 |
VALUE_LINE | 3 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | FIN_ASST_TRACKER_ID | NUMERIC | No |
The unique identifier for the program tracker record.
2 | GROUP_LINE | INTEGER | No |
The line number of the associated update for the tracker. Along with FIN_ASST_TRACKER_ID, this forms the foreign key link to the FIN_ASST_TRKR_UPDATE_HX table.
3 | VALUE_LINE | INTEGER | No |
The line number of one of the multiple medication lines associated with the tracker and update from the FIN_ASST_TRKR_UPDATE_HX table.
4 | MEDICATION_ID_MEDICATION_NAME | VARCHAR | No |
The name of this medication record.