Standard fields list

Compatibility:IdSurvey 7IdSurvey 8

IdSurvey allows you to create a virtually endless number of contact fields. But, Some basic fields – called standard fields – are always available in IdSurvey. Some standard fields are necessary for the operations of the system. For example, the fields dedicated to phone numbers are needed for the operation of CATI surveys or the email field that is needed for EmailSender campaigns.

Notes

  • Some standard fields are not linked to a specific function and are only present to ensure backward compatibility with previous versions of IdSurvey.
  • When you want to valorize the fields from the url, you must use the field name specified in the database. In all other cases, the label of the field is used – which varies depending on the browser language.

Standard fields list

DB field nameLabelFormatNotes
IdentificationIdentification255 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
AddressAddress255 characters
ZIPCodePostcode10 characters
CityCity255 characters
CityCodeCityCode50 characters
ProvinceProvince50 characters
BirthdateDateOfBirth255 characters
GenderGender50 characters
ZoneZone50 characters
ZoneNameZoneName255 characters
CompanyCompany255 charactersIf populated it is displayed in the CATI interface
If populated it is displayed in the admin contacts list
AreaArea255 characters
NumberOfEmployeesNumberOfEmployees255 characters
VATVATNumber50 characters
OccupationProfession255 characters
QualificationQualification255 characters
SampleSample50 charactersNecessary for the backup Sample feature
FamilyFamily50 charactersNecessary for the backup Sample feature
Field1Field1255 characters
Field2Field2255 characters
Field3Field3255 characters
Field4Field4255 characters
Field5Field5255 characters
Field6Field6255 characters
Field7Field7255 characters
Field8Field8255 characters
Field9Field9255 characters
Field10Field10255 characters
Field11Field11255 characters
Field12Field12255 characters
Field13Field13255 characters
Field14Field14255 characters
Field15Field15over 65000 characters
Field16Field16255 characters
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.