v_apparatus

v_apparatus

Purpose

  1. Apparatus / vehicle information view. 

Relationships


  • v_incident_report_apparatus: One-to-Many (1:N)

    • One apparatus can be on many incident reports

    • Referenced through apparatus_id

  • v_fire_station: Many-to-One (N:1)

    • Many apparatus belong to one station

    • Referenced through fire_station_id

  • v_work_order: One-to-Many (1:N)

    • One apparatus can have many work orders

    • Referenced through apparatus_id


Table


Column

Type

Description

id

integer

Primary key

name

varchar(40)

Apparatus name

apparatus_type_code

varchar(3)

Type code

vehicle_number

varchar(25)

Vehicle number

primary_use_code

varchar(2)

Primary use

vehicle_id

varchar(25)

Vehicle ID

unit_call_sign

varchar(40)

Call sign

vin_number

varchar(17)

VIN

model

varchar(40)

Model

engine

varchar(40)

Engine details

tank_volume

integer

Tank volume

pump_type

varchar(40)

Pump type

fire_station_id

integer

Station reference

odometer

numeric(8,2)

Odometer reading

apparatus_group_id

integer

Group reference

manufacturer

varchar(40)

Manufacturer

manufacture_year

smallint

Year made

pto_hours

numeric(8,2)

PTO hours

pump_hours

numeric(8,2)

Pump hours

engine_hours

numeric(8,2)

Engine hours





    • Related Articles

    • Apparatus List: Editing an Apparatus

      Purpose The purpose of this article is to inform users how to edit an existing apparatus in the First Due system. Video Directions 1. Click on Assets. 2. Click on Apparatus List. 3. Locate the apparatus that is to be edited. 4. Click the Edit icon in ...

    • Concurrent Data Entry of Apparatus within Incident Documentation

      Purpose To explain how users may access the apparatus details modal to enter all information while someone else is completing the fire report. Heads Up! We are enhancing the way agencies can manage and enter Apparatus details in a fire report! This ...

    • Apparatus: Managing Apparatus Groups

      Purpose The purpose of this article is to inform users how to manage an existing apparatus group in the First Due system. This article will cover how to reorganize, edit, and delete existing apparatus groups in First Due. Video Directions 1. Click on ...

    • Apparatus: Creating an Apparatus Group

      Purpose The purpose of this article is to inform users how to create an apparatus group in the First Due system. Apparatus grouping allows users to "group" or categorize apparatus so that they can be easily located within the system. Idea: Many ...

    • Apparatus List: Deleting an Apparatus

      Purpose The purpose of this article is to inform users how to delete an existing apparatus in the First Due system. Apparatus can be deleted individually or multiple apparatus can be deleted simultaneously using First Due's Bulk Delete feature. Note: ...