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 | Unique primary key value. |
IsLeafNode |
Definition | Indicates whether this is a leaf node in the knowledge tree. 1 = True; 0 = False |
Hierarchy |
Definition | Stores the hierarchy of parent GUIDs in a string separated by | characters. |
ParentGUID |
Definition | A foreign key to the GUID column in the CV3KnowledgeTreeItem table. |
Name |
Definition | The node name that is displayed in the Knowledge Writer for this item. |
UpperName |
Definition | The upper-case version of the name. Used for searching. |
Type |
Definition | Identifies the node type. Either Standard, Allergy, HealthIssue, Order, OrderSet, or Application |
IsMandatory |
Definition | Indicates whether this node is required to be visited during document creation. 1 = True; 0 = False |
DisplaySequence |
Definition | The sequence of this node item within its parent branch. |
IsSingleSelectParent |
Definition | Flag that indicates if only one of the children for this item is selectable by the user in the Knowledge Writer. 1 = True; 0 = False |
MultiSelectParent |
Definition | An enumerated value that indicates if more than one of the child items for the node can be selected. Either None, And, or Or |
FirstNodeTextLine |
Definition | The first line of the node text that is defined for this node. |
HasExtendedText |
Definition | Indicates if this item has additional node text lines stored in KnowledgeItemTextLine objects. 1 = True; 0 = False |
RootItemGUID |
Definition | The link to the KnowledgeTree Item that is the absolute root of this Knowledge Tree. |
DocHeadingItemGUID |
Definition | A foreign key to the GUID column in the CV3DocumentHeadingItem table. |
CodingScheme |
Definition | The coded health issue type. Validated against the CV3CodedHealthIssueType dictionary |
CodingSchemeCode |
Definition | The coded health issue. Only necessary if the CodingScheme field is set. Validated against the CV3CodedHealthIssue |
DocHeadingHierarchy |
Definition | The hierarchy string of the associated Document Heading Item. |
NodeLinkGUID |
Definition | A foreign key to the GUID column in the CV3OrderCatalogItem table. |
ApplicationCol1 |
Definition | The first 255 characters of an external application's path. |
ApplicationCol2 |
Definition | The overflow column for the application's path. Should be concatenated with ApplicationCol1 |
MSrepl_tran_version |
Definition | Optimistic lock identifier. |
MSReplrowguid |
Definition | Unique GUID used to support merge replication. |