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. |
VersionGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3FlowsheetVersion table. |
IsMasterVersion |
|
tinyint |
YES |
A flag that indicates if this item is part of the master (default) version of the flowsheet. 1 = True; 0 = False |
ObsEntryItemGUID |
|
HVCIDdt |
YES |
A foreign key to the GUID column in the CV3ObservationEntryItem table. |
IsIncluded |
|
tinyint |
YES |
A flag that indicates if this Observation Entry Item is to be included in this version of the flowsheet. 1 = True; 0 = False |
DisplayName |
|
varchar(500) |
YES |
The display name for this item as it is to appear in the flowsheet for this version. |
BackgroundColor |
|
int |
YES |
Indicates the background color for this row. |
IsColorExtended |
|
tinyint |
YES |
A flag used for Observation Items only which indicates if the background color bar is to extend across the entire flowsheet for the item. 1 = True; 0 = False |
IsInitiallyCollapsed |
|
tinyint |
YES |
A flag used for Header, Observation Sets, and Observation Items which indicates if the item is initially contracted when the flowsheet is opened. 1 = True; 0 = False |
IsBold |
|
tinyint |
YES |
A flag that indicates if the display name should be in bold font. 1 = True; 0 = False |
IsItalic |
|
tinyint |
YES |
A flag that indicates if the display name should be in italic font. 1 = True; 0 = False |
IsMandatory |
|
tinyint |
YES |
A flag used for Observation Items and Observation Modifiers which indicates if the item is mandatory during data entry. 1 = True; 0 = False |
IsInitiallyGraphed |
|
tinyint |
YES |
A flag (used for Observation Items) only which indicates if the observation value is to be part of the default graph when viewing this flowsheet in the Trend View. 1 = True; 0 = False |
GraphLevelNum |
|
int |
NO |
Integer field (used for Observation Items) only which contains the graph that this observation value should be displayed on. |
DefaultValueType |
|
int |
NO |
An enumerated type with the following list of possible values: 1 = [None],2 = [Previous],3 = [Specific], |
SpecificDefault |
|
varchar(max) |
YES |
Contains a specific value to default for the observation item or modifier when the flowsheet is displayed for data entry. |
IsPredefinedModifier |
|
tinyint |
YES |
A flag used for Observation Modification items that indicates if it is a pre-defined modifier. 1 = True; 0 = False |
IsDefaultProtected |
|
tinyint |
YES |
A flag (used for Observation Modifiers only) which indicates if the default is protected, meaning that the user cannot change it during data entry. 1 = True; 0 = False |
IsHidden |
|
tinyint |
YES |
A flag used for Observation Modifiers which indicates if the modifier is to be displayed on this version of the flowsheet. 1 = True; 0 = False |
MSrepl_tran_version |
|
uniqueidentifier |
YES |
Optimistic lock identifier. |
ShowAbnormalIcon |
|
bit |
YES |
Specifies whether to display an icon for an abnormal reading or not. 1-display, 0-don't display |
ShowVeryAbnormalIcon |
|
bit |
YES |
Specifies whether to display an icon for a very abnormal reading or not. 1-display, 0-don't display |
ShowHighIcon |
|
bit |
YES |
Specifies whether to display an icon for a High reading or not. 1-display, 0-don't display |
ShowVeryHighIcon |
|
bit |
YES |
Specifies whether to display an icon for a very high reading or not. 1-display, 0-don't display |
ShowLowIcon |
|
bit |
YES |
Specifies whether to display an icon for a low reading or not. 1-display, 0-don't display |
ShowVeryLowIcon |
|
bit |
YES |
Specifies whether to display an icon for a very low reading or not. 1-display, 0-don't display |
ActivatedWhen |
|
datetime |
YES |
Visit TimeZone - Specifies the date and time when this observation was activated. |
CopyForwardHours |
|
tinyint |
YES |
Specifies how many hours it can go back to 'copy forward' the data. |
DiscontinuedColor |
|
int |
YES |
Specifies the color to display for discontinued observations |
HeaderIndentation |
|
int |
YES |
Specifies the indentation of the header on the Structured Note |
FieldIndentation |
|
int |
YES |
Specifies the indentation of the field on the Structured Note |
FontColor |
|
int |
YES |
Color of the font selected |
FontFace |
|
varchar(30) |
YES |
Specifies the font face |
Formula |
|
varchar(1000) |
YES |
Specifies the formula for the observation |
FutureDateTime |
|
datetime |
YES |
Enterprise TimeZone - The date and time in the future from when this row will be visible on the flowsheet and available for charting |
HighlightColor |
|
int |
YES |
Color to be displayed when an item is highlighted. |
IsFanOut |
|
bit |
YES |
1 indicates observations charted, will fan-out to other flowsheets. For 0 fan out will be turn off. |
IsRelatedData |
|
bit |
YES |
1 indicates related data will be visible for particular observation. |
IsRemovable |
|
bit |
YES |
Stores 1 or 0 if the observation is removable or not |
ModifyComposition |
|
bit |
YES |
Specifies whether composition can be modified for the parameter or not. 1-Modify allowed, 0-Cannot modify. |
RelativeTime |
|
tinyint |
YES |
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], |
ShadowColor |
|
int |
YES |
The shaded color |
MandateAbove |
|
numeric(15, 5) |
YES |
Specific Value the observations must be greater or equal to |
MandateBelow |
|
numeric(15, 5) |
YES |
Specific Value the observation must be less than or equal to |
MandateEqualValidValueGUID |
|
HVCIDdt |
YES |
The ValidValue that the current cell must be equal to |
MandateDepObsEntryItemGUID |
|
HVCIDdt |
YES |
The ObservationEntryItem that determines if the absolute Mandates are to be applied |
MandateGUID |
|
HVCIDdt |
YES |
The ObservationEntryItem that dictates the relative Mandate comparison Observation |
MandateType |
|
smallint |
YES |
An enumerated type with the following list of possible values: 0 = [LessThan],1 = [GreaterThan], |
IsUnderLine |
|
bit |
NO |
Indicates if item is underlined |
IsSignificant |
|
bit |
YES |
Specifies whether the observation IsSignificant but not mandatory. |
SuppressCopyForward |
|
bit |
YES |
Suppresses an observation for structured notes not to copy forward the observation into the next note |
DefaultPreviousDocGUID |
|
HVCIDdt |
YES |
Points to the actual place where the defaults come |
DefaultPreviousOEIGUID |
|
HVCIDdt |
YES |
Points to the actual parameter where the defaults come |
DefaultPreviousSourceType |
|
int |
YES |
An enumerated type with the following list of possible values: 0 = [Any Document],1 = [This Document],2 = [Specific Document], |
IsReferenceItemInNote |
|
bit |
YES |
Whether to reference the prior source in the note |
CopyForwardUnitType |
|
int |
YES |
An enumerated type with the following list of possible values: 0 = [Hours],1 = [Days],2 = [Weeks],3 = [Months], |
OnChangeMLM |
|
varchar(80) |
YES |
The name of the MLM that will be executed when this item is charted or changed |
DefaultVisitScopeType |
|
int |
YES |
An enumerated type with the following list of possible values: 0 = [This Visit],1 = [This Chart],2 = [All Available], |
ApplyDocEntryType |
|
int |
YES |
An enumerated type with the following list of possible values: 0 = [None],1 = [Specific Value],2 = [Previous Value], |
ApplyDocEditType |
|
int |
YES |
An enumerated type with the following list of possible values: 0 = [None],1 = [Specific Value],2 = [Previous Value], |
IsEOV |
|
bit |
NO |
Indicates whether the pull set will participate in EOV (End of Visit) calculations. This is enabled only when the pull set = Health Issues or Outpatient Medication Profile or Orders. When enabled, the record participates in the EOV (End of Visit) calculation as if it were in the pre 5.0 Assessment and Plan Section |
SuppressSaveInNote |
|
bit |
YES |
Should the charting of this item be suppressed when the note is saved? |
AutoEnterMLMName |
|
varchar(80) |
YES |
The new field stores the name of the MLM that will be invoked if auto enter is selected for that observation on the flowsheet. It can be configured for each observation on a flowsheet in the FlowSheet Catalog. |
IsSuppressExternalObsIn |
|
bit |
NO |
Turns on/off allowing inbound obs from external system for each parameter |
IsSuppressExternalObsOut |
|
bit |
NO |
Turns on/off allowing outbound obs from external system for each parameter |
IsUsePatientCharSelected |
|
bit |
NO |
Used to determine whether observation is configured to use patient characteristics value for auto enter. |
IsFanIn |
|
bit |
NO |
If this column is true then Fan-In is allowed and if false then fan-in is not allowed (suppressed). This will be set for the flowsheet versions. |
DocExLinkedObsEntryItemGUID |
|
HVCIDdt |
YES |
Guid linked to the Selected flowsheet version Item |
MSReplrowguid |
|
uniqueidentifier |
NO |
Unique GUID used to support merge replication. |
ShouldSyncDocumentSequenceWithTabSequence |
|
bit |
NO |
This flag to determine whether a Structured Note Catalog's document Sequence should always be in sync with Tab Sequences in its Form (in Form Builder) |
IsHideSmartPumpAlerts |
|
bit |
NO |
Holds the bit value whether to hide the Smart Pump alert window or not at the observation level. |