Key | Name | Data Type | Max Length (Bytes) | Nullability | Identity | Default | Description |
---|
  (18) | ID | [dbo].[uniqueid] | 9 | NOT NULL | 1 - 1 | | Key to the Appointment table. |
![Foreign Keys FK_Appointment_ProblemDE_Problem_DE_ID: [dbo].[Problem_DE].ProblemDE Foreign Keys FK_Appointment_ProblemDE_Problem_DE_ID: [dbo].[Problem_DE].ProblemDE](../../../../Images/fk.png) | ProblemDE | [dbo].[dict_id] | 5 | NOT NULL | | | Problem. Key to the Problem_DE table |
(6)![Foreign Keys FK_Appointment_DepartmentDE_Department_DE_ID: [dbo].[Department_DE].DepartmentDE Foreign Keys FK_Appointment_DepartmentDE_Department_DE_ID: [dbo].[Department_DE].DepartmentDE](../../../../Images/fk.png) | DepartmentDE | [dbo].[dict_id] | 5 | NOT NULL | | | Department. Key to the Department_DE table. |
(7)![Foreign Keys FK_Appointment_LocationDE_Location_DE_ID: [dbo].[Location_DE].LocationDE Foreign Keys FK_Appointment_LocationDE_Location_DE_ID: [dbo].[Location_DE].LocationDE](../../../../Images/fk.png) | LocationDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Appointment Location. Key to the Location_DE table. |
(3) | CreatedVisitID | [dbo].[uniqueid] | 9 | NOT NULL | | | Visit. Link to Visit.ID. |
 (14)![Foreign Keys FK_Appointment_ResourceDE_Resource_DE_ID: [dbo].[Resource_DE].ResourceDE Foreign Keys FK_Appointment_ResourceDE_Resource_DE_ID: [dbo].[Resource_DE].ResourceDE](../../../../Images/fk.png) | ResourceDE | [dbo].[dict_id] | 5 | NOT NULL | | | Resource. Key to the Resource_DE table. |
(6)![Foreign Keys FK_Appointment_AppointmentTypeDE_Appointment_Type_DE_ID: [dbo].[Appointment_Type_DE].AppointmentTypeDE Foreign Keys FK_Appointment_AppointmentTypeDE_Appointment_Type_DE_ID: [dbo].[Appointment_Type_DE].AppointmentTypeDE](../../../../Images/fk.png) | AppointmentTypeDE | [dbo].[dict_id] | 5 | NOT NULL | | | Appointment Type. Key to the Appointment_Type_DE table. |
(6)![Foreign Keys FK_Appointment_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID Foreign Keys FK_Appointment_PatientID_Patient_Member_ID: [dbo].[Patient_Member].PatientID](../../../../Images/fk.png) | PatientID | [dbo].[uniqueid] | 9 | NOT NULL | | | Patient. Key to the Person Table |
(8)![Foreign Keys FK_Appointment_AppointmentStatusDE_Appointment_Status_DE_ID: [dbo].[Appointment_Status_DE].AppointmentStatusDE Foreign Keys FK_Appointment_AppointmentStatusDE_Appointment_Status_DE_ID: [dbo].[Appointment_Status_DE].AppointmentStatusDE](../../../../Images/fk.png) | AppointmentStatusDE | [dbo].[dict_id] | 5 | NOT NULL | | | Status. Key to the Appointment_Status_DE table. |
![Check Constraints CK_Appointment_WasBookedManuallyFLAG_Yes_Or_No : ([WasBookedManuallyFLAG]='N' OR [WasBookedManuallyFLAG]='Y') Check Constraints CK_Appointment_WasBookedManuallyFLAG_Yes_Or_No : ([WasBookedManuallyFLAG]='N' OR [WasBookedManuallyFLAG]='Y')](../../../../Images/c-constraint.png) | WasBookedManuallyFLAG | [dbo].[BOOL] | 1 | NOT NULL | | | Y/N |
(4) | Comment | [dbo].[message] | 255 | NOT NULL | | | Free text comment can be added by PMS so that it appears in appointment details window. |
 (15) | StartDTTM | datetime | 8 | NOT NULL | | | Date and time appointment starts |
(5) | Duration | smallint | 2 | NOT NULL | | | How long is the appointment (in minutes) |
(5)![Foreign Keys FK_Appointment_ApptCancelReasonDE_Appointment_Cancel_DE_ID: [dbo].[Appointment_Cancel_DE].ApptCancelReasonDE Foreign Keys FK_Appointment_ApptCancelReasonDE_Appointment_Cancel_DE_ID: [dbo].[Appointment_Cancel_DE].ApptCancelReasonDE](../../../../Images/fk.png) | ApptCancelReasonDE | [dbo].[dict_id] | 5 | NOT NULL | | | Reason for cancellation. Key to the Appointment_Cancel_DE table. |
(5) | ApptNumberEXT | varchar(20) | 20 | NOT NULL | | (' ') | An appointment number, often the number from the scheduling system. |
 | InterfaceSourceID | smallint | 2 | NOT NULL | | | ID of the interface that loaded the appointment into the system. Can be used to trace back to the right inbound interface. |
 ![Foreign Keys FK_Appointment_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationID Foreign Keys FK_Appointment_OrganizationID_Organization_ID: [dbo].[Organization].OrganizationID](../../../../Images/fk.png) | OrganizationID | numeric(8,0) | 5 | NOT NULL | | | Organization. Key to the Organization table. |
| AttatchedtoVisitID | [dbo].[uniqueid] | 9 | NOT NULL | | | no longer used, hard coded to 0. |
| InsuranceName | varchar(25) | 25 | NOT NULL | | (' ') | no longer used |
| InsuranceCode | varchar(4) | 4 | NOT NULL | | (' ') | no longer used |
(9) | EncounterID | [dbo].[uniqueid] | 9 | NULL allowed | | | Encounter. Link to Encounter.ID. |
 ![Foreign Keys FK_Appointment_BillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].BillingLocationDE Foreign Keys FK_Appointment_BillingLocationDE_Billing_Location_DE_ID: [dbo].[Billing_Location_DE].BillingLocationDE](../../../../Images/fk.png) | BillingLocationDE | [dbo].[dict_id] | 5 | NOT NULL | | (0) | Billing Location. Key to the Billing_Location_DE table |
(4) | Reason | varchar(255) | 255 | NOT NULL | | ('') | Free text field that appears on appointment details window. Similar to comment. |
 | AssignedProvider | [dbo].[uniqueid] | 9 | NOT NULL | | ((0)) | Actual provider who is assigned to the 'generic' appointment. Used when the appointment is for a generic provider. |
 | ParentScdProvResourceDE | [dbo].[dict_id] | 5 | NOT NULL | | ((0)) | Generic Provider feature. Updated during Encounter Transfer to preserve original ResourceDE |
![Foreign Keys FK_Appointment_AddressID_Appointment_Address_ID: [dbo].[Appointment_Address].AddressID Foreign Keys FK_Appointment_AddressID_Appointment_Address_ID: [dbo].[Appointment_Address].AddressID](../../../../Images/fk.png) | AddressID | [dbo].[uniqueid] | 9 | NULL allowed | | | Location Address. Link to Appointment_Location.ID |