[BLOB]\"\r\n      style=\"width: 308px; height: 230px;\" /><br />Blantyre</p>\r\n  <p>The closing date for receipt of application letters is 27&nbsp;May, 2022</p>\r\n  <p>Only shortlisted candidates will be invited for&nbsp;interviews</p>\r\n  <p>MBTS is an egual opportunity employer. Women are&nbsp;encouraged to apply.</p>\r\n</div>', '220520101353__CIN2974.jpg', '220520101353__CIN2977.jpg', 16, '2022-05-20 10:13:53', 0);

-- --------------------------------------------------------

--
-- Table structure for table `trainings`
--

CREATE TABLE `trainings` (
  `training_id` int(11) NOT NULL,
  `title` varchar(1024) NOT NULL,
  `category` int(11) NOT NULL,
  `venue` varchar(128) NOT NULL,
  `date` date NOT NULL,
  `training_details` text NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `posted_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `trainings`
--

INSERT INTO `trainings` (`training_id`, `title`, `category`, `venue`, `date`, `training_details`, `status`, `posted_date`) VALUES
(4, 'Consultancy to conduct a Baseline Survey for  The Fortifying for Our Communities Undernutrition Status through Strengthened C', 16, 'Sunbird Capital', '2025-05-15', 'Background information<br><br>\r\nSelf Help Africa and its partners have received funding from the European Union to implement the Fortifying for Our Communities Undernutrition Status through Strengthened Civil Society Organisation Capacity in Malawi (FOCUS) Action. The overall objective of action is strengthened local CSOs contribute to improved nutritional status, especially for children under five, in Malawi. The Action brings together the expertise of a Civil Society Organisation (CSO) network-research-technical implementation consortium to enhance the capacity of the local CSO sector to collaborate with smallholder farmers, seed companies, premix distributors, millers, and other private sector value chain players to develop commercially viable, nutrition-sensitive value chains supported by an improved enabling environment for food based micronutrient approaches, namely, food fortification and genetically biofortified food systems in Malawi.<br><br>\r\n\r\nThe specific objectives are to:\r\n<br><br>\r\nEnhance CSO capacity to promote equity, innovation and access to micronutrient rich, fortified, and biofortified foods;\r\nStrengthen CSO capacity to monitor and hold duty bearers to account for the consumption of quality, safe, nutritious and appropriately biofortified and fortified foods and infant food.<br><br>\r\nSelf Help Africa will implement the action in collaboration with the Civil Society Organisation Nutrition Alliance (CSONA), building on the expertise to ensure that local CSOs are equipped to engage effectively with producers of fortified foods and fortificants and enforcement agencies in the country, in ensuring adherence to quality manufacturing processes; the Global Alliance for Improved Nutrition (GAIN), with unrivalled international expertise in supporting food fortification in over 50 countries; and the Catholic Development Commission in Malawi (CADECOM) with 30+ years of diverse knowledge and experience in food security and nutrition security, market access and gender.\r\n<br><br>\r\nSHA will lead the implementation in Dedza and Mulanje districts, CADECOM will lead in Thyolo and Balaka districts, while CSONA and GAIN will operate at district and national levels.<br><br>\r\n<br><br>\r\nIt is against this background that SHA and its partners are seeking a consultant to carry out a baseline assessment of the FOCUS project.', 0, '2025-05-09 02:27:21'),
(5, 'Business Growth Managements For you ', 15, 'Mzuzu', '2025-05-16', 'Continually myocardinate holistic mindshare with client-based web services. Assertively e-enable catalysts for change before tested markets. Phosfluorescently maintain wireless scenarios after intermandated applications. Conveniently predominate revolutionary quality vectors through future-proof manufactured products. Enthusiastically transform distinctive collaboration.\r\n\r\nIntrinsicly coordinate multifunctional functionalities reliable potentialities. Objectively envisioneer high in convergence through collaborative networks. Interactively generate B2C e-tailers for business data restore fully researched relationships through resource maximizing results.', 0, '2025-05-10 09:10:15'),
(7, 'Business Growth Mangment', 16, 'Mzuzu', '2025-05-16', 'Continually myocardinate holistic mindshare with client-based web services. Assertively e-enable catalysts for change before tested markets. Phosfluorescently maintain wireless scenarios after intermandated applications. Conveniently predominate revolutionary quality vectors through future-proof manufactured products. Enthusiastically transform distinctive collaboration.\r\n\r\nIntrinsicly coordinate multifunctional functionalities reliable potentialities. Objectively envisioneer high in convergence through collaborative networks. Interactively generate B2C e-tailers for business data restore fully researched relationships through resource maximizing results.', 0, '2025-05-10 10:37:03'),
(8, 'Business Growth Mangment', 15, 'Mzuzu', '2025-05-16', 'Continually myocardinate holistic mindshare with client-based web services. Assertively e-enable catalysts for change before tested markets. Phosfluorescently maintain wireless scenarios after intermandated applications. Conveniently predominate revolutionary quality vectors through future-proof manufactured products. Enthusiastically transform distinctive collaboration.\r\n\r\nIntrinsicly coordinate multifunctional functionalities reliable potentialities. Objectively envisioneer high in convergence through collaborative networks. Interactively generate B2C e-tailers for business data restore fully researched relationships through resource maximizing results.', 0, '2025-05-10 10:37:13'),
(9, 'Business Growth Management for you  ', 16, 'Mzuzu', '2025-05-16', 'Continually myocardinate holistic mindshare with client-based web services. Assertively e-enable catalysts for change before tested markets. Phosfluorescently maintain wireless scenarios after intermandated applications. Conveniently predominate revolutionary quality vectors through future-proof manufactured products. Enthusiastically transform distinctive collaboration.\r\n\r\nIntrinsicly coordinate multifunctional functionalities reliable potentialities. Objectively envisioneer high in convergence through collaborative networks. Interactively generate B2C e-tailers for business data restore fully researched relationships through resource maximizing results.', 0, '2025-05-10 10:37:51');

-- --------------------------------------------------------

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

CREATE TABLE `training_applications` (
  `application_id` int(11) NOT NULL,
  `full_name` varchar(32) NOT NULL,
  `email` varchar(32) NOT NULL,
  `phone` varchar(32) NOT NULL,
  `training_id` int(11) NOT NULL,
  `sacco_name` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL,
  `reason_for_attending` text NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `application_date` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

INSERT INTO `training_applications` (`application_id`, `full_name`, `email`, `phone`, `training_id`, `sacco_name`, `position`, `reason_for_attending`, `status`, `application_date`) VALUES
(1, 'Wezzie he Mhango', 'wezmhango@hotmail.com', '09916900090', 9, 'mudzi', 'Internal Auditor', 'hjhjh jjhj', 0, '2025-06-12 08:44:18'),
(5, 'Wezzie he Mhango', 'wezmhango@hotmail.com', '0991603780', 13, 'mudzi', 'IT Officer', 'We want to learn how to use the core banking system', 1, '2025-06-12 13:29:34'),
(6, 'Owen Banda', 'obanda@mca.ac.mw', '0882297414', 13, 'Mudi Sacco', 'ICT officer', 'No any reason', 1, '2025-06-13 23:05:37'),
(7, 'Kelvin ', 'dimfa@muscco.org', '0999587051', 3, 'Rumphi', 'IT officer', 'To enhance my knowledge in Cyber Security ', 2, '2025-06-13 23:30:16'),
(8, 'Register her', 'hello@gmail.com', '0990909099', 3, 'Msilikali Sacco', 'CEO', 'Hello there', 1, '2025-06-14 21:58:05'),
(9, 'Enerst Kuyeya', 'ekuyeya@mfihub.co.mw', '0999408956', 14, 'MFIHUB ', 'Technical Manager', 'Up my Cyber security skills ', 2, '2025-06-16 16:25:32'),
(10, 'Dorothy Mambulasa', 'doro_mambulasa@hotmail.com', '088866621', 14, 'Phindu', 'IT Head of Division Iran', 'Kuchapa mmutu', 2, '2025-06-16 16:46:56'),
(11, 'Nehemiah Ng\'anjo', 'Nehemiahnganjo@outlook.com', '0882730381', 14, 'Rumphi teachers ', 'IT Officer', 'I just love Cyber Security', 3, '2025-06-16 16:48:55'),
(12, 'Davie', 'dndasowa@muscco.org', '0888845612', 15, 'Arts', 'Business', 'A new member of the sacco', 2, '2025-08-04 11:26:24'),
(13, 'Triza Magreta ', 'tmagreta@mudisaccomw.com', '0881819549', 17, 'Mudi SACCO ', 'Chief Executive Officer ', 'To impart and learn new things to improve our operations at our SACCO ', 2, '2025-10-29 21:00:28'),
(14, 'Ronald Chilumpha ', 'ronald.chilumpha@gmail.com', '0888178630', 17, 'Mudi SACCO ', 'Board Chairperson ', 'Learn from general experiences in other Saccos. Learn sacco governance in terms of how to strengthen the supervisory committee. Learn strategies for managing liquidity challenges.', 2, '2025-10-29 21:41:51'),
(15, 'JAMES TEMBO', 'jamesptembo@gmail.com', '0888066900', 17, 'MPHUNZITSI SACCO', 'CHIEF EXECUTIVE OFFICER', '\"My goal is to move beyond current best practices and explore the \'next practices\' for cooperatives. I want to engage with other leaders on how we can collectively harness emerging trends like AI, the circular economy, and changing workforce dynamics to ensure the cooperative model not only survives but leads in the next decade', 2, '2025-10-29 23:08:42'),
(16, 'Francis Waliwa', 'fwaliwa@ucssacco.com', '0888544765', 17, 'UCSS', 'CEO', 'Upskilling and grabbing opportunity of being with other SACCOs', 2, '2025-10-30 01:06:38'),
(17, 'Christobel Mbeya ', 'christobel.mbeya@gmail.com', '0888554689', 17, 'Limbe Leaf Sacco ', 'CEO ', 'As a leader learning does not stop. At this training there will be great people who have achieved a lot, am eager to tap the knowledge and expertise on how I can run the organisation.', 2, '2025-10-30 09:55:19'),
(18, 'Loyce chinangwa ', 'lchinangwa@fodyasacco.com', '0996609728', 17, 'Fodya SACCO ', 'SACCO Manager ', 'To represent Fodya SACCO and learn new ideas that will help improve our operations and services to members.\r\n', 2, '2025-10-30 10:48:21'),
(19, 'Bernadette Yafete', 'byafete@aointl.com', '0992960077', 17, 'Fodya SACCO ', 'SACCO President ', 'To represent Fodya SACCO and gain new ideas and strategies that will help strengthen our leadership, growth, and service to members.\r\n\r\n', 2, '2025-10-30 10:55:46'),
(20, 'Josephine Maonjera ', 'mayendaj@gmail.com', '0993994445', 17, 'Lighthouse SACCO ', 'General Manager ', 'To obtain new skills through learning which will help my SACCO to grow both internally and externally ', 2, '2025-10-30 11:12:57'),
(21, 'Mathias Kaselema', 'mathiaskaselema70@gmail.com', '0999068749', 17, 'Lighthouse', 'Board Chairman', 'Acquire ore knowledge and skills to help in running the sacco amidst growing challenges', 2, '2025-10-30 11:19:23'),
(22, 'Lovemore Mwabumba', 'Dcpmwabumba@gmail.com', '0888544744', 17, 'Malawi police Sacco ', 'Board Chair ', 'Enhance  governance and team work ', 2, '2025-10-30 11:23:36'),
(23, 'Sharon Tao Kalea ', 'sharon@sunbirdsacco.com', '+265995105213', 17, 'Sunbird Sacco ', 'Chief Executive Officer', 'To further leadership and governance skills. Maximise the platform for networking and collaboration.  Learning from peers. \r\n', 2, '2025-10-30 11:50:59'),
(24, 'Nedson Chikuta ', 'nedson@sunbirdmalawi.com', '+265995105213', 17, 'Sunbird Sacco ', 'BOARD Chairperson ', 'Governance\r\nFostering partnerships ', 2, '2025-10-30 11:52:51'),
(25, 'Alex Ntungama ', 'antungama@gmail.com', '0999552600', 17, 'Limbe Leaf Employees SACCO ', 'Board Chairperson ', 'Continuance learning to equip myself for member education ', 2, '2025-10-30 13:39:36'),
(26, 'Josephine Maonjera ', 'mayendaj@gmail.com', '0993994445', 17, 'Lighthouse SACCO ', 'General Manager ', 'To learn and help the growth of my SACCO in all Pillars ', 2, '2025-10-31 12:31:25'),
(27, 'Ulemu kumwenda ', 'kumwendaulemu@yahoo.com', '0888571773', 17, 'Unique SACCO ', 'Manager ', 'To learn from other SACCOs and implement the good ideas/lessons learnt in our sacco', 2, '2025-10-31 15:29:49'),
(28, 'JAYNE MALUWA', 'jaynemaluwa@unsaccomw.com', '0888528873', 17, 'UN SACCO', 'SACCO MANAGER', 'To learn and unlearn ', 2, '2025-10-31 19:32:13'),
(29, 'FRANCIS WALIWA', 'fwaliwa@ucssacco.com', '0888544765', 17, 'UNITED CIVIL SERVANTS SACCO', 'CEO', 'It will benefit our SACCO by enhancing staff knowledge, promoting best practices in operations and governance, and creating networking opportunities with other institutions to support growth and sustainability.', 2, '2025-10-31 19:35:59'),
(30, 'SIDNEY BANDULA', 'sidney.bandula@wfp.org', '0999280532', 17, 'UN SACCO', 'BOARD VICE PRESIDENT', 'To learn from the movement leaders and sessions', 2, '2025-10-31 19:36:38'),
(31, 'ALBERT FUKA MOYO', 'amoyo@ucssacco.com', '0993440675', 17, 'UNITED CIVIL SERVANTS SACCO', 'HEAD OF CUSTOMER SERVICE AND MEMBER ENGAGEMENT ', 'The exposure gained will empower our team to adopt innovative approaches in service delivery, strengthen compliance with regulatory standards, and improve overall operational efficiency', 2, '2025-10-31 20:10:47'),
(32, 'FLECTHER MHANGO', 'fkmhango@yahoo.com', '0888120620', 17, 'UNITED CIVIL SERVANTS SACCO', 'CHAIRMAN OF BOARD ', 'to contribute to strategic planning and decision-making processes, ensuring that the SACCO remains competitive, member-focused, and well-positioned for long-term development.', 2, '2025-10-31 20:37:25'),
(33, 'MAGGIE MWAKABANGA', 'mwakamaggie2@gmail.com', '0888116579', 17, 'UNITED CIVIL SERVANTS SACCO', 'VICE CHAIR OF THE BOARD ', ' to strengthen its strategic planning, improve service delivery, and ensure financial sustainability. ', 2, '2025-10-31 20:45:47'),
(34, 'EDDAH MANDA ', 'edahmandamhone@gmail.com', '0888342302', 17, 'UNITED CIVIL SERVANTS SACCO', 'TREASURER', 'to build valuable partnerships that support knowledge sharing and collaboration.', 2, '2025-10-31 20:56:56'),
(35, 'MUSSA SAIDI SOKO', 'mussachemkupasaidi@gmail.com', '0993513797', 17, 'UNITED CIVIL SERVANTS SACCO', 'SECRETARY OF THE BOARD', 'to evaluate the impact of the initiative, identify areas for further improvement, and institutionalize successful practices.', 2, '2025-10-31 21:01:52'),
(36, 'CAROLINE KADANGO', 'kadangocaroline@gmail.com', '0886971741', 17, 'UNITED CIVIL SERVANTS SACCO', 'BOARD MEMBER', ' to strengthen member confidence through consistent delivery of quality services and sound governance. Continuous monitoring and evaluation will ensure that the SACCO remains compliant, adaptable, and responsive to changing market conditions.', 2, '2025-10-31 21:05:36'),
(37, 'CANAAN KABANGO', 'canaankabango@gmail.com', '0897299310', 17, 'UNITED CIVIL SERVANTS SACCO', 'BOARD MEMBER', 'To focus on applying innovation to strengthen the SACCO’s operations.', 2, '2025-10-31 21:10:48'),
(38, 'ALINAFE WAYA', 'alinafewaya29@gmail.com', '0888385784', 17, 'UNITED CIVIL SERVANTS SACCO', 'BOARD MEMBER', 'to streamline processes, enhance service delivery, and strengthen operational efficiency', 2, '2025-10-31 21:12:46'),
(39, 'PEMPHO DZOOLE', 'pemphodzoole@gmail.com', '0884848751', 17, 'UNITED CIVIL SERVANTS SACCO', 'BOARD MEMBER', 'To strengthen accountability, promote transparency, and enhance the overall efficiency and reliability of the SACCO’s operations.', 2, '2025-10-31 21:18:38'),
(40, 'FRANCIS NSEREBO', 'francisnserebo@gmail.com', '0888562885', 17, 'UNITED CIVIL SERVANTS SACCO', 'BOARD MEMBER', 'educe errors, increase productivity, and ensure consistent service quality, strengthening the SACCO’s reputation and operational reliability.', 2, '2025-10-31 21:24:45'),
(41, 'MONICA BANDA', 'monicabanda057@gmail.com', '0991530558', 17, 'UNITED CIVIL SERVANTS SACCO', 'BOARD MEMBER', 'to adopt proven solutions and avoid common pitfalls, fostering collaborative growth.', 2, '2025-10-31 21:26:39'),
(42, 'BRENDA NAMPUNTHA', 'brandynampx@gmail.com', '0888488070', 17, 'UNITED CIVIL SERVANTS SACCO', 'BOARD MEMBER', 'To contribute to stronger revenue growth, reduced operational costs, and long-term sustainability of the SACCO.', 2, '2025-10-31 21:30:03'),
(43, 'STELLA GOLOSI', 'Chinthengastella1665@gmail.com', '0884196498', 17, 'UNITED CIVIL SERVANTS SACCO', 'BOARD MEMBER', 'To help create a motivated, empowered, and high-performing workforce.', 2, '2025-10-31 21:33:01'),
(44, 'CAROLINE KADANGO', 'kadangocaroline@gmail.com', '0886971741', 17, 'UNITED CIVIL SERVANTS SACCO', 'CBOARD MEMBER', 'To instil a culture of continuous learning and improvement.', 2, '2025-10-31 21:37:38'),
(45, 'Treza malata', 'trezamalata@dwascosacco.com', '+26599248724', 17, 'Dwasco ', 'CEO', 'To learn more new things and share experiences with my fellow CEOS,.', 2, '2025-11-01 09:21:28'),
(46, 'GABRIEL MWALE ', 'gabrielmwale@malawipolicesacco.c', '0882725130', 17, 'MALAWI POLICE SACCO', 'BRANCH MANAGER', 'To gain leadership and management skills,\r\nTo gain industry trends and updates\r\nTo gain networking opportunities \r\nTo learn best practices to improve sacco operations ', 2, '2025-11-02 18:23:41'),
(47, 'GABRIEL MWALE ', 'gabrielmwale@malawipolicesacco.c', '0882725130', 17, 'MALAWI POLICE SACCO', 'BRANCH MANAGER', 'Leadership and management skills\r\nSacco operation skill\r\nNetworking opportunities \r\nIndustry trends andbupdates', 2, '2025-11-02 18:26:14'),
(48, 'Margret Matekenya ', 'margretmatekenya22@gmail.com', '0991351572', 17, 'Malawi police sacco ', 'Territorial sales officer ', 'I want to attend  the training cause i believe  the knowledge and skills I will gain from this training will empower me to develop effective  strategies  for mobilising members, delivering  exceptional to retain existing members, driving  growth and satisfaction within our sacco community. ', 2, '2025-11-03 21:49:04'),
(49, 'Kondwani Kandiado', 'kkandiado40@gmail.com', '0999947727', 17, 'Malawi Police Sacco ', 'Board Secretary ', 'I strongly feel it is very pivotal to attend this training as it will help me develop diverse range of social and professional skills. Among others, the training will:\r\n.help in networking or connecting with other professionals and leaders in the Sacco family.\r\n. Professional development: it will help me acquire current and relevant expertise in running my Malawi Police Sacco \r\n.Not only that, the training will also help me in developing skills in leadership and problem solving skills that will help the sustainability of Malawi Police Sacco.\r\n. Lastly, this training will help in sharing information and best practices in the Sacco\'s that will in turn help me in providing good services to Malawi Police Sacco members and even Sacco management.', 2, '2025-11-03 23:01:28'),
(50, 'Ellen Risa Banda', 'Erbanda@aointl.com', '0888366152', 17, 'Fodya SACCO ', 'Board Member', 'To board member to build strategic connections, share experiences and gain exposure that can benefit the SACCO', 2, '2025-11-04 13:27:36'),
(51, 'Kondwani Kandiado', 'kkandiado40@gmail.com', '0999947727', 17, 'Malawi Police Sacco ', 'Board Secretary ', 'Very important for developing a diverse range of cognitive, social and professional skills .Among others it will help in:\r\n. professional development \r\n.Skills enhancement and \r\n. Networking\r\n', 2, '2025-11-04 17:44:42'),
(52, 'Andole Mang’anya', 'amanganya@muscco.org', '0881367852', 17, 'MUSCCO', 'Corporate Affairs', 'Secretariate', 2, '2025-11-06 16:49:36'),
(53, 'Elizabeth chinjala', 'echinjala@yahoo.com', '+265995500454', 17, 'Umodzi sacco', 'General Manager', 'Leaning is a continues process, so as leaders we don\'t stop learning.', 2, '2025-11-10 15:18:42'),
(54, 'RABSON CHILAMBULA ', 'rabsonchilambula301@gmail.com', '0882317518/0991837924', 17, 'UMODZI', 'BOARD MEMBER', 'To be equipped with knowledge and skills about sacco and this training will help on how we can serve members better which will enable our sacco to grow\r\n', 2, '2025-11-10 17:26:07'),
(55, 'Victor sandikonda', 'sandikavictor@gmail.com', '+265998905353', 17, 'Umidzi', 'Board member', 'Increase understanding of sacco, sharing experiences with well knowleged sacco members', 2, '2025-11-10 18:33:18'),
(56, 'Noel Banda ', 'benedictowalawatibanda@yahoo.com', '999048114', 17, 'Umodzi SACCO ', 'Board Member ', 'To aquire more knowledge in Sacco Philosophy which will help in the movement of our Sacco', 2, '2025-11-10 18:33:53'),
(57, 'Chisomo Clinton baluti', 'chisomoclintonbaluti14@gmail.com', '0992686822', 17, 'Umodzi sacco', 'Board member', 'To be equipped with sacco philosophy ', 2, '2025-11-10 18:38:10'),
(58, 'Victor sandikonda ', 'sandikonda.victor@gmail.com', '0998905353', 17, 'Umodzi', 'Board member ', 'Get knowledge and skills', 2, '2025-11-10 19:07:05'),
(59, 'Christon Pondakwao ', 'cpondakwao@gmail.com', '0888893646', 17, 'UMODZI', 'BOAD CHAIRPERSON', 'To increase knowledge on SACCO governance. This will help in making sure that the SACCO polices are well crafted and implemented for the growth of our SACCO', 2, '2025-11-10 19:12:24'),
(60, 'Christon Pondakwao ', 'cpondakwao@gmail.com', '0888893646', 17, 'UMODZI', 'BOAD CHAIRPERSON', 'To increase knowledge on SACCO governance. This will help in making sure that the SACCO polices are well crafted and implemented for the growth of our SACCO', 2, '2025-11-10 19:12:29'),
(61, 'Christopher Kapolo', 'chriskapolo@gmail.com', '0999093774', 17, 'Umodzi Sacco ', 'Board member ', 'To take part in the discussion of challenges affecting our economy and brainstorm on other new products in our Sacco to give to our members to help them grow in this prevailing economy ', 2, '2025-11-10 19:35:15'),
(62, 'Chisomo Clinton baluti', 'chisomoclintonbaluti14@gmail.com', '0992686822', 17, 'Umodzi sacco', 'Board member', 'To be equipped with sacco philosophy and help umodzi sacco grow it\'s membership ', 2, '2025-11-10 19:44:18'),
(63, 'Noel Banda ', 'benedictowalawatibanda@yahoo.com', '999048114', 17, 'Umodzi SACCO ', 'Board Member ', 'To aquire more knowledge in Sacco Philosophy which will help in the movement of our Sacco.', 2, '2025-11-10 19:51:25'),
(64, 'Col Alinine SIMWAKA', 'asimwaka@msilikalisacco.org', '0884828116', 17, 'MSILIKALI SACC0', 'BOARD CHAIRMAN', 'REPRESENTING MSILIKALI SACCO.', 2, '2025-11-11 14:10:48'),
(65, 'Col Alinine SIMWAKA', 'asimwaka@msilikalisacco.org', '0884828116', 17, 'MSILIKALI SACC0', 'BOARD CHAIRMAN', 'REPRESENTING MSILIKALI SACCO', 2, '2025-11-11 15:58:40'),
(66, 'Col Sosten DAMBE', 'sdambe@msilikalisacco.org', '0992867744', 17, 'MSILIKALI SACC0', 'BOARD DIRECTOR', 'REPRESENTING MSILIKALI SACCO.', 2, '2025-11-11 16:01:04'),
(67, 'WOII Patience NYIRONGO', 'pnyirongo@msilikalisacco.org', '0999574750', 17, 'MSILIKALI SACC0', 'SUPERVISORY COMMITTEE MEMBER', 'REPRESENTING MSILIKALI SACCO.', 2, '2025-11-11 16:04:22'),
(68, 'Venge Tembo', 'vtembo@msilikalisacco.org', '0884828116', 17, 'MSILIKALI SACC0', 'GENERAL MANAGER', 'REPRESENTING MSILIKALI SACCO.', 2, '2025-11-11 16:06:15'),
(69, 'Fyness MBEWE', 'fmbewe@msilikalisacco.org', '08878303977', 17, 'MSILIKALI SACC0', 'CREDIT MANAGER', 'REPRESENTING MSILIKALI SACCO.', 2, '2025-11-11 16:09:02'),
(70, 'TAKONDWA KASONGO', 'tkasongo@msilikalisacco.org', '0888854518', 17, 'MSILIKALI SACC0', 'RISK & COMPLIANCE OFFICER', 'REPRESENTING MSILIKALI SACCO.', 2, '2025-11-11 16:10:52'),
(71, 'Harvey Mpando', 'harveymphatso@gmail.com', '265888757777', 17, 'Dwasco ', 'Vice Chairperson ', 'To get more of recent strides in Sacco movement ', 2, '2025-11-12 18:02:21'),
(72, 'Jabulani Kamphodza ', 'jabulanikamphodza@gmail.com', '0884084234', 17, 'Umodzi sacco', 'Board member', 'I need to attend this training to help my sacco grow in many areas benefiting the members ', 2, '2025-11-13 17:08:33'),
(73, 'Richard Chalegwati', 'chalegr1@univetsalleaf.com', '0888383217', 17, 'Limbe Leaf Sacco ', 'Board Director ', 'This conference will help me to make right decisions in governing the Sacco.', 2, '2025-11-14 20:01:15'),
(74, 'Margret Matekenya ', 'margretmatekenya22@gmail.com', '0991351572', 17, 'Malawi police sacco ', 'Territorial sales officer ', 'As a Territorial Sales Officer, I believe attending this training will enhance my skills and knowledge, enabling me to develop effective membership retention strategies and boost brand visibility. This will allow me to promote our organisation\'s value, foster stronger relationships, and drive long term growth. Additionally, networking with professionals from diverse backgrounds will provide valuable insights into various organisational cultures and operations, further equipping me to succeed in my role', 2, '2025-11-16 07:37:26'),
(75, 'MALIZANI GAMALIEL', 'mgamaliel@ssacco.org', '0888861133', 17, 'SUCOMA', 'CEO', 'To gain more knowledge', 2, '2025-11-18 12:50:10'),
(76, 'Vincent Chinomba', 'vincentchinomba@gmail.com', '+265888751602', 17, 'LUANAR SACCO', 'General Manager', 'Continuous learning and development.  I will gain deeper knowledge for further growth of my SACCO', 2, '2025-11-18 13:01:32'),
(77, 'DR EVANCE CHAIMA', 'evachaima@gmail.com', '0886300738', 17, 'LUANAR SACCO', 'PRESIDENT', 'This training should be an eye opener to leaders of saccos on governance and policy issues and current trends in various sacco\'s in the country and beyond', 2, '2025-11-18 13:07:23'),
(78, 'Keniard Banda ', 'Keniard.Banda@mw.cicinsurancegro', '+265881779782', 17, 'CIC Insurance ', 'Business Development Manager- Cooperatives ', 'I\'m attending as a partner in the cooperative movement as well as risk advisor and underwriter ', 2, '2025-11-18 13:16:04'),
(79, 'Sata Mzumacharo', 'sata.mzumacharo@mw.cicinsuranceg', '0999227530', 17, 'Cic insurance', 'Business Development Officer', 'Business', 2, '2025-11-18 13:22:27'),
(80, 'Grace Potani ', 'gracepotani64@gmail.com', '0888852416', 17, 'Sucoma ', 'Chairperson ', 'To improve my knowledge how to run the sacco ', 2, '2025-11-18 13:31:03'),
(81, 'Grace Kandiona ', 'gkandiona@kuwalasacco.mw', '0888727318', 17, 'Kuwala ', 'Manager ', 'To learn more about Saccos and cooperatives in general ', 2, '2025-11-18 13:32:40'),
(82, 'Rose Msosa', 'rmsosa@cdfcanada.coop', '+265996339773', 17, 'CDF Canada ', 'REGIONAL COORDINATOR ', 'CDF Canada partners with different types of cooperatives to build their capacity to achieve sustainable economic and social development. Attending this training will provide strategically inform our organisation on the support SACCOs need. ', 2, '2025-11-18 13:41:37'),
(83, 'Mary ', 'mtbokosi@gmail.com', '0999688710', 17, 'Polymed sacco', 'CEO', 'Training and gain knowledge', 2, '2025-11-18 13:49:57'),
(84, 'MACFENTON BASHIR SHARIFF', 'shariffm@masm.mw', '0998592152', 17, 'N/A', 'HEAD OF COMMERCIAL  FOR MASM', 'SPONSOR', 2, '2025-11-18 13:52:08'),
(85, 'MACFENTON BASHIR SHARIFF', 'shariffm@masm.mw', '0998592152', 17, 'N/A', 'HEAD OF COMMERCIAL  FOR MASM', 'SPONSOR', 2, '2025-11-18 13:53:08'),
(86, 'Samsung Kalulu', 'skalulu@kuhes.ac.mw', '0888894979', 17, 'Polymed sacco', 'Board Chairperson', 'Training and knowledge', 2, '2025-11-18 13:53:13'),
(87, 'Chikondi Eugenio Chapola', 'cechapola@cdfcanada.coop', '0993938358', 17, 'CDF Canada - IAAM Project', 'Co-operative Development Specialist', 'To engage with SACCOs and other stakeholders in the co-operative sector, to learn about financial products and other financial services they are providing. This will inform our project in strategically planning our activities.', 2, '2025-11-18 14:40:24'),
(88, 'Leonard Chakwawa', 'chakwawaleo@gmail.com', '0995394236', 17, 'KUWALA', 'Board Chair', 'The knowledge gained will guide board to make strategic decisions for the growth of the Sacco. ', 2, '2025-11-18 15:27:21'),
(89, 'Paul Mandowa ', 'mandowap@masm.mw', '0999138888', 17, 'N/A', 'N/A', 'As sponsor ', 2, '2025-11-18 17:45:37'),
(90, 'Keniard Banda ', 'Keniard.Banda@mw.cicinsurancegro', '+265881779782', 17, 'CIC Insurance ', 'Business Development Manager- Cooperatives ', 'We are partners ', 1, '2025-11-19 02:31:39'),
(91, 'Spencer Maiden', 'spencer.maiden@mw.cicinsurancegr', '0999567237', 17, 'CIC Insurance', 'Principal Officer', 'To understand how Sacco operate\r\nTo develop insurance products that can suit Sacco members.', 1, '2025-11-19 08:05:23'),
(92, 'Zachary Wambugu', 'wambugu@cic.co.ke', '0998395032', 17, 'CIC ', 'MD', 'Partnering with the Cooperators.', 1, '2025-11-19 10:36:58'),
(93, 'Precious Kumbatira', 'pkumbatira@continental.mw', '0999165444', 17, 'Continental asset management', 'Business development manager', 'Presentation', 1, '2025-11-20 12:30:00'),
(94, 'Precious Kumbatira', 'pkumbatira@continental.mw', '0999165444', 17, 'Continental asset management', 'Business development manager', 'Presentation', 1, '2025-11-20 12:33:23');

-- --------------------------------------------------------

--
-- Table structure for table `vacancies`
--

CREATE TABLE `vacancies` (
  `vacancy_id` int(11) NOT NULL,
  `job_category` varchar(32) NOT NULL,
  `closing_date` date NOT NULL,
  `job_title` varchar(1024) NOT NULL,
  `job_description` longtext NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  `date_posted` timestamp NOT NULL DEFAULT current_timestamp(),
  `posted_by` int(11) NOT NULL,
  `link` varchar(60) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `vacancies`
--

INSERT INTO `vacancies` (`vacancy_id`, `job_category`, `closing_date`, `job_title`, `job_description`, `status`, `date_posted`, `posted_by`, `link`) VALUES
(4, '1', '2025-09-12', 'Finance and Administration Assistant - FAA', '<p>The Malawi Union of Savings and Credit Co-operatives (“MUSCCO”) is a national democratically controlled apex body of Savings and Credit Co-operatives (“SACCOs’) established on 15th September, 1980. The mission is to promote the sustainable growth and development of financial Cooperatives and their members through cost-effective inclusive programming. MUSCCO is a member of the World Council of Credit Unions and a continental body, known as African Confederation of Cooperative Savings and Credit Association (ACCOSCA). <br /></p>\r\n<p>The Union invites applications from suitably qualified persons to fill the vacant position of Finance &amp; Administration Assistant in its establishment.</p>\r\n<p><strong>POSITION: FINANCE &amp; ADMINISTRATION ASSISTANT <span>—</span>&nbsp;FAA</strong><br />Location: MUSCCO South-Blantyre <br />Reports to: Business Development -South <br />Provides supervision to: NA<br />Effective Date: 1st October, 2025</p>\r\n<p><strong>General</strong> <br />The Administration Officer reports to the Regional Coordinator and is responsible for maintaining up to date the regional records on corporate communications and Departmental activities to be up to date. S/he is expected to coordinate/execute general administrative and finance related work which will ensure the smooth running of the region.<br /></p>\r\n<ol style=\"list-style-type: decimal;\">\r\n  <li>Duties and responsibilities: The FAA will be responsible for: <br />Carry out administrative work for the MUSCCO South which includes but is not limited to: <br />Filing of documents; <br />Coordinating documentation for various processes such as services, sales, purchases etc. <br />Organizing various meetings and functions;<br />Coordinate travel &amp; accommodation arrangements for staff, members and visitors;</li>\r\n  <li>Handle the procurement of general supplies for the office. This includes receiving requests from departments, getting quotations and preparation of LPOs </li>\r\n  <li>When required, liaise with the Regional Coordinator in arrangement of meetings with stakeholders. </li>\r\n  <li>Manage massages for the Region offices.as well as handling outgoing and incoming mail. </li>\r\n  <li>Arrange out-going and incoming visits of MUSCCO roaster</li>\r\n  <li>Assist in the planning and implementation of major organization events like product launches, blitz, and other functions as they arise. </li>\r\n  <li>Any other duties as may be assigned by the Region Office</li>\r\n</ol>\r\n<ul style=\"list-style-type: square;\">\r\n  <li><strong>Qualifications, Skills and Abilities</strong> <br />Diploma in Accountancy or Administration with 2 years post qualification experience in similar position. <br />Added advantage if S/he has experience in Sage Pastel Accounting System and in exposure in a financial institution. <br />Ability to work with minimum supervision and maintain utmost confidentiality and manage multi functional tasks.<br /></li>\r\n</ul>\r\n<p><strong>Remuneration: </strong><br />The successful candidate shall be offered a negotiated performance related contract for one year (with an opportunity for two additional years) MUSCCO will offer an attractive salary, benefits and gratuity package commensurate with the position. </p>\r\n<p><strong>How to apply:</strong> <br />Candidates meeting the above qualifications and experience should include the following in their application: detailed curriculum vitae with names of three traceable referees, a covering letter and copies of certificates to the address below: <br />The Chief Executive Officer, MUSCCO Limited, MUSCCO House, P.O. Box 651, Lilongwe And, send your application to hr@muscco.org not later than16.00 pm on Friday, 12th September 2025. Only shortlisted candidates will be acknowledged </p>\r\n<p>MUSCCO is an equal opportunity employer committed to inclusive hiring and dedicated to diversity in its work and staff. Only short-listed applicants will be acknowledged</p>\r\n<p><br /></p>', 0, '2025-09-10 15:00:40', 28, 'DWyjsXoGLxxZxAh6gH235NX8fqlKMgWXQrY1gpmxFlTWoCfu3Af0UR8jih');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `blog_categories`
--
ALTER TABLE `blog_categories`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `blog_comments`
--
ALTER TABLE `blog_comments`
  ADD PRIMARY KEY (`comment_id`);

--
-- Indexes for table `blog_posts`
--
ALTER TABLE `blog_posts`
  ADD PRIMARY KEY (`blog_id`);

--
-- Indexes for table `events`
--
ALTER TABLE `events`
  ADD PRIMARY KEY (`event_id`);

--
-- Indexes for table `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`faq_id`);

