NIPO ODIN Version 5.17

Previous Topic

Next Topic

Omnibus or SubSample Table (Separate Table for Each Survey)

Separate table for each omnibus survey, only in combination with Sample table. For use within the NIPO Fieldwork System only.

The default name for the omnibus or sub-sample table is SubName, where Name is the survey name (for instance: the omnibus table for survey A1234 is called SubA1234).

In this table the NIPO Fieldwork System stores the stratification data for each sub-survey in an omnibus.

Field names in the Omnibus Table

Fieldname Description Type Minimum length NOT NULL

InterviewNumber Primary Key

Interview number

(Refers to a record in the Sample table)

Integer

8

NOT NULL

QuestionnaireName Primary Key

Sub-questionnaire name

Text

7

 

Success

Sub-questionnaire status:

1=successful

other is unsuccessful

Integer

1

 

STData

Extra data field to store stratification fields for sub-questionnaires. Only available if configured at the NIPO CATI / Web Master.

varchar

12

 

See Also