Back to Openemr

external_procedures

Documentation/EHI_Export/docs/tables/external_procedures.html

latest1.1 KB
Original Source

Columns

ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
ep_idINT10null

|

| | | 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 NameTypeSortColumn(s)
PRIMARYPrimary keyAscep_id
ep_pidPerformanceAscep_pid

Relationships

Close relationships within degrees of separation