Hello RAH Report Developers - The following enhancements are available for you in Production.

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

Table of Contents

Subaward Data Added to RAH

We are excited to announce the most recent data added to RAH is focused on subaward data. This data will give fund managers access to all outgoing subawards, including detailed information on obligated amounts and invoiced amounts. Using this information, fund managers will have a larger picture into their fund management and planning portfolio.

Report developers can choose from RAH-Subaward-View and RAH-SubawardInvoice-View when creating their Subaward reports.

Ui expand

title	RAH-Subaward-View and RAH-SubawardInvoices-View Comparison

	RAH-Subaward-View	Both	RAH-SubawardInvoice-View
When to Use	When you are looking for historical information about subawards.		When you are looking for only current invoice information.
Important Subaward Fields	Subaward Modification ID	Subaward Number Subaward Status Subaward Version Status	Subaward Invoice Number
Recommended Subaward Filters		Subaward Status = ACTIVE Subaward Version Status= ACTIVE
Measures	Subaward Obligated Total Amount: Reflects Total obligated Amount for subaward Subaward Modification Obligated Change: Use in conjunction with Subaward Modification ID otherwise will equal Subaward Obligated Total Amount Subaward Invoice Total: Reflects Total Invoiced Amount for subaward Award Obligate Total Cost: Reflects total amount obligated to award that is funding the subaward		Subaward Invoice Total: Reflects Total Invoiced Amount for subaward Subaward Invoice Amount: Use in conjunction with Subaward Invoice Number, otherwise will equal Subaward Invoice Total Subaward Obligated Total Amount: reflect total amount obligated to subaward Award Obligate Total Cost: Reflects total amount obligated to award that is funding the subaward

Ui expand

title	RAH-Subaward-View

RAH-Subaward-View

Epic: RAHMAINT-397

Fields included:

Award Activity Type
Award Activity Type and Code
Award Activity Type Code
Award Agreement Type
Award Agreement Type Code
Award Financial Description
Award IDC Applicable Rate - Multi
Award IDC Waiver Number - Multi
Award Lead Division
Award Lead Division Code
Award Lead Unit
Award Lead Unit Code
Award Lead Unit Name and Code
Award Lead Unit VC Unit
Award Lead Unit VC Unit Code
Award Obligated Direct Cost
Award Obligated Indirect Cost
Award Obligated Total Cost
Award Organization Code
Award Organization Name
Award Organization Name and Code
Award Overall End Date
Award Overall Start Date
Award Prime Sponsor
Award Prime Sponsor Code
Award Prime Sponsor REMS City
Award Prime Sponsor REMS Foreign Country Code
Award Prime Sponsor REMS Foreign Indicator
Award Prime Sponsor REMS Sponsor Agency
Award Prime Sponsor REMS Sponsor Agency Code
Award Prime Sponsor REMS Sponsor Category
Award Prime Sponsor REMS Sponsor Category Code
Award Prime Sponsor REMS Sponsor Sub-Agency
Award Prime Sponsor REMS Sponsor Sub-Agency Code
Award Principal Investigator Email Address
Award Principal Investigator Employee ID
Award Principal Investigator Home Division
Award Principal Investigator Home Division Code
Award Principal Investigator Home Unit
Award Principal Investigator Home Unit Code
Award Principal Investigator Home Unit VC Unit
Award Principal Investigator Home Unit VC Unit Code
Award Principal Investigator Name - First
Award Principal Investigator Name - Full
Award Principal Investigator Name - Last
Award Principal Investigator Name - Middle
Award Principal Investigator Name and Employee ID
Award REMS Sponsor Agency
Award REMS Sponsor Agency Code
Award REMS Sponsor Category
Award REMS Sponsor Category Code
Award REMS Sponsor Foreign Country Code
Award REMS Sponsor Foreign Indicator
Award REMS Sponsor Sub-Agency
Award REMS Sponsor Sub-Agency Code
Award Sponsor
Award Sponsor Code
Award Status
Award Template
Award Template Code
Award Title
KR Award Clinical Trial Protocol Type
Sponsor Award Number
Subaward Account ID
Subaward Anticipated Total Amount
Subaward Cost Type
Subaward Cost Type Code
Subaward Current Version Flag
Subaward Document Number
Subaward Execution Date
Subaward FFATA Required Count
Subaward FFATA Required Flag
Subaward FSRS Number
Subaward IDC Rate
Subaward Invoice Total Amount
Subaward Modification Anticipated Change
Subaward Modification Effective Date
Subaward Modification End Date
Subaward Modification Execution Date
Subaward Modification ID
Subaward Modification Obligated Change
Subaward Modification Start Date
Subaward Modification Type
Subaward Modification Type Code
Subaward Number
Subaward Obligated Total Amount
Subaward Overall End Date
Subaward Overall Start Date
Subaward Recipient Organization Code
Subaward Recipient Organization Name
Subaward Recipient Organization Name And Code
Subaward Recipient Principal Investigator Email Address
Subaward Recipient Principal Investigator First Name
Subaward Recipient Principal Investigator Full Name
Subaward Recipient Principal Investigator Last Name
Subaward Recipient Principal Investigator Middle Name
Subaward Requisitioner Employee ID
Subaward Requisitioner First Name
Subaward Requisitioner Full Name
Subaward Requisitioner Full Name And Employee ID
Subaward Requisitioner Last Name
Subaward Requisitioner Middle Name
Subaward Requisitioner Unit Name
Subaward Requisitioner Unit Number
Subaward Sequence Number
Subaward Status
Subaward Status Code
Subaward Supplier Site ID
Subaward Title
Subaward Version Status
UCSD Award Number - Full

