DatStat Internal Variables

These variables are created automatically with every survey and are found in the Data Dictionary.  They can be queried and downloaded as any other variable.


DATSTAT.SUBMISSIONID – The unique id of this data submission. No other submission on this or any other survey shares this submission id.

DATSTAT.SESSIONID – How is this calculated?  The session id assigned by the web server to this participant’s login session.

DATSTAT.VERSION – The version of the survey that the participant submitted. A survey gets a new version number each time it is published. This number may be important in some cases. For example, if a participant submitted version 2 of a survey, you know that the participant did not see any of the edits or new questions that appeared on version 3 of the survey.

DATSTAT.LOCALE – This is the locale setting on the participant’s computer. This may not always be available. The locale setting determines, among other things, what language the computer uses, and how it formats dates and times. Microsoft provides more information about locales in its Locales & Languages page (http://www.microsoft.com/globaldev/DrIntl/faqs/Locales.mspx).

DATSTAT.LANGUAGE – This variable indicates that the survey was in English

DATSTAT.BROWSER – This is the browser the participant used to enter data. This is actually the text of the browser’s “user agent” string.

DATSTAT.STARTDATETIME – This variable indicates the date and time the survey the participant first logged on to begin the survey.  The date and time the participant began entering data.

DATSTAT.ENDTIME – This indicates the time the survey was submitted.  The date and time the participant finished entering data.

DATSTAT.ELAPSEDTIME – This indicates the time (in minutes) the participant took taking the survey.  The total number of minutes it took the participant to finish entering data. Note that this cannot always be a reliable figure. If a participant spends 10 minutes answering questions, then takes an hour break for lunch, then spends another 10 minutes completing the survey, this field will show 80 minutes, even though only 20 minutes of that time was spend answering questions.

DATSTAT.SUBMISSIONSTATUS – This indicates the submission status of the participant’s survey (1 = completed; 2 = partially completed; 4 = not started; 5=terminated

This field contains one of three values:

  • 1 indicates the participant completed the survey
  • 2 indicates the participant started the survey but did not submit a complete survey.
  • 4 indicates that the participant did not start the survey
  • 5 indicates that the participant was terminated and did not complete

DATSTAT.LOGINCOUNT – This indicates the number of times the participant logged into the online survey (?)

This shows the number of times the participant logged in to this particular survey

DATSTAT.JAVASCRIPT – A value of 1 indicates that the participant’s browser had JavaScript enabled. A value of 0 indicates that JavaScript was disabled or not supported in the participant’s browser.

DATSTAT.TIMEPERIOD – This shows the time period during which the survey was submitted. Time periods apply primarily to longitudinal surveys (those where a single participant submits the survey more than once over time). Time period names are arbitrary (e.g. “P1” or “Spring 2008”) and are set at the time of publication by the user who publishes the survey. If you publish your survey under multiple time periods, you can filter your survey results by time period when querying the data.

DATSTAT.PCTCOMPLETE – The percentage of questions that the participant completed. If the survey includes a progress bar, this is the figure that drives the progress bar. For incomplete (a.k.a. “partial”) submissions, this shows how far the participant progressed.

DATSTAT.LOGINDATETIME – This shows date and time when this participant last logged in. It will be the same as

DATSTAT.UPLOADDATETIME – The date and time if and when this submission was uploaded

DATASTAT.UPLOADUSER – The name of the user that uploaded this submission

DATSTAT.UPLOADTYPE – The type of upload 1 = Remote Data Collection; 2 – Imported with Data Import

DATSTAT.IMPORTDATETIME – The date and time this submission was imported. This applies only to surveys that were imported into Illume from another application or data source. This value will be empty if the participant submitted his or her survey directly via a web browser, which is the case with all of your submissions.

DATSTAT.NUMPRESENTED – This indicates the number of items the participant was presented while logged into the survey

The number of questions presented to the participant. Show-if conditions and conditional jumps can cause this number to be lower than the total number of questions in the survey for a specific participant.

DATSTAT.NUMANSWERED – This indicates the number of items answered by the participant, including the “I choose not to answer” option

DATSTAT.NUMUNANSWERED – Number of questions unanswered by this participant

DATSTAT.PCTUNANSWERED – This indicates the percent of items left unanswered by the participant

The percentage of questions left unanswered by this participant. This number does not include items that were never presented to the specific participant because of show-if conditions or jumps.

DATSTAT.SITE – Participant site a the time when this survey was started

DATSTAT.INTERVIEWER – User that interviewed the participant




DATSTAT.RMSINSTANCE – RMS Instance in the Milestone