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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
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 |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the SCMObsCalculations table. |
ListCatalogSetGUID |
|
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 |