procedure_result


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_result.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

The table stores the actual results and findings from medical procedures and tests, such as laboratory tests, radiology reports, diagnostic imaging, and other clinical tests.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
procedure_result_id BIGINT 19 √ null

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

Indexes

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

Relationships

Close relationships within degrees of separation