-- MySQL dump 10.13  Distrib 8.0.31, for Win64 (x86_64)
--
-- Host: 35.225.233.105    Database: intralog_impo
-- ------------------------------------------------------
-- Server version	5.7.44-google-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `ds_tarifario_closed_date`
--

DROP TABLE IF EXISTS `ds_tarifario_closed_date`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ds_tarifario_closed_date` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fecha` date DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `semana` int(11) DEFAULT NULL,
  `fte_total` int(11) DEFAULT NULL,
  `volumen_cotizaciones_total` int(11) DEFAULT NULL,
  `cerrados` int(11) DEFAULT NULL,
  `win_ration_objectiv_total` float DEFAULT NULL,
  `win_ratio_total` float DEFAULT NULL,
  `incidencias_calidad_total` int(11) DEFAULT NULL,
  `incidencias_tiempo_total` int(11) DEFAULT NULL,
  `quality_objective_total` float DEFAULT NULL,
  `quality_performance_total` float DEFAULT NULL,
  `productividad_cot_x_fte_x_dia_total` float DEFAULT NULL,
  `fte_pa` int(11) DEFAULT NULL,
  `volumen_cotizaciones_pa` int(11) DEFAULT NULL,
  `cerrados_pa` int(11) DEFAULT NULL,
  `win_ratio_pa` float DEFAULT NULL,
  `productividad_cot_x_fte_x_dia_pa` float DEFAULT NULL,
  `fte_pe` int(11) DEFAULT NULL,
  `volumen_cotizaciones_pe` int(11) DEFAULT NULL,
  `cerrados_pe` int(11) DEFAULT NULL,
  `win_ratio_pe` float DEFAULT NULL,
  `productividad_cot_x_fte_x_dia_pe` float DEFAULT NULL,
  `fte_pp` int(11) DEFAULT NULL,
  `volumen_cotizaciones_pp` int(11) DEFAULT NULL,
  `cerrados_pp` int(11) DEFAULT NULL,
  `win_ratio_pp` float DEFAULT NULL,
  `productividad_cot_x_fte_x_dia_pp` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ds_tarifario_closed_date`
--

LOCK TABLES `ds_tarifario_closed_date` WRITE;
/*!40000 ALTER TABLE `ds_tarifario_closed_date` DISABLE KEYS */;
INSERT INTO `ds_tarifario_closed_date` VALUES (1,'2020-01-01',2020,1,7,76,13,16,17.11,0,0,90,100,2.07,2,40,7,17.5,3.81,4,36,6,16.67,1.71,0,0,0,0,0),(2,'2020-01-06',2020,2,7,316,74,16,23.42,0,0,90,100,8.6,2,120,22,18.33,11.43,4,196,52,26.53,9.33,0,0,0,0,0),(3,'2020-01-13',2020,3,7,333,83,16,24.92,0,0,90,100,9.06,2,155,33,21.29,14.76,4,178,50,28.09,8.48,0,0,0,0,0),(4,'2020-01-20',2020,4,7,318,69,16,21.7,3,2,90,98.43,8.65,2,108,25,23.15,10.29,4,210,44,20.95,10,0,0,0,0,0),(5,'2020-01-27',2020,5,7,419,71,16,16.95,1,4,90,98.81,11.4,2,122,25,20.49,11.62,4,297,46,15.49,14.14,0,0,0,0,0),(6,'2020-02-03',2020,6,7,323,58,16,17.96,3,1,90,98.76,8.79,2,129,23,17.83,12.29,4,194,35,18.04,9.24,0,0,0,0,0),(7,'2020-02-10',2020,7,7,436,68,16,15.6,6,1,90,98.39,11.86,2,174,25,14.37,16.57,4,262,43,16.41,12.48,0,0,0,0,0),(8,'2020-02-17',2020,8,7,406,60,16,14.78,1,0,90,99.75,11.05,2,165,19,11.52,15.71,4,241,41,17.01,11.48,0,0,0,0,0),(9,'2020-02-24',2020,9,7,419,67,16,15.99,0,0,90,100,11.4,2,161,28,17.39,15.33,4,258,39,15.12,12.29,0,0,0,0,0),(10,'2020-03-02',2020,10,7,434,76,16,17.51,3,0,90,99.31,11.81,2,180,26,14.44,17.14,4,254,50,19.69,12.1,0,0,0,0,0),(11,'2020-03-09',2020,11,7,398,74,16,18.59,1,2,90,99.25,10.83,2,196,24,12.24,18.67,4,200,50,25,9.52,1,2,0,0,0.4),(12,'2020-03-16',2020,12,7,332,70,16,21.08,4,4,90,97.59,9.03,2,148,28,18.92,14.1,4,184,42,22.83,8.76,1,0,0,0,0),(13,'2020-03-23',2020,13,7,346,99,16,28.61,4,1,90,98.55,9.41,2,149,32,21.48,14.19,4,197,67,34.01,9.38,1,0,0,0,0),(14,'2020-03-30',2020,14,7,262,61,16,23.28,3,0,90,98.85,7.13,2,106,23,21.7,10.1,4,156,38,24.36,7.43,1,0,0,0,0),(15,'2020-04-06',2020,15,7,143,40,17,27.97,1,1,90,98.6,3.89,2,66,15,22.73,6.29,4,77,25,32.47,3.67,1,0,0,0,0),(16,'2020-04-13',2020,16,7,361,80,17,22.16,0,0,90,100,9.82,2,103,19,18.45,9.81,4,218,47,21.56,10.38,1,40,14,35,7.6),(17,'2020-04-20',2020,17,7,361,88,17,24.38,3,3,90,98.34,9.82,2,77,20,25.97,7.33,4,202,50,24.75,9.62,1,82,18,22,15.6),(18,'2020-04-27',2020,18,7,285,59,17,20.7,2,0,90,99.3,7.76,2,52,13,25,4.95,4,165,33,20,7.86,1,68,13,19,13),(19,'2020-05-04',2020,19,7,355,63,17,17.75,1,1,90,99.44,9.66,2,63,9,14.29,6,4,219,44,20.09,10.43,1,73,10,14,13.9),(20,'2020-05-11',2020,20,7,413,91,17,22.03,1,0,90,99.76,11.24,2,100,10,10,9.52,4,221,64,28.96,10.52,1,92,17,18,17.5),(21,'2020-05-18',2020,21,7,385,70,17,18.18,0,0,90,100,10.48,2,86,10,11.63,8.19,4,221,48,21.72,10.52,1,78,12,15,14.9),(22,'2020-05-25',2020,22,7,401,78,17,19.45,1,2,90,99.25,10.91,2,62,17,27.42,5.9,4,255,55,21.57,12.14,1,84,6,7,16),(23,'2020-06-01',2020,23,7,480,87,17,18.13,0,1,90,99.79,13.06,2,53,13,24.53,5.05,4,255,49,19.22,12.14,1,172,25,15,32.8),(24,'2020-06-08',2020,24,7,498,84,17,16.87,0,0,90,100,13.55,2,70,17,24.29,6.67,4,248,53,21.37,11.81,1,180,14,8,34.3),(25,'2020-06-15',2020,25,7,445,102,17,22.92,0,0,90,100,12.11,2,63,31,49.21,6,4,256,56,21.88,12.19,1,126,15,12,24),(26,'2020-06-22',2020,26,7,438,86,17,19.63,0,0,90,100,11.92,2,68,17,25,6.48,4,233,51,21.89,11.1,1,137,18,13,26.1),(27,'2020-06-29',2020,27,7,425,99,17,23.29,0,0,90,100,11.56,2,72,22,30.56,6.86,4,242,58,23.97,11.52,1,111,19,17,21.1),(28,'2020-07-06',2020,28,7,414,95,17,22.95,1,0,90,99.76,11.27,2,43,24,55.81,4.1,4,268,52,19.4,12.76,1,103,19,18,19.6),(29,'2020-07-13',2020,29,7,476,102,17,21.43,0,0,90,100,12.95,2,63,24,38.1,6,4,305,60,19.67,14.52,1,108,18,17,20.6),(30,'2020-07-20',2020,30,7,444,108,18,24.32,0,0,90,100,12.08,2,60,22,36.67,5.71,4,270,68,25.19,12.86,1,114,18,16,21.7),(31,'2020-07-27',2020,31,7,386,93,18,24.09,0,0,90,100,10.5,2,52,26,50,4.95,4,239,53,22.18,11.38,1,95,14,15,18.1),(32,'2020-08-03',2020,32,7,429,110,18,25.64,0,0,90,100,11.67,2,71,32,45.07,6.76,4,264,66,25,12.57,1,94,12,13,17.9),(33,'2020-08-10',2020,33,7,400,104,18,26,0,0,90,100,10.88,2,76,33,43.42,7.24,4,248,54,21.77,11.81,1,76,17,22,14.5),(34,'2020-08-17',2020,34,7,375,93,18,24.8,0,0,90,100,10.2,2,48,19,39.58,4.57,4,244,51,20.9,11.62,1,83,23,28,15.8),(35,'2020-08-24',2020,35,7,414,88,18,21.26,0,0,90,100,11.27,2,63,17,26.98,6,4,268,58,21.64,12.76,1,83,13,16,15.8),(36,'2020-08-31',2020,36,7,388,97,18,25,0,0,90,100,10.56,2,55,21,38.18,5.24,4,248,58,23.39,11.81,1,85,18,21,16.2),(37,'2020-09-07',2020,37,7,442,99,18,22.4,0,0,90,100,12.03,2,63,20,31.75,6,4,283,60,21.2,13.48,1,96,19,20,18.3),(38,'2020-09-14',2020,38,7,368,86,18,23.37,0,0,90,100,10.01,2,46,16,34.78,4.38,4,215,59,27.44,10.24,1,107,11,10,20.4),(39,'2020-09-21',2020,39,7,448,114,18,25.45,0,0,90,100,12.19,2,64,25,39.06,6.1,4,264,75,28.41,12.57,1,120,14,12,22.9),(40,'2020-09-28',2020,40,7,447,103,18,23.04,0,0,90,100,12.16,2,60,26,43.33,5.71,4,259,66,25.48,12.33,1,128,11,9,24.4),(41,'2020-10-05',2020,41,7,384,103,18,26.82,0,0,90,100,10.45,2,66,29,43.94,6.29,4,210,51,24.29,10,1,108,23,21,20.6),(42,'2020-10-12',2020,42,7,424,105,18,24.76,0,0,90,100,11.54,2,68,26,38.24,6.48,4,239,63,26.36,11.38,1,117,16,14,22.3),(43,'2020-10-19',2020,43,7,487,126,18,25.87,0,0,90,100,13.25,2,92,37,40.22,8.76,4,272,72,26.47,12.95,1,123,17,14,23.4),(44,'2020-10-26',2020,44,7,427,86,18,20.14,0,0,90,100,11.62,2,59,18,30.51,5.62,4,247,56,22.67,11.76,1,121,12,10,23),(45,'2020-11-02',2020,45,7,381,108,18,28.35,0,0,90,100,10.37,2,55,28,50.91,5.24,4,221,63,28.51,10.52,1,105,17,16,20),(46,'2020-11-09',2020,46,7,461,104,18,22.56,0,0,90,100,12.54,2,71,17,23.94,6.76,4,281,70,24.91,13.38,1,109,17,16,20.8),(47,'2020-11-16',2020,47,7,362,85,18,23.48,0,0,90,100,9.85,2,42,17,40.48,4,4,216,50,23.15,10.29,1,104,18,17,19.8),(48,'2020-11-23',2020,48,7,431,113,18,26.22,0,0,90,100,11.73,2,69,24,34.78,6.57,4,273,74,27.11,13,1,89,15,17,17),(49,'2020-11-30',2020,49,7,375,101,18,26.93,0,0,90,100,10.2,2,69,34,49.28,6.57,4,210,50,23.81,10,1,96,17,18,18.3),(50,'2020-12-07',2020,50,7,395,82,18,20.76,0,0,90,100,10.75,2,53,16,30.19,5.05,4,238,49,20.59,11.33,1,104,17,16,19.8),(51,'2020-12-14',2020,51,7,350,77,18,22,0,0,90,100,9.52,2,58,17,29.31,5.52,4,228,44,19.3,10.86,1,64,16,25,12.2),(52,'2020-12-21',2020,52,7,193,40,18,20.73,0,0,90,100,5.25,2,32,11,34.38,3.05,4,113,16,14.16,5.38,1,48,13,27,9.1),(53,'2021-01-04',2021,1,8,0,0,18,0,0,0,90,0,0,2,0,0,0,0,5,4,1,25,0.15,1,0,0,0,0),(54,'2021-01-11',2021,2,8,316,86,18,27.22,4,0,90,98.73,7.52,2,47,18,38.3,4.48,5,199,49,24.62,7.58,1,70,19,27,13.3),(55,'2021-01-18',2021,3,8,387,99,18,25.58,3,0,90,99.22,9.21,2,80,22,27.5,7.62,5,256,63,24.61,9.75,1,51,14,27,9.7),(56,'2021-01-25',2021,4,8,433,89,18,20.55,0,0,90,100,10.31,2,120,25,20.83,11.43,5,280,55,19.64,10.67,1,33,9,27,6.3),(57,'2021-02-01',2021,5,8,441,73,18,16.55,0,0,90,100,10.5,2,104,0,0,9.9,5,290,73,25.17,11.05,1,47,0,0,9),(58,'2021-02-08',2021,6,8,293,64,18,21.84,0,0,90,100,6.98,2,96,18,18.75,9.14,5,161,36,22.36,6.13,1,36,10,28,6.9),(59,'2021-02-15',2021,7,8,382,75,18,19.63,1,0,90,99.74,9.1,2,95,17,17.89,9.05,5,248,47,18.95,9.45,1,39,11,28,7.4),(60,'2021-02-22',2021,8,8,406,123,18,30.3,0,0,90,100,9.67,2,110,29,26.36,10.48,5,264,79,29.92,10.06,1,32,15,47,6.1),(61,'2021-03-01',2021,9,8,478,87,18,18.2,1,0,90,99.79,11.38,2,125,19,15.2,11.9,5,298,55,18.46,11.35,1,55,13,24,10.5),(62,'2021-03-08',2021,10,8,488,110,18,22.54,0,0,90,100,11.62,2,120,22,18.33,11.43,5,319,72,22.57,12.15,1,49,16,33,9.3),(63,'2021-03-15',2021,11,8,469,124,18,26.44,0,0,90,100,11.17,2,109,25,22.94,10.38,5,304,85,27.96,11.58,1,56,14,25,10.7),(64,'2021-03-22',2021,12,8,405,91,18,22.47,0,0,90,100,9.64,2,111,17,15.32,10.57,5,237,66,27.85,9.03,1,57,8,14,10.9),(65,'2021-03-29',2021,13,0,387,84,0,21.71,0,0,90,100,0,0,131,25,19.08,0,0,195,42,21.54,0,1,61,17,28,11.6),(66,'2021-04-11',2021,14,8,286,62,18,0.2168,0,0,90,1,6.81,2,69,21,0.3,6.57,5,1,1,1,0.04,1,45,6,0.13,8.57),(67,'2021-04-17',2021,15,8,284,57,18,0.2007,1,0,90,0.9965,6.76,2,69,21,0.3,6.57,5,1,1,1,0.04,1,45,6,0.13,8.57),(68,'2021-04-23',2021,16,8,334,36,18,0.1078,0,0,90,1,7.95,2,69,21,0.3,6.57,5,1,1,1,0.04,1,45,6,0.13,8.57),(69,'2021-05-02',2021,17,8,214,59,18,0.2757,0,0,90,1,5.1,2,69,21,0.3,6.57,5,1,1,1,0.04,1,45,6,0.13,8.57),(70,'2021-05-07',2021,18,8,227,44,18,0.1938,0,0,90,1,5.4,2,69,21,0.3,6.57,5,1,1,1,0.04,1,45,6,0.13,8.57),(71,'2021-05-14',2021,19,8,231,34,18,0.1472,0,0,90,1,5.5,2,69,21,0.3,6.57,5,1,1,1,0.04,1,45,6,0.13,8.57),(72,'2021-05-21',2021,20,8,206,39,18,0.1893,1,0,90,0.9951,4.9,2,69,21,0.3,6.57,5,1,1,1,0.04,1,45,6,0.13,8.57),(73,'2021-05-30',2021,21,8,229,21,18,0.0917,0,0,90,1,5.45,2,69,21,0.3,6.57,5,1,1,1,0.04,1,45,6,0.13,8.57),(74,'2021-05-31',2021,22,8,40,1,18,0.025,0,0,90,1,0.95,2,69,21,0.3,6.57,5,1,1,1,0.04,1,45,6,0.13,8.57),(75,NULL,2021,23,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(76,NULL,2021,24,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(77,NULL,2021,25,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(78,NULL,2021,26,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(79,NULL,2021,27,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(80,NULL,2021,28,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(81,NULL,2021,29,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(82,NULL,2021,30,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(83,NULL,2021,31,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(84,NULL,2021,32,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(85,NULL,2021,33,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(86,NULL,2021,34,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(87,NULL,2021,35,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(88,NULL,2021,36,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(89,NULL,2021,37,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(90,NULL,2021,38,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(91,NULL,2021,39,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(92,NULL,2021,40,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(93,NULL,2021,41,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(94,NULL,2021,42,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(95,NULL,2021,43,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(96,NULL,2021,44,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(97,NULL,2021,45,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(98,NULL,2021,46,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(99,NULL,2021,47,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(100,NULL,2021,48,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(101,NULL,2021,49,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(102,NULL,2021,50,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(103,NULL,2021,51,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0),(104,NULL,2021,52,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0);
/*!40000 ALTER TABLE `ds_tarifario_closed_date` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-07-25 20:39:24
