Database Reference
In-Depth Information
Is an
Organization DUNS Number
needed to retrieve a single instance of
Organization First Survey
Date
?
✓
Is a
Survey Category Code
needed to retrieve a single instance of
Survey Category Name
?
✓
Is a
Survey Section Name
needed to retrieve a single instance of
Survey Section Description
?
✓
Is a
Survey Question Number
needed to retrieve a single instance of
Survey Question Label Name
?
✓
Is a
Survey Question Number
needed to retrieve a single instance of
Survey Question Description
?
✓
Is a
Survey Question Number
needed to retrieve a single instance of
Possible Answer Value
?
✓
Is a
Survey Question Number
needed to retrieve a single instance of
Possible Answer Description
?
✓
Is a
Survey Question Number
needed to retrieve a single instance of
Survey Question Singular Re-
sponse Indicator
?
✓
Is a
Survey Respondent ID
needed to retrieve a single instance of
Survey Respondent First Name
?
✓
Is a
Survey Respondent ID
needed to retrieve a single instance of
Survey Respondent Last Name
?
✓
Are a
Survey Code
,
Survey Respondent ID
,
Completed Survey Date
, and
Survey Question Num-
ber
needed to retrieve a single instance of
Completed Survey Free Form Response Text
?
✓
Are a
Survey Code
,
Survey Respondent ID
,
Completed Survey Date
, and
Survey Question Num-
ber
needed to retrieve a single instance of
Completed Survey Fixed Response Answer
?
✓
For the question on
Survey Section
, we learn that more is needed than just the
Survey Sec-
tion Name
to retrieve a single instance of
Survey Section Description
. After additional
discussion with the business, we learn that the
Survey Code
is needed as well in the
Sur-
vey Section
primary key.