Tables [dbo].[Act_HMP]
Activity table for Order Reminders
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Act_HMP: IDIndexes TWstat_Act_HMP_AccessionNumber_ID, TWstat_Act_HMP_ActivityHeaderID_ID, TWstat_Act_HMP_ActivityType_ID, TWstat_Act_HMP_OrganizationID_ID, TWstat_Act_HMP_PatientID_ID(5)ID[dbo].[uniqueid]9NOT NULLKey to the Act_HMP table
Indexes NIX_Act_HMP_ActivityHeaderID, TWstat_Act_HMP_ActivityHeaderID_ID(2)Foreign Keys FK_Act_HMP_Act_Hdr_HMP: [dbo].[Act_Hdr_HMP].ActivityHeaderIDActivityHeaderID[dbo].[uniqueid]9NOT NULLActivity Header. Link to Act_Hdr_HMP.ID.
Indexes TWstat_Act_HMP_OrganizationID_IDOrganizationIDnumeric(8,0)5NOT NULLOrganization. Link to Organization.ID.
NoteTypeDE[dbo].[dict_id]5NOT NULLNote Type. Link to Note_Type_DE.ID. Always 0.
TemplateVersionsmallint2NOT NULLTemplate Version. Link to Note_Template_Version.TemplateVersion. No Longer Used.
EpisodeID[dbo].[uniqueid]9NOT NULLEpisode. No longer Used.
CarePlanDE[dbo].[dict_id]5NOT NULLCare Plan. No Longer Used.
OrderSourceDE[dbo].[dict_id]5NOT NULLOrder Source. Link to Order_Source_DE.ID. Always 0.
OrderNumberEXTvarchar(20)20NOT NULLExternal Order Number
FUComment[dbo].[message]255NOT NULLFollow Up Comment.
Indexes TWstat_Act_HMP_AccessionNumber_IDAccessionNumbervarchar(255)255NOT NULLAccession number
InterfaceSourceIDsmallint2NOT NULLInterface Source. Always 0.
TestingProviderID[dbo].[uniqueid]9NOT NULLTesting Provider. Link to Provider.ID. Always 0.
WhoForID[dbo].[uniqueid]9NOT NULLEntered For Provider. Link to Provider.ID.
WhoDidItID[dbo].[uniqueid]9NOT NULLUser who entered. Link to IDX_User.ID.
PerformedDTTMdatetime8NOT NULLHolds the performed date and time of the activity
RecordedDTTMdatetime8NOT NULLHolds the Recorded Date and Time of the Activity
Check Constraints CK_Act_HMP_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y')HasClinicalWarningFLAG[dbo].[BOOL]1NOT NULLNo Longer Used.
ClinicalDTTMdatetime8NOT NULLClinical Date and Time
ClinicalSourceDE[dbo].[dict_id]5NOT NULLClinical Source. Link to Source_DE.ID. Always 0.
OrderingProviderID[dbo].[uniqueid]9NOT NULLOrdering Provider. Link to Provider.ID.
OrderingProviderName[dbo].[name]255NOT NULLOrdering provider Name.
Indexes IX_Act_HMP_PatientId, TWstat_Act_HMP_PatientID_ID(2)Foreign Keys FK_Act_HMP_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientIDnumeric(16,0)9NOT NULLPatient. Link to Person.ID
Indexes TWstat_Act_HMP_ActivityType_IDActivityTypevarchar(10)10NULL allowedHM (Order Reminder)