dbo.CV3FlowsheetVersionItem 
Default Table Name  CV3FlowsheetVersionItem 
Definition  Defines the individual observation item and headings for a flowsheet configuration. When adding observations to flowsheets (can only add a observation to a master flowsheet), the entries are inserted into this table. The entries in this table are related one to one with the entries in CV3ObservationEntryItem. 

dbo.CV3FlowsheetVersionItem Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SiteID    smallint  YES  Identifies the unique distributed database ID where the row was inserted. Distributed databases are no longer supported so this column is deprecated. 
RepFlags    tinyint  YES  Indicates the action in a distributed database environment. Distributed databases are no longer supported so this column is deprecated. 
Build    int  NO  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    varchar(50)  YES  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    datetime  YES  The date and time that the row was last updated and will be based on the Enterprise time zone. 
CreatedBy    varchar(50)  YES  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    datetime  YES  The date and time that the row was created and will be based on the Enterprise time zone. 
Active    bit  NO  Denotes whether the row is active or not, 0 means the row has been soft deleted or deactivated. 
GUID(PK)    HVCIDdt  NO  Unique primary key value. 
VersionGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3FlowsheetVersion table. 
IsMasterVersion    tinyint  YES  A flag that indicates if this item is part of the master (default) version of the flowsheet. 1 = True; 0 = False 
ObsEntryItemGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3ObservationEntryItem table. 
IsIncluded    tinyint  YES  A flag that indicates if this Observation Entry Item is to be included in this version of the flowsheet. 1 = True; 0 = False 
DisplayName    varchar(500)  YES  The display name for this item as it is to appear in the flowsheet for this version. 
BackgroundColor    int  YES  Indicates the background color for this row. 
IsColorExtended    tinyint  YES  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    tinyint  YES  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    tinyint  YES  A flag that indicates if the display name should be in bold font. 1 = True; 0 = False 
IsItalic    tinyint  YES  A flag that indicates if the display name should be in italic font. 1 = True; 0 = False 
IsMandatory    tinyint  YES  A flag used for Observation Items and Observation Modifiers which indicates if the item is mandatory during data entry. 1 = True; 0 = False 
IsInitiallyGraphed    tinyint  YES  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    int  NO  Integer field (used for Observation Items) only which contains the graph that this observation value should be displayed on. 
DefaultValueType    int  NO  An enumerated type with the following list of possible values: 1 = [None],2 = [Previous],3 = [Specific], 
SpecificDefault    varchar(max)  YES  Contains a specific value to default for the observation item or modifier when the flowsheet is displayed for data entry. 
IsPredefinedModifier    tinyint  YES  A flag used for Observation Modification items that indicates if it is a pre-defined modifier. 1 = True; 0 = False 
IsDefaultProtected    tinyint  YES  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    tinyint  YES  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    uniqueidentifier  YES  Optimistic lock identifier. 
ShowAbnormalIcon    bit  YES  Specifies whether to display an icon for an abnormal reading or not. 1-display, 0-don't display 
ShowVeryAbnormalIcon    bit  YES  Specifies whether to display an icon for a very abnormal reading or not. 1-display, 0-don't display 
ShowHighIcon    bit  YES  Specifies whether to display an icon for a High reading or not. 1-display, 0-don't display 
ShowVeryHighIcon    bit  YES  Specifies whether to display an icon for a very high reading or not. 1-display, 0-don't display 
ShowLowIcon    bit  YES  Specifies whether to display an icon for a low reading or not. 1-display, 0-don't display 
ShowVeryLowIcon    bit  YES  Specifies whether to display an icon for a very low reading or not. 1-display, 0-don't display 
ActivatedWhen    datetime  YES  Visit TimeZone - Specifies the date and time when this observation was activated. 
CopyForwardHours    tinyint  YES  Specifies how many hours it can go back to 'copy forward' the data. 
DiscontinuedColor    int  YES  Specifies the color to display for discontinued observations 
HeaderIndentation    int  YES  Specifies the indentation of the header on the Structured Note 
FieldIndentation    int  YES  Specifies the indentation of the field on the Structured Note 
FontColor    int  YES  Color of the font selected 
FontFace    varchar(30)  YES  Specifies the font face 
Formula    varchar(1000)  YES  Specifies the formula for the observation 
FutureDateTime    datetime  YES  Enterprise TimeZone - The date and time in the future from when this row will be visible on the flowsheet and available for charting 
HighlightColor    int  YES  Color to be displayed when an item is highlighted. 
IsFanOut    bit  YES  1 indicates observations charted, will fan-out to other flowsheets. For 0 fan out will be turn off. 
IsRelatedData    bit  YES  1 indicates related data will be visible for particular observation. 
IsRemovable    bit  YES  Stores 1 or 0 if the observation is removable or not 
ModifyComposition    bit  YES  Specifies whether composition can be modified for the parameter or not. 1-Modify allowed, 0-Cannot modify. 
RelativeTime    tinyint  YES  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    int  YES  The shaded color 
MandateAbove    numeric(15, 5)  YES  Specific Value the observations must be greater or equal to 
MandateBelow    numeric(15, 5)  YES  Specific Value the observation must be less than or equal to 
MandateEqualValidValueGUID    HVCIDdt  YES  The ValidValue that the current cell must be equal to 
MandateDepObsEntryItemGUID    HVCIDdt  YES  The ObservationEntryItem that determines if the absolute Mandates are to be applied 
MandateGUID    HVCIDdt  YES  The ObservationEntryItem that dictates the relative Mandate comparison Observation 
MandateType    smallint  YES  An enumerated type with the following list of possible values: 0 = [LessThan],1 = [GreaterThan], 
IsUnderLine    bit  NO  Indicates if item is underlined 
IsSignificant    bit  YES  Specifies whether the observation IsSignificant but not mandatory. 
SuppressCopyForward    bit  YES  Suppresses an observation for structured notes not to copy forward the observation into the next note 
DefaultPreviousDocGUID    HVCIDdt  YES  Points to the actual place where the defaults come 
DefaultPreviousOEIGUID    HVCIDdt  YES  Points to the actual parameter where the defaults come 
DefaultPreviousSourceType    int  YES  An enumerated type with the following list of possible values: 0 = [Any Document],1 = [This Document],2 = [Specific Document], 
IsReferenceItemInNote    bit  YES  Whether to reference the prior source in the note 
CopyForwardUnitType    int  YES  An enumerated type with the following list of possible values: 0 = [Hours],1 = [Days],2 = [Weeks],3 = [Months], 
OnChangeMLM    varchar(80)  YES  The name of the MLM that will be executed when this item is charted or changed 
DefaultVisitScopeType    int  YES  An enumerated type with the following list of possible values: 0 = [This Visit],1 = [This Chart],2 = [All Available], 
ApplyDocEntryType    int  YES  An enumerated type with the following list of possible values: 0 = [None],1 = [Specific Value],2 = [Previous Value], 
ApplyDocEditType    int  YES  An enumerated type with the following list of possible values: 0 = [None],1 = [Specific Value],2 = [Previous Value], 
IsEOV    bit  NO  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    bit  YES  Should the charting of this item be suppressed when the note is saved? 
AutoEnterMLMName    varchar(80)  YES  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    bit  NO  Turns on/off allowing inbound obs from external system for each parameter 
IsSuppressExternalObsOut    bit  NO  Turns on/off allowing outbound obs from external system for each parameter 
IsUsePatientCharSelected    bit  NO  Used to determine whether observation is configured to use patient characteristics value for auto enter. 
IsFanIn    bit  NO  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    HVCIDdt  YES  Guid linked to the Selected flowsheet version Item 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
ShouldSyncDocumentSequenceWithTabSequence    bit  NO  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    bit  NO  Holds the bit value whether to hide the Smart Pump alert window or not at the observation level. 

dbo.CV3FlowsheetVersionItem Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3FlowsheetVersionItemPK  PrimaryKey  GUID