Loading...
HomeMy WebLinkAboutgovWORKS PILOT TESTING Augusta Richmond GA DOCUMENT NAME: --g' /o1kS-#1lj DOCUMENT TYPE: ~r eemvd- YEAR:d6DD BOX NUMBER: I () . FILE NUMBER: /il >14 to NUMBER OF PAGES: /'1 {!"' .~~~ .' PILOT TESTING. IMPLEMENTATION AGREEMENT This ilgreement (the "Agreement") is entered into as of May 16, 2000 (the "Effective Date") between govWorks, Inc:. ("govWorks") and Augusta, Georgia ("Locality") to detail the interaction between govWorks and Locality in regard to the payment of specific monetary collections made by citizens and consumers which govWorks will forward to Locality. 1. Scope and Duration of Testing. Locality agrees to test govWorks's Internet payment processing systems for Utility Bill:; pursuant to the Augusta Implementation Approach dated February 25,2000 (the "Augusta Implementati.m Approach"), which is incorporated herein by reference. Such pilot testing period wiJl begin as promptly as prlcticable after the Effective Date and will end on July 1,2000, or such other date as may be agreed to by the parties (the "Pilot Test Period"). 2. Collection of Funds. After completion of the Pilot Test Period, govWorks will collect, on behalf of / _. I.:ocality, the abovementioned paymentS from citizens and consumers through govWorks's Internet software and sites. Additionally, govWorks will collect convenience fees from the citizens and consumers f9r those paymentS. The convenienl;e fees shall be clearly disclosed on the govWorks Internet site at www.!!:ovWorks.com (the "Web Site", and together with any other web sites operated by govWorks. the "Web Sites"). 3. Tr'tnsmission of Funds. (a) govWorks will use itS besCi'eas0flable commercial effortS to transmit electronically the full payment (not including the convenience fees) ,received by govWorks on behalf of Locality to Georgia Bank ~,nd Trust. a bank designated by Locality (the "Financial Institution"), within 72 hours. Initiation of payments will be reconciled to daily transaction records as they ar~ reported to the Locality. b) govWorks will transmit electronically to the Locality the details of each tranhction processed by govWorks on b,ehalf of Locality. These details will include the type, amount and date of the payment and such' additional collateral information Locality reasonably may require to process the transaction. govWorks will provide such details in a format and schedule acceptable to Locality on a daily basis for all transaction processed the previous business day, as mutually agreed upon by both parties. (c) govWorks shall maintain at all times during the term of this contr~ct Employee Theft and Computer Theft and Fund!; Transfer Fraud coverage with limits of not less than S 1,000,000 and shall use its commercially reasonable efforts to notify Augusta at least 30 days prior to any cancellation of such coverage or decrease in the amount of coverage. 4. Rec,')rd ReTention. govWorks will maintain transaction records for not less than three years after the date of payment and generate monthly managemenueports to Locality. which will provide details of the paymentS received on behalf of Locality and remitted to the Financial Institution. 5. Acceptance of Data and Payments. (a) Locality will accept the data provided by govWorks to update itS . Own data record~; regarding each transaction received from govWorks. (b) LOC,llity will ensure that the Financial Institution will accept the deposits made by govWorks into an account specified by Locality. '\ . 6. Transaction Verification. govWorks and Locality will each review all transactions processed during the term of this Agr~ement to reconcile any differences between payments and information transmitted by the citizens and consumers tt~gh the Web Sites arid the payments and information delivered to the Financial Institution. 7. LiabWties. (a) govWorks liability to the citizens and consumers is set forth in the govWorks User Agreement on thl: Web Site. (b) govWorks shall not be responsible for any failure to perform or delay in performing due to causes beyond its control, including, but not limited to. equipment failure or malfunction, power failure, severe or adverse weather conditions, labor difficulty or governmeiltal action or inaction. ; '. . .. ~, <e:s~ (c) Notwithstanding anything herein to the contrary. in no event shaH either party be liable for any indirect. exemplary. special. incidental or consequential damages or costs. including but not limited to any lost profits. loss of use or goodwill. or any third party claims. even if a party has been advised of the possibility of such damages. 8. No Cost to Locality. govWorks will not charge Locality any fees or costs associated with the implementAtio;:1 of this Agreement. . 9. Term and Termination. This Agreement shall have an initial term of one year. and shall be extended automatically for additional one-year terms unless earlier terminated by either party. This Agreement may be terminated by either party in the event of a breach of its material terms if such br.each has not been cured within 20 days of notification of the breach. In addition. either party may terminate this Agreement with 30 days advance written notice; provided all accrued payment obligations hereunder shall survive such termination or expiration and the rights and e.bligations of the parties under Sections 4 through 16 shall survi ve such termination or expiration. 10. Ai.lthorization. Each party represents and warrants that (1) the execution. delivery and performance by such party of this Agreement and the consummation of the transactions contemplated hereby are within such party's corporate powers and have been duly authorized by all necessary corporate action on the part of such party and (2) . this Agreement constitutes a valid and binding agreement of such party. 11. . Notices. All notices. requests aria other communications to any party hereunder shall be in writing (including. facsimile transmission) and shall be given. if to govWorks. to: if to Locality. to: ,govWorks. Inc. :31 Franklin Street New York. New York 10013 Attention: General Counsel Fax: (2[2) 208-4472 and (212) 898-1348 Administrator 801 Municipal Building Augusta. Georgia Attention: Charles R. Oliver Fax: (706) 821-2819 All such notices, requests and other communications shall be deemed received on the date of receipt by the recipient thereof if receive:d prior to 5 p.m. in the place of receipt and such day is a business day in the place of receipt. Otherwise. any such notice. request or communication shall be deemed not to have been received until the next succeeding business day in the place of receipt. 12. Am.mdments and Waivers. (a) Any provision of this Agreement may be amended or waived if. but only if. such amendment or waiver is in writing and is signed. in the case of an amendment. by each party to this Agreement. or in the case of a waiver. by the party against whom the waiver is to be effective. (b) No failure or delay by any party in exercising any right. power or privilege hereunder shall operate as a waiver thereof nor shall any single or partial exercise thereof preclude any other or further exercise thereof or .the exercise of any other right. power or privilege. The rights and remedies herein provided shall be cumulative and not exclusive of any rights or remedies provided by law. 13. Successors and Assigns. The provisions of this Agreement shall be binding upon and inure to the benefit of the parI ies hereto and their respective successors and assigns; provided that no party may assign. delegate or otherwise transfer any of its rights or obligations under this Agreement without the consent of each other party hereto. except that govWorks may transfer or assign. in whole or from time to time in part. to one or more of its affiliates. but no such transfer or assignment will relieve govWorks of its obligations hereunder. 14. Governing Law. Agreement shall be governed by and construed in accordance with the law of the State of New York. without regard to the conflicts of law rules of such state. " , .{: , \~( '. IS. Counterparrs; Third Parry Beneficiaries. This Agreement may be signed in any number of counterparts, c:ach of which shall be an original, with the same effect as if the signatures thereto. and hereto were upon the same instrument. This Agreement shall become effective when each party hereto shall have received a counterpart hereof signed by the other party hereto. No provision of this Agreement is intended to confer upon any person other than the parties hereto any rights or remedies hereunder. 16. Entire Agreement. This Agreement, together with the Augusta Implementation Approach, which is incorporated h':rein by reference. constitute the entire agreement between the parties with respect to the subject matter of this Agreement and supersede all prior agreements and understandings, both oral and written, between the parties with re5,pect to the subject matter of this Agreement. 17. Captions. The captions herein are included for convenience of reference only and shall be ignored in the construction or interpretation hereof. 18. Dispute Resolution. (a) Except as set forth in paragraph (b) below, all claims, disputes and other matters in question between govWorks and Locality arising out of or relating to this Agreement, or the breach thereof, shall be decided in the United States District Court for the Southern District of Georgia. and govWorks, by executing this Agreement, specifically consents to venue in the United States District Court for the Southern District of Georgia and waives any right to contest venue insuch court. (b) If the amount in controversy is insufficient for the United States District Court of the Southern District of Georgia to obtain jurisdiction over the parties or such court does nOt otherwise have jurisdiction over the parties, each of the parties shall submit to non-binding mediation in Richmond County, Georgia. If, after 30 days, the parties are unable to resolve such claim, dispute or other matter in question, then govWorks shall consent to jurisdiction of the Superior Court of Richmond County, Georgia and shalI waive any right to Contest venue in such court. The parties hereto have caused this Agreemen.t to be duly executed by their respective authorized officers as of the day and year first above written. govVVorks,Inc. C 17 A . By tt2{1 )a[ ~ Name: Linoa Morse '---- Tide: Group Executive - Public Sector Augusta, " ~~ AtteSl"~ijdU Clerk ., .",.'~ ..- ',- , govWor1<s, Inc. govWorks, Inc. 81 Franklin SI. New York, NY 10013 Phone 212-941-6900 Fax 212-208-4472 Paynlent Processing -Implementation Appl10ach August3, GA rks.com *** Proprietary and Confidential *** For the use of Augusta - Richmond County, GA solely in connection with the evaluation of an Implementation project with govWorks, Inc. , ~ govWorks, Inc. Created by: Matt Courter For: Augusta, GA Payment Processing Implementation ApprQach , Created on 2/24/00 10:41 PM Saved on 2/25/00 5:54 PM Description: This document will describe the govWorks, Inc. implementation approach for Augusta, GA Internet payment processing. Implementation will consist, initially, of utility bills with opportunities to extend to real estate and personal taxes. Matthew Courter Draft Created by: Status: Contacts: .,.-Name Title .'c:" .. Phone -', Email Randy Oliver Augusta - Richmond County - City Ro 7656@co.richmond.qa.us Director N. MAX Hicks, Augusta Utilities Dept. - Director W: 706-796-5012 Mh 7202@co,richmond.qa.us P.E. Mike Sleeper Augusta - Richmond County - W: 706-821-1570 sleeper@co. rich mond. qa. us Systems Administrator Louisa govWorks - Account Manager- W: 212-941-6900 ex! Istrayhorn@qovworks.com Strayhorn Southeastern Region 168 c: 757-650-2954 Matthew govWorks - Implementation W: 212-941-6900 ex! Matthew. courter@qovworks.com Courter Engineer 209 c: 201-681-8345 Implementation Solution Drivers: Augusta - Richrnond County, GA is seeking an Internet transaction solution that will provide constituents the ability to pay various fees, fines and taxes to the local government. This Internet solution would have to provide constituents the ability to pay various fines through credit card payments, debit card payments and electronic check processing. Adding Internet 'functionality to these payment types will provide citizens with greater access to make payments, both geographically and financially. Also, the addition of an Internet Solution will provide the first step towards adding full Internet transaction functionality, across all divisions of the Augusta - Richmond County local government. It will also provide a step towards updating the technology maintained and utilized within Augusta - Richmond County and provide a launch pad towards future system maintenance and development. Detailed Requirements: . Online posting of a sample Utility Bill, with payments available through all major credit cards, debit cards and checking accounts. . ACH or electronic transfer of money and data through Augusta's lock-box partner. . Online verification of account number and amount due, to limit citizens to only paying the exact amount due and only for active accounts. . . Reporting capabilities to insure complete reconciliation of payments made through an Internet payment engine. Current SC9pe: The current impl~ementation of an Internet payment processing solution will consist of utility payments through an electronic relationship between Augusta - Richmond County and a third party Internet payment and transaction provider. Delivl~ry of the payment process functionality will occur in May of 2000. A direction on govWorks' role as the third party transaction provider will be made on Monday, March 13th 2000. Augusta Implementation Approach Page 2 *** govWorks, Inc. Proprietary and Confidential *** \ " -~ " govWorks, Inc. Created by: Matt Courter For: Augusta, GA Payment Processing Implementation ApprQach . Created on 2/24/00 10:41 PM Saved on 2/25/00 5:54 PM govWorks, Inc. Solution: govWorks, Inc. will provide a payment processing engine accessible through its Internet site www.qovWorks.com. This payment-pwcessing engine will provide a means for citizens to make payments for Augusta - Richmond County, GA via credit card, debit card and checking account and provide confirmation of payment to the citizen via online confirmation and 24-hour customer support. GovWorks.com will provide a user the ability to input information regarding.a specific payment type to a specific . municipality. The website will prompt the user to enter all necessary information regarding the transaction such as: account number, total amount due, and remittance address. The website will transmit this information to the payment processing engine to provide real time authorization on credit and debit cards and account verification on checking accounts in real time. Users will be assessed a convenience fee based on the payment or transaction amount and type. The rate schedule can be customized on a local government basis. The standard rate schedule is available on the web site at the following web address: http://v,rww.govworks.com/pav fPayFee/o.,30.26, US,Oo.. html In batch mode the payment-processing engine, transmits daily all transactions to Cybersource for credit and debit cards and I-Check for checking accounts. Both vendors will provide capture of funds after verifying available balance, which will be routed through an electronic money transfer process (EDI, ACH or EFT) to a destination financial institution representing the local government. Data reports to :;upport the reconciliation of transactions will be compiled and sent directly to Augusta, GA. These reports can be clttached to ACH payments as a part of standard ACH documents or formatted and sent directly to a designated controller as a separate report. This report will detail at a transaction level all funds processed for Augusta, GA on a defined regular reporting interval. GovWorks, Inc. is currently implementing BETA city relationships with local governments. A BETA city designation allows for a steady and piecemeal implementation of the payment processing functionality for a local government entity. The BETA city designation includes building connections for the electronic transfer of money and data, shaping and developing core functionality for payment transfer and a public awareness campaign in your community to drive traffic and transactions through govWorks.com. In addition a BETA city relationship is maintained at the discretion of the local government until the local government is confident in the testing and implementation to make a public announcement regarding online payments through govWorks.com. GovWorks also supports the payment process with 24-hour multi-lingual customer support, available at 1-877- 729-8587. Implementation Approach: The govWorks payment processing solution will be implemented through a staged process starting with feasibility and requiremeni:s gathering stage, followed by a building-development stage, and finally an end product testing. Upon completion of each of these stages, govWorks, Inc. will partner with Augusta - Richmond County, GA to produce a markl3ting and public awareness program through inserts, public announcements, & advertising. The payment-processing implementation effort will be managed and coordinated by a Government Account Manager and an Implementation Engineer-Manager. The Governmelilt Account Manager will oversee the entire relationship between Augusta and govWorks, by acting as a liaison beN/een the local government and govWorks. This includes providing avenues for future development between govWorks and Augusta, as well as managing the marketing and public awareness program on behalf of the local government. Louisa Strayhorn will act as the Government Account Manager from govWorks on behalf of Augusta, GA. Augusta Implementation Approach Page 3 *** govWorks, Inc. Proprietary and Confidential *** govWorks, Inc. Created by: Matt Courter For: Augusta, GA Payment Processing Implementation Apprqach . Created on 2/24/00 10:41 PM Saved on 2/25/00 5:54 PM ,,' The Implementcltion Manager (1M) will be responsible for maintaining the technical aspect of the Implementation effort. The 1M will gather data, requirements and standard layouts, manage the update of the govWorks Internet site, oversee and verify the testing process. Finally, the 1M will be responsible for feeding additional development requests back into the govWorks pipeline and will provide a single point of contact for all technical inquiries on behalf of Augusta, GA. Matthew Courter will act as the Implementation Engineer on from govWorks on behalf of Augusta, GA. Feasibility Pro(:ess The feasibility process will commence with the agreement between Augusta and govWorks to begin testing a BETA city relationship for the payment of utility bills. Considering a kick-off date of March 13th, 2000, the govWorks Implementation team will need to perform an feasibility study to determine file layouts, data transfer requirements and payment transfer methods. This process will require the cooperation of the IT director, Utilities Department Director, Web Master and Augusta's primary financial institution or lock-box partner. The Implementation team will a single meeting with a representative from each of these dElpartments to insure the building of the payment processing. This time will be utilized by asking standard implementation questions to guide the discovery process as represented in Appendix A.1 AUQusta Utility Director- An implementation engineer will need dedicated time to discuss the payments of utility bills and information regarding standard utility accounts. This will require a single meeting and can be performed in person or over the phone. The following items will need to be determined and gathered. . Account Number length and type. . The average utility payment and standard range of utility payments. . A representative copy of the Augusta utility bill to be posted on the site. . Any routines used to match account numbers to names, address, zip codes and any other relationships or governing rules that determine account number validity. . Standard time frame for payments, late fees, and reconciliation needs on the part ofthe Utility Department. Webmaster -System Administrator and IT Director- An implementation engineer will need seta side time with the System Administrator to discuss file transfer and the creation of web links. This will require a single and can be performed in person or over the phone. The following items will need to be determined and gathered. . How the web link from the Augusta web page will point to the govWorks.com web site. . The desired URL for the govWorks site to point back to the Augusta home page. . How the file of valid accounts and dollar amounts will be transferred. o The address of the FTP server. o Authentication or Encryption needs for the FTP process. o File layout and format (i.e. flat file, comma delimited). o The abilities of Augusta to format this file. o When and how often will this file be provided? o Should this simply overwrite our existing or previous data files, or should it do a delta search and replace rows with identical keys. o How much data can we expect in this file, . Requirements for the archiving of the upload file. I Appendix A represents standard implementation questions for any local government. As the discovery process proceeds with Augusta, it will help to facilitate requirements gathering. It is meant as an example of the type of information needed to be gathered, however each local government will have unique informational requirements. Augusta Implementation Approach Page 4 *** govWorks, Inc. Proprietary and Confidential *** govWorks, Inc. Created by: Matt Courter For: Augusta, GA Payment Ptocessing Implementation Apprqacl:t . Created on 2/24/00 10:41 PM Saved on 2/25/00 5:54 PM Lock Box / Primary Financial Institution - An implementation engineer will need to time with the Augusta Finance Administrator and representatives from the Lock Box partner. GovWorks would like to model its data and reporting feed from the existing feed provided by the lock box partner. GovWorks would also like to provide payment to a terminating account of Augusta's choosing in the ~;;ame fashion that it receives payments from its lockbox partner. This will take a day and should be performed in person. The following items will need to be determined and gathered. . Account information for electronic transfer of funds. . Layout and data type of reporting mechanism to be provided to or by the lock-box partner for current utility payments. The overall process will require minimal input by each of the above named representatives. The govWorks Implementation -engineer will then format this information in to a detailed design and approach document that will be provided back to the city to insure that the approach is in line with Augusta's expectations for payment processing. This process will take two weeks, one week for discovery and another week to compile an approach and should be complete by the 28th of March. Feasibility Deli'verables List: Deliverable Description IA100-AUG FTPFile Interface agreement verifying the nature of the data dump by Augusta for account numbers and amount due. It will include dates and times of dump, location and address of FTP server, encryption requirements and field and data definitions. IA 100 - AUG Payment Interface agreement detailing the means for money transfer, including type of money transfer (ACH, EDI, EFC), times and dates of transfer and account payment data transfer requirements. RRD100 - AUG Imp Detail Level Implementation document detailing overall implementation time frame and approach. Development Process The development process will contain three major pieces of development by govWorks and a two pieces of development by Augusta. Augusta will provide in a flat all active accounts and total amount due for each utility account and it will provide a link to the govWor~s site from the Augusta home page. GovWorks, Inc. will advance its Internet capability by providing real time verification of account numbers and amounts due. Additional development will involve customizing the payment form for Augusta, GA utility payments and establishing the money transfer links between govWorks and the final payment destination. . Auqusta Develo,oment Augusta will be I'esponsible for updating its website to inform users of the new functionality for paying utility bills over the Internei:. It will provide a link to the govWorks payment engine to direct citizens to the Internet location to pay their utility bills online. This update will also include a link to the govWorks web site to point users directly to the payment enfline offered by govWorks for Augusta, GA. Augusta will dump in a file, outside of its firewall, a list of all active accounts and total amount due for each utility account. Augusta will create a flat file and dump it on an FTP server for retrieval by govWorks. This file will be made available on a regular basis and contain standard information, including account number and total amount due. This file may contain additional information, such as a file header indicating total number of records and encryption capabilities. These issues will be sorted out in the feasibility stage. In addition, govWorks requests a high quality TIF image of the local government seal for posting on the govWorks site in order to co-brand the payment processing web page. This will help give the site the look and feel of both govWorks and the Augusta, GA. Augusta Implementation Approach Page 5 *** govWorks, Inc. Proprietary and Confidential *** govWorks, Inc. Created by: Matt Courter For: Augusta, G.I\ Payment Processing Implementation Apprqacl:1 Created on 2/24/00 10:41 PM Saved on 2/25/00 5:54 PM qovWorks Development . GovWorks will be responsible for three major development items, customized payment form, online verification of account and amount due, and processing electronic fund and data transfer. 1. Customized Payment Form GovWorks will update its forms for utility payments to Augusta, GA to represent the necessary information for processing. It will create user input fields for account number, payment total and any other necessary information. In addition it will post in compress JPEG format a representative copy of the standard Augusta utility bill and provide a link back to the Augusta web site. It will update its databases to represent the appropriate mailing address. 2. Online Verification of Account Number and Amount Due GovWorks will develop online 'real time' account number verification or total amount due verification for Augusta as a part of the implementation process. GovWorks will retrieve, via FTP a flat file that will contain all active accounts and the corresponding amount due. It will house this data in a database that can be queried in 'real time' to verify that the account number and amount due entered by the user match the bill presented by Augusta. This process will eliminate the ability of users to make partial payments for utility bills. 3. Processing Electronic Fund and Data Transfer GovWorks will model fund transfer after existing lock-box functionality already in place for utility payments to Augusta, GA. It will set up a ACH or EDI payme.nt mechanism to transfer funds in batch format representing the transactions that have cleared the capture process by our credit and checking vendors. Along with this fund transfer, a report will be generated to provide Augusta with the information necessary to clear accounts that have been process over govWorks.com. GovWorks will aim to model its fund and data transfer to that of the current lock-box partner. Based on the information gathered in the feasibility phase, govWorks will transmit funds daily to the destination account of Augusta's choosing. Overall Build and Development time frame is slated for two months. This assumes that we can model the electronic fund and data transfer after the current lock-box relationship. If unique customization for reporting or money transfer is necessary this time frame may be stretched. It also assumes that the FTP for online verification is available earl), in the development phase so that the data modeling process can be constructed quickly. Development Deliverables List: Deliverablle Description RRV100 - AUG High-level visual representation of data flow between govWorks and Augusta. RRV200 - AUC; Low-level visual representation of data flow to Lock-Box partner or financial institution, and FTP data retrieval process. RepresentatiVE! Representative customized web pages showing layout of Augusta forms throughout the govWorks web page govWorks Site. Testin~ Process Testing will revolve around our development phase. GovWorks will build a comprehensive test plan to insure that money can be successfully transferred to thE) Augusta terminating account, that the data files can be interpreted by Augusta to settle paid accounts, and that the FTP process is seamless and can be down loaded into a database for online verification. Formal testing I.ilill involve the use of scenarios to test critical functionality. Examples of these scenarios are the following: . Credit Card payment. . Debit Card payment. . Checking Account Payment. . Invalid Account Number. . Invalid Total Amount Due. . Zero balance transfer to terminating account (for zero activity). . Single transaction transfer to terminating account. . Multiple transaction transfer to terminating account. Augusta Implementation Approach Page 6 *** govWorks, Inc. Proprietary and Confidential *** govWorks, Inc. Created by: Matt Courter For: Augusta, GA Payment Processing Implementation Approacl) . Creafed on 2/24/00 10:41 PM Saved on 2/25/00 5:54 PM '. . Connectivity between govWorks web link to Augusta home page and between Augusta home page and govWorks payment engine. Testing will be performed over a 3o.-day period to commence on the 11 th of May and round out on the 15th of June. GovWorks would like to initiate FTP transfer and data modeling for online verification earlier. This will provide lead-time and insure connectivity betweengovWorks and Augusta, for the most development intensive process. The end of testing will be punctuated with a live demo of a real payment on the site for Augusta - Richmond County officials. Testing Deliverables List: Deliverablle Description TCD100 - AUCi -Tes Test case and script, to insure validity of online routine to insure proper account and dollar Case amount and electronic transfer of payment. This will also verify accuracy of all payment types (Le. Credit, Debit, Checking). DEMO Performed Demo for government officials kicking off the first official payment through the govWorks payment-processing engine for an actual utility bill. Marketing Cam~ The marketing clnd public awareness campaign will be organized and administered by a govWorks Account Manager. The Account Manager will work with the local government to create bill inserts that reflect the new method of online payment through govWorks.com and coordinate a public announcement by Augusta - Richmond County officials. This will require the input of Augusta to insure that the public message regarding a relationship between Augusta and govWorks is handled in the most appropriate manner. This process, complete with literature, press releases, and other marketing tools should be coordinated with the delivery of the Implementation effort on June 15th, 2000. . Marketing Campaign Deliverables List: Deliverable Description Inserts Document Public Announc:emen Draft of joint announcement upon success of Augusta BETA city payment processing Augusta Implementation Approach Page 7 *** govWorks, Inc. Proprietary and Confidential *** lJ) ~ .Q :2 0) ::0 .cg -lJ) 0) ::0 co I.... 0) .~ Q) 0 " e co lJ) 0) 10 0 >. ~~ 0) ~ 0..0.. " ......"<t 0) "<t1.O t5 bu; 0) """0 B 00 I.... 0-- e.. __1.0 <( "<tN N-- __ N c:: Ne 0 e 0 ~ 0" ...... "0) e 0) > 0) ......CO E COC/) ~~ 0) (,)0 a. ns E 0 ... ::J C. - lJ) c. lJ) <( 0) U r::: U ::J 0 lJ) .. I.... ns .E - 0) r::: E CI> co E I.... - CI> 0) E c. :;J E c 0) C') E r::: e.. 0 f/) Q) f/) > CI> 0) (,) " 0 ro ... I.... a.. 0) > - 0 r::: 0) CI> E E lJ) >- 0) ns 10 a.. .~ " I.... e 0) CD t t: ~ ::J 0 0 - Q) 0 CD .0 :::<( E t . . co C) cot U ~ _ .... .!::co E co u.!:: .. ...... ~ I-u - >. lJ) lJ).o ::J zl- -t: " Ol CD <(z o 0) ::J .~ C)~ ~1O~ > 0) I.... CD 0) 0) 01....0 0 .!::.!:: 010 LL 1-...... LI) N Q) l: :J 0> LI) N ;;; 0> <0 N N N I'- 00 0) Ol CO 0.. ~ ~ ~ CO ~ 0) " 'i= <Xl e N 0 '<t 0 N " e co N ~ co ...... 0) .;:: e.. 0 I.... 0.. U e lJ)- ~ I.... ~ > 0 Ol ~ ~ ~ '" Qj a. C Ql Ql c:: E C Ql Ql a. E E ~ a. Ql o ~ 5 '" in :J Ol :J < (; E.~ ro ID"O 5 ::Ql E",.9 ~_ ~ E ti 2 E 'u .e ~ :;::::: - ~ en "0 c: co co S C ~ ci -; ~ I~ .- >- < '" ~ -Ql C Ql 0 ~ ~ o lJ) .S ~" Ql .... E (ij Qj ..:: ~ " ....- lJ.. "ECQl\2>o>c - W 0 Q)Q)Q)a.cQ)~_m "'in x .;;iCiEE-l3o>o in '" 0 EEo.-Ql.og,~ 5,:::2: CD .0 - 0 ~ .... ~ .~ ~ ~ ~ ~ Qj 0 co & ~ .3 '0 ~~ in '" ~ ~ .~ C g, ~ ~ ~~~:E <{g' ~ ~ C::'5 < ID II) -" C5 ~ >0 > .... 0 ,- Ol :c 'iij ca CII u.. ~E-g~ 2 m co 'S; ~ ~ ~ ~ ~ .~ Ci .2 CiE~~~ U - :J (J) ~~ ~ o ~ '0 > ~ o Ql Cl Ol .~ C Qj ~ 0 CII I- Ql!!! II) '" co 'C Ql Ql mro ~ E II) Ql C. '0 ~ Ql .;; ~ .!:: U CO o I.... e.. e.. <( e o ~ ...... e 0) E 0) a. E Q; Ol '" C g,~ 'n; 1l 0.< E II) ~~ Cl~ C 0 ~ rn ro CII in ..II:: :J ... Ol ca :J ~ < co in ::J Ol ::J <( .. . govWorks, Inc. Created by: Malt Courter For: Augusta, GA Payment Processing Implementation Approach Created on 2/24/00 10:41 PM Saved on 2/25/00 5:54 PM Key Delivery Dates: These dates represent the key delivery dates as dictated by the previous GANT chart and are subject to approval by Augusta personnel and govWorks development team. Date Delivery Item 3/13/00 Kick-Off Implementation Effort 3/28/00 Finalize Feasibility Study and begin building stage 5/12/00 Begin testing of FTP transfer, inter-site link connectivity 5 /26/00 Finalize Build 6/15/00 Demo-date of transaction with govworks.com Internet site for Augusta officials 6/15/00 Review & release date for public awareness and announcement campaign Assumptions: NBR Assumption 1 2 Outstandin!~ Issues: BE Issue Resolution Change History: Effective Dati~ Changed By Change Description 2/23/00 Matt Courter Initial Implementation Proposal Augusta Implementation Approach Page 9 *** govWorks, Inc. Proprietary and Confidential *** govWorks, Inc. Created by: Matt Courter For: Augusta, GA Payment Processing Implementation Approach Created on 2/24/00 10:41 PM Saved on 2/25/00 5:54 PM ~: A - Implementation Questions I. Local Government System Overview 1. Who are the representatives who will assist in Implementation effort? a. Who is the systems director, assistant, database administrator, etc? b. Will more IT hiring take place in the future? Are any outside consultants on site? c. What information is available detailing the municipality organization? 2. What software is in place? a. What database software and reporting applications are being used? b. Are packages being implemented? 3. What hardware is in place? a. Can documentation be provided with infrastructure details? b. What servers are currently in place? II. Bank Account Evaluation 1. Which bank is currently providing account services? a. What is the nature of the data being sent to the bank? b. Are Lockbox services in place? III. Information Exchange 1. What tools are in place for current data transfer? a. Does the municipality have Internet connections? b. What data transfer protocols are in place? File transfer protocol? c. Are destination folders necessary for FTP? Password and user name? IV. Data Format and Structure 1. What documentation is available detailing formatting issues? a. What data fields are required? b. Is the data format consistent betWeen all business modules? 2. What documentation is available detailing file structure? I. What are the specified structures used for number assignments? II. How flexible is the data structure? III. Is data range documentation available? IV. What kinds of delimiters are begin used? V. Payment processing methodology 1. What are the steps and workflow of payment processing? 2. Who handles the payment processing system? 3. What systems are in place? 4. How is reconciliation of transaction currently performed? VI. Reports 1. What information is available for detailing reports? a. How often are reports prepared? b. What fields are in the reports? c. What are the timing issues involved with reporting? 2. What are municipalities needs for management reports? a. What is the presentation format? b. How often are management reports sent / received? c. How do they want the information sent (ftp or email or other method) d. Where should the information be sent? i.ftp: 1. ftp server/Proxy IP address 2. authentication- if any 3. username 4. password 5. Destination folder for the upload e. E-mail Augusta Implem~ntation Approach Page 10 . , . .. *** govWorks, Inc. Proprietary and Confidential *** ~, ~ .." ...... govWorks, Inc. Created by: Matt Courter For: Augusta, GA Payment Processing Implementation Approach Created on 2/24/00 10:41 PM Saved on 2/25/00 5:54 PM i. Complete E-mail address f. In what format do they want the information? (ASCII text, HTML, other method) i. Exact file formats for the files that need to be sent ii. Type of file required - word, excel, rtf, flat-file etc g. . What fields of data do they want in the report? h. What format do they want the fields to appear in? i. What information do we need to use to marry a check, credit card, or other money payment to the report record? j. How often do they want the report sent? k. Is there a test environment we can use to try out this functionality? I. Are credit card reports formatted differently than check reports? (two per municipality, or only one?) m. Are there any timing/scheduling requirements we need to be aware of? (e.g uploaded file should be in-place by midnight etc) n. Would it be possible to provide govWorks/Sapient with a sample report file? VII. Testing 1. What is the current testing environment? a. What testers are available on site? b. How will test plan writing be coordinated? c. Is testing automation in place? Augusta Implementation Approach Page 11 . . . *** govWorks, Inc. Proprietary and Confidential ***