Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Evaluated_Immunization_History
Touchworks 25.2
[dbo].[Evaluated_Immunization_History]
MS_Description
Evaluated Immunization History 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 Evaluated_Immunization_History table
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Patient_Member.ID.
ItemID
[dbo].[uniqueid]
9
NULL allowed
Immunization Item. link to Item_Immunization.ID.
UnverifiedItemID
[dbo].[uniqueid]
9
NULL allowed
Unverified Item. Link to Unverified_Item.ID.
CVXDE
[dbo].[dict_id]
5
NULL allowed
CVX Code. Link to CVX_DE.ID.
ValidDose
varchar(1)
1
NULL allowed
Valid Dose? Data will be either Y or N
ValidityReason
varchar(150)
150
NULL allowed
Reason Text
OrdinalPositionInPrimarySeries
int
4
NULL allowed
Ordinal Position In Primary Series
NumberOfDosesInPrimarySeries
int
4
NULL allowed
Number Of Doses In Primary Series
SeriesStatus
varchar(20)
20
NULL allowed
Status
Schedule
varchar(50)
50
NULL allowed
Schedule Name, for example : ACIP
IsInActiveFlag
[dbo].[BOOL]
1
NULL allowed
('N')
Inactive (Y/N)
CreatedDTTM
datetime
8
NOT NULL
(getdate())
Created date, defaulted to current date/time
LastUpdatedDTTM
datetime
8
NULL allowed
Updated date