Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 (5) | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the Act_HMP table |
(2)![Foreign Keys FK_Act_HMP_Act_Hdr_HMP: [dbo].[Act_Hdr_HMP].ActivityHeaderID Foreign Keys FK_Act_HMP_Act_Hdr_HMP: [dbo].[Act_Hdr_HMP].ActivityHeaderID](../../../../Images/fk.png) | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | Activity Header. Link to Act_Hdr_HMP.ID. |
 | OrganizationID | numeric(8,0) | 5 | NOT NULL | Organization. Link to Organization.ID. |
| NoteTypeDE | [dbo].[dict_id] | 5 | NOT NULL | Note Type. Link to Note_Type_DE.ID. Always 0. |
| TemplateVersion | smallint | 2 | NOT NULL | Template Version. Link to Note_Template_Version.TemplateVersion. No Longer Used. |
| EpisodeID | [dbo].[uniqueid] | 9 | NOT NULL | Episode. No longer Used. |
| CarePlanDE | [dbo].[dict_id] | 5 | NOT NULL | Care Plan. No Longer Used. |
| OrderSourceDE | [dbo].[dict_id] | 5 | NOT NULL | Order Source. Link to Order_Source_DE.ID. Always 0. |
| OrderNumberEXT | varchar(20) | 20 | NOT NULL | External Order Number |
| FUComment | [dbo].[message] | 255 | NOT NULL | Follow Up Comment. |
 | AccessionNumber | varchar(255) | 255 | NOT NULL | Accession number |
| InterfaceSourceID | smallint | 2 | NOT NULL | Interface Source. Always 0. |
| TestingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Testing Provider. Link to Provider.ID. Always 0. |
| WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | Entered For Provider. Link to Provider.ID. |
| WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | User who entered. Link to IDX_User.ID. |
| PerformedDTTM | datetime | 8 | NOT NULL | Holds the performed date and time of the activity |
| RecordedDTTM | datetime | 8 | NOT NULL | Holds the Recorded Date and Time of the Activity |
![Check Constraints CK_Act_HMP_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y') Check Constraints CK_Act_HMP_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y')](../../../../Images/c-constraint.png) | HasClinicalWarningFLAG | [dbo].[BOOL] | 1 | NOT NULL | No Longer Used. |
| ClinicalDTTM | datetime | 8 | NOT NULL | Clinical Date and Time |
| ClinicalSourceDE | [dbo].[dict_id] | 5 | NOT NULL | Clinical Source. Link to Source_DE.ID. Always 0. |
| OrderingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Ordering Provider. Link to Provider.ID. |
| OrderingProviderName | [dbo].[name] | 255 | NOT NULL | Ordering provider Name. |
(2)![Foreign Keys FK_Act_HMP_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Act_HMP_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | numeric(16,0) | 9 | NOT NULL | Patient. Link to Person.ID |
 | ActivityType | varchar(10) | 10 | NULL allowed | HM (Order Reminder) |