Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.Patient_ImmRegistry_Log
Touchworks 25.2
[dbo].[Patient_ImmRegistry_Log]
MS_Description
Immunization Registry requests per patient
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Identity
Default
Description
ID
[dbo].[uniqueid]
9
NOT NULL
1 - 1
Primary Key for the Patient_ImmRegistry_Log table.
PatientID
[dbo].[uniqueid]
9
NOT NULL
Patient. Key to the Person Table
RequestedDTTM
datetime
8
NOT NULL
Time an immunization registry request was made
ResponseRcvdDTTM
datetime
8
NULL allowed
Time an immunization registry response was received
AppointmentID
[dbo].[uniqueid]
9
NOT NULL
((0))
Appointment. Link to Appointment.ID.