The following information needs to be extracted from the questionnaire.

Please find the explanation for Questionnaire Elements

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

Label	Starts With	Example	Label Note
Statement	s_q	s_qQual
Question item	qi_	qi_Smoker
Question grid	qg_	qg_Qual
Code list	cs_	cs_Yes_No
Condition	c_q	c_qSmoker	Labelled after the question in the condition logic. If there isn't logic then it should be labelled after the first question inside the condition. In case of duplicated labels: c_qSmoker_i, c_qSmoker_ii etc.
Loop	l_q	l_qSmoker	Labelled after the first question inside the loop.

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

This is a sample questionnaire:

Input temp tables:

Sequence
Label Parent_Type Parent_Name Branch Position
Example_1 CcSequence

1
Section1 CcSequence Example_1
1
SubSection1 CcSequence Section1
1
Section2 CcSequence Example_1
2
Statement
Label Literal Parent_Type Parent_Name Branch Position
s_qQual First I'd like to ask you a few things about your qualification. CcSequence Section2
1

Question item

Label	Literal	Instructions	Response	Parent_Type	Parent_Name	Branch	Position	min_responses	max_responses
qi_Smoker	Have you ever been a smoker?	Please tick one box	cs_Yes_No	CcLoop	l_qSmoker		1	1	1
qi_Number	How many cigarettes a day?		How many I	CcCondition	c_qSmoker	0	1
qi_Duration	How long have you been smoking?		Months Years	CcCondition	c_qSmoker	0	2

Question grid

Label	Literal	Instructions	Horizontal_Codelist_Name	Vertical_Codelist_Name	Response_Domain	Parent_Type	Parent_Name	Branch	Position	Horizontal_min_responses	Horizontal_max_responses	Vertical_min_responses	Vertical_max_responses
qg_Qual	Which qualifications do you have?	INTERVIEWER: CODE ALL THAT APPLY	cs_dash	cs_qQual_Y	cs_Yes_No	CcSequence	Section2		2	1	1	1	1

Code list

Label	Code_Order	Code_Value	Category
cs_Yes_No	1	1	Yes
cs_Yes_No	2	2	No
cs_qQual_Y	1	1	O level (obtained before 1975)
cs_qQual_Y	2	2	O level A-C (1975 or later)
cs_qQual_Y	3	3	O level D,E (1975 or later)
cs_qQual_Y	4	4	GCSE grades A-C
cs_qQual_Y	5	5	GCSE grades D-G
cs_qQual_Y	6	6	CSE grade 1
cs_qQual_Y	7	7	CSE grade 2-5
cs_dash	1	1	-

Condition
Label Literal Logic Parent_Type Parent_Name Branch Position
c_qSmoker If yes. qc_Smoker == 1 CcLoop l_qSmoker
2
Loop
Label Loop_While Start_value End_Value Variable Parent_Type Parent_Name Branch Position
l_qSmoker
1 10 _eligiblepersons CcSequence SubSection1
1

Browser not supported