v_work_order
Table Name: v_work_order
Last Updated: June 01, 2026 at 01:23 AM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| summary | character | Yes | - |
| description | text | Yes | - |
| client_code | character | Yes | - |
| apparatus_id | integer | Yes | - |
| apparatus_name | character | Yes | - |
| equipment_id | integer | Yes | - |
| equipment_name | character | Yes | - |
| fire_station_id | integer | Yes | - |
| station_num | character | Yes | - |
| board_id | integer | Yes | - |
| board_name | character | Yes | - |
| created_at | timestamp | Yes | - |
| asset_work_order_status_id | integer | Yes | - |
| work_order_status | character | Yes | - |
| asset_work_order_type_id | integer | Yes | - |
| work_order_type | character | Yes | - |
| created_by | integer | Yes | - |
| created_by_name | character | Yes | - |
| kit_id | integer | Yes | - |
| is_archived | boolean | Yes | - |
| submitted_by | integer | Yes | - |
| archived_at | timestamp | Yes | - |
| submitted_by_name | character | Yes | - |
| updated_at | timestamp | Yes | - |
| eta | date | Yes | - |
| apparatus_odometer | numeric(8 | Yes | - |
| apparatus_pump_hours | numeric(8 | Yes | - |
| apparatus_engine_hours | numeric(8 | Yes | - |
| number | integer | Yes | - |
| apparatus_pto_hours | numeric(8 | Yes | - |
| apparatus_starting_aerial_hours | numeric(8 | Yes | - |
| kit_name | text | Yes | - |
| parts_cost | numeric | Yes | - |
| labor_hours | numeric | Yes | - |
| labor_cost | numeric | Yes | - |
| incident_number | character | Yes | - |
| vendor_name | character | Yes | - |
| priority_level_code | character | Yes | - |
| work_performed | text | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.