Tables [dbo].[Item_Allergy]
Allergy Item Parent
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_Item_Allergy_ID: IDID[dbo].[uniqueid]9NOT NULLKey to Item_Allergy Table
Indexes xak2_itemallergy_acthdrActivityHeaderID[dbo].[uniqueid]9NOT NULLActivity Header. Link to Act_Hdr_Allergy.ID
Cluster Key XAK1ItemAllergy: PatientIDIndexes TWstat_Item_Allergy_CurrentID_PatientID, TWstat_Item_Allergy_ItemType_PatientID(2)Foreign Keys FK_Item_Allergy_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient Identifier - links to dbo.Person.ID
OrderItemEXTvarchar(20)20NOT NULLExternal Order Number
Indexes TWstat_Item_Allergy_CurrentID_PatientIDCurrentIDnumeric(16,0)9NOT NULLCurrent Allergy ID - links to Allergy.ID
Foreign Keys FK_Item_Allergy_QODE_QO_DE_ID: [dbo].[QO_DE].QODEQODE[dbo].[dict_id]5NOT NULLResultable Item Dictionary ID - Links to QO_DE.ID
QODETvarchar(255)255NOT NULLResultable item Entryname
Foreign Keys FK_Item_Allergy_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DEQOMod1DE[dbo].[dict_id]5NOT NULLModifier 1 - Links to QO_Mod_DE.ID
Foreign Keys FK_Item_Allergy_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DEQOMod2DE[dbo].[dict_id]5NOT NULLModifier 2 - Links to QO_Mod_DE.ID
Foreign Keys FK_Item_Allergy_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DEQOMod3DE[dbo].[dict_id]5NOT NULLModifier 3 - Links to QO_Mod_DE.ID
QOModDETvarchar(255)255NOT NULLModifier 1 Entryname
Foreign Keys FK_Item_Allergy_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDEQOClassificationDE[dbo].[dict_id]5NOT NULLOrderable Item ID - Links to QO_Classification_DE.ID
QOClassificationDETvarchar(255)255NOT NULLOrderable Item Entryname
DocFolderIDnumeric(16,0)9NOT NULLNot Used
EntryNamevarchar(255)255NOT NULLAllergy Name
Indexes TWstat_Item_Allergy_CreateDTTMCreateDTTMdatetime8NOT NULLCreated Datetime of Entry
Indexes Portal_Item_AllergyLastUpdateDTTMdatetime8NOT NULLLast Updated Datetime of Entry
Check Constraints CK_Item_Allergy_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')HasSecurityFLAG[dbo].[BOOL]1NOT NULLSecurity FLAG (Y/N)
Check Constraints CK_Item_Allergy_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')HasAnnotationFLAG[dbo].[BOOL]1NOT NULLAnnotation Exists FLAG (Y/N)
Check Constraints CK_Item_Allergy_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y')IsAbnormalFLAG[dbo].[BOOL]1NOT NULLAbnormal FLAG (Y/N)
IsErrorFLAG[dbo].[BOOL]1NOT NULLEntered In Error FLAG (Y/N)
DetailTypechar(1)1NOT NULLOrderable Item Type
Indexes TWstat_Item_Allergy_ItemType_PatientIDCheck Constraints CK_Item_Allergy_ItemType : ([ItemType]='AL')ItemTypechar(2)2NOT NULLItem Type (EX. 'AL')
DecodedValuevarchar(255)255NOT NULLValue in normalized units
PerformedDTTMdatetime8NOT NULLPerformed Datetime of Entry
CommunitySourceIDvarchar(255)255NULL allowedOID of the Source EHR
CommunitySourceNamevarchar(255)255NULL allowedName of the Source EHR
CommunityItemIDvarchar(100)100NULL allowedinternal Allergy item ID in the Source EHR