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

    • Creating Department Signature Needs

      Purpose Statement This article demonstrates how to define and configure your department's ePCR signature requirements, including signature blocks, form language, and workflows to ensure proper signature collection and compliance with regulatory ...

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

    • Understanding Community Connect CC and HH Reminders

      Purpose Statement This feature provides automated email reminders to citizens and businesses with active Community Connect accounts, ensuring their account information remains current and accurate. The reminder system helps maintain data integrity ...