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 |
|
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 |
|
int |
YES |
A foreign key to the BlockDefinitionID column in the SXAESBlockDefinition table. |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
ApptReminderStatusID |
|
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 |
|
int |
YES |
A foreign key to the GroupPracticeID column in the SXAAMGroupPractice table. |
ExternalSourceApplicationGUID |
|
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. |