Tables [dbo].[Item_Immunization]
Item Level table for Immunizations
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Primary Key PK_Item_Immunization_ID: IDIndexes Portal_Item_Immunization_LastUpdateDTTM_CurrentID_ID_PatientIDID[dbo].[uniqueid]9NOT NULLKey to the Item_Immunization table.
Indexes xak2_itemimmunization_acthdr, NIX_Item_Immunization_CurrentID_INC_ActivityHeaderID(2)ActivityHeaderID[dbo].[uniqueid]9NOT NULLActivity Header. Link to dbo.Act_Hdr_Other.ID
Cluster Key XAK1ItemImmun: PatientIDIndexes Portal_Item_Immunization_LastUpdateDTTM_CurrentID_ID_PatientID, TWstat_Item_Immunization_CurrentID_PatientID, TWstat_Item_Immunization_IsErrorFLAG_PatientID, TWstat_Item_Immunization_ItemType_PatientID, TWstat_Item_Immunization_PerformedDTTM_PatientID(5)Foreign Keys FK_Item_Immunization_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID
OrderItemEXTvarchar(20)20NOT NULLExternal Order Number
Indexes NIX_Item_Immunization_CurrentID_INC_ActivityHeaderID, Portal_Item_Immunization_LastUpdateDTTM_CurrentID_ID_PatientID, TWstat_Item_Immunization_CurrentID_PatientID(3)CurrentIDnumeric(16,0)9NOT NULLThis points to the ID of the current version level entry of the immunization in the dbo.immunization table
Foreign Keys FK_Item_Immunization_QODE_QO_DE_ID: [dbo].[QO_DE].QODEQODE[dbo].[dict_id]5NOT NULLResultable Item. Link to QO_DE.ID.
QODETvarchar(255)255NOT NULLResultable Item entryname. QO_DE.Entryname.
Indexes TWstat_Item_Immunization_QOMod1DEForeign Keys FK_Item_Immunization_QOMod1DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod1DEQOMod1DE[dbo].[dict_id]5NOT NULLOrdable Item Modifier. Link to QO_Mod_DE.ID
Indexes TWstat_Item_Immunization_QOMod2DEForeign Keys FK_Item_Immunization_QOMod2DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod2DEQOMod2DE[dbo].[dict_id]5NOT NULLOrdable Item Modifier. Link to QO_Mod_DE.ID
Indexes TWstat_Item_Immunization_QOMod3DEForeign Keys FK_Item_Immunization_QOMod3DE_QO_Mod_DE_ID: [dbo].[QO_Mod_DE].QOMod3DEQOMod3DE[dbo].[dict_id]5NOT NULLOrdable Item Modifier. Link to QO_Mod_DE.ID
QOModDETvarchar(255)255NOT NULLOrdable Item Modifier entryname. Link to QO_Mod_DE.Entryname
Foreign Keys FK_Item_Immunization_QOClassificationDE_QO_Classification_DE_ID: [dbo].[QO_Classification_DE].QOClassificationDEQOClassificationDE[dbo].[dict_id]5NOT NULLOrderable Item. Link to QO_Classification_DE.ID.
QOClassificationDETvarchar(255)255NOT NULLOrdable Item entryname. Link to QO_Classification_DE.Entryname
DocFolderIDnumeric(16,0)9NOT NULLNot used, weill default to 0
EntryNamevarchar(255)255NOT NULLentryname of the immunization
Indexes TWstat_Item_Immunization_CreateDTTMCreateDTTMdatetime8NOT NULLdate immunization was added to the patient's chart
Indexes Portal_Item_Immunization_LastUpdateDTTM_CurrentID_ID_PatientIDLastUpdateDTTMdatetime8NOT NULLdate immunization was last updated
Check Constraints CK_Item_Immunization_HasSecurityFLAG_Yes_Or_No : ([HasSecurityFLAG]='N' OR [HasSecurityFLAG]='Y')HasSecurityFLAG[dbo].[BOOL]1NOT NULLSecurity? Y/N
Check Constraints CK_Item_Immunization_HasAnnotationFLAG_Yes_Or_No : ([HasAnnotationFLAG]='N' OR [HasAnnotationFLAG]='Y')HasAnnotationFLAG[dbo].[BOOL]1NOT NULLAnnotated? Y/N
Check Constraints CK_Item_Immunization_IsAbnormalFLAG_Yes_Or_No : ([IsAbnormalFLAG]='N' OR [IsAbnormalFLAG]='Y')IsAbnormalFLAG[dbo].[BOOL]1NOT NULLAbnormal? Y/N
Indexes TWstat_Item_Immunization_IsErrorFLAG_PatientIDIsErrorFLAG[dbo].[BOOL]1NOT NULLEntered in Error? Y/N
DetailTypechar(1)1NOT NULLDetail Type I
Indexes TWstat_Item_Immunization_ItemType_PatientIDCheck Constraints CK_Item_Immunization_ItemType : ([ItemType]='IM')ItemTypechar(2)2NOT NULLIM for Immunization
DecodedValuevarchar(255)255NOT NULLNot used here, will be blank
Indexes TWstat_Item_Immunization_PerformedDTTM_PatientIDPerformedDTTMdatetime8NOT NULLDate Immunization was performed.
CommunitySourceIDvarchar(255)255NULL allowedOID of the Source EHR
CommunitySourceNamevarchar(255)255NULL allowedName of the Source EHR
CommunityItemIDvarchar(100)100NULL allowedinternal Immunization item ID in the Source EHR