-- 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_emp`
--

DROP TABLE IF EXISTS `ds_tarifario_closed_date_emp`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ds_tarifario_closed_date_emp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `fecha` date DEFAULT NULL,
  `anio` int(11) DEFAULT NULL,
  `mes` varchar(45) DEFAULT NULL,
  `ejecutivo_de_ventas` varchar(45) DEFAULT NULL,
  `fup` int(11) DEFAULT NULL,
  `cerrados` int(11) DEFAULT NULL,
  `ganados` int(11) DEFAULT NULL,
  `win_ratio` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=294 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ds_tarifario_closed_date_emp`
--

LOCK TABLES `ds_tarifario_closed_date_emp` WRITE;
/*!40000 ALTER TABLE `ds_tarifario_closed_date_emp` DISABLE KEYS */;
INSERT INTO `ds_tarifario_closed_date_emp` VALUES (1,'2020-01-01',2020,'ene.','AGENTES',0,328,64,19.51),(2,'2020-02-01',2020,'feb.','AGENTES',0,560,103,18.39),(3,'2020-03-01',2020,'mar.','AGENTES',0,692,94,13.58),(4,'2020-04-01',2020,'abr.','AGENTES',0,507,159,31.36),(5,'2020-05-01',2020,'may.','AGENTES',0,422,101,23.93),(6,'2020-06-01',2020,'jun.','AGENTES',0,426,150,35.21),(7,'2020-07-01',2020,'jul.','AGENTES',0,587,178,30.32),(8,'2020-08-01',2020,'ago.','AGENTES',0,0,0,0),(9,'2020-09-01',2020,'sep.','AGENTES',0,636,148,23.27),(10,'2020-10-01',2020,'oct.','AGENTES',562,626,157,25.08),(11,'2020-11-01',2020,'nov.','AGENTES',484,683,131,19.18),(12,'2020-12-01',2020,'dic.','AGENTES',355,184,154,83.7),(13,'2021-01-01',2021,'ene.','AGENTES',0,0,0,0),(14,'2021-02-01',2021,'feb.','AGENTES',0,0,0,0),(15,'2021-03-01',2021,'mar.','AGENTES',0,0,0,0),(16,'2021-04-01',2021,'abr.','AGENTES',0,0,0,0),(17,'2021-05-01',2021,'may.','AGENTES',0,0,0,0),(18,'2021-06-01',2021,'jun.','AGENTES',0,0,0,0),(19,'2021-07-01',2021,'jul.','AGENTES',0,0,0,0),(20,'2021-08-01',2021,'ago.','AGENTES',0,0,0,0),(21,'2021-09-01',2021,'sep.','AGENTES',0,0,0,0),(22,'2021-10-01',2021,'oct.','AGENTES',0,0,0,0),(23,'2021-11-01',2021,'nov.','AGENTES',0,0,0,0),(24,'2021-12-01',2021,'dic.','AGENTES',0,0,0,0),(25,'2020-01-01',2020,'ene.','ARASCON',0,17,8,47.06),(26,'2020-02-01',2020,'feb.','ARASCON',0,17,3,17.65),(27,'2020-03-01',2020,'mar.','ARASCON',0,13,1,7.69),(28,'2020-04-01',2020,'abr.','ARASCON',0,16,5,31.25),(29,'2020-05-01',2020,'may.','ARASCON',0,14,4,28.57),(30,'2020-06-01',2020,'jun.','ARASCON',0,20,6,30),(31,'2020-07-01',2020,'jul.','ARASCON',0,39,10,25.64),(32,'2020-08-01',2020,'ago.','ARASCON',0,0,0,0),(33,'2020-09-01',2020,'sep.','ARASCON',0,15,2,13.33),(34,'2020-10-01',2020,'oct.','ARASCON',0,22,4,18.18),(35,'2020-11-01',2020,'nov.','ARASCON',1,16,2,12.5),(36,'2020-12-01',2020,'dic.','ARASCON',3,24,6,25),(37,'2021-01-01',2021,'ene.','ARASCON',0,0,0,0),(38,'2021-02-01',2021,'feb.','ARASCON',0,0,0,0),(39,'2021-03-01',2021,'mar.','ARASCON',0,0,0,0),(40,'2021-04-01',2021,'abr.','ARASCON',17,8,7,0.875),(41,'2021-05-01',2021,'may.','ARASCON',0,3,3,1),(42,'2021-06-01',2021,'jun.','ARASCON',0,0,0,0),(43,'2021-07-01',2021,'jul.','ARASCON',0,0,0,0),(44,'2021-08-01',2021,'ago.','ARASCON',0,0,0,0),(45,'2021-09-01',2021,'sep.','ARASCON',0,0,0,0),(46,'2021-10-01',2021,'oct.','ARASCON',0,0,0,0),(47,'2021-11-01',2021,'nov.','ARASCON',0,0,0,0),(48,'2021-12-01',2021,'dic.','ARASCON',0,0,0,0),(49,'2020-01-01',2020,'ene.','BDELRIO',0,35,20,57.14),(50,'2020-02-01',2020,'feb.','BDELRIO',0,81,14,17.28),(51,'2020-03-01',2020,'mar.','BDELRIO',0,139,34,24.46),(52,'2020-04-01',2020,'abr.','BDELRIO',0,62,22,35.48),(53,'2020-05-01',2020,'may.','BDELRIO',0,74,23,31.08),(54,'2020-06-01',2020,'jun.','BDELRIO',0,79,31,39.24),(55,'2020-07-01',2020,'jul.','BDELRIO',0,107,19,17.76),(56,'2020-08-01',2020,'ago.','BDELRIO',0,0,0,0),(57,'2020-09-01',2020,'sep.','BDELRIO',0,99,26,26.26),(58,'2020-10-01',2020,'oct.','BDELRIO',0,87,22,25.29),(59,'2020-11-01',2020,'nov.','BDELRIO',1,90,29,32.22),(60,'2020-12-01',2020,'dic.','BDELRIO',11,69,23,33.33),(61,'2021-01-01',2021,'ene.','BDELRIO',0,0,0,0),(62,'2021-02-01',2021,'feb.','BDELRIO',0,0,0,0),(63,'2021-03-01',2021,'mar.','BDELRIO',0,0,0,0),(64,'2021-04-01',2021,'abr.','BDELRIO',25,12,13,1.0833),(65,'2021-05-01',2021,'may.','BDELRIO',3,8,8,1),(66,'2021-06-01',2021,'jun.','BDELRIO',0,0,0,0),(67,'2021-07-01',2021,'jul.','BDELRIO',0,0,0,0),(68,'2021-08-01',2021,'ago.','BDELRIO',0,0,0,0),(69,'2021-09-01',2021,'sep.','BDELRIO',0,0,0,0),(70,'2021-10-01',2021,'oct.','BDELRIO',0,0,0,0),(71,'2021-11-01',2021,'nov.','BDELRIO',0,0,0,0),(72,'2021-12-01',2021,'dic.','BDELRIO',0,0,0,0),(73,'2020-01-01',2020,'ene.','EBARRERA',0,3,2,66.67),(74,'2020-02-01',2020,'feb.','EBARRERA',0,8,3,37.5),(75,'2020-03-01',2020,'mar.','EBARRERA',0,10,10,100),(76,'2020-04-01',2020,'abr.','EBARRERA',0,9,8,88.89),(77,'2020-05-01',2020,'may.','EBARRERA',0,25,12,48),(78,'2020-06-01',2020,'jun.','EBARRERA',0,52,27,51.92),(79,'2020-07-01',2020,'jul.','EBARRERA',0,52,18,34.62),(80,'2020-08-01',2020,'ago.','EBARRERA',0,0,0,0),(81,'2020-09-01',2020,'sep.','EBARRERA',0,60,20,33.33),(82,'2020-10-01',2020,'oct.','EBARRERA',0,70,34,48.57),(83,'2020-11-01',2020,'nov.','EBARRERA',0,83,34,40.96),(84,'2020-12-01',2020,'dic.','EBARRERA',4,31,20,64.52),(85,'2021-01-01',2021,'ene.','EBARRERA',0,0,0,0),(86,'2021-02-01',2021,'feb.','EBARRERA',0,0,0,0),(87,'2021-03-01',2021,'mar.','EBARRERA',0,0,0,0),(88,'2021-04-01',2021,'abr.','EBARRERA',4,34,34,1),(89,'2021-05-01',2021,'may.','EBARRERA',0,3,3,1),(90,'2021-06-01',2021,'jun.','EBARRERA',0,0,0,0),(91,'2021-07-01',2021,'jul.','EBARRERA',0,0,0,0),(92,'2021-08-01',2021,'ago.','EBARRERA',0,0,0,0),(93,'2021-09-01',2021,'sep.','EBARRERA',0,0,0,0),(94,'2021-10-01',2021,'oct.','EBARRERA',0,0,0,0),(95,'2021-11-01',2021,'nov.','EBARRERA',0,0,0,0),(96,'2021-12-01',2021,'dic.','EBARRERA',0,0,0,0),(97,'2020-01-01',2020,'ene.','GFUENTES',0,121,45,37.19),(98,'2020-02-01',2020,'feb.','GFUENTES',0,223,38,17.04),(99,'2020-03-01',2020,'mar.','GFUENTES',0,187,53,28.34),(100,'2020-04-01',2020,'abr.','GFUENTES',0,126,43,34.13),(101,'2020-05-01',2020,'may.','GFUENTES',0,185,51,27.57),(102,'2020-06-01',2020,'jun.','GFUENTES',0,202,50,24.75),(103,'2020-07-01',2020,'jul.','GFUENTES',0,259,58,22.39),(104,'2020-08-01',2020,'ago.','GFUENTES',0,0,0,0),(105,'2020-09-01',2020,'sep.','GFUENTES',0,233,70,30.04),(106,'2020-10-01',2020,'oct.','GFUENTES',0,279,70,25.09),(107,'2020-11-01',2020,'nov.','GFUENTES',0,282,87,30.85),(108,'2020-12-01',2020,'dic.','GFUENTES',44,179,41,22.91),(109,'2021-01-01',2021,'ene.','GFUENTES',0,0,0,0),(110,'2021-02-01',2021,'feb.','GFUENTES',0,0,0,0),(111,'2021-03-01',2021,'mar.','GFUENTES',0,0,0,0),(112,'2021-04-01',2021,'abr.','GFUENTES',52,11,10,0.9091),(113,'2020-05-01',2021,'may.','GFUENTES',0,0,0,0),(114,'2021-06-01',2021,'jun.','GFUENTES',0,0,0,0),(115,'2021-07-01',2021,'jul.','GFUENTES',0,0,0,0),(116,'2021-08-01',2021,'ago.','GFUENTES',0,0,0,0),(117,'2021-09-01',2021,'sep.','GFUENTES',0,0,0,0),(118,'2021-10-01',2021,'oct.','GFUENTES',0,0,0,0),(119,'2021-11-01',2021,'nov.','GFUENTES',0,0,0,0),(120,'2021-12-01',2021,'dic.','GFUENTES',0,0,0,0),(121,'2020-01-01',2020,'ene.','GRAMIREZ',0,90,28,31.11),(122,'2020-02-01',2020,'feb.','GRAMIREZ',0,193,36,18.65),(123,'2020-03-01',2020,'mar.','GRAMIREZ',0,178,41,23.03),(124,'2020-04-01',2020,'abr.','GRAMIREZ',0,90,21,23.33),(125,'2020-05-01',2020,'may.','GRAMIREZ',0,98,35,35.71),(126,'2020-06-01',2020,'jun.','GRAMIREZ',0,122,35,28.69),(127,'2020-07-01',2020,'jul.','GRAMIREZ',0,218,47,21.56),(128,'2020-08-01',2020,'ago.','GRAMIREZ',0,0,0,0),(129,'2020-09-01',2020,'sep.','GRAMIREZ',0,200,49,24.5),(130,'2020-10-01',2020,'oct.','GRAMIREZ',0,179,47,26.26),(131,'2020-11-01',2020,'nov.','GRAMIREZ',0,208,38,18.27),(132,'2020-12-01',2020,'dic.','GRAMIREZ',51,182,26,14.29),(133,'2021-01-01',2021,'ene.','GRAMIREZ',0,0,0,0),(134,'2021-02-01',2021,'feb.','GRAMIREZ',0,0,0,0),(135,'2021-03-01',2021,'mar.','GRAMIREZ',0,0,0,0),(136,'2021-04-01',2021,'abr.','GRAMIREZ',137,32,32,1),(137,'2021-05-01',2021,'may.','GRAMIREZ',0,3,3,1),(138,'2021-06-01',2021,'jun.','GRAMIREZ',0,0,0,0),(139,'2021-07-01',2021,'jul.','GRAMIREZ',0,0,0,0),(140,'2021-08-01',2021,'ago.','GRAMIREZ',0,0,0,0),(141,'2021-09-01',2021,'sep.','GRAMIREZ',0,0,0,0),(142,'2021-10-01',2021,'oct.','GRAMIREZ',0,0,0,0),(143,'2021-11-01',2021,'nov.','GRAMIREZ',0,0,0,0),(144,'2021-12-01',2021,'dic.','GRAMIREZ',0,0,0,0),(145,'2020-01-01',2020,'ene.','IBARRAGAN',0,48,21,43.75),(146,'2020-02-01',2020,'feb.','IBARRAGAN',0,174,38,21.84),(147,'2020-03-01',2020,'mar.','IBARRAGAN',0,144,18,12.5),(148,'2020-04-01',2020,'abr.','IBARRAGAN',0,80,29,36.25),(149,'2020-05-01',2020,'may.','IBARRAGAN',0,135,22,16.3),(150,'2020-06-01',2020,'jun.','IBARRAGAN',0,135,32,23.7),(151,'2020-07-01',2020,'jul.','IBARRAGAN',0,158,28,17.72),(152,'2020-08-01',2020,'ago.','IBARRAGAN',0,0,0,0),(153,'2020-09-01',2020,'sep.','IBARRAGAN',0,177,42,23.73),(154,'2020-10-01',2020,'oct.','IBARRAGAN',0,172,33,19.19),(155,'2020-11-01',2020,'nov.','IBARRAGAN',0,182,24,13.19),(156,'2020-12-01',2020,'dic.','IBARRAGAN',31,150,15,10),(157,'2021-01-01',2021,'ene.','IBARRAGAN',0,0,0,0),(158,'2021-02-01',2021,'feb.','IBARRAGAN',0,0,0,0),(159,'2021-03-01',2021,'mar.','IBARRAGAN',0,0,0,0),(160,'2021-04-01',2021,'abr.','IBARRAGAN',77,27,26,0.963),(161,'2021-05-01',2021,'may.','IBARRAGAN',3,3,3,1),(162,'2021-06-01',2021,'jun.','IBARRAGAN',0,0,0,0),(163,'2021-07-01',2021,'jul.','IBARRAGAN',0,0,0,0),(164,'2021-08-01',2021,'ago.','IBARRAGAN',0,0,0,0),(165,'2021-09-01',2021,'sep.','IBARRAGAN',0,0,0,0),(166,'2021-10-01',2021,'oct.','IBARRAGAN',0,0,0,0),(167,'2021-11-01',2021,'nov.','IBARRAGAN',0,0,0,0),(168,'2021-12-01',2021,'dic.','IBARRAGAN',0,0,0,0),(169,'2020-01-01',2020,'ene.','JCLOPEZ',0,51,10,19.61),(170,'2020-02-01',2020,'feb.','JCLOPEZ',0,126,21,16.67),(171,'2020-03-01',2020,'mar.','JCLOPEZ',0,121,28,23.14),(172,'2020-04-01',2020,'abr.','JCLOPEZ',0,74,29,39.19),(173,'2020-05-01',2020,'may.','JCLOPEZ',0,96,20,20.83),(174,'2020-06-01',2020,'jun.','JCLOPEZ',0,100,19,19),(175,'2020-07-01',2020,'jul.','JCLOPEZ',0,130,22,16.92),(176,'2020-08-01',2020,'ago.','JCLOPEZ',0,0,0,0),(177,'2020-09-01',2020,'sep.','JCLOPEZ',0,99,19,19.19),(178,'2020-10-01',2020,'oct.','JCLOPEZ',0,109,22,20.18),(179,'2020-11-01',2020,'nov.','JCLOPEZ',0,106,23,21.7),(180,'2020-12-01',2020,'dic.','JCLOPEZ',19,87,13,14.94),(181,'2021-01-01',2021,'ene.','JCLOPEZ',0,0,0,0),(182,'2021-02-01',2021,'feb.','JCLOPEZ',0,0,0,0),(183,'2021-03-01',2021,'mar.','JCLOPEZ',0,0,0,0),(184,'2021-04-01',2021,'abr.','JCLOPEZ',27,0,2,0),(185,'2021-05-01',2021,'may.','JCLOPEZ',0,0,0,0),(186,'2021-06-01',2021,'jun.','JCLOPEZ',0,0,0,0),(187,'2021-07-01',2021,'jul.','JCLOPEZ',0,0,0,0),(188,'2021-08-01',2021,'ago.','JCLOPEZ',0,0,0,0),(189,'2021-09-01',2021,'sep.','JCLOPEZ',0,0,0,0),(190,'2021-10-01',2021,'oct.','JCLOPEZ',0,0,0,0),(191,'2021-11-01',2021,'nov.','JCLOPEZ',0,0,0,0),(192,'2021-12-01',2021,'dic.','JCLOPEZ',0,0,0,0),(193,'2020-01-01',2020,'ene.','SHURTADO',0,33,23,69.7),(194,'2020-02-01',2020,'feb.','SHURTADO',0,47,15,31.91),(195,'2020-03-01',2020,'mar.','SHURTADO',0,156,19,12.18),(196,'2020-04-01',2020,'abr.','SHURTADO',0,30,19,63.33),(197,'2020-05-01',2020,'may.','SHURTADO',0,129,18,13.95),(198,'2020-06-01',2020,'jun.','SHURTADO',0,119,23,19.33),(199,'2020-07-01',2020,'jul.','SHURTADO',0,112,16,14.29),(200,'2020-08-01',2020,'ago.','SHURTADO',0,0,0,0),(201,'2020-09-01',2020,'sep.','SHURTADO',0,83,25,30.12),(202,'2020-10-01',2020,'oct.','SHURTADO',0,32,16,50),(203,'2020-11-01',2020,'nov.','SHURTADO',0,73,18,24.66),(204,'2020-12-01',2020,'dic.','SHURTADO',0,121,34,28.1),(205,'2021-01-01',2021,'ene.','SHURTADO',0,0,0,0),(206,'2021-02-01',2021,'feb.','SHURTADO',0,0,0,0),(207,'2021-03-01',2021,'mar.','SHURTADO',0,0,0,0),(208,'2021-04-01',2021,'abr.','SHURTADO',1,3,2,0.6667),(209,'2021-05-01',2021,'may.','SHURTADO',0,0,0,0),(210,'2021-06-01',2021,'jun.','SHURTADO',0,0,0,0),(211,'2021-07-01',2021,'jul.','SHURTADO',0,0,0,0),(212,'2021-08-01',2021,'ago.','SHURTADO',0,0,0,0),(213,'2021-09-01',2021,'sep.','SHURTADO',0,0,0,0),(214,'2021-10-01',2021,'oct.','SHURTADO',0,0,0,0),(215,'2021-11-01',2021,'nov.','SHURTADO',0,0,0,0),(216,'2021-12-01',2021,'dic.','SHURTADO',0,0,0,0),(217,'2020-08-01',2020,'ago.','TGAERTNER',0,0,0,0),(218,'2020-09-01',2020,'sep.','TGAERTNER',0,0,0,0),(219,'2020-10-01',2020,'oct.','TGAERTNER',0,0,0,0),(220,'2020-11-01',2020,'nov.','TGAERTNER',0,0,0,0),(221,'2020-12-01',2020,'dic.','TGAERTNER',0,0,0,0),(222,'2021-01-01',2021,'ene.','TGAERTNER',0,0,0,0),(223,'2021-02-01',2021,'feb.','TGAERTNER',0,0,0,0),(224,'2021-03-01',2021,'mar.','TGAERTNER',0,0,0,0),(225,'2021-04-01',2021,'abr.','TGAERTNER',0,1,0,0),(226,'2021-05-01',2021,'may.','TGAERTNER',0,0,0,0),(227,'2021-06-01',2021,'jun.','TGAERTNER',0,0,0,0),(228,'2021-07-01',2021,'jul.','TGAERTNER',0,0,0,0),(229,'2021-08-01',2021,'ago.','TGAERTNER',0,0,0,0),(230,'2021-09-01',2021,'sep.','TGAERTNER',0,0,0,0),(231,'2021-10-01',2021,'oct.','TGAERTNER',0,0,0,0),(232,'2021-11-01',2021,'nov.','TGAERTNER',0,0,0,0),(233,'2021-12-01',2021,'dic.','TGAERTNER',0,0,0,0),(234,'2020-01-01',2020,'ene.','WLUCERO',0,28,5,17.86),(235,'2020-02-01',2020,'feb.','WLUCERO',0,94,12,12.77),(236,'2020-03-01',2020,'mar.','WLUCERO',0,63,11,17.46),(237,'2020-04-01',2020,'abr.','WLUCERO',0,34,10,29.41),(238,'2020-05-01',2020,'may.','WLUCERO',0,79,10,12.66),(239,'2020-06-01',2020,'jun.','WLUCERO',0,92,14,15.22),(240,'2020-07-01',2020,'jul.','WLUCERO',0,98,19,19.39),(241,'2020-08-01',2020,'ago.','WLUCERO',0,0,0,0),(242,'2020-09-01',2020,'sep.','WLUCERO',0,94,21,22.34),(243,'2020-10-01',2020,'oct.','WLUCERO',0,77,11,14.29),(244,'2020-11-01',2020,'nov.','WLUCERO',1,77,18,23.38),(245,'2020-12-01',2020,'dic.','WLUCERO',7,22,7,31.82),(246,'2021-01-01',2021,'ene.','WLUCERO',0,0,0,0),(247,'2021-02-01',2021,'feb.','WLUCERO',0,0,0,0),(248,'2021-03-01',2021,'mar.','WLUCERO',0,0,0,0),(249,'2021-04-01',2021,'abr.','WLUCERO',10,16,20,1.25),(250,'2020-05-01',2021,'may.','WLUCERO',0,0,0,0),(251,'2021-06-01',2021,'jun.','WLUCERO',0,0,0,0),(252,'2021-07-01',2021,'jul.','WLUCERO',0,0,0,0),(253,'2021-08-01',2021,'ago.','WLUCERO',0,0,0,0),(254,'2021-09-01',2021,'sep.','WLUCERO',0,0,0,0),(255,'2021-10-01',2021,'oct.','WLUCERO',0,0,0,0),(256,'2021-11-01',2021,'nov.','WLUCERO',0,0,0,0),(257,'2021-12-01',2021,'dic.','WLUCERO',0,0,0,0),(258,'2020-01-01',2020,'ene.','NBARRERA',0,0,0,0),(259,'2020-02-01',2020,'feb.','NBARRERA',0,0,0,0),(260,'2020-03-01',2020,'mar.','NBARRERA',0,0,0,0),(261,'2020-04-01',2020,'abr.','NBARRERA',0,0,0,0),(262,'2020-05-01',2020,'may.','NBARRERA',0,0,0,0),(263,'2020-06-01',2020,'jun.','NBARRERA',0,0,0,0),(264,'2020-07-01',2020,'jul.','NBARRERA',0,0,0,0),(265,'2020-08-01',2020,'ago.','NBARRERA',0,0,0,0),(266,'2020-09-01',2020,'sep.','NBARRERA',0,0,0,0),(267,'2020-10-01',2020,'oct.','NBARRERA',0,0,0,0),(268,'2020-11-01',2020,'nov.','NBARRERA',0,0,0,0),(269,'2020-12-01',2020,'dic.','NBARRERA',0,0,0,0),(270,'2021-01-01',2021,'ene.','NBARRERA',0,0,0,0),(271,'2021-02-01',2021,'feb.','NBARRERA',0,0,0,0),(272,'2021-03-01',2021,'mar.','NBARRERA',0,0,0,0),(273,'2021-04-01',2021,'abr.','NBARRERA',0,10,10,1),(274,'2021-05-01',2021,'may.','NBARRERA',0,5,5,1),(275,'2021-06-01',2021,'jun.','NBARRERA',0,0,0,0),(276,'2021-07-01',2021,'jul.','NBARRERA',0,0,0,0),(277,'2021-08-01',2021,'ago.','NBARRERA',0,0,0,0),(278,'2021-09-01',2021,'sep.','NBARRERA',0,0,0,0),(279,'2021-10-01',2021,'oct.','NBARRERA',0,0,0,0),(280,'2021-11-01',2021,'nov.','NBARRERA',0,0,0,0),(281,'2021-12-01',2021,'dic.','NBARRERA',0,0,0,0),(282,'2021-01-01',2021,'ene.','NO ASIGNADO',0,0,0,0),(283,'2021-02-01',2021,'feb.','NO ASIGNADO',0,0,0,0),(284,'2021-03-01',2021,'mar.','NO ASIGNADO',0,0,0,0),(285,'2021-04-01',2021,'abr.','NO ASIGNADO',5,4,3,0.75),(286,'2021-05-01',2021,'may.','NO ASIGNADO',0,0,0,0),(287,'2021-06-01',2021,'jun.','NO ASIGNADO',0,0,0,0),(288,'2021-07-01',2021,'jul.','NO ASIGNADO',0,0,0,0),(289,'2021-08-01',2021,'ago.','NO ASIGNADO',0,0,0,0),(290,'2021-09-01',2021,'sep.','NO ASIGNADO',0,0,0,0),(291,'2021-10-01',2021,'oct.','NO ASIGNADO',0,0,0,0),(292,'2021-11-01',2021,'nov.','NO ASIGNADO',0,0,0,0),(293,'2021-12-01',2021,'dic.','NO ASIGNADO',0,0,0,0);
/*!40000 ALTER TABLE `ds_tarifario_closed_date_emp` 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:18:36
