Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.UnverifiedItem_Immunization
Touchworks 25.2
[dbo].[UnverifiedItem_Immunization]
MS_Description
Immunizations imported via external sources
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Default
Description
UnverifiedItemID
[dbo].[uniqueid]
9
NOT NULL
Unverified Item. Link to Unverified_Item.ID
AdministeredFuzzyWhen
varchar(50)
50
NULL allowed
Administered Date based on column AdministeredFuzzySpecificity. If 'D' then ithis column will have Day. If 'Y' then Year.. Etc
AdministeredFuzzySortAs
datetime
8
NULL allowed
Administered Date and Time
AdministeredFuzzySpecificity
char(1)
1
NULL allowed
Administered Date Specificity containing values D - Day, Y - Year , M - Month , T - Date Time , F - Text
LotNumber
varchar(20)
20
NULL allowed
Lot Number
Series
varchar(20)
20
NULL allowed
Series
ManufacturerDE
[dbo].[dict_id]
5
NOT NULL
Manufacturer. Link to Vaccine_Manufacturer_DE.ID
Dose
varchar(10)
10
NOT NULL
('')
Dose
RouteOfAdminDE
[dbo].[dict_id]
5
NOT NULL
((0))
Route of Administration. Link to Route_Of_Admin_DE.ID
FreeTextPrescriber
varchar(150)
150
NOT NULL
('')
Prescriber name
IsPartiallyAdministered
bit
1
NULL allowed
Holds a Boolean value indicating whether the immunization is partially administered or not