Previous Topic: Wgn3ClassificationBaseNext Topic: Available Class Node Trees


Wgn3ClassificationNode

This table contains nodes in a hierarchy, where each node represents an unambiguous classification that can be applied to any entity that requires hierarchical classification. Each node references its immediate parent node (another entry in this table) and the type of the node (a reference to the Wgn3Classification table). This table is populated once at installation and thereafter is used for reference only.

In the CA DataMinder 3.50 schema, there are two separate classification trees defined by this table: a participant classification tree and an intervention classification tree. For details, see the Available class node trees.

Column

Primary Key

Datatype

Length

Notes

NodeUID

Unique ID of the Node.

Yes

INTEGER

 

Follow the hyperlink for details about Participant Class Node tables.

ParentNodeUID

Reference to the parent node.

 

INTEGER

 

Null value indicates root node.

ClassUID

Reference to classification of this node.

Yes

INTEGER

 

Follow the hyperlink for details about Participant Class Node tables.