dbo.CV3ObservationXInfoCUR 
Default Table Name  CV3ObservationXInfoCUR 
Definition  Contains current observation records. This table stores extended information for the Observation table when ParameterType in (3=Intake,4=Output,5=Drip). 

dbo.CV3ObservationXInfoCUR Columns 
ColumnName  Domain  Datatype  NULL  Definition 
ObservationXInfoGUID(PK)(FK)    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(PK)(FK)    int  NO  A foreign key to the ArcType column in the CV3ObservationCUR table. 

dbo.CV3ObservationXInfoCUR Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3ObservationXInfoCURPK  PrimaryKey  ObservationXInfoGUID, ArcType