HomeMy WebLinkAboutTR-50-98
DN;'TR- 50 -98
THE CORPORATION OF THE MUNICIPALITY OF CLARINGTON
REPORT
Meeti ng:
General Purpose and Administration Committee
File #
Date:
June 22, 1998
Res. #G r~q - 3'87~('1:3
Report #:
TR-SO-98
FILE #: DEV
By-law #
Subject:
YEAR 2000 COMPLIANCE - UPDATE
Recommendations:
It is respectfully recommended that the General Purpose and Administration Committee
recommend to Council the following:
1. THAT Report TR-SO-98 be received for information.
BACKGROUND AND COMMENT
1.0 The Municipality of Clarington is in the process of addressing the year 2000
compliance issue. The Treasury department is coordinating the effort to ensure that
the date sensitive systems are year 2000 compliant. To date the focus has primarily
been on the technology and the financial systems.
2.0 3C Complete Computer Consulting Inc. is currently working to ensure our
computerized accounting systems are year 2000 compliant. As outlined in the
correspondence in Attachment A, the expected completion date of the
modifications to the accounting applications is October 1998.
3.0 The new system installations in 1998 that are the tax collection system and the
G.I.S. system are both year 2000 compliant. As indicated in the Vailtech news
release, Attachment B, Vailtech's new software release accomodates a 4 digit entry
for the year. This is the release the municipality is currently using.
4.0 The municipality currently uses ScotiaPay Plus for the payroll services. Per report
TR-17-98, approval was given to staff to commit to ADP Canada's AutoPay system
which is fully year 2000 compliant.
807
REPORT NO.: TR-50-98
PAGE 2
5.0 Over the summer months the Treasury department will co-ordinate with the other
departments to identify all other 'date sensitive' systems and review them to ensure
they are year 2000 compliant. This will allow the municipality to provide
uninterrupted service into the new millennium.
Respectfully submitted,
Reviewed by,
"
~
W.H. Stockwell,
Chief Administrative Officer.
'de Marano, H.BSs., A.M.C.T.,
Treasurer
MM*KS*km
Attach.
808
~G
~
Complete
Computer
Consulting
Inc.
mm~ffiilW~~
. JUN 0 4 1998
ATTACHMENT "A"
rvllJr~iCIP!',UTY or: CUlli; .ciTON
I'liJArJCE
I DISTRIBUTION 1
I ORIGINAL: !1~ !
Dr. . !
! CC 11 Deputy i I
~ ? i ACcc(.;;i!ar.t _~
: 1\ Pu~ ~I.G' ,
· '--.' 1.1\1._,. i
i ~; Pavr~~, Clk :
I 51 Tax Coli I
16) I
7) J
Wednesday, June 03, 1998
Marie Marano
Treasurer
Municipality of Clarington
40 Temperance Street
Bowmanville, Ontario
LIC 3A6
Marie, as per our conversation regarding your Accounting Application Software for the year 2000.
This letter is to serve as notification that 3C Complete Computer Consulting Inc. has started the
modifications to the following Accounting Applications,
General Ledger
Accounts Receivable
Accounts Payable
Purchase Order
The modifications and testing are expected to be completed by the end of October with
implementation in November of 1998.
Marie, if you have any questions please do not hesitate to call me at 1-905-882-2111.
Sincerely,
-----._--~
r--r::- ./
~ .- ~" -~
.'[ c?J / <......e...--1...e~
(~.
Tony Pereira
11 Sims Crescent
Unit 1
Richmond Hill. Ontario
Canada L48 1 C9
Tel. (905) 882-2111
Fax. (905) 882-2116
809
~
--
~
ATTACHMENT "B"
,\\ VAIL TECH NEWS
Yea' 2000 Compliance
The municipality's Vailtech accounting applications run on an Unix operating system and an
lnformix database. The Informix database software acts as the repository of all data generated by
Yailtech applications Within the applications, where it llses a two (2) digit data entry field for
the year, the application sends the two (2) digits to Infomlix for storage. When encountering a
t\vo (2) digit year, Informix will prefix the digits with "19"'. When a user enters the digits "98"
within a Vaille<:h application, the lnformix database will store the digits as "1998". ^ problem
will occur if a user enters a two (2) digit year as "00". Informix "ill store "00" as "1900".
To alleviate the situation described above, Vailtcch will release new versions' of its software to
maintenance customers, modifying any two (2) digit entries for year to four (4) digits. Tn the new
releases users will he required to enter "1998" instead of"98"', or <<2000" instead of"OO". This
change has already been made in some applications such as the Tnformix-based Tax system.
Please remember that Vailtech applications arc only one component of your computer
environment, and that your maintenance support agreement only covers new releases for
Vail tech applications. Vailtech cannot comment on the year 2000 compliance of the syslt:m '::;
operating system, or database. The municipality must ensure that their version of informi, will
interpret a four digit year correctly.
Graplllcal Software
Yailtech continuc<; to develop its new graphical, client server applications which run in stnndord
nct\\'wked environments, most particularly Microsoft NT server, Microsoft NT client, Windows
'95, and Oracle Vailtech's graphical Tax system is now operational in sixteen (16) large Ontario
municipalities ranging in population between 50,000 to over 300,000 people. Vailtech's
client/server, graphical applications ure supplied as a no-charge upgrade for l11ainl<:nancc
custolllers, please note that associated costs such as c(111versi(lll~ services, installation services,
training ~ef\'kes, etc, will be billed.
Challges fa Tax Sysfem/of Leglslafb'(! Cltaltge.t
^ two (2) day ('Tax Legislation Workshop" was held in Ottawa on March 26 and 27, 1998. The
workshop was hosted by Vailtech and was attended by a cross section of Tax system use~. Roth
the lnformix-based tax system and the cJicnt/scn'er version are being modified in order to
comply \vith the legislative changes. Vailte<.:h will deliver new versions of the Tax system to
maintenance <.:ustomers by the end of May, 1998 At the same time as the version releas-=,
Yailtech will offer it's customers a standard tax bill print. Should the municipality not \\i~h t(,
use the standard tux bill print and wishes to llse it's own desi~n, please contact Vailtech so we
may program a custom bill print. Programming for custom bill prints is a chargeable 5CT\'ice
For more information, please contpct Vaihcch at (613) 224-5111.
04/23/98
810