|
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 |
QUESR_TMP_ANSWER_ID |
VARCHAR |
No |
|
|
|
The unique ID of the answer set for this row. |
|
|
4 |
QUESR_TMP_MYPT_ID |
VARCHAR |
No |
|
|
|
The unique ID of the patient account for this row. |
|
|
5 |
QUESR_TMP_ROOT_ID |
VARCHAR |
No |
|
|
|
Stores the root questionnaire (LQF) record ID for each questionnaire that has not yet been submitted. |
|
|
6 |
QUESR_TMP_ROOT_ID_FORM_NAME |
VARCHAR |
No |
|
|
|
The name of the form associated with the questionnaire. |
|
|
7 |
HX_QUESR_TMP_ID |
VARCHAR |
No |
|
|
|
Stores the web-based chart system message records of partially completed history questionnaires that have not been submitted by the patient. |
|
|
8 |
CTX_PAT_ENC_CSN_ID |
NUMERIC |
No |
|
|
|
If the TEMP_QUESR_SRC_WRKFLW_C is a value of 1, this stores the contact serial number of the patient contact that serves as the appointment context for this temporary questionnaire answer. |
|
|