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

Related columns Constraint Comments

Search:

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

Showing 1 to 9 of 9 entries

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees