This is one of the result tables and it holds the patient's encounter set information.
QT_PATIENT_ENC_COLLECTION |
|
|
|
Key |
Column Name |
Column Definition |
Nullable? |
PK |
PATIENT_ENC_COLL_ID |
Unique id for the patient encounter set |
NO |
FK |
RESULT_INSTANCE_ID |
Foreign key reference to the QT_QUERY_RESULT_INSTANCE table |
NO |
|
SET_INDEX |
The set index for each patient number |
NO |
|
PATIENT_NUM |
The patient number. |
NO |
|
ENCOUNTER_NUM |
The encounter number for the PATIENT_NUM |
NO |