...
Variable | Meaning |
|---|---|
lfdn | Unique participation ID |
external_lfdn | Unique participation ID of an external survey (External Survey Start) |
tester | Participant = tester (yes/no) |
status | Dispositioncode (status of the participation e.g., invited) |
lastpage | Page ID of the last page shown to the participant |
quality | quality of the results of a survey |
duration | Duration (time in seconds to finish the survey. If a respondent resumes the questionnaire after a break (disposition codes 23, 32), the duration is = “-1” because a meaningful calculation is not possible.) |
p_000n | URL parameter |
c_000n | User-defined variables |
v_000n | Project variables. The project variables are sequentially numbered for each project, beginning with v_1. |
md_000n | Master data variables (only in EFS Panel installations) |
ex_host | Host name based on the IP of the proxy (if available) via which the participant accesses the survey |
ip_addr | IP of the proxy (if available) via which the participant accesses the survey |
browser | Browser info (name, version etc.) of the participant |
referer | If available, the address of the page on which the participant clicked the link to the currently accessed page. This value is set by the participant's browser |
device_type | Type of the user’s devices (0 - desktop / 1 - mobile) If the option “Check whether the respondents have JavaScript activated, whether the Adobe Flash Player plugin is available and which device they are using?” of the project properties is not activated, 0 is the default value. |
quota | Quota ID of the participant (selected by “To which quota should the participant be allocated” |
quota_assignment | All quota ID’s of the participant |
page_history | List of page ID’s in the order of the pages called up by the participant |
hflip | Variable for the horizontal flip (horizontal mirroring of the answer options):
When a participant starts a survey for the first time, hflip is always written – regardless of whether flips are activated for the survey or not. However, the participant will only see those questions flipped for which the flipping function has been explicitly activated. Consequently, all questions, for which this function was not activated, will be displayed as set in the corresponding question regardless of the random hflip value. Information on whether the flipping function has been activated for a question cannot be found in the export of the result data. To get this information, you have to manually check in the respective question, if the flipping function has been activated. |
vflip | Variable for the vertical flip (vertical mirroring of the answer options):
When a participant starts a survey for the first time, vflip is always written – regardless of whether flips are activated for the survey or not. However, the participant will only see those questions flipped for which the flipping function has been explicitly activated. Consequently, all questions, for which this function was not activated, will be displayed as set in the corresponding question regardless of the random vflip value. Information on whether the flipping function has been activated for a question cannot be found in the export of the result data. To get this information, you have to manually check in the respective question, if the flipping function has been activated. |
output_mode | Which layout is used? HTML layout or mobile layout? |
javascript | Version of the browser’s javascript (if configured) |
flash | Version of the Flash Payer plugin (if configured) |
session_id | Session ID of the participation |
language | Participant’s language ID |
cleaned | Participation was modified by data cleaning |
ats | Time of survey start (absolute time stamp) |
datetime | Time of the survey start |
date_of_last_access | Time of the last access of the participant to the survey |
date_of_first_mail | Time of the first mail sent to participant |
RTS (+ page ID) | Relative time stamp for each page + page ID.  Please note, that the order of the variables "RTS (+page ID)" in the export does not necessarily correspond to the order in which the respective participant has displayed the pages. |
sid | Only in panel and master data surveys : ID of the sample that the panelists belong in. For the SPSS export, the codes are labeled with the sample titles. |
dt_send_pag_000n | Time variables of standard pages and mixed-external pages. These indicate the time in seconds elapsed since the ats until sub- mission of the respective page. If the PGID (page ID = installation-specific ID of a questionnaire page or a dynamic element) is bigger than 99.999, the name of the variable is changed to ts_xxx, to prevent problems caused by the length of the variable name when exporting for SPSS. |
rnd_pg_PGID | Random selection. For each random selection block in the questionnaire, a variable rndPGID is created. PGID is the ID of the random selection element. In this variable, the PGIDs of the selected pages are stored, separated by commas. |
rnd_pg_PGID_x | Random order. For each random order block in the questionnaire, variables rnd_pg_PGID_NR are created. PGID is the ID of the random order element, NR is the number of randomized subpages. Each of these variables contains the PGID of that subpage which has been placed on the respective position in the current cycle. Example: The PGID of the random order element is 123, the subpages have PGID 124, 125 and 126. In the questionnaire, they are displayed to a participant in the following order: 126, 124, 125. Then, you will find the following data in the export file: r123_1 = 126, r123_2 = 124, r123_3 = 125 |
tic | tic variable used in external survey start. The tic variable is always 32 characters long. This cannot be configured. |
s_000n | Scoring variables |
...