dbo.CV3KnowledgeTreeItem 
Default Table Name  CV3KnowledgeTreeItem 
Definition  Provides a mechanism to enter patient documents in a structured way. This is part of the Knowledge Writer. 

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

dbo.CV3KnowledgeTreeItem Primary and Unique Keys 
Key Name  Key Type  Keys 
CV3KnowledgeTreeItemPK  PrimaryKey  GUID