Documentation/EHI_Export/docs/tables/procedure_specimen.html
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| procedure_specimen_id | BIGINT | 19 | √ | null |
|
|
record id
| | uuid | BINARY | 16 | √ | | NULL |
|
|
FHIR Specimen id
| | procedure_order_id | BIGINT | 19 | | | null |
|
| procedure_order.procedure_order_id | Defined in XML | R |
|
links to procedure_order.procedure_order_id
| | procedure_order_seq | INT | 10 | | | null |
|
| procedure_order_code.procedure_order_seq | Defined in XML | R |
|
links to procedure_order_code.procedure_order_seq (per test line)
| | specimen_identifier | VARCHAR | 128 | √ | | NULL |
|
|
tube/barcode/internal id
| | accession_identifier | VARCHAR | 128 | √ | | NULL |
|
|
lab accession number
| | specimen_type_code | VARCHAR | 64 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘specimen_type’ and represents the type of specimen being collected for the procedure
| | specimen_type | VARCHAR | 255 | √ | | NULL |
|
|
display/text
| | collection_method_code | VARCHAR | 64 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘specimen_collection_method’ and represents the type of specimen being collected for the procedure
| | collection_method | VARCHAR | 255 | √ | | NULL |
|
| | | specimen_location_code | VARCHAR | 64 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘specimen_location’ and represents the body location the specimen is collected from for the procedure
| | specimen_location | VARCHAR | 255 | √ | | NULL |
|
| | | collected_date | DATETIME | 19 | √ | | NULL |
|
|
single instant
| | collection_date_low | DATETIME | 19 | √ | | NULL |
|
|
period start
| | collection_date_high | DATETIME | 19 | √ | | NULL |
|
|
period end
| | volume_value | DECIMAL | 10,3 | √ | | NULL |
|
| | | volume_unit | VARCHAR | 32 | √ | | 'mL' |
|
| | | condition_code | VARCHAR | 32 | √ | | NULL |
|
| list_options.option_id | Defined in XML | R |
|
Comes from the list_options.list_id=‘specimen_condition’ and represents the condition / quality of the specimen being collected for the procedure
| | specimen_condition | VARCHAR | 64 | √ | | NULL |
|
| | | comments | TEXT | 65535 | √ | | NULL |
|
| | | created_at | DATETIME | 19 | √ | | current_timestamp() |
|
| | | updated_at | DATETIME | 19 | √ | | current_timestamp() |
|
| | | created_by | BIGINT | 19 | √ | | NULL |
|
| users.id | Defined in XML | R |
| | | updated_by | BIGINT | 19 | √ | | NULL |
|
| users.id | Defined in XML | R |
| | | deleted | BOOLEAN | 3 | √ | | 0 |
|
| |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | procedure_specimen_id |
| idx_accession | Performance | Asc | accession_identifier |
| idx_identifier | Performance | Asc | specimen_identifier |
| idx_order_line | Performance | Asc/Asc | procedure_order_id + procedure_order_seq |
| uuid_unique | Must be unique | Asc | uuid |