-- MySQL dump 10.13  Distrib 8.0.36, for Linux (x86_64)
--
-- Host: localhost    Database: unza_hr_actual_data
-- ------------------------------------------------------
-- Server version	8.0.41-0ubuntu0.22.04.1

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

--
-- Table structure for table `asp_academic_ranks`
--

DROP TABLE IF EXISTS `asp_academic_ranks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_academic_ranks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `rank_name` varchar(100) DEFAULT NULL,
  `rank_description` text,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `job_position_id` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `rank_name` (`rank_name`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `fk_asp_academic_ranks_job_position` (`job_position_id`),
  CONSTRAINT `asp_academic_ranks_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_academic_ranks_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `fk_asp_academic_ranks_job_position` FOREIGN KEY (`job_position_id`) REFERENCES `job_positions` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_academic_ranks`
--

LOCK TABLES `asp_academic_ranks` WRITE;
/*!40000 ALTER TABLE `asp_academic_ranks` DISABLE KEYS */;
INSERT INTO `asp_academic_ranks` VALUES (1,'Lecturer III','Entry-level lecturer position',450,450,'2024-12-08 10:32:34','2025-03-15 05:42:26',178),(2,'Lecturer II','Mid-level lecturer position',450,450,'2024-12-08 10:32:34','2025-03-15 05:42:26',177),(3,'Lecturer I','Senior lecturer position',450,450,'2024-12-08 10:32:34','2025-03-15 05:42:26',176),(4,'Senior Lecturer','Senior academic leadership position',450,450,'2024-12-08 10:32:34','2025-03-15 05:42:26',306),(5,'Associate Professor','High-level academic leadership position',450,450,'2024-12-08 10:32:34','2025-03-15 05:42:26',40),(6,'Professor','Highest-level academic leadership position',450,450,'2024-12-08 10:32:34','2025-03-15 05:42:26',255);
/*!40000 ALTER TABLE `asp_academic_ranks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_applications_hr_committees`
--

DROP TABLE IF EXISTS `asp_applications_hr_committees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_applications_hr_committees` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `promotion_application_id` int unsigned NOT NULL,
  `hr_committee_id` int unsigned NOT NULL,
  `status` enum('APPROVED','PENDING','REJECTED','INACTIVE') NOT NULL DEFAULT 'INACTIVE',
  `appealable_to` enum('HOD','HOU','HR Committee') DEFAULT NULL,
  `comment` text,
  `committee_minutes` text,
  `file_storage` varchar(255) DEFAULT NULL,
  `meeting_date` date DEFAULT NULL,
  `meeting_time` time DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `promotion_application_id` (`promotion_application_id`),
  KEY `hr_committee_id` (`hr_committee_id`),
  CONSTRAINT `hr_committee_id` FOREIGN KEY (`hr_committee_id`) REFERENCES `asp_hr_committees` (`id`),
  CONSTRAINT `promotion_application_id` FOREIGN KEY (`promotion_application_id`) REFERENCES `asp_promotion_applications` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_applications_hr_committees`
--

