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  Unique primary key value. 

VersionGUID 
Definition  A foreign key to the GUID column in the CV3FlowsheetVersion table. 

IsMasterVersion 
Definition  A flag that indicates if this item is part of the master (default) version of the flowsheet. 1 = True; 0 = False 

ObsEntryItemGUID 
Definition  A foreign key to the GUID column in the CV3ObservationEntryItem table. 

IsIncluded 
Definition  A flag that indicates if this Observation Entry Item is to be included in this version of the flowsheet. 1 = True; 0 = False 

DisplayName 
Definition  The display name for this item as it is to appear in the flowsheet for this version. 

BackgroundColor 
Definition  Indicates the background color for this row. 

IsColorExtended 
Definition  A flag used for Observation Items only which indicates if the background color bar is to extend across the entire flowsheet for the item. 1 = True; 0 = False 

IsInitiallyCollapsed 
Definition  A flag used for Header, Observation Sets, and Observation Items which indicates if the item is initially contracted when the flowsheet is opened. 1 = True; 0 = False 

IsBold 
Definition  A flag that indicates if the display name should be in bold font. 1 = True; 0 = False 

IsItalic 
Definition  A flag that indicates if the display name should be in italic font. 1 = True; 0 = False 

IsMandatory 
Definition  A flag used for Observation Items and Observation Modifiers which indicates if the item is mandatory during data entry. 1 = True; 0 = False 

IsInitiallyGraphed 
Definition  A flag (used for Observation Items) only which indicates if the observation value is to be part of the default graph when viewing this flowsheet in the Trend View. 1 = True; 0 = False 

GraphLevelNum 
Definition  Integer field (used for Observation Items) only which contains the graph that this observation value should be displayed on. 

DefaultValueType 
Definition  An enumerated type with the following list of possible values: 1 = [None],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  A flag used for Observation Modification items that indicates if it is a pre-defined modifier. 1 = True; 0 = False 

IsDefaultProtected 
Definition  A flag (used for Observation Modifiers only) which indicates if the default is protected, meaning that the user cannot change it during data entry. 1 = True; 0 = False 

IsHidden 
Definition  A flag used for Observation Modifiers which indicates if the modifier is to be displayed on this version of the flowsheet. 1 = True; 0 = False 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

ShowAbnormalIcon 
Definition  Specifies whether to display an icon for an abnormal reading or not. 1-display, 0-don't display 

ShowVeryAbnormalIcon 
Definition  Specifies whether to display an icon for a very abnormal reading or not. 1-display, 0-don't display 

ShowHighIcon 
Definition  Specifies whether to display an icon for a High reading or not. 1-display, 0-don't display 

ShowVeryHighIcon 
Definition  Specifies whether to display an icon for a very high reading or not. 1-display, 0-don't display 

ShowLowIcon 
Definition  Specifies whether to display an icon for a low reading or not. 1-display, 0-don't display 

ShowVeryLowIcon 
Definition  Specifies whether to display an icon for a very low reading or not. 1-display, 0-don't display 

ActivatedWhen 
Definition  Visit TimeZone - Specifies the date and time when this observation was activated. 

CopyForwardHours 
Definition  Specifies how many hours it can go back to 'copy forward' the data. 

DiscontinuedColor 
Definition  Specifies the color to display for discontinued observations 

HeaderIndentation 
Definition  Specifies the indentation of the header on the Structured Note 

FieldIndentation 
Definition  Specifies the indentation of the field on the Structured Note 

FontColor 
Definition  Color of the font selected 

FontFace 
Definition  Specifies the font face 

Formula 
Definition  Specifies the formula for the observation 

FutureDateTime 
Definition  Enterprise TimeZone - The date and time in the future from when this row will be visible on the flowsheet and available for charting 

HighlightColor 
Definition  Color to be displayed when an item is highlighted. 

IsFanOut 
Definition  1 indicates observations charted, will fan-out to other flowsheets. For 0 fan out will be turn off. 

IsRelatedData 
Definition  1 indicates related data will be visible for particular observation. 

IsRemovable 
Definition  Stores 1 or 0 if the observation is removable or not 

