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

    • v_occupancy_history

      Purpose Historical occupancy information. Relationships v_occupancy: Many-to-One (N:1) Many history records link to one occupancy Referenced through place_id Table Column Type Description id integer Primary key place_id integer Location reference ...

    • Field Management: Contact Types

      Purpose To demonstrate how to manage Preplan Contact Types. Note: This permission needs to be enabled for a user to manage preplan contact types: Pre-Planning - Manage Preplan Contacts Type. Video Instructions 1. Click on Admin. 2. Click on Field ...