Skip to content

DMS (DocFinity) Version 12.4 Upgrade PROD Released on April 07, 2024

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.

Empowering PIs and Grant Managers: New Resources for Grant Reporting

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.

Introducing the New Resources

The following resources are now available!

Grant Planning and Forecasting Tool

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.

Screenshot of the Grant Planning & Forecasting Tool
Example of the Grant Planning & Forecasting Tool

To learn more about this tool, refer to W0001 – Grant Planning & Forecasting Tool.

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.

To learn more about this dashboard, refer to Post Award Dashboard.

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.

Screenshot of the Grant Expenses tab of the Post Award Dashboard
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.

Screenshot of the Grant Expenses Visual tab in the Post Award Dashboard.
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.

Screenshot of the Grant Balance Remaining tab of the Post Award Dashboard
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.

Screenshot of the Grant Balance Remaining Visual tab of the Post Award Dashboard
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:

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).

Screenshot of the "My Sponsored Grants" tab of the PI Dashboard
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).

Screenshot of the "My Awards" tab in the PI Dashboard
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.

Screenshot of the "My Stand Alone Grants" Tab in the PI Dashboard
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.

Screenshot of the "My Gifts" tab of the PI Dashboard
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).

Screenshot of the "Grant Staffing" tab in the PI Dashboard
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.

Screenshot of the "Additional Resources" tab in the PI Dashboard
Example of the “Additional Resources” Tab

Questions?

Please contact datagrp@uw.edu to initiate a ticket with the Finance DATAGroup.

UWSDBDataStore Reorg on July 20, 2024

UWSDBDataStore Reorg on July 20, 2024

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

    • ON_TIME_FLG
    • P_ACCEPT_EXCL
    • P_INCOME_BASE_USD
    • PREFERRED_AID
    • PROF_JUDGE_TYPE
    • QA_SELECTED
    • QA_STATUS
    • QA_TRAN_NO
    • QA_DT_COMPLETE
    • QA_PAID_TRAN_NO
    • REV_REQ_DISPOS

 

Streamlining Security for Admissions Reporting in the BI Portal

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:

  1. Watch this Proper Data Usage (2-minute) video.

    Note: You will need to be connected to the VPN to access this video.

  2. 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.

Winter 2024 Content Manager Update

Hello IT Connect Content Managers,

Welcome to the Winter 2024 edition of the quarterly IT Connect Content Manager Update.

In This Issue 

WHAT’S NEW?

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.

Check out the I&T Governance content

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.
  • Leverage search enhancing functionality for IT Connect. IT Connect has functionality to help improve search performance for pages. Read about how to use tags, descriptions, and modify search weight of pages for the IT Connect search.

Write for search engines

DOCUMENTATION, TRAINING & CONSULTATIONS

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.

 

UWSDBDataStore Reorg on January 27, 2024

UWSDBDataStore Reorg on January 27, 2024

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:

