external_procedures


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_procedures.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 external procedures that exist outside of this EMR that were in a patient CCDA import

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ep_id INT 10 √ null
ep_date DATE 10 √ NULL
ep_code_type VARCHAR 20 √ NULL
ep_code VARCHAR 9 √ NULL
ep_pid INT 10 √ NULL
patient_data.pid Defined in XML R

The internal patient identifier
ep_encounter INT 10 √ NULL
form_encounter.encounter Defined in XML R

The encounter for the external procedure
ep_code_text LONGTEXT 2147483647 √ NULL
ep_facility_id VARCHAR 255 √ NULL
ep_external_id VARCHAR 255 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ep_id
ep_pid Performance Asc ep_pid

Relationships

Close relationships within degrees of separation