Enterprise Data Warehouse News
March 4, 2021
New PAS Data Enhancement in the EDW
Procurement Credit Card Spend Data Now Matched to True Supplier In October of 2018, a project was initiated to capture all suppliers from the University’s Procurement Accounting System (PAS) in the Enterprise Data Warehouse (EDW). The project was comprised of three major steps: First, to capture all existing Suppliers from the PAS system in EDW Second, to secure all Spend financials and diversity indicators attributed to those suppliers And last, to attribute Procurement Credit Card transactions to the true supplier, not simply the credit card merchant (JPMorganChase) In late January 2021, this final planned enhancement to the EDW for the...
February 22, 2021
How To: Finance Date Functions in EDW
Do you ever get tired of building complicated date logic in your EDW queries? The EDW now supports several finance date functions to help you simplify your queries! These functions help enterprise data users to easily convert calendar dates, months, and years to UW fiscal calendar objects. These functions are most helpful to SQL developers working on reports and visualizations that use fiscal calendar parameters/variables. Context: In SQL, a function is a program that takes some input and generates a value. SQL has many built-in functions that you get out-of-the-box. For example, one of the built-in system functions is GETDATE(). ...
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...