(64733,1060,1,10,7,0,26,4.375,50,'2025-10-10','Informes financieros y técnicos APL','2025-10-10','2025-10-10'),(64734,1060,1,10,7,0,26,4.375,50,'2025-10-10','Criterios de conformidad APL','2025-10-10','2025-10-10'),(64735,1072,1,10,7,0,131,7.875,90,'2025-10-09','Gestión y coordinación gral','2025-10-10','2025-10-10'),(64736,1072,1,10,7,0,25,0.875,10,'2025-10-09','EEC','2025-10-10','2025-10-10'),(64737,1072,1,10,7,0,131,8.3125,95,'2025-10-10','Gestión y coordinación Gral','2025-10-10','2025-10-10'),(64738,1072,1,10,7,0,25,0.4375,5,'2025-10-10','EEC','2025-10-10','2025-10-10'),(64739,1057,1,10,1,0,5,8.75,100,'2025-10-06',NULL,'2025-10-13','2025-10-13'),(64740,1057,1,10,1,0,5,8.75,100,'2025-10-09',NULL,'2025-10-13','2025-10-13'),(64741,1057,1,10,1,0,5,8.75,100,'2025-10-07',NULL,'2025-10-13','2025-10-13'),(64742,1057,1,10,1,0,5,8.75,100,'2025-10-08',NULL,'2025-10-13','2025-10-13'),(64743,1057,1,10,1,0,5,8.75,100,'2025-10-10',NULL,'2025-10-13','2025-10-13'),(64745,1012,1,10,18,0,149,0.875,10,'2025-10-15','','2025-10-15','2025-10-15'),(64746,1012,1,10,4,0,14,2.625,30,'2025-10-15','','2025-10-15','2025-10-15'),(64747,1012,1,10,4,0,12,5.25,60,'2025-10-15','','2025-10-15','2025-10-15'),(64748,1012,1,10,18,0,149,0.875,10,'2025-10-14','','2025-10-15','2025-10-15'),(64749,1012,1,10,4,0,14,3.5,40,'2025-10-14','','2025-10-15','2025-10-15'),(64750,1012,1,10,1,0,9,0.875,10,'2025-10-14','','2025-10-15','2025-10-15'),(64751,1012,1,10,4,0,12,3.5,40,'2025-10-14','','2025-10-15','2025-10-15'),(64752,1072,1,10,7,0,131,7.875,90,'2025-10-15','Gestión y coodinación BID','2025-10-15','2025-10-15'),(64753,1072,1,10,7,0,25,0.875,10,'2025-10-15','Newsletter Rev','2025-10-15','2025-10-15'),(64754,1072,1,10,7,0,131,8.75,100,'2025-10-14','Gestión y coodinación BID','2025-10-15','2025-10-15'),(64765,1057,1,10,1,0,5,8.75,100,'2025-10-14',NULL,'2025-10-16','2025-10-16'),(64766,1057,1,10,1,0,5,8.75,100,'2025-10-15',NULL,'2025-10-16','2025-10-16'),(64768,1027,1,10,1,0,5,8.75,100,'2025-10-08',NULL,'2025-10-16','2025-10-16'),(64769,1027,1,10,1,0,5,8.75,100,'2025-10-09',NULL,'2025-10-16','2025-10-16'),(64770,1027,1,10,1,0,5,8.75,100,'2025-10-10',NULL,'2025-10-16','2025-10-16'),(64771,1027,1,10,1,0,5,8.75,100,'2025-10-14',NULL,'2025-10-16','2025-10-16'),(64772,1027,1,10,1,0,5,8.75,100,'2025-10-15',NULL,'2025-10-16','2025-10-16'),(64773,1027,1,10,1,0,5,8.75,100,'2025-10-16',NULL,'2025-10-16','2025-10-16'),(64775,1043,1,10,9,0,46,4.375,50,'2025-10-02',NULL,'2025-10-16','2025-10-16'),(64776,1043,1,10,9,0,46,4.375,50,'2025-10-01',NULL,'2025-10-16','2025-10-16'),(64777,1043,1,10,9,0,46,3,50,'2025-10-03',NULL,'2025-10-16','2025-10-16'),(64778,1043,1,10,9,0,46,4.375,50,'2025-10-06',NULL,'2025-10-16','2025-10-16'),(64779,1043,1,10,9,0,46,4.375,50,'2025-10-07',NULL,'2025-10-16','2025-10-16'),(64780,1043,1,10,9,0,46,4.375,50,'2025-10-08',NULL,'2025-10-16','2025-10-16'),(64781,1043,1,10,9,0,46,3.5,40,'2025-10-09',NULL,'2025-10-16','2025-10-16'),(64782,1043,1,10,9,0,46,3.5,40,'2025-10-10',NULL,'2025-10-16','2025-10-16'),(64783,1043,1,10,9,0,46,3.0625,35,'2025-10-14',NULL,'2025-10-16','2025-10-16'),(64784,1043,1,10,9,0,46,1.75,20,'2025-10-15',NULL,'2025-10-16','2025-10-16'),(64785,1043,1,10,9,0,46,4.375,50,'2025-10-16',NULL,'2025-10-16','2025-10-16'),(64786,1043,1,10,9,0,46,4.375,50,'2025-10-17',NULL,'2025-10-16','2025-10-16'),(64787,1043,1,10,9,0,46,4.375,50,'2025-10-21',NULL,'2025-10-16','2025-10-16'),(64788,1043,1,10,9,0,46,4.375,50,'2025-10-23',NULL,'2025-10-16','2025-10-16'),(64789,1043,1,10,9,0,46,4.375,50,'2025-10-22',NULL,'2025-10-16','2025-10-16'),(64790,1043,1,10,9,0,46,4.375,50,'2025-10-24',NULL,'2025-10-16','2025-10-16'),(64791,1043,1,10,9,0,46,4.375,50,'2025-10-28',NULL,'2025-10-16','2025-10-16'),(64792,1043,1,10,9,0,46,4.375,50,'2025-10-29',NULL,'2025-10-16','2025-10-16'),(64793,1043,1,10,9,0,46,4.375,50,'2025-10-30',NULL,'2025-10-16','2025-10-16'),(64794,1043,1,10,1,0,5,4.375,50,'2025-10-02',NULL,'2025-10-16','2025-10-16'),(64795,1043,1,10,1,0,5,4.375,50,'2025-10-06',NULL,'2025-10-16','2025-10-16'),(64796,1043,1,10,1,0,5,3,50,'2025-10-03',NULL,'2025-10-16','2025-10-16'),(64797,1043,1,10,1,0,5,4.375,50,'2025-10-07',NULL,'2025-10-16','2025-10-16'),(64798,1043,1,10,1,0,5,4.375,50,'2025-10-08',NULL,'2025-10-16','2025-10-16'),(64799,1043,1,10,1,0,5,3.5,40,'2025-10-10',NULL,'2025-10-16','2025-10-16'),(64800,1043,1,10,1,0,5,3.5,40,'2025-10-09',NULL,'2025-10-16','2025-10-16'),(64801,1043,1,10,1,0,5,3.0625,35,'2025-10-14',NULL,'2025-10-16','2025-10-16'),(64802,1043,1,10,1,0,5,1.75,20,'2025-10-15',NULL,'2025-10-16','2025-10-16'),(64803,1043,1,10,1,0,5,4.375,50,'2025-10-16',NULL,'2025-10-16','2025-10-16'),(64804,1043,1,10,1,0,5,4.375,50,'2025-10-17',NULL,'2025-10-16','2025-10-16'),(64805,1043,1,10,1,0,5,4.375,50,'2025-10-21',NULL,'2025-10-16','2025-10-16'),(64806,1043,1,10,1,0,5,4.375,50,'2025-10-22',NULL,'2025-10-16','2025-10-16'),(64807,1043,1,10,1,0,5,4.375,50,'2025-10-23',NULL,'2025-10-16','2025-10-16'),(64808,1043,1,10,1,0,5,4.375,50,'2025-10-24',NULL,'2025-10-16','2025-10-16'),(64809,1043,1,10,1,0,5,4.375,50,'2025-10-28',NULL,'2025-10-16','2025-10-16'),(64810,1043,1,10,1,0,5,4.375,50,'2025-10-29',NULL,'2025-10-16','2025-10-16'),(64811,1043,1,10,1,0,5,4.375,50,'2025-10-30',NULL,'2025-10-16','2025-10-16'),(64812,1043,1,10,1,0,5,4.375,50,'2025-10-01',NULL,'2025-10-16','2025-10-16'),(64813,1043,1,10,8,0,35,1.75,20,'2025-10-09','','2025-10-16','2025-10-16'),(64814,1043,1,10,8,0,35,1.75,20,'2025-10-10','','2025-10-16','2025-10-16'),(64815,1043,1,10,8,0,35,2.625,30,'2025-10-14','','2025-10-16','2025-10-16'),(64816,1043,1,10,8,0,35,5.25,60,'2025-10-15','','2025-10-16','2025-10-16'),(64817,1040,1,10,6,0,107,8.75,100,'2025-10-01',NULL,'2025-10-16','2025-10-16'),(64818,1040,1,10,6,0,107,8.75,100,'2025-10-28',NULL,'2025-10-16','2025-10-16'),(64819,1040,1,10,6,0,107,8.75,100,'2025-10-29',NULL,'2025-10-16','2025-10-16'),(64820,1040,1,10,6,0,107,8.75,100,'2025-10-30',NULL,'2025-10-16','2025-10-16'),(64821,1040,1,10,6,0,107,6,100,'2025-10-03',NULL,'2025-10-16','2025-10-16'),(64822,1040,1,10,6,0,107,8.75,100,'2025-10-02',NULL,'2025-10-16','2025-10-16'),(64823,1040,1,10,6,0,107,8.75,100,'2025-10-06',NULL,'2025-10-16','2025-10-16'),(64824,1040,1,10,6,0,107,8.75,100,'2025-10-08',NULL,'2025-10-16','2025-10-16'),(64825,1040,1,10,6,0,107,8.75,100,'2025-10-09',NULL,'2025-10-16','2025-10-16'),(64826,1040,1,10,6,0,107,8.75,100,'2025-10-07',NULL,'2025-10-16','2025-10-16'),(64827,1040,1,10,6,0,107,8.75,100,'2025-10-14',NULL,'2025-10-16','2025-10-16'),(64828,1040,1,10,6,0,107,8.75,100,'2025-10-10',NULL,'2025-10-16','2025-10-16'),(64829,1040,1,10,6,0,107,8.75,100,'2025-10-16',NULL,'2025-10-16','2025-10-16'),(64830,1040,1,10,6,0,107,8.75,100,'2025-10-15',NULL,'2025-10-16','2025-10-16'),(64831,1040,1,10,6,0,107,8.75,100,'2025-10-17',NULL,'2025-10-16','2025-10-16'),(64832,1040,1,10,6,0,107,8.75,100,'2025-10-22',NULL,'2025-10-16','2025-10-16'),(64833,1040,1,10,6,0,107,8.75,100,'2025-10-21',NULL,'2025-10-16','2025-10-16'),(64834,1040,1,10,6,0,107,8.75,100,'2025-10-24',NULL,'2025-10-16','2025-10-16'),(64835,1040,1,10,6,0,107,8.75,100,'2025-10-23',NULL,'2025-10-16','2025-10-16'),(64836,1012,1,10,4,0,12,8.75,100,'2025-10-16','','2025-10-16','2025-10-16'),(64837,1011,1,10,1,0,5,8.75,100,'2025-10-15',NULL,'2025-10-17','2025-10-17'),(64838,1011,1,10,1,0,5,8.75,100,'2025-10-16',NULL,'2025-10-17','2025-10-17'),(64839,1011,1,10,1,0,5,8.75,100,'2025-10-17',NULL,'2025-10-17','2025-10-17'),(64840,1011,1,10,1,0,5,8.75,100,'2025-10-14',NULL,'2025-10-17','2025-10-17'),(64841,1076,1,10,9,0,41,1.3125,15,'2025-10-01','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64842,1076,1,10,9,0,41,1.3125,15,'2025-10-02','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64843,1076,1,10,9,0,41,0.9,15,'2025-10-03','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64844,1076,1,10,9,0,41,1.3125,15,'2025-10-06','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64845,1076,1,10,9,0,41,1.3125,15,'2025-10-07','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64846,1076,1,10,9,0,41,1.3125,15,'2025-10-09','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64847,1076,1,10,9,0,41,1.3125,15,'2025-10-10','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64848,1076,1,10,9,0,41,1.3125,15,'2025-10-14','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64849,1076,1,10,9,0,41,1.3125,15,'2025-10-15','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64850,1076,1,10,9,0,41,1.3125,15,'2025-10-16','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64851,1076,1,10,9,0,41,1.3125,15,'2025-10-17','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64852,1076,1,10,9,0,41,1.3125,15,'2025-10-21','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64853,1076,1,10,9,0,41,1.3125,15,'2025-10-22','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64854,1076,1,10,9,0,41,1.3125,15,'2025-10-23','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64855,1076,1,10,9,0,41,1.3125,15,'2025-10-28','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64856,1076,1,10,9,0,41,1.3125,15,'2025-10-08','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64857,1076,1,10,9,0,41,1.3125,15,'2025-10-30','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64858,1076,1,10,9,0,41,1.3125,15,'2025-10-29','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64859,1076,1,10,9,0,41,1.3125,15,'2025-10-24','Daily eje medición y kpi\'s','2025-10-17','2025-10-17'),(64860,1076,1,10,9,0,46,1.2,20,'2025-10-03','Reunión semanal de productividad','2025-10-17','2025-10-17'),(64861,1076,1,10,9,0,46,1.75,20,'2025-10-10','Reunión semanal de productividad','2025-10-17','2025-10-17'),(64862,1076,1,10,9,0,46,1.75,20,'2025-10-17','Reunión semanal de productividad','2025-10-17','2025-10-17'),(64863,1076,1,10,9,0,46,1.75,20,'2025-10-24','Reunión semanal de productividad','2025-10-17','2025-10-17'),(64864,1076,5,10,9,0,46,1.75,20,'2025-10-24','Taller Academia CDT','2025-10-17','2025-10-17'),(64865,1076,5,10,9,0,46,2.1875,25,'2025-10-24','Picnic CDT','2025-10-17','2025-10-17'),(64866,1076,1,10,18,0,150,0.875,10,'2025-10-24','Chatbot de integración temprana','2025-10-17','2025-10-17'),(64867,1076,1,10,9,0,39,0.875,10,'2025-10-24','Comisión de productividad','2025-10-17','2025-10-17'),(64868,1076,1,10,9,0,39,3.5,40,'2025-10-17','Acta comisión de productividad','2025-10-17','2025-10-17'),(64869,1076,1,10,9,0,145,0.875,10,'2025-10-17','Manual IPLC ','2025-10-17','2025-10-17'),(64870,1076,1,10,9,0,145,1.3125,15,'2025-10-17','IPLC - convenios','2025-10-17','2025-10-17'),(64871,1076,1,10,9,0,39,2.625,30,'2025-10-16','Mapas cadena de valor','2025-10-17','2025-10-17'),(64872,1076,1,10,9,0,39,0.875,10,'2025-10-16','Coordinación focus group - VSM','2025-10-17','2025-10-17'),(64873,1076,1,10,9,0,145,1.3125,15,'2025-10-16','Reunión construye 2025 - IPLC','2025-10-17','2025-10-17'),(64874,1076,1,10,9,0,145,1.75,20,'2025-10-16','Revisión manual IPLC','2025-10-17','2025-10-17'),(64875,1076,1,10,9,0,41,0.875,10,'2025-10-16','Metaverso','2025-10-17','2025-10-17'),(64876,1076,1,10,9,0,41,1.3125,15,'2025-10-15','Avances practicantes MMC Value','2025-10-17','2025-10-17'),(64877,1076,1,10,9,0,39,2.625,30,'2025-10-15','9na reunión comisión de productividad','2025-10-17','2025-10-17'),(64878,1076,1,10,9,0,39,1.75,20,'2025-10-15','Mapa cadena de valor','2025-10-17','2025-10-17'),(64879,1076,1,10,9,0,39,1.75,20,'2025-10-15','Creación estructura focus group y talleres','2025-10-17','2025-10-17'),(64880,1060,1,10,7,0,26,3.5,40,'2025-10-14','indicadores cuantificación APL','2025-10-17','2025-10-17'),(64881,1060,1,10,7,0,32,2.625,30,'2025-10-14','Reu Comisión Medio Ambiente','2025-10-17','2025-10-17'),(64882,1060,1,10,7,0,25,1.3125,15,'2025-10-14','Coordinación + Circular','2025-10-17','2025-10-17'),(64883,1060,1,10,7,0,26,1.3125,15,'2025-10-14','Criterios de Conformidad APL','2025-10-17','2025-10-17'),(64884,1060,1,10,7,0,26,1.75,20,'2025-10-15','Datos APL Empresas','2025-10-17','2025-10-17'),(64885,1060,1,10,7,0,26,1.75,20,'2025-10-15','Criterios de conformidad APL','2025-10-17','2025-10-17'),(64886,1060,1,10,7,0,26,3.5,40,'2025-10-15','Informes de cuantificación APL','2025-10-17','2025-10-17'),(64887,1060,1,10,7,0,26,1.75,20,'2025-10-15','Revisión guía BBPP','2025-10-17','2025-10-17'),(64888,1060,1,10,7,0,26,2.625,30,'2025-10-16','Postulación certificación APL','2025-10-17','2025-10-17'),(64889,1012,1,10,18,0,149,1.75,20,'2025-10-17','','2025-10-17','2025-10-17'),(64890,1060,1,10,7,0,32,1.3125,15,'2025-10-16','Aprendizajes Enamac','2025-10-17','2025-10-17'),(64891,1012,5,10,4,0,14,0.875,10,'2025-10-17','Coordinación CDT','2025-10-17','2025-10-17'),(64892,1012,1,10,4,0,12,6.125,70,'2025-10-17','','2025-10-17','2025-10-17'),(64893,1060,1,10,7,0,32,4.8125,55,'2025-10-16','APL RM','2025-10-17','2025-10-17'),(64894,1060,1,10,7,0,26,4.375,50,'2025-10-17','Informe FInanciero Punta Arenas','2025-10-17','2025-10-17'),(64895,1060,1,10,7,0,26,4.375,50,'2025-10-17','Postulación Puerto Montt','2025-10-17','2025-10-17'),(64896,1057,1,10,1,0,5,8.75,100,'2025-10-16',NULL,'2025-10-17','2025-10-17'),(64897,1057,1,10,1,0,5,8.75,100,'2025-10-17',NULL,'2025-10-17','2025-10-17'),(64898,1067,1,10,9,0,45,4.375,50,'2025-10-02',NULL,'2025-10-17','2025-10-17'),(64899,1067,1,10,9,0,45,4.375,50,'2025-10-14',NULL,'2025-10-17','2025-10-17'),(64900,1067,1,10,9,0,45,4.375,50,'2025-10-16',NULL,'2025-10-17','2025-10-17'),(64901,1067,1,10,9,0,45,4.375,50,'2025-10-15',NULL,'2025-10-17','2025-10-17'),(64902,1067,1,10,9,0,45,4.375,50,'2025-10-17',NULL,'2025-10-17','2025-10-17'),(64903,1067,1,10,9,0,45,4.375,50,'2025-10-01',NULL,'2025-10-17','2025-10-17'),(64904,1067,1,10,9,0,45,4.375,50,'2025-10-06',NULL,'2025-10-17','2025-10-17'),(64905,1067,1,10,9,0,45,3,50,'2025-10-03',NULL,'2025-10-17','2025-10-17'),(64906,1067,1,10,9,0,45,4.375,50,'2025-10-07',NULL,'2025-10-17','2025-10-17'),(64907,1067,1,10,9,0,45,4.375,50,'2025-10-08',NULL,'2025-10-17','2025-10-17'),(64908,1067,1,10,9,0,45,4.375,50,'2025-10-09',NULL,'2025-10-17','2025-10-17'),(64909,1067,1,10,9,0,45,4.375,50,'2025-10-10',NULL,'2025-10-17','2025-10-17'),(64910,1067,1,10,9,0,45,4.375,50,'2025-09-24',NULL,'2025-10-17','2025-10-17'),(64911,1067,1,10,9,0,45,4.375,50,'2025-09-23',NULL,'2025-10-17','2025-10-17'),(64912,1067,1,10,9,0,45,3,50,'2025-09-26',NULL,'2025-10-17','2025-10-17'),(64913,1067,1,10,9,0,45,4.375,50,'2025-09-25',NULL,'2025-10-17','2025-10-17'),(64914,1067,1,10,9,0,45,4.375,50,'2025-09-29',NULL,'2025-10-17','2025-10-17'),(64915,1067,1,10,9,0,45,4.375,50,'2025-09-30',NULL,'2025-10-17','2025-10-17'),(64916,1067,1,10,9,0,39,2.625,30,'2025-10-06',NULL,'2025-10-17','2025-10-17'),(64917,1067,1,10,9,0,39,1.8,30,'2025-10-03',NULL,'2025-10-17','2025-10-17'),(64918,1067,1,10,9,0,39,2.625,30,'2025-10-16',NULL,'2025-10-17','2025-10-17'),(64919,1067,1,10,9,0,39,3.5,40,'2025-10-02',NULL,'2025-10-17','2025-10-17'),(64920,1067,1,10,9,0,39,2.625,30,'2025-10-17',NULL,'2025-10-17','2025-10-17'),(64921,1067,1,10,9,0,39,3.5,40,'2025-10-01',NULL,'2025-10-17','2025-10-17'),(64922,1067,1,10,9,0,39,2.625,30,'2025-10-08',NULL,'2025-10-17','2025-10-17'),(64923,1067,1,10,9,0,39,2.625,30,'2025-10-07',NULL,'2025-10-17','2025-10-17'),(64924,1067,1,10,9,0,39,2.625,30,'2025-10-09',NULL,'2025-10-17','2025-10-17'),(64925,1067,1,10,9,0,39,2.625,30,'2025-10-10',NULL,'2025-10-17','2025-10-17'),(64926,1067,1,10,9,0,39,2.625,30,'2025-10-15',NULL,'2025-10-17','2025-10-17'),(64927,1067,1,10,9,0,39,2.625,30,'2025-10-14',NULL,'2025-10-17','2025-10-17'),(64928,1067,1,10,18,0,150,1.75,20,'2025-10-17','','2025-10-17','2025-10-17'),(64929,1067,1,10,9,0,46,0.875,10,'2025-10-01','','2025-10-17','2025-10-17'),(64930,1067,1,10,9,0,46,0.875,10,'2025-10-02','','2025-10-17','2025-10-17'),(64931,1067,1,10,9,0,46,0.6,10,'2025-10-03',NULL,'2025-10-17','2025-10-17'),(64932,1067,1,10,9,0,46,0.875,10,'2025-10-06',NULL,'2025-10-17','2025-10-17'),(64933,1067,1,10,9,0,46,0.875,10,'2025-10-07',NULL,'2025-10-17','2025-10-17'),(64934,1067,1,10,9,0,46,0.875,10,'2025-10-09',NULL,'2025-10-17','2025-10-17'),(64935,1067,1,10,9,0,46,0.875,10,'2025-10-08',NULL,'2025-10-17','2025-10-17'),(64936,1067,1,10,9,0,46,0.875,10,'2025-10-15',NULL,'2025-10-17','2025-10-17'),(64937,1067,1,10,9,0,46,0.875,10,'2025-10-16',NULL,'2025-10-17','2025-10-17'),(64938,1067,1,10,9,0,46,0.875,10,'2025-10-14',NULL,'2025-10-17','2025-10-17'),(64939,1067,1,10,9,0,46,0.875,10,'2025-10-10',NULL,'2025-10-17','2025-10-17'),(64940,1025,5,10,1,0,5,1.75,20,'2025-09-22','Reunión semanal Gerencia Desarrollo Empresarial CChC','2025-10-17','2025-10-17'),(64941,1025,5,10,1,0,5,2.625,30,'2025-09-22','Coordinación CDT','2025-10-17','2025-10-17'),(64942,1025,5,10,1,0,5,4.375,50,'2025-09-22','Varios Gerencia General','2025-10-17','2025-10-17'),(64943,1025,8,10,1,0,5,8.75,100,'2025-10-09','Vacaciones C.López','2025-10-17','2025-10-17'),(64944,1025,5,10,1,0,5,8.75,100,'2025-10-10','Vacaciones C.López','2025-10-17','2025-10-17'),(64945,1051,1,10,9,0,127,8.75,100,'2025-10-01','HdRBIM','2025-10-17','2025-10-17'),(64946,1051,1,10,9,0,127,8.75,100,'2025-10-02','HdRBIM','2025-10-17','2025-10-17'),(64947,1051,1,10,9,0,127,6,100,'2025-10-03','HdRBIM','2025-10-17','2025-10-17'),(64948,1051,1,10,9,0,127,8.75,100,'2025-10-07','HdRBIM','2025-10-17','2025-10-17'),(64949,1051,1,10,9,0,127,8.75,100,'2025-10-06','HdRBIM','2025-10-17','2025-10-17'),(64950,1051,1,10,9,0,127,8.75,100,'2025-10-08','HdRBIM','2025-10-17','2025-10-17'),(64951,1051,1,10,9,0,127,8.75,100,'2025-10-09','HdRBIM','2025-10-17','2025-10-17'),(64952,1051,1,10,9,0,127,8.75,100,'2025-10-10','HdRBIM','2025-10-17','2025-10-17'),(64953,1051,1,10,9,0,127,8.75,100,'2025-10-15','HdRBIM','2025-10-17','2025-10-17'),(64954,1051,1,10,9,0,127,8.75,100,'2025-10-14','HdRBIM','2025-10-17','2025-10-17'),(64955,1051,1,10,9,0,127,8.75,100,'2025-10-16','HdRBIM','2025-10-17','2025-10-17'),(64956,1051,1,10,9,0,127,8.75,100,'2025-10-17','HdRBIM','2025-10-17','2025-10-17'),(64957,1051,1,10,9,0,127,8.75,100,'2025-09-22','HdRBIM','2025-10-17','2025-10-17'),(64958,1051,1,10,9,0,127,8.75,100,'2025-09-23','HdRBIM','2025-10-17','2025-10-17'),(64959,1051,1,10,9,0,127,8.75,100,'2025-09-24','HdRBIM','2025-10-17','2025-10-17'),(64960,1051,1,10,9,0,127,8.75,100,'2025-09-25','HdRBIM','2025-10-17','2025-10-17'),(64961,1051,1,10,9,0,127,6,100,'2025-09-26','HdRBIM','2025-10-17','2025-10-17'),(64962,1051,1,10,9,0,127,8.75,100,'2025-09-29','HdRBIM','2025-10-17','2025-10-17'),(64963,1051,1,10,9,0,127,8.75,100,'2025-09-30','HdRBIM','2025-10-17','2025-10-17'),(64964,1025,5,10,1,0,5,2.625,30,'2025-09-23','Inauguración Edificio Burgos','2025-10-17','2025-10-17'),(64965,1025,5,10,1,0,5,2.625,30,'2025-09-23','Coordinación Comisión de Productividad','2025-10-17','2025-10-17'),(64966,1025,4,10,1,0,5,1.75,20,'2025-09-23','Varios administrativos','2025-10-17','2025-10-17'),(64967,1025,5,10,1,0,5,1.75,20,'2025-09-23','Varios Gerencia General','2025-10-17','2025-10-17'),(64968,1025,5,10,1,0,5,2.625,30,'2025-09-24','Comisión Desarrollo Sustentable IC','2025-10-17','2025-10-17'),(64969,1025,5,10,1,0,5,1.75,20,'2025-09-24','Proyecto Innovación Interna CDT','2025-10-17','2025-10-17'),(64970,1025,5,10,8,0,5,2.625,30,'2025-09-24','Revisión temas Productividad','2025-10-17','2025-10-17'),(64971,1025,5,10,1,0,5,1.75,20,'2025-09-24','Varios Gerencia General','2025-10-17','2025-10-17'),(64972,1025,5,10,1,0,5,3.5,40,'2025-09-25','Revisión proyectos Innovación Interna CDT','2025-10-17','2025-10-17'),(64973,1025,5,10,1,0,5,2.625,30,'2025-09-25','Formulación modelo de desarrollo de proyectos','2025-10-17','2025-10-17'),(64974,1025,5,10,8,0,35,2.625,30,'2025-09-25','Puesta en marcha Corporación BIM Forum','2025-10-17','2025-10-17'),(64975,1025,5,10,1,0,5,3,50,'2025-09-26','Actividad Fundación Emprender','2025-10-17','2025-10-17'),(64976,1025,5,10,1,0,5,1.8,30,'2025-09-26','Coordinación Desarrollo Técnico','2025-10-17','2025-10-17'),(64977,1025,4,10,1,0,5,1.2,20,'2025-09-26','Varios administrativos','2025-10-17','2025-10-17'),(64978,1025,5,10,1,0,5,3.5,40,'2025-09-29','Revisión presupuesto Productividad CChC','2025-10-17','2025-10-17'),(64979,1025,5,10,1,0,5,2.625,30,'2025-09-29','Coordinación CDT','2025-10-17','2025-10-17'),(64980,1025,5,10,1,0,5,2.625,30,'2025-09-29','Avances sello PRO CDT','2025-10-17','2025-10-17'),(64981,1025,5,10,1,0,5,3.5,40,'2025-09-30','Desayuno Comisión Productividad','2025-10-17','2025-10-17'),(64982,1076,1,10,9,0,41,0.875,10,'2025-10-01','Avances estudiantes MMC Value','2025-10-17','2025-10-17'),(64983,1076,1,10,9,0,145,1.3125,15,'2025-10-01','Reunión SOCOVESA - IPLC','2025-10-17','2025-10-17'),(64984,1076,1,10,9,0,39,1.75,20,'2025-10-01','Coordinación comisión de productividad (petit)','2025-10-17','2025-10-17'),(64985,1076,1,10,9,0,145,3.5,40,'2025-10-01','Datos IPLC','2025-10-17','2025-10-17'),(64986,1076,1,10,9,0,145,3.5,40,'2025-10-02','Datos IPLC','2025-10-17','2025-10-17'),(64987,1076,1,10,9,0,145,0.9,15,'2025-10-03','Reunión entregables del IPLC','2025-10-17','2025-10-17'),(64988,1076,1,10,9,0,145,0.9,15,'2025-10-03','Reunión IPLC - Construye 2025','2025-10-17','2025-10-17'),(64989,1076,1,10,9,0,46,1.75,20,'2025-10-06','Reunión semanal de gerencia ','2025-10-17','2025-10-17'),(64990,1076,1,10,9,0,39,1.75,20,'2025-10-06','Ajustes 9na sesión de comisión','2025-10-17','2025-10-17'),(64991,1076,1,10,9,0,41,1.3125,15,'2025-10-06','Reunión manual técnico MMC','2025-10-17','2025-10-17'),(64992,1076,1,10,9,0,145,2.625,30,'2025-10-06','Datos IPLC','2025-10-17','2025-10-17'),(64993,1076,1,10,9,0,39,1.75,20,'2025-10-07','Reunión comisión de productividad','2025-10-17','2025-10-17'),(64994,1076,1,10,9,0,39,2.1875,25,'2025-10-07','PPT Comisión Productividad','2025-10-17','2025-10-17'),(64995,1076,1,10,9,0,145,0.875,10,'2025-10-07','Correo empresas IPLC','2025-10-17','2025-10-17'),(64996,1076,1,10,9,0,39,0.875,10,'2025-10-07','Coordinación con comisionados','2025-10-17','2025-10-17'),(64997,1076,1,10,9,0,39,1.75,20,'2025-10-07','Estructura y carta gantt Talleres Cadena de Valor','2025-10-17','2025-10-17'),(64998,1076,5,10,9,0,46,1.3125,15,'2025-10-08','Pitch ','2025-10-17','2025-10-17'),(64999,1076,1,10,9,0,39,2.1875,25,'2025-10-08','Mapas de cadena de valor','2025-10-17','2025-10-17'),(65000,1076,1,10,9,0,39,1.3125,15,'2025-10-08','Reunión Conecta','2025-10-17','2025-10-17'),(65001,1076,1,10,9,0,145,2.625,30,'2025-10-08','Datos IPLC','2025-10-17','2025-10-17'),(65002,1076,1,10,9,0,39,1.75,20,'2025-10-09','Reunión Talleres Cadena de Valor','2025-10-17','2025-10-17'),(65003,1076,1,10,9,0,145,2.625,30,'2025-10-09','Revisión manual IPLC','2025-10-17','2025-10-17'),(65004,1076,1,10,9,0,145,1.75,20,'2025-10-09','Reunión IPLC - Construye 2025','2025-10-17','2025-10-17'),(65005,1076,1,10,9,0,41,1.3125,15,'2025-10-09','Metaverso','2025-10-17','2025-10-17'),(65006,1076,1,10,18,0,150,1.3125,15,'2025-10-10','Chatbot integración temprana','2025-10-17','2025-10-17'),(65007,1076,1,10,9,0,39,2.1875,25,'2025-10-10','PPT estructura zoom','2025-10-17','2025-10-17'),(65008,1076,1,10,9,0,39,1.3125,15,'2025-10-10','PPT estructura zoom','2025-10-17','2025-10-17'),(65009,1076,1,10,9,0,145,0.875,10,'2025-10-10','Convenio de colaboración','2025-10-17','2025-10-17'),(65010,1076,1,10,9,0,145,2.1875,25,'2025-10-14','Manual IPLC','2025-10-17','2025-10-17'),(65011,1076,1,10,9,0,145,1.75,20,'2025-10-14','Avances IPLC','2025-10-17','2025-10-17'),(65012,1076,1,10,9,0,39,1.3125,15,'2025-10-14','Coordinación Comisión','2025-10-17','2025-10-17'),(65013,1076,1,10,9,0,145,2.1875,25,'2025-10-14','Mapa cadena de valor','2025-10-17','2025-10-17'),(65014,1076,1,10,9,0,41,1.3125,15,'2025-10-21','Avances MMC Value','2025-10-17','2025-10-17'),(65015,1076,1,10,9,0,39,1.75,20,'2025-10-21','Comisión de productividad','2025-10-17','2025-10-17'),(65016,1076,5,10,9,0,46,2.1875,25,'2025-10-22','Reunión mensual de gerencia ','2025-10-17','2025-10-17'),(65017,1076,5,10,9,0,46,1.3125,15,'2025-10-22','Pitch','2025-10-17','2025-10-17'),(65018,1076,5,10,9,0,46,1.75,20,'2025-10-22','Almuerzo','2025-10-17','2025-10-17'),(65019,1076,1,10,9,0,145,1.3125,15,'2025-10-22','Manual','2025-10-17','2025-10-17'),(65020,1076,1,10,9,0,145,0.875,10,'2025-10-22','Informe IPLC','2025-10-17','2025-10-17'),(65021,1076,1,10,9,0,145,1.75,20,'2025-10-23','Reunión IPLC - Construye 2025','2025-10-17','2025-10-17'),(65022,1076,1,10,9,0,145,1.75,20,'2025-10-23','Metaverso','2025-10-17','2025-10-17'),(65023,1076,1,10,9,0,145,1.75,20,'2025-10-28','Avances IPLC','2025-10-17','2025-10-17'),(65024,1076,1,10,9,0,41,1.3125,15,'2025-10-28','Avances MMC Value','2025-10-17','2025-10-17'),(65025,1076,1,10,9,0,145,4.375,50,'2025-10-21','Revisar Datos IPLC','2025-10-17','2025-10-17'),(65026,1076,1,10,9,0,39,1.75,20,'2025-10-29','Comisión de productividad ','2025-10-17','2025-10-17'),(65027,1076,1,10,9,0,145,1.75,20,'2025-10-29','Avances IPLC','2025-10-17','2025-10-17'),(65028,1076,1,10,9,0,41,1.75,20,'2025-10-29','Avances Practicantes MMC Value','2025-10-17','2025-10-17'),(65029,1076,1,10,9,0,41,1.75,20,'2025-10-30','Metaverso','2025-10-17','2025-10-17'),(65030,1076,1,10,9,0,145,1.75,20,'2025-10-30','Reunión Construye 2025','2025-10-17','2025-10-17'),(65031,1076,1,10,9,0,39,0.875,10,'2025-10-02','PPT comisión','2025-10-17','2025-10-17'),(65032,1076,1,10,9,0,39,4.375,50,'2025-10-28','Focus Group Cadena de Valor','2025-10-17','2025-10-17'),(65033,1025,5,10,1,0,5,2.625,30,'2025-09-30','Coordinación eje Capital Humano','2025-10-17','2025-10-17'),(65034,1076,1,10,9,0,39,2.1875,25,'2025-10-29','Focus Group','2025-10-17','2025-10-17'),(65035,1025,4,10,1,0,5,2.625,30,'2025-09-30','Varios administrativos','2025-10-17','2025-10-17'),(65036,1076,1,10,9,0,39,3.9375,45,'2025-10-23','Estructura focus group','2025-10-17','2025-10-17'),(65037,1076,1,10,9,0,145,1.75,20,'2025-10-30','Manual IPLC','2025-10-17','2025-10-17'),(65038,1076,1,10,9,0,145,2.1875,25,'2025-10-30','Informe IPLC','2025-10-17','2025-10-17'),(65039,1076,1,10,9,0,145,3.0625,35,'2025-10-02','Manual IPLC','2025-10-17','2025-10-17'),(65040,1025,5,10,1,0,5,8.75,100,'2025-10-01','ENAMAC','2025-10-17','2025-10-17'),(65041,1076,1,10,9,0,39,0.9,15,'2025-10-03','PPT comisión','2025-10-17','2025-10-17'),(65042,1025,5,10,1,0,5,8.75,100,'2025-10-02','ENAMAC','2025-10-17','2025-10-17'),(65043,1025,5,10,1,0,5,2.4,40,'2025-10-03','Proyectos Innovación Interna','2025-10-17','2025-10-17'),(65044,1025,5,10,1,0,5,1.8,30,'2025-10-03','Coordinación eje Productividad','2025-10-17','2025-10-17'),(65045,1025,5,10,1,0,5,1.8,30,'2025-10-03','Varios Gerencia General','2025-10-17','2025-10-17'),(65046,1025,5,10,1,0,5,1.75,20,'2025-10-06','Reunión Gerencia Desarrollo Empresarial','2025-10-17','2025-10-17'),(65047,1025,5,10,1,0,5,2.625,30,'2025-10-06','Coordinación CDT','2025-10-17','2025-10-17'),(65048,1076,1,10,9,0,39,1.14,19,'2025-10-03','Coordinación comisión','2025-10-17','2025-10-17'),(65049,1025,5,10,1,0,5,1.75,20,'2025-10-06','Coordinación TI CChC','2025-10-17','2025-10-17'),(65050,1025,5,10,1,0,5,2.625,30,'2025-10-06','Comité Inmobiliario CChC','2025-10-17','2025-10-17'),(65051,1025,5,10,1,0,5,2.625,30,'2025-10-07','Coordinación Comisión Productividad','2025-10-17','2025-10-17'),(65052,1025,5,10,1,0,5,3.5,40,'2025-10-07','Varios Gerencia General','2025-10-17','2025-10-17'),(65053,1025,4,10,1,0,5,2.625,30,'2025-10-07','Varios administrativos','2025-10-17','2025-10-17'),(65054,1025,5,10,1,0,5,2.625,30,'2025-10-08','Auditoría Sello PRO','2025-10-17','2025-10-17'),(65055,1025,5,10,8,0,35,2.625,30,'2025-10-08','Puesta en marcha BIM Forum Chile','2025-10-17','2025-10-17'),(65056,1025,5,10,8,0,33,3.5,40,'2025-10-08','Varios CCI','2025-10-17','2025-10-17'),(65057,1025,8,10,1,0,5,8.75,100,'2025-10-14','Vacaciones C.López','2025-10-17','2025-10-17'),(65058,1025,5,10,1,0,5,1.75,20,'2025-10-15','Comisión Construcción Sustentable IC','2025-10-17','2025-10-17'),(65059,1025,5,10,1,0,5,2.625,30,'2025-10-15','Comisión Productividad CChC ','2025-10-17','2025-10-17'),(65060,1025,5,10,8,0,33,2.625,30,'2025-10-15','Varios CCI','2025-10-17','2025-10-17'),(65061,1025,5,10,1,0,5,1.75,20,'2025-10-15','Evento CDT - Ingeniería UC','2025-10-17','2025-10-17'),(65062,1025,4,10,1,0,5,1.75,20,'2025-10-16','Reunión GEMCO - Of. Marchant Pereira','2025-10-17','2025-10-17'),(65063,1025,5,10,1,0,5,4.375,50,'2025-10-16','Ampliada Suministros','2025-10-17','2025-10-17'),(65064,1025,5,10,8,0,33,2.625,30,'2025-10-16','Varios CCI','2025-10-17','2025-10-17'),(65065,1025,5,10,1,0,5,2.625,30,'2025-10-17','Coordinación CDT','2025-10-17','2025-10-17'),(65066,1025,4,10,1,0,5,2.625,30,'2025-10-17','Varios administrativos','2025-10-17','2025-10-17'),(65067,1025,5,10,1,0,5,3.5,40,'2025-10-17','Misión delegación Ecuador','2025-10-17','2025-10-17'),(65068,1075,1,10,8,0,35,8.75,100,'2025-10-06',NULL,'2025-10-20','2025-10-20'),(65069,1075,1,10,8,0,35,8.75,100,'2025-10-17',NULL,'2025-10-20','2025-10-20'),(65070,1075,1,10,8,0,35,8.75,100,'2025-10-07',NULL,'2025-10-20','2025-10-20'),(65071,1075,1,10,8,0,35,8.75,100,'2025-10-08',NULL,'2025-10-20','2025-10-20'),(65072,1075,1,10,8,0,35,8.75,100,'2025-10-09',NULL,'2025-10-20','2025-10-20'),(65073,1075,1,10,8,0,35,8.75,100,'2025-10-10',NULL,'2025-10-20','2025-10-20'),(65074,1075,1,10,8,0,35,8.75,100,'2025-10-14',NULL,'2025-10-20','2025-10-20'),(65075,1075,1,10,8,0,35,8.75,100,'2025-10-15',NULL,'2025-10-20','2025-10-20'),(65076,1075,1,10,8,0,35,8.75,100,'2025-10-16',NULL,'2025-10-20','2025-10-20'),(65106,1013,1,10,1,0,9,1.3125,15,'2025-10-08','','2025-10-20','2025-10-20'),(65107,1013,1,10,4,0,14,1.3125,15,'2025-10-08','','2025-10-20','2025-10-20'),(65108,1013,1,10,18,0,154,6.125,70,'2025-10-08','','2025-10-20','2025-10-20'),(65109,1013,1,10,18,0,149,0.875,10,'2025-10-13','','2025-10-20','2025-10-20'),(65110,1013,1,10,1,0,9,2.625,30,'2025-10-13','','2025-10-20','2025-10-20'),(65111,1013,1,10,4,0,12,2.625,30,'2025-10-13','','2025-10-20','2025-10-20'),(65112,1013,1,10,4,0,14,2.625,30,'2025-10-13','','2025-10-20','2025-10-20'),(65113,1013,1,10,18,0,149,0.875,10,'2025-10-17','','2025-10-20','2025-10-20'),(65114,1013,1,10,1,0,9,2.625,30,'2025-10-17','','2025-10-20','2025-10-20'),(65115,1013,1,10,4,0,12,2.625,30,'2025-10-17','','2025-10-20','2025-10-20'),(65116,1013,1,10,4,0,14,2.625,30,'2025-10-17','','2025-10-20','2025-10-20'),(65117,1013,1,10,4,0,12,2.1875,25,'2025-10-09','','2025-10-20','2025-10-20'),(65118,1013,1,10,4,0,14,2.1875,25,'2025-10-09','','2025-10-20','2025-10-20'),(65119,1013,1,10,1,0,9,4.375,50,'2025-10-09','','2025-10-20','2025-10-20'),(65120,1013,1,10,4,0,14,4.375,50,'2025-10-10','','2025-10-20','2025-10-20'),(65121,1013,1,10,1,0,9,4.375,50,'2025-10-10','','2025-10-20','2025-10-20'),(65122,1013,1,10,4,0,12,1.3125,15,'2025-10-14','','2025-10-20','2025-10-20'),(65123,1013,1,10,1,0,9,2.1875,25,'2025-10-14','','2025-10-20','2025-10-20'),(65124,1013,1,10,4,0,14,5.25,60,'2025-10-14','','2025-10-20','2025-10-20'),(65125,1013,1,10,4,0,14,2.625,30,'2025-10-15','','2025-10-20','2025-10-20'),(65126,1013,1,10,4,0,12,2.625,30,'2025-10-15','','2025-10-20','2025-10-20'),(65127,1013,1,10,1,0,9,3.5,40,'2025-10-15','','2025-10-20','2025-10-20'),(65128,1013,1,10,4,0,14,3.0625,35,'2025-10-16','','2025-10-20','2025-10-20'),(65129,1013,1,10,4,0,12,3.0625,35,'2025-10-16','','2025-10-20','2025-10-20'),(65130,1013,1,10,1,0,9,2.625,30,'2025-10-16','','2025-10-20','2025-10-20'),(65131,1013,1,10,4,0,14,3.0625,35,'2025-10-20','','2025-10-20','2025-10-20'),(65132,1013,1,10,4,0,12,3.0625,35,'2025-10-20','','2025-10-20','2025-10-20'),(65133,1013,1,10,1,0,9,2.625,30,'2025-10-20','','2025-10-20','2025-10-20'),(65134,1057,1,10,1,0,5,8.75,100,'2025-10-13','','2025-10-20','2025-10-20'),(65135,1057,1,10,1,0,5,8.75,100,'2025-10-20','','2025-10-20','2025-10-20'),(65137,1075,1,10,8,0,35,8.75,100,'2025-10-13','','2025-10-20','2025-10-20'),(65138,1075,1,10,8,0,35,8.75,100,'2025-10-20','','2025-10-20','2025-10-20'),(65139,1025,8,10,1,0,5,8.75,100,'2025-10-13','Vacaciones C.López','2025-10-20','2025-10-20'),(65140,1025,5,10,1,0,5,8.75,100,'2025-10-20','Delegación Ecuador','2025-10-20','2025-10-20'),(65141,1041,1,10,8,0,33,5.25,60,'2025-10-02',NULL,'2025-10-20','2025-10-20'),(65142,1041,1,10,8,0,33,3.6,60,'2025-10-03',NULL,'2025-10-20','2025-10-20'),(65143,1041,1,10,8,0,33,5.25,60,'2025-10-01',NULL,'2025-10-20','2025-10-20'),(65144,1041,1,10,8,0,33,5.25,60,'2025-10-06',NULL,'2025-10-20','2025-10-20'),(65145,1041,1,10,8,0,33,5.25,60,'2025-10-07',NULL,'2025-10-20','2025-10-20'),(65146,1041,1,10,8,0,33,5.25,60,'2025-10-08',NULL,'2025-10-20','2025-10-20'),(65147,1041,1,10,8,0,33,5.25,60,'2025-10-09',NULL,'2025-10-20','2025-10-20'),(65148,1041,1,10,8,0,33,5.25,60,'2025-10-10',NULL,'2025-10-20','2025-10-20'),(65149,1041,1,10,8,0,33,5.25,60,'2025-10-13',NULL,'2025-10-20','2025-10-20'),(65150,1041,1,10,8,0,33,5.25,60,'2025-10-14',NULL,'2025-10-20','2025-10-20'),(65151,1041,1,10,8,0,33,5.25,60,'2025-10-15',NULL,'2025-10-20','2025-10-20'),(65152,1041,1,10,8,0,33,5.25,60,'2025-10-16',NULL,'2025-10-20','2025-10-20'),(65153,1041,1,10,8,0,33,5.25,60,'2025-10-17',NULL,'2025-10-20','2025-10-20'),(65154,1041,1,10,8,0,33,5.25,60,'2025-10-20',NULL,'2025-10-20','2025-10-20'),(65155,1041,1,10,1,0,5,0.875,10,'2025-10-02',NULL,'2025-10-20','2025-10-20'),(65156,1041,1,10,1,0,5,0.6,10,'2025-10-03',NULL,'2025-10-20','2025-10-20'),(65157,1041,1,10,1,0,5,0.875,10,'2025-10-06',NULL,'2025-10-20','2025-10-20'),(65158,1041,1,10,1,0,5,0.875,10,'2025-10-07',NULL,'2025-10-20','2025-10-20'),(65159,1041,1,10,1,0,5,0.875,10,'2025-10-08',NULL,'2025-10-20','2025-10-20'),(65160,1041,1,10,1,0,5,0.875,10,'2025-10-10',NULL,'2025-10-20','2025-10-20'),(65161,1041,1,10,1,0,5,0.875,10,'2025-10-09',NULL,'2025-10-20','2025-10-20'),(65162,1041,1,10,1,0,5,0.875,10,'2025-10-13',NULL,'2025-10-20','2025-10-20'),(65163,1041,1,10,1,0,5,0.875,10,'2025-10-14',NULL,'2025-10-20','2025-10-20'),(65164,1041,1,10,1,0,5,0.875,10,'2025-10-15',NULL,'2025-10-20','2025-10-20'),(65165,1041,1,10,1,0,5,0.875,10,'2025-10-17',NULL,'2025-10-20','2025-10-20'),(65166,1041,1,10,1,0,5,0.875,10,'2025-10-16',NULL,'2025-10-20','2025-10-20'),(65167,1041,1,10,1,0,5,0.875,10,'2025-10-20',NULL,'2025-10-20','2025-10-20'),(65168,1041,1,10,1,0,5,0.875,10,'2025-10-01',NULL,'2025-10-20','2025-10-20'),(65169,1041,1,10,7,0,31,0.875,10,'2025-10-01',NULL,'2025-10-20','2025-10-20'),(65170,1041,1,10,7,0,31,0.875,10,'2025-10-02',NULL,'2025-10-20','2025-10-20'),(65171,1041,1,10,7,0,31,0.6,10,'2025-10-03',NULL,'2025-10-20','2025-10-20'),(65172,1041,1,10,7,0,31,0.875,10,'2025-10-06',NULL,'2025-10-20','2025-10-20'),(65173,1041,1,10,7,0,31,0.875,10,'2025-10-07',NULL,'2025-10-20','2025-10-20'),(65174,1041,1,10,7,0,31,0.875,10,'2025-10-08',NULL,'2025-10-20','2025-10-20'),(65175,1041,1,10,7,0,31,0.875,10,'2025-10-09',NULL,'2025-10-20','2025-10-20'),(65176,1041,1,10,7,0,31,0.875,10,'2025-10-10',NULL,'2025-10-20','2025-10-20'),(65177,1041,1,10,7,0,31,0.875,10,'2025-10-13',NULL,'2025-10-20','2025-10-20'),(65178,1041,1,10,7,0,31,0.875,10,'2025-10-14',NULL,'2025-10-20','2025-10-20'),(65179,1041,1,10,7,0,31,0.875,10,'2025-10-16',NULL,'2025-10-20','2025-10-20'),(65180,1041,1,10,7,0,31,0.875,10,'2025-10-15',NULL,'2025-10-20','2025-10-20'),(65181,1041,1,10,7,0,31,0.875,10,'2025-10-17',NULL,'2025-10-20','2025-10-20'),(65182,1041,1,10,7,0,31,0.875,10,'2025-10-20',NULL,'2025-10-20','2025-10-20'),(65183,1041,1,10,7,0,31,0.875,10,'2025-10-22',NULL,'2025-10-20','2025-10-20'),(65184,1041,1,10,7,0,31,0.875,10,'2025-10-23',NULL,'2025-10-20','2025-10-20'),(65185,1041,1,10,7,0,31,0.875,10,'2025-10-21',NULL,'2025-10-20','2025-10-20'),(65186,1041,1,10,7,0,31,0.875,10,'2025-10-24',NULL,'2025-10-20','2025-10-20'),(65187,1041,1,10,7,0,31,0.875,10,'2025-10-29',NULL,'2025-10-20','2025-10-20'),(65188,1041,1,10,7,0,31,0.875,10,'2025-10-27',NULL,'2025-10-20','2025-10-20'),(65189,1041,1,10,7,0,31,0.875,10,'2025-10-28',NULL,'2025-10-20','2025-10-20'),(65190,1041,1,10,7,0,31,0.875,10,'2025-10-30',NULL,'2025-10-20','2025-10-20'),(65191,1043,1,10,8,0,35,1.75,20,'2025-10-13','','2025-10-20','2025-10-20'),(65192,1043,1,10,1,0,5,3.5,40,'2025-10-13','','2025-10-20','2025-10-20'),(65193,1043,1,10,9,0,46,3.5,40,'2025-10-13','','2025-10-20','2025-10-20'),(65194,1043,1,10,9,0,46,4.375,50,'2025-10-20','','2025-10-20','2025-10-20'),(65195,1043,1,10,1,0,5,4.375,50,'2025-10-20','','2025-10-20','2025-10-20'),(65196,1043,1,10,9,0,46,4.375,50,'2025-10-27','','2025-10-20','2025-10-20'),(65197,1043,1,10,1,0,5,4.375,50,'2025-10-27','','2025-10-20','2025-10-20'),(65198,1011,1,10,1,0,5,8.75,100,'2025-10-13','','2025-10-20','2025-10-20'),(65199,1011,1,10,1,0,5,8.75,100,'2025-10-20','','2025-10-20','2025-10-20'),(65200,1074,1,10,7,0,128,8.75,100,'2025-09-22','','2025-10-20','2025-10-20'),(65201,1074,1,10,7,0,32,8.75,100,'2025-09-23','','2025-10-20','2025-10-20'),(65202,1074,1,10,18,0,152,8.75,100,'2025-09-24','','2025-10-20','2025-10-20'),(65203,1074,1,10,7,0,128,8.75,100,'2025-09-25','','2025-10-20','2025-10-20'),(65204,1074,1,10,7,0,26,6,100,'2025-09-26','','2025-10-20','2025-10-20'),(65205,1074,1,10,18,0,151,8.75,100,'2025-09-29','','2025-10-20','2025-10-20'),(65206,1074,1,10,7,0,131,8.75,100,'2025-09-30','','2025-10-20','2025-10-20'),(65207,1074,1,10,7,0,32,8.75,100,'2025-10-01','','2025-10-20','2025-10-20'),(65208,1074,1,10,7,0,32,8.75,100,'2025-10-02','','2025-10-20','2025-10-20'),(65209,1074,1,10,7,0,26,6,100,'2025-10-03','','2025-10-20','2025-10-20'),(65210,1074,1,10,7,0,131,8.75,100,'2025-10-06','','2025-10-20','2025-10-20'),(65211,1074,1,10,7,0,128,8.75,100,'2025-10-07','','2025-10-20','2025-10-20'),(65212,1074,1,10,7,0,131,8.75,100,'2025-10-08','','2025-10-20','2025-10-20'),(65213,1074,1,10,18,0,152,8.75,100,'2025-10-09','','2025-10-20','2025-10-20'),(65214,1074,1,10,7,0,128,8.75,100,'2025-10-10','','2025-10-20','2025-10-20'),(65215,1074,1,10,7,0,131,8.75,100,'2025-10-13','','2025-10-20','2025-10-20'),(65216,1074,1,10,7,0,26,8.75,100,'2025-10-14','','2025-10-20','2025-10-20'),(65217,1074,1,10,7,0,26,8.75,100,'2025-10-15','','2025-10-20','2025-10-20'),(65218,1074,1,10,7,0,131,8.75,100,'2025-10-16','','2025-10-20','2025-10-20'),(65219,1074,1,10,7,0,128,8.75,100,'2025-10-17','','2025-10-20','2025-10-20'),(65220,1074,1,10,18,0,154,4.375,50,'2025-10-20','','2025-10-20','2025-10-20'),(65221,1074,1,10,7,0,26,4.375,50,'2025-10-20','','2025-10-20','2025-10-20'),(65222,1012,1,10,18,0,153,0.875,10,'2025-10-20','','2025-10-20','2025-10-20'),(65223,1012,1,10,4,0,12,5.25,60,'2025-10-20','','2025-10-20','2025-10-20'),(65224,1012,1,10,4,0,14,2.625,30,'2025-10-20','','2025-10-20','2025-10-20'),(65225,1012,1,10,18,0,149,1.75,20,'2025-10-13','','2025-10-20','2025-10-20'),(65226,1012,1,10,4,0,12,5.25,60,'2025-10-13','','2025-10-20','2025-10-20'),(65227,1012,1,10,4,0,14,1.75,20,'2025-10-13','','2025-10-20','2025-10-20'),(65228,1040,1,10,6,0,107,8.75,100,'2025-10-13','','2025-10-20','2025-10-20'),(65229,1040,1,10,6,0,107,8.75,100,'2025-10-20','','2025-10-20','2025-10-20'),(65230,1040,1,10,6,0,107,8.75,100,'2025-10-27','','2025-10-20','2025-10-20'),(65231,1076,1,10,9,0,46,1.75,20,'2025-10-13','Reunión semanal de gerencia ','2025-10-21','2025-10-21'),(65232,1076,1,10,9,0,39,3.5,40,'2025-10-20','Acta','2025-10-21','2025-10-21'),(65233,1076,1,10,9,0,41,1.3125,15,'2025-10-20','Daily eje medición y KPI\'s','2025-10-21','2025-10-21'),(65234,1076,1,10,9,0,145,1.75,20,'2025-10-20','Reunión Construye 2025','2025-10-21','2025-10-21'),(65235,1076,1,10,9,0,41,2.1875,25,'2025-10-20','Metaverso','2025-10-21','2025-10-21'),(65236,1076,1,10,9,0,41,1.3125,15,'2025-10-13','Daily eje medición y KPI\'s','2025-10-21','2025-10-21'),(65237,1076,1,10,9,0,39,1.75,20,'2025-10-13','Capacitación Conecta','2025-10-21','2025-10-21'),(65238,1076,1,10,9,0,145,3.9375,45,'2025-10-13','Manual IPLC','2025-10-21','2025-10-21'),(65239,1076,1,10,9,0,46,1.3125,15,'2025-10-27','Reunión semanal de gerencia','2025-10-21','2025-10-21'),(65240,1076,1,10,9,0,41,1.3125,15,'2025-10-27','Daily eje medición y KPI','2025-10-21','2025-10-21'),(65241,1076,1,10,9,0,145,3.5,40,'2025-10-27','Revisión datos IPLC','2025-10-21','2025-10-21'),(65242,1076,1,10,9,0,145,2.625,30,'2025-10-27','Informes IPLC','2025-10-21','2025-10-21'),(65243,1072,1,10,7,0,131,7.875,90,'2025-10-13','BID','2025-10-21','2025-10-21'),(65244,1072,1,10,7,0,32,0.875,10,'2025-10-13','SA','2025-10-21','2025-10-21'),(65245,1072,1,10,18,0,153,1.3125,15,'2025-10-16','Reu','2025-10-21','2025-10-21'),(65246,1072,1,10,7,0,32,0.875,10,'2025-10-16','ENAMAC','2025-10-21','2025-10-21'),(65247,1072,1,10,7,0,25,1.3125,15,'2025-10-16','EECC','2025-10-21','2025-10-21'),(65248,1072,1,10,7,0,131,5.25,60,'2025-10-16','BID','2025-10-21','2025-10-21'),(65249,1072,1,10,7,0,131,8.75,100,'2025-10-17','BID','2025-10-21','2025-10-21'),(65250,1072,1,10,7,0,131,7.875,90,'2025-10-20','Gestión y coordinación gral','2025-10-21','2025-10-21'),(65251,1072,1,10,18,0,153,0.875,10,'2025-10-20','Reu interna','2025-10-21','2025-10-21'),(65252,1012,1,10,4,0,12,5.25,60,'2025-10-21','','2025-10-21','2025-10-21'),(65253,1012,1,10,18,0,148,0.875,10,'2025-10-21','','2025-10-21','2025-10-21'),(65254,1012,1,10,18,0,149,0.875,10,'2025-10-21','','2025-10-21','2025-10-21'),(65255,1012,1,10,4,0,14,1.75,20,'2025-10-21','','2025-10-21','2025-10-21'),(65256,1047,1,10,7,0,128,8.75,100,'2025-10-01','','2025-10-21','2025-10-21'),(65257,1047,1,10,7,0,128,8.75,100,'2025-10-02','','2025-10-21','2025-10-21'),(65259,1047,1,10,18,0,152,1.5,25,'2025-10-03','','2025-10-21','2025-10-21'),(65260,1047,1,10,18,0,154,1.5,25,'2025-10-03','','2025-10-21','2025-10-21'),(65261,1047,1,10,18,0,151,1.5,25,'2025-10-03','','2025-10-21','2025-10-21'),(65262,1047,1,10,7,0,32,1.5,25,'2025-10-03','','2025-10-21','2025-10-21'),(65263,1047,1,10,7,0,32,8.75,100,'2025-09-30','','2025-10-21','2025-10-21'),(65264,1047,1,10,7,0,31,1.75,20,'2025-09-22','','2025-10-21','2025-10-21'),(65265,1047,1,10,7,0,32,7,80,'2025-09-22','','2025-10-21','2025-10-21'),(65266,1047,1,10,7,0,32,4.375,50,'2025-09-23','','2025-10-21','2025-10-21'),(65267,1047,1,10,7,0,128,4.375,50,'2025-09-23','','2025-10-21','2025-10-21'),(65268,1047,1,10,18,0,152,1.75,20,'2025-09-24','','2025-10-21','2025-10-21'),(65269,1047,1,10,18,0,154,1.75,20,'2025-09-24','','2025-10-21','2025-10-21'),(65270,1047,1,10,18,0,151,1.75,20,'2025-09-24','','2025-10-21','2025-10-21'),(65271,1047,1,10,7,0,131,3.5,40,'2025-09-24','','2025-10-21','2025-10-21'),(65272,1047,1,10,7,0,128,8.75,100,'2025-09-25','','2025-10-21','2025-10-21'),(65273,1047,1,10,7,0,32,6,100,'2025-09-26','','2025-10-21','2025-10-21'),(65274,1047,1,10,7,0,31,1.75,20,'2025-09-29','','2025-10-21','2025-10-21'),(65275,1047,1,10,7,0,32,7,80,'2025-09-29','','2025-10-21','2025-10-21'),(65276,1047,1,10,7,0,131,2.625,30,'2025-10-06','','2025-10-21','2025-10-21'),(65277,1047,1,10,18,0,154,2.625,30,'2025-10-06','','2025-10-21','2025-10-21'),(65278,1047,1,10,7,0,32,3.5,40,'2025-10-06','','2025-10-21','2025-10-21'),(65279,1047,1,10,7,0,26,2.625,30,'2025-10-07','','2025-10-21','2025-10-21'),(65280,1047,1,10,7,0,111,4.375,50,'2025-10-07','','2025-10-21','2025-10-21'),(65281,1047,1,10,18,0,152,1.75,20,'2025-10-07','','2025-10-21','2025-10-21'),(65282,1047,1,10,7,0,31,1.75,20,'2025-10-08','','2025-10-21','2025-10-21'),(65283,1047,1,10,18,0,154,7,80,'2025-10-08','','2025-10-21','2025-10-21'),(65284,1047,1,10,7,0,26,3.5,40,'2025-10-09','','2025-10-21','2025-10-21'),(65285,1047,1,10,7,0,32,5.25,60,'2025-10-09','','2025-10-21','2025-10-21'),(65286,1047,1,10,7,0,25,2.625,30,'2025-10-10','','2025-10-21','2025-10-21'),(65287,1047,1,10,7,0,128,6.125,70,'2025-10-10','','2025-10-21','2025-10-21'),(65288,1047,1,10,7,0,128,4.375,50,'2025-10-13','','2025-10-21','2025-10-21'),(65289,1047,1,10,7,0,131,2.625,30,'2025-10-13','','2025-10-21','2025-10-21'),(65290,1047,1,10,18,0,152,1.75,20,'2025-10-13','','2025-10-21','2025-10-21'),(65291,1047,1,10,9,0,45,1.75,20,'2025-10-14','','2025-10-21','2025-10-21'),(65292,1047,1,10,7,0,128,7,80,'2025-10-14','','2025-10-21','2025-10-21'),(65293,1047,1,10,7,0,25,2.625,30,'2025-10-15','','2025-10-21','2025-10-21'),(65294,1047,1,10,7,0,128,6.125,70,'2025-10-15','','2025-10-21','2025-10-21'),(65295,1047,1,10,7,0,32,2.625,30,'2025-10-16','','2025-10-21','2025-10-21'),(65296,1047,1,10,18,0,151,0.875,10,'2025-10-16','','2025-10-21','2025-10-21'),(65297,1047,1,10,18,0,154,0.875,10,'2025-10-16','','2025-10-21','2025-10-21'),(65298,1047,1,10,18,0,152,0.875,10,'2025-10-16','','2025-10-21','2025-10-21'),(65299,1047,1,10,7,0,128,3.5,40,'2025-10-16','','2025-10-21','2025-10-21'),(65300,1047,1,10,7,0,31,1.75,20,'2025-10-17','','2025-10-21','2025-10-21'),(65301,1047,1,10,7,0,128,7,80,'2025-10-17','','2025-10-21','2025-10-21'),(65302,1047,1,10,18,0,153,1.75,20,'2025-10-20','','2025-10-21','2025-10-21'),(65303,1047,1,10,7,0,26,2.625,30,'2025-10-20','','2025-10-21','2025-10-21'),(65304,1047,1,10,7,0,128,4.375,50,'2025-10-20','','2025-10-21','2025-10-21'),(65305,1047,1,10,7,0,131,0.875,10,'2025-10-21','','2025-10-21','2025-10-21'),(65306,1047,1,10,18,0,152,0.875,10,'2025-10-21','','2025-10-21','2025-10-21'),(65307,1047,1,10,7,0,128,7,80,'2025-10-21','','2025-10-21','2025-10-21'),(65308,1047,1,10,18,0,154,4.375,50,'2025-10-22','','2025-10-21','2025-10-21'),(65309,1047,1,10,7,0,131,2.625,30,'2025-10-22','','2025-10-21','2025-10-21'),(65310,1047,1,10,7,0,128,1.75,20,'2025-10-22','','2025-10-21','2025-10-21'),(65311,1060,1,10,7,0,32,0.875,10,'2025-10-13','Reunión S&I','2025-10-22','2025-10-22'),(65312,1060,1,10,7,0,26,2.625,30,'2025-10-13','Check list entidades APL','2025-10-22','2025-10-22'),(65313,1060,1,10,7,0,112,0.875,10,'2025-10-13','Reu coordinación CZ','2025-10-22','2025-10-22'),(65314,1060,1,10,7,0,26,2.625,30,'2025-10-13','Corrección informes cuantificación APL','2025-10-22','2025-10-22'),(65315,1060,1,10,7,0,32,1.75,20,'2025-10-13','Reu CDT Sostenibilidad Ambiental','2025-10-22','2025-10-22'),(65316,1060,1,10,7,0,26,2.1875,25,'2025-10-20','Postulación certificación APL','2025-10-22','2025-10-22'),(65317,1060,1,10,7,0,26,2.1875,25,'2025-10-20','Reporte facturación APL Puerto Montt','2025-10-22','2025-10-22'),(65318,1060,1,10,7,0,26,1.3125,15,'2025-10-20','Reu Magallanes APL','2025-10-22','2025-10-22'),(65319,1060,1,10,7,0,26,1.3125,15,'2025-10-20','Reu RVC Antofagasta','2025-10-22','2025-10-22'),(65320,1060,1,10,7,0,26,0.875,10,'2025-10-20','Cierre mesa PP Magallanes','2025-10-22','2025-10-22'),(65321,1060,1,10,7,0,112,0.875,10,'2025-10-20','Coordinación CZ','2025-10-22','2025-10-22'),(65322,1012,5,10,4,0,14,0.875,10,'2025-10-22','Pitch CDT','2025-10-22','2025-10-22'),(65323,1012,1,10,4,0,12,5.25,60,'2025-10-22','','2025-10-22','2025-10-22'),(65324,1012,1,10,4,0,14,1.75,20,'2025-10-22','','2025-10-22','2025-10-22'),(65325,1012,1,10,18,0,149,0.875,10,'2025-10-22','','2025-10-22','2025-10-22'),(65326,1011,1,10,1,0,5,8.75,100,'2025-10-21',NULL,'2025-10-23','2025-10-23'),(65327,1011,1,10,1,0,5,8.75,100,'2025-10-23',NULL,'2025-10-23','2025-10-23'),(65328,1011,1,10,1,0,5,8.75,100,'2025-10-22',NULL,'2025-10-23','2025-10-23'),(65329,1027,1,10,1,0,5,8.75,100,'2025-10-13','','2025-10-23','2025-10-23'),(65330,1027,1,10,1,0,5,8.75,100,'2025-10-24',NULL,'2025-10-23','2025-10-23'),(65331,1027,1,10,1,0,5,8.75,100,'2025-10-23',NULL,'2025-10-23','2025-10-23'),(65332,1027,1,10,1,0,5,8.75,100,'2025-10-28',NULL,'2025-10-23','2025-10-23'),(65333,1027,1,10,1,0,5,8.75,100,'2025-10-27',NULL,'2025-10-23','2025-10-23'),(65334,1027,1,10,1,0,5,8.75,100,'2025-10-30',NULL,'2025-10-23','2025-10-23'),(65335,1027,1,10,1,0,5,8.75,100,'2025-10-29',NULL,'2025-10-23','2025-10-23'),(65336,1012,1,10,7,0,111,4.375,50,'2025-10-23','Cierre Construye Zero','2025-10-23','2025-10-23'),(65337,1012,1,10,4,0,12,2.625,30,'2025-10-23','','2025-10-23','2025-10-23'),(65338,1012,1,10,4,0,14,1.75,20,'2025-10-23','','2025-10-23','2025-10-23'),(65339,1012,5,10,4,0,14,5.25,60,'2025-10-24','Academia CDT','2025-10-23','2025-10-23'),(65340,1012,1,10,4,0,12,3.5,40,'2025-10-24','','2025-10-23','2025-10-23'),(65341,1072,1,10,7,0,131,7.875,90,'2025-10-21','','2025-10-23','2025-10-23'),(65342,1072,1,10,7,0,25,0.875,10,'2025-10-21','','2025-10-23','2025-10-23'),(65343,1072,1,10,7,0,25,0.875,10,'2025-10-22','','2025-10-23','2025-10-23'),(65344,1072,1,10,7,0,131,4.375,50,'2025-10-22','','2025-10-23','2025-10-23'),(65345,1072,1,10,7,0,32,3.5,40,'2025-10-22','+Circular','2025-10-23','2025-10-23'),(65346,1072,1,10,7,0,32,4.375,50,'2025-10-23','CTEC','2025-10-23','2025-10-23'),(65347,1072,1,10,7,0,131,4.375,50,'2025-10-23','','2025-10-23','2025-10-23'),(65348,1072,1,10,7,0,131,8.75,100,'2025-10-24','','2025-10-23','2025-10-23'),(65349,1011,1,10,1,0,5,8.75,100,'2025-10-24','','2025-10-24','2025-10-24'),(65350,1060,1,10,7,0,26,1.3125,15,'2025-10-21','Reporte financiero Punta Arenas','2025-10-24','2025-10-24'),(65351,1060,1,10,7,0,26,1.3125,15,'2025-10-21','Reu BBPP Los Lagos','2025-10-24','2025-10-24'),(65352,1060,1,10,7,0,26,4.375,50,'2025-10-21','Postulaciones APL','2025-10-24','2025-10-24'),(65353,1060,1,10,7,0,26,1.75,20,'2025-10-21','Reu auditorías finales','2025-10-24','2025-10-24'),(65354,1060,1,10,7,0,26,3.0625,35,'2025-10-22','Revisión acciones empresas APL','2025-10-24','2025-10-24'),(65355,1060,1,10,18,0,154,1.3125,15,'2025-10-22','Reunión + Circular','2025-10-24','2025-10-24'),(65356,1060,1,10,18,0,154,4.375,50,'2025-10-22','2da sesión + circular','2025-10-24','2025-10-24'),(65357,1060,1,10,7,0,32,4.375,50,'2025-10-23','MDI APL RM','2025-10-24','2025-10-24'),(65358,1060,1,10,7,0,26,2.625,30,'2025-10-23','Correos empresas APL ','2025-10-24','2025-10-24'),(65359,1060,1,10,18,0,154,1.75,20,'2025-10-23','Reu + Circular','2025-10-24','2025-10-24'),(65360,1060,1,10,7,0,32,3.5,40,'2025-10-24','APL RM','2025-10-24','2025-10-24'),(65361,1060,1,10,18,0,151,1.75,20,'2025-10-24','reu dashboard ambiental','2025-10-24','2025-10-24'),(65362,1060,1,10,7,0,26,3.5,40,'2025-10-24','Planilla indicadores APL','2025-10-24','2025-10-24'),(65363,1057,1,10,1,0,5,8.75,100,'2025-10-21',NULL,'2025-10-24','2025-10-24'),(65364,1057,1,10,1,0,5,8.75,100,'2025-10-23',NULL,'2025-10-24','2025-10-24'),(65365,1057,1,10,1,0,5,8.75,100,'2025-10-22',NULL,'2025-10-24','2025-10-24'),(65366,1057,1,10,1,0,5,8.75,100,'2025-10-24',NULL,'2025-10-24','2025-10-24'),(65367,1075,1,10,8,0,35,8.75,100,'2025-10-21',NULL,'2025-10-24','2025-10-24'),(65368,1075,1,10,8,0,35,8.75,100,'2025-10-23',NULL,'2025-10-24','2025-10-24'),(65369,1075,1,10,8,0,35,8.75,100,'2025-10-22',NULL,'2025-10-24','2025-10-24'),(65370,1075,1,10,8,0,35,8.75,100,'2025-10-24',NULL,'2025-10-24','2025-10-24'),(65371,1012,5,10,4,0,14,0.875,10,'2025-10-27','Coordinación CDT','2025-10-28','2025-10-28'),(65372,1012,1,10,4,0,12,5.25,60,'2025-10-27','','2025-10-28','2025-10-28'),(65373,1012,1,10,6,0,107,0.875,10,'2025-10-27','','2025-10-28','2025-10-28'),(65374,1012,1,10,4,0,14,1.75,20,'2025-10-27','','2025-10-28','2025-10-28'),(65375,1012,1,10,4,0,14,4.375,50,'2025-10-28','','2025-10-28','2025-10-28'),(65376,1012,1,10,4,0,12,4.375,50,'2025-10-28','','2025-10-28','2025-10-28'),(65377,1027,1,10,1,0,5,8.75,100,'2025-10-17',NULL,'2025-10-28','2025-10-28'),(65378,1027,1,10,1,0,5,8.75,100,'2025-10-21',NULL,'2025-10-28','2025-10-28'),(65379,1027,1,10,1,0,5,8.75,100,'2025-10-20',NULL,'2025-10-28','2025-10-28'),(65380,1027,1,10,1,0,5,8.75,100,'2025-10-22',NULL,'2025-10-28','2025-10-28'),(65381,1012,5,10,1,0,9,2.625,30,'2025-10-29','Recepción y mini charla sobre CDT a Estudiantes de Colegios Coreduc','2025-10-29','2025-10-29'),(65382,1012,1,10,4,0,12,5.25,60,'2025-10-29','','2025-10-29','2025-10-29'),(65383,1012,1,10,4,0,14,0.875,10,'2025-10-29','','2025-10-29','2025-10-29'),(65384,1057,1,10,1,0,5,8.75,100,'2025-10-27',NULL,'2025-10-29','2025-10-29'),(65385,1057,1,10,1,0,5,8.75,100,'2025-10-29',NULL,'2025-10-29','2025-10-29'),(65386,1057,1,10,1,0,5,8.75,100,'2025-10-28',NULL,'2025-10-29','2025-10-29'),(65387,1075,1,10,8,0,35,8.75,100,'2025-10-27',NULL,'2025-10-29','2025-10-29'),(65388,1075,1,10,8,0,35,8.75,100,'2025-10-28',NULL,'2025-10-29','2025-10-29'),(65389,1075,1,10,8,0,35,8.75,100,'2025-10-29',NULL,'2025-10-29','2025-10-29'),(65390,1075,1,10,8,0,35,8.75,100,'2025-10-30',NULL,'2025-10-29','2025-10-29'),(65391,1012,1,10,18,0,153,0.875,10,'2025-10-30','','2025-10-30','2025-10-30'),(65392,1012,1,10,4,0,14,2.625,30,'2025-10-30','','2025-10-30','2025-10-30'),(65393,1012,1,10,4,0,12,5.25,60,'2025-10-30','','2025-10-30','2025-10-30'),(65394,1041,1,10,9,0,45,0.875,10,'2025-10-02',NULL,'2025-10-30','2025-10-30'),(65395,1041,1,10,9,0,45,0.875,10,'2025-10-01',NULL,'2025-10-30','2025-10-30'),(65396,1041,1,10,9,0,45,0.6,10,'2025-10-03',NULL,'2025-10-30','2025-10-30'),(65397,1041,1,10,9,0,45,0.875,10,'2025-10-06',NULL,'2025-10-30','2025-10-30'),(65398,1041,1,10,9,0,45,0.875,10,'2025-10-07',NULL,'2025-10-30','2025-10-30'),(65399,1041,1,10,9,0,45,0.875,10,'2025-10-08',NULL,'2025-10-30','2025-10-30'),(65400,1041,1,10,9,0,45,0.875,10,'2025-10-09',NULL,'2025-10-30','2025-10-30'),(65401,1041,1,10,9,0,45,0.875,10,'2025-10-10',NULL,'2025-10-30','2025-10-30'),(65402,1041,1,10,9,0,45,0.875,10,'2025-10-13',NULL,'2025-10-30','2025-10-30'),(65403,1041,1,10,9,0,45,0.875,10,'2025-10-14',NULL,'2025-10-30','2025-10-30'),(65404,1041,1,10,9,0,45,0.875,10,'2025-10-15',NULL,'2025-10-30','2025-10-30'),(65405,1041,1,10,9,0,45,0.875,10,'2025-10-16',NULL,'2025-10-30','2025-10-30'),(65406,1041,1,10,9,0,45,0.875,10,'2025-10-17',NULL,'2025-10-30','2025-10-30'),(65407,1041,1,10,9,0,45,0.875,10,'2025-10-20',NULL,'2025-10-30','2025-10-30'),(65408,1041,1,10,9,0,45,0.875,10,'2025-10-21',NULL,'2025-10-30','2025-10-30'),(65409,1041,1,10,9,0,45,0.875,10,'2025-10-22',NULL,'2025-10-30','2025-10-30'),(65410,1041,1,10,9,0,45,0.875,10,'2025-10-23',NULL,'2025-10-30','2025-10-30'),(65411,1041,1,10,9,0,45,0.875,10,'2025-10-24',NULL,'2025-10-30','2025-10-30'),(65412,1041,1,10,9,0,45,0.875,10,'2025-10-27',NULL,'2025-10-30','2025-10-30'),(65413,1041,1,10,9,0,45,0.875,10,'2025-10-28',NULL,'2025-10-30','2025-10-30'),(65414,1041,1,10,9,0,45,0.875,10,'2025-10-30',NULL,'2025-10-30','2025-10-30'),(65415,1041,1,10,9,0,45,0.875,10,'2025-10-29',NULL,'2025-10-30','2025-10-30'),(65416,1041,1,10,8,0,33,5.25,60,'2025-10-22',NULL,'2025-10-30','2025-10-30'),(65417,1041,1,10,8,0,33,5.25,60,'2025-10-24',NULL,'2025-10-30','2025-10-30'),(65418,1041,1,10,8,0,33,5.25,60,'2025-10-23',NULL,'2025-10-30','2025-10-30'),(65419,1041,1,10,8,0,33,5.25,60,'2025-10-27',NULL,'2025-10-30','2025-10-30'),(65420,1041,1,10,8,0,33,5.25,60,'2025-10-28',NULL,'2025-10-30','2025-10-30'),(65421,1041,1,10,8,0,33,5.25,60,'2025-10-29',NULL,'2025-10-30','2025-10-30'),(65422,1041,1,10,8,0,33,5.25,60,'2025-10-30',NULL,'2025-10-30','2025-10-30'),(65423,1041,1,10,8,0,33,5.25,60,'2025-10-21',NULL,'2025-10-30','2025-10-30'),(65424,1057,1,10,1,0,5,8.75,100,'2025-10-30','','2025-10-30','2025-10-30'),(65425,1025,5,10,1,0,5,8.75,100,'2025-10-28','ISPIC DAY Concepción','2025-11-03','2025-11-03'),(65426,1025,5,10,1,0,5,1.75,20,'2025-10-27','Reunión semana Gerencia Desarrollo Empresarial CChC','2025-11-03','2025-11-03'),(65427,1025,5,10,1,0,5,2.625,30,'2025-10-27','Coordinación CDT','2025-11-03','2025-11-03'),(65428,1025,5,10,1,0,5,4.375,50,'2025-10-27','Actividades Concepción','2025-11-03','2025-11-03'),(65429,1012,5,10,4,0,14,0.875,10,'2025-11-03','Coordinación CDT','2025-11-03','2025-11-03'),(65430,1012,1,10,4,0,14,2.625,30,'2025-11-03','','2025-11-03','2025-11-03'),(65431,1012,1,10,4,0,12,5.25,60,'2025-11-03','','2025-11-03','2025-11-03'),(65432,1012,1,10,4,0,12,4.375,50,'2025-11-04','','2025-11-04','2025-11-04'),(65433,1012,1,10,6,0,107,0.875,10,'2025-11-04','','2025-11-04','2025-11-04'),(65434,1012,1,10,18,0,149,0.875,10,'2025-11-04','','2025-11-04','2025-11-04'),(65435,1012,1,10,4,0,14,2.625,30,'2025-11-04','','2025-11-04','2025-11-04'),(65436,1012,1,10,9,0,45,4.375,50,'2025-11-05','','2025-11-05','2025-11-05'),(65437,1012,1,10,9,0,45,3.5,40,'2025-11-05','','2025-11-05','2025-11-05'),(65438,1012,1,10,4,0,14,0.875,10,'2025-11-05','','2025-11-05','2025-11-05'),(65439,1012,1,10,4,0,12,5.25,60,'2025-11-06','','2025-11-06','2025-11-06'),(65440,1012,1,10,6,0,107,3.5,40,'2025-11-06','','2025-11-06','2025-11-06');

