Tables [dbo].[Act_Hdr_HMP]
Activity header table for order reminders
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Act_Hdr_hmp: IDIndexes TWstat_Act_Hdr_HMP_ActivityType_ID, TWstat_Act_Hdr_HMP_CurrentID_ID, TWstat_Act_Hdr_HMP_EncounterID_ID, TWstat_Act_Hdr_HMP_PatientID_ID, TWstat_Act_Hdr_HMP_VisitID_ID(5)ID[dbo].[uniqueid]9NOT NULLKey to the Act_Hdr_HMP table
Indexes IX_Act_Hdr_HMP_PatientId, TWstat_Act_Hdr_HMP_PatientID_ID(2)Foreign Keys FK_Act_Hdr_HMP_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID.
Indexes TWstat_Act_Hdr_HMP_VisitID_IDVisitID[dbo].[uniqueid]9NOT NULLVisit Link to Visit.ID.
Indexes nix_Act_Hdr_HMP_1, TWstat_Act_Hdr_HMP_CurrentID_ID(2)CurrentIDnumeric(16,0)9NOT NULLCurrent activity row. Link to the current row in Act_HMP.ID
DocFolderIDnumeric(16,0)9NOT NULLThis is set to 0 by default. Not used for Order Reminders.
CreateDTTMdatetime8NOT NULLDate entry was added.
LastUpdateDTTMdatetime8NOT NULLDate entry was last modified.
Check Constraints CK_Act_Hdr_HMP_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')HasSecurityFLAG[dbo].[BOOL]1NOT NULLSecurity indicator (no longer used). Y/N.
Check Constraints CK_Act_Hdr_HMP_IsCorrectedFLAG_Yes_Or_No : ([IsCorrectedFLAG]='N' OR [IsCorrectedFLAG]='Y')IsCorrectedFLAG[dbo].[BOOL]1NOT NULLCorrected Indicator (no longer used). Y/N.
Check Constraints CK_Act_Hdr_HMP_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')HasAnnotationFLAG[dbo].[BOOL]1NOT NULLSet to 'Y' if the activity has an annotation else set to 'N'.  Y/N. Always N.
Check Constraints CK_Act_Hdr_HMP_SignatureRequiredFLAG_Yes_Or_No : ([SignatureRequiredFLAG]='N' OR [SignatureRequiredFLAG]='Y')SignatureRequiredFLAG[dbo].[BOOL]1NOT NULLIndicates whether signature is required or not. Y/N. Always N.
Check Constraints CK_Act_Hdr_HMP_AcknowledgementReqFLAG_Yes_Or_No : ([AcknowledgementReqFLAG]='N' OR [AcknowledgementReqFLAG]='Y')AcknowledgementReqFLAG[dbo].[BOOL]1NOT NULLIndicates whether acknowledgement is required or not. Y/N. Always N.
SignedByProviderID[dbo].[uniqueid]9NOT NULL Signed By Provider. Link to Provider.ID
Indexes TWstat_Act_Hdr_HMP_AckByProviderIDAckByProviderID[dbo].[uniqueid]9NOT NULLProvider who acknowledged. Link to Provider.ID. Always 0.
NakByProviderID[dbo].[uniqueid]9NOT NULLProvider who rejected. Link to Provider.ID. Always 0.
Indexes TWstat_Act_Hdr_HMP_ActivityType_IDActivityTypechar(10)10NOT NULLHM (Order Reminder)
Indexes nix_Act_Hdr_HMP_1, TWstat_Act_Hdr_HMP_EncounterID_ID(2)EncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID.
Indexes TWstat_Act_Hdr_HMP_ResultStageResultStagechar(2)2NOT NULLF = Final.
ParentID[dbo].[uniqueid]9NOT NULLParent identifier (no longer used).
Indexes TWstat_Act_Hdr_HMP_QOClassificationDEQOClassificationDE[dbo].[dict_id]5NOT NULLOrderable Item. Link to QO_Classification_DE.ID. Not used for reminders.
Check Constraints CK_Act_Hdr_HMP_HasProblemFLAG_Yes_Or_No : ([HasProblemFLAG]='N' OR [HasProblemFLAG]='Y')HasProblemFLAG[dbo].[BOOL]1NOT NULLProblem Indicator (no longer used). Y/N. Always N.
ActivityTypeDE[dbo].[dict_id]5NOT NULLActivity Type. Link to Activity_Type_DE.ID. Always 0.
FormDE[dbo].[dict_id]5NOT NULLForm (no longer used). Link to Form_DE.ID. Always 0.
CompletionStatuschar(10)10NOT NULLStatus. 'Complete'
CMSVersionsmallint2NOT NULLCMS Version. Currently 4.