--
-- Indexes for table `inquiries`
--
ALTER TABLE `inquiries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `job_categories`
--
ALTER TABLE `job_categories`
  ADD PRIMARY KEY (`category_id`);

--
-- Indexes for table `leadership`
--
ALTER TABLE `leadership`
  ADD PRIMARY KEY (`leader_id`);

--
-- Indexes for table `newsletters`
--
ALTER TABLE `newsletters`
  ADD PRIMARY KEY (`newsletter_id`);

--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
  ADD PRIMARY KEY (`project_id`);

--
-- Indexes for table `publications`
--
ALTER TABLE `publications`
  ADD PRIMARY KEY (`publication_id`);

--
-- Indexes for table `regions`
--
ALTER TABLE `regions`
  ADD PRIMARY KEY (`region_id`);

--
-- Indexes for table `report`
--
ALTER TABLE `report`
  ADD PRIMARY KEY (`report_id`);

--
-- Indexes for table `resources`
--
ALTER TABLE `resources`
  ADD PRIMARY KEY (`resource_id`);

--
-- Indexes for table `saccos`
--
ALTER TABLE `saccos`
  ADD PRIMARY KEY (`sacco_id`);

--
-- Indexes for table `sacco_applications`
--
ALTER TABLE `sacco_applications`
  ADD PRIMARY KEY (`application_id`);

--
-- Indexes for table `sacco_statistics`
--
ALTER TABLE `sacco_statistics`
  ADD PRIMARY KEY (`stat_id`);

--
-- Indexes for table `sacco_trainings`
--
ALTER TABLE `sacco_trainings`
  ADD PRIMARY KEY (`training_id`);

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`service_id`);

--
-- Indexes for table `subscribers`
--
ALTER TABLE `subscribers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `success_stories`
--
ALTER TABLE `success_stories`
  ADD PRIMARY KEY (`story_id`);

