Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the Act_Other table |
 ![Foreign Keys FK_Act_Other_ActivityHeaderID_Act_Hdr_Other_ID: [dbo].[Act_Hdr_Other].ActivityHeaderID Foreign Keys FK_Act_Other_ActivityHeaderID_Act_Hdr_Other_ID: [dbo].[Act_Hdr_Other].ActivityHeaderID](../../../../Images/fk.png) | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | Activity Header. Link to Act_Hdr_Other.ID |
 ![Foreign Keys FK_Act_Other_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationID Foreign Keys FK_Act_Other_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_Other_NoteTypeDE_Note_Type_DE_ID: [dbo].[Note_Type_DE].NoteTypeDE Foreign Keys FK_Act_Other_NoteTypeDE_Note_Type_DE_ID: [dbo].[Note_Type_DE].NoteTypeDE](../../../../Images/fk.png) ![Foreign Keys FK_Act_Other_NoteTypeDE_TemplateVersion_Note_Template_Version_NoteTypeDE_TemplateVersion: [dbo].[Note_Template_Version].NoteTypeDE\TemplateVersion Foreign Keys FK_Act_Other_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_Other_NoteTypeDE_TemplateVersion_Note_Template_Version_NoteTypeDE_TemplateVersion: [dbo].[Note_Template_Version].NoteTypeDE\TemplateVersion Foreign Keys FK_Act_Other_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_Other_OrderSourceDE_Order_Source_DE_ID: [dbo].[Order_Source_DE].OrderSourceDE Foreign Keys FK_Act_Other_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. |
| 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 |
 | InterfaceSourceID | smallint | 2 | NOT NULL | Interface Source. |
 ![Foreign Keys FK_Act_Other_TestingProviderID_Person_ID: [dbo].[Person].TestingProviderID Foreign Keys FK_Act_Other_TestingProviderID_Person_ID: [dbo].[Person].TestingProviderID](../../../../Images/fk.png) | TestingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Testing Provider. Link to Provider.ID. |
(2)![Foreign Keys FK_Act_Other_WhoForID_Person_ID: [dbo].[Person].WhoForID Foreign Keys FK_Act_Other_WhoForID_Person_ID: [dbo].[Person].WhoForID](../../../../Images/fk.png) | WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | Entered For Provider. Link to Provider.ID. |
 ![Foreign Keys FK_Act_Other_WhoDidItID_IDX_User_ID: [dbo].[IDX_User].WhoDidItID Foreign Keys FK_Act_Other_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 | Holds the performed date and time of the activity |
| RecordedDTTM | datetime | 8 | NOT NULL | Holds the Recorded Date and Time of the Activity |
![Check Constraints CK_Act_Other_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y') Check Constraints CK_Act_Other_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y')](../../../../Images/c-constraint.png) | HasClinicalWarningFLAG | [dbo].[BOOL] | 1 | NOT NULL | No Longer Used. |
| ClinicalDTTM | datetime | 8 | NOT NULL | Clinical Date and Time |
![Foreign Keys FK_Act_Other_ClinicalSourceDE_Source_DE_ID: [dbo].[Source_DE].ClinicalSourceDE Foreign Keys FK_Act_Other_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. |
(2)![Foreign Keys FK_Act_Other_OrderingProviderID_Person_ID: [dbo].[Person].OrderingProviderID Foreign Keys FK_Act_Other_OrderingProviderID_Person_ID: [dbo].[Person].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. |
 (7)![Foreign Keys FK_Act_Other_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Act_Other_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | numeric(16,0) | 9 | NOT NULL | Patient. Link to Person.ID |
 | ActivityType | varchar(10) | 10 | NULL allowed | Activity Type (FI - Finding, IM - Immunization) |