AppointmentName

Name of respondent that will be called at appointment time

nvar

char

30

AppointmentTime

Time the appointment should be redistributed

date

time

CallIntervalBegin

Address should never be distributed before this time
(4 digits, where 1500 stands for 3 o’clock in the afternoon)

int

CallIntervalEnd

Address should never be distributed after this time

(4 digits, where 2100 stands for 9 o’clock in the evening)

int

Channel

Channel,

where:

1= CATI

2= CAWI (Web)

3= CAPI

4= CASI (Panel)

99= Sample record sent as anonymous web interview.

int

ContactTime

Date and time of last contact (attempt).

Date

Time

DisplayField1

First address information field (for example name)

nvar

char

45

DisplayField2

Second address information field (for example address)

nvar

char

35

DisplayField3

Third address information field (for example town)

nvar

char

35

DisplayField4

Fourth address information field (for example country, zip code et cetera)

nvar

char

35

Email

Email address for CAWI / warm handover / switch-mode records. This field is not checked for duplicates; several respondents may have the same Email address

var

char

100

ExtraData

Left for compatibility with surveys using T-files. Only available if configured in the NIPO CATI / Web Master.

var

char

215

GroupID

Use GroupId to distribute certain addresses only to certain interviewers, for instance to match the language of the respondent and the interviewer.

nvar

char

10

ID

The unique identifier, that is created for each respondent in the sample table, when sending a non-anonymous mail (blank for annymous surveys).

The ID should be unique, not only within the sample table, but also within the EmailManagemenent table. Can automatically be generated by the Fieldwork Manager.

var

char

20

Indicator2ndNumber

Last dialed number:

1= second number

blank = only 1 number available / no contact

int

InitialChannel

Channel used when initially importing the sample record,

where:

1= CATI

2= CAWI (Web)

3= CAPI

4= CASI (Panel)

Int

InterviewerNumber

Interviewer number of the interviewer of the last contact attempt.

int

8

InterviewNumber

Unique identifier within the sample and all related data files

int

8

NOT NULL

Language

Language of respondent

(for sending mail and/or multi-language questionnaires). This field is also automatically updated by the questionnaire (a.o. the *LANGUAGE script command).

nvar

char

50

NumberOfContacts

Number of contact attempts, including not-at-home, appointments, suspended interviews, et cetera.

int

2

NOT NULL

ResponseCode

2-digit response code. See Overview Of Response Codes for details.

int

2

NOT NULL

SecondPhoneNumber

Alternative phone number

nvar

char

17

ShowDisplayFields

Number of display fields to show

0= No display fields

1= Show only DisplayField1

2= Show DisplayField1 +

DisplayField2

3= Show DisplayField1 +

DisplayField2 +

DisplayField3

4= Show all display fields

int

1

ShowSecondPhoneNumber

0= Hide second phone number

1= Show second phone number

2= Use second phone number by default

int

1

Status⁴

Status, where

0= Available (CATI)

1= Available (Web)

2= Not successful / Refusal

3= Completed

4= CATI appointment

5= CATI waiting (previously WW in ResponseCode field)

6= Out, distributed for NIPO CATI and NIPO CAWI

7=Switched to NIPO CAWI (but not yet sent)

8=Claimed by NIPO FMS Client for editing

int

1

NOT NULL

SuspendImage

Suspend Image, containing all the answers and the routing of previous sessions.

Image

SystemData

The 5 previous response codes

char

10

TargetInterviewer

Interviewer number to be used when interviewer requested to follow up the interview. Only used if Same Interviewer Appointment was switched on for this survey.

Int

8

TelephoneNumber

Telephone number for CATI records

var

char

17

TimeDifference

Time difference in minutes between respondent and the call center.

int