--
-- Table structure for table `tipo_tiempos`
--

CREATE TABLE `tipo_tiempos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(150) NOT NULL,
  `descripcion` text DEFAULT '',
  `color` varchar(50) DEFAULT '',
  `createdAt` date NOT NULL,
  `updatedAt` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `tipo_tiempos`
--

INSERT INTO `tipo_tiempos` VALUES (1,'Gestión Operativa','','#021cde','2020-07-24','2020-10-22'),(2,'Gestión Comercial','','#01b71f','2020-07-24','2020-10-22'),(3,'Aporte Sectorial','','#04cedc','2020-07-24','2020-10-22'),(4,'Administrativo y Financiero','','#ebdc05','2020-07-24','2020-10-22'),(5,'Corporativo','','#fa0000','2020-07-24','2020-10-22'),(8,'Vacaciones / Permisos / Licencias ','vacaciones','#018e1d','2021-01-04','2021-01-14');

--
-- Table structure for table `usuario_centro_costos`
--

CREATE TABLE `usuario_centro_costos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuario` int(11) NOT NULL,
  `centroCosto` int(11) NOT NULL,
  `createdAt` date NOT NULL,
  `updatedAt` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `usuario` (`usuario`),
  KEY `centroCosto` (`centroCosto`),
  CONSTRAINT `usuario_centro_costos_ibfk_1` FOREIGN KEY (`centroCosto`) REFERENCES `centro_costos` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `usuario_centro_costos_ibfk_2` FOREIGN KEY (`usuario`) REFERENCES `usuarios` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=456 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `usuario_centro_costos`
--

INSERT INTO `usuario_centro_costos` VALUES (5,1028,270,'2020-08-07','2020-08-07'),(9,1028,172,'2020-08-11','2020-08-11'),(10,1028,312,'2020-08-11','2020-08-11'),(11,1028,314,'2020-08-11','2020-08-11'),(12,1028,316,'2020-08-11','2020-08-11'),(13,1028,317,'2020-08-11','2020-08-11'),(15,1028,323,'2020-08-11','2020-08-11'),(16,1028,324,'2020-08-11','2020-08-11'),(17,1028,327,'2020-08-11','2020-08-11'),(20,1005,103,'2020-08-11','2020-08-11'),(21,1005,179,'2020-08-11','2020-08-11'),(23,1046,270,'2020-08-12','2020-08-12'),(24,1046,312,'2020-08-12','2020-08-12'),(25,1046,314,'2020-08-12','2020-08-12'),(26,1046,316,'2020-08-12','2020-08-12'),(27,1046,317,'2020-08-12','2020-08-12'),(28,1046,319,'2020-08-12','2020-08-12'),(29,1046,323,'2020-08-12','2020-08-12'),(30,1046,324,'2020-08-12','2020-08-12'),(31,1046,327,'2020-08-12','2020-08-12'),(35,1047,316,'2020-08-12','2020-08-12'),(42,1048,312,'2020-08-12','2020-08-12'),(43,1048,314,'2020-08-12','2020-08-12'),(44,1048,316,'2020-08-12','2020-08-12'),(46,1048,319,'2020-08-12','2020-08-12'),(49,1048,327,'2020-08-12','2020-08-12'),(60,1035,333,'2020-08-12','2020-08-12'),(61,1035,334,'2020-08-12','2020-08-12'),(62,1035,335,'2020-08-12','2020-08-12'),(63,1035,336,'2020-08-12','2020-08-12'),(64,1035,337,'2020-08-12','2020-08-12'),(65,1035,342,'2020-08-12','2020-08-12'),(66,1037,333,'2020-08-12','2020-08-12'),(67,1037,334,'2020-08-12','2020-08-12'),(68,1037,338,'2020-08-12','2020-08-12'),(70,1037,277,'2020-08-12','2020-08-12'),(71,1035,172,'2020-08-12','2020-08-12'),(73,1001,103,'2020-08-12','2020-08-12'),(74,1027,103,'2020-08-12','2020-08-12'),(75,1029,103,'2020-08-12','2020-08-12'),(76,1002,114,'2020-08-12','2020-08-12'),(77,1004,103,'2020-08-12','2020-08-12'),(79,1006,114,'2020-08-12','2020-08-12'),(80,1007,103,'2020-08-12','2020-08-12'),(82,1008,103,'2020-08-12','2020-08-12'),(83,1009,103,'2020-08-12','2020-08-12'),(84,1010,103,'2020-08-12','2020-08-12'),(85,1011,103,'2020-08-12','2020-08-12'),(86,1029,171,'2020-08-12','2020-08-12'),(87,1029,172,'2020-08-12','2020-08-12'),(88,1029,179,'2020-08-12','2020-08-12'),(92,1025,138,'2020-08-12','2020-08-12'),(93,1025,139,'2020-08-12','2020-08-12'),(94,1025,140,'2020-08-12','2020-08-12'),(95,1025,141,'2020-08-12','2020-08-12'),(96,1025,144,'2020-08-12','2020-08-12'),(97,1025,147,'2020-08-12','2020-08-12'),(98,1025,171,'2020-08-12','2020-08-12'),(99,1025,172,'2020-08-12','2020-08-12'),(100,1025,177,'2020-08-12','2020-08-12'),(101,1025,179,'2020-08-12','2020-08-12'),(102,1025,183,'2020-08-12','2020-08-12'),(103,1025,255,'2020-08-12','2020-08-12'),(106,1025,331,'2020-08-12','2020-08-12'),(108,1031,147,'2020-08-12','2020-08-12'),(109,1031,148,'2020-08-12','2020-08-12'),(110,1031,149,'2020-08-12','2020-08-12'),(111,1031,150,'2020-08-12','2020-08-12'),(112,1031,152,'2020-08-12','2020-08-12'),(113,1031,154,'2020-08-12','2020-08-12'),(114,1031,155,'2020-08-12','2020-08-12'),(115,1031,156,'2020-08-12','2020-08-12'),(116,1031,157,'2020-08-12','2020-08-12'),(117,1031,159,'2020-08-12','2020-08-12'),(118,1031,160,'2020-08-12','2020-08-12'),(119,1032,139,'2020-08-12','2020-08-12'),(120,1034,147,'2020-08-12','2020-08-12'),(121,1034,148,'2020-08-12','2020-08-12'),(122,1034,149,'2020-08-12','2020-08-12'),(125,1034,154,'2020-08-12','2020-08-12'),(126,1034,155,'2020-08-12','2020-08-12'),(127,1034,156,'2020-08-12','2020-08-12'),(128,1034,157,'2020-08-12','2020-08-12'),(129,1034,159,'2020-08-12','2020-08-12'),(130,1034,160,'2020-08-12','2020-08-12'),(131,1036,138,'2020-08-12','2020-08-12'),(132,1036,140,'2020-08-12','2020-08-12'),(133,1036,141,'2020-08-12','2020-08-12'),(145,1040,144,'2020-08-12','2020-08-12'),(146,1040,171,'2020-08-12','2020-08-12'),(147,1040,172,'2020-08-12','2020-08-12'),(148,1040,174,'2020-08-12','2020-08-12'),(150,1042,147,'2020-08-12','2020-08-12'),(151,1042,148,'2020-08-12','2020-08-12'),(152,1042,149,'2020-08-12','2020-08-12'),(153,1042,150,'2020-08-12','2020-08-12'),(154,1042,152,'2020-08-12','2020-08-12'),(155,1042,154,'2020-08-12','2020-08-12'),(156,1042,155,'2020-08-12','2020-08-12'),(157,1042,156,'2020-08-12','2020-08-12'),(158,1042,157,'2020-08-12','2020-08-12'),(159,1042,159,'2020-08-12','2020-08-12'),(160,1042,160,'2020-08-12','2020-08-12'),(161,1043,138,'2020-08-12','2020-08-12'),(162,1043,139,'2020-08-12','2020-08-12'),(163,1043,140,'2020-08-12','2020-08-12'),(164,1043,141,'2020-08-12','2020-08-12'),(165,1043,144,'2020-08-12','2020-08-12'),(166,1043,183,'2020-08-12','2020-08-12'),(168,1039,144,'2020-08-12','2020-08-12'),(169,1039,177,'2020-08-12','2020-08-12'),(170,1045,147,'2020-08-12','2020-08-12'),(171,1045,148,'2020-08-12','2020-08-12'),(172,1045,149,'2020-08-12','2020-08-12'),(173,1045,150,'2020-08-12','2020-08-12'),(174,1045,152,'2020-08-12','2020-08-12'),(175,1045,154,'2020-08-12','2020-08-12'),(176,1045,155,'2020-08-12','2020-08-12'),(177,1045,156,'2020-08-12','2020-08-12'),(178,1045,157,'2020-08-12','2020-08-12'),(179,1045,159,'2020-08-12','2020-08-12'),(180,1045,160,'2020-08-12','2020-08-12'),(181,1012,118,'2020-08-12','2020-08-12'),(182,1012,125,'2020-08-12','2020-08-12'),(183,1012,192,'2020-08-12','2020-08-12'),(184,1012,179,'2020-08-12','2020-08-12'),(186,1013,125,'2020-08-12','2020-08-12'),(187,1013,179,'2020-08-12','2020-08-12'),(188,1013,118,'2020-08-12','2020-08-12'),(189,1013,251,'2020-08-12','2020-08-12'),(193,1017,213,'2020-08-12','2020-08-12'),(194,1018,192,'2020-08-12','2020-08-12'),(197,1030,118,'2020-08-12','2020-08-12'),(198,1030,125,'2020-08-12','2020-08-12'),(199,1030,192,'2020-08-12','2020-08-12'),(200,1030,213,'2020-08-12','2020-08-12'),(201,1030,251,'2020-08-12','2020-08-12'),(202,1030,179,'2020-08-12','2020-08-12'),(203,1030,272,'2020-08-12','2020-08-12'),(204,1020,125,'2020-08-12','2020-08-12'),(205,1020,192,'2020-08-12','2020-08-12'),(206,1021,125,'2020-08-12','2020-08-12'),(207,1021,192,'2020-08-12','2020-08-12'),(208,1022,118,'2020-08-12','2020-08-12'),(209,1022,125,'2020-08-12','2020-08-12'),(210,1023,125,'2020-08-12','2020-08-12'),(211,1023,192,'2020-08-12','2020-08-12'),(212,1023,213,'2020-08-12','2020-08-12'),(213,1024,118,'2020-08-12','2020-08-12'),(214,1,270,'2020-08-13','2020-08-13'),(215,1,322,'2020-08-13','2020-08-13'),(223,1028,319,'2020-08-31','2020-08-31'),(224,1028,313,'2020-09-03','2020-09-03'),(225,1028,314,'2020-09-03','2020-09-03'),(226,1028,319,'2020-09-09','2020-09-09'),(227,1028,173,'2020-09-10','2020-09-10'),(228,1028,343,'2020-09-10','2020-09-10'),(229,1046,343,'2020-09-10','2020-09-10'),(230,1028,158,'2020-09-24','2020-09-24'),(231,1028,344,'2020-09-24','2020-09-24'),(232,1046,344,'2020-09-24','2020-09-24'),(233,1046,158,'2020-09-24','2020-09-24'),(235,1047,137,'2020-10-19','2020-10-19'),(237,1048,172,'2020-10-19','2020-10-19'),(238,1048,173,'2020-10-19','2020-10-19'),(239,1048,313,'2020-10-19','2020-10-19'),(240,1048,315,'2020-10-19','2020-10-19'),(242,1048,343,'2020-10-19','2020-10-19'),(245,1047,328,'2020-10-19','2020-10-19'),(246,1047,172,'2020-10-19','2020-10-19'),(247,1047,313,'2020-10-19','2020-10-19'),(248,1046,313,'2020-10-19','2020-10-19'),(249,1046,315,'2020-10-19','2020-10-19'),(250,1046,318,'2020-10-19','2020-10-19'),(251,1,315,'2020-10-20','2020-10-20'),(252,1,345,'2020-10-27','2020-10-27'),(256,1,338,'2020-11-02','2020-11-02'),(257,1,318,'2020-11-02','2020-11-02'),(259,1004,106,'2020-11-09','2020-11-09'),(261,1050,103,'2020-11-10','2020-11-10'),(262,1004,107,'2020-11-13','2020-11-13'),(263,1011,112,'2020-11-13','2020-11-13'),(264,1010,112,'2020-11-13','2020-11-13'),(265,1009,112,'2020-11-13','2020-11-13'),(266,1008,112,'2020-11-13','2020-11-13'),(267,1004,112,'2020-11-13','2020-11-13'),(268,1041,184,'2020-11-16','2020-11-16'),(269,1047,173,'2020-11-16','2020-11-16'),(272,1006,107,'2020-11-17','2020-11-17'),(273,1006,116,'2020-11-17','2020-11-17'),(274,1006,103,'2020-11-17','2020-11-17'),(275,1002,107,'2020-11-17','2020-11-17'),(276,1002,116,'2020-11-17','2020-11-17'),(277,1027,106,'2020-11-17','2020-11-17'),(278,1027,107,'2020-11-17','2020-11-17'),(279,1027,109,'2020-11-17','2020-11-17'),(280,1027,112,'2020-11-17','2020-11-17'),(281,1027,114,'2020-11-17','2020-11-17'),(282,1009,107,'2020-11-17','2020-11-17'),(283,1048,333,'2020-11-17','2020-11-17'),(284,1048,274,'2020-11-17','2020-11-17'),(285,1048,268,'2020-11-17','2020-11-17'),(287,1028,309,'2020-11-19','2020-11-19'),(288,1028,333,'2020-11-19','2020-11-19'),(289,1028,346,'2020-11-19','2020-11-19'),(290,1028,338,'2020-11-19','2020-11-19'),(291,1034,150,'2020-11-23','2020-11-23'),(292,1034,152,'2020-11-23','2020-11-23'),(293,1034,344,'2020-11-23','2020-11-23'),(294,1034,347,'2020-11-23','2020-11-23'),(295,1034,348,'2020-11-23','2020-11-23'),(296,1034,349,'2020-11-23','2020-11-23'),(297,1037,350,'2020-11-24','2020-11-24'),(298,1037,351,'2020-11-24','2020-11-24'),(299,1035,346,'2020-11-24','2020-11-24'),(301,1042,347,'2020-11-30','2020-11-30'),(302,1042,344,'2020-11-30','2020-11-30'),(303,1042,349,'2020-11-30','2020-11-30'),(304,1042,348,'2020-11-30','2020-11-30'),(305,1031,347,'2020-11-30','2020-11-30'),(306,1031,344,'2020-11-30','2020-11-30'),(307,1031,348,'2020-11-30','2020-11-30'),(309,1045,347,'2020-11-30','2020-11-30'),(310,1045,344,'2020-11-30','2020-11-30'),(311,1045,348,'2020-11-30','2020-11-30'),(312,1045,349,'2020-11-30','2020-11-30'),(313,1051,138,'2020-11-30','2020-11-30'),(314,1051,137,'2020-11-30','2020-11-30'),(315,1051,172,'2020-11-30','2020-11-30'),(316,1040,169,'2020-11-30','2020-11-30'),(317,1041,137,'2020-12-02','2020-12-02'),(318,1041,344,'2020-12-02','2020-12-02'),(319,1041,183,'2020-12-15','2020-12-15'),(321,1041,379,'2020-12-16','2020-12-16'),(322,1043,177,'2020-12-21','2020-12-21'),(323,1005,109,'2021-01-08','2021-01-08'),(324,1008,107,'2021-01-08','2021-01-08'),(325,1005,116,'2021-01-08','2021-01-08'),(326,1039,169,'2021-01-11','2021-01-11'),(327,1004,382,'2021-01-12','2021-01-12'),(328,1011,382,'2021-01-12','2021-01-12'),(329,1011,381,'2021-01-12','2021-01-12'),(330,1050,381,'2021-01-13','2021-01-13'),(331,1050,382,'2021-01-13','2021-01-13'),(332,1027,381,'2021-01-29','2021-01-29'),(333,1027,116,'2021-01-29','2021-01-29'),(334,1027,382,'2021-01-29','2021-01-29'),(335,1006,382,'2021-01-29','2021-01-29'),(336,1002,382,'2021-01-29','2021-01-29'),(337,1010,382,'2021-01-29','2021-01-29'),(339,1010,107,'2021-01-29','2021-01-29'),(340,1010,116,'2021-01-29','2021-01-29'),(341,1041,173,'2021-01-29','2021-01-29'),(342,1041,384,'2021-01-29','2021-01-29'),(343,1028,365,'2021-01-29','2021-01-29'),(344,1028,366,'2021-01-29','2021-01-29'),(345,1028,367,'2021-01-29','2021-01-29'),(346,1047,254,'2021-02-02','2021-02-02'),(347,1047,384,'2021-02-02','2021-02-02'),(348,1047,255,'2021-02-02','2021-02-02'),(349,1053,159,'2021-02-17','2021-02-17'),(350,1053,157,'2021-02-17','2021-02-17'),(351,1053,156,'2021-02-17','2021-02-17'),(352,1053,155,'2021-02-17','2021-02-17'),(353,1053,154,'2021-02-17','2021-02-17'),(354,1053,152,'2021-02-17','2021-02-17'),(355,1053,150,'2021-02-17','2021-02-17'),(356,1053,149,'2021-02-17','2021-02-17'),(357,1053,148,'2021-02-17','2021-02-17'),(358,1053,147,'2021-02-17','2021-02-17'),(359,1053,349,'2021-02-17','2021-02-17'),(360,1053,348,'2021-02-17','2021-02-17'),(361,1053,344,'2021-02-17','2021-02-17'),(362,1053,347,'2021-02-17','2021-02-17'),(363,1053,160,'2021-02-17','2021-02-17'),(364,1052,213,'2021-03-04','2021-03-04'),(365,1052,312,'2021-03-04','2021-03-04'),(366,1052,315,'2021-03-04','2021-03-04'),(367,1052,319,'2021-03-04','2021-03-04'),(369,1052,322,'2021-03-04','2021-03-04'),(370,1052,337,'2021-03-04','2021-03-04'),(371,1007,106,'2021-03-05','2021-03-05'),(372,1007,107,'2021-03-05','2021-03-05'),(373,1007,381,'2021-03-05','2021-03-05'),(374,1025,365,'2021-03-11','2021-03-11'),(375,1010,134,'2021-03-19','2021-03-19'),(376,1004,134,'2021-03-19','2021-03-19'),(377,1052,309,'2021-03-24','2021-03-24'),(378,1052,333,'2021-03-24','2021-03-24'),(379,1041,409,'2021-03-24','2021-10-06'),(380,1047,387,'2021-03-24','2021-03-24'),(381,1028,315,'2021-04-01','2021-04-01'),(382,1028,334,'2021-04-01','2021-04-01'),(383,1054,192,'2021-04-06','2021-04-06'),(384,1055,192,'2021-04-06','2021-04-06'),(385,1055,213,'2021-04-06','2021-04-06'),(386,1056,192,'2021-04-06','2021-04-06'),(387,1056,125,'2021-04-06','2021-04-06'),(388,1035,274,'2021-04-07','2021-04-07'),(389,1035,374,'2021-04-07','2021-04-07'),(390,1035,268,'2021-04-07','2021-04-07'),(391,1047,365,'2021-05-26','2021-05-26'),(392,1025,169,'2021-05-28','2021-05-28'),(393,1041,364,'2021-05-28','2021-05-28'),(394,1057,116,'2021-06-07','2021-06-07'),(395,1057,179,'2021-06-07','2021-06-07'),(396,1057,103,'2021-06-07','2021-06-07'),(397,1057,109,'2021-06-07','2021-06-07'),(398,1057,383,'2021-06-07','2021-06-07'),(399,1057,138,'2021-06-07','2021-06-07'),(400,1057,140,'2021-06-07','2021-06-07'),(401,1057,141,'2021-06-07','2021-06-07'),(402,1048,365,'2021-07-01','2021-07-01'),(403,1048,366,'2021-07-01','2021-07-01'),(404,1048,367,'2021-07-01','2021-07-01'),(405,1048,374,'2021-07-01','2021-07-01'),(406,1048,389,'2021-07-01','2021-07-01'),(407,1048,334,'2021-07-01','2021-07-01'),(408,1048,337,'2021-07-01','2021-07-01'),(409,1031,364,'2021-07-02','2021-07-02'),(410,1031,349,'2021-07-02','2021-07-02'),(411,1028,351,'2021-07-05','2021-07-05'),(412,1027,383,'2021-07-13','2021-07-13'),(413,1047,258,'2021-07-15','2021-07-15'),(414,1047,391,'2021-07-20','2021-07-20'),(415,1031,392,'2021-07-28','2021-07-28'),(416,1045,364,'2021-07-28','2021-07-28'),(417,1034,364,'2021-07-28','2021-07-28'),(418,1034,392,'2021-07-28','2021-07-28'),(419,1045,392,'2021-07-28','2021-07-28'),(420,1042,392,'2021-07-28','2021-07-28'),(421,1042,364,'2021-07-28','2021-07-28'),(422,1053,364,'2021-07-28','2021-07-28'),(423,1053,392,'2021-07-28','2021-07-28'),(424,1059,107,'2021-08-09','2021-08-09'),(425,1059,382,'2021-08-09','2021-08-09'),(426,1059,114,'2021-08-09','2021-08-09'),(427,1059,116,'2021-08-09','2021-08-09'),(428,1047,409,'2021-08-13','2021-08-13'),(429,1034,365,'2021-10-04','2021-10-04'),(430,1041,385,'2021-10-06','2021-10-06'),(431,1028,275,'2021-10-06','2021-10-06'),(432,1028,375,'2021-10-06','2021-10-06'),(433,1028,405,'2021-10-06','2021-10-06'),(434,1051,365,'2021-10-26','2021-10-26'),(436,1025,103,'2021-11-02','2021-11-02'),(437,1051,391,'2021-11-29','2021-11-29'),(438,1051,255,'2021-11-29','2021-11-29'),(439,1053,365,'2021-11-30','2021-11-30'),(440,1041,391,'2021-12-03','2021-12-03'),(441,1050,109,'2021-12-29','2021-12-29'),(442,1060,173,'2022-01-03','2022-01-03'),(443,1060,183,'2022-01-03','2022-01-03'),(444,1060,255,'2022-01-07','2022-01-07'),(445,1060,409,'2022-01-07','2022-01-07'),(446,1060,384,'2022-01-07','2022-01-07'),(447,1032,138,'2022-05-23','2022-05-23'),(448,1032,140,'2022-05-23','2022-05-23'),(449,1041,309,'2022-06-01','2022-06-01'),(450,1041,331,'2022-06-01','2022-06-01'),(451,1041,106,'2022-06-01','2022-06-01'),(454,1062,137,'2022-07-19','2022-07-19'),(455,1062,365,'2022-07-19','2022-07-19');

--
-- Table structure for table `usuario_centro_costos_sap`
--

CREATE TABLE `usuario_centro_costos_sap` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuario` int(11) NOT NULL,
  `centroCostoSap` int(11) NOT NULL,
  `proyectoSap` int(11) NOT NULL,
  `createdAt` datetime NOT NULL,
  `updatedAt` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `usuario` (`usuario`),
  KEY `centroCostoSap` (`centroCostoSap`),
  KEY `proyectoSap` (`proyectoSap`),
  CONSTRAINT `usuario_centro_costos_sap_ibfk_1` FOREIGN KEY (`centroCostoSap`) REFERENCES `centro_costos_sap` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `usuario_centro_costos_sap_ibfk_2` FOREIGN KEY (`proyectoSap`) REFERENCES `proyectos_sap` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `usuario_centro_costos_sap_ibfk_3` FOREIGN KEY (`usuario`) REFERENCES `usuarios` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=351 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `usuario_centro_costos_sap`
