Table
duty_visit
2 rows
| id ↑ pk | visit_code | title_en | title_zh | report_required | report_due_date | report_submitted_date | report_completed | presentation_required | presentation_due_date | presentation_completed_date | presentation_completed | remarks | created_at | updated_at | visit_category_code fk | main_category_code fk | visit_direction_code fk | status_code fk | fiscal_year_code fk | event_series_code fk | stream | budget_annual_amount | estimation_before_departure_amount | actual_completion_amount | budget_annual_calc | estimation_before_departure_calc | actual_completion_calc | actual_expenditure_items | budget_vote_code | Actions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| c1e7cd24-f764-44bb-a8f3-10f169e77b5a | interschutz-2026 | INTERSCHUTZ 2026 | 漢諾威國際消防安全展覽會2026 | True | 05/08/2026 | False | True | 05/10/2026 | False | 14/05/2026 13:16:09 | 15/05/2026 01:46:26 | Exhibition exhibition | Overseas overseas | Outbound OUT | Confirmed CONFIRMED | 2026-27 | Interschutz interschutz | FIRE | 420000.00 | 475472.64 | 0.00 | {'pax': 0, 'others': '0', 'accommodation': '0', 'allowance_rate': '0', 'flight_per_pax': '0', 'ticket_per_pax': '0', 'allowance_amount': '0', 'allowance_factor': '1.00', 'allowance_nights': 0, 'calculated_total': '0.00'} | {'pax': 16, 'others': '0', 'accommodation': '0', 'allowance_rate': '9.19', 'flight_per_pax': '18000.00', 'ticket_per_pax': '542.00', 'allowance_amount': '304.00', 'allowance_factor': '1.00', 'allowance_nights': 4, 'calculated_total': '475472.64'} | [{'amount': '0.00', 'row_id': 'exp-mp68jqq2-l8tumf', 'item_name': 'nil', 'vote_code': '565_010', 'vote_name': 'International (Overseas Duty Visits) / 海外公務出訪', 'vote_locked': True, 'vote_name_en': 'International (Overseas Duty Visits)', 'vote_name_zh': '海外公務出訪', 'vote_override': False, 'fiscal_year_code': '2026-27', 'fiscal_year_locked': True, 'fiscal_year_override': False}] | 565_010 | |||||
| fca7a7b2-b57c-4c18-afa3-2342fc1622e8 | insarag-hnpw-2026 | INSARAG Steering Group (ISG) Meeting in Humanitarian Networks and Partnerships Weeks (HNPW) 2026 | True | False | True | False | 15/04/2026 09:29:19 | 14/05/2026 11:08:00 | Meeting meeting | Overseas overseas | Outbound OUT | Planning PLANNING | 2026-27 | INSARAG insarag | FIRE | {'pax': 0, 'others': '0', 'accommodation': '0', 'allowance_rate': '0', 'flight_per_pax': '0', 'ticket_per_pax': '0', 'allowance_amount': '0', 'allowance_factor': '1.00', 'allowance_nights': 0, 'calculated_total': '0.00'} | {'pax': 0, 'others': '0', 'accommodation': '0', 'allowance_rate': '0', 'flight_per_pax': '0', 'ticket_per_pax': '0', 'allowance_amount': '0', 'allowance_factor': '1.00', 'allowance_nights': 0, 'calculated_total': '0.00'} |