INSERT INTO `payrolls` (`id`, `check_number`, `full_name`, `account_number`, `bank_name`, `basic_salary`, `allowance`, `gross_amount`, `net_amount`, `created_at`, `updated_at`) VALUES
(47242, '113136832', 'Aurelia Boniphace Magonga', '40310127086', 'NMB - Nelson Mandela-Kilimanja', 460000.00, 69000.00, 529000.00, 348791.20, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47243, '113137935', 'Latifa Hassan Mkalavile', '40310128716', 'NMB - Nelson Mandela-Kilimanja', 460000.00, 170200.00, 630200.00, 469991.20, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47244, '113138038', 'Hamisi Ahmadi Mkama', '0152739785400', 'CRDB - Tandika', 460000.00, 184000.00, 644000.00, 337660.20, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47245, '113138221', 'Eliudi Msangi Elidaima', '40310129014', 'NMB Mandela Moshi', 460000.00, 124200.00, 584200.00, 423991.20, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47246, '113138980', 'Mariamu Bernard Manumbu', '43510028126', 'NMB - Bukome', 460000.00, 69000.00, 529000.00, 368791.20, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47247, '113139377', 'Celestina Kokunyegeza Deus', '40310129373', 'NMB - Nelson Mandela-Kilimanja', 460000.00, 138000.00, 598000.00, 417791.20, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47248, '113141146', 'Hafidhu Saidi Uliya', '40310128835', 'NMB Mandela Moshi', 460000.00, 69000.00, 529000.00, 368791.20, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47249, '113141848', 'Amos Zacharia Masele', '0152754013500', 'CRDB KCMC - Kilimanjaro', 460000.00, 184000.00, 644000.00, 463791.20, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47250, '113141866', 'Petro Justene Stephano', '43510027894', 'NMB - Nelson Mandela-Kilimanja', 460000.00, 69000.00, 529000.00, 358791.20, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47251, '113137562', 'Hilda Gosbert James', '50510075689', 'NMB - Nelson Mandela-Kilimanja', 460000.00, 184900.00, 644900.00, 464691.20, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47252, '8829636', 'Josam Katungi Gabikwa', '6058000861', 'NMB - Mkwawa,Iringa', 1549000.00, 578750.00, 2127750.00, 1178051.58, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47253, '8832867', 'Janeth Boniface Matafali', '51110006416', 'NMB - Nzega Tabora', 625000.00, 52125.00, 677125.00, 369609.10, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47254, '8893457', 'Elieka Daniel Mbise', '60310000603', 'NMB - DSM - Bank House', 639000.00, 40545.00, 679545.00, 255205.83, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47255, '8893664', 'Peter Makoye Njemu', '60610000004', 'NMB - Njombe,Iringa', 938000.00, 278550.00, 1216550.00, 600357.85, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47256, '8893745', 'Kakea Peter Chogelo', '6032503500', 'NMB - Makambako,Iringa', 639000.00, 93750.00, 732750.00, 608390.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47257, '8893985', 'Siphael Ndelekwa Mungure', '6058000933', 'NMB - Mkwawa,Iringa', 1299000.00, 698450.00, 1997450.00, 1143970.40, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47258, '8896698', 'Ally Amri Kitumbu', '27201066195', 'NBC - Bukoba', 2390000.00, 347250.00, 2737250.00, 1144458.33, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47259, '8899253', 'Shabani Bakari Senzota', '2268000070', 'NMB - Msasani Br.', 639000.00, 108120.00, 747120.00, 321218.33, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47260, '8900254', 'Hamadi Faki Khamisi', '6011600521', 'NMB - Ludewa - Iringa', 639000.00, 255600.00, 894600.00, 540882.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47261, '8900634', 'Haroub Maulid Alli', '2061603363', 'NMB - Zanzibar', 639000.00, 95850.00, 734850.00, 316406.67, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47262, '8900841', 'Mohd Ali Suleiman', '2298002459', 'NMB - Zanzibar', 639000.00, 93750.00, 732750.00, 370023.49, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47263, '8900922', 'Amini Shehe Juma', '2298002614', 'NMB - DSM - Bank House', 639000.00, 187500.00, 826500.00, 702140.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47264, '8901147', 'Joyce Laurent Kayombo', '2298002752', 'NMB - Zanzibar', 639000.00, 93750.00, 732750.00, 318577.50, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47265, '8901310', 'Salum Khamis Salum', '2298002568', 'NMB - Zanzibar', 639000.00, 40545.00, 679545.00, 605185.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47266, '8901365', 'Hamza Yahya Pandu', '2028001232', 'NMB-Chakechake', 639000.00, 216952.00, 855952.00, 481612.83, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47267, '8929488', 'Malimi Ndulu Malimi', '6128000576', 'NMB - Mbozi-Mbeya', 1597000.00, 182250.00, 1779250.00, 747421.67, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47268, '8929514', 'Flora Paul Masambu', '6192401620', 'NMB - Nkasi,Sumbawanga', 639000.00, 95850.00, 734850.00, 411960.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47269, '8929754', 'Ali Sururu Abdalla', '2298002558', 'NMB - Zanzibar', 639000.00, 93750.00, 732750.00, 381067.37, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47270, '9062575', 'Atubone Anania Mwakijale', '34201021790', 'NBC Mtwara', 1070000.00, 320000.00, 1390000.00, 798550.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47271, '9063424', 'Alexander Bernard Makwasa', '7062401952', 'NMB - Mtwara', 1070000.00, 156000.00, 1226000.00, 512705.98, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47272, '9063815', 'Assel Peter Mwampamba', '010-00152951', 'TPB - Iringa', 1948000.00, 756000.00, 2704000.00, 1405535.62, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47273, '9064052', 'Keneth Linus Mbilinyi', '6062401798', 'NMB - Njombe,Iringa', 938000.00, 57375.00, 995375.00, 393985.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47274, '9183728', 'Saleh Ali Hassan', '2298000573', 'NMB - DSM - Bank House', 639000.00, 157650.00, 796650.00, 371138.04, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47275, '9184770', 'Nyange Mussa Adam', '2298002635', 'NMB - Zanzibar', 639000.00, 93750.00, 732750.00, 328371.08, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47276, '9187106', 'Mwinyi Hadhar Abdalla', '2298002669', 'NMB - DSM - Bank House', 639000.00, 251400.00, 890400.00, 549373.33, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47277, '11001946', 'Nguyahambi Mohamed Mkwayaya', '6051601575', 'NMB - Mkwawa,Iringa', 639000.00, 93750.00, 732750.00, 352140.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47278, '11002002', 'Maulidi Hamisi Mvungi', '6058000954', 'NMB - Mkwawa,Iringa', 548000.00, 82200.00, 630200.00, 265907.96, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47279, '11002013', 'Mgaya Juma Singo', '6058000853', 'NMB - Mkwawa,Iringa', 548000.00, 38115.00, 586115.00, 221535.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47280, '11002079', 'Yasinta Augustine Moshi', '6058000970', 'NMB - Mkwawa,Iringa', 1299000.00, 423750.00, 1722750.00, 864793.33, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47281, '11003696', 'Huruma Yesala Mwampashi', '3181600923', 'NMB - Biharamulo,Kagera', 965000.00, 274500.00, 1239500.00, 722289.96, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47282, '11004109', 'Jane Andarson Mwampashe', '3278000090', 'NMB - Chato,Kagera', 965000.00, 530750.00, 1495750.00, 895695.33, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47283, '11004110', 'Happyrose Addo Haule', '3188000502', 'NMB - Bukoba', 965000.00, 269700.00, 1234700.00, 601637.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47284, '11004637', 'Kelvin William Lubela', '5168002071', 'NMB - Kigoma Agency', 1299000.00, 698450.00, 1997450.00, 1151690.08, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47285, '11007199', 'Auguster Athanas Chang\'A', '7088000767', 'NMB - Newala,Mtwara', 548000.00, 38115.00, 586115.00, 420595.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47286, '11008417', 'Nazalius Idfonce Nzala', '30308000359', 'NMB - DSM - Bank House', 548000.00, 36495.00, 584495.00, 501975.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47287, '11010467', 'Abedi Ndokeji Kapaya', '6188000948', 'NMB - Songea', 548000.00, 217700.00, 765700.00, 472903.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47288, '11011534', 'Said Juma Mataru', '6058104131', 'NMB - Mkwawa,Iringa', 965000.00, 510950.00, 1475950.00, 949179.70, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47289, '11011707', 'Chimpaye Sinna Kilimali', '6218000150', 'NMB - Mpanda Sumbawanga', 548000.00, 82200.00, 630200.00, 547680.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47290, '11013620', 'Alex Michael Teutus', '5101601121', 'NMB - Mihayo', 639000.00, 187500.00, 826500.00, 432140.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47291, '11428879', 'Regnbert Renat Mkinga', '4048000330', 'NMB Rombo-Kilimanjaro', 548000.00, 124000.00, 672000.00, 307148.06, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47292, '11431022', 'Frank Claudius Haule', '4228001566', 'NMB - Mawenzi Moshi', 548000.00, 82200.00, 630200.00, 305362.82, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47293, '11434540', 'Silvester Silvester Gama', '5098000262', 'NMB - Igunga Tabora', 548000.00, 219200.00, 767200.00, 429823.86, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47294, '11435260', 'Felix Majura Magesa', '2068000746', 'NMB - DSM - Morogoro Rd', 625000.00, 82200.00, 707200.00, 334290.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47295, '11436038', 'Jordan Ahmad Kikula', '3118001862', 'NMB - Kenyatta Rd Mwanza', 548000.00, 162900.00, 710900.00, 346932.94, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47296, '11436430', 'Janeth Ndonde Henry', '5168000784', 'NMB - Kigoma Agency', 548000.00, 82200.00, 630200.00, 265211.39, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47297, '11438630', 'Mary Emmanuel Mtweve', '5058002473', 'NMB - Dodoma', 548000.00, 274000.00, 822000.00, 513775.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47298, '11441001', 'Joseph Leonard Makongoro', '6058001302', 'NMB - Mkwawa,Iringa', 965000.00, 144750.00, 1109750.00, 659108.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47299, '11441414', 'Nelius Nestory Gabriel', '6068000675', 'NMB - Njombe,Iringa', 965000.00, 438500.00, 1403500.00, 761182.19, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47300, '11441436', 'Pius Basilius Makoye', '6058001272', 'NMB - Mkwawa,Iringa', 548000.00, 217700.00, 765700.00, 447680.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47301, '12185502', 'Advent Helson Maliga', '6068001048', 'NMB - Njombe,Iringa', 653000.00, 226000.00, 879000.00, 444746.67, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47302, '12186052', 'Ali Musa Hasani', '6038000286', 'NMB - Makambako,Iringa', 548000.00, 82200.00, 630200.00, 265117.95, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47303, '12186144', 'Allen Eliud Mmari', '6048000478', 'NMB - Makete,Iringa', 548000.00, 36495.00, 584495.00, 219340.53, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47304, '12186199', 'Ally Hussein Abeid', '6041601672', 'NMB - Makete,Iringa', 558000.00, 221700.00, 779700.00, 408529.81, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47305, '12186373', 'Allyamrani Ally Mfinanga', '6038000290', 'NMB - Makambako,Iringa', 478000.00, 167300.00, 645300.00, 366102.81, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47306, '12186926', 'Amri Iddi Mbuta', '60608001068', 'NMB - DSM - Bank House', 548000.00, 82200.00, 630200.00, 292825.83, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47307, '12186982', 'Andrew Fulgence Choyo', '4038001606', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 184450.00, 732450.00, 367652.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47308, '12187100', 'Angeso Haward Kinyaga', '6068001063', 'NMB - Njombe,Iringa', 558000.00, 89250.00, 647250.00, 278792.60, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47309, '12187421', 'Anyimike Emmanuel Mwakipesile', '4038102834', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 253500.00, 892500.00, 473318.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47310, '12187487', 'Aristariki Wenzeslaus Shayo', '6038000287', 'NMB - Makambako,Iringa', 548000.00, 40411.00, 588411.00, 505891.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47311, '12187524', 'Aron Aloyce Shehiza', '6031605287', 'NMB - Makambako,Iringa', 548000.00, 82200.00, 630200.00, 264959.82, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47312, '12189959', 'Clemence Gasper Kuyumbe', '6048000475', 'NMB - Makete,Iringa', 639000.00, 240450.00, 879450.00, 453881.67, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47313, '12190351', 'Daud Ernest Kidenya', '4038001576', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 219200.00, 767200.00, 403082.87, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47314, '12190409', 'Daudi Matone Imambo', '6018000323', 'NMB - Ludewa - Iringa', 548000.00, 82200.00, 630200.00, 265117.95, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47315, '12190498', 'David Pastory Enos', '6068001049', 'NMB - Njombe,Iringa', 548000.00, 36400.00, 584400.00, 226733.56, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47316, '12193616', 'Fadhili Aloni Mgeni', '3058001380', 'NMB - Bariadi,Shinyanga', 965000.00, 258000.00, 1223000.00, 593812.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47317, '12194753', 'Frank Andrew Aloyce', '6048000474', 'NMB - Makete,Iringa', 548000.00, 82200.00, 630200.00, 301878.49, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47318, '12196557', 'Hamis Yasin Komba', '6018000317', 'NMB - Ludewa - Iringa', 548000.00, 274000.00, 822000.00, 457942.64, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47319, '12197720', 'Hussein Juma Shabani', '0152351537700', 'CRDB - Njombe,Iringa', 548000.00, 82200.00, 630200.00, 264939.23, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47320, '12198030', 'Ignas Joseph Mwitwa', '6048000477', 'NMB - Mahenge Morogoro', 548000.00, 82200.00, 630200.00, 265429.58, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47321, '12198579', 'Jackson Ernest Sumisumi', '22601601986', 'NMB - DSM - Bank House', 558000.00, 73200.00, 631200.00, 501280.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47322, '12199328', 'Jeremiah Enock Masele', '6068001044', 'NMB - Njombe,Iringa', 548000.00, 82200.00, 630200.00, 547680.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47323, '12201199', 'Jumanne Mafuru Charles', '40308001721', 'NMB - DSM - Bank House', 558000.00, 82200.00, 640200.00, 268279.67, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47324, '12202258', 'Leonard Francis Juma', '6018000319', 'NMB - DSM - Bank House', 558000.00, 80700.00, 638700.00, 553780.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47325, '111008145', 'Lupakisyo Onesmo Msese', '40310012612', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 219200.00, 767200.00, 402046.87, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47326, '111008314', 'Stanley Charles Njonjo', '40310010953', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 70350.00, 618350.00, 337602.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47327, '111008322', 'Mng\'Wala Nassoro Nassoro', '40310011329', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 80700.00, 628700.00, 546180.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47328, '111008495', 'Witness Afrael Nnko', '40310010934', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 70350.00, 618350.00, 259556.07, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47329, '111008753', 'Ferister Masota Lugwisha', '40310009370', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 154750.00, 702750.00, 422002.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47330, '111009304', 'Sauda Jumanne Mlete', '40310012285', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 70350.00, 618350.00, 331728.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47331, '111010845', 'Pastory Wilson Shimiyu', '40310010071', 'NMB - Nelson Mandela-Kilimanja', 915000.00, 411750.00, 1326750.00, 730164.21, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47332, '111010883', 'Adouf Buyegi Alphonce', '40310011110', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 164400.00, 712400.00, 347132.56, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47333, '111010911', 'Noel Christopher Chiwamba', '40310010662', 'NMB - Nelson Mandela-Kilimanja', 915000.00, 411750.00, 1326750.00, 850875.50, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47334, '111011111', 'Domician Septemu Raphael', '40310010787', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 61350.00, 609350.00, 358913.33, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47335, '111011222', 'Giliad Elibarick Kaaya', '40310011765', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 80700.00, 628700.00, 264413.33, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47336, '111011235', 'Paul Mpanda Renatus', '3111613631', 'NMB - Kenyatta Rd Mwanza', 965000.00, 274500.00, 1239500.00, 884062.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47337, '111011275', 'Asifiwe Asajile Asigile', '40310011785', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 207350.00, 755350.00, 391157.33, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47338, '111011515', 'Peter Edward Mwasenga', '40310010180', 'NMB - Nelson Mandela-Kilimanja', 478000.00, 71700.00, 549700.00, 231064.53, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47339, '111011705', 'Geofrey Nikas Pius', '40310010193', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 61350.00, 609350.00, 244630.68, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47340, '111011863', 'Felician Philemon Subeth', '40310012504', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 164400.00, 712400.00, 347530.79, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47341, '111013076', 'Fatuma Kasunga Athumani', '40310012330', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 80700.00, 628700.00, 264407.96, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47342, '111013410', 'Neema Gidion Tinda', '40310010635', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 173050.00, 711050.00, 395958.70, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47343, '111013606', 'Bushu Katemi Bushu', '40310011823', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 47000.00, 595000.00, 230049.92, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47344, '111013683', 'Benedict Onesmo Mkuti', '40310010195', 'NMB - Nelson Mandela-Kilimanja', 992000.00, 297600.00, 1289600.00, 1071400.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47345, '111014244', 'Marco John Malale', '40310012433', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 181600.00, 729600.00, 364359.54, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47346, '111014513', 'Witness Joel Yendayenda', '40310010058', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 80700.00, 628700.00, 263986.45, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47347, '111014520', 'Sikudhani Paul Mwambelo', '40310009958', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 70350.00, 618350.00, 305830.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47348, '111413762', 'Andrew Yohana Mayaka', '40310020461', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 173050.00, 711050.00, 384867.77, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47349, '111414295', 'Mohhammed Said Abdallah', '40310017192', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 70350.00, 608350.00, 309682.83, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47350, '111414404', 'Selemani Mohamed Ngapoma', '40310016994', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 104000.00, 642000.00, 540812.00, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47351, '111415040', 'Hamza Yohana Kidumangile', '40310021611', 'NMB - Nelson Mandela-Kilimanja', 625000.00, 204850.00, 829850.00, 416529.63, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47352, '111415056', 'Andrea Joseph Bundala', '40310021066', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 181600.00, 719600.00, 362995.33, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47353, '111415693', 'Mkumbukwa Ysufu Bamira', '40310020877', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 0.00, 538000.00, 179333.21, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47354, '111415799', 'Kyangwe Wang\'Anga Sarari', '40310017404', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 161400.00, 699400.00, 341180.05, '2024-10-17 15:06:15', '2024-10-17 15:06:15'),
(47355, '111417015', 'Gelvas Erick Komba', '40310020265', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 143400.00, 681400.00, 350334.41, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47356, '111417204', 'Tiron Rangson Ironga', '40310022009', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 278532.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47357, '111417704', 'Philipo Wambura Alex', '40310016731', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 53550.00, 591550.00, 295612.78, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47358, '111417735', 'Lucas Gerald Batano', '40310020173', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 70350.00, 608350.00, 249683.16, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47359, '111417774', 'Juma Ahamadi Masumba', '40310020612', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 140700.00, 678700.00, 320631.92, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47360, '111418109', 'Stephen Mpuya Peter', '40310021173', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 70350.00, 608350.00, 250378.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47361, '111418646', 'Philipo Fanuel Madinda', '40310020416', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 104000.00, 642000.00, 344282.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47362, '111418861', 'Ellon Chacha Kirina', '40310017748', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 151050.00, 689050.00, 330572.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47363, '111418972', 'Selina Samwel Kahabuka', '40310016812', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 70350.00, 608350.00, 277720.87, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47364, '111419283', 'Ibrahim Ali Faki', '40310016767', 'NMB - DSM - Bank House', 538000.00, 140700.00, 678700.00, 322639.70, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47365, '111419735', 'Ramadhan Amry Matola', '40310021098', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 255600.00, 894600.00, 584198.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47366, '111420436', 'Siamini Selemani Njee', '40310020849', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 215200.00, 753200.00, 394949.50, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47367, '111420473', 'Grace Tenga Nyamle', '40310016716', 'NMB - Nelson Mandela-Kilimanja', 653000.00, 217500.00, 870500.00, 441750.63, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47368, '111420475', 'Happy Japhet Mwanankale', '40310016715', 'NMB - Nelson Mandela-Kilimanja', 992000.00, 243050.00, 1235050.00, 573949.18, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47369, '111420864', 'Happiness Bakari Gombanila', '40310016646', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 215200.00, 753200.00, 421986.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47370, '111420965', 'Tausi Mickidad Salum', '40310017878', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 61350.00, 599350.00, 300637.92, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47371, '111865951', 'Abisai Bonifas Msungu', '40310029197', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 0.00, 538000.00, 180333.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47372, '111874333', 'Fred Noel John', '40310039211', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 134500.00, 672500.00, 351353.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47373, '111874713', 'Boniphace Morice Emmanuel', '40310041330', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 143400.00, 681400.00, 580212.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47374, '111874838', 'Crister Elia Lalika', '40310036779', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 122700.00, 660700.00, 331145.51, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47375, '111875193', 'Valerian Dismas Udake', '40310037081', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 206200.00, 744200.00, 643012.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47376, '111875204', 'Burere Samwel Kitenge', '40310040399', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 143400.00, 681400.00, 355312.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47377, '111875996', 'Godluck Timotheo Zebedeyo', '40310040409', 'NMB - Msasani Br.', 639000.00, 159750.00, 798750.00, 694390.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47378, '111876678', 'Frank Father Karadia', '40310039535', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 215200.00, 753200.00, 422032.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47379, '111877035', 'Zulfa Nassoro Kitorondo', '40310038676', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 528512.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47380, '111877756', 'Hamad Abdalla Haji', '40310037646', 'NMB - Nelson Mandela-Kilimanja', 478000.00, 71700.00, 549700.00, 456072.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47381, '111877892', 'Caroline Silvester Ayuke', '40310038397', 'NMB - Nelson Mandela-Kilimanja', 915000.00, 503250.00, 1418250.00, 1172188.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47382, '111878028', 'Maombi Yasoni Mnyanyi', '40310040097', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 0.00, 538000.00, 179723.81, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47383, '111878257', 'Magreth Gipson Kyando', '40310036777', 'NMB - Nelson Mandela-Kilimanja', 915000.00, 274500.00, 1189500.00, 580513.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47384, '111878590', 'Peter Daniel Mgendi', '40310037931', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 283612.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47385, '111878796', 'Said Saleh Mbarouk', '40310037039', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 80700.00, 618700.00, 537512.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47386, '111879416', 'Prisca Joseph Mbise', '40310042370', 'NMB - Nelson Mandela-Kilimanja', 478000.00, 71700.00, 549700.00, 236113.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47387, '111879605', 'Mariam Mohamedi Abasi', '40310039199', 'NMB - Nelson Mandela-Kilimanja', 625000.00, 133050.00, 758050.00, 344705.59, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47388, '111880190', 'Godwin Joseph Pallangyo', '40310040437', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 284838.11, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47389, '111880262', 'Yasini Yusuph Sempombe', '40310041576', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 257722.60, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47390, '111880316', 'Shida Samwel Shimawa', '40310042524', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 291032.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47391, '111881379', 'Yussuf Mohamed Alawi', '40310040715', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 456095.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47392, '111881886', 'Andrew Peter Kibao', '40310039091', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 61350.00, 599350.00, 270009.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47393, '111882233', 'Yusufu Martini Mgendi', '40310037658', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 251050.23, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47394, '112685376', 'Regina Ruti Deo', '40310108267', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 237064.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47395, '112685401', 'Kelvin Ayubu Amanyisye', '0152624946600', 'CRDB Kinondoni Municipal - Dar es Salaam', 469000.00, 70350.00, 539350.00, 231772.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47396, '112685513', 'Asia Abdul Kapalamba', '40310107389', 'NMB Mandela Moshi', 548000.00, 217700.00, 765700.00, 653180.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47397, '112685527', 'Phaustini Pascal Dalei', '42910026448', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 245189.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47398, '112685545', 'Daniel Michael Kapama', '43510018089', 'NMB Mandela Moshi', 469000.00, 140700.00, 609700.00, 297831.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47399, '112685885', 'Happiness Noel Akyoo', '0152624849000', 'CRDB Chanika - Dar es Salaam', 469000.00, 187600.00, 656600.00, 514106.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47400, '112686125', 'Naomi Mussa Mshokela', '40310107887', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 446856.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47401, '112686519', 'Newton Nesphail Mulazi', '40310109110', 'NMB Mandela Moshi', 469000.00, 187600.00, 656600.00, 343966.35, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47402, '112688201', 'Venance Konrad Mzwalandili', '0152625016600', 'CRDB Ilala Municipal - Dar es Salaam', 548000.00, 217700.00, 765700.00, 400971.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47403, '112688707', 'Leonard Pastory Lupi', '40310109700', 'NMB Mandela Moshi', 548000.00, 161400.00, 709400.00, 626880.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47404, '112689516', 'Getruda Joseph Kalinde', '40310108907', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 231658.08, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47405, '112689724', 'Khalid Ali Mwita', '40310106806', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 466856.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47406, '112690507', 'Jackline Justine Bilingi', '40310107340', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 226691.42, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47407, '112690608', 'Kassim Abdulla Mohammed', '40310109669', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 275960.17, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47408, '112692276', 'Khadija Juma Sefu', '40310109012', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 419772.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47409, '112692337', 'Imani Robert Chikole', '40310109406', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 466856.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47410, '112692362', 'Amani Odeni Mwambwalo', '40310109255', 'NMB Mandela Moshi', 469000.00, 140700.00, 609700.00, 537206.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47411, '112692466', 'Isihaka Sudi Abdala', '40310108796', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 295981.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47412, '112692505', 'Mwajuma Masudi Kitwana', '42210018941', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 461856.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47413, '112692853', 'Clement Herry Makomba', '0152625062000', 'CRDB Mwanga - Kilimanjaro', 469000.00, 187600.00, 656600.00, 347106.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47414, '112693512', 'Sadru Ali Muhsin', '43510018243', 'NMB Mandela Moshi', 469000.00, 187600.00, 656600.00, 589106.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47415, '112694374', 'Masunga Hoja Kidaha', '40310108992', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 226939.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47416, '112694615', 'Florah Flowin Chilumba', '42210018256', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 446856.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47417, '112694786', 'Saidi Hamisi Mnongelwa', '40310109628', 'NMB Mandela Moshi', 469000.00, 191650.00, 660650.00, 593156.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47418, '12031498', 'Hekima Zakayo Msemwa', '016201182175', 'NBC Mbeya', 639000.00, 249750.00, 888750.00, 462799.38, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47419, '9443181', 'Omari Mzulwa Kihenya', '6042400762', 'NMB - Makete,Iringa', 1070000.00, 156000.00, 1226000.00, 640564.05, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47420, '9443228', 'Beno Damian Komba', '6068000334', 'NMB - Njombe,Iringa', 965000.00, 0.00, 965000.00, 336758.84, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47421, '9443516', 'Said Uladi Ally', '010-00156227', 'TPB-Kariakoo', 639000.00, 40545.00, 679545.00, 277560.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47422, '9443642', 'Said Hamad Salum', '2298002873', 'NMB - DSM - Bank House', 639000.00, 95850.00, 734850.00, 309084.57, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47423, '9446872', 'Abas Mohamed Issa', '2298000301', 'NMB - Zanzibar', 625000.00, 83700.00, 708700.00, 434165.28, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47424, '9447709', 'Karimu Suleiman Ahmada', '2028001286', 'NMB-Chakechake', 639000.00, 189600.00, 828600.00, 411440.72, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47425, '9448016', 'Lilanga Selemani Chodas', '010-00254493', 'TPB - Songea', 1259000.00, 156000.00, 1415000.00, 673614.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47426, '9450158', 'Prosper George Ngoro', '6058102649', 'NMB - Mkwawa,Iringa', 1299000.00, 377700.00, 1676700.00, 812996.79, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47427, '9450538', 'Jackson John Mrema', '3118001417', 'NMB - Kenyatta Rd Mwanza', 1597000.00, 0.00, 1597000.00, 540880.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47428, '9450882', 'Selestino Ruhembe Sylvester', '5112401899', 'NMB - Nzega Tabora', 1890000.00, 375945.00, 2265945.00, 1010351.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47429, '9452897', 'Hamis Ngosho Ngwele', '2032401366', 'NMB - DSM - Ilala Br', 830000.00, 223500.00, 1053500.00, 411030.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47430, '9453263', 'Paul Daniel Chilulu', '2012529237', 'NMB - DSM - Bank House', 1299000.00, 377700.00, 1676700.00, 810872.62, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47431, '9453676', 'Mahamoud Banga Hassan', '30308000936', 'NMB - DSM - Bank House', 2315000.00, 694500.00, 3009500.00, 1466526.57, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47432, '9510571', 'Abdallah Israel Muna', '2212520475', 'NMB - Wami Morogoro', 639000.00, 95850.00, 734850.00, 309001.52, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47433, '9511028', 'Francis Florian Ngatunga', '4022400137', 'NMB - Mwanga Kilimanjaro', 965000.00, 266250.00, 1231250.00, 613636.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47434, '9512689', 'Masoud Jumanne Kitembe', '5012400713', 'NMB - Kiteto,Arusha', 639000.00, 251400.00, 890400.00, 475206.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47435, '9519448', 'Diana Mario Lupola', '6068000180', 'NMB - Njombe,Iringa', 639000.00, 93750.00, 732750.00, 306873.49, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47436, '9521247', 'Amina Mohamed Ishemwabura', '20610000838', 'NMB - DSM - Morogoro Rd', 639000.00, 40545.00, 679545.00, 253619.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47437, '9521362', 'Sankey Twajobene Mwakasege', '6062401825', 'NMB - Njombe,Iringa', 965000.00, 258000.00, 1223000.00, 580281.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47438, '9521384', 'Pantaleo Zeno Dimoso', '0112074866800', 'CRDB - Njombe,Iringa', 639000.00, 93750.00, 732750.00, 345510.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47439, '9522299', 'Emmanuel Rwekaza Kahwa', '6101601931', 'NMB - Mbalizi Rd,Mbeya', 639000.00, 93750.00, 732750.00, 307524.91, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47440, '9524983', 'Yusuph Juma Masoud', '6191600728', 'NMB - Mpanda Sumbawanga', 639000.00, 93750.00, 732750.00, 306750.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47441, '9525027', 'Upendo Asangalwisye Shibandah', '3268000023', 'NMB - Misenyi,Karagwe', 639000.00, 95850.00, 734850.00, 560490.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47442, '9559833', 'Benjamin Anthony Mwala', '61810001472', 'NMB - Songea', 1299000.00, 268230.00, 1567230.00, 1199065.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47443, '9560233', 'Jane Peter Warioba', '4088002202', 'NMB - Clock Tower,Arusha', 1597000.00, 310200.00, 1907200.00, 1108594.76, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47444, '12025214', 'Ameme Iddi Ameme', '6018000281', 'NMB - Ludewa - Iringa', 992000.00, 274500.00, 1266500.00, 624404.17, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47445, '12026030', 'Athumani Ali Makwinja', '6018000277', 'NMB - Ludewa - Iringa', 548000.00, 82200.00, 630200.00, 264892.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47446, '12027775', 'Deogratias Edecy Kiondo', '6018000267', 'NMB - Ludewa - Iringa', 548000.00, 82200.00, 630200.00, 265305.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47447, '12028177', 'Edward Kazi Leonard', '6068001051', 'NMB - Njombe,Iringa', 639000.00, 48000.00, 687000.00, 261122.70, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47448, '12029513', 'Fatuma Mwinyi Abdallah', '7068000967', 'NMB - Mtwara', 548000.00, 61350.00, 609350.00, 249496.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47449, '12030823', 'Gwamaka Joshua Mwamasage', '6041601427', 'NMB - Makete,Iringa', 639000.00, 253500.00, 892500.00, 488100.16, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47450, '12031100', 'Hamis Abdu Mbaraka', '6068000947', 'NMB - Njombe,Iringa', 548000.00, 82200.00, 630200.00, 276846.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47451, '12032007', 'Isaya John Levy', '6018000303', 'NMB - Ludewa - Iringa', 548000.00, 33606.00, 581606.00, 216434.05, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47452, '12032339', 'James Gabriel Lyaruu', '6068000843', 'NMB - Njombe,Iringa', 548000.00, 137000.00, 685000.00, 319932.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47453, '12032719', 'John Emanuel Mazinde', '6048000438', 'NMB - Makete,Iringa', 548000.00, 82200.00, 630200.00, 265824.65, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47454, '12034328', 'Liswele Mussa Liswele', '6018000275', 'NMB - Ludewa - Iringa', 548000.00, 196850.00, 744850.00, 379771.37, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47455, '12034476', 'Lwata Loibanguti Laiza', '6018000276', 'NMB - Ludewa - Iringa', 965000.00, 144750.00, 1109750.00, 487645.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47456, '12034867', 'Maria Mkama Protas', '70210002495', 'NMB - DSM - Bank House', 548000.00, 61350.00, 609350.00, 296496.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47457, '12035591', 'Michael Prudenc Evarist', '6021603305', 'NMB - Mafinga Iringa', 548000.00, 272500.00, 820500.00, 455579.24, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47458, '12035993', 'Mohamedi Hemedi Mlenda', '6068000946', 'NMB - Njombe,Iringa', 548000.00, 82200.00, 630200.00, 497680.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47459, '12037155', 'Nsajigwa Andondile Talaka', '2108000651', 'NMB - Bagamoyo Coast', 548000.00, 82200.00, 630200.00, 359013.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47460, '12037362', 'Omary Abdallah Tembeleni', '6018000278', 'NMB - Ludewa - Iringa', 942000.00, 518100.00, 1460100.00, 900728.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47461, '12037384', 'Ombeni Maiko Mbwilo', '6068000855', 'NMB - Njombe,Iringa', 548000.00, 82200.00, 630200.00, 293538.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47462, '12039030', 'Romanus Nazareth Makishe', '6018000279', 'NMB - Ludewa - Iringa', 639000.00, 317400.00, 956400.00, 531560.37, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47463, '12039591', 'Salum Kaswile Mpina', '2028001758', 'NMB-Chakechake', 639000.00, 187500.00, 826500.00, 428390.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47464, '12040753', 'Steven Charles Marwa', '6048000437', 'NMB - Makete,Iringa', 1070000.00, 468000.00, 1538000.00, 825250.04, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47465, '12041018', 'Tatu Juma Issaka', '4038002057', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 82200.00, 630200.00, 264907.34, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47466, '12041351', 'Vasco Emanuel Matepa', '6041601347', 'NMB - Makete,Iringa', 548000.00, 217700.00, 765700.00, 401135.90, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47467, '12185317', 'Adam Ernest Mathew', '40308001618', 'NMB - DSM - Bank House', 548000.00, 82200.00, 630200.00, 344452.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47468, '110663453', 'Asha Maulidi Darabu', '4031609787', 'NMB - Nelson Mandela-Kilimanja', 478000.00, 71700.00, 549700.00, 231167.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47469, '110663566', 'Theophilius Gregory Ludega', '40310004410', 'NMB - Mawenzi Moshi', 992000.00, 545600.00, 1537600.00, 1000233.91, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47470, '110664106', 'Rajabu Athuman Njaa', '40310004936', 'NMB - Nelson Mandela-Kilimanja', 965000.00, 269700.00, 1234700.00, 601603.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47471, '110664865', 'Bernad Jeremia Msuya', '40310002595', 'NMB - Mawenzi Moshi', 548000.00, 80700.00, 628700.00, 263448.06, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47472, '110664970', 'Hadija Yusufu Hakimu', '40310004561', 'NMB - Mawenzi Moshi', 548000.00, 80700.00, 628700.00, 546180.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47473, '110665550', 'Khadija Abdallah Masunga', '40310004117', 'NMB - Mawenzi Moshi', 478000.00, 71700.00, 549700.00, 235093.46, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47474, '110665724', 'Awadhi Juma Kisuse', '40310004826', 'NMB - Mawenzi Moshi', 639000.00, 253500.00, 892500.00, 466677.17, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47475, '110667295', 'Nikundael Rabsoni Raphael', '40310002579', 'NMB - Mawenzi Moshi', 548000.00, 82200.00, 630200.00, 339977.50, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47476, '110667326', 'Juma Samwel Mangweku', '2128602066', 'NMB - Kibaha,Coast', 915000.00, 274500.00, 1189500.00, 993438.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47477, '110667383', 'Msalika John Makoye', '40310002987', 'NMB - Mawenzi Moshi', 942000.00, 344000.00, 1286000.00, 665146.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47478, '110668572', 'William Shilima Shilima', '40310003958', 'NMB - Mawenzi Moshi', 548000.00, 61350.00, 609350.00, 312783.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47479, '110669204', 'Bahati Shaidary Lugome', '40310004275', 'NMB - Mawenzi Moshi', 548000.00, 80700.00, 628700.00, 263617.95, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47480, '110670945', 'Charles Sweya Mihambo', '40310002524', 'NMB - DSM - Bank House', 548000.00, 216200.00, 764200.00, 483453.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47481, '110671139', 'Johnbosco Donatus Mkinga', '40310002903', 'NMB - Mawenzi Moshi', 548000.00, 100900.00, 648900.00, 283578.89, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47482, '110671701', 'Nyenye Maliganya Masanja', '40310004417', 'NMB - Mawenzi Moshi', 548000.00, 82200.00, 630200.00, 359992.50, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47483, '110675984', 'Lilian Sebastian Sudi', '40310003279', 'NMB - Mawenzi Moshi', 548000.00, 80700.00, 628700.00, 268846.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47484, '110676492', 'Loyce Elikana John', '40310004571', 'NMB - Mawenzi Moshi', 965000.00, 266250.00, 1231250.00, 597085.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47485, '110677024', 'Lugenji Castory Ng\'Wandu', '40310004426', 'NMB - Mawenzi Moshi', 653000.00, 322300.00, 975300.00, 540054.57, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47486, '110679267', 'Naftary Alfredy Mwinuka', '40310002425', 'NMB - Mawenzi Moshi', 992000.00, 266250.00, 1258250.00, 598603.20, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47487, '110679615', 'Joseph Amos Yona', '40310003222', 'NMB - Mawenzi Moshi', 992000.00, 514250.00, 1506250.00, 905142.32, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47488, '110681494', 'Angela Fulko Komba', '40310001895', 'NMB - Mawenzi Moshi', 558000.00, 42930.00, 600930.00, 229240.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47489, '110682185', 'Sadiki Mohamedi Saidi', '40310003577', 'NMB - Mawenzi Moshi', 548000.00, 216200.00, 764200.00, 400746.54, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47490, '110682547', 'Hosea Isaya Jaiko', '40310004623', 'NMB - Mawenzi Moshi', 548000.00, 274000.00, 822000.00, 457002.75, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47491, '110683623', 'Raphael Richard Zaidi', '40310003153', 'NMB - Mawenzi Moshi', 548000.00, 82200.00, 630200.00, 264939.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47492, '111014735', 'Shirazi Abdalah Salanga', '40310011305', 'NMB - Nelson Mandela-Kilimanja', 653000.00, 191700.00, 844700.00, 578980.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47493, '111016256', 'Sadick Wangere Chibunga', '40310010726', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 47000.00, 595000.00, 312209.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47494, '111016288', 'Flora Peter Msuya', '40310011367', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 61350.00, 609350.00, 250490.25, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47495, '111016335', 'Agnes Charles Ndalifanya', '40310011511', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 80700.00, 628700.00, 297426.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47496, '111016503', 'Aroh Elieza Katabaro', '40310009916', 'NMB - Nelson Mandela-Kilimanja', 653000.00, 257000.00, 910000.00, 752280.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47497, '111016596', 'Potwal Hudson Mwabusila', '40310009291', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 187600.00, 725600.00, 438088.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47498, '111016779', 'Yocta Richard Maeyond', '40310010268', 'NMB - Nelson Mandela-Kilimanja', 942000.00, 423900.00, 1365900.00, 794866.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47499, '111017019', 'Leila Abdu Mwampyate', '40310012280', 'NMB - Nelson Mandela-Kilimanja', 653000.00, 93750.00, 746750.00, 312040.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47500, '111017209', 'Ramadhani Ahamadi Amani', '7021603790', 'NMB - Kibaha,Coast', 548000.00, 70350.00, 618350.00, 286901.86, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47501, '111017296', 'Hosea Michael Mdogo', '40310011883', 'NMB - Nelson Mandela-Kilimanja', 915000.00, 411750.00, 1326750.00, 716794.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47502, '111017305', 'Emanuela Belamini Damiano', '40310010814', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 219200.00, 767200.00, 462465.59, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47503, '111024106', 'Hagai Undule Mpala', '40310012493', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 42000.00, 590000.00, 298890.38, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47504, '111024248', 'Samiath Atugonza Mohamed', '40310009779', 'NMB - Nelson Mandela-Kilimanja', 942000.00, 613050.00, 1555050.00, 1121206.50, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47505, '111025383', 'Lucy Deogratius Temu', '40310010976', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 55000.00, 593000.00, 351175.60, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47506, '111025573', 'Oliva Chesco Ngimba', '40310011530', 'NMB - Nelson Mandela-Kilimanja', 558000.00, 221700.00, 779700.00, 407902.64, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47507, '111025763', 'Godlove Wilson Kassano', '40310012169', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 80700.00, 628700.00, 263498.74, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47508, '111026026', 'Isakwisa Syason Mwambulukutu', '40310011892', 'NMB - Nelson Mandela-Kilimanja', 965000.00, 530750.00, 1495750.00, 856535.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47509, '111026104', 'Theophil Danken Mwakalukwa', '40310009306', 'NMB - Nelson Mandela-Kilimanja', 965000.00, 277800.00, 1242800.00, 597972.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47510, '111026414', 'Vumilia Nakalemo Daud', '40310011758', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 70350.00, 618350.00, 535830.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47511, '111027245', 'Mponjoli Asesisye Mwamatepela', '40310011415', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 204850.00, 742850.00, 421703.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47512, '111027295', 'Fredrick Aloyce Phabian', '40310010712', 'NMB - Nelson Mandela-Kilimanja', 653000.00, 187500.00, 840500.00, 722780.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47513, '111027583', 'Proscovia Furgence Kaishaza', '40310009440', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 82200.00, 630200.00, 265123.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47514, '111028085', 'Isack Omary Nziku', '40310009649', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 187500.00, 826500.00, 712140.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47515, '111421025', 'Crescensia Osward Ndaile', '40310017560', 'NMB - Nelson Mandela-Kilimanja', 625000.00, 187600.00, 812600.00, 396661.04, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47516, '111428439', 'Florida Thomas Kiecha', '40310017489', 'NMB - Nelson Mandela-Kilimanja', 992000.00, 244500.00, 1236500.00, 576304.54, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47517, '111428464', 'Mohamed Kaimu Nchimbi', '40310021560', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 53550.00, 591550.00, 233754.01, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47518, '111428715', 'Eliminata Marcel Amani', '40310017989', 'NMB - Nelson Mandela-Kilimanja', 965000.00, 479750.00, 1444750.00, 802445.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47519, '111428890', 'Agatha Ladislaus Mhule', '40310021629', 'NMB - Nelson Mandela-Kilimanja', 625000.00, 70350.00, 695350.00, 354225.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47520, '111429875', 'Kanisia Lugongo Gallusi', '40310020994', 'NMB - DSM - Bank House', 558000.00, 209700.00, 767700.00, 396016.17, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47521, '111430205', 'Hassan Hamad Ayoub', '40310017743', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 80700.00, 618700.00, 260261.08, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47522, '111432354', 'Violeth Gideon Angyelile', '40310017793', 'NMB - DSM - Bank House', 992000.00, 266100.00, 1258100.00, 989900.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47523, '111438199', 'Musa Jackson Enos', '40310017582', 'NMB - DSM - Bank House', 639000.00, 187500.00, 826500.00, 400693.76, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47524, '111447466', 'Abdul Mohd Omar', '40310020669', 'NMB - DSM - Bank House', 538000.00, 161400.00, 699400.00, 400732.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16');
INSERT INTO `payrolls` (`id`, `check_number`, `full_name`, `account_number`, `bank_name`, `basic_salary`, `allowance`, `gross_amount`, `net_amount`, `created_at`, `updated_at`) VALUES
(47525, '111765884', 'Lameck Mluge Velucy', '40310031083', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 64560.00, 602560.00, 245013.21, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47526, '111766061', 'Paschal Wandiba James', '40310032193', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 140700.00, 678700.00, 320225.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47527, '111766505', 'Yemba Bakari Ramadhani', '40310029852', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 80700.00, 618700.00, 260222.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47528, '111767345', 'Ogutu Juma Jeremiah', '40310030155', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 187500.00, 826500.00, 401328.16, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47529, '111767525', 'Emanuel Numbay Gadiye', '40310031091', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 161400.00, 699400.00, 401682.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47530, '111767787', 'Nebister Akimu Mwantimwa', '40310030118', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 204850.00, 742850.00, 384372.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47531, '111768143', 'Mwajuma Ngalipa Yassin', '40310031267', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 80700.00, 618700.00, 517512.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47532, '111768976', 'Benstard Samson Mwoshe', '40310032474', 'NMB - Nelson Mandela-Kilimanja', 965000.00, 277800.00, 1242800.00, 599556.05, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47533, '111769305', 'Abdallah Hamisi Shabani', '40310030407', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 131700.00, 669700.00, 371982.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47534, '111769486', 'Winfrida Batholomeo Mwija', '40310028566', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 70350.00, 608350.00, 309657.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47535, '111769565', 'Gisbert Stanslaus Kalihose', '40310030207', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 161400.00, 699400.00, 397482.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47536, '111769621', 'Salvatory John Msukuye', '40310030405', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 215200.00, 753200.00, 394546.16, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47537, '111770293', 'Tedy Mosses Kossam', '40310028959', 'NMB - Nelson Mandela-Kilimanja', 965000.00, 290700.00, 1255700.00, 613547.39, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47538, '111882774', 'Salum Pius Nyambo', '40310042332', 'NMB - Nelson Mandela-Kilimanja', 478000.00, 71700.00, 549700.00, 296373.35, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47539, '111883173', 'Elina Stephano Mahundi', '40310039419', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 180850.00, 718850.00, 392828.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47540, '111883377', 'Masola Amoni Kyando', '40310038127', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 80700.00, 618700.00, 292647.81, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47541, '111883645', 'Emmanuel Kerenge James', '40310037048', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 102250.00, 640250.00, 281759.17, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47542, '111884185', 'Bakhira Ali Adibu', '40310037521', 'NMB - Nelson Mandela-Kilimanja', 558000.00, 82200.00, 640200.00, 545280.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47543, '111884545', 'Neema Ephraim Lutufyo', '40310041597', 'NMB - Nelson Mandela-Kilimanja', 965000.00, 274350.00, 1239350.00, 619328.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47544, '111884892', 'Khatib Ali Makame', '40310042353', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 528512.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47545, '111885099', 'Johanes Jemus Nyamubi', '40310039441', 'NMB - Nelson Mandela-Kilimanja', 478000.00, 191200.00, 669200.00, 350592.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47546, '111885373', 'Godlizen Horera Kabalana', '40310040778', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 191200.00, 729200.00, 403168.66, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47547, '111886255', 'Sairis Kayetani Mapunda', '40310038351', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 288340.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47548, '111886353', 'Abdallah Mfaume Nassoro', '40310042394', 'NMB - Nelson Mandela-Kilimanja', 558000.00, 82200.00, 640200.00, 272611.29, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47549, '111886525', 'Janeth Abinely Ikanyagwa', '40310039514', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 134500.00, 672500.00, 346749.50, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47550, '111886724', 'Jane Deogratius Njovu', '40310040019', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 195850.00, 733850.00, 447853.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47551, '111887866', 'Faraja Bisukaye Nehemia', '40310039536', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 278532.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47552, '111888193', 'Joseph James Mbwambo', '40310037917', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 311032.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47553, '111888358', 'Oscar Benjamin Nkomola', '40310040431', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 187500.00, 826500.00, 262270.83, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47554, '111888383', 'Ramadhani Selemani Hussein', '40310038067', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 0.00, 538000.00, 216752.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47555, '111888423', 'Tukelage Bathromayo Mlelwa', '40310039833', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 122700.00, 660700.00, 302216.71, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47556, '111888446', 'Msafiri Osward Kumburu', '40310040506', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 143400.00, 681400.00, 600212.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47557, '111888541', 'Regina Leonard Kaiza', '40310042533', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 187500.00, 826500.00, 401504.02, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47558, '111888754', 'Asumai Amoni Kawili', '40310037395', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 206200.00, 744200.00, 413623.37, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47559, '111889325', 'Daulat Jabir Shaaban', '40310041135', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 528512.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47560, '111889853', 'Mathayo Maroga Ibrahim', '40310037670', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 448011.53, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47561, '112695162', 'Philipo George Samwel', '40310108912', 'NMB Mandela Moshi', 469000.00, 187600.00, 656600.00, 445356.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47562, '112695216', 'Edina Chrizant Bizumbula', '51510017123', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 226694.85, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47563, '112695484', 'Mwajuma Omary Abdallah', '40310108390', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 304389.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47564, '112696136', 'Seleman Abdallah Kajimbwa', '40310108805', 'NMB Mandela Moshi', 469000.00, 187600.00, 656600.00, 344189.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47565, '112696397', 'Benedictor Peter Imani', '40310108458', 'NMB Mandela Moshi', 469000.00, 187600.00, 656600.00, 358272.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47566, '112696516', 'Yusuph Zakayo Kudaba', '51610014413', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 231814.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47567, '112696555', 'Mohamed Shaban Mohamed', '42210018175', 'NMB Mandela Moshi', 469000.00, 140700.00, 609700.00, 522206.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47568, '112697303', 'Agnes Laurent Bugalama', '43510018281', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 226691.42, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47569, '112697776', 'Tasiana Ntibandese Barnaba', '40310108749', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 226705.14, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47570, '112698127', 'Salum Mohamed Dangali', '40310108924', 'NMB Mandela Moshi', 469000.00, 187600.00, 656600.00, 347106.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47571, '112698224', 'Revocatus Alfred Pessa', '0152624872500', 'CRDB Chanika - Dar es Salaam', 469000.00, 187600.00, 656600.00, 351235.82, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47572, '112698990', 'Magreth Patus Ndunguru', '40310107061', 'NMB Mandela Moshi', 469000.00, 187600.00, 656600.00, 579106.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47573, '112699158', 'Sizya Sadick Sizya', '40310108128', 'NMB Mandela Moshi', 469000.00, 187600.00, 656600.00, 344106.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47574, '112699681', 'Mariamu Mohamed Ally', '43510018207', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 226705.14, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47575, '112704527', 'Juma Mohamed Mvumbo', '42210018176', 'NMB Mandela Moshi', 469000.00, 187600.00, 656600.00, 413210.17, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47576, '113113887', 'Lawrence Alphonce Nyangira', '0152739785100', 'CRDB - Moshi', 538000.00, 215200.00, 753200.00, 573163.20, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47577, '113114585', 'Yohana Josephat Isoya', '51510019159', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 0.00, 538000.00, 347963.20, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47578, '113114703', 'Hawa Said Maarifa', '40310129123', 'NMB - Nelson Mandela-Kilimanja', 915000.00, 274500.00, 1189500.00, 854589.20, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47579, '113114861', 'Christopher Ndaro Mafwimbo', '40310128739', 'NMB - Nelson Mandela-Kilimanja', 915000.00, 274500.00, 1189500.00, 717339.20, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47580, '113115283', 'Julieth Joseph Mnibhi', '40310126556', 'NMB - Nelson Mandela-Kilimanja', 915000.00, 411750.00, 1326750.00, 1041839.20, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47581, '113115656', 'Fanuel James Mhoja', '017159000411', 'NBC - Dodoma', 915000.00, 640500.00, 1555500.00, 1153339.20, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47582, '113116956', 'Rajab Kamwanga Tambwe', '43510028031', 'NMB - Nelson Mandela-Kilimanja', 915000.00, 274500.00, 1189500.00, 904589.20, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47583, '113116970', 'Issa Mohamed Ramadhani', '40310129023', 'NMB - Nelson Mandela-Kilimanja', 460000.00, 0.00, 460000.00, 279791.20, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47584, '113117013', 'Amour Shaban Ramadhan', '40810169318', 'NMB - Nelson Mandela-Kilimanja', 915000.00, 274500.00, 1189500.00, 787339.20, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47585, '113117052', 'Spiro Jasmin Kazibure', '43510032986', 'NMB - Nelson Mandela-Kilimanja', 460000.00, 0.00, 460000.00, 299791.20, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47586, '9560417', 'Raphael Raphael Haule', '2212520503', 'NMB - Kilosa,Morogoro', 639000.00, 67575.00, 706575.00, 582215.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47587, '9561827', 'Ohsana Willison Mnalunde', '2212522371', 'NMB - DSM - Morogoro Rd', 639000.00, 93750.00, 732750.00, 307341.33, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47588, '9567715', 'Gotifrid Daniel Kimboy', '5012400698', 'NMB - Kiteto,Arusha', 1299000.00, 446650.00, 1745650.00, 881485.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47589, '9568099', 'Fredy Wilfreddy Kisanga', '4132400341', 'NMB - Monduli Arusha', 1299000.00, 844350.00, 2143350.00, 1290870.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47590, '9570809', 'Daud Daud Mapunda', '0152472837600', 'CRDB-Makambako', 1299000.00, 341850.00, 1640850.00, 774878.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47591, '9571079', 'Andrew Michael Njwaba', '6058000899', 'NMB - Mkwawa,Iringa', 723000.00, 0.00, 723000.00, 241061.71, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47592, '9571138', 'Ummi Maulidi Shaban', '6062401796', 'NMB - Njombe,Iringa', 639000.00, 93750.00, 732750.00, 306826.02, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47593, '9571149', 'Bedom Osia Gwalupogo', '6032502455', 'NMB - Njombe,Iringa', 639000.00, 237100.00, 876100.00, 456281.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47594, '9573143', 'Haruna Mlumba Pc Haruna Mlumba', '5148000298', 'NMB - Kasulu Kigoma', 1100000.00, 156000.00, 1256000.00, 544149.25, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47595, '9574944', 'Kasokola John Tungu', '7062500775', 'NMB - Mtwara', 639000.00, 0.00, 639000.00, 224923.39, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47596, '9575398', 'Maliki Hamisi Kisuda', '6078000146', 'NMB - Chunya Mbeya', 639000.00, 172530.00, 811530.00, 707170.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47597, '9578447', 'Rolence Thadeus Semanini', '5108000450', 'NMB - Mihayo', 639000.00, 95850.00, 734850.00, 314969.17, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47598, '9580419', 'Mussa Haji Kheri', '22910001427', 'NMB - Kigoma Agency', 639000.00, 93750.00, 732750.00, 628390.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47599, '9947265', 'Moris Lucas Kasinisalah', '028201053167', 'NBC - Iringa', 1299000.00, 377700.00, 1676700.00, 961126.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47600, '9947438', 'George Albert Missinzo', '6042400986', 'NMB - Makete,Iringa', 639000.00, 253500.00, 892500.00, 510806.67, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47601, '9952102', 'Azizi Abdul Zubeir', '2131600030', 'NMB - Kibiti Coast', 1040000.00, 53145.00, 1093145.00, 454866.72, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47602, '9952294', 'Beatrice Wilbard Kandaga', '2122401822', 'NMB - Kibaha,Coast', 639000.00, 80700.00, 719700.00, 303650.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47603, '9952869', 'Deonatus Baraka Munyaga', '7092401277', 'NMB - Tunduru,Mtwara', 1070000.00, 477000.00, 1547000.00, 841611.78, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47604, '9954117', 'Elizabeth Beatrice Ndambala', '11201140360', 'NBC D\'Salaam-Corporate Br', 1259000.00, 377700.00, 1636700.00, 797411.82, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47605, '10214486', 'Alinanuswe Matayo Mwakalinga', '5108000411', 'NMB - Mihayo', 639000.00, 159750.00, 798750.00, 694390.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47606, '10216594', 'Erick Mwaisaka Edom', '6062402803', 'NMB - Njombe,Iringa', 938000.00, 489500.00, 1427500.00, 824484.01, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47607, '10216642', 'Seif Juma Ally', '6041601825', 'NMB - Makete,Iringa', 639000.00, 236950.00, 875950.00, 454617.27, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47608, '10216859', 'Marco Josephat Mayunga', '01J2080927400', 'CRDB - Njombe,Iringa', 625000.00, 80700.00, 705700.00, 300402.24, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47609, '10220386', 'Abdallah Said Mbegu', '3182405070', 'NMB - Bukoba', 1299000.00, 623130.00, 1922130.00, 1058540.44, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47610, '110700863', 'Wilfred Solomon Lolusy', '40310004698', 'NMB - Mawenzi Moshi', 558000.00, 82200.00, 640200.00, 268285.88, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47611, '110701063', 'Pendo Suleiman Wambura', '40310002416', 'NMB - DSM - Bank House', 992000.00, 266250.00, 1258250.00, 596939.00, '2024-10-17 15:06:16', '2024-10-17 15:06:16'),
(47612, '110701253', 'Halidi Omari Hamza', '40310004328', 'NMB - Mawenzi Moshi', 548000.00, 80700.00, 628700.00, 263623.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47613, '110713929', 'Khadija Abdul Mwinyi', '40310004728', 'NMB - Mawenzi Moshi', 548000.00, 80700.00, 628700.00, 269674.73, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47614, '110713968', 'Hemed Said Mrisho', '40310003354', 'NMB - Mawenzi Moshi', 548000.00, 80700.00, 628700.00, 330582.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47615, '110723433', 'Mwajuma Jumanne Kongogwa', '40310002964', 'NMB - Mawenzi Moshi', 915000.00, 274500.00, 1189500.00, 580463.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47616, '110741995', 'Alex Amon Ngindo', '40310001879', 'NMB - Mkwawa,Iringa', 548000.00, 80700.00, 628700.00, 263848.06, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47617, '110757974', 'Edward Joseph Mwakifwamba', '60610002083', 'NMB - DSM - Bank House', 548000.00, 36945.00, 584945.00, 219662.54, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47618, '111003995', 'Mohamed Adam Mohamed', '40310010016', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 140700.00, 688700.00, 323368.32, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47619, '111005188', 'Neema Juma Said', '40310010455', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 163600.00, 711600.00, 351653.72, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47620, '111005345', 'Eunis Richard Nganasha', '40310011670', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 61350.00, 609350.00, 278712.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47621, '111005383', 'Paul Luhende Ntobi', '40310011418', 'NMB - Nelson Mandela-Kilimanja', 653000.00, 259100.00, 912100.00, 485274.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47622, '111005423', 'Raphael Emmanuel Ngassu', '40310010834', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 80700.00, 628700.00, 296157.47, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47623, '111005434', 'Saka Nhondo Masunga', '40310009985', 'NMB - Nelson Mandela-Kilimanja', 653000.00, 163250.00, 816250.00, 394225.35, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47624, '111005457', 'Rahimu Sephu Kabelwa', '40310011181', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 255600.00, 894600.00, 540260.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47625, '111005466', 'Ali Kassim Hassani', '40310010948', 'NMB - Nelson Mandela-Kilimanja', 942000.00, 411750.00, 1353750.00, 735999.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47626, '111005869', 'Jaccob Enico Ndalami', '40310010322', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 80700.00, 628700.00, 341602.25, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47627, '111006796', 'Alphonce Edmund Ngalawa', '40310010464', 'NMB - Nelson Mandela-Kilimanja', 653000.00, 265500.00, 918500.00, 483280.01, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47628, '111006875', 'Franco Evord Malimba', '40310010173', 'NMB - Nelson Mandela-Kilimanja', 992000.00, 222900.00, 1214900.00, 659741.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47629, '111006972', 'Juma Ramadhani Shengena', '40310012032', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 80700.00, 628700.00, 268861.65, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47630, '111007274', 'Anyesi Lames Petro', '40310009841', 'NMB - Nzega Tabora', 915000.00, 503250.00, 1418250.00, 948354.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47631, '111007473', 'Nyangi Kirigiti Peter', '40310011262', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 244500.00, 883500.00, 457549.14, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47632, '111007645', 'Ibrahim Yessaya Yeremia', '40310010646', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 255600.00, 894600.00, 474573.46, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47633, '111008033', 'Ally Bakari Thabiti', '40310010708', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 53550.00, 601550.00, 241616.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47634, '111395256', 'Abdalah Nassoro Mtawala', '40310021033', 'NMB - DSM - Bank House', 538000.00, 80700.00, 618700.00, 260222.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47635, '111395478', 'Eufrazia Joseph Sakala', '40310016676', 'NMB - DSM - Bank House', 538000.00, 70350.00, 608350.00, 328934.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47636, '111395543', 'Janneth Kennedy Mkumbo', '40310022086', 'NMB - DSM - Bank House', 538000.00, 140700.00, 678700.00, 340230.43, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47637, '111398255', 'Jamal Seif Ally', '40310020613', 'NMB - DSM - Bank House', 915000.00, 247050.00, 1162050.00, 552269.73, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47638, '111399444', 'Hamida Juma Vyasi', '40310017913', 'NMB - DSM - Bank House', 538000.00, 70350.00, 608350.00, 250000.39, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47639, '111399585', 'Michael Gerald Lusambo', '40310020797', 'NMB - DSM - Bank House', 538000.00, 80700.00, 618700.00, 537512.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47640, '111399793', 'Lusekelo George Mwashambwa', '40310020726', 'NMB - DSM - Bank House', 965000.00, 503250.00, 1468250.00, 833832.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47641, '111401994', 'Bariki Chambua Mbwambo', '40310017757', 'NMB - DSM - Bank House', 625000.00, 93750.00, 718750.00, 302270.65, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47642, '111402211', 'Mario Andrea Kalandala', '40310021357', 'NMB - DSM - Bank House', 639000.00, 93750.00, 732750.00, 312964.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47643, '111404764', 'Zihiran Kilangiro Mntambo', '40310021784', 'NMB - DSM - Bank House', 538000.00, 206200.00, 744200.00, 663012.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47644, '111406160', 'Umaru Siraji Ibrahim', '40310017717', 'NMB - DSM - Bank House', 942000.00, 395640.00, 1337640.00, 709835.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47645, '111406572', 'Gidion Masatu Kalombero', '40310017190', 'NMB - DSM - Bank House', 538000.00, 104000.00, 642000.00, 343332.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47646, '111406755', 'Aman Deoglas Sambu', '40310017209', 'NMB - DSM - Bank House', 538000.00, 53550.00, 591550.00, 332549.06, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47647, '111407594', 'Amos Robert Mgema', '40310017408', 'NMB - DSM - Bank House', 538000.00, 80700.00, 618700.00, 298139.84, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47648, '111407904', 'Hafidh Mussa Kassim', '40310020209', 'NMB - DSM - Bank House', 538000.00, 140700.00, 678700.00, 597512.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47649, '111407926', 'Thomas Kishiwa Magembe', '40310021411', 'NMB - DSM - Bank House', 915000.00, 274500.00, 1189500.00, 700479.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47650, '111411725', 'Rapahel Raphael Lupindu', '40310022050', 'NMB - DSM - Bank House', 639000.00, 53550.00, 692550.00, 273377.50, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47651, '111411935', 'Daniel Nwaka Mwambigija', '40310017688', 'NMB - DSM - Bank House', 538000.00, 53550.00, 591550.00, 260653.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47652, '111412034', 'Bahati Dotto Ndullu', '40310017054', 'NMB - DSM - Bank House', 942000.00, 415800.00, 1357800.00, 733089.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47653, '111412738', 'Doa Athumani Makoja', '40310021573', 'NMB - Nelson Mandela-Kilimanja', 992000.00, 297600.00, 1289600.00, 1091400.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47654, '111412777', 'Abraham Damian Kamwela', '40310021745', 'NMB - Nelson Mandela-Kilimanja', 992000.00, 525800.00, 1517800.00, 856538.58, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47655, '111412826', 'Anusiata Peter Kibena', '40310021636', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 134500.00, 672500.00, 314998.99, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47656, '111413010', 'Theodori Misana Masatu', '40310021884', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 52000.00, 590000.00, 291093.60, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47657, '111413540', 'Alphonce John Mwakamele', '40310020499', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 70350.00, 608350.00, 283412.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47658, '111784247', 'Isdory Cosmasi Hyera', '40310030928', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 70350.00, 608350.00, 249915.74, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47659, '111785422', 'Ramadhani Shabani Rashidi', '40310028661', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 140700.00, 678700.00, 597512.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47660, '111785540', 'Beticia Kanagana Emmanuel', '40310028680', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 80700.00, 618700.00, 299178.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47661, '111785706', 'Eric Thomas Urembo', '40310032039', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 140700.00, 678700.00, 320232.11, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47662, '111786041', 'Suleiyum Abdulla Abdulla', '40310032014', 'NMB - Nelson Mandela-Kilimanja', 965000.00, 523850.00, 1488850.00, 1258412.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47663, '111786198', 'Said Ismail Namiona', '40310029732', 'NMB - Nelson Mandela-Kilimanja', 625000.00, 187500.00, 812500.00, 400574.37, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47664, '111786277', 'Hafidh Ali Mohamed', '40310029968', 'NMB - Nelson Mandela-Kilimanja', 992000.00, 537500.00, 1529500.00, 911757.50, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47665, '111787626', 'Samira Prosper Rupya', '0152621757800', 'CRDB - Njombe,Iringa', 558000.00, 82200.00, 640200.00, 268292.94, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47666, '111787733', 'Khamis Moh\'D Haji', '40310029206', 'NMB - Nelson Mandela-Kilimanja', 625000.00, 140700.00, 765700.00, 654700.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47667, '111787776', 'Lomitu Mollel Sindiyo', '40310028742', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 0.00, 538000.00, 239332.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47668, '111788483', 'Miraji Omari Bakari', '40310030876', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 161400.00, 699400.00, 342098.43, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47669, '111789758', 'Godfrey Raymond Simiko', '40310029335', 'NMB - Nelson Mandela-Kilimanja', 558000.00, 83700.00, 641700.00, 270166.79, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47670, '111789783', 'Sibora Mwita Ryoba', '42910003388', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 187500.00, 826500.00, 475344.17, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47671, '111794465', 'Tasiana Eusebius Challe', '42910003454', 'NMB - Nelson Mandela-Kilimanja', 942000.00, 532800.00, 1474800.00, 845900.22, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47672, '111798258', 'Victor Ndinde Lameck', '40310028706', 'NMB - Nelson Mandela-Kilimanja', 558000.00, 138000.00, 696000.00, 324058.35, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47673, '111798781', 'Esther Ayoub Kachingwe', '40310030967', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 93750.00, 732750.00, 307117.21, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47674, '111801317', 'Baziru Mussa Shimbiri', '40310031200', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 80700.00, 618700.00, 517512.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47675, '111802047', 'Yusta Ambele Mwasakujonga', '40310031278', 'NMB - Nelson Mandela-Kilimanja', 992000.00, 266100.00, 1258100.00, 597358.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47676, '111802903', 'James William Amsi', '40310030037', 'NMB - Nelson Mandela-Kilimanja', 558000.00, 129000.00, 687000.00, 373666.26, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47677, '111805023', 'Dorine Nyakato Rweyemamu', '40310031386', 'NMB - Nelson Mandela-Kilimanja', 653000.00, 95850.00, 748850.00, 339289.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47678, '111815747', 'Maulid Ali Said', '40310028541', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 93750.00, 732750.00, 309256.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47679, '111831509', 'Lazack Ntangala Mponeja', '40310030326', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 70350.00, 608350.00, 250457.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47680, '111847622', 'Ibrahim Anthoni Hunja', '40310030652', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 215200.00, 753200.00, 394722.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47681, '112671043', 'Boazi Alamu Swila', '0152624914100', 'CRDB Kinondoni Municipal - Dar es Salaam', 469000.00, 70350.00, 539350.00, 227312.13, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47682, '112671050', 'Luckman Juma Chemba', '40310102266', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 296231.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47683, '112671914', 'Mohamed Ramadhan Athuman', '0152625010200', 'CRDB Ilala Municipal - Dar es Salaam', 548000.00, 82200.00, 630200.00, 542680.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47684, '112672128', 'Haji Dominic Andrew', '40310108361', 'NMB Mandela Moshi', 942000.00, 518100.00, 1460100.00, 1134975.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47685, '112672787', 'Amos Adam Dotto', '42210018153', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 227443.36, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47686, '112672834', 'Yawatu Dotto Hamisi', '40110027090', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 237481.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47687, '112673786', 'Juma Adam Maziku', '43510018130', 'NMB Mandela Moshi', 469000.00, 234500.00, 703500.00, 460256.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47688, '112674903', 'Joseph Habibu Odilo', '0152624936300', 'CRDB - Azikiwe', 469000.00, 187600.00, 656600.00, 349022.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47689, '112675222', 'Thomas Kulwa Chiba', '43010011653', 'NMB Mandela Moshi', 469000.00, 186700.00, 655700.00, 343572.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47690, '112675680', 'Yasini Daudi Makala', '0152624963000', 'CRDB Chanika - Dar es Salaam', 469000.00, 70350.00, 539350.00, 236647.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47691, '112675752', 'Amran Bakari Amran', '40310107440', 'NMB Mandela Moshi', 469000.00, 187600.00, 656600.00, 349043.50, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47692, '112676077', 'Adamu Hassani Ally', '0152624816800', 'CRDB - Azikiwe', 469000.00, 70350.00, 539350.00, 303106.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47693, '112676536', 'Bruno Silvesta Lipopa', '0152624767600', 'CRDB Mwanga - Kilimanjaro', 469000.00, 187600.00, 656600.00, 345772.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47694, '112676994', 'Akley Pius Kaduma', '40310108117', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 456856.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47695, '112678494', 'Rehema Michael Mpondo', '40310107043', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 226779.17, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47696, '112678670', 'Eliud Masera Simeo', '40310034889', 'NMB Mandela Moshi', 942000.00, 521550.00, 1463550.00, 835595.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47697, '112679322', 'Faraja Daudi Juma', '40310109773', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 228289.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47698, '112679551', 'Diana Kengozi Julius', '40310108317', 'NMB Mandela Moshi', 469000.00, 187600.00, 656600.00, 375641.15, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47699, '112680238', 'Mundhir Pandu Ally', '40310107862', 'NMB Mandela Moshi', 469000.00, 70350.00, 539350.00, 471856.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47700, '112680428', 'Jackson Lais Mollel', '43110005785', 'NMB Mandela Moshi', 548000.00, 217700.00, 765700.00, 405846.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47701, '112684023', 'Erick Etory Tinda', '40310109749', 'NMB Mandela Moshi', 469000.00, 140700.00, 609700.00, 537206.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47702, '112684101', 'Majaliwa Ng\'Ong\'Ho Sosthenes', '0152624882100', 'CRDB - Azikiwe', 469000.00, 173530.00, 642530.00, 372806.16, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47703, '112684796', 'Ernest Ambagali Haule', '0152624983300', 'CRDB - Azikiwe', 469000.00, 117250.00, 586250.00, 405529.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47704, '112685344', 'Baraka Zahoro Kadinda', '40310106819', 'NMB Mandela Moshi', 548000.00, 162900.00, 710900.00, 628380.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47705, '113142625', 'Tumaini Mswaki Elias', '40310126252', 'NMB Mandela Moshi', 915000.00, 366000.00, 1281000.00, 878839.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47706, '113143262', 'Lazaro Paul Mikuwa', '0152739782800', 'CRDB KCMC - Kilimanjaro', 460000.00, 0.00, 460000.00, 299791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47707, '113143563', 'Abubakar Makame Ussi', '40310126235', 'NMB Mandela Moshi', 460000.00, 138000.00, 598000.00, 437791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47708, '113144136', 'Ibrahim Haji Abdalla', '40310127149', 'NMB Mandela Moshi', 460000.00, 138000.00, 598000.00, 437791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47709, '113146134', 'Gabriel Christopher Carlos', '43510028360', 'NMB Mandela Moshi', 460000.00, 69000.00, 529000.00, 368791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47710, '113146227', 'Boke Samwel Mabawa', '40310129429', 'NMB - Nelson Mandela-Kilimanja', 460000.00, 69000.00, 529000.00, 338791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47711, '113147126', 'Fadhil Elia Mwamahonje', '40310129370', 'NMB Mandela Moshi', 460000.00, 138000.00, 598000.00, 422791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47712, '113149905', 'Harith Kilinge Mtonga', '40310128949', 'NMB Mandela Moshi', 460000.00, 69000.00, 529000.00, 368791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47713, '113149930', 'Dionis Julius Malocha', '61310049286', 'NMB-Mkata', 460000.00, 69000.00, 529000.00, 268691.79, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47714, '113149937', 'Hadija Suna Kipanzi', '40310126591', 'NMB Mandela Moshi', 460000.00, 69000.00, 529000.00, 368791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47715, '113117131', 'Adamu Hamad Faki', '0152753968300', 'CRDB KCMC - Kilimanjaro', 460000.00, 138000.00, 598000.00, 437791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47716, '9187173', 'Mohamed Abdulla Mohammed', '2298000914', 'NMB - Zanzibar', 639000.00, 40545.00, 679545.00, 254049.77, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47717, '9324448', 'Iluminata Damian Gowela', '0152242565400', 'CRDB - Iringa', 1070000.00, 205875.00, 1275875.00, 900995.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47718, '9325560', 'Lucas Lingston Mwamkinga', '3268000022', 'NMB - Misenyi,Karagwe', 548000.00, 82200.00, 630200.00, 292867.50, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47719, '9327232', 'Patrick Andrew Sangito', '01J2065861100', 'CRDB - Mbeya', 1259000.00, 692450.00, 1951450.00, 924390.44, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47720, '9327380', 'Masoud Kwilekaa Omari', '2038001097', 'NMB - DSM - Ilala Br', 2064000.00, 501500.00, 2565500.00, 1189736.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47721, '9327450', 'Richard Kandilo Mahinya', '6068000332', 'NMB - Njombe,Iringa', 639000.00, 202650.00, 841650.00, 415978.16, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47722, '9327531', 'Hassani Ismail Lujendo', '7082402477', 'NMB - Newala,Mtwara', 1070000.00, 588500.00, 1658500.00, 1327050.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47723, '9327634', 'Philipina Robert Mkumbo', '2068000491', 'NMB - DSM - Morogoro Rd', 1299000.00, 383700.00, 1682700.00, 824785.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47724, '9328387', 'Thadeo Casmir Ntabindi', '2012401671', 'NMB - DSM - Bank House', 1549000.00, 619600.00, 2168600.00, 1221021.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47725, '9328538', 'Khatib Ali Abdi', '4078000372', 'NMB - Babati,Manyara', 625000.00, 236950.00, 861950.00, 445769.47, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47726, '9328871', 'Wisdom Ephraim Mwanyosi', '2068000489', 'NMB - DSM - Morogoro Rd', 1070000.00, 579500.00, 1649500.00, 946820.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47727, '9329535', 'Marwa Kichere Kisyeri', '6068000333', 'NMB - Njombe,Iringa', 992000.00, 289500.00, 1281500.00, 1063300.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47728, '9329649', 'Osmund Masulu Mwamsabe', '7032500262', 'NMB - Kibaha,Coast', 639000.00, 93750.00, 732750.00, 306749.51, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47729, '9329650', 'Michael Richard Mwaipaja', '010-00162233', 'TPB - Mbeya', 1948000.00, 748500.00, 2696500.00, 1417464.41, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47730, '9330072', 'Halamela Gabriel Sibula', '3128000217', 'NMB - Magu Mwanza', 1597000.00, 394450.00, 1991450.00, 942955.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47731, '9333028', 'Omari Mzuza Diwani', '5142503700', 'NMB - Kasulu Kigoma', 1948000.00, 564945.00, 2512945.00, 1233719.17, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47732, '9333936', 'Kyangwe Mashanga Changarawe', '5092401319', 'NMB - Igunga Tabora', 1070000.00, 428000.00, 1498000.00, 821887.76, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47733, '9333981', 'Lucas Mgunji Komba', '51010004133', 'NMB - DSM - Bank House', 639000.00, 0.00, 639000.00, 223373.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47734, '9335701', 'Martinus Gabriel Mirumbe', '7062401465', 'NMB - Mtwara', 1259000.00, 244125.00, 1503125.00, 1218360.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47735, '9337130', 'Hamisi Adam Malongo', '61810002050', 'NMB - Songea', 1597000.00, 465100.00, 2062100.00, 1269105.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47736, '9337211', 'Justin Benedict Kamfulumbwe', '6052405218', 'NMB - Mkwawa,Iringa', 1597000.00, 92445.00, 1689445.00, 642804.17, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47737, '9435575', 'Jenipher Rashid Mahanyu', '6012400708', 'NMB - Ludewa - Iringa', 548000.00, 40545.00, 588545.00, 223412.50, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47738, '9441659', 'Raphael Fanuel Minde', '6172500916', 'NMB - Mbinga Ruvuma', 1339000.00, 194850.00, 1533850.00, 644597.50, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47739, '9442324', 'Selemani Gerson Manyaka', '6101605739', 'NMB - Mbalizi Rd,Mbeya', 1597000.00, 464700.00, 2061700.00, 1014670.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47740, '11441447', 'Bernad John Antrio', '6041601328', 'NMB - Makete,Iringa', 992000.00, 258000.00, 1250000.00, 441624.16, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47741, '11442189', 'Peter Lawrence Ng\'Umbi', '6061603283', 'NMB - Njombe,Iringa', 548000.00, 82200.00, 630200.00, 264971.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47742, '11443681', 'Eva Filberth Mgaya', '6011600623', 'NMB - Ludewa - Iringa', 487000.00, 73050.00, 560050.00, 240969.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47743, '11443692', 'Anastella Ananias Justinian', '6068001062', 'NMB - Njombe,Iringa', 548000.00, 82200.00, 630200.00, 331013.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47744, '11443809', 'Emmanuel Hosea Mwakipesile', '3078002017', 'NMB - DSM - Bank House', 548000.00, 82200.00, 630200.00, 265769.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47745, '11786320', 'Nicholous Mosses Mbuta', '3048001476', 'NMB - Tarime Mara', 538000.00, 143400.00, 681400.00, 355107.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47746, '11786869', 'Nalingigwa Jeremiah Obed', '4231604489', 'NMB - Mkwakwani,Tanga', 639000.00, 235000.00, 874000.00, 449119.51, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47747, '11786962', 'Andrew Sangwa Ndutu', '2028001707', 'NMB-Chakechake', 548000.00, 82200.00, 630200.00, 264925.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47748, '11789572', 'Ayubu Alisile Ngondo', '2298000147', 'NMB - Zanzibar', 639000.00, 187500.00, 826500.00, 401140.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47749, '11789745', 'Aidano Paulo Mlangwa', '5131606108', 'NMB - Urambo Tabora', 548000.00, 82200.00, 630200.00, 265273.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47750, '11791511', 'Emmanuel Kessy Kasembe', '2028001892', 'NMB-Chakechake', 548000.00, 162900.00, 710900.00, 345708.56, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47751, '11794855', 'Saidi Dotto Ramadhani', '6018000209', 'NMB - Ludewa - Iringa', 942000.00, 274500.00, 1216500.00, 655392.50, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47752, '11794903', 'Cyprian David Bahemana', '6068000707', 'NMB - Njombe,Iringa', 548000.00, 82200.00, 630200.00, 266336.94, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47753, '11794914', 'Daniel Paul Kamwamu', '5168000627', 'NMB - DSM - Bank House', 639000.00, 93750.00, 732750.00, 307792.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47754, '11800884', 'Hawa Athumani Rashidi', '6068000706', 'NMB - Njombe,Iringa', 992000.00, 266250.00, 1258250.00, 469250.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47755, '11800909', 'Upendo Simon Mwaibanda', '6068001064', 'NMB - Njombe,Iringa', 548000.00, 219200.00, 767200.00, 402127.50, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47756, '11801009', 'Zenice Mbishi Nobert', '6041601106', 'NMB - Makete,Iringa', 548000.00, 82200.00, 630200.00, 272825.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47757, '11801489', 'Juma Abdallah Kaniki', '6048000391', 'NMB - Makete,Iringa', 942000.00, 514050.00, 1456050.00, 828278.12, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47758, '11801504', 'Khalid Ali Mnyani', '6068001030', 'NMB - Njombe,Iringa', 548000.00, 0.00, 548000.00, 188146.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47759, '11803977', 'Bryson Alphonce Ngoho', '3058000921', 'NMB - Bariadi,Shinyanga', 965000.00, 530750.00, 1495750.00, 852495.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47760, '11805797', 'Benedicto Mugabuzi Alphonce', '6041601330', 'NMB - Makete,Iringa', 548000.00, 82200.00, 630200.00, 272846.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47761, '11805801', 'Angelo Ernest Marco', '6018000188', 'NMB - Ludewa - Iringa', 639000.00, 230350.00, 869350.00, 764990.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47762, '11806037', 'Rashidi Ally Mlonga', '6018000205', 'NMB - Ludewa - Iringa', 548000.00, 0.00, 548000.00, 268084.25, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47763, '11806093', 'Samweli Mganga Augustino', '6068000698', 'NMB - Njombe,Iringa', 965000.00, 266250.00, 1231250.00, 1040812.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47764, '12202661', 'Lucas Emanuel Chanya', '6018000322', 'NMB - Ludewa - Iringa', 639000.00, 255600.00, 894600.00, 490551.73, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47765, '12203454', 'Marato Chacha Nyantuman', '6018000327', 'NMB - Ludewa - Iringa', 639000.00, 228700.00, 867700.00, 447843.93, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47766, '12205476', 'Msengi James Msengi', '6041601671', 'NMB - Mahenge Morogoro', 548000.00, 80700.00, 628700.00, 263770.46, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47767, '12206306', 'Mwinula Doto Patrick', '6018000320', 'NMB - Ludewa - Iringa', 478000.00, 160900.00, 638900.00, 350761.71, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47768, '12206605', 'Nassoro Mussa Omary', '6068001055', 'NMB - Njombe,Iringa', 992000.00, 266250.00, 1258250.00, 448542.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47769, '12207889', 'Oscar Protas Maunga', '4038001270', 'NMB - Nelson Mandela-Kilimanja', 915000.00, 434250.00, 1349250.00, 897354.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47770, '12209546', 'Raphael Modestus Kiwuyo', '60608001045', 'NMB - Njombe,Iringa', 992000.00, 266250.00, 1258250.00, 597055.07, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47771, '12211742', 'Savio Osward Ngonyani', '2308000494', 'NMB - Airport Dsm', 992000.00, 411000.00, 1403000.00, 632958.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47772, '12213144', 'Suleiman Thabiti Abdallah', '6021605414', 'NMB - Mtwara', 915000.00, 503250.00, 1418250.00, 808250.03, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47773, '12213856', 'Tobias Theophames Haule', '0152349704000', 'CRDB - Njombe,Iringa', 548000.00, 182950.00, 730950.00, 365675.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47774, '12214971', 'William Mateo Mpinda', '6068001050', 'NMB - Njombe,Iringa', 942000.00, 503250.00, 1445250.00, 817894.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47775, '12217568', 'Camila Melkiory Kimaro', '4038001803', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 80700.00, 628700.00, 536180.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47776, '12219498', 'Godfather Jairo Johanness', '6018000318', 'NMB - Ludewa - Iringa', 548000.00, 80700.00, 628700.00, 264553.96, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47777, '12220029', 'Helman Langson Simtengu', '6048000481', 'NMB - Makete,Iringa', 548000.00, 80700.00, 628700.00, 268827.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47778, '12220410', 'Jackson Marco Heke', '6038000285', 'NMB - Makambako,Iringa', 548000.00, 80700.00, 628700.00, 263508.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47779, '12223708', 'Ramadhan Daudi Juma', '6048000476', 'NMB - Makete,Iringa', 548000.00, 80700.00, 628700.00, 330513.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47780, '12224269', 'Sabina Anderson Mzilo', '6018000334', 'NMB - DSM - Samora Br', 639000.00, 235000.00, 874000.00, 448051.65, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47781, '12224454', 'Salma Awadh Killo', '6018000321', 'NMB - Ludewa - Iringa', 548000.00, 0.00, 548000.00, 182896.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47782, '12224937', 'Sihova Paschal Mwano', '6068001065', 'NMB - Njombe,Iringa', 548000.00, 80700.00, 628700.00, 349545.57, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47783, '12225797', 'William Soloko Sijaona', '7081600272', 'NMB - Newala,Mtwara', 548000.00, 274000.00, 822000.00, 456896.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47784, '110660404', 'Thadeo Dismas Thampudi', '32201603130', 'NMB - Kilombero - Morogoro', 548000.00, 80700.00, 628700.00, 263367.50, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47785, '110660465', 'Adolf Maiko Ndelwa', '40310003924', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 251400.00, 890400.00, 486227.50, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47786, '110660845', 'Godfrey Ramford Urio', '40310003694', 'NMB - Mawenzi Moshi', 625000.00, 80700.00, 705700.00, 322116.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47787, '110661253', 'Flowin Dominikus Nyoni', '40310003904', 'NMB - Mawenzi Moshi', 965000.00, 278550.00, 1243550.00, 609132.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47788, '111028135', 'Vaileth Okoth Raya', '40310012443', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 80700.00, 628700.00, 263478.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47789, '111028206', 'Dativa John Willium', '40310011439', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 0.00, 548000.00, 183652.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47790, '111028315', 'Debora Ulindula Mwaipwisi', '40310012053', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 204850.00, 843850.00, 489510.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47791, '111028655', 'Mathayo Roderick Haule', '6061602569', 'NMB - Nelson Mandela-Kilimanja', 1100000.00, 544500.00, 1644500.00, 912145.84, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47792, '111028760', 'Anastazia Tabu Mayenze', '40310009532', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 70250.00, 618250.00, 495730.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47793, '111028883', 'Rahim Ollen Ntemwa', '40310011894', 'NMB - Nelson Mandela-Kilimanja', 478000.00, 71700.00, 549700.00, 231172.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47794, '111029356', 'Juma Ali Juma', '40310011281', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 70350.00, 618350.00, 253292.15, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47795, '111029386', 'Helieth Evarist Kakusa', '40310010781', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 70350.00, 618350.00, 253456.15, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47796, '111029451', 'Shabani Digalu Jumanne', '40310012378', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 164400.00, 712400.00, 399880.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47797, '111031051', 'Tusekile Philip Mwakenja', '40310012024', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 80700.00, 628700.00, 268701.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47798, '111031502', 'Paul Matuko Wambura', '40310010084', 'NMB - Nelson Mandela-Kilimanja', 653000.00, 95850.00, 748850.00, 340100.63, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47799, '111031725', 'Edwin Joseph Mtuka', '40310012217', 'NMB - Nelson Mandela-Kilimanja', 667000.00, 200100.00, 867100.00, 424789.92, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47800, '111033056', 'Mussa Christopher Mkwai', '40310011557', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 70350.00, 618350.00, 254703.25, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47801, '111033927', 'Mwanaisha Said Hamisi', '0152621753800', 'CRDB - Njombe,Iringa', 548000.00, 219200.00, 767200.00, 403750.23, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47802, '111041073', 'Method Marandu Donath', '40310011792', 'NMB - Nelson Mandela-Kilimanja', 653000.00, 261200.00, 914200.00, 538770.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47803, '111042135', 'Abdulkarim Mohd Shaali', '40310011940', 'NMB - DSM - Bank House', 568000.00, 85200.00, 653200.00, 283421.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47804, '111042197', 'Yona Mabe Sulle', '40310011447', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 131700.00, 679700.00, 314617.95, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47805, '111042301', 'William Thomas Njohole', '40310012562', 'NMB - Nelson Mandela-Kilimanja', 965000.00, 251300.00, 1216300.00, 592711.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47806, '111042950', 'Khamis Hija Juma', '40310010947', 'NMB - DSM - Bank House', 992000.00, 258000.00, 1250000.00, 589382.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17');
INSERT INTO `payrolls` (`id`, `check_number`, `full_name`, `account_number`, `bank_name`, `basic_salary`, `allowance`, `gross_amount`, `net_amount`, `created_at`, `updated_at`) VALUES
(47807, '111045205', 'Lilian Daud Mwangaba', '40310011910', 'NMB - Nelson Mandela-Kilimanja', 938000.00, 266250.00, 1204250.00, 587717.50, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47808, '111045315', 'Jackline Kajula Johan', '40310009361', 'NMB - Nelson Mandela-Kilimanja', 548000.00, 194500.00, 742500.00, 410023.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47809, '111045836', 'Peter Oscar Luseeko', '40310010520', 'NMB - DSM - Bank House', 548000.00, 138745.00, 686745.00, 327725.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47810, '111045845', 'Tusajigwe Jacob Mwaipwisi', '40310010070', 'NMB - DSM - Bank House', 548000.00, 70350.00, 618350.00, 332603.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47811, '111770451', 'Lazaro Laurent Massay', '40310027138', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 187500.00, 826500.00, 709125.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47812, '111770615', 'Sarah Daniel Nyanda', '40310031198', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 191200.00, 729200.00, 440282.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47813, '111770870', 'Omary Howard Ng\'Umbi', '40310029979', 'NMB - Nelson Mandela-Kilimanja', 992000.00, 258000.00, 1250000.00, 588998.48, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47814, '111771181', 'Deogratius Khamis Zacharia', '40310030954', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 191700.00, 830700.00, 448769.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47815, '111771228', 'Rebecca Ayoub James', '40310031727', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 93750.00, 732750.00, 628390.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47816, '111771423', 'Mohamed Said Gambo', '40310031690', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 131700.00, 669700.00, 314530.73, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47817, '111771466', 'Mganga Misango Majani', '40310028975', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 143400.00, 681400.00, 389541.32, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47818, '111771568', 'Raheli Timotheo Marco', '40310032488', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 70350.00, 608350.00, 290495.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47819, '111771712', 'Timtim Mohamedi Timtim', '40310028995', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 143400.00, 681400.00, 355233.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47820, '111772069', 'Nassor Amour Salum', '40310029111', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 161400.00, 699400.00, 613212.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47821, '111772236', 'Imikigwe Mose Kalinga', '40310026428', 'NMB - Nelson Mandela-Kilimanja', 558000.00, 82200.00, 640200.00, 268246.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47822, '111772671', 'Donald Malangwa Moses', '40310031166', 'NMB - DSM - Bank House', 992000.00, 519050.00, 1511050.00, 849720.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47823, '111772725', 'Subby Chiluma Daud', '40310031157', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 80700.00, 618700.00, 260076.29, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47824, '111773022', 'Advela Nyansimbo Stephano', '40310031388', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 61350.00, 599350.00, 518162.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47825, '111773029', 'Jacquiline Julius Mwanga', '40310030554', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 80700.00, 618700.00, 261120.21, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47826, '111773061', 'Jeremiah Charles Mwasapili', '40310029586', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 140700.00, 678700.00, 597512.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47827, '111773156', 'Emanuel Charles Mtengwa', '40310028666', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 140700.00, 678700.00, 320033.66, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47828, '111773355', 'Baraka Fulgence Tinkamanyile', '40310031769', 'NMB - Nelson Mandela-Kilimanja', 965000.00, 266100.00, 1231100.00, 613561.35, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47829, '111773638', 'Barnaba Gwentino Mgumba', '40310028841', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 122700.00, 660700.00, 302165.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47830, '111773670', 'Simon Sylivester Mazuri', '40310031422', 'NMB - Nelson Mandela-Kilimanja', 992000.00, 293550.00, 1285550.00, 833512.40, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47831, '111774282', 'Safina Bathlomeo Mangula', '40310029086', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 70350.00, 608350.00, 507162.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47832, '111775566', 'Jackson Ally Chande', '40310029110', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 255600.00, 894600.00, 573710.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47833, '111775756', 'Khalid Jumanne Mkuki', '40310029763', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 215200.00, 753200.00, 672012.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47834, '111890377', 'Misoji Zabron James', '40310038674', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 191200.00, 729200.00, 372560.08, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47835, '111890567', 'Moshi Isack Mdamo', '40310038677', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 187500.00, 826500.00, 400660.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47836, '111891235', 'Said Msinji Hassan', '40310041346', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 278803.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47837, '111891749', 'Nyanzobe Maduka Kabisu', '40310039518', 'NMB - Nelson Mandela-Kilimanja', 478000.00, 61350.00, 539350.00, 225763.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47838, '111892053', 'Loth Richard Andrew', '40310039178', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 61350.00, 599350.00, 263973.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47839, '111892630', 'Haji Athuman Pasinje', '40310040559', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 283678.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47840, '111892685', 'Selemani Abtwalibu Mrutu', '40310041570', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 508512.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47841, '111892787', 'Mwajuma Abas Mahamudu', '40310040525', 'NMB - Nelson Mandela-Kilimanja', 639000.00, 191700.00, 830700.00, 519465.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47842, '111893455', 'Magdalena Albert Urio', '40310041120', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 288854.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47843, '111893523', 'Joyce Henry Benjamini', '40310037120', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 161400.00, 699400.00, 613212.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47844, '111893724', 'Eonike Daniel Ruzilo', '40310042526', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 287741.17, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47845, '111894391', 'Uweza Amoni Lukala', '40310040008', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 288663.17, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47846, '111894644', 'Ibrahim Madaraka Mhangwa', '40310038167', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 279345.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47847, '111895175', 'Belina Beda Natujuna', '40310036939', 'NMB - Nelson Mandela-Kilimanja', 478000.00, 143400.00, 621400.00, 547772.00, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47848, '111895272', 'Said Abdallah Ndogaji', '40310039064', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 145260.00, 683260.00, 324826.87, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47849, '111905395', 'Rashid Salum Bhao', '40310040703', 'NMB - Nelson Mandela-Kilimanja', 625000.00, 191200.00, 816200.00, 502098.80, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47850, '111905583', 'Baraka Petro Richard', '40310040462', 'NMB - Nelson Mandela-Kilimanja', 558000.00, 221700.00, 779700.00, 474943.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47851, '111905813', 'Edward Bonifance Gwandu', '40310038201', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 278424.83, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47852, '111906246', 'Innocent Selestin Temu', '40310037891', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 71700.00, 609700.00, 251220.14, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47853, '111906276', 'Noel Mayunga Charles', '40310040136', 'NMB - DSM - Bank House', 538000.00, 191200.00, 729200.00, 371154.70, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47854, '111906515', 'Swadakati Salimu Saidi', '40310037858', 'NMB - Nelson Mandela-Kilimanja', 538000.00, 206200.00, 744200.00, 448818.02, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47855, '111906649', 'Ibrahim Ali Faki', '40310041566', 'NMB - Nelson Mandela-Kilimanja', 478000.00, 71700.00, 549700.00, 231238.67, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47856, '111906713', 'Julius Bochoke Saroti', '40310041171', 'NMB - Nelson Mandela-Kilimanja', 558000.00, 83700.00, 641700.00, 275013.33, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47857, '113119193', 'Edwin William Mangula', '40310129411', 'NMB Mandela Moshi', 460000.00, 138000.00, 598000.00, 417791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47858, '113119738', 'Samwel Samwel Mkoma', '0152739812400', 'CRDB Mwanga - Kilimanjaro', 460000.00, 138000.00, 598000.00, 417791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47859, '113120214', 'Abdul-Qadir Abdulla Hamad', '43510028062', 'NMB Mandela Moshi', 915000.00, 274500.00, 1189500.00, 904589.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47860, '113120758', 'Baraka Gervas Kisovu', '0152739830200', 'CRDB KCMC - Kilimanjaro', 460000.00, 138000.00, 598000.00, 417791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47861, '113121474', 'Saphinael Gerison Mndeme', '40310127037', 'NMB Mandela Moshi', 915000.00, 503250.00, 1418250.00, 1016089.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47862, '113123938', 'Ngolo Ntula Merick', '017159000435', 'NBC Moshi-Mandela', 460000.00, 0.00, 460000.00, 299791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47863, '113124066', 'Joseph Basil Lymo', '40310128790', 'NMB - Nelson Mandela-Kilimanja', 460000.00, 138000.00, 598000.00, 422791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47864, '113125502', 'Enock Charles Baraka', '43510026647', 'NMB Mandela Moshi', 460000.00, 69000.00, 529000.00, 368791.20, '2024-10-17 15:06:17', '2024-10-17 15:06:17'),
(47865, '113125714', 'Crinton Ezekiel Ng\'Umbi', '0152753917400', 'CRDB KCMC - Kilimanjaro', 538000.00, 215200.00, 753200.00, 583163.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47866, '113126297', 'Bakari Mauridi Juma', '40310127781', 'NMB Mandela Moshi', 460000.00, 138000.00, 598000.00, 437791.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47867, '113127303', 'Alfred Emmanuel Chiwinga', '40310129372', 'NMB Mandela Moshi', 460000.00, 69000.00, 529000.00, 348791.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47868, '113127547', 'Adinani Bashiru Buchwa', '43510026795', 'NMB Mandela Moshi', 460000.00, 138000.00, 598000.00, 291421.00, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47869, '113128754', 'Ibrahim Adam Kombo', '0152739776400', 'CRDB - Moshi', 460000.00, 69000.00, 529000.00, 348791.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47870, '113129767', 'Ramadhan Juma Khamis', '43510026558', 'NMB Mandela Moshi', 460000.00, 0.00, 460000.00, 205739.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47871, '113129846', 'Rashidi Khamis Juma', '0152739827700', 'CRDB J. N. Hydropower (Kisaki) - Pwani', 460000.00, 138000.00, 598000.00, 417791.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47872, '113129911', 'Mussa Bakar Suleiman', '40310129116', 'NMB - Zanzibar', 460000.00, 138000.00, 598000.00, 417791.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47873, '113129982', 'Christina Joel Hogo', '0152707598700', 'CRDB - Moshi', 460000.00, 69000.00, 529000.00, 348791.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47874, '113130074', 'Lilian Nicodem Mwasalemba', '43510027917', 'NMB Mandela Moshi', 460000.00, 69000.00, 529000.00, 368791.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47875, '113130282', 'Agnes Jonas Benard', '40310128701', 'NMB Mandela Moshi', 460000.00, 69000.00, 529000.00, 348791.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47876, '113130361', 'Abdallah Mangole Mkessa', '43510027901', 'NMB Mandela Moshi', 460000.00, 69000.00, 529000.00, 358792.00, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47877, '113130676', 'Mussa Bakar Mussa', '40310128680', 'NMB Mandela Moshi', 460000.00, 138000.00, 598000.00, 437791.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47878, '113130716', 'Martin Eliudi Lukwaro', '43510027814', 'NMB Mandela Moshi', 460000.00, 184000.00, 644000.00, 483791.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47879, '113130787', 'Costantino Francisco Nyagawa', '0152739829700', 'CRDB KCMC - Kilimanjaro', 460000.00, 138000.00, 598000.00, 437791.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47880, '113131210', 'Baraka Elias Mkumbo', '40310127703', 'NMB Mandela Moshi', 460000.00, 69000.00, 529000.00, 358791.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47881, '113131464', 'Gomisi Selemani Mantawela', '43510027976', 'NMB - Nelson Mandela-Kilimanja', 460000.00, 138000.00, 598000.00, 437791.20, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47882, '8184289', 'Jamal Himid Hassan', '2298001509', 'NMB - Zanzibar', 639000.00, 0.00, 639000.00, 293383.06, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47883, '8192127', 'Sophia Conrad Ninje', '2238000709', 'NMB - DSM - Bank House', 766000.00, 0.00, 766000.00, 511160.00, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47884, '8516794', 'Zainab Linus John', '60310000975', 'NMB - DSM - Bank House', 745000.00, 111750.00, 856750.00, 469950.00, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47885, '8518639', 'Linus John Mlega', '6058000936', 'NMB - Mkwawa,Iringa', 766000.00, 111750.00, 877750.00, 593250.00, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47886, '8675280', 'Muhidini Mussa Mwadini', '2298001455', 'NMB - Zanzibar', 639000.00, 126450.00, 765450.00, 691090.00, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47887, '8675796', 'Hassan Mussa Fumu', '2298002555', 'NMB - Zanzibar', 639000.00, 255600.00, 894600.00, 790240.00, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47888, '8717432', 'Andrew Pius Andrew', '6051607426', 'NMB - Mkwawa,Iringa', 745000.00, 111750.00, 856750.00, 485241.35, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47889, '8720386', 'Alphonce Wiliam Kalinga', '6068000337', 'NMB - Njombe,Iringa', 766000.00, 256150.00, 1022150.00, 617310.00, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47890, '8764931', 'Annastazia Joseph Msengi', '055201061581', 'NBC D\'Salaam-Bank House', 639000.00, 255600.00, 894600.00, 717337.65, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47891, '8784586', 'Abubakar Hussein Kunga', '5028000318', 'NMB - Kondoa Dodoma', 2465000.00, 399270.00, 2864270.00, 2105495.00, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47892, '8785918', 'Rahel Simoni Simoni', '6062402047', 'NMB - Njombe,Iringa', 766000.00, 47880.00, 813880.00, 303308.00, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47893, '8811879', 'Prosper Method Komba', '2192401750', 'NMB - Mahenge Morogoro', 1259000.00, 156000.00, 1415000.00, 707623.17, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47894, '8815958', 'Ali Mzee Ame', '22910003397', 'NMB - DSM - Bank House', 639000.00, 253500.00, 892500.00, 466820.56, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47895, '8824789', 'Amasha Simbani Mwikola', '6048000163', 'NMB - Makete,Iringa', 639000.00, 40545.00, 679545.00, 575185.00, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47896, '8828835', 'Abdalla Omar Issa', '2298002490', 'NMB - Zanzibar', 639000.00, 157650.00, 796650.00, 722290.00, '2024-10-17 15:06:18', '2024-10-17 15:06:18'),
(47897, '8829108', 'Jafar Juma Mmanga', '2298002631', 'NMB - Zanzibar', 639000.00, 95850.00, 734850.00, 530490.00, '2024-10-17 15:06:18', '2024-10-17 15:06:18');

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'add.user', 'web', '2024-09-19 13:34:09', '2024-09-19 13:34:09'),
(2, 'loan.process', 'web', '2024-09-20 02:25:00', '2024-09-20 02:25:00'),
(3, 'paying', 'web', '2024-09-20 02:25:15', '2024-09-20 02:25:15'),
(4, 'loan.approval', 'web', '2024-09-20 02:25:33', '2024-09-20 02:25:33'),
(5, 'enquiry.register', 'web', '2024-09-20 02:26:25', '2024-09-20 02:26:25'),
(6, 'review.loan', 'web', '2024-09-23 06:59:34', '2024-09-23 06:59:34'),
(7, 'processloan', 'web', '2024-09-23 07:00:03', '2024-09-23 07:00:03');

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

--
-- Table structure for table `posts`
--

CREATE TABLE `posts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `image_path` varchar(255) NOT NULL,
  `caption` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `posts`
--

INSERT INTO `posts` (`id`, `image_path`, `caption`, `description`, `created_at`, `updated_at`) VALUES
(2, 'slides/1728468367-Screenshot 2023-04-18 134154.png', 'misaada', 'asdsafdffd', '2024-10-09 07:06:07', '2024-10-09 07:06:07'),
(3, 'slides/1728468713-wallpaper.png', 'misaada', 'fdsgfhfgjtydjytjytty', '2024-10-09 07:11:53', '2024-10-09 07:11:53');

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

--
-- Table structure for table `ranks`
--

CREATE TABLE `ranks` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ranks`
--

INSERT INTO `ranks` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'PC', '2024-11-25 02:57:16', '2024-11-25 02:57:16'),
(2, 'CPL', '2024-11-25 02:58:21', '2024-11-25 02:58:21'),
(3, 'SGT', '2024-11-25 02:58:31', '2024-11-25 02:58:31'),
(5, 'S/SGT', '2024-11-25 03:04:47', '2024-11-25 03:13:12'),
(11, 'SM', '2024-11-25 03:26:49', '2024-11-25 03:26:49'),
(14, 'A/INSP', '2024-11-25 03:32:13', '2024-11-25 03:32:13'),
(15, 'INSP', '2024-11-25 03:32:22', '2024-11-25 03:32:22'),
(16, 'ASP', '2024-11-25 03:32:31', '2024-11-25 03:32:31'),
(17, 'SP', '2024-11-25 03:32:40', '2024-11-25 03:32:40'),
(18, 'SSP', '2024-11-25 03:32:47', '2024-11-25 03:32:47'),
(19, 'ACP', '2024-11-25 03:32:54', '2024-11-25 03:32:54');

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

