Tables [dbo].[Patient_ImmRegistry_Log]
Immunization Registry requests per patient
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Patient_ImmRegistry_Log_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Primary Key for the Patient_ImmRegistry_Log table.
Cluster Key cix_Patient_ImmRegistry_Log: PatientIDForeign Keys FK_Patient_ImmRegistry_Log_PatientID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Key to the Person Table
RequestedDTTMdatetime8NOT NULLTime an immunization registry request was made
ResponseRcvdDTTMdatetime8NULL allowedTime an immunization registry response was received
AppointmentID[dbo].[uniqueid]9NOT NULL((0))Appointment. Link to Appointment.ID.