--
-- Indexes for table `trainings`
--
ALTER TABLE `trainings`
  ADD PRIMARY KEY (`training_id`);

--
-- Indexes for table `training_applications`
--
ALTER TABLE `training_applications`
  ADD PRIMARY KEY (`application_id`);

--
-- Indexes for table `vacancies`
--
ALTER TABLE `vacancies`
  ADD PRIMARY KEY (`vacancy_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `blog_categories`
--
ALTER TABLE `blog_categories`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `blog_comments`
--
ALTER TABLE `blog_comments`
  MODIFY `comment_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `blog_posts`
--
ALTER TABLE `blog_posts`
  MODIFY `blog_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
  MODIFY `event_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `faq_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `inquiries`
--
ALTER TABLE `inquiries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

--
-- AUTO_INCREMENT for table `job_categories`
--
ALTER TABLE `job_categories`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `leadership`
--
ALTER TABLE `leadership`
  MODIFY `leader_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=51;

--
-- AUTO_INCREMENT for table `newsletters`
--
ALTER TABLE `newsletters`
  MODIFY `newsletter_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `project_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `publications`
--
ALTER TABLE `publications`
  MODIFY `publication_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `regions`
--
ALTER TABLE `regions`
  MODIFY `region_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `report`
--
ALTER TABLE `report`
  MODIFY `report_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `resources`
--
ALTER TABLE `resources`
  MODIFY `resource_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `saccos`
--
ALTER TABLE `saccos`
  MODIFY `sacco_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80;

--
-- AUTO_INCREMENT for table `sacco_applications`
--
ALTER TABLE `sacco_applications`
  MODIFY `application_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;

--
-- AUTO_INCREMENT for table `sacco_statistics`
--
ALTER TABLE `sacco_statistics`
  MODIFY `stat_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55;

--
-- AUTO_INCREMENT for table `sacco_trainings`
--
ALTER TABLE `sacco_trainings`
  MODIFY `training_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `service_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `subscribers`
--
ALTER TABLE `subscribers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131;

--
-- AUTO_INCREMENT for table `success_stories`
--
ALTER TABLE `success_stories`
  MODIFY `story_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `trainings`
--
ALTER TABLE `trainings`
  MODIFY `training_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `training_applications`
--
ALTER TABLE `training_applications`
  MODIFY `application_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=95;

--
-- AUTO_INCREMENT for table `vacancies`
--
ALTER TABLE `vacancies`
  MODIFY `vacancy_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