--
-- Table structure for table `refunds`
--

CREATE TABLE `refunds` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `refund_amount` decimal(10,2) NOT NULL,
  `refund_duration` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `enquirable_id` bigint(20) UNSIGNED DEFAULT NULL,
  `enquirable_type` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `refunds`
--

INSERT INTO `refunds` (`id`, `refund_amount`, `refund_duration`, `created_at`, `updated_at`, `enquirable_id`, `enquirable_type`) VALUES
(1, 50000.00, 10, '2024-10-27 09:30:04', '2024-10-27 09:30:04', NULL, NULL),
(2, 50000.00, 10, '2024-10-27 09:34:56', '2024-10-27 09:34:56', NULL, NULL),
(3, 50000.00, 10, '2024-10-27 09:42:33', '2024-10-27 09:42:33', NULL, NULL),
(4, 60000.00, 5, '2024-10-27 09:43:35', '2024-10-27 09:43:35', NULL, NULL),
(5, 60000.00, 5, '2024-10-27 09:45:30', '2024-10-27 09:45:30', NULL, NULL),
(6, 70000.00, 5, '2024-10-27 09:47:10', '2024-10-27 09:47:10', NULL, NULL),
(7, 70000.00, 5, '2024-10-27 09:49:22', '2024-10-27 09:49:22', NULL, NULL),
(8, 400000.00, 7, '2024-10-28 17:41:53', '2024-10-28 17:41:53', NULL, NULL),
(9, 1000000.00, 8, '2024-10-29 17:29:22', '2024-10-29 17:29:22', NULL, NULL),
(10, 250000.00, 8, '2024-10-29 17:33:35', '2024-10-29 17:33:35', NULL, NULL),
(11, 300000.00, 9, '2024-10-29 18:18:06', '2024-10-29 18:18:06', NULL, NULL),
(12, 330000.00, 36, '2024-10-29 19:01:47', '2024-10-29 19:01:47', NULL, NULL),
(13, 100000.00, 7, '2024-11-03 15:42:21', '2024-11-03 15:42:21', NULL, NULL),
(14, 500000.00, 60000, '2024-11-04 01:41:57', '2024-11-04 01:41:57', NULL, NULL),
(15, 10000.00, 2, '2024-11-08 04:54:10', '2024-11-08 04:54:10', NULL, NULL),
(16, 2000.00, 0, '2024-11-08 05:01:23', '2024-11-08 05:01:23', NULL, NULL),
(17, 12222.00, 2, '2024-11-09 04:08:31', '2024-11-09 04:08:31', NULL, NULL),
(18, 10000.00, 2, '2024-11-12 01:41:40', '2024-11-12 01:41:40', NULL, NULL),
(19, 3333.00, 3, '2024-12-02 03:23:58', '2024-12-02 03:23:58', NULL, NULL),
(20, 2.00, 2, '2024-12-11 06:45:03', '2024-12-11 06:45:03', NULL, NULL);

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

