202308 RAH Release Notes

Owned by Saparnell
Last updated: Sep 21, 2023
4 min read

Hello RAH Report Developers - The below enhancements are now available in Production.

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.


Thank You Report Developers!

Special thanks to the report developers who submitted enhancement requests.

  • Ernesto Donate
  • Cheryl Kettnich


New View: RAH-Sponsor-View

BIA, in conjunction with the OCGA Reporting team, is excited to release the RAH-Sponsor-View.  This new view provides information about Sponsors, without attachment to awards or proposals.

Per our standard process, this view will remain in UAT for a full month.  It is schedule to be released to Production on September 28.

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

Requested via the SNOW ticket: CS1660593

Added the following fields:

  • REMS Sponsor Agency
  • REMS Sponsor Agency Code
  • REMS Sponsor Category
  • REMS Sponsor Category Code
  • REMS Sponsor City
  • REMS Sponsor Foreign Country Code
  • REMS Sponsor Foreign Indicator
  • REMS Sponsor Postal Code
  • REMS Sponsor State
  • REMS Sponsor Status
  • REMS Sponsor Status Code
  • REMS Sponsor Sub-Agency
  • REMS Sponsor Sub-Agency Code
  • Sponsor
  • Sponsor Active Count
  • Sponsor Active Flag
  • Sponsor Code
  • Sponsor Name and Code
  • UCSD Sponsor Major Agency


Your Requested Enhancements!

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

RAH-IP-View

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

Enhancements will address the following SNOW tickets: CS1660593, CS1454747, CS1454851

Added the following fields:

  • Historical PD Created By Employee ID
  • IP UCSD Prime Sponsor Major Agency
  • IP UCSD Sponsor Major Agency
  • PD Created By Email
  • PD Created By Employee ID
  • PD Created By Home Division
  • PD Created By Home Division Code
  • PD Created By Home Unit
  • PD Created By Home Unit Code
  • PD Created By Home Unit Name and Code
  • PD Created By Identity AD Username
  • PD Created By Name - First
  • PD Created By Name - Full
  • PD Created By Name - Last
  • PD Created By Name - Middle
  • PD Created By Phone
  • PD Created By Reports To Employee ID
  • PD Created By Reports To Name First
  • PD Created By Reports To Name Full
  • PD Created By Reports To Name Last
  • PD Created By Reports To Name Middle
  • PD Created By Reports To Email
  • PD Created By Reports To Identity AD Username
  • PD Created Date

Logic for Sponsor Major Agency field:

IF [Award Sponsor Code]='0770' then 'NOAA'

ELSEIF [Award Sponsor Code]='2025' then 'DARPA'

ELSEIF [Award REMS Sponsor Sub-Agency Code]=8 then 'NIH'

ELSEIF [Award REMS Sponsor Agency Code]=3 then 'DOD'

ELSEIF [Award REMS Sponsor Agency Code]=5 then 'DOE'

ELSEIF [Award REMS Sponsor Agency Code]=16 then 'NSF'

ELSEIF [Award REMS Sponsor Agency Code]=14 then 'NASA'

ELSEIF [Award REMS Sponsor Category Code]=1 then 'Other Fed'

ELSEIF [Award REMS Sponsor Category Code]=2 then 'State CA'

ELSEIF [Award REMS Sponsor Category Code]=3 then 'Other Gov'

ELSEIF [Award REMS Sponsor Category Code]=4 then 'Industry'

ELSEIF ([Award REMS Sponsor Category Code]=5 or

[Award REMS Sponsor Category Code]=6 or

[Award REMS Sponsor Category Code]=7 or

[Award REMS Sponsor Category Code]=8 or

[Award REMS Sponsor Category Code]=12 or

[Award REMS Sponsor Category Code]=13 or

[Award REMS Sponsor Category Code]=14 or

[Award REMS Sponsor Category Code]=99) then 'Private/Non-Profit'

RAH-IPDetail-View

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

Enhancements will address the following SNOW tickets: CS1660593, CS1454747, CS1454851

