July 15, 2026
RADDataStore Reorg on July 27, 2026
RADDataStore Reorg on July 27, 2026
The Office of Research Information Services (ORIS) RADDB database will go through a reorganization on July 27, 2026, which will cause breaking changes in the Enterprise Data Warehouse database, RADDataStore. These changes to the objects will be available in the EDW RADDataStore on July 28, 2026. However, data on the new objects will be available as soon as the Data Custodian submits security role definitions.
Last Updated: 7/15/2026
| Status | ORIS Schema.Object | EDW Object | Note |
| Removed | UW_rpt.vSPA_AwardTrends | UW_rpt_vSPA_AwardTrends | All 33 fields listed to be removed |
| Changed Format | UW.vItemComments.ItemType | UW_vItemComments.ItemType | nvarchar(20) to (30) |
| Added Fields | UW.vNonAwardAgreement | UW_vNonAwardAgreement | |
| Added Fields | UW.vPersonRoleItemBridge | UW_vPersonRoleItemBridge | |
| Added New Objects | UW.vAA_AdminActionSubtype | UW_vAA_AdminActionSubtype | |
| UW.vAA_Other | UW_vAA_Other | ||
| UW.vAwardLineSpecialCondition | UW_vAwardLineSpecialCondition | ||
| UW.vAwardSpecialConditionType | UW_vAwardSpecialConditionType | ||
| UW_rpt.vAwardActivity_InProgressRequests | UW_rpt_vAwardActivity_InProgressRequests | ||
| UW_rpt.vAwardTrends | UW_rpt_vAwardTrends |
More details can be found in the following ORIS RADDB changes (version 3.0):
UW Schema – Complete List of Views and Fields