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  Auto generated unique primary key value. 

ClientGUID 
Definition  The link to the client. 

OwnerGUID 
Definition  The link to the Chart Flowsheet that owns these reference items. 

IsUpdate 
Definition  Indicates if this is only an update of an existing item's display name or included state. 1 = True; 0 = False 

ObsEntryItemGUID 
Definition  The link to the parent Observation Entry Item. 

IsItemActive 
Definition  Indicates whether or not the item referenced is active. 1 = True; 0 = False 

IsIncluded 
Definition  Indicates if the item referenced should be shown when this flowsheet is displayed for this patient. 1 = True; 0 = False 

DisplayName 
Definition  Contains the display name for this row. 

CanChangeName 
Definition  Indicates if the display name of a generic item can be changed. 1 = True; 0 = False 

ItemType 
Definition  Indicates the type of observation item for added items. 1 = Header; 2 = Intake Subtotal; 3 = Output Subtotal; 4 = Net Balance; 5 = Observation Item; 6 = Observation Set; 7 = Observation Modifier 

ParentGUID 
Definition  Contains the link to the parent Client Obs Entry Item. 

DisplaySequence 
Definition  Used for observations added on the fly. Represents the sequence of the added item as it appears in the main flowsheet configuration. 

ObsMasterItemGUID 
Definition  The link to the observation catalog master item. 

ObsItemGUID 
Definition  The link to the observation catalog item. 

ObsSetGUID 
Definition  The link to the observation catalog set. 

ObsSetItemGUID 
Definition  The link to the observation catalog set item. 

ObsModifierGUID 
Definition  The link to the observation modifier. 

ObsModifierXrefGUID 
Definition  The link to the observation modifier cross-reference. 

IsMasterItem 
Definition  Indicates if an item of type Observation Item is a master item. 1 = True; 0 = False 

DefaultValueType 
Definition  Indicates the type of default value that should be used when the flowsheet is displayed for data entry. 1 = NoDefaultValue; 2 = Previous; 3 = Specific 

SpecificDefault 
Definition  Contains a specific value to default for the observation item or modifier when the flowsheet is displayed for data entry. 

IsPredefinedModifier 
Definition  Used for Observation Modifier items to indicate they are pre-defined modifiers. 1 = True; 0 = False 

IsDefaultProtected 
Definition  Used for Observation Modifiers only to indicate if the default is protected (meaning that the user cannot change it during data entry). 1 = True; 0 = False 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

EnteredWhen 
Definition  Visit TimeZone - Identifies the date time entered/set by user during modify parameter 

HasComment 
Definition  A Flag. Specifies whether the row has a comment attached to it or not. 1-Comment attached. 0-No comment attached 

HasComponents 
Definition  A flag. Identifies whether this observation has components attached to it or not. 1-Componnets are attached. 0-no components. 

HistorySeqNum 
Definition  A sequential number to indicate historical data. 

IsFanOut 
Definition  A flag. Indicates whether this client level observation entry item is applicable for fanout or not. 1-can be fanned out. 0-No fanout 

IsGenericItem 
Definition  A flag. Indicates whether this is a generic item or not. 1-Generic item (can be added multiple times) 0-Non generic, "add only once" type item. 

IsGrouped 
Definition  An enumerated type with the following list of possible values: 0 = [Unbordered],1 = [Bordered],2 = [Merged], 

Rate 
Definition  Rate of administering the intake fluid 

RateUnit 
Definition  UOM for rate 

Site 
Definition  Site where the intake fluid is administered 

State 
Definition  State of the parameter. 1-Active, 2- Cancelled, 3-Discontinued 

TotalVolume 
Definition  Total volume for the parameter 

TotalVolumeUnit 
Definition  UOM for total volume 

IsLocked 
Definition  Indicates whether this parameter can be locked 

MonitorChannelGUID 
Definition  The Monitor Channel attached to the parameter 

OrgObservationGUID 
Definition  Used if this is an historical observation 

RecordedProviderGUID 
Definition  Add field RecordedProviderGUID 

SubSequence 
Definition  Identifies the order of display of the client level parameters, which have same ‘DisplaySequence’. 

FanoutParentGUID 
Definition  This field will store the GUID of the parameter due to which the fanout was initiated 

IsDaylightSavings 
Definition  a flag to indicate additional set of time columns on flowsheets for 1-2am for the additional hour gained during daylight savings time. 

SiteDevice 
Definition  String to further define Site. For example if the site is left arm and there is an IV tube, then a further description of the IV tube may be 18 gauge. This field will map to "Type" on UI/config. 

UserOccupationCode 
Definition  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 

SourceSystem 
Definition  Source system when row is added to flowsheet via receipt of inbound observation. 

MSReplrowguid 
Definition  Unique GUID used to support merge replication.