create or replace and compile java source named sms."VehicleRecord2" as
//
// Modified  11/08/2004 LTS Added registeredWeight.
// Modified  11/16/2004 LTS Added vehicleSchoolBus.
// Modified  11/23/2004 LTS Fixed setHazmatName, change hazmatPlacard to hazmatHasPlacard
// Modified  12/01/2004 LTS Added explanation.
// Modified  06/14/2004 LTS Changed getRegistrantName to LastName, Firstname
// Modified  07/18/2006 KCM Added weightRating
//
import java.util.*;

public class VehicleRecord2
{

   int    casePk;
   String vehicleID;
   String passengerCount;
   String pubPropertyDamage;
   String truckBusClass;
   String registrantFirstName;
   String registrantMiddleName;
   String registrantLastName;
   String registrantSex;
   String registrantBirthDate;
   String hazmatCode;
   String hazmatSType;
   String hazmatReleased;
   String hazmatHasPlacard;
   String hazmatName;
   String registrantAddress;
   String registrantCity;
   String registrantState;
   String registrantZipCode;
   String plateNumber;
   String plateState;
   String year;
   String vehMake;
   String bodyType;
   //String registeredWeight;//SP will not be sending this anymore
   String insCarrierCode;
   String vehWide;
   String vehLong;
   String vehOverweight;
   String vehOverdimension;
   String damage1;
   String damage2;
   String damage3;
   String damage4;
   String damage5;
   String towedBy;
   String towedTo;
   String contributingFactor1;
   String contributingFactor2;
   String directionTravel;
   String preAccdAction;
   String secondEvent;
   String privatePropDamage;
   String vehTowed;
   String vehPlacard;
   String VIN;
   String unknownSpeedInd;
   String cargoBodyType;
   String vehicleConfiguration;
   //String carrierSource;//SP will not be sending this anymore
   String carrierName;
   String carrierAddress1;
   String carrierAddress2;
   String carrierCity;
   String carrierState;
   String carrierZipCode;
   String USDotIDNumber;
   String IccMcIDNumber;
   //String weight;//SP will not be sending this anymore
   String totalAllTrailers;
   String axleCount;
   String vehicleSchoolBus;
   //String explanation;//SP will not be sending this anymore
   String weightRating; 
   String CarrierType;
   String BusType;

   
  // =============================================================
  // Constructors
  // =============================================================
   public VehicleRecord2(int inCasePk)
   {
     casePk = inCasePk;
     setNonPkFields();
   }

   public VehicleRecord2()
   {
     casePk = -99;
     setNonPkFields();
   }

  // ==================================================================
  //  reset Method
  // ==================================================================
     public void resetVehicle()
     {
        setNonPkFields();
     }

  // ********************************************************
  // Set Methods
  // ********************************************************
  public void setVehicleID(String inVehicleID)
  {
    vehicleID = inVehicleID;
  }

  public void setPassengerCount(String inPassengerCoun)
  {
    passengerCount = inPassengerCoun;
  }

  public void setPubPropertyDamage(String inPubPropertyDamage)
  {
    pubPropertyDamage = inPubPropertyDamage;
  }

  public void setTruckBusClass(String inTruckBusClass)
  {
    truckBusClass = inTruckBusClass;
  }

  public void setRegistrantFirstName(String inRegistrantName)
  {
    registrantFirstName = inRegistrantName;
  }

  public void setRegistrantMiddleName(String inRegistrantName)
  {
    registrantMiddleName = inRegistrantName;
  }

  public void setRegistrantLastName(String inRegistrantName)
  {
    registrantLastName = inRegistrantName;
  }

  public void setRegistrantSex(String inRegistrantSex)
  {
    registrantSex = inRegistrantSex;
  }

  public void setRegistrantBirthDate(String inRegistrantBirthDate)
  {
    registrantBirthDate = inRegistrantBirthDate;
  }

  public void setHazmatCode(String inHazmatCode)
  {
    hazmatCode = inHazmatCode;
  }

  public void setHazmatSType(String inHazmatSType)
  {
    hazmatSType = inHazmatSType;
  }

  public void setHazmatReleased(String inHazmatReleased)
  {
    hazmatReleased = inHazmatReleased;
  }

  public void setHazmatHasPlacard(String inHazmatHasPlacard)
  {
    hazmatHasPlacard = inHazmatHasPlacard;
  }

