In this table all the mails for all surveys that are sent via the NIPO FMS are stored.
|
|
Fieldname
|
Description
|
Type
|
Length
|
NOT NULL
|
|
Anonymous
|
Mail is sent anonymously
|
int
|
|
|
|
EMNumber
|
Email Identifier
|
|
|
NOT NULL
|
|
FamilyMemberNumber
|
Unused
|
int
|
|
|
|
ID
|
Web respondent identifier
(matches ID in sample table). For each invitation sent to the same respondent a new ID is generated, making the previous ID invalid. Invitations resend the previous ID.
|
varchar
|
35
|
NOT NULL
|
|
InterviewNumber
|
InterviewNumber as is used in the sample table and in position 1L8 of the U-file (data file)
|
int
|
|
|
|
Language
|
Language used when sending mail
|
varchar
|
|
|
|
MediaTarget
|
Social Media Target platform (currently not used)
|
tinyint
|
|
|
|
PanelMemberID
|
Unused
|
int
|
|
|
|
Priority
|
Switched mails will get higher priority in sending than bulk-mails
|
tinyint
|
|
|
|
RemindCount
|
Number of reminders sent
|
int
|
|
|
|
RemindDate
|
Date to send the first reminder
|
int
|
|
|
|
RemindInterval
|
Interval (in days) to send reminders
|
int
|
|
|
|
RemindMax
|
Maximum number of reminders to send
|
int
|
|
|
|
ScheduledDate
|
Scheduled send date for invitation
|
datetime
|
|
|
|
SentErrorCount
|
Number of times there was an error when sending the Email
|
int
|
|
|
|
SurveyName
|
Name of associated survey
|
varchar
|
7
|
|
|
TestMode
|
Whether sent in test mode (interview will not store result data).
|
int
|
|
|
|
TextNr
|
Last used text number. Matches TextNr in EmailContents
|
int
|
|
|
|
WaveInterval
|
Time in minutes between waves
|
int
|
|
|
|
WaveWaitIntervals
|
|
int
|
|
|
|
|
|
|
|
|
