Database Reference
In-Depth Information
of the food and over-
all dining experience.
Survey
Question La-
bel Name
What the survey respondent sees on the form. That is, the
question that appears.
How was the atmo-
sphere?
Char
255
This question lets the
respondent rate the
quality of the decorat-
ing and warmness of
the room.
Survey
Question De-
scription
An explanation or background on the question, which is not
displayed on the survey form.
Char
255
Male
Certain questions have a fixed response such as the Gender
question for “Male” or “Female” or the “From 1 to 5, how
was your meal?” question. This field stores all of the possible
fixed responses.
Possible An-
swer Value
Female
Char
50
3
Certain questions have a fixed response such as the Gender
question for “Male” or “Female” or the “From 1 to 5, how
was your meal?” question. This field stores the meaning for
each of the Possible Answer Values. This field is not dis-
played on the survey form.
Possible An-
swer De-
scription
1 means Poor
Char
100
3 means Average
Survey
Question
Number
1
A required number assigned to each question. This number
is unique within a survey.
Num
3
2
Survey
Question Sin-
gular Re-
sponse Indic-
ator
Some questions allow for more than one response. This in-
dicator when set to “Y” for “Yes” captures that only one re-
sponse is expected for this particular question. This indicator
when set to “N” for “No” captures that more than one re-
sponse can be chosen for this particular question.
Y
Boolean
N
