Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (9) | ID | [dbo].[uniqueid] | 9 | NOT NULL | | Key to the Allergy Table |
(2)![Foreign Keys FK_Allergy_ItemID_Item_Allergy_ID: [dbo].[Item_Allergy].ItemID Foreign Keys FK_Allergy_ItemID_Item_Allergy_ID: [dbo].[Item_Allergy].ItemID](../../../../Images/fk.png) | ItemID | [dbo].[uniqueid] | 9 | NOT NULL | | Item. Link to Item_Allergy.ID. |
| NoteActivityID | numeric(16,0) | 9 | NOT NULL | | Note Activitry ID |
(2) | AllergenDE | [dbo].[dict_id] | 5 | NOT NULL | | Allergen. Link to Allergen_DE.ID. |
| AllergenDET | [dbo].[message] | 255 | NOT NULL | (' ') | Allergen Entryname |
| ActionTaken | [dbo].[message] | 255 | NOT NULL | (' ') | Action Taken |
 | Reaction1DE | [dbo].[dict_id] | 5 | NOT NULL | | Allergy Reaction 1. Link to Allergen_Reaction_DE.ID |
 | Reaction2DE | [dbo].[dict_id] | 5 | NOT NULL | | Allergy Reaction 2. Link to Allergen_Reaction_DE.ID |
 | Reaction3DE | [dbo].[dict_id] | 5 | NOT NULL | | Allergy Reaction 3. Link to Allergen_Reaction_DE.ID |
 | Reaction4DE | [dbo].[dict_id] | 5 | NOT NULL | | Allergy Reaction 4. Link to Allergen_Reaction_DE.ID |
 | Reaction5DE | [dbo].[dict_id] | 5 | NOT NULL | | Allergy Reaction 5. Link to Allergen_Reaction_DE.ID |
| ReactionDET | varchar(35) | 35 | NOT NULL | (' ') | Allergy Reaction Entryname |
| MedispanSymptomDE1 | [dbo].[dict_id] | 5 | NOT NULL | | Medispan symptom 1 . Link to Medispan_Symptom_DE.ID |
| MedispanSymptomCode1 | varchar(10) | 10 | NOT NULL | | Medispan symptom 1 EntryCode |
| MedispanSymptomDE2 | [dbo].[dict_id] | 5 | NOT NULL | | Medispan symptom 2 . Link to Medispan_Symptom_DE.ID |
| MedispanSymptomCode2 | varchar(10) | 10 | NOT NULL | | Medispan symptom 2 EntryCode |
| MedispanSymptomDE3 | [dbo].[dict_id] | 5 | NOT NULL | | Medispan symptom 3 . Link to Medispan_Symptom_DE.ID |
| MedispanSymptomCode3 | varchar(10) | 10 | NOT NULL | | Medispan symptom 3 EntryCode |
| MedispanSymptomCode4 | varchar(10) | 10 | NOT NULL | | Medispan symptom 4 EntryCode |
| MedispanSymptomDE4 | [dbo].[dict_id] | 5 | NOT NULL | | Medispan symptom 4 . Link to Medispan_Symptom_DE.ID |
| MedispanSymptomCode5 | varchar(10) | 10 | NOT NULL | | Medispan symptom 5 EntryCode |
| MedispanSymptomDE5 | [dbo].[dict_id] | 5 | NOT NULL | | Medispan symptom 5 . Link to Medispan_Symptom_DE.ID |
(2) | AllergyStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | Allergy Status. Link to Allergy_Status_DE.ID. |
![Check Constraints CK_Allergy_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E') Check Constraints CK_Allergy_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E')](../../../../Images/c-constraint.png) | ReasonForCreateType | char(1) | 1 | NOT NULL | | Reason for create Allowed values 'A' 'C' 'E' |
 | WhoForID | [dbo].[uniqueid] | 9 | NOT NULL | | Provider who requested to add the Allergy. Link to Person.ID |
 | WhoDidItID | [dbo].[uniqueid] | 9 | NOT NULL | | Provider who added the Allergy. Link to Person.ID |
 | RecordedDTTM | datetime | 8 | NOT NULL | | datetime allergy was added |
| ReactionFuzzyWhen | varchar(50) | 50 | NOT NULL | | Reaction Fuzzy date |
| ReactionFuzzySortAs | datetime | 8 | NULL allowed | | Reaction Date |
![Check Constraints CK_Allergy_ReactionFuzzySpecificity_FuzzyDate_Types : ([ReactionFuzzySpecificity]='F' OR [ReactionFuzzySpecificity]='Y' OR [ReactionFuzzySpecificity]='D' OR [ReactionFuzzySpecificity]='M') Check Constraints CK_Allergy_ReactionFuzzySpecificity_FuzzyDate_Types : ([ReactionFuzzySpecificity]='F' OR [ReactionFuzzySpecificity]='Y' OR [ReactionFuzzySpecificity]='D' OR [ReactionFuzzySpecificity]='M')](../../../../Images/c-constraint.png) | ReactionFuzzySpecificity | char(1) | 1 | NOT NULL | | Reaction Date Type 'D' - Date 'F' - Free Text Date |
 | AllergyCategory | varchar(255) | 255 | NOT NULL | (' ') | Allergy Category |
 ![Foreign Keys FK_Allergy_MedAllergyDE_Medication_Allergy_DE_ID: [dbo].[Medication_Allergy_DE].MedAllergyDE Foreign Keys FK_Allergy_MedAllergyDE_Medication_Allergy_DE_ID: [dbo].[Medication_Allergy_DE].MedAllergyDE](../../../../Images/fk.png) | MedAllergyDE | [dbo].[dict_id] | 5 | NOT NULL | (0) | Medication Allergy. Link to Medication_Allergy_DE.ID. |
 | MedAllergyCode | varchar(12) | 12 | NOT NULL | ('') | Medication Allergy Code |
 ![Check Constraints CK_Allergy_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y') Check Constraints CK_Allergy_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')](../../../../Images/c-constraint.png) | IsUnverifiedFLAG | [dbo].[BOOL] | 1 | NOT NULL | ('N') | Allergy is not Verified (Y/N)? |
| VerificationTaskOwnerID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Provider whom the allergy verification task is created. Link to IDX_User.ID or Team_DE.ID. |
| VerificationTaskOwnerType | char(10) | 10 | NOT NULL | ('') | Allergy verification task owner type. |