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. 

Name 
Definition  The name of the observation item. 

Description 
Definition  The description of the item. 

EffectiveDtm 
Definition  Enterprise TimeZone - The date the item is effective. 

ExpirationDtm 
Definition  Enterprise TimeZone - The date the item expires, if applicable. 

OwnerGUID 
Definition  A foreign key to the GUID column in the CV3OrganizationalUnit table. 

IsGenericItem 
Definition  Indicates if this is a generic type of observation item. 1 = True; 0 = False 

IsClientCharacteristic 
Definition  Identifies if this item is an observation that belongs to the client instead of visit (for example, height and weight). 1 = True; 0 = False 

PhysicalNoteType 
Definition  A foreign key to the Code column in the CV3PhysicalNoteType table. 

IsOutcome 
Definition  Identifies if this item is an observation that can be added as an outcome in clinical paths configuration. 1 = True; 0 = False 

ItemInfoID 
Definition  Used to link enterprise-defined help to an observation item. 

DataType 
Definition  An enumerated type with the following list of possible values: 1 = [Free Text],2 = [Numeric],3 = [Checkbox],4 = [Restricted Dictionary],5 = [Suggested Dictionary],6 = [Radio Button],7 = [User Defined Form],8 = [Date/Time],10 = [Image], 

CalculationType 
Definition  An enumerated type with the following list of possible values: 1 = [None],2 = [Observation Sum],3 = [Observation Difference],4 = [Total Intake],5 = [Total Output],6 = [Net Balance], 

TotalCalcHours 
Definition  The number of hours that observations are to be tallied for a Total type calculation before a new calculation is started. 

FluidBalanceType 
Definition  An enumerated type with the following list of possible values: 1 = [None],2 = [Intake],3 = [Output], 

IOSubtype 
Definition  A foreign key to the Code column in the CV3IntakeSubtype table. 

IncludeInTotals 
Definition  Indicates if this item should be included in Total Intake/Output calculations by default. 1 = True; 0 = False 

SummaryType 
Definition  An enumerated type with the following list of possible values: 1 = [Ellipsis],2 = [Latest],3 = [Sum], 

AllowApproximates 
Definition  Indicates if approximate values can be entered using the characters <, >, and ~. 1 = True; 0 = False 

ShowAbsoluteValue 
Definition  Indicates that only the difference will be shown for calculations that might have a negative value in the result. 1 = True; 0 = False 

UnitOfMeasure 
Definition  A foreign key to the Code column in the CV3UnitOfMeasure table. 

MinValue 
Definition  The positive minimum value that can be entered for this observation. 

MaxValue 
Definition  The positive maximum value that can be entered for this observation. 

NumDecimalsIn 
Definition  The number of decimal places allowed for entry of this observation. 

NumDecimalsOut 
Definition  The number of decimal places to be used for review of this observation. 

UseNumericSeparator 
Definition  Indicates whether the Windows-defined attribute for displaying large numbers will be used (a comma). 1 = True; 0 = False 

MaxLength 
Definition  The maximum number of characters that can be entered for this observation. 

NumLines 
Definition  The number of lines the edit box should have when the observation is being entered. 

IsMultiSelect 
Definition  Indicates whether or not multiple selection of the valid values is allowed for suggested and restricted dictionaries. 1 = True; 0 = False 

ValueSeparator 
Definition  The separator to be used between multiselect dictionary values. 

HasNumericEquiv 
Definition  Indicates if at least one of the Observation Valid Values for this dictionary type has a numeric equivalent defined. 1 = True; 0 = False 

TextValidationDict 
Definition  A foreign key to the Code column in the CV3UserDictionary table. 

TrueText 
Definition  The text equivalent for printing purposes of the checked (True) state of this observation. 

FalseText 
Definition  The text equivalent for printing purposes of the unchecked (False) state of this observation. 

CalculateCumulative 
Definition  A flag that indicates whether cumulative totals will be calculated for the subtotals based on the Reset and StartOfDay fields. 1 = True; 0 = False 

CumulativeCalcHours 
Definition  Represents the number of hours that observations are to be tallied for a Cumulative calculation before a new calculation is started. 

CumulativeStartOfDayType 
Definition  An enumerated type with the following list of possible values: 1 = [None],2 = [First Shift],3 = [Standard], 

MSrepl_tran_version 
Definition  Optimistic lock identifier. 

ParameterType 
Definition  An enumerated type with the following list of possible values: 1 = [General],2 = [Calculation],3 = [Intake],4 = [Output],5 = [Drip],6 = [Net],7 = [Phrase],8 = [Advanced Calculation],9 = [Order Based Drip], 

RoundOffResult 
Definition  Round off result to nearest decimal or integer. 1-integer, 0-decimal 

OutputNumDecimalsIn 
Definition  The Integer Length for Out parameter 

OutputNumDecimalsOut 
Definition  The number of decimal places for the Out parameter 

RateNumDecimalsIn 
Definition  The Integer Length for Rate 

RateNumDecimalsOut 
Definition  The number of decimal places for the Rate 

