FRS Subcode to Workday Worktags Crosswalk – Update

An updated cross reference between FRS subcodes and Workday worktags has been added to this website. The Excel spreadsheet allows users to look up their favorite FRS subcodes and determine the corresponding Workday Spend Category, Revenue Category, and Ledger account. As additional subcodes are added to FRS, the UR Financials team will update the cross reference to reflect the changes.

Refer to the crosswalk spreadsheet here, under the FRS Subcode to Workday Worktags Crosswalk heading. Data represented from Cognos as of June 25, 2014 (FY2012, FY2013 and FY2014 with New subcode description or attribute change)

Feedback or questions, please use the Contact Us link on the UR Financials website

UR Financials Ledger Accounts, Spend & Revenue Category Listing – Just Updated!

An updated job aid is available that shows ledger accounts and their associated spend or revenue categories, if applicable.  This Excel spreadsheet allows users to look up ledger accounts and categories based on the nature of the transaction. As additional ledger accounts and categories are created, the UR Financials project team will update this job aid to reflect those changes.

Refer to the crosswalk spreadsheet here.  Data represented from Workday as of June 20, 2014.

For feedback or questions, please use the Contact Us link on the UR Financials website.

The FRS Account to UR Financials FAO Crosswalk – Update

The preliminary cross reference between FRS accounts and Financial Activity Object (FAO) is available for use. The Excel spreadsheet allows users to look up their FRS accounts and determine the corresponding UR Financials FAO. As additional accounts are added to FRS, the UR Financials project team will update the cross reference to reflect the changes.

FRS Accounts pulled from Cognos as of 4/24/14 (Open, Frozen status) — Does not include Net Investment in Plant (NIP) FRS accounts.

Refer to the crosswalk spreadsheet here.

Feedback or questions, please use the Contact Us link on the UR Financials website

UR Financials Project Prospective

Entering 2014, we launch into the formal Test phase of the project.  During the formal Test phase, we will be including some of the Special Interest Group members to test Workday to ensure that the design meets their unique needs.  We will be executing four iterations of testing:

  1. Test Cycle 1 (Component) – in test cycle 1, we will be testing components of the design to make certain that, as individual pieces, they perform as expected.
  2. Test Cycle 2 (End-to-End) – test cycle 2 will link together test scenarios from test cycle 1 to be a comprehensive end to end test of the business process.  This test cycle validates that all the individual components work properly together.
  3. Test Cycle 3 (Day in the Life) – test cycle 3 will be emulating “life in a Workday environment”.  User security will be tested to verify that security roles can perform the appropriate functions when Workday is turned on.  Additionally, over 100 interfaces will be tested and posted into Workday to validate that all are ready for go-live.  Reports will be used to verify the results in Workday.
  4. Test Cycle 4 (Workday 22) – on March 22, 2014, we will be receiving the release of Workday that we will go live on.  Workday 22 has some critical features that need to be functioning as expected.  The two major features are the multi-company design (allowing us to have balanced set of books at the divisional level, yet report as one legal entity) and enhanced reporting features.  We will test all new functionality delivered in Workday 22, as well as re-test all other functionality that we will go live with.

Besides testing in this phase, we will be finalizing the forms revisions, develop the training material, establish end user security for go-live, and develop a Workday Data Governance structure.  It will be a busy 4 months, but necessary to be ready for training delivery in the May-July time as well as preparing for go-live.

As always, we appreciate all the feedback that we have received and are grateful for your support as we all partake on this journey.   Collectively, we can make the university “ever better”.

The UR Financial Project Team

UR Financials Overview

GL/COA team co-leads Kathy Strojny and Patty Stevens led two informational sessions at the Simon School of Business and the Medical Center on November 5th and 8th. The presentations provided a general overview of the UR Financials project and timeline. They also introduced the Financial Data Model (FDM), which is the replacement for the FRS chart of accounts, and worktags, which are the underlying building blocks. The sessions were well-attended and a dynamic discussion followed the presentation of materials. The slides, which include a crosswalk from FRS to Workday, are posted under Resources > UR Financials Project General Information.

FRS Subcode to Workday Worktags Crosswalk

It’s here!

The preliminary cross reference between FRS subcodes and Workday worktags is available for use.  The Excel spreadsheet allows users to look up their favorite FRS subcodes and determine the corresponding Workday Spend Category, Revenue Category, and Ledger account.  As additional subcodes are added to FRS, the UR Financials team will update the cross reference to reflect the changes.

Refer to the crosswalk spreadsheet here.

Feedback or questions, please use the Contact Us link on the UR Financials website

Workday Highlight – The Integrated Glossary

The Glossary provided for this project is a helpful tool that defines terms that are used in the project with special consideration for the upcoming Workday system.  Team Leads, who are experts in these concepts, vetted each definition and will continue to offer their insight.  Scroll through the Glossary to discover terms that are unique to the Workday system – such as “worktag” or a new definition for “cost center”.  Both of these terms (and there are others!) represent concepts that are brand new to the University’s financial data environment.  If you’re unfamiliar with how FRS concepts translate to Workday, the Glossary can help you untangle the terms.

