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- Adding a New Smoke Alarm Request

      Purpose To explain to First Due Users how to add a new Smoke Alarm request using the community connect module. Video Directions 1. Navigate to the Community Connect Module. 2. Select Smoke Alarm List. 3. All of the Smoke Alarm Request will be in this ...

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

    • v_cc_functional_needs

      Purpose Community functional needs registry view. Relationships v_occupancy: Many-to-One (N:1) Many functional needs records link to one location Referenced through address matching Table Column Type Description id integer Primary key name ...

    • Event List: Managing Sign Up Request for Events

      Purpose To explain how to manage Sign Up Request for an Event. Video Directions 1. For those that have the permissions to approve the requests of personnel who have signed up, navigate to the event from the Event List and select the pencil icon to ...