| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| procedure_order_id | BIGINT | 19 | null |
|
|
references procedure_order.procedure_order_id |
|||||
| procedure_order_seq | INT | 10 | null |
|
|
Supports multiple tests per order. Procedure_order_seq incremented in code |
|||||
| procedure_code | VARCHAR | 64 | '' |
|
|
like procedure_type.procedure_code |
|||||
| procedure_name | VARCHAR | 255 | '' |
|
|
descriptive name of the procedure code |
|||||
| procedure_source | CHAR | 1 | '1' |
|
|
1=original order, 2=added after order sent |
|||||
| diagnoses | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
diagnoses and maybe other coding (e.g. ICD9:111.11) |
||||
| do_not_send | BOOLEAN | 3 | 0 |
|
|
0 = normal, 1 = do not transmit to lab |
|||||
| procedure_order_title | VARCHAR | 255 | √ | NULL |
|
|
|||||
| procedure_type | VARCHAR | 31 | √ | NULL |
|
|
|||||
| transport | VARCHAR | 31 | √ | NULL |
|
|
|||||
| date_end | DATETIME | 19 | √ | NULL |
|
|
|||||
| reason_code | VARCHAR | 31 | √ | NULL |
|
|
|||||
| reason_description | MEDIUMTEXT | 16777215 | √ | NULL |
|
|
|||||
| reason_date_low | DATETIME | 19 | √ | NULL |
|
|
|||||
| reason_date_high | DATETIME | 19 | √ | NULL |
|
|
|||||
| reason_status | VARCHAR | 31 | √ | NULL |
|
|
Showing 1 to 16 of 16 entries