Patch History by qfa20129

VIEWS: 89 PAGES: 15

									Patch History for 07/26/07 TraCSPack
Note: All patches are cumulative. You only have to install the most current patch
to get the benefit of all previous patches. Most current TraCS patch should be
installed after TraCS pack, not before.

                                     Current
081409—This patch isn’t mandatory

   Update Codes_Department table:
      o Added UW Stout PD
      o Updated Walworth COS name to WALWORTH CO SHERIFF OFFICE
      o Assign TAS Numbers 355-365
                                          TOWN OF
UW STOUT PD     355 MERRILLAN PD      358 TURTLE           362
PLAINFIELD PD   356 MELROSE PD        359 KEWASKUM PD      363
TAYLOR PD       357 ALMA CENTER PD    360 MONTELLO PD      364
                   TOWN OFMILTON      361 RICHLAND COS     365
   Update Violations_WI table:
      o Updated OAR and statutes
      o Updated 343.44(1)(b) and 343.44(1)(am) forfeiture amounts
      o Deleted 343.44(1)(b) severity codes 001-008
   Updated Violations_MUNI table:
      o Updated statutes
   Updated CitCourt table:
      o Eastern Columbia County Municipal court-Poynette address: 118 to 106 and
          53953 to 53955
      o Updated Mid-Moraine Municipal Court Village of Grafton name and address.
      o Updated Fontana Municipal Court address: 175 State HWY 67 / PO Box 114
      o Updated Manitowoc City Municipal Court street address: 900 Quay Street
      o Updated Cameron Municipal Court address: 300 N. 1st street / PO BOX 387
      o Added Roberts Village Municipal Court
      o Updated Somerset Village Muni Court address: Remove phone # and Email
      o Combined Schofield and Weston Municipal courts to: Schofield Weston
          Municipal Court. Are setup for COWS
      o Reversed address of Lakeside Municipal Court and Lakeside Village
          Municipal court-Fond du Lac
      o Updated Menomonee Falls Village Municipal Court ZipCode to 53051
      o Added Waukesha County Juvenile Center, 521 Riverview Ave, Rm JC130
070109—This patch IS MANDATORY.

   Update Violations_WI table:
      o Updated DA Flag
      o Remove Rail Road surcharge bond amounts for municipal courts
               346.44(1)(a-c)
               346.44(2)
               346.45(1)(a-e)
               346.46(3)
               346.62(2m)
      o Updated bond amounts to reflect the ―Justice Info Surcharge‖ (+$9.50) and
          ―Crime Lab and Drug Law Enforcement Surcharge‖ (+$5.00)
      o Updated bond amounts for 346.44(1)

   Update Codes-Jurisdiction table
      o Added Endeavor Police Department

   Update CitCourt table:
      o Updated ―Mt Pleasant Town Muni Court‖ to ―Mount Pleasant Village Municipal
          Court‖
      o Change Horicon court from CW to MC (RTE_TYCD)
      o Updated Gillett court to COWS
      o Updated Waukesha Circuit Court address-added RM CG-49
      o Updated Kenosha court room number from 228 to 300
      o Added Eastern Dane County Joint Municipal Court-Cambridge
      o Added Eastern Dane County Joint Municipal Court-Deerfield
      o Added Eastern Dane County Joint Municipal Court-Rockdale
      o Added Eastern Columbia County Municipal Court-Poynette

   Update Codes_Department table:
      o Assign TAS Numbers 347- 354
        Racine PD     Sturtevant PD   Janesville PD   Lake Geneva PD
        Gillett PD    Adams County    Hammond PD      UW La Crosse PD




                                      Historical
