Documentation/EHI_Export/docs/tables/procedure_report.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| procedure_report_id | BIGINT | 19 | √ | null |
| procedure_result.procedure_report_id | Defined in XML | R |
|
|
Unique identifier for the procedure report. This is the primary key.
| | uuid | BINARY | 16 | √ | | NULL |
|
|
Universally unique identifier for the procedure report.
| | procedure_order_id | BIGINT | 19 | √ | | NULL |
|
| procedure_order.procedure_order_id | Defined in XML | R |
|
References the procedure order for which this report is associated.
| | procedure_order_seq | INT | 10 | | | 1 |
|
|
References procedure_order_code.procedure_order_seq.
| | date_collected | DATETIME | 19 | √ | | NULL |
|
|
Date and time when the report was collected.
| | date_collected_tz | VARCHAR | 5 | √ | | '' |
|
|
Timezone offset from UTC for the date collected.
| | date_report | DATETIME | 19 | √ | | NULL |
|
|
Date and time when the report was generated.
| | date_report_tz | VARCHAR | 5 | √ | | '' |
|
|
Timezone offset from UTC for the date reported.
| | source | BIGINT | 19 | | | 0 |
|
| users.id | Defined in XML | R |
|
References the user who entered this report data.
| | specimen_num | VARCHAR | 63 | | | '' |
|
|
A unique identifier for the specimen associated with the report.
| | report_status | VARCHAR | 31 | | | '' |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘proc_rep_status’ and represents the current state/status of the report (e.g. received, complete, error)
| | review_status | VARCHAR | 31 | | | 'received' |
|
|
The status of the report review (e.g., pending review, received, reviewed).
| | report_notes | TEXT | 65535 | √ | | NULL |
|
|
Notes from the lab related to the report.
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | procedure_report_id |
| procedure_order_id | Performance | Asc | procedure_order_id |
| uuid | Must be unique | Asc | uuid |