Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 (3) | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the Act_Result table |
(2)![Foreign Keys FK_Act_Result_ActivityHeaderID_Act_Hdr_Result_ID: [dbo].[Act_Hdr_Result].ActivityHeaderID Foreign Keys FK_Act_Result_ActivityHeaderID_Act_Hdr_Result_ID: [dbo].[Act_Hdr_Result].ActivityHeaderID](../../../../Images/fk.png) | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | Activity Header. Link to Act_Hdr_Result.ID. |
 ![Foreign Keys FK_Act_Result_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationID Foreign Keys FK_Act_Result_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationID](../../../../Images/fk.png) | OrganizationID | numeric(8,0) | 5 | NOT NULL | Organization. Link to Organization.ID. |
![Foreign Keys FK_Act_Result_NoteTypeDE_Note_Type_DE_ID: [dbo].[Note_Type_DE].NoteTypeDE Foreign Keys FK_Act_Result_NoteTypeDE_Note_Type_DE_ID: [dbo].[Note_Type_DE].NoteTypeDE](../../../../Images/fk.png) ![Foreign Keys FK_Act_Result_NoteTypeDE_TemplateVersion_Note_Template_Version_NoteTypeDE_TemplateVersion: [dbo].[Note_Template_Version].NoteTypeDE\TemplateVersion Foreign Keys FK_Act_Result_NoteTypeDE_TemplateVersion_Note_Template_Version_NoteTypeDE_TemplateVersion: [dbo].[Note_Template_Version].NoteTypeDE\TemplateVersion](../../../../Images/fk.png) | NoteTypeDE | [dbo].[dict_id] | 5 | NOT NULL | Note 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\TemplateVersion Foreign Keys FK_Act_Result_NoteTypeDE_TemplateVersion_Note_Template_Version_NoteTypeDE_TemplateVersion: [dbo].[Note_Template_Version].NoteTypeDE\TemplateVersion](../../../../Images/fk.png) | 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. |
 ![Foreign Keys FK_Act_Result_OrderSourceDE_Order_Source_DE_ID: [dbo].[Order_Source_DE].OrderSourceDE Foreign Keys FK_Act_Result_OrderSourceDE_Order_Source_DE_ID: [dbo].[Order_Source_DE].OrderSourceDE](../../../../Images/fk.png) | OrderSourceDE | [dbo].[dict_id] | 5 | NOT NULL | Order Source. Link to Order_Source_DE.ID. Always 0. |
(2) | OrderNumberEXT | varchar(20) | 20 | NOT NULL | External Order Number |
| FUComment | [dbo].[message] | 255 | NOT NULL | Follow Up Comment. Always blank. |
 | AccessionNumber | varchar(255) | 255 | NOT NULL | Accession number |
(2) | InterfaceSourceID | smallint | 2 | NOT NULL | Interface Source. 1918 indicates it came from the Touchworks application |
 ![Foreign Keys FK_Act_Result_TestingProviderID_Provider_ID: [dbo].[Provider].TestingProviderID Foreign Keys FK_Act_Result_TestingProviderID_Provider_ID: [dbo].[Provider].TestingProviderID](../../../../Images/fk.png) | TestingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Testing Provider. Link to Provider.ID. |
![Foreign Keys FK_Act_Result_WhoForID_Provider_ID: [dbo].[Provider].WhoForID Foreign Keys FK_Act_Result_WhoForID_Provider_ID: [dbo].[Provider].WhoForID](../../../../Images/fk.png) | WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | Entered For Provider. Link to Provider.ID. |
 ![Foreign Keys FK_Act_Result_WhoDidItID_IDX_User_ID: [dbo].[IDX_User].WhoDidItID Foreign Keys FK_Act_Result_WhoDidItID_IDX_User_ID: [dbo].[IDX_User].WhoDidItID](../../../../Images/fk.png) | WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | User who entered. Link to IDX_User.ID. |
 | PerformedDTTM | datetime | 8 | NOT NULL | Performed date and time of the activity |
 | RecordedDTTM | datetime | 8 | NOT NULL | Recorded Date and Time of the Activity |
![Check Constraints CK_Act_Result_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y') Check Constraints CK_Act_Result_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y')](../../../../Images/c-constraint.png) | HasClinicalWarningFLAG | [dbo].[BOOL] | 1 | NOT NULL | No Longer Used. |
(2) | ClinicalDTTM | datetime | 8 | NOT NULL | Clinical Date and Time |
![Foreign Keys FK_Act_Result_ClinicalSourceDE_Source_DE_ID: [dbo].[Source_DE].ClinicalSourceDE Foreign Keys FK_Act_Result_ClinicalSourceDE_Source_DE_ID: [dbo].[Source_DE].ClinicalSourceDE](../../../../Images/fk.png) | ClinicalSourceDE | [dbo].[dict_id] | 5 | NOT NULL | Clinical Source. Link to Source_DE.ID. Always 0. |
(4)![Foreign Keys FK_Act_Result_OrderingProviderID_Provider_ID: [dbo].[Provider].OrderingProviderID Foreign Keys FK_Act_Result_OrderingProviderID_Provider_ID: [dbo].[Provider].OrderingProviderID](../../../../Images/fk.png) | OrderingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Ordering Provider. Link to Provider.ID. |
 | OrderingProviderName | [dbo].[name] | 255 | NOT NULL | Ordering provider Name. |
 (12) | PatientID | numeric(16,0) | 9 | NOT NULL | Patient. Link to Person.ID |
 ![Check Constraints CK_Act_Result_ActivityType : ([ActivityType]='RI') Check Constraints CK_Act_Result_ActivityType : ([ActivityType]='RI')](../../../../Images/c-constraint.png) | ActivityType | varchar(10) | 10 | NULL allowed | RI - Result |
| QOMod1DE | [dbo].[dict_id] | 5 | NULL allowed | Order Modifier. Link to QO_Mod_DE.ID. Always NULL. |