�г��ٸ���Ƶ

Introduction

Last modified: November 2, 2010

�г��ٸ���Ƶ System of Georgia (�г��ٸ���Ƶ) institutions employ several financial management and information software systems to perform daily finance and business functions. Historically, all �г��ٸ���Ƶ institutions, except for the four research universities, have used common systems.

Of these four, the �г��ٸ���Ƶ of Georgia operates its own legacy systems for finance, payroll, human resources, and student information. The Georgia Institute of Technology, Georgia State �г��ٸ���Ƶ, and the Medical College of Georgia use a combination of legacy systems and new client server systems. Each of these three institutions now uses PeopleSoft for finance and/or human resources, and uses, or plans to use, BANNER for student information.

Note: Information regarding the systems in use at the �г��ٸ���Ƶ of Georgia, the Georgia Institute of Technology, Georgia State �г��ٸ���Ƶ, and the Medical College of Georgia may be obtained from those institutions.

The 31 teaching institutions that make up the balance of the �г��ٸ���Ƶ System of Georgia have implemented BANNER as their student information system and operate it independently, although plans are currently underway to initiate centralized hosting of database management and to create a single application model. PeopleSoft financial and human resources systems were implemented at these 31 institutions, along with the Skidaway Institute of Oceanography and the �г��ٸ���Ƶ System Office (USO), under the project name �г��ٸ���Ƶ�GeorgiaFIRST�г��ٸ���Ƶ� beginning in January 1998. These systems are centrally hosted, and all institutions that participated in this project use a single application model.

13.1 Implementation of Software Changes to Financial Accounting Systems

Last modified: November 2, 2010

Institutions using computer applications for maintaining financial accounting systems and wishing to make changes in software presently in use or wishing to implement new software, are to advise the Vice Chancellor for Fiscal Affairs and Treasurer of the Board of Regents (BOR) of such plans. This advice should ensure that all accounting systems are in compliance with specifications set forth in this manual.

Upon receiving this information, the Vice Chancellor for Fiscal Affairs and Treasurer of the Board of Regents will request the state Department of Audits and Accounts to perform a study and review of the proposed changes. No changes are to be implemented prior to receiving approval from the state auditor. The basic objectives of the state auditor�г��ٸ���Ƶ�s study and review are to determine whether the proposed financial accounting system (revised or new):

1. Contains adequate internal controls,
2. Is auditable, and,
3. Is operated in an environment that provides adequate security to the data.

This procedure applies to the main financial accounting system and to any other software system that maintains subsidiary records that supports the main financial accounting system.

13.2 Third Party Software Policy

Last modified: December 29, 2010

The �г��ٸ���Ƶ System Office receives requests for the addition of third party software packages into the suite of centrally supported software. Central support is made practical when the software is utilized by a significant number of the 32 centrally supported sites. This generally results in costs lower than the cost of each institution providing their own support.

Institutions may individually procure third party software packages as long as the proper notifications and approvals are received, as noted in Section 13.1 of this manual. Specifically, any third party product that interfaces with �г��ٸ���Ƶ supported software, regardless of cost, requires prior approval of the Vice Chancellor for Fiscal Affairs and the Vice Chancellor and Chief Information Officer.

Additionally, such software may be interfaced with centrally supported systems only if:

1. The design and specifications of the interface are submitted to and approved by Information Technology Services (ITS); and,
2. The development of the interface is accomplished by the institution or the third party vendor. Neither the USO nor ITS will develop interfaces for third party software in this situation.

A group of institutions may request that ITS assist in selecting and negotiating with a vendor the best site license for a third party software package. If at least 50% of the centrally supported institutions participate in the purchase, they may request that ITS provide central support for the package. The participating institutions will share the costs of purchasing and supporting the third party software package.

In this situation, interface(s) between the third party software and centrally supported systems may be developed by ITS if such an interface is deemed practical and institutions support the cost of development. The software support agreement between the ITS and the participating institutions must document the circumstances that may cause the termination of central support; e.g., withdrawal of participating institutions, termination of support from the vendor, etc.

13.3 GeorgiaFIRST PeopleSoft Institutions

Last modified: April 6, 2020

Institutions within the GeorgiaFIRST model utilize PeopleSoft Financials for financial processing and reporting, and One�г��ٸ���Ƶ Connect (PeopleSoft HCM) for payroll and human resources processing and reporting. These applications are centrally hosted at ITS in Athens. ITS maintains a single database for the application and all of the supported institutions and distributes all software upgrades and releases.