ModifyComposition 
Definition  Specifies whether composition can be modified for the parameter or not. 1-Modify allowed, 0-Cannot modify. 

RelativeTime 
Definition  An enumerated type with the following list of possible values: 0 = [Start Of This Chart],1 = [Today],2 = [Yesterday],3 = [Three Days Ago],4 = [One Week Ago],5 = [Two Weeks Ago],6 = [One Month Ago],7 = [Three Months Ago],8 = [Six Months Ago],9 = [One Year Ago], 

ShadowColor 
Definition  The shaded color 

MandateAbove 
Definition  Specific Value the observations must be greater or equal to 

MandateBelow 
Definition  Specific Value the observation must be less than or equal to 

MandateEqualValidValueGUID 
Definition  The ValidValue that the current cell must be equal to 

MandateDepObsEntryItemGUID 
Definition  The ObservationEntryItem that determines if the absolute Mandates are to be applied 

MandateGUID 
Definition  The ObservationEntryItem that dictates the relative Mandate comparison Observation 

MandateType 
Definition  An enumerated type with the following list of possible values: 0 = [LessThan],1 = [GreaterThan], 

IsUnderLine 
Definition  Indicates if item is underlined 

IsSignificant 
Definition  Specifies whether the observation IsSignificant but not mandatory. 

SuppressCopyForward 
Definition  Suppresses an observation for structured notes not to copy forward the observation into the next note 

DefaultPreviousDocGUID 
Definition  Points to the actual place where the defaults come 

DefaultPreviousOEIGUID 
Definition  Points to the actual parameter where the defaults come 

DefaultPreviousSourceType 
Definition  An enumerated type with the following list of possible values: 0 = [Any Document],1 = [This Document],2 = [Specific Document], 

IsReferenceItemInNote 
Definition  Whether to reference the prior source in the note 

CopyForwardUnitType 
Definition  An enumerated type with the following list of possible values: 0 = [Hours],1 = [Days],2 = [Weeks],3 = [Months], 

OnChangeMLM 
Definition  The name of the MLM that will be executed when this item is charted or changed 

DefaultVisitScopeType 
Definition  An enumerated type with the following list of possible values: 0 = [This Visit],1 = [This Chart],2 = [All Available], 

ApplyDocEntryType 
Definition  An enumerated type with the following list of possible values: 0 = [None],1 = [Specific Value],2 = [Previous Value], 

ApplyDocEditType 
Definition  An enumerated type with the following list of possible values: 0 = [None],1 = [Specific Value],2 = [Previous Value], 

IsEOV 
Definition  Indicates whether the pull set will participate in EOV (End of Visit) calculations. This is enabled only when the pull set = Health Issues or Outpatient Medication Profile or Orders. When enabled, the record participates in the EOV (End of Visit) calculation as if it were in the pre 5.0 Assessment and Plan Section 

SuppressSaveInNote 
Definition  Should the charting of this item be suppressed when the note is saved? 

AutoEnterMLMName 
Definition  The new field stores the name of the MLM that will be invoked if auto enter is selected for that observation on the flowsheet. It can be configured for each observation on a flowsheet in the FlowSheet Catalog. 

IsSuppressExternalObsIn 
Definition  Turns on/off allowing inbound obs from external system for each parameter 

IsSuppressExternalObsOut 
Definition  Turns on/off allowing outbound obs from external system for each parameter 

IsUsePatientCharSelected 
Definition  Used to determine whether observation is configured to use patient characteristics value for auto enter. 

IsFanIn 
Definition  If this column is true then Fan-In is allowed and if false then fan-in is not allowed (suppressed). This will be set for the flowsheet versions. 

DocExLinkedObsEntryItemGUID 
Definition  Guid linked to the Selected flowsheet version Item 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

ShouldSyncDocumentSequenceWithTabSequence 
Definition  This flag to determine whether a Structured Note Catalog's document Sequence should always be in sync with Tab Sequences in its Form (in Form Builder) 

IsHideSmartPumpAlerts 
Definition  Holds the bit value whether to hide the Smart Pump alert window or not at the observation level.