procedure_answers


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

Answers to questions that are requested to be answered for a given procedure by a procedure provider (lab, or other provider)

Columns

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

references procedure_order.procedure_order_id
procedure_order_seq INT 10 0

references procedure_order_code.procedure_order_seq
question_code VARCHAR 31 ''
procedure_questions.question_code Defined in XML R

references procedure_questions.question_code
answer_seq INT 10 null

Supports multiple-choice questions. Answer_seq, incremented in code
answer VARCHAR 255 ''

answer data
procedure_code VARCHAR 31 √ NULL

Indexes

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

Relationships

Close relationships within degrees of separation