text: -- MySQL dump 10.13  Distrib 8.0.18, for Win64 (x86_64)
  --
  -- Host: localhost    Database: isotrackingproduction
  -- ------------------------------------------------------
  -- Server version	5.7.23
  
  /*!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 `assesor_per_programs`
  --
  
  DROP TABLE IF EXISTS `assesor_per_programs`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `assesor_per_programs` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `program_id` bigint(20) unsigned NOT NULL,
    PRIMARY KEY (`id`),
    KEY `assesor_per_programs_program_id_foreign` (`program_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `assesor_per_programs`
  --
  
  LOCK TABLES `assesor_per_programs` WRITE;
  /*!40000 ALTER TABLE `assesor_per_programs` DISABLE KEYS */;
  INSERT INTO `assesor_per_programs` VALUES (1,NULL,NULL,'itsms@mail.com',1),(27,'2019-12-08 20:34:57','2019-12-08 20:35:48','bcms@mail.com',226),(3,NULL,NULL,'isms@mail.com',3),(4,NULL,NULL,'ems@mail.com',4),(5,NULL,NULL,'qms@mail.com',5),(6,NULL,NULL,'admin@mail.com',0),(23,'2019-12-05 04:07:21','2019-12-05 04:07:21','csr3@mail.com',223),(25,'2019-12-05 08:02:37','2019-12-05 08:02:37','qmcsms@mail.com',225);
  /*!40000 ALTER TABLE `assesor_per_programs` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `closed_non_conformity_evidence`
  --
  
  DROP TABLE IF EXISTS `closed_non_conformity_evidence`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `closed_non_conformity_evidence` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `clossureDate` date NOT NULL,
    `briefDescription` text COLLATE utf8_unicode_ci NOT NULL,
    `locationOfEvidence` text COLLATE utf8_unicode_ci NOT NULL,
    `nonConformity_id` bigint(20) unsigned NOT NULL,
    PRIMARY KEY (`id`),
    KEY `closed_non_conformity_evidence_nonconformity_id_foreign` (`nonConformity_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `closed_non_conformity_evidence`
  --
  
  LOCK TABLES `closed_non_conformity_evidence` WRITE;
  /*!40000 ALTER TABLE `closed_non_conformity_evidence` DISABLE KEYS */;
  /*!40000 ALTER TABLE `closed_non_conformity_evidence` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `key_perfomace_indicators`
  --
  
  DROP TABLE IF EXISTS `key_perfomace_indicators`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `key_perfomace_indicators` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `strategic_objective_id` bigint(20) unsigned DEFAULT NULL,
    `perspective_id` bigint(20) unsigned DEFAULT NULL,
    `arithmeticStructure` int(11) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `target` double NOT NULL,
    `period` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    KEY `key_perfomace_indicators_strategicobjective_id_foreign` (`strategic_objective_id`),
    KEY `key_perfomace_indicators_perspective_id_foreign` (`perspective_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=255 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `key_perfomace_indicators`
  --
  
  LOCK TABLES `key_perfomace_indicators` WRITE;
  /*!40000 ALTER TABLE `key_perfomace_indicators` DISABLE KEYS */;
  INSERT INTO `key_perfomace_indicators` VALUES (113,'Percentage Of Loaded Capex Loaded Below.',1,1,0,'2019-11-16 16:55:05','2019-12-07 04:27:56',100,4),(114,'percentage_met_of_commited_capex_below',1,1,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',100,4),(115,'percentage_of_reciept_capex_below',1,1,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',100,4),(4,'percentage_of_escaleted_complaints_above',2,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',20,4),(5,'percentage_of_returned_questionaires_above',2,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',75,4),(6,'service_desk_SLA_perfomance',3,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',98.5,4),(7,'service_desk_FCR',3,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',75,4),(8,'Average_Dropped_Call_Ratio_Below',4,2,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',0.3,4),(9,'Avearge_call_setup_success_above',4,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',99.4,4),(10,'Average_Cell_Availability_above',4,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',99.85,4),(11,'Speech_quality_MOS_Above',4,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',3.8,4),(12,'Call_Setup_time_M-M_below',4,2,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',4.5,4),(13,'M-Pesa_TPSs_Count_Below',5,2,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',1100,4),(14,'M-PESA_Availability_above_inPercentage',5,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',99,4),(15,'M-PESA_Response_time_above',5,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',5,4),(16,'3G_Download_speeds_kbps',6,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',5000,4),(17,'percentage_of_download_speeds_above_3Mbps',6,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',70,4),(18,'3G_upload_speeds_in_kbps',6,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',1700,4),(19,'3G_latency_ms',6,2,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',65,4),(20,'3G_mean_web_browsing_session_time',6,2,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',8,4),(21,'4G_download_speeds_in_Kbps',6,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',10,4),(22,'percentage_of_4G_download_connection_above_1mbps',6,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',92,4),(23,'4G_ipload_speeds_in_Kbps_above',6,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',7,4),(24,'4G_latency_in_ms_above',6,2,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',42,4),(25,'4G_mean_browsing_session_below',6,2,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',4.2,4),(26,'3G_youtube_reproductions_without_inerruption',6,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',97,4),(27,'4G_youtube_reproductions_without_inerruption',6,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',99,4),(28,'percentage_of_3G_download_connections_above_1Mbps',6,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',90,4),(29,'percentage_of_4G_download_connections_above_3Mbps',6,2,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',90,4),(30,'change_success_rate',7,3,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',93,4),(31,'change_related_incidents',7,3,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',1,4),(32,'change_roll_back',7,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',5,4),(33,'emmergency_changes',7,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',5,4),(34,'unauthorised_changes',7,3,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',0,4),(35,'closed_crqs',7,3,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',85,4),(36,'change_rescheduling',7,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',5,4),(37,'incidents_escalation_times(DIT)',8,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',20,4),(38,'incidents_report_comliance_within_24Hrs_of_service',8,3,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',100,4),(39,'incidence_escalation_DNOC',8,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',20,4),(40,'incidence_communication',8,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',15,4),(41,'incidence_notification',8,3,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',97,4),(42,'incidence_report_rate',9,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',35,4),(43,'problem_resolution_rate',9,3,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',10,4),(44,'problem_workaround_rate',9,3,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',95,4),(45,'average_problem_resolution_on_time_in_days',9,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',84,4),(46,'proactive_problem_ticket_rate',9,3,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',30,4),(47,'problem_reopen_rate',9,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',2,4),(48,'release_success_rate',10,3,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',90,4),(49,'release_resheduel_rate',10,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',1,4),(50,'release_incident_rate',10,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',1,4),(51,'known_release_errors_in_production',10,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',1,4),(52,'release_withdrawal_rate',10,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',1,4),(53,'time_to_detect_incidents',11,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',60,4),(54,'time_to_close_incidents',11,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',21,4),(55,'CPU_Utilisation_UGW',12,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',70,4),(56,'CPU_Utilisation_MSS',12,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',70,4),(57,'CPU_Utilisation_MGW',12,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',70,4),(58,'CPU_Utilisation_SGSN',12,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',70,4),(59,'CPU_Utilisation_MLG',12,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',50,4),(60,'Memory_Utilisation_UGW',13,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',70,4),(61,'Memory_Utilisation_SGSN',13,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',80,4),(62,'Memory_Utilisation_MIG',13,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',50,4),(63,'License_Utilisation_UGW',14,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',70,4),(64,'License_Utilisation_SGSN',14,3,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',70,4),(65,'No_Champions_trained',15,4,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',0,4),(66,'percentage_ITIL_foundation_comletion',15,4,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',90,4),(67,'Awareness_Attendance',15,4,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',90,4),(68,'Ensure_annual_review_of_the_Quality_management_system-_Management_Review',16,5,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',4,4),(69,'Ensure_there_are_no_repeat_non-conformities_identified_during_external_audit',16,5,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',0,4),(70,'Ensure_there_are_no_repeat_non-conformities_identified_during_internal_audit',16,5,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',0,4),(71,'Number_of_Internal_Audits_carried_out_annually',16,5,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',2,4),(72,'One_Risk_Assessment_unertaken_on_key_processes_across_the_business',17,5,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',1,4),(73,'Ensure_annual_QMS_Awareness',18,6,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',80,4),(74,'Increase_QMS_competencies_through_Training_and_awareness',19,6,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',90,4),(75,'EBU NPS Details Improve Net Promoter Score (NPS) In Relation To Customer Products And Services. Customer Satisfaction',20,7,0,'2019-11-16 16:55:05','2019-12-08 08:19:24',40,2),(76,'Customer_NPS_Details_Improve_Net_Promoter_Score_(NPS)_in_relation_to_Customer_Products_and_Services._Customer_Satisfaction',21,7,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',61,4),(77,'Ensure_Induction_for_all_New_Joiners_at_entry_point',22,7,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',100,4),(78,'Ensure_Customer_Quality_Management_in_terms_of_que_Management(HVC)_Hustler_section',22,7,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',85,4),(79,'Ensure_Customer_Quality_Management_in_terms_of_que_Management(HVC)_DP_section',22,7,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',85,4),(80,'Ensure_Customer_Quality_Management_in_terms_of_que_Management(HVC)_Post_Pay_section',22,7,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',85,4),(81,'Ensure_Customer_Quality_Management_in_terms_of_que_Management(HVC)_Enterprise_section',22,7,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',85,4),(82,'Ensure_Customer_Quality_Management_in_terms_of_que_Management_(YOUTH)',22,7,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',80,4),(83,'Ensure_Customer_Quality_Management_in_terms_of_que_Management_(MASS)',22,7,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',80,4),(84,'Ensure_Customer_Quality_Management_in_terms_of_Repeat_caller_FCR(First_Contact_Resolution)',22,7,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',75,4),(85,'Ensure_Customer_Quality_Management_in_terms_of__Offered_Calls',22,7,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',123543,4),(86,'Ensure_Customer_Quality_Management_in_terms_of_answered_Calls',22,7,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',117366,4),(87,'Ensure_Customer_Quality_Management_in_terms_of_abandoned_calls',22,7,0,'2019-11-16 16:55:05','2019-11-16 16:55:05',23,4),(88,'Cumulative_fraud_information_security_incidents_leading_to_financial_loss(_impact_of_4_to_5)',25,9,3,'2019-11-16 16:55:05','2019-11-16 16:55:05',3,4),(89,'Successful_ISO_27001_external_audit_(not_more_than_1_minor)_BSI',26,9,4,'2019-11-16 16:55:05','2019-11-16 16:55:05',1,4),(90,'Number_of_high_risk_issues_raised_by_External_audit_on_access_management',26,9,5,'2019-11-16 16:55:05','2019-11-16 16:55:05',0,4),(91,'Percentage_of_unauthorized_or_incorrect_changes_that_have_led_to_service_downtimes_services_of_customer_facing_services',27,10,6,'2019-11-16 16:55:05','2019-11-16 16:55:05',1,4),(92,'Number_of_incidents_related_to_breached_customer_information(_at_a_max_4_per_week)',28,10,7,'2019-11-16 16:55:05','2019-11-16 16:55:05',36,4),(93,'Percentage_of_active_antivirus_installed_on_desktops_and_laptops',29,11,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',95,4),(94,'Percentage_of_workstations_with_ISE_configuration(NAC)',29,11,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',100,4),(95,'Percentage_coverage_of_pentest_across_Cloud,_M-PESA,_Mobile_Data,_Customer_Support_and_Billing',29,11,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',100,4),(96,'Percentage_coverage_of_VA(PVMG)_across_Cloud,_M-PESA,_Mobile_Data,_Customer_Support_and_Billing',29,11,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',100,4),(97,'Percentage_of_group_1(Criticality_league)_systems_found_without_critical_vulnerabilties_which_can_lead_to_direct_unauthorized_access',29,11,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',100,4),(98,'Number_of_risk_assessment_cycles_carried_out_during_the_year',30,11,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',2,4),(99,'Number_of_scheduled_3rd_party_risk_assessments_conducted',30,11,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',9,4),(100,'Number_of_management_reviews_carried_out_during_the_year',30,11,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',2,4),(101,'Percentage_mandatory_ISMS_documents_reviewed',30,11,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',100,4),(102,'Number_of_internal_audits_carried_out_annually',30,11,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',1,4),(103,'Number_of_systems_in_logging_scope_whose_logs_are_collected_centrally_across_13_parameters',31,11,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',100,4),(104,'Percentage_of_monthly_user_access_reviews_completed_by_information_owners',32,11,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',100,4),(105,'Percentage_of_independent_user_access_reviews_per_schedule',32,11,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',100,4),(106,'Percentage_of_users_who_resisted_phishing_attempts',33,12,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',90,4),(107,'Percentage_of_all_new_staff_who_complete_the_induction',33,12,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',100,4),(108,'Percentage_of_all_members_of_staff_who_complete_the_quiz',33,12,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',90,4),(109,'Number_of_IRC_team_members_who_have_completed_the_ISO_27001_Lead_Implementer_course',34,12,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',80,4),(110,'Number_of_IRC_team_members_who_have_completed_the_Cyber_Risk_training',34,12,1,'2019-11-16 16:55:05','2019-11-16 16:55:05',80,4),(116,'Reduce electricity consumption of 141,499 MWh by 2 %. This considers increase in the number of sites',35,13,1,'2019-11-25 06:20:00','2019-11-25 06:20:00',34675,4),(253,'Number of management reviews carried out',47,70,1,'2020-01-08 04:23:30','2020-01-08 04:23:30',2,1),(117,'Reduce diesel consumption (gensets) of 9,639,517 L by 5 %  (This considers increase in the number of sites)',35,13,1,'2019-11-25 06:20:00','2019-11-25 06:20:00',2361682,4),(118,'Reduce carbon emission of 63,685 tCO2e by 4 %',35,13,1,'2019-11-25 06:20:00','2019-11-25 06:20:00',15285,4),(119,'Reduce water consumption of 91,449 m3 by 2 %',35,13,1,'2019-11-25 06:20:00','2019-11-25 06:20:00',22405,4),(120,'Reduce solid waste to dumpsites from the main corporate facilities by 90%',35,13,1,'2019-11-25 06:20:00','2019-11-25 06:20:00',23,4),(121,'Number of internal audits carried out for ISO14001 within the financial year ',35,13,1,'2019-11-25 06:20:00','2019-11-25 06:20:00',1,4),(122,'Conduct mandatory Regulatory Environmental audits for all BTS sites constructed ln the previous year, Retail centres, MSRs and main corporate offices - 325 sites.',36,13,1,'2019-11-25 06:20:00','2019-11-25 06:20:00',81.25,4),(123,'Noise Zero tolerance for non-Compliance on Enviromental standards',36,13,1,'2019-11-25 06:20:00','2019-11-25 06:20:00',0,4),(124,'EMF Zero tolerance for non-Compliance on Enviromental standards',36,13,1,'2019-11-25 06:20:00','2019-11-25 06:20:00',0,4),(125,'Air Quality Zero tolerance for non-Compliance on Enviromental standards',36,13,1,'2019-11-25 06:20:00','2019-11-25 06:20:00',0,4),(126,'Staff awareness campaigns carried out in the year (4)',37,13,1,'2019-11-25 06:20:00','2019-11-25 06:20:00',1,4),(127,'Increase volume of E-Waste collected from 223 tonnes by 20%',37,13,1,'2019-11-25 06:20:00','2019-11-25 06:20:00',67,4),(128,'Training sessions carried on to our staff on ISO14001',37,13,1,'2019-11-25 06:20:00','2019-11-25 06:20:00',67,4),(251,'No of business continuity risks in the top 10 companywide risk register',47,70,1,'2020-01-08 04:22:43','2020-01-08 04:22:43',1,1),(131,'trail Objective',38,60,1,'2019-12-05 05:02:32','2019-12-05 05:02:32',52,4),(250,'Number of Internal Audits carried out annually',47,70,1,'2020-01-08 04:21:28','2020-01-08 04:21:28',1,1),(135,'trial Adding',40,64,1,'2019-12-08 01:25:48','2019-12-08 01:25:48',45,2),(254,'Number of major non conformities identified during the internal audit',47,70,0,'2020-01-08 04:24:00','2020-01-08 04:24:00',1,1),(252,'Percentage mandatory BCMS up to date',47,70,1,'2020-01-08 04:23:11','2020-01-08 04:23:11',95,1),(248,'Number of drills carried out per key facility (HQ1&2,SCC,JCC and HQ3)',46,70,1,'2020-01-08 04:20:45','2020-01-08 04:20:45',9,1),(246,'Number of new strategic systems/Mission Critical implemented without adequate DR',46,70,0,'2020-01-08 04:19:54','2020-01-08 04:19:54',0,4),(247,'Number of site risk assessments carried out for key sites (HQ1&2, SCC, JCC, HQ3, Thika, QoA, Gospel, Kiboswa, Mombasa and Nakuru)',46,70,1,'2020-01-08 04:20:23','2020-01-08 04:20:23',3,1),(245,'Percentage of disaster recovery tests passed',46,70,1,'2020-01-08 04:19:31','2020-01-08 04:19:31',90,1),(244,'Percentage of Disaster Recovery tests carried out for critical systems during the year',46,70,1,'2020-01-08 04:19:09','2020-01-08 04:19:09',90,1),(243,'Percentage Of Technology BC Champions Staff With BCM Objectives Defined',49,69,1,'2020-01-08 04:18:26','2020-01-08 04:18:26',90,1),(241,'Number of employee awareness campaigns carried out during the year',48,69,1,'2020-01-08 04:17:11','2020-01-08 04:17:11',1,1),(240,'Number of induction sessions held during the year for BCM induction training',48,69,1,'2020-01-08 04:16:38','2020-01-08 04:16:38',3,4),(239,'Number of incidents where CMT is activated per quarter',50,68,0,'2020-01-08 04:15:06','2020-01-08 04:15:06',4,4),(236,'Reduce The Number Of Incidents Meeting Crisis Thresholds Per Quarter',45,67,0,'2020-01-08 04:12:51','2020-01-08 04:12:51',4,4),(237,'Number of crisis incidents that exceed the defined Maximum Torelabe Recovery Time Objectives',50,68,0,'2020-01-08 04:14:05','2020-01-08 04:14:05',0,4),(238,'Percentage of crisis management activations sorted before disaster threshold',50,68,1,'2020-01-08 04:14:38','2020-01-08 04:14:38',90,1),(235,'Crisis activation leading to financial loss above 100-500M (serious Harm)',45,67,0,'2020-01-08 04:12:27','2020-01-08 04:12:27',0,4),(229,'We have a zero tolerance for regulatory breaches on BCMS -NRRD guideliness as defined by CA',44,67,0,'2020-01-08 04:10:30','2020-01-08 04:10:30',0,4),(230,'We have a zero tolerance for contractual BCM breaches',44,67,0,'2020-01-08 04:10:43','2020-01-08 04:10:43',0,4),(231,'We have zero tolerance for health and safety risk e.g. loss of life (while on duty/company premises)',44,67,0,'2020-01-08 04:11:00','2020-01-08 04:11:00',0,4),(232,'Incidents that required reporting to the regulator',44,67,0,'2020-01-08 04:11:23','2020-01-08 04:11:23',1,4),(221,'vip',42,8,1,'2019-12-23 01:42:30','2019-12-23 01:42:30',50,4),(218,'append to',42,8,1,'2019-12-22 10:54:31','2019-12-22 10:54:31',50,4),(219,'add',42,8,1,'2019-12-22 10:58:27','2019-12-22 10:58:27',50,4),(220,'SPOC.',42,8,1,'2019-12-22 11:01:59','2019-12-22 11:01:59',56,4),(208,'first',43,8,1,'2019-12-22 10:02:37','2019-12-22 10:02:37',50,4),(209,'Number of major non conformities identified during the internal audit',42,8,1,'2019-12-22 10:04:44','2019-12-22 10:04:44',45,4),(210,'ambasesds',43,8,1,'2019-12-22 10:05:40','2019-12-22 10:05:40',50,4),(211,'asad',43,8,1,'2019-12-22 10:07:11','2019-12-22 10:07:11',50,4),(212,'lomomolo',43,8,1,'2019-12-22 10:09:44','2019-12-22 10:09:44',50,4),(213,'dom',43,8,1,'2019-12-22 10:11:05','2019-12-22 10:11:05',50,4),(214,'celine',43,8,1,'2019-12-22 10:45:50','2019-12-22 10:45:50',5,4),(215,'DOM TRIAL',43,8,1,'2019-12-22 10:48:19','2019-12-22 10:48:19',80,4),(216,'DOM TRIAL',42,8,1,'2019-12-22 10:48:41','2019-12-22 10:48:41',50,4),(217,'TRWJD',43,8,1,'2019-12-22 10:50:38','2019-12-22 10:50:38',20,4);
  /*!40000 ALTER TABLE `key_perfomace_indicators` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `key_perfomance_indicator_scores`
  --
  
  DROP TABLE IF EXISTS `key_perfomance_indicator_scores`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `key_perfomance_indicator_scores` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `year` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `ytd` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `kpi_id` bigint(20) unsigned NOT NULL,
    `strategic_objective_id` bigint(20) unsigned NOT NULL,
    `score` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `quater` varchar(155) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    KEY `key_perfomance_indicator_scores_kpi_id_foreign` (`kpi_id`),
    KEY `key_perfomance_indicator_scores_strategicobjective_id_foreign` (`strategic_objective_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=181 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `key_perfomance_indicator_scores`
  --
  
  LOCK TABLES `key_perfomance_indicator_scores` WRITE;
  /*!40000 ALTER TABLE `key_perfomance_indicator_scores` DISABLE KEYS */;
  INSERT INTO `key_perfomance_indicator_scores` VALUES (1,'2019/2020','90',113,1,'100','2019-12-31 08:04:28','2019-12-31 08:04:28','Q2'),(2,'2019/2020','100',114,1,'100','2019-12-31 08:04:28','2019-12-31 08:04:28','Q2'),(3,'2019/2020','100',115,1,'100','2019-12-31 08:04:28','2019-12-31 08:04:28','Q2'),(4,'2019/2020','89',113,1,'100','2019-12-31 08:05:46','2019-12-31 08:05:46','Q1'),(5,'2019/2020','89',114,1,'100','2019-12-31 08:05:46','2019-12-31 08:05:46','Q1'),(6,'2019/2020','89',115,1,'100','2019-12-31 08:05:46','2019-12-31 08:05:46','Q1'),(7,'2019/2020','20',4,2,'100','2019-12-31 10:27:49','2019-12-31 10:27:49','Q1'),(8,'2019/2020','75',5,2,'100','2019-12-31 10:27:49','2019-12-31 10:27:49','Q1'),(9,'2019/2020','98',6,3,'99.49238578680203','2019-12-31 10:28:15','2019-12-31 10:28:15','Q1'),(10,'2019/2020','70',7,3,'93.33333333333333','2019-12-31 10:28:15','2019-12-31 10:28:15','Q1'),(11,'2019/2020','0.2',8,4,'100','2019-12-31 10:29:01','2019-12-31 10:29:01','Q1'),(12,'2019/2020','99',9,4,'99.59758551307847','2019-12-31 10:29:01','2019-12-31 10:29:01','Q1'),(13,'2019/2020','99',10,4,'99.14872308462694','2019-12-31 10:29:01','2019-12-31 10:29:01','Q1'),(14,'2019/2020','3.5',11,4,'92.10526315789474','2019-12-31 10:29:01','2019-12-31 10:29:01','Q1'),(15,'2019/2020','4.5',12,4,'100','2019-12-31 10:29:01','2019-12-31 10:29:01','Q1'),(16,'2019/2020','1101',13,5,'0.09082652134423251','2019-12-31 10:29:24','2019-12-31 10:29:24','Q1'),(17,'2019/2020','99',14,5,'100','2019-12-31 10:29:24','2019-12-31 10:29:24','Q1'),(18,'2019/2020','5',15,5,'100','2019-12-31 10:29:24','2019-12-31 10:29:24','Q1'),(19,'2019/2020','5001',16,6,'100','2019-12-31 10:30:41','2019-12-31 10:30:41','Q1'),(20,'2019/2020','71',17,6,'100','2019-12-31 10:30:41','2019-12-31 10:30:41','Q1'),(21,'2019/2020','1600',18,6,'94.11764705882352','2019-12-31 10:30:41','2019-12-31 10:36:18','Q1'),(22,'2019/2020','66',19,6,'1.5151515151515151','2019-12-31 10:30:41','2019-12-31 10:36:18','Q1'),(23,'2019/2020','8',20,6,'100','2019-12-31 10:30:41','2019-12-31 10:30:41','Q1'),(24,'2019/2020','10',21,6,'100','2019-12-31 10:30:41','2019-12-31 10:30:41','Q1'),(25,'2019/2020','92',22,6,'100','2019-12-31 10:30:41','2019-12-31 10:30:41','Q1'),(26,'2019/2020','8',23,6,'100','2019-12-31 10:30:41','2019-12-31 10:30:41','Q1'),(27,'2019/2020','44',24,6,'4.545454545454546','2019-12-31 10:30:41','2019-12-31 10:36:18','Q1'),(28,'2019/2020','99',30,7,'100','2019-12-31 10:31:11','2019-12-31 10:31:11','Q1'),(29,'2019/2020','1',31,7,'100','2019-12-31 10:31:11','2019-12-31 10:31:11','Q1'),(30,'2019/2020','4',32,7,'100','2019-12-31 10:31:11','2019-12-31 10:31:11','Q1'),(31,'2019/2020','3',33,7,'100','2019-12-31 10:31:11','2019-12-31 10:31:11','Q1'),(32,'2019/2020','1',34,7,'100','2019-12-31 10:31:11','2019-12-31 10:31:11','Q1'),(33,'2019/2020','88',35,7,'100','2019-12-31 10:31:11','2019-12-31 10:31:11','Q1'),(34,'2019/2020','9',36,7,'44.44444444444444','2019-12-31 10:31:11','2019-12-31 10:31:11','Q1'),(35,'2019/2020','22',37,8,'9.090909090909092','2019-12-31 10:31:55','2019-12-31 10:31:55','Q1'),(36,'2019/2020','10',38,8,'10','2019-12-31 10:31:55','2019-12-31 10:31:55','Q1'),(37,'2019/2020','19',39,8,'100','2019-12-31 10:31:55','2019-12-31 10:31:55','Q1'),(38,'2019/2020','15',40,8,'100','2019-12-31 10:31:55','2019-12-31 10:31:55','Q1'),(39,'2019/2020','99',41,8,'100','2019-12-31 10:31:55','2019-12-31 10:31:55','Q1'),(40,'2019/2020','33',42,9,'100','2019-12-31 10:32:23','2019-12-31 10:32:23','Q1'),(41,'2019/2020','9',43,9,'90','2019-12-31 10:32:23','2019-12-31 10:32:23','Q1'),(42,'2019/2020','99',44,9,'100','2019-12-31 10:32:23','2019-12-31 10:32:23','Q1'),(43,'2019/2020','80',45,9,'100','2019-12-31 10:32:23','2019-12-31 10:32:23','Q1'),(44,'2019/2020','36',46,9,'100','2019-12-31 10:32:23','2019-12-31 10:32:23','Q1'),(45,'2019/2020','0',47,9,'100','2019-12-31 10:32:23','2019-12-31 10:32:23','Q1'),(46,'2019/2020','90',48,10,'100','2019-12-31 10:32:57','2019-12-31 10:32:57','Q1'),(47,'2019/2020','0',49,10,'100','2019-12-31 10:32:57','2019-12-31 10:32:57','Q1'),(48,'2019/2020','0',50,10,'100','2019-12-31 10:32:57','2019-12-31 10:32:57','Q1'),(49,'2019/2020','2',51,10,'50','2019-12-31 10:32:57','2019-12-31 10:32:57','Q1'),(50,'2019/2020','2',52,10,'50','2019-12-31 10:32:57','2019-12-31 10:32:57','Q1'),(51,'2019/2020','59',53,11,'100','2019-12-31 10:33:05','2019-12-31 10:33:05','Q1'),(52,'2019/2020','20',54,11,'100','2019-12-31 10:33:05','2019-12-31 10:33:05','Q1'),(53,'2019/2020','66',55,12,'100','2019-12-31 10:33:44','2019-12-31 10:33:44','Q1'),(54,'2019/2020','74',56,12,'5.405405405405405','2019-12-31 10:33:44','2019-12-31 10:33:44','Q1'),(55,'2019/2020','71',57,12,'1.4084507042253522','2019-12-31 10:33:44','2019-12-31 10:33:44','Q1'),(56,'2019/2020','71',58,12,'1.4084507042253522','2019-12-31 10:33:44','2019-12-31 10:33:44','Q1'),(57,'2019/2020','50',59,12,'100','2019-12-31 10:33:44','2019-12-31 10:33:44','Q1'),(58,'2019/2020','69',60,13,'100','2019-12-31 10:33:55','2019-12-31 10:33:55','Q1'),(59,'2019/2020','79',61,13,'100','2019-12-31 10:33:55','2019-12-31 10:33:55','Q1'),(60,'2019/2020','49',62,13,'100','2019-12-31 10:33:55','2019-12-31 10:33:55','Q1'),(61,'2019/2020','80',63,14,'12.5','2019-12-31 10:34:12','2019-12-31 10:34:12','Q1'),(62,'2019/2020','69',64,14,'100','2019-12-31 10:34:12','2019-12-31 10:34:12','Q1'),(63,'2019/2020','0',65,15,'0','2019-12-31 10:34:35','2019-12-31 10:34:35','Q1'),(64,'2019/2020','100',66,15,'100','2019-12-31 10:34:35','2019-12-31 10:34:35','Q1'),(65,'2019/2020','94',67,15,'4.25531914893617','2019-12-31 10:34:35','2019-12-31 10:34:35','Q1'),(66,'2019/2020','4.3',25,6,'2.3255813953488293','2019-12-31 10:36:18','2019-12-31 10:36:18','Q1'),(67,'2019/2020','99',26,6,'100','2019-12-31 10:36:18','2019-12-31 10:36:18','Q1'),(68,'2019/2020','99',27,6,'100','2019-12-31 10:36:18','2019-12-31 10:36:18','Q1'),(69,'2019/2020','89',28,6,'98.88888888888889','2019-12-31 10:36:18','2019-12-31 10:36:18','Q1'),(70,'2019/2020','90',29,6,'100','2019-12-31 10:36:18','2019-12-31 10:36:18','Q1'),(71,'2019/2020','89',4,2,'100','2019-12-31 10:37:33','2019-12-31 10:37:33','Q2'),(72,'2019/2020','65',5,2,'86.66666666666667','2019-12-31 10:37:33','2019-12-31 10:37:33','Q2'),(73,'2019/2020','99',6,3,'100','2019-12-31 10:37:48','2019-12-31 10:37:48','Q2'),(74,'2019/2020','69',7,3,'92','2019-12-31 10:37:48','2019-12-31 10:37:48','Q2'),(75,'2019/2020','0.1',8,4,'100','2019-12-31 10:38:21','2019-12-31 10:38:21','Q2'),(76,'2019/2020','100',9,4,'100','2019-12-31 10:38:21','2019-12-31 10:38:21','Q2'),(77,'2019/2020','75',10,4,'75.11266900350526','2019-12-31 10:38:21','2019-12-31 10:38:21','Q2'),(78,'2019/2020','3.5',11,4,'92.10526315789474','2019-12-31 10:38:21','2019-12-31 10:38:21','Q2'),(79,'2019/2020','4.2',12,4,'100','2019-12-31 10:38:21','2019-12-31 10:38:21','Q2'),(80,'2019/2020','1001',13,5,'100','2019-12-31 10:38:43','2019-12-31 10:38:43','Q2'),(81,'2019/2020','85',14,5,'85.85858585858585','2019-12-31 10:38:43','2019-12-31 10:38:43','Q2'),(82,'2019/2020','5',15,5,'100','2019-12-31 10:38:43','2019-12-31 10:38:43','Q2'),(83,'2019/2020','8974',16,6,'100','2019-12-31 12:12:37','2019-12-31 12:12:37','Q2'),(84,'2019/2020','63',17,6,'90','2019-12-31 12:12:37','2019-12-31 12:12:37','Q2'),(85,'2019/2020','1630',18,6,'95.88235294117648','2019-12-31 12:12:37','2019-12-31 13:22:36','Q2'),(86,'2019/2020','96',19,6,'32.29166666666667','2019-12-31 12:12:37','2019-12-31 13:22:36','Q2'),(87,'2019/2020','9',20,6,'11.11111111111111','2019-12-31 12:12:37','2019-12-31 13:22:36','Q2'),(88,'2019/2020','10',21,6,'100','2019-12-31 12:12:38','2019-12-31 12:12:38','Q2'),(89,'2019/2020','99',22,6,'100','2019-12-31 12:12:38','2019-12-31 12:12:38','Q2'),(90,'2019/2020','7',23,6,'100','2019-12-31 12:12:38','2019-12-31 12:12:38','Q2'),(91,'2019/2020','40',24,6,'100','2019-12-31 12:12:38','2019-12-31 12:12:38','Q2'),(92,'2019/2020','4.2',25,6,'100','2019-12-31 12:12:38','2019-12-31 12:12:38','Q2'),(93,'2019/2020','80',26,6,'82.4742268041237','2019-12-31 12:12:38','2019-12-31 13:22:36','Q2'),(94,'2019/2020','90',27,6,'90.9090909090909','2019-12-31 12:12:38','2019-12-31 13:22:36','Q2'),(95,'2019/2020','80',28,6,'88.88888888888889','2019-12-31 12:12:38','2019-12-31 13:22:36','Q2'),(96,'2019/2020','88',29,6,'97.77777777777777','2019-12-31 12:12:38','2019-12-31 13:22:36','Q2'),(97,'2019/2020','90',30,7,'96.7741935483871','2019-12-31 12:13:16','2019-12-31 12:13:16','Q2'),(98,'2019/2020','1',31,7,'100','2019-12-31 12:13:16','2019-12-31 12:13:16','Q2'),(99,'2019/2020','4',32,7,'100','2019-12-31 12:13:16','2019-12-31 12:13:16','Q2'),(100,'2019/2020','3',33,7,'100','2019-12-31 12:13:16','2019-12-31 12:13:16','Q2'),(101,'2019/2020','1',34,7,'100','2019-12-31 12:13:16','2019-12-31 12:13:16','Q2'),(102,'2019/2020','88',35,7,'100','2019-12-31 12:13:16','2019-12-31 12:13:16','Q2'),(103,'2019/2020','20',36,7,'75','2019-12-31 12:13:16','2019-12-31 12:13:16','Q2'),(104,'2019/2020','20',37,8,'100','2019-12-31 12:13:47','2019-12-31 12:13:47','Q2'),(105,'2019/2020','89',38,8,'89','2019-12-31 12:13:47','2019-12-31 12:13:47','Q2'),(106,'2019/2020','80',39,8,'75','2019-12-31 12:13:47','2019-12-31 12:13:47','Q2'),(107,'2019/2020','10',40,8,'100','2019-12-31 12:13:47','2019-12-31 12:13:47','Q2'),(108,'2019/2020','99',41,8,'100','2019-12-31 12:13:47','2019-12-31 12:13:47','Q2'),(109,'2019/2020','30',42,9,'100','2019-12-31 12:14:25','2019-12-31 12:14:25','Q2'),(110,'2019/2020','8',43,9,'80','2019-12-31 12:14:25','2019-12-31 12:14:25','Q2'),(111,'2019/2020','9',44,9,'9.473684210526317','2019-12-31 12:14:25','2019-12-31 12:14:25','Q2'),(112,'2019/2020','90',45,9,'6.666666666666667','2019-12-31 12:14:25','2019-12-31 12:14:25','Q2'),(113,'2019/2020','30',46,9,'100','2019-12-31 12:14:25','2019-12-31 12:14:25','Q2'),(114,'2019/2020','0',47,9,'100','2019-12-31 12:14:25','2019-12-31 12:14:25','Q2'),(115,'2019/2020','90',48,10,'100','2019-12-31 12:14:44','2019-12-31 12:14:44','Q2'),(116,'2019/2020','0',49,10,'100','2019-12-31 12:14:44','2019-12-31 12:14:44','Q2'),(117,'2019/2020','0',50,10,'100','2019-12-31 12:14:44','2019-12-31 12:14:44','Q2'),(118,'2019/2020','1',51,10,'100','2019-12-31 12:14:44','2019-12-31 12:14:44','Q2'),(119,'2019/2020','3',52,10,'66.66666666666666','2019-12-31 12:14:44','2019-12-31 12:14:44','Q2'),(120,'2019/2020','89',53,11,'32.58426966292135','2019-12-31 12:15:00','2019-12-31 12:15:00','Q2'),(121,'2019/2020','21',54,11,'100','2019-12-31 12:15:00','2019-12-31 12:15:00','Q2'),(122,'2019/2020','69',55,12,'100','2019-12-31 12:15:45','2019-12-31 12:15:45','Q2'),(123,'2019/2020','74',56,12,'5.405405405405405','2019-12-31 12:15:45','2019-12-31 12:15:45','Q2'),(124,'2019/2020','90',57,12,'22.22222222222222','2019-12-31 12:15:45','2019-12-31 12:15:45','Q2'),(125,'2019/2020','80',58,12,'12.5','2019-12-31 12:15:45','2019-12-31 12:15:45','Q2'),(126,'2019/2020','96',59,12,'47.91666666666667','2019-12-31 12:15:45','2019-12-31 12:15:45','Q2'),(127,'2019/2020','60',60,13,'100','2019-12-31 12:16:02','2019-12-31 12:16:02','Q2'),(128,'2019/2020','79',61,13,'100','2019-12-31 12:16:02','2019-12-31 12:16:02','Q2'),(129,'2019/2020','49',62,13,'100','2019-12-31 12:16:02','2019-12-31 12:16:02','Q2'),(130,'2019/2020','70',63,14,'100','2019-12-31 12:16:09','2019-12-31 12:16:09','Q2'),(131,'2019/2020','66',64,14,'100','2019-12-31 12:16:09','2019-12-31 12:16:09','Q2'),(132,'2019/2020','3',65,15,'100','2019-12-31 12:16:35','2019-12-31 12:16:35','Q2'),(133,'2019/2020','15',66,15,'16.666666666666664','2019-12-31 12:16:35','2019-12-31 12:16:35','Q2'),(134,'2019/2020','99',67,15,'9.090909090909092','2019-12-31 12:16:35','2019-12-31 12:16:35','Q2'),(135,'2019/2020','1',89,26,'100','2019-12-31 13:25:18','2019-12-31 13:25:18','Q2'),(136,'2019/2020','0',90,26,'100','2019-12-31 13:25:18','2019-12-31 13:25:18','Q2'),(137,'2019/2020','3',88,25,'70','2019-12-31 13:25:19','2019-12-31 13:25:19','Q2'),(138,'2019/2020','1',91,27,'100','2020-01-01 02:01:12','2020-01-01 02:01:12','Q2'),(139,'2019/2020','33',92,28,'100','2020-01-01 02:01:14','2020-01-01 02:01:14','Q2'),(140,'2019/2020','90',93,29,'94.73684210526315','2020-01-01 02:02:13','2020-01-01 02:02:13','Q2'),(141,'2019/2020','100',94,29,'100','2020-01-01 02:02:13','2020-01-01 02:02:13','Q2'),(142,'2019/2020','96',95,29,'96','2020-01-01 02:02:13','2020-01-01 02:02:13','Q2'),(143,'2019/2020','99',96,29,'99','2020-01-01 02:02:13','2020-01-01 02:02:13','Q2'),(144,'2019/2020','100',97,29,'100','2020-01-01 02:02:13','2020-01-01 02:02:13','Q2'),(145,'2019/2020','3',98,30,'100','2020-01-01 02:02:35','2020-01-01 02:02:35','Q2'),(146,'2019/2020','9',99,30,'100','2020-01-01 02:02:35','2020-01-01 02:02:35','Q2'),(147,'2019/2020','3',100,30,'100','2020-01-01 02:02:35','2020-01-01 02:02:35','Q2'),(148,'2019/2020','32',101,30,'32','2020-01-01 02:02:35','2020-01-01 02:02:35','Q2'),(149,'2019/2020','3',102,30,'100','2020-01-01 02:02:35','2020-01-01 02:02:35','Q2'),(150,'2019/2020','100',103,31,'100','2020-01-01 02:02:40','2020-01-01 02:02:40','Q2'),(151,'2019/2020','100',104,32,'100','2020-01-01 02:02:47','2020-01-01 02:02:47','Q2'),(152,'2019/2020','100',105,32,'100','2020-01-01 02:02:47','2020-01-01 02:02:47','Q2'),(153,'2019/2020','89',106,33,'98.88888888888889','2020-01-01 02:03:14','2020-01-01 02:03:14','Q2'),(154,'2019/2020','100',107,33,'100','2020-01-01 02:03:14','2020-01-01 02:03:14','Q2'),(155,'2019/2020','78',108,33,'86.66666666666667','2020-01-01 02:03:14','2020-01-01 02:03:14','Q2'),(156,'2019/2020','90',109,34,'100','2020-01-01 02:03:26','2020-01-01 02:03:26','Q2'),(157,'2019/2020','90',110,34,'100','2020-01-01 02:03:26','2020-01-01 02:03:26','Q2'),(158,'2019/2020','4',88,25,'66','2020-01-01 02:06:53','2020-01-01 02:06:53','Q1'),(159,'2019/2020','0',89,26,'0','2020-01-01 02:06:55','2020-01-01 02:06:55','Q1'),(160,'2019/2020','0',90,26,'100','2020-01-01 02:06:55','2020-01-01 02:06:55','Q1'),(161,'2019/2020','1',91,27,'100','2020-01-01 02:07:01','2020-01-01 02:07:01','Q1'),(162,'2019/2020','42',92,28,'16.66666666666667','2020-01-01 02:07:14','2020-01-01 02:07:14','Q1'),(163,'2019/2020','95',93,29,'100','2020-01-01 02:07:48','2020-01-01 02:07:48','Q1'),(164,'2019/2020','99',94,29,'99','2020-01-01 02:07:48','2020-01-01 02:07:48','Q1'),(165,'2019/2020','99',95,29,'99','2020-01-01 02:07:48','2020-01-01 02:07:48','Q1'),(166,'2019/2020','100',96,29,'100','2020-01-01 02:07:48','2020-01-01 02:07:48','Q1'),(167,'2019/2020','100',97,29,'100','2020-01-01 02:07:48','2020-01-01 02:07:48','Q1'),(168,'2019/2020','3',98,30,'100','2020-01-01 02:08:15','2020-01-01 02:08:15','Q1'),(169,'2019/2020','8',99,30,'88.88888888888889','2020-01-01 02:08:15','2020-01-01 02:08:15','Q1'),(170,'2019/2020','2',100,30,'100','2020-01-01 02:08:15','2020-01-01 02:08:15','Q1'),(171,'2019/2020','100',101,30,'100','2020-01-01 02:08:15','2020-01-01 02:08:15','Q1'),(172,'2019/2020','2',102,30,'100','2020-01-01 02:08:15','2020-01-01 02:08:15','Q1'),(173,'2019/2020','56',103,31,'56.00000000000001','2020-01-01 02:08:27','2020-01-01 02:08:27','Q1'),(174,'2019/2020','96',104,32,'96','2020-01-01 02:08:52','2020-01-01 02:08:52','Q1'),(175,'2019/2020','99',105,32,'99','2020-01-01 02:08:52','2020-01-01 02:08:52','Q1'),(176,'2019/2020','89',106,33,'98.88888888888889','2020-01-01 02:09:12','2020-01-01 02:09:12','Q1'),(177,'2019/2020','100',107,33,'100','2020-01-01 02:09:12','2020-01-01 02:09:12','Q1'),(178,'2019/2020','90',108,33,'100','2020-01-01 02:09:12','2020-01-01 02:09:12','Q1'),(179,'2019/2020','90',109,34,'100','2020-01-01 02:09:20','2020-01-01 02:09:20','Q1'),(180,'2019/2020','90',110,34,'100','2020-01-01 02:09:20','2020-01-01 02:09:20','Q1');
  /*!40000 ALTER TABLE `key_perfomance_indicator_scores` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `migrations`
  --
  
  DROP TABLE IF EXISTS `migrations`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `migrations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `migrations`
  --
  
  LOCK TABLES `migrations` WRITE;
  /*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
  INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2019_11_16_114800_create_key_perfomance_indicator_scores_table',1),(4,'2019_11_16_114801_create_programs_table',1),(5,'2019_11_16_114802_create_perspectives_table',1),(6,'2019_11_16_114803_create_strategic_objectives_table',1),(7,'2019_11_16_114804_create_key_perfomace_indicators_table',1),(8,'2019_11_16_114805_create_non_conformities_table',1),(9,'2019_11_16_114806_create_scoresRecorded_table',1),(10,'2019_11_16_111119_entrust_setup_tables',2),(11,'2019_11_16_145309_create_authorisations_table',3),(12,'2019_11_17_025241_create-strateic_objective_scores-table',4),(13,'2019_11_17_091638_create_assesor_per_programs_table',5),(14,'2019_11_19_074519_create_year_actives_table',6),(15,'2019_11_19_074657_create_quater_actives_table',6),(16,'2019_11_23_165755_create_closed_non_conformity_evidence_table',7),(17,'2019_12_10_031159_create_reports_generateds_table',8);
  /*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `non_conformities`
  --
  
  DROP TABLE IF EXISTS `non_conformities`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `non_conformities` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `year` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `quater` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `rootCause` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `openClosed` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `correction` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `correctiveAction` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `date` timestamp NULL DEFAULT NULL,
    `keyPerfomanceIndicator_id` bigint(20) unsigned NOT NULL,
    `strategicObjective_id` bigint(20) unsigned DEFAULT NULL,
    `perspective_id` bigint(20) unsigned DEFAULT NULL,
    `program_id` bigint(20) unsigned DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `non_conformities_keyperfomanceindicator_id_foreign` (`keyPerfomanceIndicator_id`),
    KEY `non_conformities_strategicobjective_id_foreign` (`strategicObjective_id`),
    KEY `non_conformities_perspective_id_foreign` (`perspective_id`),
    KEY `non_conformities_program_id_foreign` (`program_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=68 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `non_conformities`
  --
  
  LOCK TABLES `non_conformities` WRITE;
  /*!40000 ALTER TABLE `non_conformities` DISABLE KEYS */;
  INSERT INTO `non_conformities` VALUES (1,'2019/2020','Q1','$average','open','$average','$average','2019-12-15 21:00:00',6,3,2,1,'2019-12-31 10:28:01','2019-12-31 10:28:01'),(2,'2019/2020','Q1','$average','open','$average','$average','2020-01-03 21:00:00',7,3,2,1,'2019-12-31 10:28:12','2019-12-31 10:28:12'),(3,'2019/2020','Q1','$average','open','$average','$average','2020-01-03 21:00:00',9,4,2,1,'2019-12-31 10:28:31','2019-12-31 10:28:31'),(4,'2019/2020','Q1','$average','open','$average','$average','2019-12-16 21:00:00',10,4,2,1,'2019-12-31 10:28:44','2019-12-31 10:28:44'),(5,'2019/2020','Q1','$average','open','$average','$average','2019-12-23 21:00:00',11,4,2,1,'2019-12-31 10:28:55','2019-12-31 10:28:55'),(6,'2019/2020','Q1','$average','open','$average','$average','2020-01-03 21:00:00',13,5,2,1,'2019-12-31 10:29:16','2019-12-31 10:29:16'),(7,'2019/2020','Q1','$average','open','$average','$average','2020-01-03 21:00:00',18,6,2,1,'2019-12-31 10:29:41','2019-12-31 10:29:41'),(8,'2019/2020','Q1','$average','open','$average','$average','2019-12-23 21:00:00',19,6,2,1,'2019-12-31 10:29:52','2019-12-31 10:29:52'),(9,'2019/2020','Q1','$average','open','$average','$average','2019-12-23 21:00:00',24,6,2,1,'2019-12-31 10:30:13','2019-12-31 10:30:13'),(24,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',5,2,2,1,'2019-12-31 10:37:31','2019-12-31 10:37:31'),(11,'2019/2020','Q1','$average','open','$average','$average','2019-12-20 21:00:00',36,7,3,1,'2019-12-31 10:31:10','2019-12-31 10:31:10'),(12,'2019/2020','Q1','$average','open','$average','$average','2019-12-24 21:00:00',37,8,3,1,'2019-12-31 10:31:22','2019-12-31 10:31:22'),(13,'2019/2020','Q1','$average','open','$average','$average','2019-12-17 21:00:00',38,8,3,1,'2019-12-31 10:31:45','2019-12-31 10:31:45'),(14,'2019/2020','Q1','$average','open','$average','$average','2019-12-23 21:00:00',43,9,3,1,'2019-12-31 10:32:09','2019-12-31 10:32:09'),(15,'2019/2020','Q1','$average','open','$average','$average','2019-12-25 21:00:00',51,10,3,1,'2019-12-31 10:32:41','2019-12-31 10:32:41'),(16,'2019/2020','Q1','$average','open','$average','$average','2020-01-03 21:00:00',52,10,3,1,'2019-12-31 10:32:54','2019-12-31 10:32:54'),(17,'2019/2020','Q1','$average','open','$average','$average','2019-12-16 21:00:00',56,12,3,1,'2019-12-31 10:33:19','2019-12-31 10:33:19'),(18,'2019/2020','Q1','$average','open','$average','$average','2019-12-16 21:00:00',57,12,3,1,'2019-12-31 10:33:30','2019-12-31 10:33:30'),(19,'2019/2020','Q1','$average','open','$average','$average','2019-12-25 21:00:00',58,12,3,1,'2019-12-31 10:33:39','2019-12-31 10:33:39'),(20,'2019/2020','Q1','$average','open','$average','$average','2020-01-03 21:00:00',63,14,3,1,'2019-12-31 10:34:06','2019-12-31 10:34:06'),(21,'2019/2020','Q1','$average','open','$average','$average','2019-12-27 21:00:00',67,15,4,1,'2019-12-31 10:34:33','2019-12-31 10:34:33'),(22,'2019/2020','Q1','$average','open','$average','$average','2019-12-23 21:00:00',25,6,2,1,'2019-12-31 10:35:55','2019-12-31 10:35:55'),(23,'2019/2020','Q1','$average','open','$average','$average','2019-12-09 21:00:00',28,6,2,1,'2019-12-31 10:36:12','2019-12-31 10:36:12'),(25,'2019/2020','Q2','$average','open','$average','$average','2019-12-27 21:00:00',7,3,2,1,'2019-12-31 10:37:46','2019-12-31 10:37:46'),(26,'2019/2020','Q2','$average','open','$average','$average','2019-12-27 21:00:00',10,4,2,1,'2019-12-31 10:38:04','2019-12-31 10:38:04'),(27,'2019/2020','Q2','$average','open','$average','$average','2019-12-27 21:00:00',11,4,2,1,'2019-12-31 10:38:16','2019-12-31 10:38:16'),(28,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',14,5,2,1,'2019-12-31 10:38:39','2019-12-31 10:38:39'),(29,'2019/2020','Q2','$average','open','$average','$average','2019-12-11 21:00:00',17,6,2,1,'2019-12-31 10:38:59','2019-12-31 10:38:59'),(30,'2019/2020','Q2','$average','open','$average','v$average','2020-01-03 21:00:00',18,6,2,1,'2019-12-31 10:39:14','2019-12-31 10:39:14'),(31,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',19,6,2,1,'2019-12-31 10:39:26','2019-12-31 10:39:26'),(32,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',20,6,2,1,'2019-12-31 12:11:25','2019-12-31 12:11:26'),(33,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',26,6,2,1,'2019-12-31 12:12:03','2019-12-31 12:12:03'),(34,'2019/2020','Q2','$average','open','$average','$average','2019-12-27 21:00:00',27,6,2,1,'2019-12-31 12:12:13','2019-12-31 12:12:13'),(35,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',28,6,2,1,'2019-12-31 12:12:25','2019-12-31 12:12:25'),(36,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',29,6,2,1,'2019-12-31 12:12:35','2019-12-31 12:12:35'),(37,'2019/2020','Q2','$average','open','$average','$average','2019-12-26 21:00:00',30,7,3,1,'2019-12-31 12:12:53','2019-12-31 12:12:53'),(38,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',36,7,3,1,'2019-12-31 12:13:14','2019-12-31 12:13:14'),(39,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',38,8,3,1,'2019-12-31 12:13:27','2019-12-31 12:13:27'),(40,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',39,8,3,1,'2019-12-31 12:13:40','2019-12-31 12:13:40'),(41,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',43,9,3,1,'2019-12-31 12:14:00','2019-12-31 12:14:00'),(42,'2019/2020','Q2','$average','open','$average','$average','2019-12-27 21:00:00',44,9,3,1,'2019-12-31 12:14:09','2019-12-31 12:14:09'),(43,'2019/2020','Q2','$average','open','$average','$average','2019-12-19 21:00:00',45,9,3,1,'2019-12-31 12:14:19','2019-12-31 12:14:19'),(44,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',52,10,3,1,'2019-12-31 12:14:42','2019-12-31 12:14:42'),(45,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',53,11,3,1,'2019-12-31 12:14:55','2019-12-31 12:14:55'),(46,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',56,12,3,1,'2019-12-31 12:15:12','2019-12-31 12:15:12'),(47,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',57,12,3,1,'2019-12-31 12:15:22','2019-12-31 12:15:22'),(48,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',58,12,3,1,'2019-12-31 12:15:35','2019-12-31 12:15:35'),(49,'2019/2020','Q2','$average','open','$average','$average','2019-12-13 21:00:00',59,12,3,1,'2019-12-31 12:15:43','2019-12-31 12:15:43'),(50,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',66,15,4,1,'2019-12-31 12:16:24','2019-12-31 12:16:24'),(51,'2019/2020','Q2','$average','open','$average','$average','2020-01-03 21:00:00',67,15,4,1,'2019-12-31 12:16:33','2019-12-31 12:16:33'),(52,'2019/2020','Q2','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-07 21:00:00',93,29,11,3,'2020-01-01 02:01:31','2020-01-01 02:01:31'),(53,'2019/2020','Q2','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-14 21:00:00',95,29,11,3,'2020-01-01 02:01:47','2020-01-01 02:01:47'),(54,'2019/2020','Q2','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-07 21:00:00',96,29,11,3,'2020-01-01 02:01:57','2020-01-01 02:01:57'),(55,'2019/2020','Q2','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-07 21:00:00',101,30,11,3,'2020-01-01 02:02:30','2020-01-01 02:02:30'),(56,'2019/2020','Q2','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-16 21:00:00',106,33,12,3,'2020-01-01 02:02:59','2020-01-01 02:02:59'),(57,'2019/2020','Q2','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-07 21:00:00',108,33,12,3,'2020-01-01 02:03:12','2020-01-01 02:03:12'),(58,'2019/2020','Q1','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-07 21:00:00',88,25,9,3,'2020-01-01 02:06:33','2020-01-01 02:06:33'),(59,'2019/2020','Q1','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-08 21:00:00',89,26,9,3,'2020-01-01 02:06:47','2020-01-01 02:06:47'),(60,'2019/2020','Q1','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-07 21:00:00',92,28,10,3,'2020-01-01 02:07:12','2020-01-01 02:07:12'),(61,'2019/2020','Q1','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-15 21:00:00',94,29,11,3,'2020-01-01 02:07:30','2020-01-01 02:07:30'),(62,'2019/2020','Q1','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-16 21:00:00',95,29,11,3,'2020-01-01 02:07:40','2020-01-01 02:07:40'),(63,'2019/2020','Q1','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-07 21:00:00',99,30,11,3,'2020-01-01 02:08:00','2020-01-01 02:08:00'),(64,'2019/2020','Q1','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-14 21:00:00',103,31,11,3,'2020-01-01 02:08:25','2020-01-01 02:08:25'),(65,'2019/2020','Q1','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-08 21:00:00',104,32,11,3,'2020-01-01 02:08:39','2020-01-01 02:08:39'),(66,'2019/2020','Q1','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-08 21:00:00',105,32,11,3,'2020-01-01 02:08:49','2020-01-01 02:08:49'),(67,'2019/2020','Q1','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','open','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','Kindly Fill The Following Fields to Complete Assesing :: Percentage_of_active_antivirus_installed_on_desktops_and_laptops.','2020-01-15 21:00:00',106,33,12,3,'2020-01-01 02:09:04','2020-01-01 02:09:04');
  /*!40000 ALTER TABLE `non_conformities` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `password_resets`
  --
  
  DROP TABLE IF EXISTS `password_resets`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `password_resets` (
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    KEY `password_resets_email_index` (`email`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `password_resets`
  --
  
  LOCK TABLES `password_resets` WRITE;
  /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
  /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `permission_role`
  --
  
  DROP TABLE IF EXISTS `permission_role`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `permission_role` (
    `permission_id` int(10) unsigned NOT NULL,
    `role_id` int(10) unsigned NOT NULL,
    PRIMARY KEY (`permission_id`,`role_id`),
    KEY `permission_role_role_id_foreign` (`role_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `permission_role`
  --
  
  LOCK TABLES `permission_role` WRITE;
  /*!40000 ALTER TABLE `permission_role` DISABLE KEYS */;
  /*!40000 ALTER TABLE `permission_role` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `permissions`
  --
  
  DROP TABLE IF EXISTS `permissions`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `permissions` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `display_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `permissions_name_unique` (`name`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `permissions`
  --
  
  LOCK TABLES `permissions` WRITE;
  /*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
  /*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `perspectives`
  --
  
  DROP TABLE IF EXISTS `perspectives`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `perspectives` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `description` text COLLATE utf8_unicode_ci,
    `weight` double NOT NULL,
    `program_id` bigint(20) unsigned DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `perspective_group` int(11) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `perspectives_id_unique` (`id`),
    KEY `perspectives_program_id_foreign` (`program_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=75 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `perspectives`
  --
  
  LOCK TABLES `perspectives` WRITE;
  /*!40000 ALTER TABLE `perspectives` DISABLE KEYS */;
  INSERT INTO `perspectives` VALUES (1,'itsms_financial_perspective',NULL,10,1,'2019-11-16 12:20:21','2019-11-16 12:20:21',1),(2,'itsms_customer_perspective',NULL,35,1,'2019-11-16 12:20:21','2019-11-16 12:20:21',2),(3,'itsms_internal_business_process_perspective',NULL,50,1,'2019-11-16 12:20:21','2019-11-16 12:20:21',3),(4,'itsms_learning_and_growth',NULL,5,1,'2019-11-16 12:20:21','2019-11-16 12:20:21',4),(5,'qms_financial_perspective',NULL,30,5,'2019-11-16 12:20:21','2019-11-16 12:20:21',1),(6,'qms_customer_perspective',NULL,50,5,'2019-11-16 12:20:21','2019-11-16 12:20:21',2),(7,'qms_internal_business_process_perspective',NULL,10,5,'2019-11-16 12:20:21','2019-11-16 12:20:21',3),(8,'qms_learning_and_growth',NULL,10,5,'2019-11-16 12:20:21','2019-11-16 12:20:21',4),(9,'isms_financial_perspective',NULL,20,3,'2019-11-16 12:20:21','2019-11-16 12:20:21',1),(10,'isms_customer_perspective',NULL,25,3,'2019-11-16 12:20:21','2019-11-16 12:20:21',2),(11,'isms_internal_business_process_perspective',NULL,35,3,'2019-11-16 12:20:21','2019-11-16 12:20:21',3),(12,'isms_learning_and_growth',NULL,20,3,'2019-11-16 12:20:21','2019-11-16 12:20:21',4),(13,'ems_Environmental Management System Perspective',NULL,100,4,'2019-11-25 05:46:52','2019-11-25 05:46:52',5),(14,'ans_financial_perspective',NULL,50,184,'2019-12-03 03:19:43','2019-12-03 03:19:43',9),(70,'BCMS_internal_business_process_perspective',NULL,30,226,'2019-12-08 19:41:48','2019-12-08 19:41:48',3),(69,'BCMS_learning_and_growth_perspective',NULL,20,226,'2019-12-08 19:41:48','2019-12-08 19:41:48',4),(68,'BCMS_customer_perspective',NULL,30,226,'2019-12-08 19:41:48','2019-12-08 19:41:48',2),(67,'BCMS_financial_perspective',NULL,20,226,'2019-12-08 19:41:48','2019-12-08 19:41:48',1),(66,'QMCSMS_Customer Complaints Closure',NULL,25,225,'2019-12-05 08:02:22','2019-12-05 08:02:22',6),(65,'QMCSMS_Customer Complaints.',NULL,25,225,'2019-12-05 08:02:22','2019-12-05 08:02:22',7),(64,'QMCSMS_Strategic Management',NULL,50,225,'2019-12-05 08:02:22','2019-12-05 08:02:22',8),(60,'CSR_internal_business_process_perspective',NULL,25,223,'2019-12-05 04:07:14','2019-12-05 04:07:14',3),(59,'CSR_learning_and_growth_perspective',NULL,25,223,'2019-12-05 04:07:14','2019-12-05 04:07:14',4),(58,'CSR_customer_perspective',NULL,25,223,'2019-12-05 04:07:14','2019-12-05 04:07:14',2),(57,'CSR_financial_perspective',NULL,25,223,'2019-12-05 04:07:14','2019-12-05 04:07:14',1);
  /*!40000 ALTER TABLE `perspectives` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `programs`
  --
  
  DROP TABLE IF EXISTS `programs`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `programs` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `shortHand` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `description` text COLLATE utf8_unicode_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `imageLocation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `programCode` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `colorCode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `programs_id_unique` (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=228 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `programs`
  --
  
  LOCK TABLES `programs` WRITE;
  /*!40000 ALTER TABLE `programs` DISABLE KEYS */;
  INSERT INTO `programs` VALUES (1,'Service Management System.','SMS','This is the program that is used to get the integrity of the information technology services.','2019-11-16 12:07:47','2019-12-18 09:22:13','images/itsms.jpg','IS0/20000/2014','#00C0EF'),(3,'Information Security Management System','ISMS',NULL,'2019-11-16 12:07:47','2019-11-16 12:07:47','images/isms.png','IS0/27001','#F39C12'),(4,'Environmental Manaement System','EMS',NULL,'2019-11-16 12:07:47','2019-11-16 12:07:47','images/ems.jpg','IS0/14000','#00A65A'),(5,'Quality Management System','QMS','qms description.','2019-11-16 12:07:47','2019-12-04 09:52:11','images/qms.png','IS0/9001','#0073B7'),(223,'Cooperate Social Responsibility.','CSR','Cooperate Social Responsibility.','2019-12-05 04:07:01','2019-12-05 04:07:01','N/A','ISO 26000','#ff8000'),(225,'Quality management — Customer satisfaction Management System.','QMCSMS','Quality management — Customer satisfaction Management System.','2019-12-05 08:01:00','2019-12-05 08:01:00','N/A','ISO/10002:2018','#804000'),(226,'Business Contuinity Management System','BCMS','Business Contuinity Management System','2019-12-08 19:40:40','2019-12-08 19:40:40','N/A','ISO/22301','#ff0080');
  /*!40000 ALTER TABLE `programs` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `quater_actives`
  --
  
  DROP TABLE IF EXISTS `quater_actives`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `quater_actives` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `Quater` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `Active` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `quater_actives`
  --
  
  LOCK TABLES `quater_actives` WRITE;
  /*!40000 ALTER TABLE `quater_actives` DISABLE KEYS */;
  INSERT INTO `quater_actives` VALUES (1,NULL,'2020-01-06 07:15:57','Q1',0),(2,NULL,'2020-01-06 07:15:57','Q2',1),(3,NULL,'2020-01-02 02:51:19','Q3',0),(4,NULL,'2020-01-02 11:11:05','Q4',0);
  /*!40000 ALTER TABLE `quater_actives` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `reports_generateds`
  --
  
  DROP TABLE IF EXISTS `reports_generateds`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `reports_generateds` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `quater` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `year` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `reportLocation` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `program_id` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `reports_generateds`
  --
  
  LOCK TABLES `reports_generateds` WRITE;
  /*!40000 ALTER TABLE `reports_generateds` DISABLE KEYS */;
  INSERT INTO `reports_generateds` VALUES (1,'2019-12-10 03:41:19','2019-12-20 12:00:08','Q1','2019/2020','reports/BCMS_report_2019-2020_Q1_1576854008.pdf',226),(2,'2019-12-10 05:00:34','2019-12-20 12:04:29','Q1','2019/2020','reports/ISMS_report_2019-2020_Q1_1576854269.pdf',3),(3,'2019-12-31 04:34:54','2019-12-31 04:36:04','Q2','2019/2020','reports/ISMS_report_2019-2020_Q2_1577777764.pdf',3),(4,'2019-12-31 04:47:25','2020-01-08 08:19:06','Q2','2019/2020','reports/SMS_report_2019-2020_Q2_1578482346.pdf',1),(5,'2019-12-31 12:55:15','2019-12-31 12:55:15','Q1','2019/2020','reports/SMS_report_2019-2020_Q1_1577807715.pdf',1);
  /*!40000 ALTER TABLE `reports_generateds` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `role_user`
  --
  
  DROP TABLE IF EXISTS `role_user`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `role_user` (
    `user_id` int(10) unsigned NOT NULL,
    `role_id` int(10) unsigned NOT NULL,
    PRIMARY KEY (`user_id`,`role_id`),
    KEY `role_user_role_id_foreign` (`role_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `role_user`
  --
  
  LOCK TABLES `role_user` WRITE;
  /*!40000 ALTER TABLE `role_user` DISABLE KEYS */;
  /*!40000 ALTER TABLE `role_user` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `roles`
  --
  
  DROP TABLE IF EXISTS `roles`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `roles` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `display_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `roles_name_unique` (`name`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `roles`
  --
  
  LOCK TABLES `roles` WRITE;
  /*!40000 ALTER TABLE `roles` DISABLE KEYS */;
  /*!40000 ALTER TABLE `roles` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `scoresrecorded`
  --
  
  DROP TABLE IF EXISTS `scoresrecorded`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `scoresrecorded` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `keyPerfomanceIndicator_id` bigint(20) unsigned NOT NULL,
    `score` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `quater` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `year` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `metOrUnmet` int(11) NOT NULL,
    `reasonProvided` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `scoresrecorded_keyperfomanceindicator_id_foreign` (`keyPerfomanceIndicator_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=181 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `scoresrecorded`
  --
  
  LOCK TABLES `scoresrecorded` WRITE;
  /*!40000 ALTER TABLE `scoresrecorded` DISABLE KEYS */;
  INSERT INTO `scoresrecorded` VALUES (1,88,'3','Q2','2019/2020',0,'0','2019-12-31 07:46:44','2019-12-31 07:46:44'),(2,89,'1','Q2','2019/2020',0,'0','2019-12-31 07:49:41','2019-12-31 07:49:41'),(3,113,'90','Q2','2019/2020',0,'0','2019-12-31 07:50:26','2019-12-31 08:03:07'),(4,114,'100','Q2','2019/2020',0,'0','2019-12-31 08:04:28','2019-12-31 08:04:28'),(5,115,'100','Q2','2019/2020',0,'0','2019-12-31 08:04:28','2019-12-31 08:04:28'),(6,113,'89','Q1','2019/2020',0,'0','2019-12-31 08:05:46','2019-12-31 08:05:46'),(7,114,'89','Q1','2019/2020',0,'0','2019-12-31 08:05:46','2019-12-31 08:05:46'),(8,115,'89','Q1','2019/2020',0,'0','2019-12-31 08:05:46','2019-12-31 08:05:46'),(9,4,'20','Q1','2019/2020',0,'0','2019-12-31 10:27:49','2019-12-31 10:27:49'),(10,5,'75','Q1','2019/2020',0,'0','2019-12-31 10:27:49','2019-12-31 10:27:49'),(11,6,'98','Q1','2019/2020',1,'1','2019-12-31 10:28:15','2019-12-31 10:28:15'),(12,7,'70','Q1','2019/2020',1,'1','2019-12-31 10:28:15','2019-12-31 10:28:15'),(13,8,'0.2','Q1','2019/2020',0,'0','2019-12-31 10:29:01','2019-12-31 10:29:01'),(14,9,'99','Q1','2019/2020',1,'1','2019-12-31 10:29:01','2019-12-31 10:29:01'),(15,10,'99','Q1','2019/2020',1,'1','2019-12-31 10:29:01','2019-12-31 10:29:01'),(16,11,'3.5','Q1','2019/2020',1,'1','2019-12-31 10:29:01','2019-12-31 10:29:01'),(17,12,'4.5','Q1','2019/2020',0,'0','2019-12-31 10:29:01','2019-12-31 10:29:01'),(18,13,'1101','Q1','2019/2020',1,'1','2019-12-31 10:29:24','2019-12-31 10:29:24'),(19,14,'99','Q1','2019/2020',0,'0','2019-12-31 10:29:24','2019-12-31 10:29:24'),(20,15,'5','Q1','2019/2020',0,'0','2019-12-31 10:29:24','2019-12-31 10:29:24'),(21,16,'5001','Q1','2019/2020',2,'2','2019-12-31 10:30:41','2019-12-31 10:36:18'),(22,17,'71','Q1','2019/2020',2,'2','2019-12-31 10:30:41','2019-12-31 10:36:18'),(23,18,'1600','Q1','2019/2020',2,'2','2019-12-31 10:30:41','2019-12-31 10:36:18'),(24,19,'66','Q1','2019/2020',2,'2','2019-12-31 10:30:41','2019-12-31 10:36:18'),(25,20,'8','Q1','2019/2020',2,'2','2019-12-31 10:30:41','2019-12-31 10:36:18'),(26,21,'10','Q1','2019/2020',2,'2','2019-12-31 10:30:41','2019-12-31 10:36:18'),(27,22,'92','Q1','2019/2020',2,'2','2019-12-31 10:30:41','2019-12-31 10:36:18'),(28,23,'8','Q1','2019/2020',2,'2','2019-12-31 10:30:41','2019-12-31 10:36:18'),(29,24,'44','Q1','2019/2020',2,'2','2019-12-31 10:30:41','2019-12-31 10:36:18'),(30,30,'99','Q1','2019/2020',0,'0','2019-12-31 10:31:11','2019-12-31 10:31:11'),(31,31,'1','Q1','2019/2020',0,'0','2019-12-31 10:31:11','2019-12-31 10:31:11'),(32,32,'4','Q1','2019/2020',0,'0','2019-12-31 10:31:11','2019-12-31 10:31:11'),(33,33,'3','Q1','2019/2020',0,'0','2019-12-31 10:31:11','2019-12-31 10:31:11'),(34,34,'1','Q1','2019/2020',0,'0','2019-12-31 10:31:11','2019-12-31 10:31:11'),(35,35,'88','Q1','2019/2020',0,'0','2019-12-31 10:31:11','2019-12-31 10:31:11'),(36,36,'9','Q1','2019/2020',1,'1','2019-12-31 10:31:11','2019-12-31 10:31:11'),(37,37,'22','Q1','2019/2020',1,'1','2019-12-31 10:31:55','2019-12-31 10:31:55'),(38,38,'10','Q1','2019/2020',1,'1','2019-12-31 10:31:55','2019-12-31 10:31:55'),(39,39,'19','Q1','2019/2020',0,'0','2019-12-31 10:31:55','2019-12-31 10:31:55'),(40,40,'15','Q1','2019/2020',0,'0','2019-12-31 10:31:55','2019-12-31 10:31:55'),(41,41,'99','Q1','2019/2020',0,'0','2019-12-31 10:31:55','2019-12-31 10:31:55'),(42,42,'33','Q1','2019/2020',0,'0','2019-12-31 10:32:23','2019-12-31 10:32:23'),(43,43,'9','Q1','2019/2020',1,'1','2019-12-31 10:32:23','2019-12-31 10:32:23'),(44,44,'99','Q1','2019/2020',0,'0','2019-12-31 10:32:23','2019-12-31 10:32:23'),(45,45,'80','Q1','2019/2020',0,'0','2019-12-31 10:32:23','2019-12-31 10:32:23'),(46,46,'36','Q1','2019/2020',0,'0','2019-12-31 10:32:23','2019-12-31 10:32:23'),(47,47,'0','Q1','2019/2020',0,'0','2019-12-31 10:32:23','2019-12-31 10:32:23'),(48,48,'90','Q1','2019/2020',0,'0','2019-12-31 10:32:57','2019-12-31 10:32:57'),(49,49,'0','Q1','2019/2020',0,'0','2019-12-31 10:32:57','2019-12-31 10:32:57'),(50,50,'0','Q1','2019/2020',0,'0','2019-12-31 10:32:57','2019-12-31 10:32:57'),(51,51,'2','Q1','2019/2020',1,'1','2019-12-31 10:32:57','2019-12-31 10:32:57'),(52,52,'2','Q1','2019/2020',1,'1','2019-12-31 10:32:57','2019-12-31 10:32:57'),(53,53,'59','Q1','2019/2020',0,'0','2019-12-31 10:33:05','2019-12-31 10:33:05'),(54,54,'20','Q1','2019/2020',0,'0','2019-12-31 10:33:05','2019-12-31 10:33:05'),(55,55,'66','Q1','2019/2020',0,'0','2019-12-31 10:33:44','2019-12-31 10:33:44'),(56,56,'74','Q1','2019/2020',1,'1','2019-12-31 10:33:44','2019-12-31 10:33:44'),(57,57,'71','Q1','2019/2020',1,'1','2019-12-31 10:33:44','2019-12-31 10:33:44'),(58,58,'71','Q1','2019/2020',1,'1','2019-12-31 10:33:44','2019-12-31 10:33:44'),(59,59,'50','Q1','2019/2020',0,'0','2019-12-31 10:33:44','2019-12-31 10:33:44'),(60,60,'69','Q1','2019/2020',0,'0','2019-12-31 10:33:55','2019-12-31 10:33:55'),(61,61,'79','Q1','2019/2020',0,'0','2019-12-31 10:33:55','2019-12-31 10:33:55'),(62,62,'49','Q1','2019/2020',0,'0','2019-12-31 10:33:55','2019-12-31 10:33:55'),(63,63,'80','Q1','2019/2020',1,'1','2019-12-31 10:34:12','2019-12-31 10:34:12'),(64,64,'69','Q1','2019/2020',0,'0','2019-12-31 10:34:12','2019-12-31 10:34:12'),(65,65,'0','Q1','2019/2020',0,'0','2019-12-31 10:34:35','2019-12-31 10:34:35'),(66,66,'100','Q1','2019/2020',0,'0','2019-12-31 10:34:35','2019-12-31 10:34:35'),(67,67,'94','Q1','2019/2020',1,'1','2019-12-31 10:34:35','2019-12-31 10:34:35'),(68,25,'4.3','Q1','2019/2020',1,'1','2019-12-31 10:36:18','2019-12-31 10:36:18'),(69,26,'99','Q1','2019/2020',0,'0','2019-12-31 10:36:18','2019-12-31 10:36:18'),(70,27,'99','Q1','2019/2020',0,'0','2019-12-31 10:36:18','2019-12-31 10:36:18'),(71,28,'89','Q1','2019/2020',1,'1','2019-12-31 10:36:18','2019-12-31 10:36:18'),(72,29,'90','Q1','2019/2020',0,'0','2019-12-31 10:36:18','2019-12-31 10:36:18'),(73,4,'89','Q2','2019/2020',0,'0','2019-12-31 10:37:33','2019-12-31 10:37:33'),(74,5,'65','Q2','2019/2020',1,'1','2019-12-31 10:37:33','2019-12-31 10:37:33'),(75,6,'99','Q2','2019/2020',0,'0','2019-12-31 10:37:48','2019-12-31 10:37:48'),(76,7,'69','Q2','2019/2020',1,'1','2019-12-31 10:37:48','2019-12-31 10:37:48'),(77,8,'0.1','Q2','2019/2020',0,'0','2019-12-31 10:38:21','2019-12-31 10:38:21'),(78,9,'100','Q2','2019/2020',0,'0','2019-12-31 10:38:21','2019-12-31 10:38:21'),(79,10,'75','Q2','2019/2020',1,'1','2019-12-31 10:38:21','2019-12-31 10:38:21'),(80,11,'3.5','Q2','2019/2020',1,'1','2019-12-31 10:38:21','2019-12-31 10:38:21'),(81,12,'4.2','Q2','2019/2020',0,'0','2019-12-31 10:38:21','2019-12-31 10:38:21'),(82,13,'1001','Q2','2019/2020',0,'0','2019-12-31 10:38:43','2019-12-31 10:38:43'),(83,14,'85','Q2','2019/2020',1,'1','2019-12-31 10:38:43','2019-12-31 10:38:43'),(84,15,'5','Q2','2019/2020',0,'0','2019-12-31 10:38:43','2019-12-31 10:38:43'),(85,16,'8974','Q2','2019/2020',2,'2','2019-12-31 12:12:37','2019-12-31 13:22:36'),(86,17,'63','Q2','2019/2020',2,'2','2019-12-31 12:12:37','2019-12-31 13:22:36'),(87,18,'1630','Q2','2019/2020',2,'2','2019-12-31 12:12:37','2019-12-31 13:22:36'),(88,19,'96','Q2','2019/2020',2,'2','2019-12-31 12:12:37','2019-12-31 13:22:36'),(89,20,'9','Q2','2019/2020',2,'2','2019-12-31 12:12:37','2019-12-31 13:22:36'),(90,21,'10','Q2','2019/2020',2,'2','2019-12-31 12:12:37','2019-12-31 13:22:36'),(91,22,'99','Q2','2019/2020',2,'2','2019-12-31 12:12:38','2019-12-31 13:22:36'),(92,23,'7','Q2','2019/2020',2,'2','2019-12-31 12:12:38','2019-12-31 13:22:36'),(93,24,'40','Q2','2019/2020',2,'2','2019-12-31 12:12:38','2019-12-31 13:22:36'),(94,25,'4.2','Q2','2019/2020',2,'2','2019-12-31 12:12:38','2019-12-31 13:22:36'),(95,26,'80','Q2','2019/2020',2,'2','2019-12-31 12:12:38','2019-12-31 13:22:36'),(96,27,'90','Q2','2019/2020',2,'2','2019-12-31 12:12:38','2019-12-31 13:22:36'),(97,28,'80','Q2','2019/2020',2,'2','2019-12-31 12:12:38','2019-12-31 13:22:36'),(98,29,'88','Q2','2019/2020',2,'2','2019-12-31 12:12:38','2019-12-31 13:22:36'),(99,30,'90','Q2','2019/2020',1,'1','2019-12-31 12:13:16','2019-12-31 12:13:16'),(100,31,'1','Q2','2019/2020',0,'0','2019-12-31 12:13:16','2019-12-31 12:13:16'),(101,32,'4','Q2','2019/2020',0,'0','2019-12-31 12:13:16','2019-12-31 12:13:16'),(102,33,'3','Q2','2019/2020',0,'0','2019-12-31 12:13:16','2019-12-31 12:13:16'),(103,34,'1','Q2','2019/2020',0,'0','2019-12-31 12:13:16','2019-12-31 12:13:16'),(104,35,'88','Q2','2019/2020',0,'0','2019-12-31 12:13:16','2019-12-31 12:13:16'),(105,36,'20','Q2','2019/2020',1,'1','2019-12-31 12:13:16','2019-12-31 12:13:16'),(106,37,'20','Q2','2019/2020',0,'0','2019-12-31 12:13:47','2019-12-31 12:13:47'),(107,38,'89','Q2','2019/2020',1,'1','2019-12-31 12:13:47','2019-12-31 12:13:47'),(108,39,'80','Q2','2019/2020',1,'1','2019-12-31 12:13:47','2019-12-31 12:13:47'),(109,40,'10','Q2','2019/2020',0,'0','2019-12-31 12:13:47','2019-12-31 12:13:47'),(110,41,'99','Q2','2019/2020',0,'0','2019-12-31 12:13:47','2019-12-31 12:13:47'),(111,42,'30','Q2','2019/2020',0,'0','2019-12-31 12:14:25','2019-12-31 12:14:25'),(112,43,'8','Q2','2019/2020',1,'1','2019-12-31 12:14:25','2019-12-31 12:14:25'),(113,44,'9','Q2','2019/2020',1,'1','2019-12-31 12:14:25','2019-12-31 12:14:25'),(114,45,'90','Q2','2019/2020',1,'1','2019-12-31 12:14:25','2019-12-31 12:14:25'),(115,46,'30','Q2','2019/2020',0,'0','2019-12-31 12:14:25','2019-12-31 12:14:25'),(116,47,'0','Q2','2019/2020',0,'0','2019-12-31 12:14:25','2019-12-31 12:14:25'),(117,48,'90','Q2','2019/2020',0,'0','2019-12-31 12:14:44','2019-12-31 12:14:44'),(118,49,'0','Q2','2019/2020',0,'0','2019-12-31 12:14:44','2019-12-31 12:14:44'),(119,50,'0','Q2','2019/2020',0,'0','2019-12-31 12:14:44','2019-12-31 12:14:44'),(120,51,'1','Q2','2019/2020',0,'0','2019-12-31 12:14:44','2019-12-31 12:14:44'),(121,52,'3','Q2','2019/2020',1,'1','2019-12-31 12:14:44','2019-12-31 12:14:44'),(122,53,'89','Q2','2019/2020',1,'1','2019-12-31 12:15:00','2019-12-31 12:15:00'),(123,54,'21','Q2','2019/2020',0,'0','2019-12-31 12:15:00','2019-12-31 12:15:00'),(124,55,'69','Q2','2019/2020',0,'0','2019-12-31 12:15:45','2019-12-31 12:15:45'),(125,56,'74','Q2','2019/2020',1,'1','2019-12-31 12:15:45','2019-12-31 12:15:45'),(126,57,'90','Q2','2019/2020',1,'1','2019-12-31 12:15:45','2019-12-31 12:15:45'),(127,58,'80','Q2','2019/2020',1,'1','2019-12-31 12:15:45','2019-12-31 12:15:45'),(128,59,'96','Q2','2019/2020',1,'1','2019-12-31 12:15:45','2019-12-31 12:15:45'),(129,60,'60','Q2','2019/2020',0,'0','2019-12-31 12:16:02','2019-12-31 12:16:02'),(130,61,'79','Q2','2019/2020',0,'0','2019-12-31 12:16:02','2019-12-31 12:16:02'),(131,62,'49','Q2','2019/2020',0,'0','2019-12-31 12:16:02','2019-12-31 12:16:02'),(132,63,'70','Q2','2019/2020',0,'0','2019-12-31 12:16:09','2019-12-31 12:16:09'),(133,64,'66','Q2','2019/2020',0,'0','2019-12-31 12:16:09','2019-12-31 12:16:09'),(134,65,'3','Q2','2019/2020',0,'0','2019-12-31 12:16:35','2019-12-31 12:16:35'),(135,66,'15','Q2','2019/2020',1,'1','2019-12-31 12:16:35','2019-12-31 12:16:35'),(136,67,'99','Q2','2019/2020',1,'1','2019-12-31 12:16:35','2019-12-31 12:16:35'),(137,90,'0','Q2','2019/2020',0,'0','2019-12-31 13:25:18','2019-12-31 13:25:18'),(138,91,'1','Q2','2019/2020',0,'0','2020-01-01 02:01:12','2020-01-01 02:01:12'),(139,92,'33','Q2','2019/2020',0,'0','2020-01-01 02:01:14','2020-01-01 02:01:14'),(140,93,'90','Q2','2019/2020',1,'1','2020-01-01 02:02:13','2020-01-01 02:02:13'),(141,94,'100','Q2','2019/2020',0,'0','2020-01-01 02:02:13','2020-01-01 02:02:13'),(142,95,'96','Q2','2019/2020',1,'1','2020-01-01 02:02:13','2020-01-01 02:02:13'),(143,96,'99','Q2','2019/2020',1,'1','2020-01-01 02:02:13','2020-01-01 02:02:13'),(144,97,'100','Q2','2019/2020',0,'0','2020-01-01 02:02:13','2020-01-01 02:02:13'),(145,98,'3','Q2','2019/2020',0,'0','2020-01-01 02:02:35','2020-01-01 02:02:35'),(146,99,'9','Q2','2019/2020',0,'0','2020-01-01 02:02:35','2020-01-01 02:02:35'),(147,100,'3','Q2','2019/2020',0,'0','2020-01-01 02:02:35','2020-01-01 02:02:35'),(148,101,'32','Q2','2019/2020',1,'1','2020-01-01 02:02:35','2020-01-01 02:02:35'),(149,102,'3','Q2','2019/2020',0,'0','2020-01-01 02:02:35','2020-01-01 02:02:35'),(150,103,'100','Q2','2019/2020',0,'0','2020-01-01 02:02:40','2020-01-01 02:02:40'),(151,104,'100','Q2','2019/2020',0,'0','2020-01-01 02:02:47','2020-01-01 02:02:47'),(152,105,'100','Q2','2019/2020',0,'0','2020-01-01 02:02:47','2020-01-01 02:02:47'),(153,106,'89','Q2','2019/2020',1,'1','2020-01-01 02:03:14','2020-01-01 02:03:14'),(154,107,'100','Q2','2019/2020',0,'0','2020-01-01 02:03:14','2020-01-01 02:03:14'),(155,108,'78','Q2','2019/2020',1,'1','2020-01-01 02:03:14','2020-01-01 02:03:14'),(156,109,'90','Q2','2019/2020',0,'0','2020-01-01 02:03:26','2020-01-01 02:03:26'),(157,110,'90','Q2','2019/2020',0,'0','2020-01-01 02:03:26','2020-01-01 02:03:26'),(158,88,'4','Q1','2019/2020',1,'1','2020-01-01 02:06:53','2020-01-01 02:06:53'),(159,89,'0','Q1','2019/2020',1,'1','2020-01-01 02:06:55','2020-01-01 02:06:55'),(160,90,'0','Q1','2019/2020',0,'0','2020-01-01 02:06:55','2020-01-01 02:06:55'),(161,91,'1','Q1','2019/2020',0,'0','2020-01-01 02:07:01','2020-01-01 02:07:01'),(162,92,'42','Q1','2019/2020',1,'1','2020-01-01 02:07:14','2020-01-01 02:07:14'),(163,93,'95','Q1','2019/2020',0,'0','2020-01-01 02:07:48','2020-01-01 02:07:48'),(164,94,'99','Q1','2019/2020',1,'1','2020-01-01 02:07:48','2020-01-01 02:07:48'),(165,95,'99','Q1','2019/2020',1,'1','2020-01-01 02:07:48','2020-01-01 02:07:48'),(166,96,'100','Q1','2019/2020',0,'0','2020-01-01 02:07:48','2020-01-01 02:07:48'),(167,97,'100','Q1','2019/2020',0,'0','2020-01-01 02:07:48','2020-01-01 02:07:48'),(168,98,'3','Q1','2019/2020',0,'0','2020-01-01 02:08:15','2020-01-01 02:08:15'),(169,99,'8','Q1','2019/2020',1,'1','2020-01-01 02:08:15','2020-01-01 02:08:15'),(170,100,'2','Q1','2019/2020',0,'0','2020-01-01 02:08:15','2020-01-01 02:08:15'),(171,101,'100','Q1','2019/2020',0,'0','2020-01-01 02:08:15','2020-01-01 02:08:15'),(172,102,'2','Q1','2019/2020',0,'0','2020-01-01 02:08:15','2020-01-01 02:08:15'),(173,103,'56','Q1','2019/2020',1,'1','2020-01-01 02:08:27','2020-01-01 02:08:27'),(174,104,'96','Q1','2019/2020',1,'1','2020-01-01 02:08:52','2020-01-01 02:08:52'),(175,105,'99','Q1','2019/2020',1,'1','2020-01-01 02:08:52','2020-01-01 02:08:52'),(176,106,'89','Q1','2019/2020',1,'1','2020-01-01 02:09:12','2020-01-01 02:09:12'),(177,107,'100','Q1','2019/2020',0,'0','2020-01-01 02:09:12','2020-01-01 02:09:12'),(178,108,'90','Q1','2019/2020',0,'0','2020-01-01 02:09:12','2020-01-01 02:09:12'),(179,109,'90','Q1','2019/2020',0,'0','2020-01-01 02:09:20','2020-01-01 02:09:20'),(180,110,'90','Q1','2019/2020',0,'0','2020-01-01 02:09:20','2020-01-01 02:09:20');
  /*!40000 ALTER TABLE `scoresrecorded` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `strategic_objective_scores`
  --
  
  DROP TABLE IF EXISTS `strategic_objective_scores`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `strategic_objective_scores` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `strategicObjective_id` bigint(20) unsigned DEFAULT NULL,
    `perspective_id` bigint(20) unsigned DEFAULT NULL,
    `score` double NOT NULL,
    `year` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `quater` varchar(155) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    KEY `trategicobjectivescores_strategicobjective_id_foreign` (`strategicObjective_id`),
    KEY `trategicobjectivescores_perspective_id_foreign` (`perspective_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=51 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `strategic_objective_scores`
  --
  
  LOCK TABLES `strategic_objective_scores` WRITE;
  /*!40000 ALTER TABLE `strategic_objective_scores` DISABLE KEYS */;
  INSERT INTO `strategic_objective_scores` VALUES (1,'2019-12-31 08:04:28','2019-12-31 08:04:28',1,1,100,'2019/2020','Q2'),(2,'2019-12-31 08:05:46','2019-12-31 08:05:46',1,1,100,'2019/2020','Q1'),(3,'2019-12-31 10:27:49','2019-12-31 10:27:49',2,2,100,'2019/2020','Q1'),(4,'2019-12-31 10:28:15','2019-12-31 10:28:15',3,2,96.41285956006769,'2019/2020','Q1'),(5,'2019-12-31 10:29:01','2019-12-31 10:29:01',4,2,98.17031435112003,'2019/2020','Q1'),(6,'2019-12-31 10:29:24','2019-12-31 10:29:24',5,2,66.69694217378141,'2019/2020','Q1'),(7,'2019-12-31 10:31:11','2019-12-31 10:31:11',7,3,92.06349206349206,'2019/2020','Q1'),(8,'2019-12-31 10:31:55','2019-12-31 10:31:55',8,3,63.81818181818183,'2019/2020','Q1'),(9,'2019-12-31 10:32:23','2019-12-31 10:32:23',9,3,98.33333333333333,'2019/2020','Q1'),(10,'2019-12-31 10:32:57','2019-12-31 10:32:57',10,3,80,'2019/2020','Q1'),(11,'2019-12-31 10:33:05','2019-12-31 10:33:05',11,3,100,'2019/2020','Q1'),(12,'2019-12-31 10:33:44','2019-12-31 10:33:44',12,3,41.644461362771224,'2019/2020','Q1'),(13,'2019-12-31 10:33:55','2019-12-31 10:33:55',13,3,100,'2019/2020','Q1'),(14,'2019-12-31 10:34:12','2019-12-31 10:34:12',14,3,56.25,'2019/2020','Q1'),(15,'2019-12-31 10:34:35','2019-12-31 10:34:35',15,4,34.75177304964539,'2019/2020','Q1'),(16,'2019-12-31 10:36:18','2019-12-31 10:36:18',6,2,78.67090881454767,'2019/2020','Q1'),(17,'2019-12-31 10:37:33','2019-12-31 10:37:33',2,2,93.33333333333334,'2019/2020','Q2'),(18,'2019-12-31 10:37:48','2019-12-31 10:37:48',3,2,96,'2019/2020','Q2'),(19,'2019-12-31 10:38:21','2019-12-31 10:38:21',4,2,93.44358643228,'2019/2020','Q2'),(20,'2019-12-31 10:38:43','2019-12-31 10:38:43',5,2,95.28619528619528,'2019/2020','Q2'),(21,'2019-12-31 12:12:38','2019-12-31 12:12:38',6,2,84.95250822134538,'2019/2020','Q2'),(22,'2019-12-31 12:13:16','2019-12-31 12:13:16',7,3,95.96774193548387,'2019/2020','Q2'),(23,'2019-12-31 12:13:47','2019-12-31 12:13:47',8,3,92.8,'2019/2020','Q2'),(24,'2019-12-31 12:14:25','2019-12-31 12:14:25',9,3,66.0233918128655,'2019/2020','Q2'),(25,'2019-12-31 12:14:44','2019-12-31 12:14:44',10,3,93.33333333333333,'2019/2020','Q2'),(26,'2019-12-31 12:15:00','2019-12-31 12:15:00',11,3,66.29213483146067,'2019/2020','Q2'),(27,'2019-12-31 12:15:45','2019-12-31 12:15:45',12,3,37.60885885885885,'2019/2020','Q2'),(28,'2019-12-31 12:16:02','2019-12-31 12:16:02',13,3,100,'2019/2020','Q2'),(29,'2019-12-31 12:16:09','2019-12-31 12:16:09',14,3,100,'2019/2020','Q2'),(30,'2019-12-31 12:16:35','2019-12-31 12:16:35',15,4,41.91919191919192,'2019/2020','Q2'),(31,'2019-12-31 13:25:18','2019-12-31 13:25:18',26,9,100,'2019/2020','Q2'),(32,'2019-12-31 13:25:19','2019-12-31 13:25:19',25,9,70,'2019/2020','Q2'),(33,'2020-01-01 02:01:12','2020-01-01 02:01:12',27,10,100,'2019/2020','Q2'),(34,'2020-01-01 02:01:14','2020-01-01 02:01:14',28,10,100,'2019/2020','Q2'),(35,'2020-01-01 02:02:13','2020-01-01 02:02:13',29,11,97.94736842105263,'2019/2020','Q2'),(36,'2020-01-01 02:02:35','2020-01-01 02:02:35',30,11,86.4,'2019/2020','Q2'),(37,'2020-01-01 02:02:40','2020-01-01 02:02:40',31,11,100,'2019/2020','Q2'),(38,'2020-01-01 02:02:47','2020-01-01 02:02:47',32,11,100,'2019/2020','Q2'),(39,'2020-01-01 02:03:14','2020-01-01 02:03:14',33,12,95.18518518518518,'2019/2020','Q2'),(40,'2020-01-01 02:03:26','2020-01-01 02:03:26',34,12,100,'2019/2020','Q2'),(41,'2020-01-01 02:06:53','2020-01-01 02:06:53',25,9,66,'2019/2020','Q1'),(42,'2020-01-01 02:06:55','2020-01-01 02:06:55',26,9,50,'2019/2020','Q1'),(43,'2020-01-01 02:07:01','2020-01-01 02:07:01',27,10,100,'2019/2020','Q1'),(44,'2020-01-01 02:07:14','2020-01-01 02:07:14',28,10,16.66666666666667,'2019/2020','Q1'),(45,'2020-01-01 02:07:48','2020-01-01 02:07:48',29,11,99.6,'2019/2020','Q1'),(46,'2020-01-01 02:08:15','2020-01-01 02:08:15',30,11,97.77777777777779,'2019/2020','Q1'),(47,'2020-01-01 02:08:27','2020-01-01 02:08:27',31,11,56.00000000000001,'2019/2020','Q1'),(48,'2020-01-01 02:08:52','2020-01-01 02:08:52',32,11,97.5,'2019/2020','Q1'),(49,'2020-01-01 02:09:12','2020-01-01 02:09:12',33,12,99.62962962962963,'2019/2020','Q1'),(50,'2020-01-01 02:09:20','2020-01-01 02:09:20',34,12,100,'2019/2020','Q1');
  /*!40000 ALTER TABLE `strategic_objective_scores` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `strategic_objectives`
  --
  
  DROP TABLE IF EXISTS `strategic_objectives`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `strategic_objectives` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` text COLLATE utf8_unicode_ci NOT NULL,
    `description` text COLLATE utf8_unicode_ci,
    `perspective_id` bigint(20) unsigned DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `shortHand` varchar(250) COLLATE utf8_unicode_ci DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `strategic_objectives_perspective_id_foreign` (`perspective_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `strategic_objectives`
  --
  
  LOCK TABLES `strategic_objectives` WRITE;
  /*!40000 ALTER TABLE `strategic_objectives` DISABLE KEYS */;
  INSERT INTO `strategic_objectives` VALUES (1,'financial_namegement','Establish and maintain business relationships with customers, identify customer needs, and ensure the organization is able to meet these needs.',1,'2019-11-16 14:52:24','2019-11-16 14:52:24','financial_namegement'),(2,'business_relationship','Provide a framework for optimum financial decision making; design a method of operating the internal investment and financing of an organization.',2,'2019-11-16 14:52:24','2019-11-16 14:52:24','b/rshp'),(3,'service_desk','Support the agreed IT service provision by ensuring the accessibility and availability of the IT Organization and performing various support activities.',2,'2019-11-16 14:52:24','2019-11-16 14:52:24','srvc desk'),(4,'SLM_Voice_Service_SLA',' Add Description.',2,'2019-11-16 14:52:24','2019-11-16 14:52:24','slm voiveSLA'),(5,'SLM_Mobile_Money_SLA','Add Description.',2,'2019-11-16 14:52:24','2019-11-16 14:52:24','slm Mmoney sla'),(6,'SLM_Mobile_Data_SLA','Add Description.',2,'2019-11-16 14:52:24','2019-11-16 14:52:24','slm MData sla'),(7,'Change_Proces','Ensure that standardized methods and procedures are used for efficient and prompt handling of all changes to control IT infrastructure, in order to minimize the number and impact of any related incidents upon service',3,'2019-11-16 14:52:24','2019-11-16 14:52:24','change prcs'),(8,'Incident_Management','Restore a normal service operation as quickly as possible and to minimize the impact on business operations, thus ensuring that the best possible levels of service quality and availability are maintained',3,'2019-11-16 14:52:24','2019-11-16 14:52:24','incident mgt'),(9,'Problem_Management','To prevent problems and resulting incidents from happening, to eliminate recurring incidents, and to minimize the impact of incidents that cannot be prevented',3,'2019-11-16 14:52:24','2019-11-16 14:52:24','prblm mgt'),(10,'Release_Management','To plan, schedule and control the movement of releases from test to live environments. This ensures the integrity of the live environment is protected and the correct components are released.',3,'2019-11-16 14:52:24','2019-11-16 14:52:24','rls mnt'),(11,'Information_Security','Ensure the confidentiality, integrity, and availability of an organization information, data and IT services. ',3,'2019-11-16 14:52:24','2019-11-16 14:52:24','info sec'),(12,'Capacity_Management_CPU_Utilisation','Ensure the resources are right sized to meet current and future business requirements in a cost effective manner.',3,'2019-11-16 14:52:24','2019-11-16 14:52:24','cpu utilil'),(13,'Capacity_Management_Memory_Utilisation','Ensure the resources are right sized to meet current and future business requirements in a cost effective manner.',3,'2019-11-16 14:52:24','2019-11-16 14:52:24','memeory util'),(14,'Capacity_Management_License_Utilisation','Ensure the resources are right sized to meet current and future business requirements in a cost effective manner.',3,'2019-11-16 14:52:24','2019-11-16 14:52:24','licence util'),(15,'Business_Relationship,_training_and_awareness.','Foster Employee growth and empower employee development.',4,'2019-11-16 14:52:24','2019-11-16 14:52:24','Business_Relationship,_training_and_awareness'),(16,'Effective_monitoring_of_QMS_ISO9001:2015__program_implementation',NULL,5,'2019-11-16 14:52:24','2019-11-16 14:52:24','Effective Mntr'),(17,'Achieve_effective_Controls_on_the_Key_internal_processes',NULL,5,'2019-11-16 14:52:24','2019-11-16 14:52:24','cntrl on key pcs'),(18,'Improve_employee_awareness_on_QMS_and_compitencies',NULL,6,'2019-11-16 14:52:24','2019-11-16 14:52:24','employee awrns'),(19,'QMS_competencies',NULL,6,'2019-11-16 14:52:24','2019-11-16 14:52:24','qms comptn'),(20,'EBU_NPS_Details_-_To_offer_the_highest_possible_standard_of_Products__to_our_customers',NULL,7,'2019-11-16 14:52:24','2019-11-16 14:52:24','EBU NPS'),(21,'Consumer_NPS_Details_-_To_offer_the_highest_possible_standard_of_service_to_our_customers',NULL,7,'2019-11-16 14:52:24','2019-11-16 14:52:24','Cust NPS'),(22,'Customer_Quality_Management_in_terms_of_que_Management,_Repeat_caller_and__Call_Centre_accessibility',NULL,7,'2019-11-16 14:52:24','2019-11-16 14:52:24','Cust qms'),(25,'Decrease_financial_and_Information_loss',NULL,9,'2019-11-16 14:52:24','2019-11-16 14:52:24','Fin loss'),(26,'Ensure_regulatory_and_contractual_IS_compliance',NULL,9,'2019-11-16 14:52:24','2019-11-16 14:52:24','contr compl'),(27,'Provide_secure_and_uninterrupted_services_to_customers',NULL,10,'2019-11-16 14:52:24','2019-11-16 14:52:24','sec& unint serv'),(28,'Protect_the_privacy_of_customer_information',NULL,10,'2019-11-16 14:52:24','2019-11-16 14:52:24','priv cust data'),(29,'Ensure_systems_and_infrastructure_security',NULL,11,'2019-11-16 14:52:24','2019-11-16 14:52:24','infra sec'),(30,'Manage_ISMS_efficiently',NULL,11,'2019-11-16 14:52:24','2019-11-16 14:52:24','isms mng'),(31,'Achieve_effective_system_monitoring_and_audit',NULL,11,'2019-11-16 14:52:24','2019-11-16 14:52:24','eff syst mon'),(32,'Achieve_effective_access_management',NULL,11,'2019-11-16 14:52:24','2019-11-16 14:52:24','access mgt'),(33,'Increase_employee_awareness_and_compliance',NULL,12,'2019-11-16 14:52:24','2019-11-16 14:52:24','emp awarenes'),(34,'Increase_technical_compitencies_of_the_Information_risk_team',NULL,12,'2019-11-16 14:52:24','2019-11-16 14:52:24','tecn comp of risk team'),(43,'Improve Employee Awareness On Qms And Compliance',NULL,8,'2019-12-08 08:09:15','2019-12-08 08:09:15','improve employee awareness'),(42,'QMS Compitencies Across Broad(SPOCs)',NULL,8,'2019-12-08 08:08:59','2019-12-08 08:08:59','SPOCs'),(35,'Sustainability',NULL,13,'2019-11-25 05:58:28','2019-11-25 05:58:28','Sustainability'),(36,'Regulatory/Customer',NULL,13,'2019-11-25 05:58:28','2019-11-25 05:58:28','Regulatory/Customer'),(37,'Organizational Capacity',NULL,13,'2019-11-25 05:58:28','2019-11-25 05:58:28','Organizational Capacity'),(38,'trail',NULL,60,'2019-12-05 05:02:13','2019-12-05 05:02:13','Organizational Capacity'),(40,'mainmtenence processes two',NULL,64,'2019-12-07 07:35:08','2019-12-07 13:04:07','trial'),(44,'Regulatory and contractual compliance',NULL,67,'2019-12-08 19:42:41','2019-12-08 19:42:41','Regulatory and contractual compliance'),(45,'Reduce Financial Loss',NULL,67,'2019-12-08 19:42:59','2019-12-08 19:42:59','Reduce Financial Loss'),(46,'Ensure systems and infrastructure  redundancy',NULL,70,'2019-12-08 19:47:53','2019-12-18 00:22:03','Ensure systs and infra  redundancy '),(47,'\"Achieve effective BCM program management \"',NULL,70,'2019-12-08 19:48:09','2019-12-08 19:48:09','effective BCM management '),(48,'\"Increase employees Business Continuity awareness  and compliance \"',NULL,69,'2019-12-08 19:56:10','2019-12-08 19:56:10',' Emp BC awareness and compl'),(49,'Increase Business Continuity competencies of Technology Division',NULL,69,'2019-12-08 19:56:25','2019-12-08 19:56:25',' BC Competencies of tech div'),(50,'\"Provide uninterrupted services to our customers \"',NULL,68,'2019-12-08 19:58:40','2019-12-08 19:58:40','Provide uninterrupted services to our customers');
  /*!40000 ALTER TABLE `strategic_objectives` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `trategicobjectivescores`
  --
  
  DROP TABLE IF EXISTS `trategicobjectivescores`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `trategicobjectivescores` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `strategicObjective_id` bigint(20) unsigned DEFAULT NULL,
    `perspective_id` bigint(20) unsigned DEFAULT NULL,
    `score` double NOT NULL,
    `year` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    PRIMARY KEY (`id`),
    KEY `trategicobjectivescores_strategicobjective_id_foreign` (`strategicObjective_id`),
    KEY `trategicobjectivescores_perspective_id_foreign` (`perspective_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `trategicobjectivescores`
  --
  
  LOCK TABLES `trategicobjectivescores` WRITE;
  /*!40000 ALTER TABLE `trategicobjectivescores` DISABLE KEYS */;
  /*!40000 ALTER TABLE `trategicobjectivescores` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `users`
  --
  
  DROP TABLE IF EXISTS `users`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `users` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `users_email_unique` (`email`)
  ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `users`
  --
  
  LOCK TABLES `users` WRITE;
  /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  INSERT INTO `users` VALUES (1,'Student','mail@gmail.com',NULL,'$2y$10$bzoM.BLCVpHBB2zsYChPVuZ2dZ2wj79NtYOmyfA.G5Fdn7pe.p3zq','XTHqLFl4Tb1Nc4TnEaYKf7jsCYoB2cS6YmvySmWHxITGJSlpqlatVb9cKwER','2019-11-16 08:36:47','2019-11-16 08:36:47'),(2,'George Kariuki Ngugi','list@gmail.com',NULL,'$2y$10$Jsh8bNHi7GKcaHmn3/0SRuWaZJsH0Vt5sOIieNv6MBqiBFAJIVJ.K','iXQnEvgsqTdX4zagx39ebaMtqgxLnSmxqd55Ls3Vf8HGDXscv5LPWDNkr87z','2019-11-16 08:37:38','2019-11-16 08:37:38'),(3,'itsms','itsms@mail.com',NULL,'$2y$10$kF72yoj4770nFxwrUbra/e0jovkIbpir6OmyrdAh9yohubXaug7Nu','exsfcEEqJI0mb6mX87bw3nU9KkaeiWZw9V4olpdAtacohm7bpzqcN1qABuv2','2019-11-17 06:25:24','2019-11-17 06:25:24'),(4,'isms','isms@mail.com',NULL,'$2y$10$xEFlp4cicNlS173PhtQYPOnlhjkcruL30ldJvVNcVvbhvko2rJLrW',NULL,'2019-11-17 06:25:53','2019-11-17 06:25:53'),(5,'qms','qms@mail.com',NULL,'$2y$10$1ZBFHLHKXyK9j5yapi3x3ePkDfknV6VqVemGjKT1cOHTl1K6NfvZS',NULL,'2019-11-17 06:26:18','2019-11-17 06:26:18'),(6,'EMS','ems@mail.com',NULL,'$2y$10$9AMEqakGfjKrxsoedu0Otu/wfNq1UBe6vjbbtoYWj1tKQPPSs3mdK',NULL,'2019-11-25 06:20:39','2019-11-25 06:20:39'),(7,'Admin','admin@mail.com',NULL,'$2y$10$nIQPM0oGCZgWYc3irXIVsuO/ecUoRUW1aBSSP/sjki2i24pKyveg.',NULL,'2019-12-01 07:30:48','2019-12-01 07:30:48'),(8,'Business Contuinity Management System','bcms@mail.com',NULL,'$2y$10$OYQ10UWzJsk6vlomrcceXeFdVNO/hUzeuqoslToaIi9fvZULzYarO',NULL,'2019-12-08 20:14:17','2019-12-08 20:14:17'),(9,'Cooperate Social Responsibility.','csr3@mail.com',NULL,'$2y$10$uYqx2wdPdfhvYo/NIvAjfe2sFQ013bxNkjg.rEQ36su2xmKHHJiIK',NULL,'2019-12-08 20:37:40','2019-12-08 20:37:40'),(10,'Quality management — Customer satisfaction Management System.','qmcsms@mail.com',NULL,'$2y$10$Mpyki/1CbHxbSOc8wocFA.uabc2w9b1fCdnHE4LrbJhhUA9Xj1ClK',NULL,'2019-12-08 20:38:56','2019-12-08 20:38:56'),(11,'Anti Bribery Management System','abms@mail.com',NULL,'$2y$10$kCcPWFYi0yYVnH7qrN4ADuM8D2ZjjdamiHHg0dBPHsROeeu7Z/EJe',NULL,'2019-12-18 13:37:26','2019-12-18 13:37:26');
  /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Table structure for table `year_actives`
  --
  
  DROP TABLE IF EXISTS `year_actives`;
  /*!40101 SET @saved_cs_client     = @@character_set_client */;
  /*!50503 SET character_set_client = utf8mb4 */;
  CREATE TABLE `year_actives` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `Year` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
    `Active` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  /*!40101 SET character_set_client = @saved_cs_client */;
  
  --
  -- Dumping data for table `year_actives`
  --
  
  LOCK TABLES `year_actives` WRITE;
  /*!40000 ALTER TABLE `year_actives` DISABLE KEYS */;
  INSERT INTO `year_actives` VALUES (1,NULL,'2019-12-03 09:07:06','2019/2020',0),(2,'2019-12-03 09:07:06','2019-12-03 09:17:57','2020/2021',0),(3,'2019-12-03 09:17:57','2019-12-03 09:18:33','2019/2020',0),(4,'2019-12-03 09:18:33','2019-12-07 04:01:28','2019/2020',0),(5,'2019-12-07 04:01:28','2019-12-08 00:55:46','2020/2021',0),(6,'2019-12-08 00:55:46','2019-12-08 00:58:35','2019/2020',0),(7,'2019-12-08 00:58:35','2019-12-08 00:58:57','2019/2020',0),(8,'2019-12-08 00:58:57','2019-12-08 01:24:37','2020/2021',0),(9,'2019-12-08 01:24:37','2019-12-08 01:27:24','2019/2020',0),(10,'2019-12-08 01:27:24','2019-12-08 01:27:24','2019/2020',1);
  /*!40000 ALTER TABLE `year_actives` ENABLE KEYS */;
  UNLOCK TABLES;
  
  --
  -- Dumping routines for database 'isotrackingproduction'
  --
  /*!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 2020-01-08 18:15:20
  