ColumnName |
Domain |
Datatype |
NULL |
Definition |
ObservationXInfoGUID |
|
HVCIDdt |
NO |
A foreign key to the GUID column in the CV3ObservationCUR table. |
IOSubtype |
|
varchar(60) |
YES |
A dictionary value from either the Intake or Output Subtypes dictionaries, depending on the Fluid Balance selection or the Calculation Type. |
IncludeInTotals |
|
bit |
NO |
Indicates if this item should be included in Total Intake/Output calculations by default. 1 = True; 0 = False |
InValue |
|
numeric(15, 5) |
YES |
Charted value IN of observation |
OutValue |
|
numeric(15, 5) |
YES |
Charted value OUT of observation |
DailyValue |
|
numeric(15, 5) |
YES |
The Cumulative 24 hr value |
BagNumber |
|
int |
YES |
Bag number attached |
BagVolumeUnit |
|
varchar(30) |
YES |
UOM for bag volume |
BagVolume |
|
numeric(15, 5) |
YES |
Volume of the bag attached |
InitialBagVolume |
|
numeric(15, 5) |
YES |
Initial volume of the bag |
BagAttributes |
|
smallint |
YES |
bit mask field for bag attributes related to drips (1-more than one bag within 24hr) |
ValueRate |
|
numeric(15, 5) |
YES |
The rate as charted in case of drip generic |
ValueDose |
|
numeric(15, 5) |
YES |
The dose as charted in case of drip generic |
PatConditionOut |
|
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, 7-Normal. By default is 7. |
FormattedValueText |
|
varchar(max) |
YES |
Formatted free text observation string |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
SmartPumpOrderTaskID |
|
bigint |
YES |
Refers to the SXACDSmartPumpOrderTask.SmartPumpOrderTaskID for which the data has been auto entered. |
SmartPumpEventInfo |
|
varchar(100) |
YES |
Holds the Smart Pump Event Type. E.g. Infusion Start, Infusion Stop, Rate Changed, Infusion Complete, KVO Start, KVO Stop, Bolus Start, Bolus Stop. |
DataCapturedAtUTC |
|
datetimeoffset(3) |
YES |
Holds the time in UTC at which the actual data was captured for a charted observation. For E.g. For Smart Pump observations, this field will hold the value of the infusion time provided by the Smart Pump, however, this value can be charted on a flowsheet with a different time.selected and charted for a flowsheet time column. |
FanoutSource |
|
varchar(100) |
YES |
Specifies the source of fanout. It can be Document Name in for SN to FS fanout and Order Name for Task to FS fanout. |
FanoutSourceType |
|
int |
YES |
Specifies the fanout source type. 1 = Flowsheet, 2 = Structured Notes, 3 = Task |
FanoutSourceUpdReason |
|
varchar(100) |
YES |
Store Observation Update Reason when something was changed on Source. |
ArcType |
|
int |
NO |
A foreign key to the ArcType column in the CV3ObservationCUR table. |