The Data Dictionary tab of the survey page shows all of the variables in the survey, along with variable data types, display types, descriptions and scales.
At the top of the data dictionary is a list of collections. Click any collection to see the list of variables belonging to that collection. Click ALL to see all of the variables in the survey.
The data dictionary displays the following items:
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:
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.RMSSURVEY – RMS Survey
DATSTAT.RMSMILESTONE – RMS Milestone
DATSTAT.RMSSTUDYARM – RMS Study ARM
DATSTAT.RMSINSTANCE – RMS Instance in the Milestone
DATSTAT.RMSSTUDY – RMS Study
This can be done by viewing the data dictionary. In the Survey Designer select Tools Review Data Dictionary… The variable count is located at the top of the page. In the Data Manager, first select the survey and then select the Data Dictionary tab. Again the variable count is located at the top of the page.
Custom Variables are computed variables that allow for recoded questions to be quickly created. This functionality is found in the Data Dictionary Tab of a Published or Test Published survey.
The following points are worth noting for Custom Variables:
An example of a Custom Variable would be the creating of a variable that provided the “top 3”, “bottom 3”, and the middle. So if you have a question, Q1, with a scale from 1 through 10, you might want to recode the question into the “bottom 3”, “top 3”, and middle 4. You could do this by defining the following criteria “Q1 <= 3”, “Q3 = 7”, and “Q3 3 AND Q3 < 7” respectfully.
Another example would be where there is a question, Q1, that is an open-ended AGE question and you want to define a new question that breaks this data out into the following intervals: those < 18, between 18 and 35, between 36 and 65, 65. A variable could be defined that would define each of these separate intervals or scale values. Each scale value would be assigned a different criteria “Q1 < 18”, “Q1 = 18 AND Q1 <= 35”, “Q1 35 AND Q1 <=65”, and “Q1 65”.
To a user editing and running queries in the DataManager, Multi-Select variables look and feel like “Check All that Apply” variables.
NOTE: The Name for the Variables follow the same convention as the standard variables. They must start with a letter, and may contain letters, numbers, underscores (_) and hyphens (-). The name must be between 2-30 characters in length.
To a user editing and running queries in the DataManager, Single-Select Custom variables look and feel like “Select One” variables.
NOTE: The Name for the Variables follow the same convention as the standard variables. They must start with a letter, and may contain letters, numbers, underscores (_) and hyphens (-). The name must be between 2-30 characters in length.
NOTE: You cannot delete a scale item until you have 2 or more scale items added. Once you do, the Delete link will appear next to every scale item.
Creating a Calculated Custom Variable is similar to creating a Calculation in the DatStat Designer Client. However a major difference is that Calculated Custom Variables are written using Transact-SQL versus JScript.NET for survey calculations.
NOTE: The Name for the Variables follow the same convention as the standard variables. They must start with a letter, and may contain letters, numbers, underscores (_) and hyphens (-). The name must be between 2-30 characters in length.
Use the Edit or Delete links to modify any Custom Variable you have created.