|
|
Fieldname
|
Description
|
Type
|
Length
|
NOT NULL
|
Used by
|
|
Anonymous
|
Specifies whether or not web sample records that are imported should be anonymous.
|
Bit
|
|
|
CAWI
|
|
BiDi
|
Display questionnaire for CAWI in bi-directional language (Hebrew, Arabic).
|
bit
|
|
|
CAWI
|
|
CallingPartyId
|
The contents of this field will be sent to the dialer (if any) for each record.when dialing a number.
|
Varchar
|
|
|
CATI using Dialer
|
|
CloseTime
or
EndDate
|
Used for panel license
|
Date
time
|
|
|
Panel
|
|
Description
|
Description
|
nvar
char
|
255
|
|
CATI
CAWI
CASI
|
|
DialerParam
|
The contents of this field will be sent to the dialer when starting a survey.
|
Varchar
|
|
|
CATI using Dialer
|
|
Diary
|
Used for panel license
|
tinyint
|
|
|
Panel
|
|
EndDateCATI
|
|
|
|
|
|
|
EndDateOriginal
|
|
|
|
|
|
|
EstimatedFailure
Duration
|
Estimated time in minutes per not-successful contact
|
Int
|
|
|
CATI
|
|
EstimatedInterview
Duration
|
Estimated time in minutes per complete
|
Int
|
|
|
CATI
|
|
EstimatedSuccessRate
|
Estimate success rate (=percentage)
|
Int
|
|
|
CATI
|
|
FromAddress
|
Address to be used as ‘From Address’ when Emails are sent using the WIS part of the NIPO FMS.
|
Varchar
|
100
|
|
CAWI
|
|
FromName
|
Name to be used as ‘From Name’ when Emails are sent using the WIS part of the FMS.
|
Nvar
char
|
50
|
|
CAWI
|
|
HideClear
|
Hide the Clear button in web surveys.
|
bit
|
|
|
CAWI
|
|
HideCopyrightNotice
|
Hide the text Powered by NIPO Software from Web Client
|
bit
|
|
|
CAWI
|
|
Interval
|
Interviewing interval
(for diary surveys in CASI)
|
varchar
|
8
|
|
CASI
|
|
Language
|
Default language to be used for survey. Note that system messages are configured via the Translations table
|
varchar
|
50
|
|
CAWI
|
|
LastUsedTextNr
|
References text used in mailing for this survey (see TextNumber in EmailContents table).
|
Integer
|
|
|
CAWI
|
|
Link
|
URL of the NIPO Web Server.
|
varchar
|
100
|
|
CAWI
|
|
NumberOfInterviews
or
Target
|
Target number of successful interviews required.
|
integer
|
|
|
CATI
CAWI
CASI
|
|
PaymentVersion
|
Payment characteristics for survey. The NIPO CATI / Web Master may be configured to store this field’s value in the Interviewer log, so that it can be used for accounting
|
small
int
|
|
|
CATI
|
|
QueueID
|
|
varchar
|
|
|
CATI
|
|
ReplyAddress
|
Address to be used as ‘Reply Address’ when invitation Emails are sent.
|
Varchar
|
100
|
|
CAWI
|
|
ResponseCodesNo
Reminders
|
Specifies the response codes that should not receive reminders.
|
Varchar
|
50
|
|
CAWI
|
|
ShowClose
|
Show a Close button on the introduction screen.
|
bit
|
|
|
CAWI
|
|
StartDate
or:
StartTime
|
Used for panel license
|
Date
time
|
|
|
Panel
|
|
StartDateCATI
|
Used for panel license
|
date
time
|
|
|
Panel
|
|
StartDateOriginal
|
Used for panel license
|
date
time
|
|
|
Panel
|
|
StartTime
or:
StartDate
|
Start date and time for survey.
|
Date
time
|
|
|
Panel
|
|
Status
|
Survey status.
Where:
0= Inactive
(Survey may not be started by CATI master)
1= Active
(Survey may be started by CATI master)
2= Running
(Survey has been started by CATI master)
3= Pause
(Survey is about to be ‘reloaded’ by CATI master)
|
tinyint
|
|
|
CATI
CAWI
CASI
|
|
SuccessfulCount
|
Number of successful interviews for currently active sample records.
|
integer
|
|
|
CATI
CAWI
CASI
|
|
SuccessfulIncrement
|
Number of successful interviews before running ‘Extract data’
(reduce number of sample records)
|
integer
|
|
|
CATI
CAWI
CASI
|
|
SurveyDialerParam
|
Parameters to start to the dialer when starting this survey. For dialer surveys only.
|
String
|
|
|
CATI
|
|
SurveyID
|
Identifier when sending mails in anonymous survey.
Note that when a survey is sent as anonymous, all respondents receive the same SurveyID. The ID in the Sample table and the EmailManagement table will be empty.
|
varchar
|
10
|
|
CAWI
|
|
SurveyName
|
Survey name
|
varchar
|
7
|
NOT NULL
|
CATI
CAWI
CASI
|
|
SurveyVersion
|
Survey version
|
varchar
|
1
|
|
CAWI
|
|
Suspendable
|
Specifies if a Suspend button should be shown in the Web Client
(I.e. whether or not survey may be suspended!).
|
bit
|
|
|
CAWI
|
|
SuspendTime
|
Integer field determining the 'time-to-suspend' an inactive client in minutes
(When a respondent does not answer any question the client will be suspended in the set time. When the respondent tries to continue a new client will be started)
|
integer
|
|
|
CAWI
|
|
SuspendTimeAnonymous
|
Integer field determining the 'time-to-suspend' for anonymous surveys in minutes
|
integer
|
|
|
CAWI
|
|
SuspendTimeFirst
Screen
|
Integer field determining the 'time-to-suspend' when respondent is still on the first screen in minutes
|
integer
|
|
|
CAWI
|
|
Switched
|
Indication for NIPO FMS that a NIPO CATI Client entered a responsecode with SWITCH option.
The NIPO FMS will send the Email and set the switch back to zero.
|
integer
|
|
|
CAWI
|
|
SwitchedRemind
Interval
|
Remind interval in case of switched respondent
|
integer
|
|
|
CAWI
|
|
SwitchedRemindMax
|
Maximum number of reminders in case of switched respondent
|
integer
|
|
|
CAWI
|
|
SwitchedTextnr
|
Mailtext number to be used when sending Switch-Email.
|
integer
|
|
|
CAWI
|
|
Target
or
NumberOfInterviews
|
Target / maximum number of successful interviews required
|
integer
|
|
|
CATI
CAWI
CASI
|
|
TargetPlanningCATI
|
Target used for CATI fieldwork planning
|
Integer
|
|
|
CATI
|
|
|
|
|
|
|
|
