Rosters-Export File Anatomy

Recall that each exported file corresponds with a level of observation in the questionnaire. Rosters and their source question are exported as follows:

• Source question: Export file at the questionnaire level (corresponds with the name of the questionnaire)
• Roster: Export file at the roster level (corresponds with the roster name)

List Roster

In the export file at the questionnaire level, a list roster source question generates as many columns as the defined maximum number of list elements. Recorded values will be shown in each column.

Questionnaire Data - Export File Anatomy

Every questionnaire will contain at least one data file corresponding to the main level of data, and potentially one or more subordinate files corresponding to additional levels defined by the rosters.

Questionnaire level file: file name corresponds to the title of the questionnaire  

The questionnaire level export file consists of the following columns: Id, question variable names including roster trigger questions, and the system generated case Id.

1. Id. Survey Solutions generated identifier for each survey case.
2. Variables for main (questionnaire) level. These variables contain the answers for the questions in the main questionnaire level. All sections of the questionnaire at the same level are automatically combined.
3. Rosters trigger questions. Answers to any questions that trigger rosters are also exported at their respective level. In this illustration the Household Roster (variable hh_list) and Garden Roster (variable garden_list) text list questions at the questionnaire level.
4. ssSys_IRnd. A system generated specific random number between 0 and 1 for each survey case.  

Data Export Files

Overview

The exported data will be in a .zip file containing one or more files. The number of such files is a function of the structure of the questionnaire, meaning that exporting produces one file per level of observation in the questionnaire, or in other words in addition to one file at the questionnaire level, each roster in the questionnaire will generate another export file.  For example, one file for household-level variables, one file for household member-level variables, and one file for asset-level or consumption item-level variables. Additionally, the .zip file will contain interview comments and interview actions files.