| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| procedure_report_id | BIGINT | 19 | √ | null |
|
|
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 |
|
|
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_report | DATETIME | 19 | √ | NULL |
|
|
Date and time when the report was generated. |
||||
| source | BIGINT | 19 | 0 |
|
|
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 | '' |
|
|
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 | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
Notes from the lab related to the report. |
||||
| date_collected_tz | VARCHAR | 5 | √ | '' |
|
|
Timezone offset from UTC for the date collected. |
||||
| date_report_tz | VARCHAR | 5 | √ | '' |
|
|
Timezone offset from UTC for the date reported. |