050109-- This patch is not mandatory.
 Updated Violations_MUNI table:
     o Delete 943.20(1), 943.50(1m)
     o Change DA Flag to YES, 946.41(1)
     o Change to 2 points
              TR305.32(4)(b)2, VENT/SIDE WINDOW EXCESSIVE TINTING
              TR305.32(5)(b), REAR WINDOW EXCESSIVE TINTING
      o Added
              134.66(2)(a)-Retail Sale of Tobacco to Minor
              943.14-Criminal Trespass to Dwelling
              346.29(2)-Standing on Roadway
              941.23-Carrying a Concealed Weapon
              346.80(4)-Bicycle/Moped/EPAMD Prohibited Riding
              943.20(1)(e)-Theft, Written Lease
              943.20(1)(a)-Theft, Movable Property
   Update Violations_WI table:
      o Delete severity8, Manuf/Deliver Cocaine (>40g)
   Update Codes_Department table:
      o Sturgeon Bay Address and Phone Update
      o Assign TAS number:
               Athens PD          Germantown PD             Potosi PD
               Cottage Grove PD   Hazel Green PD            Richland Center PD
               Cuba City PD       Iola PD                   Roberts PD
               Cudahy PD          Kendall PD                Spencer PD
               De Forest PD       Lac du Flambeau Tribal PD Stoughton PD
               Dickeyville PD     Lancaster PD              Stratford PD
               Dodge County SO    Marathon PD               UW Oshkosh
               Edgar PD           Muscoda PD                UW Platteville PD
               Everest Metro PD   Pleasant Prairie PD       Verona PD
               Fennimore PD       Polk County SO            Warrens PD
                                                            Waunakee PD
   Update CitCourt table:
      o Shawano City Municipal Court to Shawano-Bonduel Municipal Court
      o Changed Fontana Municipal court address, 185 Valley View Drive P.O. Box
          114
      o Change Wausau Municipal Court Zip from 54401 to 54403
      o Add Lakeside Village Municipal Court- Fond du Lac

031409—This patch is mandatory due to a recently discovered data error in deer/other
animal crash reporting to DOT.

       Corrected data error in deer/other animal crash reporting to DOT
       Updated statute table:
           o Removed court costs from 346.63(1)(b) Operating with PAC >= .08 <.10
              (1st).
           o Changed 23.33(4c)(a)2 Operate ATV W/PAC >=.08 <.10 (PASS. <16) to a
              non-criminal offense.
           o Changed description for TR327.05(3)(a), TR327.05(3)(b), TR327.05(3)(c)
              from ―INTERSTATE‖ to ―INTRASTATE‖.
           o Sorted municipal statute table.
       Updated department table:
           o Updated ORI (NCIC) number for La Crosse PD.
           o Updated Sheboygan police department address.
         o Updated Mt Pleasant police department address.
         o Added Canadian Pacific Railroad Police
      Updated court table:
         o Updated Bloomfield Municipal Court address.
         o Updated Mid-Moraine Cedarburg Municipal Court address.
         o Updated Lake Country Municipal Court for Municipal Court Queue
             eCitation routing.
         o Updated Wrightstown Municipal Court address.

021409—This patch is not mandatory, but highly recommended.

      2009 Bond Book updates:

       New statutes:

       350.10(1)(gm)~OPER SNOWMOBILE GREATER THAN 55MPH WHEN DARK (1-10 OVER)
       350.10(1)(gm)~OPER SNOWMOBILE GREATER THAN 55MPH WHEN DARK (11-20 OVER)
       350.10(1)(gm)~OPER SNOWMOBILE GREATER THAN 55MPH WHEN DARK (21-30 OVER)
       350.10(1)(gm)~OPER SNOWMOBILE GREATER THAN 55MPH WHEN DARK (31+ OVER)
       350.17(2)~SNOWMOBILER/ REFUSE TO STOP/ OFFICER
       120.12(20)~TOBACCO USE IN SCHOOLS (MUNI citation only)

       Bond amount changed for 218.0114(1) and 343.18(1)

       Statute # change from 347.43(1) to 347.43(1s)
       Points added to TR305.32(4)(b)2 and TR305.32(5)(b)

       Statutes deleted:

       343.18(1)    004    OPERATE W/O CARRY.RESTRICTION CARD(2ND+)
       343.18(1)    003    OPERATE W/O CARRYING RESTRICTIONS CARD

      Enhancement to e-citation log
      Address update for Town of Brookfield Municipal Court
      Address update for Wabeno Municipal Court
      TAS Agency number assigned to Glenwood City
      Pleasant Prairie Village Municipal Court set up for Municipal Court Queue
       delivery
      Stanley City Municipal Court set up for COWS delivery
      Court cost for Hortonville Municipal Court set to $23.00


