PAT_HM_CUR_GUIDE
Description:
Health Maintenance Plans used during patient's last health maintenance update.

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_CURRENT_GUIDE_ID NUMERIC No
Current Health Maintenance Plans the patient is a part of.
4 HM_CURRENT_GUIDE_ID_HM_PLAN_NAME VARCHAR No
The name of the Health Maintenance Plan record.