Financial Data Converter Tool
The Financial Data Converter (FDC) tool will assist in converting FRS ledger and accounts to the new Financial Data Model (FDM). Use this to help translate FRS codes to the new FDM on updated Forms, or for entering correct Financial Activity Objects within the UR Financials system. NOTE: the FDC tool is located behind the University’s firewall. If you are accessing this tool from one of the wireless networks ( RC_Guest or MC_Guest) you must access using VPN. We will post additional information for using this application on mobile devices ( Android and iOS based) after completion of testing.
This has been updated as of September 11, 2014.
FRS/COGNOS to UR Financial FDM Report
The production versions of the FRS terms to UR Financials term reports are now located on COGNOS. You can access these reports based on your current security permissions thru the path below.
https://cognos.dw.its.rochester.edu, go into the #Financial reports/Workday folder, then FRS to Workday comparison reports- Public use folder
Budget values – FRS to Workday terms
Actual expenses – FRS to Workday terms
UR Financials Ledger Accounts, Spend & Revenue Category Listing
A new 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.
Data represented from Workday as of June 20, 2014.
FRS Account to UR Financials FAO Crosswalk
The preliminary cross reference between FRS accounts and Financial Activity Objects (FAOs) is available for use. The Excel spreadsheet allows users to look up their FRS accounts and determine the corresponding Workday Grant, Project, Operating Program, Gift, Loan Program, or Debt Service 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 April 24, 2014 (Open, Frozen status) — Does not include Net Investment in Plant (NIP) FRS accounts.
Some FRS accounts have been consolidated under one Financial Activity Object (FAO). This is by design as we move to the new Chart of Accounts in Workday.
FRS Subcode to Workday Worktags Crosswalk
The 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 project team will update the cross reference to reflect the changes.
Data represented from Cognos as of June 25, 2014 (FY2012, FY2013 and FY2014 with New subcode description or attribute change)
Some FRS subcodes have been consolidated under one Spend or Revenue Category. There are also new Spend and Revenue Categories that don’t currently exist in FRS as subcodes. This is by design as we move to the new Chart of Accounts in UR Financials.
The UR Financials Glossary found on the main page of each navigation tab is powered by the Data Cookbook. This business glossary defines words used in UR Financials’ reports delivered via Workday, or the Finance Data Warehouse. With this tool, you can search for Workday terms and general finance terms as well as translate UR Financials’ terms with comparable FRS terms.
For feedback or questions, please use the Contact Us link on the UR Financials website.