011409—This patch is mandatory.
    Updated Codes-CitCourts
       o Update routing code for Wabeno Municipal Court to CW.
    Updated Codes_Department
         o   Assigned TAS agency codes to Grant County Sheriff, Wabeno PD, Laona
            PD, and Fremont PD
         o Updated Tomah police department address
         o Updated Town of Brookfield police department phone number
    Bug fix—Citations will now route correctly when DA routing code is changed after
     issuance.
121208—This patch is not mandatory.
    Updated Codes-CitCourts
         o Update Williams Bay Municipal Court cost to $25.00
         o Updated Williams Bay Municipal Court to COWS routing.
         o Updated Washburn County Circuit Court address.
         o Updated Kaukauna City Municipal Court to Muni Court Queue routing.
         o Updated Wauwatosa Municpal Court address.
         o Updated Village of Wrightstown Municipal Court to COWS routing.
         o Updated Silver Lake Municipal Court to COWS routing.
    Updated Codes_Department
         o Updated Town of Geneva ORI # to WI0651200
         o Updated address for State Patrol Tomah Post
         o Updated room numbers for Winnebago County Circuit Court Branches 2
            and 5.

111908— This patch is not mandatory
    Updated eCitation transmission DLL so that it works regardless of the directory
     TraCS is installed in.
    Updated XSLT style sheet for crash to capture plate state on deer crash and to
     capture form status at time of transmission for all crash forms.
    Add TAS agency numbers for New Holstein and St. Francis
    Updated Kewaunee Circuit Court address.
    Updated Insurance table
    Updated highway table.
    Added the following statutes:
      TR327.05(3)(a)~INTERSTATE RECORD OF DUTY STATUS
      TR327.05(3)(a)~INTRASTATE HOURS OF SERVICE
      TR327.05(3)(a)~VIOLATION OF OUT OF SERVICE NOTICE
      TR327.05(3)(a)~RECORD OF DUTY STATUS-VIOLATION
      TR327.05(3)(b)~INTERSTATE RECORD OF DUTY STATUS
      TR327.05(3)(b)~INTRASTATE HOURS OF SERVICE
      TR327.05(3)(b)~VIOLATION OF OUT OF SERVICE NOTICE
      TR327.05(3)(b)~RECORD OF DUTY STATUS-VIOLATION
      TR327.05(3)(c)~INTERSTATE RECORD OF SERVICE
      TR327.05(3)(c)~INTRASTATE HOURS OF SERVICE
      TR327.05(3)(c)~RECORD OF DUTY STATUS
      348.27(9m)(a)1~RAW FOREST PRODUCTS - OVRWGT VIOLATION
      348.27(9m)(a)1~RAW FOREST PRODUCTS - OVRWGT VIOLATION
        (2ND+)
       348.27(9m)(a)2~BULK POTATOES - OVERWEIGHT VIOLATION
       348.27(9m)(a)2~BULK POTATOES - OVERWEIGHT VIOLATION (2ND+)
       348.27(11m)(a)~VIOLATE AGRICULTURAL EMERGENCY PERMIT
       348.27(11m)(a)~VIOLATE AGRICULTURAL EMERG PERMIT (2+)
       346.94(18)~EPAMD VIOLATION ON ROADWAY/SIDEWALK
       346.94(18)~EPAMD VIOLATION ON ROADWAY/SIDEWALK (2+)
       346.94(19)(a)~OPERATE OFF-ROAD UTILITY VEH. ON ROADWAY
       346.94(19)(b)~OPERATE OFF-ROAD UTILITY VEH. ON HIGHWAY
      
