-- Table structure for table `pss_threhold`
--

CREATE TABLE `pss_threhold` (
  `scale` varchar(10) NOT NULL,
  `rank_name` varchar(255) NOT NULL,
  `threshold` double NOT NULL,
  PRIMARY KEY (`scale`),
  UNIQUE KEY `scale_UNIQUE` (`scale`),
  UNIQUE KEY `rank_name_UNIQUE` (`rank_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='threshodl and rank positions table';

--
-- Dumping data for table `pss_threhold`
--

INSERT INTO `pss_threhold` VALUES ('ACS 01','Professor',1100),('ACS 02','Associate Professor',750),('ACS 03','Senior Lecturer',450),('ACS 04','Lecturer I',230),('ACS 05','Lecturer II',100),('ACS 06','Lecturer III',0);

--
-- Table structure for table `pss_university_leadership_and_administration`
--

CREATE TABLE `pss_university_leadership_and_administration` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `starting_from` varchar(45) NOT NULL DEFAULT '',
  `ending_on` varchar(45) NOT NULL DEFAULT '',
  `position` varchar(100) NOT NULL,
  `extraDetails` varchar(255) DEFAULT NULL,
  `unit` varchar(50) DEFAULT NULL,
  `department_id` int DEFAULT NULL,
  `man_number` int unsigned NOT NULL,
  `weight` double unsigned NOT NULL,
  `recordStatusCode` tinyint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`),
  KEY `Leader_idx` (`man_number`)
) ENGINE=InnoDB AUTO_INCREMENT=1231 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pss_university_leadership_and_administration`
--

INSERT INTO `pss_university_leadership_and_administration` VALUES (2,'09-01-2015','08-01-2017','Head of Department',NULL,'Natural Sciences',52,8300,2,0),(4,'26-02-2016','28-02-2018','Head of Department',NULL,'Natural Sciences',55,7296,2,0),(8,'01-07-2009','31-07-2011','Assistant Dean',NULL,'Law',0,9694,1.5,0),(9,'01-09-2014','30-09-2016','Assistant Dean',NULL,'Law',31,9694,1.5,0),(10,'01-03-2011','22-05-2015','Head of Department',NULL,'Education',9,9071,2,0),(13,'14-03-2013','14-09-2013','Head of Department',NULL,'Natural Sciences',55,7296,2,0),(14,'10-01-2002','20-07-2002','Head of Department',NULL,'Natural Sciences',55,7296,2,0),(15,'01-01-2010','16-11-2016','Management Appointed Committee Member',NULL,'Central Administration',0,7296,1,0),(16,'06-03-2014','16-11-2016','Management Appointed Committee Member',NULL,'Central Administration',0,7296,1,0),(17,'08-04-2009','08-06-2012','Union Executive',NULL,'Central Administration',0,7296,1,0),(18,'08-06-2012','16-11-2016','Union Executive',NULL,'Central Administration',0,7296,1,0),(21,'01-06-2017','To Date','Head of Department',NULL,'Education',9,9070,2,0),(22,'14-08-2017','To Date','Head of Department',NULL,'Natural Sciences',53,8392,2,0),(23,'01-08-2008','31-08-2012','Head of Department',NULL,'Natural Sciences',53,7787,2,0),(27,'14-08-2013','13-08-2017','Head of Department',NULL,'Natural Sciences',53,8384,2,0),(35,'02-02-2011','26-12-2013','Assistant Dean',NULL,'Education',0,9406,1.5,0),(37,'01-08-2016','To Date','Management Appointed Committee Member',NULL,'Central Administration',0,10947,1,0),(38,'01-01-2018','To Date','Head of Department',NULL,'Health Sciences',0,8337,2,4),(40,'02-01-2017','31-12-2017','Assistant Dean',NULL,'Health Sciences',0,8337,1.5,4),(42,'03-01-2018','To Date','Assistant Dean',NULL,'Education',0,8485,1.5,0),(43,'01-01-2003','31-12-2009','Head of Department',NULL,'Veterinary Medicine',57,6525,2,1),(44,'01-01-2014','31-12-2016','Dean',NULL,'Veterinary Medicine',57,6525,2.5,1),(46,'01-01-1994','11-03-2000','Head of Department',NULL,'Engineering',16,1758,2,0),(47,'01-04-2004','01-04-2007','Assistant Dean',NULL,'Engineering',0,1758,1.5,0),(54,'01-02-2016','To Date','Head of Department',NULL,'Law',31,9827,2,0),(55,'13-07-2010','12-07-2015','Head of Department',NULL,'Engineering',15,9716,2,0),(56,'01-05-2003','31-12-2003','Head of Department',NULL,'Engineering',15,9716,2,0),(57,'01-11-1997','01-11-2000','Senate Member',NULL,'Central Administration',0,9716,1.5,0),(59,'05-05-2014','17-03-2018','Head of Department',NULL,'Humanities and Social Sciences',22,7280,2,0),(60,'01-08-2014','17-03-2018','Head of Department',NULL,'Education',14,8142,2,0),(61,'03-07-2007','02-07-2009','Assistant Dean',NULL,'Humanities and Social Sciences',28,6444,1.5,0),(62,'03-07-2009','02-07-2011','Assistant Dean',NULL,'Humanities and Social Sciences',28,6444,1.5,0),(63,'03-07-2011','02-07-2013','Assistant Dean',NULL,'Humanities and Social Sciences',28,6444,1.5,0),(64,'01-09-13','30-08-2015','Assistant Dean',NULL,'Humanities and Social Sciences',28,6444,1.5,0),(66,'15-12-1998','31-12-1999','Assistant Dean',NULL,'Humanities and Social Sciences',28,6444,1.5,0),(68,'08-07-2016','To Date','Assistant Dean',NULL,'Engineering',17,10637,1.5,0),(70,'04-02-2015','03-02-2017','Assistant Dean',NULL,'Education',14,8525,1.5,0),(71,'04-02-2013','03-02-2015','Assistant Dean',NULL,'Education',14,8525,1.5,0),(72,'16-10-2017','To Date','Head of Department',NULL,'Natural Sciences',56,8388,2,3),(78,'01-08-2004','31-08-2007','Head of Department',NULL,'Engineering',17,7026,2,0),(81,'05-01-2001','21-12-2010','Head of Department',NULL,'Engineering',16,6182,2,0),(90,'16-12-2011','31-05-2016','Head of Department',NULL,'Engineering',17,7026,2,0),(92,'22-01-2016','07-02-2018','Head of Department',NULL,'Humanities and Social Sciences',24,9903,2,0),(93,'01-07-2017','To Date','Head of Department',NULL,'Nursing Sciences',0,10560,2,0),(95,'01-01-17','31-12-18','Head of Department',NULL,'Education',6,10516,2,0),(100,'01-01-2007','02-01-2011','Assistant Dean',NULL,'Education',0,7541,1.5,0),(101,'25-03-2014','24-03-2018','Head of Department',NULL,'Humanities and Social Sciences',26,10302,2,0),(105,'01-07-2017','To Date','Head of Department',NULL,'Nursing Sciences',0,8766,2,1),(107,'01-04-2001','31-03-2004','Head of Department',NULL,'Humanities and Social Sciences',25,7403,2,0),(108,'01-03-2012','28-03-2014','Head of Department',NULL,'Humanities and Social Sciences',25,7403,2,0),(115,'01-01-1986','31-12-1989','Assistant Dean',NULL,'Education',11,1884,1.5,0),(116,'20-11-1992','25-04-2018','Assistant Dean',NULL,'Education',11,1884,1.5,0),(117,'01-01-1989','31-12-1989','Head of Department',NULL,'Education',11,1884,2,0),(118,'01-01-1995','31-12-1995','Head of Department',NULL,'Education',11,1884,2,0),(119,'26-10-1995','31-12-1997','Assistant Dean',NULL,'Education',11,1884,1.5,0),(120,'01-02-1985','31-01-2008','Head of Department',NULL,'Humanities and Social Sciences',26,684,2,0),(121,'01-01-1996','31-12-1996','Head of Department',NULL,'Education',11,1884,2,0),(122,'01-01-1997','31-12-1997','Committee',NULL,'Central Administration',0,1884,0.5,0),(123,'01-01-1999','31-12-2001','Head of Department',NULL,'Education',11,1884,2,0),(124,'01-01-1999','31-12-1999','Dean',NULL,'Education',11,1884,2.5,0),(125,'01-01-2008','31-12-2008','Dean',NULL,'Education',11,1884,2.5,0),(126,'01-01-2008','31-12-2010','Dean',NULL,'Education',11,1884,2.5,0),(127,'01-01-2009','31-12-2009','Council Ad-hoc Committee',NULL,'Central Administration',0,1884,1.5,0),(128,'01-01-2010','31-12-2010','Dean',NULL,'Education',11,1884,2.5,0),(129,'01-01-2010','31-12-2012','Assistant Dean',NULL,'Education',11,1884,1.5,0),(130,'01-01-2016','31-12-2017','Assistant Dean',NULL,'Humanities and Social Sciences',26,1884,1.5,0),(131,'12-09-2017','To Date','Assistant Dean',NULL,'Nursing Sciences',0,9880,1.5,0),(132,'14-03-2008','14-03-2014','Head of Department',NULL,'Humanities and Social Sciences',26,6665,2,0),(133,'01-01-2017','To Date','Head of Department',NULL,'Nursing Sciences',0,8352,2,1),(134,'01-03-2010','30-08-2013','Head of Department',NULL,'Medicine',41,8352,2,1),(140,'01-01-2018','To Date','Assistant Dean',NULL,'Health Sciences',0,9320,1.5,3),(144,'05-07-2017','27-04-2018','Head of Department',NULL,'Nursing Sciences',0,9023,2,0),(145,'08-06-2012','07-06-2014','Head of Department',NULL,'Veterinary Medicine',57,8235,2,0),(146,'08-06-2014','07-06-2016','Head of Department',NULL,'Veterinary Medicine',57,8235,2,0),(147,'11-08-2004','10-08-2006','Assistant Dean',NULL,'Veterinary Medicine',57,8235,1.5,0),(148,'11-06-2006','10-08-2008','Assistant Dean',NULL,'Veterinary Medicine',57,8235,1.5,0),(149,'10-08-2008','09-08-2010','Assistant Dean',NULL,'Veterinary Medicine',57,8235,1.5,0),(150,'16-04-2018','To Date','Dean',NULL,'Health Sciences',0,8337,2.5,4),(153,'01-09-2012','31-10-2013','Assistant Dean',NULL,'Mines',34,7758,1.5,0),(154,'01-11-2013','31-12-2016','Head of Department',NULL,'Mines',34,7758,2,0),(156,'01-04-2011','31-03-2014','Head of Department',NULL,'Engineering',19,7538,2,0),(158,'19-03-2014','19-03-2016','Committee',NULL,'Central Administration',0,7538,0.5,0),(159,'21-08-2012','21-08-2014','Council Ad-hoc Committee',NULL,'Central Administration',0,7538,1.5,0),(161,'14-06-2017','To Date','Head of Department',NULL,'Medicine',44,11682,2,0),(162,'01-02-2004','31-01-2006','Assistant Dean',NULL,'Humanities and Social Sciences',30,9405,1.5,0),(163,'01-02-2002','31-01-2004','Assistant Dean',NULL,'Humanities and Social Sciences',30,9405,1.5,0),(165,'19-04-2013','30-05-2014','Assistant Dean',NULL,'Humanities and Social Sciences',0,8436,1.5,0),(167,'11-09-2017','To Date','Assistant Dean',NULL,'Mines',35,9302,1.5,0),(169,'01-03-2015','28-02-2017','Head of Department',NULL,'Mines',35,7611,2,0),(171,'01-09-2013','27-02-2015','Assistant Dean',NULL,'Mines',36,7611,1.5,0),(172,'01-09-2011','31-08-2013','Assistant Dean',NULL,'Mines',36,7611,1.5,0),(173,'01-10-2006','31-08-2007','Assistant Dean',NULL,'Mines',36,7611,1.5,0),(174,'01-09-2011','01-10-2012','Assistant Dean',NULL,'Mines',35,9302,1.5,0),(175,'10-01-2003','31-12-2004','Assistant Dean',NULL,'Education',11,8135,1.5,0),(176,'01-07-2014','To Date','Head of Department',NULL,'Education',11,8135,2,0),(177,'01-09-1991','30-09-1995','Board Membership to UNZA-Based Operation',NULL,'Central Administration',0,8262,0.5,0),(178,'01-09-1991','31-12-1995','Head of Department',NULL,'Natural Sciences',54,8262,2,0),(179,'03-01-1994','30-12-1994','Assistant Dean',NULL,'Humanities and Social Sciences',25,9402,1.5,0),(185,'01-04-2002','31-07-2006','Head of Department',NULL,'Engineering',15,9755,2,0),(187,'09-10-2010','08-10-2012','Head of Department',NULL,'Humanities and Social Sciences',29,7823,2,0),(188,'09-10-2008','08-10-2010','Head of Department',NULL,'Humanities and Social Sciences',29,7823,2,0),(189,'01-09-2004','31-08-2006','Head of Department',NULL,'Humanities and Social Sciences',29,7823,2,0),(190,'01-08-1998','31-07-2000','Head of Department',NULL,'Humanities and Social Sciences',29,7823,2,0),(191,'28-04-2014','27-04-2016','Head of Department',NULL,'Humanities and Social Sciences',25,9402,2,0),(192,'14-07-2011','14-07-2013','Assistant Dean',NULL,'Mines',35,1971,1.5,0),(193,'13-12-2004','03-01-2018','Assistant Dean',NULL,'Engineering',0,8014,1.5,0),(194,'02-01-2000','31-12-2010','Assistant Dean',NULL,'Humanities and Social Sciences',28,7544,1.5,0),(199,'12-07-2010','11-07-2012','Head of Department',NULL,'University Library',0,10315,2,0),(200,'03-01-2011','02-01-2013','Head of Department',NULL,'University Library',0,10315,2,0),(201,'01-09-2015','01-04-2016','Head of Department',NULL,'University Library',0,10315,2,0),(202,'02-04-2016','30-03-2018','Head of Department',NULL,'Confucius Institute at University of Zambia',0,10315,2,0),(204,'02-04-2018','To Date','Head of Department',NULL,'Confucius Institute at University of Zambia',0,10315,2,0),(205,'01-03-2018','To Date','Head of Department',NULL,'Natural Sciences',55,7296,2,0),(206,'01-07-2013','To Date','Head of Department',NULL,'Education',7,7123,2,0),(207,'05-02-2009','05-02-2013','Assistant Dean',NULL,'Education',14,7123,1.5,0),(209,'01-01-2017','To Date','Head of Department',NULL,'Natural Sciences',54,8410,2,0),(210,'01-12-2014','31-12-2016','Assistant Dean',NULL,'Natural Sciences',0,8410,1.5,0),(212,'04-09-2006','03-09-2008','Head of Department',NULL,'Mines',35,1971,2,0),(213,'02-01-1998','01-01-2000','Head of Department',NULL,'Mines',35,1971,2,0),(214,'30-12-2016','30-01-2018','Head of Department',NULL,'Veterinary Medicine',60,8062,2,5),(215,'30-12-2014','30-12-2016','Assistant Dean',NULL,'Veterinary Medicine',0,8062,1.5,5),(216,'31-05-2011','30-05-2015','Head of Department',NULL,'Humanities and Social Sciences',23,8112,2,0),(217,'01-07-2017','31-01-2018','Head of Department',NULL,'Public Health',0,10739,2,1),(218,'19-08-2013','22-07-2018','Assistant Dean',NULL,'Mines',35,1971,1.5,0),(219,'23-07-2018','To Date','Senate Member',NULL,'Central Administration',0,9694,1.5,0),(220,'01-10-2002','30-09-2004','Assistant Dean',NULL,'Mines',34,9044,1.5,0),(221,'01-10-2004','30-09-2006','Assistant Dean',NULL,'Mines',34,9044,1.5,0),(222,'01-10-2006','30-09-2008','Assistant Dean',NULL,'Mines',34,9044,1.5,0),(223,'30-05-2008','20-09-2011','Head of Department',NULL,'Mines',34,9044,2,0),(224,'08-01-2014','07-01-2016','Assistant Dean',NULL,'Mines',34,9044,1.5,0),(225,'30-05-2016','27-07-2018','Assistant Dean',NULL,'Mines',34,9044,1.5,0),(227,'14-02-2018','To Date','Assistant Dean',NULL,'Natural Sciences',53,8588,1.5,3),(228,'01-11-2012','15-09-2015','Assistant Dean',NULL,'Engineering',15,6887,1.5,0),(229,'15-09-2015','07-08-2018','Head of Department',NULL,'Engineering',15,6887,2,0),(230,'24-07-2017','27-07-2018','Assistant Dean',NULL,'Health Sciences',0,10564,1.5,2),(232,'03-06-2015','03-06-2017','Head of Department',NULL,'Agricultural Sciences',0,9269,2,0),(237,'30-05-2014','02-12-2015','Assistant Dean',NULL,'Humanities and Social Sciences',28,8486,1.5,0),(239,'01-05-2005','29-04-2013','Head of Department',NULL,'Veterinary Medicine',62,6116,2,0),(240,'15-10-2015','15-10-2017','Head of Department',NULL,'Agricultural Sciences',2,10768,2,1),(244,'18-08-2011','30-04-2012','Head of Department',NULL,'University Library',0,10573,2,0),(246,'01-05-2012','31-05-2014','Head of Department',NULL,'University Library',0,10573,2,0),(247,'01-06-2014','31-05-2016','Head of Department',NULL,'University Library',0,10573,2,0),(248,'01-06-2016','31-05-2018','Head of Department',NULL,'University Library',0,10573,2,0),(249,'01-06-2018','To Date','Head of Department',NULL,'University Library',0,10573,2,0),(250,'03-08-2010','02-08-2012','Head of Department',NULL,'Education',11,8400,2,3),(251,'03-08-2012','02-08-2014','Head of Department',NULL,'Education',11,8400,2,3),(255,'12-08-2000','12-12-2005','Assistant Dean',NULL,'Humanities and Social Sciences',28,7544,1.5,0),(256,'01-01-2006','30-12-2010','Assistant Dean',NULL,'Humanities and Social Sciences',28,7544,1.5,0),(257,'01-09-13','30-08-15','Assistant Dean',NULL,'Directorate of Research and Graduate Studies',0,6444,1.5,0),(258,'01-09-15','30-08-17','Assistant Dean',NULL,'Directorate of Research and Graduate Studies',0,6444,1.5,0),(262,'01-08-2018','To Date','Head of Department',NULL,'Humanities and Social Sciences',21,9726,2,0),(265,'01-01-2002','01-11-2002','Head of Department',NULL,'Medicine',43,6027,2,0),(267,'08-10-2012','07-10-2016','Head of Department',NULL,'Humanities and Social Sciences',29,10367,2,0),(268,'01-05-1991','01-12-1991','Assistant Dean',NULL,'Medicine',43,6027,1.5,0),(269,'01-03-2011','28-02-2017','Assistant Dean',NULL,'Medicine',0,9034,1.5,0),(270,'01-06-2017','To Date','Head of Department',NULL,'Medicine',41,9034,2,0),(273,'01-08-2007','14-08-2009','Head of Department',NULL,'Engineering',17,8444,2,1),(275,'05-04-2015','To Date','Head of Department',NULL,'Engineering',19,11102,2,1),(276,'01-01-2018','15-08-2018','Head of Department',NULL,'Education',13,10137,2,0),(277,'01-07-2017','To Date','Head of Department',NULL,'Public Health',0,10788,2,0),(278,'03-06-2015','To Date','Head of Department',NULL,'Education',10,9222,2,0),(280,'01-07-2015','30-06-2017','Head of Department',NULL,'Humanities and Social Sciences',23,8264,2,0),(282,'01-05-1981','31-07-1982','Assistant Dean',NULL,'Humanities and Social Sciences',23,8264,1.5,0),(283,'01-06-2016','15-08-2018','Director',NULL,'Public Health',0,9296,2.5,0),(290,'01-05-2012','01-11-2012','Head of Department',NULL,'Engineering',19,10143,2,0),(293,'16-02-2002','30-06-2003','Assistant Dean',NULL,'Medicine',39,7537,1.5,0),(294,'01-12-2016','17-08-2018','Assistant Dean',NULL,'Medicine',39,7537,1.5,0),(298,'08-08-2016','27-10-2017','Head of Department',NULL,'Confucius Institute at University of Zambia',0,7536,2,0),(303,'02-10-2008','31-12-2010','Assistant Dean',NULL,'Natural Sciences',54,6772,1.5,0),(304,'01-01-2011','31-12-2014','Head of Department',NULL,'Natural Sciences',54,6772,2,0),(305,'26-04-2017','To Date','Head of Department',NULL,'Humanities and Social Sciences',30,10818,2,0),(306,'25-01-2018','To Date','Head of Department',NULL,'Public Health',0,11485,2,0),(309,'31-01-2005','30-01-2007','Head of Department',NULL,'Humanities and Social Sciences',20,7317,2,0),(310,'01-03-2007','28-02-2009','Head of Department',NULL,'Humanities and Social Sciences',20,7317,2,0),(312,'01-11-2011','To Date','Head of Department',NULL,'Medicine',47,9753,2,1),(313,'01-11-2016','30-06-2017','Head of Department',NULL,'Medicine',44,7498,2,0),(317,'01-08-2012','30-09-2014','Head of Department',NULL,'Health Sciences',45,9754,2,0),(319,'01-02-2011','31-01-2013','Head of Department',NULL,'Medicine',39,10048,2,0),(320,'02-02-2009','01-02-2011','Head of Department',NULL,'Medicine',39,10048,2,0),(321,'20-05-2018','To Date','Senate Member',NULL,'Central Administration',0,6027,1.5,0),(322,'01-06-2009','To Date','Management Appointed Committee Member',NULL,'Central Administration',0,6027,1,0),(323,'01-01-2003','To Date','Management Appointed Committee Member',NULL,'Central Administration',0,6027,1,0),(324,'01-11-2003','To Date','Management Appointed Committee Member',NULL,'Central Administration',0,6027,1,0),(325,'01-03-2008','28-02-2009','Head of Department',NULL,'Natural Sciences',55,7328,2,0),(326,'01-03-2009','28-02-2010','Head of Department',NULL,'Natural Sciences',55,7328,2,0),(328,'01-03-2010','28-02-2011','Head of Department',NULL,'Natural Sciences',55,7328,2,0),(329,'01-03-2011','29-02-2012','Head of Department',NULL,'Natural Sciences',55,7328,2,0),(330,'01-09-2008','31-08-2009','Assistant Dean',NULL,'Natural Sciences',0,7119,1.5,0),(331,'01-09-2007','31-08-2008','Assistant Dean',NULL,'Natural Sciences',0,7119,1.5,0),(332,'01-09-2006','31-08-2007','Assistant Dean',NULL,'Natural Sciences',0,7119,1.5,0),(333,'01-09-2005','31-08-2006','Assistant Dean',NULL,'Natural Sciences',0,7119,1.5,0),(334,'01-09-2004','31-08-2005','Assistant Dean',NULL,'Natural Sciences',0,7119,1.5,0),(335,'01-09-2003','31-08-2004','Assistant Dean',NULL,'Natural Sciences',0,7119,1.5,0),(336,'01-09-2002','31-08-2003','Assistant Dean',NULL,'Natural Sciences',0,7119,1.5,0),(338,'01-03-2012','28-02-2013','Head of Department',NULL,'Natural Sciences',55,7438,2,0),(339,'01-03-2013','28-02-14','Head of Department',NULL,'Natural Sciences',55,7438,2,0),(340,'01-03-2014','28-02-2015','Head of Department',NULL,'Natural Sciences',55,7438,2,0),(341,'01-03-2015','28-02-2016','Head of Department',NULL,'Natural Sciences',55,7438,2,0),(342,'01-09-2009','31-08-2010','Assistant Dean',NULL,'8',55,7438,1.5,0),(343,'01-09-2010','31-08-2011','Assistant Dean',NULL,'8',55,7438,1.5,0),(344,'01-09-2011','31-08-2012','Assistant Dean',NULL,'8',0,7438,1.5,0),(350,'01-03-2001','31-08-2002','Assistant Dean',NULL,'8',0,7119,1.5,0),(352,'01-01-2004','01-01-2006','Assistant Dean',NULL,'7',35,1971,1.5,0),(353,'01-01-2017','To Date','Dean',NULL,'6',0,6544,2.5,0),(355,'01-01-2002','31-12-2003','Assistant Dean',NULL,'6',0,6544,1.5,0),(356,'01-01-2000','31-12-2002','Head of Department',NULL,'6',44,6544,2,0),(357,'01-01-2011','31-12-2016','Head of Department',NULL,'6',44,6544,2,0),(359,'01-04-2009','To Date','Assistant Dean',NULL,'6',43,8065,1.5,0),(360,'01-06-2010','To Date','Board Membership to UNZA-Based Operation',NULL,'11',0,8065,0.5,0),(361,'01-01-2014','31-12-2015','Board Membership to UNZA-Based Operation',NULL,'11',0,8065,0.5,0),(362,'01-01-2013','To Date','Assistant Dean',NULL,'3',18,6732,1.5,0),(363,'01-11-2005','30-11-2011','Head of Department',NULL,'3',18,6732,2,0),(364,'01-08-2004','31-10-2005','Head of Department',NULL,'3',18,6732,2,0),(367,'03-08-1998','29-02-2004','Assistant Dean',NULL,'3',18,6732,1.5,0),(372,'15-11-2013','02-12-2015','Director',NULL,'19',0,8486,2.5,0),(373,'02-11-2015','05-09-2018','Director',NULL,'19',0,8486,2.5,0),(374,'09-05-2011','08-05-2013','Head of Department',NULL,'4',93,7621,2,0),(375,'09-05-2013','15-04-2014','Head of Department',NULL,'4',93,7621,2,0),(379,'01-01-2013','31-12-2015','Head of Department',NULL,'7',33,6186,2,0),(381,'05-01-2000','04-12-2002','Head of Department',NULL,'7',33,6186,2,0),(382,'18-12-2002','17-12-2004','Assistant Dean',NULL,'7',0,6186,1.5,0),(383,'10-02-1999','09-02-2000','Assistant Dean',NULL,'7',0,6186,1.5,0),(385,'01-08-2016','09-09-2018','Management Appointed Committee Member',NULL,'11',0,10947,1,0),(386,'01-01-2018','To Date','Board Membership to UNZA-Based Operation',NULL,'11',0,8065,0.5,0),(387,'01-10-2009','To Date','Management Appointed Committee Member',NULL,'11',0,8065,1,0),(389,'01-01-2010','31-12-2014','Head of Department',NULL,'7',35,9571,2,0),(391,'01-01-2016','To Date','Head of Department',NULL,'7',36,9571,2,0),(392,'23-11-2012','24-11-2017','Assistant Dean',NULL,'4',0,9704,1.5,0),(394,'01-10-2007','31-05-2012','Head of Department',NULL,'1',3,8475,2,0),(396,'22-04-2013','21-04-2017','Head of Department',NULL,'4',30,9432,2,0),(399,'13-09-2018','To Date','Head of Department',NULL,'13',91,9474,2,0),(400,'18-08-2016','To Date','Senate Member',NULL,'11',0,10637,1.5,0),(401,'22-06-2017','To Date','Committee',NULL,'11',0,10637,0.5,0),(404,'12-09-2018','To Date','Head of Department',NULL,'5',31,9694,2,0),(408,'15-08-2016','14-08-2017','Assistant Director',NULL,'20',109,9442,1.5,1),(409,'15-08-2017','14-08-2018','Assistant Director',NULL,'20',109,9442,1.5,1),(412,'01-06-2009','03-05-2011','Head of Department',NULL,'4',0,9088,2,1),(413,'13-11-2017','To Date','Head of Department',NULL,'4',20,9844,2,0),(416,'04-01-2017','05-01-2018','Head of Department',NULL,'14',74,8821,2,0),(417,'01-01-2000','31-12-2010','Head of Department',NULL,'12',45,9992,2,1),(420,'19-09-2012','19-09-2014','Head of Department',NULL,'15',81,10616,2,0),(421,'19-09-2014','19-09-2016','Head of Department',NULL,'15',81,10616,2,0),(422,'19-09-2016','19-09-2018','Head of Department',NULL,'15',81,10616,2,0),(424,'01-07-2017','To Date','Head of Department','','14',75,10727,2,0),(428,'01-01-2016','31-12-2017','Head of Department','','14',74,8915,2,0),(432,'08-09-2008','15-11-2010','Head of Department','','9',60,7370,2,6),(433,'07-12-2007','07-09-2008','Head of Department','','9',0,7370,2,6),(434,'01-01-2014','31-12-2014','Head of Department','','13',71,9356,2,1),(435,'01-08-2014','31-12-2017','Assistant Dean','','6',0,9356,1.5,1),(436,'01-06-2017','10-10-2018','Assistant Dean','','13',0,9356,1.5,1),(437,'02-02-2011','02-02-2013','Assistant Dean','','8',0,7289,1.5,0),(438,'03-02-2013','03-02-2015','Assistant Dean','','8',0,7289,1.5,0),(439,'01-10-2014','31-10-2016','Head of Department','','12',45,10721,2,3),(440,'01-03-2017','31-12-2017','Council Ad-hoc Committee','Development of Policy on Affiliation of Higher Learning Institutions to University of Zambia ','11',0,10721,1.5,3),(442,'08-09-2009','10-06-2010','Assistant Dean','','4',0,8793,1.5,0),(446,'01-01-2010','10-09-2010','Assistant Dean','','18',0,8483,1.5,0),(448,'19-04-2016','18-04-2018','Assistant Dean','','5',32,8483,1.5,0),(449,'19-04-2018','12-10-2018','Assistant Dean','','5',32,8483,1.5,0),(450,'11-11-2013','10-11-2015','Head of Department','','4',20,8793,2,0),(451,'11-10-2015','10-11-2017','Head of Department','','4',20,8793,2,0),(453,'10-09-2018','To Date','Head of Department','','14',72,8821,2,0),(454,'20-12-2010','19-12-2016','Head of Department','','9',60,9065,2,5),(459,'14-08-2017','To Date','Board Membership to UNZA-Based Operation','Barbara Munyati,Cisco Academy','11',0,8392,0.5,0),(460,'14-08-2017','To Date','Board Membership to UNZA-Based Operation','A-Levels (ATCU)','11',0,8392,0.5,0),(465,'01-06-1998','31-12-1998','Assistant Dean','','8',55,1988,1.5,0),(466,'01-01-1999','31-12-1999','Assistant Dean','','8',55,1988,1.5,0),(468,'01-01-2000','31-12-2000','Assistant Dean','','8',55,1988,1.5,0),(469,'01-02-2004','31-12-2004','Head of Department','','8',55,1988,2,0),(470,'01-01-2005','31-12-2005','Head of Department','','8',55,1988,2,0),(471,'01-01-2006','31-12-2006','Head of Department','','8',55,1988,2,0),(472,'01-01-2007','31-12-2007','Head of Department','','8',55,1988,2,0),(480,'01-05-2012','30-04-2014','Head of Department','','1',3,7824,2,0),(481,'01-05-2014','30-04-2015','Head of Department','','1',3,7824,2,0),(482,'01-04-2003','30-09-2005','Head of Department','','1',3,7824,2,0),(483,'02-05-2007','05-06-2015','Assistant Dean','','6',50,8494,1.5,0),(484,'03-04-9','31-01-2012','Head of Department','','15',81,9793,2,1),(486,'01-01-2017','17-12-2018','Assistant Dean','','8',54,101821,1.5,0),(487,'03-03-2010','09-01-2011','Head of Department','','6',39,6550,2,1),(489,'01-01-2003','31-12-2005','Assistant Dean','','6',0,6550,1.5,1),(491,'10-01-2011','31-12-2016','Dean','','6',0,6550,2.5,1),(492,'14-10-2013','18-12-2018','Board Membership to UNZA-Based Operation','Evelyn Hone  College Board of Management','11',0,6550,0.5,1),(493,'10-01-2011','31-12-2016','Board Membership to UNZA-Based Operation','Health Professions Council of Zambia (HPCZ)','11',0,6550,0.5,1),(494,'01-04-2014','01-04-2016','Assistant Dean','','1',2,9298,1.5,0),(495,'01-04-2016','01-04-2018','Assistant Dean','','1',2,9298,1.5,0),(497,'10-01-2011','31-12-2015','Management Appointed Committee Member','UNZA Senate','11',0,6550,1,1),(498,'10-01-2011','31-12-2016','Management Appointed Committee Member','UNZA Research Board','11',0,6550,1,1),(499,'10-01-2011','31-12-2015','Management Appointed Committee Member','Committee for establishment of International Link Office','11',0,6550,1,1),(500,'10-01-2011','31-12-2015','Management Appointed Committee Member','UNZA LAND Development Committee','11',0,6550,1,1),(501,'10-01-2011','31-12-2016','Management Appointed Committee Member','Senate Distance Education Committee','11',0,6550,1,1),(502,'10-01-2011','31-12-2016','Management Appointed Committee Member','UNZA Biomedical Research Ethics Committee','11',0,6550,1,1),(503,'10-01-2011','31-12-2016','Management Appointed Committee Member','Committee to Review the National Education Policy of 1996','11',0,6550,1,1),(504,'10-01-2011','31-12-2016','Management Appointed Committee Member','Adhoc Committee to Draft UNZA Charter and Statutes','11',0,6550,1,1),(505,'10-01-2011','31-12-2015','Management Appointed Committee Member','Chairman of the Examinations Council of Health Sciences','11',0,6550,1,1),(506,'01-01-2013','03-03-2017','Assistant Dean','','1',5,10280,1.5,0),(508,'01-05-2017','To Date','Assistant Director','','18',0,10280,1.5,0),(509,'07-01-2015','16-01-2019','Assistant Dean','','2',0,9945,1.5,0),(510,'15-07-2018','To Date','Assistant Dean','','12',0,10752,1.5,0),(511,'01-06-2018','09-02-2019','Head of Department','','3',17,10682,2,0),(512,'01-04-2013','30-11-2017','Assistant Dean','','5',32,10592,1.5,0),(513,'01-05-2018','To Date','Head of Department','','5',32,10592,2,0),(516,'02-02-2001','02-12-2003','Head of Department','','1',1,6515,2,1),(517,'24-12-2003','02-12-2005','Head of Department','','1',1,6515,2,1),(518,'20-12-2005','02-12-2007','Head of Department','','1',1,6515,2,1),(519,'20-12-2007','02-12-2009','Head of Department','','1',1,6515,2,1),(520,'20-12-2009','02-12-2011','Head of Department','','1',1,6515,2,1),(521,'05-01-1998','25-12-1999','Assistant Dean','','1',0,6515,1.5,1),(522,'05-01-2000','30-12-2001','Assistant Dean','','1',0,6515,1.5,1),(524,'22-12-2016','To Date','Senate Member','','11',0,6515,1.5,1),(526,'01-01-2016','29-12-2017','Head of Department','','8',54,6873,2,0),(529,'27-07-2018','To Date','Assistant Dean','','7',36,9044,1.5,0),(530,'13-02-2012','13-03-2014','Assistant Dean','','1',1,9604,1.5,0),(532,'11-02-2019','To Date','Dean','','12',0,8337,2.5,4),(533,'22-08-2018','To Date','Management Appointed Committee Member','Human Resource Committee','11',0,6515,1,1),(535,'14-07-2014','14-07-2018','Head of Department','','8',51,7178,2,0),(537,'01-12-2016','01-12-2018','Head of Department','','12',45,9749,2,3),(539,'01-01-2011','31-12-2013','Dean','','8',0,10363,2.5,0),(540,'01-10-2010','31-10-2018','Head of Department','','3',16,8020,2,0),(542,'20-06-2013','02-08-2017','Management Appointed Committee Member','Students Residence Committee','11',0,6515,1,1),(544,'01-01-1999','30-09-2000','Head of Department','','8',54,10363,2,0),(545,'01-01-1988','31-12-2010','Head of Department','','8',54,10363,2,0),(549,'01-01-1997','30-10-1999','Assistant Dean','','8',0,10363,1.5,0),(551,'01-03-2014','28-02-2015','Assistant Dean','','8',0,9558,1.5,0),(552,'01-03-2015','28-02-2016','Assistant Dean','','8',0,9558,1.5,0),(553,'29-02-2016','28-02-2017','Assistant Dean','','8',0,9558,1.5,0),(554,'01-03-2017','28-02-2018','Assistant Dean','','8',0,9558,1.5,0),(557,'15-05-2018','To Date','Council Ad-hoc Committee','Member of Special Committee  to develop distance Education Programmes on behalf of School of Public Health','11',0,9296,1.5,0),(558,'09-08-2018','To Date','Management Appointed Committee Member','Member of the UNZA Strategic Plan Evaluation  as contact Person for the School of Public Health','11',0,9296,1,0),(561,'01-01-2004','31-03-2006','Head of Department','','9',60,6563,2,0),(566,'01-03-2019','To Date','Head of Department','','6',44,12172,2,0),(570,'15-06-2016','19-06-2016','Head of Department','','1',0,7168,2,1),(571,'10-09-2017','13-09-2017','Dean','','1',0,7168,2.5,1),(572,'20-01-2009','06-02-2009','Dean','','1',5,7168,2.5,1),(573,'24-11-2008','26-11-2008','Dean','','1',5,7168,2.5,1),(574,'17-09-2007','21-09-2007','Dean','','1',5,7168,2.5,1),(575,'26-03-2007','28-03-2007','Dean','','1',5,7168,2.5,1),(576,'13-02-2006','12-02-2008','Head of Department','','1',5,7168,2,1),(577,'13-02-2008','12-02-2010','Head of Department','','1',5,7168,2,1),(578,'16-07-2015','08-02-2016','Assistant Dean','','3',18,10678,1.5,1),(584,'30-11-2014','31-05-2019','Head of Department','','2',8,9362,2,4),(587,'01-05-2011','30-04-2012','Assistant Dean','','3',17,9804,1.5,0),(589,'01-07-2019','30-06-21','Head of Department','','13',0,9023,2,0),(593,'17-09-2012','17-09-2018','Dean','','3',0,6182,2.5,0),(595,'16-01-2019','17-08-2019','Assistant Dean','','2',0,9852,1.5,0),(598,'01-01-2011','31-12-2014','Head of Department','','4',28,6882,2,0),(599,'01-01-2019','To Date','Director','UNZA SPH Online Masters In Public Health ','14',72,10788,2.5,0),(601,'01-09-2010','02-07-2017','Head of Department','','17',99,8254,2,0),(602,'01-02-2008','01-08-2010','Head of Department','','17',107,8254,2,0),(603,'01-09-2005','01-01-2008','Head of Department','','17',97,8254,2,0),(604,'26-08-2019','08-09-2019','Assistant Dean','','14',0,10739,1.5,0),(607,'18-04-2014','17-04-2018','Head of Department','','9',61,8779,2,0),(616,'20-04-2019','To Date','Head of Department','','17',83,7536,2,0),(617,'06-08-2018','To Date','Head of Department','','17',0,7536,2,0),(618,'01-02-2016','31-01-2018','Head of Department','','17',105,6734,2,0),(619,'01-01-2014','To Date','Head of Department','','17',0,7638,2,0),(620,'07-10-2018','To Date','Head of Department','','17',83,7536,2,0),(621,'01-07-2010','30-04-2012','Head of Department','','17',107,10313,2,0),(622,'01-05-2012','05-05-2014','Head of Department','','17',0,10313,2,0),(623,'01-05-2014','30-10-2019','Head of Department','','17',107,10313,2,0),(624,'21-08-1996','07-09-1999','Assistant Director','','17',83,10596,1.5,0),(625,'01-04-2014','31-03-2016','Head of Department','','17',106,10596,2,0),(626,'01-01-2016','23-04-2018','Head of Department','','17',106,10596,2,0),(627,'02-04-2018','To Date','Head of Department','','17',0,10315,2,0),(628,'04-02-2019','To Date','Head of Department','','17',0,7649,2,0),(631,'01-02-2015','31-01-2017','Head of Department','','1',1,8477,2,1),(632,'01-02-2017','31-01-2019','Head of Department','','1',1,8477,2,1),(633,'25-05-2017','To Date','Senate Member','','11',0,9269,1.5,0),(637,'01-01-2019','28-11-2019','Head of Department','','2',13,10137,2,0),(638,'01-01-2017','31-12-2017','Head of Department','','2',13,10137,2,0),(645,'14-04-2008','14-10-2016','Head of Department','','15',77,9600,2,1),(646,'01-05-1995','31-05-1999','Assistant Dean','','7',34,7187,1.5,0),(647,'01-08-1994','30-04-1995','Assistant Dean','','7',34,7187,1.5,0),(650,'01-01-2007','31-10-2008','Head of Department','','7',34,7187,2,0),(651,'01-01-2010','31-12-2016','Director','Prof. Mubiana Macwan\'gi ','20',109,10476,2.5,0),(655,'01-01-2010','31-12-2015','Assistant Dean','','9',57,7652,1.5,0),(658,'02-01-2012','31-12-2017','Head of Department','','12',38,7885,2,6),(659,'01-07-2017','To Date','Head of Department','','13',69,8766,2,0),(660,'19-01-2015','09-09-2016','Director','School Seminars','1',5,10224,2.5,0),(661,'05-02-2020','NaN-NaN-NaN','Committee','2020 International Women\'s Day Preparatory Committee','11',0,10224,0.5,0),(662,'02-08-2019','To Date','Head of Department','','1',0,10224,2,0),(665,'01-02-2018','01-02-2020','Assistant Dean','','7',34,11712,1.5,0),(668,'09-11-2017','02-04-2020','Assistant Dean','','12',0,10735,1.5,3),(669,'21-08-2017','30-09-2018','Head of Department','','12',0,10735,2,3),(670,'01-03-2020','To Date','Head of Department','','8',55,9558,2,0),(672,'01-04-2016','31-03-2020','Head of Department','','1',4,9311,2,0),(674,'01-01-2020','To Date','Assistant Dean','','13',91,10744,1.5,3),(678,'01-09-2008','01-09-2009','Director','','18',0,7791,2.5,0),(680,'06-11-2019','To Date','Head of Department','','12',46,10538,2,0),(681,'09-11-2017','12-11-2019','Head of Department','','12',46,10538,2,0),(684,'01-04-2017','31-03-2020','Director','Henry M. Sichingabula','18',0,10363,2.5,0),(687,'01-04-2009','29-04-2020','Head of Department','','12',46,8324,2,1),(688,'01-04-2008','01-05-2009','Head of Department','','12',46,8324,2,1),(690,'16-08-2014','15-08-2018','Assistant Dean','','9',58,8407,1.5,0),(692,'01-05-2018','To Date','Head of Department','','6',50,9997,2,0),(696,'15-01-2018','18-05-2020','Director','Economic Policy management Programme','4',21,8362,2.5,0),(697,'15-11-2018','18-05-2020','Head of Department','','4',21,8362,2,0),(698,'09-04-2020','To Date','Assistant Director','','20',109,9761,1.5,0),(700,'01-04-2016','31-03-2018','Assistant Dean','','4',0,9418,1.5,0),(701,'25-03-2018','24-03-2020','Head of Department','','4',26,8108,2,0),(703,'01-03-2010','31-03-2012','Head of Department','','1',4,7791,2,0),(704,'01-04-2012','30-04-2014','Head of Department','','1',4,7791,2,0),(705,'01-02-2001','01-02-2003','Assistant Dean','','1',4,7791,1.5,0),(706,'02-02-2003','01-02-2005','Assistant Dean','','1',4,7791,1.5,0),(707,'02-02-2005','01-02-2007','Assistant Dean','','1',4,7791,1.5,0),(708,'06-07-2018','To Date','Head of Department','','9',57,8242,2,0),(709,'01-02-2020','To Date','Assistant Dean','','2',0,9606,1.5,1),(711,'14-12-2016','13-12-2018','Head of Department','','4',29,7823,2,0),(712,'14-12-2018','To Date','Head of Department','','4',29,7823,2,0),(713,'07-06-2020','To Date','Head of Department','','9',57,8242,2,0),(714,'18-04-2018','17-04-2020','Assistant Dean','','9',60,8961,1.5,0),(715,'18-04-2020','To Date','Assistant Dean','','9',60,8961,1.5,0),(716,'01-01-2017','31-12-2019','Dean','','7',36,7758,2.5,0),(717,'01-01-2020','To Date','Dean','','7',36,7758,2.5,0),(718,'01-01-2008','01-01-2012','Committee','Chairman, Staff Housing and Home Ownership Committee','11',0,6563,0.5,0),(719,'01-08-2019','To Date','Head of Department','','2',14,8718,2,1),(722,'01-03-2020','To Date','Head of Department','','8',52,9905,2,0),(723,'09-01-2017','07-01-2019','Head of Department','','8',52,8300,2,0),(724,'28-02-2018','28-02-2020','Head of Department','','8',55,7296,2,0),(725,'01-10-2002','30-09-2008','Assistant Dean','','8',0,1225,1.5,0),(726,'01-01-2019','31-12-2019','Head of Department','','8',52,1267,2,0),(727,'01-01-2010','31-12-2014','Head of Department','','8',52,1267,2,0),(728,'01-01-2006','31-12-2010','Assistant Dean','','8',52,1267,1.5,0),(729,'01-01-1998','31-12-2001','Assistant Dean','','8',52,1267,1.5,0),(730,'01-03-2016','28-02-2020','Assistant Dean','','8',51,9072,1.5,0),(735,'03-08-2014','02-08-2018','Assistant Dean','','2',0,9993,1.5,4),(737,'18-04-2018','17-04-2020','Head of Department','','9',61,8411,2,0),(738,'01-08-2018','25-08-2020','Head of Department','','17',83,7536,2,0),(740,'06-06-2018','06-06-2020','Head of Department','','9',57,8242,2,0),(741,'07-09-2020','To Date','Committee','Committee on UNZA Degree Programmes Offered by UNZA Affiliated Colleges & Offering of Short Courses in the University','11',0,10721,0.5,0),(742,'01-10-2005','16-09-2020','Head of Department','','6',42,8705,2,0),(745,'01-10-2020','To Date','Dean','','7',36,7758,2.5,0),(746,'01-04-2008','30-12-2011','Head of Department','','3',95,9755,2,0),(747,'01-03-2016','30-04-2019','Senate Member','','11',0,9755,1.5,0),(748,'01-11-2019','To Date','Head of Department','','1',0,9298,2,0),(749,'09-03-2016','08-03-2019','Senate Member','','11',0,9755,1.5,0),(750,'01-11-2018','To Date','Assistant Dean','','3',15,9755,1.5,0),(751,'01-04-2018','31-01-2020','Assistant Dean','','1',1,10895,1.5,0),(757,'01-01-2019','06-03-2020','Assistant Director','','6',37,0,1.5,0),(758,'01-04-2020','To Date','Director','Joseph Simbaya','20',109,9442,2.5,0),(759,'08-02-2020','28-10-2020','Head of Department','','17',107,11738,2,1),(761,'01-05-2020','18-11-2020','Head of Department','','9',61,8415,2,0),(762,'01-08-2017','To Date','Assistant Director','','17',83,8254,1.5,0),(763,'02-05-2020','To Date','Head of Department','','14',72,9574,2,0),(764,'01-10-2018','01-12-2020','Director','Folotiya','15',77,8345,2.5,0),(766,'20-09-2012','19-09-2014','Head of Department','','15',78,9775,2,0),(767,'20-09-2014','19-09-2016','Head of Department','','15',78,9775,2,0),(768,'20-09-2018','19-09-2020','Head of Department','','15',81,9775,2,0),(769,'20-09-2020','To Date','Head of Department','','15',81,9775,2,0),(770,'20-09-2016','19-09-2018','Head of Department','','15',78,9775,2,0),(772,'20-09-2018','19-09-2020','Head of Department','','15',77,10616,2,0),(773,'26-10-2020','To Date','Assistant Dean','','14',0,9296,1.5,0),(774,'01-11-2019','To Date','Assistant Director','','15',0,9980,1.5,0),(776,'01-05-2015','To Date','Management Appointed Committee Member','International Link and Advisory Coordinating Committee','11',0,7824,1,0),(777,'01-05-2015','To Date','Board Membership to UNZA-Based Operation','Research Board','11',0,7824,0.5,0),(780,'19-04-1999','To Date','Board Membership to UNZA-Based Operation','School of Agricultural Sciences, Board of Examiners','11',0,7824,0.5,0),(781,'19-04-1999','To Date','Board Membership to UNZA-Based Operation','School of Agricultural Sciences, Board of Studies','11',0,7824,0.5,0),(782,'09-07-2018','To Date','Management Appointed Committee Member','Appointed as Contact Person in the School of Agricultural Sciences for the Implementation of the University Strategic Plan for 2018 t0 2022','11',0,7824,1,0),(786,'01-09-2015','01-10-2016','Assistant Dean','','7',36,9842,1.5,0),(787,'01-10-2016','21-07-2017','Head of Department','','7',33,9842,2,0),(789,'12-01-2009','12-01-2013','Assistant Director','','18',0,9444,1.5,0),(791,'07-01-2013','08-01-2014','Assistant Dean','','2',0,8317,1.5,1),(792,'02-01-2011','03-01-2013','Assistant Dean','','2',0,8317,1.5,1),(796,'01-05-2012','30-04-2015','Committee','Member of the UNZA/NRDC Professional Committee','11',0,7824,0.5,0),(797,'05-01-2002','31-12-2004','Head of Department','','2',11,9444,2,0),(798,'01-12-2018','30-11-2020','Head of Department','','12',45,10767,2,1),(799,'12-01-2005','12-12-2009','Assistant Dean','','2',0,9444,1.5,0),(800,'01-01-2011','31-12-2016','Dean','','7',0,6613,2.5,0),(801,'01-01-2004','31-12-2006','Head of Department','','7',0,6613,2,0),(802,'01-01-2002','31-12-2004','Head of Department','','7',33,6613,2,0),(803,'01-01-1994','31-12-1997','Assistant Dean','','7',0,6613,1.5,0),(805,'16-03-2003','15-03-2005','Head of Department','','8',51,8427,2,1),(807,'01-07-2019','To Date','Management Appointed Committee Member','Member of UNZA – Biomedical Research Ethics Committee','11',0,7824,1,0),(808,'01-01-2008','30-04-2015','Board Membership to UNZA-Based Operation','Member of the Board of Studies, School of Mines, Representing the School of Agricultural Sciences','11',0,7824,0.5,0),(810,'01-11-2004','To Date','Board Membership to UNZA-Based Operation','Examiners','11',0,8475,0.5,0),(811,'01-11-2004','To Date','Board Membership to UNZA-Based Operation','','11',0,8475,0.5,0),(812,'05-10-2009','To Date','Committee','Social Functions','11',0,8475,0.5,0),(813,'07-01-2013','29-05-2015','Board Membership to UNZA-Based Operation','School of Engineering','11',0,8475,0.5,0),(814,'13-12-2010','10-10-2014','Committee','Field Station','11',0,8475,0.5,0),(819,'15-10-2017','14-10-2019','Head of Department','','1',2,10768,2,1),(820,'01-06-2019','To Date','Head of Department','','2',0,9403,2,4),(825,'01-06-2008','16-06-2020','Committee','Member of the School of Agricultural Sciences: Curriculum Review Committee','11',0,7824,0.5,0),(826,'16-06-2020','To Date','Committee','Member of the School of Agricultural Sciences: Postgraduate Studies Committee','11',0,7824,0.5,0),(830,'10-02-2009','06-08-2015','Committee','Member of the School of Agricultural Sciences: Nutrition Curriculum Development Committee','11',0,7824,0.5,0),(831,'22-04-2009','30-04-2015','Committee','Member of the School of Agricultural Sciences: Research Committee','11',0,7824,0.5,0),(833,'13-12-2008','27-12-2014','Committee','School Curriculum (incl. BSc & MSc Nutrition)','11',0,8475,0.5,0),(835,'15-10-2013','29-05-2015','Committee','Symposium ','11',0,8475,0.5,0),(836,'07-03-2014','06-03-2016','Head of Department','','4',24,10141,2,0),(839,'08-06-2016','07-06-2019','Senate Member','','11',0,8490,1.5,0),(841,'30-10-2020','To Date','Committee','Curriculum','11',0,8490,0.5,0),(842,'03-10-2016','To Date','Committee','ad-hoc','11',0,8490,0.5,0),(843,'01-11-2019','To Date','Committee','First year','11',0,8490,0.5,0),(847,'01-10-2016','30-09-2020','Registrar','','11',0,8492,2.5,0),(848,'20-06-2015','30-09-2020','Senate Member','','11',0,8492,1.5,0),(849,'20-06-2015','30-09-2020','Council Member','','11',0,8492,2,0),(850,'20-06-2015','30-09-2020','Council Standing Committee Member','','11',0,8492,2,0),(851,'20-06-2015','30-09-2020','Council Standing Committee Member','','11',0,8492,2,0),(852,'20-06-2015','30-09-2020','Council Standing Committee Member','','11',0,8492,2,0),(853,'20-06-2015','30-09-2020','Council Standing Committee Member','','11',0,8492,2,0),(854,'20-06-2015','30-09-2020','Council Standing Committee Member','','11',0,8492,2,0),(855,'10-11-2010','30-09-2020','Bargaining Unit Member','','11',0,8492,1.5,0),(856,'10-11-2010','19-06-2015','Council Standing Committee Member','','11',0,8492,2,0),(857,'01-07-2019','To Date','Board Membership to UNZA-Based Operation','GSB Lodge','11',0,8492,0.5,0),(858,'07-06-2018','30-09-2020','Council Ad-hoc Committee','Member, ZAMNET Shareholder Restructuring Technical Committee','11',0,8492,1.5,0),(859,'01-06-2018','30-09-2020','Bargaining Unit Member','','11',0,8492,1.5,0),(862,'01-01-2010','01-12-2014','Head of Department','','17',106,7480,2,0),(863,'01-01-2007','01-01-2009','Head of Department','','17',99,7480,2,0),(864,'01-06-2000','31-12-2000','Head of Department','','17',105,7480,2,0),(865,'01-01-2001','31-12-2006','Head of Department','','17',97,7480,2,0),(867,'05-03-2012','05-03-2016','Head of Department','','1',5,1585,2,0),(868,'05-03-2009','05-03-2012','Assistant Dean','','1',0,1585,1.5,0),(869,'01-07-2019','To Date','Head of Department','','2',7,8525,2,0),(876,'11-09-2018','11-09-2019','Assistant Dean','','7',35,9302,1.5,0),(877,'11-09-2019','11-09-2020','Assistant Dean','','7',35,9302,1.5,0),(880,'01-03-2017','28-02-2019','Head of Department','','7',35,7611,2,0),(881,'01-03-2019','02-02-2021','Head of Department','','7',35,7611,2,0),(883,'01-02-2016','31-01-2018','Assistant Dean','','2',0,1879,1.5,0),(884,'01-02-2018','31-01-2020','Assistant Dean','','2',0,1879,1.5,0),(885,'01-12-2002','30-11-2004','Head of Department','','2',6,1879,2,0),(886,'01-06-1987','31-05-1989','Assistant Director','','15',92,1879,1.5,0),(887,'01-01-2020','31-12-2020','Head of Department','','2',13,10137,2,0),(888,'01-06-2020','To Date','Head of Department','','13',69,10666,2,3),(892,'01-05-2019','To Date','Assistant Dean','','1',3,7824,1.5,0),(893,'01-05-2015','30-04-2017','Assistant Dean','','1',3,7824,1.5,0),(894,'01-05-2017','30-04-2019','Assistant Dean','','1',3,7824,1.5,0),(895,'01-04-2020','31-03-2021','Director','Henry M. Sichingabula','18',0,10363,2.5,0),(896,'09-02-2020','09-04-2021','Assistant Dean','','7',34,11717,1.5,1),(897,'01-08-2018','31-07-2020','Assistant Dean','','14',73,10925,1.5,0),(898,'03-07-2017','31-07-2019','Head of Department','','4',23,8264,2,0),(899,'01-03-2020','To Date','Assistant Dean','','8',51,8336,1.5,0),(900,'14-08-2019','18-11-2020','Assistant Dean','','8',56,9569,1.5,1),(901,'07-05-2013','06-05-2016','Head of Department','','4',0,10141,2,0),(902,'01-03-2021','To Date','Head of Department','','1',1,9472,2,0),(909,'01-01-2020','20-05-2021','Head of Department','','8',56,8388,2,0),(911,'01-03-2020','30-04-2021','Dean','','8',0,1267,2.5,0),(912,'10-10-2014','10-10-2015','Head of Department','','17',107,4500,2,0),(913,'01-06-2019','To Date','Committee','committe for rembursement of practicing license fees to professional bodies','11',0,11146,0.5,1),(914,'02-10-2006','30-04-2010','Head of Department','','13',0,10712,2,0),(916,'02-01-2017','15-04-2020','Dean','','13',0,10712,2.5,0),(917,'15-06-2015','30-12-2016','Head of Department','','13',69,10712,2,0),(918,'01-06-2019','31-05-21','Head of Department','','2',9,8317,2,1),(921,'03-05-2021','To Date','Director','Wilma S. S. Nchito','18',0,6873,2.5,0),(925,'02-06-2017','01-06-2021','Head of Department','','1',3,8423,2,0),(930,'01-04-2020','To Date','Head of Department','','1',0,9417,2,0),(932,'01-07-2014','01-04-2019','Head of Department','','14',0,10747,2,1),(933,'01-09-2020','To Date','Assistant Dean','','14',0,10747,1.5,1),(934,'07-08-2021','To Date','Assistant Dean','','7',35,10786,1.5,0),(936,'01-06-2017','31-12-2019','Assistant Dean','','13',0,9039,1.5,0),(938,'19-11-2020','To Date','Assistant Dean','','8',55,8524,1.5,0),(939,'01-06-2021','To Date','Head of Department','','2',9,10778,2,0),(945,'01-03-2017','28-02-2021','Assistant Dean','','1',0,10479,1.5,0),(949,'01-09-2021','To Date','Dean','','12',38,8337,2.5,1),(950,'13-09-2021','30-09-2021','Committee','Land Development ','11',0,6873,0.5,0),(951,'13-09-2012','01-10-2021','Committee','University Ranking','11',0,6873,0.5,0),(952,'03-05-2021','01-10-2021','Senate Member','','11',0,6873,1.5,0),(953,'01-01-2015','31-12-2016','Head of Department','','2',6,7398,2,0),(955,'15-07-2018','15-07-2020','Head of Department','','8',51,7289,2,0),(959,'30-11-2015','29-10-2019','Assistant Director','','15',92,8523,1.5,1),(960,'30-11-2017','31-10-2019','Assistant Director','','15',92,8523,1.5,1),(961,'06-01-2020','30-04-2021','Assistant Dean','','1',3,11488,1.5,0),(962,'04-05-2021','To Date','Assistant Dean','','1',3,11488,1.5,0),(963,'01-03-2009','01-03-2019','Head of Department','','6',0,7100,2,0),(965,'17-04-2014','17-04-2016','Assistant Dean','','9',61,7979,1.5,1),(966,'17-04-2016','16-04-2018','Assistant Dean','','9',61,7979,1.5,1),(967,'18-04-2006','17-04-2008','Head of Department','','9',61,7979,2,1),(968,'18-04-2008','17-04-2010','Head of Department','','9',61,7979,2,1),(973,'01-02-2020','To Date','Assistant Dean','','7',0,11717,1.5,1),(974,'01-10-2021','To Date','Head of Department','','1',3,11815,2,0),(976,'01-09-2021','To Date','Assistant Dean','','1',0,8195,1.5,0),(978,'01-04-2010','30-04-2014','Assistant Dean','','4',30,9264,1.5,0),(979,'07-05-21','07-05-23','Assistant Director','','18',0,9302,1.5,0),(980,'24-08-2018','23-05-2021','Committee','Senate Library and Publications Committee','11',0,9686,0.5,1),(982,'01-06-2021','07-01-2022','Head of Department','','12',38,9724,2,1),(983,'12-01-2022','To Date','Head of Department','','8',56,8249,2,0),(984,'01-12-2018','30-11-2021','Head of Department','','12',45,10767,2,1),(985,'01-06-2017','31-08-2021','Head of Department','','14',76,10738,2,0),(991,'21-04-2020','To Date','Dean','','13',0,9356,2.5,1),(995,'01-06-2021','To Date','Assistant Dean','','9',58,9689,1.5,0),(996,'01-01-2021','To Date','Assistant Dean','','8',52,10287,1.5,0),(997,'04-02-2021','To Date','Assistant Dean','','2',0,9740,1.5,0),(998,'18-09-2020','To Date','Head of Department','','9',58,9074,2,1),(1004,'01-01-2017','31-12-2020','Head of Department','','4',28,9225,2,0),(1005,'07-05-2018','To Date','Head of Department','','4',80,9399,2,0),(1006,'01-01-2021','07-03-2022','Management Appointed Committee Member','SENATE ADHOC COMMITTEE TO REVIEW THE OPERATIONS OF IDE','11',0,9574,1,0),(1008,'01-01-2021','07-03-2022','Management Appointed Committee Member','Mortality Surveillance Technical Working Group meeting MOH','11',0,9574,1,0),(1010,'28-01-2013','29-01-2016','Deputy Vice Chancellor','','11',0,1283,3,0),(1011,'29-01-2016','28-01-2020','Deputy Vice Chancellor','','11',0,1283,3,0),(1012,'22-06-2015','30-06-2016','Vice Chancellor','','11',0,1283,3.5,0),(1013,'01-12-2001','30-12-2004','Dean','','9',61,1283,2.5,0),(1014,'01-12-1995','30-12-1997','Head of Department','','9',61,1283,2,0),(1015,'01-05-1992','30-05-1994','Assistant Dean','','9',61,1283,1.5,0),(1016,'18-07-2010','17-07-2012','Head of Department','','8',51,9563,2,1),(1017,'18-07-2012','17-07-2014','Head of Department','','8',51,9563,2,1),(1021,'19-04-2019','17-04-2022','Assistant Dean','','6',39,9748,1.5,0),(1025,'01-02-2018','27-04-2022','Assistant Dean','','9',0,8062,1.5,0),(1028,'01-02-2022','To Date','Head of Department','','1',3,11856,2,0),(1030,'30-12-2020','27-04-2022','Assistant Dean','','9',0,8062,1.5,0),(1031,'24-05-2018','23-05-2021','Senate Member','','11',0,9686,1.5,1),(1032,'24-08-2018','23-05-2021','Committee','Senate Examination Irregularities Committee','11',0,9686,0.5,1),(1034,'01-04-2022','To Date','Head of Department','','13',67,12093,2,0),(1038,'01-01-1999','31-08-2004','Head of Department','','17',0,10056,2,0),(1039,'01-09-2005','30-04-2007','Head of Department','','17',0,10056,2,0),(1040,'01-07-2008','28-02-2010','Head of Department','','17',106,10056,2,0),(1041,'01-03-2010','31-05-2015','Director','Deputy University Librarian','17',83,10056,2.5,0),(1042,'01-02-2007','28-02-2011','Assistant Dean','','17',83,10056,1.5,0),(1043,'01-06-2015','30-09-2016','Director','Acting University Librarian','17',0,10056,2.5,0),(1044,'01-10-2016','28-02-2021','Director','University Librarian','17',83,10056,2.5,0),(1045,'09-05-2020','08-05-2022','Head of Department','','17',107,11738,2,0),(1046,'20-05-2019','To Date','Assistant Dean','','13',0,10724,1.5,0),(1047,'01-04-2018','31-03-2022','Assistant Dean','','4',0,8954,1.5,0),(1048,'30-03-2018','29-03-2022','Head of Department','','4',22,9555,2,0),(1049,'01-04-2022','To Date','Head of Department','','4',26,8341,2,0),(1053,'13-06-2022','To Date','Senate Member','','11',0,9574,1.5,0),(1054,'01-09-2020','To Date','Head of Department','','4',30,10519,2,1),(1062,'01-12-2020','To Date','Dean','','4',93,6696,2.5,0),(1063,'15-01-2021','To Date','Head of Department','','4',93,6696,2,0),(1064,'01-12-2014','10-06-2016','Assistant Dean','','4',24,6696,1.5,0),(1066,'01-07-2007','14-07-2010','Head of Department','','9',0,7193,2,0),(1069,'03-02-2017','03-02-2019','Assistant Dean','','2',11,10444,1.5,0),(1070,'03-02-2019','03-02-2021','Assistant Dean','','2',11,10444,1.5,0),(1071,'01-06-2016','31-12-2017','Assistant Dean','','3',17,10922,1.5,0),(1075,'01-04-2022','To Date','Assistant Dean','','4',20,11113,1.5,0),(1086,'01-06-2016','30-05-2018','Head of Department','','3',17,9782,2,1),(1087,'01-11-2018','30-05-2022','Assistant Dean','','3',17,9782,1.5,1),(1088,'31-05-2022','To Date','Head of Department','','3',17,9782,2,1),(1089,'14-07-2020','13-07-2022','Head of Department','','8',51,7289,2,0),(1090,'01-02-2022','To Date','Head of Department','','14',73,10925,2,0),(1091,'05-05-2022','25-07-2022','Management Appointed Committee Member','National TB/Leprosy Technical working Group','11',0,9574,1,0),(1092,'19-12-2018','18-12-2020','Assistant Dean','','9',0,8425,1.5,1),(1093,'19-12-2016','18-12-2018','Assistant Dean','','9',0,8425,1.5,1),(1094,'01-04-2018','30-04-2022','Head of Department','','13',67,10559,2,1),(1095,'03-01-2011','01-08-2022','Head of Department','','20',109,10001,2,0),(1096,'11-02-2019','31-08-2021','Head of Department','','12',38,10667,2,0),(1100,'16-11-2016','16-11-2020','Union Executive - Treasurer','','11',0,8444,1,1),(1101,'17-12-2016','16-11-2020','Council Standing Committee Member','','11',0,8444,2,1),(1102,'16-11-2016','16-11-2020','Bargaining Unit Member','','11',0,8444,1.5,1),(1103,'07-07-2014','31-05-2016','Assistant Dean','','3',17,9782,1.5,1),(1105,'01-06-2021','To Date','Head of Department','','2',0,9403,2,0),(1106,'01-11-2021','To Date','Head of Department','','6',39,9757,2,0),(1107,'09-05-2022','To Date','Head of Department','','17',0,11738,2,0),(1109,'02-01-2022','To Date','Head of Department','','6',43,12595,2,0),(1110,'01-12-2021','To Date','Head of Department','','17',99,10574,2,1),(1111,'01-06-2018','30-11-2021','Head of Department','','17',103,10574,2,1),(1113,'01-05-2012','31-05-2014','Head of Department','','17',103,10574,2,1),(1114,'01-06-2014','31-05-2016','Head of Department','','17',103,10574,2,1),(1115,'01-06-2016','31-05-2018','Head of Department','','17',103,10574,2,1),(1116,'15-10-2021','To Date','Head of Department','','14',110,9723,2,1),(1117,'15-10-2021','To Date','Head of Department','','14',110,9723,2,1),(1118,'15-10-2019','14-10-2021','Head of Department','','14',110,9723,2,1),(1119,'10-01-2022','To Date','Head of Department','','12',65,12205,2,0),(1120,'01-07-2022','To Date','Senate Member','','11',0,12205,1.5,0),(1121,'01-05-2010','30-04-2012','Head of Department','','17',97,10314,2,0),(1122,'01-05-2013','30-04-2015','Head of Department','','17',97,10314,2,0),(1123,'01-05-2015','30-04-2017','Head of Department','','17',97,10314,2,0),(1124,'01-01-2022','To Date','Head of Department','','17',105,10314,2,0),(1126,'01-06-2017','31-05-2019','Assistant Dean','','12',45,8312,1.5,1),(1127,'01-06-2019','31-08-2021','Assistant Dean','','12',45,8312,1.5,1),(1129,'21-12-2021','To Date','Director','UNZA Ranking Committee','18',0,6873,2.5,0),(1130,'03-11-2021','To Date','Director','ADHOC Committee to Review 2022 Budget','18',0,6873,2.5,0),(1131,'20-11-2021','To Date','Director','UNZA Publications Committee','18',0,6873,2.5,0),(1132,'05-01-2022','To Date','Director','ADHOC COmmittee Customer ServiceCharter','18',0,6873,2.5,0),(1133,'10-03-2022','To Date','Director','E-Campus Advisory Committee','18',0,6873,2.5,0),(1134,'14-05-2021','To Date','Director','SHEPIZ Advisory Committee','18',0,6873,2.5,0),(1135,'07-03-2022','To Date','Director','Standing COntract ad COnsultancy Committee','18',0,6873,2.5,0),(1136,'01-03-2022','To Date','Director','University ICT Committee','18',0,6873,2.5,0),(1137,'19-09-2022','To Date','Director','Executive Management Business Planning Committee','18',0,6873,2.5,0),(1138,'01-06-2019','31-05-2021','Assistant Dean','','3',16,12257,1.5,1),(1139,'09-01-2020','To Date','Assistant Dean','','6',43,9005,1.5,0),(1140,'01-06-2017','31-05-2019','Assistant Dean','','6',39,9754,1.5,0),(1141,'01-07-2021','11-10-2022','Head of Department','','7',33,9842,2,0),(1143,'01-04-2020','04-08-2022','Dean of Student Affairs','','11',0,8852,2.5,0),(1149,'01-02-2016','To Date','Head of Department','','17',100,4500,2,0),(1150,'01-02-2020','31-01-2022','Head of Department','','17',100,4500,2,0),(1154,'24-02-2020','28-11-2022','Committee','Partnership & Outreach Coordinator','11',0,8475,0.5,0),(1157,'19-09-2022','01-12-2022','Assistant Dean','','9',0,8408,1.5,1),(1158,'03-02-2015','21-07-2016','Assistant Director','','20',0,10785,1.5,0),(1159,'13-08-2019','To Date','Head of Department','','8',53,8588,2,0),(1160,'01-11-2022','To Date','Assistant Dean','','17',0,10056,1.5,0),(1161,'16-08-2018','15-10-2022','Assistant Dean','','9',60,9433,1.5,1),(1162,'01-06-2012','30-06-2014','Head of Department','','14',75,7786,2,0),(1163,'01-07-2016','18-07-2018','Assistant Dean','','14',72,7786,1.5,0),(1164,'01-03-2019','31-05-2020','Head of Department','','14',72,7786,2,0),(1165,'01-06-2020','20-12-2022','Dean','','14',0,7786,2.5,0),(1167,'02-06-2021','02-02-2022','Head of Department','','1',3,10917,2,0),(1169,'18-02-2014','17-02-2016','Head of Department','','1',4,8495,2,0),(1171,'01-01-2019','30-04-2022','Director','University Librarian','17',0,10056,2.5,0),(1172,'23-08-2021','To Date','Director','IDE','15',0,8915,2.5,0),(1173,'01-01-2018','01-02-2021','Assistant Dean','','14',74,8915,1.5,0),(1174,'09-12-2022','To Date','Head of Department','','3',0,10947,2,0),(1175,'21-11-2005','22-11-2007','Board Membership to UNZA-Based Operation','Chairperson UNZA Staff Housing Committee','11',0,8517,0.5,0),(1176,'10-09-2010','10-09-2013','Senate Member','','11',0,8517,1.5,0),(1177,'01-12-2000','01-12-2002','Head of Department','','2',11,8517,2,0),(1178,'12-12-2008','12-09-2010','Committee','Member Standing ExaminationsIrregularities Committee of Senatre','11',0,8517,0.5,0),(1179,'20-09-2010','20-09-2013','Committee','Member, Senate Curriculumand Examinations Committeefor SChools of Education, Law ans HSS','11',0,8517,0.5,0),(1180,'01-07-1992','01-07-1994','Head of Department','','2',7,8517,2,0),(1181,'01-07-1994','01-07-1996','Head of Department','','2',7,8517,2,0),(1182,'01-07-1996','09-07-1998','Head of Department','','2',7,8517,2,0),(1184,'01-07-2020','To Date','Head of Department','','20',109,11064,2,1),(1185,'20-11-2022','To Date','Committee','Senate Distance Education Committee','11',0,9574,0.5,0),(1186,'01-03-2016','31-05-2018','Assistant Dean','','3',0,10947,1.5,0),(1187,'01-01-2019','31-12-2022','Head of Department','','8',54,9063,2,1),(1188,'06-05-2013','31-12-2013','Dean','','9',57,6525,2.5,1),(1190,'03-03-2016','28-02-2020','Head of Department','','1',5,8195,2,0),(1194,'22-06-2015','30-09-2016','Registrar','','11',0,8492,2.5,0),(1196,'10-11-2010','30-04-2012','Director','Deputy Registrar (Acting)','11',0,8492,2.5,0),(1197,'01-05-2012','30-04-2015','Director','Deputy Registrar','11',0,8492,2.5,0),(1198,'22-06-2015','30-09-2020','Board Membership to UNZA-Based Operation','TDAU Board of Directors','11',0,8492,0.5,0),(1199,'03-08-2015','30-09-2020','Management Appointed Committee Member','Chairperson, Remodeling Income Generation (RIG)','11',0,8492,1,0),(1200,'19-12-2020','18-12-2022','Head of Department','','9',60,8772,2,1),(1201,'19-12-2022','To Date','Head of Department','','9',60,8772,2,1),(1202,'03-08-2022','To Date','Head of Department','','2',0,10140,2,0),(1203,'31-05-2020','31-05-2022','Assistant Dean','','7',0,11333,1.5,0),(1204,'20-09-2020','25-03-2021','Head of Department','','9',61,10945,2,0),(1205,'25-03-2021','To Date','Head of Department','','9',61,10945,2,0),(1206,'01-12-2022','To Date','Assistant Director','','15',92,10616,1.5,0),(1207,'01-01-2017','22-02-2023','Dean','','9',0,7193,2.5,0),(1208,'02-12-22','24-02-2023','Assistant Dean','','9',0,8062,1.5,0),(1209,'17-09-1981','23-11-1982','Head of Department','','4',21,8902,2,0),(1210,'01-11-2019','01-11-2022','Head of Department','','15',77,9941,2,0),(1211,'13-02-2022','To Date','Director','Quality Assurance Committee','18',0,6873,2.5,0),(1213,'16-11-2005','15-11-2007','Head of Department','','8',53,6873,2,0),(1214,'17-09-2022','To Date','Director','Committee on Consultancy and Projects','18',0,6873,2.5,0),(1215,'14-12-2022','To Date','Director','Project Advisory Committee','18',0,6873,2.5,0),(1216,'01-10-2019','28-02-2023','Assistant Director','','15',92,8407,1.5,0),(1218,'13-08-2010','12-08-2012','Head of Department','','17',98,8416,2,0),(1219,'13-08-2012','18-08-2014','Head of Department','','17',98,8416,2,0),(1220,'13-08-2014','12-08-2016','Head of Department','','17',98,8416,2,0),(1221,'13-08-2016','12-08-2018','Head of Department','','17',98,8416,2,0),(1222,'13-08-2018','12-08-2020','Head of Department','','17',98,8416,2,0),(1223,'13-08-2020','12-08-2022','Head of Department','','17',98,8416,2,0),(1224,'01-07-2016','03-01-2019','Dean','','1',0,12148,2.5,0),(1227,'03-08-2018','09-03-2021','Head of Department','','2',11,10096,2,1),(1228,'04-08-2020','30-11-2022','Assistant Dean','','9',62,9686,1.5,0),(1229,'01-12-2022','To Date','Assistant Dean','','9',61,9686,1.5,0),(1230,'20-09-2020','19-09-2022','Head of Department','','15',77,10616,2,0);

--
-- Table structure for table `pss_user_specialization`
--

CREATE TABLE `pss_user_specialization` (
  `ID` int NOT NULL AUTO_INCREMENT,
  `manNumber` int unsigned NOT NULL,
  `specializationID` int NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `manNumber` (`manNumber`),
  KEY `specializationID` (`specializationID`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `pss_user_specialization`
--

INSERT INTO `pss_user_specialization` VALUES (2,10662,12),(3,6550,2),(4,6027,4),(5,12172,10),(6,11023,9),(7,9753,9),(9,12124,3),(11,9997,2),(12,10717,2),(13,11483,9),(14,8705,3),(16,12130,3),(17,12130,3),(19,10453,11),(20,10664,11),(22,10688,11),(23,10445,11),(24,10445,14),(25,10445,17),(27,7773,1),(28,12595,4),(29,9005,4),(30,9005,16),(34,12674,10),(35,12540,4),(36,7100,7);

--
-- Table structure for table `pss_weights`
--

CREATE TABLE `pss_weights` (
  `id` int NOT NULL AUTO_INCREMENT,
  `year_record` year NOT NULL,
  `category` varchar(145) NOT NULL,
  `weight` double NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`,`category`)
) ENGINE=InnoDB AUTO_INCREMENT=95 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pss_weights`
--

INSERT INTO `pss_weights` VALUES (1,2018,'teaching_years_of_service',3),(2,2018,'courses_taught_undergraduate',4.5),(3,2018,'courses_taught_postgraduate',6.5),(4,2018,'teaching_student_overload',2.5),(5,2018,'approved_courses_individual',5.5),(6,2018,'approved_courses_group',4.5),(7,2018,'doctorate_supervisor',10),(8,2018,'doctorate_co_supervisor',7.5),(9,2018,'doctorate_board_of_examiners',2),(10,2018,'doctorate_thesis_marking',5),(11,2018,'masters_supervisor',6.5),(12,2018,'masters_co_supervisor',5),(13,2018,'masters_thesis_marking',3),(14,2018,'diploma_supervisor',3),(15,2018,'diploma_co_supervisor',2),(16,2018,'diploma_thesis_marking',1),(17,2018,'student_evaluation',5),(18,2018,'supervisor_evaluation',4),(19,2018,'course_coordination',2.5),(20,2018,'qualifications',2),(21,2018,'peer_reviewed_multiple_authors',3.75),(22,2018,'peer_reviewed_single_author',7.5),(23,2018,'peer_reviewed_proceedings_multiple_authors',3),(24,2018,'peer_reviewed_proceedings_single_author',6),(25,2018,'non_peer_reviewed',3.5),(26,2018,'commissioned_research_report',6),(27,2018,'book_single_author',8),(28,2018,'book_lead_author',4.5),(29,2018,'book_chapters_in_a_book',4),(30,2018,'book_creative_writing',3),(31,2018,'conference_paper',3.5),(32,2018,'conference_speaker',4),(33,2018,'conference_facilitation',3),(34,2018,'conference_attendance',1),(35,2018,'patents',9),(36,2018,'patent_related',6),(37,2018,'media_discussions',1),(38,2018,'journal_refereeing_and_editing_chairperson',2.5),(39,2018,'post_doctoral_research',10),(40,2018,'scholarly_index_one',1),(41,2018,'scholarly_index_two',2),(42,2018,'scholarly_index_three',3),(43,2018,'scholarly_index_four',4),(44,2018,'scholarly_index_five',5),(45,2018,'scholarly_index_six',6),(46,2018,'scholarly_index_seven',7),(47,2018,'scholarly_index_eight',8),(48,2018,'scholarly_index_nine',9),(49,2018,'scholarly_index_ten',10),(50,2018,'administration_vice_chancellor',3.5),(51,2018,'administration_deputy_vice_chancellor',3),(52,2018,'administration_central_support',2.5),(53,2018,'administration_dean_and_director',2.5),(54,2018,'administration_assistant_dean',1.5),(55,2018,'administration_hod',2),(56,2018,'administration_union_top_executive',1),(57,2018,'administration_union_executive',1),(58,2018,'administration_council_member',2),(59,2018,'administration_senate_member',1.5),(60,2018,'administration_council_committee_member',2),(61,2018,'administration_bargaining_council_member',1.5),(62,2018,'administration_management_appointed_committee_member',1),(63,2018,'administration_committee_and_board_member',0.5),(64,2018,'resource_mobilization_range_five',5),(65,2018,'resource_mobilization_range_one',1),(66,2018,'resource_mobilization_range_two',2),(67,2018,'resource_mobilization_range_three',3),(68,2018,'resource_mobilization_range_four',4),(69,2018,'statutory_organization_chairperson',0.5),(70,2018,'statutory_organization_secretary_or_official',0.5),(71,2018,'statutory_organization_member',0.5),(72,2018,'non_statutory_organization_chairperson',0.5),(73,2018,'non_statutory_organization_secretary_or_official',0.5),(74,2018,'non_statutory_organization_member',0.5),(75,2018,'associations',0.5),(76,2018,'secondment_above_director',1.5),(77,2018,'secondment_director',1),(78,2018,'secondment_below_director',1),(79,2018,'awards_recognized_international_award',2.5),(80,2018,'awards_conferred_by_state',1.5),(81,2018,'awards_conferred_by_university_or_professional_body',1),(82,2018,'consultancy_university_sourced',3.5),(83,2018,'consultancy_self_sourced',1),(84,2018,'miscellaneous_contributions',0.5),(85,2018,'sabbatical_leave',1.5),(86,2018,'external_examination',1.5),(87,2018,'membership_to_professional_body_fellow',1.5),(88,2018,'membership_to_professional_body_member',1),(89,2018,'membership_to_professional_body_associate',0.5),(90,2018,'administrations_relevant_contributions',0.5),(91,2018,'journal_refereeing_and_editing_member',1.5),(92,2018,'journal_refereeing_and_editing_others',1),(93,2018,'book_co_author',4),(94,2018,'book_editor',4.5);

--
-- Table structure for table `pss_years_of_services`
--

CREATE TABLE `pss_years_of_services` (
  `id` int NOT NULL AUTO_INCREMENT,
  `man_number` int unsigned NOT NULL,
  `recordStatusCode` tinyint NOT NULL DEFAULT '0',
  `weight` double NOT NULL,
  `years_of_service` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `man_number` (`man_number`)
) ENGINE=InnoDB AUTO_INCREMENT=875 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `pss_years_of_services`
--

INSERT INTO `pss_years_of_services` VALUES (1,8392,0,3,10),(2,6525,1,3,29),(3,90,0,3,0),(4,7280,0,3,18),(5,9716,0,3,28),(6,8062,5,3,14),(7,6444,0,3,29),(8,10010,0,3,6),(9,9782,1,3,12),(10,10097,3,3,11),(11,10142,0,3,0),(12,9992,1,3,22),(13,10560,0,3,8),(14,6728,0,3,0),(15,10302,0,3,8),(16,9225,0,3,14),(17,8264,0,3,24),(18,9749,3,3,9),(19,10538,0,3,8),(20,9600,1,3,14),(21,9775,0,3,14),(22,8766,1,3,8),(23,8352,1,3,15),(24,11294,0,3,0),(25,9994,0,3,32),(26,10744,3,3,9),(27,9023,0,3,19),(28,8337,4,3,10),(29,10616,0,3,11),(30,7296,0,3,17),(31,8414,0,3,0),(32,6887,0,3,17),(33,8384,0,3,14),(34,9356,1,3,13),(35,10512,0,3,6),(36,10768,1,3,11),(37,8195,1,3,20),(38,8477,1,3,15),(39,9311,0,3,13),(40,10504,0,3,3),(41,10547,3,3,8),(42,6182,0,3,22),(43,9703,0,3,30),(44,10618,0,3,7),(45,10712,0,3,27),(46,10666,2,3,9),(47,6940,0,3,20),(48,10724,2,3,6),(49,10549,0,3,7),(50,8588,3,3,12),(51,10286,0,3,7),(52,10495,0,3,13),(53,10388,0,3,9),(54,10672,0,3,6),(55,10396,0,3,8),(56,8436,0,3,19),(57,7621,0,3,18),(58,10292,0,3,10),(59,684,0,3,11),(60,6665,0,3,18),(61,7789,0,3,19),(62,8108,0,3,12),(63,8341,0,3,14),(64,10649,0,3,4),(65,8669,0,3,0),(66,8773,1,3,2),(67,8324,1,3,16),(68,9018,0,3,0),(69,10735,3,3,7),(70,10720,3,3,7),(71,8423,0,3,14),(72,8020,0,3,21),(73,11102,1,3,5),(74,7643,0,3,0),(75,10251,0,3,0),(76,10241,0,3,0),(77,9938,0,3,2),(78,9269,0,3,14),(80,9755,0,3,26),(81,9908,0,3,6),(82,11856,0,3,8),(83,6729,0,3,0),(84,10581,0,3,0),(85,7675,0,3,0),(86,7193,0,3,26),(87,8019,0,3,0),(88,10783,0,3,0),(89,9840,0,3,0),(90,895,0,3,0),(91,1988,0,3,20),(92,7119,0,3,25),(93,7328,0,3,21),(94,7438,0,3,15),(95,8204,0,3,14),(96,7801,0,3,0),(97,9558,0,3,11),(98,8338,0,3,7),(99,8524,0,3,13),(100,10170,3,3,8),(101,11478,0,3,6),(102,10586,0,3,6),(103,10320,1,3,7),(104,7824,0,3,22),(105,9414,0,3,0),(106,8345,0,3,11),(107,9471,0,3,12),(108,9413,1,3,14),(109,9751,0,3,10),(110,8253,0,3,0),(111,10656,0,3,3),(112,9418,0,3,15),(113,10828,0,3,0),(114,9424,0,3,0),(115,7403,0,3,26),(116,11376,1,3,14),(117,10245,0,3,4),(118,6651,0,3,0),(119,10554,0,3,5),(120,10745,0,3,0),(121,10545,0,3,7),(122,10552,0,3,0),(123,8486,0,3,8),(124,10546,0,3,6),(125,10671,0,3,0),(126,9550,0,3,11),(127,10652,0,3,1),(128,10651,0,3,6),(129,10894,0,3,4),(130,9409,0,3,9),(131,10944,0,3,0),(132,10057,0,3,1),(133,9904,0,3,11),(134,7246,0,3,3),(135,10267,0,3,4),(136,9098,0,3,17),(137,7787,0,3,20),(138,10674,0,3,2),(139,11820,0,3,1),(140,7885,6,3,18),(141,10752,0,3,7),(142,9320,3,3,13),(143,10530,2,3,3),(144,6116,0,3,5),(145,10781,2,3,6),(146,10668,2,3,7),(147,10548,2,3,10),(148,10675,3,3,7),(149,10956,0,3,4),(150,10551,2,3,5),(151,10564,2,3,5),(152,10667,2,3,6),(153,9724,1,3,9),(154,9428,0,3,16),(155,7804,0,3,0),(156,9844,0,3,0),(157,8267,0,3,14),(158,7823,0,3,22),(159,10818,0,3,6),(160,10594,0,3,4),(161,10760,0,3,5),(162,11331,0,3,0),(163,7168,1,3,26),(164,10479,0,3,10),(165,10280,0,3,10),(166,1585,0,3,28),(167,9624,0,3,13),(168,8526,0,3,0),(169,8310,0,3,0),(170,9399,0,3,9),(171,10458,0,3,0),(172,10852,0,3,0),(173,10866,0,3,0),(174,10078,0,3,0),(175,8475,0,3,18),(176,7178,0,3,24),(177,8388,3,3,12),(178,8300,0,3,14),(179,10359,0,3,0),(180,9827,0,3,7),(181,10088,0,3,0),(182,9552,0,3,0),(183,10570,0,3,0),(184,10382,0,3,0),(185,9569,1,3,7),(186,7746,0,3,0),(187,8942,0,3,0),(188,10686,0,3,3),(189,2214,0,3,21),(190,1225,0,3,18),(191,6624,0,3,0),(192,10253,0,3,13),(193,8490,0,3,19),(194,793,0,3,0),(195,8128,0,3,17),(196,1952,0,3,0),(197,11491,0,3,0),(198,10558,0,3,0),(199,7259,0,3,14),(200,7130,0,3,0),(201,10079,1,3,10),(202,10879,1,3,6),(203,10780,1,3,9),(204,6295,0,3,0),(205,10224,0,3,7),(206,7153,0,3,0),(207,9756,0,3,8),(208,10185,0,3,0),(209,6918,0,3,0),(210,9074,1,3,17),(211,9434,1,3,10),(212,8408,1,3,17),(213,8483,0,3,12),(214,7432,0,3,0),(215,9689,0,3,1),(216,10172,0,3,9),(217,8249,1,3,22),(218,8116,0,3,18),(219,8445,0,3,20),(220,10772,0,3,4),(221,8407,0,3,18),(222,9072,0,3,11),(223,8134,0,3,28),(224,7289,0,3,17),(225,9563,1,3,13),(226,562,0,3,0),(227,9308,0,3,0),(228,9911,0,3,5),(229,10022,0,3,0),(230,7090,0,3,0),(231,9910,0,3,0),(232,8427,1,3,30),(233,8429,0,3,0),(234,10597,0,3,6),(235,10403,0,3,3),(236,8410,0,3,10),(237,10265,0,3,1),(238,9063,1,3,17),(239,9626,0,3,3),(240,10432,0,3,0),(241,10638,0,3,0),(242,10402,0,3,8),(243,10156,0,3,13),(244,7137,0,3,0),(245,1758,0,3,7),(246,10516,0,3,18),(247,7436,0,3,0),(248,10250,0,3,6),(249,9909,0,3,0),(250,6739,0,3,25),(251,10505,0,3,6),(252,9222,0,3,12),(253,8772,4,3,18),(254,9597,0,3,0),(255,1177,0,3,0),(256,8961,0,3,10),(257,9227,0,3,10),(258,7370,6,3,22),(259,10137,0,3,10),(260,10477,1,3,8),(261,8142,0,3,20),(262,11923,0,3,4),(263,9694,0,3,11),(264,9826,0,3,0),(265,10101,0,3,4),(266,9607,0,3,10),(267,9433,1,3,12),(268,7433,0,3,5),(269,10299,0,3,0),(270,8235,0,3,16),(271,9946,0,3,9),(272,10842,0,3,6),(273,8242,0,3,14),(274,9914,0,3,0),(275,9623,1,3,9),(276,7652,0,3,20),(277,10327,0,3,4),(278,10319,0,3,9),(279,9220,1,3,12),(280,10779,0,3,6),(281,8251,0,3,0),(282,7181,0,3,0),(283,7541,0,3,20),(284,8262,0,3,42),(285,9628,0,3,0),(286,6772,0,3,30),(287,6873,0,3,29),(288,8878,0,3,13),(289,7132,0,3,0),(290,10293,3,3,11),(291,10822,0,3,6),(292,101821,0,3,6),(293,8397,1,3,15),(294,8425,1,3,17),(295,9551,1,3,10),(297,8718,1,3,7),(298,10264,0,3,6),(299,10737,0,3,4),(300,10004,2,3,5),(301,10679,0,3,2),(302,11242,1,3,6),(303,11375,0,3,6),(304,10363,0,3,29),(305,8336,0,3,8),(306,8369,0,3,15),(307,10431,0,3,3),(308,8525,0,3,13),(309,9686,1,3,12),(310,9065,5,3,19),(311,10947,0,3,9),(312,9473,0,3,0),(313,9070,0,3,17),(314,10685,1,3,10),(315,8312,3,3,15),(316,10721,3,3,8),(317,11147,1,3,6),(318,1267,0,3,23),(319,9071,0,3,16),(320,9729,1,3,12),(321,8343,0,3,11),(322,10778,0,3,9),(323,9572,0,3,0),(324,8193,1,3,16),(325,10100,0,3,6),(326,9725,0,3,0),(327,9852,0,3,11),(328,10930,0,3,5),(329,9606,1,3,11),(330,9358,0,3,10),(331,6948,0,3,10),(332,9731,0,3,9),(333,9401,0,3,8),(334,7123,0,3,27),(335,10576,0,3,0),(336,8854,0,3,0),(337,8317,1,3,17),(338,10841,0,3,6),(339,8808,0,3,0),(340,7480,0,3,21),(341,9945,0,3,13),(342,9221,0,3,12),(343,9435,0,3,4),(344,8320,0,3,19),(345,10255,0,3,1),(346,9730,1,3,10),(347,8355,0,3,16),(348,9406,0,3,9),(349,9706,1,3,9),(350,9738,0,3,7),(351,9728,0,3,0),(352,11351,0,3,0),(353,8523,1,3,16),(354,9702,0,3,0),(355,10767,1,3,7),(356,9932,0,3,7),(357,8901,0,3,4),(358,10158,0,3,0),(359,10531,0,3,4),(360,10332,0,3,3),(361,8246,0,3,1),(362,7177,0,3,0),(363,8446,0,3,5),(364,10722,0,3,0),(365,9376,0,3,0),(366,8945,0,3,0),(367,9362,4,3,17),(368,10542,0,3,4),(369,9403,3,3,12),(370,10090,1,3,13),(371,9937,0,3,17),(372,10567,3,3,9),(373,8759,0,3,11),(374,8512,0,3,0),(375,9941,0,3,14),(376,10541,0,3,4),(377,9793,1,3,12),(378,9443,0,3,0),(379,9936,0,3,1),(380,8485,0,3,11),(381,9118,3,3,13),(382,9398,3,3,12),(384,8779,0,3,18),(385,10670,0,3,5),(386,9761,0,3,7),(387,8362,1,3,12),(388,8354,0,3,0),(389,11467,3,3,6),(390,10155,0,3,5),(391,7398,0,3,17),(392,9776,0,3,3),(393,9549,0,3,3),(394,9771,0,3,0),(395,7551,0,3,0),(396,9230,0,3,0),(397,11236,0,3,0),(398,8135,0,3,22),(399,8411,0,3,16),(400,1879,0,3,26),(401,9022,0,3,21),(402,9759,0,3,0),(403,10676,0,3,2),(404,10535,0,3,8),(405,9603,0,3,0),(406,10150,0,3,7),(407,9529,0,3,0),(408,9294,0,3,12),(409,9740,0,3,13),(410,9859,1,3,13),(411,8399,0,3,18),(412,8540,3,3,13),(413,10095,0,3,10),(414,9742,0,3,8),(415,10536,0,3,10),(416,8400,3,3,19),(417,10094,0,3,0),(418,9735,0,3,7),(419,10096,3,3,8),(420,9736,0,3,10),(421,10444,0,3,10),(422,9933,3,3,15),(423,10289,0,3,6),(424,9858,0,3,12),(425,10534,0,3,8),(426,9980,0,3,13),(427,9444,0,3,27),(428,11475,0,3,3),(429,1856,0,3,0),(430,10103,3,3,13),(431,8517,0,3,37),(432,10539,0,3,5),(433,7384,0,3,0),(434,8822,0,3,0),(435,7538,0,3,6),(436,10077,0,3,0),(437,10143,0,3,5),(438,9354,1,3,14),(439,9555,0,3,9),(440,8954,0,3,13),(441,10181,0,3,28),(442,11327,0,3,5),(443,10360,0,3,0),(444,7862,0,3,26),(445,8107,0,3,0),(446,11675,0,3,0),(447,9903,0,3,7),(448,7026,0,3,20),(449,10637,0,3,3),(450,10682,0,3,6),(451,9784,0,3,9),(452,8444,1,3,16),(453,10922,0,3,21),(454,6814,0,3,5),(455,10023,0,3,10),(456,10635,0,3,5),(457,9677,0,3,11),(458,9930,0,3,0),(459,9415,0,3,1),(460,9786,0,3,7),(461,10808,0,3,0),(462,10795,0,3,0),(463,10807,0,3,2),(464,9804,0,3,5),(465,9993,4,3,11),(466,10331,0,3,7),(467,10816,0,3,6),(468,8503,0,3,0),(469,8160,0,3,0),(470,10661,0,3,0),(471,9411,0,3,0),(472,7734,0,3,0),(473,9416,1,3,8),(474,8495,0,3,18),(475,9417,1,3,7),(476,10819,1,3,14),(477,7776,0,3,0),(478,8396,0,3,3),(479,7791,0,3,23),(480,10488,0,3,3),(481,6683,0,3,0),(482,7784,0,3,0),(483,7778,0,3,1),(484,10174,0,3,6),(485,8243,0,3,11),(486,8521,0,3,0),(487,9480,0,3,0),(488,8415,1,3,12),(489,11682,0,3,2),(490,9880,0,3,12),(491,10503,2,3,9),(492,10453,0,3,5),(493,10482,2,3,8),(494,10664,2,3,5),(495,10662,2,3,3),(496,10665,2,3,4),(497,7498,0,3,23),(498,10688,0,3,7),(499,8071,0,3,0),(500,6544,0,3,27),(501,6236,0,3,0),(502,10727,0,3,6),(503,10747,1,3,11),(504,10709,0,3,0),(505,6882,0,3,15),(506,10256,0,3,4),(507,8254,0,3,3),(508,9934,0,3,0),(509,9474,0,3,12),(510,7536,0,3,9),(511,10574,1,3,10),(512,10573,0,3,0),(513,10314,0,3,12),(516,10669,2,3,6),(517,4500,0,3,8),(518,10655,0,3,3),(519,8122,0,3,20),(520,10603,0,3,6),(521,10559,1,3,10),(522,8113,0,3,13),(523,10658,0,3,4),(524,8014,0,3,20),(525,10660,0,3,6),(526,8493,0,3,13),(527,8819,0,3,23),(528,10653,1,3,7),(529,10081,0,3,0),(530,6732,0,3,24),(531,8915,0,3,10),(532,10659,0,3,7),(533,6734,0,3,0),(534,7638,0,3,0),(535,11738,1,3,0),(536,10313,0,3,0),(537,10596,0,3,6),(538,7649,0,3,0),(539,10315,0,3,5),(540,8494,0,3,4),(541,8112,0,3,17),(542,10763,0,3,0),(543,10104,0,3,0),(544,8393,0,3,0),(545,10917,3,3,11),(546,10802,1,3,15),(547,10654,0,3,4),(548,10714,0,3,0),(549,10082,0,3,0),(550,8940,0,3,0),(551,7859,0,3,11),(552,8139,0,3,0),(553,9701,0,3,0),(554,8569,0,3,0),(555,10703,0,3,0),(556,8405,0,3,0),(557,11719,0,3,0),(558,8137,0,3,17),(559,6867,0,3,0),(560,10678,1,3,6),(561,8017,0,3,0),(562,10620,0,3,0),(563,11516,0,3,0),(564,11674,0,3,1),(565,10140,0,3,9),(566,9144,0,3,0),(567,10884,0,3,3),(568,10621,0,3,11),(569,9298,0,3,13),(571,9304,0,3,13),(572,11494,0,3,8),(574,10775,0,3,0),(575,10825,0,3,8),(576,9832,0,3,10),(577,8085,0,3,0),(579,10766,0,3,1),(580,99,0,3,0),(581,9900,0,3,11),(582,9088,1,3,13),(583,1884,0,3,6),(584,9402,0,3,19),(585,9621,0,3,4),(586,9039,0,3,17),(587,10824,0,3,0),(588,8344,0,3,13),(589,10580,0,3,2),(590,8448,0,3,13),(591,8147,0,3,16),(592,9752,0,3,12),(593,8152,0,3,16),(594,10288,0,3,5),(595,9753,1,3,12),(596,9264,0,3,16),(597,10895,0,3,4),(598,10290,0,3,7),(599,9432,0,3,12),(600,9902,0,3,0),(601,10519,1,3,8),(602,10339,1,3,9),(603,8143,0,3,3),(604,6443,0,3,0),(605,10771,0,3,6),(606,10797,0,3,8),(607,9405,0,3,20),(608,11713,0,3,0),(609,11714,0,3,0),(610,7758,0,3,22),(611,10592,0,3,7),(612,12060,0,3,1),(613,9044,0,3,20),(614,6613,0,3,13),(615,7611,0,3,16),(616,9142,0,3,0),(617,1896,0,3,0),(618,8371,0,3,15),(619,10585,0,3,0),(620,9302,0,3,10),(621,10500,0,3,1),(622,9842,0,3,8),(623,1971,0,3,27),(624,6931,0,3,0),(625,10183,0,3,11),(626,7544,0,3,27),(627,9034,0,3,0),(628,10776,0,3,10),(629,9482,0,3,0),(630,10050,0,3,0),(631,10049,0,3,0),(632,10367,0,3,8),(633,9472,3,3,9),(634,4453,0,3,0),(635,10285,0,3,6),(636,8370,0,3,0),(637,10184,0,3,9),(638,9234,0,3,0),(639,6695,0,3,0),(640,10817,0,3,9),(641,8852,0,3,15),(642,10509,0,3,0),(643,6114,0,3,26),(644,6762,0,3,0),(645,9629,0,3,0),(646,10877,0,3,0),(647,6530,0,3,0),(648,8065,0,3,19),(649,8705,0,3,2),(650,9997,0,3,10),(651,10048,0,3,32),(652,7100,0,3,3),(653,9650,0,3,0),(654,6186,0,3,27),(655,1193,0,3,0),(656,8305,0,3,0),(657,7161,0,3,28),(658,10565,0,3,0),(659,8136,0,3,0),(660,12075,2,3,4),(661,12093,0,3,5),(662,11088,0,3,2),(663,8219,0,3,0),(664,7187,0,3,20),(665,10896,2,3,4),(666,10739,1,3,7),(667,9704,0,3,0),(668,11198,0,3,0),(669,11339,1,3,6),(670,10925,0,3,8),(671,7709,0,3,0),(672,10515,0,3,0),(673,11485,0,3,9),(674,8793,0,3,14),(676,10472,0,3,3),(677,6027,0,3,28),(678,8190,0,3,0),(679,7317,0,3,4),(680,10706,0,3,0),(681,9580,0,3,0),(682,10582,0,3,0),(683,9317,0,3,0),(684,10774,2,3,4),(685,9273,0,3,0),(686,12059,0,3,0),(687,9548,0,3,0),(688,9224,0,3,0),(689,10604,0,3,0),(690,6310,0,3,0),(691,11301,3,3,3),(692,8213,0,3,1),(693,11519,0,3,4),(694,9726,0,3,8),(695,10897,0,3,3),(696,11484,0,3,3),(697,11500,0,3,0),(698,10738,0,3,9),(699,8416,0,3,0),(700,10788,0,3,6),(701,9296,0,3,14),(702,9708,1,3,12),(703,9748,0,3,9),(704,7537,0,3,20),(705,12066,0,3,0),(706,10755,0,3,6),(707,11181,0,3,1),(708,10262,1,3,8),(709,12211,0,3,5),(710,6664,0,3,0),(711,11486,0,3,7),(712,10902,1,3,7),(716,70,0,3,4),(717,11418,3,3,2),(718,9825,0,3,0),(719,8256,0,3,0),(720,10673,0,3,0),(721,11113,1,3,11),(722,10827,0,3,5),(723,8125,0,3,15),(724,7780,0,3,0),(725,8821,0,3,13),(726,9754,0,3,15),(727,806,0,3,0),(728,7151,0,3,0),(729,12257,1,3,9),(730,12074,0,3,5),(731,6181,0,3,0),(732,10835,0,3,5),(733,10610,2,3,4),(734,10919,0,3,6),(735,12201,0,3,2),(736,11146,1,3,5),(737,8140,0,3,15),(738,1283,0,3,33),(739,10144,0,3,5),(740,4768,0,3,5),(741,10338,0,3,0),(742,10918,1,3,8),(743,9723,1,3,22),(744,10850,0,3,0),(745,8342,0,3,6),(746,10851,0,3,0),(747,10244,0,3,0),(748,9571,0,3,0),(749,8902,0,3,17),(750,9440,0,3,2),(751,10029,0,3,6),(752,9996,1,3,3),(753,9442,1,3,10),(754,11064,1,3,10),(755,10001,0,3,1),(756,9995,0,3,2),(757,10913,0,3,0),(758,10900,0,3,4),(759,10773,0,3,6),(760,10321,0,3,9),(761,9719,1,3,15),(762,8531,0,3,9),(763,9673,0,3,0),(764,12206,0,3,0),(765,12205,1,3,4),(766,11712,0,3,6),(767,11333,0,3,7),(768,6479,0,3,0),(769,10476,0,3,19),(770,7064,0,3,0),(771,7486,0,3,0),(772,10777,1,3,9),(773,10785,0,3,0),(774,10799,0,3,0),(775,10008,0,3,0),(776,9374,0,3,0),(777,10619,0,3,0),(778,11717,1,3,6),(779,10287,1,3,6),(780,11403,0,3,7),(781,6550,1,3,21),(782,11253,0,3,0),(783,6515,1,3,22),(784,10537,0,3,2),(785,9604,0,3,8),(786,9743,0,3,5),(787,9907,0,3,0),(788,12172,0,3,2),(789,10764,0,3,0),(790,10954,0,3,0),(791,10318,0,3,0),(792,12159,0,3,0),(793,8750,0,3,0),(794,6563,0,3,25),(795,11419,0,3,5),(796,11413,0,3,5),(797,10713,1,3,11),(798,11204,2,3,5),(799,11023,0,3,7),(800,11049,0,3,6),(801,11483,0,3,1),(802,11048,0,3,3),(803,12270,0,3,5),(804,10899,0,3,6),(805,8424,0,3,3),(806,12131,0,3,1),(807,9783,1,3,5),(808,12377,0,3,5),(809,10056,0,3,13),(810,12124,0,3,0),(811,12130,0,3,2),(812,10717,0,3,12),(813,11815,1,3,6),(814,11188,0,3,2),(815,11488,0,3,5),(816,9760,0,3,8),(817,10533,3,3,7),(818,9905,0,3,6),(819,10762,0,3,3),(820,9574,0,3,9),(821,10221,0,3,11),(822,9372,0,3,0),(823,11172,0,3,2),(824,10162,0,3,8),(825,10173,0,3,0),(826,10887,0,3,9),(827,7284,0,3,7),(828,11101,0,3,5),(829,0,0,3,0),(830,6787,0,3,0),(831,10971,0,3,10),(832,10141,0,3,8),(833,12328,1,3,2),(834,8459,0,3,4),(835,10511,3,3,8),(836,8492,0,3,6),(837,10786,0,3,5),(838,8527,0,3,9),(839,11395,0,3,3),(840,11803,0,3,5),(841,11814,0,3,3),(842,12371,0,3,3),(843,10475,0,3,4),(844,11924,0,3,0),(845,12077,0,3,4),(846,10507,0,3,10),(847,7979,1,3,20),(848,9954,0,3,1),(849,10770,0,3,1),(850,11170,0,3,3),(851,10945,0,3,6),(852,12674,0,3,2),(853,10445,0,3,4),(854,6696,0,3,27),(855,12700,0,3,2),(856,9757,0,3,7),(857,11553,0,3,8),(858,12327,0,3,1),(859,7786,0,3,20),(860,7773,0,3,26),(861,11846,0,3,3),(862,11655,0,3,0),(863,11845,0,3,3),(864,12287,0,3,4),(865,12595,0,3,3),(866,9005,0,3,27),(867,11843,0,3,0),(868,12540,1,3,3),(869,12535,0,3,5),(870,12376,0,3,5),(871,12148,0,3,4),(872,11742,0,3,2),(873,11715,0,3,0),(874,11470,0,3,0);

--
-- Table structure for table `public_holidays`
--

CREATE TABLE `public_holidays` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_holiday` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `public_holidays_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `public_holidays`
--

INSERT INTO `public_holidays` VALUES (33,'Youth day','03-12','Youth day',20,20,NULL,NULL);

--
-- Table structure for table `requisitions`
--

CREATE TABLE `requisitions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `position` int unsigned DEFAULT NULL,
  `unit` int unsigned DEFAULT NULL,
  `department` int unsigned DEFAULT NULL,
  `reason` text COLLATE utf8mb4_general_ci,
  `user` int unsigned NOT NULL,
  `variance` int unsigned DEFAULT NULL,
  `type` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `salary_scale_id` int unsigned DEFAULT NULL,
  `position_status` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `created_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` int unsigned DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `position` (`position`),
  KEY `Fk_user_id` (`user`),
  KEY `fk_salary_scale` (`salary_scale_id`),
  KEY `fk_unit` (`unit`),
  KEY `fk_departments` (`department`),
  KEY `fk_employee_requisition_applications_1_idx` (`created_by`),
  KEY `fk_employee_requisition_applications_2_idx` (`updated_by`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `requisitions`
--

INSERT INTO `requisitions` VALUES (49,69,1,2,'Need for more developers ',1239,3,'full time','2024-01-16',38,'External candidate',3,1239,'2024-01-04 14:55:41',29,'2024-03-24 10:53:44'),(67,229,1,130,'need for more',1239,2,'full time','2024-04-01',NULL,'Both internal and external candidate',2,1239,'2024-03-24 08:16:17',29,'2024-03-24 09:51:39'),(68,323,1,123,'Need for training managers ',1239,12,'full time','2024-03-06',NULL,'Both internal and external candidate',1,1239,'2024-03-24 11:12:18',29,'2024-03-25 07:22:51'),(72,299,1,1,'Developer ',1239,2,'full time','2024-03-28',NULL,'Internal candidate',0,1239,'2024-03-24 14:04:44',1239,'2024-03-24 14:04:44'),(73,69,1,1,'Software developers to fill the vacant positions',86,2,'full time','2024-03-14',NULL,'Both internal and external candidate',0,86,'2024-03-25 08:00:17',86,'2024-03-25 08:00:17');

--
-- Table structure for table `right_to_role`
--

CREATE TABLE `right_to_role` (
  `id` int NOT NULL AUTO_INCREMENT,
  `role` int unsigned NOT NULL,
  `right` text COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_right_to_role_1_idx` (`role`),
  CONSTRAINT `fk_right_to_role_1` FOREIGN KEY (`role`) REFERENCES `roles` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2509 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `right_to_role`
--

INSERT INTO `right_to_role` VALUES (187,10,'Manage Department Workplan'),(188,10,'Manage Individual Workplan'),(189,10,'Manage Target Agreed Score'),(190,10,'Manage Target Appraise Score'),(191,10,'Manage Target Appraiser Score'),(853,12,'Is clinic physician'),(1798,9,'Manage retirement applications'),(1799,9,'Manage Target Appraise Score'),(1800,9,'View Departments'),(1801,9,'View public holidays'),(1802,9,'View salary scale notches'),(1803,9,'View Salary Scales'),(1804,9,'View staff salary increments'),(1805,9,'View Units'),(2338,14,'Manage disciplinary'),(2339,14,'View disciplinary'),(2343,16,'Manage disciplinary'),(2344,16,'Manage disciplinary case'),(2345,16,'View disciplinary'),(2346,17,'Manage disciplinary case'),(2347,15,'Manage disciplinary'),(2348,15,'Manage disciplinary case'),(2349,15,'View disciplinary'),(2360,13,'Manage disciplinary case'),(2361,13,'View disciplinary case'),(2362,11,'Manage Department Workplan'),(2363,11,'Manage establishment'),(2364,11,'Manage Head of Unit Comment'),(2365,11,'Manage requisitions'),(2366,11,'Manage Target Agreed Score'),(2367,11,'Manage Target Appraise Score'),(2368,11,'Manage Target Appraiser Score'),(2369,11,'Manage training needs'),(2370,11,'View approval requests'),(2371,11,'View countries'),(2372,11,'View establishment'),(2373,11,'View job positions'),(2374,11,'View public holidays'),(2375,11,'View requisitions'),(2376,11,'View salary scale notches'),(2377,11,'View Salary Scales'),(2378,11,'View training needs'),(2379,11,'View Units'),(2380,18,'Manage disciplinary'),(2381,18,'Manage disciplinary case'),(2382,18,'View disciplinary'),(2383,18,'View disciplinary case'),(2384,18,'View job positions'),(2385,18,'View reports'),(2386,18,'View Units'),(2387,18,'View Users'),(2388,4,'Approve Department work plan'),(2389,4,'Approve terminal benefits computations'),(2390,4,'Assign acting positions'),(2391,4,'Create department work plan'),(2392,4,'Is clinic physician'),(2393,4,'Is Department Head'),(2394,4,'Is Supervisor'),(2395,4,'Is Unit Head'),(2396,4,'Manage administrative forms'),(2397,4,'Manage Appraisal Periods'),(2398,4,'Manage approval requests'),(2399,4,'Manage communication history'),(2400,4,'manage competency'),(2401,4,'Manage contract application'),(2402,4,'Manage contract types'),(2403,4,'Manage countries'),(2404,4,'Manage Department Workplan'),(2405,4,'Manage Departments'),(2406,4,'Manage disciplinary'),(2407,4,'Manage disciplinary case'),(2408,4,'Manage distributed documents'),(2409,4,'Manage employee employment details'),(2410,4,'Manage employee leave'),(2411,4,'Manage Employees'),(2412,4,'Manage establishment'),(2413,4,'manage final appraisal comment'),(2414,4,'Manage fixed term contract'),(2415,4,'Manage Head of Unit Comment'),(2416,4,'Manage Individual Workplan'),(2417,4,'Manage job offer'),(2418,4,'Manage job openings'),(2419,4,'Manage job positions'),(2420,4,'Manage Jobs'),(2421,4,'Manage KRAs'),(2422,4,'Manage leave types'),(2423,4,'Manage long term training applications'),(2424,4,'Manage mailing lists'),(2425,4,'Manage Overall Appraisals'),(2426,4,'Manage Overall Work-plans'),(2427,4,'Manage pam bank branches'),(2428,4,'Manage pam banks'),(2429,4,'Manage PAs'),(2430,4,'Manage provinces and districts'),(2431,4,'Manage public holidays'),(2432,4,'Manage reminders'),(2433,4,'Manage reports'),(2434,4,'Manage requisitions'),(2435,4,'Manage retirement applications'),(2436,4,'Manage retirement notices'),(2437,4,'Manage Roles'),(2438,4,'Manage Salary Scale'),(2439,4,'Manage salary scale notches'),(2440,4,'Manage Salary Scales'),(2441,4,'Manage short term training'),(2442,4,'Manage Staff Categories'),(2443,4,'Manage staff salary increments'),(2444,4,'Manage strategic Objective'),(2445,4,'Manage strategic period'),(2446,4,'Manage Target Agreed Score'),(2447,4,'Manage Target Appraise Score'),(2448,4,'Manage Target Appraiser Score'),(2449,4,'Manage terminal benefits advance payments'),(2450,4,'Manage terminal benefits clearance forms'),(2451,4,'Manage terminal benefits collective agreements'),(2452,4,'Manage terminal benefits computations'),(2453,4,'Manage terminal benefits deductions'),(2454,4,'Manage terminal benefits earnings'),(2455,4,'Manage terminal benefits final payments'),(2456,4,'Manage training'),(2457,4,'Manage training needs'),(2458,4,'Manage training needs SDF'),(2459,4,'Manage Units'),(2460,4,'Manage Users'),(2461,4,'Review departmental work-plan'),(2462,4,'View administrative forms'),(2463,4,'View approval requests'),(2464,4,'View communication history'),(2465,4,'View contract application'),(2466,4,'View contract types'),(2467,4,'View countries'),(2468,4,'View department work plan'),(2469,4,'View Departments'),(2470,4,'View disciplinary'),(2471,4,'View distributed documents'),(2472,4,'View establishment'),(2473,4,'View fixed term contract'),(2474,4,'View job offer'),(2475,4,'View job openings'),(2476,4,'View job positions'),(2477,4,'View KRAs'),(2478,4,'View leave types'),(2479,4,'View mailing lists'),(2480,4,'View pam bank branches'),(2481,4,'View pam banks'),(2482,4,'View PAs'),(2483,4,'View provinces and districts'),(2484,4,'View public holidays'),(2485,4,'View reminders'),(2486,4,'View reports'),(2487,4,'View requisitions'),(2488,4,'View retirement applications'),(2489,4,'View retirement notices'),(2490,4,'View Roles'),(2491,4,'View salary scale notches'),(2492,4,'View Salary Scales'),(2493,4,'View Staff Categories'),(2494,4,'View staff salary increments'),(2495,4,'View strategic objective'),(2496,4,'View terminal benefits advance payments'),(2497,4,'View terminal benefits clearance forms'),(2498,4,'View terminal benefits collective agreements'),(2499,4,'View terminal benefits computations'),(2500,4,'View terminal benefits deductions'),(2501,4,'View terminal benefits earnings'),(2502,4,'View terminal benefits final payments'),(2503,4,'View terminal benefits statements'),(2504,4,'View terminal benefits tax tables'),(2505,4,'View training'),(2506,4,'View training needs'),(2507,4,'View Units'),(2508,4,'View Users');

--
-- Table structure for table `rights`
--

CREATE TABLE `rights` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `right` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `system_rights` (`right`)
) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rights`
--

INSERT INTO `rights` VALUES (136,'Approve Department work plan'),(118,'Approve terminal benefits computations'),(79,'Assign acting positions'),(134,'Create department work plan'),(80,'Is clinic physician'),(45,'Is Department Head'),(43,'Is Supervisor'),(44,'Is Unit Head'),(99,'Manage administrative forms'),(11,'Manage Appraisal Periods'),(62,'Manage approval requests'),(125,'Manage communication history'),(18,'manage competency'),(74,'Manage contract application'),(60,'Manage contract types'),(27,'Manage countries'),(13,'Manage Department Workplan'),(8,'Manage Departments'),(137,'Manage disciplinary'),(141,'Manage disciplinary case'),(127,'Manage distributed documents'),(61,'Manage employee employment details'),(64,'Manage employee leave'),(6,'Manage Employees'),(72,'Manage establishment'),(24,'manage final appraisal comment'),(84,'Manage fixed term contract'),(23,'Manage Head of Unit Comment'),(12,'Manage Individual Workplan'),(69,'Manage job offer'),(65,'Manage job openings'),(41,'Manage job positions'),(5,'Manage Jobs'),(10,'Manage KRAs'),(35,'Manage leave types'),(140,'Manage long term training applications'),(123,'Manage mailing lists'),(47,'Manage Overall Appraisals'),(46,'Manage Overall Work-plans'),(78,'Manage pam bank branches'),(76,'Manage pam banks'),(14,'Manage PAs'),(26,'Manage provinces and districts'),(40,'Manage public holidays'),(129,'Manage reminders'),(81,'Manage reports'),(68,'Manage requisitions'),(105,'Manage retirement applications'),(103,'Manage retirement notices'),(3,'Manage Roles'),(9,'Manage Salary Scale'),(37,'Manage salary scale notches'),(31,'Manage Salary Scales'),(143,'Manage short term training'),(29,'Manage Staff Categories'),(57,'Manage staff salary increments'),(132,'Manage strategic Objective'),(131,'Manage strategic period'),(22,'Manage Target Agreed Score'),(20,'Manage Target Appraise Score'),(21,'Manage Target Appraiser Score'),(112,'Manage terminal benefits advance payments'),(100,'Manage terminal benefits clearance forms'),(119,'Manage terminal benefits collective agreements'),(110,'Manage terminal benefits computations'),(108,'Manage terminal benefits deductions'),(106,'Manage terminal benefits earnings'),(116,'Manage terminal benefits final payments'),(93,'Manage training'),(97,'Manage training needs'),(139,'Manage training needs SDF'),(7,'Manage Units'),(1,'Manage Users'),(122,'Review departmental work-plan'),(121,'View administrative forms'),(63,'View approval requests'),(126,'View communication history'),(73,'View contract application'),(59,'View contract types'),(28,'View countries'),(135,'View department work plan'),(34,'View Departments'),(138,'View disciplinary'),(142,'View disciplinary case'),(128,'View distributed documents'),(71,'View establishment'),(83,'View fixed term contract'),(70,'View job offer'),(66,'View job openings'),(42,'View job positions'),(48,'View KRAs'),(36,'View leave types'),(124,'View mailing lists'),(77,'View pam bank branches'),(75,'View pam banks'),(15,'View PAs'),(25,'View provinces and districts'),(39,'View public holidays'),(130,'View reminders'),(82,'View reports'),(67,'View requisitions'),(104,'View retirement applications'),(102,'View retirement notices'),(4,'View Roles'),(38,'View salary scale notches'),(32,'View Salary Scales'),(30,'View Staff Categories'),(58,'View staff salary increments'),(133,'View strategic objective'),(113,'View terminal benefits advance payments'),(101,'View terminal benefits clearance forms'),(120,'View terminal benefits collective agreements'),(111,'View terminal benefits computations'),(109,'View terminal benefits deductions'),(107,'View terminal benefits earnings'),(115,'View terminal benefits final payments'),(114,'View terminal benefits statements'),(117,'View terminal benefits tax tables'),(94,'View training'),(98,'View training needs'),(33,'View Units'),(2,'View Users');

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `role` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_role_name` (`role`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (4,'Admin','2021-10-25 22:13:25','2024-05-08 16:47:47',20,20),(9,'Employee','2021-11-17 13:24:25','2023-09-11 12:53:39',24,20),(10,'Supervisor','2021-11-17 13:26:32','2022-02-25 14:42:32',24,20),(11,'Head of Unit','2021-12-14 09:01:48','2024-04-23 10:47:59',20,20),(12,'Physician','2024-02-12 16:41:22','2024-02-12 18:41:22',20,20),(13,'Assistant Registrar','2024-04-23 06:55:09','2024-04-23 10:31:24',29,20),(14,'Administrative Assistant to the Vice-Chancellor','2024-04-23 06:55:51','2024-04-23 08:55:51',29,29),(15,'Industrial Relations Officer','2024-04-23 06:56:34','2024-04-23 09:34:47',29,29),(16,'Senior Administrative Officer','2024-04-23 06:57:12','2024-04-23 08:57:12',29,29),(17,'Administrative Officer','2024-04-23 06:58:44','2024-04-23 08:58:44',29,29),(18,'Assistant Registrar - Administration','2024-04-23 07:35:53','2024-04-23 10:56:55',29,20);

--
-- Table structure for table `salary_increment_records`
--

CREATE TABLE `salary_increment_records` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `notch` int unsigned NOT NULL,
  `year` int NOT NULL,
  `percentage` double DEFAULT NULL,
  `old_basic` double DEFAULT NULL,
  `new_basic` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_salary_increment_records_1_idx` (`notch`),
  CONSTRAINT `fk_salary_increment_records_1` FOREIGN KEY (`notch`) REFERENCES `salary_scale_notches` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salary_increment_records`
--

INSERT INTO `salary_increment_records` VALUES (4,1,2023,6,21600,22896,'2023-09-14 13:53:27','2023-09-14 13:53:27',20,NULL),(5,4,2023,6,24840,26330.4,'2023-09-14 13:53:27','2023-09-14 13:53:27',20,NULL),(6,5,2023,6,25920,27475.2,'2023-09-14 13:53:27','2023-09-14 13:53:27',20,NULL),(7,6,2024,10,19000,20900,'2024-02-25 11:30:13','2024-02-25 11:30:13',20,NULL);

--
-- Table structure for table `salary_scale_notches`
--

CREATE TABLE `salary_scale_notches` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `salary_scale` int unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `basic_pay` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `notch_order` int NOT NULL DEFAULT '1',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `salarnotches_salaryscales_fk_idx` (`salary_scale`),
  KEY `salarynotches_createdby_fk_idx` (`created_by`),
  KEY `salarynotches_updatedby_fk_idx` (`updated_by`),
  CONSTRAINT `salarnotches_salaryscales_fk` FOREIGN KEY (`salary_scale`) REFERENCES `salary_scales` (`id`),
  CONSTRAINT `salarynotches_createdby_fk` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `salarynotches_updatedby_fk` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salary_scale_notches`
--

INSERT INTO `salary_scale_notches` VALUES (1,7,'Notch one','VzcErRC/HaitmeqkH9nwVGE2ZTNmYjVlNzY4N2JhOGFlZmEyYzE3NjI2MzgxNzkxNTk2MzAyYzUwZTg5ODNiMGFjM2M3NTBlNWQwZjQzZjCyQwAGdtzSTbc6WEcgYW4xo8E5vNgmdxKF205ghi3gIg==',1,'Notch one description',20,20,'2023-08-31 18:10:16','2023-09-14 15:53:27'),(4,7,'Notch two','QSJTLEmbNEwZ7XSzvyljeTNiNjYyMzZkMzkyNjk4NGNlNWY1ZWEyOWU0YWMyNzViMjFjYmQzZjAyMjZjYTMyMmUyYmUyMDAyMmFhM2M4NjjhXa4fu7kRF8warS6J82ACEfgfVvG1E5Lm9F1QWFvqUw==',2,'',20,20,'2023-09-01 07:57:09','2023-09-14 15:53:27'),(5,7,'Notch three','17nKBvwVjSvFdMT372FcfTg3ZWY5NzgwNGNmNjU0YzI3NGM0MTBiMTQ0YmRmY2JkOGFkZGUxNmUzZDc2MjY4YTUzMGE3NjkyMjllN2Y5OGYxsoFJz8u85yceqo+JYRLn/YIoIzoYKJA8pUD7osTkrw==',3,'',20,20,'2023-09-01 07:57:43','2023-09-14 15:53:27'),(6,2,'Notch one','i+y+3uVk1bOYNlrQX0VjhzcwYjcwZDdmNWVjNmI2OWIwYmQ0OGE4ZTE2ZDY0ZDcyNmJiYTU1YTI1ZjQ4NGU4YTczM2ViOWM0YmM4YjAxZTkp1A4m8ty3VrpLDu+s8AOq1qLf0Y6ksZhfTslovxyLew==',1,'',20,20,'2023-09-10 15:04:30','2024-02-25 13:30:13'),(7,1,'Notch one','Bd+g2CPpaCWVVrBfH3gQYGEyNWFiZDIwNzJjMjM3ZDRjYTFkZmViNjg5MjRiZGJlOWNiYjFmMGM1NDc3YzgwMTA2Y2U0MGE2MDJmNDM0Y2URc0fhBrw2vRf5D0FTG8mc3Q3NfXK97NkmkaecX11SEw==',1,'',20,20,'2023-11-01 12:15:22','2023-11-01 12:15:22'),(8,35,'Notch one','N6ySYvKZ2yguJ0LsShXOBTA0YzYyZjRmNmY2MmE4YjUwMWI3MDFmNDcxMjViZGU2NmE5NmI4YzY0NDhlNzBlNGY3ZDQ1ZGRiYTEwNTM1MTePbIg7ycszeLaPVk6kb0SDuo11Ymet4Srnd3ZqnjdTlw==',1,'',20,20,'2023-11-01 12:20:37','2023-11-01 12:20:37'),(9,9,'Notch one','H6toG9EemHvBOfS2UOfVYDZmYjE4YmI3MzNmNjFjMGE5YWM3NTBhOTE5NTQ3N2RhZjIzMTA5NmE1MzE4NWRiMjljOTY4OGVkNjJjZTY2OWIcIaikwz3hos3erwS9zMRrMcincdL1AgtIA9uTuNnniQ==',1,'',20,20,'2023-11-01 12:24:07','2023-11-01 12:24:07'),(10,41,'Notch one','Y4dW1gBNvuz8RQKbipEFIWJlOWUwOGU1MmM0YzE0ZTJiZDVkOGNkMjc3OWU1Yzg2OWUxODNiMWVjMDI0YzJjYTE4MTU5ZTdkMzExYTUwZDkqgNZEwA3vBjHFVacZCPVIKW5jcrGEnf0wSmZqeLGzow==',1,'',20,20,'2024-02-12 19:18:45','2024-02-12 19:18:45'),(11,30,'01','FVQt0wGz2Ijm5jFDHDHIejBiOGRmY2I0ZmFmZGZkYWU2MzgwMWNjMjJiN2YxN2M3MjFhN2RmM2Y5Mjk1YmY0ZDMyZDI5NTg4YzBjMWNhNmXaflpGfYLMJmU97EPQq5i9Bp5IKjcVq10U1g5HWYqxvw==',1,'MMS01',20,20,'2024-03-25 09:44:28','2024-03-25 09:44:28'),(12,5,'AC 03','2q4Wo/9ehXWB2YXpYtdAG2FiNWE3ZjA4YTZkNGYwMGRlMWQ4NjM2ODA0NDNiYjNjNjg1ODRlODZiZWY5ZTYyOWFlMjM1NTIyMTVmY2YzZDXtHq6r4r2zcq7OQK1OMcCh2icmJAIVz+Yp+9OmH8z5ig==',1,'Academic notch',20,20,'2024-03-26 10:20:34','2024-03-26 10:20:34');

--
-- Table structure for table `salary_scales`
--

CREATE TABLE `salary_scales` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(10) NOT NULL,
  `staff_category` int unsigned NOT NULL,
  `status` tinyint DEFAULT '1',
  `description` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sc_description` (`code`),
  KEY `code` (`code`),
  KEY `salaryscale_category_fk` (`staff_category`),
  KEY `salaryscale_user_updatedby_fk_idx` (`updated_by`),
  KEY `salaryscale_user_createdby_fk_idx` (`created_by`),
  CONSTRAINT `salaryscale_category_fk` FOREIGN KEY (`staff_category`) REFERENCES `staff_categories` (`id`),
  CONSTRAINT `salaryscale_user_createdby_fk` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `salaryscale_user_updatedby_fk` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `salary_scales`
--

INSERT INTO `salary_scales` VALUES (1,'ACS06',1,1,'ACS06','2021-10-28 13:56:21','2021-10-28 15:56:21',20,20),(2,'PTS 04',2,1,'description','2021-11-17 14:11:17','2023-08-31 16:36:00',20,20),(3,'PTS 03',2,1,'PTS 03 salary scale','2021-11-17 14:13:10','2024-02-27 10:38:15',20,20),(4,'ACS02',1,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(5,'ACS03',1,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(6,'ACS04',1,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(7,'ACS05',1,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(8,'UNKNOWN',3,1,'UNKNOWN',NULL,'2021-12-09 16:48:44',NULL,NULL),(9,'ADS03',2,1,'Description',NULL,'2023-08-31 12:26:29',NULL,20),(10,'ADS04',2,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(11,'ADS05',2,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(12,'ADS06',2,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(13,'ADS07',2,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(14,'ADS08',2,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(15,'ADS09',2,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(16,'ADS10',2,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(17,'ADS11',2,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(18,'ADS12',2,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(19,'ADS13',2,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(20,'ADS14',2,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(21,'ADS15',2,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(22,'CW01',3,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(23,'CW02',3,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(24,'CW04',3,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(25,'CW05',3,1,NULL,NULL,'2021-12-09 14:55:31',NULL,NULL),(26,'CWS01',3,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(27,'CWS02',3,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(28,'CWS03',3,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(29,'DWS01',3,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(30,'MMS01',3,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(31,'MMS02',3,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(32,'PLS01',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(33,'PLS02',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(34,'PLS03',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(35,'PO',3,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(36,'PSL01',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(37,'PSS03',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(38,'PSS04',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(39,'PSS05',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(41,'PTS05',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(42,'PTS06',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(43,'PTS07',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(44,'PTS08',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(45,'PTS09',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(46,'PTS10',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(47,'PTS11',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(48,'PTS12',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(49,'PTS13',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(50,'PTS14',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(51,'PTS15',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(52,'SDS01',3,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(53,'SDS03',3,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(54,'SES01',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(55,'SES02',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(56,'SES03',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(57,'SES04',2,1,NULL,NULL,'2021-12-09 14:55:32',NULL,NULL),(65,'ACS01',1,1,NULL,NULL,'2021-12-09 16:29:05',NULL,NULL);

--
-- Table structure for table `section`
--

CREATE TABLE `section` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `department` int unsigned NOT NULL,
  `name` varchar(100) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_section_1_idx` (`department`),
  CONSTRAINT `fk_section_1` FOREIGN KEY (`department`) REFERENCES `departments` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `section`
--

INSERT INTO `section` VALUES (3,124,'section 1','2024-05-07 15:06:10','2024-05-07 15:06:10',20,20);

--
-- Table structure for table `staff_categories`
--

CREATE TABLE `staff_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_general_ci NOT NULL,
  `acting_min_payable_days` int NOT NULL COMMENT 'Minimum days required for someone acting to be payed the additional or acting allowance',
  `current_salary_increment` double DEFAULT '0' COMMENT 'Salary increment',
  `annual_monthly_leave_days_accumulated` double NOT NULL DEFAULT '0' COMMENT 'total days each staff category can accumulate for an annual leave',
  `has_accrued_leave_days_ceiling` enum('Yes','No') COLLATE utf8mb4_general_ci DEFAULT 'Yes',
  `accrued_leave_days_ceiling` varchar(100) COLLATE utf8mb4_general_ci DEFAULT '0.0',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime NOT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `staffcat_user_createdby_fk_idx` (`created_by`),
  KEY `staffcat_user_updatedby_fk_idx` (`updated_by`),
  CONSTRAINT `staffcat_user_createdby_fk` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `staffcat_user_updatedby_fk` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `staff_categories`
--

INSERT INTO `staff_categories` VALUES (1,'Academic',14,0,3.5,'Yes','78.75','2023-08-23 16:55:33','2023-10-26 15:26:39',20,20),(2,'Non-Academic',10,0,3,'Yes','90','2023-08-23 16:55:33','2023-10-26 15:26:19',20,20),(3,'Management',10,0,3.5,'No','0.0','2023-08-23 16:56:21','2023-10-26 15:25:54',20,20),(8,'Principle office',10,0,3.5,'Yes','88','2023-10-26 15:28:09','2023-10-26 15:28:09',20,20);

--
-- Table structure for table `staff_salary_increments`
--

CREATE TABLE `staff_salary_increments` (
  `id` int NOT NULL AUTO_INCREMENT,
  `staff_category` int unsigned NOT NULL,
  `salary_scale` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `increment` int NOT NULL,
  `year` int NOT NULL,
  `collective_agreement` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('Applied','Not Applied') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `salary_increments_staffcat_fk_idx` (`staff_category`),
  KEY `salary_increments_createdby_fk_idx` (`created_by`),
  CONSTRAINT `salary_increments_createdby_fk` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `salary_increments_staffcat_fk` FOREIGN KEY (`staff_category`) REFERENCES `staff_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `staff_salary_increments`
--

INSERT INTO `staff_salary_increments` VALUES (3,1,NULL,6,2023,'collective_agreement_Academic_2023.pdf','Applied',NULL,NULL,20),(4,2,'2',10,2024,'collective_agreement_Non-Academic_2024.pdf','Applied',NULL,NULL,20);

--
-- Table structure for table `strategic_objective`
--

CREATE TABLE `strategic_objective` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `strategic_period_id` int unsigned NOT NULL,
  `strategic_objective` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `strategic_objective_strategic_period_fk` (`strategic_period_id`),
  KEY `strategic_object_user_created_by_user_id_fk` (`created_by`),
  KEY `strategic_objective_user_updated_by_id_fk` (`updated_by`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `strategic_objective`
--

INSERT INTO `strategic_objective` VALUES (1,1,'Enhancement of Technology','2023-11-24 10:09:49','2023-11-24 12:09:49',20,20),(2,1,'Enhancement of Security ','2023-11-24 10:13:30','2023-11-24 12:13:30',20,20),(3,1,'Enhance Intellectual wealth','2023-11-27 10:12:07','2023-11-27 12:12:07',20,20),(4,5,'Enhance Intellectual wealth','2023-11-27 13:09:07','2023-11-27 15:09:07',20,20);

--
-- Table structure for table `strategic_period`
--

CREATE TABLE `strategic_period` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) COLLATE utf8mb4_general_ci NOT NULL,
  `start` year NOT NULL,
  `end` year NOT NULL,
  `duration` varchar(10) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `strategic_period_updated_by_user_idfk` (`updated_by`),
  KEY `sp_created_by_user_id_fk` (`created_by`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `strategic_period`
--

INSERT INTO `strategic_period` VALUES (1,'strategic period',2018,2022,NULL,'2023-11-24 04:37:30','2023-11-24 06:37:30',20,20),(4,'strategic period 1',2012,2017,NULL,'2023-11-27 11:12:09','2023-11-27 13:12:09',20,20),(5,'strategic period 2',2023,2027,NULL,'2023-11-27 13:05:42','2023-11-27 15:05:42',20,20);

--
-- Table structure for table `strategic_period_year`
--

CREATE TABLE `strategic_period_year` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `strategic_period_id` int unsigned NOT NULL,
  `period_year` year NOT NULL,
  PRIMARY KEY (`id`),
  KEY `spy_id` (`strategic_period_id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `strategic_period_year`
--

INSERT INTO `strategic_period_year` VALUES (1,1,2018),(2,1,2019),(3,1,2020),(4,1,2021),(5,1,2022),(8,4,2012),(9,4,2013),(10,4,2014),(11,4,2015),(12,4,2016),(13,4,2017),(14,5,2023),(15,5,2024),(16,5,2025),(17,5,2026),(18,5,2027);

--
-- Table structure for table `tbm_advance_payments`
--

CREATE TABLE `tbm_advance_payments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `computation_id` int unsigned NOT NULL,
  `deduction_id` int unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `units` decimal(20,2) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_advance_payments_users_FK` (`created_by`),
  KEY `tbm_advance_payments_users_FK_1` (`updated_by`),
  KEY `tbm_advance_payments_tbm_computations_FK` (`computation_id`),
  KEY `tbm_advance_payments_tbm_deduction_defs_FK` (`deduction_id`),
  CONSTRAINT `tbm_advance_payments_tbm_computations_FK` FOREIGN KEY (`computation_id`) REFERENCES `tbm_computations` (`id`),
  CONSTRAINT `tbm_advance_payments_tbm_deduction_defs_FK` FOREIGN KEY (`deduction_id`) REFERENCES `tbm_deduction_defs` (`id`),
  CONSTRAINT `tbm_advance_payments_users_FK` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_advance_payments_users_FK_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbm_advance_payments`
--

INSERT INTO `tbm_advance_payments` VALUES (34,131,7,'Advance payment',50000.00,29,29,'2024-04-25 15:50:49','2024-04-25 15:50:49',NULL,'APPROVED','221511');

--
-- Table structure for table `tbm_clearance_form_units`
--

CREATE TABLE `tbm_clearance_form_units` (
  `id` int NOT NULL AUTO_INCREMENT,
  `clearance_form_d` int unsigned NOT NULL,
  `comment` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_tbm_clearance_form_units_1_idx` (`created_by`),
  KEY `fk_tbm_clearance_form_units_2_idx` (`updated_by`),
  KEY `tbm_clearance_form_units_tbm_clearance_forms_FK` (`clearance_form_d`),
  CONSTRAINT `fk_tbm_clearance_form_units_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `fk_tbm_clearance_form_units_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_clearance_form_units_tbm_clearance_forms_FK` FOREIGN KEY (`clearance_form_d`) REFERENCES `tbm_clearance_forms` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=146 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbm_clearance_form_units`
--


--
-- Table structure for table `tbm_clearance_forms`
--

CREATE TABLE `tbm_clearance_forms` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` int unsigned NOT NULL,
  `man_number` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `department_id` int unsigned NOT NULL,
  `position_id` int unsigned NOT NULL,
  `salary_scale_notch_id` int unsigned DEFAULT NULL,
  `contract_type_id` int unsigned NOT NULL,
  `reason_for_clearance` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_separation` date NOT NULL,
  `status` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `date_of_appointment` date NOT NULL,
  `retirement_notice_id` int unsigned DEFAULT NULL,
  `clearance_form` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_clearance_forms_tbm_retirement_notices_FK` (`retirement_notice_id`),
  KEY `tbm_clearance_forms_users_FK` (`emp_id`),
  KEY `tbm_clearance_forms_departments_FK` (`department_id`),
  KEY `tbm_clearance_forms_job_positions_FK` (`position_id`),
  KEY `tbm_clearance_forms_salary_scale_notches_FK` (`salary_scale_notch_id`),
  KEY `tbm_clearance_forms_contracts_FK` (`contract_type_id`),
  KEY `tbm_clearance_forms_users_FK_1` (`created_by`),
  KEY `tbm_clearance_forms_users_FK_2` (`updated_by`),
  CONSTRAINT `tbm_clearance_forms_contracts_FK` FOREIGN KEY (`contract_type_id`) REFERENCES `contracts` (`id`),
  CONSTRAINT `tbm_clearance_forms_departments_FK` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `tbm_clearance_forms_job_positions_FK` FOREIGN KEY (`position_id`) REFERENCES `job_positions` (`id`),
  CONSTRAINT `tbm_clearance_forms_salary_scale_notches_FK` FOREIGN KEY (`salary_scale_notch_id`) REFERENCES `salary_scale_notches` (`id`),
  CONSTRAINT `tbm_clearance_forms_tbm_retirement_notices_FK` FOREIGN KEY (`retirement_notice_id`) REFERENCES `tbm_retirement_notices` (`id`),
  CONSTRAINT `tbm_clearance_forms_users_FK` FOREIGN KEY (`emp_id`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_clearance_forms_users_FK_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_clearance_forms_users_FK_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbm_clearance_forms`
--

INSERT INTO `tbm_clearance_forms` VALUES (17,564,'11923',78,188,12,2,'Retirement','2024-05-17','ACTIVE',564,564,NULL,NULL,'2019-07-10',1246,'clearance_form_for_Retirement_25042024054422.pdf');

--
-- Table structure for table `tbm_collective_agreements`
--

CREATE TABLE `tbm_collective_agreements` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `staff_category_id` int unsigned NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `collective_agreement` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_collective_agreements_staff_categories_FK` (`staff_category_id`),
  KEY `tbm_collective_agreements_users_FK` (`created_by`),
  KEY `tbm_collective_agreements_users_FK_1` (`updated_by`),
  CONSTRAINT `tbm_collective_agreements_staff_categories_FK` FOREIGN KEY (`staff_category_id`) REFERENCES `staff_categories` (`id`),
  CONSTRAINT `tbm_collective_agreements_users_FK` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_collective_agreements_users_FK_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbm_collective_agreements`
--

INSERT INTO `tbm_collective_agreements` VALUES (26,1,'2024','2024 Collective Agreement for Academic','2024-01-01','2024-12-31','tbm_collective_agreement_Academic_2024.pdf','ACTIVE','2024-04-25 13:32:00','2024-04-25 13:32:00',29,29);

--
-- Table structure for table `tbm_computation_deductions`
--

CREATE TABLE `tbm_computation_deductions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `computation_id` int unsigned NOT NULL,
  `deduction_id` int unsigned NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `units` decimal(20,2) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_computation_deductions_users_FK` (`created_by`),
  KEY `tbm_computation_deductions_users_FK_1` (`updated_by`),
  KEY `tbm_computation_deductions_tbm_computations_FK` (`computation_id`),
  KEY `tbm_computation_deductions_tbm_deduction_defs_FK` (`deduction_id`),
  CONSTRAINT `tbm_computation_deductions_tbm_computations_FK` FOREIGN KEY (`computation_id`) REFERENCES `tbm_computations` (`id`),
  CONSTRAINT `tbm_computation_deductions_tbm_deduction_defs_FK` FOREIGN KEY (`deduction_id`) REFERENCES `tbm_deduction_defs` (`id`),
  CONSTRAINT `tbm_computation_deductions_users_FK` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_computation_deductions_users_FK_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbm_computation_deductions`
--

INSERT INTO `tbm_computation_deductions` VALUES (61,131,5,-650.00,29,29,'2024-04-25 15:41:22','2024-04-25 15:45:29',NULL);

--
-- Table structure for table `tbm_computation_earnings`
--

CREATE TABLE `tbm_computation_earnings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `computation_id` int unsigned NOT NULL,
  `earning_id` int unsigned NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `units` decimal(20,2) NOT NULL,
  `rate` decimal(20,2) DEFAULT NULL,
  `number_of_years_from` int unsigned DEFAULT NULL,
  `number_of_years_to` int unsigned DEFAULT NULL,
  `factor` decimal(20,2) DEFAULT NULL,
  `taxable` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_computation_earnings_tbm_computations_FK` (`computation_id`),
  KEY `tbm_computation_earnings_tbm_earning_defs_FK` (`earning_id`),
  KEY `tbm_computation_earnings_users_FK` (`created_by`),
  KEY `tbm_computation_earnings_users_FK_1` (`updated_by`),
  CONSTRAINT `tbm_computation_earnings_tbm_computations_FK` FOREIGN KEY (`computation_id`) REFERENCES `tbm_computations` (`id`),
  CONSTRAINT `tbm_computation_earnings_tbm_earning_defs_FK` FOREIGN KEY (`earning_id`) REFERENCES `tbm_earning_defs` (`id`),
  CONSTRAINT `tbm_computation_earnings_users_FK` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_computation_earnings_users_FK_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=203 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbm_computation_earnings`
--

INSERT INTO `tbm_computation_earnings` VALUES (200,131,10,4070424.66,29,29,'2024-04-25 15:41:22','2024-04-25 15:41:22',1.00,6.00,10,90,1.00,0),(202,131,11,14400.00,29,29,'2024-04-25 15:45:29','2024-04-25 15:45:29',10.00,NULL,1,1,1.00,1);

--
-- Table structure for table `tbm_computation_tax`
--

CREATE TABLE `tbm_computation_tax` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `computation_id` int unsigned NOT NULL,
  `limit` decimal(20,2) NOT NULL,
  `tax_rate` decimal(8,2) NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_computation_tax_users_FK` (`created_by`),
  KEY `tbm_computation_tax_users_FK_1` (`updated_by`),
  KEY `tbm_computation_tax_tbm_computations_FK` (`computation_id`),
  CONSTRAINT `tbm_computation_tax_tbm_computations_FK` FOREIGN KEY (`computation_id`) REFERENCES `tbm_computations` (`id`),
  CONSTRAINT `tbm_computation_tax_users_FK` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_computation_tax_users_FK_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=346 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbm_computation_tax`
--

INSERT INTO `tbm_computation_tax` VALUES (344,131,10000.00,20.00,2000.00,29,29,'2024-04-25 15:45:29','2024-04-25 15:45:29'),(345,131,29400.00,25.00,7350.00,29,29,'2024-04-25 15:45:29','2024-04-25 15:45:29');

--
-- Table structure for table `tbm_computations`
--

CREATE TABLE `tbm_computations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `retirement_notice_id` int unsigned DEFAULT NULL,
  `staff_category_id` int unsigned NOT NULL,
  `man_number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_appointment` date NOT NULL,
  `date_of_separation` date NOT NULL,
  `payments` decimal(20,2) NOT NULL,
  `deductions` decimal(20,2) NOT NULL,
  `net_payment` decimal(20,2) NOT NULL,
  `tax_paid` decimal(20,2) DEFAULT NULL,
  `exit_basic_salary` decimal(20,2) NOT NULL,
  `last_payslip_gross_pay` decimal(20,2) NOT NULL,
  `last_payslip_tax_paid` decimal(20,2) NOT NULL,
  `years_served` decimal(8,2) NOT NULL,
  `months_served` decimal(8,2) NOT NULL,
  `days_served` decimal(8,2) NOT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `period_served_fraction` decimal(8,4) NOT NULL,
  `tax_table_id` int unsigned NOT NULL,
  `leave_pay_deduction` decimal(20,2) NOT NULL,
  `items_omitted_by_mof` decimal(20,2) NOT NULL,
  `leave_pay_earning` decimal(20,2) NOT NULL,
  `gross_pay` decimal(20,2) NOT NULL,
  `less_pension` decimal(20,2) NOT NULL,
  `adjusted_mof_gross_benefits` decimal(20,2) NOT NULL,
  `taxable_gross_pay` decimal(20,2) NOT NULL,
  `tax_payable` decimal(20,2) NOT NULL,
  `benefits_after_tax` decimal(20,2) NOT NULL,
  `total_advance_payment` decimal(20,2) NOT NULL,
  `net_benefits_payable` decimal(20,2) NOT NULL,
  `collective_agreement_id` int unsigned NOT NULL,
  `contract_type_id` int unsigned NOT NULL,
  `last_payslip_copy` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `final_payment_id` int unsigned DEFAULT NULL,
  `entitlement_id` int unsigned DEFAULT NULL,
  `payment_to` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `clearance_form` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_computations_users_FK` (`created_by`),
  KEY `tbm_computations_users_FK_1` (`updated_by`),
  KEY `tbm_computations_users_FK_2` (`user_id`),
  KEY `tbm_computations_staff_categories_FK` (`staff_category_id`),
  KEY `tbm_computations_tbm_tax_tables_FK` (`tax_table_id`),
  KEY `tbm_computations_tbm_collective_agreements_FK` (`collective_agreement_id`),
  KEY `tbm_computations_contracts_FK` (`contract_type_id`),
  CONSTRAINT `tbm_computations_contracts_FK` FOREIGN KEY (`contract_type_id`) REFERENCES `contracts` (`id`),
  CONSTRAINT `tbm_computations_staff_categories_FK` FOREIGN KEY (`staff_category_id`) REFERENCES `staff_categories` (`id`),
  CONSTRAINT `tbm_computations_tbm_collective_agreements_FK` FOREIGN KEY (`collective_agreement_id`) REFERENCES `tbm_collective_agreements` (`id`),
  CONSTRAINT `tbm_computations_users_FK` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_computations_users_FK_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_computations_users_FK_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbm_computations`
--

INSERT INTO `tbm_computations` VALUES (131,570,NULL,1,'8384','2001-07-03','2024-02-14',4084824.66,0.00,0.00,-650.00,30000.00,25000.00,10000.00,22.00,7.00,11.00,'APPROVED',29,29,'2024-04-25 15:41:17','2024-04-25 15:51:28',22.6135,6,0.00,0.00,14400.00,39400.00,0.00,4084824.66,0.00,-650.00,4085474.66,0.00,4085474.66,26,2,'tbm_last_payslip_8384_140224.pdf',163,NULL,'EMPLOYEE','clearance_form_8384_131.pdf');

--
-- Table structure for table `tbm_deduction_defs`
--

CREATE TABLE `tbm_deduction_defs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `general_ledger_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deduction_type_id` int unsigned NOT NULL,
  `deduction_type_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_deduction_defs_tbm_deduction_types_FK` (`deduction_type_id`),
  KEY `tbm_deduction_defs_users_FK` (`created_by`),
  KEY `tbm_deduction_defs_users_FK_1` (`updated_by`),
  CONSTRAINT `tbm_deduction_defs_tbm_deduction_types_FK` FOREIGN KEY (`deduction_type_id`) REFERENCES `tbm_deduction_types` (`id`),
  CONSTRAINT `tbm_deduction_defs_users_FK` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_deduction_defs_users_FK_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbm_deduction_defs`
--

INSERT INTO `tbm_deduction_defs` VALUES (5,'PAYE','PAYE','PAYE',1,'INCTAX',572,572,'2024-03-22 14:06:37','2024-03-23 08:44:03','ACTIVE'),(6,'LEAVE PAY','LEAVEPAY','Leave Pay',4,'LEAVEPAY',572,572,'2024-03-23 08:41:12','2024-03-23 09:06:00','ACTIVE'),(7,'SchoolFees','SchoolFees','School Fees',3,'ADVANCE',572,572,'2024-04-06 12:17:52','2024-04-06 12:17:52','ACTIVE'),(8,'Medical','Medical','Medical',3,'ADVANCE',572,572,'2024-04-19 12:01:08','2024-04-19 12:01:08','ACTIVE');

--
-- Table structure for table `tbm_deduction_types`
--

CREATE TABLE `tbm_deduction_types` (
  `id` int unsigned NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tbm_deduction_types_unique` (`code`),
  UNIQUE KEY `tbm_deduction_types_unique_1` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbm_deduction_types`
--

INSERT INTO `tbm_deduction_types` VALUES (1,'INCTAX','Income Tax','Active',572,572,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(2,'OTHER','Other Deductions','Active',572,572,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(3,'ADVANCE','Advance','Active',572,572,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(4,'LEAVEPAY','Leave Pay','Active',572,572,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(5,'MOFOMMISSION','MOF Ommission','Active',572,572,'2023-11-02 11:08:15','2023-11-02 11:08:15');

--
-- Table structure for table `tbm_earning_defs`
--

CREATE TABLE `tbm_earning_defs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `staff_category_id` int unsigned NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `general_ledger_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `earning_type_id` int unsigned NOT NULL,
  `earning_type_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rate` decimal(8,2) NOT NULL,
  `number_of_years_from` int unsigned DEFAULT NULL,
  `number_of_years_to` int unsigned DEFAULT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `contract_type_id` int unsigned NOT NULL,
  `factor` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `taxable` int unsigned NOT NULL DEFAULT '0' COMMENT '0 for no and 1 for yes',
  `years_served_factor` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_earning_defs_staff_categories_FK` (`staff_category_id`),
  KEY `tbm_earning_defs_tbm_earning_types_FK` (`earning_type_id`),
  KEY `tbm_earning_defs_users_FK` (`created_by`),
  KEY `tbm_earning_defs_users_FK_1` (`updated_by`),
  KEY `tbm_earning_defs_contracts_FK` (`contract_type_id`),
  CONSTRAINT `tbm_earning_defs_contracts_FK` FOREIGN KEY (`contract_type_id`) REFERENCES `contracts` (`id`),
  CONSTRAINT `tbm_earning_defs_staff_categories_FK` FOREIGN KEY (`staff_category_id`) REFERENCES `staff_categories` (`id`),
  CONSTRAINT `tbm_earning_defs_tbm_earning_types_FK` FOREIGN KEY (`earning_type_id`) REFERENCES `tbm_earning_types` (`id`),
  CONSTRAINT `tbm_earning_defs_users_FK` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_earning_defs_users_FK_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbm_earning_defs`
--

INSERT INTO `tbm_earning_defs` VALUES (7,1,'GRATUITY','GRA','Gratuity',2,'GRATUITY',37.50,1,65,572,572,'2024-03-22 14:05:28','2024-03-22 14:05:28',3,'1','ACTIVE',0,0),(8,1,'LEAVE','LEAVE','LEAVE PAY',5,'LEAVEPAY',1.00,1,1,572,572,'2024-03-22 21:18:35','2024-03-22 21:18:35',3,'1','ACTIVE',1,0),(10,1,'PENSION','PENSION','10 Above',1,'PENSION',6.00,10,90,86,86,'2024-03-23 07:45:48','2024-04-06 13:38:35',2,'1','ACTIVE',0,1),(11,1,'LEAVEPAY','LEAVEPAY','LEAVE PAY',5,'LEAVEPAY',1.00,1,1,572,572,'2024-03-23 09:59:39','2024-04-06 09:46:01',2,'1','ACTIVE',1,0),(12,1,'4-7YearsService','4-7YearsService','4-7 Years Service',1,'PENSION',19.00,4,7,572,572,'2024-04-05 19:33:18','2024-04-05 19:51:46',2,'1','ACTIVE',0,1),(13,2,'1-3YearsService','1-3YearsService','1-3 Years Service Non Academic',1,'PENSION',4.00,1,3,572,572,'2024-04-06 12:11:16','2024-04-06 12:11:16',2,NULL,'ACTIVE',0,1),(14,2,'PENSION2','PENSION2','PENSION NON ACADEMIC',1,'PENSION',18.00,1,5,572,572,'2024-04-19 11:59:34','2024-04-23 12:18:11',2,NULL,'ACTIVE',0,0),(15,2,'PENSION3','PENSION2','15 and Above',1,'PENSION',5.00,15,99,572,572,'2024-04-19 12:05:57','2024-04-19 12:05:57',2,NULL,'ACTIVE',0,1),(16,1,'BAGGAGE','BAGGAGE','Baggage Allowance ',3,'BAGGAGE',1.00,1,1,572,572,'2024-04-19 12:25:41','2024-04-19 12:25:41',2,NULL,'ACTIVE',0,0),(17,2,'LEAVEPAY2','LEAVEPAY2','LEAVEPAY2',5,'LEAVEPAY',1.00,1,1,572,572,'2024-04-23 09:56:16','2024-04-23 09:56:16',2,NULL,'ACTIVE',0,0),(18,2,'PASSAGES','PASSAGES','PASSAGES',4,'PASSAGES',1.00,1,1,572,572,'2024-04-23 09:57:51','2024-04-23 09:57:51',2,NULL,'ACTIVE',0,0),(19,2,'PASSAGES2','PASSAGES2','PASSAGES2',4,'PASSAGES',1.00,1,1,572,572,'2024-04-23 09:59:26','2024-04-23 10:31:44',2,NULL,'ACTIVE',0,0),(20,2,'GRATUITYNONACAD','GRATUITYNONACAD','GRATUITY NON ACADEMIC',2,'GRATUITY',37.00,1,1,572,572,'2024-04-23 12:14:44','2024-04-23 12:14:44',3,NULL,'ACTIVE',0,0),(21,2,'LEAVEPAYNONACAD','LEAVEPAYNONACAD','LEAVE PAY NON ACADEMIC',5,'LEAVEPAY',1.00,1,1,572,572,'2024-04-23 12:21:38','2024-04-23 12:21:38',3,NULL,'ACTIVE',1,0),(22,2,'BAGGAGENONACAD','BAGGAGENONACAD','Baggage Allowance Non Academic',3,'BAGGAGE',1.00,1,1,572,572,'2024-04-23 12:22:52','2024-04-23 12:22:52',3,NULL,'ACTIVE',0,0);

--
-- Table structure for table `tbm_earning_types`
--

CREATE TABLE `tbm_earning_types` (
  `id` int unsigned NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` bigint unsigned DEFAULT NULL,
  `updated_by` bigint unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `tbm_earning_types_unique` (`code`),
  UNIQUE KEY `tbm_earning_types_unique_1` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbm_earning_types`
--

INSERT INTO `tbm_earning_types` VALUES (1,'PENSION','PENSION','Active',572,572,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(2,'GRATUITY','Gratuity','Active',572,572,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(3,'BAGGAGE','Baggage Allowance','Active',572,572,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(4,'PASSAGES','PASSAGES','Active',572,572,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(5,'LEAVEPAY','Leave Pay','Active',572,572,'2023-11-02 11:08:15','2023-11-02 11:08:15');

--
-- Table structure for table `tbm_entitlement_items`
--

CREATE TABLE `tbm_entitlement_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `entitlement_id` int unsigned NOT NULL,
  `earning_id` int unsigned NOT NULL,
  `units` decimal(20,2) NOT NULL,
  `rate` decimal(20,2) DEFAULT NULL,
  `amount` decimal(20,2) NOT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_entitlements_items_tbm_entitlements_FK` (`entitlement_id`),
  KEY `tbm_entitlement_items_tbm_earning_defs_FK` (`earning_id`),
  KEY `tbm_entitlement_items_users_FK` (`created_by`),
  KEY `tbm_entitlements_items_users_FK_1` (`updated_by`),
  CONSTRAINT `tbm_entitlement_items_tbm_earning_defs_FK` FOREIGN KEY (`earning_id`) REFERENCES `tbm_earning_defs` (`id`),
  CONSTRAINT `tbm_entitlement_items_tbm_entitlement_letters_FK` FOREIGN KEY (`entitlement_id`) REFERENCES `tbm_entitlements` (`id`),
  CONSTRAINT `tbm_entitlement_items_users_FK` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_entitlement_items_users_FK_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbm_entitlement_items`
--


--
-- Table structure for table `tbm_entitlements`
--

CREATE TABLE `tbm_entitlements` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` int unsigned NOT NULL,
  `man_number` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `department_id` int unsigned NOT NULL,
  `position_id` int unsigned NOT NULL,
  `salary_scale_notch_id` int unsigned NOT NULL,
  `contract_type_id` int unsigned NOT NULL,
  `reason_for_separation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_separation` date NOT NULL,
  `status` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `date_of_appointment` date NOT NULL,
  `retirement_notice_id` int unsigned NOT NULL,
  `entitlement_letter` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `staff_category_id` int unsigned NOT NULL,
  `computation_id` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_entitlements_tbm_retirement_notices_FK` (`retirement_notice_id`),
  KEY `tbm_entitlements_users_FK` (`emp_id`),
  KEY `tbm_entitlements_departments_FK` (`department_id`),
  KEY `tbm_entitlements_job_positions_FK` (`position_id`),
  KEY `tbm_entitlements_salary_scale_notches_FK` (`salary_scale_notch_id`),
  KEY `tbm_entitlements_contracts_FK` (`contract_type_id`),
  KEY `tbm_entitlements_users_FK_1` (`created_by`),
  KEY `tbm_entitlements_users_FK_2` (`updated_by`),
  KEY `tbm_entitlements_staff_categories_FK` (`staff_category_id`),
  KEY `tbm_entitlements_tbm_computations_FK` (`computation_id`),
  CONSTRAINT `tbm_entitlements_contracts_FK` FOREIGN KEY (`contract_type_id`) REFERENCES `contracts` (`id`),
  CONSTRAINT `tbm_entitlements_departments_FK` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `tbm_entitlements_job_positions_FK` FOREIGN KEY (`position_id`) REFERENCES `job_positions` (`id`),
  CONSTRAINT `tbm_entitlements_salary_scale_notches_FK` FOREIGN KEY (`salary_scale_notch_id`) REFERENCES `salary_scale_notches` (`id`),
  CONSTRAINT `tbm_entitlements_staff_categories_FK` FOREIGN KEY (`staff_category_id`) REFERENCES `staff_categories` (`id`),
  CONSTRAINT `tbm_entitlements_tbm_retirement_notices_FK` FOREIGN KEY (`retirement_notice_id`) REFERENCES `tbm_retirement_notices` (`id`),
  CONSTRAINT `tbm_entitlements_users_FK` FOREIGN KEY (`emp_id`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_entitlements_users_FK_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_entitlements_users_FK_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbm_entitlements`
--


--
-- Table structure for table `tbm_final_payment_payees`
--

CREATE TABLE `tbm_final_payment_payees` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `payment_id` int unsigned DEFAULT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `other_name` varchar(255) DEFAULT NULL,
  `title` varchar(15) NOT NULL,
  `phone` varchar(45) NOT NULL,
  `email` varchar(255) NOT NULL,
  `national_id` varchar(45) DEFAULT NULL,
  `postal_address` text NOT NULL,
  `bank_branch_id` int unsigned NOT NULL,
  `bank_account` varchar(20) NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime NOT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `national_id_type` varchar(255) NOT NULL,
  `computation_id` int unsigned NOT NULL,
  `order_of_appointment` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_final_payment_payees_users_FK` (`created_by`),
  KEY `tbm_final_payment_payees_users_FK_1` (`updated_by`),
  KEY `tbm_final_payment_payees_tbm_final_payments_FK` (`payment_id`),
  KEY `tbm_final_payment_payees_pam_bank_branches_FK` (`bank_branch_id`),
  KEY `tbm_final_payment_payees_tbm_computations_FK` (`computation_id`),
  CONSTRAINT `tbm_final_payment_payees_pam_bank_branches_FK` FOREIGN KEY (`bank_branch_id`) REFERENCES `pam_bank_branches` (`id`),
  CONSTRAINT `tbm_final_payment_payees_tbm_computations_FK` FOREIGN KEY (`computation_id`) REFERENCES `tbm_computations` (`id`),
  CONSTRAINT `tbm_final_payment_payees_tbm_final_payments_FK` FOREIGN KEY (`payment_id`) REFERENCES `tbm_final_payments` (`id`),
  CONSTRAINT `tbm_final_payment_payees_users_FK` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_final_payment_payees_users_FK_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1263 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `tbm_final_payment_payees`
--

INSERT INTO `tbm_final_payment_payees` VALUES (1262,163,'kabwe','Mwale','Phiri','Mr.','097851564','kabwe.mutale@unza.zm','261451/14/2','Lusaka',15,'156241',4085474.66,29,'2024-04-25 15:48:57','2024-04-25 15:51:28',29,'NRC.',131,'tbm_order_of_appointment_8384_131.pdf');

--
-- Table structure for table `tbm_final_payments`
--

CREATE TABLE `tbm_final_payments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `computation_id` int unsigned NOT NULL,
  `amount` decimal(20,2) NOT NULL,
  `payment_to` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `bank_branch_id` int unsigned DEFAULT NULL,
  `bank_account` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_final_payments_tbm_computations_FK` (`computation_id`),
  KEY `tbm_final_payments_users_FK` (`created_by`),
  KEY `tbm_final_payments_users_FK_1` (`updated_by`),
  CONSTRAINT `tbm_final_payments_tbm_computations_FK` FOREIGN KEY (`computation_id`) REFERENCES `tbm_computations` (`id`),
  CONSTRAINT `tbm_final_payments_users_FK` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_final_payments_users_FK_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbm_final_payments`
--

INSERT INTO `tbm_final_payments` VALUES (163,131,4085474.66,'Employee','APPROVED',29,29,'2024-04-25 15:51:23','2024-04-25 15:53:53',NULL,NULL);

--
-- Table structure for table `tbm_retirement_applications`
--

CREATE TABLE `tbm_retirement_applications` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` int unsigned NOT NULL,
  `man_number` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `department_id` int unsigned NOT NULL,
  `position_id` int unsigned NOT NULL,
  `salary_scale_notch_id` int unsigned DEFAULT NULL,
  `contract_type_id` int unsigned NOT NULL,
  `type_of_retirement` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_separation` date NOT NULL,
  `status` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `date_of_appointment` date NOT NULL,
  `application_letter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `response_letter` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_retirement_applications_users_FK` (`emp_id`),
  KEY `tbm_retirement_applications_users_FK_1` (`created_by`),
  KEY `tbm_retirement_applications_users_FK_2` (`updated_by`),
  KEY `tbm_retirement_applications_departments_FK` (`department_id`),
  KEY `tbm_retirement_applications_job_positions_FK` (`position_id`),
  KEY `tbm_retirement_applications_salary_scale_notches_FK` (`salary_scale_notch_id`),
  KEY `tbm_retirement_applications_contracts_FK` (`contract_type_id`),
  CONSTRAINT `tbm_retirement_applications_contracts_FK` FOREIGN KEY (`contract_type_id`) REFERENCES `contracts` (`id`),
  CONSTRAINT `tbm_retirement_applications_departments_FK` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `tbm_retirement_applications_job_positions_FK` FOREIGN KEY (`position_id`) REFERENCES `job_positions` (`id`),
  CONSTRAINT `tbm_retirement_applications_salary_scale_notches_FK` FOREIGN KEY (`salary_scale_notch_id`) REFERENCES `salary_scale_notches` (`id`),
  CONSTRAINT `tbm_retirement_applications_users_FK` FOREIGN KEY (`emp_id`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_retirement_applications_users_FK_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_retirement_applications_users_FK_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_vietnamese_ci;

--
-- Dumping data for table `tbm_retirement_applications`
--

INSERT INTO `tbm_retirement_applications` VALUES (53,564,'11923',78,188,12,2,'Late retirement','2024-05-17','APPROVED',564,29,'2024-04-25 15:57:39','2024-04-25 17:39:18','2019-07-10','application_letter_for_Late_Retirement_11923_.pdf','retirement_application_response_for_11923_53.pdf');

--
-- Table structure for table `tbm_retirement_notices`
--

CREATE TABLE `tbm_retirement_notices` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` int unsigned NOT NULL,
  `man_number` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `department_id` int unsigned NOT NULL,
  `position_id` int unsigned NOT NULL,
  `salary_scale_notch_id` int unsigned DEFAULT NULL,
  `contract_type_id` int unsigned NOT NULL,
  `type_of_retirement` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `date_of_separation` date NOT NULL,
  `status` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int unsigned NOT NULL,
  `updated_by` int unsigned NOT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `date_of_appointment` date NOT NULL,
  `dob` date DEFAULT NULL,
  `notice_letter` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `retirement_application_id` int unsigned DEFAULT NULL,
  `reason_for_separation` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_retirement_notices_users_FK` (`emp_id`),
  KEY `tbm_retirement_notices_users_FK_1` (`created_by`),
  KEY `tbm_retirement_notices_users_FK_2` (`updated_by`),
  KEY `tbm_retirement_notices_departments_FK` (`department_id`),
  KEY `tbm_retirement_notices_contracts_FK` (`contract_type_id`),
  KEY `tbm_retirement_notices_job_positions_FK` (`position_id`),
  KEY `tbm_retirement_notices_salary_scale_notches_FK` (`salary_scale_notch_id`),
  KEY `tbm_retirement_notices_tbm_retirement_applications_FK` (`retirement_application_id`),
  CONSTRAINT `tbm_retirement_notices_contracts_FK` FOREIGN KEY (`contract_type_id`) REFERENCES `contracts` (`id`),
  CONSTRAINT `tbm_retirement_notices_departments_FK` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `tbm_retirement_notices_job_positions_FK` FOREIGN KEY (`position_id`) REFERENCES `job_positions` (`id`),
  CONSTRAINT `tbm_retirement_notices_salary_scale_notches_FK` FOREIGN KEY (`salary_scale_notch_id`) REFERENCES `salary_scale_notches` (`id`),
  CONSTRAINT `tbm_retirement_notices_tbm_retirement_applications_FK` FOREIGN KEY (`retirement_application_id`) REFERENCES `tbm_retirement_applications` (`id`),
  CONSTRAINT `tbm_retirement_notices_users_FK` FOREIGN KEY (`emp_id`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_retirement_notices_users_FK_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_retirement_notices_users_FK_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1247 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tbm_retirement_notices`
--

INSERT INTO `tbm_retirement_notices` VALUES (1246,564,'11923',78,188,12,2,'Late retirement','2024-05-17','APPROVED',29,29,'2024-04-25 17:39:19','2024-04-25 17:39:19','2019-07-10','1965-02-04','retirement_notice_for_11923_1246.pdf',53,'Late retirement');

--
-- Table structure for table `tbm_tax_bands`
--

CREATE TABLE `tbm_tax_bands` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `tax_table_id` int unsigned DEFAULT NULL,
  `tax_table_code` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `from_amount` decimal(15,2) DEFAULT NULL,
  `to_amount` decimal(15,2) DEFAULT NULL,
  `taxable_amount` decimal(15,2) DEFAULT NULL,
  `tax_percentage` decimal(8,2) DEFAULT NULL,
  `status` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_tax_bands_tbm_tax_tables_FK` (`tax_table_id`),
  KEY `tbm_tax_bands_users_FK` (`created_by`),
  KEY `tbm_tax_bands_users_FK_1` (`updated_by`),
  CONSTRAINT `tbm_tax_bands_tbm_tax_tables_FK` FOREIGN KEY (`tax_table_id`) REFERENCES `tbm_tax_tables` (`id`),
  CONSTRAINT `tbm_tax_bands_users_FK` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_tax_bands_users_FK_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbm_tax_bands`
--

INSERT INTO `tbm_tax_bands` VALUES (32,6,NULL,0.00,10000.00,10000.00,20.00,'PENDING',29,29,'2024-04-25 13:43:49','2024-04-25 13:43:49'),(33,6,NULL,10000.10,1000000000000.00,999999989999.90,25.00,'PENDING',29,29,'2024-04-25 13:44:20','2024-04-25 13:44:20');

--
-- Table structure for table `tbm_tax_tables`
--

CREATE TABLE `tbm_tax_tables` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `status` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tbm_tax_tables_users_FK` (`created_by`),
  KEY `tbm_tax_tables_users_FK_1` (`updated_by`),
  CONSTRAINT `tbm_tax_tables_users_FK` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `tbm_tax_tables_users_FK_1` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tbm_tax_tables`
--

INSERT INTO `tbm_tax_tables` VALUES (6,'2024','2024','2024-01-01','2024-12-31','ACTIVE',29,29,'2024-04-25 13:30:59','2024-04-25 13:30:59');

--
-- Table structure for table `training`
--

CREATE TABLE `training` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `school_id` int unsigned DEFAULT NULL,
  `user` int unsigned DEFAULT NULL,
  `program` int unsigned DEFAULT NULL,
  `mode` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `duration` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `extension_1` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `extension_2` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `extension_3` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `extension_4` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `extension_5` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `progress_report` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `institution_id` int unsigned DEFAULT NULL,
  `sponsor` int unsigned DEFAULT NULL,
  `duration_of_years_spent` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `tuition_fees` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `book_allowance` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `examination_fee` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `registration_fee` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `travel_expense` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `total` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `status` int DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `school_id` (`school_id`),
  KEY `program` (`program`),
  KEY `institution_id` (`institution_id`),
  KEY `sponsor` (`sponsor`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `training_ibfk_1` FOREIGN KEY (`user`) REFERENCES `users` (`id`),
  CONSTRAINT `training_ibfk_2` FOREIGN KEY (`school_id`) REFERENCES `units` (`id`),
  CONSTRAINT `training_ibfk_3` FOREIGN KEY (`program`) REFERENCES `training_program` (`id`),
  CONSTRAINT `training_ibfk_4` FOREIGN KEY (`institution_id`) REFERENCES `training_institution` (`id`),
  CONSTRAINT `training_ibfk_5` FOREIGN KEY (`sponsor`) REFERENCES `training_sponsor` (`id`),
  CONSTRAINT `training_ibfk_6` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `training_ibfk_7` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `training`
--


--
-- Table structure for table `training_application_files`
--

CREATE TABLE `training_application_files` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `application` int NOT NULL,
  `name` varchar(255) NOT NULL,
  `file` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_new_table_1_idx` (`application`),
  CONSTRAINT `fk_new_table_1` FOREIGN KEY (`application`) REFERENCES `training_applications` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `training_application_files`
--

INSERT INTO `training_application_files` VALUES (10,2,'ACCEPTANCE_LETTER','acceptance_letter_1238.pdf'),(11,2,'APPLICATION_LETTER','application_letter_1238.pdf'),(12,2,'SCHOOL_MINUTES','school_minutes_1238.pdf'),(13,2,'DEANS_RECOMMENDATION','deans_recommendation_1238.pdf'),(15,2,'STAFFTRAININGCOMMITEE_MINUTES','stafftrainingcommitee_minutes_12382.pdf'),(16,3,'ACCEPTANCE_LETTER','acceptance_letter_353.pdf'),(17,3,'APPLICATION_LETTER','application_letter_353.pdf'),(18,4,'ACCEPTANCE_LETTER','acceptance_letter_12384.pdf'),(20,4,'APPLICATION_LETTER','application_letter_12384.pdf'),(21,4,'SCHOOL_MINUTES','school_minutes_12384.pdf'),(22,4,'DEANS_RECOMMENDATION','deans_recommendation_12384.pdf'),(23,4,'STAFFTRAININGCOMMITEE_MINUTES','stafftrainingcommitee_minutes_12384.pdf');

--
-- Table structure for table `training_applications`
--

CREATE TABLE `training_applications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user` int unsigned NOT NULL,
  `institution` int unsigned NOT NULL,
  `program_type` varchar(45) NOT NULL COMMENT 'PhD, Masters, Diploma, Certificate etc',
  `program` text NOT NULL,
  `other_porgram_names` varchar(45) DEFAULT NULL COMMENT 'In the case of PhD by research',
  `duration` int NOT NULL,
  `mode_of_study` varchar(45) NOT NULL COMMENT 'Full time, Part time, Distance, Sandwich',
  `sponsorship_type` varchar(255) NOT NULL COMMENT 'Self or Sponsored',
  `sponsor` int unsigned DEFAULT NULL,
  `expected_start_date` date NOT NULL,
  `expected_end_date` date DEFAULT NULL,
  `status` varchar(45) NOT NULL COMMENT 'Approved, Pending,Terminated, Completed',
  `fellowship_termination_reasons` varchar(45) DEFAULT NULL,
  `date_of_termination` date DEFAULT NULL,
  `terminated_by` int DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `unit` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_training_applications_1_idx` (`user`),
  KEY `fk_training_applications_2_idx` (`institution`),
  KEY `fk_training_applications_3_idx` (`sponsor`),
  CONSTRAINT `fk_training_applications_1` FOREIGN KEY (`user`) REFERENCES `users` (`id`),
  CONSTRAINT `fk_training_applications_2` FOREIGN KEY (`institution`) REFERENCES `training_institution` (`id`),
  CONSTRAINT `fk_training_applications_3` FOREIGN KEY (`sponsor`) REFERENCES `training_sponsor` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `training_applications`
--

INSERT INTO `training_applications` VALUES (2,1238,19,'PhD','Soil Chemistry','Chemistry of water',96,'Full time','Sponsored',4,'2024-09-26','2033-09-30','Approved','<p>Just had to terminate</p>','2024-04-16',29,'2024-03-22 22:04:40','2024-04-17 15:23:21',1238,29,18),(3,35,21,'Masters Degree','Animal Nutrition','',24,'Full time','Sponsored',4,'2024-07-24','2026-07-24','Incomplete',NULL,NULL,NULL,'2024-04-05 09:41:07','2024-05-05 11:47:36',35,35,18),(4,1238,19,'Masters Degree','Animal Nutrition','',24,'Full time','Sponsored',4,'2024-06-12','2026-06-12','Approved',NULL,NULL,NULL,'2024-04-05 09:55:51','2024-04-05 10:21:55',1238,29,18);

--
-- Table structure for table `training_extensions`
--

CREATE TABLE `training_extensions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `application` int NOT NULL,
  `reason` text NOT NULL COMMENT 'Valid extension reason',
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `actual_application_start_date` date DEFAULT NULL,
  `actual_application_end_date` date DEFAULT NULL,
  `supervisor_recomendation_letter` varchar(45) NOT NULL,
  `hod_recomendation_letter` varchar(45) NOT NULL,
  `status` varchar(45) NOT NULL DEFAULT 'Pending' COMMENT 'Pending,Approved,Rejected',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_training_extensions_1_idx` (`application`),
  CONSTRAINT `fk_training_extensions_1` FOREIGN KEY (`application`) REFERENCES `training_applications` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `training_extensions`
--

INSERT INTO `training_extensions` VALUES (3,2,'<p>Still doing studies</p>','2032-09-27','2033-09-30','2024-09-26','2032-09-26','supervisorExtensionRecomletter2.pdf','hodextensionrecomletter_3.pdf','Approved','2024-04-17 08:20:32','2024-04-17 15:23:21',1238);

--
-- Table structure for table `training_institution`
--

CREATE TABLE `training_institution` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `type_of_institution` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `phone` varchar(45) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `physical_postal_address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `country_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `country_id` (`country_id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `training_institution_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`),
  CONSTRAINT `training_institution_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `training_institution_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `training_institution`
--

INSERT INTO `training_institution` VALUES (18,'Cornell University','Academic','',NULL,'',235,'2024-03-18 09:56:06','2024-03-18 09:56:06',20,20),(19,'Nottingham University','Academic','',NULL,'',234,'2024-03-18 09:56:34','2024-03-18 09:56:34',20,20),(20,'University of Zambia','Academic','francis.chulu@unza.zm',NULL,'',246,'2024-03-18 11:10:33','2024-03-18 11:16:33',20,20),(21,'Copperbelt University','Academic','francis.chulu@unza.zm','+260978981234','',246,'2024-03-18 11:24:50','2024-03-18 11:42:48',20,20),(24,'UNZA CICT CTU','Academic','','','',246,'2024-05-08 16:41:04','2024-05-08 16:41:14',20,20);

--
-- Table structure for table `training_needs`
--

CREATE TABLE `training_needs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `school` int unsigned DEFAULT NULL,
  `department` int unsigned NOT NULL,
  `program` int unsigned NOT NULL,
  `type` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `category` varchar(45) COLLATE utf8mb4_general_ci NOT NULL,
  `duration` varchar(45) COLLATE utf8mb4_general_ci NOT NULL,
  `area_of_study` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `number_of_staff` int NOT NULL,
  `year` varchar(45) COLLATE utf8mb4_general_ci NOT NULL,
  `status` int NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `program` (`program`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `training_needs_ibfk_1` (`school`),
  KEY `department` (`department`),
  CONSTRAINT `training_needs_ibfk_1` FOREIGN KEY (`school`) REFERENCES `units` (`id`),
  CONSTRAINT `training_needs_ibfk_2` FOREIGN KEY (`program`) REFERENCES `training_program` (`id`),
  CONSTRAINT `training_needs_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `training_needs_ibfk_4` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `training_needs_ibfk_5` FOREIGN KEY (`department`) REFERENCES `departments` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `training_needs`
--

INSERT INTO `training_needs` VALUES (5,18,161,17,'Professional, Administrative and Technical','Seminar','Short term',NULL,10,'2024',1,'2024-03-19 06:58:44','2024-04-05 09:22:57',35,35),(6,18,160,29,'Professional, Administrative and Technical','Seminar','Short term',NULL,3,'2024',1,'2024-03-19 08:40:01','2024-04-05 09:22:57',35,35),(7,18,157,30,'Professional, Administrative and Technical','Seminar','Short term',NULL,5,'2024',1,'2024-03-19 09:49:11','2024-04-05 09:22:57',35,35),(8,18,92,23,'Academic','MSc','Long term',NULL,1,'2024',1,'2024-03-19 13:31:40','2024-04-05 09:22:57',35,35),(9,18,92,23,'Academic','PhD','Long term',NULL,2,'2024',1,'2024-03-19 13:32:17','2024-04-05 09:22:57',35,35),(10,18,154,14,'Academic','MA','Long term',NULL,3,'2024',1,'2024-03-19 13:33:18','2024-04-05 09:22:57',35,35),(11,18,155,20,'Professional, Administrative and Technical','MA','Long term',NULL,7,'2024',1,'2024-03-19 13:52:21','2024-04-05 09:22:57',35,35);

--
-- Table structure for table `training_program`
--

CREATE TABLE `training_program` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `category` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `training_program_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `training_program_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `training_program`
--

INSERT INTO `training_program` VALUES (5,'Soil Science','PhD','Short term','2024-03-18 12:06:09','2024-03-18 12:06:16',20,20),(6,'Animal Breeding',NULL,NULL,'2024-03-19 06:46:25','2024-03-19 06:46:25',20,20),(7,'Animal Reproduction',NULL,NULL,'2024-03-19 06:46:34','2024-03-19 06:46:34',20,20),(8,'Animal Nutrition',NULL,NULL,'2024-03-19 06:46:43','2024-03-19 06:46:43',20,20),(9,'Soil Physics (Shallow-Geo Physics)',NULL,NULL,'2024-03-19 06:46:52','2024-03-19 06:46:52',20,20),(10,'Soil Chemistry',NULL,NULL,'2024-03-19 06:47:02','2024-03-19 06:47:02',20,20),(11,'Irrigation and Water Resources Management',NULL,NULL,'2024-03-19 06:47:09','2024-03-19 06:47:09',20,20),(12,'Laboratory Instrumentation & Operations',NULL,NULL,'2024-03-19 06:47:18','2024-03-19 06:47:18',20,20),(13,'Remote Sensing & Soil Sensing Techniques',NULL,NULL,'2024-03-19 06:47:30','2024-03-19 06:47:30',20,20),(14,'Human Resources',NULL,NULL,'2024-03-19 08:35:50','2024-03-19 08:35:50',20,20),(15,'Management skills for executive secretaries',NULL,NULL,'2024-03-19 08:36:05','2024-03-19 08:36:05',20,20),(16,'Financial management',NULL,NULL,'2024-03-19 08:36:14','2024-03-19 08:36:14',20,20),(17,'Excel',NULL,NULL,'2024-03-19 08:36:21','2024-03-19 08:36:21',20,20),(18,'Monitoring and evaluation',NULL,NULL,'2024-03-19 08:36:29','2024-03-19 08:36:29',20,20),(19,'International computer driving license',NULL,NULL,'2024-03-19 08:36:38','2024-03-19 08:36:38',20,20),(20,'Administration',NULL,NULL,'2024-03-19 08:36:48','2024-03-19 08:36:48',20,20),(21,'Advanced statistical methods',NULL,NULL,'2024-03-19 08:36:56','2024-03-19 08:36:56',20,20),(22,'Records and Archives Management',NULL,NULL,'2024-03-19 08:37:11','2024-03-19 08:37:11',20,20),(23,'Library and Information Science',NULL,NULL,'2024-03-19 08:37:19','2024-03-19 08:37:19',20,20),(24,'Public Administration',NULL,NULL,'2024-03-19 08:37:26','2024-03-19 08:37:26',20,20),(25,'Accounts',NULL,NULL,'2024-03-19 08:37:33','2024-03-19 08:37:33',20,20),(26,'Team Building',NULL,NULL,'2024-03-19 08:37:45','2024-03-19 08:37:45',20,20),(27,'Records Management',NULL,NULL,'2024-03-19 08:37:53','2024-03-19 08:37:53',20,20),(28,'ICT Skills',NULL,NULL,'2024-03-19 08:37:58','2024-03-19 08:37:58',20,20),(29,'Website Management',NULL,NULL,'2024-03-19 08:38:05','2024-03-19 08:38:05',20,20),(30,'Inventory Management',NULL,NULL,'2024-03-19 08:38:11','2024-03-19 08:38:11',20,20),(31,'Etiquette training in administration',NULL,NULL,'2024-03-19 08:38:31','2024-03-19 08:38:31',20,20),(32,'MS Office',NULL,NULL,'2024-05-08 16:41:30','2024-05-08 16:41:30',20,20);

--
-- Table structure for table `training_progress_reports`
--

CREATE TABLE `training_progress_reports` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `application` int NOT NULL,
  `year` int NOT NULL,
  `report` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `sdf_status` varchar(45) DEFAULT NULL COMMENT 'OK,NOT OK, Pending',
  PRIMARY KEY (`id`),
  KEY `fk_training_progress_reports_1_idx` (`application`),
  CONSTRAINT `fk_training_progress_reports_1` FOREIGN KEY (`application`) REFERENCES `training_applications` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `training_progress_reports`
--

INSERT INTO `training_progress_reports` VALUES (2,2,2024,'progress_report_2024_240415055243.pdf','2024-04-15 13:43:29','2024-04-15 15:53:12',1238,1238,'OK');

--
-- Table structure for table `training_scholarship`
--

CREATE TABLE `training_scholarship` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_general_ci NOT NULL,
  `date_received` date DEFAULT NULL,
  `disseminated` varchar(512) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `comment` text COLLATE utf8mb4_general_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `training_scholarship_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `training_scholarship_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `training_scholarship`
--

INSERT INTO `training_scholarship` VALUES (5,'Full scholarship','Test scholarship','2023-07-12','Education,Graduate School of Business,Natural Sciences','Comment','2024-03-18 12:08:41','2024-03-18 12:11:41',20,20);

--
-- Table structure for table `training_short_term`
--

CREATE TABLE `training_short_term` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user` int unsigned NOT NULL,
  `training` int unsigned NOT NULL,
  `institution` int unsigned NOT NULL,
  `trainers` text,
  `year` int DEFAULT NULL,
  `date_of_training` date NOT NULL,
  `source_of_funds` text,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `unit` int unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `trainingshort_user_fk_idx` (`user`),
  KEY `trainingshort_trainingprogram_fk_idx` (`training`),
  KEY `trainingshort_institution_fk_idx` (`institution`),
  CONSTRAINT `trainingshort_institution_fk` FOREIGN KEY (`institution`) REFERENCES `training_institution` (`id`),
  CONSTRAINT `trainingshort_trainingprogram_fk` FOREIGN KEY (`training`) REFERENCES `training_program` (`id`),
  CONSTRAINT `trainingshort_user_fk` FOREIGN KEY (`user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `training_short_term`
--

INSERT INTO `training_short_term` VALUES (2,1238,28,24,'Mr. John Doe',2024,'2024-04-29','Central Admin',20,20,'2024-05-09 10:04:08','2024-05-09 10:15:38',18);

--
-- Table structure for table `training_sponsor`
--

CREATE TABLE `training_sponsor` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL,
  `country_id` int unsigned DEFAULT NULL,
  `description` text COLLATE utf8mb4_general_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `country_id` (`country_id`),
  CONSTRAINT `training_sponsor_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `training_sponsor_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `training_sponsor_ibfk_3` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `training_sponsor`
--

INSERT INTO `training_sponsor` VALUES (4,'Cape town University',207,'UCT sponsorship','2024-03-18 12:12:17','2024-03-18 12:12:17',20,20);

--
-- Table structure for table `training_study_leave`
--

CREATE TABLE `training_study_leave` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `application` int NOT NULL,
  `status` int DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_training_study_leave_1_idx` (`application`),
  KEY `fk_training_study_leave_2_idx` (`created_by`),
  CONSTRAINT `fk_training_study_leave_1` FOREIGN KEY (`application`) REFERENCES `training_applications` (`id`),
  CONSTRAINT `fk_training_study_leave_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `training_study_leave`
--

INSERT INTO `training_study_leave` VALUES (1,2,1,1238,29,'2024-03-28 11:07:38','2024-03-28 15:31:32'),(2,4,1,1238,29,'2024-04-05 10:27:50','2024-04-05 10:42:05');

--
-- Table structure for table `training_withdraw_details`
--

CREATE TABLE `training_withdraw_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `application` int NOT NULL,
  `reason` text NOT NULL,
  `sdf_approval` varchar(45) NOT NULL,
  `sdf_approved_by` int DEFAULT NULL,
  `attachment_one` varchar(255) NOT NULL,
  `attachment_two` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_training_withdraw_details_1_idx` (`application`),
  CONSTRAINT `fk_training_withdraw_details_1` FOREIGN KEY (`application`) REFERENCES `training_applications` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `training_withdraw_details`
--

INSERT INTO `training_withdraw_details` VALUES (1,2,'<p>Am sick</p>','Cancelled',NULL,'trainingwithdrawattachment_one_2_240416125116.pdf',NULL,'2024-04-16 10:51:16','2024-04-16 11:06:34',NULL,NULL),(2,2,'<p>Sick</p>','Cancelled',NULL,'trainingwithdrawattachment_one_2_240416010837.pdf',NULL,'2024-04-16 11:08:37','2024-04-16 11:48:31',NULL,NULL),(3,2,'<p>My Sponsor Withdrew and I cannot manage to sponsor myslef</p>','NOT Accepted',29,'trainingwithdrawattachment_one_2_240416015028.pdf','trainingwithdrawattachment_two_2_240416015028.pdf','2024-04-16 11:50:28','2024-04-16 13:40:45',NULL,NULL);

--
-- Table structure for table `units`
--

CREATE TABLE `units` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `head` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unit_name` (`name`),
  KEY `unit_createdby_fk_idx` (`created_by`),
  KEY `unit_head_fk_idx` (`head`),
  KEY `unit_updatedby_fk_idx` (`updated_by`),
  CONSTRAINT `unit_createdby_fk` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `unit_head_fk` FOREIGN KEY (`head`) REFERENCES `users` (`id`),
  CONSTRAINT `unit_updatedby_fk` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `units`
--

INSERT INTO `units` VALUES (1,'CICT',86,'2021-10-27 13:28:18','2022-02-11 10:52:26',20,20),(2,'Agricultural Sciences',47,NULL,'2022-05-16 07:56:21',NULL,31),(3,'Education',48,NULL,'2022-01-26 10:13:42',NULL,20),(4,'Engineering',46,NULL,'2022-03-31 11:01:58',NULL,20),(5,'Humanities and Social Sciences',44,NULL,'2022-03-31 11:02:28',NULL,20),(6,'Law',328,NULL,'2022-02-28 14:12:24',NULL,20),(7,'Medicine',38,NULL,'2022-01-26 10:14:18',NULL,20),(8,'Nursing Sciences',51,NULL,'2022-01-26 06:26:43',NULL,30),(9,'Health Sciences',40,NULL,'2021-12-10 12:53:37',NULL,NULL),(10,'Public Health',28,NULL,'2021-12-10 12:53:37',NULL,NULL),(11,'Mines',52,NULL,'2022-01-26 10:13:18',NULL,20),(12,'Natural Sciences',717,NULL,'2022-10-25 12:43:50',NULL,31),(13,'Verterinary Medicine',362,NULL,'2023-02-16 11:34:33',NULL,31),(14,'Graduate School of Business',36,NULL,'2022-01-26 10:13:57',NULL,20),(15,'Institute of Distance Education',28,NULL,'2021-12-10 12:53:37',NULL,NULL),(16,'INESOR',28,NULL,'2021-12-10 12:53:37',NULL,NULL),(17,'Directorate of Research and Graduate Studies',41,NULL,'2023-02-16 11:48:34',NULL,31),(18,'Library',35,NULL,'2022-11-10 08:19:56',NULL,20),(19,'Vice-Chancellor',929,NULL,'2023-01-26 12:48:36',NULL,20),(20,'Dean of Student Affairs',880,NULL,'2023-01-13 09:03:56',NULL,20),(21,'Registrar',351,NULL,'2023-01-13 12:09:26',NULL,31),(22,'Bursar',43,NULL,'2022-01-26 06:29:29',NULL,30),(30,'UNKNOWN',28,NULL,'2021-12-10 12:53:37',NULL,NULL),(31,'Confucius Institute',37,'2022-02-01 08:06:12','2022-02-01 08:06:12',20,20),(33,'TDAU',85,'2022-02-10 13:28:41','2022-02-10 13:28:41',29,29),(34,'Procurement and Supplies',90,'2022-02-14 06:36:17','2022-02-14 06:36:17',29,29),(35,'Finance',43,'2022-03-29 10:25:02','2022-03-29 10:25:02',29,29),(40,'Business Directorate',280,'2023-03-24 13:58:33','2023-03-24 13:58:33',30,30);

--
-- Table structure for table `user_to_role`
--

CREATE TABLE `user_to_role` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user` int unsigned NOT NULL,
  `role` int unsigned NOT NULL,
  `status` tinyint unsigned DEFAULT '0',
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_to_role_user_fk_idx` (`user`),
  KEY `user_to_role_createdby_fk_idx` (`created_by`),
  KEY `user_to_role_updatedby_fk_idx` (`updated_by`),
  KEY `user_to_role_role_fk_idx` (`role`),
  CONSTRAINT `user_to_role_createdby_fk` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `user_to_role_role_fk` FOREIGN KEY (`role`) REFERENCES `roles` (`id`),
  CONSTRAINT `user_to_role_updatedby_fk` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `user_to_role_user_fk` FOREIGN KEY (`user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_to_role`
--



