Message-ID: <2017674694.7500.1711628117487.JavaMail.confluence@ip-172-30-4-17.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_7499_524688157.1711628117487" ------=_Part_7499_524688157.1711628117487 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html QT_PATIENT_ENC_COLLECTION

QT_PATIENT_ENC_COLLECTION

This is one of the result tables and it holds the patient's enco= unter set information.

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 = =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

QT_PATIENT_ENC_COLLECTION

 

 

 

Key

Column Name

Column Definition

Nullable?
(Default =3D YES)

PK

PATIENT_ENC_COLL_ID

Unique id for the patient encounter set

=20

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

=20

NO

 

PATIENT_NUM

The patient number.

NO

 

ENCOUNTER_NUM

The encounter number for the PATIENT_NUM

<= /td>=20

NO

=20



------=_Part_7499_524688157.1711628117487--