Skip to content

Archives: Service News

News content type for use by UW-IT Services on IT Connect

DMS (DocFinity) Version 12.3 Upgrade PROD Released on June 21, 2023

Document Management System (DMS) released DocFinity v12.3 upgrade on June 21, 2023.

New Features:

  • DocFinity has added a new Document Viewer in addition to the existing Markup Viewer
    • The new Document Viewer is accessible via the “Document View” button or by changing default viewer in Preferences > Document View
    • Document Viewer is not a default and user needs to selected that option.
    • The new Document Viewer displays now supports all file types that can be rendered natively by the web browser (PDF, text, audio files, video files and more).
    • Additional differences between Document Viewer and Markup Viewer
      • PDFs larger than 30 MB will be displayed within Document Viewer without having to download the file
      • The entire PDF will be displayed, allowing you to scroll through pages rather than clicking page by page
      • Document loading time has been significantly improved in the majority of cases
    • Note: The new Document Viewer is not currently supported in the Safari web browser
  • A new Contact Support option has been added within the Help drop-down menu
    • Use this feature to submit UW Connect tickets for support
  • DocFinity now supports displaying the file’s MD5 Checksum as a metadata field

Notable Corrections

  • An issue that caused an error message to display when re-indexing a document has been resolved.  
    • An error would display if a user selected “Re-index”, but did not make any changes to the panel.  This is resolved.
  • An issue that prevented documents from displaying when the filename contained unsupported characters has been resolved.
    • Users will no longer be able to add files that contain unsupported characters in the document name.

EWS EVAL Release 22 is Now Available

Enterprise Web Services (EWS) has released an update in EVAL for multiple web services in support of UW Finance Transformation (UWFT). For an overview of how EWS is adapting to support UWFT, refer to EWS for Finance Transformation.

Final Scheduled EVAL Release

This is the final scheduled EWS EVAL release. The updates from this EVAL release will be deployed to PROD sometime after UWFT Go Live. Future releases are expected on an ad hoc basis.

What’s New in EWS Release 22

Web Service Overview of Release
FWS v2 (Outbound)
  • Removed inactive records from all FWS v2 /{Entity}/Branch and /{EntityHierarchy}/Branch resources. Inactive records are still available from the main resources.
  • Removed inactive records from the following FWS v2 resources. Inactive records will still be available from the main resources.
    • /AppropriationHierarchy/Tree
    • /FundHierarchy/Tree
    • /GiftHierarchy/Tree
    • /GrantHierarchy/Tree
    • /ProgramHierarchy/Tree
    • /ProjectHierarchy/Tree
    • /SpendCategoryHierarchy/Tree
  • Added the following endpoints for search within the FWS v2 /{Entity}/Branch and /{EntityHierarchy}/Branch resources:
    • Appropriation
    • Appropriation Hierarchy

For more information, refer to FWS Reference Data (Outbound) – Release 22. For support, refer to Support | FWS.
FWS Common Transactions (Inbound) There were no customer-facing changes for FWS Common Transactions (Inbound) introduced in this release. For support, refer to Support | FWS.
HRPWS v3 There were no customer-facing changes for HRPWS v3 introduced in this release. For support, refer to Support | HRPWS.

Action Required by 7/5/23 – Prepare for UWFT Go Live

Workday production data will become available at UWFT Go Live (7/6/23). To access this data, update the web service URL(s) for your solution(s) to point to the correct PROD environment(s). To learn more about web service cutover and key dates, refer to EWS for Finance Transformation.

Reminder – Request Access to FWS PROD

If you or your system/integration have access to an FWS environment today, this access will not automatically transfer to the FWS PROD environment at UWFT Go Live. You must specifically request access to this new PROD environment. For more information, refer to Preparation for UWFT Go Live – Request Access to FWS PROD by 6/2/23.

Join Us for FWS Inbound Office Hours

FWS Inbound Subject Matter Experts are available every Friday from 10:00am to 11:00am to answer your questions. If possible, please submit questions ahead of time to fws-support@uw.edu.

