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 MEDIUMTEXT 16777215 √ NULL

diagnoses and maybe other coding (e.g. ICD9:111.11)
do_not_send BOOLEAN 3 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 MEDIUMTEXT 16777215 √ 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