Tables structure
- Hayley Mills
- Becky Oldroyd
Owned by Hayley Mills
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
| 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 ..
Format of each table
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 ResponseÂ
Label Type Type2 Format Min Max Generic text Text 255 How many I Numeric Integer 0 Generic time Date Time How many F Numeric Float 0 Months Years Date Duration PnnYnnM Generic date Date Date 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