v_cc_functional_needs

v_cc_functional_needs

Purpose

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

varchar(255)

Registrant name

address

text

Address

email

varchar(255)

Email contact

phone

varchar(12)

Phone contact

time_zone

varchar(64)

Time zone

family_member_type_code

varchar(25)

Family member type

special_resident_name

varchar(255)

Special needs resident

special_resident_age

smallint

Resident age

disability_type_code

varchar

Disability type

note

text

Additional notes

client_code

varchar(28)

Organization ID

attachments

boolean

Has attachments





    • Related Articles

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

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

    • v_permit_questions

      Purpose Fire department permit questions and answers. Relationships v_fd_permit: Many-to-One (N:1) Many questions link to one permit Referenced through fd_permit_id Table Column Type Description id integer Primary key fd_permit_custom_question text ...

    • Creating a Historical Permit Type

      Purpose To explain how to create a Historical Permit Type on the First Due Platform Video Instructions 1. Navigate to the Historic Permits Module Users will need to have the correct permissions to access. 2. Select Permit Types 3. This will bring up ...