procedure_report


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of procedure_report.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Procedure order overall report container for an ordered procedure result in procedure_order_codes which represents findings, conclusions, and recommendations for the procedure order

Columns

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.

Indexes

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

Relationships

Close relationships within degrees of separation