202409 RAH Release Notes

Hello RAH Report Developers - The below enhancements are included in this month's RAH Release.

Keep up with our future enhancements here: RAH Bugs and Enhancements In Progress.

Learn more about the Research Activity Hub in the RAH Quick Start Guides.


Schedule for September

  • Thursday the 19th, end of day: release enhancements to User Acceptance Testing

  • Wednesday the 25th: UAT feedback Due

  • Thursday the 26th, end of day: release enhancement to Production

  • Friday the 27th, end of day: delete QA models


Thank You Report Developers!

Special thanks to the report developers who submitted enhancement requests.

  • Ernesto Donate
  • Jessie Gao


Your Requested Enhancements!

Items marked with an asterisk (*) are report breaking enhancements if you have these fields in your report.

RAH-IP-View & RAH-IPDetail-View, RAH-PD-View & RAH-PDDetail-View, RAH-PDProposalPersonDetail-View

Epic:  RAHE-1069 - Getting issue details... STATUS

Enhancements will address the following SNOW tickets: CS2135273

Added the following fields:

  • PD Revisions Requested Date

  • PD Revisions Requested Count


RAH-Subaward-View

Epic:  RAHE-1051 - Getting issue details... STATUS

Enhancements will address the following SNOW tickets:  CS2128343

Added the following fields:

  • OFC Expenditure Supplier

  • OFC Expenditure Supplier Code


RAH-Subaward-View & RAH-SubawardInvoice-View

Epic:  RAHE-1065 - Getting issue details... STATUS

Enhancements will address the following SNOW tickets: CSTASK0037413

Added the following fields:

  • Award Transaction Type

  • Award Transaction Type Code

  • Award UCSD Prime Sponsor Major Agency

  • Award UCSD Sponsor Major Agency

  • OFC Award Contract Amount

  • OFC Award End Date

  • OFC Award Fund Manager Active Count

  • OFC Award Fund Manager Email Address

  • OFC Award Fund Manager Employee ID

  • OFC Award Fund Manager ID And Name

  • OFC Award Fund Manager Identity AD Username

  • OFC Award Fund Manager Name Full

  • OFC Award Fund Manager Reports To Email Address

  • OFC Award Fund Manager Reports To Employee ID

  • OFC Award Fund Manager Reports To ID And Name

  • OFC Award Fund Manager Reports To Identity AD Username

  • OFC Award Fund Manager Reports To Name Full

  • OFC Award Number

  • OFC Award Owning Organization

  • OFC Award Owning Organization Code

  • OFC Award Owning Organization Code And Name

  • OFC Award SPF Accountant Active Count

  • OFC Award SPF Accountant Email Address

  • OFC Award SPF Accountant Employee ID

  • OFC Award SPF Accountant ID And Name

  • OFC Award SPF Accountant Identity AD Username

  • OFC Award SPF Accountant Name Full

  • OFC Award SPF Accountant Reports To Email Address

  • OFC Award SPF Accountant Reports To Employee ID

  • OFC Award SPF Accountant Reports To ID And Name

  • OFC Award SPF Accountant Reports To Identity AD Username

  • OFC Award SPF Accountant Reports To Name Full

  • OFC Award SPF Supervisor Active Count

  • OFC Award SPF Supervisor Email Address

  • OFC Award SPF Supervisor Employee ID

  • OFC Award SPF Supervisor ID And Name

  • OFC Award SPF Supervisor Identity AD Username

  • OFC Award SPF Supervisor Name Full

  • OFC Award SPF Supervisor Reports To Email Address

  • OFC Award SPF Supervisor Reports To Employee ID

  • OFC Award SPF Supervisor Reports To ID And Name

  • OFC Award SPF Supervisor Reports To Identity AD Username

  • OFC Award SPF Supervisor Reports To Name Full

  • OFC Award Start Date

  • OFC Award Status

  • UCSD Award Number - Base



UAT - Customer Service Reminder

Data in UAT is not ready to be shared with end customers, is not considered completely validated and can change suddenly.  For optimal customer satisfaction, do not connect your production solutions to packages / data sources that are in UAT.  If you choose to share UAT items with end customer, be explicit that the data and report is in UAT and can change suddenly or be broken by UAT changes.

Follow our Enhancement User Acceptance Testing (UAT) Steps

Use this UAT time to adjust your reports as needed prior to the Production release where your customers will be able to see any issues these enhancements cause. 
  • Cognos: Use the packages in Cognos DEV > Student Activity Hub > Student Activity Hub Packages UAT to build your report and select Hana QA.  Do not select Hana Prod as the report will fail.  Using Hana QA will allow you to see the below enhancements with Production data. 
  • Tableau: Sign into Tableau on your Tableau desktop tool and open your report.  Add a new data source with the same name and -QA at the end of the title.  Using this data source will allow you to see the below enhancements with Production data.
  • Hana QA:  SAH data in Hana QA is production data loaded daily, just like in Hana PROD.

If you find an issue, please include in your email to busintel@ucsd.edu the following:

  • What browser are you using?
  • What environment are you using?  Cognos DEV, QA or PROD?  Or Tableau?
  • What data source / package are you using?
  • What results were you expecting? 

Reminder: QA data sources will be deleted the Friday after the enhancements are migrated to Production.