Tables [dbo].[Visit_Detail]
Table containing dates and providers associated with the Visit
KeyNameData TypeMax Length (Bytes)NullabilityDefaultDescription
Cluster Primary Key PK_Visit_Detail: VisitIDIndexes TWstat_Visit_Detail_AdmissionDTTM_VisitID, TWstat_Visit_Detail_AdmittingProviderID_VisitID, TWstat_Visit_Detail_AttendingProviderID_VisitID, TWstat_Visit_Detail_ConsultingProviderID_VisitID, TWstat_Visit_Detail_DischargeDTTM_VisitID, TWstat_Visit_Detail_TransferDTTM_VisitID(6)Foreign Keys FK_Visit_Detail_VisitID: [dbo].[Visit].VisitIDForeign Keys FK_Visit_Detail_VisitID_Visit_ID: [dbo].[Visit].VisitIDVisitID[dbo].[uniqueid]9NOT NULLVisit Identifier. Foreign key to Visit.ID
Indexes TWstat_Visit_Detail_AdmissionDTTM_VisitIDAdmissionDTTMdatetime8NULL allowedDate Patient Admitted
Indexes TWstat_Visit_Detail_DischargeDTTM_VisitIDDischargeDTTMdatetime8NULL allowedDate Patient Discharged
Indexes TWstat_Visit_Detail_TransferDTTM_VisitIDTransferDTTMdatetime8NULL allowedDate of Patient Transfer
Indexes TWstat_Visit_Detail_AdmittingProviderID_VisitIDForeign Keys FK_Visit_Detail_AdmittingProviderID: [dbo].[Provider].AdmittingProviderIDAdmittingProviderID[dbo].[uniqueid]9NOT NULL(0)Admitting Provider Identifier for the Visit. Foreign key to the Provider.ID
Indexes TWstat_Visit_Detail_AttendingProviderID_VisitIDForeign Keys FK_Visit_Detail_AttendingProviderID: [dbo].[Provider].AttendingProviderIDAttendingProviderID[dbo].[uniqueid]9NOT NULL(0)Attending Provider Identifier for the Visit. Foreign key to the Provider.ID
Indexes TWstat_Visit_Detail_ConsultingProviderID_VisitIDForeign Keys FK_Visit_Detail_ConsultingProviderID: [dbo].[Provider].ConsultingProviderIDConsultingProviderID[dbo].[uniqueid]9NOT NULL(0)Consulting Provider Identifier for the Visit. Foreign key to the Provider.ID
VisitNotesvarchar(7000)7000NOT NULL('')Notes pertaining to the Visit