v_time_off
Table Name: v_time_off
Last Updated: June 01, 2026 at 01:23 AM
Columns
| Column Name | Data Type | Nullable | Default |
|---|---|---|---|
| id | integer | Yes | - |
| user_id | integer | Yes | - |
| client_code | character | Yes | - |
| public_name | character | Yes | - |
| first_name | character | Yes | - |
| middle_name | character | Yes | - |
| last_name | character | Yes | - |
| time_off_type_name | character | Yes | - |
| time_off_type_shortcode | character | Yes | - |
| time_off_subtype_name | character | Yes | - |
| time_off_subtype_shortcode | character | Yes | - |
| project_code_name | character | Yes | - |
| project_code_shortcode | character | Yes | - |
| time_off_date | date | Yes | - |
| start_at_local | timestamp | Yes | - |
| end_at_local | timestamp | Yes | - |
| start_date | date | Yes | - |
| end_date | date | Yes | - |
| start_time | time | Yes | - |
| end_time | time | Yes | - |
| created_at | timestamp | Yes | - |
| duration_hours | numeric(5 | Yes | - |
| rotation_name | character | Yes | - |
| is_trade | boolean | Yes | - |
| is_kelly_day | boolean | Yes | - |
| is_approved | boolean | Yes | - |
| status_code | character | Yes | - |
| approving_user_id | integer | Yes | - |
| responded_at | timestamp | Yes | - |
| time_off_type_id | integer | Yes | - |
| rotation_id | integer | Yes | - |
| notes | text | Yes | - |
This documentation is automatically generated from the ODBC Data Warehouse schema.