Viewing the Data Dictionary

To see a survey’s Data Dictionary, choose Review Data Dictionary from the Tools menu. This displays the same data dictionary that appears in the Data Manager.

 

The Data Dictionary is organized by Collection.  It can be printed via the Print button.  There is no save button, however you may print to PDF (if you have a PDF-maker on your device) and save that PDF.

DatStat Auto-Generated 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 – The session id a unique alpha numeric string assigned by the web server to a participant’s session.  Every survey session has a single unique session ID.  This value is important within the Data Import feature in the Data Manager, as it can be used to update an existing survey submission.

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 the four digit LCID for the participant, which is the Locale ID – it represents the language in which the survey was taken.  By default this is 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 – when the Login button was clicked either by the participant, or by way of clicking a unique link delivered in an Illume email.  The date and time the participant began entering data.

DATSTAT.ENDTIME – This indicates the date and time the survey was submitted (clicked the Submit button)

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 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.

DATSTAT.UPLOADDATETIME – The date and time if and when this submission was uploaded either via Remote Data Collection or imported with Data Import.

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.

DATSTAT.NUMPRESENTED – This indicates the number of items the participant was presented while logged into the survey. 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 – 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 at the time when this survey was started.

DATSTAT.INTERVIEWER – User that interviewed the participant.

DATSTAT.RMSSURVEY – Only relevant for Discovery product users.  Identifies the Illume survey utilized in the Survey Study task

DATSTAT.RMSMILESTONE – Only relevant for Discovery product users.Identifies the milestone in which the Survey Study task resides.

DATSTAT.RMSSTUDYARM – Only relevant for Discovery product users. Identifies the study arm in which the Survey Study task resides.

DATSTAT.RMSINSTANCE – Only relevant for Discovery product users. Identifies the instance of the survey study task within the study milestone.

DATSTAT.RMSSTUDY – Only relevant for Discovery product users. Identifies the Discovery study in which the Survey Study task resides.