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. 

MSRowVersion 
Definition  Optimistic lock identifier using rowversion datatype. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

Active 
Definition  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 

ExamId 
Definition  Auto generated unique primary key value. 

AccessionNumber 
Definition  Accession number for the exam 

ClientGUID 
Definition  A foreign key to the GUID column in the CV3Client table. 

OrderGUID 
Definition  Order GUID from CV#Order table 

LocnGUID 
Definition  A foreign key to the GUID column in the CV3Location table. 

ExamDate 
Definition  before the exam is performed, this is the requested date. Once the exam is performed, this is the actual date when the exam is performed 

ProcedureId 
Definition  A foreign key to the ProcedureId column in the SXAANCProcedure table. 

PriorityCode 
Definition  priority associated with this exam 

ExamStatusId 
Definition  A foreign key to the ExamStatusID column in the SXAANCExamStatus table. 

SideOrLevel 
Definition  side or level for the exam 

ClientVisitGUID 
Definition  A foreign key to the GUID column in the CV3ClientVisit table. 

FacilityGUID 
Definition  Visit guid for the order 

TranspMethodCode 
Definition  Patient transport method code 

ArrivalDateTimeUTC 
Definition  Date time when patient arrives to radiology facility 

AUCScore 
Definition  store AUC information 

DSN 
Definition  store DSN information 

IDCode 
Definition  IDCode from CV3Order 

RADSTypeCategoryId 
Definition  A foreign key to the CategoryID column in the SXAANCRADSTypeCategory table. 

StartDateTimeUTC 
Definition  Used to store exam start date & time 

EndDateTimeUTC 
Definition  Used to store exam end date & time 

ExamDateTimeUTC 
Definition  Used to store Exam Date 

TechDocGuid 
Definition  It stores the document GUID for technician document 

LocationFunGrpGuid 
Definition  A foreign key to the GUID column in the CV3LocationFunctionGroup table. 

IsErrorResult 
Definition  Indicates that Radiology Exam contains Erroneous Result 

BDClassID 
Definition  A foreign key to the BDClassId column in the SXAANCBreastDensity table. 

LegacyLocation 
Definition  Ppulates the Exam description from legacy Database if map doesn't exist in EMR RIS 

TechNotes 
Definition  PHI: Contains Tech notes that are migrated from legacy RIS. 

StudyInstanceUID 
Definition  DICOM Study Instance UID 

LegacyAccessionNumber 
Definition  It stores the legacy accession number of Migrated Exam 

ProtocolStatusID 
Definition  Used to store Exam's Protocol status id 

ProtocolDocGUID 
Definition  Used to store Exam's Protocol template document GUID 

AppointmentDateTimeUTC 
Definition  Used to store Exam's appointment date/time 

ExamCustomStatusId 
Definition  Custom status Id of exam 

LastModifiedUser 
Definition  Last modified user of exam status, custom status, protocol status except dicom status 

StatusModifiedWhenUTC 
Definition  Last modified datetime of exam status, custom status, protocol status except dicom status 

IsOrderCancelled 
Definition  Indicates SCM order is cancelled/discontinued 

IsInterpretationRequired 
Definition  Flag for storing whether interpretation required for Exam