HM_TOPIC_EDITS
Description:
The HM_TOPIC_EDITS table includes all Health Maintenance topics that have overridden information specific to this patient. For example, a user may specify a frequency to use for a given patient instead of the defaults coming from the Health Maintenance topic or Health Maintenance plan records.

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_EDIT_TOPIC_ID NUMERIC No
This item contains all of the Health Maintenance Topics that this patient has edits for. Any edits to a topic for a patient will supersede the automatic defaults from the HMT or HMP record.
4 HM_EDIT_TOPIC_ID_NAME VARCHAR No
The name of the health maintenance topic.
5 HM_EDIT_FREQ VARCHAR No
This item contains the edited frequency for a given Health Maintenance topic for this patient. Any edits to a topic for a patient will supersede the automatic defaults from the HMT or HMP record.
6 HM_EDIT_RSN_C_NAME VARCHAR No
This item contains the reasons for each edited frequency of an HM Topic for this patient.
May contain organization-specific values: Yes
7 HM_EDIT_CMT VARCHAR No
This item contains comments for each edited frequency of an HM Topic for this patient.
8 HM_EDIT_RECOM_ID NUMERIC No
This item contains the Recommendation record ID that is driving the associated Health Maintenance Topic patient specific frequency.
9 HM_EDIT_DUE_DATE DATETIME No
This item contains the specified due date of the associated Health Maintenance Topic. This due date will supersede any due date calculated from the patient specific frequency.
10 HM_EDIT_MSG_ID VARCHAR No
This item contains the In Basket message record ID that is driving the associated Health Maintenance topic patient specific frequency.