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.
|
Fieldname
|
Description
|
Type
|
Length
|
NOT NULL
|
|
ActiveCATI
|
Enable / disable NIPO CATI access for interviewer
|
tinyint
|
|
|
|
AuthenticationKey 2
|
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
|
|
|
|
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
|
|
|
|
|
|
|
|