IDOT CVISN Documentation Project

Motor Vehicle Registration (MVR)

Background

Contacts

• Lead administrator of the IRP ILLINOIS SECRETARY OF STATE (International Registration Plan) :
• Name: Michael Ramirez
• Phone: (217) 785-1803
• e-Mail: MRamirez @ ilsos.net
• Assistant Lead
• Name: Bill Graber
• Phone: (217) 785-1803
• e-Mail: BGraber @ ilsos.net
• Office Administrator
• Name: Eva Letterle
• Phone: (217) 785-1803
• e-Mail: ELetterle @ ilsos.net
•  Technical Contact (MVR System):
• Name: Pam Corey
• Phone: (217) 785-0002
• e-Mail: PCorey @ ilsos.net

Registration Systems

There are two sources of registration information of commercial vehicles at the Secretary of State.  The IRP system is documented in a different section.  The MVR registration system for intrastate vehicles is documented here.

Database Environment

The database server is an IBM DB2 database environment with the following table:

Mapping

The standard general mappings on the home tab need to be applied.

Date Note: dates are of the form ccyymmdd format which will need to be converted to yyyy-mm-dd format.

IRP CAB (T0022V2)

Note: All commercial vehicles are classified by weight.  Only vehicle records with values of "3" in VEH_BODY_TYPE (which indicates classified by weight) should be used for mapping.

Notes:

1) Unless there is a CVIEW mapping specified in the table below, the default mapping of ZZ (Other unlisted type) should be used.

Triggers

The trigger field for transactions are as follows:

US_DOT Cross Reference Mapping

According to Pam Corey, the SOS MVR system does not maintain the US_DOT Carrier ID.  Based on this information, the US_DOT Cross Reference Mapping is nonexistent.

XML Creation Script

Below is a php script which was used to generate the T0022 transactions which were then applied to XCVIEW implementation of CVIEW.  A database was created and minimally populated with test data. The application of the test cases succeeded in creating T0022 transactions and the scripts could be used as the basis for an implementation of a XML creation script for the MVR system.

The $Host, $Username, $Password, "LSI_MVR" database would need to be adjusted to reflect the actual MVR database.  This script assumes the MVR database is a MS-SQL 2005 database. This is not the case and minor modifications to the script are required to operate with the DB2 database.

<?php
$Host = "lsimovhost";
// This script will open up the MVR database and produce a transaction
// file for processing in the augmented cview tasks
/* Connecting, selecting database */
$Username = "username";
$Password = "password";
function ConvertDate($InDate){
 return substr($InDate,0,4) . "-" . substr($InDate,4,2) . "-" . substr($InDate,6,2);
}
$link = mssql_connect($Host, $Username, $Password)
 or die('Could not connect\n');
if (!mssql_select_db("LSI_MVR"))
 die("Could not select LSI_MVR\n");
$MapType = array (
 "AC" => "AC",
 "AM" => "AM",
 "A1" => "CK",
 "BU" => "BS",
 "CG" => "CD",
 "CM" => "CM",
 "CP" => "CP",
 "CR" => "CR",
 "CV" => "CO",
 "DB" => "DB",
 "DS" => "DT",
 "FB" => "FB",
 "GG" => "GG",
 "HB" => "HB",
 "HD" => "DP",
 "JP" => "JE",
 "LS" => "LS",
 "MC" => "MC",
 "MH" => "MA",
 "PK" => "PK",
 "PN" => "PN",
 "RH" => "RH",
 "RS" => "MC",
 "SE" => "ST",
 "TD" => "TD",
 "TK" => "TC",
 "TL" => "TR",
 "TN" => "TV",
 "TT" => "TT",
 "WD" => "WW",
 "WG" => "UT",
 "WK" => "WK");
$MapFuel = array (
 1 => "G",
 2 => "D",
 3 => "E",
 8 => "O");
$LastDay = array (
 "01" => 31,
 "02" => 28,
 "03" => 31,
 "04" => 30,
 "05" => 31,
 "06" => 30,
 "07" => 31,
 "08" => 31,
 "09" => 30,
 "10" => 31,
 "11" => 30,
 "12" => 31);
// open output file
$FileNameOut = ($argc > 1) ? $argv[1] : "CVIEWT0022V1.xml";
($fhout = fopen($FileNameOut, "w")) || die("Cannot open output file $FileNameOut\n");

$QryStr = "SELECT * FROM RT_REGISTRATION WHERE VEH_BODY_TYPE = '3'";
$Results = mssql_query($QryStr);
if ($Results === FALSE)
 die("Failed Query - $QryStr\n");
if ($Results === TRUE) die("no rows");
$SnapDate = date("Y-m-d\Th:i:s");
// output XML heading
$XMLHeader = "<?xml version=\"1.0\"?>
<T0022 xmlns=\"http://www.safersys.org/namespaces/T0022V1\"
xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"
xsi:schemaLocation=\"http://www.safersys.org/namespaces/T0022V1 T0022V1.xsd\">
 <INTERFACE>
 <NAME>SAFER</NAME>
 <VERSION>04.02</VERSION>
 </INTERFACE>
 <TRANSACTION>
 <VERSION>01.00</VERSION>
 <OPERATION>REPLACE</OPERATION>
 <DATE_TIME>$SnapDate</DATE_TIME>
 <TZ>CD</TZ>
 </TRANSACTION>\n";