DoseNumDecimalsIn 
Definition  The Integer Length for Dose 

DoseNumDecimalsOut 
Definition  The number of decimal places for the Dose 

DisplayUOM 
Definition  Indicates whether to display the UOM in the cell or not 

EnterDetailDialog 
Definition  Specifies whether Enter Detail dialogue is enabled or not. 1-enter dialog is to be enabled, 0-Don't enable 

CalculationGUID 
Definition  A foreign key to the GUID column in the SCMObsCalculations table. 

ListCatalogSetGUID 
Definition  A foreign key to the GUID column in the SCMObsListCatalogSet table. 

UserDictionaryCode 
Definition  Link to CV3UserDictionary if the parameter is a list type 

Formula 
Definition  This stores the formula of the calculation whether Generic or General 

MaskingFormat 
Definition  Format mask for observation 

IsHorizontal 
Definition  Indicates whether the radio / check box group is to be displayed horizontally or vertically. 1-Horizontal, 0-Vertical 

RightJustifiedLabel 
Definition  Stores the right justified label. 

RightJustifiedLabelFontSize 
Definition  The font size of the right justified label 

LeftJustifiedLabel 
Definition  Let justified label for observation 

LeftJustifiedLabelFontSize 
Definition  Font size for LeftJustifiedLabel 

Comments 
Definition  Actual comments associated with observation 

CommentFontSize 
Definition  Specifies the size of the comment font. 1-Normal, 2-Tiny 

ModifyFormFilter 
Definition  The modify form filter to be displayed. 

ModifyFormFilterFontSize 
Definition  The font size of the modify form filter. 1-Normal, 2-Tiny 

FontSize 
Definition  An enumerated type with the following list of possible values: 0 = [Tiny],1 = [Normal], 

ComponentFontSize 
Definition  Specifies the size of the component font. 1-Normal, 2-Tiny 

EnterIntake 
Definition  Stores a bit value 0 - Cannot show intake option for this observation1 - Show Intake Entry Element. 

EnterOutput 
Definition  Stores a bit value.0 - Cannot show output option for this observation1 - Show Output Entry Element 

EnterNet 
Definition  Stores a bit value.0 - Cannot Show Net Calculated Value1 - Show Net Calculated Value 

Enter24Hr 
Definition  Stores a bit value.0 - Cannot Show 24 Hr Calculated Value1 - Show 24 Hr Calculated Value 

LabelIn 
Definition  Label for intake observation 

LabelOut 
Definition  Label for output observation 

LabelNet 
Definition  Label for net observation 

Label24Hr 
Definition  Label for 24 hour reading 

TotalVolume 
Definition  Total volume for the parameter 

TotalVolumeUnit 
Definition  UOM for total volume 

Rate 
Definition  Stores the value of initial rate at configuration time. 

RateUnit 
Definition  Stores the unit of initial dose at configuration time 

Site 
Definition  The site for the parameter 

IsDeviceInterface 
Definition  Indicates whether this parameter is to be a device parameter or not 

MonitorChannelGUID 
Definition  The reference to SCMDevIntfMonChannelMapList 

NoEditing 
Definition  Editing allowed for this observation or not. 1-Cannot edit, 0-Can Edit 

HasModifier 
Definition  Indicates whether the parameter has a modifier attached 

IsLocked 
Definition  Indicates whether this parameter is locked 

HasWDL 
Definition  Does the Catalog Item have a WDL message associated with it? 

SiteFontSize 
Definition  Size of the Font for Site string 

SiteListGUID 
Definition  Link to CV3UserDictionary to represent list used in front end dropdown 

SiteDevice 
Definition  String to further define Site. For example if the site is left arm and there is an IV tube, then a further description of the IV tube may be 18 gauge. This field will map to "Type" on UI/config. 

SiteDeviceFontSize 
Definition  Size of the Font for site device string 

SiteDeviceListGUID 
Definition  Link to CV3UserDictionary to represent list used in front end dropdown 

CommentListGUID 
Definition  Link to CV3UserDictionary to represent list used in front end dropdown 

FreeTextBoxHeight 
Definition  Height of a Free Text Observation in Structured notes. Height in number of Rows visible 

FreeTextBoxWidth 
Definition  Width of a Free Text Observation in Structured notes. Width in number of Characters 

ImageType 
Definition  An enumerated type with the following list of possible values: 0 = [Locked],1 = [Annotated],2 = [Hotspot Image],3 = [Digital Signature], 

IsRTFInput 
Definition  Should this observation accept RTF text as input 

IsChartText 
Definition 
Contains Chart Text flag value. 

EnableDateTimeStamp 
Definition  Will date time stamp be enabled for observation 

Section1ListGUID 
Definition  Pointer to an entry in CV3UserDictionary 

Section2ListGUID 
Definition  Pointer to an entry in CV3UserDictionary 

IsFormBuilderScore 
Definition  Modification observation screen - Form Builder Score 

MSReplrowguid 
Definition  Unique GUID used to support merge replication. 

IsSmartPump 
Definition  Specifies whether the observation is configured for Smart Pump