Reconciling Payroll During Split Implementation

   Overview   

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.

1. Step 1

Employee Self Service homepage displayed with the Employee Self Service dropdown menu highlighted

First log onto https://financials.onesource.uga.edu/

Click the drop-down button next to the Employee Self Service menu.

2. Step 2

UGA Financials homepage displayed with the UGA Financials dropdown menu highlighted

Click the UGA Financials link.

3. Step 3

UGA Financials homepage displayed with the Query Viewer tile highlighted

Click the Query Viewer tile.

4. Step 4

Query Viewer page displayed with the Begins with field highlighted

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.

5. Step 5

Query Viewer page displayed with the Searh button highlighted

Click the Search button.

6. Step 6

Query Viewer page displayed with the HTML link highlighted

The Query Viewer will display the search results.

To run the report to an HTML page, click the HTML link.

7. Step 7

UGA_GL_LEGACY_ACCT_OBJECT_GL Visibility of Legacy Info query page displayed with the Accounting Period and Payroll fields highlighted

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.

8. Step 8

UGA_GL_LEGACY_ACCT_OBJECT_GL Visibility of Legacy Info query page displayed with the Department field highlighted

Enter your Department into the Department field.

Example shown here: enter "192%" into the Department field.

9. Step 9

UGA_GL_LEGACY_ACCT_OBJECT_GL Visibility of Legacy Info query page displayed with the View Results button highlighted

Click the View Results button.

10. Step 10

UGA_GL_LEGACY_ACCT_OBJECT_GL Visibility of Legacy Info query results displayed with the Excel SpredSheet link highlighted

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.
Print Article