Journal of Clinical and Translational Science (Mar 2019)

3372 Developing a REDCap Database to Understand Partnership Cultivation Efforts

  • Grisel M. Robles-Schrader,
  • Gina Curry,
  • Josefina Serrato,
  • Jen Brown,
  • Keith A Herzog

DOI
https://doi.org/10.1017/cts.2019.200
Journal volume & issue
Vol. 3
pp. 87 – 87

Abstract

Read online

OBJECTIVES/SPECIFIC AIMS:.Outline the development and purpose of the partnership brokering database in REDCap. Provide an overview of the tool and how it works. Discuss how this tool facilitates partnership-brokering activities and discuss plans for future use METHODS/STUDY POPULATION: Research Electronic Data Capture (REDCap) is a secure, web-based application developed at Vanderbilt University to assist with systematic data management of small and medium sized projects. CCH utilized REDCap to build a custom data management warehouse entitled the Partnership Brokering Tool. Information compiled in various formats (handwritten notes, spreadsheets, etc.) over the past 10 years by CCH staff, was then systematically organized and entered into the Partnership Brokering Tool. The tool captures information such as individual contact information, organizational affiliation (academic, community, faith, government etc.), research interests (35 categories - asthma, diabetes, heart disease, etc.), communities of foci (children, elderly, LGBTQ, ethnicity, etc.), and target geographic community served (Chicago north, south, suburban, Illinois, etc.). RESULTS/ANTICIPATED RESULTS: Data was compiled on 451 community groups and organizations and 77 partners in academia thus far. Community organizations represent a range of community sectors including advocacy and policy groups, community-based, faith-based organizations, foundations, media, schools, etc. throughout the Chicagoland area. Data analysis activities are underway, however, results will also be shared regarding characteristics of the communities these organizations serve including:. Age range. Special populations (as defined by the CSTI grant). Underrepresented racial and ethnic communities. DISCUSSION/SIGNIFICANCE OF IMPACT: The Partnership Brokering Tool has provided a format for CCH to systematically gather information about the relationships staff have cultivated with community groups and organizations. Unlike an email management system, this REDCap project is highly useful in capturing the parameters of our partner pool, identifying partnership gaps, and matching individuals interested in collaborating with researchers or community organizations that have a particular skill set or research interest. The Partnership Brokering Tool has also facilitated stakeholder engagement dedicated to guiding the centers’ overall goals, objectives, and programming. Finally, utilizing REDCap has streamlined efforts in reporting quantitative and qualitative data about these organizations. In the next phase of this project, CCH will utilize the database to assess the nature of the relationship between CCH and community groups and organizations.