A query has been built to use to help reconcile your payroll information during the split between the UGA Financial Management System launch in July 2018 and the OneUSG Connect go-live in December 2018.
This query is the UGA_GL_LEGACY_ACCT_OBJECT and it is run using the Query Viewer tool inside the UGA Financial Management System (FMS). Once you have retrieved the information from the FMS, you can save the data in an Excel spreadsheet.
In this article, you will learn the steps to run a query to help in reconciling payroll during the Split Implementation period, July to December 2018. The query you will run is UGA_GL_LEGACY_ACCT_OBJECT.
First log onto https://financials.onesource.uga.edu/
Click the drop-down button next to the Employee Self Service menu.
Click the UGA Financials link.
Click the Query Viewer tile.
Enter all or the first part of the Query name in the begins with field.
Enter "UGA_GL_LEGA" to search for the UGA_GL_LEGACY_ACCT_OBJECT query.
Click the Search button.
The Query Viewer will display the search results.
To run the report to an HTML page, click the HTML link.
You will see parameter fields that will help you retrieve information specific to you.
Note: The Accounting Period in Financials is based on the Fiscal Year, not the Calendar Year. Ex. 02 = August.
Payroll has 4 options to filter by payroll type that all start with SI for Split Implementation: SIAC = Academic, SIHO = Hourly, SIMO = Monthly, SISA = Salaried.
Enter your Department into the Department field.
Example shown here: enter "192%" into the Department field.
Click the View Results button.
The information for the criteria you specified is returned.
Click the Excel SpreadSheet link to download the data to Excel. An excel file will be created with this data.