v_occupancy

v_occupancy

Purpose

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

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

    • One occupancy can have many violations

    • Referenced through place_id

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

    • One occupancy can have many permits

    • Referenced through location relationship



Table



Column

Type

Description

id

integer

Primary key

created_by

integer

Creator reference

address1

varchar(255)

Primary address

address2

varchar(255)

Secondary address

location_cache

text

Location details

street_name

varchar(128)

Street name

client_code

varchar(28)

Organization ID

preplan_id

integer

Pre-plan reference

place_status_code

varchar(20)

Status code

parent_id

integer

Parent location

city

varchar(255)

City

state_code

varchar(3)

State code

zip

varchar(15)

ZIP code

latitude

numeric(9,7)

GPS latitude

longitude

numeric(10,7)

GPS longitude

preplan_business_name

varchar(128)

Business name

preplan_business_phone

varchar(50)

Business phone

preplan_is_high_rise

boolean

High-rise flag

preplan_property_class

varchar(255)

Property class

preplan_building_use

varchar(2048)

Building use

preplan_building_height_feet

integer

Height in feet

preplan_building_area_squarefeet

varchar(64)

Floor area

preplan_number_floors

varchar(64)

Floor count

preplan_occupancy_load

varchar(128)

Occupant load

fire_zone

integer

Fire zone

fire_zone_name

varchar(255)

Zone name




    • Related Articles

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

    • v_occupancy_contact

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

    • Occupancy Log

      Purpose The purpose of this Knowledge Base Article is to demonstrate the Occupancy Log. The Occupancy Log allows inspectors to record visits, complaints, and phone conversations that aren’t tied to formal inspections but are crucial for understanding ...