SPARCRequest Wiki

Survey Responses Report Data Dictionary (SPARCRequest v3.12.1)

Owned by Evan Martinez

Last updated: Jan 18, 2024 by Brigette White

1 min read

Data Dictionary

No.	Column Name	Description	Database Name	Source	Type

No.	Column Name	Description	Database Name	Source	Type
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

Sample Report

<style></style><div class="cells-worksheet" data-sheet-number="0" data-sheet-name="Data"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse:collapse;table-layout:fixed;width:1105pt"> <colgroup> <col style="mso-width-source:userset;width:164px"></col> <col style="mso-width-source:userset;width:159px"></col> <col style="mso-width-source:userset;width:199px"></col> <col style="mso-width-source:userset;width:193px"></col> <col style="mso-width-source:userset;width:149px"></col> <col class="x17" style="mso-width-source:userset;background:none;width:275px"></col> <col class="x17" style="mso-width-source:userset;background:none;width:335px"></col> </colgroup> <tbody> <tr style="mso-height-source:userset;height:14pt" id="r0"> <td style="height:14pt;width:123pt">Report Generated:</td> <td style="width:119.25pt">2023-08-08</td> <td style="width:149.25pt"></td> <td style="width:144.75pt"></td> <td style="width:111.75pt"></td> <td class="x17" style="width:206.25pt"></td> <td class="x17" style="width:251.25pt"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r1"> <td style="height:14pt"># of Records:</td> <td style="text-align:right">647</td> <td></td> <td></td> <td></td> <td class="x17"></td> <td class="x17"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r2"> <td style="height:14pt"></td> <td></td> <td></td> <td></td> <td></td> <td class="x17"></td> <td class="x17"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r3"> <td style="height:14pt">Report Parameters</td> <td></td> <td></td> <td></td> <td></td> <td class="x17"></td> <td class="x17"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r4"> <td style="height:14pt">Type:</td> <td>Survey Responses</td> <td></td> <td></td> <td></td> <td class="x17"></td> <td class="x17"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r5"> <td style="height:14pt">Created At From:</td> <td>01/01/2023</td> <td></td> <td></td> <td></td> <td class="x17"></td> <td class="x17"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r6"> <td style="height:14pt">Created At To:</td> <td>08/08/2023</td> <td></td> <td></td> <td></td> <td class="x17"></td> <td class="x17"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r7"> <td style="height:14pt">System Survey:</td> <td colspan="3" style="mso-ignore:colspan">SCTR Customer Satisfaction Survey - Version 2 (Active)</td> <td></td> <td class="x17"></td> <td class="x17"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r8"> <td style="height:14pt">Show Pending:</td> <td>true</td> <td></td> <td></td> <td></td> <td class="x17"></td> <td class="x17"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r9"> <td style="height:14pt"></td> <td></td> <td></td> <td></td> <td></td> <td class="x17"></td> <td class="x17"></td> </tr> <tr style="mso-height-source:userset;height:42pt" id="r10"> <td style="height:42pt">SRID</td> <td>User ID</td> <td>User Name</td> <td>User Email</td> <td>Submitted Date</td> <td class="x17">1) How likely is it that you would recommend this SCTR service to a colleague?</td> <td class="x17">2) If you would like to provide additional feedback, please use the space below.</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r11"> <td style="height:14pt">13291-0004</td> <td style="text-align:right">543578</td> <td>Richard Silver</td> <td>test1@musc.edu</td> <td>01/02/23</td> <td class="x17">Extremely Likely</td> <td class="x17">No Response</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r12"> <td style="height:14pt">13291-0004</td> <td style="text-align:right">34560</td> <td>Stephanie Koren</td> <td>test2@musc.edu</td> <td>01/02/23</td> <td class="x17">Somewhat Likely</td> <td class="x17">No Response</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r13"> <td style="height:14pt"></td> <td></td> <td></td> <td></td> <td></td> <td class="x17"></td> <td class="x17"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r14"> <td style="height:14pt">Overall Satisfaction Rate</td> <td></td> <td class="x16" style="text-align:right">90%</td> <td></td> <td></td> <td class="x17"></td> <td class="x17"></td> </tr> <tr style="display:none"> <td style="width:123pt"></td> <td style="width:119.25pt"></td> <td style="width:149.25pt"></td> <td style="width:144.75pt"></td> <td style="width:111.75pt"></td> <td style="width:206.25pt"></td> <td style="width:251.25pt"></td> </tr> </tbody></table></div>

Copyright © 2011-2020 MUSC Foundation for Research Development