|
Name |
Type |
Discontinued? |
|
1 |
CASE_ID |
NUMERIC |
No |
|
|
|
The unique ID for the case record. |
|
|
2 |
CONTACT_DATE_REAL |
FLOAT |
No |
|
|
|
The contact date in decimal format. |
|
|
3 |
LINE |
INTEGER |
No |
|
|
|
The line count of questionnaire information for the case record. |
|
|
4 |
CONTACT_DATE |
DATETIME |
No |
|
|
|
The contact date in datetime format. |
|
|
5 |
QUEST_FORM_ID |
VARCHAR |
No |
|
|
|
The unique ID of the questionnaire form. |
|
|
6 |
QUEST_FORM_ID_FORM_NAME |
VARCHAR |
No |
|
|
|
The name of the form associated with the questionnaire. |
|
|
7 |
QUEST_ANSWER_ID |
VARCHAR |
No |
|
|
|
The unique ID of the questionnaire answer. |
|
|
8 |
QUEST_TIME |
DATETIME (Local) |
No |
|
|
|
The date and time of the questionnaire. |
|
|
9 |
QUEST_USER_ID |
VARCHAR |
No |
|
|
|
The unique ID of the user associated with the questionnaire. |
|
|
10 |
QUEST_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
11 |
QUEST_COMMENT |
VARCHAR |
No |
|
|
|
The comment of the questionnaire. |
|
|