BOARD MEETING DATE: April 10, 1998 AGENDA NO. 14
PROPOSAL:
Execute Contract for New Integrated Financial and Human Resources System
SYNOPSIS:
AQMD requires an integrated financial system (including accounting, purchasing, payroll, contracts, budgeting, human resources, and fixed asset inventory software that replaces/enhances current functionality, a new computer, and migration of historical data) to achieve efficient unified accounting and finance functions for the agency. This action is to award bid to Mikon Computer Systems to provide a turnkey system for a total cost of $1,185,171. Initial funds ($500,000) for purchase of this system are included in the FY 1997-98 Budget; the remainder will be requested in the budgets for FY 1998-99 through FY 2000-01 as part of a three-year lease/purchase agreement.
COMMITTEE:
Administrative, March 20, 1998, Recommended for Approval;
Finance, Review Scheduled for April 3, 1998
RECOMMENDED ACTION:
- Award bid to Mikon Computer Systems for new financial system software, computer hardware, and implementation and migration services.
- Authorize the Executive Officer to execute a three-year lease/purchase agreement for a New Finance Accounting System with Mikon Computer Systems through Digital Financial Services with an initial payment of $500,000 and an annual lease cost not to exceed $241,064 per year for FY 1998-99, FY 1999-00, and FY 2000-01.
Barry R. Wallerstein, D.Env.
Acting Executive Officer
Background
On November 18, 1997, the AQMD released RFP #9798-10 entitled Finance Accounting System Migration. AQMD’s current system, comprising Bi-Tech government accounting software running on an HP935, has been in use since 1990 and provides fundamental accounting functions (General Ledger, Accounts Payable, Accounts Receivable) in addition to several other finance-related functions, including payroll, human resources, and purchasing. The software package itself has been modified extensively to conform with specific AQMD needs and requirements.
Although the primary motivating factor for acquiring a new finance system is Year 2000 compliance, there is also a need to keep up with current technology and to enhance the functionality of the overall finance system, eliminating duplicate effort where possible and integrating processes that access the same data. Under the current system, some processes are still performed manually, while others not included in the basic system require redundant data entry and data storage. In addition, the current system relies on proprietary operating system software and a proprietary non-relational database management system. With open systems technology, data and code can be easily transported between platforms and systems, so that essential information can easily and securely move between independent systems
The RFP solicited bids for a complete, turnkey solution to replace and enhance existing system functionality. Seven categories of goods and services necessary for the migration of AQMD accounting system functions were identified in the RFP. These included an off-the-shelf financial system software package, appropriate relational database software, customization of the off-the-shelf software necessary to meet AQMD requirements, a hardware platform, installation of the hardware and software, maintenance support for the hardware and software, and migration of current AQMD data into the new system.
Outreach
In accordance with the AQMD’s consulting and contracting policies, a public notice advertising the RFP and inviting bids was published in the following publications:
|
1. |
Antelope Valley Press |
10. |
La Opinion |
19. |
Precinct Reporter |
|
2. |
Black Voice News |
11. |
La Voz |
20. |
Rafu Shimpo |
|
3. |
Chinese Daily News |
12. |
Los Angeles Daily News |
21. |
Riverside Press Enterprise |
|
4. |
Eastern Group Publications |
13. |
Los Angeles Sentinel |
22. |
San Bernardino Sun |
|
5. |
El Chicano |
14. |
Los Angeles Times |
23. |
Santa Clarita Signal |
|
6. |
Excelsior, The |
15. |
M/W/DVBE Source |
24. |
State of California Contracts |
|
7. |
Inland Empire Hispanic News |
16. |
Orange County Register |
Register |
|
|
8. |
Inland Valley Daily Bulletin |
17. |
Palm Springs Desert Sun | ||
|
9. |
Korea Central Daily |
18. |
Philippine News |
Additionally, potential bidders were identified using the Los Angeles County MTA, and Cal Trans Directories of Certified Minority, Women, Disadvantaged and Disabled Veterans Business Enterprises; the Inland Area Opportunity Pages Ethnic/Women Business & Professional Directory; AQMD’s own electronic listing of certified minority vendors; and AQMD Purchasing’s mailing list. Copies of the RFP were mailed to the Black and Latino Legislative Caucuses and various minority chambers of commerce and business associations; and placed on the Internet at AQMD’s Web site [http://www.aqmd.gov, "Business and Job Opportunities" icon] and AQMD’s 24-hour telephone message line for bidders (909) 396-2724.
One hundred-sixty copies of the RFP were mailed out and 25 vendors attended the mandatory bidders conference held on December 2, 1997. Of the 25 organizations attending the bidders conferences, six were Minority Business/Disabled Veteran Business enterprises, and five were woman-owned.
Bid Evaluation
Four (4) bids were received in response to the RFP when final bidding closed at 12:00 p.m. on January 6, 1998. Of the four bids, one was from a women-owned business enterprise.
Two of the four bids were rejected as non-responsive; one for failing to follow the proposal submittal requirements as specified in the RFP and one for proposing a non-Windows, non-client server solution. The remaining two bids represented partnerships between two or more vendors. One bidder also proposed two different vendors to provide Human Resources/Payroll functionality. The three vendor groups included in the evaluation are as follows:
The in-depth evaluation of these three proposals by the panel found that two did not meet all of the technical requirements of the RFP. Attachment 1 reflects the evaluation of the single proposal that passed all of the technical criteria.
Independent of the selection process by the evaluation panel, the bids were evaluated by an external contractor to assess the proposed software, implementation/data migration services, need for customization, and associated costs. The contractor's assessment concluded that both proposed solutions are sound; however, the PeopleSoft software offers a base functionality that satisfies all of the District’s requirements in one package. The Platinum solution does not satisfy all of AQMD’s requirements and requires integration of third-party software for Payroll and Human Resources. The lack of basic functionality, need for customization, and integration of distinct software packages impacts both implementation and future maintenance. In addition, the contractor found that the proposed costs were all within reasonable industry standards for Finance/HR/Payroll migration. The total cost for each proposal and the estimated total cost over five years, incorporating anticipated customization and routine maintenance, are as follows:
|
Purchase Cost |
Total Est. Cost Over 5 Years |
|
|
Group 1 |
$1,002,453 |
$1,690,078 |
|
Group 2 |
$ 878,204 |
$1,695,379 |
|
Group 3 |
$1,185,171 |
$1,757,822 |
Panel Composition
The bid evaluation panel consisted of eight individuals, six internal to the AQMD and two external. Of these eight panelists, five are women and three are men; two of the panelists are Hispanic American, one is Asian-Pacific and five are Caucasian. Panel members represent all of the major users of AQMD’s current Finance/HR system, including Finance, Purchasing, and Human Resources, as well as Information Management, with responsibility for maintaining and supporting the hardware and software that make up the system.
Resource Impacts
Funds in the amount of $500,000 for this purchase are included in the FY 1997-98 Budget to initiate this purchase. The remainder of the purchase price will be covered by a three-year lease/purchase agreement with Digital Financial Services at an maximum annual lease cost of $241,064 for three years, for a total price of $1,185,171. Funds in the amount of $241,064 will be requested annually through FY 2000-01 to cover the remainder of the lease.
In an effort to determine how this level of expenditure reflects public sector experience in the purchase or upgrade of finance system software, AQMD staff surveyed a number of local agencies, county governments, and municipal governments. Publicly available data from the survey are tabulated in Attachment 2. The reasons given for migrating to new finance/human resource software were fairly consistent -- Year 2000 issues, integration of separate but related functions, open vs. proprietary environments, client-server technology replacing legacy systems, relational databases, and additional functionality. However, there were many different solutions depending on specific needs and costs range from several hundred thousand dollars to millions of dollars.
Finally, Attachment 3 contains a listing of users for the software being recommended for purchase.
Attachment(s)
Attachment 1 - Evaluation of Respondents to RFP/RFQ #9798-10
Attachment 2 - Public Sector Survey Results
Attachment 3 - Software Users List
ATTACHMENT 1
Summary of Evaluation of Respondents to RFP #9798-10
Four proposals were received in response to this RFP. Of these four proposals, two were deemed non-responsive. The remaining two proposals were group efforts from two or more independent vendors providing one or more pieces of the overall bid. Group 1 consisted of CompUSA, Platinum Software Group, and The Ultimate Software Group. Group 2 consisted of CompUSA, Platinum Software Group, and Automatic Data Processing. Group 3 consisted of Mikon Computer Systems and PeopleSoft.
Step 1 - Technical Criteria (70 points minimum, 100 points maximum)
|
Proposer | |||
|
Group 1 |
Group 2 |
Group 3 |
|
|
Panel Average |
68.4 |
60.8 |
90.9 |
|
Carry-over (50% of points > 70) |
0 |
0 |
10.5 |
Step 2 - Cost and Other Factors (80 points maximum)
|
Criteria |
Proposer |
|
Group 3 |
|
|
Cost (Maximum = 70 points for lowest cost) (Actual Amount) |
70 $1,185,171 |
|
Certified DVBE/Joint Ventures Points (Maximum = 10) |
No 0 |
|
Total |
70 |
Total Score (80 points maximum)
|
Criteria |
Proposer |
|
Group 3 |
|
|
Step 1 Carry-over Points (Maximum = 15) |
10.5 |
|
Step 2 Points (Maximum = 80) |
70 |
|
Total |
80.5 |
ATTACHMENT 2
Public Sector Survey Results*
|
Name |
Revenues |
# Empl. |
Purchased |
Budget |
Comments |
|
City of Costa Mesa |
$67,300,000 |
573 |
• SW (PeopleSoft) • Implementation svcs. |
$2 million |
Hardware cost not included. The City purchased all new computer hardware as part of an overall upgrade of all City systems. Approx. $3,500/employee. |
|
City of Glendale |
$331,000,000 |
1,500 |
• SW (PeopleSoft) • HW • Implementation svcs. |
$2.2 million |
Some implementation done in-house and cost for in-house effort not included. Approx. $1,500/employee. |
|
City of Oakland |
$650,000,000 |
5,000 |
• SW (Oracle) • HW • Implementation svcs. • Project management |
$20 million |
SW includes five 3rd-party packages. HW includes server and desktop equipment. Implementation services include development of interfaces. Total budget includes cost to finance purchase. Approx. $4,000/employee. |
|
City of Pasadena |
$350,000,000 |
1,900 |
• SW (PeopleSoft) • HW • Implementation svcs. |
$2.5 million |
Approx. $1,300/employee. |
|
LA Co. Public Works Dept. |
$1,000,000,000 |
4,000 |
• SW (KPMG) • HW • Implementation svcs. • Maintenance for 10 years |
$6 million (estimate) |
Some implementation done in-house and cost for in-house effort not included. Approx. $1,500/employee. |
*Publicly available data.
Attachment 3
Software Users List
|
Customer |
HRMS Apps |
Financial Apps |
DB Platform |
|
AC Transit |
HRMS |
Financials |
N/A |
|
Adams Twelve Five Star Schools, CO |
HR,BA,PI - 6 |
Microsoft SQL |
|
|
Arapahoe County |
BA,HR,PY, TL - 6 |
Mircrosoft SQL Server/NT |
|
|
Arthritis Foundation - FIN |
AM,BI,BD,GL,IN,OM,AP - 6 |
Oracle/NT |
|
|
Boston Water And Sewer Commission |
BA,FS,HR,PY,TL - 6 |
AM,BD,GL,AP,PO - 6 |
Oracle/DEC Alpha |
|
California Power Exchange Corporation |
BI*,GL*,AR*,AP*,PO*,AM*,BD* - 6 |
Sybase SQL Server 11/UNIX |
|
|
California Public Employee's Retirement Syst |
AM,BI,BD,GL,AP,PC,PO,AR, - 6 |
Oracle/UNIX |
|
|
California Secretary of State, CA |
Financials |
N/A |
|
|
Cincinnati Public Schools |
HR,BA - 4.02 |
Oracle/UNIX |
|
|
City and County of San Francisco |
PY - 5.1 |
Oracle/UNIX |
|
|
City of Akron, OH |
BA,*FS,HR,PY,TL - 7 |
Oracle/UNIX |
|
|
City of Baltimore, MD |
AP,PO - 6 |
Oracle/UNIX |
|
|
City of Boise, ID |
HR,PY,BA - 6 |
GL,AP,BI,AR,AM,BD,PO,PC - 5.1 |
Microsoft SQL Server/NT |
|
City of Boston |
BA,HR,AP,PO,AR - 6 |
AM,BI,GL,AP,PO,AR, - 6 |
DB#2 |
|
City of Cedar Rapids, IA |
BA,HR,PY,TL - 6 |
AM,BI,BD,GL,IN,AP,PC,PO,AR |
Microsoft SQL Server/NT |
|
City of Cincinnati, OH |
BA,FS,PY,PN*,TL-6 |
Oracle/UNIX |
|
|
City of Clearwater, FL |
HR*,PY* - 5 |
Oracle RunTime |
|
|
City of Colorado Springs, CO |
BA,HR,PY,TL - 6 |
AM,BI,BD,GL,IN,AP,PC,PO,AR,-6 |
Oracle/UNIX |
|
City of Coquitlam, BC |
HR*,PY*,TL* - 6 |
Oracle/UNIX |
|
|
City of Costa Mesa, CA |
BA*,HR*,PY* - 5.1 |
AM*,BI*,PC*-5.1;AR,GL,AP - 5 |
Oracle/UNIX |
|
City of Edmonton, ON |
TL* - 6; HR*,PY*,BA* - 5.11 |
Oracle/UNIX |
|
|
City of Escondido, CA |
HR*,PY*,BA*,BD,AR,BI - 5.11 |
GL,AP,GL - 5 ; PO*,IN*,AM*,PC* - 5.1 |
Oracle/UNIX |
|
City of Eugene, OR |
HR- 6 |
GL,AP,PO,AR,-6 |
Microsoft SQL/NT |
|
City of Flint,MI |
BA*,HR*,PI*,PN*,TL*,-6 |
AM,BI,BD,GL,IN,AP,PC,PO,AR,-6 |
Oracle/UNIX |
|
City of Glendale, AZ |
HR*,PY*,BA* - 5.11 |
IN,BD - 5.1 ; PO,GL,AP,AR,AM,BI,PC - 5 |
Oracle/UNIX |
|
City of Glendale, CA |
HR*,PY*,BA*,FS* - 3.3 |
AM,BI,BD,GL,AP,PO,RE,-6 |
Oracle/UNIX |
|
City of Indianapolis, IN |
BA*,HR*,PI* - 5.1 |
Oracle/UNIX |
|
|
City of Kelowna, BC |
HR*PY* - 5.1 |
PO*,GL,AP,PO,BI,AM,AR,,IN - 6 |
Oracle/NT |
Attachment 3 (continued)
|
City of Kitchener, ON |
HR*,PY* - 5.11 |
Oracle/UNIX |
|
|
City of Knoxville, TN |
HR,PY,TL - 6.01 |
AM,BI,GL,AP,PC,PO,AR - 6 |
Oracle/UNIX |
|
City of Lakeland, FL |
BA*,HR*,PY* - 5.1 |
Oracle/UNIX |
|
|
City of Lethbridge, AB |
PY*,TL*,HR* - 6 |
Oracle/UNIX |
|
|
City of Los Angeles-CDC |
HRMS |
Financials |
N/A |
|
City of Los Angeles |
HR - 6 |
Oracle/UNIX |
|
|
City of Louisville, KY |
HR,PY - 6 |
Sybase SQL Server 11/NT |
|
|
City of Mesa Information Services, AZ |
HR* - 4 |
Oracle/UNIX |
|
|
City of Milwaukee,WI |
BA,HR,PY,TL,-6 |
BI,BD,GL,IN,AP,PC,PO,AR,-6 |
Oracle/UNIX |
|
City of Minneapolis, MN |
BA*,FS*,HR*,PY* - 5.11 ; TL - 6 |
Oracle/UNIX |
|
|
City of Mississauga, ON |
HR* - 4.02 ; TL* - 6 ; PY* - Unknown |
Oracle/UNIX |
|
|
City of Norfolk, VA |
BA*,PY*,HR*,FS* - 5 ; TL* - 6 |
DB2/MVS |
|
|
City of Pasadena, CA |
GL,AP,AR, AM*,PC*,IN*,BI* - 5.1 |
Oracle/UNIX |
|
|
City of Phoenix, AZ |
HR*,BA*,PY*,PI* - 5 ; FS* - 5.1 |
Oracle/UNIX |
|
|
City of Pittsburgh, PA |
BA*,PY*,HR* - 5 ; PI,HR,BA - 6 |
PO,AP,GL,IN,AM,BD,AR - 5.1; PO* - 6 |
Oracle/UNIX |
|
City of Provo, UT |
HR*,BA*,PY* - 5.11 |
PO,GL,AP,AR,AM,BI,PC - 5.1 |
Oracle/UNIX |
|
City of Richmond, BC |
HR*,PY*,TL* - 6 |
AP,AR,PO,AM,PC,BD,BI,GL,IN - 5.1 |
Oracle/UNIX |
|
City of San Jose, CA |
HR*,BA*,PY*,TL* - 6 |
Oracle/NT |
|
|
City of Santa Monica, CA |
BA,HR,PY,TL - 6 |
Microsoft SQL Server/NT |
|
|
City of Scarborough, ON |
HR* - 3.22 ; HR* - 6 |
Oracle/UNIX |
|
|
City of Seattle, WA |
TL - 6 |
GL,AP,PR,PO,BI,IN,AM,AR - 6 |
Oracle/UNIX |
|
City of Springfield, OR |
BA,HR,TL,PY - 6 |
AM,BD,GL,AP,PR,PO,AR,IN - 6 |
Microsoft SQL Server/NT |
|
City of Tacoma, WA |
HR*,PY* - 4.02 ; PY*,BA*,HR* - 6 |
Oracle/NT |
|
|
City of Tallahassee, FL |
TL - 6 ; BA*,HR*,PY* - 5.1 |
Oracle/UNIX |
|
|
City of Tempe, AZ |
BD,HR,PY,TL,BA -6 |
PO*,AM*,PC*,GL,AP,AR,PO - 5.1; BD* - unknown |
Oracle/UNIX |
|
City of Torrance, CA |
AM,BD,GL,AP,PC,AR - 6 |
Microsoft SQL Server/NT |
|
|
City of Victorville, CA |
GL,AR,AP,AM,PC,BD,PO,IN,BI - 6 |
Microsoft SQL Server/NT |
|
|
City of Waterloo, ON |
PY* - 5.1 |
AP,AR,GL - 5 ; IN*,AM*,PC* - 5.01 |
Oracle/UNIX |
|
City Utilities of Springfield, MO |
PO*,AM*,GL*,AP*,PR* - 6 |
Oracle/UNIX |
|
|
Commonwealth of Massachusetts |
BA,FS,TL,PY,HR - 6 |
Oracle/UNIX |
|
|
Commonwealth of VA Dept. of Gen. Svcs. |
TL* - 6 |
BD,AR,PO,GL,AP - 5.1 |
Oracle/NT |
|
Commonwealth of Virginia |
BA,HR,PR,TL - 6 |
Oracle/UNIX | |
Attachment 3 (continued)
|
Contra Costa County, CA |
BA*,HR*,PY* - 5.11 |
Informix/UNIX |
|
|
Corporation of the City of Windsor, ON |
BA*,HR*,PY* - 5.1 |
Microsoft SQL Server/NT |
|
|
County of Napa, CA |
HR*,PY*,BA* - 5.11 |
AM,GL,AP,AR,PC,PO,IN,BD - 5 |
Informix/UNIX |
|
Dallas Fort Worth International Airport |
HR,PI - 6 |
Oracle/UNIX |
|
|
Denver Water Department |
FS*,HR*,PY* - 3.02 |
Oracle/NT |
|
|
Edmonton Public Schools, AB |
HR*,PY*,BA* - 4.02 |
Oracle/UNIX |
|
|
Edmonton Roman Catholic S.D., AB |
HR*,PY* - 5.1 |
Oracle/UNIX |
|
|
El Paso Water Utility Public Srvc Board |
BA,*HR*,PY*-5.11 |
GL,AP,PO,AR,IN,AM,BD,PC,-5 IN* |
Oracle/UNIX |
|
Government of Alberta |
HR,PY,TL,BA- 6 |
GL,AP,BD,AR, IN*,AM*,PC*,BI,PO,IN - 5.1 |
Oracle/UNIX |
|
Government of Alberta Municipal Affairs |
BI,AR,AM,BD,GL,AP,PR,PO,IN - 6 |
Oracle/UNIX |
|
|
Government of Puerto Rico Dept. of Treas. |
HR,PY - 6 |
AM,GL,AP,AR,PO - 6 |
DB2/MVS |
|
Government of Saskatchewan |
PO*,AP*,GL* - 5.1 |
DB2/UNIX |
|
|
Government of Yukon |
HR*,PY*,BA* - 5.11 ; TL* - 6 |
Oracle/UNIX |
|
|
Greater Cleveland Regional Transit Auth |
HR*,PY*,BA* - 5.11 |
Oracle/DEC Alpha |
|
|
Greater Vancouver Regional District |
GL,HR,BA,TL,PY - 6 |
GL,PO,AP,BD,AR,AM,PR, - 6 |
Sybase System 4/UNIX |
|
Guilford County, VA |
HR*,PY* - 5.11 |
Oracle/UNIX |
|
|
Halton Board of Education, ON |
BD,HR |
GL,PO,AP,AR,AM, - 6 |
Oracle RunTime |
|
Jefferson County Public Schools, CO |
BA,HR,PY,TL - 6 |
GL,AP,PO,AR,AM,PR,IN,BD,BI,OM - 6 |
Oracle/UNIX |
|
Judicial Council of California |
HR* - 4.02 |
Oracle/UNIX |
|
|
Kaiser-Hill Company LLC |
TL*,HR*,BA*,PY*,PN* - 6 |
BD,AM,GL,IN,AP,PR,PO - 6 |
Oracle/DEC Alpha |
|
Kent County, MI |
AM,BI,BD,GL,IN,AP,PC,PO,AR - 6 |
Oracle/UNIX |
|
|
King County, WA |
BA,HR,PY,TL - 7 |
Oracle/DEC Alpha |
|
|
Kings County, CA |
HR*,PY* - 3.22 |
SQLBase |
|
|
Lancaster County, PA |
HR*,BA*,PY* - 5.11 |
Oracle/UNIX |
|
|
Lane County, OR |
BA,HR,TL,PY - 6 |
AM,BD,GL,PO,PR,AR,IN,AP - 6 |
Microsoft SQL Server/NT |
|
Los Angeles Department of Water & Power |
BA*,HR* - 3.02 |
DB2/MVS |
|
|
Lower Colorado River Authority |
HRMS |
Financials |
N/A |
|
Mashantucket Pequot Tribal Nation |
BA,FSA,HR,PY,TL-6 |
AM,BD,GL,IN,AP,PC,PO,AR |
Oracle/UNIX |
|
Metro Water Services, Nashville |
HR* - 4 ; HR* - 6 (Upgrading) |
Oracle/UNIX |
|
|
Metro, Portland, OR |
HR,PY,TL -6 |
GL,BI,AP,AR,PO,AM,BD,PC - 5.1 |
Informix/UNIX |
|
Metropolitan Council, St. Paul, MN |
AM,BD,GL,AP,PO,AR,PC |
Oracle/UNIX |
|
|
Metropolitan Water Dist of Southern CA |
PY*,HR*, BA* - 4 ; TL* - 6 |
Oracle/UNIX | |
Attachment 3 (continued)
|
Milwaukee Public Schools, WI |
BA,HR,*PY,TL -7 |
Oracle/UNIX |
|
|
Munic of Metropolitan Toronto Police |
HR,BA,PY - 5.11 |
Oracle/UNIX |
|
|
Munic. Employees Retirement Sys., MI |
PY*,PN* - 6 |
Oracle/UNIX |
|
|
Municipality of Anchorage |
BA,HR,PY,TL,-6 |
AM,BI,BD,GL,IN,AP,PC,PO,AR,-6 |
DB2/MVS |
|
Newark Public Schools, NJ |
BA,HR,PY,Tl - 7 |
AM,BD,GL,IN,AP,PO -6 |
Oracle/NT |
|
New York Port Authority |
HRMS |
N/A |
|
|
Oakland County, MI |
HR*,BA*,PY*- 6 |
Oracle/UNIX |
|
|
Orange County Board of Commissioners, CA |
HR*,PY*,BA*,TL* - 6 |
Oracle/NT |
|
|
Peel Regional Police, ON |
HR* - 4 |
SQLBase |
|
|
Port of Seattle, WA |
HR,PY,BA,TL - 6 |
PO*,BD,GL,AP,PC,AM,AR,BI - 5.1 |
SQLBase/NT |
|
Public Utility Dist No 1 Snohomish Cnty, WA |
BD*,GL*,PR* - 6 |
Oracle/UNIX |
|
|
Ramsey County, MN |
AM,BI,BD,GL,AP,PO,AR - 6 |
Oracle/VAX/VMS |
|
|
Regional Municipality of Ottawa-Carleton |
PY*,HR*,BA* - 5.11 |
Oracle/UNIX |
|
|
Regional Municipality of Peel, ON |
HR*,PY* - 5.11 |
AR,BD,PR,GL-7 |
Oracle/UNIX |
|
Saint Paul Public Schools, MN |
HR*,PY*,BA*,FS*,TL* - 6 |
Oracle/UNIX |
|
|
San Bernardino County, CA |
HR,PY,BA,TL - 6 |
Oracle/NT |
|
|
San Diego County Water Authority |
HR*,PY* - 5.11 |
BD,AP,GL,PO,AR,AM,PC - 5.1 |
Oracle/UNIX |
|
San Diego Housing Comm. |
AM,BD,GL,IN,AP,PC,PO,AR, - 6 |
Microsoft SQL Server/NT |
|
|
Santa Clara County, CA |
HR,PY,BA - 6 |
Oracle/UNIX |
|
|
Seattle School District No 1 |
BA*,HR,PY - 6 |
Oracle/DEC Alpha |
|
|
Seminole County Public Schools, FL |
HR,PY,BA,TL - 6 |
BD,GL,AP,PO,AR - 5.1 |
Informix/UNIX |
|
Shawnee Mission Unified School Dist 512, KS |
BA,HR,PY - 6 |
GL,BD,AM,AP,AR,PO - 6 |
Microsoft SQL Server/NT |
|
Solano County, CA |
BA,HR,PY,TL,- 7 |
Oracle/UNIX |
|
|
South Carolina State Port Authority |
PO*,AM*,GL*,PR*,AP*,AR* - 6 |
N/A |
|
|
Spokane County, WA |
HR,BA,PY,TL - 6 |
GL,BD,PR,AM,AR,AP,PO,IN,BI -6 |
Microsoft SQL Server/NT |
|
Stanislaus County |
BA,PY,TL |
Oracle/UNIX |
|
|
State of California Health And Welfare |
HR*,PI* - 6 |
GL,AP,PO,AM,BD,PC,AR - 5.1 |
Oracle/UNIX |
|
State of Delaware |
PN*,HR,BA,PY,TL - 6 |
Oracle RunTime |
|
|
State of Hawaii Dept of HR Development |
HR*,PI* - 5.11 |
Oracle/UNIX |
|
|
State of Indiana, IN |
*BA,*HR,PY*,PI*,*TL - 7 |
AM,BI,BD,GL,AP,PC,AR - 6 |
DB2/MVS |
|
State of Kansas |
BA*,HR*,PY* - 4.02 ; BA,HR,PY - 6 (Upgrading) |
Oracle/UNIX |
|
|
State of Minnesota |
HR*,PY*,BA* - 3.22 |
DB2/MVS | |
Attachment 3 (continued)
|
State of Montana |
BA,HR,PY,TL - 6 |
IN,AM,BI,GL,AP,PC,PO,AR-6 |
Oracle/DEC Alpha |
|
State of Nevada |
BA*,HR* - 4 |
DB2/MVS |
|
|
State of NY Office Of State Comptroller |
HR,PY - 6 |
Financials |
Oracle/UNIX |
|
State of Oregon |
HR - 6 |
DB2/MVS |
|
|
State of Vermont |
HR*,PY* - 3.21 ; HR*,PY* - 5.11 (Upgrading) |
Oracle/UNIX |
|
|
Supreme Court Of Virginia |
HR*, PY*,BA* - 5.11 |
Oracle/UNIX |
|
|
Texas Attorney General |
HR - 6 |
AM,BD,GL,PO,IN -6 |
Sybase SQL Server 11/NT |
|
Texas Department of Transportation |
BA,HR,PY,TL-6 |
Sybase SQL Server 11/UNIX |
|
|
Texas Dept of Housing and Community Aff |
AM,BD,PO,AP,GL - 6 |
Oracle/UNIX |
|
|
Texas Education Agency |
GL,AP,AR,AM,BD,PC,IN,PO,BI - 5.1 |
Sybase SQL Server 11/UNIX |
|
|
Texas Employee Retirement |
HRMS |
AM,BD,GL,IN,PO-6 | |
|
Texas General Land Office |
BI,AR,GL,AM,AP,PO,BD - 6 |
Microsoft SQL Server/NT |
|
|
Texas Legislative Council |
AM,BD,IN,AR,GL,AP,PO - 5.1 |
DB2/MVS |
|
|
Tucson School District |
HRMS |
Financials |
N/A |
|
Vancouver School Board, BC |
AM,BD,GL,IN,AP,PC,PR,PO,AR - 6 |
Microsoft SQL Server/NT |
|
|
Virginia Department Of Transportation |
PO*,GL,AP,AR,PO,BD- 6 |
Oracle/UNIX |
|
|
Virginia Farm Bureau |
AM*,AP*,GL* - 5.1 |
Oracle/UNIX |
|
|
Washington Public Power Supply System |
HR,BA,PY,TL - 6 |
GL,BD,PR,AM - 6 |
Microsoft SQL Server/NT |
|
Weld County, CO |
HR*,PY*,BA*, FS* - 4.02 |
Oracle/UNIX |
|
|
Wichita School District 259, KS |
BA,HR,PY - 5.1 |
Oracle/UNIX |
|
|
Winnebago County, WI |
HR*,BA*,PY*,TL* - 6 |
GL,AP,BI,AR,AM,BD,PO |
Oracle/NT |
|
Workers Compensation Board of AB |
HR*,PI* - 3.01 |
PO* - 6 ; GL,BI,AP,AR,PO - 5.1 |
SQL Base/OS2 |
|
Workers Compensation Board of BC |
GL*,AP*, BD* - 5.1 |
DB2/MVS | |
|
BOLD = IN PRODUCTION |
|
ITALICS = LICENSED, NOT USING PRODUCT YET |
|
REGULAR = IN IMPLEMENTATION |
|
* = Commercial Module |
Attachment 3 (continued)
|
Product Key | |
|
Financials |
HRMS |
|
GL = General Ledger |
HR = Human Resources |
|
AP = Account Payables |
BA = Benefits Administration |
|
AR = Account Receivables |
FS = Flexible Spending Account |
|
IN = Inventory |
PY = Payroll |
|
PO = Purchasing |
PI = Payroll Interface |
|
BD = Budgeting |
TL = Time & Labor |
|
PC = Project Costing |
PA= Pension Administration |
|
AM = Assest Managment | |
|
BI = Billing |
/ / /