HM_HISTORICAL_STATUS
Description:
Records Health Maintenance status over time.

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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 HM_TOPIC_ID NUMERIC No
The Health Maintenance topic that applied to the patient at the time the snapshot was taken.
4 HM_TOPIC_ID_NAME VARCHAR No
The name of the health maintenance topic.
5 HM_STATUS_C_NAME VARCHAR No
Indicates the patient's due status for the Health Maintenance topic at the time the snapshot was taken.
May contain organization-specific values: No
Category Entries:
Not Due
Due Soon
Due On
Overdue
Postponed
Completed
Addressed
Aged Out
Discontinued
Hidden
6 NEXT_DUE_DATE DATETIME No
The patient's next due date for this Health Maintenance topic at the time the snapshot was taken.
7 LAST_COMPLETED_DATE DATETIME No
The date this patient last had a completion for the Health Maintenance topic, as of the time the snapshot was taken.
8 HAS_OUTSIDE_COMPLETION_YN VARCHAR No
Indicates whether external data was used to complete the related Health Maintenance topic at the time the snapshot was recorded.
May contain organization-specific values: No
Category Entries:
No
Yes
9 EXTERNAL_CLINICAL_DATE DATETIME No
If the related HM topic is currently satisfied by external clinical data (e.g. Care Everywhere or immunization registries), this item will contain the date of the relevant completion.
10 EXTERNAL_CLAIM_DATE DATETIME No
If the related HM topic is currently satisfied by external claims data, this item will contain the date of the relevant completion.
11 PAT_REPORTED_DATE DATETIME No
If the related HM topic is currently satisfied by patient-reported data, this item will contain the date of the relevant patient-reported satisfaction.
12 EXTERNAL_HEALTH_PLAN_DATE DATETIME No
If the related HM topic is currently satisfied by external health plan data, this item will contain the date of the relevant completion.