Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (4) | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Item_HMP table |
 ![Foreign Keys FK_ITEM_HMP_Act_Hdr_HMP: [dbo].[Act_Hdr_HMP].ActivityHeaderID Foreign Keys FK_ITEM_HMP_Act_Hdr_HMP: [dbo].[Act_Hdr_HMP].ActivityHeaderID](../../../../Images/fk.png) | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | | The Activity Header ID. Link to Act_Hdr_HMP.ID |
(2)![Foreign Keys FK_ITEM_HMP_Patient_Member: [dbo].[Patient_Member].PatientID Foreign Keys FK_ITEM_HMP_Patient_Member: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | Patient. Link to Patient_Member.ID |
 | CurrentID | numeric(16,0) | 9 | NOT NULL | | This is the ID of the Current HMP Item. Link to HMP.ID |
| EntryName | varchar(255) | 255 | NOT NULL | | The Entry Name of the Health Maintenance Plan |
| CreateDTTM | datetime | 8 | NOT NULL | | Date Created |
(2) | LastUpdateDTTM | datetime | 8 | NULL allowed | | Date Last Updated |
![Check Constraints CK_Item_HMP_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y') Check Constraints CK_Item_HMP_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')](../../../../Images/c-constraint.png) | HasSecurityFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Security Flag (Y/N) |
![Check Constraints CK_Item_HMP_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y') Check Constraints CK_Item_HMP_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')](../../../../Images/c-constraint.png) | HasAnnotationFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Annotation Flag (Y/N) |
![Check Constraints CK_Item_HMP_IsErrorFLAG_Yes_Or_No : ([IsErrorFLAG]='N' OR [IsErrorFLAG]='Y') Check Constraints CK_Item_HMP_IsErrorFLAG_Yes_Or_No : ([IsErrorFLAG]='N' OR [IsErrorFLAG]='Y')](../../../../Images/c-constraint.png) | IsErrorFLAG | [dbo].[BOOL] | 1 | NOT NULL | | Error Flag (Y/N) |
| DetailType | char(1) | 1 | NOT NULL | | Detail Type code |
| ItemType | char(2) | 2 | NOT NULL | | Item Type (HM) |
| PerformedDTTM | datetime | 8 | NOT NULL | | Date Performed |
| FreeTextDescription | varchar(4000) | 4000 | NOT NULL | ('') | A description of the HMP |
| FreeTextName | varchar(255) | 255 | NOT NULL | ('') | Name associated to the Free text description |