This table contains a history of sent Emails. A record is added for each new mail sent by the NIPO FMS.
|
|
Fieldname
|
Description / Default value
|
Type
|
Length
|
NOT NULL
|
|
Anonymous
|
Mail was sent with anonymous link
|
int
|
|
|
|
EmailAddress
|
Email address
|
nvarchar
|
100
|
NOT NULL
|
|
EmailType
|
Email type, where
1= Invitation
2= Reminder
0= Other (Email without link) like thank-you messages and website invitations
|
int
|
|
|
|
Error
|
Error
|
nvarchar
|
100
|
|
|
ID
|
ID that was used when sending the mail
|
nvarchar
|
20
|
|
|
InterviewNumber
|
Interview number
|
int
|
|
NOT NULL
|
|
Language
|
Language
|
nvarchar
|
50
|
|
|
MediaTarget
|
Social Media Target platform (currently not used)
|
tinyint
|
|
|
|
ScheduledDate
|
Scheduled date
|
datetime
|
|
|
|
SentDate
|
Date sent
|
datetime
|
|
NOT NULL
|
|
SurveyName
|
Name of associated survey
|
varchar
|
7
|
NOT NULL
|
|
TestMode
|
Whether mail was sent in test mode
|
bit
|
|
NOT NULL
|
|
TextNr
|
Email text sent, matches TextNr in EmailHistory table
|
int
|
|
|
|
|
|
|
|
|
