Tables [dbo].[Visit]
Visit. A visit is the parent of an encounter.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_Visit_ID: IDID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Visit table.
ReferralID[dbo].[uniqueid]9NOT NULLNot used
Indexes TWstat_Visit_EpisodeID_VisitNumberEXTEpisodeID[dbo].[uniqueid]9NOT NULLNot Used
Indexes TWstat_Visit_ArrivedByID_VisitNumberEXTForeign Keys FK_Visit_ArrivedByID_IDX_User_ID: [dbo].[IDX_User].ArrivedByIDArrivedByID[dbo].[uniqueid]9NOT NULLArrived by user. Link to IDX_User.ID
Indexes TWstat_Visit_CourtesyCodeDE_VisitNumberEXTForeign Keys FK_Visit_CourtesyCodeDE_Courtesy_Code_DE_ID: [dbo].[Courtesy_Code_DE].CourtesyCodeDECourtesyCodeDE[dbo].[dict_id]5NOT NULLCourtesy code. Not used. Courtesy_Code_DE.ID
Indexes TWstat_Visit_ProductLineDE_VisitNumberEXTForeign Keys FK_Visit_ProductLineDE_Product_Line_DE_ID: [dbo].[Product_Line_DE].ProductLineDEProductLineDE[dbo].[dict_id]5NOT NULLProduct Line. Not Used. Link to Product_Line_DE.ID
Indexes TWstat_Visit_ProgramDE_VisitNumberEXTForeign Keys FK_Visit_ProgramDE_Program_DE_ID: [dbo].[Program_DE].ProgramDEProgramDE[dbo].[dict_id]5NOT NULLProgram. Not Used. Link to Program_DE.ID
Indexes TWstat_Visit_VIPTypeDE_VisitNumberEXTForeign Keys FK_Visit_VIPTypeDE_VIP_Type_DE_ID: [dbo].[VIP_Type_DE].VIPTypeDEVIPTypeDE[dbo].[dict_id]5NOT NULLVIP (Very Important Person) type. Link to VIP_Type_DE.ID
Indexes NIX_Visit_PatientID_WithIncludeColumns, TWstat_Visit_VisitTypeDE_VisitNumberEXT(2)Foreign Keys FK_Visit_VisitTypeDE_Visit_Type_DE_ID: [dbo].[Visit_Type_DE].VisitTypeDEVisitTypeDE[dbo].[dict_id]5NOT NULLVisit Type. Link to Visit_Type_DE.ID
Indexes TWstat_Visit_ArrivalModeDE_VisitNumberEXTForeign Keys FK_Visit_ArrivalModeDE_Arrival_Mode_DE_ID: [dbo].[Arrival_Mode_DE].ArrivalModeDEArrivalModeDE[dbo].[dict_id]5NOT NULLArrival Mode. Not Used. Link to Arrival_Mode_DE.ID
Indexes TWstat_Visit_InjuryInformationID_VisitNumberEXTInjuryInformationID[dbo].[uniqueid]9NOT NULLInjury Information. Link to Injury_Information.ID.
Indexes NIX_Visit_OrganizationID_PatientID_WithIncludeColumns, NIX_Visit_PatientID_WithIncludeColumns, TWstat_Visit_StartDTTM_VisitNumberEXT(3)StartDTTMdatetime8NULL allowedStart date and time of the visit.
Indexes TWstat_Visit_EndDTTM_VisitNumberEXTEndDTTMdatetime8NULL allowedEnd date and time of the visit
Indexes NIX_Visit_PatientID_WithIncludeColumns, NIX_Visit_VisitNumberEXT, TWstat_Visit_ArrivalModeDE_VisitNumberEXT, TWstat_Visit_ArrivedByID_VisitNumberEXT, TWstat_Visit_BillingAreaDE_VisitNumberEXT, TWstat_Visit_BillingLocationDE_VisitNumberEXT, TWstat_Visit_CourtesyCodeDE_VisitNumberEXT, TWstat_Visit_DivisionDE_VisitNumberEXT, TWstat_Visit_EndDTTM_VisitNumberEXT, TWstat_Visit_EpisodeID_VisitNumberEXT, TWstat_Visit_HospitalOrgID_VisitNumberEXT, TWstat_Visit_InjuryInformationID_VisitNumberEXT, TWstat_Visit_InterfaceSourceID_VisitNumberEXT, TWstat_Visit_LocationDE_VisitNumberEXT, TWstat_Visit_MotherVisitID_VisitNumberEXT, TWstat_Visit_OptionalField1_VisitNumberEXT, TWstat_Visit_OptionalField2_VisitNumberEXT, TWstat_Visit_OptionalField3_VisitNumberEXT, TWstat_Visit_OptionalField4_VisitNumberEXT, TWstat_Visit_OptionalField5_VisitNumberEXT, TWstat_Visit_OrganizationID_VisitNumberEXT, TWstat_Visit_PrimaryInsuranceDE_VisitNumberEXT, TWstat_Visit_PrimaryProviderID_VisitNumberEXT, TWstat_Visit_ProductLineDE_VisitNumberEXT, TWstat_Visit_ProgramDE_VisitNumberEXT, TWstat_Visit_ReferringProvider_VisitNumberEXT, TWstat_Visit_ReferringProvider3DE_VisitNumberEXT, TWstat_Visit_ReferringProviderID_VisitNumberEXT, TWstat_Visit_RoomNumber_VisitNumberEXT, TWstat_Visit_SecondaryInsuranceDE_VisitNumberEXT, TWstat_Visit_StartDTTM_VisitNumberEXT, TWstat_Visit_TerciaryInsuranceDE_VisitNumberEXT, TWstat_Visit_VIPTypeDE_VisitNumberEXT, TWstat_Visit_VisitStatusDE_VisitNumberEXT, TWstat_Visit_VisitTypeDE_VisitNumberEXT(35)VisitNumberEXTvarchar(40)40NOT NULLExternal visit number
Indexes TWstat_Visit_InterfaceSourceID_VisitNumberEXTInterfaceSourceIDsmallint2NOT NULLSource of the visit. This is 0 for visits created within Touchworks or and interface identifier.
Indexes NIX_Visit_OrganizationID_PatientID_WithIncludeColumns, TWstat_Visit_OrganizationID_VisitNumberEXT(2)Foreign Keys FK_Visit_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationIDOrganizationIDnumeric(8,0)5NOT NULLOrganization. Link to Organization.ID
Indexes NIX_Visit_MotherVisitID, TWstat_Visit_MotherVisitID_VisitNumberEXT(2)Foreign Keys FK_Visit_MotherVisitID_Visit_ID: [dbo].[Visit].MotherVisitIDMotherVisitID[dbo].[uniqueid]9NOT NULLVisit for the mother if this visit is a maternity visit. Link to Visit.ID
Indexes NIX_Visit_PatientID_WithIncludeColumns, TWstat_Visit_VisitStatusDE_VisitNumberEXT(2)Foreign Keys FK_Visit_VisitStatusDE_Visit_Status_DE_ID: [dbo].[Visit_Status_DE].VisitStatusDEVisitStatusDE[dbo].[dict_id]5NOT NULLVisit Status. Link to Visit_Status_DE.ID
Indexes NIX_Visit_OrganizationID_PatientID_WithIncludeColumns, NIX_Visit_PatientID_WithIncludeColumns(2)Foreign Keys FK_Visit_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Link to Person.ID
Indexes NIX_Visit_PatientID_WithIncludeColumns, TWstat_Visit_PrimaryProviderID_VisitNumberEXT(2)PrimaryProviderID[dbo].[uniqueid]9NOT NULLPrimary Provider. Link to Provider.ID
PatientCaseID[dbo].[uniqueid]9NOT NULLCase if there is one. Link to Patient_Case.ID
Indexes TWstat_Visit_ReferringProviderID_VisitNumberEXTForeign Keys FK_Visit_ReferringProviderID_Referring_Provider_DE_ID: [dbo].[Referring_Provider_DE].ReferringProviderIDReferringProviderID[dbo].[dict_id]5NOT NULLReferring Provider. Link to Referring_Provider_DE.ID
Indexes TWstat_Visit_ReferringProvider_VisitNumberEXTReferringProvidervarchar(50)50NOT NULL(' ')Referring Provider name
Indexes TWstat_Visit_LocationDE_VisitNumberEXTForeign Keys FK_Visit_LocationDE_Location_DE_ID: [dbo].[Location_DE].LocationDELocationDE[dbo].[dict_id]5NOT NULL(0)Appointment Location. Link to Location_DE.ID
Indexes TWstat_Visit_BillingAreaDE_VisitNumberEXTForeign Keys FK_Visit_BillingAreaDE_Billing_Area_DE_ID: [dbo].[Billing_Area_DE].BillingAreaDEBillingAreaDE[dbo].[dict_id]5NOT NULL(0)Billing Area. Link to Billining_Area_DE.ID
Indexes TWstat_Visit_RoomNumber_VisitNumberEXTRoomNumberchar(15)15NOT NULL('')Room number
Indexes TWstat_Visit_DivisionDE_VisitNumberEXTForeign Keys FK_Visit_DivisionDE_Division_DE_ID: [dbo].[Division_DE].DivisionDEDivisionDE[dbo].[dict_id]5NOT NULL(0)Division. Link to Division_DE.ID
Indexes TWstat_Visit_BillingLocationDE_VisitNumberEXTForeign Keys FK_Visit_BillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].BillingLocationDEBillingLocationDE[dbo].[dict_id]5NOT NULL(0)Billing Location. Link to Billing_Location_DE.ID
Indexes NIX_Visit_PatientID_WithIncludeColumns, TWstat_Visit_PrimaryInsuranceDE_VisitNumberEXT(2)Foreign Keys FK_Visit_PrimaryInsuranceDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].PrimaryInsuranceDEPrimaryInsuranceDE[dbo].[dict_id]5NOT NULL('0')Primary visit level insurance. Link to Insurance_Class_DE.ID
Indexes NIX_Visit_PatientID_WithIncludeColumns, TWstat_Visit_SecondaryInsuranceDE_VisitNumberEXT(2)Foreign Keys FK_Visit_SecondaryInsuranceDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].SecondaryInsuranceDESecondaryInsuranceDE[dbo].[dict_id]5NOT NULL('0')Secondary visit level insurance. Link to Insurance_Class_DE.ID
Indexes NIX_Visit_PatientID_WithIncludeColumns, TWstat_Visit_TerciaryInsuranceDE_VisitNumberEXT(2)Foreign Keys FK_Visit_TerciaryInsuranceDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].TerciaryInsuranceDETerciaryInsuranceDE[dbo].[dict_id]5NOT NULL('0')Terciary visit level insurance. link to Insurance_Class_DE.ID
Indexes NIX_Visit_PatientID_WithIncludeColumns, TWstat_Visit_HospitalOrgID_VisitNumberEXT(2)Foreign Keys FK_Visit_HospitalOrgID: [dbo].[Organization].HospitalOrgIDHospitalOrgID[dbo].[dict_id]5NOT NULL(0)Hospital. This is an external organization. Link to Organization.ID
Indexes TWstat_Visit_OptionalField1_VisitNumberEXTOptionalField1varchar(255)255NOT NULL('')Optional field 1
Indexes TWstat_Visit_OptionalField2_VisitNumberEXTOptionalField2varchar(255)255NOT NULL('')Optional Field 2
Indexes TWstat_Visit_OptionalField3_VisitNumberEXTOptionalField3varchar(255)255NOT NULL('')Optional field 3
Indexes TWstat_Visit_OptionalField4_VisitNumberEXTOptionalField4varchar(255)255NOT NULL('')Optional field 4
Indexes TWstat_Visit_OptionalField5_VisitNumberEXTOptionalField5varchar(255)255NOT NULL('')Optional Field 5
Foreign Keys FK_Visit_ReferringProvider2DE: [dbo].[Referring_Provider_DE].ReferringProvider2DEReferringProvider2DE[dbo].[dict_id]5NOT NULL(0)Referring Provider 2. Link to Referring_Provider_DE.ID
Indexes TWstat_Visit_ReferringProvider3DE_VisitNumberEXTForeign Keys FK_Visit_ReferringProvider3DE: [dbo].[Referring_Provider_DE].ReferringProvider3DEReferringProvider3DE[dbo].[dict_id]5NOT NULL(0)Referring Provider 3. Link to Referring_Provider_DE.ID