Tables [dbo].[UnverifiedItem_Immunization]
Immunizations imported via external sources
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Key CIX_UnverifiedItem_Immunization_UnverifiedItemID: UnverifiedItemIDUnverifiedItemID[dbo].[uniqueid]9NOT NULLUnverified Item. Link to Unverified_Item.ID
AdministeredFuzzyWhenvarchar(50)50NULL allowedAdministered Date based on column AdministeredFuzzySpecificity. If 'D' then ithis column will have Day. If 'Y' then Year.. Etc
AdministeredFuzzySortAsdatetime8NULL allowedAdministered Date and Time
AdministeredFuzzySpecificitychar(1)1NULL allowedAdministered Date Specificity containing values  D - Day, Y - Year , M - Month , T - Date Time , F - Text
LotNumbervarchar(20)20NULL allowedLot Number
Seriesvarchar(20)20NULL allowedSeries
ManufacturerDE[dbo].[dict_id]5NOT NULLManufacturer. Link to Vaccine_Manufacturer_DE.ID
Dosevarchar(10)10NOT NULL('')Dose
RouteOfAdminDE[dbo].[dict_id]5NOT NULL((0))Route of Administration. Link to Route_Of_Admin_DE.ID
FreeTextPrescribervarchar(150)150NOT NULL('')Prescriber name
IsPartiallyAdministeredbit1NULL allowedHolds a Boolean value indicating whether the immunization is partially administered or not