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 |
|
bigint |
NO |
Auto generated unique primary key value. |
AccessionNumber |
|
varchar(50) |
NO |
Accession number for the exam |
ClientGUID |
|
HVCIDdt |
NO |
A foreign key to the GUID column in the CV3Client table. |
OrderGUID |
|
HVCIDdt |
NO |
Order GUID from CV#Order table |
LocnGUID |
|
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 |
|
bigint |
NO |
A foreign key to the ProcedureId column in the SXAANCProcedure table. |
PriorityCode |
|
varchar(30) |
YES |
priority associated with this exam |
ExamStatusId |
|
int |
NO |
A foreign key to the ExamStatusID column in the SXAANCExamStatus table. |
SideOrLevel |
|
varchar(50) |
YES |
side or level for the exam |
ClientVisitGUID |
|
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 |
|
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 |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3LocationFunctionGroup table. |
IsErrorResult |
|
bit |
NO |
Indicates that Radiology Exam contains Erroneous Result |
BDClassID |
|
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 |