PAT_TEMP_DTREES
Description:
This table houses information regarding the decision trees that are currently not fully completed by the patient.

Primary Key
Column Name Ordinal Position
PAT_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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 PAT_TMP_DTREE_ID VARCHAR No
Stores decision trees that haven't been completed by the patient yet.
4 PAT_TMP_DTREE_ID_FORM_NAME VARCHAR No
The name of the form associated with the questionnaire.
5 PAT_TMP_DTREE_ANSWER_ID VARCHAR No
Stores the answer record for the corresponding in-progress decision tree.
6 PAT_TMP_DTREE_STATUS_C_NAME VARCHAR No
Stores the status of the corresponding in-progress decision tree.
May contain organization-specific values: No
Category Entries:
In-Progress
Actionable