LOCK TABLES `asp_applications_hr_committees` WRITE;
/*!40000 ALTER TABLE `asp_applications_hr_committees` DISABLE KEYS */;
INSERT INTO `asp_applications_hr_committees` VALUES (1,4,3,'PENDING',NULL,NULL,NULL,NULL,NULL,NULL,'2025-03-15 17:44:49','2025-03-28 16:17:51'),(2,4,2,'PENDING',NULL,'',NULL,NULL,NULL,NULL,'2025-03-15 17:44:49','2025-03-28 16:17:51'),(3,4,1,'PENDING',NULL,'Final Approval Passed',NULL,NULL,NULL,NULL,'2025-03-15 17:44:49','2025-03-28 16:19:05');
/*!40000 ALTER TABLE `asp_applications_hr_committees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_courses`
--

DROP TABLE IF EXISTS `asp_courses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_courses` (
  `course_code` varchar(50) NOT NULL,
  `course_name` varchar(255) NOT NULL,
  PRIMARY KEY (`course_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_courses`
--

LOCK TABLES `asp_courses` WRITE;
/*!40000 ALTER TABLE `asp_courses` DISABLE KEYS */;
INSERT INTO `asp_courses` VALUES ('BIO101','Biology I'),('CHEM101','General Chemistry I'),('CSC101','Introduction to Computer Science'),('ECO100','Principles of Microeconomics'),('ENG101','English Composition I'),('MATH300','Calculus I'),('PHY101','Physics I'),('PSY100','Introduction to Psychology'),('SOC101','Introduction to Sociology'),('STAT101','Statistics for Beginners');
/*!40000 ALTER TABLE `asp_courses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_form_inputs`
--

DROP TABLE IF EXISTS `asp_form_inputs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_form_inputs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `input_fields` json DEFAULT NULL,
  `description` text,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `asp_form_inputs_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_form_inputs_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_form_inputs`
--

LOCK TABLES `asp_form_inputs` WRITE;
/*!40000 ALTER TABLE `asp_form_inputs` DISABLE KEYS */;
INSERT INTO `asp_form_inputs` VALUES (105,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the undergraduate courses you have taught since you started lecturing at the University of Zambia, indicate the year, course and total title, and the institution where the courses were taught. The years should be reported chronologically: the most recent should be reported first; and the first one, last. Please report the current course codes even if the course codes have changed over time.\", \"required\": true}, {\"name\": \"period\", \"type\": \"text\", \"label\": \"Period (e.g., 1990 – 2018)\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Courses Taught (Undergraduate) - Individual\"}','Courses Taught (Undergraduate) - Individual',NULL,NULL,'2025-03-17 21:15:26',NULL),(106,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the undergraduate courses you have taught since you started lecturing at the University of Zambia, indicate the year, course code and title, and the institution where the course is very taught. The years should be reported chronologically; the most recent should be reported first; and the first one, last. Please report the current course codes even if the course codes have changed over time.\", \"required\": true}, {\"name\": \"period\", \"type\": \"text\", \"label\": \"Period (e.g., 1990 – 2018)\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"total_course_lecturers\", \"type\": \"number\", \"label\": \"Total Number of Lecturers Who Co-Taught the Course\", \"required\": true, \"validation\": {\"min\": 1}}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Courses Taught (Undergraduate) - Group\"}','Courses Taught (Undergraduate) - Group',NULL,NULL,'2025-03-17 21:15:26',NULL),(107,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the postgraduate courses you have taught since you started lecturing at the University of Zambia. Indicate the year, course code and title, and the institution where the courses were taught. The years should be reported chronologically: the most recent should be reported first, and the first one, last. Please report the current course codes even if the course codes have changed over time.\", \"required\": true}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Courses Taught (Postgraduate) - Individual\"}','Courses Taught (Postgraduate) - Individual',NULL,NULL,'2025-03-17 21:15:26',NULL),(108,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the postgraduate courses you have taught since you started lecturing at the University of Zambia. Indicate the year, course code and title, and the institution where the courses were taught. The years should be reported chronologically; the most recent should be reported first; and the first one, last. Please report the current course codes even if the course codes have changed over time.\"}, {\"name\": \"period\", \"type\": \"year\", \"label\": \"Period (e.g., 1990 – 2018)\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"total_course_lecturers\", \"type\": \"number\", \"label\": \"Total Number of Lecturers Who Co-Taught the Course\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Courses Taught (Postgraduate) - Group\"}','Courses Taught (Postgraduate) - Group',NULL,NULL,'2025-03-17 21:15:26',NULL),(109,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the undergraduate courses you have taught with more than 75 students in the course since you started lecturing at the University of Zambia. Indicate the year, course code and title, and the institution where the courses were taught. The years should be reported chronologically; the most recent should be reported first; and the first one, last. Please report the current course codes even if the course codes have changed over time.\"}, {\"name\": \"period\", \"type\": \"text\", \"label\": \"Period (e.g., 1990 – 2018)\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"num_students\", \"type\": \"number\", \"label\": \"Number of Students\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Class Size (Teaching >76 Students per Year)\"}','Class Size (Teaching >76 Students per Year)',NULL,NULL,'2025-03-17 21:15:26',NULL),(110,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the undergraduate courses you have coordinated since you started lecturing at the University of Zambia. Indicate the year, course code and title, and the institution where the courses were taught. The years should be reported chronologically: the most recent should be reported first; and the first one, last. Please report the current course codes even if the course codes have changed over time.\", \"required\": true}, {\"name\": \"period\", \"type\": \"text\", \"label\": \"Period (e.g., 1990 – 2018)\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"num_students\", \"type\": \"number\", \"label\": \"Number of Students\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Course Coordination (Maximum of Two Courses per Year)\"}','Course Coordination (Maximum of Two Courses per Year)',NULL,NULL,'2025-03-17 21:15:26',NULL),(111,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the courses you have designed alone since you started lecturing at the University of Zambia. Indicate the year, course code and title, and the institution where the courses were designed. The years should be reported chronologically; the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Approved Courses (Individual)\"}','Approved Courses (Individual)',NULL,NULL,'2025-03-17 21:15:26',NULL),(112,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the courses you have designed together with other members of staff since you started lecturing at the University of Zambia. Indicate the year, course code and title, and the institution where the courses were designed. The years should be reported chronologically; the most recent should be reported first; and the first one, last.\"}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"New Approved Complete Course Module / Courses per Year (Group)\"}','New Approved Complete Course Module / Courses per Year (Group)',NULL,NULL,'2025-03-17 21:15:26',NULL),(113,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the doctoral dissertations/theses you have successfully supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Doctorate) - Supervisor per Year\"}','Postgraduate Supervision (Doctorate) - Supervisor per Year',NULL,NULL,'2025-03-17 21:15:26',NULL),(114,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the doctoral dissertations/theses you have successfully co-supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Doctorate) - Co-supervisor per Year\"}','Postgraduate Supervision (Doctorate) - Co-supervisor per Year',NULL,NULL,'2025-03-17 21:15:26',NULL),(115,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the doctoral dissertation/thesis presentations or viva voce examinations you have chaired at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Doctorate) - Chair of Board of Examiners\"}','Postgraduate Supervision (Doctorate) - Chair of Board of Examiners',NULL,NULL,'2025-03-17 21:15:26',NULL),(116,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the doctoral dissertations/theses you have successfully examined at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Doctorate) - Thesis Examiner\"}','Postgraduate Supervision (Doctorate) - Thesis Examiner',NULL,NULL,'2025-03-17 21:15:26',NULL),(117,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the master’s dissertations/theses you have successfully supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Masters) - Supervisor for Master’s with Thesis per Year\"}','Postgraduate Supervision (Masters) - Supervisor for Master’s with Thesis per Year',NULL,NULL,'2025-03-17 21:15:26',NULL),(118,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the master’s dissertations/theses you have successfully co-supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\"}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"year\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Masters) - Supervisor for masters without thesis p\"}','Postgraduate Supervision (Masters) - Supervisor for masters without thesis p',NULL,NULL,'2025-03-17 21:15:26',NULL),(119,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the master’s dissertations/theses you have successfully supervised outside your area of specialisation at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\"}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"year\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Masters) - Supervisor for Master\'s Outside Area of Specialisation\"}','Postgraduate Supervision (Masters) - Supervisor for Master\'s Outside Area of Specialisation',NULL,NULL,'2025-03-17 21:15:26',NULL),(120,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the master’s dissertations/theses you have successfully co-supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Masters) - Co-supervisor per Year\"}','Postgraduate Supervision (Masters) - Co-supervisor per Year',NULL,NULL,'2025-03-17 21:15:26',NULL),(121,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the master’s dissertations/theses you have successfully examined at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\"}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"year\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Masters) - Thesis Examiner\"}','Postgraduate Supervision (Masters) - Thesis Examiner',NULL,NULL,'2025-03-17 21:15:26',NULL),(122,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the diploma dissertations/theses/reports you have successfully supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Diploma) - Supervisor per Year\"}','Postgraduate Supervision (Diploma) - Supervisor per Year',NULL,NULL,'2025-03-17 21:15:26',NULL),(123,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the diploma dissertations/theses/reports you have successfully co-supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Diploma) - Co-Supervisor per Year\"}','Postgraduate Supervision (Diploma) - Co-Supervisor per Year',NULL,NULL,'2025-03-17 21:15:26',NULL),(124,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the diploma dissertations/theses/reports you have successfully examined at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Diploma) - Thesis Examiner\"}','Postgraduate Supervision (Diploma) - Thesis Examiner',NULL,NULL,'2025-03-17 21:15:26',NULL),(125,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Information will be inserted by the Head of Department from the Student Evaluation Questionnaire.\"}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"score\", \"type\": \"number\", \"label\": \"Score\", \"required\": true}], \"form_description\": \"Teaching Evaluation - Score per Year (Student Evaluation)\"}','Teaching Evaluation - Score per Year (Student Evaluation)',NULL,NULL,'2025-03-17 21:15:26',NULL),(126,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Information will be inserted by the Head of Department from the Performance Appraisal Questionnaire.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"score\", \"type\": \"number\", \"label\": \"Score\", \"required\": true}], \"form_description\": \"Teaching Evaluation - Score per Year (Supervisor Evaluation)\"}','Teaching Evaluation - Score per Year (Supervisor Evaluation)',NULL,NULL,'2025-03-17 21:15:26',NULL),(127,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report only peer-reviewed journals here. Verify the status of the journal from websites such as Scopus or Web of Science or from your departmental inventory of peer-reviewed journals.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Author Type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"name_of_journal\", \"type\": \"text\", \"label\": \"Name of Journal\", \"required\": true}], \"form_description\": \"Peer-Reviewed Journal Publications - Single Author\"}','Peer-Reviewed Journal Publications - Single Author',NULL,NULL,'2025-03-17 21:15:26',NULL),(128,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any article you have published in peer-reviewed conference papers.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Author Type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"name_of_journal\", \"type\": \"text\", \"label\": \"Name of Journal\", \"required\": true}], \"form_description\": \"Peer-Reviewed Proceedings (National & International) - Single Author\"}','Peer-Reviewed Proceedings (National & International) - Single Author',NULL,NULL,'2025-03-17 21:15:26',NULL),(129,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any journals you have published here. The journals need not be peer-reviewed.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"name_of_journal\", \"type\": \"text\", \"label\": \"Name of Journal\", \"required\": true}], \"form_description\": \"Non-Peer-Reviewed Journal Publications - Author, Lead Author, or Co-author\"}','Non-Peer-Reviewed Journal Publications - Author, Lead Author, or Co-author',NULL,NULL,'2025-03-17 21:15:26',NULL),(130,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"This is research, survey, or other work, the costs of which are wholly paid for by the customer and carried out in cooperation with industry. Report any research report you have written for international organisations, government, non-governmental organisations for which you received payment.\"}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"name_of_journal\", \"type\": \"text\", \"label\": \"Name of Journal\", \"required\": true}], \"form_description\": \"Commissioned Research Report\"}','Commissioned Research Report',NULL,NULL,'2025-03-17 21:15:26',NULL),(131,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any books you have published here. This includes training manuals, textbooks, and creative works such as novels.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"publisher\", \"type\": \"text\", \"label\": \"Publisher\", \"required\": true}, {\"name\": \"number_of_pages\", \"type\": \"number\", \"label\": \"Number of Pages\", \"required\": true}], \"form_description\": \"Books\"}','Books',NULL,NULL,'2025-03-17 21:15:26',NULL),(132,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any conferences, seminars, workshops, or symposia you have participated in. Also indicate your role/capacity at the conference, for example, as a keynote speaker, presenter of a paper, rapporteur, discussant, facilitator/resource person, or attendee.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"conference_title\", \"type\": \"text\", \"label\": \"Conference Title\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Academic / Professional Conference, Seminar, Workshop, Symposia\"}','Academic / Professional Conference, Seminar, Workshop, Symposia',NULL,NULL,'2025-03-17 21:15:26',NULL),(133,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any patents, inventions, prototypes, or artefacts to your credit. Indicate your role as inventor, partner, or assistant.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Type of Artifact\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Patents, Prototypes & Artefacts\"}','Patents, Prototypes & Artefacts',NULL,NULL,'2025-03-17 21:15:26',NULL),(134,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any scholarly articles written in newspapers and magazines or any scholarly discussions or presentations on radio, internet, or television.\", \"required\": true}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"name_of_media\", \"type\": \"text\", \"label\": \"Name of Paper/Magazine/Radio/TV\", \"required\": true}], \"form_description\": \"Media Discussions\"}','Media Discussions',NULL,NULL,'2025-03-17 21:15:26',NULL),(135,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report your role in journal refereeing and editing. Indicate your role (e.g., Chairperson of Editorial Board, Member Editorial Board, Reviewer) and the duration of your involvement.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}], \"form_description\": \"Journal Refection & Editing\"}','Journal Refection & Editing',NULL,NULL,'2025-03-17 21:15:26',NULL),(136,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the research conducted and the name of your mentor during the postdoctoral stint.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"research_done\", \"type\": \"text\", \"label\": \"Research Done\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}, {\"name\": \"mentor\", \"type\": \"text\", \"label\": \"Mentor\", \"required\": true}], \"form_description\": \"Post-Doctoral Research\"}','Post-Doctoral Research',NULL,NULL,'2025-03-17 21:15:26',NULL),(137,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Leave this section blank. Information will be inserted by the Head of Department from Google Scholar or other relevant sources. The Head of Department should record the number of years between the first citation and the current year. EDITED\"}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"h_index_score\", \"type\": \"number\", \"label\": \"H-Index Score\", \"required\": true}], \"form_description\": \"Scholarly Rating - H-Index\"}','Scholarly Rating - H-Index',NULL,NULL,'2025-03-17 21:15:26',NULL),(138,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\"}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','University Leadership & Administration',NULL,NULL,'2025-03-17 21:15:26',NULL),(139,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any participation in any fund-raising activities done on behalf of the University. Also indicate the amount raised and your role - as a team leader or member - of the fund-raising activity.\"}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Amount Range\", \"options\": [], \"required\": true}, {\"name\": \"amount_raised\", \"type\": \"number\", \"label\": \"Actual Amount Raised (in Kwacha)\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Resource Mobilisation\"}','Resource Mobilisation',NULL,NULL,'2025-03-17 21:15:26',NULL),(140,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any responsibilities you have had outside the university within and outside Zambia in statutory or international organisations such as parastatals like Bank of Zambia or the World Bank. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Service to Society (Statutory Organizations/International)\"}','Service to Society (Statutory Organizations/International)',NULL,NULL,'2025-03-17 21:15:26',NULL),(141,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any relevant associations you belong that in some way advance your academic responsibilities. Examples of these are the Economic Association of Zambia, Law Association of Zambia, etc. Indicate both the start and end date of your membership and your role whether as member of the executive or mere member.\", \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"association_name\", \"type\": \"text\", \"label\": \"Name of Association\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Associations - Member\"}','Associations - Member',NULL,NULL,'2025-03-17 21:15:26',NULL),(142,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any responsibilities you have been seconded by the university to serve either government or international organisation. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Secondment at National/International Level Organization\"}','Secondment at National/International Level Organization',NULL,NULL,'2025-03-17 21:15:26',NULL),(143,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any fellowships or scholarships you have been awarded such as the Rhodes, Chevening or Fulbright as well as others including local ones such as the Labour Day Award.\"}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Award Type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"award_title\", \"type\": \"text\", \"label\": \"Award Title\", \"required\": true}, {\"name\": \"status\", \"type\": \"text\", \"label\": \"Status\", \"required\": true}], \"form_description\": \"Awards\"}','Awards',NULL,NULL,'2025-03-17 21:15:26',NULL),(144,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any form of engagement with industry, community and society through applied research and/or service provision. Indicate your role such as principal consultant, partner, assistant, associate, etc., and also the organisation you did the consultancy for.\"}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Consultancy Type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}], \"form_description\": \"Consultancy\"}','Consultancy',NULL,NULL,'2025-03-17 21:15:26',NULL),(145,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any provision of oversight and quality assurance activity you have been involved in such as the administration of a course, programme, or examination in another institution of learning outside Zambia.\"}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"External Examination/Moderation\"}','External Examination/Moderation',NULL,NULL,'2025-03-17 21:15:26',NULL),(146,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any engagement in research or teaching activity outside the University of Zambia\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Sebbatical Leave\"}','Sebbatical Leave',NULL,NULL,'2025-03-17 21:15:26',NULL),(147,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any membership in professional bodies such as Engineering Institute of Zambia. For level, indicate if you are a fellow, associate, or just an ordinary member.\"}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Membership type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"year\", \"label\": \"Year\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Membership to Professional Bodies\"}','Membership to Professional Bodies',NULL,NULL,'2025-03-17 21:15:26',NULL),(148,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any other contributions not covered by the instrument but which unit/department may consider important. Indicate the role you played in your contribution.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Miscellaneous Contributions\"}','Miscellaneous Contributions',NULL,NULL,'2025-03-17 21:15:26',NULL),(149,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any other activity not covered in the preceding sections, which you have participated in such as: chief invigilator, course coordinator, project/team leader/coordinator, technical adviser, research coordinator, business official, etc.\", \"required\": true}, {\"name\": \"entries\", \"type\": \"repeater\", \"label\": \"Contributions\", \"fields\": [{\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"position\", \"type\": \"text\", \"label\": \"Position\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}]}], \"form_description\": \"Other Relevant Contributions\"}','Other Relevant Contributions',NULL,NULL,'2025-03-17 21:15:26',NULL),(150,'{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any responsibilities you have had outside the university in local institutions within Zambia such as non-governmental organisations, civil society organisations, private companies or industries. Indicate both the start date and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}, {\"name\": \"province\", \"type\": \"text\", \"label\": \"Province\", \"required\": true}], \"form_description\": \"Service to Society (Non-Statutory Organizations)\"}','Service to Society (Non-Statutory Organizations)',NULL,NULL,'2025-03-17 21:15:26',NULL);
/*!40000 ALTER TABLE `asp_form_inputs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_formula_categories`
--

DROP TABLE IF EXISTS `asp_formula_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_formula_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `qualification_type_id` int unsigned DEFAULT NULL,
  `qualification_category` varchar(100) DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `qualification_type_id` (`qualification_type_id`),
  CONSTRAINT `asp_formula_categories_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_formula_categories_ibfk_2` FOREIGN KEY (`qualification_type_id`) REFERENCES `asp_qualification_types` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_formula_categories`
--

LOCK TABLES `asp_formula_categories` WRITE;
/*!40000 ALTER TABLE `asp_formula_categories` DISABLE KEYS */;
INSERT INTO `asp_formula_categories` VALUES (1,1,'Years of service (quantity = per year teaching)',450,450,'2025-03-02 07:20:12',NULL),(2,1,'Course taught per year alone (undergraduate)',450,450,'2025-03-02 07:20:12',NULL),(3,1,'Course co-taught per year (undergraduate)',450,450,'2025-03-02 07:20:12',NULL),(4,1,'Course taught per year alone (postgraduate)',450,450,'2025-03-02 07:20:12',NULL),(5,1,'Teaching >76 students per year',450,450,'2025-03-02 07:20:12',NULL),(6,1,'Course coordinator (maximum of two courses per year)',450,450,'2025-03-02 07:20:12',NULL),(7,1,'New Approved complete course module / courses per year (individual)',450,450,'2025-03-02 07:20:12',NULL),(8,1,'New Approved complete course module / courses per year (group)',450,450,'2025-03-02 07:20:12',NULL),(9,1,'Postgraduate Supervision (Doctorate) : Supervisor per year',450,450,'2025-03-02 07:20:12',NULL),(10,1,'Postgraduate Supervision (Doctorate) : Co-supervisor per year',450,450,'2025-03-02 07:20:12',NULL),(11,1,'Postgraduate Supervision (Doctorate) : Chair of Board of Examiners',450,450,'2025-03-02 07:20:12',NULL),(12,1,'Postgraduate Supervision (Doctorate) : Thesis examiner',450,450,'2025-03-02 07:20:12',NULL),(13,1,'Postgraduate Supervision (Masters) : Supervisor for master\'s with thesis per year',450,450,'2025-03-02 07:20:12',NULL),(14,1,'Postgraduate Supervision (Masters) : Supervisor for master\'s without thesis per year',450,450,'2025-03-02 07:20:12',NULL),(15,1,'Postgraduate Supervision (Masters) : Supervisor for master\'s outside area of specialisation',450,450,'2025-03-02 07:20:12',NULL),(16,1,'Postgraduate Supervision (Masters) : Co-supervisor per year',450,450,'2025-03-02 07:20:12',NULL),(17,1,'Postgraduate Supervision (Masters) : Thesis examiner',450,450,'2025-03-02 07:20:12',NULL),(18,1,'Postgraduate Supervision (Diploma) : Supervisor per year',450,450,'2025-03-02 07:20:12',NULL),(19,1,'Postgraduate Supervision (Diploma) : Co-Supervisor per year',450,450,'2025-03-02 07:20:12',NULL),(20,1,'Postgraduate Supervision (Diploma) : Thesis examiner',450,450,'2025-03-02 07:20:12',NULL),(21,1,'Teaching Evaluation : Score per year (Student Evaluation)',450,450,'2025-03-02 07:20:12',NULL),(22,1,'Teaching Evaluation : Score per year (Supervisor Evaluation)',450,450,'2025-03-02 07:20:12',NULL),(23,2,'Peer-Reviewed Journal Publications',450,450,'2025-03-02 07:20:12',NULL),(25,2,'Peer-Reviewed Proceedings (National & International)',450,450,'2025-03-02 07:20:12',NULL),(27,2,'Non-peer-reviewed Journal Publications - Author, lead author or Co-author',450,450,'2025-03-02 07:20:12',NULL),(28,2,'Commissioned Research Report - Completed research',450,450,'2025-03-02 07:20:12',NULL),(29,2,'Books',450,450,'2025-03-02 07:20:12',NULL),(30,2,'Conferences & Seminars',450,450,'2025-03-02 07:20:12',NULL),(31,2,'Patents & Prototypes ',450,450,'2025-03-02 07:20:12',NULL),(32,2,'Media Discussions : Scholarly & creative contribution to media (maximum of 3 per year)',450,450,'2025-03-02 07:20:12',NULL),(33,2,'Journal Refereeing & Editing',450,450,'2025-03-02 07:20:12',NULL),(34,2,'Post-Doctoral Research',450,450,'2025-03-02 07:20:12',NULL),(35,2,'Scholarly Rating : H-Index',450,450,'2025-03-02 07:20:12',NULL),(36,3,'University Leadership and Administration',450,450,'2025-03-02 07:20:12',NULL),(37,3,'Resource Mobilization',450,450,'2025-03-02 07:20:12',NULL),(38,4,'Service to Society (Statutory)',450,450,'2025-03-02 07:20:12',NULL),(39,4,'Associations - Member (quantity per association)',450,450,'2025-03-02 07:20:12',NULL),(40,4,'Secondment at National/International Level Organization',450,450,'2025-03-02 07:20:12',NULL),(41,4,'Awards',450,450,'2025-03-02 07:20:12',NULL),(42,4,'Consultancy',450,450,'2025-03-02 07:20:12',NULL),(43,4,'External Examination : External examiner / moderator (at diploma level)',450,450,'2025-03-02 07:20:12',NULL),(44,4,'Sabbatical Leave',450,450,'2025-03-02 07:20:12',NULL),(45,4,'Membership to Professional Bodies',450,450,'2025-03-02 07:20:12',NULL),(46,4,'Miscellaneous Contributions',450,450,'2025-03-02 07:20:12',NULL),(47,5,'Professional Qualifications (quantity = per qualification)',450,450,'2025-03-02 07:20:12',NULL),(48,4,'Service to Society (Non Statutory))',450,450,'2025-03-03 08:51:15',NULL),(49,1,'Course co-taught per year(postgraduate)',450,450,'2025-03-02 07:20:12',NULL);
/*!40000 ALTER TABLE `asp_formula_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_formula_variables`
--

DROP TABLE IF EXISTS `asp_formula_variables`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_formula_variables` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `asp_formula_variables_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_formula_variables_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_formula_variables`
--

LOCK TABLES `asp_formula_variables` WRITE;
/*!40000 ALTER TABLE `asp_formula_variables` DISABLE KEYS */;
INSERT INTO `asp_formula_variables` VALUES (1,'365','Days in a year',450,NULL,'2024-12-08 00:57:31','2025-03-07 16:39:16'),(2,'years_of_service','Years of service',450,NULL,'2024-12-08 00:57:31','2024-12-08 00:57:31'),(3,'h_index','H index',450,NULL,'2024-12-08 00:57:31','2024-12-08 00:57:31'),(4,'weight','Weight',450,NULL,'2024-12-08 00:57:31','2024-12-08 00:57:31'),(5,'course_weight','Weight of course ',450,NULL,'2024-12-08 00:57:31','2025-03-06 20:24:34'),(68,'total_course_lecturers','Total number of lecturers sharing the course',450,NULL,'2024-12-08 00:57:31','2024-12-08 00:57:31'),(69,'role_in_book','Role in a book(single authour, editor etc)',450,NULL,'2024-12-08 00:57:31','2024-12-08 00:57:31'),(70,'days_on_position','total days held by a candidate on a position',3,3,'2025-03-07 14:57:35','2025-03-07 14:57:35');
/*!40000 ALTER TABLE `asp_formula_variables` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_general_qualifications`
--

DROP TABLE IF EXISTS `asp_general_qualifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_general_qualifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `year_awarded` year DEFAULT NULL,
  `academic_qualification` varchar(255) DEFAULT NULL,
  `institution` varchar(255) DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `asp_general_qualifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_general_qualifications_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_general_qualifications_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_general_qualifications`
--

LOCK TABLES `asp_general_qualifications` WRITE;
/*!40000 ALTER TABLE `asp_general_qualifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `asp_general_qualifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_hr_committee_categories`
--

DROP TABLE IF EXISTS `asp_hr_committee_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_hr_committee_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` text,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `code` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `asp_human_resource_committees_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_human_resource_committees_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_hr_committee_categories`
--

LOCK TABLES `asp_hr_committee_categories` WRITE;
/*!40000 ALTER TABLE `asp_hr_committee_categories` DISABLE KEYS */;
INSERT INTO `asp_hr_committee_categories` VALUES (4,'Department Level HR Committee',NULL,NULL,NULL,'2025-03-12 09:58:03','2025-03-12 09:58:03','dep_hr_com'),(5,'School Level HR Committee',NULL,NULL,NULL,'2025-03-12 09:58:03','2025-03-12 09:58:03','sch_hr_com'),(6,'Human Resource Committee',NULL,NULL,NULL,'2025-03-12 09:58:03','2025-03-12 09:58:03','hr_com');
/*!40000 ALTER TABLE `asp_hr_committee_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_hr_committee_members`
--

DROP TABLE IF EXISTS `asp_hr_committee_members`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_hr_committee_members` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `hr_committee_id` int unsigned NOT NULL,
  `user_id` int unsigned NOT NULL,
  `role` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `committee_member_hr_committee_id` (`hr_committee_id`),
  KEY `committee_member_user_id` (`user_id`),
  CONSTRAINT `committee_member_hr_committee_id` FOREIGN KEY (`hr_committee_id`) REFERENCES `asp_hr_committees` (`id`),
  CONSTRAINT `committee_member_user_id` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_hr_committee_members`
--

LOCK TABLES `asp_hr_committee_members` WRITE;
/*!40000 ALTER TABLE `asp_hr_committee_members` DISABLE KEYS */;
INSERT INTO `asp_hr_committee_members` VALUES (5,2,199,'Member','2025-03-14 08:11:56','2025-03-24 20:35:45'),(6,2,662,'Chairperson','2025-03-14 08:11:56','2025-03-24 20:35:45'),(7,1,77,'Chairperson','2025-03-14 08:40:57','2025-03-14 08:40:57'),(8,2,1002,'Member','2025-03-14 18:28:11','2025-03-24 19:52:49'),(9,2,1877,'Member','2025-03-14 18:32:48','2025-03-24 19:39:52'),(10,2,2708,'Member','2025-03-14 18:33:13','2025-03-14 18:33:13'),(12,2,443,'Member','2025-03-15 06:31:39','2025-03-15 06:31:39'),(13,3,1499,'Member','2025-03-24 17:59:16','2025-03-24 17:59:16'),(14,3,82,'Member','2025-03-24 17:59:16','2025-03-24 17:59:16'),(15,3,199,'Member','2025-03-24 17:59:16','2025-03-24 17:59:16'),(18,3,443,'Chairperson','2025-03-25 00:03:06','2025-03-28 17:14:16'),(20,3,491,'Member','2025-03-28 17:10:40','2025-03-28 17:10:40'),(21,3,920,'Member','2025-03-28 17:11:04','2025-03-28 17:13:55'),(22,3,447,'Member','2025-03-28 17:13:55','2025-03-28 17:14:16');
/*!40000 ALTER TABLE `asp_hr_committee_members` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_hr_committees`
--

DROP TABLE IF EXISTS `asp_hr_committees`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_hr_committees` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `hr_committee_category_id` int unsigned NOT NULL,
  `department_id` int unsigned DEFAULT NULL,
  `unit_id` int unsigned DEFAULT NULL,
  `name` varchar(255) NOT NULL,
  `description` text,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `committee_category_id` (`hr_committee_category_id`),
  KEY `committee_department_id` (`department_id`),
  KEY `committee_unit_id` (`unit_id`),
  KEY `committee_created_by` (`created_by`),
  KEY `committee_updated_by` (`updated_by`),
  CONSTRAINT `committee_category_id` FOREIGN KEY (`hr_committee_category_id`) REFERENCES `asp_hr_committee_categories` (`id`),
  CONSTRAINT `committee_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `committee_department_id` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `committee_unit_id` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`),
  CONSTRAINT `committee_updated_by` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_hr_committees`
--

LOCK TABLES `asp_hr_committees` WRITE;
/*!40000 ALTER TABLE `asp_hr_committees` DISABLE KEYS */;
INSERT INTO `asp_hr_committees` VALUES (1,6,NULL,NULL,'Test HR Committeee','some committee',3,3,'2025-03-13 22:46:53','2025-03-25 07:32:14'),(2,5,NULL,11,'NS HR Committee','NS HR',3,3,'2025-03-13 22:49:41','2025-03-13 22:49:41'),(3,4,81,NULL,'Another Test','',3,3,'2025-03-13 23:02:19','2025-03-15 17:38:54'),(13,4,130,NULL,'ACADEMIC AFFAIRS HR COMMITTEE','',443,443,'2025-03-25 01:19:36','2025-03-25 01:19:36'),(14,4,44,NULL,'ANATOMY HR COMMITTEE','',443,443,'2025-03-25 01:20:35','2025-03-25 01:20:35'),(15,4,128,NULL,'ADMINISTRATION HR COMMITTEE','',443,443,'2025-03-25 07:29:10','2025-03-25 07:29:10'),(17,4,52,NULL,'SURGERY HR COMMITTEE','',3,3,'2025-03-28 20:15:13','2025-03-28 20:15:13');
/*!40000 ALTER TABLE `asp_hr_committees` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_lecturer_point_totals`
--

DROP TABLE IF EXISTS `asp_lecturer_point_totals`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_lecturer_point_totals` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `lecturer_id` int unsigned DEFAULT NULL,
  `total_points` decimal(10,2) DEFAULT NULL,
  `teaching_percentage` decimal(5,2) DEFAULT NULL,
  `teaching_points` decimal(10,2) DEFAULT NULL,
  `research_percentage` decimal(5,2) DEFAULT NULL,
  `research_points` decimal(10,2) DEFAULT NULL,
  `university_service_percentage` decimal(5,2) DEFAULT NULL,
  `university_service_points` decimal(10,2) DEFAULT NULL,
  `community_service_percentage` decimal(5,2) DEFAULT NULL,
  `community_service_points` decimal(10,2) DEFAULT NULL,
  `h_index` int DEFAULT NULL,
  `annual_performance_appraisal` decimal(5,2) DEFAULT NULL,
  `new_publications` int DEFAULT NULL,
  `peer_reviewed_publications` int DEFAULT NULL,
  `postgraduate_supervision` int DEFAULT NULL,
  `doctoral_supervision` int DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `lecturer_id` (`lecturer_id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `asp_lecturer_point_totals_ibfk_1` FOREIGN KEY (`lecturer_id`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_lecturer_point_totals_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_lecturer_point_totals_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_lecturer_point_totals`
--

LOCK TABLES `asp_lecturer_point_totals` WRITE;
/*!40000 ALTER TABLE `asp_lecturer_point_totals` DISABLE KEYS */;
INSERT INTO `asp_lecturer_point_totals` VALUES (1,3,500.00,95.00,475.00,5.00,25.00,3.00,15.00,2.50,12.50,2,80.00,0,10,2,1,450,450,'2024-12-08 09:34:30','2025-03-11 12:24:50'),(6,443,1140.51,46.69,532.50,9.29,106.00,5.17,59.00,1.62,18.51,15,80.00,0,25,15,5,450,443,'2024-12-08 09:34:30','2025-03-27 07:20:00'),(7,1877,76.62,68.19,52.25,24.15,18.50,1.62,1.24,6.04,4.63,0,0.00,0,0,0,0,NULL,1877,'2025-03-19 00:08:50','2025-03-27 21:29:04'),(8,NULL,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0.00,0,0,0,0,NULL,NULL,'2025-03-19 19:14:55','2025-03-19 19:14:55'),(9,459,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0.00,0,0,0,0,NULL,NULL,'2025-04-04 14:00:38','2025-04-04 14:00:38');
/*!40000 ALTER TABLE `asp_lecturer_point_totals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_lecturer_qualifications`
--

DROP TABLE IF EXISTS `asp_lecturer_qualifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_lecturer_qualifications` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `lecturer_id` int unsigned NOT NULL,
  `formula_categories_id` int NOT NULL,
  `point_scoring_formulas_id` int NOT NULL,
  `qualification_data` json NOT NULL,
  `calculated_points` decimal(10,2) NOT NULL DEFAULT '0.00',
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `lecturer_application_id` int unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `point_scoring_formulas_id` (`point_scoring_formulas_id`),
  KEY `asp_lecturer_qualifications_ibfk_1` (`lecturer_id`),
  KEY `asp_lecturer_qualifications_ibfk_3` (`lecturer_application_id`),
  CONSTRAINT `asp_lecturer_qualifications_ibfk_1` FOREIGN KEY (`lecturer_id`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_lecturer_qualifications_ibfk_2` FOREIGN KEY (`point_scoring_formulas_id`) REFERENCES `asp_point_scoring_formulas` (`id`),
  CONSTRAINT `asp_lecturer_qualifications_ibfk_3` FOREIGN KEY (`lecturer_application_id`) REFERENCES `asp_promotion_applications` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_lecturer_qualifications`
--

LOCK TABLES `asp_lecturer_qualifications` WRITE;
/*!40000 ALTER TABLE `asp_lecturer_qualifications` DISABLE KEYS */;
INSERT INTO `asp_lecturer_qualifications` VALUES (13,443,29,31,'\"{\\\"year\\\":{\\\"value\\\":\\\"2000\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"title\\\":{\\\"value\\\":\\\"hhjdjshf\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"publisher\\\":{\\\"value\\\":\\\"dbh\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"number_of_pages\\\":{\\\"value\\\":\\\"30\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"Role\\\":{\\\"value\\\":\\\"Books - Single author\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',8.00,443,443,'2025-03-18 12:00:31','2025-03-24 01:06:34',4),(14,443,29,35,'\"{\\\"year\\\":{\\\"value\\\":\\\"7878\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"title\\\":{\\\"value\\\":\\\"dfhj\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"publisher\\\":{\\\"value\\\":\\\"df\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"number_of_pages\\\":{\\\"value\\\":\\\"409\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"Role\\\":{\\\"value\\\":\\\"Books - Editor\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',4.50,443,443,'2025-03-18 12:00:44','2025-03-24 01:06:34',4),(15,443,37,71,'\"{\\\"year\\\":{\\\"value\\\":\\\"2022\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"project_title\\\":{\\\"value\\\":\\\"Some Title\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"amount_raised\\\":{\\\"value\\\":\\\"30000\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"Leader\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Amount Range\\\":{\\\"value\\\":\\\"Resource Mobilization : Team Member (\\\\u00e2\\\\u2030\\\\u00a550,000 but <250,000 Kwacha)\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',2.00,443,443,'2025-03-18 16:29:00','2025-03-24 01:06:34',4),(16,443,30,39,'\"{\\\"year\\\":{\\\"value\\\":\\\"2323\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"conference_title\\\":{\\\"value\\\":\\\"test read only\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"country\\\":{\\\"value\\\":\\\"test readonly\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Role\\\":{\\\"value\\\":\\\"Conferences & Seminars : Facilitation (maximum of 4 per year)\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',3.00,443,443,'2025-03-18 19:27:20','2025-03-24 01:06:34',4),(17,443,30,39,'\"{\\\"year\\\":{\\\"value\\\":\\\"8989\\\",\\\"type\\\":\\\"number\\\"},\\\"conference_title\\\":{\\\"value\\\":\\\"huhj\\\",\\\"type\\\":\\\"text\\\"},\\\"country\\\":{\\\"value\\\":\\\"yuu\\\",\\\"type\\\":\\\"text\\\"},\\\"Role\\\":{\\\"value\\\":\\\"Conferences & Seminars : Facilitation (maximum of 4 per year)\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',3.00,443,443,'2025-03-18 19:40:22','2025-03-24 01:06:34',4),(18,443,30,37,'\"{\\\"year\\\":{\\\"value\\\":\\\"9090\\\",\\\"type\\\":\\\"number\\\"},\\\"conference_title\\\":{\\\"value\\\":\\\"ui\\\",\\\"type\\\":\\\"text\\\"},\\\"country\\\":{\\\"value\\\":\\\"h\\\",\\\"type\\\":\\\"text\\\"},\\\"Role\\\":{\\\"value\\\":\\\"Conferences & Seminars : Conference paper\\\\/Multimedia \\\\/ Poster presentation\\\",\\\"type\\\":\\\"text\\\"}}\"',3.50,443,443,'2025-03-18 19:41:56','2025-03-24 01:06:34',4),(19,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"45\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"45df\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 19:59:20','2025-03-24 01:06:34',4),(20,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"34\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"fj\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 20:05:11','2025-03-24 01:06:34',4),(21,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"89\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"uy\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 20:12:26','2025-03-24 01:06:34',4),(22,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"78\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"udhg\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 20:15:21','2025-03-24 01:06:34',4),(23,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"78\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"ghhe\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 20:16:12','2025-03-24 01:06:34',4),(24,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"34\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"fd\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 20:16:38','2025-03-24 01:06:34',4),(25,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"8998\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"hjdfjh\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 20:21:19','2025-03-24 01:06:34',4),(26,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"87\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"fh\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 20:22:36','2025-03-24 01:06:34',4),(27,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"8787\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"dffg\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 20:24:49','2025-03-24 01:06:34',4),(28,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"8374\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"ehr\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 20:25:28','2025-03-24 01:06:34',4),(29,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"87\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"rer\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 20:26:31','2025-03-24 01:06:34',4),(30,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"98\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"hdf\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 20:27:44','2025-03-24 01:06:34',4),(31,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"89\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"h\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 20:28:43','2025-03-24 01:06:34',4),(32,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"7887\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"g\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',9.00,443,443,'2025-03-18 20:38:09','2025-03-24 01:06:34',4),(33,443,31,41,'\"{\\\"year\\\":{\\\"value\\\":\\\"98\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"role\\\":{\\\"value\\\":\\\"hg\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Type of Artifact\\\":{\\\"value\\\":\\\"Patents & Prototypes : Patents\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',9.00,443,443,'2025-03-18 20:39:07','2025-03-24 01:06:34',4),(34,443,29,36,'\"{\\\"year\\\":{\\\"value\\\":\\\"89\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"title\\\":{\\\"value\\\":\\\"hhg\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"publisher\\\":{\\\"value\\\":\\\"gh\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"number_of_pages\\\":{\\\"value\\\":\\\"888\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"Role\\\":{\\\"value\\\":\\\"Books - Creative writing\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',3.00,443,443,'2025-03-18 20:40:46','2025-03-24 01:06:34',4),(35,443,2,2,'\"{\\\"period\\\":{\\\"value\\\":\\\"8998\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"course_code\\\":{\\\"value\\\":\\\"gghhg\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"course_title\\\":{\\\"value\\\":\\\"gygh\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"institution\\\":{\\\"value\\\":\\\"hghg\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',2.25,443,443,'2025-03-18 20:42:08','2025-03-24 01:06:34',4),(36,443,13,15,'\"{\\\"candidate_name\\\":{\\\"value\\\":\\\"hggh\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"title_of_dissertation\\\":{\\\"value\\\":\\\"hghg\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"year_of_completion\\\":{\\\"value\\\":\\\"7878\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"institution\\\":{\\\"value\\\":\\\"hgg\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',6.50,443,443,'2025-03-18 20:42:51','2025-03-24 01:06:34',4),(37,443,41,91,'\"{\\\"year\\\":{\\\"value\\\":\\\"8998\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"award_title\\\":{\\\"value\\\":\\\"hg\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"status\\\":{\\\"value\\\":\\\"ggh\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Award Type\\\":{\\\"value\\\":\\\"Awards : Conferred by the State \\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',2.00,443,443,'2025-03-18 20:43:16','2025-03-24 01:06:34',4),(38,443,41,90,'\"{\\\"year\\\":{\\\"value\\\":\\\"8734\\\",\\\"type\\\":\\\"number\\\",\\\"required\\\":true},\\\"award_title\\\":{\\\"value\\\":\\\"dfhj\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"status\\\":{\\\"value\\\":\\\"dfh\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Award Type\\\":{\\\"value\\\":\\\"Awards : Recognised International Awards \\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',4.00,443,443,'2025-03-18 20:47:36','2025-03-24 01:06:34',4),(39,443,42,94,'\"{\\\"year\\\":{\\\"value\\\":\\\"8743\\\",\\\"type\\\":\\\"number\\\",\\\"required\\\":true},\\\"project_title\\\":{\\\"value\\\":\\\"jhdf\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"role\\\":{\\\"value\\\":\\\"899\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"organisation\\\":{\\\"value\\\":\\\"ufdjh\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Consultancy Type\\\":{\\\"value\\\":\\\"Consultancy : Self-sourced per consultancy completed\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',1.00,443,443,'2025-03-18 20:48:29','2025-03-24 01:06:34',4),(40,1877,29,31,'\"{\\\"year\\\":{\\\"value\\\":\\\"2017\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"title\\\":{\\\"value\\\":\\\"Reasonable test\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"publisher\\\":{\\\"value\\\":\\\"Testing\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"number_of_pages\\\":{\\\"value\\\":\\\"44\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"Role\\\":{\\\"value\\\":\\\"Books - Single author\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',8.00,1877,1877,'2025-03-19 00:11:23','2025-03-27 17:37:34',NULL),(43,443,25,27,'\"{\\\"year\\\":{\\\"value\\\":\\\"2022\\\",\\\"type\\\":\\\"number\\\",\\\"required\\\":true},\\\"title\\\":{\\\"value\\\":\\\"Peer Reviewed\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"name_of_journal\\\":{\\\"value\\\":\\\"Test Journal\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Author Type\\\":{\\\"value\\\":\\\"Single author\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',6.00,443,443,'2025-03-19 13:48:59','2025-03-24 01:06:34',4),(44,443,25,27,'\"{\\\"year\\\":{\\\"value\\\":\\\"2000\\\",\\\"type\\\":\\\"number\\\",\\\"required\\\":true},\\\"title\\\":{\\\"value\\\":\\\"test\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"name_of_journal\\\":{\\\"value\\\":\\\"test2\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Author Type\\\":{\\\"value\\\":\\\"Single author\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',6.00,443,443,'2025-03-19 13:49:32','2025-03-24 01:06:34',4),(45,443,25,27,'\"{\\\"year\\\":{\\\"value\\\":\\\"787\\\",\\\"type\\\":\\\"number\\\",\\\"required\\\":true},\\\"title\\\":{\\\"value\\\":\\\"hdfhjdf\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"name_of_journal\\\":{\\\"value\\\":\\\"dfdf\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Author Type\\\":{\\\"value\\\":\\\"Single author\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',6.00,443,443,'2025-03-19 14:25:26','2025-03-24 01:06:34',4),(46,443,41,91,'\"{\\\"year\\\":{\\\"value\\\":\\\"3333\\\",\\\"type\\\":\\\"number\\\",\\\"required\\\":true},\\\"award_title\\\":{\\\"value\\\":\\\"Test\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"status\\\":{\\\"value\\\":\\\"test\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Award Type\\\":{\\\"value\\\":\\\"Awards : Conferred by the State \\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',2.00,443,443,'2025-03-21 14:07:25','2025-03-24 01:06:34',4),(47,443,41,90,'\"{\\\"year\\\":{\\\"value\\\":\\\"2999\\\",\\\"type\\\":\\\"number\\\",\\\"required\\\":true},\\\"award_title\\\":{\\\"value\\\":\\\"djhjhdf\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"status\\\":{\\\"value\\\":\\\"dfh\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Award Type\\\":{\\\"value\\\":\\\"Awards : Recognised International Awards \\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',4.00,443,443,'2025-03-21 14:07:35','2025-03-24 01:06:34',4),(48,443,5,6,'\"{\\\"period\\\":{\\\"value\\\":\\\"7700-3487\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"course_code\\\":{\\\"value\\\":\\\"Test110\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"course_title\\\":{\\\"value\\\":\\\"Test Course\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"num_students\\\":{\\\"value\\\":\\\"77\\\",\\\"type\\\":\\\"number\\\",\\\"required\\\":true},\\\"institution\\\":{\\\"value\\\":\\\"UNZA\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true}}\"',2.50,443,443,'2025-03-21 14:23:17','2025-03-24 01:06:34',4),(49,443,29,32,'\"{\\\"year\\\":{\\\"value\\\":\\\"39847\\\",\\\"type\\\":\\\"number\\\",\\\"required\\\":true},\\\"title\\\":{\\\"value\\\":\\\"drhhej\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"publisher\\\":{\\\"value\\\":\\\"rehj\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"number_of_pages\\\":{\\\"value\\\":\\\"47\\\",\\\"type\\\":\\\"number\\\",\\\"required\\\":true},\\\"Role\\\":{\\\"value\\\":\\\"Books - Co-author\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',4.00,443,443,'2025-03-21 22:03:41','2025-03-24 01:06:34',4),(50,443,29,32,'\"{\\\"year\\\":{\\\"value\\\":\\\"7887\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"title\\\":{\\\"value\\\":\\\"huehj\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"publisher\\\":{\\\"value\\\":\\\"ghgf\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"number_of_pages\\\":{\\\"value\\\":\\\"333\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"Role\\\":{\\\"value\\\":\\\"Books - Co-author\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',4.00,443,443,'2025-03-22 12:13:56','2025-03-24 01:06:34',4),(51,443,25,27,'\"{\\\"year\\\":{\\\"value\\\":\\\"9905\\\",\\\"type\\\":\\\"number\\\",\\\"required\\\":true},\\\"title\\\":{\\\"value\\\":\\\"erje\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"name_of_journal\\\":{\\\"value\\\":\\\"fdf\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Author Type\\\":{\\\"value\\\":\\\"Single author\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',6.00,443,443,'2025-03-24 01:08:24','2025-03-24 01:08:24',NULL),(56,1877,30,39,'\"{\\\"Year\\\":{\\\"value\\\":\\\"2015\\\",\\\"type\\\":\\\"select-one\\\"},\\\"Conference Title\\\":{\\\"value\\\":\\\"hjhjhj\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Country\\\":{\\\"value\\\":\\\"hhh\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Role\\\":{\\\"value\\\":\\\"Conferences & Seminars : Facilitation (maximum of 4 per year)\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',3.00,1877,1877,'2025-03-25 09:16:12','2025-03-25 09:17:02',NULL),(57,1877,35,49,'\"{\\\"Year\\\":{\\\"value\\\":\\\"2019\\\",\\\"type\\\":\\\"select-one\\\"},\\\"H-Index Score\\\":{\\\"value\\\":\\\"15\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false}}\"',0.00,1877,1877,'2025-03-26 15:59:02','2025-03-26 15:59:31',NULL),(58,1877,37,70,'\"{\\\"Year\\\":{\\\"value\\\":\\\"2017\\\",\\\"type\\\":\\\"select-one\\\"},\\\"Project Title\\\":{\\\"value\\\":\\\"Testing Form Fields Editing\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Actual Amount Raised (in Kwacha)\\\":{\\\"value\\\":\\\"40000.00\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"Role\\\":{\\\"value\\\":\\\"Member\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Amount Range\\\":{\\\"value\\\":\\\"Resource Mobilization : Team Member (\\\\u00e2\\\\u2030\\\\u00a51000 but <50,000 Kwacha)\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',1.00,1877,1877,'2025-03-26 16:23:01','2025-03-26 16:24:29',NULL),(59,1877,10,12,'\"{\\\"Candidate\'s Name\\\":{\\\"value\\\":\\\"hggh\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Title of Dissertation\\\":{\\\"value\\\":\\\"ghhgh\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Year of Completion\\\":{\\\"value\\\":\\\"8998\\\",\\\"type\\\":\\\"number\\\",\\\"required\\\":true},\\\"Institution\\\":{\\\"value\\\":\\\"ghgh\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true}}\"',7.50,1877,1877,'2025-03-26 19:57:34','2025-03-26 19:57:34',NULL),(60,1877,10,12,'\"{\\\"Candidate\'s Name\\\":{\\\"value\\\":\\\"uyu\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Title of Dissertation\\\":{\\\"value\\\":\\\"hdfhgd\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Year of Completion\\\":{\\\"value\\\":\\\"9089\\\",\\\"type\\\":\\\"number\\\",\\\"required\\\":true},\\\"Institution\\\":{\\\"value\\\":\\\"hgdf\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true}}\"',7.50,1877,1877,'2025-03-26 19:57:52','2025-03-26 19:57:52',NULL),(61,1877,5,6,'\"{\\\"Period (e.g., 1990 \\\\u2013 2018)\\\":{\\\"value\\\":\\\"2010 - 2015\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Course Code\\\":{\\\"value\\\":\\\"ECO100\\\",\\\"type\\\":\\\"select-one\\\"},\\\"Course Title\\\":{\\\"value\\\":\\\"Principles of Microeconomics\\\",\\\"type\\\":\\\"select-one\\\"},\\\"Number of Students\\\":{\\\"value\\\":\\\"100\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"Institution\\\":{\\\"value\\\":\\\"UNZA\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',2.50,1877,1877,'2025-03-26 19:58:37','2025-03-27 14:23:57',NULL),(65,1877,4,4,'\"{\\\"Year\\\":{\\\"value\\\":\\\"2020\\\",\\\"type\\\":\\\"year\\\",\\\"required\\\":true},\\\"Course Code\\\":{\\\"value\\\":\\\"CHEM101\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Course Title\\\":{\\\"value\\\":\\\"General Chemistry I\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Institution\\\":{\\\"value\\\":\\\"UNZA\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true}}\"',3.25,1877,1877,'2025-03-26 20:22:04','2025-03-26 20:22:04',NULL),(68,1877,3,3,'\"{\\\"Period (e.g., 1990 \\\\u2013 2018)\\\":{\\\"value\\\":\\\"4545\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Course Code\\\":{\\\"value\\\":\\\"PSY100\\\",\\\"type\\\":\\\"select-one\\\"},\\\"Course Title\\\":{\\\"value\\\":\\\"Introduction to Psychology\\\",\\\"type\\\":\\\"select-one\\\"},\\\"Total Number of Lecturers Who Co-Taught the Course\\\":{\\\"value\\\":\\\"4\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"Institution\\\":{\\\"value\\\":\\\"UNZA\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',0.00,1877,1877,'2025-03-26 21:45:54','2025-03-27 14:24:25',NULL),(69,1877,30,38,'\"{\\\"Year\\\":{\\\"value\\\":\\\"2011\\\",\\\"type\\\":\\\"select-one\\\"},\\\"Conference Title\\\":{\\\"value\\\":\\\"Test COuntries\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Country\\\":{\\\"value\\\":\\\"ANDORRA\\\",\\\"type\\\":\\\"select-one\\\"},\\\"Role\\\":{\\\"value\\\":\\\"Conferences & Seminars : Plenary\\\\/Keynote speaker (maximum of 4 per year)\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',4.00,1877,1877,'2025-03-26 22:04:17','2025-03-26 22:17:11',NULL),(70,1877,30,37,'\"{\\\"Year\\\":{\\\"value\\\":\\\"2016\\\",\\\"type\\\":\\\"year\\\",\\\"required\\\":true},\\\"Conference Title\\\":{\\\"value\\\":\\\"yuuyyu\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Country\\\":{\\\"value\\\":\\\"BAHRAIN\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Role\\\":{\\\"value\\\":\\\"Conferences & Seminars : Conference paper\\\\/Multimedia \\\\/ Poster presentation\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',3.50,1877,1877,'2025-03-26 22:17:45','2025-03-26 22:17:45',NULL),(71,443,48,103,'\"{\\\"Start Date\\\":{\\\"value\\\":\\\"2025-03-04\\\",\\\"type\\\":\\\"date\\\",\\\"required\\\":true},\\\"End Date\\\":{\\\"value\\\":\\\"2025-03-14\\\",\\\"type\\\":\\\"date\\\",\\\"required\\\":true},\\\"Organisation\\\":{\\\"value\\\":\\\"hjdfjh\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Province\\\":{\\\"value\\\":\\\"NORTHERN\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Position\\\":{\\\"value\\\":\\\"Service to Society (Non Statutory Organizations ) - Secretary \\\\/ Official \\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',0.01,443,443,'2025-03-27 07:20:00','2025-03-27 07:20:00',NULL),(72,1877,22,24,'\"{\\\"Year\\\":{\\\"value\\\":\\\"2000\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"Course Code\\\":{\\\"value\\\":\\\"BIO101\\\",\\\"type\\\":\\\"select-one\\\"},\\\"Score\\\":{\\\"value\\\":\\\"55\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false}}\"',0.00,1877,1877,'2025-03-27 14:25:45','2025-03-27 14:26:26',NULL),(73,1877,6,7,'\"{\\\"Period (e.g., 1990 \\\\u2013 2018)\\\":{\\\"value\\\":\\\"2000 - 2005\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Course Code\\\":{\\\"value\\\":\\\"STAT101\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"Course Title\\\":{\\\"value\\\":\\\"Statistics for Beginners\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"Number of Students\\\":{\\\"value\\\":\\\"700\\\",\\\"type\\\":\\\"number\\\",\\\"readonly\\\":false},\\\"Institution\\\":{\\\"value\\\":\\\"Test\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',2.50,1877,1877,'2025-03-27 14:27:59','2025-03-27 20:55:45',NULL),(74,1877,36,50,'\"{\\\"Start Date\\\":{\\\"value\\\":\\\"2025-03-11\\\",\\\"type\\\":\\\"date\\\",\\\"readonly\\\":false},\\\"End Date\\\":{\\\"value\\\":\\\"2025-03-31\\\",\\\"type\\\":\\\"date\\\",\\\"readonly\\\":false},\\\"Department\\\":{\\\"value\\\":\\\"SOIL SCIENCE\\\",\\\"type\\\":\\\"select-one\\\"},\\\"Unit\\\":{\\\"value\\\":\\\"AGRICULTURAL SCIENCES\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true},\\\"Position\\\":{\\\"value\\\":\\\"Vice Chancellor \\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',0.19,1877,1877,'2025-03-27 15:04:36','2025-03-27 15:07:32',NULL),(76,1877,2,2,'\"{\\\"Period (e.g., 1990 \\\\u2013 2018)\\\":{\\\"value\\\":\\\"2000\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Course Code\\\":{\\\"value\\\":\\\"SOC101\\\",\\\"type\\\":\\\"select-one\\\"},\\\"Course Title\\\":{\\\"value\\\":\\\"Introduction to Sociology\\\",\\\"type\\\":\\\"select-one\\\"},\\\"Institution\\\":{\\\"value\\\":\\\"UNZA\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',2.25,1877,1877,'2025-03-27 16:10:14','2025-03-27 16:10:33',NULL),(77,1877,41,90,'\"{\\\"Year\\\":{\\\"value\\\":\\\"2013\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Award Title\\\":{\\\"value\\\":\\\"hfhd\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Status\\\":{\\\"value\\\":\\\"herhjrehj\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Award Type\\\":{\\\"value\\\":\\\"Awards : Recognised International Awards \\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',4.00,1877,1877,'2025-03-27 19:09:23','2025-03-27 19:09:59',NULL),(78,1877,42,93,'\"{\\\"Year\\\":{\\\"value\\\":\\\"2013\\\",\\\"type\\\":\\\"year\\\",\\\"required\\\":true},\\\"Project Title\\\":{\\\"value\\\":\\\"hjeerjh\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Role\\\":{\\\"value\\\":\\\"erhj\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Organisation\\\":{\\\"value\\\":\\\"erhj\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Consultancy Type\\\":{\\\"value\\\":\\\"Consultancy : University sourced per consultancy completed\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',0.50,1877,1877,'2025-03-27 19:10:16','2025-03-27 19:10:16',NULL),(79,1877,36,50,'\"{\\\"Start Date\\\":{\\\"value\\\":\\\"2025-02-26\\\",\\\"type\\\":\\\"date\\\",\\\"required\\\":true},\\\"End Date\\\":{\\\"value\\\":\\\"2025-03-03\\\",\\\"type\\\":\\\"date\\\",\\\"required\\\":true},\\\"Department\\\":{\\\"value\\\":\\\"PLANT SCIENCE\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":false},\\\"Unit\\\":{\\\"value\\\":\\\"AGRICULTURAL SCIENCES\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":false},\\\"Position\\\":{\\\"value\\\":\\\"Vice Chancellor \\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',0.05,1877,1877,'2025-03-27 19:36:42','2025-03-27 19:36:42',NULL),(80,1877,4,4,'\"{\\\"Year\\\":{\\\"value\\\":\\\"2016\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false},\\\"Course Code\\\":{\\\"value\\\":\\\"BIO101\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"Course Title\\\":{\\\"value\\\":\\\"Biology I\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"Institution\\\":{\\\"value\\\":\\\"yuhjh\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',3.25,1877,1877,'2025-03-27 19:37:19','2025-03-27 19:37:36',NULL),(81,1877,48,102,'\"{\\\"Start Date\\\":{\\\"value\\\":\\\"2025-02-25\\\",\\\"type\\\":\\\"date\\\",\\\"required\\\":true},\\\"End Date\\\":{\\\"value\\\":\\\"2025-03-20\\\",\\\"type\\\":\\\"date\\\",\\\"required\\\":true},\\\"Organisation\\\":{\\\"value\\\":\\\"dhjfhj\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Province\\\":{\\\"value\\\":\\\"SOUTHERN\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Position\\\":{\\\"value\\\":\\\"Service to Society (Non Statutory Organizations ) - Chairperson \\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',0.03,1877,1877,'2025-03-27 20:08:03','2025-03-27 20:08:03',NULL),(82,1877,40,87,'\"{\\\"Start Date\\\":{\\\"value\\\":\\\"2025-03-04\\\",\\\"type\\\":\\\"date\\\",\\\"required\\\":true},\\\"End Date\\\":{\\\"value\\\":\\\"2025-03-28\\\",\\\"type\\\":\\\"date\\\",\\\"required\\\":true},\\\"Organisation\\\":{\\\"value\\\":\\\"ggh\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Country\\\":{\\\"value\\\":\\\"BARBADOS\\\",\\\"type\\\":\\\"text\\\",\\\"required\\\":true},\\\"Position\\\":{\\\"value\\\":\\\"Secondment at National\\\\/International Level Organization - Above Director\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":true}}\"',0.10,1877,1877,'2025-03-27 20:09:20','2025-03-27 20:09:20',NULL),(83,1877,4,4,'\"{\\\"Year\\\":{\\\"value\\\":\\\"2024\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"Course Code\\\":{\\\"value\\\":\\\"PHY101\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"Course Title\\\":{\\\"value\\\":\\\"Physics I\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"Institution\\\":{\\\"value\\\":\\\"jdhjdf\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',3.25,1877,1877,'2025-03-27 20:10:30','2025-03-27 20:17:34',NULL),(84,1877,8,10,'\"{\\\"Year\\\":{\\\"value\\\":\\\"2023\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"Course Code\\\":{\\\"value\\\":\\\"PSY100\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"Course Title\\\":{\\\"value\\\":\\\"Introduction to Psychology\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"Institution\\\":{\\\"value\\\":\\\"The University of Zambia\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',4.50,1877,1877,'2025-03-27 20:56:45','2025-03-27 23:28:45',NULL),(86,1877,8,10,'\"{\\\"Year\\\":{\\\"value\\\":\\\"2014\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"Course Code\\\":{\\\"value\\\":\\\"MATH300\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"Course Title\\\":{\\\"value\\\":\\\"Calculus I\\\",\\\"type\\\":\\\"select-one\\\",\\\"readonly\\\":false},\\\"Institution\\\":{\\\"value\\\":\\\"CBU\\\",\\\"type\\\":\\\"text\\\",\\\"readonly\\\":false}}\"',4.50,1877,1877,'2025-03-27 21:29:04','2025-03-27 21:48:09',NULL);
/*!40000 ALTER TABLE `asp_lecturer_qualifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_other_professional_qualifications`
--

DROP TABLE IF EXISTS `asp_other_professional_qualifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_other_professional_qualifications` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `year_awarded` year DEFAULT NULL,
  `professional_qualification` varchar(255) DEFAULT NULL,
  `institution` varchar(255) DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `asp_other_professional_qualifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_other_professional_qualifications_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_other_professional_qualifications_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_other_professional_qualifications`
--

LOCK TABLES `asp_other_professional_qualifications` WRITE;
/*!40000 ALTER TABLE `asp_other_professional_qualifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `asp_other_professional_qualifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_point_scoring_formulas`
--

DROP TABLE IF EXISTS `asp_point_scoring_formulas`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_point_scoring_formulas` (
  `id` int NOT NULL AUTO_INCREMENT,
  `formula_category_id` int unsigned DEFAULT NULL,
  `form_inputs_id` int DEFAULT NULL,
  `qualification_description` varchar(100) DEFAULT NULL,
  `weight` decimal(4,2) DEFAULT NULL,
  `string_formular` varchar(250) DEFAULT NULL,
  `input_fields` json DEFAULT NULL,
  `full_qualification_description` text,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `fk_formula_categories` (`formula_category_id`),
  KEY `fk_form_inputs` (`form_inputs_id`),
  CONSTRAINT `asp_point_scoring_formulas_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_point_scoring_formulas_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `fk_form_inputs` FOREIGN KEY (`form_inputs_id`) REFERENCES `asp_form_inputs` (`id`),
  CONSTRAINT `fk_formula_categories` FOREIGN KEY (`formula_category_id`) REFERENCES `asp_formula_categories` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_point_scoring_formulas`
--

LOCK TABLES `asp_point_scoring_formulas` WRITE;
/*!40000 ALTER TABLE `asp_point_scoring_formulas` DISABLE KEYS */;
INSERT INTO `asp_point_scoring_formulas` VALUES (1,1,NULL,'Years of service (quantity = per year teaching)',3.00,'( years_of_service * weight )',NULL,'Years of service (quantity = per year teaching)',450,3,'2024-12-08 07:35:07',NULL),(2,2,105,'Course taught per year alone (undergraduate) ',4.50,'( course_weight * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the undergraduate courses you have taught since you started lecturing at the University of Zambia, indicate the year, course and total title, and the institution where the courses were taught. The years should be reported chronologically: the most recent should be reported first; and the first one, last. Please report the current course codes even if the course codes have changed over time.\", \"required\": true}, {\"name\": \"period\", \"type\": \"text\", \"label\": \"Period (e.g., 1990 – 2018)\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Courses Taught (Undergraduate) - Individual\"}','Course taught per year alone (undergraduate) (quantity = 1 for full course & 0.5 for half course)',450,3,'2024-12-08 07:35:07',NULL),(3,3,106,'Course co-taught per year (undergraduate) ',4.50,'( ( course_weight / total_course_lecturers ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the undergraduate courses you have taught since you started lecturing at the University of Zambia, indicate the year, course code and title, and the institution where the course is very taught. The years should be reported chronologically; the most recent should be reported first; and the first one, last. Please report the current course codes even if the course codes have changed over time.\", \"required\": true}, {\"name\": \"period\", \"type\": \"text\", \"label\": \"Period (e.g., 1990 – 2018)\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"total_course_lecturers\", \"type\": \"number\", \"label\": \"Total Number of Lecturers Who Co-Taught the Course\", \"required\": true, \"validation\": {\"min\": 1}}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Courses Taught (Undergraduate) - Group\"}','Course co-taught per year (undergraduate) (quantity = 1 for full course & 0.5 for half course) - The formula for computing weighting for a co-taught is: Total weight of a course divided by the number of people who co-taught the course',450,3,'2024-12-08 07:35:07',NULL),(4,4,107,'Course taught per year alone (postgraduate) ',6.50,'course_weight * weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the postgraduate courses you have taught since you started lecturing at the University of Zambia. Indicate the year, course code and title, and the institution where the courses were taught. The years should be reported chronologically: the most recent should be reported first, and the first one, last. Please report the current course codes even if the course codes have changed over time.\", \"required\": true}, {\"name\": \"year\", \"type\": \"text\", \"label\": \"Year\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Courses Taught (Postgraduate) - Individual\"}','Course taught per year alone (postgraduate) (quantity = 1 for full course & 0.5 for half course)',450,3,'2024-12-08 07:35:07',NULL),(5,49,108,'Course co-taught per year (postgraduate)',6.50,'( ( course_weight / total_course_lecturers ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the postgraduate courses you have taught since you started lecturing at the University of Zambia. Indicate the year, course code and title, and the institution where the courses were taught. The years should be reported chronologically; the most recent should be reported first; and the first one, last. Please report the current course codes even if the course codes have changed over time.\", \"required\": true}, {\"name\": \"period\", \"type\": \"text\", \"label\": \"Period (e.g., 1990 – 2018)\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"total_course_lecturers\", \"type\": \"number\", \"label\": \"Total Number of Lecturers Who Co-Taught the Course\", \"required\": true, \"validation\": {\"min\": 1}}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Courses Taught (Postgraduate) - Group\"}','Course taught per year alone (postgraduate) (quantity = 1 for full course & 0.5 for half course) - The formula for computing weighting for a co-taught is: Total weight of a course divided by the number of people who co-taught the course',450,3,'2024-12-08 07:35:07',NULL),(6,5,109,'Teaching >76 students per year',2.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the undergraduate courses you have taught with more than 75 students in the course since you started lecturing at the University of Zambia. Indicate the year, course code and title, and the institution where the courses were taught. The years should be reported chronologically; the most recent should be reported first; and the first one, last. Please report the current course codes even if the course codes have changed over time.\", \"required\": true}, {\"name\": \"period\", \"type\": \"text\", \"label\": \"Period (e.g., 1990 – 2018)\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"num_students\", \"type\": \"number\", \"label\": \"Number of Students\", \"required\": true, \"validation\": {\"min\": 76}}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Class Size (Teaching >76 Students per Year)\"}','Teaching >76 students per year (quantity = years with overload)',450,3,'2024-12-08 07:35:07',NULL),(7,6,110,'Course coordinator (maximum of two courses per year)',2.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the undergraduate courses you have coordinated since you started lecturing at the University of Zambia. Indicate the year, course code and title, and the institution where the courses were taught. The years should be reported chronologically: the most recent should be reported first; and the first one, last. Please report the current course codes even if the course codes have changed over time.\", \"required\": true}, {\"name\": \"period\", \"type\": \"text\", \"label\": \"Period (e.g., 1990 – 2018)\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"num_students\", \"type\": \"number\", \"label\": \"Number of Students\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Course Coordination (Maximum of Two Courses per Year)\"}','Course coordinator (maximum of two courses per year)',450,3,'2024-12-08 07:35:07',NULL),(8,7,105,'New Approved complete course module / courses per year (individual)',5.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the undergraduate courses you have taught since you started lecturing at the University of Zambia, indicate the year, course and total title, and the institution where the courses were taught. The years should be reported chronologically: the most recent should be reported first; and the first one, last. Please report the current course codes even if the course codes have changed over time.\", \"required\": true}, {\"name\": \"period\", \"type\": \"text\", \"label\": \"Period (e.g., 1990 – 2018)\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Courses Taught (Undergraduate) - Individual\"}','New Approved complete course module / courses per year (individual)',450,3,'2024-12-08 07:35:07',NULL),(9,47,111,'Professional Qualifications (quantity = per qualification)',0.50,'-','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the courses you have designed alone since you started lecturing at the University of Zambia. Indicate the year, course code and title, and the institution where the courses were designed. The years should be reported chronologically; the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Approved Courses (Individual)\"}','Professional Qualifications (quantity = per qualification)',450,3,'2024-12-08 07:35:07',NULL),(10,8,112,'New Approved complete course module / courses per year (group)',4.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the courses you have designed together with other members of staff since you started lecturing at the University of Zambia. Indicate the year, course code and title, and the institution where the courses were designed. The years should be reported chronologically; the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"course_title\", \"type\": \"text\", \"label\": \"Course Title\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"New Approved Complete Course Module / Courses per Year (Group)\"}','New Approved complete course module / courses per year (group)',450,3,'2024-12-08 07:35:07',NULL),(11,9,113,'Postgraduate Supervision (Doctorate) : Supervisor per year',10.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the doctoral dissertations/theses you have successfully supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Doctorate) - Supervisor per Year\"}','Supervisor per year',450,3,'2024-12-08 07:35:07',NULL),(12,10,114,'Postgraduate Supervision (Doctorate) : Co-supervisor per year',7.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the doctoral dissertations/theses you have successfully co-supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Doctorate) - Co-supervisor per Year\"}','Co-supervisor per year',450,3,'2024-12-08 07:35:08',NULL),(13,11,115,'Postgraduate Supervision (Doctorate) : Chair of Board of Examiners',2.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the doctoral dissertation/thesis presentations or viva voce examinations you have chaired at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Doctorate) - Chair of Board of Examiners\"}','Chair of Board of Examiners',450,3,'2024-12-08 07:35:08',NULL),(14,12,116,'Postgraduate Supervision (Doctorate) : Thesis examiner',3.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the doctoral dissertations/theses you have successfully examined at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Doctorate) - Thesis Examiner\"}','Thesis examiner',450,3,'2024-12-08 07:35:08',NULL),(15,13,117,'Postgraduate Supervision (Masters) : Supervisor for master\'s with thesis per year',6.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the master’s dissertations/theses you have successfully supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Masters) - Supervisor for Master’s with Thesis per Year\"}','Supervisor for master\'s with thesis per year',450,3,'2024-12-08 07:35:08',NULL),(16,14,118,'Postgraduate Supervision (Masters) : Supervisor for master\'s without thesis per year',3.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the master’s dissertations/theses you have successfully co-supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Masters) - Supervisor for masters without thesis p\"}','Supervisor for master\'s without thesis per year',450,3,'2024-12-08 07:35:08',NULL),(17,15,119,'Postgraduate Supervision (Masters) : Supervisor for master\'s outside area of specialisation',3.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the master’s dissertations/theses you have successfully supervised outside your area of specialisation at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Masters) - Supervisor for Master\'s Outside Area of Specialisation\"}','Supervisor for master\'s outside area of specialisation',450,3,'2024-12-08 07:35:08',NULL),(18,16,120,'Postgraduate Supervision (Masters) : Co-supervisor per year',3.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the master’s dissertations/theses you have successfully co-supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Masters) - Co-supervisor per Year\"}','Co-supervisor per year',450,3,'2024-12-08 07:35:08',NULL),(19,17,121,'Postgraduate Supervision (Masters) : Thesis examiner',2.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the master’s dissertations/theses you have successfully examined at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Masters) - Thesis Examiner\"}','Thesis examiner',450,3,'2024-12-08 07:35:08',NULL),(20,18,122,'Postgraduate Supervision (Diploma) : Supervisor per year',2.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the diploma dissertations/theses/reports you have successfully supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Diploma) - Supervisor per Year\"}','Supervisor per year',450,3,'2024-12-08 07:35:08',NULL),(21,19,123,'Postgraduate Supervision (Diploma) : Co-Supervisor per year',1.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the diploma dissertations/theses/reports you have successfully co-supervised at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Diploma) - Co-Supervisor per Year\"}','Co-Supervisor per year',450,3,'2024-12-08 07:35:08',NULL),(22,20,124,'Postgraduate Supervision (Diploma) : Thesis examiner',0.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report all the diploma dissertations/theses/reports you have successfully examined at the University of Zambia and other recognized institutions of higher learning. Only completed work should be reported. The years should be reported chronologically: the most recent should be reported first; and the first one, last.\", \"required\": true}, {\"name\": \"candidate_name\", \"type\": \"text\", \"label\": \"Candidate\'s Name\", \"required\": true}, {\"name\": \"title_of_dissertation\", \"type\": \"text\", \"label\": \"Title of Dissertation\", \"required\": true}, {\"name\": \"year_of_completion\", \"type\": \"number\", \"label\": \"Year of Completion\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Postgraduate Supervision (Diploma) - Thesis Examiner\"}','Thesis examiner',450,3,'2024-12-08 07:35:08',NULL),(23,21,125,'Teaching Evaluation : Score per year (Student Evaluation)',5.00,'-','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Information will be inserted by the Head of Department from the Student Evaluation Questionnaire.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"score\", \"type\": \"number\", \"label\": \"Score\", \"required\": true}], \"form_description\": \"Teaching Evaluation - Score per Year (Student Evaluation)\"}','Score per year (Student Evaluation) (quantity = average % evaluation, score weight x quantity x years of service)',450,3,'2024-12-08 07:35:08',NULL),(24,22,126,'Teaching Evaluation : Score per year (Supervisor Evaluation) ',4.00,'-','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Information will be inserted by the Head of Department from the Performance Appraisal Questionnaire.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"course_code\", \"type\": \"text\", \"label\": \"Course Code\", \"required\": true}, {\"name\": \"score\", \"type\": \"number\", \"label\": \"Score\", \"required\": true}], \"form_description\": \"Teaching Evaluation - Score per Year (Supervisor Evaluation)\"}','Score per year (Supervisor Evaluation) (quantity = average % evaluation, score weight x quantity x years of service)',450,3,'2024-12-08 07:35:08',NULL),(25,23,127,'Single author',7.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report only peer-reviewed journals here. Verify the status of the journal from websites such as Scopus or Web of Science or from your departmental inventory of peer-reviewed journals.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Author Type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"name_of_journal\", \"type\": \"text\", \"label\": \"Name of Journal\", \"required\": true}], \"form_description\": \"Peer-Reviewed Journal Publications - Single Author\"}','Peer-Reviewed Journal Publications - Single author',450,3,'2024-12-08 07:35:08',NULL),(26,23,127,'Multiple authors',3.75,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report only peer-reviewed journals here. Verify the status of the journal from websites such as Scopus or Web of Science or from your departmental inventory of peer-reviewed journals.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Author Type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"name_of_journal\", \"type\": \"text\", \"label\": \"Name of Journal\", \"required\": true}], \"form_description\": \"Peer-Reviewed Journal Publications - Single Author\"}','Peer-Reviewed Journal Publications - Multiple authors',450,3,'2024-12-08 07:35:08',NULL),(27,25,128,'Single author',6.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any article you have published in peer-reviewed conference papers.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Author Type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"name_of_journal\", \"type\": \"text\", \"label\": \"Name of Journal\", \"required\": true}], \"form_description\": \"Peer-Reviewed Proceedings (National & International) - Single Author\"}','Peer-Reviewed Proceedings (National & International) - Single author',450,3,'2024-12-08 07:35:08',NULL),(28,25,128,'Multiple authors',3.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any article you have published in peer-reviewed conference papers.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Author Type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"name_of_journal\", \"type\": \"text\", \"label\": \"Name of Journal\", \"required\": true}], \"form_description\": \"Peer-Reviewed Proceedings (National & International) - Single Author\"}','Peer-Reviewed Proceedings (National & International) - Multiple authors',450,3,'2024-12-08 07:35:08',NULL),(29,27,129,'Non-peer-reviewed Journal Publications - Author, lead author or Co-author',3.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any journals you have published here. The journals need not be peer-reviewed.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"name_of_journal\", \"type\": \"text\", \"label\": \"Name of Journal\", \"required\": true}], \"form_description\": \"Non-Peer-Reviewed Journal Publications - Author, Lead Author, or Co-author\"}','Non-peer-reviewed Journal Publications - Author, lead author or Co-author',450,3,'2024-12-08 07:35:08',NULL),(30,28,130,'Commissioned Research Report - Completed research',6.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"This is research, survey, or other work, the costs of which are wholly paid for by the customer and carried out in cooperation with industry. Report any research report you have written for international organisations, government, non-governmental organisations for which you received payment.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"name_of_journal\", \"type\": \"text\", \"label\": \"Name of Journal\", \"required\": true}], \"form_description\": \"Commissioned Research Report\"}','Commissioned Research Report - Completed research (quantity = per completed research acknowledged by commissioner)',450,3,'2024-12-08 07:35:08',NULL),(31,29,131,'Books - Single author',8.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any books you have published here. This includes training manuals, textbooks, and creative works such as novels.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"publisher\", \"type\": \"text\", \"label\": \"Publisher\", \"required\": true}, {\"name\": \"number_of_pages\", \"type\": \"number\", \"label\": \"Number of Pages\", \"required\": true}], \"form_description\": \"Books\"}','Books - Single author',450,3,'2024-12-08 07:35:08',NULL),(32,29,131,'Books - Co-author',4.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any books you have published here. This includes training manuals, textbooks, and creative works such as novels.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"publisher\", \"type\": \"text\", \"label\": \"Publisher\", \"required\": true}, {\"name\": \"number_of_pages\", \"type\": \"number\", \"label\": \"Number of Pages\", \"required\": true}], \"form_description\": \"Books\"}','Books - Co-author',450,3,'2024-12-08 07:35:08',NULL),(33,29,131,'Books - Lead author with others',4.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any books you have published here. This includes training manuals, textbooks, and creative works such as novels.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"publisher\", \"type\": \"text\", \"label\": \"Publisher\", \"required\": true}, {\"name\": \"number_of_pages\", \"type\": \"number\", \"label\": \"Number of Pages\", \"required\": true}], \"form_description\": \"Books\"}','Books - Lead author with others',450,3,'2024-12-08 07:35:08',NULL),(34,29,131,'Books - Chapters in a book (Per book)',4.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any books you have published here. This includes training manuals, textbooks, and creative works such as novels.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"publisher\", \"type\": \"text\", \"label\": \"Publisher\", \"required\": true}, {\"name\": \"number_of_pages\", \"type\": \"number\", \"label\": \"Number of Pages\", \"required\": true}], \"form_description\": \"Books\"}','Books - Chapters in a book (Per book)',450,3,'2024-12-08 07:35:08',NULL),(35,29,131,'Books - Editor',4.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any books you have published here. This includes training manuals, textbooks, and creative works such as novels.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"publisher\", \"type\": \"text\", \"label\": \"Publisher\", \"required\": true}, {\"name\": \"number_of_pages\", \"type\": \"number\", \"label\": \"Number of Pages\", \"required\": true}], \"form_description\": \"Books\"}','Books - Editor',450,3,'2024-12-08 07:35:08',NULL),(36,29,131,'Books - Creative writing',3.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any books you have published here. This includes training manuals, textbooks, and creative works such as novels.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"publisher\", \"type\": \"text\", \"label\": \"Publisher\", \"required\": true}, {\"name\": \"number_of_pages\", \"type\": \"number\", \"label\": \"Number of Pages\", \"required\": true}], \"form_description\": \"Books\"}','Books - Creative writing',450,3,'2024-12-08 07:35:08',NULL),(37,30,132,'Conferences & Seminars : Conference paper/Multimedia / Poster presentation',3.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any conferences, seminars, workshops, or symposia you have participated in. Also indicate your role/capacity at the conference, for example, as a keynote speaker, presenter of a paper, rapporteur, discussant, facilitator/resource person, or attendee.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"conference_title\", \"type\": \"text\", \"label\": \"Conference Title\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Academic / Professional Conference, Seminar, Workshop, Symposia\"}','Conference paper/Multimedia / Poster presentation',450,3,'2024-12-08 07:35:08',NULL),(38,30,132,'Conferences & Seminars : Plenary/Keynote speaker (maximum of 4 per year)',4.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any conferences, seminars, workshops, or symposia you have participated in. Also indicate your role/capacity at the conference, for example, as a keynote speaker, presenter of a paper, rapporteur, discussant, facilitator/resource person, or attendee.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"conference_title\", \"type\": \"text\", \"label\": \"Conference Title\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Academic / Professional Conference, Seminar, Workshop, Symposia\"}','Plenary/Keynote speaker (maximum of 4 per year)',450,3,'2024-12-08 07:35:08',NULL),(39,30,132,'Conferences & Seminars : Facilitation (maximum of 4 per year)',3.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any conferences, seminars, workshops, or symposia you have participated in. Also indicate your role/capacity at the conference, for example, as a keynote speaker, presenter of a paper, rapporteur, discussant, facilitator/resource person, or attendee.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"conference_title\", \"type\": \"text\", \"label\": \"Conference Title\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Academic / Professional Conference, Seminar, Workshop, Symposia\"}','Facilitation (maximum of 4 per year)',450,3,'2024-12-08 07:35:08',NULL),(40,30,132,'Conferences & Seminars : Attendance at International Conferences, Seminars, Workshops, Symposia',1.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any conferences, seminars, workshops, or symposia you have participated in. Also indicate your role/capacity at the conference, for example, as a keynote speaker, presenter of a paper, rapporteur, discussant, facilitator/resource person, or attendee.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"conference_title\", \"type\": \"text\", \"label\": \"Conference Title\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Academic / Professional Conference, Seminar, Workshop, Symposia\"}','Attendance at International Conferences, Seminars, Workshops, Symposia',450,3,'2024-12-08 07:35:08',NULL),(41,31,133,'Patents & Prototypes : Patents',9.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any patents, inventions, prototypes, or artefacts to your credit. Indicate your role as inventor, partner, or assistant.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Type of Artifact\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Patents, Prototypes & Artefacts\"}','Patents',450,3,'2024-12-08 07:35:08',NULL),(42,31,133,'Patents & Prototypes : Prototypes, artefacts & artistic outputs',6.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any patents, inventions, prototypes, or artefacts to your credit. Indicate your role as inventor, partner, or assistant.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Type of Artifact\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Patents, Prototypes & Artefacts\"}','Prototypes, artefacts & artistic outputs',450,3,'2024-12-08 07:35:08',NULL),(43,32,134,'Media Discussions : Scholarly & creative contribution to media (maximum of 3 per year)',1.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any scholarly articles written in newspapers and magazines or any scholarly discussions or presentations on radio, internet, or television.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"title\", \"type\": \"text\", \"label\": \"Title\", \"required\": true}, {\"name\": \"name_of_media\", \"type\": \"text\", \"label\": \"Name of Paper/Magazine/Radio/TV\", \"required\": true}], \"form_description\": \"Media Discussions\"}','Scholarly & creative contribution to newspapers, magazines, radio & television (maximum of 3 per year)',450,3,'2024-12-08 07:35:08',NULL),(44,33,135,'Journal Refereeing & Editing : Chairperson of Editorial Board ',1.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report your role in journal refereeing and editing. Indicate your role (e.g., Chairperson of Editorial Board, Member Editorial Board, Reviewer) and the duration of your involvement.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}], \"form_description\": \"Journal Refection & Editing\"}','Chairperson of Editorial Board (Quantity = time units (days/months) at that level)',450,3,'2024-12-08 07:35:08',NULL),(45,33,135,'Journal Refereeing & Editing : Member Editorial Board ',1.00,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report your role in journal refereeing and editing. Indicate your role (e.g., Chairperson of Editorial Board, Member Editorial Board, Reviewer) and the duration of your involvement.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}], \"form_description\": \"Journal Refection & Editing\"}','Member Editorial Board (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(46,33,135,'Journal Refereeing & Editing : Reviewing and refereeing of published article, conference paper, Book',1.00,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report your role in journal refereeing and editing. Indicate your role (e.g., Chairperson of Editorial Board, Member Editorial Board, Reviewer) and the duration of your involvement.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}], \"form_description\": \"Journal Refection & Editing\"}','Reviewing and refereeing of published article, conference paper, Book',450,450,'2024-12-08 07:35:08',NULL),(47,34,136,'Post-Doctoral Research : Visiting fellow (quantity = per research)',10.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the research conducted and the name of your mentor during the postdoctoral stint.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"research_done\", \"type\": \"text\", \"label\": \"Research Done\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}, {\"name\": \"mentor\", \"type\": \"text\", \"label\": \"Mentor\", \"required\": true}], \"form_description\": \"Post-Doctoral Research\"}','Visiting fellow (quantity = per research)',450,450,'2024-12-08 07:35:08',NULL),(48,34,136,'Post-Doctoral Research : Ordinary postdoctoral (quantity = per research)',5.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report the research conducted and the name of your mentor during the postdoctoral stint.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Role\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"research_done\", \"type\": \"text\", \"label\": \"Research Done\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}, {\"name\": \"mentor\", \"type\": \"text\", \"label\": \"Mentor\", \"required\": true}], \"form_description\": \"Post-Doctoral Research\"}','Ordinary postdoctoral (quantity = per research)',450,450,'2024-12-08 07:35:08',NULL),(49,35,137,'Scholarly Rating : H-Index',6.50,'-','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Leave this section blank. Information will be inserted by the Head of Department from Google Scholar or other relevant sources. The Head of Department should record the number of years between the first citation and the current year.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"h_index_score\", \"type\": \"number\", \"label\": \"H-Index Score\", \"required\": true}], \"form_description\": \"Scholarly Rating - H-Index\"}','H-Index',450,450,'2024-12-08 07:35:08',NULL),(50,36,138,'Vice Chancellor ',3.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Vice Chancellor (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(51,36,138,'Deputy Vice Chancellor',2.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Deputy Vice Chancellor (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(52,36,138,'Registrar/Bursar / Librarian / Dean of Student Affairs',2.00,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Registrar/Bursar / Librarian / Dean of Student Affairs (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(53,36,138,'Dean /Director or equivalent',2.00,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Dean /Director or equivalent (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(54,36,138,'Head of Department',2.00,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Head of Department (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(55,36,138,'Assistant Dean ',1.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Assistant Dean (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(56,36,138,'Union Executive - President/General Secretary/Treasurer ',2.00,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Union Executive - President/General Secretary/Treasurer (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(57,36,138,'Council Member ',2.00,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Council Member (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(58,36,138,'Senate Member',1.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Senate Member (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(59,36,138,'Council Standing Committee Member ',2.00,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Council Standing Committee Member (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(60,36,138,'Council Ad-hoc Committee / Bargaining Unit (Quantity = time units (days/months) at that level)',1.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Council Ad-hoc Committee / Bargaining Unit (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(61,36,138,'Management Appointed Committee Member / External Assessor ',0.80,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Management Appointed Committee Member / External Assessor (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(62,36,138,'Committee / Board Membership to UNZA-Based Organisations - Patron/Chairperson/Secretary/Treasurer',0.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Committee / Board Membership to UNZA-Based Organisations - Patron/Chairperson/Secretary/Treasurer (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(63,36,138,'Committee / Board Membership to UNZA-Based Organisations ',0.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Committee / Board Membership to UNZA-Based Organisations (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(64,36,138,'Other administrative University responsibilities',0.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any activity or responsibility you have performed apart from your normal academic duties. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}], \"form_description\": \"University Leadership & Administration\"}','Other administrative University responsibilities',450,450,'2024-12-08 07:35:08',''),(65,37,139,'Resource Mobilization : Team leader (â‰¥1000 but <50,000 Kwacha)',1.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any participation in any fund-raising activities done on behalf of the University. Also indicate the amount raised and your role - as a team leader or member - of the fund-raising activity.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Amount Range\", \"options\": [], \"required\": true}, {\"name\": \"amount_raised\", \"type\": \"number\", \"label\": \"Actual Amount Raised (in Kwacha)\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Resource Mobilisation\"}','Team leader (â‰¥1000 but <50,000 Kwacha)',450,450,'2024-12-08 07:35:08',NULL),(66,37,139,'Resource Mobilization : Team leader (â‰¥50,000 but <250,000 Kwacha)',2.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any participation in any fund-raising activities done on behalf of the University. Also indicate the amount raised and your role - as a team leader or member - of the fund-raising activity.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Amount Range\", \"options\": [], \"required\": true}, {\"name\": \"amount_raised\", \"type\": \"number\", \"label\": \"Actual Amount Raised (in Kwacha)\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Resource Mobilisation\"}','Team leader (â‰¥50,000 but <250,000 Kwacha)',450,450,'2024-12-08 07:35:08',NULL),(67,37,139,'Resource Mobilization : Team leader (â‰¥250,000 but <1,000,000 Kwacha)',3.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any participation in any fund-raising activities done on behalf of the University. Also indicate the amount raised and your role - as a team leader or member - of the fund-raising activity.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Amount Range\", \"options\": [], \"required\": true}, {\"name\": \"amount_raised\", \"type\": \"number\", \"label\": \"Actual Amount Raised (in Kwacha)\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Resource Mobilisation\"}','Team leader (â‰¥250,000 but <1,000,000 Kwacha)',450,450,'2024-12-08 07:35:08',NULL),(68,37,139,'Resource Mobilization : Team leader (â‰¥1,000,000 but <5,000,000 Kwacha)',4.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any participation in any fund-raising activities done on behalf of the University. Also indicate the amount raised and your role - as a team leader or member - of the fund-raising activity.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Amount Range\", \"options\": [], \"required\": true}, {\"name\": \"amount_raised\", \"type\": \"number\", \"label\": \"Actual Amount Raised (in Kwacha)\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Resource Mobilisation\"}','Team leader (â‰¥1,000,000 but <5,000,000 Kwacha)',450,450,'2024-12-08 07:35:08',NULL),(69,37,139,'Resource Mobilization : Team leader (â‰¥5,000,000 Kwacha)',5.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any participation in any fund-raising activities done on behalf of the University. Also indicate the amount raised and your role - as a team leader or member - of the fund-raising activity.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Amount Range\", \"options\": [], \"required\": true}, {\"name\": \"amount_raised\", \"type\": \"number\", \"label\": \"Actual Amount Raised (in Kwacha)\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Resource Mobilisation\"}','Team leader (â‰¥5,000,000 Kwacha)',450,450,'2024-12-08 07:35:08',NULL),(70,37,139,'Resource Mobilization : Team Member (â‰¥1000 but <50,000 Kwacha)',1.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any participation in any fund-raising activities done on behalf of the University. Also indicate the amount raised and your role - as a team leader or member - of the fund-raising activity.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Amount Range\", \"options\": [], \"required\": true}, {\"name\": \"amount_raised\", \"type\": \"number\", \"label\": \"Actual Amount Raised (in Kwacha)\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Resource Mobilisation\"}','Team leader (â‰¥1000 but <50,000 Kwacha)',450,450,'2024-12-08 07:35:08',NULL),(71,37,139,'Resource Mobilization : Team Member (â‰¥50,000 but <250,000 Kwacha)',2.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any participation in any fund-raising activities done on behalf of the University. Also indicate the amount raised and your role - as a team leader or member - of the fund-raising activity.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Amount Range\", \"options\": [], \"required\": true}, {\"name\": \"amount_raised\", \"type\": \"number\", \"label\": \"Actual Amount Raised (in Kwacha)\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Resource Mobilisation\"}','Team leader (â‰¥50,000 but <250,000 Kwacha)',450,450,'2024-12-08 07:35:08',NULL),(72,37,139,'Resource Mobilization : Team Member (â‰¥250,000 but <1,000,000 Kwacha)',3.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any participation in any fund-raising activities done on behalf of the University. Also indicate the amount raised and your role - as a team leader or member - of the fund-raising activity.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Amount Range\", \"options\": [], \"required\": true}, {\"name\": \"amount_raised\", \"type\": \"number\", \"label\": \"Actual Amount Raised (in Kwacha)\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Resource Mobilisation\"}','Team leader (â‰¥250,000 but <1,000,000 Kwacha)',450,450,'2024-12-08 07:35:08',NULL),(73,37,139,'Resource Mobilization : Team Member (â‰¥1,000,000 but <5,000,000 Kwacha)',4.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any participation in any fund-raising activities done on behalf of the University. Also indicate the amount raised and your role - as a team leader or member - of the fund-raising activity.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Amount Range\", \"options\": [], \"required\": true}, {\"name\": \"amount_raised\", \"type\": \"number\", \"label\": \"Actual Amount Raised (in Kwacha)\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Resource Mobilisation\"}','Team leader (â‰¥1,000,000 but <5,000,000 Kwacha)',450,450,'2024-12-08 07:35:08',NULL),(74,37,139,'Resource Mobilization : Team Member (â‰¥5,000,000 Kwacha)',5.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any participation in any fund-raising activities done on behalf of the University. Also indicate the amount raised and your role - as a team leader or member - of the fund-raising activity.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Amount Range\", \"options\": [], \"required\": true}, {\"name\": \"amount_raised\", \"type\": \"number\", \"label\": \"Actual Amount Raised (in Kwacha)\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Resource Mobilisation\"}','Team leader (â‰¥5,000,000 Kwacha)',450,450,'2024-12-08 07:35:08',NULL),(83,38,140,'Service to Society (Statutory Organizations - District/Provincial/National) - Chairperson ',0.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any responsibilities you have had outside the university within and outside Zambia in statutory or international organisations such as parastatals like Bank of Zambia or the World Bank. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Service to Society (Statutory Organizations/International)\"}','Service to Society (Statutory Organizations - District/Provincial/National) - Chairperson (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(84,38,140,'Service to Society (Statutory Organizations - District/Provincial/National) - Secretary/officials',0.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any responsibilities you have had outside the university within and outside Zambia in statutory or international organisations such as parastatals like Bank of Zambia or the World Bank. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Service to Society (Statutory Organizations/International)\"}','Service to Society (Statutory Organizations - District/Provincial/National) - Secretary/officials (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(85,38,140,'Service to Society (Statutory Organizations - District/Provincial/National) - Member ',0.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any responsibilities you have had outside the university within and outside Zambia in statutory or international organisations such as parastatals like Bank of Zambia or the World Bank. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Service to Society (Statutory Organizations/International)\"}','Service to Society (Statutory Organizations - District/Provincial/National) - Member (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(86,39,141,'Associations - Member (quantity per association)',0.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any relevant associations you belong that in some way advance your academic responsibilities. Examples of these are the Economic Association of Zambia, Law Association of Zambia, etc. Indicate both the start and end date of your membership and your role whether as member of the executive or mere member.\", \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"association_name\", \"type\": \"text\", \"label\": \"Name of Association\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Associations - Member\"}','Associations - Member (quantity per association)',450,3,'2024-12-08 07:35:08',NULL),(87,40,142,'Secondment at National/International Level Organization - Above Director',1.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any responsibilities you have been seconded by the university to serve either government or international organisation. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Secondment at National/International Level Organization\"}','Secondment at National/International Level Organization - Above Director (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(88,40,142,'Secondment at National/International Level Organization - Director ',1.00,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any responsibilities you have been seconded by the university to serve either government or international organisation. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Secondment at National/International Level Organization\"}','Secondment at National/International Level Organization - Director (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(89,40,142,'Secondment at National/International Level Organization - Below Director',1.00,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any responsibilities you have been seconded by the university to serve either government or international organisation. Indicate both the start and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Secondment at National/International Level Organization\"}','Secondment at National/International Level Organization - Below Director (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(90,41,143,'Awards : Recognised International Awards ',4.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any fellowships or scholarships you have been awarded such as the Rhodes, Chevening or Fulbright as well as others including local ones such as the Labour Day Award.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Award Type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"award_title\", \"type\": \"text\", \"label\": \"Award Title\", \"required\": true}, {\"name\": \"status\", \"type\": \"text\", \"label\": \"Status\", \"required\": true}], \"form_description\": \"Awards\"}','Recognised International Awards (quantity = per award)',450,450,'2024-12-08 07:35:08',NULL),(91,41,143,'Awards : Conferred by the State ',2.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any fellowships or scholarships you have been awarded such as the Rhodes, Chevening or Fulbright as well as others including local ones such as the Labour Day Award.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Award Type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"award_title\", \"type\": \"text\", \"label\": \"Award Title\", \"required\": true}, {\"name\": \"status\", \"type\": \"text\", \"label\": \"Status\", \"required\": true}], \"form_description\": \"Awards\"}','Conferred by the State (quantity = per award)',450,450,'2024-12-08 07:35:08',NULL),(92,41,143,'Awards : Conferred by a University / Professional Body ',1.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any fellowships or scholarships you have been awarded such as the Rhodes, Chevening or Fulbright as well as others including local ones such as the Labour Day Award.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Award Type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"award_title\", \"type\": \"text\", \"label\": \"Award Title\", \"required\": true}, {\"name\": \"status\", \"type\": \"text\", \"label\": \"Status\", \"required\": true}], \"form_description\": \"Awards\"}','Conferred by a University / Professional Body (quantity = per award)',450,450,'2024-12-08 07:35:08',NULL),(93,42,144,'Consultancy : University sourced per consultancy completed',0.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any form of engagement with industry, community and society through applied research and/or service provision. Indicate your role such as principal consultant, partner, assistant, associate, etc., and also the organisation you did the consultancy for.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Consultancy Type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}], \"form_description\": \"Consultancy\"}','University sourced per consultancy completed',450,450,'2024-12-08 07:35:08',NULL),(94,42,144,'Consultancy : Self-sourced per consultancy completed',1.00,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any form of engagement with industry, community and society through applied research and/or service provision. Indicate your role such as principal consultant, partner, assistant, associate, etc., and also the organisation you did the consultancy for.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Consultancy Type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"project_title\", \"type\": \"text\", \"label\": \"Project Title\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}], \"form_description\": \"Consultancy\"}','Self-sourced per consultancy completed',450,450,'2024-12-08 07:35:08',NULL),(95,43,145,'External Examination : External examiner / moderator (at diploma level)',0.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any provision of oversight and quality assurance activity you have been involved in such as the administration of a course, programme, or examination in another institution of learning outside Zambia.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"External Examination/Moderation\"}','External examiner / moderator (at diploma level)',450,450,'2024-12-08 07:35:08',NULL),(96,44,146,'Sabbatical Leave : ',1.50,'weight','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any engagement in research or teaching activity outside the University of Zambia\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}, {\"name\": \"country\", \"type\": \"text\", \"label\": \"Country\", \"required\": true}], \"form_description\": \"Sebbatical Leave\"}','Sabatical Leave',450,450,'2024-12-08 07:35:08',NULL),(97,45,147,'Membership to Professional Bodies : Fellow (Quantity = time units (days/months) at that level)',0.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any membership in professional bodies such as Engineering Institute of Zambia. For level, indicate if you are a fellow, associate, or just an ordinary member.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Membership type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Membership to Professional Bodies\"}','Fellow (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(98,45,147,'Membership to Professional Bodies : Member (Quantity = time units (days/months) at that level)',0.25,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any membership in professional bodies such as Engineering Institute of Zambia. For level, indicate if you are a fellow, associate, or just an ordinary member.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Membership type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Membership to Professional Bodies\"}','Member (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(99,45,147,'Membership to Professional Bodies : Associate (Quantity = time units (days/months) at that level)',0.20,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any membership in professional bodies such as Engineering Institute of Zambia. For level, indicate if you are a fellow, associate, or just an ordinary member.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Membership type\", \"options\": [], \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}], \"form_description\": \"Membership to Professional Bodies\"}','Associate (Quantity = time units (days/months) at that level)',450,450,'2024-12-08 07:35:08',NULL),(100,46,148,'Miscellaneous Contributions : ',0.50,'-','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any other contributions not covered by the instrument but which unit/department may consider important. Indicate the role you played in your contribution.\", \"required\": true}, {\"name\": \"year\", \"type\": \"number\", \"label\": \"Year\", \"required\": true}, {\"name\": \"institution\", \"type\": \"text\", \"label\": \"Institution\", \"required\": true}, {\"name\": \"role\", \"type\": \"text\", \"label\": \"Role\", \"required\": true}], \"form_description\": \"Miscellaneous Contributions\"}','Miscellaneous Contributions : ',450,3,'2024-12-08 07:35:08',NULL),(101,37,149,'Other Relevant Contributions',0.50,'-','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any other activity not covered in the preceding sections, which you have participated in such as: chief invigilator, course coordinator, project/team leader/coordinator, technical adviser, research coordinator, business official, etc.\", \"required\": true}, {\"name\": \"entries\", \"type\": \"repeater\", \"label\": \"Contributions\", \"fields\": [{\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"position\", \"type\": \"text\", \"label\": \"Position\", \"required\": true}, {\"name\": \"unit\", \"type\": \"text\", \"label\": \"Unit\", \"required\": true}, {\"name\": \"department\", \"type\": \"text\", \"label\": \"Department\", \"required\": true}]}], \"form_description\": \"Other Relevant Contributions\"}','Other relevant contributions',450,3,'2024-12-08 07:35:08',NULL),(102,48,150,'Service to Society (Non Statutory Organizations ) - Chairperson ',0.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any responsibilities you have had outside the university in local institutions within Zambia such as non-governmental organisations, civil society organisations, private companies or industries. Indicate both the start date and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}, {\"name\": \"province\", \"type\": \"text\", \"label\": \"Province\", \"required\": true}], \"form_description\": \"Service to Society (Non-Statutory Organizations)\"}','Service to Society (Non Statutory Organizations ) - Chairperson ',450,450,'2024-12-08 07:35:08',NULL),(103,48,150,'Service to Society (Non Statutory Organizations ) - Secretary / Official ',0.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any responsibilities you have had outside the university in local institutions within Zambia such as non-governmental organisations, civil society organisations, private companies or industries. Indicate both the start date and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}, {\"name\": \"province\", \"type\": \"text\", \"label\": \"Province\", \"required\": true}], \"form_description\": \"Service to Society (Non-Statutory Organizations)\"}','Service to Society (Non Statutory Organizations ) - Secretary / Official ',450,450,'2024-12-08 07:35:08',NULL),(104,48,150,'Service to Society (Non Statutory Organizations ) - Member',0.50,'( ( days_on_position / 365 ) * weight )','{\"fields\": [{\"name\": \"instructions\", \"type\": \"textarea\", \"label\": \"Instructions\", \"value\": \"Report any responsibilities you have had outside the university in local institutions within Zambia such as non-governmental organisations, civil society organisations, private companies or industries. Indicate both the start date and end date of acting or serving in any capacity and the positions held.\", \"required\": true}, {\"name\": \"related_formula\", \"type\": \"select\", \"label\": \"Position\", \"options\": [], \"required\": true}, {\"name\": \"start_date\", \"type\": \"date\", \"label\": \"Start Date\", \"required\": true}, {\"name\": \"end_date\", \"type\": \"date\", \"label\": \"End Date\", \"required\": true}, {\"name\": \"organisation\", \"type\": \"text\", \"label\": \"Organisation\", \"required\": true}, {\"name\": \"province\", \"type\": \"text\", \"label\": \"Province\", \"required\": true}], \"form_description\": \"Service to Society (Non-Statutory Organizations)\"}','Service to Society (Non Statutory Organizations ) - Member',450,450,'2024-12-08 07:35:08',NULL);
/*!40000 ALTER TABLE `asp_point_scoring_formulas` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_points_at_promotion`
--

DROP TABLE IF EXISTS `asp_points_at_promotion`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_points_at_promotion` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `lecturer_id` int unsigned DEFAULT NULL,
  `from_rank_id` int unsigned DEFAULT NULL,
  `to_rank_id` int unsigned DEFAULT NULL,
  `total_points_at_promotion` decimal(10,2) DEFAULT NULL,
  `teaching_points_at_promotion` decimal(10,2) DEFAULT NULL,
  `research_points_at_promotion` decimal(10,2) DEFAULT NULL,
  `university_service_points_at_promotion` decimal(10,2) DEFAULT NULL,
  `community_service_points_at_promotion` decimal(10,2) DEFAULT NULL,
  `promotion_date` date DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `lecturer_id` (`lecturer_id`),
  KEY `created_by` (`created_by`),
  KEY `from_rank_id` (`from_rank_id`),
  KEY `to_rank_id` (`to_rank_id`),
  CONSTRAINT `asp_points_at_promotion_ibfk_1` FOREIGN KEY (`lecturer_id`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_points_at_promotion_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_points_at_promotion_ibfk_3` FOREIGN KEY (`from_rank_id`) REFERENCES `asp_academic_ranks` (`id`),
  CONSTRAINT `asp_points_at_promotion_ibfk_4` FOREIGN KEY (`to_rank_id`) REFERENCES `asp_academic_ranks` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_points_at_promotion`
--

LOCK TABLES `asp_points_at_promotion` WRITE;
/*!40000 ALTER TABLE `asp_points_at_promotion` DISABLE KEYS */;
/*!40000 ALTER TABLE `asp_points_at_promotion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_promotion_applications`
--

DROP TABLE IF EXISTS `asp_promotion_applications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_promotion_applications` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `lecturer_id` int unsigned DEFAULT NULL,
  `current_rank_id` int unsigned DEFAULT NULL,
  `applied_rank_id` int unsigned DEFAULT NULL,
  `point_total_id` int unsigned DEFAULT NULL,
  `department_id` int unsigned DEFAULT NULL,
  `unit_id` int unsigned DEFAULT NULL,
  `promotion_date` date DEFAULT NULL,
  `application_status` enum('PENDING','APPROVED','REJECTED','APPEALED','WITHDRAWN') NOT NULL DEFAULT 'PENDING',
  `promotion_snapshot_id` int unsigned DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `lecturer_id` (`lecturer_id`),
  KEY `current_rank_id` (`current_rank_id`),
  KEY `applied_rank_id` (`applied_rank_id`),
  KEY `point_total_id` (`point_total_id`),
  KEY `promotion_snapshot_id` (`promotion_snapshot_id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `department_id` (`department_id`),
  KEY `unit_id` (`unit_id`),
  CONSTRAINT `asp_promotion_applications_ibfk_1` FOREIGN KEY (`lecturer_id`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_promotion_applications_ibfk_2` FOREIGN KEY (`current_rank_id`) REFERENCES `asp_academic_ranks` (`id`),
  CONSTRAINT `asp_promotion_applications_ibfk_3` FOREIGN KEY (`applied_rank_id`) REFERENCES `asp_academic_ranks` (`id`),
  CONSTRAINT `asp_promotion_applications_ibfk_4` FOREIGN KEY (`point_total_id`) REFERENCES `asp_lecturer_point_totals` (`id`),
  CONSTRAINT `asp_promotion_applications_ibfk_5` FOREIGN KEY (`promotion_snapshot_id`) REFERENCES `asp_points_at_promotion` (`id`),
  CONSTRAINT `asp_promotion_applications_ibfk_6` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_promotion_applications_ibfk_7` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_promotion_applications_ibfk_8` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  CONSTRAINT `asp_promotion_applications_ibfk_9` FOREIGN KEY (`unit_id`) REFERENCES `units` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_promotion_applications`
--

LOCK TABLES `asp_promotion_applications` WRITE;
/*!40000 ALTER TABLE `asp_promotion_applications` DISABLE KEYS */;
INSERT INTO `asp_promotion_applications` VALUES (4,443,5,6,6,81,11,NULL,'PENDING',NULL,443,443,'2025-03-15 17:44:49','2025-03-28 16:18:31');
/*!40000 ALTER TABLE `asp_promotion_applications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_qualification_types`
--

DROP TABLE IF EXISTS `asp_qualification_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_qualification_types` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `code` varchar(255) NOT NULL,
  `description` text,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `asp_qualification_types_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_qualification_types_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_qualification_types`
--

LOCK TABLES `asp_qualification_types` WRITE;
/*!40000 ALTER TABLE `asp_qualification_types` DISABLE KEYS */;
INSERT INTO `asp_qualification_types` VALUES (1,'Teaching','TQ','',450,450,'2024-12-08 01:49:16','2025-03-18 23:41:10'),(2,'Research and Publication','RQ','',450,450,'2024-12-08 01:49:16','2025-03-18 23:41:10'),(3,'University Leadership And Administration','USQ','',450,450,'2024-12-08 01:49:16','2025-03-18 23:46:28'),(4,'Community And Public Service','CSQ','',450,450,'2024-12-08 01:49:16','2025-03-18 23:46:28'),(5,'Relevant Qualifications','RQ','',450,450,'2024-12-08 01:51:19','2025-03-18 23:41:10');
/*!40000 ALTER TABLE `asp_qualification_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `asp_rank_thresholds`
--

DROP TABLE IF EXISTS `asp_rank_thresholds`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `asp_rank_thresholds` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `rank_id` int unsigned DEFAULT NULL,
  `minimum_points` decimal(10,2) DEFAULT NULL,
  `teaching_percentage` decimal(5,2) DEFAULT NULL,
  `research_percentage` decimal(5,2) DEFAULT NULL,
  `university_service_percentage` decimal(5,2) DEFAULT NULL,
  `community_service_percentage` decimal(5,2) DEFAULT NULL,
  `h_index` int DEFAULT NULL,
  `annual_performance_appraisal` decimal(5,2) DEFAULT NULL,
  `new_publications` int DEFAULT NULL,
  `peer_reviewed_publications` int DEFAULT NULL,
  `postgraduate_supervision` int DEFAULT NULL,
  `doctoral_supervision` int DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `rank_id` (`rank_id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `asp_rank_thresholds_ibfk_1` FOREIGN KEY (`rank_id`) REFERENCES `asp_academic_ranks` (`id`),
  CONSTRAINT `asp_rank_thresholds_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `asp_rank_thresholds_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `asp_rank_thresholds`
--

LOCK TABLES `asp_rank_thresholds` WRITE;
/*!40000 ALTER TABLE `asp_rank_thresholds` DISABLE KEYS */;
INSERT INTO `asp_rank_thresholds` VALUES (1,1,0.00,95.00,0.00,2.50,2.50,1,75.00,0,0,0,0,450,450,'2024-12-08 09:34:30','2025-03-15 08:40:08'),(2,2,100.00,95.00,0.00,2.50,2.50,2,75.00,1,0,0,0,450,450,'2024-12-08 09:34:30','2025-03-15 08:40:08'),(3,3,250.00,57.50,32.50,5.00,5.00,6,75.00,3,10,6,0,450,450,'2024-12-08 09:34:30','2025-03-15 08:40:08'),(4,4,450.00,50.00,35.00,5.00,10.00,8,75.00,0,15,8,2,450,450,'2024-12-08 09:34:30','2025-03-15 08:40:08'),(5,5,750.00,45.00,40.00,5.00,10.00,10,75.00,0,20,10,4,450,450,'2024-12-08 09:34:30','2025-03-15 08:40:08'),(6,6,1100.00,95.00,40.00,5.00,10.00,15,75.00,0,25,10,7,450,450,'2024-12-08 09:34:30','2025-03-28 22:12:05');
/*!40000 ALTER TABLE `asp_rank_thresholds` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `etl_academic_year_semesters`
--

DROP TABLE IF EXISTS `etl_academic_year_semesters`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `etl_academic_year_semesters` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `academic_year_id` int unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `academic_year_id` (`academic_year_id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `etl_academic_year_semesters_ibfk_1` FOREIGN KEY (`academic_year_id`) REFERENCES `etl_academic_years` (`id`) ON DELETE CASCADE,
  CONSTRAINT `etl_academic_year_semesters_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `etl_academic_year_semesters_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `etl_academic_year_semesters`
--

LOCK TABLES `etl_academic_year_semesters` WRITE;
/*!40000 ALTER TABLE `etl_academic_year_semesters` DISABLE KEYS */;
INSERT INTO `etl_academic_year_semesters` VALUES (7,4,'Semester 1','2024-02-01','2024-06-30',3,3,'2024-11-07 10:32:39','2024-11-16 10:19:29'),(8,4,'Semester 2','2024-07-01','2024-12-30',3,3,'2024-11-07 10:33:38','2024-11-07 10:33:38'),(58,39,'Semester 1','2025-01-01','2025-04-11',3,3,'2024-11-13 11:54:11','2024-11-13 11:54:11'),(59,39,'Semester 2','2025-07-15','2025-12-31',3,3,'2024-11-13 11:54:11','2024-11-13 11:54:11'),(60,39,'Full Academic Year','2025-01-01','2025-12-31',3,3,'2024-11-13 11:54:11','2024-11-17 22:25:25'),(83,52,'Semester 1','2026-01-01','2026-06-30',3,3,'2024-11-14 20:39:56','2024-11-14 20:39:56'),(84,52,'Semester 2','2026-07-02','2026-12-30',3,3,'2024-11-14 20:39:56','2024-11-14 20:39:56'),(85,52,'Full Academic Year','2026-01-01','2026-12-30',3,3,'2024-11-14 20:39:56','2024-11-17 22:25:25'),(86,53,'Semester 1','2027-01-01','2027-06-27',3,3,'2024-11-14 20:50:27','2024-11-14 20:50:27'),(87,53,'Semester 2','2027-07-01','2027-12-31',3,3,'2024-11-14 20:50:27','2024-11-14 20:50:27'),(88,53,'Full Academic Year','2027-01-01','2027-12-31',3,3,'2024-11-14 20:50:27','2024-11-17 22:25:25'),(89,4,'Full Academic Year','2024-02-01','2024-12-30',3,3,'2024-11-17 22:27:23','2024-11-17 22:27:23'),(96,60,'Semester 1','2025-02-01','2025-07-01',3,3,'2025-02-25 14:18:56','2025-02-25 14:18:56'),(97,60,'Semester 2','2025-07-30','2025-12-23',3,3,'2025-02-25 14:18:56','2025-02-25 14:18:56'),(98,60,'Full Academic Year','2025-02-01','2025-12-23',3,3,'2025-02-25 14:18:56','2025-02-25 14:18:56'),(107,61,'Semester 1','2025-02-01','2025-02-07',3,3,'2025-02-26 20:24:18','2025-02-26 20:24:18'),(108,61,'Semester 2','2025-02-19','2025-02-27',3,3,'2025-02-26 20:24:18','2025-02-26 20:24:18'),(109,61,'Full Academic Year','2025-02-01','2025-02-27',3,3,'2025-02-26 20:24:18','2025-02-26 20:24:18');
/*!40000 ALTER TABLE `etl_academic_year_semesters` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `etl_academic_years`
--

DROP TABLE IF EXISTS `etl_academic_years`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `etl_academic_years` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` char(255) DEFAULT NULL,
  `year` int DEFAULT NULL,
  `start_year` int DEFAULT NULL,
  `end_year` int DEFAULT NULL,
  `current` tinyint(1) DEFAULT '0',
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `etl_academic_years_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `etl_academic_years_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `etl_academic_years`
--

LOCK TABLES `etl_academic_years` WRITE;
/*!40000 ALTER TABLE `etl_academic_years` DISABLE KEYS */;
INSERT INTO `etl_academic_years` VALUES (4,'2023/2024',2024,2023,2024,0,NULL,NULL,'2024-11-07 10:31:19','2025-03-19 10:15:01'),(39,'2024/2025',2025,2024,2025,1,3,3,'2024-11-13 11:54:11','2025-03-31 11:49:21'),(52,'2025/2026',2026,2025,2026,0,3,3,'2024-11-14 20:39:56','2025-03-31 11:49:21'),(53,'2026/2027',2027,2026,2027,0,3,3,'2024-11-14 20:50:27','2025-03-05 11:20:18'),(60,'2027/2028',2028,2027,2028,0,3,3,'2025-02-25 14:18:56','2025-02-27 08:45:11'),(61,'2028/2029',2029,2028,2029,0,3,3,'2025-02-26 15:00:33','2025-03-05 11:20:18'),(62,'2029/2030',NULL,2029,2030,0,3,3,'2025-02-26 20:41:03','2025-02-27 09:29:38');
/*!40000 ALTER TABLE `etl_academic_years` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `etl_claims`
--

DROP TABLE IF EXISTS `etl_claims`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `etl_claims` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `lecturer_id` int unsigned NOT NULL,
  `man_number` varchar(10) DEFAULT NULL,
  `lecturer_qualification` int NOT NULL,
  `claim_department_id` int unsigned NOT NULL,
  `semester_id` int unsigned NOT NULL,
  `status` tinyint(1) DEFAULT '0',
  `processed_status` tinyint(1) DEFAULT '0',
  `earn_def_code` varchar(10) DEFAULT NULL,
  `earn_def_description` text,
  `claim_description` text,
  `amount` decimal(10,2) DEFAULT NULL,
  `approved` tinyint(1) DEFAULT '0',
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `processed_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lecturer_id` (`lecturer_id`),
  KEY `lecturer_qualification` (`lecturer_qualification`),
  KEY `department_id` (`claim_department_id`),
  KEY `semester_id` (`semester_id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `etl_claims_ibfk_1` FOREIGN KEY (`lecturer_id`) REFERENCES `employment_details` (`id`) ON DELETE CASCADE,
  CONSTRAINT `etl_claims_ibfk_2` FOREIGN KEY (`lecturer_qualification`) REFERENCES `etl_lecturer_qualifications` (`id`) ON DELETE CASCADE,
  CONSTRAINT `etl_claims_ibfk_3` FOREIGN KEY (`claim_department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `etl_claims_ibfk_5` FOREIGN KEY (`semester_id`) REFERENCES `etl_academic_year_semesters` (`id`) ON DELETE CASCADE,
  CONSTRAINT `etl_claims_ibfk_6` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `etl_claims_ibfk_7` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `etl_claims`
--

LOCK TABLES `etl_claims` WRITE;
/*!40000 ALTER TABLE `etl_claims` DISABLE KEYS */;
INSERT INTO `etl_claims` VALUES (39,252,'008393',8,39,7,1,0,'002F',NULL,NULL,40000.00,0,450,979,'2024-11-09 09:19:20','2025-02-23 20:15:10',NULL),(42,256,'008384',9,81,7,0,0,'002F',NULL,NULL,40000.00,0,443,979,'2024-11-11 13:26:31','2025-02-23 20:42:56',NULL),(46,258,'008485',10,13,8,0,0,'002F',NULL,NULL,91064.00,0,491,491,'2024-11-18 00:31:37','2024-12-02 23:10:12',NULL),(48,252,'008393',12,39,58,0,0,'002F',NULL,NULL,92220.00,0,450,450,'2025-02-20 09:11:49','2025-02-20 09:11:49',NULL),(50,258,'008485',14,13,58,0,0,'002F',NULL,NULL,91064.00,0,491,491,'2025-03-19 10:27:01','2025-03-19 10:27:01',NULL),(54,1046,'007296',15,76,58,1,0,'002F',NULL,NULL,76326.00,0,172,979,'2025-03-19 10:38:48','2025-03-19 11:01:41',NULL),(59,245,'006732',11,27,58,0,0,'002F',NULL,NULL,90670.00,0,77,77,'2025-04-03 18:13:58','2025-04-03 18:13:58',NULL);
/*!40000 ALTER TABLE `etl_claims` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `etl_courses`
--

DROP TABLE IF EXISTS `etl_courses`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `etl_courses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(50) NOT NULL,
  `name` varchar(255) NOT NULL,
  `description` text,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `etl_courses_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `etl_courses_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `etl_courses`
--

LOCK TABLES `etl_courses` WRITE;
/*!40000 ALTER TABLE `etl_courses` DISABLE KEYS */;
INSERT INTO `etl_courses` VALUES (6,'MA210','Mathermatics',NULL,3,3,'2024-11-07 10:47:41','2024-11-07 10:47:41'),(7,'PH315','Physics',NULL,3,3,'2024-11-07 10:48:10','2024-11-07 10:48:10'),(8,'CS110','Introduction to Computer Science',NULL,3,3,'2024-11-11 13:12:10','2024-11-11 13:12:10'),(9,'MA110','Engineering Mathematics',NULL,3,3,'2024-11-11 13:13:05','2024-11-11 13:13:05'),(10,'CHEM 115','Chemistry',NULL,3,3,'2025-02-27 09:04:45','2025-02-27 09:04:45'),(11,'Test450','TestEdited',NULL,3,3,'2025-03-29 14:51:17','2025-03-29 14:51:27'),(12,'BIO200','Biology',NULL,3,3,'2025-03-31 11:51:19','2025-03-31 11:51:19'),(13,'LA220','Language',NULL,3,3,'2025-03-31 11:51:42','2025-03-31 11:51:42');
/*!40000 ALTER TABLE `etl_courses` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `etl_division_course_lecturers`
--

DROP TABLE IF EXISTS `etl_division_course_lecturers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `etl_division_course_lecturers` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `division_id` bigint unsigned NOT NULL,
  `course_id` int unsigned NOT NULL,
  `course_students` int DEFAULT NULL,
  `lecturer_id` int unsigned NOT NULL,
  `semester_id` int unsigned NOT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `division_id` (`division_id`),
  KEY `course_id` (`course_id`),
  KEY `lecturer_id` (`lecturer_id`),
  KEY `semester_id` (`semester_id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `etl_division_course_lecturers_ibfk_1` FOREIGN KEY (`division_id`) REFERENCES `etl_divisions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `etl_division_course_lecturers_ibfk_2` FOREIGN KEY (`course_id`) REFERENCES `etl_courses` (`id`) ON DELETE CASCADE,
  CONSTRAINT `etl_division_course_lecturers_ibfk_3` FOREIGN KEY (`lecturer_id`) REFERENCES `employment_details` (`id`) ON DELETE CASCADE,
  CONSTRAINT `etl_division_course_lecturers_ibfk_4` FOREIGN KEY (`semester_id`) REFERENCES `etl_academic_year_semesters` (`id`) ON DELETE CASCADE,
  CONSTRAINT `etl_division_course_lecturers_ibfk_5` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `etl_division_course_lecturers_ibfk_6` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `etl_division_course_lecturers`
--

LOCK TABLES `etl_division_course_lecturers` WRITE;
/*!40000 ALTER TABLE `etl_division_course_lecturers` DISABLE KEYS */;
INSERT INTO `etl_division_course_lecturers` VALUES (11,8,6,100,252,7,3,3,'2024-11-07 11:41:59','2024-11-07 11:41:59'),(12,9,8,30,256,7,3,3,'2024-11-11 13:15:31','2024-11-11 13:15:31'),(13,9,9,40,256,7,3,3,'2024-11-11 13:16:57','2024-11-11 13:16:57'),(14,27,6,100,252,58,3,3,'2024-11-13 11:54:11','2025-03-19 10:04:06'),(17,30,6,100,252,83,3,3,'2024-11-14 20:39:57','2024-11-14 20:39:57'),(18,33,6,20,252,86,3,3,'2024-11-14 20:50:27','2025-02-25 13:51:59'),(19,9,9,200,258,89,3,3,'2024-11-17 23:38:50','2024-11-17 23:38:50'),(20,28,9,200,245,58,3,3,'2025-02-20 08:47:52','2025-02-20 08:47:52'),(21,34,8,40,256,87,3,3,'2025-02-20 08:56:08','2025-02-27 08:44:41'),(26,34,8,40,2062,86,3,3,'2025-02-25 13:55:57','2025-02-27 08:44:41'),(42,43,8,15,256,97,3,3,'2025-02-26 13:53:57','2025-02-26 13:53:57'),(43,33,7,30,280,88,3,3,'2025-02-26 14:00:12','2025-02-27 12:17:17'),(49,42,7,500,281,98,3,3,'2025-02-26 14:21:14','2025-02-26 14:21:14'),(50,42,6,20,252,96,3,3,'2025-02-26 14:36:35','2025-02-26 14:36:35'),(51,43,8,100,2062,96,3,3,'2025-02-26 14:36:35','2025-02-26 14:36:35'),(52,42,7,500,280,98,3,3,'2025-02-26 14:36:35','2025-02-26 14:36:35'),(109,130,6,350,252,107,3,3,'2025-02-26 20:25:24','2025-02-27 08:28:48'),(110,131,8,30,2062,107,3,3,'2025-02-26 20:25:24','2025-02-27 08:27:04'),(111,131,8,30,256,108,3,3,'2025-02-26 20:25:24','2025-02-27 08:27:04'),(112,130,7,5,281,109,3,3,'2025-02-26 20:25:24','2025-02-27 08:27:42'),(113,130,7,5,280,109,3,3,'2025-02-26 20:25:24','2025-02-27 08:27:42'),(116,29,6,300,247,85,3,3,'2025-02-27 11:46:50','2025-02-27 12:10:02'),(117,32,6,300,247,88,3,3,'2025-02-27 12:14:11','2025-02-27 12:14:11'),(118,9,9,40,1046,89,3,3,'2025-03-19 10:07:22','2025-03-19 10:07:22'),(119,28,8,33,256,58,3,3,'2025-03-19 10:14:47','2025-03-29 15:47:15'),(120,28,9,200,258,60,3,3,'2025-03-19 10:14:47','2025-03-19 10:14:47'),(121,28,9,40,1046,60,3,3,'2025-03-19 10:14:47','2025-03-19 10:14:47'),(122,28,8,33,1046,60,3,3,'2025-03-19 10:19:29','2025-03-29 15:47:15'),(123,133,8,10,958,60,3,3,'2025-03-29 15:44:21','2025-03-31 11:58:25'),(124,31,9,200,245,83,3,3,'2025-03-31 11:45:08','2025-03-31 11:45:08'),(125,31,8,33,256,83,3,3,'2025-03-31 11:45:08','2025-03-31 11:45:08'),(126,31,9,200,258,85,3,3,'2025-03-31 11:45:08','2025-03-31 11:45:08'),(127,31,9,40,1046,85,3,3,'2025-03-31 11:45:08','2025-03-31 11:45:08'),(128,137,8,105,958,85,3,3,'2025-03-31 11:45:08','2025-03-31 11:45:08'),(129,140,11,30,257,85,3,3,'2025-03-31 11:48:44','2025-03-31 11:48:44'),(130,135,12,23,257,60,3,3,'2025-03-31 11:52:43','2025-03-31 11:52:43'),(131,136,13,90,257,60,3,3,'2025-03-31 11:53:44','2025-03-31 11:53:44'),(132,134,11,102,1328,60,3,3,'2025-04-04 10:32:24','2025-04-04 10:32:24');
/*!40000 ALTER TABLE `etl_division_course_lecturers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `etl_divisions`
--

DROP TABLE IF EXISTS `etl_divisions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `etl_divisions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `program_cycle_id` int unsigned NOT NULL,
  `academic_year_id` int unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `student_count` int DEFAULT '0',
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `program_id` (`program_cycle_id`),
  KEY `academic_year_id` (`academic_year_id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `etl_divisions_fk_program_cycle_id_restrict` FOREIGN KEY (`program_cycle_id`) REFERENCES `etl_programs_cycles` (`id`) ON DELETE RESTRICT,
  CONSTRAINT `etl_divisions_ibfk_2` FOREIGN KEY (`academic_year_id`) REFERENCES `etl_academic_years` (`id`) ON DELETE CASCADE,
  CONSTRAINT `etl_divisions_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `etl_divisions_ibfk_4` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `etl_divisions`
--

LOCK TABLES `etl_divisions` WRITE;
/*!40000 ALTER TABLE `etl_divisions` DISABLE KEYS */;
INSERT INTO `etl_divisions` VALUES (7,7,4,'Group 1',300,3,3,'2024-11-07 10:46:56','2024-11-07 10:46:56'),(8,8,4,'Group 1',300,3,3,'2024-11-07 11:40:36','2024-11-07 11:40:36'),(9,9,4,'Group 1',50,3,3,'2024-11-11 13:10:50','2024-11-11 13:10:50'),(26,7,39,'Group 1',300,3,3,'2024-11-07 10:46:56','2024-11-07 10:46:56'),(27,8,39,'Group 1',300,3,3,'2024-11-07 11:40:36','2024-11-07 11:40:36'),(28,9,39,'Group 1',50,3,3,'2024-11-11 13:10:50','2024-11-11 13:10:50'),(29,7,52,'Group 1',300,3,3,'2024-11-07 10:46:56','2024-11-07 10:46:56'),(30,8,52,'Group 1',300,3,3,'2024-11-07 11:40:36','2024-11-07 11:40:36'),(31,9,52,'Group 1',50,3,3,'2024-11-11 13:10:50','2024-11-11 13:10:50'),(32,7,53,'Group 1',300,3,3,'2024-11-07 10:46:56','2024-11-07 10:46:56'),(33,8,53,'Group 1',32,3,3,'2024-11-07 11:40:36','2024-11-16 10:08:30'),(34,9,53,'Cs Group 1',50,3,3,'2024-11-11 13:10:50','2024-11-16 15:15:00'),(41,7,60,'Group 1',300,3,3,'2024-11-07 10:46:56','2024-11-07 10:46:56'),(42,8,60,'Group 1',32,3,3,'2024-11-07 11:40:36','2024-11-16 10:08:30'),(43,9,60,'Cs Group 1',50,3,3,'2024-11-11 13:10:50','2024-11-16 15:15:00'),(129,7,61,'Group 1',300,3,3,'2024-11-07 10:46:56','2024-11-07 10:46:56'),(130,8,61,'Group 1',32,3,3,'2024-11-07 11:40:36','2024-11-16 10:08:30'),(131,9,61,'Cs Group 1',50,3,3,'2024-11-11 13:10:50','2024-11-16 15:15:00'),(132,9,53,'Group 1',50,3,3,'2024-11-11 13:10:50','2024-11-11 13:10:50'),(133,10,39,'Civil 3',500,3,3,'2025-03-29 15:27:24','2025-03-29 15:27:24'),(134,9,39,'CS 1 Intake',310,3,3,'2025-03-29 15:28:21','2025-04-04 10:29:06'),(135,19,39,'Test Nursing Division',150,3,3,'2025-03-31 08:04:18','2025-03-31 08:04:18'),(136,20,39,'Test2 Nursing Division',100,3,3,'2025-03-31 08:05:44','2025-03-31 08:05:44'),(137,10,52,'Civil 3',500,3,3,'2025-03-29 15:27:24','2025-03-29 15:27:24'),(138,9,52,'CS 1 Intake',200,3,3,'2025-03-29 15:28:21','2025-04-04 10:27:08'),(139,19,52,'Test Nursing Division',150,3,3,'2025-03-31 08:04:18','2025-03-31 08:04:18'),(140,20,52,'Test2 Nursing Division',100,3,3,'2025-03-31 08:05:44','2025-03-31 08:05:44');
/*!40000 ALTER TABLE `etl_divisions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `etl_lecturer_qualifications`
--

DROP TABLE IF EXISTS `etl_lecturer_qualifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `etl_lecturer_qualifications` (
  `id` int NOT NULL AUTO_INCREMENT,
  `lecturer_id` int unsigned NOT NULL,
  `man_number` varchar(10) NOT NULL,
  `claim_id` int unsigned DEFAULT NULL,
  `academic_year_id` int unsigned NOT NULL,
  `semester_id` int unsigned DEFAULT NULL,
  `full_courses` text,
  `half_courses` text,
  `divisions` text,
  `qualification_status` tinyint(1) NOT NULL DEFAULT '0',
  `has_claim` tinyint(1) NOT NULL DEFAULT '0',
  `eligibility_condition` text,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  KEY `lecturer_id` (`lecturer_id`),
  KEY `academic_year_id` (`academic_year_id`),
  KEY `semester_id` (`semester_id`),
  KEY `fk_claim_id` (`claim_id`),
  CONSTRAINT `etl_lecturer_qualifications_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `etl_lecturer_qualifications_ibfk_2` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`),
  CONSTRAINT `etl_lecturer_qualifications_ibfk_3` FOREIGN KEY (`lecturer_id`) REFERENCES `employment_details` (`id`),
  CONSTRAINT `etl_lecturer_qualifications_ibfk_4` FOREIGN KEY (`academic_year_id`) REFERENCES `etl_academic_years` (`id`),
  CONSTRAINT `etl_lecturer_qualifications_ibfk_5` FOREIGN KEY (`semester_id`) REFERENCES `etl_academic_year_semesters` (`id`),
  CONSTRAINT `fk_claim_id` FOREIGN KEY (`claim_id`) REFERENCES `etl_claims` (`id`) ON DELETE RESTRICT
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `etl_lecturer_qualifications`
--

LOCK TABLES `etl_lecturer_qualifications` WRITE;
/*!40000 ALTER TABLE `etl_lecturer_qualifications` DISABLE KEYS */;
INSERT INTO `etl_lecturer_qualifications` VALUES (8,252,'008393',39,4,7,'6','','8',1,1,'Taught (100 students) in MA210 of Bsc in Governance 1 (Group 1), meeting 76 or more students requirement',3,3,'2024-11-07 13:23:34','2024-11-09 09:19:20'),(9,256,'008384',42,4,7,'8, 9','','9, 9',1,1,'Taught 2 full courses (CS110, MA110), meeting 2 or more full courses requirement',3,3,'2024-11-11 13:17:40','2024-11-11 13:26:31'),(10,258,'008485',46,4,8,'9','','9',1,1,'Taught (200 students) in MA110 of Bsc Computer Science 1 (Group 1), meeting 76 or more students requirement',3,3,'2024-11-17 23:39:41','2024-11-18 00:31:37'),(11,245,'006732',59,39,58,'9','','28',1,1,'Taught (200 students) in MA110 of Bsc Computer Science 1 (Group 1), meeting 76 or more students requirement',3,3,'2025-02-20 09:07:29','2025-04-03 18:13:58'),(12,252,'008393',48,39,58,'6','','27',1,1,'Taught (100 students) in MA210 of Bsc in Governance 1 (Group 1), meeting 76 or more students requirement',3,3,'2025-02-20 09:07:29','2025-02-20 09:11:49'),(13,256,'008384',NULL,39,58,'8','','28',0,0,'Does not meet eligibility criteria',3,3,'2025-03-19 10:15:26','2025-03-19 10:15:26'),(14,258,'008485',50,39,58,'9','','28',1,1,'Taught (200 students) in MA110 of Bsc Computer Science 1 (Group 1), meeting 76 or more students requirement',3,3,'2025-03-19 10:15:26','2025-03-19 10:27:01'),(15,1046,'007296',54,39,58,'9, 8','','28, 28',1,1,'Taught 2 full courses (MA110, CS110), meeting 2 or more full courses requirement',3,3,'2025-03-19 10:15:26','2025-03-19 10:38:48'),(16,958,'006887',NULL,39,58,'8','','133',0,0,'Does not meet eligibility criteria',3,3,'2025-03-29 15:48:59','2025-03-31 11:58:30'),(17,257,'009356',NULL,39,58,'12, 13','','135, 136',1,0,'Taught 2 full courses (BIO200, LA220), meeting 2 or more full courses requirement',3,3,'2025-03-31 11:54:27','2025-03-31 11:54:27'),(18,1328,'010495',NULL,39,58,'11','','134',1,1,'Taught (102 students) in Test450 of Bsc Computer Science 1 (CS 1 Intake), meeting 76 or more students requirement',3,3,'2025-04-04 10:32:47','2025-04-04 10:33:20');
/*!40000 ALTER TABLE `etl_lecturer_qualifications` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `etl_programs`
--

DROP TABLE IF EXISTS `etl_programs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `etl_programs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `program_cycles` int unsigned DEFAULT NULL,
  `department_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp 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_etl_programs_created_by` (`created_by`),
  KEY `fk_etl_programs_updated_by` (`updated_by`),
  KEY `etl_programs_ibfk_1` (`department_id`),
  CONSTRAINT `etl_programs_ibfk_1` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_etl_programs_created_by_programs` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `fk_etl_programs_updated_by_programs` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `etl_programs`
--

LOCK TABLES `etl_programs` WRITE;
/*!40000 ALTER TABLE `etl_programs` DISABLE KEYS */;
INSERT INTO `etl_programs` VALUES (1,'Bsc in Population - 1',3,33,'2024-11-07 10:35:54','2025-03-30 08:03:26',3,3),(2,'Bsc in Population - 2',4,33,'2024-11-07 10:36:27','2025-03-30 08:03:26',3,3),(3,'Bsc in Governance 1',5,39,'2024-11-07 11:39:48','2025-03-30 08:03:26',3,3),(4,'Bsc Computer Science 1',3,81,'2024-11-11 13:09:49','2025-03-30 08:03:26',3,3),(5,'Civil Engineering',5,24,'2025-03-29 15:25:52','2025-03-31 07:00:45',3,3),(8,'Nursing Testing',4,54,'2025-03-31 07:01:45','2025-03-31 07:01:45',3,3);
/*!40000 ALTER TABLE `etl_programs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `etl_programs_cycles`
--

DROP TABLE IF EXISTS `etl_programs_cycles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `etl_programs_cycles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `program_id` int unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `cycle` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp 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_etl_programs_created_by` (`created_by`),
  KEY `fk_etl_programs_updated_by` (`updated_by`),
  KEY `fk_etl_programs_cycles_program_id` (`program_id`),
  CONSTRAINT `fk_etl_programs_created_by` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `fk_etl_programs_cycles_program_id_programs` FOREIGN KEY (`program_id`) REFERENCES `etl_programs` (`id`) ON DELETE CASCADE,
  CONSTRAINT `fk_etl_programs_updated_by` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `etl_programs_cycles`
--

LOCK TABLES `etl_programs_cycles` WRITE;
/*!40000 ALTER TABLE `etl_programs_cycles` DISABLE KEYS */;
INSERT INTO `etl_programs_cycles` VALUES (6,1,'Bsc in Population - 1',1,'2024-11-07 10:35:54','2025-03-30 08:01:55',3,3),(7,2,'Bsc in Population - 2',2,'2024-11-07 10:36:27','2025-03-30 08:01:55',3,3),(8,3,'Bsc in Governance 1',1,'2024-11-07 11:39:48','2025-03-30 08:01:55',3,3),(9,4,'Bsc Computer Science 1',1,'2024-11-11 13:09:49','2025-03-30 08:01:55',3,3),(10,5,'Civil Engineering - 3',3,'2025-03-29 15:25:52','2025-03-31 07:00:45',3,3),(18,8,'Nursing Testing - 1',1,'2025-03-31 07:01:45','2025-03-31 07:01:45',3,3),(19,8,'Nursing Testing - 2',2,'2025-03-31 07:01:45','2025-03-31 07:01:45',3,3),(20,8,'Nursing Testing - 3',3,'2025-03-31 07:01:45','2025-03-31 07:01:45',3,3),(21,8,'Nursing Testing - 4',4,'2025-03-31 07:01:45','2025-03-31 07:01:45',3,3);
/*!40000 ALTER TABLE `etl_programs_cycles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `etl_qualifications_basis`
--

DROP TABLE IF EXISTS `etl_qualifications_basis`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `etl_qualifications_basis` (
  `id` int NOT NULL AUTO_INCREMENT,
  `total_full_courses` int DEFAULT NULL,
  `total_half_courses` int DEFAULT NULL,
  `total_students` int DEFAULT NULL,
  `multiple_claims` tinyint(1) DEFAULT '0',
  `academic_year_id` int unsigned DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `updated_by` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `academic_year_id` (`academic_year_id`),
  KEY `created_by` (`created_by`),
  KEY `updated_by` (`updated_by`),
  CONSTRAINT `etl_qualifications_basis_ibfk_1` FOREIGN KEY (`academic_year_id`) REFERENCES `etl_academic_years` (`id`),
  CONSTRAINT `etl_qualifications_basis_ibfk_2` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `etl_qualifications_basis_ibfk_3` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=60 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `etl_qualifications_basis`
--

LOCK TABLES `etl_qualifications_basis` WRITE;
/*!40000 ALTER TABLE `etl_qualifications_basis` DISABLE KEYS */;
INSERT INTO `etl_qualifications_basis` VALUES (6,2,4,76,0,4,NULL,NULL,'2024-11-07 10:48:52','2024-11-07 10:48:52'),(20,2,4,76,0,39,3,3,'2024-11-07 10:48:52','2024-11-07 10:48:52'),(22,2,4,76,0,52,3,3,'2024-11-07 10:48:52','2025-02-27 10:20:54'),(23,2,4,76,0,53,3,3,'2024-11-07 10:48:52','2024-11-07 10:48:52'),(26,2,4,76,0,60,3,3,'2024-11-07 10:48:52','2024-11-07 10:48:52'),(59,2,4,76,0,61,3,3,'2024-11-07 10:48:52','2025-02-27 10:20:46');
/*!40000 ALTER TABLE `etl_qualifications_basis` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

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

-- Dump completed on 2025-04-15 12:24:00
