SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 

Build 
Definition  Identifies the build number and patch level of the software that inserted/updated this row. The format is the Build number followed by 3 digits for the patch level which is typically 000. The build number is tied to specific versions of the software, e.g. Sunrise 15.3 is Build 5021, Sunrise 16.3 is Build 5503. 

TouchedBy 
Definition  Information about the user that last updated the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

TouchedWhen 
Definition  The date and time that the row was last updated and will be based on the Enterprise time zone. 

CreatedBy 
Definition  Information about the user that created the row. This will typically be the UserID (IDCode from CV3User table) and may be prefixed with an environment identifier followed by an underscore, e.g. b96d2bf5_jongmore. 

CreatedWhen 
Definition  The date and time that the row was created and will be based on the Enterprise time zone. 

AppointmentID 
Definition  Auto generated unique primary key value. 

EventID 
Definition  EventID from SXAESEvent 

GroupMemberID 
Definition  GroupMemberID from SXAESEventGroupEvents 

ClientGUID 
Definition  GUID of patient/client booked for patient 

ClientVisitGUID 
Definition  GUID of visit associated with this appointment 

IsConfirmationRequired 
Definition  Indicator if Confirmation is required for the appointment (1=yes,0=no) 

IsConfirmationReceived 
Definition  Indicator if Confirmation was received for the appointment (1=yes,0=no) 

IsRegistrationRequired 
Definition  Indicator if Registration is required for the appointment (1=yes,0=no) 

PreEventTime 
Definition  Number of minutes before appointment which pre-event must occur 

PriorityCode 
Definition  List for the priority of the appointment (user definable) 

AppointmentStatus 
Definition  List for the status of the appointment 

OriginalAppointmentID 
Definition  The original AppointmentID for a rescheduled appointment 

ReasonCode 
Definition  List for the reason for the appointment (user definable) 

BookingIdentifier 
Definition  The AppointmentID of the first appointment in the appointment set. It is used when rescheduling appointments so the system can identify all appointments that belong together. 

ScheduleCode 
Definition  List for the type of schedule (S) 

ParentEventID 
Definition  EventID from SXAESEvent of the Parent Event to this appointment event 

IsArrived 
Definition  Indicator if Appointment is arrived (1=yes,0=no) 

ReferringCareProviderGUID 
Definition  GUID of requesting CareProvider 

ScheduledStartDtm 
Definition  Visit TimeZone - Start date/time of the appointment 

ScheduledEndDtm 
Definition  Visit TimeZone - End date/time of the appointment 

RescheduleReasonCode 
Definition  List for the reason for rescheduling (user definable) 

RescheduleDtm 
Definition  Visit TimeZone - Date/time of the reschedule request 

CancelledReasonCode 
Definition  List for the reason for cancelling (user definable) 

CancelledDtm 
Definition  Visit TimeZone - Date/time of the cancel request 

StartDtm 
Definition  Visit TimeZone - Stores start date/time if different than scheduled 

CompletionDtm 
Definition  Visit TimeZone - Stores end date/time if different than scheduled 

PositionNum 
Definition  The relative position of the event in the event group 

IsPrimaryEvent 
Definition  Indicator if this event is the primary in the event group (1=yes,0=no) 

IsMaintainPos 
Definition  Indicator if the event order should be enforced (1=yes,0=no) 

IsMandatory 
Definition  Indicator if the event is mandatory (1=yes,0=no) 

MinDelay 
Definition  The minimum delay before this event (in minutes) 

MaxDelay 
Definition  The maximum delay before this event (in minutes) 

CurrentLocationGUID 
Definition  Current location of the patient/client 

AssignedLocationGUID 
Definition  Assigned location of the patient/client 

TransportMethodCode 
Definition  List of the transport methods (user definable) 

CancelComment 
Definition  Stores additional information for a cancelled appointment 

WaitlistComment 
Definition  Stores additional information for a waitlisted appointment 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

Complaint 
Definition  The free text complaint attached to the appointment. 

AppointmentNote 
Definition  The free text note attached to the appointment. 

LocationGUID 
Definition  The GUID of the location. 

IsHL7Appointment 
Definition  Indicates if the appointment is from an external system 

HL7ExternalID 
Definition  The identifier of the external appointment 

HL7AppointmentFlags 
Definition  Bitmask for HL7 appointment setting values 

MsgEnteredByPerson 
Definition  PHI: The raw text of the EnteredByPerson tag from HL7 

MsgEventReason 
Definition  The raw text of the EventReason tag from HL7 

MsgAppointmentReason 
Definition  The raw text of the AppointmentReason tag from HL7 

MsgAppointmentDuration 
Definition  The raw text of the AppointmentDuration tag from HL7 

MsgAppointmentType 
Definition  The raw text of the AppointmentType tag from HL7 

CDSUniqueGUID 
Definition  The current CDS GUID that has been generated for this appointment 

ReferringFreeTextCareProviderID 
Definition  ID from SXAESFreeTextCareProvider 

CheckInDtm 
Definition  Visit TimeZone - Save checking recorded time 

CheckOutDtm 
Definition  Visit TimeZone - Save checkout recorded time 

IsShortNotice 
Definition  Stores flag which tells is appointees is Short Notice or not. 

BlockDefinitionID 
Definition  A foreign key to the BlockDefinitionID column in the SXAESBlockDefinition table. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

ApptReminderStatusID 
Definition  A foreign key to the ApptReminderStatusID column in the SXAESApptReminderStatus table. 

EventSeqNum 
Definition  Stores Event Sequence number of an event in case of Multi Event Recurring Series Appointment Booking 

GroupPracticeID 
Definition  A foreign key to the GroupPracticeID column in the SXAAMGroupPractice table. 

ExternalSourceApplicationGUID 
Definition  A foreign key to the GUID column in the CV3Application table. 

IsTeleHealth 
Definition  This column help to identify whether the appointment is a telehealth appointment or not.