Added the following fields:

  • Historical PD Aggregator Employee ID
  • Historical PD Created By Employee ID
  • IP UCSD Prime Sponsor Major Agency
  • IP UCSD Sponsor Major Agency
  • PD Aggregator Email
  • PD Aggregator Employee ID
  • PD Aggregator Home Division
  • PD Aggregator Home Division Code
  • PD Aggregator Home Unit
  • PD Aggregator Home Unit Code
  • PD Aggregator Home Unit Name and Code
  • PD Aggregator Identity AD Username
  • PD Aggregator Name - First
  • PD Aggregator Name - Full
  • PD Aggregator Name - Full
  • PD Aggregator Name - Last
  • PD Aggregator Name - Middle
  • PD Aggregator Phone
  • PD Aggregator Reports To Email
  • PD Aggregator Reports To Employee ID
  • PD Aggregator Reports To Identity AD Username
  • PD Aggregator Reports To Name - First
  • PD Aggregator Reports To Name - Full
  • PD Aggregator Reports To Name - Last
  • PD Aggregator Reports To Name - Middle
  • PD Created By Email
  • PD Created By Employee ID
  • PD Created By Home Division
  • PD Created By Home Division Code
  • PD Created By Home Unit
  • PD Created By Home Unit Code
  • PD Created By Home Unit Name and Code
  • PD Created By Identity AD Username
  • PD Created By Name - First
  • PD Created By Name - Full
  • PD Created By Name - Last
  • PD Created By Name - Middle
  • PD Created By Phone
  • PD Created By Reports To Employee ID
  • PD Created By Reports To Name - First
  • PD Created By Reports To Name - Full
  • PD Created By Reports To Name - Last
  • PD Created By Reports To Name - Middle
  • PD Created By Reports To Email
  • PD Created By Reports To Identity AD Username
  • PD Created Date

RAH-PD-View

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

Enhancements will address the following SNOW tickets: CS1660593, CS1454747, CS1454851

Added the following fields:

  • PD Created By Home Division
  • PD Created By Home Division Code
  • PD Created By Home Unit
  • PD Created By Home Unit Code
  • PD Created By Home Unit Name and Code
  • PD Created By Reports To Employee ID
  • PD Created By Reports To Name First
  • PD Created By Reports To Name Full
  • PD Created By Reports To Name Last
  • PD Created By Reports To Name Middle
  • PD Created By Reports To Email
  • PD Created By Reports To Identity AD Username
  • PD UCSD Prime Sponsor Major Agency
  • PD UCSD Sponsor Major Agency

RAH-PDDetail-View

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

Enhancements will address the following SNOW tickets: CS1660593, CS1454747, CS1454851

Added the following fields:

  • PD Aggregator Home Division
  • PD Aggregator Home Division Code
  • PD Aggregator Home Unit
  • PD Aggregator Home Unit Code
  • PD Aggregator Home Unit Name and Code
  • PD Aggregator Reports To Email
  • PD Aggregator Reports To Employee ID
  • PD Aggregator Reports To Identity AD Username
  • PD Aggregator Reports To Name - First
  • PD Aggregator Reports To Name - Full
  • PD Aggregator Reports To Name - Last
  • PD Aggregator Reports To Name - Middle
  • PD Created By Home Division
  • PD Created By Home Division Code
  • PD Created By Home Unit
  • PD Created By Home Unit Code
  • PD Created By Home Unit Name and Code
  • PD Created By Reports To Employee ID
  • PD Created By Reports To Name - First
  • PD Created By Reports To Name - Full
  • PD Created By Reports To Name - Last
  • PD Created By Reports To Name - Middle
  • PD Created By Reports To Email
  • PD Created By Reports To Identity AD Username
  • PD UCSD Prime Sponsor Major Agency
  • PD UCSD Sponsor Major Agency

RAH-Subaward-View

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

Enhancements will address the following SNOW tickets: CS1648630

Added the following fields:

  • Subaward Modification Obligated Amount

  • Subaward Sequence Obligated Change

RAH-SubawardInvoice-View

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

Enhancements will address the following SNOW tickets: CS1648630

Added the following fields:

  • Subaward Sequence Obligated Change