...
Variable name | Variable name in | Meaning | Data type | Size |
---|---|---|---|---|
pseudonym | pseudonym | Encoded unique panelist ID, which is required e.g. to match result data and master data in SPSS. | int | 11 places Threshold values: -2147483648 bis |
pstatus | pstatus | Panel status. | tinyint | 4 |
pinput | pinput | Mode of entry. Describes the type of registration. It is automatically allocated by the system. The following modes of entry are
Please mind: The mode of entry should not be confused with the ways of entry stored in | tinyint | 4 |
pcredit_points | pcredit_points | The current total sum of bonus points. | decimal | 10,2 |
pstatus_date | pstatus_date | The last change in panel status. Only set during manual import. | datetime | |
deprecated: | last_poll_date | The date the panelist last participated in a survey. Gets updated when the last page of apanel survey is reached. From EFS 6.0, the new tracking function provides you with more precise information. | datetime | |
deprecated: n_poll | n_poll | The number of surveys in which the panelist has participated so far. Updated each time the final page of a panel survey is reached. From EFS 6.0, the new tracking function provides you with more precise information. | int | 11 (see |
doub_stat | doub_stat | The duplicates status:
| tinyint | 4 |
penter_date | penter_date | The date of entry into the panel. Technically this is the point in time at which the panelist's profile is created during the import process or manual entry. | datetime | |
panelist_code | panelist_code | Panelist codes make it possible to log in directly into the panel. | binary | 40 |
md_status | md_status | The panelist’s status in the master data survey.
The system variable “md_status” should not be confused with the disposition code:
| tinyint | 4 |
md_update_date | md_update_date | Date of the last update to the master data survey. | datetime | |
md_num_updates | md_num_updates | The number of times the panelist has participated in the master data survey. | mediumint | 8 |
md_invite_date | md_invite_date | The date of the invitation to the master data | datetime | |
md_num_invites | md_num_invites | The number of invitation mails sent for the master data survey. | int | 11 (see |
reg_code | reg_code | Way of entry.
| int | 11 (see |
invited_by | invited_by | If the panelist was invited to participate during a “Tell-a-friend” campaign, this field will contain the ID of the panelist who canvassed them. | Int | 11 (see |
date_last_login | date_last_login | Date of the last time the panelist logged in. | datetime | |
pci | pci | PCI value. | tinyint | 4 |
site_id | site_id | Language version. For identification of the various language versions of the website(s). | Int | 11 (see |
last_mod_date | last_mod_date | The date of the last change. | datetime | |
last_mod_user | last_mod_user | Initiator of the last change:
| tinyint | 1 |
dropout_date | dropout_date | Leaving date of a panelist. | datetime | |
mail_validation_ | mail_validation_ | Status of the double opt-in e-mail verification:
| tinyint | 1 |
mail_validation_ | mail_validation_ | E-mail verification code. | binary | 32 |
marked (not contained in the export data record) | (not contained in the export data record) | Indicates whether notes have been made on the panelist in the Panelists administration or Panelists administration → Candidates menu. | tinyint | 1 |
member_id (not contained in the export data record) | (not contained in the export data record) | An auxiliary variable for calculating the pseudonym. | int | 11 (see |
remote_addr (not contained in the export data record) | (not contained in the export data record) | The IP address used by the panelist during registration. | 11 | |
remote_host (not contained in the export data record) | (not contained in the | The domain from which the panelist entered the panel during registration. |