What do you need help with?

System fields list

1 min read

AI Doc Summarizer AI Summary

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 nameLabelFormatNotes
IdentificationExternal_id255 charactersTo use as default primary key
NameName255 charactersIf 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
SurnameSurname255 charactersIf 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
UsernameUsername255 charactersUsed for CAWI interviews authenticated via login
PasswordPassword50 charactersUsed for CAWI interviews authenticated via login
eMailEmail255 charactersUsed for email sender
PhoneNumberPhoneNumber255 charactersUsed as phone number for CATI
If populated it is displayed in the admin contacts list
OtherPhoneNumberOtherPhone50 charactersUsed as phone number for CATI
MobileMobile50 charactersUsed as phone number for CATI
Used for SMS Sender
NewPhoneNewPhone255 charactersUsed as phone number for CATI
CompanyCompany255 charactersIf populated it is displayed in the CATI interface
If populated it is displayed in the admin contacts list
SampleSample50 charactersNecessary for the backup Sample feature
FamilyFamily50 charactersNecessary for the backup Sample feature
CapiOperatorCAPIinterviewer255 charactersDefault field used for the distributions of contacts to CAPI interviewers
UTCUTCNumerical decimal 53 charactersReserved for calculating the time zone of the contact compared to the server time zone
langLanguage255 charactersUsed for multilingual surveys. It stores the ISO code of the contact language,
priorityPriorityIntegerUsed for CATI surveys. It allows you to change the priority of the contact extraction over others. A lower value corresponds to a higher priority.
What are your feelings
Table of contents