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. 

TouchedWhenUTC 
Definition  The date and time that the row was last updated including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is 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. 

CreatedWhenUTC 
Definition  The date and time that the row was created including the time zone offset from UTC, for example 2015-01-30 04:55:04.372 -05:00. The date and time is based on the Enterprise Time Zone. 

CaseID 
Definition  Primary key 

CaseIdentifier 
Definition  Case number assigned to the case 

CaseTypeID 
Definition  Type of Case. For example: Elective, Emergency 

CaseStatusID 
Definition  Status of the case, for example: Pending, In Progress 

ClientGUID 
Definition  Link to the patient 

ClientVisitGUID 
Definition  Link to the clientvisit 

LocationGUID 
Definition  Location where the surgery will take place 

PlannedStartDateTimeUTC 
Definition  Time the surgery was planned 

ScheduledStartDateTimeUTC 
Definition  Scheduled time of the surgery 

ActualStartDateTimeUTC 
Definition  Time the surgery was actually started 

RequiresReview 
Definition  Indicate if the case needs review 

TotalDurationMinutes 
Definition  Total number of minutes the procedures took in the case. 

CDSUniqueGUID 
Definition  A GUID used exclusivly by the CDS system to uniquely identify occurrences.  

MSRowVersion 
Definition  Optimistic lock identifier using rowversion datatype. 

SurgeryTimePolicyID 
Definition  A foreign key to the SurgeryTimePolicyID column in the SXASRGSurgeryTimePolicy table. 

BookingComments1 
Definition  The internal/confidential or external/not-confidential booking comments. It is up to the site to determine whether booking comments 1 or booking comments 2 are the internal or external comments. 

BookingComments2 
Definition  The internal/confidential or external/not-confidential booking comments. It is up to the site to determine whether booking comments 1 or booking comments 2 are the internal or external comments. 

ProcedureNotes 
Definition  Concatenation of procedure notes from assigned procedures with a specified preference card 

ProviderNotes 
Definition  Concatenation of provider notes from preference cards, if the provider assigned to a procedure has a matching preference card. 

SurgeryRolePolicyID 
Definition  A foreign key to the SurgeryRolePolicyID column in the SXASRGSurgeryRolePolicy table. 

AnesthesiaTypeID 
Definition  A foreign key to the AnesthesiaTypeID column in the SXASRGAnesthesiaType table. 

ActualEndDateTimeUTC 
Definition  Time the surgery was actually ended 

ReviewNotes 
Definition  Review notes for the case 

BlockID 
Definition  A foreign key to the BlockID column in the SXASRGBlock table. 

BlockDefinitionID 
Definition  The ID of the block definition associated with the case. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

PlannedStartDate 
Definition  The planned start date of the case. 

ActualStartDate 
Definition  The actual start date of the case. 

PhysicalStatus 
Definition  The physical status (ASA score) of the patient