CL_QANSWER_QNR_PROGRESS

Description: |
The CL_QANSWER_QNR_PROGRESS table contains information about the steps a user took while navigating a questionnaire as they provided answers. This information includes the questionnaires they've seen and the pages they've visited.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ANSWER_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ANSWER_ID | VARCHAR | No |
This column stores the unique identifier 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 | FORM_CSN_ID | NUMERIC | No |
Stores what questionnaire form was shown to the patient at this point in their audit history.
4 | FORM_PAGE | INTEGER | No |
Stores what page of the corresponding questionnaire was shown to the patient at this point in their audit history.
5 | IN_PROGRESS_FORM_ID | VARCHAR | No |
Stores the record ID for the questionnaire that was shown to the patient at this point in their audit history.
6 | IN_PROGRESS_FORM_ID_FORM_NAME | VARCHAR | No |
The name of the form associated with the questionnaire.
7 | IN_PROGRESS_CONTACT_DATE_REAL | NUMERIC | No |
Stores the contact date (DAT) for the questionnaire that was shown to the patient at this point in their audit history.
8 | FORM_ANSWER_ID | VARCHAR | No |
Stores the answer corresponding to the questionnaire that was shown to the patient at this point in their audit history.
9 | COMPLD_FORM_LOCALE | VARCHAR | No |
Stores the locale subscript of the compiled questionnaire record that was shown to the patient at this point in their audit history. This only applies if a language override was triggered.
10 | FORM_SUBPAGE | INTEGER | No |
Stores the last subpage shown to the patient for a given page in their audit history.