System generated files

June 5, 2010

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 (GUID) 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 numeric System role of the person performing the action. See role codes. Supervisor
responsible_name string Login name of the person now responsible for the interview JackInt
responsible_role numeric System role of the person now responsible for the interview. See role codes. 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 (GUID) of the interview 5b3c8288289646699580e16f5d1b6d1e
roster *string Name of the roster containing the variable members
id1 *numeric Roster ID of the 1st level of nesting 7
id2 *numeric Roster ID of the 2nd level of nesting 7
id3 *numeric Roster ID of the 3rd level of nesting 7
id4 *numeric 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 2018-12-31
time string Time when the comment was left 12:34:56
originator string Login name of the person leaving the comment JohnSup
role numeric System role of the person leaving the comment. See role codes. 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 (GUID) of the interview 5b3c8288289646699580e16f5d1b6d1e
interview__status numeric Last status of interview. See status codes. 100
responsible string Last responsible person JohnSup
interviewers numeric Number of interviewers who worked on this interview 1
rejections__sup numeric How many times this interview was rejected by supervisors 0
rejections__hq numeric How many times this interview was rejected by HQ 1
entities__errors numeric 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 (GUID) of the interview 5b3c8288289646699580e16f5d1b6d1e
roster *string Name of the roster containing the variable members
id1 *numeric Roster ID of the 1st level of nesting 7
id2 *numeric Roster ID of the 2nd level of nesting 7
id3 *numeric Roster ID of the 3rd level of nesting 7
id4 *numeric Roster ID of the 4th level of nesting 7
variable string Variable name for the question, where validation error occurred age
type numeric Type of the variable where the validation error occurred. See type codes. 2
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 magenta color, this alerts of a recent change in how this value is saved.

Coding of roles
Code Meaning
0<UNKNOWN ROLE>
1Interviewer
2Supervisor
3Headquarter
4Administrator
5Api User

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 interview statuses
Code Meaning
-1Deleted
0Restored
20Created
40SupervisorAssigned
60InterviewerAssigned
65RejectedBySupervisor
80ReadyForInterview
85SentToCapi
95Restarted
100Completed
120ApprovedBySupervisor
125RejectedByHeadquarters
130ApprovedByHeadquarters

Coding of types
Code Meaning
1Section
2Question
3StaticText
4Variable