Tables [dbo].[Appointment]
Patient Appointments, Past, Present and Future.
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Primary Key PK_Appointment_ID: IDCluster Key XAK4Appointment: ResourceDE\StartDTTM\IDIndexes Portal_Appointment, XAK6Appointment, NIX_Appointment_Patient_Encounter, XAK1APPOINTMENT, Nix_ParentScdProvResourceDe_StartDTTM, XAK7Appointment, TWstat_Appointment_AppointmentStatusDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_AppointmentTypeDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_ApptCancelReasonDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_BillingLocationDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_Comment_ResourceDE_StartDTTM_ID, TWstat_Appointment_DepartmentDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_Duration_ResourceDE_StartDTTM_ID, TWstat_Appointment_InterfaceSourceID_ResourceDE_StartDTTM_ID, TWstat_Appointment_LocationDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_OrganizationID_ResourceDE_StartDTTM_ID, TWstat_Appointment_Reason_ResourceDE_StartDTTM_ID, TWstat_Appointment_StartDTTM_ResourceDE_ID(18)ID[dbo].[uniqueid]9NOT NULL1 - 1Key to the Appointment table.
Foreign Keys FK_Appointment_ProblemDE_Problem_DE_ID: [dbo].[Problem_DE].ProblemDEProblemDE[dbo].[dict_id]5NOT NULLProblem. Key to the Problem_DE table
Indexes Nix_Appointment_EncounterID_DepartmentDE, nix_Appointment_PatientID_EncounterID_AppointmentStatusDE_ApptCancelReasonDE_LocationDE_Include, Portal_Appointment_StartDTTM_EncounterID_DepartmentDE_LocationDE_AppointmentTypeDE_AppointmentStatusDE_Duration, Nix_ParentScdProvResourceDe_StartDTTM, XAK7Appointment, TWstat_Appointment_DepartmentDE_ResourceDE_StartDTTM_ID(6)Foreign Keys FK_Appointment_DepartmentDE_Department_DE_ID: [dbo].[Department_DE].DepartmentDEDepartmentDE[dbo].[dict_id]5NOT NULLDepartment. Key to the Department_DE table.
Indexes Nix_Appointment_EncounterID_LocationDE, nix_Appointment_PatientID_EncounterID_AppointmentStatusDE_ApptCancelReasonDE_LocationDE_Include, NIX_Appointment_Patient_Encounter, Portal_Appointment_StartDTTM_EncounterID_DepartmentDE_LocationDE_AppointmentTypeDE_AppointmentStatusDE_Duration, Nix_ParentScdProvResourceDe_StartDTTM, XAK7Appointment, TWstat_Appointment_LocationDE_ResourceDE_StartDTTM_ID(7)Foreign Keys FK_Appointment_LocationDE_Location_DE_ID: [dbo].[Location_DE].LocationDELocationDE[dbo].[dict_id]5NOT NULL(0)Appointment Location. Key to the Location_DE table.
Indexes XAK2APPOINT_CreVisID, XAK6Appointment, nix_Appointment_PatientID_EncounterID_AppointmentStatusDE_ApptCancelReasonDE_LocationDE_Include(3)CreatedVisitID[dbo].[uniqueid]9NOT NULLVisit. Link to Visit.ID.
Cluster Key XAK4Appointment: ResourceDE\StartDTTM\IDIndexes Nix_ParentScdProvResourceDe_StartDTTM, XAK7Appointment, TWstat_Appointment_AppointmentStatusDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_AppointmentTypeDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_ApptCancelReasonDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_BillingLocationDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_Comment_ResourceDE_StartDTTM_ID, TWstat_Appointment_DepartmentDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_Duration_ResourceDE_StartDTTM_ID, TWstat_Appointment_InterfaceSourceID_ResourceDE_StartDTTM_ID, TWstat_Appointment_LocationDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_OrganizationID_ResourceDE_StartDTTM_ID, TWstat_Appointment_Reason_ResourceDE_StartDTTM_ID, TWstat_Appointment_StartDTTM_ResourceDE_ID(14)Foreign Keys FK_Appointment_ResourceDE_Resource_DE_ID: [dbo].[Resource_DE].ResourceDEResourceDE[dbo].[dict_id]5NOT NULLResource. Key to the Resource_DE table.
Indexes xEncounterID, nix_Appointment_PatientID_EncounterID_AppointmentStatusDE_ApptCancelReasonDE_LocationDE_Include, Portal_Appointment_StartDTTM_EncounterID_DepartmentDE_LocationDE_AppointmentTypeDE_AppointmentStatusDE_Duration, Nix_ParentScdProvResourceDe_StartDTTM, XAK7Appointment, TWstat_Appointment_AppointmentTypeDE_ResourceDE_StartDTTM_ID(6)Foreign Keys FK_Appointment_AppointmentTypeDE_Appointment_Type_DE_ID: [dbo].[Appointment_Type_DE].AppointmentTypeDEAppointmentTypeDE[dbo].[dict_id]5NOT NULLAppointment Type. Key to the Appointment_Type_DE table.
Indexes XAK6Appointment, nix_Appointment_PatientID_EncounterID_AppointmentStatusDE_ApptCancelReasonDE_LocationDE_Include, NIX_Appointment_Patient_Encounter, XAK1APPOINTMENT, Nix_ParentScdProvResourceDe_StartDTTM, XAK7Appointment(6)Foreign Keys FK_Appointment_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientIDPatientID[dbo].[uniqueid]9NOT NULLPatient. Key to the Person Table
Indexes xEncounterID, XAK6Appointment, nix_Appointment_PatientID_EncounterID_AppointmentStatusDE_ApptCancelReasonDE_LocationDE_Include, NIX_Appointment_Patient_Encounter, Portal_Appointment_StartDTTM_EncounterID_DepartmentDE_LocationDE_AppointmentTypeDE_AppointmentStatusDE_Duration, Nix_ParentScdProvResourceDe_StartDTTM, XAK7Appointment, TWstat_Appointment_AppointmentStatusDE_ResourceDE_StartDTTM_ID(8)Foreign Keys FK_Appointment_AppointmentStatusDE_Appointment_Status_DE_ID: [dbo].[Appointment_Status_DE].AppointmentStatusDEAppointmentStatusDE[dbo].[dict_id]5NOT NULLStatus. Key to the Appointment_Status_DE table.
Check Constraints CK_Appointment_WasBookedManuallyFLAG_Yes_Or_No : ([WasBookedManuallyFLAG]='N' OR [WasBookedManuallyFLAG]='Y')WasBookedManuallyFLAG[dbo].[BOOL]1NOT NULLY/N
Indexes nix_Appointment_PatientID_EncounterID_AppointmentStatusDE_ApptCancelReasonDE_LocationDE_Include, Nix_ParentScdProvResourceDe_StartDTTM, XAK7Appointment, TWstat_Appointment_Comment_ResourceDE_StartDTTM_ID(4)Comment[dbo].[message]255NOT NULLFree text comment can be added by PMS so that it appears in appointment details window.
Cluster Key XAK4Appointment: ResourceDE\StartDTTM\IDIndexes Portal_Appointment_StartDTTM_EncounterID_DepartmentDE_LocationDE_AppointmentTypeDE_AppointmentStatusDE_Duration, Nix_ParentScdProvResourceDe_StartDTTM, XAK7Appointment, TWstat_Appointment_AppointmentStatusDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_AppointmentTypeDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_ApptCancelReasonDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_BillingLocationDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_Comment_ResourceDE_StartDTTM_ID, TWstat_Appointment_DepartmentDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_Duration_ResourceDE_StartDTTM_ID, TWstat_Appointment_InterfaceSourceID_ResourceDE_StartDTTM_ID, TWstat_Appointment_LocationDE_ResourceDE_StartDTTM_ID, TWstat_Appointment_OrganizationID_ResourceDE_StartDTTM_ID, TWstat_Appointment_Reason_ResourceDE_StartDTTM_ID, TWstat_Appointment_StartDTTM_ResourceDE_ID(15)StartDTTMdatetime8NOT NULLDate and time appointment starts
Indexes nix_Appointment_PatientID_EncounterID_AppointmentStatusDE_ApptCancelReasonDE_LocationDE_Include, Portal_Appointment_StartDTTM_EncounterID_DepartmentDE_LocationDE_AppointmentTypeDE_AppointmentStatusDE_Duration, Nix_ParentScdProvResourceDe_StartDTTM, XAK7Appointment, TWstat_Appointment_Duration_ResourceDE_StartDTTM_ID(5)Durationsmallint2NOT NULLHow long is the appointment (in minutes)
Indexes xEncounterID, XAK6Appointment, nix_Appointment_PatientID_EncounterID_AppointmentStatusDE_ApptCancelReasonDE_LocationDE_Include, NIX_Appointment_Patient_Encounter, TWstat_Appointment_ApptCancelReasonDE_ResourceDE_StartDTTM_ID(5)Foreign Keys FK_Appointment_ApptCancelReasonDE_Appointment_Cancel_DE_ID: [dbo].[Appointment_Cancel_DE].ApptCancelReasonDEApptCancelReasonDE[dbo].[dict_id]5NOT NULLReason for cancellation. Key to the Appointment_Cancel_DE table.
Indexes XAK5Appointment, xEncounterID, nix_Appointment_PatientID_EncounterID_AppointmentStatusDE_ApptCancelReasonDE_LocationDE_Include, Nix_ParentScdProvResourceDe_StartDTTM, XAK7Appointment(5)ApptNumberEXTvarchar(20)20NOT NULL(' ')An appointment number, often the number from the scheduling system.
Indexes TWstat_Appointment_InterfaceSourceID_ResourceDE_StartDTTM_IDInterfaceSourceIDsmallint2NOT NULLID of the interface that loaded the appointment into the system. Can be used to trace back to the right inbound interface.
Indexes TWstat_Appointment_OrganizationID_ResourceDE_StartDTTM_IDForeign Keys FK_Appointment_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationIDOrganizationIDnumeric(8,0)5NOT NULLOrganization. Key to the Organization table.
AttatchedtoVisitID[dbo].[uniqueid]9NOT NULLno longer used, hard coded to 0.
InsuranceNamevarchar(25)25NOT NULL(' ')no longer used
InsuranceCodevarchar(4)4NOT NULL(' ')no longer used
Indexes xEncounterID, Nix_Appointment_EncounterID_DepartmentDE, Portal_Appointment, Nix_Appointment_EncounterID_LocationDE, nix_Appointment_PatientID_EncounterID_AppointmentStatusDE_ApptCancelReasonDE_LocationDE_Include, NIX_Appointment_Patient_Encounter, Portal_Appointment_StartDTTM_EncounterID_DepartmentDE_LocationDE_AppointmentTypeDE_AppointmentStatusDE_Duration, Nix_ParentScdProvResourceDe_StartDTTM, XAK7Appointment(9)EncounterID[dbo].[uniqueid]9NULL allowedEncounter. Link to Encounter.ID.
Indexes TWstat_Appointment_BillingLocationDE_ResourceDE_StartDTTM_IDForeign Keys FK_Appointment_BillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].BillingLocationDEBillingLocationDE[dbo].[dict_id]5NOT NULL(0)Billing Location. Key to the Billing_Location_DE table
Indexes nix_Appointment_PatientID_EncounterID_AppointmentStatusDE_ApptCancelReasonDE_LocationDE_Include, Nix_ParentScdProvResourceDe_StartDTTM, XAK7Appointment, TWstat_Appointment_Reason_ResourceDE_StartDTTM_ID(4)Reasonvarchar(255)255NOT NULL('')Free text field that appears on appointment details window. Similar to comment.
Indexes Nix_ParentScdProvResourceDe_StartDTTMAssignedProvider[dbo].[uniqueid]9NOT NULL((0))Actual provider who is assigned to the 'generic' appointment. Used when the appointment is for a generic provider.
Indexes Nix_ParentScdProvResourceDe_StartDTTMParentScdProvResourceDE[dbo].[dict_id]5NOT NULL((0))Generic Provider feature. Updated during Encounter Transfer to preserve original ResourceDE
Foreign Keys FK_Appointment_AddressID_Appointment_Address_ID: [dbo].[Appointment_Address].AddressIDAddressID[dbo].[uniqueid]9NULL allowedLocation Address. Link to Appointment_Location.ID