UWSDBDataStore Reorg on January 29, 2022

UWSDBDataStore Reorg on January 29,2022

The student database (SDB) will go through a reorganization on January 29,2022 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on January 31, 2022.
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: 01.29.2022)

*Please continuously monitor this site for the most current update.

Old Columns to be deleted

Table	Column
sa_sf_fund	fund_flag_45
sa_wd_det_trans	wd_det_proc_pd
sa_wd_sum_tran	wd_sum_proc_pd

Columns to be Added

Table	Column	DataType
addresses	dip_chg_date	datetime
	dip_chg_user_id	char(12)
	diploma_city	char(30)
	diploma_country	char(40)
	diploma_line_1	char(30)
	diploma_line_2	char(30)
	diploma_phone_num	decimal(10,0)
	diploma_postal_cd	char(10)
	diploma_state	char(2)
	diploma_zip_4	char(4)
	diploma_zip_5	char(5)
budget_resources	br_pkg_pt_sw	char(1)
finaid_docs_desc	fdd_archive_dt	datetime
sa_sf_fund	fund_school_med	bit
sa_wd_det_trans	wd_det_run_no	int
sa_wd_det_trans	wd_det_bal_unit	char(6)
sa_wd_sum_tran	wd_sum_bal_unit	char(6)
sa_wd_sum_tran	wd_sum_run_no	int
sdbdb01	g_sa_post_status	char(1)
sdbdb01	g_sa_post_run_no	int
sf_evaluation	strt_qtr_ovrd	tinyint
	coa_accepted_flg	char(1)
	coa_accepted_dt	datetime
	partial_isir_load	char(1)
sf_history	iasg_eligible_flg	char(1)
	sap_appeal_date	datetime
	sap_appeal_qtr	tinyint
	sap_appeal_yr	smallint
	sap_mtf_subtr_cr	smallint
	sap_pace_subtr_cr	smallint
	sap_plan	char(1)
	sap_prob_rem_qtrs	tinyint
	sap_prob_tot_qtrs	tinyint

Data Type changes

Table	Column	Old Datatype	New Datatype
student_2	diploma_name	char(45)	char(80)

FWS v2 EVAL Release 5 is now available

Enterprise Web Services has just released an update for FWS v5 EVAL to support UW Finance Transformation.

Change Summary:

Several new resources and fields have been added. See FWS v2 R5 Release Notes for details.
New search features have been added to most endpoints, including search by ‘changed_since_date’ and the ability to filter inactive results if the record contains an active field.
New Branch endpoint that allows for the viewing of entities/entity hierarchies and their related hierarchies from the bottom up.
New Workday Hierarchy endpoint that provides summarized hierarchy information including Total Nodes, Max Depth, Total Branches, etc.
Some breaking changes were introduced. See FWS v2 R5 Release Notes for details.
Minor bug fixes.

See our FWS v2 R5 Release Notes for a complete list of new features, changes, and bug fixes.

Additional resources, including a ‘Getting Started Guide’ to support your evaluation, are available on our FWS for Finance Transformation Support page.

We have already started working on Release 6, scheduled for April 2022. Bookmark the R6 Release Notes page to watch our progress. When you see a change item move to “Ready for Review” or “Done” before the release date, then this will indicate that a change is available in DEV. You can also use this page to monitor upcoming breaking changes so there are no surprises!

Support:

Please submit support requests to fws-support@uw.edu with ‘FWS v2 EVAL’ in the subject line
Subscribe to fws-ft-users to stay current on upcoming deployments and changes
Subscribe to the FWS for Finance Transformation Support page; we will be adding new resources to this page periodically
We will support questions related to e.g. missing data, data structure, access/connection issues, and adding access for additional NetIds or Applications

For questions regarding data quality please contact UWFT at uwftask@uw.edu.

UW Event Registration Application Release: Bug Fix and Updates

Update (1/5/2022): UW Event Registration Application updates are now in production.

Change Summary:

Bug fixed in the log out flow that was introduced by a recent browser security update. You will now see a browser pop up message when you log out.
Migrated from UW Services Certificate Authority (UWCA) to the Incommon Certificate Authority as part of a larger plan to standardize all EWS services to use Incommon. Learn more about these UW-IT offered services here: https://wiki.cac.washington.edu/display/infra/UW+Certificate+Services
Maintenance upgrade of Node.js Javascript runtime environment

We do not expect any customer impact. We will monitor and respond to this communication if we identify any impacts during deployment.

Learn more:

The UW Event Registration application automatically turns UW’s Husky Card swipes, taps, and NetIDs into a group of participants you can view, capture, download, export and email. This application is in Beta and we’re seeking new users.

