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.