Tables [dbo].[Act_Hdr_Result]
Activity header table for Results
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_Act_Hdr_Result_ID: IDIndexes nix_Act_Hdr_Result_ID_PatientID_CurrentIDID[dbo].[uniqueid]9NOT NULLKey to the Act_Hdr_Result table
Cluster Key XcAct_Hdr_Result_Person: PatientIDIndexes nix_Act_Hdr_Result_ID_PatientID_CurrentID, TWstat_Act_Hdr_Result_AckByProviderID_PatientID, TWstat_Act_Hdr_Result_AcknowledgementReqFLAG_PatientID, TWstat_Act_Hdr_Result_ActivityType_PatientID, TWstat_Act_Hdr_Result_CreateDTTM_PatientID, TWstat_Act_Hdr_Result_LastUpdateDTTM_PatientID, TWstat_Act_Hdr_Result_NakByProviderID_PatientID, TWstat_Act_Hdr_Result_QOClassificationDE_PatientID, TWstat_Act_Hdr_Result_ResultStage_PatientID, TWstat_Act_Hdr_Result_SignedByProviderID_PatientID(10)Foreign Keys FK_Act_Hdr_Result_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID.
Indexes XAct_Hdr_Result_VisIDVisitID[dbo].[uniqueid]9NOT NULLVisit Link to Visit.ID.
Indexes XAct_Hdr_Result_CurID, nix_Act_Hdr_Result_1, nix_Act_Hdr_Result_ID_PatientID_CurrentID(3)CurrentIDnumeric(16,0)9NOT NULLCurrent activity row. Link to the current row in Act_Result.ID
DocFolderIDnumeric(16,0)9NOT NULLThis is set to 0 by default. Not used for Results.
Indexes TWstat_Act_Hdr_Result_CreateDTTM_PatientIDCreateDTTMdatetime8NOT NULLDate entry was added.
Indexes TWstat_Act_Hdr_Result_LastUpdateDTTM_PatientIDLastUpdateDTTMdatetime8NOT NULLDate entry was last modified.
Check Constraints CK_Act_Hdr_Result_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_Result_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_Result_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.
Check Constraints CK_Act_Hdr_Result_SignatureRequiredFLAG_Yes_Or_No : ([SignatureRequiredFLAG]='N' OR [SignatureRequiredFLAG]='Y')SignatureRequiredFLAG[dbo].[BOOL]1NOT NULLIndicates whether signature is required or not. Y/N. Always N.
Indexes nix_Act_Hdr_Result_ID_PatientID_CurrentID, TWstat_Act_Hdr_Result_AcknowledgementReqFLAG_PatientID(2)Check Constraints CK_Act_Hdr_Result_AcknowledgementReqFLAG_Yes_Or_No : ([AcknowledgementReqFLAG]='N' OR [AcknowledgementReqFLAG]='Y')AcknowledgementReqFLAG[dbo].[BOOL]1NOT NULLIndicates whether acknowledgement is required or not. Y/N.
Indexes TWstat_Act_Hdr_Result_SignedByProviderID_PatientIDSignedByProviderID[dbo].[uniqueid]9NOT NULL Signed By Provider. Link to Provider.ID. Always 0.
Indexes nix_Act_Hdr_Result_ID_PatientID_CurrentID, TWstat_Act_Hdr_Result_AckByProviderID_PatientID(2)AckByProviderID[dbo].[uniqueid]9NOT NULLProvider who acknowledged. Link to Provider.ID.
Indexes nix_Act_Hdr_Result_ID_PatientID_CurrentID, TWstat_Act_Hdr_Result_NakByProviderID_PatientID(2)NakByProviderID[dbo].[uniqueid]9NOT NULLProvider who rejected. Link to Provider.ID.
Indexes nix_Act_Hdr_Result_ID_PatientID_CurrentID, TWstat_Act_Hdr_Result_ActivityType_PatientID(2)Check Constraints CK_Act_Hdr_Result_ActivityType : ([ActivityType]='RI')ActivityTypechar(10)10NOT NULLRI (Result)
Indexes nix_Act_Hdr_Result_1, XAct_Hdr_Result_EncID, nix_Act_Hdr_Result_ID_PatientID_CurrentID(3)EncounterID[dbo].[uniqueid]9NOT NULLEncounter. Link to Encounter.ID.
Indexes nix_Act_Hdr_Result_ID_PatientID_CurrentID, TWstat_Act_Hdr_Result_ResultStage_PatientID(2)Check Constraints CK_Act_Hdr_Result_ResultStage_Result_Stage : ([ResultStage]='' OR [ResultStage]='C' OR [ResultStage]='A' OR [ResultStage]='F' OR [ResultStage]='I' OR [ResultStage]='P')ResultStagechar(2)2NOT NULLStage:
Valid values:
' ' =
'C'  =Complete
'A'  =Ammended
'F'  =Final
'I'  =Preliminary
'P' =Pending
ParentID[dbo].[uniqueid]9NOT NULLParent identifier (no longer used).
Indexes nix_Act_Hdr_Result_1, nix_Act_Hdr_Result_ID_PatientID_CurrentID, TWstat_Act_Hdr_Result_QOClassificationDE_PatientID(3)QOClassificationDE[dbo].[dict_id]5NOT NULLOrderable Item. Link to QO_Classification_DE.ID.
Check Constraints CK_Act_Hdr_Result_HasProblemFLAG_Yes_Or_No : ([HasProblemFLAG]='N' OR [HasProblemFLAG]='Y')HasProblemFLAG[dbo].[BOOL]1NOT NULLProblem Indicator (no longer used). Y/N.
ActivityTypeDE[dbo].[dict_id]5NOT NULLActivity Type. Link to Activity_Type_DE.ID
FormDE[dbo].[dict_id]5NOT NULLForm (no longer used). Link to Form_DE.ID.
Check Constraints CK_Act_Hdr_Result_CompletionStatus_Note_Completion_Status : ([CompletionStatus]='CompAmend' OR [CompletionStatus]='Ammended' OR [CompletionStatus]='Complete' OR [CompletionStatus]='Incomplete')CompletionStatuschar(10)10NOT NULLStatus
Valid values:
'CompAmend'
'Ammended'
'Complete'
'Incomplete'
Indexes nix_Act_Hdr_Result_ID_PatientID_CurrentIDCMSVersionsmallint2NOT NULLCMS Version. Currently 4.