-- https://www.phpmyadmin.net/
--

START TRANSACTION;





--
-- Dumping data for table `core_pasajes_viaticos_catalog_items`
--

INSERT INTO `core_pasajes_viaticos_catalog_items` (`id`, `users_sid`, `global_branch_office_id`, `value`, `label`, `lang`, `catalog_code`, `catalog_code_dep`, `catalog_id_dep`, `description`, `svg_image`, `status`, `created_at`, `updated_at`) VALUES
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'DESPACHO DEL MINISTRO', 'es', 'AREA', '0', 0, 'Despacho del Ministro', NULL, 'A', '2021-07-26 16:03:34', '2021-07-26 16:03:34'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'UNIDAD DE COMUNICACIÓN SOCIAL - UCOS', 'es', 'AREA', '0', 0, 'Unidad de Comunicación Social - UCOS', NULL, 'A', '2021-07-26 16:03:45', '2021-07-26 16:03:45'),
(4, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'UNIDAD DE AUDITORÍA INTERNA - UAI', 'es', 'AREA', '0', 0, 'Unidad de Auditoría Interna - UAI', NULL, 'A', '2021-07-26 16:03:52', '2021-07-26 16:03:52'),
(5, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 4, 'UNIDAD DE TRANSPARENCIA Y LUCHA CONTRA LA CORRUPCIÓN - UTRA', 'es', 'AREA', '0', 0, 'Unidad de Transparencia y Lucha Contra la Corrupción - UTRA', NULL, 'A', '2021-07-26 16:04:01', '2021-07-26 16:04:01'),
(6, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 5, 'DIRECCIÓN GENERAL DE CONTROL Y FISCALIZACIÓN - DGCF', 'es', 'AREA', '0', 0, 'Dirección General de Control y Fiscalización - DGCF', NULL, 'A', '2021-07-26 16:04:24', '2021-07-26 16:04:24'),
(7, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 6, 'DIRECCIÓN GENERAL DE ASUNTOS JURÍDICOS - DGAJ', 'es', 'AREA', '0', 0, 'Dirección General de Asuntos Jurídicos - DGAJ', NULL, 'A', '2021-07-26 16:04:38', '2021-07-26 16:04:38'),
(8, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 7, 'DIRECCIÓN GENERAL DE ASUNTOS ADMINISTRATIVOS - DGAA', 'es', 'AREA', '0', 0, 'Dirección General de Asuntos Administrativos - DGAA', NULL, 'A', '2021-07-26 16:04:47', '2021-07-26 16:04:47'),
(9, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8, 'VICEMINISTERIO DE PLANIFICACIÓN Y DESARROLLO ENERGÉTICO - VMPDE', 'es', 'AREA', '0', 0, 'Viceministerio de Planificación y Desarrollo Energético - VMPDE', NULL, 'A', '2021-07-26 16:05:26', '2021-07-26 16:05:26'),
(10, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 9, 'VICEMINISTERIO DE PLANIFICACIÓN Y DESARROLLO ENERGÉTICO - VMPDE', 'es', 'AREA', '0', 0, 'Viceministerio de Planificación y Desarrollo Energético - VMPDE', NULL, 'A', '2021-07-26 16:05:34', '2021-07-26 16:05:34'),
(11, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 10, 'VICEMINISTERIO DE PLANIFICACIÓN Y DESARROLLO ENERGÉTICO - VMPDE', 'es', 'AREA', '0', 0, 'Viceministerio de Planificación y Desarrollo Energético - VMPDE', NULL, 'A', '2021-07-26 16:05:39', '2021-07-26 16:05:39'),
(12, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 11, 'VICEMINISTERIO DE EXPLORACIÓN Y EXPLOTACIÓN DE HIDROCARBUROS - VMEEH', 'es', 'AREA', '0', 0, 'Viceministerio de Exploración y Explotación de Hidrocarburos - VMEEH', NULL, 'A', '2021-07-26 16:05:47', '2021-07-26 16:06:09'),
(13, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 12, 'VICEMINISTERIO DE INDUSTRIALIZACIÓN, COMERCIALIZACION, TRANSPORTE Y ALMACENAJE DE HIDROCARBUROS - VMICTAH', 'es', 'AREA', '0', 0, 'Viceministerio de Industrialización, Comercializacion, Transporte y Almacenaje de Hidrocarburos - VMICTAH', NULL, 'A', '2021-07-26 16:06:40', '2021-07-26 16:06:40'),
(14, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 13, 'VICEMINISTERIO DE ELECTRICIDAD Y ENERGÌAS ALTERNATIVAS VMEEA', 'es', 'AREA', '0', 0, 'Viceministerio de Electricidad y Energìas Alternativas VMEEA', NULL, 'A', '2021-07-26 16:06:52', '2021-07-26 16:06:52'),
(15, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 14, 'VICEM. DE ALTAS TECNOLOGIAS ENERGETICAS - VMATE', 'es', 'AREA', '0', 0, 'VICEM. DE ALTAS TECNOLOGIAS ENERGETICAS - VMATE', NULL, 'A', '2021-07-26 16:07:10', '2021-09-06 11:57:42'),
(73, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'REUNIONES, APOYO Y SEGUIMIENTO', 'es', 'CATEGORIA', '0', 0, 'Reuniones, apoyo y seguimiento', NULL, 'A', '2021-07-26 16:17:16', '2021-07-26 16:20:18'),
(74, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'ASISTENCIA TECNICA REMOTA', 'es', 'CATEGORIA', '0', 0, 'Asistencia técnica remota', NULL, 'A', '2021-07-26 16:17:39', '2021-07-26 16:17:39'),
(75, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'ASISTENCIA TECNICA INMEDIATA', 'es', 'CATEGORIA', '0', 0, 'Asistencia ténica inmediata', NULL, 'A', '2021-07-26 16:18:05', '2021-07-26 16:18:05'),
(76, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 4, 'MANTENIMIENTO PREVENTIVO CORRECTIVO', 'es', 'CATEGORIA', '0', 0, 'Mantenimiento preventivo correctivo', NULL, 'A', '2021-07-26 16:18:26', '2021-07-26 16:18:26'),
(77, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 5, 'OFIMATICA, IMPRESIONES, OTROS', 'es', 'CATEGORIA', '0', 0, 'Ofimática, impresiones y otros', NULL, 'A', '2021-07-26 16:18:55', '2021-07-26 16:18:55'),
(78, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 6, 'INTERNET, WIFI, CAMARAS DE SEGURIDAD', 'es', 'CATEGORIA', '0', 0, 'Internet, wifi, cámaras de seguridad', NULL, 'A', '2021-07-26 16:19:46', '2021-07-26 16:19:46'),
(79, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'PARAFERNALIA REQUERIDA PARA UNA REUNION EXITOSA', 'es', 'CATEGORIA', 'CATEGORIA', 1, 'Parafernalia requerida para una reunión exitosa', NULL, 'A', '2021-07-26 16:21:26', '2021-07-26 16:21:26'),
(80, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'SEGUIMIENTO A REUNION PRESENCIAL O VIRTUAL', 'es', 'CATEGORIA', 'CATEGORIA', 1, 'Seguimiento a reunión presencial o virtual', NULL, 'A', '2021-07-26 16:21:53', '2021-07-26 16:21:53'),
(81, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'APOYO LOGISTICO', 'es', 'CATEGORIA', 'CATEGORIA', 1, 'Apoyo logístico', NULL, 'A', '2021-07-26 16:22:04', '2021-07-26 16:22:04'),
(82, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'ASISTENCIA TECNICA TELEFONICA', 'es', 'CATEGORIA', 'CATEGORIA', 2, 'Asistencia técnica telefónica', NULL, 'A', '2021-07-26 16:22:44', '2021-07-26 16:22:44'),
(83, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'ASISTENCIA TECNICA POR INTERNET', 'es', 'CATEGORIA', 'CATEGORIA', 2, 'Asistencia técnica por internet', NULL, 'A', '2021-07-26 16:23:02', '2021-07-26 16:23:02'),
(84, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'ASISTENCIA TECNICA PRESENCIAL INMEDIATA', 'es', 'CATEGORIA', 'CATEGORIA', 3, 'Asistencia técnica presencial inmediata', NULL, 'A', '2021-07-26 16:23:28', '2021-07-26 16:23:28'),
(85, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'DIAGNOSTICO, MANTENIMIENTO PREVENTIVO CORRECTIVO', 'es', 'CATEGORIA', 'CATEGORIA', 4, 'Diagnóstico, mantenimiento preventivo correctivo', NULL, 'A', '2021-07-26 16:24:54', '2021-07-26 16:24:54'),
(86, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'REPARACION, REEMPLAZO O COMPRA DE EQUIPO', 'es', 'CATEGORIA', 'CATEGORIA', 4, 'Reparación, reemplazo o compra de equipo', NULL, 'A', '2021-07-26 16:25:53', '2021-07-26 16:25:53'),
(87, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'SOPORTE EN OFIMATICA (OFFICE, WINDOWS, OTROS PROGRAMAS)', 'es', 'CATEGORIA', 'CATEGORIA', 5, 'Soporte en ofimática', NULL, 'A', '2021-07-26 16:26:43', '2021-07-26 16:26:43'),
(88, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'IMPRESION DE DOCUMENTOS, CONFIGURACION DE IMPRESORAS O FAX', 'es', 'CATEGORIA', 'CATEGORIA', 5, 'Impresión de documentos', NULL, 'A', '2021-07-26 16:27:17', '2021-07-26 16:27:17'),
(89, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'SOPORTE PROGRAMAS DE PAGO DE TERCEROS', 'es', 'CATEGORIA', 'CATEGORIA', 5, 'Soporte programas de pago', NULL, 'A', '2021-07-26 16:27:45', '2021-07-26 16:27:45'),
(90, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'DIAGNOSTICO, CONEXION O RE-CONEXION DE INTERNET', 'es', 'CATEGORIA', 'CATEGORIA', 6, 'DIAGNOSTICO, CONEXION O RE-CONEXION DE INTERNET', NULL, 'A', '2021-07-26 16:29:01', '2021-07-26 16:29:01'),
(91, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'DIAGNOSTICO, CONEXION, RE-CONEXCION, REPARACION DE REDES WIFI', 'es', 'CATEGORIA', 'CATEGORIA', 6, 'DIAGNOSTICO, CONEXION, RE-CONEXCION, REPARACION DE REDES WIFI', NULL, 'A', '2021-07-26 16:29:30', '2021-07-26 16:29:30'),
(92, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'CONFIGURACION, MANTENIMIENTO, REPARACION O REEMPLAZO DE CAMARAS DE SEGURIDAD', 'es', 'CATEGORIA', 'CATEGORIA', 6, 'CONFIGURACION, MANTENIMIENTO, REPARACION O REEMPLAZO DE CAMARAS DE SEGURIDAD', NULL, 'A', '2021-07-26 16:29:55', '2021-07-26 16:29:55'),
(93, '7d85e609-c75e-404d-bf77-2169a6f2c1e6', NULL, 1, 'ALTA', 'es', 'PRIORIDAD', '0', 0, 'Alta - urgente', NULL, 'A', '2021-07-26 16:30:34', '2021-07-29 09:52:27'),
(94, '7d85e609-c75e-404d-bf77-2169a6f2c1e6', NULL, 2, 'BAJA', 'es', 'PRIORIDAD', '0', 0, 'Baja', NULL, 'A', '2021-07-26 16:31:33', '2021-07-29 09:52:33'),
(95, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'HORA(S)', 'es', 'UNIDAD DE TIEMPO', '0', 0, 'Hora(s)', NULL, 'A', '2021-07-26 16:31:55', '2021-07-26 16:31:55'),
(96, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'MINUTOS', 'es', 'UNIDAD DE TIEMPO', '0', 0, 'Minutos', NULL, 'A', '2021-07-26 16:32:04', '2021-07-26 16:32:04'),
(97, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'ABIERTO - TRABAJO EN CURSO', 'es', 'ESTADO DEL TICKET', '0', 0, 'Trabajo en curso', NULL, 'A', '2021-07-26 16:33:16', '2021-07-26 16:33:16'),
(98, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'ABIERTO - COTIZACION DE REPUESTOS', 'es', 'ESTADO DEL TICKET', '0', 0, 'Cotización de respuestos', NULL, 'A', '2021-07-26 16:34:18', '2021-07-26 16:34:18'),
(99, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'CERRADO - A LA ESPERA DE CONFORMIDAD', 'es', 'ESTADO DEL TICKET', '0', 0, 'CERRADO - A LA ESPERA DE CONFORMIDAD', NULL, 'A', '2021-07-26 16:35:09', '2021-07-26 16:35:09'),
(100, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'URGENTE', 'es', 'PRIORIDAD', '0', 0, 'Urgente', NULL, 'A', '2021-08-04 09:42:05', '2021-08-04 09:42:05'),
(101, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 1, 'Ministro ', 'es', 'CARGO', '0', 0, 'Ministro de Estado', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(102, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 2, 'Asesor ', 'es', 'CARGO', '0', 0, 'Jefe Unidad I - Asesor', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(103, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 3, 'Jefe de Gabinete ', 'es', 'CARGO', '0', 0, 'Jefe de Unidad II - Jefe de Gabinete', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(104, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 4, 'Jefe de la Unidad de Comunicación Social', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(105, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 5, 'Profesional de Imagen y Video', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(106, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 6, 'Profesional de Prensa y WEB', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(107, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 7, 'Técnico en Comunicación y Logistica', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(108, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8, 'Jefe de la Unidad de Auditoria Interna', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(109, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 9, 'Profesional Supervisor Auditor Interno ', 'es', 'CARGO', '0', 0, 'Profesional VII - Técnico I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(110, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 10, 'Profesional Auditor Interno ', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(111, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 11, 'Profesional Auditor Interno ', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(112, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 12, 'Jefe de la Unidad de Transparencia y Lucha Contra la Corrupción', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(113, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 13, 'Profesional en Análisis Económico Financiero del MHE', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(114, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 14, 'Profesional Analista Jurídico de Transaparencia', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(115, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 15, 'Asistente de Transparencia', 'es', 'CARGO', '0', 0, 'Administrativo III - Ujier Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(116, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 16, 'Director General de Control y Fiscalización', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(117, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 17, 'Secretaria DGCF', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(118, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 18, 'Asistente de Control y Fiscalización', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(119, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 19, 'Jefe de la Unidad de Control y Fiscalización Energética', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(120, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 20, 'Profesional en Derecho Regulatorio de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(121, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 21, 'Profesional en Derecho Regulatorio de Energía', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(122, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 22, 'Profesional Analista Técnico de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(123, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 23, 'Profesional Analista Técnico de Energía', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(124, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 24, 'Director General de Asuntos Jurídicos', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(125, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 25, 'Secretaria DGAJ', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(126, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 26, 'Ujier DGAJ', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(127, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 27, 'Jefe de la Unidad de Análisis Jurídico', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(128, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 28, 'Profesional Abogado de Análisis Jurídico', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(129, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 29, 'Profesional Abogado de Análisis Jurídico', 'es', 'CARGO', '0', 0, 'Responsable IV - Profesional III', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(130, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 30, 'Profesional Abogado de Análisis Jurídico', 'es', 'CARGO', '0', 0, 'Profesional VII - Técnico I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(131, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 31, 'Profesional Abogado de Análisis Jurídico', 'es', 'CARGO', '0', 0, 'Profesional VII - Técnico I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(132, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 32, 'Técnico de Análisis Jurídico', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(133, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 33, 'Jefe de Unidad de Gestión Jurídica    ', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(134, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 34, 'Profesional Abogado de Gestión Jurídica', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(135, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 35, 'Profesional Abogado de Gestión Jurídica', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(136, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 36, 'Profesional Abogado de Gestión Jurídica', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(137, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 37, 'Profesional Abogado de Gestión Jurídica', 'es', 'CARGO', '0', 0, 'Profesional VII - Técnico I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(138, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 38, 'Técnico Procesalista', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(139, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 39, 'Procurador Abogado', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(140, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 40, 'Director General de Asuntos Administrativos', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(141, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 41, 'Secretaria DGAA', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(142, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 42, 'Ujier DGAA', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(143, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 43, 'Asistente DGAA - (oficina Regional Santa Cruz)', 'es', 'CARGO', '0', 0, 'Administrativo IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(144, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 44, 'Técnico Ejecutivo de Despacho Ministro', 'es', 'CARGO', '0', 0, 'Profesional VII - Técnico I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(145, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 45, 'Secretaria Despacho Ministro', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(146, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 46, 'Chofer Despacho Ministro', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(147, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 47, 'Ujier Despacho Ministro', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(148, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 48, 'Asistente Administrativo Despacho - Santa Cruz', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(149, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 49, 'Asistente de Archivo Despacho', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(150, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 50, 'Encargado Atención Ventanilla Unica', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(151, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 51, 'Jefe de la Unidad Financiera', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(152, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 52, 'Profesional  Financiero', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(153, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 53, 'Contador General', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(154, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 54, 'Profesional de Tesorería', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(155, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 55, 'Encargado de Pasajes y Viáticos', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(156, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 56, 'Profesional de Presupuestos', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(157, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 57, 'Técnico de Presupuestos', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(158, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 58, 'Jefe de la Unidad de Recursos Humanos y Administrativos', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(159, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 59, 'Profesional en Recursos Humanos y Normas', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(160, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 60, 'Habilitado de Planillas', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(161, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 61, 'Técnico en Recursos Humanos', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(162, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 62, 'Telefonista', 'es', 'CARGO', '0', 0, 'Auxiliar I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(163, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 63, 'Portero Almacén TARIJA', 'es', 'CARGO', '0', 0, 'Auxiliar I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(164, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 64, 'Profesional de Contrataciones', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(165, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 65, 'Técnico en Compras y Contrataciones', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(166, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 66, 'Encargado de Archivo Central', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(167, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 67, 'Asistente de Archivo Central', 'es', 'CARGO', '0', 0, 'Administrativo IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(168, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 68, 'Encargado de Servicios Generales', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(169, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 69, 'Técnico de  Servicios Generales', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(170, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 70, 'Encargado de Activos Fijos', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(171, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 71, 'Técnico de Activos Fijos', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(172, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 72, 'Encargado Almacén Central', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(173, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 73, 'Profesional de Tecnología de Información y Comunicación', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(174, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 74, 'Encargado de Soporte Técnico e Informático', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(175, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 75, 'Técnico Digitalizador', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(176, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 76, 'Técnico en Soporte y Sistemas Informáticos', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(177, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 77, 'Viceministro de Planificación y Desarrollo  Energético', 'es', 'CARGO', '0', 0, 'Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(178, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 78, 'Secretaria VMPDE', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(179, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 79, 'Chofer VMPDE', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(180, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 80, 'Ujier VMPDE', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(181, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 81, 'Director General de Gestión Socio Ambiental', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(182, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 82, 'Secretaria DGGSA', 'es', 'CARGO', '0', 0, 'Técnico VI -Secretaria de Dirección Gral. - Chofer Ministro - Ujier Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(183, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 83, 'Ujier DGGSA', 'es', 'CARGO', '0', 0, 'Administrativo II - Ujier de Dirección Gral.', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(184, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 84, 'Jefe de la Unidad de Prevención y Control Socio Ambiental', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(185, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 85, 'Profesional en Prevención y Control Socio Ambiental UPSTREAM', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(186, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 86, 'Profesional en Prevención y Control Socio Ambiental DOWNSTREAM', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(187, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 87, 'Profesional en Prevención Socio Ambiental', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(188, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 88, 'Jefe de Unidad de Seguimiento y Control', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(189, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 89, 'Profesional de Pasivos Ambientales', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(190, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 90, 'Profesional en Seguimiento y Control Ambiental UPSTREAM', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(191, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 91, 'Profesional en Seguimiento y Control Ambiental DOWNSTREAM', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(192, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 92, 'Jefe de Unidad de Consulta y Participación', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(193, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 93, 'Profesional  en Gestión Socio Ambiental y Conflictos', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(194, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 94, 'Profesional  Administrativo Financiero Socio Ambiental', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(195, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 95, 'Profesional en Consulta y Participación', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(196, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 96, 'Director General de Planifcación y Desarrollo Energético', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(197, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 97, 'Jefe de Unidad de Planificación y Desarrollo Energético', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(198, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 98, 'Responsable en Planificación Sectorial y Estratégica', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(199, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 99, 'Profesional en Planificación y Evaluación de Proyectos', 'es', 'CARGO', '0', 0, 'Responsable IV - Profesional III', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(200, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 100, 'Profesional en Planificación y Prospectiva Energética', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(201, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 101, 'Profesional en Planificación Operativa', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(202, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 102, 'Jefe de Unidad de Estadisticas e Información Energética', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(203, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 103, 'Profesional en Balance Energético', 'es', 'CARGO', '0', 0, 'Responsable IV - Profesional III', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(204, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 104, 'Profesional en Estadisticas e Información Energética', 'es', 'CARGO', '0', 0, 'Responsable IV - Profesional III', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(205, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 105, 'Viceministro de Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(206, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 106, 'Secretaria VMEEH', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(207, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 107, 'Chofer VMEEH', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(208, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 108, 'Ujier VMEEH', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(209, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 109, 'Director General de Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(210, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 110, 'Jefe Unidad de Normas y  Control Técnico en Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(211, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 111, 'Profesional  en Normativa de Exploración de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(212, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 112, 'Profesional en Análisis Económico de Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(213, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 113, 'Profesional Legal en Normativa de Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(214, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 114, 'Profesional  en Análisis Econométrico', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(215, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 115, 'Profesional  en Análisis Técnico Exploración y Explotación', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(216, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 116, 'Jefe de la Unidad de Control Técnico de Actividades de Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(217, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 117, 'Profesional en Seguimiento a Reservas y Operaciones de Pozo y Planta', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(218, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 118, 'Profesional en Evaluación de Areas de Interés Hidrocarburifero y Reconocimiento Superficial', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(219, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 119, 'Profesional en Seguimiento a Inversiones y Costos de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(220, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 120, 'Profesional en Control Cartográfico de Exploración y Explotación de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(221, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 121, 'Profesional en Seguimiento a Actividades de Exploración y Explotacion de Hidrocarburos ', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(222, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 122, 'Director General de Producción, Recaudación e Incentivos', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(223, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 123, 'Jefe de la Unidad de Producción, Recaudación e Incentivos', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(224, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 124, 'Profesional en Ingresos por la Producción de Gas Natural', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(225, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 125, 'Profesional en Ingresos por la Producción de Hidrocarburos Líquidos', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(226, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 126, 'Profesional en Análisis y Supervisión de Costos Generados por Incentivos ', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(227, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 127, 'Profesional  en Análisis y Control de Incentivos por Producción', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(228, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 128, 'Profesional en Control y Seguimiento de la Producción Fiscalizada', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(229, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 129, 'Profesional en Desarrollo y Administración de Información de Producción y Recaudaciones', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(230, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 130, 'Profesional  en Análisis y Supervisión de Costos Generados por Incentivos y Recaudaciones', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(231, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 131, 'Profesional para el Control de Recaudaciones Petroleras', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(232, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 132, 'Viceministro de Industrialización, Comercialización, Transporte y Almacenaje de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(233, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 133, 'Secretaria VMICTAH', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(234, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 134, 'Chofer VMICTAH', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(235, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 135, 'Ujier VMICTAH', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(236, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 136, 'Director General de Industrialización y Refinación', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(237, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 137, 'Profesional Economico de Industrialización y Refinación', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(238, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 138, 'Jefe de la Unidad de Industrialización', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(239, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 139, 'Profesional en Fertilizantes Nitrogenados', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(240, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 140, 'Jefe de la Unidad de Refinación', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(241, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 141, 'Profesional en Proyectos de Refinación', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(242, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 142, 'Profesional en Plantas de Separación de Licuables', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(243, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 143, 'Técnico en Procesos de Refinación    ', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(244, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 144, 'Director General de Comercialización, Transporte y Almacenaje', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(245, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 145, 'Jefe de la Unidad de Transporte, Almacenaje y Distribución de Gas', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(246, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 146, 'Profesional en Logistica de Hidrocarburos ', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(247, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 147, 'Profesional en Sistemas de Gas Natural', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(248, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 148, 'Profesional de Transporte por Ductos', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(249, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 149, 'Jefe de la Unidad de Comercialización de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(250, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 150, 'Profesional  Económico en Determinación de Subsidio de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(251, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 151, 'Profesional Económico en Comercialización de Hidrocarburos', 'es', 'CARGO', '0', 0, 'Profesional IV', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(252, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 152, 'Profesional en Comercialización de Combustibles Líquidos', 'es', 'CARGO', '0', 0, 'Profesional IX - Técnico III - Secretaria Ministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(253, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 153, 'Viceministro de Electricidad y Energías Alternativas', 'es', 'CARGO', '0', 0, 'Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(254, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 154, 'Secretaria VMEEA', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(255, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 155, 'Ujier VMEEA', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(256, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 156, 'Chofer VMEEA', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-10-22 09:11:59'),
(257, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 157, 'Director General de Electricidad', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(258, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 158, 'Profesional  en Evaluación y Seguimiento Técnico en Proyectos de Transmision e Interconexión', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(259, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 159, 'Profesional  en Mercados Energéticos  y Transacciones Internacionales', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(260, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 160, 'Profesional  en Evaluación y Seguimiento Técnico en Proyectos de Generación', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(261, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 161, 'Profesional  en Proyectos Hidroeléctricos (Construcción de Presas, Embalses, Tuneles y Obras Civiles)', 'es', 'CARGO', '0', 0, 'Responsable II - Profesional I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(262, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 162, 'Jefe Unidad de Evaluación y Normas', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(263, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 163, 'Profesional en Evaluación y Monitoreo', 'es', 'CARGO', '0', 0, 'Profesional VI', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(264, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 164, 'Profesional de la Normativa de Generación y Transporte', 'es', 'CARGO', '0', 0, 'Responsable II - Profesional I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(265, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 165, 'Director General de Energias Alternativas', 'es', 'CARGO', '0', 0, 'Director General  - Sec.Priv. Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(266, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 166, 'Profesional  en Energías Alternativas', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(267, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 167, 'Profesional  en Seguimiento de Proyectos', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(268, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 168, 'Profesional  en Eficiencia Energética', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(269, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 169, 'Profesional  en Energías Renovables no Convencionales', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(270, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 170, 'Profesional de Normas, Reglamentos Técnicos y Convenios para Energías Alternativas', 'es', 'CARGO', '0', 0, 'Profesional VII - Técnico I', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(271, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 171, 'Jefe Unidad Desarrollo de Infraestructura y Electrificación Rural', 'es', 'CARGO', '0', 0, 'Jefe de Unidad IV - Especialista II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(272, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 172, 'Profesional en Gestión de la Información Geográfica del Sector Eléctrico y Cobertura', 'es', 'CARGO', '0', 0, 'Responsable III - Profesional II', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(273, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 173, 'Profesional  en Gestión de Financiamiento y Seguimiento Institucional', 'es', 'CARGO', '0', 0, 'Profesional V', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(274, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 174, 'Profesional en Sistemas Aislados', 'es', 'CARGO', '0', 0, 'Profesional VIII - Técnico II - Secretaria Presidente', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(275, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 175, 'VICEMINISTRO DE ALTAS TECNOLOGÍAS ENERGÉTICAS (LITIO, ENERGÍA NUCLEAR)', 'es', 'CARGO', '0', 0, 'VICEMINISTRO DE ALTAS TECNOLOGÍAS ENERGÉTICAS (LITIO, ENERGÍA NUCLEAR)', NULL, 'A', '2021-09-01 13:50:04', '2022-06-10 10:50:48'),
(276, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 176, 'Secretaria VMATE', 'es', 'CARGO', '0', 0, 'Técnico V - Secretaria Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(277, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 177, 'Chofer VMATE', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(278, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 178, 'Ujier VMATE', 'es', 'CARGO', '0', 0, 'Administrativo I - Secretaria Unidad - Chofer Viceministro - Ujier Viceministro', NULL, 'A', '2021-09-01 13:50:04', '2021-09-01 13:50:04'),
(279, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 179, 'UNIDAD FINANCIERA - UFIN', 'es', 'CARGO', '0', 0, 'Unidad financiera - UFIN', NULL, 'A', '2021-09-03 16:24:22', '2021-09-03 16:24:22'),
(280, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 15, 'UNIDAD FINANCIERA - UFIN', 'es', 'AREA', '0', 0, 'Unidad financiera - UFIN', NULL, 'A', '2021-09-03 16:25:27', '2021-09-03 16:25:27');
INSERT INTO `core_pasajes_viaticos_catalog_items` (`id`, `users_sid`, `global_branch_office_id`, `value`, `label`, `lang`, `catalog_code`, `catalog_code_dep`, `catalog_id_dep`, `description`, `svg_image`, `status`, `created_at`, `updated_at`) VALUES
(281, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 16, 'UNIDAD DE RECURSOS HUMANOS Y ADMINISTRATIVOS - URHA', 'es', 'AREA', '0', 0, 'UNIDAD DE RECURSOS HUMANOS Y ADMINISTRATIVOS - URHA', NULL, 'A', '2021-09-03 16:34:54', '2021-09-03 16:34:54'),
(282, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 17, 'AREA DE COMPRAS Y CONTRATACIONES', 'es', 'AREA', '0', 0, 'AREA DE COMPRAS Y CONTRATACIONES', NULL, 'A', '2021-09-03 16:36:48', '2021-09-03 16:36:48'),
(283, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 18, 'ARCHIVO CENTRAL', 'es', 'AREA', '0', 0, 'ARCHIVO CENTRAL', NULL, 'A', '2021-09-03 16:37:49', '2021-09-03 16:37:49'),
(284, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 19, 'SERVICIOS GENERALES', 'es', 'AREA', '0', 0, 'SERVICIOS GENERALES', NULL, 'A', '2021-09-03 16:38:39', '2021-09-03 16:38:39'),
(285, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 20, 'ACTIVOS FIJOS', 'es', 'AREA', '0', 0, 'ACTIVOS FIJOS', NULL, 'A', '2021-09-03 16:39:31', '2021-09-03 16:39:31'),
(286, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 21, 'ARCHIVO CENTRAL', 'es', 'AREA', '0', 0, 'ARCHIVO CENTRAL', NULL, 'A', '2021-09-03 16:40:25', '2021-09-03 16:40:25'),
(287, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 22, 'AREA DE TECNOLOGIAS DE INFORMACION Y COMUNICACIÓN - ATIC', 'es', 'AREA', '0', 0, 'AREA DE TECNOLOGIAS DE INFORMACION Y COMUNICACIÓN - ATIC', NULL, 'A', '2021-09-03 16:41:23', '2021-09-03 16:41:23'),
(288, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 23, 'DIRECCIÓN GENERAL DE GESTIÓN SOCIO AMBIENTAL- DGGSA', 'es', 'AREA', '0', 0, 'DIRECCIÓN GENERAL DE GESTIÓN SOCIO AMBIENTAL- DGGSA', NULL, 'A', '2021-09-03 16:54:35', '2021-09-03 16:54:35'),
(289, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 24, 'UNIDAD DE PREVENCION Y CONTROL SOCIO AMBIENTAL- UPCSA', 'es', 'AREA', '0', 0, 'UNIDAD DE PREVENCION Y CONTROL SOCIO AMBIENTAL- UPCSA', NULL, 'A', '2021-09-03 16:57:20', '2021-09-03 16:57:20'),
(290, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 25, 'UNIDAD DE SEGUIMIENTO Y CONTROL - USC', 'es', 'AREA', '0', 0, 'UNIDAD DE SEGUIMIENTO Y CONTROL - USC', NULL, 'A', '2021-09-03 17:00:20', '2021-09-03 17:00:20'),
(291, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 26, 'UNIDAD DE CONSULTA Y PARTICIPACION - UCP', 'es', 'AREA', '0', 0, 'UNIDAD DE CONSULTA Y PARTICIPACION - UCP', NULL, 'A', '2021-09-06 11:26:23', '2021-09-06 11:26:23'),
(292, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 27, 'DIREC GRAL DE PLANIFICACIÓN Y DESARROLLO ENERGETICO - DGPDE', 'es', 'AREA', '0', 0, 'DIREC GRAL DE PLANIFICACIÓN Y DESARROLLO ENERGETICO - DGPDE', NULL, 'A', '2021-09-06 11:28:16', '2021-09-06 11:28:16'),
(293, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 28, 'UNIDAD DE PLANIFICACION Y DESARROLLO ENERGETICO - UPDE', 'es', 'AREA', '0', 0, 'UNIDAD DE PLANIFICACION Y DESARROLLO ENERGETICO - UPDE', NULL, 'A', '2021-09-06 11:28:32', '2021-09-06 11:28:32'),
(294, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 29, 'UNIDAD DE ESTADISTICAS E INFORMACION ENERGETICA - UEIE', 'es', 'AREA', '0', 0, 'UNIDAD DE ESTADISTICAS E INFORMACION ENERGETICA - UEIE', NULL, 'A', '2021-09-06 11:31:26', '2021-09-06 11:31:26'),
(295, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 30, 'DIREC GRAL DE CONTROL Y FISCAL. ENERGÉTICA- DGCFE', 'es', 'AREA', '0', 0, 'DIREC GRAL DE CONTROL Y FISCAL. ENERGÉTICA- DGCFE', NULL, 'A', '2021-09-06 11:31:50', '2021-09-06 11:31:50'),
(296, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 31, 'DIRECCIÓN GENERAL DE E&E DE HIDROCARBUROS - DGEEH', 'es', 'AREA', '0', 0, 'DIRECCIÓN GENERAL DE E&E DE HIDROCARBUROS - DGEEH', NULL, 'A', '2021-09-06 11:35:32', '2021-09-06 11:35:32'),
(297, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 32, 'UNIDAD DE POL. Y NOR. EN E&E DE HIDROC. - UPNEEH', 'es', 'AREA', '0', 0, 'UNIDAD DE POL. Y NOR. EN E&E DE HIDROC. - UPNEEH', NULL, 'A', '2021-09-06 11:35:50', '2021-09-06 11:35:50'),
(298, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 33, 'UNIDAD DE CON. TÉC. DE ACT. DE E&E HIDROC. - UNCTAEEH', 'es', 'AREA', '0', 0, 'UNIDAD DE CON. TÉC. DE ACT. DE E&E HIDROC. - UNCTAEEH', NULL, 'A', '2021-09-06 11:39:05', '2021-09-06 11:39:05'),
(299, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 34, 'DIREC. GRAL. DE PROD. RECAUDACION E INCENTIVOS - DGPRI', 'es', 'AREA', '0', 0, 'DIREC. GRAL. DE PROD. RECAUDACION E INCENTIVOS - DGPRI', NULL, 'A', '2021-09-06 11:39:22', '2021-09-06 11:39:22'),
(300, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 35, 'DIREC. GRAL. DE INDUSTRIALIZACIÓN Y REFINACIÓN - DGIR', 'es', 'AREA', '0', 0, 'DIREC. GRAL. DE INDUSTRIALIZACIÓN Y REFINACIÓN - DGIR', NULL, 'A', '2021-09-06 11:39:49', '2021-09-06 11:39:49'),
(301, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 36, 'UNIDAD DE  INDUSTRIALIZACIÓN - UIN', 'es', 'AREA', '0', 0, 'UNIDAD DE  INDUSTRIALIZACIÓN - UIN', NULL, 'A', '2021-09-06 11:40:00', '2021-09-06 11:40:00'),
(302, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 37, 'UNIDAD DE REFINACIÓN - URE', 'es', 'AREA', '0', 0, 'UNIDAD DE REFINACIÓN - URE', NULL, 'A', '2021-09-06 11:40:13', '2021-09-06 11:40:13'),
(303, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 38, 'DIREC GRAL. COMERCIALIZACION Y TRASPORTE Y ALMACENAJE - DGCTA', 'es', 'AREA', '0', 0, 'DIREC GRAL. COMERCIALIZACION Y TRASPORTE Y ALMACENAJE - DGCTA', NULL, 'A', '2021-09-06 11:40:29', '2021-09-06 11:40:29'),
(304, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 39, 'UNIDAD DE TRASP. ALMAC. Y DISTRIB. DE GAS - UTADG', 'es', 'AREA', '0', 0, 'UNIDAD DE TRASP. ALMAC. y DISTRIB. DE GAS - UTADG', NULL, 'A', '2021-09-06 11:40:42', '2021-09-06 11:40:42'),
(305, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 40, 'UNIDAD DE COMERCIALIZACION DE HIDROCARBUROS - UCOH', 'es', 'AREA', '0', 0, 'UNIDAD DE COMERCIALIZACION DE HIDROCARBUROS - UCOH', NULL, 'A', '2021-09-06 11:41:00', '2021-09-06 11:41:00'),
(306, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 41, 'UNIDAD DE PROD, RECAUDACION E INCENTIVOS - UPRI', 'es', 'AREA', '0', 0, 'UNIDAD DE PROD, RECAUDACION E INCENTIVOS - UPRI', NULL, 'A', '2021-09-06 11:46:19', '2021-09-06 11:46:19'),
(307, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 42, 'DIRECCION GENERAL DE ELECTRICIDAD - DGE', 'es', 'AREA', '0', 0, 'DIRECCION GENERAL DE ELECTRICIDAD - DGE', NULL, 'A', '2021-09-06 11:56:40', '2021-09-06 11:56:40'),
(308, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 43, 'UNIDAD DE EVALUACION Y NORMAS - UEN', 'es', 'AREA', '0', 0, 'UNIDAD DE EVALUACION Y NORMAS - UEN', NULL, 'A', '2021-09-06 11:56:49', '2021-09-06 11:56:49'),
(309, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 44, 'DIRECCION GENERAL DE ENERGIAS ALTERNATIVAS - DGEA', 'es', 'AREA', '0', 0, 'DIRECCION GENERAL DE ENERGIAS ALTERNATIVAS - DGEA', NULL, 'A', '2021-09-06 11:57:01', '2021-09-06 11:57:01'),
(310, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 45, 'UNIDAD DE DESARROLLO DE INFRAE. Y ELECTRIF. RURAL - UDIE', 'es', 'AREA', '0', 0, 'UNIDAD DE DESARROLLO DE INFRAE. Y ELECTRIF. RURAL - UDIE', NULL, 'A', '2021-09-06 11:57:13', '2021-09-06 11:57:13'),
(311, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 46, 'DIRECCION GENERAL DE LITIO - DGL', 'es', 'AREA', '0', 0, 'DIRECCION GENERAL DE LITIO - DGL', NULL, 'A', '2021-09-06 11:57:58', '2021-09-06 11:57:58'),
(312, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 47, 'UNIDAD DE APLICACIONES Y NORMATIVAS DE LITIO - UANL', 'es', 'AREA', '0', 0, 'UNIDAD DE APLICACIONES Y NORMATIVAS DE LITIO - UANL', NULL, 'A', '2021-09-06 11:58:13', '2021-09-06 11:58:13'),
(313, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 48, 'DIRECCION GENERAL DE ENERGIA NUCLEAR - DGEN', 'es', 'AREA', '0', 0, 'DIRECCION GENERAL DE ENERGIA NUCLEAR - DGEN', NULL, 'A', '2021-09-06 11:58:28', '2021-09-06 11:58:28'),
(314, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 49, 'UNIDAD DE APLICACIONES Y NORMATIVAS NUCLEAR - UANN', 'es', 'AREA', '0', 0, 'UNIDAD DE APLICACIONES Y NORMATIVAS NUCLEAR - UANN', NULL, 'A', '2021-09-06 11:58:43', '2021-09-06 11:58:43'),
(315, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 50, 'PROGRAMA PNUMA', 'es', 'AREA', '0', 0, 'PROGRAMA PNUMA', NULL, 'A', '2021-09-06 11:58:58', '2021-09-06 11:58:58'),
(316, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 51, 'PROGRAMA AFD', 'es', 'AREA', '0', 0, 'PROGRAMA AFD', NULL, 'A', '2021-09-06 11:59:10', '2021-09-06 11:59:10'),
(317, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 52, 'OFICINAS TARIJA', 'es', 'AREA', '0', 0, 'OFICINAS TARIJA', NULL, 'A', '2021-09-06 11:59:20', '2021-09-06 11:59:20'),
(318, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 53, 'OFICINAS SANTA CRUZ', 'es', 'AREA', '0', 0, 'OFICINAS SANTA CRUZ', NULL, 'A', '2021-09-06 11:59:30', '2021-09-06 11:59:30'),
(319, '937f7af1-55a1-4ecd-a439-364613c75833', NULL, 180, 'CONSULTOR', 'es', 'CARGO', '0', 0, 'CONSULTOR', NULL, 'A', '2021-11-04 10:21:45', '2021-11-04 10:21:45'),
(320, '937f7af1-55a1-4ecd-a439-364613c75833', NULL, 54, 'CONSULTORA', 'es', 'AREA', '0', 0, 'CONSULTORA', NULL, 'A', '2021-11-04 10:22:00', '2021-11-04 10:22:00'),
(321, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8001, 'Core user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:06:47', '2022-02-18 12:06:47'),
(322, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8002, 'HelpDesk user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:09:07', '2022-02-18 12:09:07'),
(323, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8003, 'Pyv user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:09:34', '2022-02-18 12:09:34'),
(324, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8004, 'Hotel user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:11:01', '2022-02-18 12:11:01'),
(325, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8010, 'Sivir user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:11:01', '2022-02-18 12:11:01'),
(326, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8011, 'Customer user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:11:02', '2022-02-18 12:11:02'),
(327, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8012, 'Supplier user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:11:02', '2022-02-18 12:11:02'),
(328, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8013, 'Employee user', 'es', 'AREA', '0', 0, 'AREA', NULL, 'A', '2022-02-18 12:11:02', '2022-02-18 12:11:02'),
(329, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 8014, 'GERENCIA', 'es', 'AREA', '0', 0, 'GERENCIA', NULL, 'A', '2023-05-02 09:08:27', '2023-05-02 09:08:27'),
(330, '69abe0de-7812-41bd-9124-6a7238aee7d1', NULL, 181, 'ENCARGADO DE LOGISTICA', 'es', 'CARGO', '0', 0, 'ENCARGADO DE LOGISTICA', NULL, 'A', '2023-05-02 09:08:42', '2023-05-02 09:08:42');



--
-- Dumping data for table `core_pasajes_viaticos_currency`
--

INSERT INTO `core_pasajes_viaticos_currency` (`id`, `users_sid`, `currency`, `code`, `usd_dollar`, `global_countries_id`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Dolar', '$USD', 'Y', 233, 'A', '2021-07-11 13:21:50', '2022-12-15 03:21:46'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Bolivianos', 'Bs', 'N', 27, 'A', '2021-07-11 13:22:16', '2022-12-15 04:06:31'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Real', 'R$', 'N', 31, 'X', '2021-07-11 13:23:32', '2021-07-11 17:22:18'),
(4, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Peso Chileno', '$CLP', 'N', 44, 'X', '2021-08-20 11:17:34', '2021-11-16 08:08:02'),
(5, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'YUAN, RENMINBI', '¥ CNY', 'N', 45, 'A', '2022-09-29 23:47:48', '2022-09-30 00:12:04');





--
-- Dumping data for table `core_pasajes_viaticos_person`
--

INSERT INTO `core_pasajes_viaticos_person` (`id`, `users_sid`, `first_name`, `last_name`, `phone_number`, `intern`, `cargo_id`, `area_id`, `country_id`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'José', 'Aparicio', '76108443', '0', 76, 7, 27, 'A', '2021-06-24 16:09:51', '2021-10-22 09:39:28'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Franklin', 'Molina Ortiz', '0', '0', 1, 1, NULL, 'A', '2021-09-01 16:04:53', '2021-10-11 10:19:28'),
(38, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Mario Alberto', 'Sapiencia Arrieta', '0', '201 - 901', 40, 7, NULL, 'A', '2021-09-01 16:04:53', '2021-09-03 16:48:35'),
(53, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Mario Gonzalo', 'Aruquipa Lastario', '0', '209', 55, 7, NULL, 'A', '2021-09-01 16:04:53', '2021-09-03 16:27:51'),
(164, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Bill', 'Gates', '0', '666', 73, 7, NULL, 'A', '2021-10-28 11:58:10', '2021-10-29 15:21:20'),
(221, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'Nueva', 'Persona de Prueba', '741585210', NULL, 180, 54, NULL, 'A', '2023-04-12 16:09:34', '2023-04-12 16:09:34'),
(222, '69abe0de-7812-41bd-9124-6a7238aee7d1', 'MAYBER', 'APARICIO', '70000000', '0', 181, 8014, NULL, 'A', '2023-05-02 09:09:31', '2023-05-02 09:09:31');



--
-- Dumping data for table `core_supplier_vendors`
--

INSERT INTO `core_supplier_vendors` (`relative`, `users_sid`, `global_branch_office_id`, `country_id`, `code`, `full_name`, `nit`, `email`, `social_media`, `phones`, `address`, `references`, `photo`, `status`, `created_at`, `updated_at`) VALUES
('2a3e7ce5-0ecb-478c-9df0-6f73f5898058', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, NULL, 'INGCO BOLIVIA', '2312360019', NULL, NULL, NULL, NULL, NULL, NULL, 'A', '2023-06-09 07:20:21', '2023-06-09 07:20:21'),
('52695997-eef8-45b0-b2d0-21ce78e11e0f', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 31, '0006', 'Proveedor Brasil', '9876541254', NULL, NULL, NULL, NULL, NULL, '1674951350-5542437-9719f239-3c8d-42e6-b777-bf336e8e637d.png', 'A', '2023-01-28 20:15:50', '2023-01-28 20:15:50'),
('56bc1547-6955-44a3-8891-11adc5963971', '937f7af1-55a1-4ecd-a439-364613c75833', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, NULL, 'Amaszonas', '12312312312312', NULL, NULL, NULL, NULL, NULL, NULL, 'A', '2022-04-21 14:26:21', '2022-04-21 14:26:21'),
('5d03e5ca-9515-41ce-b799-e341e4b281fe', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, NULL, 'TRYDENT SERVICES', '4807414019', NULL, NULL, NULL, NULL, NULL, NULL, 'A', '2023-06-09 08:21:41', '2023-06-09 08:21:41'),
('8b1de46a-3e96-457b-b18d-dbfd51aebcd1', '937f7af1-55a1-4ecd-a439-364613c75833', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, 'BOA-01', 'Boliviana de Aviacion (BOA)', '154422029', 'ventasweb@boa.bo', 'https://fb.com/boa', '2 2166500', 'Av. Camacho, La Paz', NULL, '1646314625-3196550-06787d19-416f-448d-840a-6792c525cfaf.png', 'A', '2022-03-03 09:37:05', '2022-03-03 09:37:05'),
('95d29aff-582e-4c21-87ae-34edbf7ff498', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, NULL, 'Proveedor boliviano', '0', NULL, NULL, NULL, NULL, NULL, NULL, 'A', '2022-03-15 10:10:52', '2022-03-15 10:10:52'),
('e76efee0-8ec6-482c-8e33-82c4d4933e5d', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 27, '00005', 'Nuevo proveedor', '541236987', 'nuevo@nuevo.com', NULL, '+59174215863', 'Sin direccion conocida', 'Sin referencias conocidas', '1674945344-9828063-6c048919-bb57-4326-9b58-c34093e24ffb.png', 'A', '2023-01-28 18:35:44', '2023-01-28 18:35:44');

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_catalog_items`
--

CREATE TABLE `pasajes_viaticos_catalog_items` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `value` int NOT NULL,
  `label` varchar(250) NOT NULL,
  `lang` varchar(5) NOT NULL,
  `orden` int DEFAULT NULL,
  `catalog_code` varchar(50) NOT NULL,
  `catalog_code_dep` varchar(50) NOT NULL,
  `catalog_id_dep` int NOT NULL,
  `description` varchar(512) NOT NULL,
  `svg_image` varchar(150) DEFAULT NULL,
  `status` varchar(2) NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pasajes_viaticos_catalog_items`
--

INSERT INTO `pasajes_viaticos_catalog_items` (`id`, `users_sid`, `global_branch_office_id`, `value`, `label`, `lang`, `orden`, `catalog_code`, `catalog_code_dep`, `catalog_id_dep`, `description`, `svg_image`, `status`, `created_at`, `updated_at`) VALUES
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'PRIMERA CATEGORIA', 'es', NULL, 'CATEGORIAVIATICO', '0', 0, 'PRIMERA CATEGORIA', NULL, 'A', '2021-12-07 12:08:35', '2021-12-07 12:08:35'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'SEGUNDA CATEGORIA', 'es', NULL, 'CATEGORIAVIATICO', '0', 0, 'SEGUNDA CATEGORIA', NULL, 'A', '2021-12-07 12:08:45', '2021-12-07 12:08:45'),
(4, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'TERCERA CATEGORIA', 'es', NULL, 'CATEGORIAVIATICO', '0', 0, 'TERCERA CATEGORIA', NULL, 'A', '2021-12-07 12:08:54', '2021-12-07 12:18:09'),
(5, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'INTERNACIONAL', 'es', NULL, 'CATEGORIA', '0', 0, 'INTERNACIONAL', NULL, 'A', '2021-12-07 14:54:16', '2021-12-07 14:54:16'),
(6, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'INTERIOR', 'es', NULL, 'CATEGORIA', '0', 0, 'INTERIOR', NULL, 'A', '2021-12-07 14:54:35', '2021-12-07 14:54:35'),
(7, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'INTERDEPARTAMENTAL', 'es', NULL, 'CATEGORIA', 'CATEGORIA', 2, 'INTERDEPARTAMENTAL', NULL, 'A', '2021-12-07 14:55:45', '2021-12-07 14:58:11'),
(8, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'NORTE AMERICA, EUROPA, ASIA, AFRICA Y OCEANIA', 'es', NULL, 'CATEGORIA', 'CATEGORIA', 1, 'NORTE AMERICA, EUROPA, ASIA, AFRICA Y OCEANIA', NULL, 'A', '2021-12-07 14:57:57', '2021-12-07 14:57:57'),
(9, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'INTERIOR DEL DEPARTAMENTO', 'es', NULL, 'CATEGORIA', 'CATEGORIA', 2, 'INTERIOR DEL DEPARTAMENTO', NULL, 'A', '2021-12-07 14:58:32', '2021-12-07 14:58:32'),
(10, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'FRANJA DE FRONTERA', 'es', NULL, 'CATEGORIA', 'CATEGORIA', 2, 'FRANJA DE FRONTERA', NULL, 'A', '2021-12-07 14:58:46', '2021-12-07 14:58:46'),
(11, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'CENTRO, SUD AMERICA Y EL CARIBE', 'es', NULL, 'CATEGORIA', 'CATEGORIA', 1, 'CENTRO, SUD AMERICA Y EL CARIBE', NULL, 'A', '2021-12-07 14:59:24', '2021-12-07 14:59:24'),
(12, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'AEREO EMPRESA PRIVADA', 'es', NULL, 'MEDIO', '0', 0, 'AEREO EMPRESA PRIVADA', NULL, 'A', '2021-12-07 15:50:46', '2022-05-09 12:15:55'),
(13, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'TERRESTRE EMPRESA PRIVADA', 'es', NULL, 'MEDIO', '0', 0, 'TERRESTRE EMPRESA PRIVADA', NULL, 'A', '2021-12-07 15:51:15', '2021-12-07 15:51:15'),
(14, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'VEHICULO OFICIAL DEL ESTADO', 'es', NULL, 'MEDIO', '0', 0, 'VEHICULO OFICIAL DEL ESTADO', NULL, 'A', '2021-12-07 15:53:34', '2021-12-07 15:53:34'),
(15, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'COMITIVA OFICIAL CON EL PRESIDENTE DEL ESTADO PLURINACIONAL DE BOLIVIA', 'es', NULL, 'MEDIO', '0', 0, 'COMITIVA OFICIAL CON EL PRESIDENTE DEL ESTADO PLURINACIONAL DE BOLIVIA', NULL, 'A', '2021-12-07 15:57:22', '2021-12-07 15:57:22'),
(16, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'MINISTRO(A)', 'es', NULL, 'AUTORIDAD', '0', 0, 'MINISTRO(A)', NULL, 'A', '2021-12-09 10:48:13', '2022-06-10 11:25:59'),
(17, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'VICEMINISTROS(AS)', 'es', NULL, 'AUTORIDAD', '0', 0, 'VICEMINISTROS(AS)', NULL, 'A', '2021-12-09 10:48:25', '2021-12-09 10:48:25'),
(18, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'DIRECTORES GENERALES Y JEFES DE UNIDAD', 'es', NULL, 'AUTORIDAD', '0', 0, 'DIRECTORES GENERALES Y JEFES DE UNIDAD', NULL, 'A', '2021-12-09 10:48:40', '2021-12-09 10:48:40'),
(19, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'RESTO DEL PERSONAL DEPENDIENTE', 'es', NULL, 'AUTORIDAD', '0', 0, 'RESTO DEL PERSONAL DEPENDIENTE', NULL, 'A', '2021-12-09 10:48:58', '2021-12-09 10:48:58'),
(20, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'SOLO IDA', 'es', NULL, 'FORMA', '0', 0, 'SOLO IDA', NULL, 'A', '2021-12-22 15:31:52', '2021-12-22 15:31:52'),
(21, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'SOLO VUELTA', 'es', NULL, 'FORMA', '0', 0, 'SOLO VUELTA', NULL, 'A', '2021-12-22 15:31:59', '2021-12-22 15:31:59'),
(23, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'PASE A BORDO (BOARDING PASS)', 'es', NULL, 'PASEABORDO', '0', 0, 'PASE A BORDO', NULL, 'A', '2022-01-24 10:01:46', '2022-01-24 10:01:46'),
(24, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'TICKET DE TRANSPORTE TERRESTRE', 'es', NULL, 'PASEABORDO', '0', 0, 'TICKET DE TRANSPORTE TERRESTRE', NULL, 'A', '2022-01-24 10:02:03', '2022-01-24 10:02:03'),
(25, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'INTERMEDIO', 'es', NULL, 'FORMA', '0', 0, 'INTERMEDIO', NULL, 'A', '2022-05-03 11:50:55', '2022-05-03 11:50:55'),
(26, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'IDA Y VUELTA', 'es', NULL, 'FORMA', '0', 0, 'IDA Y VUELTA', NULL, 'A', '2022-05-03 11:51:03', '2022-05-03 11:51:03'),
(27, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'BILLETE AEREO DE IDA Y VUELTA', 'es', NULL, 'MEDIO', 'MEDIO', 1, 'BILLETE AEREO DE IDA Y VUELTA', NULL, 'A', '2022-05-04 13:51:33', '2022-05-04 13:55:04'),
(28, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'BILLETE AEREO DE SOLO IDA', 'es', NULL, 'MEDIO', 'MEDIO', 1, 'BILLETE AEREO DE SOLO IDA', NULL, 'A', '2022-05-04 13:51:49', '2022-05-04 13:55:11'),
(29, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'BILLETE AEREO DE SOLO VUELTA', 'es', NULL, 'MEDIO', 'MEDIO', 1, 'BILLETE AEREO DE SOLO VUELTA', NULL, 'A', '2022-05-04 13:52:03', '2022-05-04 13:55:16'),
(30, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'SIN BILLETE AEREO ASIGNADO', 'es', NULL, 'MEDIO', 'MEDIO', 1, 'SIN BILLETE AEREO ASIGNADO', NULL, 'A', '2022-05-04 13:52:13', '2022-05-04 13:55:24'),
(31, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'BILLETE DE BUS DE IDA Y VUELTA', 'es', NULL, 'MEDIO', 'MEDIO', 2, 'BILLETE DE BUS DE IDA Y VUELTA', NULL, 'A', '2022-05-04 13:53:11', '2022-05-04 13:55:54'),
(32, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'BILLETE DE BUS DE SOLO IDA', 'es', NULL, 'MEDIO', 'MEDIO', 2, 'BILLETE DE BUS DE SOLO IDA', NULL, 'A', '2022-05-04 13:53:21', '2022-05-04 13:55:59'),
(33, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'BILLETE DE BUS DE SOLO VUELTA', 'es', NULL, 'MEDIO', 'MEDIO', 2, 'BILLETE DE BUS DE SOLO VUELTA', NULL, 'A', '2022-05-04 13:54:01', '2022-05-04 13:56:03'),
(34, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 4, 'SIN BILLETE DE BUS ASIGNADO', 'es', NULL, 'MEDIO', 'MEDIO', 2, 'SIN BILLETE DE BUS ASIGNADO', NULL, 'A', '2022-05-04 13:54:39', '2022-05-04 13:56:09'),
(35, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'SIN BILLETE DE BUS O AEREO ASIGNADO', 'es', NULL, 'MEDIO', 'MEDIO', 3, 'SIN BILLETE DE BUS O AEREO ASIGNADO', NULL, 'A', '2022-05-04 13:56:53', '2022-05-04 13:56:53'),
(36, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'SIN BILLETE DE BUS O AEREO ASIGNADO', 'es', NULL, 'MEDIO', 'MEDIO', 4, 'SIN BILLETE DE BUS O AEREO ASIGNADO', NULL, 'A', '2022-05-04 13:57:39', '2022-05-04 13:57:39'),
(37, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 5, 'COMISION FINANCIADA POR ORGANISMOS EXTERNOS', 'es', NULL, 'MEDIO', '0', 0, 'COMISION FINANCIADA POR ORGANISMOS EXTERNOS', NULL, 'A', '2022-05-09 12:48:06', '2022-05-09 12:52:26');

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_configuration`
--

CREATE TABLE `pasajes_viaticos_configuration` (
  `relative` varchar(50) NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch office on core',
  `administrative_affairs` varchar(50) NOT NULL COMMENT 'Related to users sid',
  `pyv_in_charge` varchar(50) NOT NULL COMMENT 'Related to users sid',
  `before_national_trip` smallint NOT NULL DEFAULT '2',
  `before_international_trip` smallint NOT NULL DEFAULT '4',
  `admministrative_resolution` text,
  `days_after_trip` smallint NOT NULL DEFAULT '8',
  `noon_time` time NOT NULL COMMENT 'The noon time',
  `decimals` smallint NOT NULL,
  `currency_id` int NOT NULL DEFAULT '1' COMMENT 'Related to currency table',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pasajes_viaticos_configuration`
--

INSERT INTO `pasajes_viaticos_configuration` (`relative`, `users_sid`, `global_branch_office_id`, `administrative_affairs`, `pyv_in_charge`, `before_national_trip`, `before_international_trip`, `admministrative_resolution`, `days_after_trip`, `noon_time`, `decimals`, `currency_id`, `status`, `created_at`, `updated_at`) VALUES
('69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', '7ce7a7a9-5ddf-4727-8d0b-1ec2dc2cf8cb', 'eeef3815-11de-4a4a-a6ac-8619b4e9b4ca', 2, 4, 'Que la constitución política del estado aprobada mediante reféndum de fecha 25 de enero de 2009, en el artículo 232 establece que la administración pública se rige por los principios de legitimidad, legalidad, imparcialidad, publicidad, compromiso e interés social, ética, transparencia, igualdad, competencia, eficiencia, calidad, calidez, honestidad, responsabilidad y resultados. Además de disposiciones legales al caso, y:\nQue el inciso c) del artículo de la Ley 1178 de fecha 20 de julio de 1990, de administración y control gubernamentales, tiene por objeto, lograr que todo servidor público, sin distinción de jerarquía, asuma plena responsabilidad por sus actos. El artículo 28, determina que todo servidor público responderá de los resultados emergentes del desempeño de las funciones, deberes y atribuciones asignados a su cargo.\nQue el Decreto Supremo 1788 del 7 de noviembre de 2013, establece la escala de viáticos, categorías y pasajes para los servidores públicos, personal eventual y consultores individuales de línea del servidor público que viajan en comisión oficial al exterior e interior del país, además establece aspectos operativos relacionados a gastos realizados en el exterior como en el interior del Estado, emergentes de viajes oficiales.\nQue el Decreto Supremo 27327 del 31 de enero de 2004, refiere en su parte considerativa que es necesario establecer un marco de austeridad racionalizado al gasto de las entidades públicas.\nQue el artículo 3, parágrafo II, del Decreto Supremo 4393, del 13 de noviembre de 2020, modifica el capítulo X del Título III del Decreto Supremo 29894, del 7 de febrero de 2009, Organización del Órgano Ejecutivo: cambiando el nomen iuris del Ministerio de Hidrocarburos por MINISTERIO DE HIDROCARBUROS Y ENERGÍAS.\nQue el reglamento interno de pasajes y viáticos del Ministerio de Hidrocarburos y Energías, aprobado mediante Resolución Ministerial 118-19 del 20 de septiembre de 2019, se constituye en un instrumento operativo y complementario de control interno, cuyo objetivo consiste en normal, controlar y hacer eficiente la solicitud, asigación y descargo de los recursos desembolsados para el pago de viáticos, pasajes y gastos de representación a servidores públicos del Ministerio de Hidrocarburos y Energías que realizan viajes al interior y/o exterior del país en comisión oficial.\nQue el reglamento interno de pasajes y viáticos del Ministerio de Hidrocarburos y Energías, en el artículo 23 en sus dos parágrafos establece que, para proceder al pago de viáticos cuando la estadía programada se extienda por más días, el servidor público o personal dependiente del Ministerio de Hidrocarburos y Energías deberá presentar vía el Sistema de Control de Pasajes y Viáticos a la Dirección General de Asuntos Administrativos, el informe administrativo de descargo de pasajes y viáticos, el mismo que debe considerar las fechas y horarios del pase a bordo (aéreo) y otros (terrestre); aprobado por su inmediato superior, solicitando expresamente la cancelación de los días de viático adicionales.\nEn caso de que la extensión del viaje sea en fin de semana o feriado, se requerirá Resolución Administrativa o Ministerial (viajes al exterior) para la tercera categoría, según corresponda; o Resolución Suprema en caso de viajes internacionales de la primera y segunda categoría.', 8, '13:30:00', 2, 2, 'A', '2022-04-11 08:42:59', '2022-11-18 10:10:55');

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_escala`
--

CREATE TABLE `pasajes_viaticos_escala` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `type_id` int NOT NULL COMMENT 'related to catalogs items = CATEGORIA',
  `subtype_id` int NOT NULL COMMENT 'related to catalogs items = SUBCATEGORIA',
  `categoria_viatico_id` int NOT NULL COMMENT 'related to catalogs items  = CATEGORIAVIATICO',
  `amount` decimal(10,5) NOT NULL,
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `status` enum('A','X') NOT NULL,
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pasajes_viaticos_escala`
--

INSERT INTO `pasajes_viaticos_escala` (`id`, `users_sid`, `global_branch_office_id`, `type_id`, `subtype_id`, `categoria_viatico_id`, `amount`, `currency_id`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 1, 1, '360.00000', 1, 'A', '2021-12-13 10:26:40', '2021-12-13 10:26:40'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 1, 2, '300.00000', 1, 'A', '2021-12-13 10:26:59', '2021-12-13 10:26:59'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 1, 3, '276.00000', 1, 'A', '2021-12-13 10:27:14', '2021-12-13 10:27:14'),
(4, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 2, 1, '300.00000', 1, 'A', '2021-12-13 10:27:28', '2021-12-13 10:27:28'),
(5, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 2, 2, '240.00000', 1, 'A', '2021-12-13 10:27:41', '2021-12-13 10:27:41'),
(6, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 2, 3, '207.00000', 1, 'A', '2021-12-13 10:27:52', '2021-12-13 10:27:52'),
(7, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 1, 1, '553.00000', 2, 'A', '2021-12-13 11:24:06', '2021-12-13 11:24:06'),
(8, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 1, 2, '465.00000', 2, 'A', '2021-12-13 11:24:21', '2021-12-13 11:24:21'),
(9, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 1, 3, '371.00000', 2, 'A', '2021-12-13 11:24:44', '2021-12-13 11:24:44'),
(10, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 2, 1, '332.00000', 2, 'A', '2021-12-13 11:25:11', '2021-12-13 11:25:11'),
(11, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 2, 2, '277.00000', 2, 'A', '2021-12-13 11:25:24', '2021-12-13 11:25:24'),
(12, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 2, 3, '222.00000', 2, 'A', '2021-12-13 11:25:36', '2021-12-13 11:25:36'),
(13, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 3, 1, '583.00000', 2, 'A', '2021-12-13 11:25:56', '2021-12-13 11:25:56'),
(14, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 3, 2, '491.00000', 2, 'A', '2021-12-13 11:26:10', '2021-12-13 11:26:10'),
(15, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 3, 3, '391.00000', 2, 'A', '2021-12-13 11:26:34', '2021-12-13 11:54:43');

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_fly_ticket_control`
--

CREATE TABLE `pasajes_viaticos_fly_ticket_control` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `supplier_vendors_id` varchar(50) NOT NULL COMMENT 'Related to supplier vendor table',
  `issue_date` date NOT NULL,
  `electronic_ticket` varchar(50) NOT NULL,
  `traveler_id` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'Related to users sid',
  `traveler_document` varchar(35) NOT NULL,
  `origin` varchar(200) NOT NULL,
  `destiny` varchar(200) NOT NULL,
  `way_id` int NOT NULL COMMENT 'related to catalogs items = FORMA',
  `itinerary_datetime` datetime NOT NULL,
  `itinerary_datetime_arrive` datetime NOT NULL,
  `total` decimal(10,5) NOT NULL,
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `stage` enum('R','C','A','RU') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'R=Reserved, C=Confirmed, A=Cancelled, RU=ReUsed',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_fly_ticket_related_request`
--

CREATE TABLE `pasajes_viaticos_fly_ticket_related_request` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `request_id` int DEFAULT NULL COMMENT 'Related to request id',
  `provisional` varchar(50) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci DEFAULT NULL COMMENT 'The provisional UUID',
  `fly_ticket_control_id` int NOT NULL COMMENT 'Related to pasajes_viaticos_fly_ticket_control',
  `way_id` int NOT NULL COMMENT 'Related to catalogs items = ''FORMA''',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_itinerary`
--

CREATE TABLE `pasajes_viaticos_itinerary` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `request_id` int NOT NULL COMMENT 'Related to request table',
  `provisional` varchar(50) DEFAULT NULL COMMENT 'a uuid data',
  `where_from` varchar(250) NOT NULL,
  `itinerary_datetime` datetime NOT NULL,
  `transportway_id` int NOT NULL COMMENT 'related to catalogs items  = MEDIO',
  `to_where` varchar(250) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_message_notification`
--

CREATE TABLE `pasajes_viaticos_message_notification` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'Related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'Related to branch table',
  `follow_message` varchar(50) NOT NULL COMMENT 'This is a UUID for the same message',
  `request_id` int DEFAULT NULL COMMENT 'Related to the request id, but could be null',
  `receivers` text NOT NULL COMMENT 'Many users sid separated by |',
  `reason` varchar(200) NOT NULL COMMENT 'The reason title',
  `complete_message` longtext NOT NULL,
  `attachments` text,
  `actions` enum('A','R','RS','D','J','AT') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'J' COMMENT 'J=Just a request, A=Autorize or proceed, R=Rejected, RS=Resend, D=Derived, AT=Attended',
  `readed` enum('Y','N') NOT NULL DEFAULT 'N',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_relation`
--

CREATE TABLE `pasajes_viaticos_relation` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `cargo_id` int NOT NULL COMMENT 'related to catalogs items = CARGO',
  `inmediato_superior_id` int NOT NULL COMMENT 'related to catalogs items = SUPERIOR',
  `categoria_viatico_id` int NOT NULL COMMENT 'related to catalogs items = CATEGORIAVIATICO	',
  `autoridad_id` int NOT NULL COMMENT 'related to catalogs items = AUTORIDAD',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pasajes_viaticos_relation`
--

INSERT INTO `pasajes_viaticos_relation` (`id`, `users_sid`, `global_branch_office_id`, `cargo_id`, `inmediato_superior_id`, `categoria_viatico_id`, `autoridad_id`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 76, 40, 3, 4, 'A', '2021-12-09 11:59:08', '2021-12-09 11:59:08'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 1, 1, 1, 'A', '2021-12-09 12:05:49', '2021-12-09 12:05:49'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 73, 40, 3, 4, 'A', '2021-12-09 12:21:21', '2021-12-09 12:22:55'),
(4, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 180, 40, 3, 4, 'X', '2021-12-16 12:33:20', '2022-03-03 09:02:53'),
(5, '7ce7a7a9-5ddf-4727-8d0b-1ec2dc2cf8cb', '69abe0de-7812-41bd-9124-6a7238aee7d1', 40, 1, 3, 3, 'A', '2022-03-23 14:55:30', '2022-03-23 14:55:30'),
(6, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 55, 51, 3, 4, 'A', '2022-04-12 09:29:42', '2022-04-12 09:29:42'),
(7, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 34, 24, 3, 4, 'A', '2022-04-12 09:30:55', '2022-04-12 09:30:55'),
(8, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 35, 24, 3, 4, 'A', '2022-04-12 09:35:07', '2022-04-12 09:35:07'),
(9, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 36, 24, 3, 4, 'A', '2022-04-12 09:35:27', '2022-04-12 09:35:27'),
(10, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 37, 24, 3, 4, 'A', '2022-04-12 09:35:39', '2022-04-12 09:35:39'),
(11, 'eeef3815-11de-4a4a-a6ac-8619b4e9b4ca', '69abe0de-7812-41bd-9124-6a7238aee7d1', 81, 77, 3, 3, 'A', '2022-04-12 15:22:42', '2022-04-12 15:22:42'),
(12, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 175, 1, 2, 2, 'A', '2022-04-13 08:49:52', '2022-04-13 08:49:52');

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_request_administrative_resolution`
--

CREATE TABLE `pasajes_viaticos_request_administrative_resolution` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `request_id` int NOT NULL COMMENT 'Related to pasajes_viaticos_request table',
  `mem` varchar(45) NOT NULL,
  `person_id` int NOT NULL COMMENT 'Related to person table',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_request_approve_reject`
--

CREATE TABLE `pasajes_viaticos_request_approve_reject` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `request_id` int NOT NULL COMMENT 'Related to pasajes_viaticos_request table',
  `approve_reject_date_time` datetime NOT NULL,
  `stage` enum('A','R') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pasajes_viaticos_request_approve_reject`
--

INSERT INTO `pasajes_viaticos_request_approve_reject` (`id`, `users_sid`, `global_branch_office_id`, `request_id`, `approve_reject_date_time`, `stage`, `status`, `created_at`, `updated_at`) VALUES
(1, '7ce7a7a9-5ddf-4727-8d0b-1ec2dc2cf8cb', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '2022-11-18 10:15:42', 'A', 'A', '2022-11-18 10:15:42', '2022-11-18 10:15:42'),
(2, '7ce7a7a9-5ddf-4727-8d0b-1ec2dc2cf8cb', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, '2022-11-21 16:37:33', 'A', 'A', '2022-11-21 16:37:33', '2022-11-21 16:37:33'),
(3, '7ce7a7a9-5ddf-4727-8d0b-1ec2dc2cf8cb', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, '2022-12-15 11:51:58', 'A', 'A', '2022-12-15 11:51:58', '2022-12-15 11:51:58');

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_request_attachments`
--

CREATE TABLE `pasajes_viaticos_request_attachments` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `request_id` int NOT NULL COMMENT 'Related to pasajes_viaticos_request table',
  `mem` varchar(45) NOT NULL,
  `mem_date_time` datetime NOT NULL,
  `attachments` text,
  `doctype` enum('A1','A2','A3','A4','A5','A6','A7') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A1',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pasajes_viaticos_request_attachments`
--

INSERT INTO `pasajes_viaticos_request_attachments` (`id`, `users_sid`, `global_branch_office_id`, `request_id`, `mem`, `mem_date_time`, `attachments`, `doctype`, `status`, `created_at`, `updated_at`) VALUES
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'M-OEP1', '2022-11-18 00:00:00', 'http://127.0.0.1:8003/storage/attachments/2022-11-18 10:18:17e9bea6e1-827e-4214-a68d-0c79a86a51dc.pdf', 'A1', 'A', '2022-11-18 10:18:17', '2022-11-18 10:18:17'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'M-OEP1', '2022-11-18 00:00:00', 'http://127.0.0.1:8003/storage/attachments/2022-11-18 10:18:320e86fceb-7803-4538-a336-f7b8dbe879e8.pdf', 'A2', 'A', '2022-11-18 10:18:32', '2022-11-18 10:18:32'),
(4, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'M-OEP1', '2022-11-18 00:00:00', 'http://127.0.0.1:8003/storage/attachments/2022-11-18 10:20:37f1c72650-9f04-4546-bc67-5ae2d8b5511e.pdf', 'A4', 'A', '2022-11-18 10:20:37', '2022-11-18 10:20:37'),
(5, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'M-OEP2', '2022-11-21 00:00:00', 'http://127.0.0.1:8003/storage/attachments/2022-11-21 16:38:0567ec18ef-2cca-41f1-9dc8-8121d9f38e24.pdf', 'A1', 'A', '2022-11-21 16:38:05', '2022-11-21 16:38:05'),
(6, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'M-OEP2', '2022-11-21 00:00:00', 'http://127.0.0.1:8003/storage/attachments/2022-11-21 16:38:29f29760b0-123f-4192-8045-1fa0e10ab27c.pdf', 'A2', 'A', '2022-11-21 16:38:29', '2022-11-21 16:38:29'),
(7, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, 'M-OEP2', '2022-11-21 00:00:00', 'http://127.0.0.1:8003/storage/attachments/2022-11-21 16:41:18440aff0c-6e79-47f1-acd2-6a0b43d31844.pdf', 'A4', 'A', '2022-11-21 16:41:18', '2022-11-21 16:41:18'),
(8, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'M-OEP1', '2022-11-21 00:00:00', 'http://127.0.0.1:8003/storage/attachments/2022-11-21 16:45:5011537189-e6ad-4f10-a135-b2bf5babdf12.pdf', 'A7', 'A', '2022-11-21 16:45:50', '2022-11-21 16:45:50'),
(13, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'M-UAP3', '2022-12-15 00:00:00', 'http://127.0.0.1:8003/storage/attachments/2022-12-15 11:57:0149a7f37e-c7f6-4c23-b738-01729f040c51.pdf', 'A1', 'A', '2022-12-15 11:57:01', '2022-12-15 11:57:01'),
(14, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, 'M-UAP3', '2022-12-15 00:00:00', 'http://127.0.0.1:8003/storage/attachments/2022-12-15 11:57:0717244a02-c04c-4bd6-8960-79b17a614899.pdf', 'A2', 'A', '2022-12-15 11:57:07', '2022-12-15 11:57:07');

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_request_calculation`
--

CREATE TABLE `pasajes_viaticos_request_calculation` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `request_id` int NOT NULL COMMENT 'Related to request table',
  `overnight` decimal(10,5) NOT NULL,
  `representation_expenses` enum('Y','N') NOT NULL DEFAULT 'N',
  `days_before` decimal(10,2) NOT NULL,
  `trip_days` decimal(10,2) NOT NULL,
  `amount_designed` decimal(10,5) NOT NULL,
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_request_final_inform`
--

CREATE TABLE `pasajes_viaticos_request_final_inform` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `request_id` int DEFAULT NULL COMMENT 'Related to request table',
  `cite` varchar(50) NOT NULL COMMENT 'Numero de hoja de ruta',
  `addressed_to_id` int NOT NULL COMMENT 'Related to catalogs items = ''CARGO''',
  `inform` longtext NOT NULL COMMENT 'Long text for the inform',
  `fullfilled` enum('Y','N') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'Y' COMMENT 'For N = Required reliquidation, for Y = Nothing happend',
  `conclusion` text NOT NULL,
  `recomendation` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
  `attachments` text COMMENT 'Files separated by commas',
  `stage` enum('P','A','R') NOT NULL DEFAULT 'P',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pasajes_viaticos_request_final_inform`
--

INSERT INTO `pasajes_viaticos_request_final_inform` (`id`, `users_sid`, `global_branch_office_id`, `request_id`, `cite`, `addressed_to_id`, `inform`, `fullfilled`, `conclusion`, `recomendation`, `attachments`, `stage`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'INF-1', 40, '<p>asjkdjhags jdhgas dkjhasg dajshgd kasjdhg kasdg asjdhgas</p><p>4asjdhg askjdhgas kdjhas gdkajs4akjdsasg djkhas</p><p>&nbsp;</p><p>akjshdg asjkdhg askjdhg as</p>', 'Y', 'askjdhg askjdhg askjdhg askdjghas kdjh', 'asdkjhg askjdhg askdjhasg dkjashg dkhas', NULL, 'A', 'A', '2022-11-21 16:43:26', '2022-11-21 16:45:41');

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_request_final_inform_cite`
--

CREATE TABLE `pasajes_viaticos_request_final_inform_cite` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `request_id` int DEFAULT NULL COMMENT 'Related to request table',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pasajes_viaticos_request_final_inform_cite`
--

INSERT INTO `pasajes_viaticos_request_final_inform_cite` (`id`, `users_sid`, `global_branch_office_id`, `request_id`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 'A', '2022-11-21 16:43:26', '2022-11-21 16:43:26');

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_request_formulario_110`
--

CREATE TABLE `pasajes_viaticos_request_formulario_110` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `request_id` int DEFAULT NULL COMMENT 'Related to request table',
  `presentation_date` date NOT NULL COMMENT 'Fecha de presentacion',
  `ammount` decimal(10,4) NOT NULL COMMENT 'Puede ser 0',
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `attachments` text,
  `stage` enum('P','A','R') NOT NULL DEFAULT 'P',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pasajes_viaticos_request_formulario_110`
--

INSERT INTO `pasajes_viaticos_request_formulario_110` (`id`, `users_sid`, `global_branch_office_id`, `request_id`, `presentation_date`, `ammount`, `currency_id`, `attachments`, `stage`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '2022-11-21', '900.0000', 2, NULL, 'A', 'A', '2022-11-21 16:44:39', '2022-11-21 16:45:41');

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_request_itinerary`
--

CREATE TABLE `pasajes_viaticos_request_itinerary` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `request_id` int DEFAULT NULL COMMENT 'Related to request table',
  `provisional` varchar(50) DEFAULT NULL COMMENT 'a uuid data',
  `origin` varchar(250) NOT NULL,
  `itinerary_datetime` datetime NOT NULL,
  `itinerary_datetime_arrive` datetime DEFAULT NULL,
  `way_id` int NOT NULL COMMENT 'related to catalogs items  = FORMA',
  `transportway_id` int NOT NULL COMMENT 'related to catalogs items  = MEDIO',
  `destiny` varchar(250) NOT NULL,
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pasajes_viaticos_request_itinerary`
--

INSERT INTO `pasajes_viaticos_request_itinerary` (`id`, `users_sid`, `global_branch_office_id`, `request_id`, `provisional`, `origin`, `itinerary_datetime`, `itinerary_datetime_arrive`, `way_id`, `transportway_id`, `destiny`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, NULL, 'La Paz', '2022-11-23 16:00:00', '2022-11-23 17:30:00', 1, 1, 'Cochabamba', 'A', '2022-11-18 10:07:49', '2022-11-18 10:08:44'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, NULL, 'Cochabamba', '2022-11-25 10:00:00', '2022-11-25 11:30:00', 2, 1, 'La Paz', 'A', '2022-11-18 10:08:21', '2022-11-18 10:08:44'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, NULL, 'La Paz', '2022-11-23 09:00:00', '2022-11-23 10:30:00', 1, 1, 'Cochabamba', 'A', '2022-11-21 16:35:27', '2022-11-21 16:36:36'),
(4, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, NULL, 'Cochabamba', '2022-11-25 14:00:00', '2022-11-25 15:00:00', 2, 1, 'La Paz', 'A', '2022-11-21 16:35:59', '2022-11-21 16:36:36'),
(5, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, NULL, 'Cobija', '2022-12-19 09:00:00', '2022-12-19 10:30:00', 1, 1, 'Santa Cruz de la Sierra', 'A', '2022-12-15 11:48:49', '2022-12-15 11:49:25'),
(6, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 3, NULL, 'Santa Cruz de la Sierra', '2022-12-22 12:00:00', '2022-12-22 13:30:00', 2, 1, 'Cobija', 'A', '2022-12-15 11:49:20', '2022-12-15 11:49:25');

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_request_reliquidation`
--

CREATE TABLE `pasajes_viaticos_request_reliquidation` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `request_id` int NOT NULL COMMENT 'Related to pasajes_viaticos_request table',
  `departure_date_time` datetime NOT NULL,
  `arrival_date_time` datetime NOT NULL,
  `reason` longtext,
  `stage` enum('P','A','R') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_request_reliquidation_itinerary`
--

CREATE TABLE `pasajes_viaticos_request_reliquidation_itinerary` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `request_id` int DEFAULT NULL COMMENT 'Related to request table',
  `itinerary_id` int DEFAULT NULL COMMENT 'related to pasajes_viaticos_request_itinerary table',
  `origin` varchar(250) DEFAULT NULL,
  `itinerary_datetime` datetime NOT NULL,
  `itinerary_datetime_arrive` datetime NOT NULL,
  `way_id` int DEFAULT NULL COMMENT 'related to catalogs items = FORMA	',
  `transportway_id` int DEFAULT NULL COMMENT 'related to catalogs items = MEDIO	',
  `destiny` varchar(250) DEFAULT NULL,
  `stage` enum('P','A','R') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_request_reliquidation_itinerary_costs`
--

CREATE TABLE `pasajes_viaticos_request_reliquidation_itinerary_costs` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `request_id` int DEFAULT NULL COMMENT 'Related to request table',
  `cost` decimal(10,5) NOT NULL,
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `stage` enum('P','A','R') CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL DEFAULT 'A',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_request_weekend_holliday`
--

CREATE TABLE `pasajes_viaticos_request_weekend_holliday` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `request_id` int NOT NULL COMMENT 'Related to pasajes_viaticos_request table',
  `weekends_holidays` text CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'All dates separated by commas',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pasajes_viaticos_request_weekend_holliday`
--

INSERT INTO `pasajes_viaticos_request_weekend_holliday` (`id`, `users_sid`, `global_branch_office_id`, `request_id`, `weekends_holidays`, `status`, `created_at`, `updated_at`) VALUES
(1, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '2022-06-04 00:00:00', 'A', '2022-06-02 12:29:10', '2022-06-02 12:29:10'),
(2, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, '2022-06-05 00:00:00', 'A', '2022-06-02 12:29:10', '2022-06-02 12:29:10'),
(3, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, '2022-06-11 00:00:00', 'A', '2022-06-07 09:20:06', '2022-06-07 09:20:06'),
(4, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 2, '2022-06-12 00:00:00', 'A', '2022-06-07 09:20:06', '2022-06-07 09:20:06');

-- --------------------------------------------------------

--
-- Table structure for table `pasajes_viaticos_resume`
--

CREATE TABLE `pasajes_viaticos_resume` (
  `id` int NOT NULL,
  `users_sid` varchar(50) NOT NULL COMMENT 'related to users table',
  `global_branch_office_id` varchar(50) NOT NULL COMMENT 'related to branch office',
  `person_id` int NOT NULL COMMENT 'Related to person table',
  `request_id` int NOT NULL COMMENT 'Related to request table',
  `days_before` decimal(10,2) NOT NULL,
  `trip_days` decimal(10,2) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `currency_id` int NOT NULL COMMENT 'Related to currency table',
  `stage` enum('A','R') NOT NULL DEFAULT 'A',
  `status` enum('A','X') NOT NULL DEFAULT 'A',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pasajes_viaticos_resume`
--

INSERT INTO `pasajes_viaticos_resume` (`id`, `users_sid`, `global_branch_office_id`, `person_id`, `request_id`, `days_before`, `trip_days`, `amount`, `currency_id`, `stage`, `status`, `created_at`, `updated_at`) VALUES
(7, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 1, '5.00', '2.00', '742.00', 2, 'A', 'A', '2022-11-18 10:08:44', '2022-11-18 10:08:44'),
(8, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 2, '2.00', '2.50', '927.50', 2, 'A', 'A', '2022-11-21 16:36:36', '2022-11-21 16:36:36'),
(9, '69abe0de-7812-41bd-9124-6a7238aee7d1', '69abe0de-7812-41bd-9124-6a7238aee7d1', 1, 3, '4.00', '3.00', '1113.00', 2, 'A', 'A', '2022-12-15 11:49:25', '2022-12-15 11:49:25');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `pasajes_viaticos_catalog_items`
--
ALTER TABLE `pasajes_viaticos_catalog_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pasajes_viaticos_catalog_items_value_IDX` (`value`) USING BTREE,
  ADD KEY `fk_users_sid_catalogs_items` (`users_sid`);

--
-- Indexes for table `pasajes_viaticos_configuration`
--
ALTER TABLE `pasajes_viaticos_configuration`
  ADD PRIMARY KEY (`relative`),
  ADD UNIQUE KEY `configuration.relative` (`relative`),
  ADD KEY `fk_users_configuration` (`users_sid`),
  ADD KEY `fk_administrative_affairs_configuration` (`administrative_affairs`),
  ADD KEY `fk_pyv_in_charge_configuration` (`pyv_in_charge`),
  ADD KEY `fk_currency_id_configuration` (`currency_id`);

--
-- Indexes for table `pasajes_viaticos_escala`
--
ALTER TABLE `pasajes_viaticos_escala`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_escala` (`users_sid`),
  ADD KEY `fk_type_id_escala` (`type_id`),
  ADD KEY `fk_subtype_id_escala` (`subtype_id`),
  ADD KEY `fk_categoria_viatico_id_escala` (`categoria_viatico_id`),
  ADD KEY `fk_currency_id_escala` (`currency_id`);

--
-- Indexes for table `pasajes_viaticos_fly_ticket_control`
--
ALTER TABLE `pasajes_viaticos_fly_ticket_control`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_fly_ticket_control` (`users_sid`),
  ADD KEY `fk_supplier_vendors_id_fly_ticket_control` (`supplier_vendors_id`),
  ADD KEY `fk_traveler_id_fly_ticket_control` (`traveler_id`),
  ADD KEY `fk_way_id_fly_ticket_control` (`way_id`),
  ADD KEY `fk_currency_id_fly_ticket_control` (`currency_id`);

--
-- Indexes for table `pasajes_viaticos_fly_ticket_related_request`
--
ALTER TABLE `pasajes_viaticos_fly_ticket_related_request`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_fly_ticket_related_request` (`users_sid`),
  ADD KEY `fk_request_id_fly_ticket_related_request` (`request_id`),
  ADD KEY `fk_fly_ticket_control_id_fly_ticket_related_request` (`fly_ticket_control_id`),
  ADD KEY `fk_way_id_fly_ticket_related_request` (`way_id`);

--
-- Indexes for table `pasajes_viaticos_itinerary`
--
ALTER TABLE `pasajes_viaticos_itinerary`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_itinerary` (`users_sid`),
  ADD KEY `fk_request_id_itinerary` (`request_id`),
  ADD KEY `fk_transportway_id_itinerary` (`transportway_id`),
  ADD KEY `id` (`id`);

--
-- Indexes for table `pasajes_viaticos_message_notification`
--
ALTER TABLE `pasajes_viaticos_message_notification`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_message_notification` (`users_sid`),
  ADD KEY `fk_request_id_message_notification` (`request_id`);

--
-- Indexes for table `pasajes_viaticos_relation`
--
ALTER TABLE `pasajes_viaticos_relation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_relation` (`users_sid`),
  ADD KEY `fk_cargo_id_relation` (`cargo_id`),
  ADD KEY `fk_inmediato_superior_id_relation` (`inmediato_superior_id`),
  ADD KEY `fk_categoria_viatico_id_relation` (`categoria_viatico_id`),
  ADD KEY `fk_autoridad_id_relation` (`autoridad_id`);

--
-- Indexes for table `pasajes_viaticos_request_administrative_resolution`
--
ALTER TABLE `pasajes_viaticos_request_administrative_resolution`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_request_administrative_resolution` (`users_sid`),
  ADD KEY `fk_request_id_request_administrative_resolution` (`request_id`),
  ADD KEY `fk_person_id_request_administrative_resolution` (`person_id`);

--
-- Indexes for table `pasajes_viaticos_request_approve_reject`
--
ALTER TABLE `pasajes_viaticos_request_approve_reject`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_request_approve_reject` (`users_sid`),
  ADD KEY `fk_request_id_request_approve_reject` (`request_id`);

--
-- Indexes for table `pasajes_viaticos_request_attachments`
--
ALTER TABLE `pasajes_viaticos_request_attachments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_request_attachments` (`users_sid`),
  ADD KEY `fk_request_id_request_attachments` (`request_id`);

--
-- Indexes for table `pasajes_viaticos_request_calculation`
--
ALTER TABLE `pasajes_viaticos_request_calculation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_request_calculation` (`users_sid`),
  ADD KEY `fk_request_id_request_calculation` (`request_id`),
  ADD KEY `fk_currency_id_request_calculation` (`currency_id`);

--
-- Indexes for table `pasajes_viaticos_request_final_inform`
--
ALTER TABLE `pasajes_viaticos_request_final_inform`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_request_final_inform` (`users_sid`),
  ADD KEY `fk_request_id_request_final_inform` (`request_id`),
  ADD KEY `fk_addressed_to_id_request_final_inform` (`addressed_to_id`);

--
-- Indexes for table `pasajes_viaticos_request_final_inform_cite`
--
ALTER TABLE `pasajes_viaticos_request_final_inform_cite`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_request_final_inform_cite` (`users_sid`),
  ADD KEY `fk_request_id_request_final_inform_cite` (`request_id`);

--
-- Indexes for table `pasajes_viaticos_request_formulario_110`
--
ALTER TABLE `pasajes_viaticos_request_formulario_110`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_request_formulario_110` (`users_sid`),
  ADD KEY `fk_request_id_request_formulario_110` (`request_id`),
  ADD KEY `fk_currency_id_request_formulario_110` (`currency_id`);

--
-- Indexes for table `pasajes_viaticos_request_itinerary`
--
ALTER TABLE `pasajes_viaticos_request_itinerary`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_request_itinerary` (`users_sid`),
  ADD KEY `fk_request_id_request_itinerary` (`request_id`),
  ADD KEY `fk_way_id_request_itinerary` (`way_id`),
  ADD KEY `fk_transportway_id_request_itinerary` (`transportway_id`);

--
-- Indexes for table `pasajes_viaticos_request_reliquidation`
--
ALTER TABLE `pasajes_viaticos_request_reliquidation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_request_reliquidation` (`users_sid`),
  ADD KEY `fk_request_id_request_reliquidation` (`request_id`);

--
-- Indexes for table `pasajes_viaticos_request_reliquidation_itinerary`
--
ALTER TABLE `pasajes_viaticos_request_reliquidation_itinerary`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_request_reliquidation_itinerary` (`users_sid`),
  ADD KEY `fk_request_id_request_reliquidation_itinerary` (`request_id`),
  ADD KEY `fk_itinerary_id_request_reliquidation_itinerary` (`itinerary_id`),
  ADD KEY `fk_way_id_request_reliquidation_itinerary` (`way_id`),
  ADD KEY `fk_transportway_id_request_reliquidation_itinerary` (`transportway_id`);

--
-- Indexes for table `pasajes_viaticos_request_reliquidation_itinerary_costs`
--
ALTER TABLE `pasajes_viaticos_request_reliquidation_itinerary_costs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_request_reliquidation_itinerary_costs` (`users_sid`),
  ADD KEY `fk_request_id_request_reliquidation_itinerary_costs` (`request_id`),
  ADD KEY `fk_currency_id_request_reliquidation_itinerary_costs` (`currency_id`);

--
-- Indexes for table `pasajes_viaticos_request_weekend_holliday`
--
ALTER TABLE `pasajes_viaticos_request_weekend_holliday`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_request_weekend_holliday` (`users_sid`),
  ADD KEY `fk_request_id_request_weekend_holliday` (`request_id`);

--
-- Indexes for table `pasajes_viaticos_resume`
--
ALTER TABLE `pasajes_viaticos_resume`
  ADD PRIMARY KEY (`id`),
  ADD KEY `fk_users_sid_resume` (`users_sid`),
  ADD KEY `fk_person_id_resume` (`person_id`),
  ADD KEY `fk_request_id_resume` (`request_id`),
  ADD KEY `fk_currency_id_resume` (`currency_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `pasajes_viaticos_catalog_items`
--
ALTER TABLE `pasajes_viaticos_catalog_items`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_escala`
--
ALTER TABLE `pasajes_viaticos_escala`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_fly_ticket_control`
--
ALTER TABLE `pasajes_viaticos_fly_ticket_control`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_fly_ticket_related_request`
--
ALTER TABLE `pasajes_viaticos_fly_ticket_related_request`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_itinerary`
--
ALTER TABLE `pasajes_viaticos_itinerary`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_message_notification`
--
ALTER TABLE `pasajes_viaticos_message_notification`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_relation`
--
ALTER TABLE `pasajes_viaticos_relation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_request_administrative_resolution`
--
ALTER TABLE `pasajes_viaticos_request_administrative_resolution`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_request_approve_reject`
--
ALTER TABLE `pasajes_viaticos_request_approve_reject`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_request_attachments`
--
ALTER TABLE `pasajes_viaticos_request_attachments`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_request_calculation`
--
ALTER TABLE `pasajes_viaticos_request_calculation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_request_final_inform`
--
ALTER TABLE `pasajes_viaticos_request_final_inform`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_request_final_inform_cite`
--
ALTER TABLE `pasajes_viaticos_request_final_inform_cite`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_request_formulario_110`
--
ALTER TABLE `pasajes_viaticos_request_formulario_110`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_request_itinerary`
--
ALTER TABLE `pasajes_viaticos_request_itinerary`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_request_reliquidation`
--
ALTER TABLE `pasajes_viaticos_request_reliquidation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_request_reliquidation_itinerary`
--
ALTER TABLE `pasajes_viaticos_request_reliquidation_itinerary`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_request_reliquidation_itinerary_costs`
--
ALTER TABLE `pasajes_viaticos_request_reliquidation_itinerary_costs`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_request_weekend_holliday`
--
ALTER TABLE `pasajes_viaticos_request_weekend_holliday`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `pasajes_viaticos_resume`
--
ALTER TABLE `pasajes_viaticos_resume`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `pasajes_viaticos_catalog_items`
--
ALTER TABLE `pasajes_viaticos_catalog_items`
  ADD CONSTRAINT `fk_users_sid_catalogs_items` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_configuration`
--
ALTER TABLE `pasajes_viaticos_configuration`
  ADD CONSTRAINT `fk_administrative_affairs_configuration` FOREIGN KEY (`administrative_affairs`) REFERENCES `core`.`global_users` (`sid`),
  ADD CONSTRAINT `fk_currency_id_configuration` FOREIGN KEY (`currency_id`) REFERENCES `core`.`global_currency` (`id`),
  ADD CONSTRAINT `fk_pyv_in_charge_configuration` FOREIGN KEY (`pyv_in_charge`) REFERENCES `core`.`global_users` (`sid`),
  ADD CONSTRAINT `fk_users_configuration` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_escala`
--
ALTER TABLE `pasajes_viaticos_escala`
  ADD CONSTRAINT `fk_categoria_viatico_id_escala` FOREIGN KEY (`categoria_viatico_id`) REFERENCES `pasajes_viaticos_catalog_items` (`value`),
  ADD CONSTRAINT `fk_currency_id_escala` FOREIGN KEY (`currency_id`) REFERENCES `core`.`global_currency` (`id`),
  ADD CONSTRAINT `fk_subtype_id_escala` FOREIGN KEY (`subtype_id`) REFERENCES `pasajes_viaticos_catalog_items` (`value`),
  ADD CONSTRAINT `fk_type_id_escala` FOREIGN KEY (`type_id`) REFERENCES `pasajes_viaticos_catalog_items` (`value`),
  ADD CONSTRAINT `fk_users_sid_escala` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_fly_ticket_control`
--
ALTER TABLE `pasajes_viaticos_fly_ticket_control`
  ADD CONSTRAINT `fk_currency_id_fly_ticket_control` FOREIGN KEY (`currency_id`) REFERENCES `core`.`global_currency` (`id`),
  ADD CONSTRAINT `fk_supplier_vendors_id_fly_ticket_control` FOREIGN KEY (`supplier_vendors_id`) REFERENCES `core_supplier`.`supplier_vendors` (`relative`),
  ADD CONSTRAINT `fk_traveler_id_fly_ticket_control` FOREIGN KEY (`traveler_id`) REFERENCES `core`.`global_users` (`sid`),
  ADD CONSTRAINT `fk_users_sid_fly_ticket_control` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`),
  ADD CONSTRAINT `fk_way_id_fly_ticket_control` FOREIGN KEY (`way_id`) REFERENCES `pasajes_viaticos_catalog_items` (`value`);

--
-- Constraints for table `pasajes_viaticos_fly_ticket_related_request`
--
ALTER TABLE `pasajes_viaticos_fly_ticket_related_request`
  ADD CONSTRAINT `fk_fly_ticket_control_id_fly_ticket_related_request` FOREIGN KEY (`fly_ticket_control_id`) REFERENCES `pasajes_viaticos_fly_ticket_control` (`id`),
  ADD CONSTRAINT `fk_request_id_fly_ticket_related_request` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_users_sid_fly_ticket_related_request` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`),
  ADD CONSTRAINT `fk_way_id_fly_ticket_related_request` FOREIGN KEY (`way_id`) REFERENCES `pasajes_viaticos_catalog_items` (`value`);

--
-- Constraints for table `pasajes_viaticos_itinerary`
--
ALTER TABLE `pasajes_viaticos_itinerary`
  ADD CONSTRAINT `fk_request_id_itinerary` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_transportway_id_itinerary` FOREIGN KEY (`transportway_id`) REFERENCES `pasajes_viaticos_catalog_items` (`value`),
  ADD CONSTRAINT `fk_users_sid_itinerary` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_message_notification`
--
ALTER TABLE `pasajes_viaticos_message_notification`
  ADD CONSTRAINT `fk_request_id_message_notification` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_users_sid_message_notification` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_relation`
--
ALTER TABLE `pasajes_viaticos_relation`
  ADD CONSTRAINT `fk_autoridad_id_relation` FOREIGN KEY (`autoridad_id`) REFERENCES `pasajes_viaticos_catalog_items` (`value`),
  ADD CONSTRAINT `fk_cargo_id_relation` FOREIGN KEY (`cargo_id`) REFERENCES `core`.`global_catalog_items` (`value`),
  ADD CONSTRAINT `fk_categoria_viatico_id_relation` FOREIGN KEY (`categoria_viatico_id`) REFERENCES `pasajes_viaticos_catalog_items` (`value`),
  ADD CONSTRAINT `fk_inmediato_superior_id_relation` FOREIGN KEY (`inmediato_superior_id`) REFERENCES `core`.`global_catalog_items` (`value`),
  ADD CONSTRAINT `fk_users_sid_relation` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_request_administrative_resolution`
--
ALTER TABLE `pasajes_viaticos_request_administrative_resolution`
  ADD CONSTRAINT `fk_person_id_request_administrative_resolution` FOREIGN KEY (`person_id`) REFERENCES `core`.`global_person` (`id`),
  ADD CONSTRAINT `fk_request_id_request_administrative_resolution` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_users_sid_request_administrative_resolution` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_request_approve_reject`
--
ALTER TABLE `pasajes_viaticos_request_approve_reject`
  ADD CONSTRAINT `fk_request_id_request_approve_reject` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_users_sid_request_approve_reject` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_request_attachments`
--
ALTER TABLE `pasajes_viaticos_request_attachments`
  ADD CONSTRAINT `fk_request_id_request_attachments` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_users_sid_request_attachments` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_request_calculation`
--
ALTER TABLE `pasajes_viaticos_request_calculation`
  ADD CONSTRAINT `fk_currency_id_request_calculation` FOREIGN KEY (`currency_id`) REFERENCES `core`.`global_currency` (`id`),
  ADD CONSTRAINT `fk_request_id_request_calculation` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_users_sid_request_calculation` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_request_final_inform`
--
ALTER TABLE `pasajes_viaticos_request_final_inform`
  ADD CONSTRAINT `fk_addressed_to_id_request_final_inform` FOREIGN KEY (`addressed_to_id`) REFERENCES `core`.`global_catalog_items` (`value`),
  ADD CONSTRAINT `fk_request_id_request_final_inform` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_users_sid_request_final_inform` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_request_final_inform_cite`
--
ALTER TABLE `pasajes_viaticos_request_final_inform_cite`
  ADD CONSTRAINT `fk_request_id_request_final_inform_cite` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_users_sid_request_final_inform_cite` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_request_formulario_110`
--
ALTER TABLE `pasajes_viaticos_request_formulario_110`
  ADD CONSTRAINT `fk_currency_id_request_formulario_110` FOREIGN KEY (`currency_id`) REFERENCES `core`.`global_currency` (`id`),
  ADD CONSTRAINT `fk_request_id_request_formulario_110` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_users_sid_request_formulario_110` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_request_itinerary`
--
ALTER TABLE `pasajes_viaticos_request_itinerary`
  ADD CONSTRAINT `fk_request_id_request_itinerary` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_transportway_id_request_itinerary` FOREIGN KEY (`transportway_id`) REFERENCES `pasajes_viaticos_catalog_items` (`value`),
  ADD CONSTRAINT `fk_users_sid_request_itinerary` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`),
  ADD CONSTRAINT `fk_way_id_request_itinerary` FOREIGN KEY (`way_id`) REFERENCES `pasajes_viaticos_catalog_items` (`value`);

--
-- Constraints for table `pasajes_viaticos_request_reliquidation`
--
ALTER TABLE `pasajes_viaticos_request_reliquidation`
  ADD CONSTRAINT `fk_request_id_request_reliquidation` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_users_sid_request_reliquidation` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_request_reliquidation_itinerary`
--
ALTER TABLE `pasajes_viaticos_request_reliquidation_itinerary`
  ADD CONSTRAINT `fk_itinerary_id_request_reliquidation_itinerary` FOREIGN KEY (`itinerary_id`) REFERENCES `pasajes_viaticos_request_itinerary` (`id`),
  ADD CONSTRAINT `fk_request_id_request_reliquidation_itinerary` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_transportway_id_request_reliquidation_itinerary` FOREIGN KEY (`transportway_id`) REFERENCES `pasajes_viaticos_catalog_items` (`value`),
  ADD CONSTRAINT `fk_users_sid_request_reliquidation_itinerary` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`),
  ADD CONSTRAINT `fk_way_id_request_reliquidation_itinerary` FOREIGN KEY (`way_id`) REFERENCES `pasajes_viaticos_catalog_items` (`value`);

--
-- Constraints for table `pasajes_viaticos_request_reliquidation_itinerary_costs`
--
ALTER TABLE `pasajes_viaticos_request_reliquidation_itinerary_costs`
  ADD CONSTRAINT `fk_currency_id_request_reliquidation_itinerary_costs` FOREIGN KEY (`currency_id`) REFERENCES `core`.`global_currency` (`id`),
  ADD CONSTRAINT `fk_request_id_request_reliquidation_itinerary_costs` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_users_sid_request_reliquidation_itinerary_costs` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_request_weekend_holliday`
--
ALTER TABLE `pasajes_viaticos_request_weekend_holliday`
  ADD CONSTRAINT `fk_request_id_request_weekend_holliday` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_users_sid_request_weekend_holliday` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);

--
-- Constraints for table `pasajes_viaticos_resume`
--
ALTER TABLE `pasajes_viaticos_resume`
  ADD CONSTRAINT `fk_currency_id_resume` FOREIGN KEY (`currency_id`) REFERENCES `core`.`global_currency` (`id`),
  ADD CONSTRAINT `fk_person_id_resume` FOREIGN KEY (`person_id`) REFERENCES `core`.`global_person` (`id`),
  ADD CONSTRAINT `fk_request_id_resume` FOREIGN KEY (`request_id`) REFERENCES `pasajes_viaticos_request` (`id`),
  ADD CONSTRAINT `fk_users_sid_resume` FOREIGN KEY (`users_sid`) REFERENCES `core`.`global_users` (`sid`);
COMMIT;

