procedure_type


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

This table holds a compendium of possible procedures and labs that can be ordered by the procedure ordering system within OpenEMR

Columns

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

Surrogate id of the record used as the primary incrementing key
parent BIGINT 19 0

References procedure_type.procedure_type_id for heirarchies of procedure types
name VARCHAR 63

Name for this category, procedure or result type
lab_id BIGINT 19 0

References procedure_providers.ppid, 0 means default to parent
procedure_code VARCHAR 64
procedure_order_code.procedure_code Defined in XML R
procedure_questions.procedure_code Defined in XML R

Code and code system identifying this procedure in the format of codesystem:code
procedure_type VARCHAR 31
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘proc_type’ and represents the kind of procedure_type this is (‘group’, ‘order’, ‘discrete_result’, etc’)
body_site VARCHAR 31

Where to do injection, e.g. arm, buttock
specimen VARCHAR 31

Blood, urine, saliva, etc.
route_admin VARCHAR 31

Oral, injection
laterality VARCHAR 31

Left, right, …
description VARCHAR 255

Descriptive text for procedure_code
standard_code VARCHAR 255

Industry standard code type and code (e.g. CPT4:12345)
related_code VARCHAR 255

Suggested code(s) for follow-up services if result is abnormal
units VARCHAR 31

Default for procedure_result.units
range VARCHAR 255

Default for procedure_result.range
seq INT 10 0

Sequence number for ordering
activity BIT 1 1

1=active, 0=inactive
notes VARCHAR 255

Additional notes to enhance description
transport VARCHAR 31 √ null
procedure_type_name VARCHAR 64 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc procedure_type_id
parent Performance Asc parent
ptype_procedure_code Performance Asc procedure_code

Relationships

Close relationships within degrees of separation