--
-- Table structure for table `regions`
--

CREATE TABLE `regions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` (`id`, `name`, `created_at`, `updated_at`) VALUES
(1, 'Arusha', NULL, NULL),
(2, 'Dar es Salaam', NULL, NULL),
(3, 'Dodoma', NULL, NULL),
(4, 'Geita', NULL, NULL),
(5, 'Iringa', NULL, NULL),
(6, 'Kagera', NULL, NULL),
(7, 'Katavi', NULL, NULL),
(8, 'Kigoma', NULL, NULL),
(9, 'Kilimanjaro', NULL, NULL),
(10, 'Lindi', NULL, NULL),
(11, 'Manyara', NULL, NULL),
(12, 'Mara', NULL, NULL),
(13, 'Mbeya', NULL, NULL),
(14, 'Morogoro', NULL, NULL),
(15, 'Mtwara', NULL, NULL),
(16, 'Mwanza', NULL, NULL),
(17, 'Njombe', NULL, NULL),
(18, 'Pwani', NULL, NULL),
(19, 'Rukwa', NULL, NULL),
(20, 'Ruvuma', NULL, NULL),
(21, 'Shinyanga', NULL, NULL),
(22, 'Simiyu', NULL, NULL),
(23, 'Singida', NULL, NULL),
(24, 'Songwe', NULL, NULL),
(25, 'Tabora', NULL, NULL),
(26, 'Tanga', NULL, NULL),
(27, 'Zanzibar', NULL, NULL);

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

