v_occupancy_contact
Table Name: v_occupancy_contact
Last Updated: June 01, 2026 at 01:22 AM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| contact_type_id | integer | Yes | - |
| contact_type | character | Yes | - |
| contact_primary_occupancy | boolean | Yes | - |
| contact_first_name | character | Yes | - |
| contact_last_name | character | Yes | - |
| contact_name | character | Yes | - |
| contact_company_name | character | Yes | - |
| contact_phone | character | Yes | - |
| contact_phone2 | character | Yes | - |
| contact_mobile | character | Yes | - |
| contact_email | character | Yes | - |
| contact_primary_phone | character | Yes | - |
| contact_location | character | Yes | - |
| contact_notes | text | Yes | - |
| client_code | character | Yes | - |
| preplan_business_name | character | Yes | - |
| location_cache | text | Yes | - |
| place_id | integer | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.