  public void setHazmatName(String inHazmatName)
  {
    hazmatName = inHazmatName;
  }

  public void setRegistrantAddress(String inRegistrantAddress)
  {
    registrantAddress = inRegistrantAddress;
  }

  public void setRegistrantCity(String inRegistrantCity)
  {
    registrantCity = inRegistrantCity;
  }

  public void setRegistrantState(String inRegistrantState)
  {
    registrantState = inRegistrantState;
  }

  public void setRegistrantZipCode(String inRegistrantZipCode)
  {
    registrantZipCode = inRegistrantZipCode;
  }

  public void setPlateNumber(String inPlateNumber)
  {
    plateNumber = inPlateNumber;
  }

  public void setPlateState(String inPlateState)
  {
    plateState = inPlateState;
  }

  public void setYear(String inYear)
  {
    year = inYear;
  }

  public void setVehMake(String inVehMake)
  {
    vehMake = inVehMake;
  }

  public void setBodyType(String inBodyType)
  {
    bodyType = inBodyType;
  }

  //SP will not be sending this anymore
  //public void setRegisteredWeight(String inRegisteredWeight)
  //{
    //registeredWeight = inRegisteredWeight;
  //}
  
  public void setInsCarrierCode(String inInsCarrierCode)
  {
    insCarrierCode = inInsCarrierCode;
  }

  public void setVehWide(String inVehWide)
  {
    vehWide = inVehWide;
  }

  public void setVehLong(String inVehLong)
  {
    vehLong = inVehLong;
  }

  public void setVehOverweight(String inVehOverweight)
  {
    vehOverweight = inVehOverweight;
  }

  public void setVehOverdimension(String inVehOverdimension)
  {
    vehOverdimension = inVehOverdimension;
  }

  public void setDamage1(String inDamage1)
  {
    damage1 = inDamage1;
  }

  public void setDamage2(String inDamage2)
  {
    damage2 = inDamage2;
  }

  public void setDamage3(String inDamage3)
  {
    damage3 = inDamage3;
  }

  public void setDamage4(String inDamage4)
  {
    damage4 = inDamage4;
  }

  public void setDamage5(String inDamage5)
  {
    damage5 = inDamage5;
  }

  public void setTowedBy(String inTowedBy)
  {
    towedBy = inTowedBy;
  }

  public void setTowedTo(String inTowedTo)
  {
    towedTo = inTowedTo;
  }

  public void setContributingFactor1(String inContributingFactor1)
  {
    contributingFactor1 = inContributingFactor1;
  }

  public void setContributingFactor2(String inContributingFactor2)
  {
    contributingFactor2 = inContributingFactor2;
  }

  public void setDirectionTravel(String inDirectionTravel)
  {
    directionTravel = inDirectionTravel;
  }

  public void setPreAccdAction(String inPreAccdAction)
  {
    preAccdAction = inPreAccdAction;
  }

  public void setSecondEvent(String inSecondEvent)
  {
    secondEvent = inSecondEvent;
  }

  public void setPrivatePropDamage(String inPrivatePropDamage)
  {
    privatePropDamage = inPrivatePropDamage;
  }

  public void setVehTowed(String inVehTowed)
  {
    vehTowed = inVehTowed;
  }

  public void setVehPlacard(String inVehPlacard)
  {
    vehPlacard = inVehPlacard;
  }

  public void setVIN(String inVIN)
  {
    VIN = inVIN;
  }

  public void setUnknownSpeedInd(String inUnknownSpeedInd)
  {
    unknownSpeedInd = inUnknownSpeedInd;
  }

  public void setCargoBodyType(String inCargoBodyType)
  {
    cargoBodyType = inCargoBodyType;
  }

  public void setVehicleConfiguration (String inVehicleConfiguration)
  {
    vehicleConfiguration = inVehicleConfiguration;
  }

  //SP will not be sending this anymore
  //public void setCarrierSource (String inCarrierSource)
  //{
    //carrierSource = inCarrierSource;
  //}

  public void setCarrierName (String inCarrierName)
  {
    carrierName = inCarrierName;
  }

  public void setCarrierAddress1 (String inCarrierAddress1)
  {
    carrierAddress1  = inCarrierAddress1;
  }

  public void setCarrierAddress2 (String inCarrierAddress2)
  {
    carrierAddress2 = inCarrierAddress2;
  }

