Documentation/EHI_Export/docs/tables/procedure_result.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| procedure_result_id | BIGINT | 19 | √ | null |
| clinical_notes_procedure_results.procedure_result_id | Defined in XML | R |
|
|
Surrogate id of the record used as the primary incrementing key
| | uuid | BINARY | 16 | √ | | NULL |
|
|
UUID of the record
| | procedure_report_id | BIGINT | 19 | | | null |
|
| procedure_report.procedure_report_id | Defined in XML | R |
|
references procedure_report.procedure_report_id
| | result_data_type | CHAR | 1 | | | 'S' |
|
|
N=Numeric, S=String, F=Formatted, E=External, L=Long text as the first line of comments
| | result_code | VARCHAR | 31 | | | '' |
|
|
LOINC code, might match a procedure_type.procedure_code
| | result_text | VARCHAR | 255 | | | '' |
|
|
Description of result_code
| | date | DATETIME | 19 | √ | | NULL |
|
|
Lab-provided date specific to this result
| | facility | VARCHAR | 255 | | | '' |
|
|
Lab-provided testing facility ID
| | units | VARCHAR | 31 | | | '' |
|
|
Units for the result
| | result | VARCHAR | 255 | | | '' |
|
|
Result data
| | range | VARCHAR | 255 | | | '' |
|
|
Result range
| | abnormal | VARCHAR | 31 | | | '' |
|
|
Abnormal values (no, yes, high, low)
| | comments | TEXT | 65535 | √ | | NULL |
|
|
Comments from the lab
| | document_id | BIGINT | 19 | | | 0 |
|
| documents.id | Defined in XML | R |
|
References documents.id if this result is a document
| | result_status | VARCHAR | 31 | | | '' |
|
|
Result status (preliminary, cannot be done, final, corrected, incomplete, etc.)
| | date_end | DATETIME | 19 | √ | | NULL |
|
|
Lab-provided end date specific to this result
|
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | procedure_result_id |
| procedure_report_id | Performance | Asc | procedure_report_id |
| uuid | Must be unique | Asc | uuid |