Column
rev_req_dispos2
rev_req_type
rev_req_type2
routed_to
routed_to2
s_accept_excl
s_income_base_usd
saf_child_care
ap_display_sw
sap_ovrd_cred_aut
sap_ovrd_cred_spr
sap_ovrd_cred_sum
sap_ovrd_cred_win
sap_ovrd_cred_yr
pep_ovrd_cred_aut
pep_ovrd_cred_win
pep_ovrd_cred_spr
pep_ovrd_cred_sum
pep_ovrd_cred_ay
acad_plan_aut
acad_plan_win
acad_plan_spr
acad_plan_sum
acad_plan_ay
sap_sum_flg
sap_aut_flg
sap_win_flg
sap_spr_flg
sap_ay_flg
sum_credits_att
sum_credits_comp
sum_curr_cr_att
sum_curr_cr_comp
aut_credits_att
aut_credits_comp
aut_curr_cr_att
aut_curr_cr_comp
win_credits_att
win_credits_comp
win_curr_cr_att
win_curr_cr_comp
spr_credits_att
spr_credits_comp
spr_curr_cr_att
spr_curr_cr_comp
pep_sum_cred_req
pep_aut_cred_req
pep_win_cred_req
pep_spr_cred_req
sap_sum_cred_req
sap_aut_cred_req
sap_win_cred_req
sap_spr_cred_req
sap_ay_cred_att
sap_ay_cred_comp
sap_ay_cred_req
schol_elig_code
sng_aut_enroll_st
sng_dca_elig
sng_spr_enroll_st
sng_sum_enroll_st
sng_win_enroll_st
sf_aut_enrl_lock
sf_spr_enrl_lock
sf_sum_enrl_lock
sf_win_enrl_lock
sum_stat_cd
aut_stat_cd
win_stat_cd
spr_stat_cd
ay_stat_cd
sws_eligible
val_complt
verif_req_1
verif_req_2
verif_req_3
aid_from_parents
aid_hold_no
aid_prog_status
appeal_recd
appeal_recd2
appeal_reviewed
appeal_reviewed2
appli_date
appli_type
arm_date
arm_date_temp
audit_dt1
audit_dt2
audit_dt3
audit_dt4
audit_dt5
audit_dt6
audit_dt7
audit_dt8
basic_budget
books
budget_duration
child_care
corr_trans_cnt
corr_trans_sent
counselor_rev_dt
cps_ss_no
creation_date
date_last_update
dep_maint_allow
edit_dt
eval_spare_1
eval_spare_2
eval_spare_6
eval_spare_15
eval_spare_18
eval_spare_28
eval_spare_35
eval_spare_36
eval_spare_37
eval_spare_38
eval_spare_39
eval_spare_40
eval_spare_41
eval_spare_42
eval_spare_43
eval_spare_44
eval_spare_45
eval_spare_46
eval_spare_47
extra_books
extra_med_dent
extra_trans
faf_proc_date
fws_rev_req_recd
gsl_fees
indep_pet_rcvd
jacket_dt
no_of_other_exp
other_resource_no
outside_aid_amt
outside_aid_dt
over_awarded_amt
p_1040_cy_rcvd
p_1040_cy_sent
p_1040_ly_rcvd
p_1040_ly_sent
p_assets_rcvd
p_assets_sent
p_non_filer_recd
p_non_filer_sent
p_non_filer_doc
p_tax_return_dt
p_drt_rev_dt
pell_enroll_stat
pell_remain_mths
pell_last_yr_flg
pell_su_st_value
pell_su_as_of_dt
personal_exp
pkg_sum_enroll_st
pkg_aut_enroll_st
pkg_win_enroll_st
pkg_spr_enroll_st
tran_no_ovrd
qa_reviewed
remaining_need
rev_req_recd
rev_req_recd2
rev_req_review
rev_req_review2
rm_bd
s_1040_cy_rcvd
s_1040_cy_sent
s_1040_ly_rcvd
s_1040_ly_sent
s_assets_rcvd
s_assets_sent
s_computer_costs
s_g845_rcvd
s_g845_sent
s_inc_exc_rcvd
s_inc_exc_sent
s_ins_rcvd
s_ins_sent
s_non_filer_recd
s_non_filer_sent
s_non_filer_doc
s_sel_serv_rcvd
s_sel_serv_sent
s_ssn_rcvd_dt
s_ssn_sent_dt
s_tax_return_dt
s_drt_rev_dt
s_vet_rcvd_dt
s_vet_sent_dt
s_sub_ovrd_amt
s_usub_ovrd_amt
s_perk_ovrd_flg
s_perk_ovrd_amt

 

Complying with Federal Grant Reporting Requirements: The New SF425 Report

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:
  1. Enter the criteria into the prompts provided.
    Screenshot of sample criteria for the SF425 report in the BI Portal.
    Sample Report Criteria for the SF425 Report in the BI Portal

     

  2. Review the results, which are properly formatted for the SF425 form.
    Screenshot of sample results for the SF425 report in the BI Portal.
    Sample Results for the SF425 Report in the BI Portal

     

  3. If the results are correct, submit the form.

Questions?

Please contact help@uw.edu with “BI Portal” in the subject line.

Exploring Non-Numeric Grade Values: A New Academic Dashboard in the BI Portal

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.
Check out the Non-Numeric Grade Frequency Distribution dashboard in the BI Portal to learn more!

What are non-numeric grade values?

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.
  1. Display the Non-Numeric Grade Frequency Distribution page in the BI Portal.
  2. 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
  3. In the Grade filter, select Missing Grade Annotations. Use additional filters to refine your results, as needed.
    Sample Results for Missing Grade Annotations Filter
  4. 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
  5. To expose all available data, drill down to the Course Level.
    1. Hover over the Course Campus column to display the plus sign (+). Click the plus sign (+) to display the Course College column.
    2. 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
  6. 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.

IMPORTANT: Budget Planning for UW Google Shared Drives over 100GB limit

A version of this message was sent to managers of affected UW Shared Drives on November 28, 2023.

What’s Changing in DocuSign

eSignatures Updates

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.