NIPO Fieldwork System Version 1.14
InterviewerFieldworkCancellation
Stores fieldwork cancelation dates as set in the NIPO FMS. If a new date was set, the new date is stored as well.
InterviewerFieldworkCancellation table
|
|
Fieldname
|
Description / Default value
|
Type
|
Length
|
NOT NULL
|
|
Date
|
Date of cancelation
|
Datetime
|
|
NOT NULL
|
|
FromDate
|
Date that was canceled
|
Datetime
|
|
|
|
FromShiftNumber
|
Shift that was canceled
|
Int
|
|
|
|
InterviewerNumber
|
Interviewer number
|
Int
|
|
NOT NULL
|
|
Type
|
Type of cancelation
|
Tinyint
|
|
NOT NULL
|
|
ToDate
|
ToDate
|
Datetime
|
|
|
|
ToShiftNumber
|
ToShift
|
Int
|
|
|
|
|
|
|
|
|
|
