July 7, 2026
Launch of the New RADDataStore Database in EDW
Announcement: Launch of the New RADDataStore Database in EDW
A new database, RADDataStore, has been introduced in EDW to provide Research Administration Data views. These views are sourced from the RADDB database designed and maintained by the Office of Research Information Services (ORIS), where data from the SAGE system and related Workday datasets are integrated using Research-defined business rules and logic.
This database is a direct copy of the ORIS RADDB data, with only minor changes to the view names. The mapping from the ORIS RADDB to EDW RADDataStore is provided below and may be useful for campus users who are already familiar with and using the RADDB on the ORIS server.
| ORIS RADDB (Schema: “UW”) | EDW RADDataStore |
| UW.vAbstract | sec.UW_vAbstract |
| UW.vApplication | sec.UW_vApplication |
| UW.vApplicationAwardBridge | sec.UW_vApplicationAwardBridge |
| UW.vApplicationCountry | sec.UW_vApplicationCountry |
| UW.vAward | sec.UW_vAward |
| UW.vAwardAdvanceExtensionRequest | sec.UW_vAwardAdvanceExtensionRequest |
| UW.vAwardAdvanceRequest | sec.UW_vAwardAdvanceRequest |
| UW.vAwardLine | sec.UW_vAwardLine |
| UW.vAwardModificationRequest | sec.UW_vAwardModificationRequest |
| UW.vAwardModificationRequestCategory | sec.UW_vAwardModificationRequestCategory |
| UW.vAwardRequestReturn | sec.UW_vAwardRequestReturn |
| UW.vAwardSetupRequest | sec.UW_vAwardSetupRequest |
| UW.vCompliance | sec.UW_vCompliance |
| UW.vCostCenter | sec.UW_vCostCenter |
| UW.vDate | sec.UW_vDate |
| UW.vFundingAction | sec.UW_vFundingAction |
| UW.vGrant | sec.UW_vGrant |
| UW.vGrantHierarchy | sec.UW_vGrantHierarchy |
| UW.vHold | sec.UW_vHold |
| UW.vItemComments | sec.UW_vItemComments |
| UW.vNonAwardAgreement | sec.UW_vNonAwardAgreement |
| UW.vPerson | sec.UW_vPerson |
| UW.vPersonRoleItemBridge | sec.UW_vPersonRoleItemBridge |
| UW.vResearchRole | sec.UW_vResearchRole |
| UW.vSAGESubrecipient | sec.UW_vSAGESubrecipient |
| UW.vSponsor | sec.UW_vSponsor |
| UW.vSubaward | sec.UW_vSubaward |
| UW.vSubawardRequest | sec.UW_vSubawardRequest |
| UW.vWDSubrecipient | sec.UW_vWDSubrecipient |
| ORIS RADDB (Schema: “UW_rpt”) | EDW RADDataStore |
| UW_rpt.vActiveConvertedAwards | sec.UW_rpt_vActiveConvertedAwards |
| UW_rpt.vAdvancementProposal | sec.UW_rpt_vAdvancementProposal |
| UW_rpt.vApplication | sec.UW_rpt_vApplication |
| UW_rpt.vASRs | sec.UW_rpt_vASRs |
| UW_rpt.vAward_OpenItems | sec.UW_rpt_vAward_OpenItems |
| UW_rpt.vAward_PostFT | sec.UW_rpt_vAward_PostFT |
| UW_rpt.vCurrentReturnedAwardRequests | sec.UW_rpt_vCurrentReturnedAwardRequests |
| UW_rpt.vMODs | sec.UW_rpt_vMODs |
| UW_rpt.vNonAwardAgreement | sec.UW_rpt_vNonAwardAgreement |
| UW_rpt.vSPA_AwardTrends | sec.UW_rpt_vSPA_AwardTrends |
| UW_rpt.vSubawardRequest | sec.UW_rpt_vSubawardRequest |
| UW_rpt.vSubawardRequestDean | sec.UW_rpt_vSubawardRequestDean |
Definitions for the views and columns will be made accessible in the Knowledge Navigator soon.
Questions?
Please contact edw-help@uw.edu with “RADDataStore” in the subject line.