Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to the Act_Allergy table |
 ![Foreign Keys FK_Act_Allergy_ActivityHeaderID_Act_Hdr_Allergy_ID: [dbo].[Act_Hdr_Allergy].ActivityHeaderID Foreign Keys FK_Act_Allergy_ActivityHeaderID_Act_Hdr_Allergy_ID: [dbo].[Act_Hdr_Allergy].ActivityHeaderID](../../../../Images/fk.png) | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | Allergy Activity Header ID. Link to Act_Hdr_Allergy.ID. |
 ![Foreign Keys FK_Act_Allergy_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationID Foreign Keys FK_Act_Allergy_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationID](../../../../Images/fk.png) | OrganizationID | numeric(8,0) | 5 | NOT NULL | Organization ID. Link to Organization.ID. |
![Foreign Keys FK_Act_Allergy_NoteTypeDE_Note_Type_DE_ID: [dbo].[Note_Type_DE].NoteTypeDE Foreign Keys FK_Act_Allergy_NoteTypeDE_Note_Type_DE_ID: [dbo].[Note_Type_DE].NoteTypeDE](../../../../Images/fk.png) ![Foreign Keys FK_Act_Allergy_NoteTypeDE_TemplateVersion_Note_Template_Version_NoteTypeDE_TemplateVersion: [dbo].[Note_Template_Version].NoteTypeDE\TemplateVersion Foreign Keys FK_Act_Allergy_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. |
![Foreign Keys FK_Act_Allergy_NoteTypeDE_TemplateVersion_Note_Template_Version_NoteTypeDE_TemplateVersion: [dbo].[Note_Template_Version].NoteTypeDE\TemplateVersion Foreign Keys FK_Act_Allergy_NoteTypeDE_TemplateVersion_Note_Template_Version_NoteTypeDE_TemplateVersion: [dbo].[Note_Template_Version].NoteTypeDE\TemplateVersion](../../../../Images/fk.png) | TemplateVersion | smallint | 2 | NOT NULL | Not Used. Link to Note_Template_Version.ID. |
| EpisodeID | [dbo].[uniqueid] | 9 | NOT NULL | Not Used |
| CarePlanDE | [dbo].[dict_id] | 5 | NOT NULL | Care Plan. Link to Care_Plan_DE.ID. |
![Foreign Keys FK_Act_Allergy_OrderSourceDE_Order_Source_DE_ID: [dbo].[Order_Source_DE].OrderSourceDE Foreign Keys FK_Act_Allergy_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. |
| OrderNumberEXT | varchar(20) | 20 | NOT NULL | External Order Number |
| FUComment | [dbo].[message] | 255 | NOT NULL | Not used |
 | AccessionNumber | varchar(255) | 255 | NOT NULL | Accession Number |
 | InterfaceSourceID | smallint | 2 | NOT NULL | Interface Source ID |
![Foreign Keys FK_Act_Allergy_TestingProviderID_Provider_ID: [dbo].[Provider].TestingProviderID Foreign Keys FK_Act_Allergy_TestingProviderID_Provider_ID: [dbo].[Provider].TestingProviderID](../../../../Images/fk.png) | TestingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Testing Provider ID. Always 0 |
![Foreign Keys FK_Act_Allergy_WhoForID_Provider_ID: [dbo].[Provider].WhoForID Foreign Keys FK_Act_Allergy_WhoForID_Provider_ID: [dbo].[Provider].WhoForID](../../../../Images/fk.png) | WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | Provider who requested to add the Allergy into the patient Chart. Link to Person.ID. |
![Foreign Keys FK_Act_Allergy_WhoDidItID_IDX_User_ID: [dbo].[IDX_User].WhoDidItID Foreign Keys FK_Act_Allergy_WhoDidItID_IDX_User_ID: [dbo].[IDX_User].WhoDidItID](../../../../Images/fk.png) | WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | Provider who added the Allergy into the patient Chart. Link to IDX_User.ID. |
| PerformedDTTM | datetime | 8 | NOT NULL | Datetime Allergy was added |
| RecordedDTTM | datetime | 8 | NOT NULL | Datetime the details are added in Act_Allergy table. |
![Check Constraints CK_Act_Allergy_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y') Check Constraints CK_Act_Allergy_HasClinicalWarningFLAG_Yes_Or_No : ([HasClinicalWarningFLAG]='N' OR [HasClinicalWarningFLAG]='Y')](../../../../Images/c-constraint.png) | HasClinicalWarningFLAG | [dbo].[BOOL] | 1 | NOT NULL | Has Clinical Warning ? Always 'N' |
| ClinicalDTTM | datetime | 8 | NOT NULL | Datetime Allergy was added |
![Foreign Keys FK_Act_Allergy_ClinicalSourceDE_Source_DE_ID: [dbo].[Source_DE].ClinicalSourceDE Foreign Keys FK_Act_Allergy_ClinicalSourceDE_Source_DE_ID: [dbo].[Source_DE].ClinicalSourceDE](../../../../Images/fk.png) | ClinicalSourceDE | [dbo].[dict_id] | 5 | NOT NULL | Clinical Source. Always 0 |
![Foreign Keys FK_Act_Allergy_OrderingProviderID_Provider_ID: [dbo].[Provider].OrderingProviderID Foreign Keys FK_Act_Allergy_OrderingProviderID_Provider_ID: [dbo].[Provider].OrderingProviderID](../../../../Images/fk.png) | OrderingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | Provider who requested to add the Allergy into the patient Chart. Link to Person.ID. |
| OrderingProviderName | [dbo].[name] | 255 | NOT NULL | Ordering Provider Name |
  ![Foreign Keys FK_Act_Allergy_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Act_Allergy_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | numeric(16,0) | 9 | NOT NULL | Patient. Link to Person.ID. |
 ![Check Constraints CK_Act_Allergy_ActivityType : ([ActivityType]='Al') Check Constraints CK_Act_Allergy_ActivityType : ([ActivityType]='Al')](../../../../Images/c-constraint.png) | ActivityType | varchar(10) | 10 | NULL allowed | Activity Type. 'AL' |