Get started with UW Event Registration today!

Support:

For questions about this release or getting started with UW Event Registration, please contact us at uw-event-support@uw.edu.

BI Portal: New Report – Principal Investigator Proposal and Award Search

Now Available in the BI Portal: Principal Investigator Proposal and Award Search report

Do you find it difficult to manage research proposals and related awards for one or more specified principal investigators? If you could, would you like to dive deeper into the Principal Investigator (PI) research proposal and award data by a specific Fin Org code? Would your work be easier if you could filter and analyze the PI research proposal and award data by the proposal short or long title containing specific words or phrases?

All of this and more are now available in the Enterprise Data Warehouse (EDW), BI Portal, and Knowledge Navigator. This new report capability is the result of the partnership between the Office of Research Decision Support Services (ORIS DSS) team that developed this new report and the UW-IT Enterprise Reporting and Analytics team, this information and more are now available in the Enterprise Data Warehouse (EDW), BI Portal, and Knowledge Navigator.

New Report:

The new Principal Investigator Proposal and Award Search report, gives you detailed and summary information and the ability to analyze sponsored research proposals and awards by org, and/or by PI, and/or by keyword or phrase.

Data Used:

The report sources all of the data from existing views in the EDW RAD database. The EDW data is sourced from the Sponsored Proposal and Award data sources as entered into the SAGE suite.

Server: edwpub.s.uw.edu

Database: RAD

Views:

RAD.SEC.AWARD
RAD.SEC.PERSONFUNCTION
RAD.SEC.PERSONNEL
RAD.SEC.PROPOSAL
RAD.SEC.PROPOSALSTATUS
RAD.SEC.SPONSOR
RAD.SEC.SPONSORTYPE

Questions?

If you have questions about the meaning of Principal Investigator Proposal and Award Search or any other terms referenced in this new report, please visit Knowledge Navigator.

If you have questions about the report or would like to provide feedback, please write to grantrpt@uw.edu with “BI Portal Principal Investigator Proposal and Award Search Report” in the subject line.

New Look for Workday Reports Catalog

As part of the Report Adoption Project (RAP), we are very pleased to announce a new look and enhanced functionality of the Workday Reports Catalog in UW-IT’s Knowledge Navigator.

The Workday Reports Catalog still provides summary information about all available Workday Reports, including:

The full name of the report (as found in Workday)
A description of the report
Details about who can run the report

But now you can use several new report filters to quickly search the catalog by:

Workday Security Role – for a list of all reports that can be run by HR Partners, HCM Initiate 2s, Managers, etc.
Functional Subject Area – for a list of all reports by either the “primary functional area” (PFA) the report was originally designed to help with or the “secondary functional area” (SFA) the report might not have been originally designed for but still has relevance for (for example, a report that was originally designed to help review “Payroll” details that can also be helpful when reviewing “Costing” information).
Report Categories – for a more narrow, topic-specific list of all reports in a given category (for example, FTE, Holiday Credit, I-9s, Postdoctoral Scholars, Years of Service and more).
Your Favorite Reports – for a personalized list of all your favorite reports (you can add any report to your favorite list by selecting the name of the report and, on the Reports Detail page, selecting the “Add to Favorites” button in the upper right corner)

We hope this resource helps you pinpoint specific reports that provide you with the information you need, helps you discover new reports that become new favorites and becomes a welcome addition to your Workday toolkit!

How Do I Access The New Feature?

To access this new feature in the Workday Report Catalog in Knowledge Navigator:

Navigate to metadata.uw.edu
Expand the ‘Reports’ node in the navigation pane (right hand)
Click on ‘Workday Reports’ node:

You will be taken to the Workday Reports landing page in Knowledge Navigator
Scroll down to the list of reports
On the left hand side, you will be presented with a number of input boxes:

You can search report titles by entering keywords in the ‘Search report names…’ search box. The report listing will update to show matching reports as you type.
You can also select from the “Security groups”, “Functional groups” and/or “Report categories” filters.
The search, filters and favorites functionality work together to provide a finely tuned listing.

For more information about additional Workday report resources, including other ways of discovering Workday reports that can meet your needs, make sure to visit our Workday Reports 101 page.

BI Portal New Release: Notify Course Section Demand by Student Major

Available Now: New Dashboard Helps You Help Students

The Notify Course Section Demand by Student Major dashboard is now available on the BI Portal. Built through the collaboration of the Report Prioritization Group (RPG), the Enterprise Data Warehouse (EDW) team, and the Enterprise Reporting Analytics (ERA) team, this new Tableau visualization is where student advisers and coordinators can use data to see which courses are in high demand.

What is it?

