external_encounters


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of external_encounters.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Holds data on encounters that exist outside of this EMR that were in a patient CCDA import

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ee_id INT 10 √ null
ee_date DATE 10 √ null
ee_pid INT 10 √ null
patient_data.pid Defined in XML R

The internal patient identifier
ee_provider_id VARCHAR 255 √ null
ee_facility_id VARCHAR 255 √ null
ee_encounter_diagnosis VARCHAR 255 √ null
ee_external_id VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ee_id

Relationships

Close relationships within degrees of separation