--
-- Table structure for table `representatives`
--

CREATE TABLE `representatives` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `department_id` bigint(20) UNSIGNED NOT NULL,
  `branch_id` bigint(20) UNSIGNED NOT NULL,
  `district_id` bigint(20) UNSIGNED NOT NULL,
  `region_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `representatives`
--

INSERT INTO `representatives` (`id`, `user_id`, `department_id`, `branch_id`, `district_id`, `region_id`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 1, 96, 20, '2024-10-08 22:07:02', '2024-10-08 22:07:02');

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

--
-- Table structure for table `residential_disasters`
--

CREATE TABLE `residential_disasters` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `disaster_type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `residential_disasters`
--

INSERT INTO `residential_disasters` (`id`, `disaster_type`, `created_at`, `updated_at`) VALUES
(1, 'fire', '2024-10-27 10:49:19', '2024-10-27 10:49:19'),
(2, 'flood', '2024-11-08 05:35:03', '2024-11-08 05:35:03'),
(3, 'fire', '2024-11-12 01:50:03', '2024-11-12 01:50:03'),
(4, 'hurricane', '2024-11-13 05:54:28', '2024-11-13 05:54:28'),
(5, 'fire', '2024-12-02 03:28:35', '2024-12-02 03:28:35');

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

--
-- Table structure for table `responses`
--