Ui expand

title	RAH-SubawardInvoice-View

RAH-SubawardInvoice-View

Epic: RAHMAINT-465

Fields included:

Award Activity Type
Award Activity Type and Code
Award Activity Type Code
Award Agreement Type
Award Agreement Type Code
Award Financial Description
Award IDC Applicable Rate - Multi
Award IDC Waiver Number - Multi
Award Lead Division
Award Lead Division Code
Award Lead Unit
Award Lead Unit Code
Award Lead Unit Name and Code
Award Lead Unit VC Unit
Award Lead Unit VC Unit Code
Award Obligated Direct Cost
Award Obligated Indirect Cost
Award Obligated Total Cost
Award Organization Code
Award Organization Name
Award Organization Name and Code
Award Overall End Date
Award Overall Start Date
Award Prime Sponsor
Award Prime Sponsor Code
Award Prime Sponsor REMS City
Award Prime Sponsor REMS Foreign Country Code
Award Prime Sponsor REMS Foreign Indicator
Award Prime Sponsor REMS Sponsor Agency
Award Prime Sponsor REMS Sponsor Agency Code
Award Prime Sponsor REMS Sponsor Category
Award Prime Sponsor REMS Sponsor Category Code
Award Prime Sponsor REMS Sponsor Sub-Agency
Award Prime Sponsor REMS Sponsor Sub-Agency Code
Award Principal Investigator Email Address
Award Principal Investigator Employee ID
Award Principal Investigator Home Division
Award Principal Investigator Home Division Code
Award Principal Investigator Home Unit
Award Principal Investigator Home Unit Code
Award Principal Investigator Home Unit VC Unit
Award Principal Investigator Home Unit VC Unit Code
Award Principal Investigator Name - First
Award Principal Investigator Name - Full
Award Principal Investigator Name - Last
Award Principal Investigator Name - Middle
Award Principal Investigator Name and Employee ID
Award REMS Sponsor Agency
Award REMS Sponsor Agency Code
Award REMS Sponsor Category
Award REMS Sponsor Category Code
Award REMS Sponsor Foreign Country Code
Award REMS Sponsor Foreign Indicator
Award REMS Sponsor Sub-Agency
Award REMS Sponsor Sub-Agency Code
Award Sponsor
Award Sponsor Code
Award Status
Award Template
Award Template Code
Award Title
KR Award Clinical Trial Protocol Type
Sponsor Award Number
Subaward Account ID
Subaward Anticipated Total Amount
Subaward Cost Type
Subaward Cost Type Code
Subaward Current Version Flag
Subaward Document Number
Subaward Execution Date
Subaward FFATA Required Count
Subaward FFATA Required Flag
Subaward FSRS Number
Subaward IDC Rate
Subaward Invoice Amount
Subaward Invoice Created By Email Address
Subaward Invoice Created By Employee ID
Subaward Invoice Created By First Name
Subaward Invoice Created By Full Name
Subaward Invoice Created By Full Name And Employee ID
Subaward Invoice Created By Last Name
Subaward Invoice Created By Middle Name
Subaward Invoice Effective Date
Subaward Invoice End Date
Subaward Invoice ID
Subaward Invoice Initiated Date
~~Subaward Invoice Number~~ (replaced by Subaward Invoice ID Nov 3, 2021 Case CS0761694)
Subaward Invoice Start Date
Subaward Invoice Status
Subaward Invoice Status Code
Subaward Invoice Status Update Datetime
Subaward Invoice Total Amount
Subaward Invoice Updated By Email Address
Subaward Invoice Updated By Employee ID
Subaward Invoice Updated By First Name
Subaward Invoice Updated By Full Name
Subaward Invoice Updated By Full Name And Employee ID
Subaward Invoice Updated By Last Name
Subaward Invoice Updated By MIddle Name
Subaward Number
Subaward Obligated Total Amount
Subaward Overall End Date
Subaward Overall Start Date
Subaward Recipient Organization Code
Subaward Recipient Organization Name
Subaward Recipient Organization Name And Code
Subaward Recipient Principal Investigator Email Address
Subaward Recipient Principal Investigator First Name
Subaward Recipient Principal Investigator Full Name
Subaward Recipient Principal Investigator Last Name
Subaward Recipient Principal Investigator Middle Name
Subaward Requisitioner Employee ID
Subaward Requisitioner First Name
Subaward Requisitioner Full Name
Subaward Requisitioner Full Name And Employee ID
Subaward Requisitioner Last Name
Subaward Requisitioner Middle Name
Subaward Requisitioner Unit Name
Subaward Requisitioner Unit Number
Subaward Sequence Number
Subaward Status
Subaward Status Code
Subaward Supplier Site ID
Subaward Title
Subaward Version Status
UCSD Award Number - Full

