Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (6) | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the HMP table |
(2)![Foreign Keys FK_HMP_ITEM_HMP: [dbo].[Item_HMP].ItemID Foreign Keys FK_HMP_ITEM_HMP: [dbo].[Item_HMP].ItemID](../../../../Images/fk.png) | ItemID | [dbo].[uniqueid] | 9 | NOT NULL | | Item. Link to Item_HMP.ID |
| NoteActivityID | [dbo].[uniqueid] | 9 | NOT NULL | | Not Used. |
 ![Foreign Keys FK_HMP_HMP_ITEM_DE: [dbo].[HMP_Item_DE].HMPItemDE Foreign Keys FK_HMP_HMP_ITEM_DE: [dbo].[HMP_Item_DE].HMPItemDE](../../../../Images/fk.png) | HMPItemDE | [dbo].[dict_id] | 5 | NOT NULL | | Obsolete HMP Item. Link to HMP_Item_DE.ID |
 ![Foreign Keys FK_HMP_PROBLEM_DE: [dbo].[Problem_DE].ProblemDE Foreign Keys FK_HMP_PROBLEM_DE: [dbo].[Problem_DE].ProblemDE](../../../../Images/fk.png) | ProblemDE | [dbo].[dict_id] | 5 | NOT NULL | | Problem. link to Problem_DE.ID |
(2)![Foreign Keys FK_HMP_PROBLEM_HEADER: [dbo].[Problem_Header].ProblemID Foreign Keys FK_HMP_PROBLEM_HEADER: [dbo].[Problem_Header].ProblemID](../../../../Images/fk.png) | ProblemID | [dbo].[uniqueid] | 9 | NOT NULL | | Problem Instance. Link to Problem_Header.ID. |
| FreqValue | smallint | 2 | NOT NULL | | Specified numeric value for the given frequency unit |
 ![Foreign Keys FK_HMP_HMP_Freq_Unit_DE: [dbo].[HMP_Freq_Unit_DE].FreqUnitDE Foreign Keys FK_HMP_HMP_Freq_Unit_DE: [dbo].[HMP_Freq_Unit_DE].FreqUnitDE](../../../../Images/fk.png) | FreqUnitDE | [dbo].[dict_id] | 5 | NOT NULL | | Frequency Units. Link to HMP_Freq_Unit_DE.ID |
 ![Foreign Keys FK_HMP_HMP_Status_DE: [dbo].[HMP_Status_DE].HMPStatusDE Foreign Keys FK_HMP_HMP_Status_DE: [dbo].[HMP_Status_DE].HMPStatusDE](../../../../Images/fk.png) | HMPStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | Status. Link to HMP_Status_DE.ID |
 | StartDTTM | datetime | 8 | NOT NULL | | When this reminder begins |
| EndDTTM | datetime | 8 | NULL allowed | | When this reminder ends |
| LastDoneDTTM | datetime | 8 | NULL allowed | | When the reminder action was last done |
 | PlannedBy | [dbo].[uniqueid] | 9 | NOT NULL | | Provider who specified the order reminder for this patient |
 | RecordedDTTM | datetime | 8 | NOT NULL | | When the row was inserted |
 | WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | | Which provider this is on behalf of |
 | WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | | Which provider recorded this reminder |
![Check Constraints CK_HMP_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y') Check Constraints CK_HMP_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')](../../../../Images/c-constraint.png) | IsUnverifiedFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Y=Reminder has not yet been verified; N=Reminder has been verified |
| VerificationTaskOwnerID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Owner of the verification task, either Provider.ID or Team_DE.ID depending on type |
| VerificationTaskOwnerType | char(10) | 10 | NOT NULL | ('') | Either "Team" or "User" which qualifies VerificationTaskOwnerID |
| OIDDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Points to either Medication_DE.ID or QO_Classification_DE.ID, depending on OIDType |
![Check Constraints CK_HMP_OIDType : ([OIDType]='M' OR [OIDType]='O' OR [OIDType]='F') Check Constraints CK_HMP_OIDType : ([OIDType]='M' OR [OIDType]='O' OR [OIDType]='F')](../../../../Images/c-constraint.png) | OIDType | char(1) | 1 | NOT NULL | ('O') | Determines where OIDDE points to: M=Medication; O=QOClass |
 | ScheduleID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Schedule. Link to WIP_Schedule.ID |
| HMPEnrollmentID | [dbo].[uniqueid] | 9 | NULL allowed | | Link to HMP_Enrollment.ID |
| CareGuideTemplateID | [dbo].[dict_id] | 5 | NOT NULL | (0) | Points to CarePlan_Template.ID, the Care Guide template this was created from, if any. |
![Check Constraints CK_HMP_DeferredFLAG_Yes_Or_No : ([DeferredFLAG]='N' OR [DeferredFLAG]='Y') Check Constraints CK_HMP_DeferredFLAG_Yes_Or_No : ([DeferredFLAG]='N' OR [DeferredFLAG]='Y')](../../../../Images/c-constraint.png) | DeferredFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Y=reminder is deferred; N=reminder is active |
![Check Constraints CK_HMP_PermanentDeferralFLAG_Yes_Or_No : ([PermanentDeferralFLAG]='N' OR [PermanentDeferralFLAG]='Y') Check Constraints CK_HMP_PermanentDeferralFLAG_Yes_Or_No : ([PermanentDeferralFLAG]='N' OR [PermanentDeferralFLAG]='Y')](../../../../Images/c-constraint.png) | PermanentDeferralFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Y=reminder is permanently deferred; N=not permanently defered |
 ![Foreign Keys FK_HMP_OrderStatusReasonDE: [dbo].[Order_Status_Reason_DE].DeferralReasonDE Foreign Keys FK_HMP_OrderStatusReasonDE: [dbo].[Order_Status_Reason_DE].DeferralReasonDE](../../../../Images/fk.png) | DeferralReasonDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Deferral Reason. Link to Order_Status_Reason_DE.ID |
| DeferredUntilDTTM | datetime | 8 | NULL allowed | | When the deferral expires |
| OrderFirstInstDTTM | datetime | 8 | NULL allowed | | Holds the value of StartDTTM, the first time this was ordered |
| LinkedProblemIDs | varchar(max) | max | NOT NULL | ('') | Linked Problems. Comma seperated list of Problem.ID. |
| OrderStatusReasonFreeText | varchar(50) | 50 | NULL allowed | | User-specified reason of the order status |