Tables [dbo].[Patient_Alert_Deferral]
Deferred Patient Alert from Patient Query
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Patient_Alert_Deferral_PatientID_QueryID: PatientID\QueryIDIndexes XA1_Patient_Alert_DefForeign Keys FK_Patient_Alert_Deferral_PatientID_Person_ID: [dbo].[Person].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient ID. Link to Person.ID
Cluster Primary Key PK_Patient_Alert_Deferral_PatientID_QueryID: PatientID\QueryIDIndexes XA1_Patient_Alert_DefForeign Keys FK_Patient_Alert_Deferral_QueryID_Query_ID: [dbo].[Query].QueryIDQueryID[dbo].[uniqueid]9NOT NULLQuery. Link to Query.ID
StartDTTMdatetime8NOT NULLStart Date and Time
EndDTTMdatetime8NOT NULLEnd Date and Time
UserID[dbo].[uniqueid]9NOT NULLUser. Link to IDX_User.ID
DeferralReasonvarchar(255)255NOT NULLAlert Deferred Reason