MDL_HISTORY

Description: |
The MDL_HISTORY table enables you to report on Medication Problem List history information over time.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
MED_PRBLM_LIST_ID | 1 |
CONTACT_DATE_REAL | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | MED_PRBLM_LIST_ID | NUMERIC | No |
The unique identifier for the med problem list record.
2 | CONTACT_DATE_REAL | FLOAT | No |
This is a numeric representation of the date of this contact in your system. The integer portion of the number specifies the date of the contact. The digits after the decimal point indicate multiple contacts on one day.
3 | CONTACT_DATE | DATETIME | No |
The date of this contact in calendar format.
4 | LNG_TRM_OVERTIME_YN | VARCHAR | No |
The changes to the long-term indicator over time.
May contain organization-specific values: No
Category Entries:
Yes
No