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
Started
Skipped-Automated Traversal
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.