Skip to content

October 13, 2026

RADDataStore Reorg (ORIS RADDB Release v3.2 on November 2, 2026)

The Office of Research Information Services (ORIS) RADDB database will be updated on November 2, 2026, which will cause changes in the EDW RADDataStore database. EDW RADDataStore will incorporate these changes in an upcoming release (late evening on November 2, 2026).  Please note that data in new views will be available as soon as the Data Custodian submits security role definitions.

A summary of the changes is provided below.

Change ORIS Schema.Object EDW Schema.Object Number of Columns to Change
Field Removed (see below) UW.vApplication sec.UW_vApplication 1
UW.vAwardAdvanceExtensionRequest sec.UW_vAwardAdvanceExtensionRequest 2
UW.vAwardAdvanceRequest sec.UW_vAwardAdvanceRequest 1
UW.vAwardModificationRequest sec.UW_vAwardModificationRequest 1
UW.vAwardSetupRequest sec.UW_vAwardSetupRequest 1
New Field Added UW.vApplication sec.UW_vApplication 6
UW.vAward sec.UW_vAward 1
UW.vAwardAdvanceExtensionRequest sec.UW_vAwardAdvanceExtensionRequest 3
UW.vAwardAdvanceRequest sec.UW_vAwardAdvanceRequest 3
UW.vAwardModificationRequest sec.UW_vAwardModificationRequest 5
UW.vAwardSetupRequest sec.UW_vAwardSetupRequest 5
UW.vNonAwardAgreement sec.UW_vNonAwardAgreement 6
UW.vPersonRoleItemBridge sec.UW_vPersonRoleItemBridge 3
UW.vSponsor sec.UW_vSponsor 1
UW.vSubaward sec.UW_vSubaward 4
UW.vSubawardRequest sec.UW_vSubawardRequest 4
New View Added UW.vBudget sec.UW_vBudget 10
UW.vSAGESponsor sec.UW_vSAGESponsor 21

 

*** Breaking Change ***

These columns will be removed:

  • RADDataStore.sec.UW_vApplication.CostCenterName
  • RADDataStore.sec.UW_vAwardAdvanceExtensionRequest.DaysSinceStatusDate
  • RADDataStore.sec.UW_vAwardAdvanceExtensionRequest.StatusDate
  • RADDataStore.sec.UW_vAwardAdvanceRequest.StatusDate
  • RADDataStore.sec.UW_vAwardModificationRequest.StatusDate
  • RADDataStore.sec.UW_vAwardSetupRequest.StatusDate

 

More details can be found in ORIS RADDB Release v3.2 Change Details (see the [RADDB 3.2 11.2.26] tab).