dbo.CV3ObservationARC 
Default Table Name  CV3ObservationARC 
Definition  Contains older observation records. This table has a single clinical reading of a client characteristic. (Note: this is different from a basic observation which results from a diagnostic order.) Observations are recorded as part of a client document. 

dbo.CV3ObservationARC Columns 
ColumnName  Domain  Datatype  NULL  Definition 
GUID(PK)    HVCIDdt  NO  Auto generated unique primary key value. 
IsGenericItem    bit  NO  Identifies if this is a generic observation item. 1 = True; 0 = False 
UserGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3User table. 
IsClientCharacteristic    bit  NO  Indicates if this observation represents a client characteristic. 1 = True; 0 = False 
ObsItemGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3ObservationEntryItem table. 
PhysicalNoteType    varchar(30)  YES  The physical note type of the client characteristic. Needed only if IsClientCharacteristic is True 
RecordedProviderGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3CareProvider table. 
StatusType    int  NO  The status type. 1 = Active; 2 = Canceled 
StatusReason    varchar(255)  YES  Primarily used as a cancel reason. 
UnitOfMeasure    varchar(30)  YES  The default unit of measure for a numeric observation item, which is selected from the CV3UnitOfMeasure dictionary. 
NumDecimalsOut    int  NO  The number of decimal places allowed for entry and review of this observation. Defaults to 0 and must be positive 
UseNumericSeparator    bit  NO  Indicates whether the Windows defined attribute for display of large numbers is to be used (a comma). 1 = True; 0 = False 
ShiftDailyHourlyTotal    int  YES  Identifies if the total is a shift total, daily total or hourly total. 1-Shift total, 2-Daily(24 hr) total, 3-Hourly total 
EnterHeld    bit  YES  Specifies if the observation's value s to be held or not. 1-Held, 0- Not held. 
HasNote    bit  YES  Identifies if the charted cell has a note attached to it or not. 1-Note is attached, 0-No note attached. 
HasModifier    bit  YES  Identifies if the observation has a modifier attached to it or not. 1-Modifier is attached. 0-No modifier attached 
PatCondition    int  YES  The condition of the patient against the value charted1- Very Low, 2 - Low, 3 - High, 4 - Very High, 5 - Abnormal, 6 - Very Abnormal 
IsWDL    bit  YES  Does the Catalog Item have a WDL message associated with it? 
NoteGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3ClientDocumentARC table. 
HasImageType    tinyint  YES  Specifies the Type of Image. 0 - Locked 1 Annotated 
ValueText    varchar(max)  YES  PHI: A text representation of this observation's value. 
UserOccupationCode    varchar(30)  YES  PHI: Occupation of the CreatedBy user to display in the history dialog of the Observation parameter and Observation charted Value -Value of the field comes from CV3User.OccupationCode 
BaseImageReference    varchar(5)  YES  String indicating combination of sex/age/race of the base image used in charting. For example "MAC" would stand for a male/adult/caucasian. 
HotspotVersion    smallint  YES  Version of hotspots used for charting 
OrderTaskOccuranceGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3OrderTaskOccurrence table. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
ArcType(PK)(FK)    int  NO  A foreign key to the ArcType column in the CV3ClientDocumentARC table. 
FirstDocGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3ClientDocumentARC table. 
ObsAutoEnterType    int  NO  Stores how an observation was Auto Entered  

dbo.CV3ObservationARC Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3ObservationARCPK  PrimaryKey  GUID, ArcType