-- Table structure for table `empleado_tmp`
--

CREATE TABLE `empleado_tmp` (
  `id` int(11) NOT NULL,
  `id_old` int(11) NOT NULL,
  `id_empleado_tmp` varchar(20) CHARACTER SET utf8 COLLATE utf8_spanish_ci NOT NULL,
  `de_nombre` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
  `co_departamento` varchar(2) CHARACTER SET utf8 COLLATE utf8_spanish_ci DEFAULT NULL,
  `co_cargo` varchar(3) CHARACTER SET utf8 COLLATE utf8_spanish_ci DEFAULT NULL,
  `tipo_empleado_tmp` int(11) NOT NULL DEFAULT '1' COMMENT '1) DOC 2 ) ADM 3) SSGG 4)DECE',
  `tipo_ssgg` int(11) NOT NULL DEFAULT '0',
  `fe_ingreso` date DEFAULT NULL,
  `de_mail` varchar(80) CHARACTER SET utf8 COLLATE utf8_spanish_ci DEFAULT NULL,
  `foto` longtext,
  `asignatura` varchar(100) DEFAULT NULL,
  `paralelo` varchar(100) DEFAULT NULL,
  `anio` varchar(100) DEFAULT NULL,
  `firma` longtext,
  `superior` int(11) DEFAULT '0',
  `perfil` int(11) NOT NULL DEFAULT '0',
  `estado` int(11) NOT NULL DEFAULT '1',
  `evaluacion` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idempleado_tmp_UNIQUE` (`id_empleado_tmp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `empleado_tmp`
--

INSERT INTO `empleado_tmp` VALUES (1,102,'0914581160','ACOSTA VILLALTA DARWIN RUBEN','04','57',3,1,'2015-04-13','darwin.acosta@colegioamericano.edu.ec','[encoded data, 61952 characters]','','','','[encoded data, 36676 characters]',93,0,1,1),(2,75,'0911828234','RAMIREZ CERVANTES MARIO YSMAEL','04','102',2,0,'2014-11-10','planta.fisica@colegioamericano.edu.ec','[encoded data, 54144 characters]','','','','[encoded data, 20804 characters]',0,0,1,1),(4,248,'0940897945','QUINTANA PISCO DALLAN STEPHANY','10','146',4,0,'2015-10-19','dallan.quintana@colegioamericano.edu.ec','[encoded data, 85084 characters]','','','','',0,0,0,0),(5,15,'0905064374','QUINDE MURILLO JORGE LUIS','04','41',2,0,'1987-04-01','jorge.quinde@colegioamericano.edu.ec','[encoded data, 75912 characters]','','','','',0,0,2,1),(8,120,'0915442123','PULLA MATUTE LOURDES CATALINA','02','118',1,0,'2000-03-07','lourdes.pulla@colegioamericano.edu.ec','[encoded data, 45544 characters]','.','.','.','[encoded data, 27436 characters]',0,0,1,1),(10,169,'0920937125','POZO TOMALA LORENZO RUBEN','04','83',3,2,'2013-07-01','ruben.pozo@colegioamericano.edu.ec','[encoded data, 55020 characters]','','','','[encoded data, 33804 characters]',193,0,1,1),