NIPO Fieldwork System Version 1.14

Previous Topic

Next Topic

Interviewer

In the Interviewer table the interviewer IDs, names and address data of the interviewers is stored.

This section only lists the fields that are or may be used by the NIPO CATI / Web Master and the NIPO FMS. All other fields are optional and only serve to store information about the interviewer. They may be removed if considered unfit for your company.

Interviewer table

  Fieldname Description Type Length NOT NULL

 

ActiveCATI

Enable / disable NIPO CATI access for interviewer

tinyint

 

 

 

AuthenticationKey2

Authentication key for remote interviewers. May also be defined in StationsKeys table.

varchar

255

 

 

Authentication

Station

Station for authentication. May also be defined in StationsKeys table

varchar

255

 

 

Authentication

Status

Authentication Status. May also be defined in StationsKeys table

tinyint

 

 

 

FirstName

Interviewer first name

nvarchar

100

 

 

GroupID

Interviewer group ID. Groups may be used to assign sample records to interviewers belonging to a certain group, for example for interviewers that speak a certain language. Matches group ID in sample table

varchar

 

 

Key

InterviewerNumber

Interviewer identification number. Value 0 is used by the dialer

int

 

NOT NULL

 

LastLoginDateTime

Date and time of last login of the interviewer

date

time

 

 

 

LastName

Interviewer last name

nvarchar

50

 

 

OdinAllVersions

Contains all NIPO ODIN engine versions a particular interviewer ever connected with

varchar/

text

200

 

 

OdinClientVersion

Contains the NIPO ODIN engine version a particular interviewer last connected with

varchar

8

 

 

Prefix

Prefix to last name

nvarchar

100

 

 

RemoteTelnr

Number to be dialed by the dialer in case of remote interviewers

varchar

 

 

 

StartingDate

StartingDate

date

time

 

 

 

WatchSurvey

WatchSurvey

varchar

100

 

 

 

 

 

 

 

See Also