api_external.travel
View
Flights and ground transport booked under the caller's engagements (Section 4.5.8 Crew Travel and Lodging), while the operational area is open. What the org paid never appears.
| Column | Type | Nullable | Description |
|---|---|---|---|
| id | uuid | Yes | Travel segment. |
| engagement_id | uuid | Yes | Engagement travelled under. |
| project_id | uuid | Yes | Project. |
| project_name | text | Yes | Project name. |
| travel_mode | app.travel_mode | Yes | Flight or Ground. |
| operator_name | text | Yes | Airline or ground operator. |
| service_identifier | text | Yes | Flight or service number. |
| confirmation_identifier | text | Yes | Booking confirmation. |
| departs_from | text | Yes | Departure place. |
| departs_at | timestamp with time zone | Yes | Departure time. |
| departs_time_zone | text | Yes | IANA time zone of the departure. |
| arrives_at_place | text | Yes | Arrival place. |
| arrives_at | timestamp with time zone | Yes | Arrival time; NULL when open. |
| arrives_time_zone | text | Yes | IANA time zone of the arrival. |