Appliances- editing in Access

Vehicle Classes

Opens the vehicle classes table tblVehicleClasses so vehicle classes can be created, edited or deleted as follows:

• Field VehicleClassPk is the key used to access these rows.
• Field VehicleClass is the user-visible class, e.g. “PRL”, “Aerial”. These values can be changed without affecting the relationships in the data.
• Field InAttendanceTarget is the target time for the first appliance on the scene. It contains the value used in Limit Stations by Vehicle Target Time.
• Field InAttendanceTarget2nd is the target time for the second appliance on the scene. It contains the value used in Limit Stations by Vehicle Target Time.
• Field SpecialRequest defines if this class of vehicle can only be mobilised for an Appliance Request by special request. For example, Aerials are special request but PRLs are not. Special request appliances will only respond to incidents they have responded to in historic data. For example, Rescue or Evacuation from Water will only be responded to by a Boat Vehicle Class (if this has happened in the historic data).
• Field AverageMPH defines the average speed to the Vehicle Class used in calculation mode.
• Field SelectionOrder provides an optional sorting mechanism for Vehicle Classes when retrieved for Modelling. For example if you have two general purpose classes of vehicle: ‘TypeA’ and ‘TypeB’ and you want TypeB to be considered before TypeA then you could set SelectionOrder as 1 for TypeB and 2 for TypeA.

Appliances

Opens the table of appliances for editing.

• Field VehicleId is the key by which the individual appliance is referenced.
• Field VehicleClass defines the class of the vehicle.

Appliance - Station Mapping

Opens the table that associates appliances to stations.

• Field VehicleId is the key by which the individual appliance is referenced.
• Field BaseID defines the station id.

---