Survey Responses Report Data Dictionary (SPARCRequest v3.12.1)

1

SRID

System generated from SPARCRequest

protocols.id - sub_service_requests.ssr_id

Automatically generated by SPARC application

BIGINT(20)

2

User ID

Identity ID of the survey response submitter

identities.id

database

BIGINT(20)

3

User Name

User Full Name associated to NetID

identities.first_name identities.last_name

pulled from Identity Management System (such as ldap)

VARCHAR(255)

4

User Email

User email address

identities.email

pulled from Identity Management System (such as ldap)

VARCHAR(255)

5

Submitted Date

Date survey response was submitted

question_responses.created_at

system generated date stamp

DATETIME

6+

*Survey-specific questions with responses

Admin has ability to build surveys; can have variety of questions and answer types

question_responses.content

user entry

TEXT