Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_ImmRegistry_Sent_Log
Touchworks 25.2
[dbo].[Patient_ImmRegistry_Sent_Log]
MS_Description
Audit data sent to Immunization Registries
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Key to the Patient_ImmRegistry_Sent_Log table.
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Key to the Person Table
ItemID
[dbo].[uniqueid]
9
NOT NULL
Immunization identifier
SentImmStatus
char(1)
1
NOT NULL
('')
Status. Contains 'A', 'D' or 'U"
CreatedDTTM
datetime
8
NOT NULL
Created time
UpdatedDTTM
datetime
8
NULL allowed
Updated time
RegistryRegionDE
[dbo].[dict_id]
5
NOT NULL
((0))
Registry Region. Link to Registry_Region_DE.ID
MessageStatus
varchar(max)
max
NULL allowed
Message Status