dbo.SXASRGProcedure 
Default Table Name  SXASRGProcedure 
Definition  This surgery table contains the surgical procedures that wil be performed in the Operating room. 

dbo.SXASRGProcedure 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. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
ProcedureID(PK)    int  NO  Auto generated unique primary key value. 
IDCode    varchar(50)  NO  Identifier code for the Procedure. 
AlternateID    varchar(50)  YES  Alternate procedure identifier code 
Name    varchar(150)  NO  Procedure Name 
ShortName    varchar(50)  YES  User defined abbreviation of the procedure name 
AltSearchTerm    varchar(255)  YES  Alternate name for searching procedures 
Description    varchar(2000)  YES  Procedure description 
ServiceID    int  YES  Link to the Surgical service 
SetupTime    smallint  YES  total set up time needed for the procedure in minutes 
ProcedureTime    smallint  NO  total time the procedure will take in minutes 
CleanUpTime    smallint  YES  procedure clean up time in minutes 
SubProcedureTime    smallint  NO  Time the procedure would take if it was performed as a sub procedure 
AcuityID(FK)    int  YES  A foreign key to the AcuityID column in the SXASRGAcuity table. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
LateralityDictionaryGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3UserDictionary table. 
SiteDictionaryGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3UserDictionary table. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.SXASRGProcedure Primary and Unique Keys 
Key Name  Key Type  Keys 
SXASRGProcedurePK  PrimaryKey  ProcedureID