dbo.CV3ClientObsEntryItem 
Default Table Name  CV3ClientObsEntryItem 
Definition  The definition for a client-level flowsheet row. The original parameter stay in CV3ObsEntryItem, but if there are particular changes to the patient the change is stored in this table. 

dbo.CV3ClientObsEntryItem 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  Auto generated unique primary key value. 
ClientGUID    HVCIDdt  YES  The link to the client. 
OwnerGUID    HVCIDdt  YES  The link to the Chart Flowsheet that owns these reference items. 
IsUpdate    bit  NO  Indicates if this is only an update of an existing item's display name or included state. 1 = True; 0 = False 
ObsEntryItemGUID    HVCIDdt  YES  The link to the parent Observation Entry Item. 
IsItemActive    bit  NO  Indicates whether or not the item referenced is active. 1 = True; 0 = False 
IsIncluded    bit  NO  Indicates if the item referenced should be shown when this flowsheet is displayed for this patient. 1 = True; 0 = False 
DisplayName    varchar(500)  YES  Contains the display name for this row. 
CanChangeName    bit  NO  Indicates if the display name of a generic item can be changed. 1 = True; 0 = False 
ItemType    int  NO  Indicates the type of observation item for added items. 1 = Header; 2 = Intake Subtotal; 3 = Output Subtotal; 4 = Net Balance; 5 = Observation Item; 6 = Observation Set; 7 = Observation Modifier 
ParentGUID    HVCIDdt  YES  Contains the link to the parent Client Obs Entry Item. 
DisplaySequence    int  NO  Used for observations added on the fly. Represents the sequence of the added item as it appears in the main flowsheet configuration. 
ObsMasterItemGUID    HVCIDdt  YES  The link to the observation catalog master item. 
ObsItemGUID    HVCIDdt  YES  The link to the observation catalog item. 
ObsSetGUID    HVCIDdt  YES  The link to the observation catalog set. 
ObsSetItemGUID    HVCIDdt  YES  The link to the observation catalog set item. 
ObsModifierGUID    HVCIDdt  YES  The link to the observation modifier. 
ObsModifierXrefGUID    HVCIDdt  YES  The link to the observation modifier cross-reference. 
IsMasterItem    bit  NO  Indicates if an item of type Observation Item is a master item. 1 = True; 0 = False 
DefaultValueType    int  NO  Indicates the type of default value that should be used when the flowsheet is displayed for data entry. 1 = NoDefaultValue; 2 = Previous; 3 = Specific 
SpecificDefault    varchar(5000)  YES  Contains a specific value to default for the observation item or modifier when the flowsheet is displayed for data entry. 
IsPredefinedModifier    bit  NO  Used for Observation Modifier items to indicate they are pre-defined modifiers. 1 = True; 0 = False 
IsDefaultProtected    bit  NO  Used for Observation Modifiers only to indicate if the default is protected (meaning that the user cannot change it during data entry). 1 = True; 0 = False 
MSrepl_tran_version    uniqueidentifier  YES  Optimistic lock identifier. 
EnteredWhen    datetime  YES  Visit TimeZone - Identifies the date time entered/set by user during modify parameter 
HasComment    bit  NO  A Flag. Specifies whether the row has a comment attached to it or not. 1-Comment attached. 0-No comment attached 
HasComponents    bit  NO  A flag. Identifies whether this observation has components attached to it or not. 1-Componnets are attached. 0-no components. 
HistorySeqNum    int  YES  A sequential number to indicate historical data. 
IsFanOut    bit  NO  A flag. Indicates whether this client level observation entry item is applicable for fanout or not. 1-can be fanned out. 0-No fanout 
IsGenericItem    bit  NO  A flag. Indicates whether this is a generic item or not. 1-Generic item (can be added multiple times) 0-Non generic, "add only once" type item. 
IsGrouped    smallint  YES  An enumerated type with the following list of possible values: 0 = [Unbordered],1 = [Bordered],2 = [Merged], 
Rate    varchar(20)  YES  Rate of administering the intake fluid 
RateUnit    varchar(30)  YES  UOM for rate 
Site    varchar(500)  YES  Site where the intake fluid is administered 
State    int  NO  State of the parameter. 1-Active, 2- Cancelled, 3-Discontinued 
TotalVolume    numeric(15, 5)  YES  Total volume for the parameter 
TotalVolumeUnit    varchar(30)  YES  UOM for total volume 
IsLocked    bit  NO  Indicates whether this parameter can be locked 
MonitorChannelGUID    HVCIDdt  YES  The Monitor Channel attached to the parameter 
OrgObservationGUID    HVCIDdt  YES  Used if this is an historical observation 
RecordedProviderGUID    HVCIDdt  YES  Add field RecordedProviderGUID 
SubSequence    smallint  YES  Identifies the order of display of the client level parameters, which have same ‘DisplaySequence’. 
FanoutParentGUID    HVCIDdt  YES  This field will store the GUID of the parameter due to which the fanout was initiated 
IsDaylightSavings    smallint  NO  a flag to indicate additional set of time columns on flowsheets for 1-2am for the additional hour gained during daylight savings time. 
SiteDevice    varchar(500)  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. 
UserOccupationCode    varchar(30)  YES  PHI: Occupation of the CreatedBy user to display in the history dialog of the Observation parameter and Observation charted Value -Value of the field comes from CV3User.OccupationCode 
SourceSystem    varchar(255)  YES  Source system when row is added to flowsheet via receipt of inbound observation. 
MSReplrowguid    uniqueidentifier  NO  Unique GUID used to support merge replication. 

dbo.CV3ClientObsEntryItem Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3ClientObsEntryItemPK  PrimaryKey  GUID