procedure_order


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

A procedure order is an encounter form within a patient visit representing an order for one or more procedures and its associated report/results for the procedure. Orders can be for either internal or external procedure providers

Columns

Column Type Size Nulls Auto Default Children Parents Comments
procedure_order_id BIGINT 19 √ null
procedure_answers.procedure_order_id Defined in XML R
procedure_order_code.procedure_order_id Defined in XML R
procedure_report.procedure_order_id Defined in XML R

Surrogate id of the procedure order record
uuid BINARY 16 √ null

UUID of the record
provider_id BIGINT 19 0
users.id Defined in XML R

References users.id, representing the ordering provider
patient_id BIGINT 19 null
patient_data.pid Defined in XML R

The internal patient identifier
encounter_id BIGINT 19 0
form_encounter.encounter Defined in XML R

References form_encounter.encounter, representing the encounter for the order
date_collected DATETIME 19 √ null

Time the specimen was collected
date_ordered DATETIME 19 √ null

Date and time the order was placed
order_priority VARCHAR 31
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘ord_priority’ and represents the priority of the order
order_status VARCHAR 31
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘ord_status’ and represents the status of the order (pending, routed, complete, canceled)
patient_instructions TEXT 65535 √ null

Instructions to be given to the patient for the procedure
activity BIT 1 1

0 if the record is deleted, 1 if the record is active
control_id VARCHAR 255

Control ID sent back from the lab
lab_id BIGINT 19 0
procedure_providers.ppid Defined in XML R

References procedure_providers.ppid and is the lab or provider of the procedure that will process the order and the order is being sent to
specimen_type VARCHAR 31
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘Specimen_Type’ and represents the specimen type collected for the procedure
specimen_location VARCHAR 31
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘Specimen_Location’ and represents the location the specimen was collected at
specimen_volume VARCHAR 30

Volume of the specimen
date_transmitted DATETIME 19 √ null

Time of order transmission (null if unsent)
clinical_hx VARCHAR 255

Clinical history text relevant to the order
external_id VARCHAR 20 √ null

External identifier
history_order enum('0', '1') 1 √ 0

Indicates if the order is added for history purposes only. 0=No, 1=Yes
order_diagnosis VARCHAR 255 √

Primary order diagnosis
billing_type VARCHAR 4 √ null
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘procedure_billing’ and represents the kind billing being used for this procedure order (insurance, self-pay, etc)
specimen_fasting VARCHAR 31 √ null

Fasting status of the patient at the time the specimen was collected. 0=Patient not fasting, 1=Patient was fasting at time of collection
order_psc TINYINT 3 √ null

Should the order for the Patient Service Center (PSC) be put on hold. 0=No, 1=Yes
order_abn VARCHAR 31 not_required

The status of the US CMS Advanced Beneficiary Notice and whether the patient has already been given the ABN. Possible values are ‘not_required’=Patient doesn’t need an ABN, ‘required’=Patient needs to be given an ABN before procedure can occur, or ‘signed’=Patient has already been given an ABN and signed it.
collector_id BIGINT 19 0
users.id Defined in XML R

References users.id, representing the individual that collected the specimen
account VARCHAR 60 √ null

The specific name of the facility location associated with the order where the lab work will be sent from. This is typically used for LabCorp orders.
account_facility INT 10 √ null
facility.id Defined in XML R

Facility Location associated with the order where the lab work is being sent from. This is typically used for LabCorp orders.
procedure_type Unknown 0 null
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’)
provider_number VARCHAR 30 √ null

Provider number
procedure_order_type VARCHAR 32 laboratory_test
list_options.option_id Defined in XML R

Comes from the list_options.list_id=‘order_type’ and represents the type of procedure order this is (order, lab test, imaging, physical exams, etc

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc procedure_order_id
datepid Performance Asc/Asc date_ordered + patient_id
patient_id Performance Asc patient_id
uuid Must be unique Asc uuid

Relationships

Close relationships within degrees of separation