Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | Key to Item_Allergy Table |
 | ActivityHeaderID | [dbo].[uniqueid] | 9 | NOT NULL | Activity Header. Link to Act_Hdr_Allergy.ID |
 (2)![Foreign Keys FK_Item_Allergy_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Item_Allergy_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | Patient Identifier - links to dbo.Person.ID |
| OrderItemEXT | varchar(20) | 20 | NOT NULL | External Order Number |
 | CurrentID | numeric(16,0) | 9 | NOT NULL | Current Allergy ID - links to Allergy.ID |
![Foreign Keys FK_Item_Allergy_QODE_QO_DE_ID: [dbo].[QO_DE].QODE Foreign Keys FK_Item_Allergy_QODE_QO_DE_ID: [dbo].[QO_DE].QODE](../../../../Images/fk.png) | QODE | [dbo].[dict_id] | 5 | NOT NULL | Resultable Item Dictionary ID - Links to QO_DE.ID |
| QODET | varchar(255) | 255 | NOT NULL | Resultable item Entryname |
![Foreign Keys FK_Item_Allergy_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DE Foreign Keys FK_Item_Allergy_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DE](../../../../Images/fk.png) | QOMod1DE | [dbo].[dict_id] | 5 | NOT NULL | Modifier 1 - Links to QO_Mod_DE.ID |
![Foreign Keys FK_Item_Allergy_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DE Foreign Keys FK_Item_Allergy_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DE](../../../../Images/fk.png) | QOMod2DE | [dbo].[dict_id] | 5 | NOT NULL | Modifier 2 - Links to QO_Mod_DE.ID |
![Foreign Keys FK_Item_Allergy_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DE Foreign Keys FK_Item_Allergy_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DE](../../../../Images/fk.png) | QOMod3DE | [dbo].[dict_id] | 5 | NOT NULL | Modifier 3 - Links to QO_Mod_DE.ID |
| QOModDET | varchar(255) | 255 | NOT NULL | Modifier 1 Entryname |
![Foreign Keys FK_Item_Allergy_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDE Foreign Keys FK_Item_Allergy_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDE](../../../../Images/fk.png) | QOClassificationDE | [dbo].[dict_id] | 5 | NOT NULL | Orderable Item ID - Links to QO_Classification_DE.ID |
| QOClassificationDET | varchar(255) | 255 | NOT NULL | Orderable Item Entryname |
| DocFolderID | numeric(16,0) | 9 | NOT NULL | Not Used |
| EntryName | varchar(255) | 255 | NOT NULL | Allergy Name |
 | CreateDTTM | datetime | 8 | NOT NULL | Created Datetime of Entry |
 | LastUpdateDTTM | datetime | 8 | NOT NULL | Last Updated Datetime of Entry |
![Check Constraints CK_Item_Allergy_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y') Check Constraints CK_Item_Allergy_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')](../../../../Images/c-constraint.png) | HasSecurityFLAG | [dbo].[BOOL] | 1 | NOT NULL | Security FLAG (Y/N) |
![Check Constraints CK_Item_Allergy_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y') Check Constraints CK_Item_Allergy_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')](../../../../Images/c-constraint.png) | HasAnnotationFLAG | [dbo].[BOOL] | 1 | NOT NULL | Annotation Exists FLAG (Y/N) |
![Check Constraints CK_Item_Allergy_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y') Check Constraints CK_Item_Allergy_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y')](../../../../Images/c-constraint.png) | IsAbnormalFLAG | [dbo].[BOOL] | 1 | NOT NULL | Abnormal FLAG (Y/N) |
| IsErrorFLAG | [dbo].[BOOL] | 1 | NOT NULL | Entered In Error FLAG (Y/N) |
| DetailType | char(1) | 1 | NOT NULL | Orderable Item Type |
 ![Check Constraints CK_Item_Allergy_ItemType : ([ItemType]='AL') Check Constraints CK_Item_Allergy_ItemType : ([ItemType]='AL')](../../../../Images/c-constraint.png) | ItemType | char(2) | 2 | NOT NULL | Item Type (EX. 'AL') |
| DecodedValue | varchar(255) | 255 | NOT NULL | Value in normalized units |
| PerformedDTTM | datetime | 8 | NOT NULL | Performed Datetime of Entry |
| CommunitySourceID | varchar(255) | 255 | NULL allowed | OID of the Source EHR |
| CommunitySourceName | varchar(255) | 255 | NULL allowed | Name of the Source EHR |
| CommunityItemID | varchar(100) | 100 | NULL allowed | internal Allergy item ID in the Source EHR |