ColumnName |
Domain |
Datatype |
NULL |
Definition |
SiteID |
|
smallint |
YES |
Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. |
RepFlags |
|
tinyint |
YES |
Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. |
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) |
YES |
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. |
TouchedWhen |
|
datetime |
YES |
The date and time that the row was last updated and will be based on the Enterprise time zone. |
CreatedBy |
|
varchar(50) |
YES |
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. |
CreatedWhen |
|
datetime |
YES |
The date and time that the row was created and will be 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. |
GUID |
|
HVCIDdt |
NO |
Unique primary key value. |
Entered |
|
datetime |
YES |
Visit TimeZone - The date and time the result was received. |
Status |
|
varchar(10) |
YES |
The chart item status. F = Final; I = Pending; P = Prelim; R = NotVerified; S = Partial; C = Corrected; D = Delete |
ToBeVerified |
|
bit |
NO |
Not used. 1 = True; 0 = False |
ToBeSigned |
|
bit |
NO |
Not used. 1 = True; 0 = False |
EnterRole |
|
varchar(30) |
YES |
Not used. |
UserGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3User table. |
ClientVisitGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3ClientVisit table. |
ClientGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3Client table. |
ChartGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3Chart table. |
ItemName |
|
varchar(125) |
YES |
The name of the result item. Denormalized from CV3ResultCatalogItem |
RestrictedAccess |
|
bit |
NO |
Restricted access flag from the result catalog item. 1 = True; 0 = False |
AuthorizedDtm |
|
datetime |
YES |
Visit TimeZone - Not used. |
ClusterID |
|
varchar(20) |
YES |
Used to group observations together (specifically Microbiology results). |
Value |
|
varchar(60) |
YES |
The result value. See CV3TextualObservationLine for long text results. |
TypeCode |
|
varchar(2) |
YES |
The type of result. FT = Fixed Text; CT = Compressed Text; N = Numeric; LT = LongText |
IsHistory |
|
bit |
NO |
Indicates if this is an historical result. 1 = True; 0 = False; see MasterGUID for link to current result |
IsTextual |
|
bit |
NO |
Indicates if the result has textual result information. 1 = True; 0 = False |
HasHistory |
|
bit |
NO |
Indicates if there are historical results. 1 = True; 0 = False |
AbnormalityCode |
|
varchar(5) |
YES |
The level of abnormality of the result. HH = Very High; H = High; LL = Very Low; L = Low; AA = Very Abnormal Txt; A = Abnormal Txt |
ReferenceUpperLimit |
|
varchar(60) |
YES |
The upper limit of the reference value. |
ReferenceLowerLimit |
|
varchar(60) |
YES |
The lower limit of the reference value. |
UnitOfMeasure |
|
varchar(15) |
YES |
The unit of measure for the result. |
OrderGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3Order table. |
ResultItemGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3ResultCatalogItem table. |
MasterGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3BasicObservation table. |
ArrivalDtm |
|
datetime |
YES |
Visit TimeZone - The date and time the result arrived at the Primary Active database. |
HasMediaLink |
|
tinyint |
YES |
Indicates if this result has a link to a multi-media object (for example, an image). 1 = True; 0 = False |
MSrepl_tran_version |
|
uniqueidentifier |
YES |
Optimistic lock identifier. |
IsReleasedToPatient |
|
bit |
YES |
1 - Released; 0-Not Released. Is a nullable filed, when it is NULL, it means no decision has been made |
ObservationDtm |
|
datetime |
YES |
Visit TimeZone - Date time of the observation |
PerformingOrganizationObserverID |
|
bigint |
YES |
Link to CV3PerformingOrganizationPerson table for Responsible Observer. |
PerformingOrganizationID |
|
int |
YES |
Link to CV3PerformingOrganization table for Performing Organization. |
PerformingOrganizationAddressID |
|
bigint |
YES |
Identifies address of the performing organization. Links to CV3PerformingOrganizationAddress. |
PerformingOrganizationDirectorID |
|
bigint |
YES |
Identifies the medical director of the performing organization. Links to CV3PerformingOrganizationPerson. |
AnalysisDtm |
|
datetime |
YES |
Visit TimeZone - Date time of the Analysis |
ResultItemCode |
|
varchar(125) |
YES |
Ancillary Code for result item |
ResultItemCodingStandard |
|
varchar(60) |
YES |
Ancillary Coding Standard for result item |
ValueCode |
|
varchar(125) |
YES |
The code for a coded value |
ValueCodingStandard |
|
varchar(30) |
YES |
The coding standard for the coded value |
AlternateValueCode |
|
varchar(20) |
YES |
Stores data from OBX-5.4 |
AlternateValue |
|
varchar(200) |
YES |
Stores data from OBX-5.5 |
AlternateValueCodingStandard |
|
varchar(15) |
YES |
Stores data from OBX-5.6 |
CodingSystemVersionID |
|
varchar(10) |
YES |
Stores data from OBX-5.7 |
AlternateCodingSystemVersionID |
|
varchar(10) |
YES |
Stores data from OBX-5.8 |
ObsMethodCode |
|
varchar(20) |
YES |
Stores data from OBX-17.1 |
ObsMethodText |
|
varchar(200) |
YES |
Stores data from OBX-17.2 |
ObsMethodCodingStandard |
|
varchar(20) |
YES |
Stores data from OBX-17.3 |
ObsMethodAltObservationMethodCode |
|
varchar(20) |
YES |
Stores data from OBX-17.4 |
ObsMethodAltObservationMethodText |
|
varchar(200) |
YES |
Stores data from OBX-17.5 |
ObsMethodAltCodingStandard |
|
varchar(20) |
YES |
Stores data from OBX-17.6 |
ObsMethodCodingStandardVersionId |
|
varchar(10) |
YES |
Stores data from OBX-17.7 |
ObsMethodAltCodingStandardVersionId |
|
varchar(10) |
YES |
Stores data from OBX-17.8 |
CommentStartPosition |
|
int |
YES |
When an observation has textual results, this number indicates the starting position of the comment portion (comments are appended to the end) |
HL7AbnormalityCode |
|
varchar(30) |
YES |
Stores the original abnormality code as it was sent in via HL7 |
ObsDataType |
|
int |
YES |
An enumerated type with the following list of possible values: 0 = [Unknown],1 = [CE],2 = [CWE],3 = [CX],4 = [DT],5 = [ED],6 = [FT],7 = [NM],8 = [RP],9 = [SN],10 = [ST],11 = [TM],12 = [TS],13 = [TX], |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
IsHoldFromOrder |
|
bit |
NO |
Is Hold fromorder |