Deleted the following statutes: TR327.05(5) TR327.05(6) TR327.05(3)

101708 -- This patch is not mandatory

      Modified the Violations_WI table for the following statutes:
         1. Corrected the word TRAFIC to TRAFFIC on 2 statutes for 346.04(2)
         2. Corrected the word INTRASTATE to INTERSTATE for Trans Rule
              TR325.02(4).
         3. Corrected the word MILAGE to MILEAGE on two 342.155(1)(b) statutes,
              two 342.155(3) statutes, two 342.156(2) statutes, two 342.156(3) statutes
              and one 342.16(1g) statute.
         4. Changed four 346.9 statutes to 346.90. The zero was missing.
         5. Corrected bond amount on statute 346.63(1)(b). It should not be $250.00

      Modified the Violations_MUNI table for the following statutes:
         1. Corrected statute 254.92 POSSESION OR PURCHASE OF TOBACCO
              BY MINOR to make it non-criminal.

      Changes to Codes_Department table:
         1. Updated mailing address for Jackson County.
         2. Updated zip code of Eau Claire County Sheriff from 54701 to 54703
         3. Changed NCIC numbers to the correct values for Town of Ripon,
            Rosendale and Brandon-Fairwater.

      Changed Black River Falls to Black River Fall in Codes_IACities table to prevent
         errors on end shifting too long of an agency name.

      Changes to the Codes – CitCourts table:
         1. Added Reedsburg Municipal Court. Added this court as a TIPPS court.
         2. Added Delafield City Municipal Court
         3. Changed address of Sauk County Circuit Court to add Room 320.
         4. Changed address of Kewaunee County Circuit Court to new address.
         5. Updated New London Municipal Court, Wauwatosa City Municipal Court,
            Kiel City Municipal Court - Calumet, Kiel City Municipal Court –
            Manitowoc, Menasha Town Municipal Court, Bloomfield Town Municipal
            Court and Hortonville Village Municipal Court to COWS courts.
         6. Changed Wrightstown Municipal Court from COWS court to TIPPS court.
          7. Changed address of Hudson City Municipal Court

         Updated tables Codes - PlateType, Codes – PlateTypeByVehicleUnit and
          Codes – PlateTypeByOpClassEndorsement for LIF, MCM, RVD, TRP, and
          WHC plate types.

090508 -- This patch is not mandatory

      Modified the Violations_WI table for the following statutes:
         1. Added statute 343.22(1) – FAIL/NOTIFY DMF OF ADDRESS/NAME
              CHANGE
         2. Changed statutes 346.63(2)(a)2 with severity of 001 and 002. The severity
              001 showed as criminal and the 002 showed as a misdemeanor. The
              severity 001 was changed to the misdemeanor and the 002 was changed
              to the criminal.
         3. Deleted statute 343.43(1)(d) with severity 012 – VIOLATE GDL
              RESTRICTIONS – PASSENGER (3RD+). This statute is no longer valid.

      Changes to the Codes – CitCourts table:
         8. Updated Crivitz Municipal Court address with PO Box 176.
         9. Updated Coleman Village Municipal Court, Peshtigo City Municipal Court,
            Niagara City Municipal Court, Marinette City Municipal Court and Fontana
            Village Municipal Court to COWS courts.

      Assigned TAS agency numbers in Codes_Department table for:
          1. Town of Bloomfield Police Department – TAS number 308
          2. Changed NCIC number for Fox Valley Metro PD to WI0450400

    Changes to DB2PROD_DT_CNTY_MUNI_ZIP table.
Corrected Village of Weyerhaeuser Municipality name.

