procedure_order_code


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

Holds individual procedure / labs ordered from the procedure_type table for a given procedure order. It contains also the individual diagnosis code that is related to the ordered procedure

Columns

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

references procedure_order.procedure_order_id
procedure_order_seq INT 10 null

Supports multiple tests per order. Procedure_order_seq, incremented in code
procedure_code VARCHAR 64
procedure_type.procedure_code Defined in XML R

like procedure_type.procedure_code
procedure_name VARCHAR 255

descriptive name of the procedure code
procedure_source CHAR 1 1

1=original order, 2=added after order sent
diagnoses TEXT 65535 √ null

diagnoses and maybe other coding (e.g. ICD9:111.11)
do_not_send BIT 1 0

0 = normal, 1 = do not transmit to lab
procedure_order_title VARCHAR 255 √ null
procedure_type VARCHAR 31 √ null
transport VARCHAR 31 √ null
date_end DATETIME 19 √ null
reason_code VARCHAR 31 √ null
reason_description TEXT 65535 √ null
reason_date_low DATETIME 19 √ null
reason_date_high DATETIME 19 √ null
reason_status VARCHAR 31 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc procedure_order_id + procedure_order_seq

Relationships

Close relationships within degrees of separation