NIPO Fieldwork System Version 1.14
Sub[survey]
Stores the stratification data and other sample data fields for a sub-survey in an omnibus survey. The name of the table is dependent on the name of the omnibus survey. For example, for an omnibus survey A1234 the omnibus table is called SubA1234 and contains a row for each sub-survey. The table fields below are the defaults; additional fields may have been added by NIPO FMS users.
Sub[survey] table
|
|
Fieldname
|
Description
|
Type
|
Length
|
NOT NULL
|
|
InterviewNumber
|
Interview number
(Refers to a record in the Sample table)
|
Integer
|
8
|
NOT NULL
|
|
QuestionnaireName
|
Sub-questionnaire name
|
Text
|
7
|
NOT NULL
|
|
Success
|
Sub-questionnaire status:
1=successful
other is unsuccessful
|
Integer
|
1
|
|
|
STData
|
Extra data field to store stratification fields for sub-questionnaires
|
varchar
|
12
|
|
|
|
|
|
|
|
Note:
The field STData is only created in an omnibus table by NIPO FMS when the setting STData='STData' is specified in the registry of the NIPO CATI / Web Master.
|
