v_occupancy_contact

v_occupancy_contact

Purpose

  1. Contact information for occupancies.

Relationships

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

    • Many contacts link to one occupancy

    • Referenced through place_id


Table



Column

Type

Description

id

integer

Primary key

contact_type_id

integer

Contact type

contact_type

varchar(30)

Type description

contact_primary_occupancy

boolean

Primary contact

contact_first_name

varchar(128)

First name

contact_last_name

varchar(128)

Last name

contact_name

varchar(255)

Full name

contact_company_name

varchar(255)

Company name

contact_phone

varchar(50)

Phone number

contact_phone2

varchar(50)

Alt phone

contact_mobile

varchar(50)

Mobile number

contact_email

varchar(255)

Email

contact_notes

text

Additional notes

client_code

varchar(28)

Organization ID

preplan_business_name

varchar(128)

Business name

location_cache

text

Location details

place_id

integer

Location reference



    • Related Articles

    • v_occupancy

      Purpose Building and occupancy information. Relationships v_occupancy_contact: One-to-Many (1:N) One occupancy can have many contacts Referenced through place_id f_fire_inspection: One-to-Many (1:N) One occupancy can have many inspections Referenced ...

    • Managing the Occupancy Record

      Purpose To demonstrate navigating through and updating the Occupancy Record. Related Articles Editing Occupancy Address Video Instructions 1. Click on Inspections. 2. Click on Inspection Organizer. 3. Select an inspection type and then change. 4. ...

    • Managing the Occupancy Record

      Purpose Statement The Occupancy Record management feature allows fire department personnel to efficiently navigate, view, and update comprehensive property information including occupancy details, contacts, pre-planning data, permits, inspections, ...

    • Inspection Record - Occupancy Section

      Purpose Statement The Occupancy section within Inspection Records allows users to capture and update critical building occupancy information during inspection activities. This feature enables real-time data collection that automatically synchronizes ...

    • Inspection Record - Occupancy Log

      Purpose Statement The Occupancy Log feature allows fire inspection personnel to document detailed records and chronological entries during property inspections. This tool enables inspectors to maintain comprehensive documentation of inspection ...