v_cc_smoke_alarm_request

v_cc_smoke_alarm_request

Purpose

  1. Smoke alarm installation request view. 

Relationships


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

    • Many requests link to one location

    • Referenced through place_id

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

    • Many requests assigned to one personnel

    • Referenced through assigned_to



Table


Column

Type

Description

smoke_alarm_request_id

integer

Primary key

request_number

varchar(32)

Request ID

address

text

Installation address

request_type

varchar(12)

Request type

submitted_date

date

Submission date

contact_name

varchar(255)

Contact name

contact_phone

varchar(12)

Contact phone

contact_email

varchar(255)

Contact email

status

varchar(12)

Request status

assigned_to

varchar(255)

Assigned personnel

service_date

date

Service date

reviewed_date

date

Review date

scheduled_date

date

Schedule date

completed_date

date

Completion date

place_id

integer

Location reference







    • Related Articles

    • Community Connect: Smoke Alarm Request

      Purpose Statement The Smoke Alarm Request feature in Community Connect enables fire departments to efficiently manage and track smoke alarm installation, maintenance, and inspection requests from community members. This tool streamlines the process ...

    • v_cc_burn_permit

      Purpose Community burn permit records view. Relationships v_occupancy: Many-to-One (N:1) Many permits link to one location Referenced through place_id v_cc_burn_permit_question: One-to-Many (1:N) One permit can have many questions Referenced through ...

    • v_cc_burn_permit_question

      Purpose Burn permit questions and answers view. Relationships v_cc_burn_permit: Many-to-One (N:1) Many questions link to one permit Referenced through permit_id Table Column Type Description permit_answer_id integer Primary key question text Question ...

    • Inspection Request from Community Connect Portal

      Purpose Statement This feature allows community members to request inspections through the Community Connect Portal, creating a streamlined process for inspection scheduling and communication between the public and fire department personnel. The ...

    • Permit Request from the Community Connect Portal

      Purpose Statement This article demonstrates the workflow process for handling permit requests submitted through the Community Connect Portal. The process enables Fire/EMS departments to efficiently review, process, and respond to community-submitted ...