Document Management System (DMS) released DocFinity v12.4 upgrade on April 7, 2024.
This upgrade includes the following:
New Feature – Bulk Reindexing
Bulk Reindex allows you to reindex multiple documents at once with the same values. Bulk reindex is only available when selecting multiple documents with the same document type. The Re-Index button is available on the Results panel.
To learn more, please review the details in Release Notes.
For many Grant Managers and Principal Investigators, the implementation of Workday Finance marked the beginning of a journey—for answers, efficiencies, and reports, but most importantly, data. Along the way, these folks have come across Office Hours and Webinars, UW Connect articles and wiki pages, seeking answers and sharing gaps and pain points, all of which have supported us as we develop solutions.
While there is still more work to do, the Finance DATAGroup, with support from UW-IT Reporting & Analytics, is thrilled to announce three new Grant Reporting resources to provide clarity and support for grant management.
The Grant Planning and Forecasting Tool is a worksheet, which calculates totals based on actual Workday data and manually entered projected values. A Grant Manager can use this tool to review actuals and track projections for a grant with the Principal Investigator (PI). This is helpful in understanding how grant funding is being spent, making projections, and then making adjustments, as needed, based on the calculations.
Note: You must be logged into Husky OnNet (VPN) in order to access the above link. For more information, refer to Husky OnNet.
Post Award Dashboard
The Post Award Dashboard displays grant expense and balance data in table and visual format using data available in Workday. This tool provides an alternative way to access this data for users who are not as familiar with Workday.
This dashboard was originally developed by the Office of Research to fill an urgent need for Principal Investigators (PI) and Grant Managers following Workday Go Live. This second iteration builds on the first, moving the dashboard into Tableau (our supported visualization tool), streamlining filters, tables, and visuals, pulling data directly from Workday to ensure data integrity, and incorporating feedback from a group of early adopters. This dashboard is a work-in-progress and iterative updates are expected.
This dashboard groups data into two primary views, Grant Expenses and Balance Remaining, which are explained in more detail in the following sections.
Note: You must be logged into Husky OnNet (VPN) in order to access the above link. For more information, refer to Husky OnNet.
Grant Expenses
This dashboard displays Grant Expenses data in two formats: table and visual.
The table format displays grant expenses by month, beginning in July 2023, when data was loaded into Workday.
Example of Grant Expense Data in Table Format
The visual format displays life-to-date grant expenses, by Grant Default Department (CCH 07). From this view, you can click on different graphical elements to drill into additional detail, if desired.
Example of Grant Expense Data in Visual Format
Balance Remaining
This dashboard displays Balance Remaining data in two formats: table and visual.
The table format displays the current status of a grant.
Example of Balance Remaining Data in Table Format
The visual format displays balance remaining data, by Grant Department From this view, you can click on different graphical elements to drill into additional detail, if desired.
Example of Balance Remaining Data in Visual Format
Principal Investigator Dashboard
The Principal Investigator (PI) Dashboard displays grant data, which is tailored to the PI, who is logged into Workday. This gives PIs a central place to find grant-related content that is specific to them.
This dashboard splits data across six tabs—My Sponsored Grants, My Awards, My Stand Alone Grants, My Gifts, Grant Staffing, and Additional Resources—which are explained in more detail in the following sections.
Tips:
For help finding this dashboard in Workday, refer to Finding Reports.
For help saving this dashboard to your Apps list in Workday, refer to Customizing Workday.
Note: You must be logged into Husky OnNet (VPN) in order to access the above links. For more information, refer to Husky OnNet.
My Sponsored Grants Tab
This tab displays a snapshot of the Sponsored Grants associated with the PI, and allows the user to drill into additional detail, if needed.
Note: This tab refreshes nightly, so it reflects data from the previous day. Because this tab is not updated in real-time, you may find some discrepancies between this tab and real-time reports (for example, R1234).
Example of the “My Sponsored Grants” Tab
My Awards Tab
This tab displays a snapshot of the awards associated with the PI, and allows the user to drill into additional detail, if needed.
Note: This tab refreshes nightly, so it reflects data from the previous day. Because this tab is not updated in real-time, you may find some discrepancies between this tab and real-time reports (for example, R1234).
Example of the “My Awards” Tab
My Stand Alone Grants Tab
This tab displays a snapshot of the stand-alone grants associated with the PI, and allows the user to drill into additional detail, if needed.
Note: This tab reflects data in real-time.
Example of the “My Stand Alone Grants” Tab
My Gifts Tab
This tab displays gifts, but unlike the other tabs, the gits that display are not specific to the PI. This tab also allows the user to drill into additional detail, if needed.
Note: This tab reflects data in real-time.
Example of the “My Gifts” Tab
Grant Staffing Tab
This tab displays the staff working on grants associated with the PI, and allows the user to drill into additional detail, if needed.
Note: This tab refreshes nightly, so it reflects data from the previous day. Because this tab is not updated in real-time, you may find some discrepancies between this tab and real-time reports (for example, R1234).
Example of the “Grant Staffing” Tab
Additional Resources
This tab links out to helpful resources for the PI, including reports (Workday, research, and legacy), tasks, and other external resources.
Example of the “Additional Resources” Tab
Questions?
Please contact datagrp@uw.edu to initiate a ticket with the Finance DATAGroup.
The student database (SDB) will go through a reorganization on July 20, 2024 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on July 22, 2024.
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 – 7.18.24
Columns to be Added
Table
Column
DataType
ADDRESSES
SF_COUNTRY
char(2)
BUDGET_RESOURCES
BR_FOOD
int
BR_HOUSING
int
BR_EXTRA_FOOD
int
BR_EXTRA_HOUSING
int
ISIR_TRANSACTIONS
ISIR_CPS_SAI_BLK
bit
ISIR_CPS_P_SAI_BLK
bit
ISIR_INAS_SAI
int
ISIR_INAS_SAI_BLK
bit
NSLDS_DATA_PELL_DATA
N_PELL_SAI
int
SF_EVALUATION
S_MIDDLE_NAME
char(15)
S_SUFFIX
char(10)
STD_EITC_RCVD
char(1)
P1_EITC_RCVD
char(1)
USER_PROV_DATA
char(5)
P_INCOME_ADDITIONS
decimal(11,0)
S_INCOME_ADDITIONS
decimal(11,0)
INSTITUTIONAL_SAI
int
INST_SAI_BLK
bit
IP_S_ADJ_BUS_FARM
decimal(15,0)
IP_P_ADJ_BUS_FARM
decimal(15,0)
SF_EVALUATION1
PJ_STD_FAM_SIZE
char(2)
PJ_P1_FAM_SIZE
char(2)
SR_MAJOR_CODE
MAJOR_TYPES_20
bit
STUDENT_1
DISAB_ARCHIVE_FLG
bit
S1_BOOLEAN_09
bit
S1_BOOLEAN_10
bit
S1_BOOLEAN_11
bit
S1_BOOLEAN_12
bit
S1_BOOLEAN_13
bit
S1_BOOLEAN_14
bit
S1_BOOLEAN_15
bit
S1_BOOLEAN_16
bit
DISAB_ARC_UPDT_DT
datetime
DISAB_ARC_UPDT_ID
char(12)
S1_SPARE_F
char(64)
S1_SPARE_M
char(64)
S1_SPARE_L
char(64)
S1_SPARE_S
char(10)
New Table
Table
Column
Key
DataType
SR_ADM_RESULTS
MY_AA
Y
char(12)
SR_AAR_APPL_NAME
char(45)
SR_AAR_APPL_DOB
datetime
SR_AAR_SYSKEY
int
SR_AAR_EXACTID
char(10)
SR_AAR_CAMPUS
tinyint
SR_AAR_FORM_TYPE
char(8)
SR_AAR_APPL_TYPE
char(1)
SR_AAR_ENTRY_TERM
char(6)
SR_AAR_STATUS
char(1)
SR_AAR_MESSAGE
char(50)
SR_AAR_POSTED_DT
datetime
Columns to be Removed
Table
Column
Notes
SR_ADM_APPL
UW_PROMISE
No data
SR_MAJOR_CODE
MAJOR_EXCHANGE
Not in use, all records ‘0’
STUDENT_1
S1_BOOLEAN_07
Not in use, being replaced by Disab_Archive_Flg
Datatype Changes
Table
Column
DataType(new)
Data Type (old)
SA_WD_SUM_TRAN
WD_SUM_DB_AMOUNT
decimal(11,2)
decimal(9,2)
WD_SUM_CR_AMOUNT
decimal(11,2)
decimal(9,2)
SF_EVALUATION
IP_PC
decimal(15,0)
int
IP_TI
decimal(15,0)
int
IP_SATI
decimal(15,0)
int
IP_ATI
decimal(15,0)
int
SF_EVALUATION1
PJ_STD_EXMPTS
tinyint
decimal(15,0)
PJ_SP_EXMPTS
tinyint
decimal(15,0)
PJ_P1_EXMPTS
tinyint
decimal(15,0)
PJ_P2_EXMPTS
tinyint
decimal(15,0)
Field Moves – from SF_Evaluation to SF_Evaluation1
Two resources in the BI Portal leverage the same data: UW Admissions Cube and All Applications Report. In an effort to streamline security for this data, we recently deployed security updates to both of these resources.
Why was this change necessary?
Historically, access to the UW Admissions Cube and All Applications Report was managed separately, meaning that a user could have access to one resource, but not the other. This change allows us to grant user access at the data level, which ensures consistency in data management.
I no longer have access. What should I do?
The data accessed through these resources must be handled with care—it includes sensitive student data, data that could be misinterpreted and data that should only be communicated to students via the Office of Admissions. Therefore, action is required to gain or maintain access:
Note: You will need to be connected to the VPN to access this video.
Email studentdata@uw.edu and include “Access to Data in the UW Admissions Cube or All Applications Report” in the subject line. Make sure to indicate that you watched the video.
Content Spotlight: Information & Technology Governance
The UW has a new Information & Technology governance model to help guide how we use IT, aimed at enabling transformation and innovation at the UW through strategic investment in information and technology. The governance model is detailed in IT Connect’s IT at the UW section, and gives an overview of the governance groups that oversee various IT domains, their membership, and their purpose.
The content is an excellent example of teams from UW-IT collaborating to create an informative topical experience on IT Connect. If you or your team want support with creating web experiences on IT Connect, fill out this intake form and check the “Consulting on web content” option.
Web Content Best Practices: Optimize content for search engines
Good SEO practices on IT Connect content help end users find the information they seek. The IT Connect platform includes many features behind the scenes to help improve the search prominence of the site, but a significant key to the success of content in search results relies on the content itself.
Use plain language and use the words that end users use.
Repeat keywords throughout the content. If a word is central to a topic, if it appears on the page more than a few times, that page is more likely to be featured in search results for that term.
Use headings logically. Headings can be important for search engines evaluation of a page for search results. For the IT Connect internal search, headings are given additional weight. Headings should be clear and aimed at reader comprehension first, but use keywords in headings where it makes sense to do so.
Do you need some help creating IT Connect content, another head to brainstorm content organization and layout, or want to learn how to use the features available in IT Connect? There are several ways to get help:
Content Manager Documentation: Extensive documentation, ranging from the basics of WordPress to advanced features for pages, is available on the IT Connect Content Manager Documentation.
Guide to writing documentation: Use the Getting started with documentation guide to help you start writing documentation. The guide breaks down the documentation process that will benefit your end users.
Training: One-on-one training for managing content on IT Connect is available from the IT Connect service manager, Nick Rohde, over Zoom or in person. Get tips on correctly formatting content using the tools in IT Connect or learn how to organize your content. To arrange training, fill out this intake form.
Consultation: Consultation sessions for individuals or teams are available from the IT Connect product manager, Nick Rohde. To schedule a consultation, fill out this intake form.
The student database (SDB) will go through a reorganization on January 27, 2024 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on January 29, 2024.
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.23.24
**below additions to SF_Evaluation will result in additional records being shifted to SF_Evaluation1, will add details as soon as available.
Columns to be Added
Table
Column
DataType
ISIR_TRANSACTIONS
ISIR_CPS_SAI
int
ISIR_CPS_PROV_SAI
int
I_SP_SIGNATURE_CD
char(1)
I_P1_SIGNATURE_CD
char(1)
I_P2_SIGNATURE_CD
char(1)
I_SP_SSN_MATCH_FL
char(1)
I_P1_SSN_MATCH_FL
char(1)
I_P2_SSN_MATCH_FL
char(1)
PELL_DISBURSEMENT
PD_PAY_END_DT
datetime
PD_QTR_FLG
char(1)
SA_WD_DET_TRANS
WD_DET_BANK_CD
char(1)
SA_WD_SUM_TRAN
WD_SUM_BANK_CD
char(1)
STUDENT_1
DISAB_MORE_IND
bit
SYS_TBL_63_NONTUIT_CHARGES
AID_REPAY_CHARGE
bit
SPARE_BOOLEAN_2
bit
SDBDB01
G_SA_FLAG4
bit
SF_EVALUATION1
PJ_STD_DEPS
tinyint
PJ_SP_DEPS
tinyint
PJ_P1_DEPS
tinyint
PJ_P2_DEPS
tinyint
SP_TAX_RETURN_DT
datetime
P2_TAX_RETURN_DT
datetime
SF_EVALUATION
IP_S_IPA
decimal(15,0)
IP_S_APA
decimal(15,0)
S_SP_SSN_MATCH_IND
char(1)
P1_SSN_MATCH_IND
char(1)
P2_SSN_MATCH_IND
char(1)
S_DRUG_HOLD_IND
char(1)
SSA_CITIZENSHIP_SP
char(1)
SSA_CITIZENSHIP_P1
char(1)
SSA_CITIZENSHIP_P2
char(1)
STD_TU_MATCH_FLG
char(1)
SP_TU_MATCH_FLG
char(1)
P1_TU_MATCH_FLG
char(1)
P2_TU_MATCH_FLG
char(1)
MET_POVERTY_GUIDE
char(1)
SPO_PENSIONS_MAN
decimal(11,0)
P1_PENSIONS_MAN
decimal(11,0)
SAI_BLK
bit
PROV_SAI_BLK
bit
S_NO_FAM_MEMB_BLK
bit
S_NO_IN_COLLE_BLK
bit
STD_WK_INCOME_BLK
bit
STD_INTEREST_BLK
bit
STD_IRA_DIST_BLK
bit
STD_IRA_ROLL_BLK
bit
STD_PENSIONS_BLK
bit
STD_PENS_ROLL_BLK
bit
STD_AGI_BLK
bit
STD_TAX_PAID_BLK
bit
STD_DEDCT_PMT_BLK
bit
S_EDUC_CREDIT_BLK
bit
STD_SCHED_C_BLK
bit
STD_GRNT_SCHL_BLK
bit
STD_FRGN_EXCL_BLK
bit
STD_CHLD_SUPP_BLK
bit
STD_CASH_BLK
bit
STD_BUS_FARM_BLK
bit
STD_INVEST_BLK
bit
SPO_WK_INCOME_BLK
bit
SPO_INTEREST_BLK
bit
SPO_IRA_DIST_BLK
bit
SPO_IRA_ROLL_BLK
bit
SPO_PENSIONS_BLK
bit
SPO_PENS_ROLL_BLK
bit
SPO_AGI_BLK
bit
SPO_TAX_PAID_BLK
bit
SPO_DEDCT_PMT_BLK
bit
SPO_EDUC_CRED_BLK
bit
SPO_SCHED_C_BLK
bit
SPO_FRGN_EXCL_BLK
bit
P1_WK_INCOME_BLK
bit
P1_INTEREST_BLK
bit
P1_IRA_DIST_BLK
bit
P1_IRA_ROLL_BLK
bit
P1_PENSIONS_BLK
bit
P1_PENS_ROLL_BLK
bit
P1_AGI_BLK
bit
P1_TAX_PAID_BLK
bit
P1_DEDCT_PMT_BLK
bit
P1_EDUC_CRED_BLK
bit
P1_SCHED_C_BLK
bit
P1_GRNT_SCHL_BLK
bit
P1_FRGN_EXCL_BLK
bit
P1_CHLD_SUPP_BLK
bit
P1_BUS_FARM_BLK
bit
P1_INVEST_BLK
bit
P1_CASH_BLK
bit
P2_WK_INCOME_BLK
bit
P2_INTEREST_BLK
bit
P2_IRA_DIST_BLK
bit
P2_IRA_ROLL_BLK
bit
P2_PENSIONS_BLK
bit
P2_PENS_ROLL_BLK
bit
P2_AGI_BLK
bit
P2_TAX_PAID_BLK
bit
P2_DEDCT_PMT_BLK
bit
P2_EDUC_CRED_BLK
bit
P2_SCHED_C_BLK
bit
P2_FRGN_EXCL_BLK
bit
IP_STD_FWS_BLK
bit
IP_SP_FWS_BLK
bit
IP_P1_FWS_BLK
bit
IP_P2_FWS_BLK
bit
IP_ATI_BLK
bit
IP_P_PTA_BLK
bit
IP_IPA_BLK
bit
IP_P_PEEA_BLK
bit
IP_AI_BLK
bit
IP_AAI_BLK
bit
IP_PC_BLK
bit
IP_STD_PTA_BLK
bit
IP_S_IPA_BLK
bit
IP_STD_PNAAI_BLK
bit
IP_STD_SEEA_BLK
bit
IP_SATI_BLK
bit
IP_STAI_BLK
bit
IP_SCI_BLK
bit
IP_SAAI_BLK
bit
IP_SC_SAAI_BLK
bit
IP_DNW_BLK
bit
IP_NW_BLK
bit
IP_APA_BLK
bit
IP_PCA_BLK
bit
IP_SDNW_BLK
bit
IP_S_APA_BLK
bit
IP_SCA_BLK
bit
CUI_STD_AGI_BLK
bit
CUI_STD_EXEMP_BLK
bit
CUI_STD_DEPS_BLK
bit
CUI_STD_INC_BLK
bit
CUI_STD_TAX_BLK
bit
CUI_STD_EDUC_BLK
bit
CUI_STD_IRA_D_BLK
bit
CUI_STD_IRA_P_BLK
bit
CUI_STD_INTER_BLK
bit
CUI_STD_PENSN_BLK
bit
CUI_STD_SCHDC_BLK
bit
CUI_SPO_AGI_BLK
bit
CUI_SPO_EXEMP_BLK
bit
CUI_SPO_DEPS_BLK
bit
CUI_SPO_INC_BLK
bit
CUI_SPO_TAX_P_BLK
bit
CUI_SPO_EDUC_BLK
bit
CUI_SPO_IRA_D_BLK
bit
CUI_SPO_IRA_P_BLK
bit
CUI_SPO_INTER_BLK
bit
CUI_SPO_PENSN_BLK
bit
CUI_SPO_SCHDC_BLK
bit
CUI_P1_AGI_BLK
bit
CUI_P1_EXEMPT_BLK
bit
CUI_P1_DEPS_BLK
bit
CUI_P1_INC_BLK
bit
CUI_P1_TAX_BLK
bit
CUI_P1_EDUC_BLK
bit
CUI_P1_IRA_D_BLK
bit
CUI_P1_IRA_P_BLK
bit
CUI_P1_INTER_BLK
bit
CUI_P1_PENSN_BLK
bit
CUI_P1_SCHDC_BLK
bit
CUI_P2_AGI_BLK
bit
CUI_P2_EXEMPT_BLK
bit
CUI_P2_DEPS_BLK
bit
CUI_P2_INC_BLK
bit
CUI_P2_TAX_BLK
bit
CUI_P2_EDUC_BLK
bit
CUI_P2_IRA_D_BLK
bit
CUI_P2_IRA_P_BLK
bit
CUI_P2_INTER_BLK
bit
CUI_P2_PENSN_BLK
bit
CUI_P2_SCHDC_BLK
bit
IP_STI_BLK
bit
IP_TI_BLK
bit
IP_FTI_BLK
bit
PJ_STD_WORK_BLK
bit
PJ_STD_TAXES_BLK
bit
PJ_STD_AGI_BLK
bit
PJ_STD_UNTAXI_BLK
bit
PJ_STD_IRA_P_BLK
bit
PJ_STD_EDUC_BLK
bit
PJ_STD_INTER_BLK
bit
PJ_STD_EXMPT_BLK
bit
PJ_STD_DEPS_BLK
bit
PJ_STD_SCHDC_BLK
bit
PJ_STD_UNTAXP_BLK
bit
PJ_SP_WORK_BLK
bit
PJ_SP_TAXES_BLK
bit
PJ_SP_AGI_BLK
bit
PJ_SP_UNTAXI_BLK
bit
PJ_SP_IRA_P_BLK
bit
PJ_SP_EDUC_BLK
bit
PJ_SP_INTER_BLK
bit
PJ_SP_EXMPT_BLK
bit
PJ_SP_DEPS_BLK
bit
PJ_SP_SCHDC_BLK
bit
PJ_SP_UNTAXP_BLK
bit
PJ_P1_WORK_BLK
bit
PJ_P1_TAXES_BLK
bit
PJ_P1_AGI_BLK
bit
PJ_P1_UNTAXI_BLK
bit
PJ_P1_IRA_PMT_BLK
bit
PJ_P1_EDUC_BLK
bit
PJ_P1_INTER_BLK
bit
PJ_P1_EXMPT_BLK
bit
PJ_P1_DEPS_BLK
bit
PJ_P1_SCHDC_BLK
bit
PJ_P1_UNTAXP_BLK
bit
PJ_P2_WORK_BLK
bit
PJ_P2_TAXES_BLK
bit
PJ_P2_AGI_BLK
bit
PJ_P2_UNTAXI_BLK
bit
PJ_P2_IRA_PMT_BLK
bit
PJ_P2_EDUC_BLK
bit
PJ_P2_INTER_BLK
bit
PJ_P2_EXMPT_BLK
bit
PJ_P2_DEPS_BLK
bit
PJ_P2_SCHDC_BLK
bit
PJ_P2_UNTAXP_BLK
bit
SPARE_BOOLEAN1
bit
SPARE_BOOLEAN2
bit
SPARE_BOOLEAN3
bit
SPARE_BOOLEAN4
bit
Columns with datatype changes
Table
Column
DataType (existing)
DataType
(New)
SF_EVALUATION1
(currently in SF_EVALUATION)
SNG_SUM_ENROLL_ST
char(1)
char(2)
SNG_AUT_ENROLL_ST
char(1)
char(2)
SNG_WIN_ENROLL_ST
char(1)
char(2)
SNG_SPR_ENROLL_ST
char(1)
char(2)
Columns to be Removed
Table
Column
Notes
SDBDB01
G_WORKDAY_FIN
Replaced with G_SA_FLAG4
SF_EVALUATION
STD_TU_MATCH_DT
Not currently in use
Replaced with STD_TU_MATCH_FLG
SP_TU_MATCH_DT
Not currently in use
Replaced with SP_TU_MATCH_FLG
P1_TU_MATCH_DT
Not currently in use
Replaced with P1_TU_MATCH_FLG
P2_TU_MATCH_DT
Not currently in use
Replaced with P2_TU_MATCH_FLG
SR_DEPT_CODE
DEPT_FAS_ORG_CODE
STUDENT_1
S1_BOOLEAN_06
Not currently in use
Replaced with DISAB_MORE_IND
SA_WD_DET_TRANS
WD_DET_AID_TYPE
SA_AID_DISB_TRANS
Entire table
Columns moving from SF_Evaluation to SF_Evaluation1 due to column additions:
As of 12/29/23, the BI Portal now includes Release 1 of the SF425 report! This report allows Grant and Contract Accounting (GCA) to pull data from Workday into the SF425 Federal Financial Report, which is required to report on a grant’s cumulative expenses. This report was developed in collaboration between the BI Portal and DATAGroup teams. Check out the SF425 report in the BI Portal to learn more!
Why is the SF425 report a big deal?
For Release 1, the report pulls data for any reporting period that ends on 7/1/23 or later and displays the results within the SF425 form, in the correct format. This saves users significant time and reduces the potential for error.
Note: As with other new financial reports, this report will follow an iterative development process and planning for Release 2 is already underway.
How will GCA use the report?
This report is expected to streamline SF425 reporting for GCA as follows:
Enter the criteria into the prompts provided. Sample Report Criteria for the SF425 Report in the BI Portal
Review the results, which are properly formatted for the SF425 form. Sample Results for the SF425 Report in the BI Portal
If the results are correct, submit the form.
Questions?
Please contact help@uw.edu with “BI Portal” in the subject line.
As of 12/5/23, the BI Portal now includes the Non-Numeric Grade Frequency Distribution dashboard! This dashboard allows users to explore trends in grading patterns, missing grades, and other non-numeric grade outliers across UW academic departments. It reflects rolling data from the last 12 quarters and is intended for advisors, registrars and academic service leaders.
These are values assigned to a student’s transcript that do not follow the standard numerical grading system (4.0 scale). The following non-numeric values are included in this dashboard:
Incomplete
Registrar Drop
Missing Grade Annotations
Satisfactory/Not Satisfactory
Pass/Fail
Credit/No Credit
Honors
High Pass
In Progress
Letter Grades (A – E)
Does the dashboard include any Personally Identifiable Information (PII)?
The dataset does not include any PII, meaning there is no student, staff or faculty-identifying data. The most granular level of data available is a specific Curriculum Code (for example, ENG) and Course Level (for example, 100, 200, etc.).
How do I use the dashboard?
The dashboard makes it really easy to look at data in different ways by using filters to refine the view, expose trends and drill into the details to investigate, as needed. The following is a typical use case.
Use Case – Investigate Missing Grades
A user would take the following steps to explore trends in missing grades and take action to resolve them.
Click Run Dashboard. The dashboard defaults to the Trends view, presenting data for non-numeric grade values in three charts for all three UW Campuses. Default View of the Dashboard
In the Grade filter, select Missing Grade Annotations. Use additional filters to refine your results, as needed. Sample Results for Missing Grade Annotations Filter
To display a detailed report of the data as a table, click Go to Details >>. “Go to Details > >” Button Default View of the Details Report
To expose all available data, drill down to the Course Level.
Hover over the Course Campus column to display the plus sign (+). Click the plus sign (+) to display the Course College column.
Repeat for the Course College column, then the Course Department column, and then the Curriculum column to display the distribution of missing grades by course level. This is the most granular level of information available in the dashboard. Course Level Drill Down on the Details Report
Optional To export the data to Excel for further analysis, click the Choose a format to download icon and then select Crosstab. Selections to Export Data to Excel
Questions?
Please contact help@uw.edu with “BI Portal Dashboards” in the subject line.
A version of this message was sent to managers of affected UW Shared Drives on November 28, 2023.
What is happening?
Because your UW Google Shared Drive exceeds the 100GB limit, we want to remind you that you’ll need to purchase additional storage space before June 11, 2024. Our contract with Google now has system limitations that will require deletion of any UW Google Shared Drive that exceeds 100GB starting November 2024.
IMPORTANT: UW Google Shared Drives that are over the maximum quota will be deleted. UW-IT is unable to delete a portion of content in order to get the Shared Drive under the quota limit.
When is it happening?
OnJune 11, 2024, all UW Google Shared Drives that are over the 100GB limit will be restricted. You will still be able to view or download content in the affected drives, but you will be unable to add, modify or update existing files.
StartingNovember 5, 2024, all restricted UW Google Shared Drives that have not chosen to upgrade to a higher tier of storage will be subject to deletion.
What do I need to do now?
Review the attached list of UW Google Shared Drives that have been identified as close to or over the 100GB limit and determine which tier(s) of storage you will need to purchase. See available storage tiers and pricing information on IT Connect.* With this information, you can then budget accordingly for the upcoming fiscal year.
If you do not wish to purchase a higher tier of storage for the over quota UW Google Shared Drives, please make plans to migrate data — so that your data is under the 100GB limit.
*For storage greater than 1TB per year, please email help@uw.edu with the subject: UW Google Shared Drive – Custom Storage Pricing Information.
Please note: If a Shared Drive is flagged for deletion, the entire drive will be deleted, not just a select amount over the 100GB limit.
How do I purchase a higher tier of storage?
In April 2024, the UW Google Changes Project Team will provide an intake form for purchasing additional storage to anyone whose Shared Drive is over quota at that time. This form will collect required information such as the department, work tag, name of the UW Google Shared Drive(s), primary contact, etc.
Once we receive this information, the specified UW Google Shared Drive(s) will no longer be subject to deletion, provided that the governance and drive deletion policy are maintained. For more information, review the UW Google Shared Drive Service Offering page.
Where can I go for help?
Please contact the UW-IT Technology Service Center at help@uw.edu or 206-221-5000.
Update: Removal of aging envelopes in DocuSign to begin November 2023
What’s happening?
The eSignatures service team has begun implementing procedures to guarantee the removal of aging envelopes in DocuSign. This work is expected to begin the week of November 27th. We will be reaching out to the account Delegated Administrators with more details when we are ready to begin working on each department’s account. For more information about why this change is occurring, see below.
What do I need to do?
If you have sent envelopes using DocuSign, now is a great time to start working with your team’s Delegated Administrator to identify and download any envelopes that you’ve sent that need to be retained for records retention purposes.
If you are a Delegated Administrator, work with your team members to ensure that any envelopes that need to be retained have been downloaded and stored in your team’s repository. Review your team’s DocuSign group(s) and identify if anyone has left but still has an active account. The eSignatures team can help transfer their materials to someone who will be able to download them.
Why is this change happening?
Since the introduction of the centralized eSignatures service (DocuSign) at the University of Washington in 2014, the eSignatures service has required individual users to retain completed envelopes and other records outside of the DocuSign system in a repository that meets state and federal standards for records storage as outlined in the Acceptable Use Requirements.
To encourage users to correctly store records, the eSignatures team will begin purging aging envelopes this fall. Enforcing a periodic purge will ensure compliance with the UW Records Management and UW Medicine Records and Information Governance guidelines and policies.
Support
If you have any questions or concerns regarding this announcement, please reach out to the eSignatures team directly at eSignatures Help.
If you have any questions regarding records management, please reach out to the UW Records Management Services team at recmgt@uw.edu. For questions regarding UW Medicine Records and Information Governance, you can reach their team at hrc@uw.edu.