Appointment table

The Appointment [sn_hcls_appointment] table stores the appointment booking details for a patient in your healthcare organization.

Key features

• Stores any appointments associated with the patient.
• Includes the appointment type, status, service type, service category, start and end times, priority, location, and practitioner.

Role required to configure the table: sn_hcls.admin.

For more information, see Healthcare and Life Sciences data model.

Table 1. Appointment table fields

Field	Data type	Description
Actual end time	Date/Time	Actual end date and time of the appointment.
Actual start time	Date/Time	Actual start date and time of the appointment.
Additional comments	String	Detailed or expanded information to support the appointment provided when making the appointment.
Appointment Id	String	Identifier of the appointment entered in the electronic medical records (EMR) system.
Appointment status	Choice list	Status of an appointment. The following statuses are available by default: Arrived Booked Cancelled Checked in Entered in error Fulfilled No show Pending Proposed Waitlist For more information about the available statuses, see appointment statuses defined in the FHIR specifications.
Appointment type	Choice list	Style of appointment or patient that has been booked in the slot. The following types are available by default: Checkup Emergency Follow up Routine Walkin For more information about the appointment types, see appointment types defined in the FHIR specifications.
Case	Reference	Case associated with this appointment.
Condition	Reference	Condition associated with the appointment.
Description	String	Brief description of the appointment as would be shown on a subject line in a meeting request, or appointment list.
Duration of the appointment	Duration	Actual duration of the appointment.
Location	Reference	Location of the appointment.
Number	String	Alpha-numeric profile identifier of the appointment. The value is auto-generated and is incremented every time you add a new appointment to your ServiceNow instance. The initial value for the Number field is APPT00001001. Note: To customize the number, define the auto-numbering format for the Appointment [sn_hcls_appointment] table. For more information, see Add auto-numbering records in a table.
Observation	Reference	Observation associated with the appointment.
Patient	Reference	Name of the patient.
Patient Instructions	String	Patient-facing information about the appointment. For example, request to bring a referral or fast from 8 p.m. the night before.
Practitioner	Reference	Person added as the practitioner. Practitioners associated with an appointment are referenced in the Appointment participant [sn_hcls_appointment_participant] table.
Priority	Reference	Urgency of the appointment that is used to make informed decisions if needing to reprioritize.
Procedure	Reference	Activity that is performed on, with, or for a patient as part of the appointment.
Requested end time	Date/Time	Proposed end date and time of the appointment requested by the patient.
Requested start time	Date/Time	Proposed start date and time of the appointment requested by the patient.
Service category	Reference	Broad category of the service that is to be performed during this appointment. For more information about the service categories, see service categories defined in the FHIR specifications.
Service type	Reference	Specific service that is to be performed during this appointment. For more information about the service types, see service types defined in the FHIR specifications.
Source	Reference	Source system details of an external healthcare system in a ServiceNow instance.
Specialty	Reference	Specialty of a practitioner that would be required to perform the service requested in this appointment.