dbo.CV3FlowsheetVersion 
Default Table Name  CV3FlowsheetVersion 
Definition  Different versions of the same flowsheet. 

dbo.CV3FlowsheetVersion 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. 
FlowsheetGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3Flowsheet table. 
IsMaster    tinyint  YES  A flag that indicates whether this version is the master or default version of the flowsheet. 1 = True; 0 = False 
Name    varchar(60)  YES  Contains the name of the flowsheet version. 
ShowNormalRange    tinyint  YES  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    int  YES  Indicates the background color for the observation columns. 
NRColumnBGColor    int  YES  Indicates the background color for the Normal Range column. 
HeaderRowBGColor    int  YES  Indicates the default background color for all header rows. 
TimeIntervalType    int  NO  An enumerated type with the following list of possible values: 1 = [Actual],2 = [Minutes],3 = [Hours],4 = [Days], 
TimeIntervalNum    int  NO  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    int  NO  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    uniqueidentifier  YES  Optimistic lock identifier. 
MasterGUID    HVCIDdt  YES  The GUID of the master from which this version is derived 
AfterDischargeHours    smallint  YES  Number of hours after discharge of patient, after which the flowsheet cannot be charted. 
AutoGenerateFrequency    varchar(9)  YES  Frequency of hours for auto generated columns in a flowsheet. 
AutoGenerateTime    smallint  YES  Stores the number of hours to auto generate 
ColumnsToFetch    tinyint  YES  Identifies how many columns to fetch for every call in pagination. 
DailyTotalBGColor    int  YES  Background color for Daily total value 
DailyTotalFGColor    int  YES  Foreground color for Daily total value 
DailyTotalStartTime    varchar(10)  YES  Start time for daily total value 
FixedColWidth    int  YES  Stores the fixed width of column 
FixedRowHeight    int  YES  Stores the fixed height of row. 
FutureChartingHours    smallint  YES  Specifies for how many hours in future can the flowsheet be charted. 
HeaderFont    varchar(30)  YES  This stores the header font type. 
HeaderFontColor    int  YES  Specifies the font color of the observation 
IsBottomLOSBBT    bit  NO  Specifies where to display LOS and BBT totals. 1-Show at bottom, 0-show at top 
IsFixedHeightWidth    bit  NO  Specifies whether row/column has fixed height/width or not. 1-Fixed, 0-not fixed 
IsIntakeOutput    bit  NO  Indicates if the flowsheet is an IO flowsheet or a non-IO flowsheet. 1-IO flowsheet, 0-Non-IO flowsheet. 
ItemFont    varchar(30)  YES  Specifies font type of observation item. 
ItemFontColor    int  YES  Specifies the font color of the observation item 
MaxColWidth    int  YES  Specifies the maximum column width for a flowsheet 
MaxRowHeight    int  YES  Specifies the maximum row height for a flowsheet 
MinColWidth    int  YES  Specifies the minimum column width for a flowsheet 
MinRowHeight    int  YES  Specifies the minimum row height for a flowsheet 
OffSetHours    tinyint  YES  The offset hours 
ShiftTotalBGColor    int  YES  Specifies the background color of the ShiftTotal value 
ShiftTotalFGColor    int  YES  Specifies the foreground color of the ShiftTotal value 
ShowBloodBalanceTotal    bit  NO  Specifies if the blood balance total should be displayed or not. 1-show the total, 0-don't show. 
ShowLOSTotal    bit  NO  Specifies that whether or not to include IO Category Summary Totals. 1-Include, 0-Don't include 
SuppressRangeIcons    bit  NO  Specifies if the range icons should be suppressed from display or not. 1-supress, 0-don't suppress 
SuppressFanOut    bit  NO  Specifies if the Fan Out should be suppressed on the flowsheet. 1-supress, 0-don't suppress 
DocumentType    int  YES  An enumerated type with the following list of possible values: 1 = [Flowsheet],2 = [StructuredNote], 
Description    varchar(500)  YES  Flowsheet version description 
IsExpandedFormat    bit  NO  Determines that a structured note should show all sections for data entry or Flowsheet is KBC or not 
ObsEntryItemGUID    HVCIDdt  YES  A link to the observation entry item used to calculate drip weight. This is a logical relationship with CV3ObservationEntryItem table. 
DripTimeIntervalType    int  YES  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    bit  NO  Stores 0 or 1. Value 1 indicates the column headers for the pull sets will display at the bottom of the document 
AutoEnterMLMMenuLabel    varchar(60)  YES  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    bit  NO  Indicates that the Structured Note is to be used as a CCD Document Source 
ParameterColWidth    int  YES  an integer representing the flowsheet parameter column width 
IsSuppressExternalObsIn    bit  NO  Turns on/off allowing inbound obs from external system for entire flowsheet 
IsSuppressExternalObsOut    bit  NO  Turns on/off allowing outbound obs from external system for entire flowsheet 
AfterDischargeHoursType    tinyint  NO  An enumerated type with the following list of possible values: 0 = [Weeks],1 = [Days],2 = [Hours],3 = [Minutes], 
SuppressFanIn    bit  NO  This column when set to True Will restrict Fan-In to flowsheet 
FontName    varchar(60)  YES  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    smallint  YES  An enumerated type with the following list of possible values: 8 = [8],9 = [9],10 = [10],11 = [11],12 = [12], 
BackgroundColor    int  YES  Background color 
ShowToolbarText    bit  NO  Show Toolbar text status 
ShowToolbarIcon    bit  NO  Show Toolbar Icon status 
FontColor    int  YES  Font Color 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsAwareNote    bit  NO  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    varchar(50)  YES  Holds the value for Smart Pump Event Row Label configured from Flowsheet Catalog Configuration by the User. 
IsSuppressSmartPumpAlerts    bit  NO  Holds the bit value whether to suppress the Smart Pump alert window or not. 
IsBoldObservationLabel    bit  NO  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 

dbo.CV3FlowsheetVersion Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3FlowsheetVersionPK  PrimaryKey  GUID