Tables [dbo].[Evaluated_Immunization_History]
Evaluated Immunization History data received from registry
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Evaluated_Immunization_History_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Evaluated_Immunization_History table
Indexes NIX_Evaluated_Immunization_History_PatientIDForeign Keys FK_Evaluated_Immunization_History_Patient_Member: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID.
ItemID[dbo].[uniqueid]9NULL allowedImmunization Item. link to Item_Immunization.ID.
Indexes NIX_Evaluated_Immunization_History_UnverifiedItemIDForeign Keys FK_Evaluated_Immunization_History_Unverified_Item: [dbo].[Unverified_Item].UnverifiedItemIDUnverifiedItemID[dbo].[uniqueid]9NULL allowedUnverified Item. Link to Unverified_Item.ID.
Foreign Keys FK_Evaluated_Immunization_History_CVX_DE: [dbo].[CVX_DE].CVXDECVXDE[dbo].[dict_id]5NULL allowedCVX Code. Link to CVX_DE.ID.
ValidDosevarchar(1)1NULL allowedValid Dose? Data will be either Y or N
ValidityReasonvarchar(150)150NULL allowedReason Text
OrdinalPositionInPrimarySeriesint4NULL allowedOrdinal Position In Primary Series
NumberOfDosesInPrimarySeriesint4NULL allowedNumber Of Doses In Primary Series
SeriesStatusvarchar(20)20NULL allowedStatus
Schedulevarchar(50)50NULL allowedSchedule Name, for example : ACIP
IsInActiveFlag[dbo].[BOOL]1NULL allowed('N')Inactive (Y/N)
CreatedDTTMdatetime8NOT NULL(getdate())Created date, defaulted to current date/time
LastUpdatedDTTMdatetime8NULL allowedUpdated date