procedure_questions


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

Information/questions that should be answered for a given procedure as requested by the procedure service provider. Created as part of the procedure compendium import/creation process.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
lab_id BIGINT 19 0
procedure_providers.ppid Defined in XML R

references procedure_providers.ppid to identify the lab
procedure_code VARCHAR 31
procedure_type.procedure_code Defined in XML R

references procedure_type.procedure_code to identify this order type
question_code VARCHAR 31
procedure_answers.question_code Defined in XML R

code identifying this question
seq INT 10 0

sequence number for ordering
question_text VARCHAR 255

descriptive text for question_code
required BIT 1 0

1 = required, 0 = not
maxsize INT 10 0

maximum length if text input field
fldtype CHAR 1 T

Text, Number, Select, Multiselect, Date, Gestational-age
options TEXT 65535 √ null

choices for fldtype S and T
tips VARCHAR 255

Additional instructions for answering the question
activity BIT 1 1

1 = active, 0 = inactive

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc/Asc lab_id + procedure_code + question_code

Relationships

Close relationships within degrees of separation