QUESR_LST_ANS_INFO

Description: |
This table stores information about the most recent patient questionnaire submission. This table stores when the questionnaire was last answered and the contact serial number for the encounter.

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 | QUESR_ANS_FORM_ID | VARCHAR | No |
This column stores recently answered questionnaire IDs. Use the QUESR_ANS_CSN_ID and QUESR_ANS_DDATETIME columns to determine the encounter and last submission instant for each questionnaire.
4 | QUESR_ANS_FORM_ID_FORM_NAME | VARCHAR | No |
The name of the form associated with the questionnaire.
5 | QUESR_ANS_CSN_ID | NUMERIC | No |
This column stores the encounter contact serial number (CSN) for the most recent questionnaire submissions. Use the QUESR_ANS_FORM_ID and QUESR_ANS_CSN_ID columns to determine the form ID and encounter contact serial number for each questionnaire.
6 | QUESR_ANS_DATETIME | DATETIME (Attached) | No |
This column stores the last instant of submission for questionnaires. Use the QUESR_ANS_FORM_ID and QUESR_ANS_CSN_ID columns to determine the form ID and encounter contact serial number for each questionnaire.