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
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 MEDIUMTEXT 16777215 √ 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.)
uuid BINARY 16 √ NULL

UUID of the record
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