|
Name |
Type |
Discontinued? |
|
| 1 |
ANSWER_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the questionnaire answer record. |
|
|
| 2 |
LINE |
INTEGER |
No |
|
|
|
| Line count of the answers in the questionnaire record. |
|
|
| 3 |
QUEST_LINE_NUM |
INTEGER |
No |
|
|
|
| The line number for the question for this record. |
|
|
| 4 |
QUEST_EDIT_USER_ID |
VARCHAR |
No |
|
|
|
| The unique ID of the user associated with this record. |
|
|
| 5 |
QUEST_EDIT_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 6 |
QUESTION_INSTANT |
DATETIME (Local) |
No |
|
|
|
| Stores the instant a question was answered. |
|
|
| 7 |
VARCHAR_ANSWER |
VARCHAR |
No |
|
|
|
| For questions of networked or category response types where the linked INI and item is string (aka varchar) based, this column will hold either a record ID or category ID. These are useful for linking directly to other tables such as CLARITY_SER for provider-linked questions, or ZC tables for category response types. If you are unsure what types of records these IDs hold, consult CL_QQUEST_OVTM for the question ID in the QUEST_ID column and use the RESP_INI and RESP_ITEM columns. |
|
|
| 8 |
NUMERIC_ANSWER |
INTEGER |
No |
|
|
|
| For questions of networked or category response types where the linked INI and item is numeric (integer) based, this column holds either a record ID or category ID. |
|
|
| 9 |
FLOAT_ANSWER |
FLOAT |
No |
|
|
|
| The answer to the question for this record converted into a floating point value. |
|
|
| 10 |
IS_NULL |
INTEGER |
No |
|
|
|
| Specifies if there was no response to a question (set to 1 - Yes). |
|
|
| 11 |
QUESTION_SDI |
VARCHAR |
No |
|
|
|
| The SmartData identifier of the SmartData element that this patient-entered custom history question uses. |
|
|
| 12 |
QUESN_SDI_FILED_YN |
VARCHAR |
No |
|
|
|
| Whether the response to this custom history question has been filed to the patient's history. |
| May contain organization-specific values: No |
| Category Entries: |
| No |
| Yes |
|
|
| 13 |
DATETIME_ANSWER |
DATETIME (Local) |
No |
|
|
|
| Stores questionnaire answer data in a datetime format that includes hours and seconds. |
|
|
| 14 |
TIME_ANSWER |
VARCHAR |
No |
|
|
|
| The answer to the question for this record, formatted as a time value. This is the preferred column for reporting on answers to questions with the response type (LQL 110) of 3-Time. Source: HQA 120 |
|
|
| 15 |
SCORE_STD_ERR |
NUMERIC |
No |
|
|
|
| The standard error on the score calculated by the computerized adaptive testing (CAT) algorithm |
|
|
| 16 |
DOC_INFO_ID |
VARCHAR |
No |
|
|
|
| The unique identifier of a document uploaded for a question. |
|
|
| 17 |
FOL_UP_PAR_QUEST_ID |
VARCHAR |
No |
|
|
|
| The question ID (LQL) of the parent question for which this follow-up question is answered. |
|
|
| 18 |
PAT_LOC_DOC_ID |
VARCHAR |
No |
|
|
|
| Stores the ID of the drawing record (DCS) submitted by the patient in the locale in which he answered the question if the locale is different from the base locale. |
|
|
| 19 |
ANSWER_SEVERITY_C_NAME |
VARCHAR |
No |
|
|
|
| The severity level of an answer. Calculated using the thresholds defined for the question that was answered. |
| May contain organization-specific values: No |
| Category Entries: |
| Normal |
| Abnormal |
| Critical |
|
|