fwrite($fhout,$XMLHeader);
while ($Row = mssql_fetch_object($Results)){
 $XMLCab = " <IRP_REGISTRATION>\n";
 // IRP_REGISTRATION (Cab) info
 $VIN = $Row->ASGN_VIN;
 $TITLE_NUMBER = $Row->VEH_TITLE_NO;
 $TITLE_JURISDICTION = "USIL";
 $LastName = trim($Row->OWN_LAST_NAME);
 $FirstName = trim($Row->OWN_FIRST_MI);
 if (strlen($LastName) + strlen($FirstName) + 2 > 55)
 $OWNER_NAME = $LastName . ", " . 
 substr($FirstName, 0, 55 - 2 - strlen($LastName));
 else $OWNER_NAME = $LastName . ", " . $FirstName;
 $MODEL_YEAR = $Row->VEH_YR;
 $MAKE = $Row->VEH_MAKE_CODE;
 if (isset($MapType[$Row->BODY_STYLE])) $TYPE = $MapType[$Row->BODY_STYLE];
 else $TYPE = "FF";
 $FUEL = $MapFuel[$Row->ENGINE_FUEL];
 //$UNLADEN_WEIGHT = $Row->UNLADEN_WEIGHT;
 $NUMBER_OF_AXLES = $Row->AXLES;
 $LICENSE_PLATE_NUMBER = $Row->DISP_ASGN_PLT_NO;
 $UNIT_NUMBER = $Row->UNIT_NO;
 $LAST_UPDATE_DATE = ConvertDate($Row->ACTION_DATE); // check for vehicle
 $INTERSTATE_FLAG = "S";
 //$IRP_CARRIER_NUMBER = $Row->US_DOT_NUMBER_1;
// obtain GVW
 //$IRP_STATUS_DATE = $LAST_UPDATE_DATE;
 //$IRP_ACCOUNT_NUMBER = $Row->FIRM_NO;
 $IRP_FLEET_NUMBER = $Row->FLEET_ID;
 $REGISTRATION_START_DATE = ConvertDate($Row->VAL_DATE);
 $REGISTRATION_EXPIRE_DATE = $Row->ASGN_EXP_YR . "-" . $Row->ASGN_EXP_MO . 
 "-" . $LastDay[$Row->ASGN_EXP_MO]; // need to fix for leap year

 $GVW = $Row->WGT_CYL_CC_HP;
 //$GVW_EXPIRE_DATE = $REGISTRATION_EXPIRE_DATE;
 $XMLCab = "
 <IRP_REGISTRATION>
 <VIN>$VIN</VIN>
 <TITLE_NUMBER>$TITLE_NUMBER</TITLE_NUMBER>
 <TITLE_JURISDICTION>$TITLE_JURISDICTION</TITLE_JURISDICTION>
 <OWNER_NAME>$OWNER_NAME</OWNER_NAME>
 <MODEL_YEAR>$MODEL_YEAR</MODEL_YEAR>
 <MAKE>$MAKE</MAKE>
 <TYPE>$TYPE</TYPE>
 <FUEL>$FUEL</FUEL>
 <NUMBER_OF_AXLES>$NUMBER_OF_AXLES</NUMBER_OF_AXLES>
 <LICENSE_PLATE_NUMBER>$LICENSE_PLATE_NUMBER</LICENSE_PLATE_NUMBER>
 <IRP_BASE_COUNTRY>US</IRP_BASE_COUNTRY>
 <IRP_BASE_STATE>IL</IRP_BASE_STATE>
 <UNIT_NUMBER>$UNIT_NUMBER</UNIT_NUMBER>
 <LAST_UPDATE_DATE>$LAST_UPDATE_DATE</LAST_UPDATE_DATE>
 <INTERSTATE_FLAG>$INTERSTATE_FLAG</INTERSTATE_FLAG>
 <IRP_FLEET_NUMBER>$IRP_FLEET_NUMBER</IRP_FLEET_NUMBER>
 <REGISTRATION_START_DATE>$REGISTRATION_START_DATE</REGISTRATION_START_DATE>
 <REGISTRATION_EXPIRE_DATE>$REGISTRATION_EXPIRE_DATE</REGISTRATION_EXPIRE_DATE>
 <GVW>$GVW</GVW>
 </IRP_REGISTRATION>
";
 fwrite($fhout, $XMLCab);
}
$XMLCab = 
"</T0022>\n";
fwrite($fhout,$XMLCab);
fclose($fhout);
?>

XML Transactions

In the MVR system, there is one  CVIEW Transaction (T0022) which deals with the registration of the vehicle.

T0022V2.xsd - IRP Cab