--

INSERT INTO `usuario_centro_costos_sap` VALUES (10,1,8,34,'2022-09-26 00:00:00','2022-09-26 00:00:00'),(12,1,12,55,'2022-09-26 00:00:00','2022-09-26 00:00:00'),(14,1,8,36,'2022-09-27 00:00:00','2022-09-27 00:00:00'),(15,1,7,30,'2022-09-27 00:00:00','2022-09-27 00:00:00'),(17,1,9,40,'2022-10-11 00:00:00','2022-10-11 00:00:00'),(20,1057,1,5,'2022-10-17 00:00:00','2022-10-17 00:00:00'),(21,1025,1,5,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(24,1025,8,35,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(27,1030,1,9,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(28,1030,4,12,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(29,1030,4,13,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(30,1030,4,14,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(31,1030,11,51,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(32,1025,11,51,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(33,1028,9,39,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(34,1028,9,46,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(36,1047,7,25,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(37,1047,7,26,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(41,1047,7,31,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(42,1047,7,32,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(44,1047,9,45,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(45,1039,5,15,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(53,1027,1,5,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(54,1011,1,5,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(55,1060,7,25,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(56,1060,7,26,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(61,1060,7,32,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(62,1007,1,5,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(66,1012,1,9,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(67,1012,3,11,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(68,1012,4,12,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(69,1012,4,13,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(70,1012,4,14,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(73,1013,1,9,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(74,1013,4,12,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(75,1013,4,13,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(76,1013,4,14,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(78,1057,9,41,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(79,1032,8,34,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(80,1032,8,35,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(81,1032,8,36,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(82,1022,4,14,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(83,1022,4,12,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(84,1041,1,5,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(86,1041,7,25,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(87,1041,7,26,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(89,1041,7,31,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(90,1041,8,33,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(91,1041,9,39,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(92,1043,1,5,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(99,1043,8,35,'2022-10-19 00:00:00','2022-10-19 00:00:00'),(103,1040,7,31,'2022-10-21 00:00:00','2022-10-21 00:00:00'),(104,1040,5,23,'2022-10-21 00:00:00','2022-10-21 00:00:00'),(105,1025,9,46,'2022-10-26 00:00:00','2022-10-26 00:00:00'),(106,1025,9,46,'2022-10-26 00:00:00','2022-10-26 00:00:00'),(107,1039,5,23,'2022-11-07 00:00:00','2022-11-07 00:00:00'),(108,1063,8,34,'2022-11-07 00:00:00','2022-11-07 00:00:00'),(110,1040,6,107,'2022-11-11 00:00:00','2022-11-11 00:00:00'),(112,1030,8,34,'2022-11-21 00:00:00','2022-11-21 00:00:00'),(113,1012,6,107,'2022-11-21 00:00:00','2022-11-21 00:00:00'),(114,1012,9,45,'2022-11-21 00:00:00','2022-11-21 00:00:00'),(115,1013,6,107,'2022-11-21 00:00:00','2022-11-21 00:00:00'),(116,1013,9,45,'2022-11-21 00:00:00','2022-11-21 00:00:00'),(117,1057,9,42,'2022-12-02 00:00:00','2022-12-02 00:00:00'),(118,1039,5,22,'2022-12-05 00:00:00','2022-12-05 00:00:00'),(120,1066,11,51,'2022-12-21 00:00:00','2022-12-21 00:00:00'),(121,1043,9,46,'2023-01-05 00:00:00','2023-01-05 00:00:00'),(130,1062,9,39,'2023-01-30 00:00:00','2023-01-30 00:00:00'),(134,1013,7,111,'2023-03-13 00:00:00','2023-03-13 00:00:00'),(135,1013,7,112,'2023-03-13 00:00:00','2023-03-13 00:00:00'),(136,1012,7,111,'2023-03-13 00:00:00','2023-03-13 00:00:00'),(137,1012,7,112,'2023-03-13 00:00:00','2023-03-13 00:00:00'),(138,1047,7,111,'2023-03-13 00:00:00','2023-03-13 00:00:00'),(139,1047,7,112,'2023-03-13 00:00:00','2023-03-13 00:00:00'),(141,1060,7,112,'2023-03-13 00:00:00','2023-03-13 00:00:00'),(142,1041,9,45,'2023-04-21 00:00:00','2023-04-21 00:00:00'),(143,1051,8,35,'2023-05-19 00:00:00','2023-05-19 00:00:00'),(144,1051,9,39,'2023-05-19 00:00:00','2023-05-19 00:00:00'),(145,1051,9,46,'2023-05-19 00:00:00','2023-05-19 00:00:00'),(146,1039,5,114,'2023-05-22 00:00:00','2023-05-22 00:00:00'),(147,1039,5,115,'2023-05-22 00:00:00','2023-05-22 00:00:00'),(148,1028,9,113,'2023-05-22 00:00:00','2023-05-22 00:00:00'),(149,1028,9,116,'2023-05-22 00:00:00','2023-05-22 00:00:00'),(150,1028,9,117,'2023-05-22 00:00:00','2023-05-22 00:00:00'),(151,1028,9,118,'2023-05-22 00:00:00','2023-05-22 00:00:00'),(152,1028,9,119,'2023-05-22 00:00:00','2023-05-22 00:00:00'),(153,1067,9,45,'2023-05-22 00:00:00','2023-05-22 00:00:00'),(154,1041,7,112,'2023-06-06 00:00:00','2023-06-06 00:00:00'),(157,1068,7,32,'2023-09-28 00:00:00','2023-09-28 00:00:00'),(158,1068,7,31,'2023-09-28 00:00:00','2023-09-28 00:00:00'),(160,1069,7,25,'2023-09-29 00:00:00','2023-09-29 00:00:00'),(161,1069,7,26,'2023-09-29 00:00:00','2023-09-29 00:00:00'),(162,1069,7,32,'2023-09-29 00:00:00','2023-09-29 00:00:00'),(186,1070,7,26,'2023-12-15 00:00:00','2023-12-15 00:00:00'),(187,1070,7,32,'2023-12-15 00:00:00','2023-12-15 00:00:00'),(188,1070,7,111,'2023-12-15 00:00:00','2023-12-15 00:00:00'),(189,1040,9,46,'2024-01-09 00:00:00','2024-01-09 00:00:00'),(190,1057,7,26,'2024-01-15 00:00:00','2024-01-15 00:00:00'),(191,1028,9,129,'2024-03-21 00:00:00','2024-03-21 00:00:00'),(192,1028,9,130,'2024-03-21 00:00:00','2024-03-21 00:00:00'),(194,1057,8,33,'2024-05-03 00:00:00','2024-05-03 00:00:00'),(197,1012,9,39,'2024-05-13 00:00:00','2024-05-13 00:00:00'),(198,1013,9,39,'2024-05-13 00:00:00','2024-05-13 00:00:00'),(199,1028,9,45,'2024-05-13 00:00:00','2024-05-13 00:00:00'),(200,1062,9,46,'2024-05-13 00:00:00','2024-05-13 00:00:00'),(201,1043,9,39,'2024-05-13 00:00:00','2024-05-13 00:00:00'),(202,1051,9,127,'2024-05-13 00:00:00','2024-05-13 00:00:00'),(206,1069,18,133,'2024-05-20 00:00:00','2024-05-20 00:00:00'),(234,1069,18,138,'2024-05-20 00:00:00','2024-05-20 00:00:00'),(252,1025,8,33,'2024-05-24 00:00:00','2024-05-24 00:00:00'),(259,1047,7,128,'2024-06-27 00:00:00','2024-06-27 00:00:00'),(260,1028,8,33,'2024-08-26 00:00:00','2024-08-26 00:00:00'),(261,1012,7,32,'2024-09-03 00:00:00','2024-09-03 00:00:00'),(262,1012,7,128,'2024-09-03 00:00:00','2024-09-03 00:00:00'),(263,1012,7,26,'2024-09-03 00:00:00','2024-09-03 00:00:00'),(264,1013,7,32,'2024-09-03 00:00:00','2024-09-03 00:00:00'),(265,1013,7,128,'2024-09-03 00:00:00','2024-09-03 00:00:00'),(266,1013,7,26,'2024-09-03 00:00:00','2024-09-03 00:00:00'),(269,1072,7,32,'2024-10-18 00:00:00','2024-10-18 00:00:00'),(270,1071,7,26,'2024-10-18 00:00:00','2024-10-18 00:00:00'),(271,1071,7,32,'2024-10-18 00:00:00','2024-10-18 00:00:00'),(272,1072,7,25,'2024-10-25 00:00:00','2024-10-25 00:00:00'),(273,1072,7,131,'2024-10-25 00:00:00','2024-10-25 00:00:00'),(274,1071,7,111,'2024-10-25 00:00:00','2024-10-25 00:00:00'),(275,1071,7,128,'2024-10-25 00:00:00','2024-10-25 00:00:00'),(276,1073,9,127,'2024-10-28 00:00:00','2024-10-28 00:00:00'),(277,1047,7,131,'2024-11-13 00:00:00','2024-11-13 00:00:00'),(278,1074,7,25,'2024-11-21 00:00:00','2024-11-21 00:00:00'),(279,1074,7,26,'2024-11-21 00:00:00','2024-11-21 00:00:00'),(280,1074,7,32,'2024-11-21 00:00:00','2024-11-21 00:00:00'),(281,1074,7,112,'2024-11-21 00:00:00','2024-11-21 00:00:00'),(282,1074,7,128,'2024-11-21 00:00:00','2024-11-21 00:00:00'),(283,1074,7,131,'2024-11-21 00:00:00','2024-11-21 00:00:00'),(285,1068,9,39,'2025-01-14 00:00:00','2025-01-14 00:00:00'),(286,1068,9,41,'2025-01-14 00:00:00','2025-01-14 00:00:00'),(287,1068,9,43,'2025-01-14 00:00:00','2025-01-14 00:00:00'),(288,1068,9,46,'2025-01-14 00:00:00','2025-01-14 00:00:00'),(289,1041,7,131,'2025-01-21 00:00:00','2025-01-21 00:00:00'),(290,1041,7,32,'2025-01-21 00:00:00','2025-01-21 00:00:00'),(291,1041,7,131,'2025-01-21 00:00:00','2025-01-21 00:00:00'),(292,1075,8,35,'2025-03-17 00:00:00','2025-03-17 00:00:00'),(293,1076,9,41,'2025-03-19 00:00:00','2025-03-19 00:00:00'),(294,1076,9,46,'2025-03-19 00:00:00','2025-03-19 00:00:00'),(295,1076,9,145,'2025-03-19 00:00:00','2025-03-19 00:00:00'),(296,1062,9,42,'2025-04-22 00:00:00','2025-04-22 00:00:00'),(297,1062,9,142,'2025-04-22 00:00:00','2025-04-22 00:00:00'),(298,1062,9,143,'2025-04-22 00:00:00','2025-04-22 00:00:00'),(299,1062,9,145,'2025-04-22 00:00:00','2025-04-22 00:00:00'),(300,1062,9,146,'2025-04-23 00:00:00','2025-04-23 00:00:00'),(301,1062,9,147,'2025-04-23 00:00:00','2025-04-23 00:00:00'),(302,1012,9,143,'2025-04-28 00:00:00','2025-04-28 00:00:00'),(303,1068,9,143,'2025-04-28 00:00:00','2025-04-28 00:00:00'),(304,1076,9,143,'2025-04-28 00:00:00','2025-04-28 00:00:00'),(305,1051,9,143,'2025-04-28 00:00:00','2025-04-28 00:00:00'),(306,1043,9,143,'2025-04-28 00:00:00','2025-04-28 00:00:00'),(307,1012,18,148,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(308,1039,18,148,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(309,1012,18,149,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(310,1013,18,149,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(311,1025,18,150,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(312,1062,18,150,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(313,1068,18,150,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(314,1067,18,150,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(315,1076,18,150,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(316,1071,18,151,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(317,1074,18,151,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(318,1072,18,151,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(319,1047,18,151,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(320,1013,18,151,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(321,1047,18,154,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(322,1071,18,154,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(323,1013,18,154,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(324,1074,18,154,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(325,1047,18,152,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(326,1071,18,152,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(327,1013,18,152,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(328,1074,18,152,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(329,1068,18,153,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(330,1062,18,153,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(331,1047,18,153,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(332,1012,18,153,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(333,1013,18,153,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(334,1072,18,153,'2025-06-26 00:00:00','2025-06-26 00:00:00'),(335,1067,9,43,'2025-07-15 00:00:00','2025-07-15 00:00:00'),(336,1074,7,131,'2025-07-22 00:00:00','2025-07-22 00:00:00'),(337,1067,9,39,'2025-07-22 00:00:00','2025-07-22 00:00:00'),(338,1067,9,127,'2025-07-22 00:00:00','2025-07-22 00:00:00'),(339,1067,9,42,'2025-07-22 00:00:00','2025-07-22 00:00:00'),(340,1067,9,145,'2025-07-22 00:00:00','2025-07-22 00:00:00'),(341,1067,9,46,'2025-07-22 00:00:00','2025-07-22 00:00:00'),(342,1076,9,39,'2025-09-16 00:00:00','2025-09-16 00:00:00'),(343,1060,18,151,'2025-10-21 00:00:00','2025-10-21 00:00:00'),(344,1060,18,154,'2025-10-21 00:00:00','2025-10-21 00:00:00'),(345,1060,18,152,'2025-10-21 00:00:00','2025-10-21 00:00:00'),(346,1060,7,128,'2025-10-21 00:00:00','2025-10-21 00:00:00'),(347,1047,7,155,'2025-11-04 00:00:00','2025-11-04 00:00:00'),(348,1071,7,155,'2025-11-04 00:00:00','2025-11-04 00:00:00'),(349,1047,7,156,'2025-11-04 00:00:00','2025-11-04 00:00:00'),(350,1071,7,156,'2025-11-04 00:00:00','2025-11-04 00:00:00');

--
-- Table structure for table `usuario_subareas`
--

CREATE TABLE `usuario_subareas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `usuario` int(11) NOT NULL,
  `subarea` int(11) NOT NULL,
  `createdAt` date NOT NULL,
  `updatedAt` date NOT NULL,
  PRIMARY KEY (`id`),
  KEY `subarea` (`subarea`),
  KEY `usuario` (`usuario`),
  CONSTRAINT `usuario_subareas_ibfk_1` FOREIGN KEY (`subarea`) REFERENCES `subareas` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `usuario_subareas_ibfk_2` FOREIGN KEY (`usuario`) REFERENCES `usuarios` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `usuario_subareas`
--


--
-- Temporary table structure for view `v_autorizaciones`
--

/*!50001 DROP VIEW IF EXISTS `v_autorizaciones`*/;
/*!50001 CREATE VIEW `v_autorizaciones` AS SELECT
 1 AS `id`,
  1 AS `usuario`,
  1 AS `nombreUsuario`,
  1 AS `mes`,
  1 AS `estado`,
  1 AS `nombreEstado`,
  1 AS `observaciones`,
  1 AS `autorizadoPor`,
  1 AS `nombreAutoriza`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_calendario`
--

/*!50001 DROP VIEW IF EXISTS `v_calendario`*/;
/*!50001 CREATE VIEW `v_calendario` AS SELECT
 1 AS `idUsuario`,
  1 AS `nombreUsuario`,
  1 AS `fecha`,
  1 AS `year`,
  1 AS `mes`,
  1 AS `dia`,
  1 AS `nDiaSemana`,
  1 AS `nSemana`,
  1 AS `trimestre`,
  1 AS `horasD1`,
  1 AS `horasD2`,
  1 AS `horasD3`,
  1 AS `horasD4`,
  1 AS `horasD5` */;

--
-- Temporary table structure for view `v_categoria_indicadores`
--

/*!50001 DROP VIEW IF EXISTS `v_categoria_indicadores`*/;
/*!50001 CREATE VIEW `v_categoria_indicadores` AS SELECT
 1 AS `id`,
  1 AS `area`,
  1 AS `nombreArea`,
  1 AS `centroCosto`,
  1 AS `nombre`,
  1 AS `usuario`,
  1 AS `nombreUsuario`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_centro_costos`
--

/*!50001 DROP VIEW IF EXISTS `v_centro_costos`*/;
/*!50001 CREATE VIEW `v_centro_costos` AS SELECT
 1 AS `id`,
  1 AS `categoria`,
  1 AS `nombreCategoria`,
  1 AS `codigo`,
  1 AS `nombre`,
  1 AS `estado`,
  1 AS `nombreEstado`,
  1 AS `color`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_feriados`
--

/*!50001 DROP VIEW IF EXISTS `v_feriados`*/;
/*!50001 CREATE VIEW `v_feriados` AS SELECT
 1 AS `id`,
  1 AS `fecha`,
  1 AS `descripcion`,
  1 AS `mes`,
  1 AS `year`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_presupuesto_indicadores`
--

/*!50001 DROP VIEW IF EXISTS `v_presupuesto_indicadores`*/;
/*!50001 CREATE VIEW `v_presupuesto_indicadores` AS SELECT
 1 AS `id`,
  1 AS `areaIndicador`,
  1 AS `nombreAreaIndicador`,
  1 AS `categoriaIndicador`,
  1 AS `nombreCategoriaIndicadores`,
  1 AS `responsableCategoria`,
  1 AS `subcategoriaIndicador`,
  1 AS `nombreSubcategoriaIndicadores`,
  1 AS `responsableSubcategoria`,
  1 AS `nombreResponsableSubcategoria`,
  1 AS `areaUsuario`,
  1 AS `nombreAreaUsuario`,
  1 AS `referenciaYearAnterior`,
  1 AS `year`,
  1 AS `enero`,
  1 AS `eneroReal`,
  1 AS `febrero`,
  1 AS `febreroReal`,
  1 AS `marzo`,
  1 AS `marzoReal`,
  1 AS `abril`,
  1 AS `abrilReal`,
  1 AS `mayo`,
  1 AS `mayoReal`,
  1 AS `junio`,
  1 AS `junioReal`,
  1 AS `julio`,
  1 AS `julioReal`,
  1 AS `agosto`,
  1 AS `agostoReal`,
  1 AS `septiembre`,
  1 AS `septiembreReal`,
  1 AS `octubre`,
  1 AS `octubreReal`,
  1 AS `noviembre`,
  1 AS `noviembreReal`,
  1 AS `diciembre`,
  1 AS `diciembreReal`,
  1 AS `metaAnual`,
  1 AS `valorAcumulado`,
  1 AS `tipoDato`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_proyectos`
--

/*!50001 DROP VIEW IF EXISTS `v_proyectos`*/;
/*!50001 CREATE VIEW `v_proyectos` AS SELECT
 1 AS `id`,
  1 AS `centroCosto`,
  1 AS `nombreCentroCosto`,
  1 AS `codigo`,
  1 AS `estado`,
  1 AS `nombreEstado`,
  1 AS `area`,
  1 AS `nombreArea`,
  1 AS `nombre`,
  1 AS `descripcion`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_proyectos_sap`
--

/*!50001 DROP VIEW IF EXISTS `v_proyectos_sap`*/;
/*!50001 CREATE VIEW `v_proyectos_sap` AS SELECT
 1 AS `id`,
  1 AS `codigoProyectoSap`,
  1 AS `centroCostoSap`,
  1 AS `codigoCentroCostoSap`,
  1 AS `nombreCentroCostoSap`,
  1 AS `descripcion`,
  1 AS `estado`,
  1 AS `nombreEstado`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_subareas`
--

/*!50001 DROP VIEW IF EXISTS `v_subareas`*/;
/*!50001 CREATE VIEW `v_subareas` AS SELECT
 1 AS `id`,
  1 AS `nombre`,
  1 AS `area`,
  1 AS `nombreArea`,
  1 AS `descripcion`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_subcategoria_indicadores`
--

/*!50001 DROP VIEW IF EXISTS `v_subcategoria_indicadores`*/;
/*!50001 CREATE VIEW `v_subcategoria_indicadores` AS SELECT
 1 AS `id`,
  1 AS `categoria`,
  1 AS `nombreCategoria`,
  1 AS `area`,
  1 AS `nombreArea`,
  1 AS `nombre`,
  1 AS `responsable`,
  1 AS `nombreResponsable`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_timecontrollings`
--

/*!50001 DROP VIEW IF EXISTS `v_timecontrollings`*/;
/*!50001 CREATE VIEW `v_timecontrollings` AS SELECT
 1 AS `id`,
  1 AS `usuario`,
  1 AS `nombreUsuario`,
  1 AS `tipoTiempo`,
  1 AS `nombre`,
  1 AS `centroCosto`,
  1 AS `codigo`,
  1 AS `nombreCentroCosto`,
  1 AS `proyecto`,
  1 AS `nombreProyecto`,
  1 AS `proyectoSap`,
  1 AS `codigoProyectoSap`,
  1 AS `nombreProyectoSap`,
  1 AS `centroCostoSap`,
  1 AS `codigoCentroCostoSap`,
  1 AS `nombreCentroCostoSap`,
  1 AS `horas`,
  1 AS `porcentaje`,
  1 AS `fecha`,
  1 AS `semana`,
  1 AS `mes`,
  1 AS `year`,
  1 AS `observaciones`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_usuario_categoria_indicadores`
--

/*!50001 DROP VIEW IF EXISTS `v_usuario_categoria_indicadores`*/;
/*!50001 CREATE VIEW `v_usuario_categoria_indicadores` AS SELECT
 1 AS `id`,
  1 AS `nombreUsuario`,
  1 AS `area`,
  1 AS `nombreArea`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_usuario_centro_costos`
--

/*!50001 DROP VIEW IF EXISTS `v_usuario_centro_costos`*/;
/*!50001 CREATE VIEW `v_usuario_centro_costos` AS SELECT
 1 AS `id`,
  1 AS `usuario`,
  1 AS `nombreUsuario`,
  1 AS `centroCosto`,
  1 AS `codigo`,
  1 AS `nombreCentroCosto`,
  1 AS `categoria`,
  1 AS `nombreCategoriaCentroCosto`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_usuario_centro_costos_sap`
--

/*!50001 DROP VIEW IF EXISTS `v_usuario_centro_costos_sap`*/;
/*!50001 CREATE VIEW `v_usuario_centro_costos_sap` AS SELECT
 1 AS `id`,
  1 AS `usuario`,
  1 AS `centroCostoSap`,
  1 AS `codigoCentroCostoSap`,
  1 AS `nombreCentroCostoSap`,
  1 AS `proyectoSap`,
  1 AS `codigoProyectoSap`,
  1 AS `nombreProyectoSap`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_usuario_subareas`
--

/*!50001 DROP VIEW IF EXISTS `v_usuario_subareas`*/;
/*!50001 CREATE VIEW `v_usuario_subareas` AS SELECT
 1 AS `id`,
  1 AS `usuario`,
  1 AS `nombreUsuario`,
  1 AS `subarea`,
  1 AS `nombreSubarea`,
  1 AS `area`,
  1 AS `nombreArea`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_usuario_subcategoria_indicadores`
--

/*!50001 DROP VIEW IF EXISTS `v_usuario_subcategoria_indicadores`*/;
/*!50001 CREATE VIEW `v_usuario_subcategoria_indicadores` AS SELECT
 1 AS `id`,
  1 AS `nombreUsuario`,
  1 AS `area`,
  1 AS `nombreArea`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Temporary table structure for view `v_usuarios`
--

/*!50001 DROP VIEW IF EXISTS `v_usuarios`*/;
/*!50001 CREATE VIEW `v_usuarios` AS SELECT
 1 AS `id`,
  1 AS `nombre`,
  1 AS `email`,
  1 AS `telefono`,
  1 AS `rut`,
  1 AS `password`,
  1 AS `role`,
  1 AS `horas`,
  1 AS `horasD1`,
  1 AS `horasD2`,
  1 AS `horasD3`,
  1 AS `horasD4`,
  1 AS `horasD5`,
  1 AS `estado`,
  1 AS `nombreEstado`,
  1 AS `zona`,
  1 AS `nombreZona`,
  1 AS `area`,
  1 AS `nombreArea`,
  1 AS `cargo`,
  1 AS `nombreCargo`,
  1 AS `img`,
  1 AS `descripcion`,
  1 AS `visualizacion`,
  1 AS `createdAt`,
  1 AS `updatedAt` */;

--
-- Table structure for table `zonas`
--

CREATE TABLE `zonas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(150) NOT NULL,
  `descripcion` text NOT NULL,
  `createdAt` date NOT NULL,
  `updatedAt` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `zonas`
--

INSERT INTO `zonas` VALUES (10,'Norte','Zona norte del Pais','2020-07-29','2020-07-29'),(20,'Metropolitana','Región metropolitana ','2020-07-29','2020-08-03'),(30,'Sur Austral','Zona Sur y Austral','2020-07-29','2020-07-29');

--
-- Final view structure for view `r_administracion_usuario_centro_costos`
--

/*!50001 DROP VIEW IF EXISTS `r_administracion_usuario_centro_costos`*/;

--
-- Final view structure for view `r_administracion_usuario_centro_costos_sap`
--

/*!50001 DROP VIEW IF EXISTS `r_administracion_usuario_centro_costos_sap`*/;

--
-- Final view structure for view `r_administracion_usuario_proyectos_sap`
--

/*!50001 DROP VIEW IF EXISTS `r_administracion_usuario_proyectos_sap`*/;

--
-- Final view structure for view `r_centro_costo_indicadores`
--

/*!50001 DROP VIEW IF EXISTS `r_centro_costo_indicadores`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_centro_costo_indicadores` AS select `usuarios`.`id` AS `usuario`,`usuarios`.`nombre` AS `nombre`,year(`timecontrollings`.`fecha`) AS `year`,month(`timecontrollings`.`fecha`) AS `mes`,`centro_costos`.`codigo` AS `centroCosto`,`centro_costos`.`nombre` AS `nombreCentroCosto`,`tipo_tiempos`.`color` AS `color`,round(sum(`timecontrollings`.`horas`),2) AS `horasTotales`,`timecontrollings`.`tipoTiempo` AS `indicadorControl`,`tipo_tiempos`.`nombre` AS `nombreIndicadorControl`,`timecontrollings`.`createdAt` AS `createdAt`,`timecontrollings`.`updatedAt` AS `updatedAt` from (((`usuarios` join `timecontrollings`) join `centro_costos`) join `tipo_tiempos`) where `timecontrollings`.`usuario` = `usuarios`.`id` and `timecontrollings`.`centroCosto` = `centro_costos`.`id` and `timecontrollings`.`tipoTiempo` = `tipo_tiempos`.`id` group by `timecontrollings`.`usuario`,year(`timecontrollings`.`fecha`),month(`timecontrollings`.`fecha`),`timecontrollings`.`centroCosto`,`tipo_tiempos`.`id` order by `timecontrollings`.`usuario` desc */;

--
-- Final view structure for view `r_gerencia_cat_centro_costo_mes`
--

/*!50001 DROP VIEW IF EXISTS `r_gerencia_cat_centro_costo_mes`*/;

--
-- Final view structure for view `r_gerencia_centro_costo_mes`
--

/*!50001 DROP VIEW IF EXISTS `r_gerencia_centro_costo_mes`*/;

--
-- Final view structure for view `r_gerencia_centro_costo_proyectos_sap_mes`
--

/*!50001 DROP VIEW IF EXISTS `r_gerencia_centro_costo_proyectos_sap_mes`*/;

--
-- Final view structure for view `r_gerencia_tipo_tiempo_mes`
--

/*!50001 DROP VIEW IF EXISTS `r_gerencia_tipo_tiempo_mes`*/;

--
-- Final view structure for view `r_gerencia_usuario_areas`
--

/*!50001 DROP VIEW IF EXISTS `r_gerencia_usuario_areas`*/;

--
-- Final view structure for view `r_proyecto_indicadores`
--

/*!50001 DROP VIEW IF EXISTS `r_proyecto_indicadores`*/;

--
-- Final view structure for view `r_proyecto_meses`
--

/*!50001 DROP VIEW IF EXISTS `r_proyecto_meses`*/;

--
-- Final view structure for view `r_proyecto_usuarios`
--

/*!50001 DROP VIEW IF EXISTS `r_proyecto_usuarios`*/;

--
-- Final view structure for view `r_proyectos`
--

/*!50001 DROP VIEW IF EXISTS `r_proyectos`*/;

--
-- Final view structure for view `r_timecontrollings`
--

/*!50001 DROP VIEW IF EXISTS `r_timecontrollings`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_timecontrollings` AS select `usuarios`.`id` AS `id`,`usuarios`.`nombre` AS `nombre`,`timecontrollings`.`fecha` AS `fecha`,`categoria_centro_costos`.`id` AS `categoriaCentroCosto`,`categoria_centro_costos`.`nombre` AS `nombreCategoriaCentroCosto`,`centro_costos`.`codigo` AS `centroCosto`,`centro_costos`.`nombre` AS `nombreCentroCosto`,round(sum(`timecontrollings`.`horas`),2) AS `horasTotales`,round(sum(`timecontrollings`.`horas`) * 100 / `usuarios`.`horas`,1) AS `porcentaje`,`timecontrollings`.`tipoTiempo` AS `indicadorControl`,`tipo_tiempos`.`nombre` AS `nombreIndicadorControl`,`areas`.`id` AS `areaGerencia`,`areas`.`nombre` AS `nombreAreaGerencia`,year(`timecontrollings`.`fecha`) AS `year`,month(`timecontrollings`.`fecha`) AS `mes`,`timecontrollings`.`observaciones` AS `observaciones`,`timecontrollings`.`createdAt` AS `createdAt`,`timecontrollings`.`updatedAt` AS `updatedAt` from (((((`usuarios` join `timecontrollings`) join `centro_costos`) join `tipo_tiempos`) join `categoria_centro_costos`) join `areas`) where `timecontrollings`.`usuario` = `usuarios`.`id` and `timecontrollings`.`centroCosto` = `centro_costos`.`id` and `centro_costos`.`categoria` = `categoria_centro_costos`.`id` and `usuarios`.`area` = `areas`.`id` and `timecontrollings`.`tipoTiempo` = `tipo_tiempos`.`id` group by `timecontrollings`.`usuario`,`timecontrollings`.`fecha`,`categoria_centro_costos`.`id`,`timecontrollings`.`centroCosto`,`tipo_tiempos`.`id` order by `timecontrollings`.`usuario`,`timecontrollings`.`fecha` desc */;

--
-- Final view structure for view `r_usuario_cat_centro_costo_mes`
--

/*!50001 DROP VIEW IF EXISTS `r_usuario_cat_centro_costo_mes`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_usuario_cat_centro_costo_mes` AS select `timecontrollings`.`id` AS `id`,`timecontrollings`.`usuario` AS `usuario`,`categoria_centro_costos`.`id` AS `catCentroCosto`,`categoria_centro_costos`.`nombre` AS `nombreCatCentroCosto`,round(sum(`timecontrollings`.`horas`),2) AS `horas`,`categoria_centro_costos`.`color` AS `color`,month(`timecontrollings`.`fecha`) AS `mes`,year(`timecontrollings`.`fecha`) AS `year`,`timecontrollings`.`createdAt` AS `createdAt`,`timecontrollings`.`updatedAt` AS `updatedAt` from ((`timecontrollings` join `centro_costos`) join `categoria_centro_costos`) where `timecontrollings`.`centroCosto` = `centro_costos`.`id` and `centro_costos`.`categoria` = `categoria_centro_costos`.`id` group by `timecontrollings`.`usuario`,`categoria_centro_costos`.`id`,month(`timecontrollings`.`fecha`),year(`timecontrollings`.`fecha`) */;

--
-- Final view structure for view `r_usuario_cat_centro_costos`
--

/*!50001 DROP VIEW IF EXISTS `r_usuario_cat_centro_costos`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_usuario_cat_centro_costos` AS select `timecontrollings`.`id` AS `id`,`timecontrollings`.`usuario` AS `usuario`,`categoria_centro_costos`.`id` AS `catCentroCosto`,`categoria_centro_costos`.`nombre` AS `nombreCatCentroCosto`,round(sum(`timecontrollings`.`horas`),2) AS `horas`,`timecontrollings`.`fecha` AS `fecha`,month(`timecontrollings`.`fecha`) AS `mes`,year(`timecontrollings`.`fecha`) AS `year`,`timecontrollings`.`createdAt` AS `createdAt`,`timecontrollings`.`updatedAt` AS `updatedAt` from ((`timecontrollings` join `centro_costos`) join `categoria_centro_costos`) where `timecontrollings`.`centroCosto` = `centro_costos`.`id` and `centro_costos`.`categoria` = `categoria_centro_costos`.`id` group by `timecontrollings`.`usuario`,`categoria_centro_costos`.`id`,`timecontrollings`.`fecha` */;

--
-- Final view structure for view `r_usuario_centro_costo_dia`
--

/*!50001 DROP VIEW IF EXISTS `r_usuario_centro_costo_dia`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_usuario_centro_costo_dia` AS select `timecontrollings`.`id` AS `id`,`usuarios`.`id` AS `usuario`,`usuarios`.`nombre` AS `nombreUsuario`,`usuarios`.`area` AS `area`,`areas`.`nombre` AS `nombreArea`,`centro_costos`.`id` AS `idCentroCosto`,`centro_costos`.`codigo` AS `codigo`,`centro_costos`.`color` AS `color`,`centro_costos`.`nombre` AS `nombreCentroCosto`,round(sum(`timecontrollings`.`horas`),2) AS `horas`,round(sum(`timecontrollings`.`porcentaje`),2) AS `porcentaje`,`timecontrollings`.`fecha` AS `fecha`,month(`timecontrollings`.`fecha`) AS `mes`,year(`timecontrollings`.`fecha`) AS `year`,`timecontrollings`.`createdAt` AS `createdAt`,`timecontrollings`.`updatedAt` AS `updatedAt` from (((`usuarios` join `centro_costos`) join `areas`) join `timecontrollings`) where `timecontrollings`.`centroCosto` = `centro_costos`.`id` and `timecontrollings`.`usuario` = `usuarios`.`id` and `usuarios`.`area` = `areas`.`id` group by `usuarios`.`id`,`centro_costos`.`id`,`timecontrollings`.`fecha`,month(`timecontrollings`.`fecha`) order by `usuarios`.`id`,`timecontrollings`.`fecha` desc */;

--
-- Final view structure for view `r_usuario_centro_costo_mes`
--

/*!50001 DROP VIEW IF EXISTS `r_usuario_centro_costo_mes`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_usuario_centro_costo_mes` AS select `timecontrollings`.`id` AS `id`,`timecontrollings`.`usuario` AS `usuario`,`timecontrollings`.`centroCosto` AS `centroCosto`,`centro_costos`.`nombre` AS `nombreCentroCosto`,`centro_costos`.`codigo` AS `codigo`,round(sum(`timecontrollings`.`horas`),2) AS `horas`,`centro_costos`.`color` AS `color`,month(`timecontrollings`.`fecha`) AS `mes`,year(`timecontrollings`.`fecha`) AS `year`,`timecontrollings`.`createdAt` AS `createdAt`,`timecontrollings`.`updatedAt` AS `updatedAt` from (`timecontrollings` join `centro_costos`) where `timecontrollings`.`centroCosto` = `centro_costos`.`id` group by `timecontrollings`.`usuario`,`timecontrollings`.`centroCosto`,month(`timecontrollings`.`fecha`),year(`timecontrollings`.`fecha`) */;

--
-- Final view structure for view `r_usuario_centro_costo_sap_dia`
--

/*!50001 DROP VIEW IF EXISTS `r_usuario_centro_costo_sap_dia`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_usuario_centro_costo_sap_dia` AS select `timecontrollings`.`id` AS `id`,`usuarios`.`id` AS `usuario`,`usuarios`.`nombre` AS `nombreUsuario`,`centro_costos_sap`.`id` AS `idCentroCostoSap`,`centro_costos_sap`.`codigo` AS `codigo`,`centro_costos_sap`.`color` AS `color`,`centro_costos_sap`.`nombre` AS `nombreCentroCosto`,round(sum(`timecontrollings`.`horas`),2) AS `horas`,round(sum(`timecontrollings`.`porcentaje`),2) AS `porcentaje`,`timecontrollings`.`fecha` AS `fecha`,month(`timecontrollings`.`fecha`) AS `mes`,year(`timecontrollings`.`fecha`) AS `year`,`timecontrollings`.`createdAt` AS `createdAt`,`timecontrollings`.`updatedAt` AS `updatedAt` from ((`usuarios` join `centro_costos_sap`) join `timecontrollings`) where `timecontrollings`.`centroCostoSap` = `centro_costos_sap`.`id` and `timecontrollings`.`usuario` = `usuarios`.`id` group by `usuarios`.`id`,`centro_costos_sap`.`id`,`timecontrollings`.`fecha`,month(`timecontrollings`.`fecha`) order by `usuarios`.`id`,`timecontrollings`.`fecha` desc */;

--
-- Final view structure for view `r_usuario_centro_costo_sap_mes`
--

/*!50001 DROP VIEW IF EXISTS `r_usuario_centro_costo_sap_mes`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_usuario_centro_costo_sap_mes` AS select `timecontrollings`.`id` AS `id`,`timecontrollings`.`usuario` AS `usuario`,`timecontrollings`.`centroCostoSap` AS `centroCostoSap`,`centro_costos_sap`.`nombre` AS `nombreCentroCostoSap`,`centro_costos_sap`.`codigo` AS `codigo`,round(sum(`timecontrollings`.`horas`),2) AS `horas`,`centro_costos_sap`.`color` AS `color`,month(`timecontrollings`.`fecha`) AS `mes`,year(`timecontrollings`.`fecha`) AS `year`,`timecontrollings`.`createdAt` AS `createdAt`,`timecontrollings`.`updatedAt` AS `updatedAt` from (`timecontrollings` join `centro_costos_sap`) where `timecontrollings`.`centroCostoSap` = `centro_costos_sap`.`id` group by `timecontrollings`.`usuario`,`timecontrollings`.`centroCostoSap`,month(`timecontrollings`.`fecha`),year(`timecontrollings`.`fecha`) */;

--
-- Final view structure for view `r_usuario_centro_costos`
--

/*!50001 DROP VIEW IF EXISTS `r_usuario_centro_costos`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_usuario_centro_costos` AS select `timecontrollings`.`id` AS `id`,`timecontrollings`.`usuario` AS `usuario`,`timecontrollings`.`centroCosto` AS `centroCosto`,`centro_costos`.`nombre` AS `nombreCentroCosto`,`centro_costos`.`codigo` AS `codigo`,round(sum(`timecontrollings`.`horas`),2) AS `horas`,`timecontrollings`.`fecha` AS `fecha`,month(`timecontrollings`.`fecha`) AS `mes`,year(`timecontrollings`.`fecha`) AS `year`,`timecontrollings`.`createdAt` AS `createdAt`,`timecontrollings`.`updatedAt` AS `updatedAt` from (`timecontrollings` join `centro_costos`) where `timecontrollings`.`centroCosto` = `centro_costos`.`id` group by `timecontrollings`.`usuario`,`timecontrollings`.`centroCosto`,`timecontrollings`.`fecha` */;

--
-- Final view structure for view `r_usuario_fechas`
--

/*!50001 DROP VIEW IF EXISTS `r_usuario_fechas`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_usuario_fechas` AS select `timecontrollings`.`usuario` AS `usuario`,round(sum(`timecontrollings`.`horas`),2) AS `horas`,`timecontrollings`.`fecha` AS `fecha`,month(`timecontrollings`.`fecha`) AS `mes`,year(`timecontrollings`.`fecha`) AS `year`,`timecontrollings`.`createdAt` AS `createdAt`,`timecontrollings`.`updatedAt` AS `updatedAt` from `timecontrollings` group by `timecontrollings`.`usuario`,`timecontrollings`.`fecha` */;

--
-- Final view structure for view `r_usuario_hora_mes`
--

/*!50001 DROP VIEW IF EXISTS `r_usuario_hora_mes`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_usuario_hora_mes` AS select `r_usuario_fechas`.`usuario` AS `usuario`,round(sum(`r_usuario_fechas`.`horas`),2) AS `horas`,`r_usuario_fechas`.`mes` AS `mes`,`r_usuario_fechas`.`year` AS `year`,`r_usuario_fechas`.`createdAt` AS `createdAt`,`r_usuario_fechas`.`updatedAt` AS `updatedAt` from `r_usuario_fechas` group by `r_usuario_fechas`.`usuario`,`r_usuario_fechas`.`year`,`r_usuario_fechas`.`mes` */;

--
-- Final view structure for view `r_usuario_proyecto_sap_dia`
--

/*!50001 DROP VIEW IF EXISTS `r_usuario_proyecto_sap_dia`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_usuario_proyecto_sap_dia` AS select `timecontrollings`.`id` AS `id`,`usuarios`.`id` AS `usuario`,`usuarios`.`nombre` AS `nombreUsuario`,`centro_costos_sap`.`id` AS `idCentroCostoSap`,`centro_costos_sap`.`codigo` AS `codigo`,`centro_costos_sap`.`color` AS `color`,`centro_costos_sap`.`nombre` AS `nombreCentroCosto`,`proyectos_sap`.`id` AS `idProyectoSap`,`proyectos_sap`.`codigo` AS `codigoProyectoSap`,`proyectos_sap`.`descripcion` AS `nombreProyectoSap`,round(sum(`timecontrollings`.`horas`),2) AS `horas`,round(sum(`timecontrollings`.`porcentaje`),2) AS `porcentaje`,`timecontrollings`.`fecha` AS `fecha`,month(`timecontrollings`.`fecha`) AS `mes`,year(`timecontrollings`.`fecha`) AS `year`,`timecontrollings`.`createdAt` AS `createdAt`,`timecontrollings`.`updatedAt` AS `updatedAt` from (((`usuarios` join `centro_costos_sap`) join `timecontrollings`) join `proyectos_sap`) where `timecontrollings`.`centroCostoSap` = `centro_costos_sap`.`id` and `timecontrollings`.`usuario` = `usuarios`.`id` and `timecontrollings`.`proyectoSap` = `proyectos_sap`.`id` group by `usuarios`.`id`,`centro_costos_sap`.`id`,`proyectos_sap`.`id`,`timecontrollings`.`fecha`,month(`timecontrollings`.`fecha`),year(`timecontrollings`.`fecha`) order by `usuarios`.`id`,`timecontrollings`.`fecha` desc */;

--
-- Final view structure for view `r_usuario_tipo_tiempo_mes`
--

/*!50001 DROP VIEW IF EXISTS `r_usuario_tipo_tiempo_mes`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_usuario_tipo_tiempo_mes` AS select `timecontrollings`.`id` AS `id`,`timecontrollings`.`usuario` AS `usuario`,`timecontrollings`.`tipoTiempo` AS `tipoTiempo`,`tipo_tiempos`.`nombre` AS `nombreTipoTiempo`,round(sum(`timecontrollings`.`horas`),2) AS `horas`,`tipo_tiempos`.`color` AS `color`,month(`timecontrollings`.`fecha`) AS `mes`,year(`timecontrollings`.`fecha`) AS `year`,`timecontrollings`.`createdAt` AS `createdAt`,`timecontrollings`.`updatedAt` AS `updatedAt` from (`timecontrollings` join `tipo_tiempos`) where `timecontrollings`.`tipoTiempo` = `tipo_tiempos`.`id` group by `timecontrollings`.`usuario`,`timecontrollings`.`tipoTiempo`,month(`timecontrollings`.`fecha`),year(`timecontrollings`.`fecha`) */;

--
-- Final view structure for view `r_usuario_tipo_tiempos`
--

/*!50001 DROP VIEW IF EXISTS `r_usuario_tipo_tiempos`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `r_usuario_tipo_tiempos` AS select `timecontrollings`.`usuario` AS `usuario`,`timecontrollings`.`tipoTiempo` AS `tipoTiempo`,`tipo_tiempos`.`nombre` AS `nombreTipoTiempo`,round(sum(`timecontrollings`.`horas`),2) AS `horas`,`timecontrollings`.`fecha` AS `fecha`,month(`timecontrollings`.`fecha`) AS `mes`,year(`timecontrollings`.`fecha`) AS `year`,`timecontrollings`.`createdAt` AS `createdAt`,`timecontrollings`.`updatedAt` AS `updatedAt` from (`timecontrollings` join `tipo_tiempos`) where `timecontrollings`.`tipoTiempo` = `tipo_tiempos`.`id` group by `timecontrollings`.`usuario`,`timecontrollings`.`tipoTiempo`,`timecontrollings`.`fecha` */;

--
-- Final view structure for view `v_autorizaciones`
--

/*!50001 DROP VIEW IF EXISTS `v_autorizaciones`*/;

--
-- Final view structure for view `v_calendario`
--

/*!50001 DROP VIEW IF EXISTS `v_calendario`*/;

--
-- Final view structure for view `v_categoria_indicadores`
--

/*!50001 DROP VIEW IF EXISTS `v_categoria_indicadores`*/;

--
-- Final view structure for view `v_centro_costos`
--

/*!50001 DROP VIEW IF EXISTS `v_centro_costos`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_centro_costos` AS select `centro_costos`.`id` AS `id`,`centro_costos`.`categoria` AS `categoria`,`categoria_centro_costos`.`nombre` AS `nombreCategoria`,`centro_costos`.`codigo` AS `codigo`,`centro_costos`.`nombre` AS `nombre`,`centro_costos`.`estado` AS `estado`,`estados`.`nombre` AS `nombreEstado`,`centro_costos`.`color` AS `color`,`centro_costos`.`createdAt` AS `createdAt`,`centro_costos`.`updatedAt` AS `updatedAt` from ((`centro_costos` join `categoria_centro_costos`) join `estados`) where `centro_costos`.`categoria` = `categoria_centro_costos`.`id` and `centro_costos`.`estado` = `estados`.`id` */;

--
-- Final view structure for view `v_feriados`
--

/*!50001 DROP VIEW IF EXISTS `v_feriados`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_feriados` AS select `feriados`.`id` AS `id`,`feriados`.`fecha` AS `fecha`,`feriados`.`descripcion` AS `descripcion`,month(`feriados`.`fecha`) AS `mes`,year(`feriados`.`fecha`) AS `year`,`feriados`.`createdAt` AS `createdAt`,`feriados`.`updatedAt` AS `updatedAt` from `feriados` order by `feriados`.`fecha` desc */;

--
-- Final view structure for view `v_presupuesto_indicadores`
--

/*!50001 DROP VIEW IF EXISTS `v_presupuesto_indicadores`*/;

--
-- Final view structure for view `v_proyectos`
--

/*!50001 DROP VIEW IF EXISTS `v_proyectos`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_proyectos` AS select `proyectos`.`id` AS `id`,`proyectos`.`centroCosto` AS `centroCosto`,`centro_costos`.`nombre` AS `nombreCentroCosto`,`centro_costos`.`codigo` AS `codigo`,`proyectos`.`estado` AS `estado`,`estados`.`nombre` AS `nombreEstado`,`proyectos`.`area` AS `area`,`areas`.`nombre` AS `nombreArea`,`proyectos`.`nombre` AS `nombre`,`proyectos`.`descripcion` AS `descripcion`,`proyectos`.`createdAt` AS `createdAt`,`proyectos`.`updatedAt` AS `updatedAt` from (((`proyectos` join `areas`) join `estados`) join `centro_costos`) where `proyectos`.`centroCosto` = `centro_costos`.`id` and `proyectos`.`estado` = `estados`.`id` and `proyectos`.`area` = `areas`.`id` and `proyectos`.`id` > 0 order by `proyectos`.`id` desc */;

--
-- Final view structure for view `v_proyectos_sap`
--

/*!50001 DROP VIEW IF EXISTS `v_proyectos_sap`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_proyectos_sap` AS select `proyectos_sap`.`id` AS `id`,`proyectos_sap`.`codigo` AS `codigoProyectoSap`,`proyectos_sap`.`centroCostoSap` AS `centroCostoSap`,`centro_costos_sap`.`codigo` AS `codigoCentroCostoSap`,`centro_costos_sap`.`nombre` AS `nombreCentroCostoSap`,`proyectos_sap`.`descripcion` AS `descripcion`,`proyectos_sap`.`estado` AS `estado`,`estados`.`nombre` AS `nombreEstado`,`proyectos_sap`.`createdAt` AS `createdAt`,`proyectos_sap`.`updatedAt` AS `updatedAt` from ((`proyectos_sap` join `centro_costos_sap`) join `estados`) where `proyectos_sap`.`centroCostoSap` = `centro_costos_sap`.`id` and `proyectos_sap`.`estado` = `estados`.`id` */;

--
-- Final view structure for view `v_subareas`
--

/*!50001 DROP VIEW IF EXISTS `v_subareas`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_subareas` AS select `subareas`.`id` AS `id`,`subareas`.`nombre` AS `nombre`,`subareas`.`area` AS `area`,`areas`.`nombre` AS `nombreArea`,`subareas`.`descripcion` AS `descripcion`,`subareas`.`createdAt` AS `createdAt`,`subareas`.`updatedAt` AS `updatedAt` from (`subareas` join `areas`) where `subareas`.`area` = `areas`.`id` */;

--
-- Final view structure for view `v_subcategoria_indicadores`
--

/*!50001 DROP VIEW IF EXISTS `v_subcategoria_indicadores`*/;

--
-- Final view structure for view `v_timecontrollings`
--

/*!50001 DROP VIEW IF EXISTS `v_timecontrollings`*/;

--
-- Final view structure for view `v_usuario_categoria_indicadores`
--

/*!50001 DROP VIEW IF EXISTS `v_usuario_categoria_indicadores`*/;

--
-- Final view structure for view `v_usuario_centro_costos`
--

/*!50001 DROP VIEW IF EXISTS `v_usuario_centro_costos`*/;

--
-- Final view structure for view `v_usuario_centro_costos_sap`
--

/*!50001 DROP VIEW IF EXISTS `v_usuario_centro_costos_sap`*/;

--
-- Final view structure for view `v_usuario_subareas`
--

/*!50001 DROP VIEW IF EXISTS `v_usuario_subareas`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_usuario_subareas` AS select `usuario_subareas`.`id` AS `id`,`usuario_subareas`.`usuario` AS `usuario`,`usuarios`.`nombre` AS `nombreUsuario`,`usuario_subareas`.`subarea` AS `subarea`,`subareas`.`nombre` AS `nombreSubarea`,`areas`.`id` AS `area`,`areas`.`nombre` AS `nombreArea`,`usuario_subareas`.`createdAt` AS `createdAt`,`usuario_subareas`.`updatedAt` AS `updatedAt` from (((`usuarios` join `areas`) join `subareas`) join `usuario_subareas`) where `usuario_subareas`.`usuario` = `usuarios`.`id` and `usuario_subareas`.`subarea` = `subareas`.`id` and `subareas`.`area` = `areas`.`id` order by `usuarios`.`nombre` */;

--
-- Final view structure for view `v_usuario_subcategoria_indicadores`
--

/*!50001 DROP VIEW IF EXISTS `v_usuario_subcategoria_indicadores`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_usuario_subcategoria_indicadores` AS select distinct `usuarios`.`id` AS `id`,`usuarios`.`nombre` AS `nombreUsuario`,`areas`.`id` AS `area`,`areas`.`nombre` AS `nombreArea`,`usuarios`.`createdAt` AS `createdAt`,`usuarios`.`updatedAt` AS `updatedAt` from ((`usuarios` join `areas`) join `subcategoria_indicadores`) where `usuarios`.`area` = `areas`.`id` and `subcategoria_indicadores`.`responsable` = `usuarios`.`id` and `usuarios`.`id` <> 1 order by `usuarios`.`nombre` */;

--
-- Final view structure for view `v_usuarios`
--

/*!50001 DROP VIEW IF EXISTS `v_usuarios`*/;
/*!50001 CREATE ALGORITHM=UNDEFINED */
/*!50013 DEFINER=`root`@`localhost` SQL SECURITY DEFINER */
/*!50001 VIEW `v_usuarios` AS select `usuarios`.`id` AS `id`,`usuarios`.`nombre` AS `nombre`,`usuarios`.`email` AS `email`,`usuarios`.`telefono` AS `telefono`,`usuarios`.`rut` AS `rut`,`usuarios`.`password` AS `password`,`usuarios`.`role` AS `role`,`usuarios`.`horas` AS `horas`,`usuarios`.`horasD1` AS `horasD1`,`usuarios`.`horasD2` AS `horasD2`,`usuarios`.`horasD3` AS `horasD3`,`usuarios`.`horasD4` AS `horasD4`,`usuarios`.`horasD5` AS `horasD5`,`usuarios`.`estado` AS `estado`,`estados`.`nombre` AS `nombreEstado`,`usuarios`.`zona` AS `zona`,`zonas`.`nombre` AS `nombreZona`,`usuarios`.`area` AS `area`,`areas`.`nombre` AS `nombreArea`,`usuarios`.`cargo` AS `cargo`,`cargos`.`nombre` AS `nombreCargo`,`usuarios`.`img` AS `img`,`usuarios`.`descripcion` AS `descripcion`,`usuarios`.`visualizacion` AS `visualizacion`,`usuarios`.`createdAt` AS `createdAt`,`usuarios`.`updatedAt` AS `updatedAt` from (((((`usuarios` join `estados`) join `zonas`) join `areas`) join `cargos`) join `roles`) where `usuarios`.`estado` = `estados`.`id` and `usuarios`.`role` = `roles`.`id` and `usuarios`.`zona` = `zonas`.`id` and `usuarios`.`area` = `areas`.`id` and `usuarios`.`cargo` = `cargos`.`id` and `usuarios`.`id` > 0 */;


