ehi_export_job_tasks


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

Export task for a subset of patients in the export job

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ehi_task_id BIGINT 19 √ null
ehi_export_job_task_patients.ehi_task_id FK_ehi_export_job_task_patients_job_id C
ehi_export_job_id INT 10 null
ehi_export_job.ehi_export_job_id FK_task_ehi_export_job_id R
export_document_id INT 10 √ NULL
documents.id FK_task_ehi_export_document_id R

FK to documents.id - represents the document result file that was created as part of this task
creation_date DATETIME 19 current_timestamp()
completion_date DATETIME 19 current_timestamp()
status VARCHAR 20 'pending'

pending=task export has not started, processing=task export in progress, failed=error occurred in the task, completed=export task completed without errors
error_message TEXT 65535 √ NULL

The error that occurred in the export process, only populated if status=failed
exported_result TEXT 65535 √ NULL

The JSON encoded result of the export process, populated during processing for status updates

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc ehi_task_id
FK_task_ehi_export_document_id Performance Asc export_document_id
FK_task_ehi_export_job_id Performance Asc ehi_export_job_id

Relationships

Close relationships within degrees of separation