dbo.CV3ObsCatalogMasterItem 
Default Table Name  CV3ObsCatalogMasterItem 
Definition  Definition of a clinical observation that can be part of a patient document. It defines the name, description, and type of data to be entered for the observation. Stores parameter data.
Contains the Chart Text value 

dbo.CV3ObsCatalogMasterItem 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. 
Name    varchar(250)  YES  The name of the observation item. 
Description    varchar(500)  YES  The description of the item. 
EffectiveDtm    datetime  YES  Enterprise TimeZone - The date the item is effective. 
ExpirationDtm    datetime  YES  Enterprise TimeZone - The date the item expires, if applicable. 
OwnerGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the CV3OrganizationalUnit table. 
IsGenericItem    tinyint  YES  Indicates if this is a generic type of observation item. 1 = True; 0 = False 
IsClientCharacteristic    tinyint  YES  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(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3PhysicalNoteType table. 
IsOutcome    tinyint  YES  Identifies if this item is an observation that can be added as an outcome in clinical paths configuration. 1 = True; 0 = False 
ItemInfoID    int  NO  Used to link enterprise-defined help to an observation item. 
DataType    int  NO  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    int  NO  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    int  YES  The number of hours that observations are to be tallied for a Total type calculation before a new calculation is started. 
FluidBalanceType    int  NO  An enumerated type with the following list of possible values: 1 = [None],2 = [Intake],3 = [Output], 
IOSubtype(FK)    varchar(60)  YES  A foreign key to the Code column in the CV3IntakeSubtype table. 
IncludeInTotals    tinyint  YES  Indicates if this item should be included in Total Intake/Output calculations by default. 1 = True; 0 = False 
SummaryType    int  NO  An enumerated type with the following list of possible values: 1 = [Ellipsis],2 = [Latest],3 = [Sum], 
AllowApproximates    tinyint  YES  Indicates if approximate values can be entered using the characters <, >, and ~. 1 = True; 0 = False 
ShowAbsoluteValue    tinyint  YES  Indicates that only the difference will be shown for calculations that might have a negative value in the result. 1 = True; 0 = False 
UnitOfMeasure(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3UnitOfMeasure table. 
MinValue    float  YES  The positive minimum value that can be entered for this observation. 
MaxValue    float  YES  The positive maximum value that can be entered for this observation. 
NumDecimalsIn    int  NO  The number of decimal places allowed for entry of this observation. 
NumDecimalsOut    int  NO  The number of decimal places to be used for review of this observation. 
UseNumericSeparator    tinyint  YES  Indicates whether the Windows-defined attribute for displaying large numbers will be used (a comma). 1 = True; 0 = False 
MaxLength    int  NO  The maximum number of characters that can be entered for this observation. 
NumLines    int  NO  The number of lines the edit box should have when the observation is being entered. 
IsMultiSelect    tinyint  YES  Indicates whether or not multiple selection of the valid values is allowed for suggested and restricted dictionaries. 1 = True; 0 = False 
ValueSeparator    varchar(1)  YES  The separator to be used between multiselect dictionary values. 
HasNumericEquiv    tinyint  YES  Indicates if at least one of the Observation Valid Values for this dictionary type has a numeric equivalent defined. 1 = True; 0 = False 
TextValidationDict(FK)    varchar(30)  YES  A foreign key to the Code column in the CV3UserDictionary table. 
TrueText    varchar(30)  YES  The text equivalent for printing purposes of the checked (True) state of this observation. 
FalseText    varchar(30)  YES  The text equivalent for printing purposes of the unchecked (False) state of this observation. 
CalculateCumulative    bit  NO  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    int  YES  Represents the number of hours that observations are to be tallied for a Cumulative calculation before a new calculation is started. 
CumulativeStartOfDayType    int  NO  An enumerated type with the following list of possible values: 1 = [None],2 = [First Shift],3 = [Standard], 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
ParameterType    int  NO  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    bit  NO  Round off result to nearest decimal or integer. 1-integer, 0-decimal 
OutputNumDecimalsIn    int  YES  The Integer Length for Out parameter 
OutputNumDecimalsOut    int  YES  The number of decimal places for the Out parameter 
RateNumDecimalsIn    int  YES  The Integer Length for Rate 
RateNumDecimalsOut    int  YES  The number of decimal places for the Rate 
DoseNumDecimalsIn    int  YES  The Integer Length for Dose 
DoseNumDecimalsOut    int  YES  The number of decimal places for the Dose 
DisplayUOM    bit  NO  Indicates whether to display the UOM in the cell or not 
EnterDetailDialog    bit  NO  Specifies whether Enter Detail dialogue is enabled or not. 1-enter dialog is to be enabled, 0-Don't enable 
CalculationGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the SCMObsCalculations table. 
ListCatalogSetGUID(FK)    HVCIDdt  YES  A foreign key to the GUID column in the SCMObsListCatalogSet table. 
UserDictionaryCode    varchar(30)  YES  Link to CV3UserDictionary if the parameter is a list type 
Formula    varchar(1000)  YES  This stores the formula of the calculation whether Generic or General 
MaskingFormat    varchar(50)  YES  Format mask for observation 
IsHorizontal    tinyint  YES  Indicates whether the radio / check box group is to be displayed horizontally or vertically. 1-Horizontal, 0-Vertical 
RightJustifiedLabel    varchar(500)  YES  Stores the right justified label. 
RightJustifiedLabelFontSize    tinyint  YES  The font size of the right justified label 
LeftJustifiedLabel    varchar(250)  YES  Let justified label for observation 
LeftJustifiedLabelFontSize    tinyint  YES  Font size for LeftJustifiedLabel 
Comments    varchar(2000)  YES  Actual comments associated with observation 
CommentFontSize    tinyint  YES  Specifies the size of the comment font. 1-Normal, 2-Tiny 
ModifyFormFilter    varchar(80)  YES  The modify form filter to be displayed. 
ModifyFormFilterFontSize    tinyint  YES  The font size of the modify form filter. 1-Normal, 2-Tiny 
FontSize    tinyint  YES  An enumerated type with the following list of possible values: 0 = [Tiny],1 = [Normal], 
ComponentFontSize    tinyint  YES  Specifies the size of the component font. 1-Normal, 2-Tiny 
EnterIntake    bit  YES  Stores a bit value 0 - Cannot show intake option for this observation1 - Show Intake Entry Element. 
EnterOutput    bit  YES  Stores a bit value.0 - Cannot show output option for this observation1 - Show Output Entry Element 
EnterNet    bit  YES  Stores a bit value.0 - Cannot Show Net Calculated Value1 - Show Net Calculated Value 
Enter24Hr    bit  YES  Stores a bit value.0 - Cannot Show 24 Hr Calculated Value1 - Show 24 Hr Calculated Value 
LabelIn    varchar(50)  YES  Label for intake observation 
LabelOut    varchar(50)  YES  Label for output observation 
LabelNet    varchar(50)  YES  Label for net observation 
Label24Hr    varchar(50)  YES  Label for 24 hour reading 
TotalVolume    numeric(15, 5)  YES  Total volume for the parameter 
TotalVolumeUnit    varchar(30)  YES  UOM for total volume 
Rate    varchar(20)  YES  Stores the value of initial rate at configuration time. 
RateUnit    varchar(30)  YES  Stores the unit of initial dose at configuration time 
Site    varchar(40)  YES  The site for the parameter 
IsDeviceInterface    bit  NO  Indicates whether this parameter is to be a device parameter or not 
MonitorChannelGUID    HVCIDdt  YES  The reference to SCMDevIntfMonChannelMapList 
NoEditing    bit  NO  Editing allowed for this observation or not. 1-Cannot edit, 0-Can Edit 
HasModifier    bit  NO  Indicates whether the parameter has a modifier attached 
IsLocked    bit  NO  Indicates whether this parameter is locked 
HasWDL    bit  NO  Does the Catalog Item have a WDL message associated with it? 
SiteFontSize    tinyint  YES  Size of the Font for Site string 
SiteListGUID    HVCIDdt  YES  Link to CV3UserDictionary to represent list used in front end dropdown 
SiteDevice    varchar(40)  YES  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    tinyint  YES  Size of the Font for site device string 
SiteDeviceListGUID    HVCIDdt  YES  Link to CV3UserDictionary to represent list used in front end dropdown 
CommentListGUID    HVCIDdt  YES  Link to CV3UserDictionary to represent list used in front end dropdown 
FreeTextBoxHeight    smallint  YES  Height of a Free Text Observation in Structured notes. Height in number of Rows visible 
FreeTextBoxWidth    smallint  YES  Width of a Free Text Observation in Structured notes. Width in number of Characters 
ImageType    int  YES  An enumerated type with the following list of possible values: 0 = [Locked],1 = [Annotated],2 = [Hotspot Image],3 = [Digital Signature], 
IsRTFInput    bit  NO  Should this observation accept RTF text as input 
IsChartText    bit  NO 
Contains Chart Text flag value. 
EnableDateTimeStamp    bit  NO  Will date time stamp be enabled for observation 
Section1ListGUID    HVCIDdt  YES  Pointer to an entry in CV3UserDictionary 
Section2ListGUID    HVCIDdt  YES  Pointer to an entry in CV3UserDictionary 
IsFormBuilderScore    bit  NO  Modification observation screen - Form Builder Score 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 
IsSmartPump    bit  NO  Specifies whether the observation is configured for Smart Pump 

dbo.CV3ObsCatalogMasterItem Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3ObsCatalogMasterItemPK  PrimaryKey  GUID