Key | Name | Data Type | Max Length (Bytes) | Nullability | Default | Description |
---|
 (6)![Foreign Keys FK_Visit_Detail_VisitID: [dbo].[Visit].VisitID Foreign Keys FK_Visit_Detail_VisitID: [dbo].[Visit].VisitID](../../../../Images/fk.png) ![Foreign Keys FK_Visit_Detail_VisitID_Visit_ID: [dbo].[Visit].VisitID Foreign Keys FK_Visit_Detail_VisitID_Visit_ID: [dbo].[Visit].VisitID](../../../../Images/fk.png) | VisitID | [dbo].[uniqueid] | 9 | NOT NULL | | Visit Identifier. Foreign key to Visit.ID |
 | AdmissionDTTM | datetime | 8 | NULL allowed | | Date Patient Admitted |
 | DischargeDTTM | datetime | 8 | NULL allowed | | Date Patient Discharged |
 | TransferDTTM | datetime | 8 | NULL allowed | | Date of Patient Transfer |
 ![Foreign Keys FK_Visit_Detail_AdmittingProviderID: [dbo].[Provider].AdmittingProviderID Foreign Keys FK_Visit_Detail_AdmittingProviderID: [dbo].[Provider].AdmittingProviderID](../../../../Images/fk.png) | AdmittingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Admitting Provider Identifier for the Visit. Foreign key to the Provider.ID |
 ![Foreign Keys FK_Visit_Detail_AttendingProviderID: [dbo].[Provider].AttendingProviderID Foreign Keys FK_Visit_Detail_AttendingProviderID: [dbo].[Provider].AttendingProviderID](../../../../Images/fk.png) | AttendingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Attending Provider Identifier for the Visit. Foreign key to the Provider.ID |
 ![Foreign Keys FK_Visit_Detail_ConsultingProviderID: [dbo].[Provider].ConsultingProviderID Foreign Keys FK_Visit_Detail_ConsultingProviderID: [dbo].[Provider].ConsultingProviderID](../../../../Images/fk.png) | ConsultingProviderID | [dbo].[uniqueid] | 9 | NOT NULL | (0) | Consulting Provider Identifier for the Visit. Foreign key to the Provider.ID |
| VisitNotes | varchar(7000) | 7000 | NOT NULL | ('') | Notes pertaining to the Visit |