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. 

FlowsheetGUID 
Definition  A foreign key to the GUID column in the CV3Flowsheet table. 

IsMaster 
Definition  A flag that indicates whether this version is the master or default version of the flowsheet. 1 = True; 0 = False 

Name 
Definition  Contains the name of the flowsheet version. 

ShowNormalRange 
Definition  A flag that indicates whether the Normal Range column should be initially displayed when the flowsheet version is opened or shown. 1 = True; 0 = False 

ObsColumnBGColor 
Definition  Indicates the background color for the observation columns. 

NRColumnBGColor 
Definition  Indicates the background color for the Normal Range column. 

HeaderRowBGColor 
Definition  Indicates the default background color for all header rows. 

TimeIntervalType 
Definition  An enumerated type with the following list of possible values: 1 = [Actual],2 = [Minutes],3 = [Hours],4 = [Days], 

TimeIntervalNum 
Definition  Integer field which represents the number of hours, days, or weeks to condense the flowsheet columns to when it is being displayed. Must be positive number 

DefaultSinceTimeType 
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], 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

MasterGUID 
Definition  The GUID of the master from which this version is derived 

AfterDischargeHours 
Definition  Number of hours after discharge of patient, after which the flowsheet cannot be charted. 

AutoGenerateFrequency 
Definition  Frequency of hours for auto generated columns in a flowsheet. 

AutoGenerateTime 
Definition  Stores the number of hours to auto generate 

ColumnsToFetch 
Definition  Identifies how many columns to fetch for every call in pagination. 

DailyTotalBGColor 
Definition  Background color for Daily total value 

DailyTotalFGColor 
Definition  Foreground color for Daily total value 

DailyTotalStartTime 
Definition  Start time for daily total value 

FixedColWidth 
Definition  Stores the fixed width of column 

FixedRowHeight 
Definition  Stores the fixed height of row. 

FutureChartingHours 
Definition  Specifies for how many hours in future can the flowsheet be charted. 

HeaderFont 
Definition  This stores the header font type. 

HeaderFontColor 
Definition  Specifies the font color of the observation 

IsBottomLOSBBT 
Definition  Specifies where to display LOS and BBT totals. 1-Show at bottom, 0-show at top 

IsFixedHeightWidth 
Definition  Specifies whether row/column has fixed height/width or not. 1-Fixed, 0-not fixed 

IsIntakeOutput 
Definition  Indicates if the flowsheet is an IO flowsheet or a non-IO flowsheet. 1-IO flowsheet, 0-Non-IO flowsheet. 

ItemFont 
Definition  Specifies font type of observation item. 

ItemFontColor 
Definition  Specifies the font color of the observation item 

MaxColWidth 
Definition  Specifies the maximum column width for a flowsheet 

MaxRowHeight 
Definition  Specifies the maximum row height for a flowsheet 

MinColWidth 
Definition  Specifies the minimum column width for a flowsheet 

MinRowHeight 
Definition  Specifies the minimum row height for a flowsheet 

OffSetHours 
Definition  The offset hours 

ShiftTotalBGColor 
Definition  Specifies the background color of the ShiftTotal value 

ShiftTotalFGColor 
Definition  Specifies the foreground color of the ShiftTotal value 

ShowBloodBalanceTotal 
Definition  Specifies if the blood balance total should be displayed or not. 1-show the total, 0-don't show. 

ShowLOSTotal 
Definition  Specifies that whether or not to include IO Category Summary Totals. 1-Include, 0-Don't include 

SuppressRangeIcons 
Definition  Specifies if the range icons should be suppressed from display or not. 1-supress, 0-don't suppress 

SuppressFanOut 
Definition  Specifies if the Fan Out should be suppressed on the flowsheet. 1-supress, 0-don't suppress 

DocumentType 
Definition  An enumerated type with the following list of possible values: 1 = [Flowsheet],2 = [StructuredNote], 

Description 
Definition  Flowsheet version description 

IsExpandedFormat 
Definition  Determines that a structured note should show all sections for data entry or Flowsheet is KBC or not 

ObsEntryItemGUID 
Definition  A link to the observation entry item used to calculate drip weight. This is a logical relationship with CV3ObservationEntryItem table. 

DripTimeIntervalType 
Definition  An enumerated type with the following list of possible values: 1 = [60 min],2 = [2 hrs],3 = [3 hrs],4 = [4 hrs],5 = [5 hrs],6 = [6 hrs],7 = [7 hrs],8 = [8 hrs],9 = [9 hrs],10 = [10 hrs],11 = [11 hrs],12 = [12 hrs],13 = [13 hrs],14 = [14 hrs],15 = [15 hrs],16 = [16 hrs],17 = [17 hrs],18 = [18 hrs],19 = [19 hrs],20 = [20 hrs],21 = [21 hrs],22 = [22 hrs],23 = [23 hrs],24 = [24 hrs],48 = [2 days],72 = [3 days],96 = [4 days],120 = [5 days],144 = [6 days],168 = [7 days], 

IsRTFColumnHeaderAppended 
Definition  Stores 0 or 1. Value 1 indicates the column headers for the pull sets will display at the bottom of the document 

AutoEnterMLMMenuLabel 
Definition  Menu Label for Called MLMs. This new field will store the name for the menu label that will be used in the Auto Enter sub menu on the flowsheet. User should be able to configure it at the Flowsheet Catalog . 

IsCCD 
Definition  Indicates that the Structured Note is to be used as a CCD Document Source 

ParameterColWidth 
Definition  an integer representing the flowsheet parameter column width 

IsSuppressExternalObsIn 
Definition  Turns on/off allowing inbound obs from external system for entire flowsheet 

IsSuppressExternalObsOut 
Definition  Turns on/off allowing outbound obs from external system for entire flowsheet 

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

SuppressFanIn 
Definition  This column when set to True Will restrict Fan-In to flowsheet 

FontName 
Definition  An enumerated type with the following list of possible values: 1 = [Segoe UI],2 = [Arial Narrow],3 = [Georgia],4 = [Tahoma],5 = [Microsoft Sans Serif], 

FontSize 
Definition  An enumerated type with the following list of possible values: 8 = [8],9 = [9],10 = [10],11 = [11],12 = [12], 

BackgroundColor 
Definition  Background color 

ShowToolbarText 
Definition  Show Toolbar text status 

ShowToolbarIcon 
Definition  Show Toolbar Icon status 

FontColor 
Definition  Font Color 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

IsAwareNote 
Definition  To store whether SN is AwareNote or Hybrid SN(Containing SN and AwareNote or Pure SN) {0 - Non Aware Note, 1- Pure Aware Note} 

SmartPumpEventRowLabel 
Definition  Holds the value for Smart Pump Event Row Label configured from Flowsheet Catalog Configuration by the User. 

IsSuppressSmartPumpAlerts 
Definition  Holds the bit value whether to suppress the Smart Pump alert window or not. 

IsBoldObservationLabel 
Definition  This is a toggle flag. If it is off (0), the label for any non-CT observations in document output will be unbolded. When set (1), the non-CT observation labels will be bolded