Tables structure
The following information needs to be extracted from the questionnaire.
Please find the explanation for Questionnaire Elements
Sequence
Statement
Question item
Question grid
Code list
Response
Condition
Loop
The table structure and example are given below, but please see https://gitlab.com/jli755/archivist_insert_workaround/-/tree/master/template for the latest version.
The checklist will also help with finding any potential problems.
Naming
Branch in conditions 0 is true 1 is else. i.e. if the parent_type is condition, and it if a true branch, then branch = 0 for that question/statement ..
Format of each table
This is a sample questionnaire:
Input temp tables:
Sequence
Statement
Question item
Question grid
Response
Code list
Condition
Loop