Back to Openemr

external_encounters

Documentation/EHI_Export/docs/tables/external_encounters.html

latest868 B
Original Source

Columns

ColumnTypeSizeNullsAutoDefaultChildrenParentsComments
ee_idINT10null

|

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

Relationships

Close relationships within degrees of separation