Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Internal variable name

External variable name

Description

Meaning

lfdn

lfdn

number

Every participant to the questionnaire will be assigned a consecutive number.

external_lfdn

external_lfdn

external lfdn

If external survey start is used, external_lfdn is used in the secondary project to store the participants’ ldfn from the primary project. You can download a dedicated documentation for external survey start in customer center.

If several surveys are linked by external survey start, the variable external_lfdn will contain the lfdn of the primary project in all fol- lowing surveys.

tester

tester

tester

Indicates whether the participant in question is a tester (not for anonymous projects), “1” being for a tester and “0” for a normal participant.

status

discode

disposition code

The participants’ disposition code. Please mind that the disposition code is only part of the export file if the exporting user has read rights for show_dispcode.

last_page

lastpage

last page

Indicates the last page sent by the server. I.e. if participants dropped out of a survey, this is usually the last page presented to them.

quality

quality

quality

The respondents’ quality index.

time_to_complete_survey

duration

time to complete survey

The duration of survey completion (in seconds), i.e. the time elapsed between the respondent’s first and last accessing of the questionnaire.

The duration is computed as follows: A record is made of when the respondent first and last accessed the survey. These values can be found in the export record as the variables datetime (SPSS label: datetime of survey start) and lastaccs (SPSS label: date of last access). The difference of these two values is the time the participant took to complete the survey (duration = lastaccs - datetime).

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

p_000n

URL parameter

c_000n

c_000n

User-defined variables

v_000n

v_000n

Project variables. The project variables are sequentially numbered for each project, beginning with v_1.

md_000n

(Only in EFS Panel installations)

md_000n

Master data variables.

remote_host

ext_host

external host

Indicates the domain of the computer via which the participant is connected to the Internet, if it has a domain.

remote_addr

ip_addr

remote address

Indicates the IP address of the computer via which the participant is connected to the Internet.

user_agent

browser

browser-id

Indicates the name of the browser in the form in which it was transferred to the EFS server. Examples can be found at http:// de.wikipedia.org/wiki/User_Agent.

When filtering is done via browser types, it is advisable to use the “matches regex” condition, which is also new.

http_referer

referer

http-referer

Indicates the Internet page from which the survey was invoked.

device_type

(From EFS 10.0 in “Responsive Layout” projects)

device_type

device type

Contains the result of the check for device type, which can optionally be performed at the beginning of the survey:

Activated

  • 0 = Desktop

  • 1 = mobile

Not activated: 0

participant_browser

(For EFS 10.7 and later versions)

participant_browser

participant browser

States the browser used by the participant, e. g. Internet Explorer

participant_browser_version

(For EFS 10.7 and later versions)

participant_browser_version

participant browser version

States the participant‘s browser version, e. g. 9.0

participant_os

(For EFS 10.7 and later versions)

participant_os

participant operating system

states the participant‘s computer‘s operating system, e. g. Windows.

participant_device

(For EFS 10.7 and later versions)

participant_device

participant device

contains result of the device type check (optional, may be performed at the start of the survey), e. g. smartphone. Refer directly to the software‘s user interface for a list of all identifiable devices.

participant_brand

(For EFS 10.7 and later versions)

participant_brand

participant brand

states brand of device used, e. g. Apple.

participant_model

(For EFS 10.7 and later versions)

participant_model

participant model

states model of device used, e. g. iPhone 6.

participant_isbot

(For EFS 10.7 and later versions)

participant_isbot

participant is (ro)bot

states whether participant is a robot or crawler. Regular participants are assigned the value 0.

participant_continent

(For EFS 10.7 and later versions)

participant_continent

participant continent

states the participant‘s current location (continent), e. g. Europe

participant_country

(For EFS 10.7 and later versions)

participant_country

participant country

states the participant‘s current location (country, e. g. Great Britain

participant_region

(For EFS 10.7 and later versions)

participant_region

participant region

states the participant‘s current location (region), e. g. Lancashire

participant_city

(For EFS 10.7 and later versions)

participant_city

participant city

states the participant‘s current location (city), e. g. Lancaster

quota

quota

quota

Contains the ID of the allocated quota (i.e. the quota selected via allocation mode).

quota_assignment

quota_assignment

quota_assignment

Contains the IDs of all quotas in which the respective participant has been counted.

page_history

page_history

page history

Indicates the sequence of invoked pages. The page ID (pgid) displayed in the questionnaire editor beside the individual pages is used.

The current state of questionnaire processing is minutely recorded in the page history, i.e. the variable page_history will show you the movements of the participants within the questionnaire up to the last viewed page.

Please note: If a real Back button is activated in the form, and a participant leaves a page using this Back button, this page will be removed from page history.

hflip

hflip

hflip

Variable for horizontal flipping:

  • 0 = not flipped

  • 1 = flipped

vflip

vflip

vflip

Variable for vertical flipping:

  • 0 = not flipped

  • 1 = flipped

javascript

javascript

jscript

Contains the result of the check for JavaScript, which can optionally be performed at the beginning of the survey:

  • 0 = JavaScript switched off

  • Other = Version number (e.g. jscript = “10” for JavaScript 1.0, jscript = “15” for JavaScript 1.5)

flash

flash

flash

Contains the result of the check for the Adobe Flash plugin, which can optionally be performed at the beginning of the survey and is required for the Flash question types:

  • 0 = Flash plugin not availablef

  • Other=Versionnumber(e.g.flash=“800”forFlashplugin8.0, flash = “900” for Flash plugin 9.0)

seesion_id

session_id

session id

Indicates the session ID the participant received during the survey.

language

language

language

The language in which the respondent has seen the questionnaire.

The numbers correspond to the language ID (identification number) of the languages used in the project.

With the wildcard #language# you can display the language ID in the questionnaire or in templates. This is particularly important for language-dependent layouts and special programming.

datacleaning

cleaned

datacleaning

Indicates if the individual record has been cleaned:

  • 0= uncleaned data records and records of incomplete interviews which are excluded from the cleaning process

  • 1 = cleaned

  • 2 = checked but did not require cleaning

dt_begin

ats

absolute timestamp

Indicates the time in seconds elapsed since 01/01/1970 until the request of the first page of the questionnaire).

dt_begin

datetime

datetime of survey start

Date and time of survey start, i.e. the invoking of the first page of the questionnaire.

date_of_last_access

date_of_last_access

date of last access

Date and time of the last access to the survey.

date_of_first_mail

date_of_first_mail

date of first mail

Date and time of the first invitation mail sent to the participant. The variable is used for all project types which include invitation pro- cesses, i.e. personalized projects, panel surveys and master data surveys. In anonymous projects , it is not filled.

Please mind: date_of_first_access is updated upon resumption.

sid

sample_id

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

rts_000n

For pgid > 99999: ts_000n

relative timestamp for page xxxx

Time variables of standard pages and mixed-external pages. These indicate the time in seconds elapsed since the ats until submission 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

rnd_pg_PGID

random page selection order

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

rnd_pg_PGID_x

random rotation selection order

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 sub-pages 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

survey ticket id

tic variable used in external survey start. The tic variable is always 32 characters long. This cannot be configured.

s_000n

(From EFS 10.5)

s_000n

s_000n

Scoring variables.

...