Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Immunization_Forecast
Touchworks 25.2
[dbo].[Immunization_Forecast]
MS_Description
Immunization Forecast data received from registry
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Immunization_Forecast table.
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Patient_Member.ID.
CVXDE
[dbo].[dict_id]
5
NULL allowed
CVX Code. Link to CVX_DE.ID.
RegistryImmunName
[dbo].[name]
255
NULL allowed
Immunization name received from Registry
NextDate
date
3
NULL allowed
Next date of the forecast immunization
EarliestDateToGive
date
3
NULL allowed
Earliest date the immunization can be given
OverDueDate
date
3
NULL allowed
Due date of the immunization
LatestDateToGive
date
3
NULL allowed
Latest date the immunization can be given
CreatedDTTM
datetime
8
NOT NULL
(getdate())
Created date, defaulted to current time
LastUpdatedDTTM
datetime
8
NULL allowed
Updated date
SeriesStatus
varchar(50)
50
NULL allowed
Status for the Immunization Series.
Reason
varchar(255)
255
NULL allowed
Reason for the Immunization Series Status.
MessageSource
varchar(255)
255
NULL allowed
Registry Source Info - DestinationID value from inbound ImmunizationRegistryRespondedEvent message
IsInactiveFlag
bit
1
NOT NULL
((0))
Flag to determine if entry is current
PublisherMessageID
varchar(50)
50
NULL allowed
Inbound ImmunizationRegistryRespondedEvent message ID