You can either sign up ahead of time or drop by during the session:

Preparation for UWFT Go Live – Request Access to FWS PROD by 6/2/23

The Enterprise Web Services (EWS) team is preparing to transition Financial Web Service (FWS) access for UW Finance Transformation (UWFT) Go Live.

Changes to FWS Environments at UWFT Go Live

When UWFT goes live, FWS v1 Outbound will freeze and FWS v2 Outbound and FWS Inbound will move to Production. At a high-level, these changes are summarized as follows:

FWS Offering FWS Environments Today FWS Environments at UWFT Go Live
FWS v1 Outbound Production (PROD) Still available, but data will be frozen.
FWS v2 Outbound Evaluation (EVAL) EVAL (Workday Sandbox tenant)

 

PROD (Workday UW tenant)
FWS Inbound Evaluation (EVAL); End-to-End Testing (E2E)

If you or your system/integration have access to an FWS environment today, this access will not automatically transfer to the FWS PROD environment at UWFT Go Live. You must specifically request access to this new PROD environment.

Requirements for X.509 Certificates for FWS v2 Outbound PROD

To access FWS v2 Outbound PROD, an X.509 certificate is required. The X.509 certificate must meet one of the following criteria in order to access FWS PROD at Go Live:

  • System/integration-based (e.g., coral-prod.engr.washington.edu)
  • Department-based (e.g., physoffice.phys.washington.edu)

If your X.509 certificate meets this criteria, you can reuse it when you request access to the PROD environment; however, please be aware that access to FWS v2 Outbound EVAL was previously provisioned for NetIDs (e.g., jdoe) and individual-based X.509 certificates (e.g., jdoe.cac.washington.edu)—in this case, a new certificate is required.

Action Required by Friday 6/2/23

Over the last three weeks, the EWS team has reached out to contacts who currently have access to FWS v2 Outbound and FWS Inbound EVAL environments to inform them that they must request access to PROD. If you have requested access (and updated your x.509 certificate, if needed) in response to this outreach, no further action is required.

However, if you have not received this outreach or have not yet responded and need access to FWS PROD at UWFT Go Live, please take the following action by EOD Friday, 6/2/23:

If you need access to… Then…
FWS v2 Outbound PROD
  1. Ensure you have an X.509 certificate that is system, integration, or department-based.
  2. Request access for FWS v2.
FWS Inbound PROD Request access for FWS v2.

If you have questions or concerns, please email fws-support@uw.edu.

EDW for Finance Transformation Release 21 is Now Available

Enterprise Data Warehouse (EDW) has released an update in UWODS and WDFinDataMart in support of UW Finance Transformation (UWFT). For an overview of how EDW is adapting to support UWFT, refer to EDW for Finance Transformation.

Monthly Scheduled Releases

Updates to UWODS and WDFinDataMart are released on the same monthly schedule. This allows us to better synchronize with Enterprise Data Platform’s release schedule for Finance Transformation. For more information, refer to the Data Availability Timeline.

Updated access to UWODS and WDFinDataMart data

If you HAVE ACCESS to EDW HR/Payroll and or Finance data in PRODUCTION today, you now have access to the same type of data in UWODS and WDFinDataMart without requiring a special request to access. We have updated the Getting Started l UWODS and Getting Started l WDFinDataMart guides accordingly.

What’s New in EDW Release 21

Database

Overview of Release
UWODS This release includes:

  • No new tables were added.
  • 38 new columns were added to existing tables.
  • Introduced Breaking Changes by renaming and removing fields in multiple tables.

New or Revised Frequently Asked Questions (FAQ) available –

  • Why are the PayComponentEarning columns in the PayrollResultLine view null? Should I use PayComponentGroup instead?

See FAQ | UWODS to learn more about this updated FAQ!

Known Data Issues are as follows:

    • Some Tables are missing data. Refer to Tables Missing Data | UWODS
    • Truncated data due to bad test data not following expected standards
    • Some definitions are unknown