The dashboard for the Notify Course Section Demand by Student Major is a Tableau visualization that displays data related to students who have signed up to receive notifications from the Notify.UW system.

It’s Built for You

If you’re a student advisor or program coordinator, you can use the dashboard to filter for specific majors and readily determine if students in those majors have signed up to receive notifications for a specific course section(s). With registration and degree information included, you will be able to get a more complete picture of a student’s course registration activity for any given quarter.

Help for Students

The dashboard allows you to determine student interest in courses offered by your program, information that enables you to reach out to students and help them register for a course at a critical point in a student’s progress toward their degree.

Get Access

Just a reminder that this dashboard is a Tableau dashboard. To connect to the UW Tableau server, you need to either be physically on the UW network (on campus) or connected through a VPN (Virtual Private Network). We recommend the UW-IT-supported Husky OnNet VPN. Find out how to download and use Husky OnNet at IT Connect: Download and Use Husky OnNet.

Furthermore, you will need an Enterprise Data Warehouse (EDW) Astra role to access the dashboard if you don’t already have one. Follow the instructions to “Request Access to Reports, Analytics, and Data” on IT Connect.

Questions?

If you have any questions about this new dashboard, please don’t hesitate to write to us at help@uw.edu and put “Notify Course Section Demand by Student Major” in the subject line.

Coming December 1: Tableau License Fee Change

UW-IT’s current licensing fees for Tableau Desktop have not changed since 2013. Over the course of the last eight years, Tableau’s additional offerings and subscription-based model have made it necessary for UW-IT to apply an increase to this service. The fees listed below will become effective on December 1, 2021.

What’s changing?

Tableau Desktop License (No Tableau Prep)*
- New fee: $40/month (current fee: $35/month)
Tableau Creator License (Tableau Desktop + Prep)
- New fee: $60/month (current fee: $52/month)

Please be sure to notify your department’s budget administrator of this change. Since Tableau licenses renew automatically, let your budget administrator know this change is coming on December 1, 2021 so they will recognize the new fee.

Need to renew with a different budget number?

If you need to bill a different budget number, email help@uw.edu by end of business on 11/26/2021 with “Tableau product license renewal” in the subject line.

Need to cancel your subscription?

To avoid automatic renewal of your subscription, email help@uw.edu by end of business on 11/26/2021 with “Cancel Tableau subscription” in the subject line.

Need a new subscription?

For a new subscription, please refer to the Tableau information and order form page.

GET A TABLEAU SUBSCRIPTION

Learn more about Tableau at the UW

Tableau is a world leader in data analytics platforms. The platform helps you, your colleagues, and customers visualize data in engaging and comprehensible ways so you can more easily make business decisions with confidence. Want to learn more about how Tableau is used at the UW? Do you want your own Tableau Desktop license? Get more information at the Tableau page on IT Connect.

LEARN MORE

Questions?

Please contact the UW-IT Service Center at help@uw.edu or call 206-221-5100.

*Existing subscriptions only

UWSDBDataStore Reorg on October 23, 2021

The student database (SDB) will go through a reorganization on October 23, 2021 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on October 25, 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: 10.22.2021)

*Please continuously monitor this site for the most current update.

Old Columns to be deleted

Table Name	Column Name
sdbdb01	g_sa_flag4
sa_sf_awards	award_event_dt1
	award_event_dt2
	award_event_dt3
	award_event_dt4
	award_event_dt5
	award_event_dt6
	award_status_cd1
	award_status_cd2
	award_status_cd3
	award_status_cd4
	award_status_cd5
	award_status_cd6

New columns to be added

Table	Column	DataType
sdbdb01	g_workday_fin	bit
addresses	text_message_ok	bit
sa_sf_award_awards	tara_last_elig_dt	datetime
sr_adm_appl	interest_in_other	bit
sr_adm_appl_guardian_data	guardian_email	char(50)
student_2	rn_ferpa_year	smallint
student_2	rn_ferpa_qtr	tinyint
sys_tbl_33_home_addr_by_code	home_addr_st_ter	char(24)
sys_tbl_39_calendar	tacoma_ymca_chrg	decimal(10,0)
sys_tbl_72_appl_status	appl_stat_long_ds	char(120)

New Tables to be Added

Table	Column Name	Datatype
sa_aid_disb_trans	system_key	int
	sa_aid_fund_info	smallint
	sa_aid_tran_dt	datetime
	sa_aid_year	tinyint
	sa_aid_qtr	tinyint
	sa_aid_disb_amt	decimal(9,2)
