ColumnName |
Domain |
Datatype |
NULL |
Definition |
GUID |
|
HVCIDdt |
NO |
Auto generated unique primary key value. |
IsGenericItem |
|
bit |
NO |
Identifies if this is a generic observation item. 1 = True; 0 = False |
UserGUID |
|
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 |
|
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 |
|
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 |
|
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 |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3OrderTaskOccurrence table. |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
ArcType |
|
int |
NO |
A foreign key to the ArcType column in the CV3ClientDocumentARC table. |
FirstDocGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3ClientDocumentARC table. |
ObsAutoEnterType |
|
int |
NO |
Stores how an observation was Auto Entered |