ehi_export_job_task_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_task_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_tasks

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ehi_task_id BIGINT 19 null
ehi_export_job_tasks.ehi_task_id FK_ehi_export_job_task_patients_job_id C
pid BIGINT 19 null
patient_data.pid FK_ehi_export_job_task_patients_patient_id C

Indexes

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

Relationships

Close relationships within degrees of separation