By default for each survey in the NIPO Fieldwork System a separate Sample table is used. The default name for the Sample table is SampleName, where Name is the survey name (for instance: the Sample table for survey A1234 is called SampleA1234). The Sample table can also be an ASCII file (T-file), see Telephone File (T-file) for details.
| Fieldname
|
Pos in T-file
|
Description
|
Type
|
Length
|
NOT NULL
|
AppointmentName
|
72L30
|
Name of respondent that will be called at appointment time
|
nvar
char
|
30
|
|
AppointmentTime
|
60L12
|
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)
|
Var
Char
|
4
|
|
CallIntervalEnd
|
|
Address should never be distributed after this time
(4 digits, where 2100 stands for 9 o’clock in the evening)
|
Var
Char
|
4
|
|
Channel
|
|
Channel,
where:
1= CATI
2= CAWI (Web)
3= CAPI
4= CASI (Panel)
99= Sample record sent as anonymous web interview.
|
int
|
|
|
ContactTime
|
24L12
|
Date and time of last contact (attempt).
|
Date
Time
|
|
|
DisplayField1
|
136L45
|
First address information field (for example name)
|
nvar
char
|
45
|
|
DisplayField2
|
181L35
|
Second address information field (for example address)
|
nvar
char
|
35
|
|
DisplayField3
|
216L35
|
Third address information field (for example town)
|
nvar
char
|
35
|
|
DisplayField4
|
251L35
|
Fourth address information field (for example country, zip code et cetera)
|
nvar
char
|
35
|
|
Email
|
|
Email address for CAWI records
|
var
char
|
50
|
|
ExtraData
|
286-…
|
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.
|
Var
Char
|
|
|
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
|
50
|
|
Indicator2ndNumber
|
120L1
|
Last dialed number:
1= second number
blank= only 1 number available / no contact
|
int
|
1
|
|
InitialChannel
|
|
Channel used when initially importing the sample record,
where:
1= CATI
2= CAWI (Web)
3= CAPI
4= CASI (Panel)
|
Int
|
|
|
InterviewerNumber
|
36L8
|
Interviewer number of the interviewer of the last contact attempt.
|
int
|
8
|
|
InterviewNumber
|
52L8
|
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).
|
var
char
|
|
|
NumberOfContacts1
|
20L2
|
Number of contact attempts, including not-at-home, appointments, suspended interviews, et cetera.
|
int
|
2
|
NOT NULL
|
ResponseCode3
|
18L2
|
2-digit response code. See Overview Of Response Codes for details.
|
int
|
2
|
NOT NULL
|
SecondPhoneNumber
|
103L17
|
Alternative phone number
|
Var
Char
|
17
|
|
ShowDisplayFields
|
135
|
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
|
102L1
|
0= Hide second phone number
1= Show second phone number
2= Use second phone number by default
|
int
|
1
|
|
Status4
|
|
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= laimed 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
|
22L2
44L2
46L2
48L2
50L2
|
The 5 previous response codes
|
Var
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
|
1L17
|
Telephone number for CATI records
|
Var
Char
|
17
|
|
TimeDifference
|
|
Time difference in minutes between respondent and the call center.
|
Var
Char
|
10
|
|
