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

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

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

    • Accessing Completed Checklist Results for a Specific Asset Check.

      Purpose The purpose of this article is to inform users how to locate completed asset checklists in the Asset Module in the First Due system. Note: This process applies to apparatus, equipment, kit, and station checks. Video Directions 1. Click on ...

    • Accessing Completed Checklist Results for a Specific Asset Check.

      Purpose The purpose of this article is to inform users how to locate completed asset checklists in the Asset Module in the First Due system. Note: This process applies to apparatus, equipment, kit, and station checks. Video Directions 1. Click on ...

    • Accessing Completed Checklist Results for a Specific Asset Check.

      Purpose The purpose of this article is to inform users how to locate completed asset checklists in the Asset Module in the First Due system. Note: This process applies to apparatus, equipment, kit, and station checks. Video Directions 1. Click on ...