Tables [dbo].[Item_HMP]
This is the parent Table to the HMP detail records
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Item_HMP: IDIndexes TWstat_Item_HMP_ActivityHeaderID_ID, TWstat_Item_HMP_CurrentID_ID, TWstat_Item_HMP_LastUpdateDTTM_ID, TWstat_Item_HMP_PatientID_ID(4)ID[dbo].[uniqueid]9NOT NULLKey to the Item_HMP table
Indexes TWstat_Item_HMP_ActivityHeaderID_IDForeign Keys FK_ITEM_HMP_Act_Hdr_HMP: [dbo].[Act_Hdr_HMP].ActivityHeaderIDActivityHeaderID[dbo].[uniqueid]9NOT NULLThe Activity Header ID. Link to Act_Hdr_HMP.ID
Indexes IX_Item_HMP_PatientId, TWstat_Item_HMP_PatientID_ID(2)Foreign Keys FK_ITEM_HMP_Patient_Member: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID
Indexes TWstat_Item_HMP_CurrentID_IDCurrentIDnumeric(16,0)9NOT NULLThis is the ID of the Current HMP Item. Link to HMP.ID
EntryNamevarchar(255)255NOT NULLThe Entry Name of the Health Maintenance Plan
CreateDTTMdatetime8NOT NULLDate Created
Indexes Portal_Item_Hmp, TWstat_Item_HMP_LastUpdateDTTM_ID(2)LastUpdateDTTMdatetime8NULL allowedDate Last Updated
Check Constraints CK_Item_HMP_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')HasSecurityFLAG[dbo].[BOOL]1NOT NULLSecurity Flag (Y/N)
Check Constraints CK_Item_HMP_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')HasAnnotationFLAG[dbo].[BOOL]1NOT NULLAnnotation Flag (Y/N)
Check Constraints CK_Item_HMP_IsErrorFLAG_Yes_Or_No : ([IsErrorFLAG]='N' OR [IsErrorFLAG]='Y')IsErrorFLAG[dbo].[BOOL]1NOT NULLError Flag (Y/N)
DetailTypechar(1)1NOT NULLDetail Type code
ItemTypechar(2)2NOT NULLItem Type (HM)
PerformedDTTMdatetime8NOT NULLDate Performed
FreeTextDescriptionvarchar(4000)4000NOT NULL('')A description of the HMP
FreeTextNamevarchar(255)255NOT NULL('')Name associated to the Free text description