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: Permanently Archiving Apparatus

      Purpose The purpose of this article is to instruct users on how to permanently archive a piece of apparatus in the First Due System. Archiving an apparatus will permanently remove all functionality of the apparatus in the First Due system, allowing ...

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

    • 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: Bulk Archiving Apparatus

      Purpose The purpose of this article is to instruct users on how to permanently archive multiple pieces of apparatus simultaneously in the First Due System. Archiving an apparatus will permanently remove all functionality of the apparatus in the First ...