The URL can be used to link to this page

89-266 WHITE - C�TV CLERK PINK - FINANCE COUQCII BLUERV - MAVOR7MENT GITY OF SAINT PAUL File NO. ��' ��° - ouncil Resolution '� � � Presented B �'�� ' �-�� Referred To Committee: Date Out of Committee By I Date � WHEREAS, The Ma�yor, pursuant to Section 10.07.1 of the Charter of the City of Saint Paul, does certify that� there are available for appropriation total revenues in excess of those estimated in the 1989 budget; and WHEREAS, Counc'1 File 277510, Adopted October l, 1981, did establish certain Special Fund Policies; and WHEREAS, the yor recommends that the following additions be made to the 1989 budget: Current Amended FINANCING PLAN Budget Changes Budget 065 Housing Informatio Off ice Fund 30131 Housing Infor tion Services -7299 Transfer from General Fund 138,535 54,089 192,624 All Other Fina cing 216,950 -- 216,950 All Other Fund Fina cing 20,500 -- 20,500 Total Fund Financin Plan 375,985 54,089 430,074 SPENDING PLAN 065 Housing Informatio Office Fund 30131 Housing Infor tion Services -0856 Data Pro essing Software -- 18,031 18,031 -0857 Data Pro essing Hardware 500 36,058 36,558 Al1 Other Spe ing 354,985 -- 354,985 All Other Fund Spe ding 20,5�0 -- 20,500 Total Fund Spendin Plan 375,985 54,089 430,074 NET CHANGE + 54,089 NOW THEREFORE BE I� RESOLVED, That the City Council approve these changes to the 1989 budget. i Approval Recommended: COUNCIL MEMBERS I Bud�e� Di ector Yeas Nays Requested by Departme o : � �.ong � In Favor coswitz ` Rettman Scheibel �_ Against By Sonnen � MAR 1 4198� Form Ap ro ed by Cit Attorne Adopted by Council: Dat Certified • sed by Coupcil Se tary By �1't�� B}. M � �a/ �� MAR 1 5 �989 Appr d Mayor for Submissi to ouncil "P A►pprov y iVlavor: Date By pUg�l�p MAR � 5 �� . . I . . •M . . . � . � . . . . . • I Attachment A . . . . ; :o: . � CITY OF SAINT PAUL �� lNTERDEPAR7MENTAI MEMORANDUM � September 27, 1988 TO: CHRIS L SH, Housing Information Officer � � �� FR: GREGOR J. HAUPT, Manager CIS �'- � f� Direct exte ion: 298-4985 RE: Proposed OS Computer Environment for HIO CC: Pamela Me dez, CIS Gale Haw on, CIS Jim Conkli , CIS Current Svstems C�nent hardware ' one(1)vintage Texas Instruments personal computer with DOS 2.0(we think), Lotus, Wo dStar and dBase. This is all that is available for the six HIO staff members and inte ns (usually one or two). Only a few staff inembers are familiar with one or more of the packages. Rice, Yost and Lukesh each use dBase and Lotus for specific needs. � What is Needed 1. An office- de client data base and housing resources data base accessible by a11 HTO personneL 2. Program-sp cific data bases (e.g., the BOSS program or the Shelter Board program) . for individu 1 program managers. • 3. Spreadshee� and, perhaps, statistical analysis capability for analysis/reporting. 4. Word proc��ssing capability. 5. Access to P anning and Economic Development Census data and data from various PED surve s (housing condition surveys, downtown survey)�. 6. Access to tl�e central PRIME-based: , i 1 May need be othing more complicated than diskettes from PED or it may mean access to PED files on the central�PRIME. I �. � � i i � � _ _ . �� •. . , Office System Prop sal For Housing Info tion Office (HIO) September 27, 1988 - Certi cate of Occupancy Subsyst��m of PRRIS2; - Envir nmental Health Subsystem of PRRIS3; - Rent Registration System (under development for Environmental Health); - Comp aint-Handling System for housing-related issues/complaints; - Electr�nic mail; - Finan�e system (for accounting data). Suggested Solution The suggested solu ion is a DOS-based Novel Ethernet network of diskless personal camputer workstati ns and a file server. In addition, we suggest purchase of an asynchronous serve to permit any of the HIU work$tations, or other Novel network works�ations, access to the central PRIMEs over CityLink. The asynchronous server would not be located in th Housing Information Office. The suggested solu ion is focused on automation, not data processing. A PRIME-based supernucrocompute solution was also considered. Its data processing capabilities are not indicated for HIO. e suggested solution is provides superior office automation power at equal or less cost nd does not require HIO personnel to become trained in the Unix operating system. e proposed solution, however, does not support CIS PRIME-based data pracessing app ications. This solution is co istent w�ith current city computer-related standards, as promulgated through the Inform ion Systems Policy Advisory Group(TSPAG), and is consistent with the Public Administrati n Service (PAS) Information Systems Master Plan. While System Ad 'nistrator training is part of the pro�osed solution and budget, HIO personnel would ne d to go through CIS-sponsored DOS, V4'ord Perfect and dBase training. Some specialized t 'ning from CIS Systems Analyst Elaine Treacy, Accounting Systems Analyst Elizabeth T desco, and CIS Manager Gregory Haupt would likely also be necessary 2 For placarded s"unfit for human habitation". 3 For placarded s "unfit for human habitation". 2 . � _ I� . . �0 ��r Office System Pro osal For Housing Info ation Office (HIO j September 27, 19 8 for use of PRI -based cer,tral software systems (PRRIS, Complaint System, Finance System, electronic mail). This training coul be arranged either for HIO as a group or individually, and may need to be supplemented y training from outside, third-party sources, depending upon your needs. The total project ost (excluding staff hours contributed by CIS personnel, for which there is no charge) is$5 ,089,as shown on the first attachment. Given timely budgetary decisions, we would expect t have the whole system in place and operational by July 1, 1989, with basic training for our people completed. We would want to "phase in" your use of the software packages getting people up to speed one piece at a time. Please note that i cluded in the proposed pruject budget is a $5,000 line item for dBase programming to a dress your unique data base needs. CIS does not currently have staff available to meet his need. Please let me kno if you ha�e any questions or concerns. If you or your staff would like to discuss this pro osal, I would be happy to do so. \hio�propose1.88 3 � { . . .-. �0 �-�S f�� Office System Pr osal For Housing Info�mation Office (HIO) September 27, 19$8 P oposed Housing Information Office System ffice Automation System Proposed by CIS Elements�of the System Element Cost FILE SERVER 386 Samsung M�icro Computer 1,695 20 meghz' 1 meg memory, mono monitor, 140 meg Hard rive 1,800 Hard Drive Co troller 250 2 meg Additio al Memory 1,035 Novel Netware ESL - 8 User 1,255 Ethernet 16 b t Card 415 Set-up of Fil Server 250 LaserJet Seri s II, 4 meg memory, soft fonts 3,700 WORRSTATION3 8 Novel PC AT Diskless Works�ations @ 2, 150 each 17,200 12 meghz 640k, VGA Color monitor, 4 expans on slots, Ethernet Card built in Tape Back-up 20 meg (Everex) 1,295 Set-up �8 @ $ 5) 200 SOFTAARE dBase 450 Clipper (dBas compiler) 400 Lotus 299 Word Per.fect ist Station) 395 Word Perfect Stations @ $75 each 600 Windows with icroSoft Mouse (8 @ $175) 1,400 COMMIINICATION SERVER CityLink, I-N t and Subscriber Drop 350 Novel ACS Sof ware with Ascom4 595 2 WNIM (4-por card) @ $895 1,790 1 Allen-Bradl y P� NIM card 650 Heath Zenith 248/12, VGA, 40 meg 3,350 MISCELLANEOIIS Dot Matrix Pr'nter 400 Network Inter ace Unit (2-port) 1,295 Supplies (cri pers, T connectors) 60 Ethernet Cabl 500 feet 325 9 Power Strip Surge Protectors 180 4 _ r . ��'9-a�� Office System Propo al For Housing Inform tion Office (HIO) September 27, 1988� APPLYCATION PRO R1�IMMING Contract Progra er 5, 00C1 TRAINING Training for 2 �taff (system administration) 400 47,034 15� Contingency 7,055 �OTAL 54,089 5 � ,.� . : -, _ � �i�Q-a�� . . � z � � � aN 3 E�-� � z 0 aW � H aaa �n www x � �n z oz � �aH � 3H � z 0 H a o � 00 3 H w a V � ~�+ H E D4 H w W � aH � H z w � H � Z z a H `� O � � W o � � � xH � aH W H � � ►-a O H o � �' � a H z A 3H z �n Z � A � H a o wa � z a� H a � � � H � 3 H oa � �n a oH aa wH OQW � t/� � H xHa °za � a z � � w � � � � o U a ww � � H . z w � � w � N \ � =. • : - �c�,c��.� � ��9-�� °'�'°- CITY OF SAINT PAUL �s ; � ��,��,�� ;� OFFICE OF THE MAYOR �. � HOUSING INFORMATION OFFICE ��• 21 W. Fourth Street GEORGE LATIMER Saint Paul,Minnesota 55102 MAYOR 612-298-5591 CHRISTINE LUKESH,Director Memorandum T0: Greg Blees FROM: Chris Luk sh �� DATE: January 6; 1989 RE: Justificati n for Housing Information Office Computer System Fund�ing In the City of S . Paul 1989 Budget Goals and Policies it states "employ good management riorities when planning for service delivery by including in the budget re uests money to pursue activities such as: office automation and c mputer applications that increase productivety; equipment modernization; w rk flow simplification. . ." Currently the HI is one of the few office's that is not automated. Computers would llow the office to provide a more effective service to the Mayor, City Council, other City Departments, and St. Paul citizens. The system that 's being proposed would fit into the existing City CIS system easily. The main goals o computerizing the HIO are to increase productivity, simplify workloa s, and increase information sharing and distribution in order to enhance policy decision making on housing issues in the City. Increased produc ivity and work simplification would include the ability to process paper wo k in a shorter period of time, and enable us to maintain records and have easy access to informa.tion and statistics. This will allow the office to sp nd more time on direct client services, relocation activities, special programs, such as B.O.S.S. , the Overnight Shelter Board, the McKinney Homeless Progra , and reports and assignments requested by the Ma.yor and City Council. I addition, computers would assist me greatly in budget pre- paration and gi e me more time to work on quality performa.nce and strategic planning. Some of the specific types of record maintenance and information sharing will include the fol owing: l. HIO statistics on calls, walk-ins, informational requests, and com laints. 2. Reports, code condemnations, client files, and special program =, data. . .:d ! 1��:� ' r �,l i; m<,��. �.,>.s;+'`°° as�-��5 . � .�- ��9 -�� ' � Page 2 I 3. Budge� Informa.tion. 4. Apart�Uent and rental listings. 5. Demog�aphics on client populations. 6. Typesllof housing requests/needs. 7. Resultls of relocation efforts to be published and problems associ�ated with relocation efforts. 8. Informlation on specific groups of clients served, i.e. Southeast Asiansl, minorities, displaced workers, homeless, single parents, etc. The bottom lin�e is that computers will allow HIO to provide more information, in a shorter p�riod of time which can be instrumental in policy decisions regarding hous�ng types, numbers, and sizes, along with services related to socio-economic issues. In addition, code related issues can be better monitored if m re thorough results are maintained. Automation will connect the HIO with o her City Departments to streamline information and finally it will allow the office to provide more quality time with St. Paul Citizens requesting ourlassi.stance. If you would l�ke to talk to me about this further, I'd be happy to meet with you. CL:kp I I � � I • � ' � l// V i{�1f!� � COUNCIL ADOPTED 1989 BUDGET GENERAL CONTINGENT RESERVE (09060-0537) as of January 23, 1989 Council Changes/Transfers Adopted ------------------------------- 1989 Council Budget File Date Amount Available ---------- --------- ------- ------------ ------------ Beginning Balance 206,000 Human Rights Director S arch pending (29,800) D.A.R.E. Grant Match (P lice) pending (21,000) Helping Hand Strategic lanning Increase pending (12,200) Mpls/St. Paul House To Promotion pending (15,000) EFS Rental Assistance C ntract pending (33,000) HIO Automation pending (54,089) ----------- ------------ ------------ Ending Balance 206,000 (165,089) 40,911 pending - Pending action y the Finance Committee or identified but not yet submitted by the department. withdrawn - Request with rawn before council action OMBS/J'eanetta 700/GRESRV89.wk1 1/23/89 i . , , , `C;��°�� 9. kesa 1 u l:i�n �!9--`Lfi - �rr�e��i!i ng the 1 yti9 t�uc!uet by Apprc�veu 3-�] ddd i ng $54,OH9 t the F i rti�+ic i rtg ancy Spcnd i ng P 1 ans for' H�us i ng I nfo ria t i on Us=f i ce Data Proces5 i r�g. (I�efprr�G trom C �nr�i i Febr�.�ary !6) i 0. kesa 1 ut i or, 8`�-•28 - an�end i�g the 1989 budget by A}�prov�cl 3-U transferr �riy $�i, 23 fron� Conr.i r�gr��t Reser�ve t.c� Currnnun i ty �rrv i c .s. (ke�`erreu fr�om Counc i 1 Fe�r��r'y 21 i ' ! 1 . Keso 1 u G i un $9-36 - amend i r�g t;�2 1�ti9 budc�et by Aporoved 2-1 add i ng �96,OUO t th�e F i nanc i n� anr� ;;pend i ng P�ans C:i ty W i c�e Data :'�oc�s s i ng F ur�c� fiur C i ty Caunc i I l�ata F'roc.e�si r�� ; ystem crid Lo�ri I Area Network. (KeF�i�r�ed from C �unci 1 FNbruary 28) 12. kesalution 89-37 - amen�iing the 1989 budget Ap�r�oved '3-0 l�y aUd i ng $2 i U,0 U to the F�i nanc i ng and Sp�r�d i ny P i ar�s for F i re C� partment Master ('i an. (h�fe�'re� fram C uncil February Z$) 13. Urdinan�e 89-30�1 - amer�dir�g Chapter 86 of the Approved as amended Adrninistrative C de pertainin� to signing af 3-U c�ntracts, deeds bonds and checks by providing that execution o" any contract in tne amount of $5U,OQ0 or m�r�e y the Numan Rights Director is not requ i re�� wt�e the ��rson or ent i ty the C i Ly is �onti�actinq with has five or less full-time employees. (Refi rreci from Cauncil F�ebruary 23} 14. Hesolution 89-2811 - es�tabl �shing the rate of pay A�proved 3-0 for Ou�lichting quipment Cipera�or in Grade 29, Sr-.ction [D1, in he Salary Plan ar�d hates ot Co�nuensat i on Res I ut i on. (�eferred fr�:�m CGUt1C 1 � rebruary 21 ) 1�. Urd i nance �i9-�49 - amend i ng Sect i on 3ti.U7 of the Appr�aved 3-U Ad�ii i r�i strar_i ve C:-de perte�n i r+g to �aynier��t of sever- a�7ce pay �nc1 d I I ��w i ng payme��t i n 1 ump ��m or annua 1 i nsta 1 1 ments. (K��f�erreG f rorn C�u��c i 1 February 23) 16. hceport from Pers rinel ()ffic� on status of Public Laid over to 3/�0 W�rks Program �GOrd i nat�r pc�s i t i c�n. 17. Ois�:.us,i�n of 8 r�a� ot Mediation Servic�es Urder Discussed a��,ea 1 w i t.hdt��w:.: 1 and �,�p 1 i cat,i or� �hereat. A.�,�� r i�.;r-,a� t te+�� 123. ReSO 1 ut i on �,9-3`_% - �rnenu i ng tt�e 1��'Y,`.i bud�3et by �1�;�r�oved as arnenraed d�_!d i r�c� �'�,t)00 �� ti��e F'i r�anc i ng and S�end i ng F'M ar�s i o� Gerrle��a 1 Rrve ur f�ur�c1 C i ty Cour�c i 1 Adm i n i stra- � i r�n for. Futui�e ivCAA i�ournan?ents �.o be he 1 d i n tt�e r_ity, (kef rred from Counr_i � March 2) . .... . . .... .. _ . . - . ._ .. . .. . . . _ _ � - . . . . . _.. . .. .. _ . _ .. . . .. . __. . ...__ ....____. -.-'�. �, = GITY OF SAINT PAUL � ` � �i�'Isik��i 73� � - � . � - —3I`-�-- OFFICF. OF TAE CITY COUNCIL Committee Report Finance. Management. & Personnel Committee Marct� 6. 1969 1 . H�t=�r uva 1 c,t �r�i r�ui.ey ofi n,�et i r-�cYS r,r l d r"ear uarY t� and 1 i. Approved �. R�solutian 89-229 - appr�vin� Wage and Benefit Policy Laid over La 3/20 fior� non-��epre5ei�ted rnanagement per�onne 1 . (Referred f r�orn C��unc i 1 F e��-uar�y I 6) 3. Resr�lutiori 89-�6U - ame��ling tr�e 1989 budget bY Ar�pr-ov�d �--0 add i r�g �59,51':� to �tre F i nar�c i ng and SF>Er�d i ng �1 ar�s for ass�s:�rnent' Ser�vice charge storrn sewer canstruction. (Referreci fir'om Cc�unci 1 Fet.�ruary 15} <►. Resolution 89-��i2 - amendin�a the 1989 budget by Approvea 3-0 adU i ng �i830,b 17 to the F i ndnc i ri� ar�c! 5per�d i ng P i ans fur Nub 1 i c Wo�-ks Eny i neez-i r�g Fund for C i ty Rec�1c i i ng F'roc�r air�. (�efer red f rorr� Cc>unt i 1 Fe�aruar y 16 i 5. Re�o 1 ut i on 89-�63 - ame+id i r�g the 1 q89 buciget by Ap�roved 3-0 �tir�i nc� ;��9, !C�G t.o the F 7 ila�+C i rl�� cr��i SF�end i nn F'I an5 - t�7► F'o I i ce Gener-a 1 Tra+n i nq for� purchasa nf p i sto 1 s. (Ret-Nr r Pd f i�on� Counc i I f=ebruar,y 16} E�. K�SOlution 89-2h4 - amending the 19$9 budgPt by Ar��roved 3-0 tr��r�sfNr�r�i r�t�� a. 1 UO f-rom Po� �ce 5F>ec i a 1 Pro j��t s Rrspo!�s i ve S�r�v i r_e�� ta h'o i i ce ��er�era i F und Tra i n i ng lh°i�t For �th� purtt�a;e ��f p i st.o 1 s. (Referred rrom C�uncil February lE;) 7. Aclm i n i s h�a't i ve Order' U-1 C1G92 - autho�'i z i ng D i scussecl payr��ent: fat- t.r�ve i cost� of Sc�t. W i i � for �rnc�1�yr„ent i nterv i zw. (ReferrN�� f rorn Counc i 1 �e1�r uar'y 16? 8. Re5<,i�r i�an 89-2�5 - amer7d i r�g th� 19$9 bucJ��et by A(�proveU 3-li � r.r�nsterr;��y $`_��,�89 f"ri>n�� General G��ver�r,mer�t Ar_count:s to Ex��::ut i ve Aciin i n i str at i un-H��us i ng Ir,r�,rrr�at.iori caif" ir�e Contr9t�uLior�. (Rererred t t'uin C��i.�rti:i i Fe�ru�r'y l61 CITY HALL SEVENTH FLOOR SAIN? PAUL, MINNESOTA 55102 B�b48