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.
• 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.

---