RAH Quick Start Guides
Overview
Supporting blended research reporting and analysis, the Research Activity Hub (RAH) is a central repository for UC San Diego enterprise system data as it relates to UC San Diego sponsored research activity across relevant systems.
The Research Activity Hub supports the analysis of sponsored projects including pre and post award. The primary data source for RAH is Kuali Research. Major operational reports built on RAH include current awards and pending proposals, award obligations by totals per fiscal year, and quarterly award snapshots among others. We’ve partnered closely with OCGA to continue to enhance RAH. RAH also includes a subaward and subaward invoice views.
Other Resources
Have a field name but not sure what view to look in? Search the Data Dictionary
Data is loaded each night. To see when the data completed being loaded by UCSD into RAH see this report: AH-Data Load Status Report
RAH Basics
Some Agency (Names) will show null even though Agency Codes are present:
PD Rems Sponsor Agency
IP REMS Sponsor Agency
Award REMS Sponsor Agency
IP REMS Prime Sponsor Agency
Award Prime Sponsor REMS Sponsor Agency
Per UCOP “Not ALL sponsor codes will have these selected – we update legacy codes as we interact with them."
Principal Investigators (PI) - The person leading the research project. Usually faculty member or academic leader.
Relationships
Proposal Development (PD) → Institutional Proposal (IP) → Award
PD records can not be changed after they are submitted
1 PD record has 0 or 1 IP record
Generally speaking, a Proposal Development (PD) record gets assigned an Institutional Proposal (IP) # once it is approved and submitted to sponsor. There are several cases why a PD record does not have an IP record, but most cases are PDs that haven't been Approved and Submitted to the sponsor yet. Also, PD numbers started being issued around 2016, so IPs prior to 2016 are likely without a PD number.
1 IP record can have 1 or more PD record
1 IP record can have 0, 1 or more Awards
1 Award can have 0, 1 or more IP record
Find the View You Need
In general, use the summary view and move to the detail view if needed.
View Name aka Tableau Data Source / Cognos Package | Use this view when... |
|---|---|
You are looking for Award information and one row per Award. | |
You are looking for Award information, including attributes that will display multiple values per award. IE: Award Key Person | |
RAH-IP-View | You are looking for IP information and one row per IP. |
You are looking for IP information, including attributes that will display multiple values per award. IE: IP Key Person | |
RAH-PD-View | You are looking for PD information and one row per PD. |
You are looking for PD information, including attributes that will display multiple values per award. IE: PD Key Person | |
RAH-Subaward-View | You are looking for Subaward information and one row per Subaward. |
You are looking for Subaward information, including attributes that will display multiple values per award. | |
Research Administration - Developer Package - Award - KUALI | Retired February 2022. |
Research Administration - Developer Package - IP- KUALI | Retired February 2022. |
Research Administration - Developer Package - PD - KUALI | Retired February 2022. |