dbo.SXASRGCase 
Default Table Name  SXASRGCase 
Definition  This surgery table contains the case information 

dbo.SXASRGCase Columns 
ColumnName  Domain  Datatype  NULL  Definition 
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. 
TouchedWhenUTC    datetimeoffset(3)  NO  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    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. 
CreatedWhenUTC    datetimeoffset(3)  NO  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(PK)    bigint  NO  Primary key 
CaseIdentifier    varchar(50)  NO  Case number assigned to the case 
CaseTypeID    int  YES  Type of Case. For example: Elective, Emergency 
CaseStatusID    int  NO  Status of the case, for example: Pending, In Progress 
ClientGUID    HVCIDdt  NO  Link to the patient 
ClientVisitGUID    HVCIDdt  YES  Link to the clientvisit 
LocationGUID    HVCIDdt  NO  Location where the surgery will take place 
PlannedStartDateTimeUTC    datetimeoffset(3)  YES  Time the surgery was planned 
ScheduledStartDateTimeUTC    datetimeoffset(3)  NO  Scheduled time of the surgery 
ActualStartDateTimeUTC    datetimeoffset(3)  YES  Time the surgery was actually started 
RequiresReview    bit  YES  Indicate if the case needs review 
TotalDurationMinutes    smallint  NO  Total number of minutes the procedures took in the case. 
CDSUniqueGUID    HVCIDdt  YES  A GUID used exclusivly by the CDS system to uniquely identify occurrences.  
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
SurgeryTimePolicyID(FK)    int  YES  A foreign key to the SurgeryTimePolicyID column in the SXASRGSurgeryTimePolicy table. 
BookingComments1    varchar(1000)  YES  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    varchar(1000)  YES  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    varchar(8000)  YES  Concatenation of procedure notes from assigned procedures with a specified preference card 
ProviderNotes    varchar(8000)  YES  Concatenation of provider notes from preference cards, if the provider assigned to a procedure has a matching preference card. 
SurgeryRolePolicyID(FK)    int  YES  A foreign key to the SurgeryRolePolicyID column in the SXASRGSurgeryRolePolicy table. 
AnesthesiaTypeID(FK)    int  YES  A foreign key to the AnesthesiaTypeID column in the SXASRGAnesthesiaType table. 
ActualEndDateTimeUTC    datetimeoffset(3)  YES  Time the surgery was actually ended 
ReviewNotes    varchar(1000)  YES  Review notes for the case 
BlockID(FK)    int  YES  A foreign key to the BlockID column in the SXASRGBlock table. 
BlockDefinitionID    int  YES  The ID of the block definition associated with the case. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
PlannedStartDate    AS (CONVERT([date],[PlannedStartDateTimeUTC]))    The planned start date of the case. 
ActualStartDate    AS (CONVERT([date],[ActualStartDateTimeUTC]))    The actual start date of the case. 
PhysicalStatus    varchar(20)  YES  The physical status (ASA score) of the patient 

dbo.SXASRGCase Primary and Unique Keys 
Key Name  Key Type  Keys 
SXASRGCasePK  PrimaryKey  CaseID