|
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. |
|
|