For more information, refer to UWODS – Release 21. For support, refer to Support l UWODS.
WDFinDataMart This release includes:

  • Persistent keys have been implemented for 43 dim tables in WDFinDataMart. This will cause a one-time change to the SIDs in all of the dim tables.
  • There were no Breaking Changes introduced for this release.

Known Data Issues

  • Some Tables are missing data. Refer to Tables Missing Data | WDFinDataMart
  • Truncated data due to bad test data not following expected standards
  • Some definitions are unknown

For more information, refer to WDFinDataMart – Release 21. For Support, refer to Support l WDFinDataMart

EDW Release Schedule

We have already started working on next month’s release. Bookmark Release Notes | UWODS and Release Notes | WDFinDataMart to follow our progress.

Support Available to Transition Human Resource/Payroll Data from ODS to UWODS

When UW Finance Transformation (UWFT) goes live, the current state ODS database will be frozen and the UWODS database will be introduced. For more information, refer to Transitioning HR Data from ODS to UWODS.

Guidance for Writing Code Using Finance Data in WDFinDataMart and UWODS

We have provided a link on the UWODS and WDFinDataMart Sample Queries pages that take you to a resource where you can find sample queries for common finance related questions. This resource is under construction and restricted to current EDW and BI Portal finance data viewers. Use at your own risk.

You will find this link under the Finance Data Concepts and Queries section on these pages:

Join Us for Enterprise Reporting and Analytics (ERA) Office Hours

EDW Subject Matter Experts are now available during the Enterprise Reporting and Analytics (ERA) Office Hours every Friday from 9 to 10.
Please drop in to ask your UWODS and WDFinDataMart questions. You can either sign up ahead of time or drop by during the session:

EDW Data Load Status for Production and Test Environments

Based on our requests from customers, we have published a stand alone EDW Data Load Status page for both EDW Production and Test environments. This replaces the Data Load Status information that was previously embedded in the EDW help page. Please update your bookmarks accordingly.

EDP for FT Resource Available

EDP for Finance Transformation offers services that reflect the Foundation Data Model (FDM) and Finance Reference Data; however, because the changes to finance data are so transformational, we are not able to answer questions that are specific to your unit or provide guidance on how to use this data. Fortunately, there are various UWFT resources available to help with this aspect of the transformation and we’ve compiled a list of these resources on the Resources for Understanding Finance Transformation page. We will update this page as more resources are identified, so please watch for updates.

EWS EVAL Release 21 is Now Available

Enterprise Web Services (EWS) has released an update in EVAL for multiple web services in support of UW Finance Transformation (UWFT). For an overview of how EWS is adapting to support UWFT, refer to EWS for Finance Transformation.

Monthly Scheduled Releases

  • EVAL: Updates to EVAL environments for all EWS services are released on the same monthly schedule. This allows us to better synchronize with Enterprise Data Platform’s release schedule for Finance Transformation. For more information, refer to the Data Availability Timeline.
  • PROD: Updates to PROD environments for all EWS services reflect changes from the previous month’s EVAL release (for example, if EVAL reflects Release 21, then PROD reflects Release 20).

What’s New in EWS Release 21

Web Service Overview of Release
FWS v2 (Outbound)
  • Introduced Breaking Changes by removing the /CatalogItem resource and any associated entities.
  • Added search parameters to the following resources: /CustomListValue, /LedgerAccount, /LedgerAccountSummary, and /Location.
  • Added new endpoints for search within the following resources: /WorkdayHierarchy and Generic Search (/SearchID).
  • Fixed a few field HREFs to point to the correct endpoints in the following resources: /Gift and /SupplierContract.
  • Fixed mappings for a couple fields in the /Award resource.
  • Fixed an issue in the /Award resource that was preventing some records from updating correctly.
  • Fixed an issue in some hierarchy-based resources that was displaying the Top-Level Hierarchy value incorrectly.
  • Fixed an issue in many resources that was allowing ‘null’ Inactive records to appear alongside ‘Active’ records.
  • Updated a number of fields across the web service to allow for a “null” state.
  • Updated Swagger documentation for the /SearchID resource to explain the result maximum.
  • Updated Swagger metadata for all resources.

