dbo.SXAESApptEvtResourceXREF 
Default Table Name  SXAESApptEvtResourceXREF 
Definition  Stores event and resource information for an appointment. Note that the scheduling component allows the user to add more than 1 event to an appointment and add resources not originally configured as part of the event to be included in the event (for the current appointment booking only). 

dbo.SXAESApptEvtResourceXREF 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. 
ApptEvtResourceID(PK)    bigint  NO  Auto generated unique primary key value. 
AppointmentID(FK)    bigint  NO  A foreign key to the AppointmentID column in the SXAESAppointment table. 
EventID(FK)    bigint  NO  A foreign key to the EventID column in the SXAESEvent table. 
ResourceID(FK)    bigint  NO  A foreign key to the ResourceID column in the SXAESResource table. 
IsOverbookIndicator    bit  NO  Indicates if Appointment is overbooked (1=yes, 0=no) 
OverbookByUser    varchar(50)  YES  PHI: Stores the username of the user that overbooked the appointment 
ResourceParentID    bigint  NO  ResourceID from SXAESResource used for resource pool 
ResourceParentCode    varchar(30)  YES  List for the type of Resource Parent (X) 
TopLevelParentID    bigint  NO  Stores the top level ResourceID from SXAESResource for the resource. Used in resource pool 
TopLevelParentCode    varchar(30)  YES  List for the type of Top Level Resource Parent (X) 
MSrepl_tran_version    uniqueidentifier  NO  Optimistic lock identifier. 
IsPoolSameResourceMode    bit  NO  Indicates that this resource in the event is in same resource from pool mode. 
StartMinutes    int  NO  The start minute value of when the resource must be present. 
EndMinutes    int  NO  The end minute value of when the resource must be present. 
IsPrimary    bit  NO 
Indicates whether the appointment resource is primary. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
OutlookAppointmentID    nvarchar(2048)  YES  Stores the Outlook Appointment Id for individual care provider resource. 
IsSyncedWithExternalCalendar    int  NO  An enumerated type with the following list of possible values: 0 = [NotOpted],1 = [NotSynced],2 = [Success], 
IsAnchorResource    bit  NO  Column to store anchor resource for telehealth option book 

dbo.SXAESApptEvtResourceXREF Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAESApptEvtResourceXREFPK  PrimaryKey  ApptEvtResourceID