081508 -- This patch is mandatory because of CCAP statute changes.

      Changed the following statutes on the Violations_MUNI table to make these
       statutes ordinance violations and not misdemeanor violations.
       Statute Description
       947.01     - Disorderly Conduct
       167.10(3)) – Fireworks Violation
       943.24(1) – Issue Worthless Checks

      Modified the following statutes on the Violations_WI table. Please delete
       shortcuts OWI5, PCS5 and PAC5 from your shortcut table. You may then re-add
       them using the newest statutes added below.

       Deleted Statutes
       Statute Severity Description
       346.63(1)(a)   011    OPERATING WHILE INTOX. (5TH+)
       346.63(1)(am) 003     OPERATE WITH CONTROL SUBSTANCE (5TH)
       346.63(1)(b)  011     OPERATING WITH PAC OF .02 OR MORE (5TH+)

       Added Statutes
       Statute Severity Description
       346.63(1)(a)    012   OPERATING WHILE UNDER INFLUENCE (5TH OR 6TH)
       346.63(1)(a)    013   OPERATING WHILE UNDER INFLUENCE (7TH, 8TH OR 9TH)
       346.63(1)(a)    014   OPERATING WHILE UNDER INFLUENCE (10TH OR MORE)
       346.63(1)(am)   011   OPERATE WITH CONTROLLED SUBSTANCE (5TH OR 6TH)
       346.63(1)(am)   012   OPER WITH CONTROLLED SUBSTANCE (7TH, 8TH OR 9TH)
       346.63(1)(am)   013   OPER WITH CONTROLLED SUBSTANCE (10TH OR MORE)
       346.63(1)(b)    015   OPERATING WITH PAC OF .02 OR MORE (5TH OR 6TH)
       346.63(1)(b)    016   OPERATING WITH PAC OF .02 OR MORE (7TH, 8TH OR 9TH)
       346.63(1)(b)    017   OPERATING WITH PAC OF .02 OR MORE (10TH OR MORE)

      Changes to the Codes – CitCourts table:
         10. Added COWS Court flags for Omro Municipal Court.
         11. Updated Northern Waupaca County Joint Municipal Court.
         12. Updated Columbia County Court address with PO Box 587.
         13. Updated Shiocton Village Municipal Court address.
         14. Changed Sparta Municipal Court to a TIPPS court


      Changed State Patrol Southwest Region Headquarters Zip code extension from
       0610 to 1971 in Codes_Department table.

      Assigned TAS agency numbers in Codes_Department table for:
             3. New Berlin Police Department – TAS number 304
             4. Fall River Police Department – TAS number 305
             5. Delafield Police Department -- TAS number 306
             6. Trempealeau County Sheriff’s Dept – TAS number 307


      Codes - Insurance table updated with new insurance information

      Replaced Crash_DocumentNumber.grp This fixes a problem where a crash
       would abend at endshift if this group contained multiple occurrences.



072408 -- This patch is not mandatory

      A Spanish version of the Municipal citation has been created and made available
       for printing as a courtesy copy. This is a statutory requirement for the City of
       Milwaukee.

      Changed ELCI.val validation rule. When the routing to DA flag is reset after
       issuance, the routing was not getting changed. Also added Error code 501 to not
       allow validation of a citation that does not contain a statute description. This will
       occur if an obsolete shortcut code is used.

      Changed Bond amounts for Statutes 346.505(2)(a), 346.505(2)(b) and
       346.505(2)(c) from $155.00 to $205.00 in Violations_WI table

      Codes – DomesticatedAnimal table was updated with ―CATTLE‖,
       ―WILD CAT‖, ―WILD CATS‖, ―WILD DOG‖ and ―WILD DOGS‖.

      Changes to the Codes – CitCourts table:
         15. Rothschild Municipal Court court costs changed from $23.00 to $28.00.
         16. Sparta Municipal Court court costs changed from $28.00 to $21.00.
         17. Added COWS court flags for Elm Grove, Windsor Town and Madison
                Town – Middleton Municipal courts.
         18. Added TIPPS court flag for Little Chute Village Municipal court.

      TAS agency code assigned to Stanley PD (303) to Codes_Department table.
       Changed NCIC number for Fox Valley Metro PD to WI0450400

      Codes - Insurance table updated with new insurance information



