Tables [dbo].[Act_Result]
Activity Level table for Results
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_Act_Result_ID: IDIndexes nix_Act_Result_ActivityHeaderID_ClinicalDTTM, nix_Act_Result_ActivityHeaderID_PatientID, nix_Act_Result_ID_OrderingProviderID(3)ID[dbo].[uniqueid]9NOT NULLKey to the Act_Result table
Indexes nix_Act_Result_ActivityHeaderID_ClinicalDTTM, nix_Act_Result_ActivityHeaderID_PatientID(2)Foreign Keys FK_Act_Result_ActivityHeaderID_Act_Hdr_Result_ID: [dbo].[Act_Hdr_Result].ActivityHeaderIDActivityHeaderID[dbo].[uniqueid]9NOT NULLActivity Header. Link to Act_Hdr_Result.ID.
Indexes TWstat_Act_Result_OrganizationID_PatientIDForeign Keys FK_Act_Result_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationIDOrganizationIDnumeric(8,0)5NOT NULLOrganization. Link to Organization.ID.
Foreign Keys FK_Act_Result_NoteTypeDE_Note_Type_DE_ID: [dbo].[Note_Type_DE].NoteTypeDEForeign Keys FK_Act_Result_NoteTypeDE_TemplateVersion_Note_Template_Version_NoteTypeDE_TemplateVersion: [dbo].[Note_Template_Version].NoteTypeDE\TemplateVersionNoteTypeDE[dbo].[dict_id]5NOT NULLNote Type. Link to Note_Type_DE.ID. Always 0.
Foreign Keys FK_Act_Result_NoteTypeDE_TemplateVersion_Note_Template_Version_NoteTypeDE_TemplateVersion: [dbo].[Note_Template_Version].NoteTypeDE\TemplateVersionTemplateVersionsmallint2NOT 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.
Indexes TWstat_Act_Result_OrderSourceDE_PatientIDForeign Keys FK_Act_Result_OrderSourceDE_Order_Source_DE_ID: [dbo].[Order_Source_DE].OrderSourceDEOrderSourceDE[dbo].[dict_id]5NOT NULLOrder Source. Link to Order_Source_DE.ID. Always 0.
Indexes nix_Act_Result_ActivityHeaderID_PatientID, TWstat_Act_Result_OrderNumberEXT_PatientID(2)OrderNumberEXTvarchar(20)20NOT NULLExternal Order Number
FUComment[dbo].[message]255NOT NULLFollow Up Comment. Always blank.
Indexes XAct_Result_AccNumAccessionNumbervarchar(255)255NOT NULLAccession number
Indexes nix_Act_Result_ActivityHeaderID_PatientID, TWstat_Act_Result_InterfaceSourceID_PatientID(2)InterfaceSourceIDsmallint2NOT NULLInterface Source. 1918 indicates it came from the Touchworks application
Indexes nix_Act_Result_ActivityHeaderID_PatientIDForeign Keys FK_Act_Result_TestingProviderID_Provider_ID: [dbo].[Provider].TestingProviderIDTestingProviderID[dbo].[uniqueid]9NOT NULLTesting Provider. Link to Provider.ID.
Foreign Keys FK_Act_Result_WhoForID_Provider_ID: [dbo].[Provider].WhoForIDWhoForID[dbo].[uniqueid]9NOT NULLEntered For Provider. Link to Provider.ID.
Indexes TWstat_Act_Result_WhoDidItID_PatientIDForeign Keys FK_Act_Result_WhoDidItID_IDX_User_ID: [dbo].[IDX_User].WhoDidItIDWhoDidItID[dbo].[uniqueid]9NOT NULLUser who entered. Link to IDX_User.ID.
Indexes TWstat_Act_Result_PerformedDTTM_PatientIDPerformedDTTMdatetime8NOT NULLPerformed date and time of the activity
Indexes TWstat_Act_Result_RecordedDTTM_PatientIDRecordedDTTMdatetime8NOT NULLRecorded Date and Time of the Activity
Check Constraints CK_Act_Result_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y')HasClinicalWarningFLAG[dbo].[BOOL]1NOT NULLNo Longer Used.
Indexes nix_Act_Result_ActivityHeaderID_ClinicalDTTM, TWstat_Act_Result_ClinicalDTTM_PatientID(2)ClinicalDTTMdatetime8NOT NULLClinical Date and Time
Foreign Keys FK_Act_Result_ClinicalSourceDE_Source_DE_ID: [dbo].[Source_DE].ClinicalSourceDEClinicalSourceDE[dbo].[dict_id]5NOT NULLClinical Source. Link to Source_DE.ID. Always 0.
Indexes nix_Act_Result_ActivityHeaderID_ClinicalDTTM, nix_Act_Result_ActivityHeaderID_PatientID, nix_Act_Result_ID_OrderingProviderID, TWstat_Act_Result_OrderingProviderID_PatientID(4)Foreign Keys FK_Act_Result_OrderingProviderID_Provider_ID: [dbo].[Provider].OrderingProviderIDOrderingProviderID[dbo].[uniqueid]9NOT NULLOrdering Provider. Link to Provider.ID.
Indexes TWstat_Act_Result_OrderingProviderName_PatientIDOrderingProviderName[dbo].[name]255NOT NULLOrdering provider Name.
Cluster Key XcAct_Result_Person: PatientIDIndexes nix_Act_Result_ActivityHeaderID_PatientID, TWstat_Act_Result_ActivityType_PatientID, TWstat_Act_Result_ClinicalDTTM_PatientID, TWstat_Act_Result_InterfaceSourceID_PatientID, TWstat_Act_Result_OrderingProviderID_PatientID, TWstat_Act_Result_OrderingProviderName_PatientID, TWstat_Act_Result_OrderNumberEXT_PatientID, TWstat_Act_Result_OrderSourceDE_PatientID, TWstat_Act_Result_OrganizationID_PatientID, TWstat_Act_Result_PerformedDTTM_PatientID, TWstat_Act_Result_RecordedDTTM_PatientID, TWstat_Act_Result_WhoDidItID_PatientID(12)PatientIDnumeric(16,0)9NOT NULLPatient. Link to Person.ID
Indexes TWstat_Act_Result_ActivityType_PatientIDCheck Constraints CK_Act_Result_ActivityType : ([ActivityType]='RI')ActivityTypevarchar(10)10NULL allowedRI - Result
QOMod1DE[dbo].[dict_id]5NULL allowedOrder Modifier. Link to QO_Mod_DE.ID. Always NULL.