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 |