Enterprise Data Warehouse News
February 10, 2021
EDW Upgrade to SQL Server 2019 Complete
The EDW successfully upgraded our user-facing servers (EDWPub.s.uw.edu) to SQL Server 2019. We believe you will experience minimal impact, however, if you do experience any issues, please reference our IT Connect article titled, “Preview available for upcoming EDW server upgrade” which contains a list of known issues. Reporting issues If you experience any issues you are not able to resolve, please write help@uw.edu and put “EDWPub Server Upgrade” in the subject line.
February 2, 2021
Upcoming changes on EDW process dates for WorkerPosition-related views
Update on 2/12/2021: EDW team is going to deploy this change on Saturday February 27th to give room for our Payroll data processing to take place in the week of March 1st. If you have any concerns with the 2/27 deployment, please let us know as soon as possible by emailing help@uw.edu with the subject: “EDW WorkerPosition Changes”. Thank you, EDW team 2/2/2021 We’d like to share upcoming changes to the following columns in the views of the ODS and HumanResources databases. The Impacted columns are: Views Columns ODS.sec.WorkerPosition RecordLoadDttm, RecordUpdateDttm ODS.sec.WorkerPositionDetail RecordLoadDttm, RecordUpdateDttm ODS.sec.WorkerPositionJobClassificationDetail RecordLoadDttm, RecordUpdateDttm HumanResources.sec.WorkerPosition (history data) RecordLoadDttm, RecordUpdateDttm, RecordEffBeginDate, RecordEffEndDate...
Read Upcoming changes on EDW process dates for WorkerPosition-related views
January 21, 2021
EDW Customer Survey: The Results Are In
If you participated in the EDW's Customer Survey, thank you! Understanding how you use the EDW helps us improve our services and enhances our ability to support you now and in the future. Over One Million You queried the EDW over one million times from August 2019 to August 2020. By Popular Demand By far, the type of data you want most is Finance (75%), HR/Payroll (62%) and Academic (54%). Among the variety of databases that you access, the top three are ODS, UWSDBData, and FinancialSumMart. Roles and Responsibilities At least half of you have multiple roles in your department and...
December 18, 2020
UWSDBDataStore Reorg on January 30, 2021
The student database (SDB) will go through a reorganization on January 30, 2021 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on February 1, 2021. 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 modified: 03.03.2021) *Please continuously monitor this site for the most current update. Old Columns to be deleted Table Name Column Name registration_courses crs_fee_budget crs_rev_obj_cd crs_cost_acct_cd sa_tuition_table no_per_std_surch sdb_security sdb_home_dept sdb_org_code sr_course_instr fac_budget_no fac_course_bgt...
December 14, 2020
Preview available for upcoming EDW server upgrade
On the evening of February 9, 2021, the EDW will be upgrading our user-facing servers (EDWPub.s.uw.edu) to SQL Server 2019. This upgrade will position the EDW to take advantage of modern SQL features, as well as allow for greater flexibility as computing and technology needs evolve. Impact We believe this upgrade will have minimal impact on our users. However, we recognize that with any upgrade to a newer version of a relational database management system, there is potential to introduce a compatibility issue with tools or systems that interact with our servers. With this in mind, we have set up...
December 7, 2020
ASTRA 2.1 auto-deprovisioning feature now available in the EDW
The Data Platform uses ASTRA to manage access to Enterprise Data Warehouse (EDW) data. The recent release of ASTRA 2.1 includes a new auto-deprovisioning feature that will monitor and automatically remove access for terminated employees. As of December 7, 2020, the EDW is now using ASTRA 2.1 and taking advantage of its new features. The deprovisioning process was previously accomplished via manual review. This automation greatly reduces the risk of inappropriate access to EDW data. How may this affect you? EDW authorizers will benefit from the improved efficiency of automated removal of authorizations. It is still recommended that you continue...
Read ASTRA 2.1 auto-deprovisioning feature now available in the EDW
October 15, 2020
Knowledge Navigator Expands Meta Tag Feature
The meta tag feature in Knowledge Navigator (KN) https://metadata.uw.edu has been expanded to provide one more tool to help you search for categorized metadata objects. What are meta tags? Just like the categories on a blog or keywords in a search tool, meta tags help you find all content that is related by that category or keyword. Where do I find meta tags in Knowledge Navigator? Meta tags are shown under the search field on KN’s home page next to the words “Quick Search.” Meta tags can also be found under Details > Meta Tags: on a metadata object’s page....
October 9, 2020
UWSDBDataStore Reorg on October 24, 2020
The student database (SDB) will go through a reorganization on October 24, 2020 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on Monday, October 26, 2020. 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 modified: 10.26.2020) *Please Note:The scope listed below isn't final until 1 week before the reorg. Please continuously monitor this site for the most current update. New columns to be added Table Name...
October 2, 2020
2020 CIP Codes Load Into EDW
On Tuesday, October 6, 2020, the new 2020 CIP Series will be loaded into the Enterprise Data Warehouse. This affects any table that contains CIPKeyId. The tables that contain CIP code reference data are dimCIPCurrent and CIPAcademicYear in EDWPresentation. What is included in CIP code updates? Part 1: CIP codes with descriptions from the National Center for Education Statistics (NCES). Part 2: Federal STEM (Science, Technology, Engineering & Mathematics) indicator provided by Immigrations and Customs Enforcement (ICE). This indicator is updated at irregular intervals. The most current data is from 2016. Part 3: Washington State STEM indicators provided by the...
August 21, 2020
Spend Financial Data Now Available in EDW
In October of 2018, in partnership with the Financial Data Group, the UW-IT Information Management team completed the capture of all suppliers from the University’s Procurement Accounting System (PAS) in the Enterprise Data Warehouse (EDW). The next step in securing PAS data focused on the Spend financials and Diversity indicators for those suppliers. With access to PAS Supplier, Spend and Diversity Data, campus departments can get information to help them evaluate, manage and plan their financial expenditures as well as meet all their Federal reporting requirements. How Can You Use PAS Data? To answer questions like: In the calendar year...