Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Item_Immunization
Touchworks 25.2
[dbo].[Item_Immunization]
MS_Description
Item Level table for Immunizations
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
ID
[dbo].[uniqueid]
9
NOT NULL
Key to the Item_Immunization table.
(2)
ActivityHeaderID
[dbo].[uniqueid]
9
NOT NULL
Activity Header. Link to dbo.Act_Hdr_Other.ID
(5)
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Link to Patient_Member.ID
OrderItemEXT
varchar(20)
20
NOT NULL
External Order Number
(3)
CurrentID
numeric(16,0)
9
NOT NULL
This points to the ID of the current version level entry of the immunization in the dbo.immunization table
QODE
[dbo].[dict_id]
5
NOT NULL
Resultable Item. Link to QO_DE.ID.
QODET
varchar(255)
255
NOT NULL
Resultable Item entryname. QO_DE.Entryname.
QOMod1DE
[dbo].[dict_id]
5
NOT NULL
Ordable Item Modifier. Link to QO_Mod_DE.ID
QOMod2DE
[dbo].[dict_id]
5
NOT NULL
Ordable Item Modifier. Link to QO_Mod_DE.ID
QOMod3DE
[dbo].[dict_id]
5
NOT NULL
Ordable Item Modifier. Link to QO_Mod_DE.ID
QOModDET
varchar(255)
255
NOT NULL
Ordable Item Modifier entryname. Link to QO_Mod_DE.Entryname
QOClassificationDE
[dbo].[dict_id]
5
NOT NULL
Orderable Item. Link to QO_Classification_DE.ID.
QOClassificationDET
varchar(255)
255
NOT NULL
Ordable Item entryname. Link to QO_Classification_DE.Entryname
DocFolderID
numeric(16,0)
9
NOT NULL
Not used, weill default to 0
EntryName
varchar(255)
255
NOT NULL
entryname of the immunization
CreateDTTM
datetime
8
NOT NULL
date immunization was added to the patient's chart
LastUpdateDTTM
datetime
8
NOT NULL
date immunization was last updated
HasSecurityFLAG
[dbo].[BOOL]
1
NOT NULL
Security? Y/N
HasAnnotationFLAG
[dbo].[BOOL]
1
NOT NULL
Annotated? Y/N
IsAbnormalFLAG
[dbo].[BOOL]
1
NOT NULL
Abnormal? Y/N
IsErrorFLAG
[dbo].[BOOL]
1
NOT NULL
Entered in Error? Y/N
DetailType
char(1)
1
NOT NULL
Detail Type I
ItemType
char(2)
2
NOT NULL
IM for Immunization
DecodedValue
varchar(255)
255
NOT NULL
Not used here, will be blank
PerformedDTTM
datetime
8
NOT NULL
Date Immunization was performed.
CommunitySourceID
varchar(255)
255
NULL allowed
OID of the Source EHR
CommunitySourceName
varchar(255)
255
NULL allowed
Name of the Source EHR
CommunityItemID
varchar(100)
100
NULL allowed
internal Immunization item ID in the Source EHR