v_equipment
Table Name: v_equipment
Last Updated: June 01, 2026 at 01:21 AM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| name | character | Yes | - |
| model | character | Yes | - |
| make | character | Yes | - |
| serial_number | character | Yes | - |
| description | character | Yes | - |
| created_at | timestamp | Yes | - |
| xref_id | character | Yes | - |
| in_service | boolean | Yes | - |
| manufacture_date | date | Yes | - |
| manufacture_year | integer | Yes | - |
| manufacture_month | smallint | Yes | - |
| end_of_service_year | integer | Yes | - |
| closed_length | integer | Yes | - |
| annual_test_month | integer | Yes | - |
| annual_test_month_day | integer | Yes | - |
| equipment_group_id | integer | Yes | - |
| width | numeric(6 | Yes | - |
| end_of_service_month | smallint | Yes | - |
| grant_year | smallint | Yes | - |
| purchase_price | numeric | Yes | - |
| grant_name | character | Yes | - |
| is_grant_purchase | boolean | Yes | - |
| equipment_type | character | Yes | - |
| equipment_group_name | character | Yes | - |
| client_code | character | Yes | - |
| assigned_user_name | character | Yes | - |
| assigned_compartment_name | character | Yes | - |
| assigned_storage_name | character | Yes | - |
| size_inseam | character | Yes | - |
| weight | integer | Yes | - |
| no_of_sections | integer | Yes | - |
| rail_size | numeric(7 | Yes | - |
| assigned_kit_name | text | Yes | - |
| assigned_pouch_name | character | Yes | - |
| notes | character | Yes | - |
| ownership | character | Yes | - |
| initial_in_service_date | date | Yes | - |
| end_service_life_date | date | Yes | - |
| inventory_count | text | Yes | - |
| cylinder_size | character | Yes | - |
| inventory_min | text | Yes | - |
| inventory_max | text | Yes | - |
| original_length | integer | Yes | - |
| current_length | integer | Yes | - |
| max_fill_psi | integer | Yes | - |
| hose_type | character | Yes | - |
| jacket | character | Yes | - |
| diameter | numeric(3 | Yes | - |
| coupling_type | character | Yes | - |
| date_received | date | Yes | - |
| regulator_type | character | Yes | - |
| battery_type | character | Yes | - |
| estimated_replacement_cost | numeric(9 | Yes | - |
| next_hydro_static_test_date | date | Yes | - |
| last_hydro_static_test_date | date | Yes | - |
| next_service_test_date | date | Yes | - |
| last_service_test_date | date | Yes | - |
| high_pressure | boolean | Yes | - |
| fuel_type | character | Yes | - |
| operating_mechanism | character | Yes | - |
| size_waist | character | Yes | - |
| size_chest | character | Yes | - |
| size_front | character | Yes | - |
| size_back | character | Yes | - |
| size_sleeve | character | Yes | - |
| size_gloves | character | Yes | - |
| size_hood | character | Yes | - |
| size_helmet | character | Yes | - |
| outer_shell | character | Yes | - |
| thermal_liner | character | Yes | - |
| nfpa_edition | character | Yes | - |
| length_feet | integer | Yes | - |
| length_meters | integer | Yes | - |
| rope_length | integer | Yes | - |
| construction | character | Yes | - |
| fabric | character | Yes | - |
| stretch | character | Yes | - |
| primary_color | character | Yes | - |
| secondary_color | character | Yes | - |
| use_type | character | Yes | - |
| lot | character | Yes | - |
| dimension_of_rope | character | Yes | - |
| equipment_funding_source | character | Yes | - |
| boot_size | character | Yes | - |
| boot_width | character | Yes | - |
| is_archived | boolean | Yes | - |
| regulator_serial_number | character | Yes | - |
| regulator_flow_test_date | timestamp | Yes | - |
| pressure_gauge_serial_number | character | Yes | - |
| reducer_serial_number | character | Yes | - |
| iso_classification | character | Yes | - |
| equipment_hours | numeric(8 | Yes | - |
| electronic_product_code | character | Yes | - |
| fema_cost_code | text | Yes | - |
| time_out_of_service_in_day_hour_min_sec | text | Yes | - |
| apparatus_name | character | Yes | - |
| station_num | character | Yes | - |
| assigned_to | character | Yes | - |
| full_interval | interval | Yes | - |
| home_location_to | character | Yes | - |
| home_location_compartment_name | character | Yes | - |
| home_location_storage_name | character | Yes | - |
| home_location_kit_name | text | Yes | - |
| home_location_pouch_name | character | Yes | - |
| home_location_user_name | character | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.