For internal control purposes, access to modules, processes, and approval functions are limited based on a person�г��ٸ���Ƶ�s security role(s). These roles are independently set and maintained by each institution�г��ٸ���Ƶ�s security administrator and should be periodically reviewed for control weaknesses.

Along with the �г��ٸ���Ƶ System Office, institutions in the GeorgiaFIRST model that utilize the centrally hosted PeopleSoft applications are:

• Abraham Baldwin Agricultural College
• Albany State �г��ٸ���Ƶ
• Atlanta Metropolitan College
• Clayton State �г��ٸ���Ƶ
• College of Coastal Georgia
• Columbus State �г��ٸ���Ƶ
• Dalton State College
• East Georgia College
• Fort Valley State �г��ٸ���Ƶ
• Georgia College & State �г��ٸ���Ƶ
• Georgia Gwinnett College
• Georgia Highlands College
• Georgia Southern �г��ٸ���Ƶ
• Georgia Southwestern State �г��ٸ���Ƶ
• Gordon State College
• Kennesaw State �г��ٸ���Ƶ
• Middle Georgia State �г��ٸ���Ƶ
• Savannah State �г��ٸ���Ƶ
• South Georgia College
• �г��ٸ���Ƶ of North Georgia
• �г��ٸ���Ƶ of West Georgia
• Valdosta State �г��ٸ���Ƶ

13.4 Description of GeorgiaFIRST PeopleSoft Financial Software Modules

Last modified: December 31, 2013

The GeorgiaFIRST PeopleSoft Financials application model is a fully integrated, Oracle-based technology suite of software applications managing the financial data that meet BOR and �г��ٸ���Ƶ institutional needs for information used in decision-making. A brief overview of the modules in this model is presented in the following sections.

13.4.1 Accounts Payable

Last modified: December 31, 2013

Functions of the Accounts Payable module include processing and managing vouchers, and processing payments, including express checks, which are checks that are not initiated through the Purchasing module. This module interfaces with the Asset Management and General Ledger modules.

---

13.4.2 Accounts Receivable

Last modified: December 31, 2013

The Accounts Receivable module is used to enter and maintain customer information, process invoices and receivables, create dunning letters, and register payments and cash receipts*. Information related to COBRA and retiree receivables is loaded from the PeopleSoft HRMS system.

---

13.4.3 Asset Management

Last modified: December 31, 2013

The Asset Management module maintains capitalized assets as well as non-capitalized inventory items. Assets may be added manually or can be fed through an interface with the Accounts Payable module. This module is used to add, adjust, transfer, and retire capitalized assets and non-capitalized inventory items.

The module uses different books to track various types of items. Capitalized assets, which are assets with a cost over $5,000, are maintained in the Enterprise book and are depreciated over the useful life of the asset.

Note: Refer to Section 7.0, Capitalization, for more information.

Items costing between $3,000 and $4,999.99 are maintained in the Small Value Property asset book and are not capitalized or depreciated. Additionally, certain items valued at less than $3,000, such as firearms, can be tracked through the Asset Management module.

---

13.4.4 Budget Prep

Last modified: December 31, 2013

The Budget Prep module is a custom-designed component of the PeopleSoft Financial system and is used to prepare initial budgets each fiscal year. The module allows for users to import data from the HRMS/Payroll and Financials systems to create a draft budget. Tools are available to modify the draft using mass updates, ad-hoc updates, and individual budget updates before the final budget is exported. Users may also save multiple budget versions for analysis and comparison during the budget preparation process.

Note: The Budget Prep module is not utilized for budget amendments during the fiscal year.

---

13.4.5 General Ledger (including Budgets)

Last modified: November 2, 2010

The General Ledger module is the control center of the PeopleSoft Financials system as it integrates and reports on information from all modules. The General Ledger is used to create and maintain specific fields such as departments, accounts, classes, programs, and projects. Other functions include creating and processing journals including external journals from Microsoft Excel, processing allocations such as plant suspense and grants, and depreciating assets, as well as budgetary and general financial reporting.

Budgeting functions of this module include creating and maintaining appropriation (high level) and organization budgets, budget inquiry, and budget status reporting.

---

13.4.6 Purchasing

Last modified: November 2, 2010

The Purchasing module is used to create, approve, edit, budget check, dispatch, modify, delete, post, and reconcile requisitions (where applicable) and purchase orders for goods and services. This module is also used to maintain and update vendor information.

---

13.4.7 Query

Last modified: November 2, 2010

The Query module is a powerful tool used to retrieve specific ad-hoc information in any PeopleSoft module by specifying the fields and criteria to be applied to the search. The Query module does not execute any processes other than retrieving information. Query results can be displayed on the user�г��ٸ���Ƶ�s computer screen, or exported to an Excel spreadsheet for further data manipulation, sorting, and printing. The module allows quick ad-hoc information without creating a formal report. Queries can be saved as public (all users see) or private (only the creator sees).

---

13.5 GeorgiaFIRST PeopleSoft HRMS

Last modified: December 29, 2010

The GeorgiaFIRST PeopleSoft HRMS application model is a fully integrated, Oracle-based technology suite of software applications used to maintain and process human resource and payroll related information. The HRMS system includes the following modules/functions:

1. Benefits: Used to maintain employee and dependant/beneficiary information, including health, life, disability, and leave benefits.

2. Deductions: Used to establish employee�г��ٸ���Ƶ�s general, annuity, and savings bond deductions, establish direct deposit, establish federal and state tax distribution, and garnish wages. Employer matching deductions, such as FICA and retirement, are also established in this function.

3. Employee Self Service: Allows employees to manage their personal information without the need for emails and phone calls to Human Resources or Payroll.

4. Hiring: Used to place a person into a position(s), change personal and job data, process additional pay, and load the benefits table for reporting purposes.

5. Manage Faculty Events: Used to maintain faculty rank and tenure information, prior experience/credits information, and funding and effort reporting information; track special achievements and faculty event cases; and, produce faculty information reports.

6. Payroll: Used to create and process all payroll checks and advices.

7. Position Management: Used to create regular positions, multi-incumbent positions, and position pools, and to provide position reporting.

8. Position and Personal Data Changes: Used to reclassify, transfer, or abolish a position, implement job and salary changes, and process leaves of absence, terminations and retirements.

9. Workforce Recruitment: Used to manage job openings, applicants, recruiting expenses, job offers, and other recruiting related tasks.

13.6 BANNER Student Information System

Last modified: December 22, 2010

The BANNER Student Information System is an integrated software package used to input and store Student and Financial Aid information, as well as cash receipting*. Student information includes data on recruiting, admissions, advising, course scheduling, registration, tuition and fee payments, grading and housing. Financial Aid information includes data related to applications, awards, and disbursements.

Specific information on use of these systems are available through systems training manuals or online.

13.7 Financial Reporting System/Data Warehouse

Last modified: October 18, 2012

The Financial Reporting System (FRS) is the portion of the �г��ٸ���Ƶ System�г��ٸ���Ƶ�s data warehouse that maintains summary financial data. Information is used for year-end reporting on a consolidated or by institution basis, as well as management reporting for analysis during the fiscal year. Data is collected on budgets, revenues, and expenditures and is aggregated at the account balance level based on the Chart of Accounts approved by the �г��ٸ���Ƶ System Office (http://www.usg.edu/gafirst-fin/documentation/ (login required)).

Institutions should submit data to the FRS by the tenth (10th) day of the month. Before submitting the period, the data should be reviewed for errors utilizing the provided system error reports. The period can be extracted as many times as necessary before being submitted. After all errors have been corrected, the institution should then submit the period to the FRS to be reviewed at the System Office. Data is reviewed for unacceptable errors including the use of accounts or other fields not listed in the official Chart of Accounts, missing required fields, and missing required processes. After the period is accepted, the next period is then available to be populated by the institution. The accepted period should be closed for all ledgers in PeopleSoft to ensure that the data warehouse and PeopleSoft remain synchronized.

Year-end reports include annual financial reports mandated by GASB, such as the Statement of Net Assets, and the Statement of Revenues, Expenses and Changes in Net Assets (SRECNA), as well other financial reports required by the USO and the state Department of Audits and Accounts. Management reports include the Statement of Financial Position reports, which provide state budgetary position data, and the Annual Expenditure Reports required by the USO Budget department. The Financial Position Reports for each institution are presented to the Board of Regents quarterly. These reports compare revenues and expenditures to budget for educational and general, other organized activities, auxiliary enterprises, and student activities.

Access to data and standardized reports are available to the general public and expanded access is available to all state agencies. These expanded access levels are determined by a secure login. Query access can also be utilized for ad-hoc inquiries on financial data not available in the standard reports.

The data warehouse also contains information other than financial, such as student and employee data. Future changes will be made to include facilities, curriculum, and other information.

Note: For more information on these data and processes, please refer to the Guidelines for the Use of the �г��ٸ���Ƶ System of Georgia Data Warehouse document and the User Documentation section of the data warehouse, which are available at: http://info.usg.edu/

© 2024 Board of Regents of the �г��ٸ���Ƶ System of Georgia
270 Washington Street, S.W.,
Atlanta, Georgia  30334
U.S.A.

↑ Top