Completion of Research Activity Hub Restructuring

The primary purpose of using Activity Hubs is to blend information across hubs. The original release of Kuali data was a basic "lift and shift", which caused delays in delivering on our blending promise and slowed the performance of Kuali reports. With today's release of RAH-PD-View and RAH-PDDetail-View we are completing our move of the Kuali data into our standard Activity Hub table structure.

The field names are all the same so those of you with reports using Research Administration - Developer Package - PD - KUALI can now repoint at the new RAH-PDDetail-View or RAH-PD-View Cognos package / Tableau data source in order to move forward.

In Summary:

Data Source / Package	Cognos	Tableau
RAH-Award-View	Available with enhancements	Available with enhancements
RAH-AwardDetail-View	Available with enhancements	Available with enhancements Tableau LOD included in data source
Research Administration - Developer Package - Award - KUALI	Available but NO enhancements - Will eventually be retired	Available but NO enhancements - Will eventually be retired
RAH-IP-View	Available with enhancements	Available with enhancements
RAH-IPDetail-View	Available with enhancements	Available with enhancements
Research Administration - Developer Package - IP- KUALI	Available with February enhancements - Will eventually be retired	Available with February enhancements - Will eventually be retired
RAH-PD-View RAHMAINT-462	Available with enhancements	Available with enhancements
RAH-PDDetail-View RAHMAINT-416	Available with enhancements	Available with enhancements
Research Administration - Developer Package - PD - KUALI	Available with February enhancements - Will eventually be retired	Available with February enhancements - Will eventually be retired

Versions Compared

Old Version 1

New Version Current

Key

Subaward Data Added to RAH

RAH-Subaward-View

RAH-SubawardInvoice-View

Completion of Research Activity Hub Restructuring

Page Comparison

Versions Compared

Old Version 1

New Version Current

Key

Subaward Data Added to RAH

RAH-Subaward-View

RAH-SubawardInvoice-View

Completion of Research Activity Hub Restructuring