Service News Category: Enterprise Data Warehouse

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…

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…

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…

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…

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…

UWSDBDataStore Reorg on June 6, 2020

The student database (SDB) will go through a reorganization on June 6, 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, June 8, 2020. However, data on the new objects will be available as soon as the Data Custodians…

The Newest Addition to the EDW: Time Travel with dimTime

If you work with time data, a new reference table in the EDW makes it easier than ever to manipulate time in your SQL query. What is it? The new dimTime table has a row for each minute of the day for a total of 1,440 records. Each “minute record” has details including: a minute…

EDW Payroll data will include NWH and UWP employees

As part of the Enterprise Data Warehouse’s support for the Northwest Hospital Integration effort, beginning with the next payroll, pay period Jan 1-15, the EDW payroll data will include the Northwest Hospital (NWH) and UW Physicians (UWP) employees who are all now UW employees as of the beginning of 2020. If you have any questions…

Column Change: EarnType in BudgetActivityDetail

The Change The length for column EarnType (description) in the BudgetActivityDetail table has been increased from a varchar(25) to a varchar(255). This change will occur in the following ODS tables: BudgetActivityDetail BudgetActivityDetail2Bien BudgetActivityDetailCurrentBiennium BudgetActivityDetailCurrentBienniumMinus1 BudgetActivityDetailCurrentBienniumMinus2 BudgetActivityDetailCurrentBienniumMinus3 BudgetActivityDetailCurrentBienniumMinus4 BudgetActivityDetailCurrentBienniumMinus5 BudgetActivityDetailCurrentBienniumMinus6 BudgetActivityDetailCurrentBienniumMinus7 How will this affect me? If you query the tables directly, you may be affected….

UWSDBDataStore Reorg on February 1, 2020

Hello, The student database (SDB) will go through a reorganization on February 1, 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, February 3, 2020. (However, data on the new objects will be available as soon as the Data…

« Previous Page Next Page »