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 | Auto generated unique primary key value. |
ClientGUID |
Definition | The link to the client. |
OwnerGUID |
Definition | The link to the Chart Flowsheet that owns these reference items. |
IsUpdate |
Definition | Indicates if this is only an update of an existing item's display name or included state. 1 = True; 0 = False |
ObsEntryItemGUID |
Definition | The link to the parent Observation Entry Item. |
IsItemActive |
Definition | Indicates whether or not the item referenced is active. 1 = True; 0 = False |
IsIncluded |
Definition | Indicates if the item referenced should be shown when this flowsheet is displayed for this patient. 1 = True; 0 = False |
DisplayName |
Definition | Contains the display name for this row. |
CanChangeName |
Definition | Indicates if the display name of a generic item can be changed. 1 = True; 0 = False |
ItemType |
Definition | 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 |
Definition | Contains the link to the parent Client Obs Entry Item. |
DisplaySequence |
Definition | Used for observations added on the fly. Represents the sequence of the added item as it appears in the main flowsheet configuration. |
ObsMasterItemGUID |
Definition | The link to the observation catalog master item. |
ObsItemGUID |
Definition | The link to the observation catalog item. |
ObsSetGUID |
Definition | The link to the observation catalog set. |
ObsSetItemGUID |
Definition | The link to the observation catalog set item. |
ObsModifierGUID |
Definition | The link to the observation modifier. |
ObsModifierXrefGUID |
Definition | The link to the observation modifier cross-reference. |
IsMasterItem |
Definition | Indicates if an item of type Observation Item is a master item. 1 = True; 0 = False |
DefaultValueType |
Definition | 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 |
Definition | Contains a specific value to default for the observation item or modifier when the flowsheet is displayed for data entry. |
IsPredefinedModifier |
Definition | Used for Observation Modifier items to indicate they are pre-defined modifiers. 1 = True; 0 = False |
IsDefaultProtected |
Definition | 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 |
Definition | Optimistic lock identifier. |
EnteredWhen |
Definition | Visit TimeZone - Identifies the date time entered/set by user during modify parameter |
HasComment |
Definition | A Flag. Specifies whether the row has a comment attached to it or not. 1-Comment attached. 0-No comment attached |
HasComponents |
Definition | A flag. Identifies whether this observation has components attached to it or not. 1-Componnets are attached. 0-no components. |
HistorySeqNum |
Definition | A sequential number to indicate historical data. |
IsFanOut |
Definition | 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 |
Definition | 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 |
Definition | An enumerated type with the following list of possible values: 0 = [Unbordered],1 = [Bordered],2 = [Merged], |
Rate |
Definition | Rate of administering the intake fluid |
RateUnit |
Definition | UOM for rate |
Site |
Definition | Site where the intake fluid is administered |
State |
Definition | State of the parameter. 1-Active, 2- Cancelled, 3-Discontinued |
TotalVolume |
Definition | Total volume for the parameter |
TotalVolumeUnit |
Definition | UOM for total volume |
IsLocked |
Definition | Indicates whether this parameter can be locked |
MonitorChannelGUID |
Definition | The Monitor Channel attached to the parameter |
OrgObservationGUID |
Definition | Used if this is an historical observation |
RecordedProviderGUID |
Definition | Add field RecordedProviderGUID |
SubSequence |
Definition | Identifies the order of display of the client level parameters, which have same ‘DisplaySequence’. |
FanoutParentGUID |
Definition | This field will store the GUID of the parameter due to which the fanout was initiated |
IsDaylightSavings |
Definition | a flag to indicate additional set of time columns on flowsheets for 1-2am for the additional hour gained during daylight savings time. |
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. |
UserOccupationCode |
Definition | 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 |
Definition | Source system when row is added to flowsheet via receipt of inbound observation. |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |