Patriot Project logo.

Finance and HR System

Project Definition

Project Timeline Milestones

FAQ

Training

Committees and Teams


Student System

Other Banner Links

Patriot Project

Archived News

Site Index


Patriot Project
Feedback & Questions:

Patriot Project Team

Website problems:
Patriot Project Webmaster

Updated:
January 7, 2004

Finance and Human Resources Systems.

Project Definition

Executive Summary
George Mason University’s administrative systems were implemented in 1989 and 1990. These legacy systems are inflexible and prevent management from receiving key reporting information it requires. Further, the database is unique such that only two individuals possess the knowledge to trouble shoot when problems arise. The database is unreliable; data is lost and tables must be rebuilt with too much frequency for appropriate management of risk. New administrative systems are required that run on a production quality database such as Oracle. The challenge is to implement new systems that will bring stability, reliability, and flexibility, while retaining the level of web reporting and functionality to which the university has become accustomed.

An ambitious schedule is necessary because the existing database is unstable. If a major crash occurred it could take four days to rebuild the database, and the University could miss a payroll if the timing were poor. Pay checks that were identical to those issued the prior pay period would be processed, but this would require advances, repayment arrangements, and extraordinary rework in order to recover.

The goals and objectives of the project are to improve software reliability, management and regulatory reporting capabilities, business processes, level of system functionality for transaction processing, and data integrity; assign ownership for business processes, maintain an audit trail and establish an appropriate decentralized environment for end users.

The scope of the project is to upgrade the current Finance and Human Resources Administrative System software to the level of SCT’s current and emerging software technology contained in versions called “Banner.” Implementing Banner will present challenges, opportunities, and a road map to the future at GMU. The challenges will involve building and implementing the new system in an ambitious time frame and preparing employees to use new tools. This will require dedicated effort by a project team assembled from many functional areas at the university.

SCT is committed to the effort required to complete this upgrade by providing implementation support, and training services for the following Banner software: General Workflow, Finance, Human Resources, Web for Employees, Web for Executives, and e-Print Reports. GMU is committed to the effort required to complete this upgrade by dedicating the personnel, equipment and space required for implementation, education, communication and ongoing maintenance of the software.

 

SCT will ensure that the goals of the project are met by providing project management services using their Common Services Methodology (CSM). One aspect of the CSM that maximizes project success is the change management process, which requires an approved change request for all base line work products before action is taken. A formal Steering Committee has been established by GMU, and one of its responsibilities is to review all Change Requests.

Scope, cost, schedule, quality and objectives for the project are built on a number of assumptions that events will or will not occur. Some of the more significant assumptions are that changing to the accrual method of accounting will not cause unmanageable budgetary issues, a consistent series of business processes will be employed by all University units, and new federal and state mandates will not be so significant to redirect project staff.

There are a number of risks to the project’s success that require contingency plans, which are designed to minimize the impact on scope, cost, schedule and quality. For example, there is a high likelihood that some staff members will be needed on both the Finance and Human Resources implementations. The contingency options are to manage the implementation schedule around these overlaps or add resources. If policy and procedural decisions are not made in a timely manner, the contingency plan is to elevate decisions to a higher level. If the state legislature enacts a retroactive pay raise next spring, the contingency options are to assign other technical staff to the project so project staff could be redirected to meet the requirements in the legacy system or to accelerate the payroll implementation if practical. If network connectivity to the Commerce building is not adequate to transmit the data, the contingency is to upgrade the transmission lines.

The communications plan for the project includes a web site and town hall meetings to inform and involve the University community. Focus group meetings will be used to solicit input from stakeholders at decision points for key elements of the system. The Steering and Coordinating committees will meet at regular intervals to make layout, ownership and policy decisions. Project team members will report time spent on tasks, and team leaders, project managers, and quality assurance reviewers will provide periodic status reports. The Executive Committee will meet as needed.

Several quantitative and qualitative measurements will be used to determine whether the goals and objectives of the project are met. The number of items listed will increase as the project progresses. At this time, measurements to be evaluated include the following: pay checks are produced accurately and on time, the chart of accounts restructure will allow activity (project) tracking and will support Student as well and Finance and Human Resources system needs, system generated IDs are used to identify employees instead of social security numbers, faculty and staff will have remote access to core and web applications, and web applications will be accessible through any internet service provider (ISP).

The challenges are great, but the potential for innovation is even greater. The University community will be asked to remain open to new ideas and understand that we must commit to positive change in order to thrive and succeed. Implementing Banner will present a road map to the future by establishing the basis for an integrated reporting environment and will bring both short and long-term opportunities to improve information management.

Assumptions/Dependencies
Assumptions and Dependencies are items that are being presumed and are potentially out of our control or outside the scope of this project.

Assumptions

  • Executive management will support the project throughout its duration.
  • Changing to the accrual method of accounting will not cause unmanageable budgetary issues.
  • Remote access will be available to users.
  • A consistent series of business processes will be employed by all University units.
  • New federal, state or university mandates will not be so significant to redirect project staff.
  • External vendors and State agencies will supply files and accommodate tests within a reasonable time frame.
  • End users will accept the deliverables.
  • SCT consultant hours are adequate to complete the project.

Dependencies

Dependent Projects
The table below identifies the ongoing projects whose deliverables will be required to enable this project to meet its objectives. If the project has already been completed, then it is not listed as a dependency here.

Capturing accurate project dependency information early is critical in order to identify the issues that may prevent GMU from implementing the project deliverables because of known issues that jeopardize the completion of a project upon which this project depends.

Dependent Projects Table
Project Name Expected Completion Date Reason for Dependency
Oracle Financial Analyzer (OFA) 3/31/03 New chart of accounts requires restructuring of OFA dimensions.
Kronos Time and Attendance system 9/30/02 Current system uses IA/HRS codes.
University Data Warehouse 12/31/02 The data warehouse currently is the source of official university data and SCHEV reporting. Once Banner is implemented, it will store historical information.
New GASB Reporting Requirements 12/31/02 Changes to financial reporting require additional data manipulation.
SCT Banner Datamarts 12/31/02 Reporting requires static data. Also, implementing datamarts will enable us to retain the high quality of existing financial and human resources web reports.
Space Management Database 3/31/03 Relies on organizational structure within chart of accounts.
Photo Identification Card 1/1/03 Uses SSN for ID number.
EVisions for check printing and payroll notification 7/01/02 Print vendor and payroll checks. Produce e-mail notification of automatic deposit.

Dependent Products
The table below identifies the products that will provide the deliverables required to enable this project to meet its objectives.

Capturing accurate product dependency information here is critical to identifying early the issues that may prevent clients from implementing your project deliverables because of known issues with products upon which this project depends.

Dependent Products Table
Product Name Release Number Release Dependency is Higher Reason for Dependency
SCT Datamarts   No Reporting requires static data. Also, implementing datamarts will enable us to retain the high quality of existing financial and human resources web reports.

Dependent Resources
Identify the people and material resources required for which the project is dependent upon.

Dependent Resources Table
Project Name Commerce Building Network Closet Air Conditioning
Expected Completion Date N/A
Reason for Dependency Performance of the Banner core modules requires that the Banner forms be served locally. An additional server and air conditioner will be added to the Commerce network closet.

If the performance of the web deployed application is suitable for back-office transaction processing, the additional server would not be needed. 2/1/02 Superceded. We will use the Web to deploy the application.

Dependent Interfaces Tables
Product Name Student Information System (SIS).
Release Number  
Release Dependency is Higher  
Reason for Dependency The SIS runs on an IBM using IDMS/CA software. Feeds from SIS into Finance for financial aid drawdowns, student refunds, and revenue are required. HR uses SIS to determine student FICA calculations.

Product Name Commonwealth Accounting and Reporting System (CARS).
Release Number Not Applicable.
Release Dependency is Higher No.
Reason for Dependency Finance feeds deposit accounts payable and accounting information to CARS.

Product Name Human Resources (HRS).
Release Number  
Release Dependency is Higher  
Reason for Dependency HRS feeds payroll to Finance and will be required to interface from July 1, 2002 through HR implementation.

Product Name Oracle Financial Analyzer (OFA).
Release Number 11i, release 6.3.1
Release Dependency is Higher No.
Reason for Dependency OFA allows trend analysis and forecasting that is required by the University but is not available in the Banner system.

Nightly downloads from SCT Banner will be required from Finance and Human Resources. The new Chart of Accounts structure will have a significant impact on OFA. There are no regulatory changes to consider for this dependency.

Product Name Kronos Time and Attendance System.
Release Number V3A
Release Dependency is Higher No.
Reason for Dependency The Kronos interface to Payroll is dependent on the overall payroll coding scheme in the core administrative system.

Employee information is downloaded to Kronos. Time and attendance information is uploaded to drive payroll. The payroll calculations are based on the payroll coding scheme in the core system. There are no regulatory changes that are an issue.

An alternative method would be required to collect time in a non-web, clock based manner.

Product Name Institutional Reporting Data Warehouse.
Release Number  
Release Dependency is Higher No.
Reason for Dependency The data warehouse is dependent on extracts from the core administrative systems.

Employee and financial information is downloaded to the warehouse nightly. Some scripts match human resources and student system information for complex analysis. SCHEV and other official university reports are generated from this data. The state could impose new regulatory requirements during the period of this implementation.