060508 -- This patch is not mandatory

          Changes to the Codes – CitCourts table:
             19. Added New London Municipal Court..
             20. Fixed Agency code for Grand Rapids Municipal Court
             21. Fixed Agency code for Hidden Valley Municipal Court

          Changes to the Codes_Department table.
             1. Changed Princeton PD address
             2. Added TAS Agency numbers for Belleville, Boulder Junction, Lake
                Delton, Mellon and Tigerton.

          Codes - Insurance table updated with new insurance information

          Codes - Highways table updated with new highways.

          Violations_WI table changed to correct statute descriptions for TR327.03(3)
           Intrastate Driving Reqmts and TR327.05 Intrastate Record of Duty Status.
           Both of these were worded InterState instead of IntraState

          TableManager utility changed to include Violations_Local under the
           distribution tab. This was inadvertently removed.
051008 -- This patch is not mandatory

         Additions to the Violations_MUNI table.
            1. Added these statutes to the table
                  946.41(1)     RESIST OR OBSTRUCT AN OFFICER

                 947.01         DISORDERLY CONDUCT
                 943.50(1m)     RETAIL THEFT
                 167.10(3)(a)   FIREWORKS VIOLATION
                 943.46(2)(a)   THEFT OF CABLE T.V. SERVICE
                 174.042(1)(a) ALLOW DOG TO RUN AT LARGE
                 943.01(1)      DAMAGE TO PROPERTY
                 947.012(1)     UNLAWFUL USE OF TELEPHONE
                 125.07(3)      ALLOW UNDERAGE ON LICENSED PREMISES
                 943.21(1m)     FRAUD ON HOTEL,RESTAURANT, OR GAS STATION
                 943.20 (1)     THEFT
                 943.24(1)      ISSUE WORTHLESS CHECKS
                 947.0125(3)    UNLAWFUL USE OF COMPUTERIZED COMMUNICATIONS
                 946.41(1)      RESIST OR OBSTRUCT AN OFFICER
                 947.01         DISORDERLY CONDUCT
                 254.92(2)      POSSESSION OR PURCHASE OF TOBACCO BY MINOR


         Changes to the Codes – CitCourts table:
            22. Added Grand Rapids Municipal Court..
            23. Changed Hobart postal address to no longer use Oneida for the city.
            24. Updated COWS and Municipal court routing codes to prepare for
                ecitation.

         Changes to the Codes_Department table.
            3. Changed Kewaunee County Sheriffs Depar to Kewaunee County
               Sheriffs Dept.

         Codes - Insurance table updated with new insurance information
         Codes - Highways table updated with new highways.

         Codes – PlateTypeByOpClassEndorsement and Codes -
          PlateTypeByVehicleUnit updated to remove Plate type LTL from Unit type
          of Auto, Vehicle Type of auto. A trailer plate should not be a allowable entry
          on a power unit.
