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 |
|
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 |
|
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 |
|
int |
YES |
A foreign key to the SurgeryRolePolicyID column in the SXASRGSurgeryRolePolicy table. |
AnesthesiaTypeID |
|
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 |
|
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 |