IdSurvey lets you create a virtually unlimited number of fields for your contacts. Some fields, called system fields, are already available and are used by specific features. For example, the “mobile” field is required for SMS campaigns, while the “email” field is required for Email Sender campaigns.
To ensure IdSurvey recognizes a system field, use the exact label shown in the “Label” column of the table below. The label may vary depending on the browser language.
Notes
- To populate a system field automatically through a parameter in the survey link sent to a respondent, it is necessary to use the name shown in the “DB field name” column. For example, to populate the field labeled “Language”, use “lang” in the link.
System fields list #
| DB field name | Label | Format | Notes |
| Identification | External_id | 255 characters | To use as default primary key |
| Name | Name | 255 characters | If populated it is displayed in the CATI interface If populated it is displayed in the CAPI interface If populated it is displayed in the admin contacts list |
| Surname | Surname | 255 characters | If populated it is displayed in the CATI interface If populated it is displayed in the CAPI interface If populated it is displayed in the admin contacts list |
| Username | Username | 255 characters | Used for CAWI interviews authenticated via login |
| Password | Password | 50 characters | Used for CAWI interviews authenticated via login |
| 255 characters | Used for email sender | ||
| PhoneNumber | PhoneNumber | 255 characters | Used as phone number for CATI If populated it is displayed in the admin contacts list |
| OtherPhoneNumber | OtherPhone | 50 characters | Used as phone number for CATI |
| Mobile | Mobile | 50 characters | Used as phone number for CATI Used for SMS Sender |
| NewPhone | NewPhone | 255 characters | Used as phone number for CATI |
| Company | Company | 255 characters | If populated it is displayed in the CATI interface If populated it is displayed in the admin contacts list |
| Sample | Sample | 50 characters | Necessary for the backup Sample feature |
| Family | Family | 50 characters | Necessary for the backup Sample feature |
| CapiOperator | CAPIinterviewer | 255 characters | Default field used for the distributions of contacts to CAPI interviewers |
| UTC | UTC | Numerical decimal 53 characters | Reserved for calculating the time zone of the contact compared to the server time zone |
| lang | Language | 255 characters | Used for multilingual surveys. It stores the ISO code of the contact language, |
| priority | Priority | Integer | Used for CATI surveys. It allows you to change the priority of the contact extraction over others. A lower value corresponds to a higher priority. |