  public void setCarrierCity (String inCarrierCity)
  {
    carrierCity = inCarrierCity;
  }

  public void setCarrierState (String inCarrierState)
  {
    carrierState = inCarrierState;
  }

  public void setCarrierZipCode (String inCarrierZipCode)
  {
    carrierZipCode  = inCarrierZipCode;
  }

  public void setUSDotIDNumber (String inUSDotIDNumber)
  {
    USDotIDNumber  = inUSDotIDNumber;
  }

  public void setIccMcIDNumber (String inIccMcIDNumber)
  {
    IccMcIDNumber  = inIccMcIDNumber;
  }

  //SP will not be sending this anymore
  //public void setWeight(String inWeight)
  //{
    //weight = inWeight;
  //}

  public void setTotalAllTrailers(String inTotalAllTrailers)
  {
    totalAllTrailers = inTotalAllTrailers;
  }

  public void setAxleCount(String inAxleCount)
  {
    axleCount = inAxleCount;
  }

  public void setVehicleSchoolBus(String inVehicleSchoolBus)
  {
    vehicleSchoolBus = inVehicleSchoolBus;
  }

  //public void setExplanation(String inExplanation)
  //{
    //explanation = inExplanation;
  //}
  
  public void setWeightRating(String inWeightRating)
  {
    weightRating = inWeightRating;
  }

  public void setCarrierType(String inCarrierType)
  {
    carrierType = inCarrierType;
  }

  public void setBusType(String inBusType)
  {
    BusType = inBusType;
  }



  // ********************************************************
  // Get Methods
  // ********************************************************
   public int getCasePk()
   {
      return(casePk);
   }

   public String getVehicleID()
   {
      return(vehicleID);
   }

   public String getPassengerCount()
   {
      return(passengerCount);
   }

   public String getPubPropertyDamage()
   {
      return(pubPropertyDamage);
   }

   public String getTruckBusClass()
   {
      return(truckBusClass);
   }

   public String getRegistrantName()
   {
     if (registrantFirstName == "")
       return(registrantLastName + " " + registrantFirstName + " " + registrantMiddleName);
     else
       return(registrantLastName + ", " + registrantFirstName + " " + registrantMiddleName);
   }

   public String getRegistrantSex()
   {
      return(registrantSex);
   }

   public String getRegistrantBirthDate()
   {
      return(registrantBirthDate);
   }

   public String getHazmatCode()
   {
      return(hazmatCode);
   }

   public String getHazmatSType()
   {
      return(hazmatSType);
   }

   public String getHazmatReleased()
   {
      return(hazmatReleased);
   }

   public String getHazmatName()
   {
      return(hazmatName);
   }

   public String getHazmatHasPlacard()
   {
      return(hazmatHasPlacard);
   }

   public String getRegistrantAddres()
   {
      return(registrantAddress);
   }

   public String getRegistrantCity()
   {
      return(registrantCity);
   }

   public String getRegistrantState()
   {
      return(registrantState);
   }

   public String getRegistrantZipCode()
   {
      return(registrantZipCode);
   }

   public String getPlateNumber()
   {
      return(plateNumber);
   }

   public String getPlateState()
   {
      return(plateState);
   }

   public String getYear()
   {
      return(year);
   }

   public String getVehMake()
   {
      return(vehMake);
   }

   public String getBodyType()
   {
      return(bodyType);
   }

   //SP will not be sending this anymore
   //public String getRegisteredWeight()
   //{
      //return(registeredWeight);
   //}

   public String getInsCarrierCode()
   {
      return(insCarrierCode);
   }

   public String getVehWide()
   {
      return(vehWide);
   }

   public String getVehLong()
   {
      return(vehLong);
   }

   public String getVehOverweight()
   {
      return(vehOverweight);
   }

   public String getVehOverdimension()
   {
      return(vehOverdimension);
   }

   public String getDamage1()
   {
      return(damage1);
   }

   public String getDamage2()
   {
      return(damage2);
   }

   public String getDamage3()
   {
      return(damage3);
   }

   public String getDamage4()
   {
      return(damage4);
   }

   public String getDamage5()
   {
      return(damage5);
   }

   public String getTowedBy()
   {
      return(towedBy);
   }

   public String getTowedTo()
   {
      return(towedTo);
   }

