System generated files

December 12, 2018

Every archive of data exported from the Survey Solutions Headquarters contains among the user data the following system-generated data files:

  • interview__actions;
  • interview__comments;
  • interview__diagnostics;
  • interview__errors.

The data files are also accompanied by an automatically generated file named export__readme.txt. This file documents which version of the Survey Solutions software was used to export the data, when the export was done, and placement of variables into the data files. Here is an example of such a file that may be accompanying, e.g. an agricultural survey.

The contents of the system-generated data files is described in the table below:

interview__actions

Variable Type Meaning Example
interview__key string Interview key (identifier in XX-XX-XX-XX format) 12-34-56-78
interview__id string Unique 32-character long identifier of the interview 5b3c8288289646699580e16f5d1b6d1e
date string Date when the action was taken 2018-12-12
time string Time when the action was taken 10:11:12
action numeric Type of action taken. See action codes. 12
originator string Login name of the person performing the action JohnSup
role string System role of the person performing the action Supervisor
responsible_name string Login name of the person now responsible for the interview JackInt
responsible_role string System role of the person now responsible for the interview Interviewer

interview__comments

Variable Type Meaning Example
interview__key string Interview key (identifier in XX-XX-XX-XX format) 12-34-56-78
interview__id string Unique 32-character long identifier of the interview 5b3c8288289646699580e16f5d1b6d1e
roster *string Name of the roster containing the variable members
id1 *string Roster ID of the 1st level of nesting 7
id2 *string Roster ID of the 2nd level of nesting 7
id3 *string Roster ID of the 3rd level of nesting 7
id4 *string Roster ID of the 4th level of nesting 7
variable string Variable name for the commented question age
order numeric Sequential order of the comment 1
date string Date when the comment was left 12/31/2018
time string Time when the comment was left 12:34:56
originator string Login name of the person leaving the comment JohnSup
role string System role of the person leaving the comment Supervisor
comment string Text of the comment Age is confirmed by document

interview__diagnostics

Variable Type Meaning Example
interview__key string Interview key (identifier in XX-XX-XX-XX format) 12-34-56-78
interview__id string Unique 32-character long identifier of the interview 5b3c8288289646699580e16f5d1b6d1e
interview__status numeric Last status of interview. See status codes. 100
responsible string Last responsible person JohnSup
interviewers string Number of interviewers who worked on this interview 1
rejections__sup string How many times this interview was rejected by supervisors 0
rejections__hq string How many times this interview was rejected by HQ 1
entities__errors string Number of questions and static texts with errors 10
interview__duration string Active time it took to complete the interview, DD.HH:MM:SS 00.05:28:39

interview__errors

Variable Type Meaning Example
interview__key string Interview key (identifier in XX-XX-XX-XX format) 12-34-56-78
interview__id string Unique 32-character long identifier of the interview 5b3c8288289646699580e16f5d1b6d1e
roster *string Name of the roster containing the variable members
id1 *string Roster ID of the 1st level of nesting 7
id2 *string Roster ID of the 2nd level of nesting 7
id3 *string Roster ID of the 3rd level of nesting 7
id4 *string Roster ID of the 4th level of nesting 7
variable string Variable name for the question, where validation error occurred age
type string Type of the variable where the validation error occurred Question
message__number numeric Numeric index of the validation rule that has fired 1
message string Text of the error message Age may not be negative

Fields indicated with a star (*) are optional and present only if the questionnaire template contains rosters.

Where a value is shown in red or magenta color, this may be (and likely will be) changed in the upcoming releases.

Coding of actions
Code Meaning
0SupervisorAssigned
1InterviewerAssigned
2FirstAnswerSet
3Completed
4Restarted
5ApprovedBySupervisor
6ApprovedByHeadquarter
7RejectedBySupervisor
8RejectedByHeadquarter
9Deleted
10Restored
11UnapprovedByHeadquarter
12Created
13InterviewReceivedByTablet
14Resumed
15Paused
16TranslationSwitched
17OpenedBySupervisor
18ClosedBySupervisor
Coding of the interview status
Code Meaning
-1Deleted
0Restored
20Created
40SupervisorAssigned
60InterviewerAssigned
65RejectedBySupervisor
80ReadyForInterview
85SentToCapi
95Restarted
100Completed
120ApprovedBySupervisor
125RejectedByHeadquarters
130ApprovedByHeadquarters