v_asset_inspection_completed

v_asset_inspection_completed

Purpose

  1. Completed asset inspection records view. 

Relationships


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

    • Many inspections link to one apparatus

    • Referenced through apparatus_id

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

    • Many inspections link to one equipment item

    • Referenced through equipment_id

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

    • Many inspections link to one station

    • Referenced through fire_station_id



Table



Column

Type

Description

id

integer

Primary key

name

varchar(255)

Inspection name

client_code

varchar(28)

Organization ID

asset_type_code

varchar(32)

Asset type

apparatus_id

integer

Apparatus reference

apparatus_name

varchar(40)

Apparatus name

equipment_id

integer

Equipment reference

equipment_name

text

Equipment name

fire_station_id

integer

Station reference

station_name

varchar(64)

Station name

completed_at

timestamp

Completion time

created_by

integer

Creator reference

public_name

varchar(255)

Creator name


    • Related Articles

    • v_equipment

      Purpose Equipment inventory and tracking. Relationships v_work_order: One-to-Many (1:N) One equipment item can have many work orders Referenced through equipment_id v_asset_inspection_completed: One-to-Many (1:N) One equipment item can have many ...

    • Accessing Completed Checklist Results for a Specific Asset Check.

      Purpose This feature enables Fire/EMS personnel to locate, review, and analyze completed asset checklists within the First Due system. By providing comprehensive access to historical checklist data, departments can monitor asset condition trends, ...

    • Delete Completed Inspection

      Purpose Statement This feature allows authorized users to delete completed fire inspections from the system. Unlike standard inspection deletions which permanently remove records, completed inspection deletions archive the records while maintaining ...

    • Starting an Asset Checklist

      Purpose This feature enables Fire/EMS personnel to initiate and complete asset checklists for apparatus, equipment, kits, and stations within the First Due system. By providing a standardized checklist process, departments can ensure consistent asset ...

    • Starting an Asset Checklist

      Purpose This feature enables Fire/EMS personnel to initiate and complete asset checklists for apparatus, equipment, kits, and stations within the First Due system. By providing a standardized checklist process, departments can ensure consistent asset ...