Tables [dbo].[Patient_ImmRegistry_Sent_Log]
Audit data sent to Immunization Registries
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Patient_ImmRegistry_Sent_Log_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Patient_ImmRegistry_Sent_Log table.
Cluster Key cix_Patient_ImmRegistry_Sent_Log: PatientID\ItemIDForeign Keys FK_Patient_ImmRegistry_Sent_Log_PatientID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Key to the Person Table
Cluster Key cix_Patient_ImmRegistry_Sent_Log: PatientID\ItemIDForeign Keys FK_Patient_ImmRegistry_Sent_Log_ItemID: [dbo].[Item_Immunization].ItemIDItemID[dbo].[uniqueid]9NOT NULLImmunization identifier
SentImmStatuschar(1)1NOT NULL('')Status. Contains 'A', 'D' or 'U"
CreatedDTTMdatetime8NOT NULLCreated time
UpdatedDTTMdatetime8NULL allowedUpdated time
Foreign Keys FK_Patient_ImmRegistry_Sent_Log_Registry_Region_DE: [dbo].[Registry_Region_DE].RegistryRegionDERegistryRegionDE[dbo].[dict_id]5NOT NULL((0))Registry Region. Link to Registry_Region_DE.ID
MessageStatusvarchar(max)maxNULL allowedMessage Status