DTREE_NODES_USED
Description:
Table containing the nodes used in a decision tree run.

Primary Key
Column Name Ordinal Position
DTREE_ANSWER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 DTREE_ANSWER_ID VARCHAR No
The unique identifier (.1 item) for the answer record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 NODE_STATUS_C_NAME VARCHAR No
Stores the status of the decision tree node based on the actions taken by the user when completing the decision tree. For example, if a user answers a question in a decision tree, the status of the question node will be set to Completed.
May contain organization-specific values: No
Category Entries:
Completed
In-Progress
Skipped
Clinician Only
Throttled
Declined
Abandoned
Disabled
4 CREATED_PAT_ENC_CSN_ID NUMERIC No
The encounter ID number of the record used to store information generated as a result of the user taking an action in a decision tree.
5 CREATED_APPT_REQUEST_ID NUMERIC No
The ID number of the record used to store the appointment requests created as a result of the user taking an action in a decision tree.
6 CHILD_DTREE_ANS_ID VARCHAR No
The ID number of the record used to store the answers to a child decision tree created by a decision tree node in a decision tree.
7 NODE_ETX_DATE_REAL FLOAT No
A unique contact date in decimal format for the contact viewed by the patient during self-triage. The integer portion of the number indicates the date of the contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 references the first (or only) contact, .01 references the second contact, etc.