Tables [dbo].[Immunization_Forecast]
Immunization Forecast data received from registry
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Immunization_Forecast_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Immunization_Forecast table.
Indexes NIX_Immunization_Forecast_PatientIDForeign Keys FK_Immunization_Forecast_Patient_Member: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Patient_Member.ID.
CVXDE[dbo].[dict_id]5NULL allowedCVX Code. Link to CVX_DE.ID.
RegistryImmunName[dbo].[name]255NULL allowedImmunization name received from Registry
NextDatedate3NULL allowedNext date of the forecast immunization
EarliestDateToGivedate3NULL allowedEarliest date the immunization can be given
OverDueDatedate3NULL allowedDue date of the immunization
LatestDateToGivedate3NULL allowedLatest date  the immunization can be given
CreatedDTTMdatetime8NOT NULL(getdate())Created date, defaulted to current time
LastUpdatedDTTMdatetime8NULL allowedUpdated date
SeriesStatusvarchar(50)50NULL allowedStatus for the Immunization Series.
Reasonvarchar(255)255NULL allowedReason for the Immunization Series Status.
MessageSourcevarchar(255)255NULL allowedRegistry Source Info - DestinationID value from inbound ImmunizationRegistryRespondedEvent message
IsInactiveFlagbit1NOT NULL((0))Flag to determine if entry is current
PublisherMessageIDvarchar(50)50NULL allowedInbound ImmunizationRegistryRespondedEvent message ID