Large, mutli-team projects like this one bring together people who are not familiar with the language of each other’s work.  For folks who do not have a technical background, the Glossary defines “financial data converter” and “bi-directional translation”.  For non-finance folks, “F&A rate” is conveniently defined. We aim for the Glossary to provide a common ground for the University community and future Workday users.

If you see a term that you’d like more clarification on or if you’d like to have terms added to our Glossary, please use the Contact Us tab to relay your requests.  The Glossary will grow and change throughout the project.  Your input is always welcome in the process.

Workday Highlight – Technical Management & Integration

The Technical Management and Integration team within the UR Financials team holds a special responsibility for the life of the project: to transition from the Financial Records System (FRS) to the incoming Workday system.  With this introduction are tireless efforts of research, testing, revising and documentation.  Over the forty years of its existence, FRS created hundreds of lines and links to auxiliary systems such as HRMS, Cognos, COEUS and FAMIS, among others.  Those links require careful attention to ensure that data is transmitted seamlessly and that all business processes may be maintained over the transitional period and beyond.  Once the links are created and tested, the Integration team will continue to support the Financial Data Converter to maintain the translation of information from FRS to Workday and from Workday to FRS.

Though often surrounded by the designs, architecture plans and risk-mitigation procedures, the UR Financials Integration team stands front and center with their meticulous and expert utilization of our data and we salute them for their efforts!

Workday Highlight – Reporting & Analytics

“Delivering the right information at the right time and in the right format” is a general Reporting and Analytics mantra.  With the Workday application, users will be able to leverage a range of reporting capabilities to enable quicker and more informed decision making.  Workday calls this functionality “actionable insights” and the UR Financials Reporting Team has been working on a plan to translate the FRS and Cognos reporting methods into Workday’s “actionable insights”.

Since the onset of the project, the UR Financials Reporting Team has reviewed hundreds of Cognos reports, met with nearly twenty groups across the University and started to develop an initial reporting design for the Workday application.  With an exceptional amount of information already gathered, the team has immediate plans to incorporate more user feedback and data to evolve the design to match University needs.  Overall, with the primary goal of the UR Financials Reporting Team to improve the current reporting structure and enable Workday “actionable insights”, a great foundation has been established and we look forward to building upon it.

Plan Phase Completed!

The UR Financials project team has successfully completed the Plan phase of the project.  During this phase, the team completed the following deliverables:

  • Documented business requirements that the current system (FRS) can perform.  Based on our current knowledge of the new system (Workday), we identified each requirement as a “Fit” (Workday can satisfy the requirement) or as a “Gap” (Workday cannot satisfy the requirement).
  • Documented business process improvement opportunities.  Based on functionality available in Workday or based on best practices, the team has identified opportunities to improve process efficiencies or internal controls.  Business cases will be developed and reviewed with the Finance Advisory Committee to determine the path forward.
  • We have identified over 1000 reports that are used today.  We expect that 80% will be satisfied by standard Workday reports, and the remaining 20% will be custom Workday reports.
  • Today, there are over 100 interfaces into FRS.  We expect approximately 60% will convert to the new Workday Chart of Accounts (COA) with the remaining 40% continuing to send FRS COA format.  The 40% FRS COA formatted interfaces will be converted to the Workday COA format via an internal system.
  • Developed the strategy for change management as well as increased our communications to impacted audience via enhanced website content.

This was a concerted effort by all members of our project team.  The efforts spent on this crucial stage of the project will pave a solid path for future accomplishments and University benefits.

Workday Highlight – General Ledger / Chart of Accounts

With the upcoming installment of Workday as the new Financial Records System, a thorough undertaking has been initiated regarding the University community’s usage of the Chart of Accounts.  The General Ledger / Chart of Accounts group within the UR Financials project is working collaboratively with other teams and consultants in the project to formulate the best solutions for account numbers and design for Workday and beyond.  Institutional, divisional and departmental reporting needs are being examined with great care and attention to the many aspects that go into creating the Chart of Accounts as well as its usage and upkeep.  Stay tuned for future updates regarding the UR Financials project team progress and, in particular, the General Ledger / Chart of Accounts group.

Workday Highlight: Accounts Payable & Preferred Payment Methods

Workday allows for a preferred payment type for suppliers.  As Accounts Payable works with suppliers, available methods for payments are established.  For example, a given supplier may accept checks, money orders, electronic Automatic Clearing House (ACH) or credit card payments.  As a result of communications between Accounts Payable and this particular supplier, it’s determined that ACH would be the method of choice.  Workday’s flexibility allows Accounts Payable to set ACH as this supplier’s preferred payment option.  This method will be used for future payments unless an accepted alternative is specified on the invoice or payment request.  This added functionality creates a cooperative environment between the University and its suppliers and allows for smoother transactions.

Thank you for your participation and support.  Stay tuned for more announcements and updates.