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 date when the patient's qualified Health Maintenance topic due status was last updated.
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 Mixed Product 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 2-dose series COVID-19 Start At 5 Years+