SiteID 
Definition  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 

RepFlags 
Definition  Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. 

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. 

TouchedWhen 
Definition  The date and time that the row was last updated and will be 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. 

CreatedWhen 
Definition  The date and time that the row was created and will be based on the Enterprise time zone. 

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

GUID 
Definition  Unique primary key value. 

Entered 
Definition  Visit TimeZone - The date and time the result was received. 

Status 
Definition  The chart item status. F = Final; I = Pending; P = Prelim; R = NotVerified; S = Partial; C = Corrected; D = Delete 

ToBeVerified 
Definition  Not used. 1 = True; 0 = False 

ToBeSigned 
Definition  Not used. 1 = True; 0 = False 

EnterRole 
Definition  Not used. 

UserGUID 
Definition  A foreign key to the GUID column in the CV3User table. 

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

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

ChartGUID 
Definition  A foreign key to the GUID column in the CV3Chart table. 

ItemName 
Definition  The name of the result item. Denormalized from CV3ResultCatalogItem 

RestrictedAccess 
Definition  Restricted access flag from the result catalog item. 1 = True; 0 = False 

AuthorizedDtm 
Definition  Visit TimeZone - Not used. 

ClusterID 
Definition  Used to group observations together (specifically Microbiology results). 

Value 
Definition  The result value. See CV3TextualObservationLine for long text results. 

TypeCode 
Definition  The type of result. FT = Fixed Text; CT = Compressed Text; N = Numeric; LT = LongText 

IsHistory 
Definition  Indicates if this is an historical result. 1 = True; 0 = False; see MasterGUID for link to current result 

IsTextual 
Definition  Indicates if the result has textual result information. 1 = True; 0 = False 

HasHistory 
Definition  Indicates if there are historical results. 1 = True; 0 = False 

AbnormalityCode 
Definition  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 
Definition  The upper limit of the reference value. 

ReferenceLowerLimit 
Definition  The lower limit of the reference value. 

UnitOfMeasure 
Definition  The unit of measure for the result. 

OrderGUID 
Definition  A foreign key to the GUID column in the CV3Order table. 

ResultItemGUID 
Definition  A foreign key to the GUID column in the CV3ResultCatalogItem table. 

MasterGUID 
Definition  A foreign key to the GUID column in the CV3BasicObservation table. 

ArrivalDtm 
Definition  Visit TimeZone - The date and time the result arrived at the Primary Active database. 

HasMediaLink 
Definition  Indicates if this result has a link to a multi-media object (for example, an image). 1 = True; 0 = False 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

IsReleasedToPatient 
Definition  1 - Released; 0-Not Released. Is a nullable filed, when it is NULL, it means no decision has been made 

ObservationDtm 
Definition  Visit TimeZone - Date time of the observation 

PerformingOrganizationObserverID 
Definition  Link to CV3PerformingOrganizationPerson table for Responsible Observer. 

PerformingOrganizationID 
Definition  Link to CV3PerformingOrganization table for Performing Organization. 

PerformingOrganizationAddressID 
Definition  Identifies address of the performing organization. Links to CV3PerformingOrganizationAddress. 

PerformingOrganizationDirectorID 
Definition  Identifies the medical director of the performing organization. Links to CV3PerformingOrganizationPerson. 

AnalysisDtm 
Definition  Visit TimeZone - Date time of the Analysis 

ResultItemCode 
Definition  Ancillary Code for result item 

ResultItemCodingStandard 
Definition  Ancillary Coding Standard for result item 

ValueCode 
Definition  The code for a coded value 

ValueCodingStandard 
Definition  The coding standard for the coded value 

AlternateValueCode 
Definition  Stores data from OBX-5.4 

AlternateValue 
Definition  Stores data from OBX-5.5 

AlternateValueCodingStandard 
Definition  Stores data from OBX-5.6 

CodingSystemVersionID 
Definition  Stores data from OBX-5.7 

AlternateCodingSystemVersionID 
Definition  Stores data from OBX-5.8 

ObsMethodCode 
Definition  Stores data from OBX-17.1 

ObsMethodText 
Definition  Stores data from OBX-17.2 

ObsMethodCodingStandard 
Definition  Stores data from OBX-17.3 

ObsMethodAltObservationMethodCode 
Definition  Stores data from OBX-17.4 

ObsMethodAltObservationMethodText 
Definition  Stores data from OBX-17.5 

ObsMethodAltCodingStandard 
Definition  Stores data from OBX-17.6 

ObsMethodCodingStandardVersionId 
Definition  Stores data from OBX-17.7 

ObsMethodAltCodingStandardVersionId 
Definition  Stores data from OBX-17.8 

CommentStartPosition 
Definition  When an observation has textual results, this number indicates the starting position of the comment portion (comments are appended to the end) 

HL7AbnormalityCode 
Definition  Stores the original abnormality code as it was sent in via HL7 

ObsDataType 
Definition  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 
Definition  Unique GUID used to support merge replication. 

IsHoldFromOrder 
Definition  Is Hold fromorder