CREATE TABLE `responses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `enquiry_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(15,2) DEFAULT NULL,
  `interest` decimal(5,2) DEFAULT NULL,
  `remarks` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `from_amount` decimal(15,2) DEFAULT NULL,
  `to_amount` decimal(15,2) DEFAULT NULL,
  `duration` int(11) DEFAULT NULL,
  `date_of_retirement` date DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `responses`
--

INSERT INTO `responses` (`id`, `enquiry_id`, `user_id`, `amount`, `interest`, `remarks`, `description`, `from_amount`, `to_amount`, `duration`, `date_of_retirement`, `created_at`, `updated_at`) VALUES
(15, 31, 1, 10000.00, 32.00, NULL, NULL, NULL, NULL, 445667, NULL, '2024-08-16 11:17:23', '2024-08-16 11:17:23'),
(16, 31, 1, 10000.00, 23.00, NULL, NULL, NULL, NULL, 567, NULL, '2024-08-16 11:17:53', '2024-08-16 11:17:53'),
(17, 32, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-16 11:27:00', '2024-08-16 11:27:00'),
(18, 36, 1, 50000.00, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2024-08-16 11:27:14', '2024-08-16 11:27:14');

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

--
-- Table structure for table `retirements`
--

CREATE TABLE `retirements` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date_of_retirement` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `retirements`
--

INSERT INTO `retirements` (`id`, `date_of_retirement`, `created_at`, `updated_at`) VALUES
(1, '2024-10-30', '2024-10-27 10:05:17', '2024-10-27 10:05:17'),
(2, '2024-11-22', '2024-11-05 02:58:29', '2024-11-05 02:58:29'),
(3, '2024-11-12', '2024-11-08 05:07:08', '2024-11-08 05:07:08'),
(4, '2024-11-14', '2024-11-08 08:23:11', '2024-11-08 08:23:11'),
(5, '2024-11-22', '2024-11-08 08:36:50', '2024-11-08 08:36:50'),
(6, '2024-11-30', '2024-11-08 10:29:26', '2024-11-08 10:29:26'),
(7, '2024-12-25', '2024-12-02 03:32:23', '2024-12-02 03:32:23'),
(8, '2024-12-23', '2024-12-11 07:06:23', '2024-12-11 07:06:23'),
(9, '2024-12-24', '2024-12-11 07:10:12', '2024-12-11 07:10:12');

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

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(1, 'admin', 'web', '2024-09-19 13:33:54', '2024-09-19 13:33:54'),
(2, 'accountant', 'web', '2024-09-19 15:30:24', '2024-09-19 15:30:24'),
(3, 'loanofficer', 'web', '2024-09-19 16:08:34', '2024-09-19 16:08:34'),
(4, 'Registrar', 'web', '2024-09-19 16:10:37', '2024-09-19 16:10:37'),
(5, 'superadmin', 'web', '2024-10-15 01:51:34', '2024-10-15 01:51:34'),
(6, 'system admin', 'web', '2024-10-15 01:52:34', '2024-10-15 01:52:34'),
(7, 'public relation officer', 'web', '2024-10-15 01:53:47', '2024-10-15 01:53:47'),
(8, 'registrar_hq', 'web', '2024-12-11 06:18:56', '2024-12-11 06:18:56'),
(9, 'a', 'web', '2024-12-13 05:37:12', '2024-12-13 05:37:12'),
(10, 'b', 'web', '2024-12-13 05:39:11', '2024-12-13 05:39:11');

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

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(1, 1),
(1, 5),
(1, 7),
(1, 8),
(2, 3),
(3, 2),
(5, 4),
(5, 6);

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

--
-- Table structure for table `shares`
--

CREATE TABLE `shares` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `share_amount` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shares`
--

INSERT INTO `shares` (`id`, `share_amount`, `created_at`, `updated_at`) VALUES
(1, 500000.00, '2024-10-27 10:00:51', '2024-10-27 10:00:51'),
(2, 500000.00, '2024-11-04 02:21:46', '2024-11-04 02:21:46'),
(3, 100.00, '2024-11-08 05:04:22', '2024-11-08 05:04:22'),
(4, 323.00, '2024-12-02 03:36:18', '2024-12-02 03:36:18');

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

--
-- Table structure for table `sick_leaves`
--

CREATE TABLE `sick_leaves` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `startdate` date NOT NULL,
  `enddate` date NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sick_leaves`
--

INSERT INTO `sick_leaves` (`id`, `startdate`, `enddate`, `created_at`, `updated_at`) VALUES
(1, '2024-10-27', '2024-10-30', '2024-10-27 10:38:11', '2024-10-27 10:38:11'),
(2, '2024-11-06', '2024-11-30', '2024-11-08 05:30:27', '2024-11-08 05:30:27'),
(3, '2024-11-12', '2024-11-25', '2024-11-08 08:25:20', '2024-11-08 08:25:20'),
(4, '2024-11-03', '2024-11-19', '2024-11-08 10:18:28', '2024-11-08 10:18:28'),
(5, '2024-11-20', '2024-11-13', '2024-11-08 14:46:27', '2024-11-08 14:46:27'),
(6, '2024-11-20', '2024-11-12', '2024-11-09 13:10:28', '2024-11-09 13:10:28'),
(7, '2025-01-02', '2024-12-19', '2024-12-02 03:41:21', '2024-12-02 03:41:21'),
(8, '2024-12-25', '2024-12-31', '2024-12-02 07:43:16', '2024-12-02 07:43:16'),
(9, '2024-12-26', '2024-12-24', '2024-12-12 03:54:44', '2024-12-12 03:54:44'),
(10, '2024-12-25', '2024-12-31', '2024-12-12 05:43:41', '2024-12-12 05:43:41');

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

--
-- Table structure for table `ura_mobile`
--

CREATE TABLE `ura_mobile` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `mobile_number` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `ura_mobile`
--

INSERT INTO `ura_mobile` (`id`, `mobile_number`, `created_at`, `updated_at`) VALUES
(1, NULL, '2024-10-27 11:44:17', '2024-10-27 11:44:17'),
(2, NULL, '2024-11-08 05:26:11', '2024-11-08 05:26:11'),
(3, NULL, '2024-11-08 08:39:39', '2024-11-08 08:39:39'),
(4, NULL, '2024-11-08 08:45:41', '2024-11-08 08:45:41'),
(5, NULL, '2024-11-08 09:21:31', '2024-11-08 09:21:31');

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

--
-- Table structure for table `withdrawals`
--

CREATE TABLE `withdrawals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `type` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `withdrawals`
--

INSERT INTO `withdrawals` (`id`, `amount`, `type`, `created_at`, `updated_at`) VALUES
(1, 500000.00, 'savings', '2024-10-27 10:19:51', '2024-10-27 10:19:51'),
(2, 1000000.00, 'deposit', '2024-10-27 10:24:25', '2024-10-27 10:24:25'),
(3, 3000.00, 'savings', '2024-11-08 05:12:31', '2024-11-08 05:12:31'),
(4, 1000.00, 'deposit', '2024-11-08 05:17:59', '2024-11-08 05:17:59'),
(5, 32.00, 'deposit', '2024-12-02 03:45:07', '2024-12-02 03:45:07'),
(6, 44.00, 'savings', '2024-12-11 07:33:19', '2024-12-11 07:33:19');

--
-- Indexes for dumped tables
--

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

--
-- Indexes for table `branches`
--
ALTER TABLE `branches`
  ADD PRIMARY KEY (`id`),
  ADD KEY `branches_district_id_foreign` (`district_id`),
  ADD KEY `branches_region_id_foreign` (`region_id`);

--
-- Indexes for table `branch_department`
--
ALTER TABLE `branch_department`
  ADD PRIMARY KEY (`branch_id`,`department_id`);

--
-- Indexes for table `commands`
--
ALTER TABLE `commands`
  ADD PRIMARY KEY (`id`),
  ADD KEY `commands_region_id_foreign` (`region_id`),
  ADD KEY `commands_branch_id_foreign` (`branch_id`),
  ADD KEY `commands_district_id_foreign` (`district_id`);

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

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

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

--
-- Indexes for table `districts`
--
ALTER TABLE `districts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `districts_region_id_foreign` (`region_id`);

--
-- Indexes for table `enquiries`
--
ALTER TABLE `enquiries`
  ADD PRIMARY KEY (`id`),
  ADD KEY `enquiries_registered_by_foreign` (`registered_by`),
  ADD KEY `enquiries_branch_id_foreign` (`branch_id`),
  ADD KEY `enquiries_enquirable_id_enquirable_type_index` (`enquirable_id`,`enquirable_type`),
  ADD KEY `enquiries_command_id_foreign` (`command_id`);

--
-- Indexes for table `enquiry_user`
--
ALTER TABLE `enquiry_user`
  ADD PRIMARY KEY (`enquiry_id`,`user_id`),
  ADD KEY `enquiry_user_user_id_foreign` (`user_id`),
  ADD KEY `enquiry_user_assigned_by_foreign` (`assigned_by`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `files`
--
ALTER TABLE `files`
  ADD PRIMARY KEY (`id`),
  ADD KEY `files_file_series_id_foreign` (`file_series_id`),
  ADD KEY `files_keyword1_id_foreign` (`keyword1_id`),
  ADD KEY `files_keyword2_id_foreign` (`keyword2_id`),
  ADD KEY `files_department_id_foreign` (`department_id`),
  ADD KEY `files_branch_id_foreign` (`branch_id`);

--
-- Indexes for table `file_series`
--
ALTER TABLE `file_series`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `file_series_name_unique` (`name`),
  ADD UNIQUE KEY `file_series_code_unique` (`code`);

--
-- Indexes for table `folios`
--
ALTER TABLE `folios`
  ADD PRIMARY KEY (`id`),
  ADD KEY `folios_file_id_foreign` (`file_id`);

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

--
-- Indexes for table `keywords`
--
ALTER TABLE `keywords`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `keywords_code_unique` (`code`);

--
-- Indexes for table `loan_application_histories`
--
ALTER TABLE `loan_application_histories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `loan_application_histories_loan_application_id_foreign` (`loan_application_id`),
  ADD KEY `loan_application_histories_user_id_foreign` (`user_id`);

--
-- Indexes for table `members`
--
ALTER TABLE `members`
  ADD PRIMARY KEY (`id`),
  ADD KEY `members_branch_id_foreign` (`branch_id`);

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

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

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

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

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

--
-- Indexes for table `payment_logs`
--
ALTER TABLE `payment_logs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payment_logs_payment_id_foreign` (`payment_id`),
  ADD KEY `payment_logs_initiated_by_foreign` (`initiated_by`),
  ADD KEY `payment_logs_approved_by_foreign` (`approved_by`),
  ADD KEY `payment_logs_paid_by_foreign` (`paid_by`),
  ADD KEY `payment_logs_rejected_by_foreign` (`rejected_by`);

--
-- Indexes for table `payrolls`
--
ALTER TABLE `payrolls`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `payrolls_check_number_unique` (`check_number`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

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

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

--
-- Indexes for table `refunds`
--
ALTER TABLE `refunds`
  ADD PRIMARY KEY (`id`),
  ADD KEY `refunds_enquirable_id_enquirable_type_index` (`enquirable_id`,`enquirable_type`);

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

--
-- Indexes for table `representatives`
--
ALTER TABLE `representatives`
  ADD PRIMARY KEY (`id`),
  ADD KEY `representatives_user_id_foreign` (`user_id`),
  ADD KEY `representatives_department_id_foreign` (`department_id`),
  ADD KEY `representatives_branch_id_foreign` (`branch_id`),
  ADD KEY `representatives_district_id_foreign` (`district_id`),
  ADD KEY `representatives_region_id_foreign` (`region_id`);

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

--
-- Indexes for table `responses`
--
ALTER TABLE `responses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `responses_enquiry_id_foreign` (`enquiry_id`),
  ADD KEY `responses_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `benefits`
--
ALTER TABLE `benefits`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `branches`
--
ALTER TABLE `branches`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `commands`
--
ALTER TABLE `commands`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `condolences`
--
ALTER TABLE `condolences`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `deductions`
--
ALTER TABLE `deductions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `departments`
--
ALTER TABLE `departments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `districts`
--
ALTER TABLE `districts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=131;

--
-- AUTO_INCREMENT for table `enquiries`
--
ALTER TABLE `enquiries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=289;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `files`
--
ALTER TABLE `files`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `file_series`
--
ALTER TABLE `file_series`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `folios`
--
ALTER TABLE `folios`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=107;

--
-- AUTO_INCREMENT for table `injuries`
--
ALTER TABLE `injuries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `keywords`
--
ALTER TABLE `keywords`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=414;

--
-- AUTO_INCREMENT for table `loan_application_histories`
--
ALTER TABLE `loan_application_histories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `members`
--
ALTER TABLE `members`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=145;

--
-- AUTO_INCREMENT for table `memberships`
--
ALTER TABLE `memberships`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `membership_changes`
--
ALTER TABLE `membership_changes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=75;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=168;

--
-- AUTO_INCREMENT for table `payment_logs`
--
ALTER TABLE `payment_logs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT for table `payrolls`
--
ALTER TABLE `payrolls`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47898;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `posts`
--
ALTER TABLE `posts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `ranks`
--
ALTER TABLE `ranks`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `refunds`
--
ALTER TABLE `refunds`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `regions`
--
ALTER TABLE `regions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

--
-- AUTO_INCREMENT for table `representatives`
--
ALTER TABLE `representatives`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `residential_disasters`
--
ALTER TABLE `residential_disasters`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `responses`
--
ALTER TABLE `responses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `retirements`
--
ALTER TABLE `retirements`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `shares`
--
ALTER TABLE `shares`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `sick_leaves`
--
ALTER TABLE `sick_leaves`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `ura_mobile`
--
ALTER TABLE `ura_mobile`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `withdrawals`
--
ALTER TABLE `withdrawals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `branches`
--
ALTER TABLE `branches`
  ADD CONSTRAINT `branches_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `branches_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `branch_department`
--
ALTER TABLE `branch_department`
  ADD CONSTRAINT `branch_department_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `commands`
--
ALTER TABLE `commands`
  ADD CONSTRAINT `commands_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `commands_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `commands_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `districts`
--
ALTER TABLE `districts`
  ADD CONSTRAINT `districts_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `enquiries`
--
ALTER TABLE `enquiries`
  ADD CONSTRAINT `enquiries_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `enquiries_command_id_foreign` FOREIGN KEY (`command_id`) REFERENCES `commands` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `enquiries_registered_by_foreign` FOREIGN KEY (`registered_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `enquiry_user`
--
ALTER TABLE `enquiry_user`
  ADD CONSTRAINT `enquiry_user_assigned_by_foreign` FOREIGN KEY (`assigned_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `enquiry_user_enquiry_id_foreign` FOREIGN KEY (`enquiry_id`) REFERENCES `enquiries` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `enquiry_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `files`
--
ALTER TABLE `files`
  ADD CONSTRAINT `files_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `files_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`),
  ADD CONSTRAINT `files_file_series_id_foreign` FOREIGN KEY (`file_series_id`) REFERENCES `file_series` (`id`),
  ADD CONSTRAINT `files_keyword1_id_foreign` FOREIGN KEY (`keyword1_id`) REFERENCES `keywords` (`id`),
  ADD CONSTRAINT `files_keyword2_id_foreign` FOREIGN KEY (`keyword2_id`) REFERENCES `keywords` (`id`);

--
-- Constraints for table `folios`
--
ALTER TABLE `folios`
  ADD CONSTRAINT `folios_file_id_foreign` FOREIGN KEY (`file_id`) REFERENCES `files` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `loan_application_histories`
--
ALTER TABLE `loan_application_histories`
  ADD CONSTRAINT `loan_application_histories_loan_application_id_foreign` FOREIGN KEY (`loan_application_id`) REFERENCES `loan_applications` (`id`),
  ADD CONSTRAINT `loan_application_histories_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `members`
--
ALTER TABLE `members`
  ADD CONSTRAINT `members_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `payment_logs`
--
ALTER TABLE `payment_logs`
  ADD CONSTRAINT `payment_logs_approved_by_foreign` FOREIGN KEY (`approved_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `payment_logs_initiated_by_foreign` FOREIGN KEY (`initiated_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `payment_logs_paid_by_foreign` FOREIGN KEY (`paid_by`) REFERENCES `users` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `payment_logs_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payment_logs_rejected_by_foreign` FOREIGN KEY (`rejected_by`) REFERENCES `users` (`id`) ON DELETE SET NULL;

--
-- Constraints for table `representatives`
--
ALTER TABLE `representatives`
  ADD CONSTRAINT `representatives_branch_id_foreign` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `representatives_department_id_foreign` FOREIGN KEY (`department_id`) REFERENCES `departments` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `representatives_district_id_foreign` FOREIGN KEY (`district_id`) REFERENCES `districts` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `representatives_region_id_foreign` FOREIGN KEY (`region_id`) REFERENCES `regions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `representatives_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `responses`
--
ALTER TABLE `responses`
  ADD CONSTRAINT `responses_enquiry_id_foreign` FOREIGN KEY (`enquiry_id`) REFERENCES `enquiries` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `responses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;
COMMIT;

