Enterprise Data Warehouse News
October 13, 2026
RADDataStore Reorg (ORIS RADDB Release v3.2 on November 2, 2026)
This news provides details of EDW RADDataStore database changes, which reflect ORIS RADDB Release v3.2 on November 2, 2026.
Read RADDataStore Reorg (ORIS RADDB Release v3.2 on November 2, 2026)
September 23, 2026
UWSDBDataStore Reorg on October 24, 2026
UWSDBDataStore Reorg on October 24, 2026 The student database (SDB) will go through a reorganization on October 24, 2026 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on October 26, 2026 However, data on the new objects will be available as soon as the Data Custodians submit the security role definitions and the SIS team loads the data. Last Updated – 10.19.26 Columns to be Added Table Column DataType SA_ACCOUNT NO_PSHIP_DATA TINYINT NSLDS_DATA N_NSLDS_UPDATE_DT DATETIME N_UAGGR_SUB_PEND DECIMAL(15,0) N_UAGGR_COM_PEND DECIMAL(15,0) BUDGET_RESOURCES BR_BASIC_BUDGET_F INT SF_EVALUATION** UW_RECEIPT_DATE DATETIME FAA_FRAUD_OVRD...
August 6, 2026
RADDataStore Reorg (ORIS RADDB Release v3.1)
The Office of Research Information Services (ORIS) RADDB database was updated on August 5, 2026, EDW RADDataStore will incorporate these changes in a release on September 3, 2026. Data will be available for users on the following day. A summary of the changes is provided below. Change ORIS Schema.Objecct EDW Object Add New Fields UW.vAwardModificationRequest UW_vAwardModificationRequest UW_rpt.vApplication UW_rpt_vApplication UW_rpt.vAwardTrends UW_rpt_vAwardTrends UW_rpt.vAwardActivity_InProgressRequests UW_rpt_vAwardActivity_InProgressRequests Add New Objects UW.vPersonMarketo UW_vPersonMarketo UW.vSponsorAffiliate UW_vSponsorAffiliate UW.vSponsorAffiliateType UW_vSponsorAffiliateType UW.vSponsorRiskType UW_vSponsorRiskType UW.vSponsorRiskTypeBridge UW_vSponsorRiskTypeBridge UW.rpt.vAwardActivity UW_rpt_vAwardActivity UW.rpt.vAwardActivity.AwardLine UW_rpt_vAwardActivity_AwardLine UW.rpt.vAwardActivity.History UW_rpt_vAwardActivity_History UW.rpt.vPaidBySPA UW_rpt_vPaidBySPA UW.rpt.vPaidBySPA.Potential UW_rpt_vPaidBySPA_Potential More details can be found in ORIS RADDB Release v3.1 Change Details (see the...
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...
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...
April 17, 2026
UWSDBDataStore Reorg on May 2, 2026
UWSDBDataStore Reorg on May 2, 2026 The student database (SDB) will go through a reorganization on May 2, 2026 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on May 4, 2026 However, data on the new objects will be available as soon as the Data Custodians submit the security role definitions and the SIS team loads the data. Last Updated – 4.17.26 Columns to be Added Table Column DataType NSLDS_DATA N_LOAN_LIM_EXC_FG CHAR(1) N_DISB_DT_FLG CHAR(1) N_LIFETM_LOAN_TOT DECIMAL(15,0) N_G_COMB_LIM_FLGA CHAR(1) N_P_COMB_LIM_FLGA CHAR(1) N_PLUS_LIMIT_FLG CHAR(1) N_LIFETIME_MAX_FG CHAR(1) N_AGGR_GRAD_BAL DECIMAL(15,0)...
March 9, 2026
Upcoming EDW Data Updates Related to Procurement Roll Forward (PRF) Journal Cleanup
WHAT: Duplicate Roll Forward Encumbrance journals were inadvertently created and will need to be deleted. WHO: Customers extracting EDW data into downstream systems, please note you may need to remove these journals on your end. WHEN: Fix will be seen in EDW on 3/17, cleanup can be asynchronous Hello EDW Users, We want to inform you about upcoming changes to EDW data related to cleanup duplicate Procurement Encumbrance Roll Forward (PRF) journals within Workday. The University Controller’s Office (UCO) and Financial Accounting & Management (FAM) are canceling certain encumbrance journals in Workday to resolve issues where duplicate Roll Forward Encumbrance journals were inadvertently created. This update...
Read Upcoming EDW Data Updates Related to Procurement Roll Forward (PRF) Journal Cleanup
February 2, 2026
EDW Breaking Changes March 11, 2026
EDW Breaking Changes March 11, 2026 Summary of changes, details to follow below. JIRA Database Table Notes EDW-25564 UWODS sec.EmploymentStatus Logic change, existing logic avaialble in new table sec.EmploymentStatusWorkerType EDW-25654 UWODS sec.CustomerRefund Column Removals EDW-25590 SpaceDataStore sec.BuildingInteriorSpace Data type changes sec.EmployeeInSeat sec.FunctionalUse sec.PIsToRooms sec.SharedSpace sec.SpaceWorktag EmploymentStatus Logic Change - EDW-25564 A new table UWODS.sec.EmploymentStatusWorkerType has been created to replace the existing UWODS.sec.EmploymentStatus. The table currently named UWODS.sec.EmploymentStatus can show multiple statuses for the same person when they have worked under multiple worker types. The new table name better respresents this behavior and avoids confusion. Table Notes sec.EmploymentStatusWorkerType New table (already...
January 8, 2026
UWSDBDataStore Reorg on January 31, 2026
UWSDBDataStore Reorg on January 31, 2026 The student database (SDB) will go through a reorganization on January 31, 2026 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on February 2, 2026 However, data on the new objects will be available as soon as the Data Custodians submit the security role definitions and the SIS team loads the data. Last Updated – 1.29.26 Columns to be Added Table Column DataType SF_EVALUATION** STD_ISIR_EMAIL char(50) STUDENT_1 EO_MODCAMP_ID char(8) EO_MODCAMP_DT datetime STUDENT_2_CERTIFICATE_INFO CERTIF_YR smallint CERTIF_QTR tinyint CERTIF_BRANCH tinyint CERTIF_MAJOR_ABBR char(6)...
November 13, 2025
Connecting Campus with Space Data via the Enterprise Data Platform
UW Facilities manages more than 15 million square feet of owned space on the Seattle campus and over 2 million square feet of leased space across the greater Seattle area. These spaces are essential to the University’s academic, research, and administrative operations. To effectively manage them, UW Facilities relies on a Space Management System that supports data-driven decision-making and ensures compliance with federal and state reporting requirements—including the Facilities & Administrative (F&A) rate proposal, which depends on reliable research space data. When UW Facilities began the project to replace its Space Management System earlier this year, it opened the door...
Read Connecting Campus with Space Data via the Enterprise Data Platform