For more information, refer to FWS Reference Data (Outbound) – Release 21. For support, refer to Support | FWS.
FWS Common Transactions (Inbound)
  • Fixed line number ordering for ISD transactions. Previously, the line numbers were off by one.

For more information, refer to FWS Common Transactions (Inbound) – Release 21. For support, refer to Support | FWS.
HRPWS v3
  • Fixed an issue in many resources that was allowing ‘null’ Inactive records to appear alongside ‘Active’ records.

For more information, refer to HRPWS v3 – Release 21. For support, refer to Support | HRPWS.

Join Us for FWS Inbound Office Hours

FWS Inbound Subject Matter Experts are now available every Friday from 10:00am to 11:00am to answer your questions. If possible, please submit questions ahead of time to fws-support@uw.edu.

You can either sign up ahead of time or drop by during the session: 

Change to EWS EVAL Server Endpoint

There were previously two endpoints for the EWS EVAL Server: https://it-wseval1.s.uw.edu/ and https://wseval.s.uw.edu/. We have implemented a new load balancer, which removed it-wseval1 as an available endpoint. This change took effect in EWS EVAL environments on 5/25/23. Any configurations or bookmarks that still point to it-wseval1 will break.

Recommended Action – Evaluate EVAL Endpoints

If you haven’t done so already, please evaluate your configurations or bookmarks to ensure they point to the correct endpoint: https://wseval.s.uw.edu/. If they are already pointing to wseval, no action is required.

For support with this change, contact ews-support@uw.edu.

Resource Worktag Error

If you’re receiving a missing Resource worktag error when posting common transactions via FWS Inbound, your system or integration may be impacted by the most recent Tenant 5 build, which became available in UW13 on 4/17/23. In this case, you will need to update your system remediation and integration and then retest. To learn more, refer to Resource Worktag: Updated System Integration Requirements.

Transitioning Access for FWS v2 Outbound and FWS Inbound to Production

We are preparing to transition FWS v2 Outbound and FWS Inbound access for Go Live and will be reaching out to users to ensure access is provisioned correctly. Please watch for more information via email next week.

HRPWS v3 EVAL for UWFT Environment

We have set up an HRPWS v3 EVAL environment that points to Workday UW13 data to support UWFT. We encourage all current HRPWS users to connect their current solutions to this environment before Go Live to become familiar with how the data will change and to adapt if needed.

UWSDBDataStore Reorg on June 3, 2023

UWSDBDataStore Reorg on June 3, 2022

The student database (SDB) will go through a reorganization on June 3, 2022 which will cause changes in the Enterprise Data Warehouse database, UWSDBDataStore. These changes to the objects will be available in the UWSDBDataStore on June 5. 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 Updated – 06.01.23

 

Columns to be Added

Table Column DataType
BUDGET_RESOURCES BR_PPLUS_LOAN_FEE int
BR_GPLUS_LOAN_FEE int
DL_SUPL_PLUS SP_PREV_CR_STAT char(1)
SF_EDIT_DESC SF_ED_EDIT_CD2 char(3)
SF_ED_EDIT_CD3 char(3)
SF_ED_HOLD_CD2 char(2)
SF_EVALUATION UNUS_CIRCUMSTANCE char(1)
SF_FEES SFF_TERM char(1)
SFF_CLASS tinyint
SFF_FEES_SPARE1 tinyint
SFF_FEES_SPARE2 char(2)
SFF_FEES_SPARE3 int
SF_HISTORY UNACC_YTH_HISTORY char(1)
UNACC_YTH_HIST_DT datetime
UNUS_CIRC_HISTORY char(1)
UNUS_CIRC_HIST_DT datetime
COMP_DEP_HISTORY char(1)
SF_ROOM_BOARD_TBL RB_HOUSING_AMT int
RB_FOOD_AMT int
SR_ADM_APPL UW_PROMISE char(1)
STUDENT_1 DISAB_START_YR smallint
DISAB_START_QTR tinyint
DISAB_PR_BEG_YR smallint
DISAB_PR_BEG_QTR tinyint
DISAB_PR_END_YR smallint
DISAB_PR_END_QTR tinyint
DISAB_RC_BEG_YR smallint
DISAB_RC_BEG_QTR tinyint
DISAB_RC_END_YR smallint
DISAB_RC_END_QTR tinyint
S1_BOOLEAN_06 bit
S1_BOOLEAN_07 bit
S1_BOOLEAN_08 bit
SYS_TBL_63_NONTUIT_CHARGES NONT_MEDICINE bit
SPARE_BOOLEAN_1 bit

