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.

Browser not supported