dbo.SXAANCExam 
Default Table Name  SXAANCExam 
Definition  Defines a radiology order that will progress troguh the department workflow 

dbo.SXAANCExam 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. 
MSRowVersion    timestamp  NO  Optimistic lock identifier using rowversion datatype. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
ExamId(PK)    bigint  NO  Auto generated unique primary key value. 
AccessionNumber    varchar(50)  NO  Accession number for the exam 
ClientGUID(FK)    HVCIDdt  NO  A foreign key to the GUID column in the CV3Client table. 
OrderGUID    HVCIDdt  NO  Order GUID from CV#Order table 
LocnGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Location table. 
ExamDate    date  YES  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(FK)    bigint  NO  A foreign key to the ProcedureId column in the SXAANCProcedure table. 
PriorityCode    varchar(30)  YES  priority associated with this exam 
ExamStatusId(FK)    int  NO  A foreign key to the ExamStatusID column in the SXAANCExamStatus table. 
SideOrLevel    varchar(50)  YES  side or level for the exam 
ClientVisitGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3ClientVisit table. 
FacilityGUID    HVCIDdt  YES  Visit guid for the order 
TranspMethodCode    varchar(30)  YES  Patient transport method code 
ArrivalDateTimeUTC    datetimeoffset(3)  YES  Date time when patient arrives to radiology facility 
AUCScore    varchar(5)  YES  store AUC information 
DSN    varchar(50)  YES  store DSN information 
IDCode    varchar(15)  YES  IDCode from CV3Order 
RADSTypeCategoryId(FK)    int  YES  A foreign key to the CategoryID column in the SXAANCRADSTypeCategory table. 
StartDateTimeUTC    datetimeoffset(3)  YES  Used to store exam start date & time 
EndDateTimeUTC    datetimeoffset(3)  YES  Used to store exam end date & time 
ExamDateTimeUTC    datetimeoffset(3)  YES  Used to store Exam Date 
TechDocGuid    HVCIDdt  YES  It stores the document GUID for technician document 
LocationFunGrpGuid(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3LocationFunctionGroup table. 
IsErrorResult    bit  NO  Indicates that Radiology Exam contains Erroneous Result 
BDClassID(FK)    int  YES  A foreign key to the BDClassId column in the SXAANCBreastDensity table. 
LegacyLocation    varchar(35)  YES  Ppulates the Exam description from legacy Database if map doesn't exist in EMR RIS 
TechNotes    varchar(max)  YES  PHI: Contains Tech notes that are migrated from legacy RIS. 
StudyInstanceUID    varchar(64)  YES  DICOM Study Instance UID 
LegacyAccessionNumber    varchar(50)  YES  It stores the legacy accession number of Migrated Exam 
ProtocolStatusID    int  NO  Used to store Exam's Protocol status id 
ProtocolDocGUID    HVCIDdt  YES  Used to store Exam's Protocol template document GUID 
AppointmentDateTimeUTC    datetimeoffset(3)  YES  Used to store Exam's appointment date/time 
ExamCustomStatusId    int  YES  Custom status Id of exam 
LastModifiedUser    varchar(50)  NO  Last modified user of exam status, custom status, protocol status except dicom status 
StatusModifiedWhenUTC    datetimeoffset(7)  NO  Last modified datetime of exam status, custom status, protocol status except dicom status 
IsOrderCancelled    bit  NO  Indicates SCM order is cancelled/discontinued 
IsInterpretationRequired    bit  NO  Flag for storing whether interpretation required for Exam 

dbo.SXAANCExam Primary and Unique Keys 
Key Name  Key Type  Keys 
SXAANCExamPK  PrimaryKey  ExamId