NIPO Fieldwork System Version 1.14

Previous Topic

Next Topic

ContactLog

The ContactLog stores a record each contact attempt, across all surveys. This table may grow large over time and may require periodic pruning.

ContactLog table

  Fieldname Description Type Length NOT NULL

 

AppointmentTime

Appointment time (if one was made)

datetime

 

 

 

 

AreaCodeRespondent

Area code (the first 6 digits of telephone number). Only includes numerical characters.

varchar

6

 

 

Channel

Channel:

1 = CATI

2 = CAWI (Web)

3 = CAPI

4 = CASI (Panel)

int

 

 

Key

ContactDate

Date and time of contact attempt

datetime

 

NOT NULL

 

ContactNumber

Contact number

int

2

 

 

EditTime

Edit open time in seconds. This is the time it took the interviewer to edit the open ended answers at the end of the interview (also included in total time).

int

 

 

 

InterviewerNumber

Interviewer number

int

8

 

Key

InterviewNumber

Interview number

int

8

NOT NULL

 

IntroductionTime

Introduction time in seconds

Time between the moment the NIPO CATI / Web Master sends a sample record to the interviewer workstation and the interviewer pressing Start or confirming a non-response on the introduction screen.

(Also included in the total time)

int

 

 

 

NumberOfScreens

Number of screens shown to interviewer. Note that when the interviewer goes back in the questionnaire and follows another routing, the number of screen will be reset.

int

 

 

 

ResponseStatus

Response code (space means no sample file available). See Overview Of Response Codes for details.

int

2

 

 

StationID

Workstation ID for the workstation where the contact attempt was made (IDs are set using the NIPO CATI / Web Manager).

varchar

100

NOT NULL

Key

SurveyName

Name of survey or in case of an omnibus survey, the name of the questionnaire

varchar

7

NOT NULL

 

TelephoneTime

Telephone time in seconds. . This is either:
The accumulated stopwatch time. The stopwatch is toggled by the interviewer by pressing F10 during the interview. The stopwatch stops automatically at the end of the interview (before editing open ended answers). This feature must be enabled in the survey configuration.
The actual telephone contact (call) time with the respondent (only available if using a dialer, as reported by the dialer

int

 

 

 

TotalSurveyName

Used for omnibus surveys. Name of the omnibus survey that contains the questionnaire.

varchar

7

 

 

TotalTime

Total time in seconds.

The total time between the moment the NIPO CATI / Web Master sends a sample record to the interviewer workstation until after finally receiving the sample record back again from the workstation. This includes interview time, introduction time and edit time,

but excludes waiting time.

int

 

 

 

WaitingTime

Waiting time, in seconds. Time spent by the NIPO CATI / Web Master to search a new sample record and the dialer in power / predictive mode (if any) to make call attempts (waiting time may be significantly higher).

int

 

 

 

SampleWaitTime

Sample Wait Time. Time spent by the NIPO CATI / Web Master to wait for a sample record to become available for an interviewer. Includes looking up a sample record if not using a dialer, or waiting for a connected respondent when using a dialer.

 

 

 

 

 

 

 

 

 

Note:
Omnibus surveys store contact log records in this table for each sub-survey. However only the C-file of the omnibus survey stores only one row for the accumulated interview time and number of screens for all sub-surveys.

See Also