HM_TOPIC_METADATA

Description:

This table contains rows of Health Maintenance topics with metadata values that are calculated for a patient.

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	TOPIC_ID	NUMERIC	No
	This column stores Health Maintenance topics that have calculated data that should persist even when the topic no longer applies to the patient.
4	TOPIC_ID_NAME	VARCHAR	No
	The name of the health maintenance topic.
5	EXT_DATA_CHECKSUM	INTEGER	No
	This column indicates whether external data was used to complete the related Health Maintenance topic.
6	EXT_CLIN_DATA_DATE	DATETIME	No
	If external clinical data (e.g. Care Everywhere or immunization registries) was used to complete the related Health Maintenance topic, this item will contain the date of the relevant completion.
7	EXT_CLAIM_DATE	DATETIME	No
	If external claims data was used to complete the related Health Maintenance topic, this item will contain the date of the relevant completion.
8	PT_REPORTED_DATE	DATETIME	No
	If a patient reported action was used to complete the related Health Maintenance topic, this item will contain the date of the relevant completion.
9	EXT_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.