PATIENT_HMT_STATUS

Description: |
This table contains information on the due status of health maintenance topics.

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 Count
3 | HMT_PPN_UNTL_DT | DATETIME | No |
The date until which a Health Maintenance topic is postponed.
4 | HMT_PPN_RSN_C_NAME | VARCHAR | No |
The postpone reason category number for a Health Maintenance topic which was postponed.
May contain organization-specific values: Yes
5 | HMT_LAST_UPDATE_DT | DATETIME | No |
The last completion date for the patient's Health Maintenance topic.
6 | HM_ORDER_STATUS_YN | VARCHAR | No |
This item indicates if the Health Maintenance (HM) topic has been addressed by signing an order. If an appropriate active order was found during the HM update, this will be set to yes.
May contain organization-specific values: No
Category Entries:
No
Yes
7 | ACTIVE_SUBTOPIC_ID | NUMERIC | No |
Stores the active subtopic for a combination topic
8 | ACTIVE_SUBTOPIC_ID_NAME | VARCHAR | No |
The name of the health maintenance topic.
9 | ACTIVE_HM_PLAN_ID | NUMERIC | No |
Stores the Health Maintenance plan that is currently active for the topic
10 | ACTIVE_HM_PLAN_ID_HM_PLAN_NAME | VARCHAR | No |
The name of the Health Maintenance Plan record.
11 | HM_TENTATIVE_YN | VARCHAR | No |
Boolean value indicating whether the Health Maintenance topic's next follow-up is tentative and requiring review.
The category values for this column were already listed for column: HM_ORDER_STATUS_YN
12 | HM_ACTIVE_SERIES_C_NAME | VARCHAR | No |
Stores the active immunization series the patient is currently on.
May contain organization-specific values: Yes
Category Entries:
COVID-19 Pfizer 2-dose series
COVID-19 Moderna 2-dose series
COVID-19 Janssen series with boosters
COVID-19 AstraZeneca 2-dose series
COVID-19 Novavax series
COVID-19 Sinopharm 2-dose series
COVID-19 Sinovac 2-dose series
COVID-19 Inadvertent 2-dose series
COVID-19 Unsupported vaccine series
COVID-19 Risk IC Pfizer series
COVID-19 Risk IC Moderna series
COVID-19 Risk IC Janssen series
COVID-19 Risk IC Mixed Product series
COVID-19 Pfizer series
COVID-19 Start at 6-23 months series
COVID-19 Moderna series
COVID-19 Risk IC WHO-authorized series
COVID-19 COVAXIN 2-dose series
COVID-19 WHO-authorized series with boosters
Pneumococcal PCV-first series
Pneumococcal PCV-second series
Pneumococcal PCV-third series
Pneumococcal PPSV-only series
COVID-19 Risk Janssen series with intermediate booster
Hepatitis B 3-dose series
Hepatitis B 4-dose series
Hepatitis B adolescent 2-dose series
Hepatitis B CpG 2-dose series
Hepatitis B HepB-CpG 4-dose series
Hepatitis B CpG-HepB 4-dose series
Hepatitis B Twinrix 3-dose series
Hepatitis B Twinrix 4-dose series
Hepatitis B risk 3-dose series
Hepatitis B risk dialysis Recombivax 3-dose series
Hepatitis B risk dialysis 4-dose series
COVID-19 Risk IC Novavax series
Orthopoxvirus risk more virulent 2-dose series
Orthopoxvirus risk less virulent 2-dose series
Orthopoxvirus risk post-exposure 2-dose series
COVID-19 Start at 2 years+ series
Orthopoxvirus risk pre-exposure 2-dose series