   public String getContributingFactor1()
   {
      return(contributingFactor1);
   }

   public String getContributingFactor2()
   {
      return(contributingFactor2);
   }

   public String getDirectionTravel()
   {
      return(directionTravel);
   }

   public String getPreAccdAction()
   {
      return(preAccdAction);
   }

   public String getSecondEvent()
   {
      return(secondEvent);
   }

   public String getPrivatePropDamage()
   {
      return(privatePropDamage);
   }

   public String getVehTowed()
   {
      return(vehTowed);
   }

   public String getVehPlacard()
   {
      return(vehPlacard);
   }

   public String getVIN()
   {
      return(VIN);
   }

   public String getUnknownSpeedInd()
   {
      return(unknownSpeedInd);
   }

   public String getCargoBodyType()
   {
      return(cargoBodyType);
   }

   public String getVehicleConfiguration()
   {
      return(vehicleConfiguration);
   }
   
   //SP will not be sending this anymore
   //public String getCarrierSource()
   //{
      //return(carrierSource);
   //}

   public String getCarrierName()
   {
      return(carrierName);
   }

   public String getCarrierAddress1()
   {
      return(carrierAddress1);
   }

   public String getCarrierAddress2()
   {
      return(carrierAddress2);
   }

   public String getCarrierCity()
   {
      return(carrierCity);
   }

   public String getCarrierState()
   {
      return(carrierState);
   }

   public String getCarrierZipCode()
   {
      return(carrierZipCode);
   }

   public String getUSDotIDNumber()
   {
      return(USDotIDNumber);
   }

   public String getIccMcIDNumber()
   {
      return(IccMcIDNumber);
   }
   
   //SP will not be sending this anymore
   //public String getWeight()
   //{
      //return(weight);
   //}

   public String getTotalAllTrailers()
   {
      return(totalAllTrailers);
   }

   public String getAxleCount()
   {
      return(axleCount);
   }

   public String getVehicleSchoolBus()
   {
      return(vehicleSchoolBus);
   }

   //public String getExplanation()
   //{
      //return(explanation);
   //}
 
   public String getWeightRating()
   {
      return(weightRating);
   }

   public String getCarrierType()
   {
      return(CarrierType);
   }

   public String getBusType()
   {
      return(BusType);
   }
   

//  ==================================================================
//     Set Non PK Fields
//  ==================================================================
   private void setNonPkFields()
   {
     vehicleID = "";
     passengerCount = "";
     pubPropertyDamage = "";
     truckBusClass = "";
     registrantFirstName = "";
     registrantMiddleName = "";
     registrantLastName = "";
     registrantSex = "";
     registrantBirthDate = "";
     hazmatCode = "";
     hazmatSType = "";
     hazmatReleased = "";
     hazmatHasPlacard = "";
     hazmatName = "";
     registrantAddress = "";
     registrantCity = "";
     registrantState = "";
     registrantZipCode = "";
     plateNumber = "";
     plateState = "";
     year = "";
     vehMake = "";
     bodyType = "";
     //registeredWeight = "";//SP will not be sending this anymore
     insCarrierCode = "";
     vehWide = "";
     vehLong = "";
     vehOverweight = "";
     vehOverdimension = "";
     damage1 = "";
     damage2 = "";
     damage3 = "";
     damage4 = "";
     damage5 = "";
     towedBy = "";
     towedTo = "";
     contributingFactor1 = "";
     contributingFactor2 = "";
     directionTravel = "";
     preAccdAction = "";
     secondEvent = "";
     privatePropDamage = "";
     vehTowed = "";
     vehPlacard = "";
     VIN = "";
     unknownSpeedInd = "";
     cargoBodyType = "";
     vehicleConfiguration = "";
     //carrierSource = "";//SP will not be sending this anymore
     carrierName = "";
     carrierAddress1 = "";
     carrierAddress2 = "";
     carrierCity = "";
     carrierState = "";
     carrierZipCode = "";
     USDotIDNumber = "";
     IccMcIDNumber = "";
     //weight = ""; //SP will not be sending this anymore
     totalAllTrailers = "";
     axleCount = "";
     vehicleSchoolBus = "";
     //explanation = "";//SP will not be sending this anymore
     weightRating = "";
     carrierType = "";
     busType = "";
    
  }

}  // public Class Vehicle Record

;
/