Column Renames (all currently not in use)

Table Existing Name New Name
SDBDB01  G_SR_FLAG5 G_SR_BATCH_IP
SR_MAJOR_CODE MAJOR_TYPES_20 MAJOR_EXCHANGE
STUDENT_1 S1_BOOLEAN_13 DISAB_RCLOAD
S1_BOOLEAN_14 DISAB_ALTFMT

Columns with data type changes

Table Column DataType
FINAID_DOCS FD_DOC_KEY char(30)

 

ACTION REQUIRED to preserve content in UW Google Shared Drives (Reminder #1)

A version of this message was sent to affected audiences on 5/2/2023.

 

Please note: These changes affect only UW Google Shared Drives. These changes do not affect your consumer Google Drive or personal UW Google Drive. 

What is happening and when

UW Google Shared Drives (Shared Drives) that do not have a current UW employee with a UW email address in the Manager role have been restricted beginning March 22, 2023. (The Manager role is the highest level of permissions in a Shared Drive.) 

You will still be able to view and download existing files in restricted Shared Drives, but you will be unable to add new files to restricted Shared Drives. 

Any Shared Drives that are still restricted in August 2023, including all files within, will be permanently deleted beginning August 29, 2023.   

Important Dates 

  • March 22, 2023: Shared Drives without a current UW employee’s UW Google account in the Manager role were restricted.
  • Restricted Shared Drive names were changed on March 22 to indicate that they are now restricted.
  • (PENDING_DELETE_on_8-29-2023)– is appended to the name of the restricted Shared Drive.
  • Files in a restricted Shared Drive can still be accessed and the content downloaded, but the Shared Drive will not accept any further uploads or file updates.
  • August 29, 2023: Restricted Shared Drives and all files within them will be permanently deleted, with no option for recovery.

What you need to do 

If you do not want the restricted Shared Drives deleted, add a current UW Employee’s UW Google account (associated with their UW NetID) in the Manager role. 

If you no longer need the Shared Drive, download the files you wish to keep from a Shared Drive. 

Shared Drive policies 

The Shared Drive lifecycle policy now requires that all Shared Drives must have at least one current UW employee’s UW Google account in the Manager role. For more information regarding related UW policies, please see the following resources: 

What to do if you need help 

UW Google Changes project is the best resource for more information on the status, milestone and details of the project. 

We recommend that you consult first with your local IT support group, as they are the experts on your data and technology needs. If this is not an option for you, reach out to UW-IT at help@uw.edu or 206-221-5000. 

 

Thank you for your understanding and support as the University of Washington adjusts to these significant changes. 

ACTION REQUIRED: Use of UW Google with Shared UW NetIDs ends August 29, 2023

A version of this reminder message was sent to owners and administrators of Shared UW NetIDs with a UW Google account on April 25, 2023. Messages included a customized list of Shared UW NetIDs, owned or administered by the recipient, and associated with UW Google services.

 

As communicated in March 2022, due to changes to the UW Google service, the use of UW Google with Shared UW NetIDs will be eliminated, effective August 29, 2023. The UW Google service includes YouTube, among other frequently used tools. Owners of Shared UW NetIDs with UW Google service accounts must migrate data from these services or delete data that is no longer needed (according to the UW Records Retention schedule and the UW Medicine Records Retention schedule).

Any data that is not removed from these services will be deleted after August 29, 2023.

Please note that Shared UW NetIDs are not being deleted; only UW Google accounts and services for Shared UW NetIDs are being deleted.

What is happening?

In 2021, Google announced significant changes to their Google Workspace for Education product and how it is licensed. These changes, detailed on IT Connect, have major implications for UW-IT’s ability to provide UW Google (aka Google Workspace for Education, formerly known as G Suite and Google Apps) to the UW.

Google now considers the use of Shared UW NetIDs — widely used to support teaching, student activities, research, public outreach and business processes across the UW and with external partners — a violation of its Acceptable Use Policy and will be prohibiting their use. To comply with Google’s new requirements, the UW must discontinue the use of UW Google with Shared UW NetIDs.

As a first step toward compliance with Google’s new requirements, UW-IT discontinued the creation of new UW Google accounts for Shared UW NetIDs in August 2021. Owners and administrators of Shared UW NetIDs with existing UW Google accounts should begin planning to migrate data from these accounts.

What do I need to do?

  1. Review the lists of Shared UW NetIDs that you administer at the end of this message.
  2. Create a migration plan for email, files and business processes that must be retained.
  3. Review alternatives to UW Google for Shared UW NetIDs.

If the UW Google account is no longer needed, the owner should revoke access to UW Google services for the account using the Provisioning Request Tool (PRT). This will delete the UW Google account and data.

Is it possible to pay to keep services associated with Shared UW NetIDs?

No, it is not possible. The removal of Shared UW NetIDs from use with Google services is driven by the requirement to comply with Google’s new terms of service, which define the use of Shared UW NetIDs as a violation of Google’s acceptable use policy.

When do I need to migrate my data?

All data that needs to be preserved in UW Google accounts for Shared UW NetIDs must be moved to a new location by August 29, 2023. All UW Google accounts and data for Shared UW NetIDs will be deleted after that date. UW-IT recommends that you begin work now to create a data migration plan.

Can UW-IT help me migrate my data?

Unfortunately, due to limited resources, UW-IT is unable to offer individualized data migration consulting or assistance. Your department’s IT group is your best resource for assistance and recommendations.

Review alternatives to UW Google for Shared UW NetIDs and data migration guides

Can I stop receiving these reminders?

You will receive periodic reminders about moving content from the affected UW Google accounts. If you prefer not to receive these messages, the owner of a Shared UW NetID can delete the UW Google account for a Shared UW NetID using the Provisioning Request Tool (PRT) by clicking “Revoke” next to the service. This will delete the UW Google account and all data.

Please note that only an owner of a Shared UW NetID will see it listed in the PRT and can act; Shared UW NetID administrators will not see the Shared UW NetID listed in the PRT and cannot perform this action.

Questions?

Please contact the UW-IT Technology Service Center at help@uw.edu or 206-221-5000 with questions about the UW Google Changes Project.

New Version of HRP Web Service Aligns with Finance Transformation

We recently retired HRP Web Service (HRPWS) v2 and deployed v3 to PRODUCTION. This change better aligns HRPWS with the UW Finance Transformation (UWFT).
Thank you to all our users for adapting to this change. We appreciate your support and partnership!

Please ensure all current and future integrations point to HRPWS v3!

Check out the new customer portal!

We’ve updated the HRP Web Service l HRPWS customer portal to reflect the retirement of v2 and introduce some revised service parameters:

  • Removed v2 content to streamline the customer experience.
  • Updated the Memorandum of Understanding l HRPWS to communicate key resources, environment considerations, and release policies.

Please watch this space for updates. To do so, display the portal, click Watch in the upper right corner, and then select Watch all content in this space to be notified of updates related to HRPWS.

Engage with us!

We want to hear your questions, comments, and solutions! Please engage with us via the following channels:

  • HRP Web Service | HRPWS customer portal – We’re always looking to improve our documentation. Please use the page comment feature to provide feedback on any page within this space.
  • hrpws-users Mailman List – Subscribe to receive important communications and maintenance notices for HRPWS.
  • Support | HRPWS – Refer to this page for guidance on who to contact for various support scenarios.

EDW for Finance Transformation Release 20 is Now Available

Enterprise Data Warehouse (EDW) has released an update in UWODS and WDFinDataMart in support of UW Finance Transformation (UWFT). For an overview of how EDW is adapting to support UWFT, refer to EDW for Finance Transformation.

Monthly Scheduled Releases

Updates to UWODS and WDFinDataMart are released on the same monthly schedule. This allows us to better synchronize with Enterprise Data Platform’s release schedule for Finance Transformation. For more information, refer to the Data Availability Timeline.

What’s New in EDW Release 20

Database

Overview of Release
UWODS This release includes:

  • 2 new tables containing 33 columns and 119 columns were added to existing tables.
  • Introduced Breaking Changes by renaming and removing fields in multiple tables.  

New or Revised Frequently Asked Questions (FAQ) available –

See FAQ | UWODS to learn more about this updated FAQ!

Known Data Issues are as follows:

    • Some Tables are missing data. See: Tables Missing Data | UWODS
    • Truncated data due to bad test data not following expected standards 
    • Some definitions are unknown

For more information, refer to UWODS – Release 20. For support, refer to Support l UWODS. 
WDFinDataMart This release includes:

  • 3 new tables with 7 fields each, including:  
    • RecordLoadDttm
    • RecordUpdateDttm
  • Updates to 2 existing tables and 2 existing views
  • 2 new views based on factPayrollJournalLineUnfiltered
  • Introduced Breaking Changes by renaming and removing fields in multiple tables, including: 
    • Rename of factPayrollJournalLine to factPayrollJournalLineUnfiltered

New or Revised Frequently Asked Questions (FAQ) available – See FAQ l WDFinDataMart to learn more about this updated FAQ!

Known Data Issues

For more information, refer to WDFinDataMart – Release 20. For Support, refer to Support l WDFinDataMart

EDW Release Schedule

We have already started working on next month’s release. Bookmark Release Notes | UWODS and Release Notes | WDFinDataMart to follow our progress.

Support Available to Transition Human Resource/Payroll Data from ODS to UWODS

When UW Finance Transformation (UWFT) goes live, the current state ODS database will be frozen and the UWODS database will be introduced. For more information, refer to Transitioning HR Data from ODS to UWODS.

New Emerging Guidance for Writing Code Using Finance Data in WDFinDataMart and UWODS

We have provided a link on the UWODS and WDFinDataMart Sample Queries pages that take you to a resource where you can find sample queries for common finance related questions. This resource is under construction and restricted to current EDW and BI Portal finance data viewers. Use at your own risk.

You will find this link under the Finance Data Concepts and Queries section on these pages:

Join Us for Enterprise Reporting and Analytics (ERA) Office Hours

EDW Subject Matter Experts are now available during the Enterprise Reporting and Analytics (ERA) Office Hours every Friday from 9 to 10.
Please drop in to ask your UWODS and WDFinDataMart questions. You can either sign up ahead of time or drop by during the session:

EDW Data Load Status for Production and Test Environments

Based on our requests from customers, we have published a new stand alone EDW Data Load Status page for both EDW Production and Test environments. This replaces the Data Load Status information that was previously embedded in the EDW help page. Please update your bookmarks accordingly.

New EDP for FT Resource Available

EDP for Finance Transformation offers services that reflect the Foundation Data Model (FDM) and Finance Reference Data; however, because the changes to finance data are so transformational, we are not able to answer questions that are specific to your unit or provide guidance on how to use this data. Fortunately, there are various UWFT resources available to help with this aspect of the transformation and we’ve compiled a list of these resources on the Resources for Understanding Finance Transformation page. We will update this page as more resources are identified, so please watch for updates.