InterviewerFieldworkPlanning

Stores the planning of interviewers per shift and survey. Set by the supervisor using the NIPO FMS.

InterviewerFieldworkPlanning table

Fieldname	Description / Default value	Type	Length	NOT NULL
`Date`	Date	`Date` `time`		`NOT NULL`
`ShiftNumber`	Shift number	`Int`		`NOT NULL`
`InterviewerNumber`	Interviewer number	`Int`		`NOT NULL`
`SurveyName`	Survey name	`Varchar`	`7`	`NOT NULL`
`Status`	Planning status, where: 1 = interviewer assigned to survey 2 = interviewer instruction 3 = assignment removed	`Int`