Database Schema and Views Reference Guide › Database Tables › Wgn3ClassificationNode › Available Class Node Trees

Available Class Node Trees

The tree views on the following pages are schematic representations of the two classification trees defined by the Wgn3Classification and Wgn3ClassificationNode tables.

• Participant classification tree: See Participant class nodes for details. NodeUID values starting with 1 refer to Participant Classifications, referenced by the ParticipantNodeUID column of the Wgn3EventParticipant table.
• Intervention classification tree: See Intervention nodes for details. NodeUID values starting with 2 refer to Intervention Classifications, referenced by the InterventionNodeUID column of the Wgn3EventParticipant table.
• Policy classification tree: See Policy classification nodes for details. NodeUID values starting with 3 refer to Policy Classifications, referenced by the PolicyID column of the Wgn3Event table.

The structure of each tree is derived directly from the entries in the Wgn3ClassificationNode table. Each node references an entry in the Wgn3Classification table to define its type; for clarity, the type of each node (its 'class name' and class UID) is shown alongside each entry in the tree.

Notes: Be aware of the following:

• The NodeUID uniquely identifies each node in the tree. However, the node 'type' is not necessarily unique, so many nodes may refer to the same ClassUID in the Wgn3Classification table.
• In the Wgn3Classification and Wgn3ClassificationNode tables, all NodeUID and ClassUID values are decimal, not hexadecimal.