Tables [dbo].[Immunization]
Versioned table of patient immunizations.
KeyNameData TypeMax Length (Bytes)NullabilityDefaultBound DefaultDescription
Cluster Primary Key PK_Immunization_ID: IDIndexes Portal_Immunization_ID_RequestedByID, TWstat_Immunization_ImmunizationStatusDE_ID, TWstat_Immunization_MedDictDE_ID, TWstat_Immunization_RouteOfAdminDE_ID, TWstat_Immunization_VaccineManufacturerDE_ID(5)ID[dbo].[uniqueid]9NOT NULLKey to the dbo.Immunization table.
Indexes NIX_Immunization_ItemID_WithIncludeColumns, NIX_Immunization_RecordedDttm_INC_ItemID(2)Foreign Keys FK_Immunization_ItemID_Item_Immunization_ID: [dbo].[Item_Immunization].ItemIDItemID[dbo].[uniqueid]9NOT NULLItem. Link to Item_Immunization.ID.
Indexes TWstat_Immunization_NoteActivityIDNoteActivityIDnumeric(16,0)9NOT NULLAudit Note. Link to Act_Hdr_Note.ID.
MedispanDE[dbo].[dict_id]5NOT NULLDictDefaultThis is no longer used. It once referenced dbo.medispan_de.id. It just defaults to 0 now.
Unused_Med_Pointernumeric(8,0)5NOT NULL(0)This is no longer used. It just defaults to 0 now.
Indexes TWstat_Immunization_BodySiteDEForeign Keys FK_Immunization_BodySiteDE_Body_Site_DE_ID: [dbo].[Body_Site_DE].BodySiteDEBodySiteDE[dbo].[dict_id]5NOT NULLBody Site. Link to Body_Site_DE.ID.
Indexes TWstat_Immunization_Lot_IDLot_IDvarchar(20)20NOT NULLThe lot # for the vaccine
BodySiteDETvarchar(255)255NOT NULL(' ')Body Site. Link to dbo.Body_Site_de.Entryname
Indexes TWstat_Immunization_RouteOfAdminDE_IDRouteOfAdminDE[dbo].[dict_id]5NOT NULLRoute of administration. Link to dbo.Route_of_Admin_de.id
Indexes TWstat_Immunization_AgeIntervalDEAgeIntervalDE[dbo].[dict_id]5NOT NULL(0)Age Interval. Link to db.Age_Interval_de.id
Indexes NIX_Immunization_AdministeredFuzzySortAs_WhoAdministeredID, NIX_Immunization_ItemID_WithIncludeColumns, NIX_Immunization_MedDictDE_Disposition_RecordedDTTM_WithIncludeColumns(3)Check Constraints CK_Immunization_Disposition_Disposition : ([Disposition]='Rpt' OR [Disposition]='Rx' OR [Disposition]='None' OR [Disposition]='DocA' OR [Disposition]='ReqA')Dispositionchar(4)4NOT NULLNone/DocA/ReqA  (none, documented administration, requested administration)
Indexes NIX_Immunization_AdministeredFuzzySortAs_WhoAdministeredID, NIX_Immunization_ItemID_WithIncludeColumns, NIX_Immunization_WhoAdministeredID_INC_AdministeredFuzzySortAs(3)AdministeredFuzzySortAsdatetime8NULL allowedDate immunization was administered
Indexes TWstat_Immunization_WhoForIDWhoForID[dbo].[uniqueid]9NOT NULLProvider the immunization is for. Link to Idx_user.id
AdministeredFuzzyWhenvarchar(50)50NOT NULL(' ')Administered date. Fuzzy date
AdministeredFuzzySpecificitychar(1)1NOT NULLAdministered date specificity (F - Fuzzy, D - Day, M - Month, Y - Year)
Indexes TWstat_Immunization_ReasonForCreateTypeCheck Constraints CK_Immunization_ReasonForCreateType_Reason_Create_Type : ([ReasonForCreateType]='A' OR [ReasonForCreateType]='C' OR [ReasonForCreateType]='E')ReasonForCreateTypechar(1)1NOT NULLCreate type. This will be A for Administration
Indexes NIX_Immunization_AdministeredFuzzySortAs_WhoAdministeredID, NIX_Immunization_WhoAdministeredID_INC_AdministeredFuzzySortAs(2)WhoAdministeredID[dbo].[uniqueid]9NOT NULLUser who administered the Immunization. Link to idx_user.id
Indexes TWstat_Immunization_WhoDidItIDWhoDidItID[dbo].[uniqueid]9NOT NULLUser who recorded the Immunization being administered. Link to idx_user.id
Indexes NIX_Immunization_AdministeredFuzzySortAs_WhoAdministeredID, NIX_Immunization_ItemID_WithIncludeColumns, NIX_Immunization_MedDictDE_Disposition_RecordedDTTM_WithIncludeColumns, NIX_Immunization_RecordedDttm_INC_ItemID, TWstat_Immunization_RecordedDTTM(5)RecordedDTTMdatetime8NOT NULLdate immunization was added to the system. We do a getdate() call.
Indexes NIX_Immunization_AdministeredFuzzySortAs_WhoAdministeredID, NIX_Immunization_ItemID_WithIncludeColumns, NIX_Immunization_ToBeDoneDTTM_StatusDE, TWstat_Immunization_ImmunizationStatusDE_ID(4)Foreign Keys FK_Immunization_Order_Status_DE: [dbo].[Order_Status_DE].ImmunizationStatusDEImmunizationStatusDE[dbo].[dict_id]5NOT NULLStatus. Link to Order_Status_DE.ID.
Indexes NIX_Immunization_AdministeredFuzzySortAs_WhoAdministeredID, NIX_Immunization_ItemID_WithIncludeColumns, TWstat_Immunization_Series(3)Seriesvarchar(20)20NOT NULLThe series of the vaccine
Indexes Portal_Immunization_ID_RequestedByID, TWstat_Immunization_RequestedByID(2)RequestedByID[dbo].[uniqueid]9NOT NULLWho requested the administration. Link to Idx_user.id
DateToAdministerdatetime8NULL allowedDate Administration is to be done.
Indexes NIX_Immunization_AdministeredFuzzySortAs_WhoAdministeredID, NIX_Immunization_ItemID_WithIncludeColumns, TWstat_Immunization_NDC(3)NDCchar(12)12NOT NULL(' ')10 digit national drug code
Indexes TWstat_Immunization_DoseDosevarchar(10)10NOT NULL(' ')The dose given, IE 2ML
Indexes TWstat_Immunization_VaccineManufacturerDE_IDForeign Keys FK_Immunization_VaccineManufacturerDE_Vaccine_Manufacturer_DE_ID: [dbo].[Vaccine_Manufacturer_DE].VaccineManufacturerDEVaccineManufacturerDEnumeric(8,0)5NOT NULL(0)Manufacturer. Link to Vaccine_Manufacturer_DE.ID
Indexes NIX_Immunization_AdministeredFuzzySortAs_WhoAdministeredID, NIX_Immunization_ItemID_WithIncludeColumns, NIX_Immunization_MedDictDE_Disposition_RecordedDTTM_WithIncludeColumns, TWstat_Immunization_MedDictDE_ID(4)Foreign Keys FK_Immunization_MedDictDE_Medication_DE_ID: [dbo].[Medication_DE].MedDictDEMedDictDE[dbo].[dict_id]5NOT NULL(0)Vaccine. Link to Medication_DE.ID
Indexes TWstat_Immunization_LastVISGivenLastVISGiven[dbo].[BOOL]1NULL allowed('N')VIS is Vaccine Information Sheet. It displays info about the immunization and warnings for the patient.  Has the user received a VIS for this immunization before?
Indexes TWstat_Immunization_LastGivenDateLastGivenDatedatetime8NOT NULL('1900-01-01')If they did receive a VIS before what was the date.
Indexes TWstat_Immunization_ConstentObtainedCheck Constraints CK_Immunization_ConstentObtained_Yes_Or_No : ([ConstentObtained]='N' OR [ConstentObtained]='Y')ConstentObtained[dbo].[BOOL]1NOT NULL('N')Did the user give Consent for this administration. This is a checkbox on the Record Administration tab in touchWorks.
Indexes TWstat_Immunization_LastObtainedLastObtaineddatetime8NOT NULL('1900-01-01')Last time Consent was obtained. So if you check the box in the application it would be the current date.
Indexes NIX_Immunization_AdministeredFuzzySortAs_WhoAdministeredID, NIX_Immunization_ItemID_WithIncludeColumns, NIX_Immunization_MedDictDE_Disposition_RecordedDTTM_WithIncludeColumns, TWstat_Immunization_VisDTTM(4)VisDTTMdatetime8NULL allowed('1900-01-01')Date on the VIS handed out
Indexes NIX_Immunization_ToBeDoneDTTM_StatusDE, TWstat_Immunization_ToBeDoneDTTM(2)ToBeDoneDTTMdatetime8NULL allowedThe date the administration should be done.
Indexes TWstat_Immunization_VIS1NameVIS1Namevarchar(255)255NULL allowedVaccine Informatuion Sheet 1 Name. Unused.
Indexes NIX_Immunization_MedDictDE_Disposition_RecordedDTTM_WithIncludeColumns, TWstat_Immunization_VIS1PublicationDate(2)VIS1PublicationDatedatetime8NULL allowedVaccine Informatuion Sheet 1 Publication Date. Unused.
Indexes TWstat_Immunization_VIS1LastPublicationDateVIS1LastPublicationDatedatetime8NULL allowedVaccine Informatuion Sheet 1 Last Publication Date. Unused.
Indexes TWstat_Immunization_VIS2NameVIS2Namevarchar(255)255NULL allowedVaccine Informatuion Sheet 2 Name. Unused.
Indexes TWstat_Immunization_VIS2ProvidedCheck Constraints CK_Immunization_VIS2Provided_Yes_Or_No : ([VIS2Provided]='N' OR [VIS2Provided]='Y')VIS2Provided[dbo].[BOOL]1NULL allowedVaccine Informatuion Sheet 2 Provided (Y/N). Unused.
Indexes NIX_Immunization_MedDictDE_Disposition_RecordedDTTM_WithIncludeColumns, TWstat_Immunization_VIS2PublicationDate(2)VIS2PublicationDatedatetime8NULL allowedVaccine Informatuion Sheet 2 Publication Date. Unused.
Indexes TWstat_Immunization_VIS2LastGivenDateVIS2LastGivenDatedatetime8NULL allowedVaccine Informatuion Sheet 3 Last Provided Date. Unused.
Indexes TWstat_Immunization_VIS2LastPublicationDateVIS2LastPublicationDatedatetime8NULL allowedVaccine Informatuion Sheet 2 Last Publication Date. Unused.
Indexes TWstat_Immunization_VIS3NameVIS3Namevarchar(255)255NULL allowedVaccine Informatuion Sheet 2 Name. Unused.
Indexes TWstat_Immunization_VIS3ProvidedCheck Constraints CK_Immunization_VIS3Provided_Yes_Or_No : ([VIS3Provided]='N' OR [VIS3Provided]='Y')VIS3Provided[dbo].[BOOL]1NULL allowedVaccine Informatuion Sheet 3 Provided (Y/N). Unused.
Indexes NIX_Immunization_MedDictDE_Disposition_RecordedDTTM_WithIncludeColumns, TWstat_Immunization_VIS3PublicationDate(2)VIS3PublicationDatedatetime8NULL allowedVaccine Informatuion Sheet 3 Publication Date. Unused.
Indexes TWstat_Immunization_VIS3LastGivenDateVIS3LastGivenDatedatetime8NULL allowedVaccine Informatuion Sheet 3 Last Provided Date. Unused.
Indexes TWstat_Immunization_VIS3LastPublicationDateVIS3LastPublicationDatedatetime8NULL allowedVaccine Informatuion Sheet 3 Last Publication Date. Unused.
Indexes TWstat_Immunization_VIS4NameVIS4Namevarchar(255)255NULL allowedVaccine Informatuion Sheet 4 Name. Unused.
Indexes TWstat_Immunization_VIS4ProvidedCheck Constraints CK_Immunization_VIS4Provided_Yes_Or_No : ([VIS4Provided]='N' OR [VIS4Provided]='Y')VIS4Provided[dbo].[BOOL]1NULL allowedVaccine Informatuion Sheet 4 Provided (Y/N). Unused.
Indexes NIX_Immunization_MedDictDE_Disposition_RecordedDTTM_WithIncludeColumns, TWstat_Immunization_VIS4PublicationDate(2)VIS4PublicationDatedatetime8NULL allowedVaccine Informatuion Sheet 3 Publication Date. Unused.
Indexes TWstat_Immunization_VIS4LastGivenDateVIS4LastGivenDatedatetime8NULL allowedVaccine Informatuion Sheet 4 Last Provided Date. Unused.
Indexes TWstat_Immunization_VIS4LastPublicationDateVIS4LastPublicationDatedatetime8NULL allowedVaccine Informatuion Sheet 4 Last Publication Date. Unused.
Indexes TWstat_Immunization_ProblemLinkListProblemLinkListvarchar(500)500NOT NULL('')A piped list of problem ids that relate to the patient. They will link to dbo.Problem_header.id
Indexes TWstat_Immunization_ALLSCRIP_SIG_CDALLSCRIP_SIG_CDchar(15)15NOT NULL('')If using one of our delivered sigs this will link to dbo.Allscrip_SIG.allscript_sig_cd
Indexes TWstat_Immunization_IsUnverifiedFLAGCheck Constraints CK_Immunization_IsUnverifiedFLAG_Yes_Or_No : ([IsUnverifiedFLAG]='N' OR [IsUnverifiedFLAG]='Y')IsUnverifiedFLAG[dbo].[BOOL]1NOT NULL('N')Unverified? Y/N
Indexes TWstat_Immunization_VerificationTaskOwnerIDVerificationTaskOwnerID[dbo].[uniqueid]9NOT NULL(0)ID of user/team who owns a task. Link to idx_user.id
Indexes TWstat_Immunization_VerificationTaskOwnerTypeVerificationTaskOwnerTypechar(10)10NOT NULL('')Type of owner. Would be U/T for user or team
Indexes TWstat_Immunization_PerformingCommentsPerformingCommentsvarchar(255)255NOT NULL('')A free text field for the provider to add a comment for the person performing the administration.
AuthorizingProviderID[dbo].[uniqueid]9NOT NULL(0)Provider that authorized the immunization. Link to dbo.Provider.ID
Indexes TWstat_Immunization_ExpirationDTExpirationDTdatetime8NULL allowedDate the immunization expires
Check Constraints CK_Immunization_PARChecked_Yes_Or_No : ([PARChecked]='N' OR [PARChecked]='Y')PARChecked[dbo].[BOOL]1NOT NULL('N')Y/N Were prior adverse reactions checked when this was given? This just means did a DUR check happen.
FreeTextPrescribervarchar(150)150NOT NULL('')text field to add prescriber name
VisuallyVerifiedByID[dbo].[uniqueid]9NOT NULL((0))provider who verified admin. Link to Provider.ID
InventoryIDvarchar(64)64NULL allowedInventory ID for Flexscan interface
Barcodevarchar(64)64NULL allowedBarcode of inventory item for Flexscan interface