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.
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
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.
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!
“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.
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.
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 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.