Tables [dbo].[Allergy]
Allergy Instance
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Allergy_ID: IDIndexes TWstat_Allergy_AllergenDE_ID, TWstat_Allergy_AllergyStatusDE_ID, TWstat_Allergy_MedAllergyCode_ID, TWstat_Allergy_MedAllergyDE_ID, TWstat_Allergy_Reaction1DE_ID, TWstat_Allergy_Reaction2DE_ID, TWstat_Allergy_Reaction3DE_ID, TWstat_Allergy_Reaction4DE_ID, TWstat_Allergy_Reaction5DE_ID(9)ID[dbo].[uniqueid]9NOT NULLKey to the Allergy Table
Indexes NIX_Allergy_ItemID, NIX_Allergy_RecordedDttm_INC_ItemID(2)Foreign Keys FK_Allergy_ItemID_Item_Allergy_ID: [dbo].[Item_Allergy].ItemIDItemID[dbo].[uniqueid]9NOT NULLItem. Link to Item_Allergy.ID.
NoteActivityIDnumeric(16,0)9NOT NULLNote Activitry ID
Indexes NIX_Allergy_AllergenDE_AllergyStatusDE, TWstat_Allergy_AllergenDE_ID(2)AllergenDE[dbo].[dict_id]5NOT NULLAllergen. Link to Allergen_DE.ID.
AllergenDET[dbo].[message]255NOT NULL(' ')Allergen Entryname
ActionTaken[dbo].[message]255NOT NULL(' ')Action Taken
Indexes TWstat_Allergy_Reaction1DE_IDReaction1DE[dbo].[dict_id]5NOT NULLAllergy Reaction 1. Link to Allergen_Reaction_DE.ID
Indexes TWstat_Allergy_Reaction2DE_IDReaction2DE[dbo].[dict_id]5NOT NULLAllergy Reaction 2. Link to Allergen_Reaction_DE.ID
Indexes TWstat_Allergy_Reaction3DE_IDReaction3DE[dbo].[dict_id]5NOT NULLAllergy Reaction 3. Link to Allergen_Reaction_DE.ID
Indexes TWstat_Allergy_Reaction4DE_IDReaction4DE[dbo].[dict_id]5NOT NULLAllergy Reaction 4. Link to Allergen_Reaction_DE.ID
Indexes TWstat_Allergy_Reaction5DE_IDReaction5DE[dbo].[dict_id]5NOT NULLAllergy Reaction 5. Link to Allergen_Reaction_DE.ID
ReactionDETvarchar(35)35NOT NULL(' ')Allergy Reaction Entryname
MedispanSymptomDE1[dbo].[dict_id]5NOT NULLMedispan symptom 1 . Link to Medispan_Symptom_DE.ID
MedispanSymptomCode1varchar(10)10NOT NULLMedispan symptom 1 EntryCode
MedispanSymptomDE2[dbo].[dict_id]5NOT NULLMedispan symptom 2 . Link to Medispan_Symptom_DE.ID
MedispanSymptomCode2varchar(10)10NOT NULLMedispan symptom 2 EntryCode
MedispanSymptomDE3[dbo].[dict_id]5NOT NULLMedispan symptom 3 . Link to Medispan_Symptom_DE.ID
MedispanSymptomCode3varchar(10)10NOT NULLMedispan symptom 3 EntryCode
MedispanSymptomCode4varchar(10)10NOT NULLMedispan symptom 4 EntryCode
MedispanSymptomDE4[dbo].[dict_id]5NOT NULLMedispan symptom 4 . Link to Medispan_Symptom_DE.ID
MedispanSymptomCode5varchar(10)10NOT NULLMedispan symptom 5 EntryCode
MedispanSymptomDE5[dbo].[dict_id]5NOT NULLMedispan symptom 5 . Link to Medispan_Symptom_DE.ID
Indexes NIX_Allergy_AllergenDE_AllergyStatusDE, TWstat_Allergy_AllergyStatusDE_ID(2)AllergyStatusDE[dbo].[dict_id]5NOT NULLAllergy Status. Link to Allergy_Status_DE.ID.
Check Constraints CK_Allergy_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E')ReasonForCreateTypechar(1)1NOT NULLReason for create
         Allowed values
                 'A'
                  'C'
                  'E'
Indexes TWstat_Allergy_WhoForIDWhoForID[dbo].[uniqueid]9NOT NULLProvider who requested to add the Allergy.  Link to Person.ID
Indexes TWstat_Allergy_WhoDidItIDWhoDidItID[dbo].[uniqueid]9NOT NULLProvider who added the Allergy.  Link to  Person.ID
Indexes NIX_Allergy_RecordedDttm_INC_ItemIDRecordedDTTMdatetime8NOT NULLdatetime allergy was added
ReactionFuzzyWhenvarchar(50)50NOT NULLReaction Fuzzy date
ReactionFuzzySortAsdatetime8NULL allowedReaction Date
Check Constraints CK_Allergy_ReactionFuzzySpecificity_FuzzyDate_Types : ([ReactionFuzzySpecificity]='F' OR [ReactionFuzzySpecificity]='Y' OR [ReactionFuzzySpecificity]='D' OR [ReactionFuzzySpecificity]='M')ReactionFuzzySpecificitychar(1)1NOT NULLReaction Date Type
 'D' - Date
 'F' - Free Text Date
Indexes TWstat_Allergy_AllergyCategoryAllergyCategoryvarchar(255)255NOT NULL(' ')Allergy Category
Indexes TWstat_Allergy_MedAllergyDE_IDForeign Keys FK_Allergy_MedAllergyDE_Medication_Allergy_DE_ID: [dbo].[Medication_Allergy_DE].MedAllergyDEMedAllergyDE[dbo].[dict_id]5NOT NULL(0)Medication Allergy. Link to Medication_Allergy_DE.ID.
Indexes TWstat_Allergy_MedAllergyCode_IDMedAllergyCodevarchar(12)12NOT NULL('')Medication Allergy Code
Indexes TWstat_Allergy_IsUnverifiedFLAGCheck Constraints CK_Allergy_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')IsUnverifiedFLAG[dbo].[BOOL]1NOT NULL('N')Allergy is not Verified (Y/N)?
VerificationTaskOwnerID[dbo].[uniqueid]9NOT NULL(0)Provider whom the allergy verification task is created. Link to IDX_User.ID or Team_DE.ID.
VerificationTaskOwnerTypechar(10)10NOT NULL('')Allergy verification task owner type.