ehi_export_job_patients


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 ehi_export_job_patients.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

Patients to be exported in the ehi_export_job

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ehi_export_job_id INT 10 null
ehi_export_job.ehi_export_job_id FK_ehi_export_job_patients_job_id C
pid BIGINT 19 null
patient_data.pid FK_ehi_export_job_patients_patient_id C

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc ehi_export_job_id + pid
FK_ehi_export_job_patients_patient_id Performance Asc pid

Relationships

Close relationships within degrees of separation