Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
 | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Visit table. |
| ReferralID | [dbo].[uniqueid] | 9 | NOT NULL | | | Not used |
 | EpisodeID | [dbo].[uniqueid] | 9 | NOT NULL | | | Not Used |
 ![Foreign Keys FK_Visit_ArrivedByID_IDX_User_ID: [dbo].[IDX_User].ArrivedByID Foreign Keys FK_Visit_ArrivedByID_IDX_User_ID: [dbo].[IDX_User].ArrivedByID](../../../../Images/fk.png) | ArrivedByID | [dbo].[uniqueid] | 9 | NOT NULL | | | Arrived by user. Link to IDX_User.ID |
 ![Foreign Keys FK_Visit_CourtesyCodeDE_Courtesy_Code_DE_ID: [dbo].[Courtesy_Code_DE].CourtesyCodeDE Foreign Keys FK_Visit_CourtesyCodeDE_Courtesy_Code_DE_ID: [dbo].[Courtesy_Code_DE].CourtesyCodeDE](../../../../Images/fk.png) | CourtesyCodeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Courtesy code. Not used. Courtesy_Code_DE.ID |
 ![Foreign Keys FK_Visit_ProductLineDE_Product_Line_DE_ID: [dbo].[Product_Line_DE].ProductLineDE Foreign Keys FK_Visit_ProductLineDE_Product_Line_DE_ID: [dbo].[Product_Line_DE].ProductLineDE](../../../../Images/fk.png) | ProductLineDE | [dbo].[dict_id] | 5 | NOT NULL | | | Product Line. Not Used. Link to Product_Line_DE.ID |
 ![Foreign Keys FK_Visit_ProgramDE_Program_DE_ID: [dbo].[Program_DE].ProgramDE Foreign Keys FK_Visit_ProgramDE_Program_DE_ID: [dbo].[Program_DE].ProgramDE](../../../../Images/fk.png) | ProgramDE | [dbo].[dict_id] | 5 | NOT NULL | | | Program. Not Used. Link to Program_DE.ID |
 ![Foreign Keys FK_Visit_VIPTypeDE_VIP_Type_DE_ID: [dbo].[VIP_Type_DE].VIPTypeDE Foreign Keys FK_Visit_VIPTypeDE_VIP_Type_DE_ID: [dbo].[VIP_Type_DE].VIPTypeDE](../../../../Images/fk.png) | VIPTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | VIP (Very Important Person) type. Link to VIP_Type_DE.ID |
(2)![Foreign Keys FK_Visit_VisitTypeDE_Visit_Type_DE_ID: [dbo].[Visit_Type_DE].VisitTypeDE Foreign Keys FK_Visit_VisitTypeDE_Visit_Type_DE_ID: [dbo].[Visit_Type_DE].VisitTypeDE](../../../../Images/fk.png) | VisitTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Visit Type. Link to Visit_Type_DE.ID |
 ![Foreign Keys FK_Visit_ArrivalModeDE_Arrival_Mode_DE_ID: [dbo].[Arrival_Mode_DE].ArrivalModeDE Foreign Keys FK_Visit_ArrivalModeDE_Arrival_Mode_DE_ID: [dbo].[Arrival_Mode_DE].ArrivalModeDE](../../../../Images/fk.png) | ArrivalModeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Arrival Mode. Not Used. Link to Arrival_Mode_DE.ID |
 | InjuryInformationID | [dbo].[uniqueid] | 9 | NOT NULL | | | Injury Information. Link to Injury_Information.ID. |
(3) | StartDTTM | datetime | 8 | NULL allowed | | | Start date and time of the visit. |
 | EndDTTM | datetime | 8 | NULL allowed | | | End date and time of the visit |
(35) | VisitNumberEXT | varchar(40) | 40 | NOT NULL | | | External visit number |
 | InterfaceSourceID | smallint | 2 | NOT NULL | | | Source of the visit. This is 0 for visits created within Touchworks or and interface identifier. |
