procedure_order_relationships


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

Links ServiceRequests to supporting clinical information

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
procedure_order_id BIGINT 19 null
procedure_order.procedure_order_id Defined in XML R

Links to procedure_order.procedure_order_id
resource_type VARCHAR 50 null

FHIR resource type (Observation, Condition, etc.)
resource_uuid BINARY 16 null

UUID of the related resource
relationship VARCHAR 50 √ NULL

Type of relationship
created_at TIMESTAMP 19 √ current_timestamp()
created_by BIGINT 19 √ NULL

User who created this link

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_created_at Performance Asc created_at
idx_order_id Performance Asc procedure_order_id
idx_resource Performance Asc/Asc resource_type + resource_uuid

Relationships

Close relationships within degrees of separation