sa_tara_funding	system_key	int
	sa_tara_fund_no	smallint
	sa_tara_seq_no	smallint
	sa_tara_date	datetime
	sa_tara_aid_yr	smallint
	sa_tara_qtr	tinyint
	sa_tara_status	bit
	sa_tara_ex_amt	decimal(9,2)
	sa_tara_src_tag1	char(10)
	sa_tara_src_tag2	char(10)
	sa_tara_src_tag3	char(10)
	sa_tara_spare_1	char(10)
	sa_tara_spare_2	char(10)
	sa_tara_spare_3	int
	sa_tara_spare_4	int
sr_raw_transfer	system_key	int
	sr_raw_inst_cd	smallint
	sr_raw_year	char(6)
	sr_raw_term	char(1)
	sr_raw_curric	char(6)
	sr_raw_crs_no	char(4)
	sr_raw_dup_crs	tinyint
	sr_raw_crs_ttl	char(24)
	sr_raw_credits	decimal(3, 1)
	sr_raw_grade	char(2)
	sr_raw_qual	char(2)
	sr_raw_ta_group	smallint
	sr_raw_eval	char(1)
	sr_raw_pend_group	smallint
	sr_raw_pend_eval	char(1)
	sr_raw_ta_dt	datetime
	sr_raw_updt_dt	datetime
	sr_raw_updt_id	char(12)
	sr_raw_spare_1	char(10)
	sr_raw_spare_2	char(10)
	sr_raw_spare_3	int
	sr_raw_spare_4	int

FWS v2 EVAL Release 4 is now available

Enterprise Web Services has just released an update for FWS v4 EVAL to support UW Finance Transformation.

Change Summary:

Several new resources and fields have been added. See FWS v2 R4 Release Notes for details.
Some sub resources were deprecated that have introduced breaking changes.
Minor bug fixes.

See our FWS v2 R4 Release Notes for a complete list of new features, changes, and bug fixes.

Additional resources, including a ‘Getting Started Guide’ to support your evaluation, are available on our FWS for Finance Transformation Support page.

We have already started working on Release 5, scheduled for January 2022. Bookmark the R5 Release Notes page to watch our progress. When you see a change item move to “Ready for Review” or “Done” before the release date, then this will indicate that a change is available in DEV. You can also use this page to monitor upcoming breaking changes so there are no surprises!

Support:

Please submit support requests to fws-support@uw.edu with ‘FWS v2 EVAL’ in the subject line
Subscribe to fws-ft-users to stay current on upcoming deployments and changes
Subscribe to the FWS for Finance Transformation Support page; we will be adding new resources to this page periodically
We will support questions related to e.g. missing data, data structure, access/connection issues, and adding access for additional NetIds or Applications

For questions regarding data quality please contact UWFT at uwftask@uw.edu.

Infrastructure Upgrade and Access Change for Added Data Security

The Business Intelligence (BI) team in UW-IT Enterprise Reporting and Analytics (ERA) is completing an infrastructure upgrade.

If you use reports available through BI Portal or if you partner with our team to support data tools on the BI Portal, you need to know about some of the changes we’ve made and how they may impact your work.

1. Increased Security for Reports

Starting on October 6, to increase security, access to the ERA report server and all reports available through the BI Portal (https://biportal.uw.edu) will require you to be physically on campus or connect to UW’s network via a Virtual Private Network (VPN) for access off-campus. This is a departure from the current security in which reports are accessible from outside the UW networks without installing a VPN client.

Our goal is to provide best security practices around UW’s data to ensure that our systems and the data are not compromised.

How does this impact you?

If you are on campus you don’t have to do anything. If you are NOT on campus, you must connect to the UW network through a VPN. You will be required to download and install the Husky OnNet VPN application supported by UW-IT. You can read about it, download it, and learn more on IT Connect: Husky OnNet.

The security of the systems and data that you access are our priority and a VPN is critical to help protect personal and University data and information on the UW network.

2. Latest SQL Server and SSAS (aka cubes) Versions

With this tech refresh, we’ve made the following upgrades:

Migrated to Windows Managed Virtual Machines (VMs) for all of our BI infrastructure.

Environment	DEV	TEST	PROD
Old Servers	edwdevbi1.s.uw.edu	edwtestbi1.s.uw.edu	reports: edw.washington.edu cubes: cubes.uw.edu
New Servers	edwdevbi11.s.uw.edu	edwtestbi10.s.uw.edu	reports: edw.washington.edu cubes: cubes.uw.edu

Upgraded to the latest software versions:
- SQL Server 2019
- SSRS Version 15.0
- SSAS 2019

Questions?

Whether you’re a BI Portal user or a partner development team, if you have any questions about this tech refresh, please write help@uw.edu with “BI Infrastructure Upgrade/Access” in the subject line.