040708 -- This patch is mandatory for Workstations only. It is highly recommended for
          Field units due to the increase in OWI & PAC bond amounts.

         Fixed a bug in the ELCI and MUNI deposit/bail amount calculation for OWI
          and PAC statutes. The court cost flags were being set improperly under some
          conditions. This either caused the deposit/bail amounts to be short by the
          court costs or it calculated the deposit/bail amount as $28.00 when it should
          have been $0.00. Changes were made to MUNI.val, ELCI.val,
          MUNI_FORM_Violation.grp and ELCI_FORM_Violation.grp.

         Added phone number to MUNI.pop Autopop rule upon replicate.

         Changes to the Violations_WI table.
            1. Added the $10.00 surcharge on OWI and PAC fees that were effective
               on 04/02/08. The statutes affected are 346.63(1)(a), 346.63(1)(b),
               346.63(5)(a). 346.63(1)(am). The surcharge is for the 1st violation only.
            2. Corrected court cost flags on statutes 23.33(4c)(a)2, and
               350.101(1)(b).
            3. Changed the database definition of the two description fields (60
               positions and 75 positions) to match the data entry field lengths. This
               will eliminate endshift problems in the future.
            4. Changed sequencing of 343.07 statute series to be included in the
               ―Light‖ statute search category.
            5. Added Statute number and tilde to the five 346.46 statutes in the
               DATA_CODE field. This column in the table should look like this
               example - 346.46~FAIL TO STOP/IMPROPER STOP AT STOP SIGN

         Changes to the Violations_MUNI table.
            1. Changed the database definition of the two description fields (50
               positions and 75 positions) to match the data entry field lengths. This
               will eliminate endshift problems in the future.

         Changes to the Codes – CitCourts table:
            25. La Crosse and Williams Bay court fees changed to $15.00.
            26. Rothschild court fees changed to $23.00.
            27. Rice Lake City Municipal court address changed.
            28. Suamico Town Municipal Court changed to Suamico Village Municipal
                Court.
            29. Hobart and Lawrence Town Municipal courts combined to Hobart /
                Lawrence Municipal Court.
            30. Added MUNI court routing type of ―MC‖ for 34 TIPPS courts to get
                them ready for eCitation processing
            31. Added Childrens Court – Milwaukee County as a new court.
            32. Changed Winnebago Circuit Court Branch II room number to 413.
          Changes to the Codes_Department table.
             4. Changed NCIC number for Siren PD to WI0070200.

          Changes to the Codes_Municipality table.
             1. Changed Town of Richfield, Washington County to Village of Richfield,
                Washington County.
             2. Removed Town of Ashwaubenon from the table.

          Changes to DB2PROD_DT_CNTY_MUNI_ZIP table.
             1. Changed Town of Richfield, Washington County to Village of Richfield,
                Washington County

          Codes – DomesticatedAnimal table was updated with ―BOVINE‖.

          Codes - Insurance and Codes - Highways tables updated.

       The TraCS baseline Violations_Shortcuts were modified to bring them up to
       date with the new statutes. The baseline shortcuts are only installed on a new
       installation. They are not updated with a Patch or Pack update. You may want to
       manually adjust your shortcut table using the TableManager utility. The changes
       we made were
                   1. Delete shortcuts GCV, GDLC, GDLP, DPV, HLC, and IDL
                   2. Change shortcut CSR statute from 347.48(4)(a)1 to 347.48(4)(am)
                   3. Change OWI5 severity code from 005 to 011
                   4. Change PAC5 severity code from 001 to 011

Note: If this is the first time you are installing a patch on a workstation, you should
perform a database sync.

04/02/08---
     Don’t install this Patch because 040708 Patch replaced it.

03/10/08----

       Mandatory patch replaces 022908 Patch and includes the following:

          Patch change from 022908 to 031008 because of 13 statutes with
           descriptions greater than 60 positions that will cause endshift abends.
          Updated both the Violations_WI and Violations_MUNI tables with the most
           current statutes and amounts. Court costs will be set at a default of $28.00
           for all Municipal courts. NOTE: (If your Municipal court amount is not
           $28.00, you must use Table Manager to change the Municipal court
           amount and also send a note to the Badger/TraCS help desk with the
           correct amount. We will update the master Codes – CitCourts table for
           future patches. If you do not send us a note, your Municipal court fees
           will be overwritten with future patches.) We were unable to add custom
          Municipal citation statutes in this release due to time constraints and the
          rewrite of the violation tables.
         Updated Table Manager to remove Local fees and update court fees on the
          Codes – CitCourts table.
         Court address for Rothschild MUNI court and Village of Somerset (again)
          updated. Added Hidden Valleys Municipal Court and Walworth County Circuit
          Court BR4 to Codes – CitCourts.
         Changed North Fond du Lac to N Fond du Lac in Codes_IACities table.
         TAS agency code assigned to Endeavor PD (272), Mount Pleasant (273),
          Darlington (274), Juneau County (275), Mauston (276), New London (277),
          Chetek (278), Arcadia (279), Boyd (280), Trempealeau (281), Chippewa Falls
          (282), Marquette County (283), Big Bend (284), Osseo (285), Saukville (286),
          St Francis PD (287), Oconto County Sheriff (288), Oconto PD (289), Amery
          PD (290), Reedsburg PD (291), Ellsworth PD (292), Elmwood PD (293),
          Lincoln County (294), Prescott PD (295), Spring Valley PD (296), and Dane
          PD (297) to Codes_Department table. Also changed LaCrosse County
          Sheriffs DEPA to DEPT in this table.
         Updated Wisconsin Rapids PD and Winnebago County Sheriff’s NCIC
          number in Codes_Department table to the correct values. Updated Berlin PD
          address to include PO box.
         Insurance and highway tables updated.
         Turned on logging of form numbers for all forms. This will allow agencies to
          determine the last form numbers used if a laptop crashes.
         Added ELCI validation rule to display message box and Error on validation if
          the citation number is blank.



