Tables [dbo].[HMP]
Health Order Reminder child/detail table  (see also Item_HMP)
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_HMP: IDIndexes TWstat_HMP_FreqUnitDE_ID, TWstat_HMP_HMPItemDE_ID, TWstat_HMP_HMPStatusDE_ID, TWstat_HMP_ItemID_ID, TWstat_HMP_ProblemDE_ID, TWstat_HMP_ProblemID_ID(6)ID[dbo].[uniqueid]9NOT NULLKey to the HMP table
Indexes NIX_HMP_RecordedDttm_INC_ItemID, TWstat_HMP_ItemID_ID(2)Foreign Keys FK_HMP_ITEM_HMP: [dbo].[Item_HMP].ItemIDItemID[dbo].[uniqueid]9NOT NULLItem. Link to Item_HMP.ID
NoteActivityID[dbo].[uniqueid]9NOT NULLNot Used.
Indexes TWstat_HMP_HMPItemDE_IDForeign Keys FK_HMP_HMP_ITEM_DE: [dbo].[HMP_Item_DE].HMPItemDEHMPItemDE[dbo].[dict_id]5NOT NULLObsolete HMP Item. Link to HMP_Item_DE.ID
Indexes TWstat_HMP_ProblemDE_IDForeign Keys FK_HMP_PROBLEM_DE: [dbo].[Problem_DE].ProblemDEProblemDE[dbo].[dict_id]5NOT NULLProblem. link to Problem_DE.ID
Indexes NIX_HMP_ProblemID, TWstat_HMP_ProblemID_ID(2)Foreign Keys FK_HMP_PROBLEM_HEADER: [dbo].[Problem_Header].ProblemIDProblemID[dbo].[uniqueid]9NOT NULLProblem Instance. Link to Problem_Header.ID.
FreqValuesmallint2NOT NULLSpecified numeric value for the given frequency unit
Indexes TWstat_HMP_FreqUnitDE_IDForeign Keys FK_HMP_HMP_Freq_Unit_DE: [dbo].[HMP_Freq_Unit_DE].FreqUnitDEFreqUnitDE[dbo].[dict_id]5NOT NULLFrequency Units. Link to HMP_Freq_Unit_DE.ID
Indexes TWstat_HMP_HMPStatusDE_IDForeign Keys FK_HMP_HMP_Status_DE: [dbo].[HMP_Status_DE].HMPStatusDEHMPStatusDE[dbo].[dict_id]5NOT NULLStatus. Link to HMP_Status_DE.ID
Indexes NIX_HMP_ScheduleIDStartDTTMdatetime8NOT NULLWhen this reminder begins
EndDTTMdatetime8NULL allowedWhen this reminder ends
LastDoneDTTMdatetime8NULL allowedWhen the reminder action was last done
Indexes TWstat_HMP_PlannedByPlannedBy[dbo].[uniqueid]9NOT NULLProvider who specified the order reminder for this patient
Indexes NIX_HMP_RecordedDttm_INC_ItemIDRecordedDTTMdatetime8NOT NULLWhen the row was inserted
Indexes TWstat_HMP_WhoForIDWhoForID[dbo].[uniqueid]9NOT NULLWhich provider this is on behalf of
Indexes TWstat_HMP_WhoDidItIDWhoDidItID[dbo].[uniqueid]9NOT NULLWhich provider recorded this reminder
Check Constraints CK_HMP_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')IsUnverifiedFLAG[dbo].[BOOL]1NOT NULL('N')Y=Reminder has not yet been verified; N=Reminder has been verified
VerificationTaskOwnerID[dbo].[uniqueid]9NOT NULL(0)Owner of the verification task, either Provider.ID or Team_DE.ID depending on type
VerificationTaskOwnerTypechar(10)10NOT NULL('')Either "Team" or "User" which qualifies VerificationTaskOwnerID
OIDDE[dbo].[dict_id]5NOT 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')OIDTypechar(1)1NOT NULL('O')Determines where OIDDE points to:  M=Medication; O=QOClass
Indexes NIX_HMP_ScheduleIDScheduleID[dbo].[uniqueid]9NOT NULL(0)Schedule. Link to WIP_Schedule.ID
HMPEnrollmentID[dbo].[uniqueid]9NULL allowedLink to HMP_Enrollment.ID
CareGuideTemplateID[dbo].[dict_id]5NOT 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')DeferredFLAG[dbo].[BOOL]1NOT NULL('N')Y=reminder is deferred;  N=reminder is active
Check Constraints CK_HMP_PermanentDeferralFLAG_Yes_Or_No : ([PermanentDeferralFLAG]='N' OR [PermanentDeferralFLAG]='Y')PermanentDeferralFLAG[dbo].[BOOL]1NOT NULL('N')Y=reminder is permanently deferred;  N=not permanently defered
Indexes TWstat_HMP_DeferralReasonDEForeign Keys FK_HMP_OrderStatusReasonDE: [dbo].[Order_Status_Reason_DE].DeferralReasonDEDeferralReasonDE[dbo].[dict_id]5NOT NULL(0)Deferral Reason. Link to Order_Status_Reason_DE.ID
DeferredUntilDTTMdatetime8NULL allowedWhen the deferral expires
OrderFirstInstDTTMdatetime8NULL allowedHolds the value of StartDTTM, the first time this was ordered
LinkedProblemIDsvarchar(max)maxNOT NULL('')Linked Problems. Comma seperated list of Problem.ID.
OrderStatusReasonFreeTextvarchar(50)50NULL allowedUser-specified reason of the order status