(2)![Foreign Keys FK_Visit_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationID Foreign Keys FK_Visit_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationID](../../../../Images/fk.png) | OrganizationID | numeric(8,0) | 5 | NOT NULL | | | Organization. Link to Organization.ID |
(2)![Foreign Keys FK_Visit_MotherVisitID_Visit_ID: [dbo].[Visit].MotherVisitID Foreign Keys FK_Visit_MotherVisitID_Visit_ID: [dbo].[Visit].MotherVisitID](../../../../Images/fk.png) | MotherVisitID | [dbo].[uniqueid] | 9 | NOT NULL | | | Visit for the mother if this visit is a maternity visit. Link to Visit.ID |
(2)![Foreign Keys FK_Visit_VisitStatusDE_Visit_Status_DE_ID: [dbo].[Visit_Status_DE].VisitStatusDE Foreign Keys FK_Visit_VisitStatusDE_Visit_Status_DE_ID: [dbo].[Visit_Status_DE].VisitStatusDE](../../../../Images/fk.png) | VisitStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | | Visit Status. Link to Visit_Status_DE.ID |
(2)![Foreign Keys FK_Visit_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Visit_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | | Patient. Link to Person.ID |
(2) | PrimaryProviderID | [dbo].[uniqueid] | 9 | NOT NULL | | | Primary Provider. Link to Provider.ID |
| PatientCaseID | [dbo].[uniqueid] | 9 | NOT NULL | | | Case if there is one. Link to Patient_Case.ID |
 ![Foreign Keys FK_Visit_ReferringProviderID_Referring_Provider_DE_ID: [dbo].[Referring_Provider_DE].ReferringProviderID Foreign Keys FK_Visit_ReferringProviderID_Referring_Provider_DE_ID: [dbo].[Referring_Provider_DE].ReferringProviderID](../../../../Images/fk.png) | ReferringProviderID | [dbo].[dict_id] | 5 | NOT NULL | | | Referring Provider. Link to Referring_Provider_DE.ID |
 | ReferringProvider | varchar(50) | 50 | NOT NULL | | (' ') | Referring Provider name |
 ![Foreign Keys FK_Visit_LocationDE_Location_DE_ID: [dbo].[Location_DE].LocationDE Foreign Keys FK_Visit_LocationDE_Location_DE_ID: [dbo].[Location_DE].LocationDE](../../../../Images/fk.png) | LocationDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Appointment Location. Link to Location_DE.ID |
 ![Foreign Keys FK_Visit_BillingAreaDE_Billing_Area_DE_ID: [dbo].[Billing_Area_DE].BillingAreaDE Foreign Keys FK_Visit_BillingAreaDE_Billing_Area_DE_ID: [dbo].[Billing_Area_DE].BillingAreaDE](../../../../Images/fk.png) | BillingAreaDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Billing Area. Link to Billining_Area_DE.ID |
 | RoomNumber | char(15) | 15 | NOT NULL | | ('') | Room number |
 ![Foreign Keys FK_Visit_DivisionDE_Division_DE_ID: [dbo].[Division_DE].DivisionDE Foreign Keys FK_Visit_DivisionDE_Division_DE_ID: [dbo].[Division_DE].DivisionDE](../../../../Images/fk.png) | DivisionDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Division. Link to Division_DE.ID |
 ![Foreign Keys FK_Visit_BillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].BillingLocationDE Foreign Keys FK_Visit_BillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].BillingLocationDE](../../../../Images/fk.png) | BillingLocationDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Billing Location. Link to Billing_Location_DE.ID |
(2)![Foreign Keys FK_Visit_PrimaryInsuranceDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].PrimaryInsuranceDE Foreign Keys FK_Visit_PrimaryInsuranceDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].PrimaryInsuranceDE](../../../../Images/fk.png) | PrimaryInsuranceDE | [dbo].[dict_id] | 5 | NOT NULL | | ('0') | Primary visit level insurance. Link to Insurance_Class_DE.ID |
(2)![Foreign Keys FK_Visit_SecondaryInsuranceDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].SecondaryInsuranceDE Foreign Keys FK_Visit_SecondaryInsuranceDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].SecondaryInsuranceDE](../../../../Images/fk.png) | SecondaryInsuranceDE | [dbo].[dict_id] | 5 | NOT NULL | | ('0') | Secondary visit level insurance. Link to Insurance_Class_DE.ID |
(2)![Foreign Keys FK_Visit_TerciaryInsuranceDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].TerciaryInsuranceDE Foreign Keys FK_Visit_TerciaryInsuranceDE_Insurance_Class_DE_ID: [dbo].[Insurance_Class_DE].TerciaryInsuranceDE](../../../../Images/fk.png) | TerciaryInsuranceDE | [dbo].[dict_id] | 5 | NOT NULL | | ('0') | Terciary visit level insurance. link to Insurance_Class_DE.ID |
(2)![Foreign Keys FK_Visit_HospitalOrgID: [dbo].[Organization].HospitalOrgID Foreign Keys FK_Visit_HospitalOrgID: [dbo].[Organization].HospitalOrgID](../../../../Images/fk.png) | HospitalOrgID | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Hospital. This is an external organization. Link to Organization.ID |
 | OptionalField1 | varchar(255) | 255 | NOT NULL | | ('') | Optional field 1 |
 | OptionalField2 | varchar(255) | 255 | NOT NULL | | ('') | Optional Field 2 |
 | OptionalField3 | varchar(255) | 255 | NOT NULL | | ('') | Optional field 3 |
 | OptionalField4 | varchar(255) | 255 | NOT NULL | | ('') | Optional field 4 |
 | OptionalField5 | varchar(255) | 255 | NOT NULL | | ('') | Optional Field 5 |
![Foreign Keys FK_Visit_ReferringProvider2DE: [dbo].[Referring_Provider_DE].ReferringProvider2DE Foreign Keys FK_Visit_ReferringProvider2DE: [dbo].[Referring_Provider_DE].ReferringProvider2DE](../../../../Images/fk.png) | ReferringProvider2DE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Referring Provider 2. Link to Referring_Provider_DE.ID |
 ![Foreign Keys FK_Visit_ReferringProvider3DE: [dbo].[Referring_Provider_DE].ReferringProvider3DE Foreign Keys FK_Visit_ReferringProvider3DE: [dbo].[Referring_Provider_DE].ReferringProvider3DE](../../../../Images/fk.png) | ReferringProvider3DE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Referring Provider 3. Link to Referring_Provider_DE.ID |