02/29/08---
     Don’t install this Patch because 031008 Patch replaced it.

11/30/07—
       Vehicle make code values padded out to 4 characters to avoid mis-selection
         of makes, i.e., Kenworth/KW Dart issue.
       CCAP and eCitation style sheets updated to strip out trailing spaces on
         vehicle make for data transmission.
       Court address for Village of Somerset updated.
       TAS agency code assigned to West Milwaukee (271) to Codes_Department
         table.
       Insurance and highway tables updated.


10/31/07 — Mandatory
          Added TAS numbers for Cadott PD (269) and Blue Mounds PD (270) to
            the Codes_Department table.
          Updated Insurance and Highway table values.
            Changed Court addresses for Marinette MUNI court, Village of Cleveland
             MUNI court and Kewaunee Circuit court in Codes – Citcourts table. Also
             added new circuit court for Green Lake County Circuit Court – Berlin
             Branch.
            Changed Crash validation to correctly set the Non reportable accident
             flag.
            MV4000.xslt in Communications has been modified for Crash form.
            Added Statute 346.63(2)(a)3 to ALCHL validation for Notice of intent to
             suspend report.
            Modified Amended Crash form to change the Document Number Override
             from 8 to 7 positions to match the database.
            Removed Error message 610 requiring vehicle plate type for statute
             341.04(1)(a) and 341.01(1).
            Changed NCIC number in Codes_Department for Walworth County
            Changed mailing address in Codes_Department for Somerset PD.




092807 —Mandatory
         Added TAS numbers up to 268 for agencies Stoddard PD, Westby PD,
          Baraboo PD, UW Eau Claire PD, Manawa PD, Minocqua PD, Orfordville
          PD, and South Milwaukee PD to the Codes_Department table.
         Updated Insurance and Highway table values
         Changed Mid Morraine Municipal Court – Grafton City address in Codes –
          Citcourts table.
         Changed Crash validation and Deer Crash validation to correctly set the
          Non reportable accident flag.
         CCAP_ELCI.xslt and eCitation.xslt XSLT have been modified.
         Added DB2PROD_DT_CNTY_MUNI_ZIP table to Support.mdb

091107 —
            Added TAS numbers up to 260 for agencies Lena PD, Oak Creek PD,
             Hales Corners PD, Berlin PD, Waupun PD, Markesan PD, Elm Grove PD,
             Argyle PD, Neilsville PD, Colby-Abbotsford PD, Merrill PD, Horicon PD,
             Pewaukee City PD, Rio PD, and Shorewood PD to the
             Codes_Department table.
            Updated Insurance and Highway table values
            Changed Coleman PD address in Codes_Department table.
            Changed Coleman Village Municipal Court in Codes – Citcourts table.
            Fixed Warning: Ordinance Notice report to correctly include the entire date
             on the Correct by date field.
            Modified the ELCI and MUNI to enable DA Routing flag after issuance.
             This change will allow you to change the DA Routing flag if an ELCI or
             MUNI has an Issued status.
   Changed MUNI validation to remove statute description from printing if the
    statute has been cleared.
   MV4000 XSLT has been modified.
   Modified TraCS\System\WieCitationService.ini for Ecitation processing

								
To top