Implementation of SCT Banner datamarts should eliminate the need for the dependency.

Product Name GASB Reporting Requirements.
Release Number Not Applicable.
Release Dependency is Higher No.
Reason for Dependency The university financial reports are dependent on data from the core administrative systems.

New regulatory requirements dictate significant changes to the manipulation of financial information from the core administrative systems. The new system must capture this information in a manner that allows adequate reporting.

Implementation of an SCT Banner version that is compliant with the GASB requirements should eliminate the need for the dependency.

Product Name SCT Banner Datamarts.
Release Number  
Release Dependency is Higher No.
Reason for Dependency Datamarts are required for SCHEV reporting. Further, they are necessary for us to continue the high quality web based financial and human resources reporting. There are no regulatory changes that are an issue.

SCT is providing the scripts to populate the datamarts from the core administrative systems.

Product Name Chargeback systems.
Release Number Not Applicable.
Release Dependency is Higher No.
Reason for Dependency Telephone, print services, mail services, computer store and other feed chargeback information into Finance using various software applications.

Product Name HR feed for LAN and e-mail accounts.
Release Number Not Applicable.
Release Dependency is Higher No.
Reason for Dependency LAN and e-mail accounts currently use SSN; will use employee ID number in new system.

Project Constraints
Project Constraints are aspects about the project that cannot be changed and are limiting in nature. Constraints generally surround four major areas: Scope, Cost, Schedule (Time), and Quality.

Project Dimension Grid Table
Project Dimension Minimize/Maximize Constrain Vary
Scope Minimize. No. Yes.
Cost Minimize. Yes. No.
Schedule Maximize. No. Yes.
Quality Maximize. Yes. No.

Constraint Details
Schedule is constrained for Finance due to fiscal year end of June 30. Cost is constrained due to budget limitations and need to comply with state laws.

Project Success Criteria
Several quantitative and qualitative measurements of project benefits will be taken and recorded to determine whether the goals and objectives of the project (section 1.3) have been met. The number of items listed will increase as the project progresses. At this time, the measurements to be evaluated include the following specifics:

  • Improve software stability and reliability.
    • Pay checks are produced accurately and on time.
    • Finance and HR applications are available as scheduled 95 percent of the time.
    • Duration of downtime does not exceed one business day.
    • Software libraries and database tables are backed up nightly.
    • Database audit records are produced as scheduled 99 percent of the time.

  • Improve data integrity and maintain audit trail.
    • Employee attributes are reported reliably.
    • Expenditure descriptions are specific.
    • Common terminology are established.
    • All transactions can be traced easily to entry date and user ID.

  • Improve management reporting capabilities.
    • Chart of accounts restructure allows activity (project) tracking.
    • Chart of accounts organization methodology supports Student system as well and Finance and HR needs.
    • MS Access or Oracle Discoverer can be used by casual users for simple reporting.
    • System information can be downloaded into Excel.
    • Reporting packages such as Oracle Discoverer, Brio, or Crystal Reports enable technically proficient end users to extract and download data.
    • Current year expenditure transactions are processed beyond the end of May.
    • Access to new year information is provided in July prior to closing the old year.

  • Improve level of system functionality for transaction processing.
    • Timesheets are eliminated.
    • Year-end processes/requirements are invisible to the end-user.
    • Integrated workflow approval hierarchy for faculty and staff is retained.

  • Improve regulatory reporting capabilities.
    • IPEDS report is produced from system attributes.
    • Annual financial statements are produced from the system instead of complex Excel spreadsheets.
    • SCHEV reports are produced with less data manipulation than currently required.

  • Improve business processes and identify or assign ownership.
    • System generated IDs are used for employees instead of SSN's.
    • Ownership is assigned for more faculty attribute codes recorded in the system.
    • Consistent rules are applied for budget versus actual transfers.

  • Establish an appropriate decentralized environment for end users.
    • Users can continue to enter additions/modifications/terminations for wage, part-time faculty and graduate assistant assignments and prospective funding changes for faculty.
    • Users continue to have web access to yesterday’s financial activity.
    • Users can create additional documents as required in workflow, such as requisitions, journal entries, and budget adjustments.
    • Retroactive funding changes can be processed through workflow.
    • Faculty and staff have remote access to core and web applications.
    • Web applications are accessible through any ISP.
    • Acceptable response time is delivered to back-office support staff (need to define in terms of seconds between forms).
    • Desk procedures are established.
    • On-going end-user training is scheduled.

Project Close Out Criteria
The following criteria must be met to close the project:
  • All issues and action items have been completed and signed off.
  • All required work products have been produced.
  • All deficiencies have been logged and signed off.
  • All quality assurance issues have been addressed.
  • A project termination or cancellation statement exists.

[Top]

Patriot Project. George Mason University.