dbo.SXAESAppointment 
Default Table Name  SXAESAppointment 
Definition  Stores the ES Appointments 

dbo.SXAESAppointment Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  NO  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 
Build    int  NO  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    varchar(50)  NO  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    datetime  NO  The date and time that the row was last updated and will be based on the Enterprise time zone. 
CreatedBy    varchar(50)  NO  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    datetime  NO  The date and time that the row was created and will be based on the Enterprise time zone. 
AppointmentID(PK)    bigint  NO  Auto generated unique primary key value. 
EventID    bigint  NO  EventID from SXAESEvent 
GroupMemberID    bigint  NO  GroupMemberID from SXAESEventGroupEvents 
ClientGUID    bigint  NO  GUID of patient/client booked for patient 
ClientVisitGUID    bigint  YES  GUID of visit associated with this appointment 
IsConfirmationRequired    bit  NO  Indicator if Confirmation is required for the appointment (1=yes,0=no) 
IsConfirmationReceived    bit  NO  Indicator if Confirmation was received for the appointment (1=yes,0=no) 
IsRegistrationRequired    bit  NO  Indicator if Registration is required for the appointment (1=yes,0=no) 
PreEventTime    int  YES  Number of minutes before appointment which pre-event must occur 
PriorityCode    varchar(30)  YES  List for the priority of the appointment (user definable) 
AppointmentStatus    varchar(30)  YES  List for the status of the appointment 
OriginalAppointmentID    bigint  NO  The original AppointmentID for a rescheduled appointment 
ReasonCode    varchar(30)  YES  List for the reason for the appointment (user definable) 
BookingIdentifier    varchar(255)  YES  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    varchar(30)  YES  List for the type of schedule (S) 
ParentEventID    bigint  NO  EventID from SXAESEvent of the Parent Event to this appointment event 
IsArrived    bit  NO  Indicator if Appointment is arrived (1=yes,0=no) 
ReferringCareProviderGUID    bigint  YES  GUID of requesting CareProvider 
ScheduledStartDtm    datetime  NO  Visit TimeZone - Start date/time of the appointment 
ScheduledEndDtm    datetime  YES  Visit TimeZone - End date/time of the appointment 
RescheduleReasonCode    varchar(30)  YES  List for the reason for rescheduling (user definable) 
RescheduleDtm    datetime  YES  Visit TimeZone - Date/time of the reschedule request 
CancelledReasonCode    varchar(30)  YES  List for the reason for cancelling (user definable) 
CancelledDtm    datetime  YES  Visit TimeZone - Date/time of the cancel request 
StartDtm    datetime  YES  Visit TimeZone - Stores start date/time if different than scheduled 
CompletionDtm    datetime  YES  Visit TimeZone - Stores end date/time if different than scheduled 
PositionNum    int  NO  The relative position of the event in the event group 
IsPrimaryEvent    bit  NO  Indicator if this event is the primary in the event group (1=yes,0=no) 
IsMaintainPos    bit  NO  Indicator if the event order should be enforced (1=yes,0=no) 
IsMandatory    bit  NO  Indicator if the event is mandatory (1=yes,0=no) 
MinDelay    int  YES  The minimum delay before this event (in minutes) 
MaxDelay    int  YES  The maximum delay before this event (in minutes) 
CurrentLocationGUID    bigint  YES  Current location of the patient/client 
AssignedLocationGUID    bigint  YES  Assigned location of the patient/client 
TransportMethodCode    varchar(30)  YES  List of the transport methods (user definable) 
CancelComment    varchar(500)  YES  Stores additional information for a cancelled appointment 
WaitlistComment    varchar(500)  YES  Stores additional information for a waitlisted appointment 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
Complaint    varchar(60)  YES  The free text complaint attached to the appointment. 
AppointmentNote    varchar(500)  YES  The free text note attached to the appointment. 
LocationGUID    bigint  NO  The GUID of the location. 
IsHL7Appointment    bit  NO  Indicates if the appointment is from an external system 
HL7ExternalID    varchar(75)  YES  The identifier of the external appointment 
HL7AppointmentFlags    int  NO  Bitmask for HL7 appointment setting values 
MsgEnteredByPerson    varchar(50)  YES  PHI: The raw text of the EnteredByPerson tag from HL7 
MsgEventReason    varchar(50)  YES  The raw text of the EventReason tag from HL7 
MsgAppointmentReason    varchar(50)  YES  The raw text of the AppointmentReason tag from HL7 
MsgAppointmentDuration    varchar(10)  YES  The raw text of the AppointmentDuration tag from HL7 
MsgAppointmentType    varchar(50)  YES  The raw text of the AppointmentType tag from HL7 
CDSUniqueGUID    bigint  YES  The current CDS GUID that has been generated for this appointment 
ReferringFreeTextCareProviderID    bigint  YES  ID from SXAESFreeTextCareProvider 
CheckInDtm    datetime  YES  Visit TimeZone - Save checking recorded time 
CheckOutDtm    datetime  YES  Visit TimeZone - Save checkout recorded time 
IsShortNotice    bit  NO  Stores flag which tells is appointees is Short Notice or not. 
BlockDefinitionID(FK)    int  YES  A foreign key to the BlockDefinitionID column in the SXAESBlockDefinition table. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
ApptReminderStatusID(FK)    int  YES  A foreign key to the ApptReminderStatusID column in the SXAESApptReminderStatus table. 
EventSeqNum    tinyint  YES  Stores Event Sequence number of an event in case of Multi Event Recurring Series Appointment Booking 
GroupPracticeID(FK)    int  YES  A foreign key to the GroupPracticeID column in the SXAAMGroupPractice table. 
ExternalSourceApplicationGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Application table. 
IsTeleHealth    bit  NO  This column help to identify whether the appointment is a telehealth appointment or not. 

dbo.SXAESAppointment Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAESAppointmentPK  PrimaryKey  AppointmentID