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

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

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