-- Table structure for table `emppaymentdetails`
--

CREATE TABLE `emppaymentdetails` (
  `EmpPaymentId` int(11) NOT NULL,
  `EmpId` decimal(18,0) DEFAULT NULL,
  `PaymentId` decimal(18,0) DEFAULT NULL,
  `Amount` decimal(18,0) DEFAULT NULL,
  `PayTaxable` decimal(18,0) DEFAULT NULL,
  `PayPensionOnly` decimal(18,0) DEFAULT NULL,
  `PayPAYEOnly` decimal(18,0) DEFAULT NULL,
  `IsInReport` decimal(18,0) DEFAULT NULL,
  `IsInPayslip` decimal(18,0) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `EffectOnSDL` int(11) DEFAULT NULL,
  `EffectOnWCF` int(11) DEFAULT NULL,
  `IsBenefit` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `emppaymentdetails`
--

INSERT INTO `emppaymentdetails` (`EmpPaymentId`, `EmpId`, `PaymentId`, `Amount`, `PayTaxable`, `PayPensionOnly`, `PayPAYEOnly`, `IsInReport`, `IsInPayslip`, `CompanyId`, `EffectOnSDL`, `EffectOnWCF`, `IsBenefit`) VALUES
(8, '7', '1', '2180190', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(9, '85', '1', '835132', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(10008, '4', '1', '503195', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(10018, '13', '1', '689027', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(10023, '63', '2', '34722', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(10024, '63', '1', '65960', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(20011, '2', '1', '33590', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(20013, '8', '1', '846284', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(20017, '87', '1', '849739', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30021, '68', '1', '2595875', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30028, '96', '1', '551492', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30030, '75', '1', '2463333', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30034, '5', '1', '80700', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30041, '23', '1', '99349', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30042, '26', '1', '625293', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30045, '46', '1', '75856', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30048, '59', '1', '577932', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30049, '39', '1', '46797', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30051, '1', '1', '83585', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30054, '62', '1', '41941', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30057, '86', '1', '393828', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30059, '95', '1', '76497', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30061, '98', '1', '505596', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(30062, '20', '1', '900000', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40084, '78', '1', '54853', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40087, '97', '1', '26594', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40091, '25', '1', '26087', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40092, '29', '1', '142539', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40093, '27', '1', '36000', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40095, '31', '1', '156522', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40102, '14', '1', '93229', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40106, '18', '1', '47915', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40110, '28', '1', '38249', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40113, '33', '1', '38249', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40114, '34', '1', '51756', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40116, '42', '1', '38249', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40118, '47', '1', '42270', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40120, '52', '1', '51733', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40122, '53', '1', '38249', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40123, '69', '1', '26087', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40125, '72', '1', '106071', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40129, '83', '1', '44077', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40137, '92', '1', '75441', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(40148, '84', '1', '419876', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50142, '10', '1', '49721', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50143, '16', '1', '38249', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50146, '74', '1', '484331', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50147, '82', '1', '58075', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50148, '94', '1', '49721', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50153, '30', '1', '33441', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50154, '65', '1', '53297', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50156, '79', '1', '38904', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50157, '90', '1', '172612', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50158, '58', '1', '3645625', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50159, '45', '1', '23865', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50160, '19', '1', '32112', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50161, '64', '2', '76960', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50162, '64', '1', '53784', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50163, '88', '1', '730435', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50164, '57', '1', '375192', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50165, '60', '1', '378522', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50166, '54', '1', '405022', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50167, '89', '1', '1516219', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50168, '93', '1', '378468', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50169, '38', '1', '63072', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50170, '3', '1', '181902', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50171, '12', '2', '34722', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50172, '12', '1', '65960', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50173, '35', '1', '48367', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50175, '51', '2', '107759', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(50176, '51', '1', '53785', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(60174, '44', '1', '378468', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(60175, '56', '1', '19565', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(60176, '71', '1', '19565', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(60178, '40', '1', '378522', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(60179, '48', '1', '553350', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(60180, '21', '1', '268379', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(60181, '24', '1', '131015', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(60182, '32', '1', '39405', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(60183, '70', '1', '40850', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(60184, '81', '1', '40850', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(60185, '91', '1', '45656', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70181, '80', '1', '500000', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70182, '43', '1', '500000', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70184, '36', '1', '407301', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70185, '9', '1', '38783', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70186, '6', '1', '281610', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70187, '11', '1', '33958', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70188, '15', '1', '156522', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70189, '17', '1', '58710', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70190, '22', '1', '43016', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70191, '37', '1', '36000', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70192, '50', '1', '31054', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70193, '61', '1', '33958', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70194, '66', '1', '39076', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70195, '76', '1', '32592', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70196, '77', '1', '45388', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70197, '73', '1', '342745', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(70198, '49', '1', '32609', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(80182, '55', '1', '896066', '1', '1', '1', '1', '1', '1', 0, 1, 0),
(80183, '99', '1', '450000', '1', '1', '1', '1', '1', '1', 1, 1, 1);

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

--
-- Table structure for table `emppaymentshistory`
--

CREATE TABLE `emppaymentshistory` (
  `Id` decimal(18,0) NOT NULL,
  `EmpId` decimal(18,0) DEFAULT NULL,
  `PaymentId` decimal(18,0) DEFAULT NULL,
  `PayTaxable` decimal(18,0) DEFAULT NULL,
  `PayPensionOnly` decimal(18,0) DEFAULT NULL,
  `PayPAYEOnly` decimal(18,0) DEFAULT NULL,
  `IsInReport` decimal(18,0) DEFAULT NULL,
  `IsInPayslip` decimal(18,0) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `CreatedBy` decimal(18,0) DEFAULT NULL,
  `CreatedDate` datetime DEFAULT NULL,
  `EffectOnSDL` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `empqualification`
--

CREATE TABLE `empqualification` (
  `EmpQualificationId` int(11) NOT NULL,
  `EmpId` decimal(18,0) DEFAULT NULL,
  `QualificationId` decimal(18,0) DEFAULT NULL,
  `EmpQualificationDetails` longtext DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `empqualification`
--

INSERT INTO `empqualification` (`EmpQualificationId`, `EmpId`, `QualificationId`, `EmpQualificationDetails`, `CompanyId`) VALUES
(1, '99', '1', '', '1');

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

--
-- Table structure for table `empshiftdetails`
--

CREATE TABLE `empshiftdetails` (
  `EmpShiftid` int(11) NOT NULL,
  `EmpId` decimal(18,0) DEFAULT NULL,
  `ShiftId` decimal(18,0) DEFAULT NULL,
  `MonthDay` decimal(18,0) DEFAULT NULL,
  `PayrollMonth` decimal(18,0) DEFAULT NULL,
  `PayrollYear` decimal(18,0) DEFAULT NULL,
  `chkWorkOnSunday` int(11) DEFAULT NULL,
  `ShiftType` varchar(50) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `empshifthistory`
--

CREATE TABLE `empshifthistory` (
  `Id` decimal(18,0) NOT NULL,
  `EmpId` decimal(18,0) DEFAULT NULL,
  `ShiftId` decimal(18,0) DEFAULT NULL,
  `MonthDay` decimal(18,0) DEFAULT NULL,
  `PayrollMonth` decimal(18,0) DEFAULT NULL,
  `PayrollYear` decimal(18,0) DEFAULT NULL,
  `chkWorkonSunday` int(11) DEFAULT NULL,
  `ShiftType` varchar(50) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `formulas`
--

CREATE TABLE `formulas` (
  `Id` int(11) NOT NULL,
  `FormulaName` varchar(50) DEFAULT NULL,
  `PensionId` decimal(18,0) DEFAULT NULL,
  `SalaryType` decimal(18,0) DEFAULT NULL,
  `Dividedby` decimal(18,0) DEFAULT NULL,
  `MonthlyHrs` decimal(18,0) DEFAULT NULL,
  `WorkingDays` decimal(18,0) DEFAULT NULL,
  `DailyHrs` decimal(18,0) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `CreatedBy` decimal(18,0) DEFAULT NULL,
  `CreatedDate` date DEFAULT NULL,
  `ModifiedBy` decimal(18,0) DEFAULT NULL,
  `ModifiedDate` date DEFAULT NULL,
  `DeductionId` decimal(18,0) DEFAULT NULL,
  `AbsentFormulaUsed` decimal(18,0) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `formulas`
--

INSERT INTO `formulas` (`Id`, `FormulaName`, `PensionId`, `SalaryType`, `Dividedby`, `MonthlyHrs`, `WorkingDays`, `DailyHrs`, `CompanyId`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`, `DeductionId`, `AbsentFormulaUsed`, `status`) VALUES
(1, 'Pension-NSSF', '1', '1', '0', '0', '0', '0', '1', NULL, NULL, NULL, NULL, '0', '0', '1'),
(2, 'Overtime', '0', '0', '1', '195', '0', '0', '1', NULL, NULL, NULL, NULL, '0', '0', '1'),
(3, 'Absent', '0', '1', '2', '0', '30', '0', '1', NULL, NULL, '1', '2024-01-26', '0', NULL, '1'),
(4, 'Late', '0', '1', '1', '195', '0', '0', '1', '1', '2024-01-26', NULL, NULL, '0', NULL, '1');

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

--
-- Table structure for table `holidays`
--

CREATE TABLE `holidays` (
  `HolidayId` int(11) NOT NULL,
  `Holiday` varchar(50) DEFAULT NULL,
  `HolidayDay` decimal(18,0) DEFAULT NULL,
  `HolidayMonth` decimal(18,0) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `holidays`
--

INSERT INTO `holidays` (`HolidayId`, `Holiday`, `HolidayDay`, `HolidayMonth`, `status`) VALUES
(1, 'New Year', '1', '1', NULL),
(2, 'Maulidi Day', '12', '12', NULL),
(3, 'Revolution Day', '12', '1', NULL),
(4, 'Good Friday', '25', '3', NULL),
(5, 'Easter Monday', '28', '3', NULL),
(6, 'Karume Day', '7', '4', NULL),
(7, 'Union Day', '26', '4', NULL),
(8, 'Wokers Day', '1', '5', NULL),
(9, 'SabaSaba', '7', '7', NULL),
(10, 'Eid-ul-Fitr', '7', '7', NULL),
(11, 'NaneNane', '8', '8', NULL),
(12, 'Eid-ul-Hajj', '13', '9', NULL),
(13, 'Nyerere Day', '14', '10', NULL),
(14, 'Independence Day', '9', '12', NULL),
(15, 'Chrismas', '25', '12', NULL),
(16, 'Boxing Day', '26', '12', NULL),
(17, 'holiday', '1', '1', NULL),
(18, 'Holiday2', '1', '1', NULL),
(19, 'Holiday3', '1', '1', NULL),
(20, 'Holiday4', '1', '1', '1');

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

--
-- Table structure for table `housingrate`
--

CREATE TABLE `housingrate` (
  `HousingRateId` int(11) NOT NULL,
  `HousingRate` decimal(16,2) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `housingrate`
--

INSERT INTO `housingrate` (`HousingRateId`, `HousingRate`, `CompanyId`, `status`) VALUES
(1, '15.00', '1', '1');

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

--
-- Table structure for table `inventoryitems`
--

CREATE TABLE `inventoryitems` (
  `InventoryId` decimal(18,0) NOT NULL,
  `ItemName` varchar(50) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `late`
--

CREATE TABLE `late` (
  `LateId` decimal(18,0) NOT NULL,
  `DeductedFrom` int(11) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `leaveapproval`
--

CREATE TABLE `leaveapproval` (
  `LeaveAppId` decimal(18,0) NOT NULL,
  `LeaveAppDate` date DEFAULT NULL,
  `LeaveReqId` decimal(18,0) DEFAULT NULL,
  `EmpId` decimal(18,0) DEFAULT NULL,
  `LeaveTypeId` decimal(18,0) DEFAULT NULL,
  `TotalBalance` decimal(18,0) DEFAULT NULL,
  `FromDate` date DEFAULT NULL,
  `ToDate` date DEFAULT NULL,
  `NoOfDays` decimal(18,0) DEFAULT NULL,
  `RemainingDays` decimal(18,0) DEFAULT NULL,
  `Remarks` longtext DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `LeaveAction` varchar(50) DEFAULT NULL,
  `EncashAmount` decimal(18,0) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `leavetransaction`
--

CREATE TABLE `leavetransaction` (
  `LeaveTrId` int(11) NOT NULL,
  `LeaveNo` decimal(18,0) DEFAULT NULL,
  `LeaveTrDate` date DEFAULT NULL,
  `LeaveAppDate` date DEFAULT NULL,
  `EmpId` decimal(18,0) DEFAULT NULL,
  `LeaveTypeId` decimal(18,0) DEFAULT NULL,
  `Type` varchar(50) DEFAULT NULL,
  `FromDate` date DEFAULT NULL,
  `ToDate` date DEFAULT NULL,
  `NoOfDays` decimal(17,1) DEFAULT NULL,
  `Remarks` longtext DEFAULT NULL,
  `Status` decimal(18,0) DEFAULT NULL,
  `LeaveAction` varchar(50) DEFAULT NULL,
  `EncashAmount` decimal(18,0) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `CreatedBy` decimal(18,0) DEFAULT NULL,
  `CreatedDate` date DEFAULT NULL,
  `ModifiedBy` decimal(18,0) DEFAULT NULL,
  `ModifiedDate` date DEFAULT NULL,
  `LeaveGivenFrom` varchar(150) DEFAULT NULL,
  `UseFormula` int(11) DEFAULT NULL,
  `HODApprovalFlag` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `leavetransaction`
--

INSERT INTO `leavetransaction` (`LeaveTrId`, `LeaveNo`, `LeaveTrDate`, `LeaveAppDate`, `EmpId`, `LeaveTypeId`, `Type`, `FromDate`, `ToDate`, `NoOfDays`, `Remarks`, `Status`, `LeaveAction`, `EncashAmount`, `CompanyId`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`, `LeaveGivenFrom`, `UseFormula`, `HODApprovalFlag`) VALUES
(1, '1', '2023-05-17', '2023-07-18', '12', '1', 'IN', '2023-07-18', '2023-07-18', '0.0', '', '1', '', '0', '1', '0', '2023-05-17', '1', '2023-07-18', 'EmpDetails', 0, 0),
(2, '2', '2023-05-17', '2023-07-18', '12', '4', 'IN', '2023-07-18', '2023-07-18', '4.0', '', '1', '', '0', '1', '0', '2023-05-17', '1', '2023-07-18', 'EmpDetails', 0, 0),
(3, '3', '2023-05-17', '2023-07-18', '12', '3', 'IN', '2023-07-18', '2023-07-18', '3.0', '', '1', '', '0', '1', '0', '2023-05-17', '1', '2023-07-18', 'EmpDetails', 0, 0),
(4, NULL, '2024-01-26', NULL, '1', '1', 'OUT', '2024-02-01', '2024-02-10', '10.0', '', '0', '0', NULL, '1', '1', '2024-01-26', NULL, NULL, 'Transaction', NULL, NULL),
(5, NULL, '2024-03-15', '2024-03-15', '99', '1', 'IN', '2024-03-15', '2024-03-15', '28.0', NULL, '1', NULL, NULL, '1', '1', '2024-03-15', NULL, NULL, 'EmpDetails', NULL, NULL);

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

--
-- Table structure for table `leavetype`
--

CREATE TABLE `leavetype` (
  `LeaveId` int(11) NOT NULL,
  `LeaveName` varchar(150) DEFAULT NULL,
  `NoOfDays` decimal(18,0) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `othername` varchar(150) DEFAULT NULL,
  `showinweb` int(11) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `leavetype`
--

INSERT INTO `leavetype` (`LeaveId`, `LeaveName`, `NoOfDays`, `CompanyId`, `othername`, `showinweb`, `status`) VALUES
(1, 'ANNUAL LEAVE', '28', '1', '', 0, '1'),
(2, 'ANNUAL LEAVE', '28', '1', '', 0, '1'),
(3, 'ANNUAL LEAVE', '28', '1', '', 0, '1'),
(4, 'ANNUAL LEAVE', '28', '1', '', 0, '1'),
(5, 'ANNUAL LEAVE', '28', '1', '', 0, '1');

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

--
-- Table structure for table `loanchange`
--

CREATE TABLE `loanchange` (
  `LoanChangeId` int(11) NOT NULL,
  `LoanChangeDate` date DEFAULT NULL,
  `LoanTypeId` decimal(18,0) DEFAULT NULL,
  `LoanTrId` decimal(18,0) DEFAULT NULL,
  `EmpId` decimal(18,0) DEFAULT NULL,
  `CurrentLoanDedAmount` decimal(16,2) DEFAULT NULL,
  `AmountChange` decimal(16,2) DEFAULT NULL,
  `ChangeMonth` decimal(18,0) DEFAULT NULL,
  `ChangeYear` decimal(18,0) DEFAULT NULL,
  `TypeofChange` int(11) DEFAULT NULL,
  `Remarks` text DEFAULT NULL,
  `CreatedBy` decimal(18,0) DEFAULT NULL,
  `CreatedDate` date DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `loanchange`
--

INSERT INTO `loanchange` (`LoanChangeId`, `LoanChangeDate`, `LoanTypeId`, `LoanTrId`, `EmpId`, `CurrentLoanDedAmount`, `AmountChange`, `ChangeMonth`, `ChangeYear`, `TypeofChange`, `Remarks`, `CreatedBy`, `CreatedDate`, `CompanyId`) VALUES
(4, '2024-09-09', '1', '4', '2', '0.00', '0.00', '4', '2024', 0, '', '1', '2024-09-09', '1'),
(5, '2024-09-09', '1', '4', '2', '0.00', '0.00', '4', '2024', 0, '', '1', '2024-09-09', '1'),
(6, '2024-09-09', '1', '4', '2', '0.00', '0.00', '4', '2024', 0, '', '1', '2024-09-09', '1'),
(7, '2024-09-09', '2', '3', '8', '0.00', '0.00', '4', '2024', 0, '', '1', '2024-09-09', '1'),
(8, '2024-09-09', '1', '5', '7', '0.00', '0.00', '4', '2024', 0, '', '1', '2024-09-09', '1'),
(9, '2024-09-10', '1', '6', '12', '0.00', '0.00', '4', '2024', 0, '', '1', '2024-09-10', '1'),
(10, '2024-09-10', '1', '6', '12', '0.00', '0.00', '4', '2024', 0, '', '1', '2024-09-10', '1'),
(11, '2024-09-10', '1', '7', '10', '0.00', '0.00', '4', '2024', 0, '', '1', '2024-09-10', '1'),
(14, '2024-09-10', '1', '7', '10', '0.00', '0.00', '4', '2024', 1, '', '1', '2024-09-10', '1'),
(15, '2024-09-10', '1', '7', '10', '50000.00', '0.00', '4', '2024', 1, '', '1', '2024-09-10', '1'),
(16, '2024-09-10', '1', '7', '10', '50000.00', '0.00', '4', '2024', 1, '', '1', '2024-09-10', '1'),
(17, '2024-09-10', '1', '7', '10', '50000.00', '0.00', '4', '2024', 1, '', '1', '2024-09-10', '1'),
(18, '2024-09-10', '2', '8', '3', '90000.00', '45000.00', '4', '2024', 1, '', '1', '2024-09-10', '1');

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

--
-- Table structure for table `loaninstallment`
--

CREATE TABLE `loaninstallment` (
  `LoanInstallId` int(11) NOT NULL,
  `LoanTrId` decimal(18,0) DEFAULT NULL,
  `LoanInstallMonth` decimal(18,0) DEFAULT NULL,
  `LoanInstallYear` decimal(18,0) DEFAULT NULL,
  `LoanInstallDeduction` decimal(18,0) DEFAULT NULL,
  `LoanInstallDeducted` decimal(18,0) DEFAULT NULL,
  `PaidInCash` decimal(18,0) NOT NULL,
  `CashAmount` decimal(18,0) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `loaninstallment`
--

INSERT INTO `loaninstallment` (`LoanInstallId`, `LoanTrId`, `LoanInstallMonth`, `LoanInstallYear`, `LoanInstallDeduction`, `LoanInstallDeducted`, `PaidInCash`, `CashAmount`) VALUES
(1, '3', '4', '2024', '0', '0', '0', '0'),
(2, '3', '5', '2024', '78000', '0', '0', '0'),
(3, '3', '6', '2024', '57000', '0', '0', '0'),
(4, '3', '7', '2024', '57000', '0', '0', '0'),
(5, '3', '8', '2024', '57000', '0', '0', '0'),
(6, '3', '9', '2024', '57000', '0', '0', '0'),
(7, '3', '10', '2024', '58000', '0', '0', '0'),
(8, '4', '4', '2024', '0', '0', '0', '0'),
(9, '4', '5', '2024', '55000', '0', '0', '0'),
(10, '4', '6', '2024', '55000', '0', '0', '0'),
(11, '4', '7', '2024', '55000', '0', '0', '0'),
(12, '4', '8', '2024', '55000', '0', '0', '0'),
(13, '4', '9', '2024', '55000', '0', '0', '0'),
(14, '4', '10', '2024', '55000', '0', '0', '0'),
(15, '4', '11', '2024', '55000', '0', '0', '0'),
(16, '4', '12', '2024', '60000', '0', '0', '0'),
(19, '4', '1', '2025', '5000', '0', '0', '0'),
(20, '3', '11', '2024', '47000', '0', '0', '0'),
(21, '5', '4', '2024', '0', '0', '0', '0'),
(22, '5', '5', '2024', '111000', '0', '0', '0'),
(23, '5', '6', '2024', '111000', '0', '0', '0'),
(24, '5', '7', '2024', '111000', '0', '0', '0'),
(25, '5', '8', '2024', '111000', '0', '0', '0'),
(26, '5', '9', '2024', '111000', '0', '0', '0'),
(27, '5', '10', '2024', '114000', '0', '0', '0'),
(28, '5', '11', '2024', '11000', '0', '0', '0'),
(29, '6', '4', '2024', '5000', '0', '0', '0'),
(30, '6', '5', '2024', '8900', '0', '0', '0'),
(31, '6', '6', '2024', '8900', '0', '0', '0'),
(32, '6', '7', '2024', '8900', '0', '0', '0'),
(33, '6', '8', '2024', '8900', '0', '0', '0'),
(34, '6', '9', '2024', '8900', '0', '0', '0'),
(35, '6', '10', '2024', '8900', '0', '0', '0'),
(36, '6', '11', '2024', '8900', '0', '0', '0'),
(37, '6', '12', '2024', '8900', '0', '0', '0'),
(38, '6', '1', '2025', '8900', '0', '0', '0'),
(39, '6', '2', '2025', '3900', '0', '0', '0'),
(40, '6', '3', '2025', '3900', '0', '0', '0'),
(41, '6', '4', '2025', '3900', '0', '0', '0'),
(42, '6', '5', '2025', '3900', '0', '0', '0'),
(43, '6', '6', '2025', '3900', '0', '0', '0'),
(44, '6', '7', '2025', '3900', '0', '0', '0'),
(45, '6', '8', '2025', '3900', '0', '0', '0'),
(46, '6', '9', '2025', NULL, '0', '0', '0'),
(47, '6', '10', '2025', NULL, '0', '0', '0'),
(48, '6', '11', '2025', '3900', '0', '0', '0'),
(49, '6', '12', '2025', '3900', '0', '0', '0'),
(50, '6', '1', '2026', '3900', '0', '0', '0'),
(51, '6', '2', '2026', '3900', '0', '0', '0'),
(52, '6', '3', '2026', '3900', '0', '0', '0'),
(53, '6', '4', '2026', '3900', '0', '0', '0'),
(54, '6', '5', '2026', '3900', '0', '0', '0'),
(55, '6', '6', '2026', '3900', '0', '0', '0'),
(56, '7', '4', '2024', '0', '0', '0', '0'),
(57, '7', '5', '2024', '50000', '0', '0', '0'),
(58, '7', '6', '2024', '50000', '0', '0', '0'),
(59, '7', '7', '2024', '50000', '0', '0', '0'),
(60, '7', '8', '2024', '50000', '0', '0', '0'),
(61, '7', '9', '2024', '50000', '0', '0', '0'),
(62, '7', '10', '2024', '50000', '0', '0', '0'),
(63, '7', '11', '2024', '50000', '0', '0', '0'),
(64, '7', '12', '2024', '50000', '0', '0', '0'),
(67, '7', '3', '2025', '50000', '0', '0', '0'),
(68, '7', '4', '2025', '50000', '0', '0', '0'),
(69, '7', '5', '2025', '50000', '0', '0', '0'),
(70, '7', '6', '2025', '50000', '0', '0', '0'),
(71, '7', '7', '2025', '50000', '0', '0', '0'),
(72, '7', '8', '2025', '50000', '0', '0', '0'),
(73, '7', '9', '2025', '50000', '0', '0', '0'),
(74, '7', '10', '2025', '50000', '0', '0', '0'),
(75, '8', '4', '2024', '45000', '0', '0', '0'),
(76, '8', '5', '2024', '90000', '0', '0', '0'),
(77, '8', '6', '2024', '90000', '0', '0', '0'),
(78, '8', '7', '2024', '90000', '0', '0', '0'),
(79, '8', '8', '2024', '90000', '0', '0', '0'),
(80, '8', '9', '2024', '90000', '0', '0', '0'),
(81, '8', '10', '2024', '90000', '0', '0', '0'),
(82, '8', '11', '2024', '90000', '0', '0', '0'),
(83, '8', '12', '2024', '90000', '0', '0', '0'),
(84, '8', '1', '2025', '90000', '0', '0', '0'),
(85, '8', '2', '2025', '45000', '0', '0', '0');

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

--
-- Table structure for table `loanoutstanding`
--

CREATE TABLE `loanoutstanding` (
  `Id` decimal(18,0) NOT NULL,
  `LoanTrid` decimal(18,0) DEFAULT NULL,
  `LoanId` decimal(18,0) DEFAULT NULL,
  `EmpId` decimal(18,0) DEFAULT NULL,
  `LoanNo` decimal(18,0) DEFAULT NULL,
  `OpeningBalance` decimal(15,3) DEFAULT NULL,
  `DeductedAmt` decimal(15,3) DEFAULT NULL,
  `ClosingBalance` decimal(15,3) DEFAULT NULL,
  `Month` decimal(18,0) DEFAULT NULL,
  `Year` decimal(18,0) DEFAULT NULL,
  `Companyid` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `loanpayment`
--

CREATE TABLE `loanpayment` (
  `LoanPaymentId` decimal(18,0) NOT NULL,
  `LoanTypeId` decimal(18,0) DEFAULT NULL,
  `LoanTrId` decimal(18,0) DEFAULT NULL,
  `LoanInstallId` decimal(18,0) DEFAULT NULL,
  `Empid` decimal(18,0) DEFAULT NULL,
  `PaymentDate` date DEFAULT NULL,
  `Reason` longtext DEFAULT NULL,
  `Status` decimal(18,0) DEFAULT NULL,
  `TotalCashPayment` decimal(18,0) DEFAULT NULL,
  `CreatedBy` decimal(18,0) DEFAULT NULL,
  `CreatedDate` date DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `loanrequest`
--

CREATE TABLE `loanrequest` (
  `LReqId` int(11) NOT NULL,
  `EmpId` int(11) DEFAULT NULL,
  `LReqDate` date DEFAULT NULL,
  `LReqStatus` varchar(50) DEFAULT NULL,
  `Amount` decimal(18,0) DEFAULT NULL,
  `Reason` varchar(50) DEFAULT NULL,
  `Outstanding` int(11) DEFAULT NULL,
  `CompanyId` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `loantransactions`
--

CREATE TABLE `loantransactions` (
  `LoanTrId` int(11) NOT NULL,
  `LoanNo` decimal(18,0) DEFAULT NULL,
  `LoanTrDate` date DEFAULT NULL,
  `EmpId` decimal(18,0) DEFAULT NULL,
  `LoanId` decimal(18,0) DEFAULT NULL,
  `LoanAppDate` date DEFAULT NULL,
  `RequestedAmount` decimal(15,3) DEFAULT NULL,
  `Reason` longtext DEFAULT NULL,
  `Status` decimal(18,0) DEFAULT NULL,
  `ApprovedAmount` decimal(18,0) DEFAULT NULL,
  `Installments` decimal(18,0) DEFAULT NULL,
  `MonthlyDeduction` decimal(15,3) DEFAULT NULL,
  `LoanPayMode` decimal(18,0) DEFAULT NULL,
  `ChequeNo` varchar(50) DEFAULT NULL,
  `CreatedBy` decimal(18,0) DEFAULT NULL,
  `CreatedDate` date DEFAULT NULL,
  `ModifiedBy` decimal(18,0) DEFAULT NULL,
  `ModifiedDate` date DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `chkinterest` int(11) DEFAULT NULL,
  `InterestPer` decimal(16,2) DEFAULT NULL,
  `WithInterestAmt` decimal(16,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `loantransactions`
--

INSERT INTO `loantransactions` (`LoanTrId`, `LoanNo`, `LoanTrDate`, `EmpId`, `LoanId`, `LoanAppDate`, `RequestedAmount`, `Reason`, `Status`, `ApprovedAmount`, `Installments`, `MonthlyDeduction`, `LoanPayMode`, `ChequeNo`, `CreatedBy`, `CreatedDate`, `ModifiedBy`, `ModifiedDate`, `CompanyId`, `chkinterest`, `InterestPer`, `WithInterestAmt`) VALUES
(8, '1', '2024-04-01', '3', '2', '2024-09-10', '900000.000', '', '1', '900000', '10', '90000.000', NULL, NULL, '1', '2024-09-10', '1', '2024-09-10', '1', NULL, NULL, NULL);

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

--
-- Table structure for table `loantype`
--

CREATE TABLE `loantype` (
  `LoanTypeId` int(11) NOT NULL,
  `LoanTypeName` varchar(50) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `loantype`
--

INSERT INTO `loantype` (`LoanTypeId`, `LoanTypeName`, `CompanyId`, `status`) VALUES
(1, 'Education Loan', '1', '1'),
(2, 'STAFF LOAN', '1', '1');

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

--
-- Table structure for table `maindivision`
--

CREATE TABLE `maindivision` (
  `MainDivisionId` int(11) NOT NULL,
  `MainDivisionName` varchar(150) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `maindivision`
--

INSERT INTO `maindivision` (`MainDivisionId`, `MainDivisionName`, `CompanyId`, `status`) VALUES
(1, 'NC', '1', NULL),
(2, 'TRUST', '1', NULL),
(3, 'test main division', '1', '0');

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

--
-- Table structure for table `menu`
--

CREATE TABLE `menu` (
  `MenuId` int(11) NOT NULL,
  `Menu` varchar(50) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `menu`
--

INSERT INTO `menu` (`MenuId`, `Menu`, `status`) VALUES
(1, 'Admin', '1'),
(2, 'Employee', '1'),
(3, 'Transactions', '1'),
(4, 'Payroll Process', '1'),
(5, 'Reports', '1'),
(6, 'Utilities', '0');

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

--
-- Table structure for table `nationality`
--

CREATE TABLE `nationality`(
  `NationalityId` int(11) NOT NULL,
  `Nationality` longtext DEFAULT NULL,
  `Status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `nationality`
--

INSERT INTO `nationality` (`NationalityId`, `Nationality`, `Status`) VALUES
(1, 'TANZANIAN', '1'),
(2, 'CANADIAN', '1'),
(3, 'INDIAN', '1'),
(4, 'PAKISTANI', '1'),
(5, 'KENYAN', '1'),
(6, 'TEST', '1'),
(7, 'mysql testing nationality', '0'),
(8, 'test456', '1'),
(9, 'test3', '1'),
(10, 'nationality june', '0'),
(11, 'new nationality', '1');

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

--
-- Table structure for table `nhif`
--

CREATE TABLE `nhif` (
  `NHIFId` int(11) NOT NULL,
  `NHIFStartDate` date DEFAULT NULL,
  `NHIFEmployerPer` decimal(16,2) DEFAULT NULL,
  `NHiFEmployeePer` decimal(16,2) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `nhif`
--

INSERT INTO `nhif` (`NHIFId`, `NHIFStartDate`, `NHIFEmployerPer`, `NHiFEmployeePer`, `CompanyId`, `status`) VALUES
(1, '2024-01-01', '3.00', '3.00', '1', '1');

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

--
-- Table structure for table `overtime`
--

CREATE TABLE `overtime` (
  `OvertimeId` int(11) NOT NULL,
  `EmpId` decimal(18,0) DEFAULT NULL,
  `OTMonth` decimal(18,0) DEFAULT NULL,
  `OTYear` decimal(18,0) DEFAULT NULL,
  `OTWD` double DEFAULT NULL,
  `OTSAT` double DEFAULT NULL,
  `OTSUN` double DEFAULT NULL,
  `OTHOL` double DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `overtime`
--

INSERT INTO `overtime` (`OvertimeId`, `EmpId`, `OTMonth`, `OTYear`, `OTWD`, `OTSAT`, `OTSUN`, `OTHOL`, `CompanyId`) VALUES
(1, '1', '5', '2023', 0, 0, 0, 0, '1'),
(2, '2', '5', '2023', 0, 0, 0, 0, '1'),
(3, '3', '5', '2023', 0, 0, 0, 0, '1'),
(4, '4', '5', '2023', 0, 0, 0, 0, '1'),
(5, '6', '5', '2023', 0, 0, 0, 0, '1'),
(6, '7', '5', '2023', 0, 0, 0, 0, '1'),
(7, '8', '5', '2023', 0, 0, 0, 0, '1'),
(8, '9', '5', '2023', 0, 0, 25.38, 0, '1'),
(9, '10', '5', '2023', 0, 0, 16.31, 0, '1'),
(10, '11', '5', '2023', 2.57, 0, 26.31, 0, '1'),
(11, '12', '5', '2023', 0, 0, 0, 8, '1'),
(12, '13', '5', '2023', 0, 0, 0, 0, '1'),
(13, '14', '5', '2023', 20.43, 0, 22, 0, '1'),
(14, '15', '5', '2023', 0, 0, 24, 0, '1'),
(15, '16', '5', '2023', 0.43, 0, 16.45, 0, '1'),
(16, '17', '5', '2023', 0.52, 0, 16.45, 0, '1'),
(17, '18', '5', '2023', 0, 0, 0, 0, '1'),
(18, '19', '5', '2023', 15.13, 0, 0, 0, '1'),
(19, '20', '5', '2023', 0, 0, 0, 0, '1'),
(20, '21', '5', '2023', 0, 0, 0, 0, '1'),
(21, '22', '5', '2023', 33.36, 0, 34.04, 0, '1'),
(22, '23', '5', '2023', 26.4, 0, 0, 0, '1'),
(23, '24', '5', '2023', 0, 0, 0, 0, '1'),
(24, '25', '5', '2023', 0, 0, 0, 0, '1'),
(25, '26', '5', '2023', 0, 0, 0, 0, '1'),
(26, '28', '5', '2023', 9.34, 0, 21.04, 0, '1'),
(27, '27', '5', '2023', 11.57, 0, 26.5, 0, '1'),
(28, '29', '5', '2023', 0, 0, 20.53, 0, '1'),
(29, '30', '5', '2023', 27.27, 0, 34.56, 0, '1'),
(30, '31', '5', '2023', 0, 0, 11.23, 0, '1'),
(31, '32', '5', '2023', 0, 0, 0, 0, '1'),
(32, '33', '5', '2023', 1.09, 0, 15.3, 0, '1'),
(33, '34', '5', '2023', 110.21, 0, 48.31, 0, '1'),
(34, '35', '5', '2023', 6.21, 0, 44.26, 0, '1'),
(35, '36', '5', '2023', 0, 0, 0, 0, '1'),
(36, '37', '5', '2023', 9.35, 0, 26.11, 0, '1'),
(37, '38', '5', '2023', 0, 0, 0, 0, '1'),
(38, '39', '5', '2023', 0, 0, 0, 0, '1'),
(39, '40', '5', '2023', 0, 0, 0, 0, '1'),
(40, '41', '5', '2023', 0, 0, 0, 0, '1'),
(41, '42', '5', '2023', 13.59, 0, 9.46, 0, '1'),
(42, '43', '5', '2023', 0, 0, 0, 0, '1'),
(43, '44', '5', '2023', 0, 0, 0, 0, '1'),
(44, '45', '5', '2023', 0, 0, 0, 0, '1'),
(45, '46', '5', '2023', 0, 0, 0, 0, '1'),
(46, '47', '5', '2023', 4.21, 0, 14.28, 0, '1'),
(47, '48', '5', '2023', 0, 0, 0, 0, '1'),
(48, '49', '5', '2023', 0, 0, 0, 0, '1'),
(49, '50', '5', '2023', 2.48, 0, 17.59, 0, '1'),
(50, '51', '5', '2023', 8.5, 0, 21.17, 0, '1'),
(51, '52', '5', '2023', 20.09, 0, 30.3, 0, '1'),
(52, '53', '5', '2023', 1, 0, 27.45, 0, '1'),
(53, '5', '5', '2023', 0, 0, 0, 0, '1'),
(54, '54', '5', '2023', 0, 0, 0, 0, '1'),
(55, '55', '5', '2023', 0, 0, 0, 0, '1'),
(56, '56', '5', '2023', 0, 0, 0, 0, '1'),
(57, '57', '5', '2023', 0, 0, 0, 0, '1'),
(58, '58', '5', '2023', 0, 0, 0, 0, '1'),
(59, '59', '5', '2023', 0, 0, 0, 0, '1'),
(60, '60', '5', '2023', 0, 0, 0, 0, '1'),
(61, '62', '5', '2023', 0, 0, 0, 0, '1'),
(62, '61', '5', '2023', 34.59, 0, 35.03, 0, '1'),
(63, '63', '5', '2023', 0, 0, 0, 0, '1'),
(64, '64', '5', '2023', 0, 0, 0, 11.48, '1'),
(65, '65', '5', '2023', 16, 0, 0, 0, '1'),
(66, '66', '5', '2023', 35.52, 0, 46.21, 0, '1'),
(67, '67', '5', '2023', 0, 0, 0, 0, '1'),
(68, '68', '5', '2023', 0, 0, 0, 0, '1'),
(69, '69', '5', '2023', 0, 0, 16.07, 0, '1'),
(70, '70', '5', '2023', 0, 0, 0, 0, '1'),
(71, '71', '5', '2023', 0, 0, 0, 0, '1'),
(72, '72', '5', '2023', 2.1, 0, 27.29, 0, '1'),
(73, '73', '5', '2023', 0, 0, 0, 0, '1'),
(74, '74', '5', '2023', 0, 0, 0, 0, '1'),
(75, '76', '5', '2023', 38.3, 0, 38.56, 0, '1'),
(76, '77', '5', '2023', 1.49, 0, 27.11, 0, '1'),
(77, '75', '5', '2023', 0, 0, 0, 0, '1'),
(78, '78', '5', '2023', 0, 0, 27.13, 0, '1'),
(79, '79', '5', '2023', 18, 0, 0, 0, '1'),
(80, '80', '5', '2023', 0, 0, 0, 0, '1'),
(81, '81', '5', '2023', 0, 0, 0, 0, '1'),
(82, '82', '5', '2023', 14.38, 0, 31.55, 0, '1'),
(83, '83', '5', '2023', 0, 0, 16.11, 0, '1'),
(84, '84', '5', '2023', 0, 0, 0, 0, '1'),
(85, '85', '5', '2023', 0, 0, 0, 0, '1'),
(86, '86', '5', '2023', 0, 0, 0, 0, '1'),
(87, '87', '5', '2023', 0, 0, 0, 0, '1'),
(88, '88', '5', '2023', 0, 0, 0, 0, '1'),
(89, '89', '5', '2023', 0, 0, 0, 0, '1'),
(90, '90', '5', '2023', 0, 0, 7.29, 0, '1'),
(91, '91', '5', '2023', 0, 0, 0, 0, '1'),
(92, '92', '5', '2023', 0, 0, 0, 0, '1'),
(93, '93', '5', '2023', 0, 0, 0, 0, '1'),
(94, '94', '5', '2023', 6.4, 0, 30.05, 0, '1'),
(95, '95', '5', '2023', 0, 0, 0, 0, '1'),
(96, '96', '5', '2023', 0, 0, 0, 0, '1'),
(97, '97', '5', '2023', 31.46, 0, 18, 0, '1'),
(98, '98', '5', '2023', 0, 0, 0, 0, '1'),
(1002, '1', '6', '2023', 1, NULL, NULL, NULL, '1'),
(1003, '2', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1004, '3', '6', '2023', 2, NULL, NULL, NULL, '1'),
(1005, '4', '6', '2023', NULL, 2, NULL, NULL, '1'),
(1006, '5', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1007, '6', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1008, '7', '6', '2023', NULL, NULL, 3, NULL, '1'),
(1009, '8', '6', '2023', 1, NULL, NULL, NULL, '1'),
(1010, '9', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1011, '10', '6', '2023', NULL, NULL, 3, 1, '1'),
(1012, '11', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1013, '12', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1014, '13', '6', '2023', NULL, NULL, 2, NULL, '1'),
(1015, '14', '6', '2023', NULL, 3, NULL, NULL, '1'),
(1016, '15', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1017, '16', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1018, '17', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1019, '18', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1020, '19', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1021, '20', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1022, '21', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1023, '22', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1024, '23', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1025, '24', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1026, '25', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1027, '26', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1028, '27', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1029, '28', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1030, '29', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1031, '30', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1032, '31', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1033, '32', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1034, '33', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1035, '34', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1036, '35', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1037, '36', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1038, '37', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1039, '38', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1040, '39', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1041, '40', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1042, '41', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1043, '42', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1044, '43', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1045, '44', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1046, '45', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1047, '46', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1048, '47', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1049, '48', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1050, '49', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1051, '50', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1052, '51', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1053, '52', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1054, '53', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1055, '54', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1056, '55', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1057, '56', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1058, '57', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1059, '58', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1060, '59', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1061, '60', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1062, '61', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1063, '62', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1064, '63', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1065, '64', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1066, '65', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1067, '66', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1068, '67', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1069, '68', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1070, '69', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1071, '70', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1072, '71', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1073, '72', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1074, '73', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1075, '74', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1076, '75', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1077, '76', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1078, '77', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1079, '78', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1080, '79', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1081, '80', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1082, '81', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1083, '82', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1084, '83', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1085, '84', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1086, '85', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1087, '86', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1088, '87', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1089, '88', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1090, '89', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1091, '90', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1092, '91', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1093, '92', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1094, '93', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1095, '94', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1096, '95', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1097, '96', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1098, '97', '6', '2023', NULL, NULL, NULL, NULL, '1'),
(1099, '98', '6', '2023', NULL, NULL, NULL, NULL, '1');

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

--
-- Table structure for table `overtimerate`
--

CREATE TABLE `overtimerate` (
  `OvertimeId` int(11) NOT NULL,
  `WeekDaysRate` decimal(18,2) DEFAULT NULL,
  `SaturdayRate` decimal(18,2) DEFAULT NULL,
  `WeekEndHolRate` decimal(18,2) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `overtimerate`
--

INSERT INTO `overtimerate` (`OvertimeId`, `WeekDaysRate`, `SaturdayRate`, `WeekEndHolRate`, `CompanyId`, `status`) VALUES
(2, '1.50', '1.50', '2.00', '1', '1');

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `PaymentId` int(11) NOT NULL,
  `Payments` varchar(150) DEFAULT NULL,
  `PaymentType` varchar(50) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `rateChk` int(11) DEFAULT NULL,
  `Rate` decimal(16,2) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`PaymentId`, `Payments`, `PaymentType`, `CompanyId`, `rateChk`, `Rate`, `status`) VALUES
(1, 'HOUSING', 'Static', '1', 0, '0.00', '1'),
(2, 'HOUSING', 'Static', '1', 0, '0.00', '1'),
(10002, 'HOUSING', 'Static', '1', 0, '0.00', '1'),
(10003, 'HOUSING', 'Static', '1', 0, '0.00', '1'),
(10004, 'Test Dynamic', 'Dynamic', '1', 0, '0.00', '1'),
(10005, 'Test Dynamic Rate', 'Dynamic', '1', 1, '150.00', '1');

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

--
-- Table structure for table `payrollmonthyear`
--

CREATE TABLE `payrollmonthyear` (
  `Id` int(11) NOT NULL,
  `Month` decimal(18,0) DEFAULT NULL,
  `Year` decimal(18,0) DEFAULT NULL,
  `PurgeStatus` varchar(50) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `payrollmonthyear`
--

INSERT INTO `payrollmonthyear` (`Id`, `Month`, `Year`, `PurgeStatus`, `CompanyId`) VALUES
(1, '5', '2023', 'Y', '1'),
(2, '6', '2023', 'Y', '1'),
(3, '2', '2024', 'Y', '1'),
(5, '4', '2024', 'N', '1');

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

--
-- Table structure for table `pension`
--

CREATE TABLE `pension` (
  `PensionId` int(11) NOT NULL,
  `PensionName` varchar(50) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `pension`
--

INSERT INTO `pension` (`PensionId`, `PensionName`, `status`) VALUES
(1, 'NSSF', '1'),
(2, 'mysql pension testing', '1'),
(3, 'new pension june', '1');

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

--
-- Table structure for table `pensionreceipt`
--

CREATE TABLE `pensionreceipt` (
  `PensionRectId` decimal(18,0) NOT NULL,
  `PensionId` decimal(18,0) DEFAULT NULL,
  `PayrollMonth` decimal(18,0) DEFAULT NULL,
  `PayrollYear` decimal(18,0) DEFAULT NULL,
  `PaymentMode` int(11) DEFAULT NULL,
  `ChequeNo` varchar(50) DEFAULT NULL,
  `ChequeDate` date DEFAULT NULL,
  `BankId` decimal(18,0) DEFAULT NULL,
  `BranchId` decimal(18,0) DEFAULT NULL,
  `BranchBox` varchar(150) DEFAULT NULL,
  `PensionRecNo` varchar(50) DEFAULT NULL,
  `Amount` decimal(15,3) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `CreatedBy` decimal(18,0) DEFAULT NULL,
  `ModifiedBy` decimal(18,0) DEFAULT NULL,
  `CreatedDate` date DEFAULT NULL,
  `ModifiedDate` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `pensiontransfer`
--

CREATE TABLE `pensiontransfer` (
  `PensionTransferId` decimal(18,0) NOT NULL,
  `EmpId` decimal(18,0) NOT NULL,
  `OldPensionId` decimal(18,0) NOT NULL,
  `OldPensionNumber` decimal(18,0) NOT NULL,
  `NewPensionId` decimal(18,0) NOT NULL,
  `NewPensionNumber` decimal(18,0) NOT NULL,
  `TransferMonth` decimal(18,0) NOT NULL,
  `TransferYear` decimal(18,0) NOT NULL,
  `TransferDate` date NOT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

CREATE TABLE `permissions` (
  `Id` int(11) NOT NULL,
  `RoleId` decimal(18,0) NOT NULL,
  `MenuId` decimal(18,0) NOT NULL,
  `SubmenuId` decimal(18,0) NOT NULL,
  `MenuStatus` int(11) DEFAULT NULL,
  `SubmenuStatus` int(11) DEFAULT NULL,
  `can_view` int(11) DEFAULT NULL,
  `can_add` int(11) DEFAULT NULL,
  `can_edit` int(11) DEFAULT NULL,
  `can_delete` int(11) DEFAULT NULL,
  `can_assign` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `permissions` (`Id`, `RoleId`, `MenuId`, `SubmenuId`, `MenuStatus`, `SubmenuStatus`, `can_view`, `can_add`, `can_edit`, `can_delete`, `can_assign`) VALUES
(1, '1', '1', '1', 1, 1, 1, 1, 1, 1, 1),
(2, '1', '1', '2', 1, 1, 1, 1, 1, 1, NULL),
(3, '1', '1', '3', 1, 1, 1, 1, 1, 1, NULL),
(4, '1', '1', '4', 1, 1, 1, 1, 1, 1, NULL),
(5, '1', '1', '5', 1, 1, 1, 1, 1, 1, NULL),
(6, '1', '1', '6', 1, 1, 1, 1, 1, 1, NULL),
(7, '1', '1', '7', 1, 1, 1, 1, 1, 1, NULL),
(8, '1', '1', '8', 1, 1, 1, 1, 1, 1, NULL),
(9, '1', '1', '9', 1, 1, 1, 1, 1, 1, NULL),
(10, '1', '1', '10', 1, 1, 1, 1, 1, 1, NULL),
(11, '1', '1', '11', 1, 1, 1, 1, 1, 1, NULL),
(12, '1', '1', '12', 1, 1, 1, 1, 1, 1, NULL),
(13, '1', '1', '13', 1, 1, 1, 1, 1, 1, NULL),
(14, '1', '5', '51', 1, 1, 1, 1, 1, 1, NULL);

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

--
-- Table structure for table `processhistory`
--

CREATE TABLE `processhistory` (
  `ProcessHistoryId` decimal(18,0) NOT NULL,
  `PayrollMonth` decimal(18,0) DEFAULT NULL,
  `PayrollYear` decimal(18,0) DEFAULT NULL,
  `AttStartDate` date DEFAULT NULL,
  `AttEndDate` date DEFAULT NULL,
  `ProcessedBy` decimal(18,0) DEFAULT NULL,
  `ProcessedDate` datetime DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `processhistory`
--

INSERT INTO `processhistory` (`ProcessHistoryId`, `PayrollMonth`, `PayrollYear`, `AttStartDate`, `AttEndDate`, `ProcessedBy`, `ProcessedDate`, `CompanyId`) VALUES
('1', '5', '2023', '2023-01-05', '2023-01-06', '0', '2023-05-17 00:00:00', '1'),
('2', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-06-01 00:00:00', '1'),
('3', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-06-01 00:00:00', '1'),
('4', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-06-01 00:00:00', '1'),
('5', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-06-01 00:00:00', '1'),
('10005', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-06-05 00:00:00', '1'),
('10006', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-06-05 00:00:00', '1'),
('10007', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-06-05 00:00:00', '1'),
('10008', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-06-05 00:00:00', '1'),
('20005', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-06-15 00:00:00', '1'),
('30005', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-07-17 00:00:00', '1'),
('30006', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-07-18 00:00:00', '1'),
('30007', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-07-18 00:00:00', '1'),
('30008', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-07-18 00:00:00', '1'),
('40008', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-10 00:00:00', '1'),
('40009', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-10 00:00:00', '1'),
('40010', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-10 00:00:00', '1'),
('40011', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-11 00:00:00', '1'),
('40012', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-11 00:00:00', '1'),
('40013', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-12 00:00:00', '1'),
('40014', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-12 00:00:00', '1'),
('40015', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-12 00:00:00', '1'),
('40016', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-12 00:00:00', '1'),
('40017', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-12 00:00:00', '1'),
('40018', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-12 00:00:00', '1'),
('40019', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-12 00:00:00', '1'),
('40020', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-12 00:00:00', '1'),
('40021', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-17 00:00:00', '1'),
('40022', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-17 00:00:00', '1'),
('40023', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-17 00:00:00', '1'),
('50022', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-18 00:00:00', '1'),
('50023', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-18 00:00:00', '1'),
('50024', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-18 00:00:00', '1'),
('50025', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-31 00:00:00', '1'),
('50026', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-31 00:00:00', '1'),
('50027', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-31 00:00:00', '1'),
('50028', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-08-31 00:00:00', '1'),
('50029', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-09-04 00:00:00', '1'),
('50030', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-09-18 00:00:00', '1'),
('50031', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-09 00:00:00', '1'),
('50032', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-09 00:00:00', '1'),
('50033', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-09 00:00:00', '1'),
('50034', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-09 00:00:00', '1'),
('50035', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-09 00:00:00', '1'),
('60032', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-11 00:00:00', '1'),
('60033', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-11 00:00:00', '1'),
('60034', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-11 00:00:00', '1'),
('60035', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-11 00:00:00', '1'),
('70032', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-12 00:00:00', '1'),
('70033', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-12 00:00:00', '1'),
('80032', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-16 00:00:00', '1'),
('80033', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-16 00:00:00', '1'),
('80034', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-16 00:00:00', '1'),
('80035', '5', '2023', '2023-05-01', '2023-06-01', '1', '2023-10-25 00:00:00', '1');

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

--
-- Table structure for table `processmaster`
--

CREATE TABLE `processmaster` (
  `Id` decimal(18,0) NOT NULL,
  `PayrollMonth` decimal(18,0) DEFAULT NULL,
  `PayrollYear` decimal(18,0) DEFAULT NULL,
  `AttStartDate` date DEFAULT NULL,
  `AttEndDate` date DEFAULT NULL,
  `ProcessedBy` decimal(18,0) DEFAULT NULL,
  `ProcessedDate` datetime DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `processmaster`
--

INSERT INTO `processmaster` (`Id`, `PayrollMonth`, `PayrollYear`, `AttStartDate`, `AttEndDate`, `ProcessedBy`, `ProcessedDate`, `CompanyId`) VALUES
('80035', '5', '2023', '2023-01-05', '2023-01-06', '1', '2023-10-25 00:00:00', '1');

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

--
-- Table structure for table `qualification`
--

CREATE TABLE `qualification` (
  `Qualificationid` int(11) NOT NULL,
  `Qualificationname` varchar(100) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `qualification`
--

INSERT INTO `qualification` (`Qualificationid`, `Qualificationname`, `CompanyId`, `status`) VALUES
(1, 'certificate', '1', '0');

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

--
-- Table structure for table `religion`
--

CREATE TABLE `religion` (
  `ReligionId` int(11) NOT NULL,
  `Religion` longtext DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `religion`
--

INSERT INTO `religion` (`ReligionId`, `Religion`, `status`) VALUES
(1, 'ISLAM', NULL),
(2, 'CHRISTIAN', NULL),
(3, 'HINDU', NULL),
(4, 'testing religion test', '0');

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

--
-- Table structure for table `remindermonth`
--

CREATE TABLE `remindermonth` (
  `ReminderId` decimal(18,0) NOT NULL,
  `ContractReminderMonth` decimal(18,0) DEFAULT NULL,
  `ProbationReminderMonth` decimal(18,0) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `remindermonth`
--

INSERT INTO `remindermonth` (`ReminderId`, `ContractReminderMonth`, `ProbationReminderMonth`, `CompanyId`) VALUES
('1', '2', '1', '1');

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

--
-- Table structure for table `returnitems`
--

CREATE TABLE `returnitems` (
  `ReturnItemId` decimal(18,0) NOT NULL,
  `EmpId` decimal(18,0) DEFAULT NULL,
  `ReturnInventoryId` decimal(18,0) DEFAULT NULL,
  `ReturnStatus` varchar(50) DEFAULT NULL,
  `Remarks` longtext DEFAULT NULL,
  `ChkReplace` decimal(18,0) DEFAULT NULL,
  `ReplaceItemId` decimal(18,0) DEFAULT NULL,
  `ModelNo` varchar(50) DEFAULT NULL,
  `CreatedBy` decimal(18,0) DEFAULT NULL,
  `CreatedDate` date DEFAULT NULL,
  `ModifiedBy` decimal(18,0) DEFAULT NULL,
  `ModifiedDate` date DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

CREATE TABLE `rights` (
  `RightsId` decimal(8,0) NOT NULL,
  `RightsName` varchar(50) DEFAULT NULL,
  `ParentId` decimal(8,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `rights` (`RightsId`, `RightsName`, `ParentId`) VALUES
('1', 'ADMIN', '0'),
('2', 'Company Information', '1'),
('3', 'Nationality', '1'),
('4', 'Religion', '1'),
('5', 'Pension', '1'),
('6', 'Tax Table', '1'),
('7', 'Users', '1'),
('8', 'Department', '1'),
('9', 'Designation', '1'),
('10', 'Bank Details', '1'),
('11', 'Branch Details', '1'),
('12', 'Payments', '1'),
('13', 'Company Payments Details', '1'),
('14', 'Deductions', '1'),
('15', 'Leave Type', '1'),
('16', 'Loan Type', '1'),
('17', 'Office Timings', '1'),
('18', 'Shift Details', '1'),
('21', 'Overtime Rate', '1'),
('22', 'SDL%', '1'),
('23', 'Absent', '1'),
('24', 'Late', '1'),
('25', 'Formulas', '1'),
('26', 'Holidays', '1'),
('27', 'EMPLOYEE DETAILS', '0'),
('28', 'Employees', '27'),
('29', 'TRANSACTIONS', '0'),
('30', 'Loan Transactions', '29'),
('31', 'Loan Cash/Payment', '29'),
('32', 'Leave Transactions', '29'),
('33', 'Advance Transactions', '29'),
('34', 'Overtime', '29'),
('35', 'Absent/Late', '29'),
('36', 'Dynamic Payments/Deductions', '29'),
('37', 'Payroll Process', '29'),
('38', 'BIOMETRICS', '0'),
('39', 'Upload Employees', '38'),
('40', 'Download Attendance', '38'),
('41', 'Attendance Process', '38'),
('42', 'Attendance', '38'),
('43', 'PAYROLL REPORTS', '0'),
('44', 'Payslip', '43'),
('45', 'Salary Summary', '43'),
('46', 'Employee Details', '43'),
('47', 'Outstanding Loan Report', '43'),
('48', 'Monthly Report', '43'),
('49', 'UTILITIES', '0'),
('50', 'MonthEnd Purge', '49'),
('51', 'Cash Salary', '43'),
('52', 'Bank Salary', '43'),
('53', 'Bulk Salary Advance', '29'),
('56', 'Print ID', '49'),
('57', 'Leave Summary Report', '43'),
('59', 'NHIF', '1'),
('60', 'Deduction %', '1'),
('61', 'Payment Report', '43'),
('62', 'Deduction Report', '43'),
('63', 'Pension Receipt', '43'),
('64', 'Pension Accumulation', '43'),
('65', 'Netpay Forecast', '49'),
('66', 'WCF Previous Contribution', '49'),
('67', 'Journal Report', '43'),
('68', 'Basicpay Forecast', '49'),
('69', 'Employee Detailed Report', '43'),
('70', 'Employee Cost Report', '43'),
('71', 'Salary Departmentwise', '43'),
('72', 'Salary Summary Taxable/NonTaxable', '43'),
('73', 'Generate Detailed Salary Report', '43'),
('74', 'Print Detailed Salary Report', '43'),
('75', 'Yearly Reports', '43'),
('76', 'Other Leave Report', '43'),
('77', 'NHIF Excel Report', '43'),
('78', 'Deduction Contribution %', '1'),
('79', 'Prepare Contracts', '27'),
('80', 'Contract Clauses', '1'),
('81', 'Set Contract Reminder Month', '27'),
('82', 'DashBoard', '49'),
('83', 'Reminder Alert', '49'),
('84', 'WCF Excel Upload', '43'),
('85', 'HESLB Excel Upload', '43'),
('87', 'Email Setting', '1'),
('88', 'Email Payslip', '43'),
('89', 'Employee Pension Report', '43'),
('90', 'Employees OnHold', '43'),
('91', 'Employee Bank Details', '43'),
('92', 'Employee Multi-Bank Details', '43'),
('93', 'Bank Salary Verification', '43'),
('94', 'Bank Salary With MultiBanks', '43'),
('95', 'Employees Emails', '43'),
('96', 'Invalid Emails', '43'),
('97', 'Inactive Employees Emails', '43'),
('98', 'Employees Department', '43'),
('99', 'Rotation Shift', '27'),
('100', 'Daily Shift', '27'),
('101', 'Batchwise Shift', '27'),
('102', 'Leave Summary Yearly', '43'),
('103', 'Reset Leave', '49'),
('104', 'IsBenefit Payment', '43'),
('105', 'Employee Bank Details with Bank Code', '43'),
('106', 'Bank Code', '1'),
('107', 'Qualification', '1'),
('108', 'House Rate', '1'),
('109', 'WCFRate', '1'),
('110', 'Employee Inactive Report', '43'),
('111', 'Leave Detailed Report', '43'),
('112', 'Employee Contract Expiry Report', '43'),
('113', 'Employee Probation Expiry Reportt', '43'),
('114', 'Employee Guarantors Report', '43'),
('115', 'Employee Deductions Paid By Employer', '43'),
('116', 'Employee Deductions Paid By Employer - Monthly', '43'),
('117', 'Employee WithHolding Tax List', '43'),
('118', 'WithHolding Tax Rate', '1'),
('119', 'Employee Salary Report', '43'),
('120', 'WCF Annual Returns in Excel', '43'),
('121', 'Consultant Salary OnHold', '43'),
('122', 'Export to DTB Format', '43'),
('123', 'Export to SBC Format', '43'),
('124', 'Export to CRDB Format', '43'),
('125', 'Total Loan and Outstanding', '43'),
('126', 'Consultant Bank Fee- Departmentwise', '43'),
('127', 'TRA e-Filing', '43'),
('128', 'Tax Type', '1'),
('129', 'Main Division (Branch)', '1'),
('130', 'Sub Division', '1'),
('131', 'Payments with Rates', '1'),
('132', 'Termination Types', '1'),
('133', 'Dynamic Payments with Rate', '29'),
('134', 'Employee Tax Type Report', '43'),
('135', 'Managerial Report', '43'),
('136', 'Pension Accumulation Yearly', '43'),
('137', 'Salary Summary Main Division wise', '43'),
('138', 'Payment with Rates Report', '43'),
('139', 'Employee Main Division Report', '43'),
('140', 'Employee Type (Permenant or on Contract)', '43'),
('141', 'Employee Inactive with Inactive Dates', '43'),
('142', 'Employee Inactive Monthwise', '43'),
('143', 'Employee Cost to Company Departmentwise with Chart', '43'),
('144', 'Employee Cost to Company Main divisionwise', '43'),
('145', 'Employee Tin No', '43'),
('146', 'Employee Qualification', '43'),
('147', 'Employee Retirement', '43'),
('148', 'Salary Summary with NetPAYE', '43'),
('149', 'Cost Report Summarised', '43'),
('150', 'Consolidate Managerial Month Comparison Report', '43'),
('151', 'Admin Emails for Leave Portal', '1'),
('152', 'SMS Setting for Leave Portal', '1'),
('153', 'Loan Installment Change', '29'),
('154', 'Check for Image', '49'),
('155', 'Dashboard Monthly', '49'),
('156', 'Employee Cost Report - not with subdivision', '43'),
('157', 'NSSF Excel Upload', '43'),
('158', 'Employee Detailed Report - Revised', '43'),
('159', 'Casual Employees', '27'),
('160', 'Casual Transaction', '29'),
('161', 'Casual Reports', '43'),
('162', 'OT Upload', '29'),
('163', 'Absent/Late Upload', '29'),
('164', 'Dynamic Payment Upload', '29'),
('165', 'Employee Details Export to Excel', '43'),
('166', 'Export to ABSA Format', '43'),
('167', 'Export to FNB Format', '43'),
('168', 'Selected Bank Excel', '43'),
('169', 'Export to EXIM Format', '43'),
('170', 'Export to NBC Format', '43'),
('171', 'Export to NMB Format', '43'),
('172', 'Dynamic Deduction Upload', '29');

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

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

CREATE TABLE `roles` (
  `RoleId` int(11) NOT NULL,
  `RoleName` varchar(50) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `roles` (`RoleId`, `RoleName`, `status`, `CompanyId`) VALUES
(1, 'SuperUser', '1', '1'),
(2, 'Accountant', '1', '1'),
(3, 'Admin', '1', '2'),
(4, 'Accountant', '1', '1'),
(5, 'Admin', '1', '2'),
(6, 'Superadmin', '1', '1'),
(7, 'test', '1', '1');

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

--
-- Table structure for table `salaryfields`
--

CREATE TABLE `salaryfields` (
  `SalaryFieldId` decimal(18,0) NOT NULL,
  `EmpId` decimal(18,0) DEFAULT NULL,
  `PayrollMonth` decimal(18,0) DEFAULT NULL,
  `PayrollYear` decimal(18,0) DEFAULT NULL,
  `SalaryFieldName` varchar(190) DEFAULT NULL,
  `Amount` decimal(16,2) DEFAULT NULL,
  `No` decimal(18,0) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `salaryfields`
--

INSERT INTO `salaryfields` (`SalaryFieldId`, `EmpId`, `PayrollMonth`, `PayrollYear`, `SalaryFieldName`, `Amount`, `No`, `CompanyId`) VALUES
('16788', '1', '5', '2023', 'BASIC PAY', '557234.00', '1', '1'),
('16789', '1', '5', '2023', 'Allowance', '0.00', '2', '1'),
('16790', '1', '5', '2023', 'HOUSING', '83585.00', '3', '1'),
('16791', '1', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('16792', '1', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('16793', '1', '5', '2023', 'GROSS SALARY', '640819.00', '7', '1'),
('16794', '1', '5', '2023', 'NSSF', '64081.90', '8', '1'),
('16795', '1', '5', '2023', 'TAXABLE INCOME', '576737.10', '9', '1'),
('16796', '1', '5', '2023', 'PAYE', '31347.42', '10', '1'),
('16797', '1', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('16798', '1', '5', '2023', 'NHIF', '0.00', '12', '1'),
('16799', '1', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('16800', '1', '5', '2023', 'LATE', '0.00', '14', '1'),
('16801', '1', '5', '2023', 'Loan', '0.00', '15', '1'),
('16802', '1', '5', '2023', 'Other', '0.00', '16', '1'),
('16803', '1', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('16804', '1', '5', '2023', 'NETPAY', '545389.68', '20', '1'),
('16805', '2', '5', '2023', 'BASIC PAY', '223930.00', '1', '1'),
('16806', '2', '5', '2023', 'Allowance', '0.00', '2', '1'),
('16807', '2', '5', '2023', 'HOUSING', '33590.00', '3', '1'),
('16808', '2', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('16809', '2', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('16810', '2', '5', '2023', 'GROSS SALARY', '257520.00', '7', '1'),
('16811', '2', '5', '2023', 'NSSF', '25752.00', '8', '1'),
('16812', '2', '5', '2023', 'TAXABLE INCOME', '231768.00', '9', '1'),
('16813', '2', '5', '2023', 'PAYE', '0.00', '10', '1'),
('16814', '2', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('16815', '2', '5', '2023', 'NHIF', '0.00', '12', '1'),
('16816', '2', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('16817', '2', '5', '2023', 'LATE', '0.00', '14', '1'),
('16818', '2', '5', '2023', 'Loan', '0.00', '15', '1'),
('16819', '2', '5', '2023', 'Other', '0.00', '16', '1'),
('16820', '2', '5', '2023', 'STAFF LOAN', '60000.00', '18', '1'),
('16821', '2', '5', '2023', 'NETPAY', '171768.00', '20', '1'),
('16822', '3', '5', '2023', 'BASIC PAY', '1212677.00', '1', '1'),
('16823', '3', '5', '2023', 'Allowance', '0.00', '2', '1'),
('16824', '3', '5', '2023', 'HOUSING', '181902.00', '3', '1'),
('16825', '3', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('16826', '3', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('16827', '3', '5', '2023', 'GROSS SALARY', '1394579.00', '7', '1'),
('16828', '3', '5', '2023', 'NSSF', '139457.90', '8', '1'),
('16829', '3', '5', '2023', 'TAXABLE INCOME', '1255121.10', '9', '1'),
('16830', '3', '5', '2023', 'PAYE', '204536.33', '10', '1'),
('16831', '3', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('16832', '3', '5', '2023', 'NHIF', '0.00', '12', '1'),
('16833', '3', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('16834', '3', '5', '2023', 'LATE', '0.00', '14', '1'),
('16835', '3', '5', '2023', 'Loan', '0.00', '15', '1'),
('16836', '3', '5', '2023', 'Other', '0.00', '16', '1'),
('16837', '3', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('16838', '3', '5', '2023', 'NETPAY', '1050584.77', '20', '1'),
('16839', '4', '5', '2023', 'BASIC PAY', '3354633.00', '1', '1'),
('16840', '4', '5', '2023', 'Allowance', '0.00', '2', '1'),
('16841', '4', '5', '2023', 'HOUSING', '503195.00', '3', '1'),
('16842', '4', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('16843', '4', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('16844', '4', '5', '2023', 'GROSS SALARY', '3857828.00', '7', '1'),
('16845', '4', '5', '2023', 'NSSF', '385782.80', '8', '1'),
('16846', '4', '5', '2023', 'TAXABLE INCOME', '3472045.20', '9', '1'),
('16847', '4', '5', '2023', 'PAYE', '869613.56', '10', '1'),
('16848', '4', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('16849', '4', '5', '2023', 'NHIF', '0.00', '12', '1'),
('16850', '4', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('16851', '4', '5', '2023', 'LATE', '0.00', '14', '1'),
('16852', '4', '5', '2023', 'Loan', '0.00', '15', '1'),
('16853', '4', '5', '2023', 'Other', '0.00', '16', '1'),
('16854', '4', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('16855', '4', '5', '2023', 'NETPAY', '2602431.64', '20', '1'),
('16856', '5', '5', '2023', 'BASIC PAY', '537750.00', '1', '1'),
('16857', '5', '5', '2023', 'Allowance', '0.00', '2', '1'),
('16858', '5', '5', '2023', 'HOUSING', '80700.00', '3', '1'),
('16859', '5', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('16860', '5', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('16861', '5', '5', '2023', 'GROSS SALARY', '618450.00', '7', '1'),
('16862', '5', '5', '2023', 'NSSF', '61845.00', '8', '1'),
('16863', '5', '5', '2023', 'TAXABLE INCOME', '556605.00', '9', '1'),
('16864', '5', '5', '2023', 'PAYE', '27321.00', '10', '1'),
('16865', '5', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('16866', '5', '5', '2023', 'NHIF', '0.00', '12', '1'),
('16867', '5', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('16868', '5', '5', '2023', 'LATE', '0.00', '14', '1'),
('16869', '5', '5', '2023', 'Loan', '0.00', '15', '1'),
('16870', '5', '5', '2023', 'Other', '0.00', '16', '1'),
('16871', '5', '5', '2023', 'STAFF LOAN', '150000.00', '18', '1'),
('16872', '5', '5', '2023', 'NETPAY', '379284.00', '20', '1'),
('16873', '6', '5', '2023', 'BASIC PAY', '0.00', '1', '1'),
('16874', '6', '5', '2023', 'Allowance', '0.00', '2', '1'),
('16875', '6', '5', '2023', 'HOUSING', '0.00', '3', '1'),
('16876', '6', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('16877', '6', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('16878', '6', '5', '2023', 'GROSS SALARY', '0.00', '7', '1'),
('16879', '6', '5', '2023', 'NSSF', '0.00', '8', '1'),
('16880', '6', '5', '2023', 'TAXABLE INCOME', '0.00', '9', '1'),
('16881', '6', '5', '2023', 'PAYE', '0.00', '10', '1'),
('16882', '6', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('16883', '6', '5', '2023', 'NHIF', '0.00', '12', '1'),
('16884', '6', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('16885', '6', '5', '2023', 'LATE', '0.00', '14', '1'),
('16886', '6', '5', '2023', 'Loan', '0.00', '15', '1'),
('16887', '6', '5', '2023', 'Other', '0.00', '16', '1'),
('16888', '6', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('16889', '6', '5', '2023', 'NETPAY', '0.00', '20', '1'),
('16890', '7', '5', '2023', 'BASIC PAY', '14534600.00', '1', '1'),
('16891', '7', '5', '2023', 'Allowance', '0.00', '2', '1'),
('16892', '7', '5', '2023', 'HOUSING', '2180190.00', '3', '1'),
('16893', '7', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('16894', '7', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('16895', '7', '5', '2023', 'GROSS SALARY', '16714790.00', '7', '1'),
('16896', '7', '5', '2023', 'NSSF', '0.00', '8', '1'),
('16897', '7', '5', '2023', 'TAXABLE INCOME', '16714790.00', '9', '1'),
('16898', '7', '5', '2023', 'PAYE', '4842437.00', '10', '1'),
('16899', '7', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('16900', '7', '5', '2023', 'NHIF', '0.00', '12', '1'),
('16901', '7', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('16902', '7', '5', '2023', 'LATE', '0.00', '14', '1'),
('16903', '7', '5', '2023', 'Loan', '0.00', '15', '1'),
('16904', '7', '5', '2023', 'Other', '0.00', '16', '1'),
('16905', '7', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('16906', '7', '5', '2023', 'NETPAY', '11872353.00', '20', '1'),
('16907', '8', '5', '2023', 'BASIC PAY', '5641892.00', '1', '1'),
('16908', '8', '5', '2023', 'Allowance', '0.00', '2', '1'),
('16909', '8', '5', '2023', 'HOUSING', '846284.00', '3', '1'),
('16910', '8', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('16911', '8', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('16912', '8', '5', '2023', 'GROSS SALARY', '6488176.00', '7', '1'),
('16913', '8', '5', '2023', 'NSSF', '648817.60', '8', '1'),
('16914', '8', '5', '2023', 'TAXABLE INCOME', '5839358.40', '9', '1'),
('16915', '8', '5', '2023', 'PAYE', '1579807.52', '10', '1'),
('16916', '8', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('16917', '8', '5', '2023', 'NHIF', '0.00', '12', '1'),
('16918', '8', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('16919', '8', '5', '2023', 'LATE', '0.00', '14', '1'),
('16920', '8', '5', '2023', 'Loan', '0.00', '15', '1'),
('16921', '8', '5', '2023', 'Other', '0.00', '16', '1'),
('16922', '8', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('16923', '8', '5', '2023', 'NETPAY', '4259550.88', '20', '1'),
('16924', '9', '5', '2023', 'BASIC PAY', '258551.00', '1', '1'),
('16925', '9', '5', '2023', 'Allowance', '0.00', '2', '1'),
('16926', '9', '5', '2023', 'HOUSING', '38783.00', '3', '1'),
('16927', '9', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('16928', '9', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('16929', '9', '5', '2023', 'GROSS SALARY', '297334.00', '7', '1'),
('16930', '9', '5', '2023', 'NSSF', '29733.40', '8', '1'),
('16931', '9', '5', '2023', 'TAXABLE INCOME', '267600.60', '9', '1'),
('16932', '9', '5', '2023', 'PAYE', '0.00', '10', '1'),
('16933', '9', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('16934', '9', '5', '2023', 'NHIF', '0.00', '12', '1'),
('16935', '9', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('16936', '9', '5', '2023', 'LATE', '0.00', '14', '1'),
('16937', '9', '5', '2023', 'Loan', '0.00', '15', '1'),
('16938', '9', '5', '2023', 'Other', '0.00', '16', '1'),
('16939', '9', '5', '2023', 'STAFF LOAN', '100000.00', '18', '1'),
('16940', '9', '5', '2023', 'NETPAY', '167600.60', '20', '1'),
('16941', '10', '5', '2023', 'BASIC PAY', '331476.00', '1', '1'),
('16942', '10', '5', '2023', 'Allowance', '0.00', '2', '1'),
('16943', '10', '5', '2023', 'HOUSING', '49721.00', '3', '1'),
('16944', '10', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('16945', '10', '5', '2023', 'OVERTIME', '55449.99', '6', '1'),
('16946', '10', '5', '2023', 'GROSS SALARY', '436646.99', '7', '1'),
('16947', '10', '5', '2023', 'NSSF', '43664.70', '8', '1'),
('16948', '10', '5', '2023', 'TAXABLE INCOME', '392982.29', '9', '1'),
('16949', '10', '5', '2023', 'PAYE', '9838.58', '10', '1'),
('16950', '10', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('16951', '10', '5', '2023', 'NHIF', '0.00', '12', '1'),
('16952', '10', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('16953', '10', '5', '2023', 'LATE', '0.00', '14', '1'),
('16954', '10', '5', '2023', 'Loan', '0.00', '15', '1'),
('16955', '10', '5', '2023', 'Other', '0.00', '16', '1'),
('16956', '10', '5', '2023', 'STAFF LOAN', '80000.00', '18', '1'),
('16957', '10', '5', '2023', 'NETPAY', '203143.70', '20', '1'),
('16958', '11', '5', '2023', 'BASIC PAY', '226387.00', '1', '1'),
('16959', '11', '5', '2023', 'Allowance', '0.00', '2', '1'),
('16960', '11', '5', '2023', 'HOUSING', '33958.00', '3', '1'),
('16961', '11', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('16962', '11', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('16963', '11', '5', '2023', 'GROSS SALARY', '260345.00', '7', '1'),
('16964', '11', '5', '2023', 'NSSF', '26034.50', '8', '1'),
('16965', '11', '5', '2023', 'TAXABLE INCOME', '234310.50', '9', '1'),
('16966', '11', '5', '2023', 'PAYE', '0.00', '10', '1'),
('16967', '11', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('16968', '11', '5', '2023', 'NHIF', '0.00', '12', '1'),
('16969', '11', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('16970', '11', '5', '2023', 'LATE', '0.00', '14', '1'),
('16971', '11', '5', '2023', 'Loan', '0.00', '15', '1'),
('16972', '11', '5', '2023', 'Other', '0.00', '16', '1'),
('16973', '11', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('16974', '11', '5', '2023', 'NETPAY', '234310.50', '20', '1'),
('16975', '12', '5', '2023', 'BASIC PAY', '439730.00', '1', '1'),
('16976', '12', '5', '2023', 'Allowance', '34722.00', '2', '1'),
('16977', '12', '5', '2023', 'HOUSING', '65960.00', '3', '1'),
('16978', '12', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('16979', '12', '5', '2023', 'OVERTIME', '36080.41', '6', '1'),
('16980', '12', '5', '2023', 'GROSS SALARY', '576492.41', '7', '1'),
('16981', '12', '5', '2023', 'NSSF', '57649.24', '8', '1'),
('16982', '12', '5', '2023', 'TAXABLE INCOME', '518843.17', '9', '1'),
('16983', '12', '5', '2023', 'PAYE', '19907.45', '10', '1'),
('16984', '12', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('16985', '12', '5', '2023', 'NHIF', '0.00', '12', '1'),
('16986', '12', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('16987', '12', '5', '2023', 'LATE', '0.00', '14', '1'),
('16988', '12', '5', '2023', 'Loan', '0.00', '15', '1'),
('16989', '12', '5', '2023', 'Other', '0.00', '16', '1'),
('16990', '12', '5', '2023', 'STAFF LOAN', '50000.00', '18', '1'),
('16991', '12', '5', '2023', 'NETPAY', '348935.72', '20', '1'),
('16992', '13', '5', '2023', 'BASIC PAY', '4593513.00', '1', '1'),
('16993', '13', '5', '2023', 'Allowance', '0.00', '2', '1'),
('16994', '13', '5', '2023', 'HOUSING', '689027.00', '3', '1'),
('16995', '13', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('16996', '13', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('16997', '13', '5', '2023', 'GROSS SALARY', '5282540.00', '7', '1'),
('16998', '13', '5', '2023', 'NSSF', '528254.00', '8', '1'),
('16999', '13', '5', '2023', 'TAXABLE INCOME', '4754286.00', '9', '1'),
('17000', '13', '5', '2023', 'PAYE', '1254285.80', '10', '1'),
('17001', '13', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17002', '13', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17003', '13', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17004', '13', '5', '2023', 'LATE', '0.00', '14', '1'),
('17005', '13', '5', '2023', 'Loan', '0.00', '15', '1'),
('17006', '13', '5', '2023', 'Other', '0.00', '16', '1'),
('17007', '13', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17008', '13', '5', '2023', 'NETPAY', '3500000.20', '20', '1'),
('17009', '14', '5', '2023', 'BASIC PAY', '621527.00', '1', '1'),
('17010', '14', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17011', '14', '5', '2023', 'HOUSING', '93229.00', '3', '1'),
('17012', '14', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17013', '14', '5', '2023', 'OVERTIME', '237917.35', '6', '1'),
('17014', '14', '5', '2023', 'GROSS SALARY', '952673.35', '7', '1'),
('17015', '14', '5', '2023', 'NSSF', '95267.34', '8', '1'),
('17016', '14', '5', '2023', 'TAXABLE INCOME', '857406.01', '9', '1'),
('17017', '14', '5', '2023', 'PAYE', '92351.50', '10', '1'),
('17018', '14', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17019', '14', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17020', '14', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17021', '14', '5', '2023', 'LATE', '0.00', '14', '1'),
('17022', '14', '5', '2023', 'Loan', '0.00', '15', '1'),
('17023', '14', '5', '2023', 'Other', '0.00', '16', '1'),
('17024', '14', '5', '2023', 'STAFF LOAN', '170000.00', '18', '1'),
('17025', '14', '5', '2023', 'NETPAY', '495054.51', '20', '1'),
('17026', '15', '5', '2023', 'BASIC PAY', '1043478.00', '1', '1'),
('17027', '15', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17028', '15', '5', '2023', 'HOUSING', '156522.00', '3', '1'),
('17029', '15', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17030', '15', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17031', '15', '5', '2023', 'GROSS SALARY', '1200000.00', '7', '1'),
('17032', '15', '5', '2023', 'NSSF', '120000.00', '8', '1'),
('17033', '15', '5', '2023', 'TAXABLE INCOME', '1080000.00', '9', '1'),
('17034', '15', '5', '2023', 'PAYE', '152000.00', '10', '1'),
('17035', '15', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17036', '15', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17037', '15', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17038', '15', '5', '2023', 'LATE', '0.00', '14', '1'),
('17039', '15', '5', '2023', 'Loan', '0.00', '15', '1'),
('17040', '15', '5', '2023', 'Other', '0.00', '16', '1'),
('17041', '15', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17042', '15', '5', '2023', 'NETPAY', '928000.00', '20', '1'),
('17043', '16', '5', '2023', 'BASIC PAY', '254990.00', '1', '1'),
('17044', '16', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17045', '16', '5', '2023', 'HOUSING', '38249.00', '3', '1'),
('17046', '16', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17047', '16', '5', '2023', 'OVERTIME', '43864.82', '6', '1'),
('17048', '16', '5', '2023', 'GROSS SALARY', '337103.82', '7', '1'),
('17049', '16', '5', '2023', 'NSSF', '33710.38', '8', '1'),
('17050', '16', '5', '2023', 'TAXABLE INCOME', '303393.44', '9', '1'),
('17051', '16', '5', '2023', 'PAYE', '2671.48', '10', '1'),
('17052', '16', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17053', '16', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17054', '16', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17055', '16', '5', '2023', 'LATE', '0.00', '14', '1'),
('17056', '16', '5', '2023', 'Loan', '0.00', '15', '1'),
('17057', '16', '5', '2023', 'Other', '0.00', '16', '1'),
('17058', '16', '5', '2023', 'STAFF LOAN', '40000.00', '18', '1'),
('17059', '16', '5', '2023', 'NETPAY', '160721.96', '20', '1'),
('17060', '17', '5', '2023', 'BASIC PAY', '391403.00', '1', '1'),
('17061', '17', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17062', '17', '5', '2023', 'HOUSING', '58710.00', '3', '1'),
('17063', '17', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17064', '17', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17065', '17', '5', '2023', 'GROSS SALARY', '450113.00', '7', '1'),
('17066', '17', '5', '2023', 'NSSF', '45011.30', '8', '1'),
('17067', '17', '5', '2023', 'TAXABLE INCOME', '405101.70', '9', '1'),
('17068', '17', '5', '2023', 'PAYE', '10808.14', '10', '1'),
('17069', '17', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17070', '17', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17071', '17', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17072', '17', '5', '2023', 'LATE', '0.00', '14', '1'),
('17073', '17', '5', '2023', 'Loan', '0.00', '15', '1'),
('17074', '17', '5', '2023', 'Other', '0.00', '16', '1'),
('17075', '17', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17076', '17', '5', '2023', 'NETPAY', '394293.56', '20', '1'),
('17077', '18', '5', '2023', 'BASIC PAY', '319432.00', '1', '1'),
('17078', '18', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17079', '18', '5', '2023', 'HOUSING', '47915.00', '3', '1'),
('17080', '18', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17081', '18', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17082', '18', '5', '2023', 'GROSS SALARY', '367347.00', '7', '1'),
('17083', '18', '5', '2023', 'NSSF', '32496.08', '8', '1'),
('17084', '18', '5', '2023', 'TAXABLE INCOME', '292464.73', '9', '1'),
('17085', '18', '5', '2023', 'PAYE', '1797.18', '10', '1'),
('17086', '18', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17087', '18', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17088', '18', '5', '2023', 'ABSENT', '42386.19', '13', '1'),
('17089', '18', '5', '2023', 'LATE', '0.00', '14', '1'),
('17090', '18', '5', '2023', 'Loan', '0.00', '15', '1'),
('17091', '18', '5', '2023', 'Other', '0.00', '16', '1'),
('17092', '18', '5', '2023', 'STAFF LOAN', '80000.00', '18', '1'),
('17093', '18', '5', '2023', 'NETPAY', '110667.55', '20', '1'),
('17094', '19', '5', '2023', 'BASIC PAY', '214081.00', '1', '1'),
('17095', '19', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17096', '19', '5', '2023', 'HOUSING', '32112.00', '3', '1'),
('17097', '19', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17098', '19', '5', '2023', 'OVERTIME', '24915.74', '6', '1'),
('17099', '19', '5', '2023', 'GROSS SALARY', '271108.74', '7', '1'),
('17100', '19', '5', '2023', 'NSSF', '27110.87', '8', '1'),
('17101', '19', '5', '2023', 'TAXABLE INCOME', '243997.86', '9', '1'),
('17102', '19', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17103', '19', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17104', '19', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17105', '19', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17106', '19', '5', '2023', 'LATE', '0.00', '14', '1'),
('17107', '19', '5', '2023', 'Loan', '0.00', '15', '1'),
('17108', '19', '5', '2023', 'Other', '0.00', '16', '1'),
('17109', '19', '5', '2023', 'STAFF LOAN', '30000.00', '18', '1'),
('17110', '19', '5', '2023', 'NETPAY', '213997.86', '20', '1'),
('17111', '20', '5', '2023', 'BASIC PAY', '6000000.00', '1', '1'),
('17112', '20', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17113', '20', '5', '2023', 'HOUSING', '900000.00', '3', '1'),
('17114', '20', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17115', '20', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17116', '20', '5', '2023', 'GROSS SALARY', '6900000.00', '7', '1'),
('17117', '20', '5', '2023', 'NSSF', '690000.00', '8', '1'),
('17118', '20', '5', '2023', 'TAXABLE INCOME', '6210000.00', '9', '1'),
('17119', '20', '5', '2023', 'PAYE', '1691000.00', '10', '1'),
('17120', '20', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17121', '20', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17122', '20', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17123', '20', '5', '2023', 'LATE', '0.00', '14', '1'),
('17124', '20', '5', '2023', 'Loan', '0.00', '15', '1'),
('17125', '20', '5', '2023', 'Other', '0.00', '16', '1'),
('17126', '20', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17127', '20', '5', '2023', 'NETPAY', '4519000.00', '20', '1'),
('17128', '21', '5', '2023', 'BASIC PAY', '1789193.00', '1', '1'),
('17129', '21', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17130', '21', '5', '2023', 'HOUSING', '0.00', '3', '1'),
('17131', '21', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17132', '21', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17133', '21', '5', '2023', 'GROSS SALARY', '1789193.00', '7', '1'),
('17134', '21', '5', '2023', 'NSSF', '178919.30', '8', '1'),
('17135', '21', '5', '2023', 'TAXABLE INCOME', '1610273.70', '9', '1'),
('17136', '21', '5', '2023', 'PAYE', '311082.11', '10', '1'),
('17137', '21', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17138', '21', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17139', '21', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17140', '21', '5', '2023', 'LATE', '0.00', '14', '1'),
('17141', '21', '5', '2023', 'Loan', '0.00', '15', '1'),
('17142', '21', '5', '2023', 'Other', '0.00', '16', '1'),
('17143', '21', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17144', '21', '5', '2023', 'NETPAY', '1299191.59', '20', '1'),
('17145', '22', '5', '2023', 'BASIC PAY', '286770.00', '1', '1'),
('17146', '22', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17147', '22', '5', '2023', 'HOUSING', '43016.00', '3', '1'),
('17148', '22', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17149', '22', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17150', '22', '5', '2023', 'GROSS SALARY', '329786.00', '7', '1'),
('17151', '22', '5', '2023', 'NSSF', '32978.60', '8', '1'),
('17152', '22', '5', '2023', 'TAXABLE INCOME', '296807.40', '9', '1'),
('17153', '22', '5', '2023', 'PAYE', '2144.59', '10', '1'),
('17154', '22', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17155', '22', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17156', '22', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17157', '22', '5', '2023', 'LATE', '0.00', '14', '1'),
('17158', '22', '5', '2023', 'Loan', '0.00', '15', '1'),
('17159', '22', '5', '2023', 'Other', '0.00', '16', '1'),
('17160', '22', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17161', '22', '5', '2023', 'NETPAY', '294662.81', '20', '1'),
('17162', '23', '5', '2023', 'BASIC PAY', '662324.00', '1', '1'),
('17163', '23', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17164', '23', '5', '2023', 'HOUSING', '99349.00', '3', '1'),
('17165', '23', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17166', '23', '5', '2023', 'OVERTIME', '134502.72', '6', '1'),
('17167', '23', '5', '2023', 'GROSS SALARY', '896175.72', '7', '1'),
('17168', '23', '5', '2023', 'NSSF', '89617.57', '8', '1'),
('17169', '23', '5', '2023', 'TAXABLE INCOME', '806558.15', '9', '1'),
('17170', '23', '5', '2023', 'PAYE', '79639.54', '10', '1'),
('17171', '23', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17172', '23', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17173', '23', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17174', '23', '5', '2023', 'LATE', '0.00', '14', '1'),
('17175', '23', '5', '2023', 'Loan', '0.00', '15', '1'),
('17176', '23', '5', '2023', 'Other', '0.00', '16', '1'),
('17177', '23', '5', '2023', 'STAFF LOAN', '190000.00', '18', '1'),
('17178', '23', '5', '2023', 'NETPAY', '536918.61', '20', '1'),
('17179', '24', '5', '2023', 'BASIC PAY', '0.00', '1', '1'),
('17180', '24', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17181', '24', '5', '2023', 'HOUSING', '0.00', '3', '1'),
('17182', '24', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17183', '24', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17184', '24', '5', '2023', 'GROSS SALARY', '0.00', '7', '1'),
('17185', '24', '5', '2023', 'NSSF', '0.00', '8', '1'),
('17186', '24', '5', '2023', 'TAXABLE INCOME', '0.00', '9', '1'),
('17187', '24', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17188', '24', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17189', '24', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17190', '24', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17191', '24', '5', '2023', 'LATE', '0.00', '14', '1'),
('17192', '24', '5', '2023', 'Loan', '0.00', '15', '1'),
('17193', '24', '5', '2023', 'Other', '0.00', '16', '1'),
('17194', '24', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17195', '24', '5', '2023', 'NETPAY', '0.00', '20', '1'),
('17196', '25', '5', '2023', 'BASIC PAY', '173913.00', '1', '1'),
('17197', '25', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17198', '25', '5', '2023', 'HOUSING', '26087.00', '3', '1'),
('17199', '25', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17200', '25', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17201', '25', '5', '2023', 'GROSS SALARY', '200000.00', '7', '1'),
('17202', '25', '5', '2023', 'NSSF', '20000.00', '8', '1'),
('17203', '25', '5', '2023', 'TAXABLE INCOME', '180000.00', '9', '1'),
('17204', '25', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17205', '25', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17206', '25', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17207', '25', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17208', '25', '5', '2023', 'LATE', '0.00', '14', '1'),
('17209', '25', '5', '2023', 'Loan', '0.00', '15', '1'),
('17210', '25', '5', '2023', 'Other', '0.00', '16', '1'),
('17211', '25', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17212', '25', '5', '2023', 'NETPAY', '180000.00', '20', '1'),
('17213', '26', '5', '2023', 'BASIC PAY', '3543322.00', '1', '1'),
('17214', '26', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17215', '26', '5', '2023', 'HOUSING', '625293.00', '3', '1'),
('17216', '26', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17217', '26', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17218', '26', '5', '2023', 'GROSS SALARY', '4168615.00', '7', '1'),
('17219', '26', '5', '2023', 'NSSF', '416861.50', '8', '1'),
('17220', '26', '5', '2023', 'TAXABLE INCOME', '3751753.50', '9', '1'),
('17221', '26', '5', '2023', 'PAYE', '953526.05', '10', '1'),
('17222', '26', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17223', '26', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17224', '26', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17225', '26', '5', '2023', 'LATE', '0.00', '14', '1'),
('17226', '26', '5', '2023', 'Loan', '0.00', '15', '1'),
('17227', '26', '5', '2023', 'Other', '0.00', '16', '1'),
('17228', '26', '5', '2023', 'STAFF LOAN', '1000000.00', '18', '1'),
('17229', '26', '5', '2023', 'NETPAY', '1798227.45', '20', '1'),
('17230', '27', '5', '2023', 'BASIC PAY', '240000.00', '1', '1'),
('17231', '27', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17232', '27', '5', '2023', 'HOUSING', '36000.00', '3', '1'),
('17233', '27', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17234', '27', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17235', '27', '5', '2023', 'GROSS SALARY', '276000.00', '7', '1'),
('17236', '27', '5', '2023', 'NSSF', '27600.00', '8', '1'),
('17237', '27', '5', '2023', 'TAXABLE INCOME', '248400.00', '9', '1'),
('17238', '27', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17239', '27', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17240', '27', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17241', '27', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17242', '27', '5', '2023', 'LATE', '0.00', '14', '1'),
('17243', '27', '5', '2023', 'Loan', '0.00', '15', '1'),
('17244', '27', '5', '2023', 'Other', '0.00', '16', '1'),
('17245', '27', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17246', '27', '5', '2023', 'NETPAY', '248400.00', '20', '1'),
('17247', '28', '5', '2023', 'BASIC PAY', '254990.00', '1', '1'),
('17248', '28', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17249', '28', '5', '2023', 'HOUSING', '38249.00', '3', '1'),
('17250', '28', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17251', '28', '5', '2023', 'OVERTIME', '73345.59', '6', '1'),
('17252', '28', '5', '2023', 'GROSS SALARY', '366584.59', '7', '1'),
('17253', '28', '5', '2023', 'NSSF', '36658.46', '8', '1'),
('17254', '28', '5', '2023', 'TAXABLE INCOME', '329926.13', '9', '1'),
('17255', '28', '5', '2023', 'PAYE', '4794.09', '10', '1'),
('17256', '28', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17257', '28', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17258', '28', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17259', '28', '5', '2023', 'LATE', '0.00', '14', '1'),
('17260', '28', '5', '2023', 'Loan', '0.00', '15', '1'),
('17261', '28', '5', '2023', 'Other', '0.00', '16', '1'),
('17262', '28', '5', '2023', 'STAFF LOAN', '50000.00', '18', '1'),
('17263', '28', '5', '2023', 'NETPAY', '175132.04', '20', '1'),
('17264', '29', '5', '2023', 'BASIC PAY', '950257.00', '1', '1'),
('17265', '29', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17266', '29', '5', '2023', 'HOUSING', '142539.00', '3', '1'),
('17267', '29', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17268', '29', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17269', '29', '5', '2023', 'GROSS SALARY', '1092796.00', '7', '1'),
('17270', '29', '5', '2023', 'NSSF', '109279.60', '8', '1'),
('17271', '29', '5', '2023', 'TAXABLE INCOME', '983516.40', '9', '1'),
('17272', '29', '5', '2023', 'PAYE', '123879.10', '10', '1'),
('17273', '29', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17274', '29', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17275', '29', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17276', '29', '5', '2023', 'LATE', '0.00', '14', '1'),
('17277', '29', '5', '2023', 'Loan', '0.00', '15', '1'),
('17278', '29', '5', '2023', 'Other', '0.00', '16', '1'),
('17279', '29', '5', '2023', 'STAFF LOAN', '80000.00', '18', '1'),
('17280', '29', '5', '2023', 'NETPAY', '779637.30', '20', '1'),
('17281', '30', '5', '2023', 'BASIC PAY', '222940.00', '1', '1'),
('17282', '30', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17283', '30', '5', '2023', 'HOUSING', '33441.00', '3', '1'),
('17284', '30', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17285', '30', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17286', '30', '5', '2023', 'GROSS SALARY', '256381.00', '7', '1'),
('17287', '30', '5', '2023', 'NSSF', '25638.10', '8', '1'),
('17288', '30', '5', '2023', 'TAXABLE INCOME', '230742.90', '9', '1'),
('17289', '30', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17290', '30', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17291', '30', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17292', '30', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17293', '30', '5', '2023', 'LATE', '0.00', '14', '1'),
('17294', '30', '5', '2023', 'Loan', '0.00', '15', '1'),
('17295', '30', '5', '2023', 'Other', '0.00', '16', '1'),
('17296', '30', '5', '2023', 'STAFF LOAN', '50000.00', '18', '1'),
('17297', '30', '5', '2023', 'NETPAY', '180742.90', '20', '1'),
('17298', '31', '5', '2023', 'BASIC PAY', '1043478.00', '1', '1'),
('17299', '31', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17300', '31', '5', '2023', 'HOUSING', '156522.00', '3', '1'),
('17301', '31', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17302', '31', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17303', '31', '5', '2023', 'GROSS SALARY', '1200000.00', '7', '1'),
('17304', '31', '5', '2023', 'NSSF', '120000.00', '8', '1'),
('17305', '31', '5', '2023', 'TAXABLE INCOME', '1080000.00', '9', '1'),
('17306', '31', '5', '2023', 'PAYE', '152000.00', '10', '1'),
('17307', '31', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17308', '31', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17309', '31', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17310', '31', '5', '2023', 'LATE', '0.00', '14', '1'),
('17311', '31', '5', '2023', 'Loan', '0.00', '15', '1'),
('17312', '31', '5', '2023', 'Other', '0.00', '16', '1'),
('17313', '31', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17314', '31', '5', '2023', 'NETPAY', '928000.00', '20', '1'),
('17315', '32', '5', '2023', 'BASIC PAY', '0.00', '1', '1'),
('17316', '32', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17317', '32', '5', '2023', 'HOUSING', '0.00', '3', '1'),
('17318', '32', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17319', '32', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17320', '32', '5', '2023', 'GROSS SALARY', '0.00', '7', '1'),
('17321', '32', '5', '2023', 'NSSF', '0.00', '8', '1'),
('17322', '32', '5', '2023', 'TAXABLE INCOME', '0.00', '9', '1'),
('17323', '32', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17324', '32', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17325', '32', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17326', '32', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17327', '32', '5', '2023', 'LATE', '0.00', '14', '1'),
('17328', '32', '5', '2023', 'Loan', '0.00', '15', '1'),
('17329', '32', '5', '2023', 'Other', '0.00', '16', '1'),
('17330', '32', '5', '2023', 'STAFF LOAN', '100000.00', '18', '1'),
('17331', '32', '5', '2023', 'NETPAY', '-100000.00', '20', '1'),
('17332', '33', '5', '2023', 'BASIC PAY', '254990.00', '1', '1'),
('17333', '33', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17334', '33', '5', '2023', 'HOUSING', '38249.00', '3', '1'),
('17335', '33', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17336', '33', '5', '2023', 'OVERTIME', '42151.81', '6', '1'),
('17337', '33', '5', '2023', 'GROSS SALARY', '335390.81', '7', '1'),
('17338', '33', '5', '2023', 'NSSF', '33539.08', '8', '1'),
('17339', '33', '5', '2023', 'TAXABLE INCOME', '301851.73', '9', '1'),
('17340', '33', '5', '2023', 'PAYE', '2548.14', '10', '1'),
('17341', '33', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17342', '33', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17343', '33', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17344', '33', '5', '2023', 'LATE', '0.00', '14', '1'),
('17345', '33', '5', '2023', 'Loan', '0.00', '15', '1'),
('17346', '33', '5', '2023', 'Other', '0.00', '16', '1'),
('17347', '33', '5', '2023', 'STAFF LOAN', '40000.00', '18', '1'),
('17348', '33', '5', '2023', 'NETPAY', '159303.59', '20', '1'),
('17349', '34', '5', '2023', 'BASIC PAY', '345041.00', '1', '1'),
('17350', '34', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17351', '34', '5', '2023', 'HOUSING', '51756.00', '3', '1'),
('17352', '34', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17353', '34', '5', '2023', 'OVERTIME', '463478.54', '6', '1'),
('17354', '34', '5', '2023', 'GROSS SALARY', '860275.54', '7', '1'),
('17355', '34', '5', '2023', 'NSSF', '86027.55', '8', '1'),
('17356', '34', '5', '2023', 'TAXABLE INCOME', '774247.98', '9', '1'),
('17357', '34', '5', '2023', 'PAYE', '71562.00', '10', '1'),
('17358', '34', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17359', '34', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17360', '34', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17361', '34', '5', '2023', 'LATE', '0.00', '14', '1'),
('17362', '34', '5', '2023', 'Loan', '0.00', '15', '1'),
('17363', '34', '5', '2023', 'Other', '0.00', '16', '1'),
('17364', '34', '5', '2023', 'STAFF LOAN', '70000.00', '18', '1'),
('17365', '34', '5', '2023', 'NETPAY', '532685.99', '20', '1'),
('17366', '35', '5', '2023', 'BASIC PAY', '322447.00', '1', '1'),
('17367', '35', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17368', '35', '5', '2023', 'HOUSING', '48367.00', '3', '1'),
('17369', '35', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17370', '35', '5', '2023', 'OVERTIME', '161777.45', '6', '1'),
('17371', '35', '5', '2023', 'GROSS SALARY', '532591.45', '7', '1'),
('17372', '35', '5', '2023', 'NSSF', '53259.15', '8', '1'),
('17373', '35', '5', '2023', 'TAXABLE INCOME', '479332.30', '9', '1'),
('17374', '35', '5', '2023', 'PAYE', '16746.58', '10', '1'),
('17375', '35', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17376', '35', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17377', '35', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17378', '35', '5', '2023', 'LATE', '0.00', '14', '1'),
('17379', '35', '5', '2023', 'Loan', '0.00', '15', '1'),
('17380', '35', '5', '2023', 'Other', '0.00', '16', '1'),
('17381', '35', '5', '2023', 'STAFF LOAN', '25000.00', '18', '1'),
('17382', '35', '5', '2023', 'NETPAY', '337585.72', '20', '1'),
('17383', '36', '5', '2023', 'BASIC PAY', '0.00', '1', '1'),
('17384', '36', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17385', '36', '5', '2023', 'HOUSING', '0.00', '3', '1'),
('17386', '36', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17387', '36', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17388', '36', '5', '2023', 'GROSS SALARY', '0.00', '7', '1'),
('17389', '36', '5', '2023', 'NSSF', '0.00', '8', '1'),
('17390', '36', '5', '2023', 'TAXABLE INCOME', '0.00', '9', '1'),
('17391', '36', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17392', '36', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17393', '36', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17394', '36', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17395', '36', '5', '2023', 'LATE', '0.00', '14', '1'),
('17396', '36', '5', '2023', 'Loan', '0.00', '15', '1'),
('17397', '36', '5', '2023', 'Other', '0.00', '16', '1'),
('17398', '36', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17399', '36', '5', '2023', 'NETPAY', '0.00', '20', '1'),
('17400', '37', '5', '2023', 'BASIC PAY', '240000.00', '1', '1'),
('17401', '37', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17402', '37', '5', '2023', 'HOUSING', '36000.00', '3', '1'),
('17403', '37', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17404', '37', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17405', '37', '5', '2023', 'GROSS SALARY', '276000.00', '7', '1'),
('17406', '37', '5', '2023', 'NSSF', '27600.00', '8', '1'),
('17407', '37', '5', '2023', 'TAXABLE INCOME', '248400.00', '9', '1'),
('17408', '37', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17409', '37', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17410', '37', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17411', '37', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17412', '37', '5', '2023', 'LATE', '0.00', '14', '1'),
('17413', '37', '5', '2023', 'Loan', '0.00', '15', '1'),
('17414', '37', '5', '2023', 'Other', '0.00', '16', '1'),
('17415', '37', '5', '2023', 'STAFF LOAN', '50000.00', '18', '1'),
('17416', '37', '5', '2023', 'NETPAY', '198400.00', '20', '1'),
('17417', '38', '5', '2023', 'BASIC PAY', '420482.00', '1', '1'),
('17418', '38', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17419', '38', '5', '2023', 'HOUSING', '63072.00', '3', '1'),
('17420', '38', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17421', '38', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17422', '38', '5', '2023', 'GROSS SALARY', '483554.00', '7', '1'),
('17423', '38', '5', '2023', 'NSSF', '48355.40', '8', '1'),
('17424', '38', '5', '2023', 'TAXABLE INCOME', '435198.60', '9', '1'),
('17425', '38', '5', '2023', 'PAYE', '13215.89', '10', '1'),
('17426', '38', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17427', '38', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17428', '38', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17429', '38', '5', '2023', 'LATE', '0.00', '14', '1'),
('17430', '38', '5', '2023', 'Loan', '0.00', '15', '1'),
('17431', '38', '5', '2023', 'Other', '0.00', '16', '1'),
('17432', '38', '5', '2023', 'STAFF LOAN', '120800.00', '18', '1'),
('17433', '38', '5', '2023', 'NETPAY', '301182.71', '20', '1'),
('17434', '39', '5', '2023', 'BASIC PAY', '311981.00', '1', '1'),
('17435', '39', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17436', '39', '5', '2023', 'HOUSING', '46797.00', '3', '1'),
('17437', '39', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17438', '39', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17439', '39', '5', '2023', 'GROSS SALARY', '358778.00', '7', '1'),
('17440', '39', '5', '2023', 'NSSF', '35877.80', '8', '1'),
('17441', '39', '5', '2023', 'TAXABLE INCOME', '322900.20', '9', '1'),
('17442', '39', '5', '2023', 'PAYE', '4232.02', '10', '1'),
('17443', '39', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17444', '39', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17445', '39', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17446', '39', '5', '2023', 'LATE', '0.00', '14', '1'),
('17447', '39', '5', '2023', 'Loan', '0.00', '15', '1'),
('17448', '39', '5', '2023', 'Other', '0.00', '16', '1'),
('17449', '39', '5', '2023', 'STAFF LOAN', '100000.00', '18', '1'),
('17450', '39', '5', '2023', 'NETPAY', '218668.18', '20', '1'),
('17451', '40', '5', '2023', 'BASIC PAY', '2523478.00', '1', '1'),
('17452', '40', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17453', '40', '5', '2023', 'HOUSING', '378522.00', '3', '1'),
('17454', '40', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17455', '40', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17456', '40', '5', '2023', 'GROSS SALARY', '2902000.00', '7', '1'),
('17457', '40', '5', '2023', 'NSSF', '290200.00', '8', '1'),
('17458', '40', '5', '2023', 'TAXABLE INCOME', '2611800.00', '9', '1'),
('17459', '40', '5', '2023', 'PAYE', '611540.00', '10', '1'),
('17460', '40', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17461', '40', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17462', '40', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17463', '40', '5', '2023', 'LATE', '0.00', '14', '1'),
('17464', '40', '5', '2023', 'Loan', '0.00', '15', '1'),
('17465', '40', '5', '2023', 'Other', '0.00', '16', '1'),
('17466', '40', '5', '2023', 'STAFF LOAN', '500000.00', '18', '1'),
('17467', '40', '5', '2023', 'NETPAY', '1500260.00', '20', '1'),
('17468', '41', '5', '2023', 'BASIC PAY', '200000.00', '1', '1'),
('17469', '41', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17470', '41', '5', '2023', 'HOUSING', '0.00', '3', '1'),
('17471', '41', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17472', '41', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17473', '41', '5', '2023', 'GROSS SALARY', '200000.00', '7', '1'),
('17474', '41', '5', '2023', 'NSSF', '20000.00', '8', '1'),
('17475', '41', '5', '2023', 'TAXABLE INCOME', '180000.00', '9', '1'),
('17476', '41', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17477', '41', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17478', '41', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17479', '41', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17480', '41', '5', '2023', 'LATE', '0.00', '14', '1'),
('17481', '41', '5', '2023', 'Loan', '0.00', '15', '1'),
('17482', '41', '5', '2023', 'Other', '0.00', '16', '1'),
('17483', '41', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17484', '41', '5', '2023', 'NETPAY', '180000.00', '20', '1'),
('17485', '42', '5', '2023', 'BASIC PAY', '254990.00', '1', '1'),
('17486', '42', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17487', '42', '5', '2023', 'HOUSING', '38249.00', '3', '1'),
('17488', '42', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17489', '42', '5', '2023', 'OVERTIME', '51396.83', '6', '1'),
('17490', '42', '5', '2023', 'GROSS SALARY', '344635.83', '7', '1'),
('17491', '42', '5', '2023', 'NSSF', '34463.58', '8', '1'),
('17492', '42', '5', '2023', 'TAXABLE INCOME', '310172.25', '9', '1'),
('17493', '42', '5', '2023', 'PAYE', '3213.78', '10', '1'),
('17494', '42', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17495', '42', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17496', '42', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17497', '42', '5', '2023', 'LATE', '0.00', '14', '1'),
('17498', '42', '5', '2023', 'Loan', '0.00', '15', '1'),
('17499', '42', '5', '2023', 'Other', '0.00', '16', '1'),
('17500', '42', '5', '2023', 'STAFF LOAN', '40000.00', '18', '1'),
('17501', '42', '5', '2023', 'NETPAY', '166958.47', '20', '1'),
('17502', '43', '5', '2023', 'BASIC PAY', '11620875.00', '1', '1'),
('17503', '43', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17504', '43', '5', '2023', 'HOUSING', '500000.00', '3', '1'),
('17505', '43', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17506', '43', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17507', '43', '5', '2023', 'GROSS SALARY', '12120875.00', '7', '1'),
('17508', '43', '5', '2023', 'NSSF', '1212087.50', '8', '1'),
('17509', '43', '5', '2023', 'TAXABLE INCOME', '10908787.50', '9', '1'),
('17510', '43', '5', '2023', 'PAYE', '3100636.25', '10', '1'),
('17511', '43', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17512', '43', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17513', '43', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17514', '43', '5', '2023', 'LATE', '0.00', '14', '1'),
('17515', '43', '5', '2023', 'Loan', '0.00', '15', '1'),
('17516', '43', '5', '2023', 'Other', '0.00', '16', '1'),
('17517', '43', '5', '2023', 'STAFF LOAN', '1577777.00', '18', '1'),
('17518', '43', '5', '2023', 'NETPAY', '6230374.25', '20', '1'),
('17519', '44', '5', '2023', 'BASIC PAY', '2523120.00', '1', '1'),
('17520', '44', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17521', '44', '5', '2023', 'HOUSING', '378468.00', '3', '1'),
('17522', '44', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17523', '44', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17524', '44', '5', '2023', 'GROSS SALARY', '2901588.00', '7', '1'),
('17525', '44', '5', '2023', 'NSSF', '290158.80', '8', '1'),
('17526', '44', '5', '2023', 'TAXABLE INCOME', '2611429.20', '9', '1'),
('17527', '44', '5', '2023', 'PAYE', '611428.76', '10', '1'),
('17528', '44', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17529', '44', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17530', '44', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17531', '44', '5', '2023', 'LATE', '0.00', '14', '1'),
('17532', '44', '5', '2023', 'Loan', '0.00', '15', '1'),
('17533', '44', '5', '2023', 'Other', '0.00', '16', '1'),
('17534', '44', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17535', '44', '5', '2023', 'NETPAY', '2000000.44', '20', '1'),
('17536', '45', '5', '2023', 'BASIC PAY', '159102.00', '1', '1'),
('17537', '45', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17538', '45', '5', '2023', 'HOUSING', '23865.00', '3', '1'),
('17539', '45', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17540', '45', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17541', '45', '5', '2023', 'GROSS SALARY', '182967.00', '7', '1'),
('17542', '45', '5', '2023', 'NSSF', '18296.70', '8', '1'),
('17543', '45', '5', '2023', 'TAXABLE INCOME', '164670.30', '9', '1'),
('17544', '45', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17545', '45', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17546', '45', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17547', '45', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17548', '45', '5', '2023', 'LATE', '0.00', '14', '1'),
('17549', '45', '5', '2023', 'Loan', '0.00', '15', '1'),
('17550', '45', '5', '2023', 'Other', '0.00', '16', '1'),
('17551', '45', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17552', '45', '5', '2023', 'NETPAY', '164670.30', '20', '1'),
('17553', '46', '5', '2023', 'BASIC PAY', '505704.00', '1', '1'),
('17554', '46', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17555', '46', '5', '2023', 'HOUSING', '75856.00', '3', '1'),
('17556', '46', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17557', '46', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17558', '46', '5', '2023', 'GROSS SALARY', '581560.00', '7', '1'),
('17559', '46', '5', '2023', 'NSSF', '58156.00', '8', '1'),
('17560', '46', '5', '2023', 'TAXABLE INCOME', '523404.00', '9', '1'),
('17561', '46', '5', '2023', 'PAYE', '20680.80', '10', '1'),
('17562', '46', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17563', '46', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17564', '46', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17565', '46', '5', '2023', 'LATE', '0.00', '14', '1'),
('17566', '46', '5', '2023', 'Loan', '0.00', '15', '1'),
('17567', '46', '5', '2023', 'Other', '0.00', '16', '1'),
('17568', '46', '5', '2023', 'STAFF LOAN', '120000.00', '18', '1'),
('17569', '46', '5', '2023', 'NETPAY', '382723.20', '20', '1'),
('17570', '47', '5', '2023', 'BASIC PAY', '281801.00', '1', '1'),
('17571', '47', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17572', '47', '5', '2023', 'HOUSING', '42270.00', '3', '1'),
('17573', '47', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17574', '47', '5', '2023', 'OVERTIME', '50399.03', '6', '1'),
('17575', '47', '5', '2023', 'GROSS SALARY', '374470.03', '7', '1'),
('17576', '47', '5', '2023', 'NSSF', '37447.00', '8', '1'),
('17577', '47', '5', '2023', 'TAXABLE INCOME', '337023.02', '9', '1'),
('17578', '47', '5', '2023', 'PAYE', '5361.84', '10', '1'),
('17579', '47', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17580', '47', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17581', '47', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17582', '47', '5', '2023', 'LATE', '0.00', '14', '1'),
('17583', '47', '5', '2023', 'Loan', '0.00', '15', '1'),
('17584', '47', '5', '2023', 'Other', '0.00', '16', '1'),
('17585', '47', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17586', '47', '5', '2023', 'NETPAY', '231661.18', '20', '1'),
('17587', '48', '5', '2023', 'BASIC PAY', '3689000.00', '1', '1'),
('17588', '48', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17589', '48', '5', '2023', 'HOUSING', '553350.00', '3', '1'),
('17590', '48', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17591', '48', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17592', '48', '5', '2023', 'GROSS SALARY', '4242350.00', '7', '1'),
('17593', '48', '5', '2023', 'NSSF', '424235.00', '8', '1'),
('17594', '48', '5', '2023', 'TAXABLE INCOME', '3818115.00', '9', '1'),
('17595', '48', '5', '2023', 'PAYE', '973434.50', '10', '1'),
('17596', '48', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17597', '48', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17598', '48', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17599', '48', '5', '2023', 'LATE', '0.00', '14', '1'),
('17600', '48', '5', '2023', 'Loan', '0.00', '15', '1'),
('17601', '48', '5', '2023', 'Other', '0.00', '16', '1'),
('17602', '48', '5', '2023', 'STAFF LOAN', '800000.00', '18', '1'),
('17603', '48', '5', '2023', 'NETPAY', '2044680.50', '20', '1'),
('17604', '49', '5', '2023', 'BASIC PAY', '217391.00', '1', '1'),
('17605', '49', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17606', '49', '5', '2023', 'HOUSING', '32609.00', '3', '1'),
('17607', '49', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17608', '49', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17609', '49', '5', '2023', 'GROSS SALARY', '250000.00', '7', '1'),
('17610', '49', '5', '2023', 'NSSF', '0.00', '8', '1'),
('17611', '49', '5', '2023', 'TAXABLE INCOME', '250000.00', '9', '1'),
('17612', '49', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17613', '49', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17614', '49', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17615', '49', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17616', '49', '5', '2023', 'LATE', '0.00', '14', '1'),
('17617', '49', '5', '2023', 'Loan', '0.00', '15', '1');
INSERT INTO `salaryfields` (`SalaryFieldId`, `EmpId`, `PayrollMonth`, `PayrollYear`, `SalaryFieldName`, `Amount`, `No`, `CompanyId`) VALUES
('17618', '49', '5', '2023', 'Other', '0.00', '16', '1'),
('17619', '49', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17620', '49', '5', '2023', 'NETPAY', '250000.00', '20', '1'),
('17621', '50', '5', '2023', 'BASIC PAY', '207028.00', '1', '1'),
('17622', '50', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17623', '50', '5', '2023', 'HOUSING', '31054.00', '3', '1'),
('17624', '50', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17625', '50', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17626', '50', '5', '2023', 'GROSS SALARY', '238082.00', '7', '1'),
('17627', '50', '5', '2023', 'NSSF', '23808.20', '8', '1'),
('17628', '50', '5', '2023', 'TAXABLE INCOME', '214273.80', '9', '1'),
('17629', '50', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17630', '50', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17631', '50', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17632', '50', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17633', '50', '5', '2023', 'LATE', '0.00', '14', '1'),
('17634', '50', '5', '2023', 'Loan', '0.00', '15', '1'),
('17635', '50', '5', '2023', 'Other', '0.00', '16', '1'),
('17636', '50', '5', '2023', 'STAFF LOAN', '55000.00', '18', '1'),
('17637', '50', '5', '2023', 'NETPAY', '159273.80', '20', '1'),
('17638', '51', '5', '2023', 'BASIC PAY', '358566.00', '1', '1'),
('17639', '51', '5', '2023', 'Allowance', '107759.00', '2', '1'),
('17640', '51', '5', '2023', 'HOUSING', '53785.00', '3', '1'),
('17641', '51', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17642', '51', '5', '2023', 'OVERTIME', '101299.49', '6', '1'),
('17643', '51', '5', '2023', 'GROSS SALARY', '621409.49', '7', '1'),
('17644', '51', '5', '2023', 'NSSF', '62140.95', '8', '1'),
('17645', '51', '5', '2023', 'TAXABLE INCOME', '559268.54', '9', '1'),
('17646', '51', '5', '2023', 'PAYE', '27853.71', '10', '1'),
('17647', '51', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17648', '51', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17649', '51', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17650', '51', '5', '2023', 'LATE', '0.00', '14', '1'),
('17651', '51', '5', '2023', 'Loan', '0.00', '15', '1'),
('17652', '51', '5', '2023', 'Other', '0.00', '16', '1'),
('17653', '51', '5', '2023', 'STAFF LOAN', '50000.00', '18', '1'),
('17654', '51', '5', '2023', 'NETPAY', '381414.83', '20', '1'),
('17655', '52', '5', '2023', 'BASIC PAY', '344885.00', '1', '1'),
('17656', '52', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17657', '52', '5', '2023', 'HOUSING', '51733.00', '3', '1'),
('17658', '52', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17659', '52', '5', '2023', 'OVERTIME', '160477.64', '6', '1'),
('17660', '52', '5', '2023', 'GROSS SALARY', '557095.64', '7', '1'),
('17661', '52', '5', '2023', 'NSSF', '55709.56', '8', '1'),
('17662', '52', '5', '2023', 'TAXABLE INCOME', '501386.08', '9', '1'),
('17663', '52', '5', '2023', 'PAYE', '18510.89', '10', '1'),
('17664', '52', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17665', '52', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17666', '52', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17667', '52', '5', '2023', 'LATE', '0.00', '14', '1'),
('17668', '52', '5', '2023', 'Loan', '0.00', '15', '1'),
('17669', '52', '5', '2023', 'Other', '0.00', '16', '1'),
('17670', '52', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17671', '52', '5', '2023', 'NETPAY', '382875.19', '20', '1'),
('17672', '53', '5', '2023', 'BASIC PAY', '254990.00', '1', '1'),
('17673', '53', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17674', '53', '5', '2023', 'HOUSING', '38249.00', '3', '1'),
('17675', '53', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17676', '53', '5', '2023', 'OVERTIME', '73750.95', '6', '1'),
('17677', '53', '5', '2023', 'GROSS SALARY', '366989.95', '7', '1'),
('17678', '53', '5', '2023', 'NSSF', '36699.00', '8', '1'),
('17679', '53', '5', '2023', 'TAXABLE INCOME', '330290.96', '9', '1'),
('17680', '53', '5', '2023', 'PAYE', '4823.28', '10', '1'),
('17681', '53', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17682', '53', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17683', '53', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17684', '53', '5', '2023', 'LATE', '0.00', '14', '1'),
('17685', '53', '5', '2023', 'Loan', '0.00', '15', '1'),
('17686', '53', '5', '2023', 'Other', '0.00', '16', '1'),
('17687', '53', '5', '2023', 'STAFF LOAN', '30000.00', '18', '1'),
('17688', '53', '5', '2023', 'NETPAY', '195467.68', '20', '1'),
('17689', '54', '5', '2023', 'BASIC PAY', '2700146.00', '1', '1'),
('17690', '54', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17691', '54', '5', '2023', 'HOUSING', '405022.00', '3', '1'),
('17692', '54', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17693', '54', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17694', '54', '5', '2023', 'GROSS SALARY', '3105168.00', '7', '1'),
('17695', '54', '5', '2023', 'NSSF', '310516.80', '8', '1'),
('17696', '54', '5', '2023', 'TAXABLE INCOME', '2794651.20', '9', '1'),
('17697', '54', '5', '2023', 'PAYE', '666395.36', '10', '1'),
('17698', '54', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17699', '54', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17700', '54', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17701', '54', '5', '2023', 'LATE', '0.00', '14', '1'),
('17702', '54', '5', '2023', 'Loan', '0.00', '15', '1'),
('17703', '54', '5', '2023', 'Other', '0.00', '16', '1'),
('17704', '54', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17705', '54', '5', '2023', 'NETPAY', '2128255.84', '20', '1'),
('17706', '55', '5', '2023', 'BASIC PAY', '5973775.00', '1', '1'),
('17707', '55', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17708', '55', '5', '2023', 'HOUSING', '896066.00', '3', '1'),
('17709', '55', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17710', '55', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17711', '55', '5', '2023', 'GROSS SALARY', '6869841.00', '7', '1'),
('17712', '55', '5', '2023', 'NSSF', '554871.77', '8', '1'),
('17713', '55', '5', '2023', 'TAXABLE INCOME', '4993845.96', '9', '1'),
('17714', '55', '5', '2023', 'PAYE', '1326153.79', '10', '1'),
('17715', '55', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17716', '55', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17717', '55', '5', '2023', 'ABSENT', '1321123.27', '13', '1'),
('17718', '55', '5', '2023', 'LATE', '0.00', '14', '1'),
('17719', '55', '5', '2023', 'Loan', '0.00', '15', '1'),
('17720', '55', '5', '2023', 'Other', '0.00', '16', '1'),
('17721', '55', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17722', '55', '5', '2023', 'NETPAY', '3667692.17', '20', '1'),
('17723', '56', '5', '2023', 'BASIC PAY', '130435.00', '1', '1'),
('17724', '56', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17725', '56', '5', '2023', 'HOUSING', '19565.00', '3', '1'),
('17726', '56', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17727', '56', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17728', '56', '5', '2023', 'GROSS SALARY', '150000.00', '7', '1'),
('17729', '56', '5', '2023', 'NSSF', '15000.00', '8', '1'),
('17730', '56', '5', '2023', 'TAXABLE INCOME', '135000.00', '9', '1'),
('17731', '56', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17732', '56', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17733', '56', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17734', '56', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17735', '56', '5', '2023', 'LATE', '0.00', '14', '1'),
('17736', '56', '5', '2023', 'Loan', '0.00', '15', '1'),
('17737', '56', '5', '2023', 'Other', '0.00', '16', '1'),
('17738', '56', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17739', '56', '5', '2023', 'NETPAY', '135000.00', '20', '1'),
('17740', '57', '5', '2023', 'BASIC PAY', '2501281.00', '1', '1'),
('17741', '57', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17742', '57', '5', '2023', 'HOUSING', '375192.00', '3', '1'),
('17743', '57', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17744', '57', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17745', '57', '5', '2023', 'GROSS SALARY', '2876473.00', '7', '1'),
('17746', '57', '5', '2023', 'NSSF', '287647.30', '8', '1'),
('17747', '57', '5', '2023', 'TAXABLE INCOME', '2588825.70', '9', '1'),
('17748', '57', '5', '2023', 'PAYE', '604647.71', '10', '1'),
('17749', '57', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17750', '57', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17751', '57', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17752', '57', '5', '2023', 'LATE', '0.00', '14', '1'),
('17753', '57', '5', '2023', 'Loan', '0.00', '15', '1'),
('17754', '57', '5', '2023', 'Other', '0.00', '16', '1'),
('17755', '57', '5', '2023', 'STAFF LOAN', '250000.00', '18', '1'),
('17756', '57', '5', '2023', 'NETPAY', '1734177.99', '20', '1'),
('17757', '58', '5', '2023', 'BASIC PAY', '24296250.00', '1', '1'),
('17758', '58', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17759', '58', '5', '2023', 'HOUSING', '3645625.00', '3', '1'),
('17760', '58', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17761', '58', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17762', '58', '5', '2023', 'GROSS SALARY', '27941875.00', '7', '1'),
('17763', '58', '5', '2023', 'NSSF', '2794187.50', '8', '1'),
('17764', '58', '5', '2023', 'TAXABLE INCOME', '25147687.50', '9', '1'),
('17765', '58', '5', '2023', 'PAYE', '7372306.25', '10', '1'),
('17766', '58', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17767', '58', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17768', '58', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17769', '58', '5', '2023', 'LATE', '0.00', '14', '1'),
('17770', '58', '5', '2023', 'Loan', '0.00', '15', '1'),
('17771', '58', '5', '2023', 'Other', '0.00', '16', '1'),
('17772', '58', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17773', '58', '5', '2023', 'NETPAY', '17775381.25', '20', '1'),
('17774', '59', '5', '2023', 'BASIC PAY', '3852880.00', '1', '1'),
('17775', '59', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17776', '59', '5', '2023', 'HOUSING', '577932.00', '3', '1'),
('17777', '59', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17778', '59', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17779', '59', '5', '2023', 'GROSS SALARY', '4430812.00', '7', '1'),
('17780', '59', '5', '2023', 'NSSF', '443081.20', '8', '1'),
('17781', '59', '5', '2023', 'TAXABLE INCOME', '3987730.80', '9', '1'),
('17782', '59', '5', '2023', 'PAYE', '1024319.24', '10', '1'),
('17783', '59', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17784', '59', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17785', '59', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17786', '59', '5', '2023', 'LATE', '0.00', '14', '1'),
('17787', '59', '5', '2023', 'Loan', '0.00', '15', '1'),
('17788', '59', '5', '2023', 'Other', '0.00', '16', '1'),
('17789', '59', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17790', '59', '5', '2023', 'NETPAY', '2963411.56', '20', '1'),
('17791', '60', '5', '2023', 'BASIC PAY', '2523478.00', '1', '1'),
('17792', '60', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17793', '60', '5', '2023', 'HOUSING', '378522.00', '3', '1'),
('17794', '60', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17795', '60', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17796', '60', '5', '2023', 'GROSS SALARY', '2902000.00', '7', '1'),
('17797', '60', '5', '2023', 'NSSF', '290200.00', '8', '1'),
('17798', '60', '5', '2023', 'TAXABLE INCOME', '2611800.00', '9', '1'),
('17799', '60', '5', '2023', 'PAYE', '611540.00', '10', '1'),
('17800', '60', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17801', '60', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17802', '60', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17803', '60', '5', '2023', 'LATE', '0.00', '14', '1'),
('17804', '60', '5', '2023', 'Loan', '0.00', '15', '1'),
('17805', '60', '5', '2023', 'Other', '0.00', '16', '1'),
('17806', '60', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17807', '60', '5', '2023', 'NETPAY', '2000260.00', '20', '1'),
('17808', '61', '5', '2023', 'BASIC PAY', '226387.00', '1', '1'),
('17809', '61', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17810', '61', '5', '2023', 'HOUSING', '33958.00', '3', '1'),
('17811', '61', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17812', '61', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17813', '61', '5', '2023', 'GROSS SALARY', '260345.00', '7', '1'),
('17814', '61', '5', '2023', 'NSSF', '26034.50', '8', '1'),
('17815', '61', '5', '2023', 'TAXABLE INCOME', '234310.50', '9', '1'),
('17816', '61', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17817', '61', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17818', '61', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17819', '61', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17820', '61', '5', '2023', 'LATE', '0.00', '14', '1'),
('17821', '61', '5', '2023', 'Loan', '0.00', '15', '1'),
('17822', '61', '5', '2023', 'Other', '0.00', '16', '1'),
('17823', '61', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17824', '61', '5', '2023', 'NETPAY', '234310.50', '20', '1'),
('17825', '62', '5', '2023', 'BASIC PAY', '279604.00', '1', '1'),
('17826', '62', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17827', '62', '5', '2023', 'HOUSING', '41941.00', '3', '1'),
('17828', '62', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17829', '62', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17830', '62', '5', '2023', 'GROSS SALARY', '321545.00', '7', '1'),
('17831', '62', '5', '2023', 'NSSF', '32154.50', '8', '1'),
('17832', '62', '5', '2023', 'TAXABLE INCOME', '289390.50', '9', '1'),
('17833', '62', '5', '2023', 'PAYE', '1551.24', '10', '1'),
('17834', '62', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17835', '62', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17836', '62', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17837', '62', '5', '2023', 'LATE', '0.00', '14', '1'),
('17838', '62', '5', '2023', 'Loan', '0.00', '15', '1'),
('17839', '62', '5', '2023', 'Other', '0.00', '16', '1'),
('17840', '62', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17841', '62', '5', '2023', 'NETPAY', '287839.26', '20', '1'),
('17842', '63', '5', '2023', 'BASIC PAY', '439730.00', '1', '1'),
('17843', '63', '5', '2023', 'Allowance', '34722.00', '2', '1'),
('17844', '63', '5', '2023', 'HOUSING', '65960.00', '3', '1'),
('17845', '63', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17846', '63', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17847', '63', '5', '2023', 'GROSS SALARY', '540412.00', '7', '1'),
('17848', '63', '5', '2023', 'NSSF', '51962.69', '8', '1'),
('17849', '63', '5', '2023', 'TAXABLE INCOME', '467664.23', '9', '1'),
('17850', '63', '5', '2023', 'PAYE', '15813.14', '10', '1'),
('17851', '63', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17852', '63', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17853', '63', '5', '2023', 'ABSENT', '20785.08', '13', '1'),
('17854', '63', '5', '2023', 'LATE', '0.00', '14', '1'),
('17855', '63', '5', '2023', 'Loan', '0.00', '15', '1'),
('17856', '63', '5', '2023', 'Other', '0.00', '16', '1'),
('17857', '63', '5', '2023', 'STAFF LOAN', '100000.00', '18', '1'),
('17858', '63', '5', '2023', 'NETPAY', '251851.09', '20', '1'),
('17859', '64', '5', '2023', 'BASIC PAY', '358561.00', '1', '1'),
('17860', '64', '5', '2023', 'Allowance', '76960.00', '2', '1'),
('17861', '64', '5', '2023', 'HOUSING', '53784.00', '3', '1'),
('17862', '64', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17863', '64', '5', '2023', 'OVERTIME', '42218.26', '6', '1'),
('17864', '64', '5', '2023', 'GROSS SALARY', '531523.26', '7', '1'),
('17865', '64', '5', '2023', 'NSSF', '53152.33', '8', '1'),
('17866', '64', '5', '2023', 'TAXABLE INCOME', '478370.93', '9', '1'),
('17867', '64', '5', '2023', 'PAYE', '16669.68', '10', '1'),
('17868', '64', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('17869', '64', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17870', '64', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17871', '64', '5', '2023', 'LATE', '0.00', '14', '1'),
('17872', '64', '5', '2023', 'Loan', '0.00', '15', '1'),
('17873', '64', '5', '2023', 'Other', '0.00', '16', '1'),
('17874', '64', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17875', '64', '5', '2023', 'NETPAY', '361701.26', '20', '1'),
('17876', '65', '5', '2023', 'BASIC PAY', '355312.00', '1', '1'),
('17877', '65', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17878', '65', '5', '2023', 'HOUSING', '53297.00', '3', '1'),
('17879', '65', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17880', '65', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17881', '65', '5', '2023', 'GROSS SALARY', '408609.00', '7', '1'),
('17882', '65', '5', '2023', 'NSSF', '40860.90', '8', '1'),
('17883', '65', '5', '2023', 'TAXABLE INCOME', '367748.10', '9', '1'),
('17884', '65', '5', '2023', 'PAYE', '7819.85', '10', '1'),
('17885', '65', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17886', '65', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17887', '65', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17888', '65', '5', '2023', 'LATE', '0.00', '14', '1'),
('17889', '65', '5', '2023', 'Loan', '0.00', '15', '1'),
('17890', '65', '5', '2023', 'Other', '0.00', '16', '1'),
('17891', '65', '5', '2023', 'STAFF LOAN', '120000.00', '18', '1'),
('17892', '65', '5', '2023', 'NETPAY', '239928.25', '20', '1'),
('17893', '66', '5', '2023', 'BASIC PAY', '260509.00', '1', '1'),
('17894', '66', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17895', '66', '5', '2023', 'HOUSING', '39076.00', '3', '1'),
('17896', '66', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17897', '66', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17898', '66', '5', '2023', 'GROSS SALARY', '299585.00', '7', '1'),
('17899', '66', '5', '2023', 'NSSF', '29958.50', '8', '1'),
('17900', '66', '5', '2023', 'TAXABLE INCOME', '269626.50', '9', '1'),
('17901', '66', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17902', '66', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17903', '66', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17904', '66', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17905', '66', '5', '2023', 'LATE', '0.00', '14', '1'),
('17906', '66', '5', '2023', 'Loan', '0.00', '15', '1'),
('17907', '66', '5', '2023', 'Other', '0.00', '16', '1'),
('17908', '66', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17909', '66', '5', '2023', 'NETPAY', '269626.50', '20', '1'),
('17910', '67', '5', '2023', 'BASIC PAY', '11031875.00', '1', '1'),
('17911', '67', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17912', '67', '5', '2023', 'HOUSING', '0.00', '3', '1'),
('17913', '67', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17914', '67', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17915', '67', '5', '2023', 'GROSS SALARY', '11031875.00', '7', '1'),
('17916', '67', '5', '2023', 'NSSF', '1060757.21', '8', '1'),
('17917', '67', '5', '2023', 'TAXABLE INCOME', '9546814.90', '9', '1'),
('17918', '67', '5', '2023', 'PAYE', '2692044.47', '10', '1'),
('17919', '67', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17920', '67', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17921', '67', '5', '2023', 'ABSENT', '424302.89', '13', '1'),
('17922', '67', '5', '2023', 'LATE', '0.00', '14', '1'),
('17923', '67', '5', '2023', 'Loan', '0.00', '15', '1'),
('17924', '67', '5', '2023', 'Other', '0.00', '16', '1'),
('17925', '67', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17926', '67', '5', '2023', 'NETPAY', '6854770.43', '20', '1'),
('17927', '68', '5', '2023', 'BASIC PAY', '16074000.00', '1', '1'),
('17928', '68', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17929', '68', '5', '2023', 'HOUSING', '2595875.00', '3', '1'),
('17930', '68', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17931', '68', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17932', '68', '5', '2023', 'GROSS SALARY', '18669875.00', '7', '1'),
('17933', '68', '5', '2023', 'NSSF', '1866987.50', '8', '1'),
('17934', '68', '5', '2023', 'TAXABLE INCOME', '16802887.50', '9', '1'),
('17935', '68', '5', '2023', 'PAYE', '4868866.25', '10', '1'),
('17936', '68', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17937', '68', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17938', '68', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17939', '68', '5', '2023', 'LATE', '0.00', '14', '1'),
('17940', '68', '5', '2023', 'Loan', '0.00', '15', '1'),
('17941', '68', '5', '2023', 'Other', '0.00', '16', '1'),
('17942', '68', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17943', '68', '5', '2023', 'NETPAY', '11934021.25', '20', '1'),
('17944', '69', '5', '2023', 'BASIC PAY', '173913.00', '1', '1'),
('17945', '69', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17946', '69', '5', '2023', 'HOUSING', '26087.00', '3', '1'),
('17947', '69', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17948', '69', '5', '2023', 'OVERTIME', '28664.43', '6', '1'),
('17949', '69', '5', '2023', 'GROSS SALARY', '228664.43', '7', '1'),
('17950', '69', '5', '2023', 'NSSF', '22866.44', '8', '1'),
('17951', '69', '5', '2023', 'TAXABLE INCOME', '205797.99', '9', '1'),
('17952', '69', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17953', '69', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17954', '69', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17955', '69', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17956', '69', '5', '2023', 'LATE', '0.00', '14', '1'),
('17957', '69', '5', '2023', 'Loan', '0.00', '15', '1'),
('17958', '69', '5', '2023', 'Other', '0.00', '16', '1'),
('17959', '69', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17960', '69', '5', '2023', 'NETPAY', '205797.99', '20', '1'),
('17961', '70', '5', '2023', 'BASIC PAY', '0.00', '1', '1'),
('17962', '70', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17963', '70', '5', '2023', 'HOUSING', '0.00', '3', '1'),
('17964', '70', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17965', '70', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17966', '70', '5', '2023', 'GROSS SALARY', '0.00', '7', '1'),
('17967', '70', '5', '2023', 'NSSF', '0.00', '8', '1'),
('17968', '70', '5', '2023', 'TAXABLE INCOME', '0.00', '9', '1'),
('17969', '70', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17970', '70', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17971', '70', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17972', '70', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17973', '70', '5', '2023', 'LATE', '0.00', '14', '1'),
('17974', '70', '5', '2023', 'Loan', '0.00', '15', '1'),
('17975', '70', '5', '2023', 'Other', '0.00', '16', '1'),
('17976', '70', '5', '2023', 'STAFF LOAN', '108000.00', '18', '1'),
('17977', '70', '5', '2023', 'NETPAY', '-108000.00', '20', '1'),
('17978', '71', '5', '2023', 'BASIC PAY', '130435.00', '1', '1'),
('17979', '71', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17980', '71', '5', '2023', 'HOUSING', '19565.00', '3', '1'),
('17981', '71', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17982', '71', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('17983', '71', '5', '2023', 'GROSS SALARY', '150000.00', '7', '1'),
('17984', '71', '5', '2023', 'NSSF', '15000.00', '8', '1'),
('17985', '71', '5', '2023', 'TAXABLE INCOME', '135000.00', '9', '1'),
('17986', '71', '5', '2023', 'PAYE', '0.00', '10', '1'),
('17987', '71', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('17988', '71', '5', '2023', 'NHIF', '0.00', '12', '1'),
('17989', '71', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('17990', '71', '5', '2023', 'LATE', '0.00', '14', '1'),
('17991', '71', '5', '2023', 'Loan', '0.00', '15', '1'),
('17992', '71', '5', '2023', 'Other', '0.00', '16', '1'),
('17993', '71', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('17994', '71', '5', '2023', 'NETPAY', '135000.00', '20', '1'),
('17995', '72', '5', '2023', 'BASIC PAY', '707139.00', '1', '1'),
('17996', '72', '5', '2023', 'Allowance', '0.00', '2', '1'),
('17997', '72', '5', '2023', 'HOUSING', '106071.00', '3', '1'),
('17998', '72', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('17999', '72', '5', '2023', 'OVERTIME', '209349.41', '6', '1'),
('18000', '72', '5', '2023', 'GROSS SALARY', '1022559.41', '7', '1'),
('18001', '72', '5', '2023', 'NSSF', '102255.94', '8', '1'),
('18002', '72', '5', '2023', 'TAXABLE INCOME', '920303.47', '9', '1'),
('18003', '72', '5', '2023', 'PAYE', '108075.87', '10', '1'),
('18004', '72', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('18005', '72', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18006', '72', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18007', '72', '5', '2023', 'LATE', '0.00', '14', '1'),
('18008', '72', '5', '2023', 'Loan', '0.00', '15', '1'),
('18009', '72', '5', '2023', 'Other', '0.00', '16', '1'),
('18010', '72', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18011', '72', '5', '2023', 'NETPAY', '712227.60', '20', '1'),
('18012', '73', '5', '2023', 'BASIC PAY', '2284970.00', '1', '1'),
('18013', '73', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18014', '73', '5', '2023', 'HOUSING', '342745.00', '3', '1'),
('18015', '73', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18016', '73', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18017', '73', '5', '2023', 'GROSS SALARY', '2627715.00', '7', '1'),
('18018', '73', '5', '2023', 'NSSF', '262771.50', '8', '1'),
('18019', '73', '5', '2023', 'TAXABLE INCOME', '2364943.50', '9', '1'),
('18020', '73', '5', '2023', 'PAYE', '537483.05', '10', '1'),
('18021', '73', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18022', '73', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18023', '73', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18024', '73', '5', '2023', 'LATE', '0.00', '14', '1'),
('18025', '73', '5', '2023', 'Loan', '0.00', '15', '1'),
('18026', '73', '5', '2023', 'Other', '0.00', '16', '1'),
('18027', '73', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18028', '73', '5', '2023', 'NETPAY', '1827460.45', '20', '1'),
('18029', '74', '5', '2023', 'BASIC PAY', '3228871.00', '1', '1'),
('18030', '74', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18031', '74', '5', '2023', 'HOUSING', '484331.00', '3', '1'),
('18032', '74', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18033', '74', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18034', '74', '5', '2023', 'GROSS SALARY', '3713202.00', '7', '1'),
('18035', '74', '5', '2023', 'NSSF', '371320.20', '8', '1'),
('18036', '74', '5', '2023', 'TAXABLE INCOME', '3341881.80', '9', '1'),
('18037', '74', '5', '2023', 'PAYE', '830564.54', '10', '1'),
('18038', '74', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18039', '74', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18040', '74', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18041', '74', '5', '2023', 'LATE', '0.00', '14', '1'),
('18042', '74', '5', '2023', 'Loan', '0.00', '15', '1'),
('18043', '74', '5', '2023', 'Other', '0.00', '16', '1'),
('18044', '74', '5', '2023', 'STAFF LOAN', '920000.00', '18', '1'),
('18045', '74', '5', '2023', 'NETPAY', '1591317.26', '20', '1'),
('18046', '75', '5', '2023', 'BASIC PAY', '16422250.00', '1', '1'),
('18047', '75', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18048', '75', '5', '2023', 'HOUSING', '2463333.00', '3', '1'),
('18049', '75', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18050', '75', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18051', '75', '5', '2023', 'GROSS SALARY', '18885583.00', '7', '1'),
('18052', '75', '5', '2023', 'NSSF', '1888558.30', '8', '1'),
('18053', '75', '5', '2023', 'TAXABLE INCOME', '16997024.70', '9', '1'),
('18054', '75', '5', '2023', 'PAYE', '4927107.41', '10', '1'),
('18055', '75', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18056', '75', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18057', '75', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18058', '75', '5', '2023', 'LATE', '0.00', '14', '1'),
('18059', '75', '5', '2023', 'Loan', '0.00', '15', '1'),
('18060', '75', '5', '2023', 'Other', '0.00', '16', '1'),
('18061', '75', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18062', '75', '5', '2023', 'NETPAY', '12069917.29', '20', '1'),
('18063', '76', '5', '2023', 'BASIC PAY', '217281.00', '1', '1'),
('18064', '76', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18065', '76', '5', '2023', 'HOUSING', '32592.00', '3', '1'),
('18066', '76', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18067', '76', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18068', '76', '5', '2023', 'GROSS SALARY', '249873.00', '7', '1'),
('18069', '76', '5', '2023', 'NSSF', '24987.30', '8', '1'),
('18070', '76', '5', '2023', 'TAXABLE INCOME', '224885.70', '9', '1'),
('18071', '76', '5', '2023', 'PAYE', '0.00', '10', '1'),
('18072', '76', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18073', '76', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18074', '76', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18075', '76', '5', '2023', 'LATE', '0.00', '14', '1'),
('18076', '76', '5', '2023', 'Loan', '0.00', '15', '1'),
('18077', '76', '5', '2023', 'Other', '0.00', '16', '1'),
('18078', '76', '5', '2023', 'STAFF LOAN', '60000.00', '18', '1'),
('18079', '76', '5', '2023', 'NETPAY', '164885.70', '20', '1'),
('18080', '77', '5', '2023', 'BASIC PAY', '302585.00', '1', '1'),
('18081', '77', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18082', '77', '5', '2023', 'HOUSING', '45388.00', '3', '1'),
('18083', '77', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18084', '77', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18085', '77', '5', '2023', 'GROSS SALARY', '347973.00', '7', '1'),
('18086', '77', '5', '2023', 'NSSF', '34797.30', '8', '1'),
('18087', '77', '5', '2023', 'TAXABLE INCOME', '313175.70', '9', '1'),
('18088', '77', '5', '2023', 'PAYE', '3454.06', '10', '1'),
('18089', '77', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18090', '77', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18091', '77', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18092', '77', '5', '2023', 'LATE', '0.00', '14', '1'),
('18093', '77', '5', '2023', 'Loan', '0.00', '15', '1'),
('18094', '77', '5', '2023', 'Other', '0.00', '16', '1'),
('18095', '77', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18096', '77', '5', '2023', 'NETPAY', '309721.64', '20', '1'),
('18097', '78', '5', '2023', 'BASIC PAY', '365685.00', '1', '1'),
('18098', '78', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18099', '78', '5', '2023', 'HOUSING', '54853.00', '3', '1'),
('18100', '78', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18101', '78', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18102', '78', '5', '2023', 'GROSS SALARY', '420538.00', '7', '1'),
('18103', '78', '5', '2023', 'NSSF', '42053.80', '8', '1'),
('18104', '78', '5', '2023', 'TAXABLE INCOME', '378484.20', '9', '1'),
('18105', '78', '5', '2023', 'PAYE', '8678.74', '10', '1'),
('18106', '78', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18107', '78', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18108', '78', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18109', '78', '5', '2023', 'LATE', '0.00', '14', '1'),
('18110', '78', '5', '2023', 'Loan', '0.00', '15', '1'),
('18111', '78', '5', '2023', 'Other', '0.00', '16', '1'),
('18112', '78', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18113', '78', '5', '2023', 'NETPAY', '369805.46', '20', '1'),
('18114', '79', '5', '2023', 'BASIC PAY', '259360.00', '1', '1'),
('18115', '79', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18116', '79', '5', '2023', 'HOUSING', '38904.00', '3', '1'),
('18117', '79', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18118', '79', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18119', '79', '5', '2023', 'GROSS SALARY', '298264.00', '7', '1'),
('18120', '79', '5', '2023', 'NSSF', '29826.40', '8', '1'),
('18121', '79', '5', '2023', 'TAXABLE INCOME', '268437.60', '9', '1'),
('18122', '79', '5', '2023', 'PAYE', '0.00', '10', '1'),
('18123', '79', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18124', '79', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18125', '79', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18126', '79', '5', '2023', 'LATE', '0.00', '14', '1'),
('18127', '79', '5', '2023', 'Loan', '0.00', '15', '1'),
('18128', '79', '5', '2023', 'Other', '0.00', '16', '1'),
('18129', '79', '5', '2023', 'STAFF LOAN', '70000.00', '18', '1'),
('18130', '79', '5', '2023', 'NETPAY', '198437.60', '20', '1'),
('18131', '80', '5', '2023', 'BASIC PAY', '15601375.00', '1', '1'),
('18132', '80', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18133', '80', '5', '2023', 'HOUSING', '500000.00', '3', '1'),
('18134', '80', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18135', '80', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18136', '80', '5', '2023', 'GROSS SALARY', '16101375.00', '7', '1'),
('18137', '80', '5', '2023', 'NSSF', '1610137.50', '8', '1'),
('18138', '80', '5', '2023', 'TAXABLE INCOME', '14491237.50', '9', '1'),
('18139', '80', '5', '2023', 'PAYE', '4175371.25', '10', '1'),
('18140', '80', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18141', '80', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18142', '80', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18143', '80', '5', '2023', 'LATE', '0.00', '14', '1'),
('18144', '80', '5', '2023', 'Loan', '0.00', '15', '1'),
('18145', '80', '5', '2023', 'Other', '315000.00', '16', '1'),
('18146', '80', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18147', '80', '5', '2023', 'NETPAY', '10000866.25', '20', '1'),
('18148', '81', '5', '2023', 'BASIC PAY', '0.00', '1', '1'),
('18149', '81', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18150', '81', '5', '2023', 'HOUSING', '0.00', '3', '1'),
('18151', '81', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18152', '81', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18153', '81', '5', '2023', 'GROSS SALARY', '0.00', '7', '1'),
('18154', '81', '5', '2023', 'NSSF', '0.00', '8', '1'),
('18155', '81', '5', '2023', 'TAXABLE INCOME', '0.00', '9', '1'),
('18156', '81', '5', '2023', 'PAYE', '0.00', '10', '1'),
('18157', '81', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18158', '81', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18159', '81', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18160', '81', '5', '2023', 'LATE', '0.00', '14', '1'),
('18161', '81', '5', '2023', 'Loan', '0.00', '15', '1'),
('18162', '81', '5', '2023', 'Other', '0.00', '16', '1'),
('18163', '81', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18164', '81', '5', '2023', 'NETPAY', '0.00', '20', '1'),
('18165', '82', '5', '2023', 'BASIC PAY', '387164.00', '1', '1'),
('18166', '82', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18167', '82', '5', '2023', 'HOUSING', '58075.00', '3', '1'),
('18168', '82', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18169', '82', '5', '2023', 'OVERTIME', '168108.59', '6', '1'),
('18170', '82', '5', '2023', 'GROSS SALARY', '613347.59', '7', '1'),
('18171', '82', '5', '2023', 'NSSF', '61334.76', '8', '1'),
('18172', '82', '5', '2023', 'TAXABLE INCOME', '552012.84', '9', '1'),
('18173', '82', '5', '2023', 'PAYE', '26402.57', '10', '1'),
('18174', '82', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('18175', '82', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18176', '82', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18177', '82', '5', '2023', 'LATE', '0.00', '14', '1'),
('18178', '82', '5', '2023', 'Loan', '0.00', '15', '1'),
('18179', '82', '5', '2023', 'Other', '0.00', '16', '1'),
('18180', '82', '5', '2023', 'STAFF LOAN', '50000.00', '18', '1'),
('18181', '82', '5', '2023', 'NETPAY', '375610.27', '20', '1'),
('18182', '83', '5', '2023', 'BASIC PAY', '293848.00', '1', '1'),
('18183', '83', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18184', '83', '5', '2023', 'HOUSING', '44077.00', '3', '1'),
('18185', '83', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18186', '83', '5', '2023', 'OVERTIME', '48552.73', '6', '1'),
('18187', '83', '5', '2023', 'GROSS SALARY', '386477.73', '7', '1'),
('18188', '83', '5', '2023', 'NSSF', '38647.77', '8', '1'),
('18189', '83', '5', '2023', 'TAXABLE INCOME', '347829.96', '9', '1'),
('18190', '83', '5', '2023', 'PAYE', '6226.40', '10', '1'),
('18191', '83', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('18192', '83', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18193', '83', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18194', '83', '5', '2023', 'LATE', '0.00', '14', '1'),
('18195', '83', '5', '2023', 'Loan', '0.00', '15', '1'),
('18196', '83', '5', '2023', 'Other', '0.00', '16', '1'),
('18197', '83', '5', '2023', 'STAFF LOAN', '90000.00', '18', '1'),
('18198', '83', '5', '2023', 'NETPAY', '151603.56', '20', '1'),
('18199', '84', '5', '2023', 'BASIC PAY', '2799172.00', '1', '1'),
('18200', '84', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18201', '84', '5', '2023', 'HOUSING', '419876.00', '3', '1'),
('18202', '84', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18203', '84', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18204', '84', '5', '2023', 'GROSS SALARY', '3219048.00', '7', '1'),
('18205', '84', '5', '2023', 'NSSF', '321904.80', '8', '1'),
('18206', '84', '5', '2023', 'TAXABLE INCOME', '2897143.20', '9', '1'),
('18207', '84', '5', '2023', 'PAYE', '697142.96', '10', '1'),
('18208', '84', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18209', '84', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18210', '84', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18211', '84', '5', '2023', 'LATE', '0.00', '14', '1'),
('18212', '84', '5', '2023', 'Loan', '0.00', '15', '1'),
('18213', '84', '5', '2023', 'Other', '0.00', '16', '1'),
('18214', '84', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18215', '84', '5', '2023', 'NETPAY', '2200000.24', '20', '1'),
('18216', '85', '5', '2023', 'BASIC PAY', '5567544.00', '1', '1'),
('18217', '85', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18218', '85', '5', '2023', 'HOUSING', '835132.00', '3', '1'),
('18219', '85', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18220', '85', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18221', '85', '5', '2023', 'GROSS SALARY', '6402676.00', '7', '1'),
('18222', '85', '5', '2023', 'NSSF', '640267.60', '8', '1'),
('18223', '85', '5', '2023', 'TAXABLE INCOME', '5762408.40', '9', '1'),
('18224', '85', '5', '2023', 'PAYE', '1556722.52', '10', '1'),
('18225', '85', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18226', '85', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18227', '85', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18228', '85', '5', '2023', 'LATE', '0.00', '14', '1'),
('18229', '85', '5', '2023', 'Loan', '0.00', '15', '1'),
('18230', '85', '5', '2023', 'Other', '0.00', '16', '1'),
('18231', '85', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18232', '85', '5', '2023', 'NETPAY', '4205685.88', '20', '1'),
('18233', '86', '5', '2023', 'BASIC PAY', '2625520.00', '1', '1'),
('18234', '86', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18235', '86', '5', '2023', 'HOUSING', '393828.00', '3', '1'),
('18236', '86', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18237', '86', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18238', '86', '5', '2023', 'GROSS SALARY', '3019348.00', '7', '1'),
('18239', '86', '5', '2023', 'NSSF', '301934.80', '8', '1'),
('18240', '86', '5', '2023', 'TAXABLE INCOME', '2717413.20', '9', '1'),
('18241', '86', '5', '2023', 'PAYE', '643223.96', '10', '1'),
('18242', '86', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18243', '86', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18244', '86', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18245', '86', '5', '2023', 'LATE', '0.00', '14', '1'),
('18246', '86', '5', '2023', 'Loan', '0.00', '15', '1'),
('18247', '86', '5', '2023', 'Other', '0.00', '16', '1'),
('18248', '86', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18249', '86', '5', '2023', 'NETPAY', '2074189.24', '20', '1'),
('18250', '87', '5', '2023', 'BASIC PAY', '5664929.00', '1', '1'),
('18251', '87', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18252', '87', '5', '2023', 'HOUSING', '849739.00', '3', '1'),
('18253', '87', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18254', '87', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18255', '87', '5', '2023', 'GROSS SALARY', '6514668.00', '7', '1'),
('18256', '87', '5', '2023', 'NSSF', '651466.80', '8', '1'),
('18257', '87', '5', '2023', 'TAXABLE INCOME', '5863201.20', '9', '1'),
('18258', '87', '5', '2023', 'PAYE', '1586960.36', '10', '1'),
('18259', '87', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18260', '87', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18261', '87', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18262', '87', '5', '2023', 'LATE', '0.00', '14', '1'),
('18263', '87', '5', '2023', 'Loan', '0.00', '15', '1'),
('18264', '87', '5', '2023', 'Other', '0.00', '16', '1'),
('18265', '87', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18266', '87', '5', '2023', 'NETPAY', '4276240.84', '20', '1'),
('18267', '88', '5', '2023', 'BASIC PAY', '4869565.00', '1', '1'),
('18268', '88', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18269', '88', '5', '2023', 'HOUSING', '730435.00', '3', '1'),
('18270', '88', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18271', '88', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18272', '88', '5', '2023', 'GROSS SALARY', '5600000.00', '7', '1'),
('18273', '88', '5', '2023', 'NSSF', '560000.00', '8', '1'),
('18274', '88', '5', '2023', 'TAXABLE INCOME', '5040000.00', '9', '1'),
('18275', '88', '5', '2023', 'PAYE', '1340000.00', '10', '1'),
('18276', '88', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18277', '88', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18278', '88', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18279', '88', '5', '2023', 'LATE', '0.00', '14', '1'),
('18280', '88', '5', '2023', 'Loan', '0.00', '15', '1'),
('18281', '88', '5', '2023', 'Other', '0.00', '16', '1'),
('18282', '88', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18283', '88', '5', '2023', 'NETPAY', '3700000.00', '20', '1'),
('18284', '89', '5', '2023', 'BASIC PAY', '10108129.00', '1', '1'),
('18285', '89', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18286', '89', '5', '2023', 'HOUSING', '1516219.00', '3', '1'),
('18287', '89', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18288', '89', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18289', '89', '5', '2023', 'GROSS SALARY', '11624348.00', '7', '1'),
('18290', '89', '5', '2023', 'NSSF', '1162434.80', '8', '1'),
('18291', '89', '5', '2023', 'TAXABLE INCOME', '10461913.20', '9', '1'),
('18292', '89', '5', '2023', 'PAYE', '2966573.96', '10', '1'),
('18293', '89', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18294', '89', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18295', '89', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18296', '89', '5', '2023', 'LATE', '0.00', '14', '1'),
('18297', '89', '5', '2023', 'Loan', '0.00', '15', '1'),
('18298', '89', '5', '2023', 'Other', '0.00', '16', '1'),
('18299', '89', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18300', '89', '5', '2023', 'NETPAY', '7495339.24', '20', '1'),
('18301', '90', '5', '2023', 'BASIC PAY', '1150749.00', '1', '1'),
('18302', '90', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18303', '90', '5', '2023', 'HOUSING', '172612.00', '3', '1'),
('18304', '90', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18305', '90', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18306', '90', '5', '2023', 'GROSS SALARY', '1323361.00', '7', '1'),
('18307', '90', '5', '2023', 'NSSF', '132336.10', '8', '1'),
('18308', '90', '5', '2023', 'TAXABLE INCOME', '1191024.90', '9', '1'),
('18309', '90', '5', '2023', 'PAYE', '185307.47', '10', '1'),
('18310', '90', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18311', '90', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18312', '90', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18313', '90', '5', '2023', 'LATE', '0.00', '14', '1'),
('18314', '90', '5', '2023', 'Loan', '0.00', '15', '1'),
('18315', '90', '5', '2023', 'Other', '0.00', '16', '1'),
('18316', '90', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18317', '90', '5', '2023', 'NETPAY', '1005717.43', '20', '1'),
('18318', '91', '5', '2023', 'BASIC PAY', '0.00', '1', '1'),
('18319', '91', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18320', '91', '5', '2023', 'HOUSING', '0.00', '3', '1'),
('18321', '91', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18322', '91', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18323', '91', '5', '2023', 'GROSS SALARY', '0.00', '7', '1'),
('18324', '91', '5', '2023', 'NSSF', '0.00', '8', '1'),
('18325', '91', '5', '2023', 'TAXABLE INCOME', '0.00', '9', '1'),
('18326', '91', '5', '2023', 'PAYE', '0.00', '10', '1'),
('18327', '91', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18328', '91', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18329', '91', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18330', '91', '5', '2023', 'LATE', '0.00', '14', '1'),
('18331', '91', '5', '2023', 'Loan', '0.00', '15', '1'),
('18332', '91', '5', '2023', 'Other', '0.00', '16', '1'),
('18333', '91', '5', '2023', 'STAFF LOAN', '80000.00', '18', '1'),
('18334', '91', '5', '2023', 'NETPAY', '-80000.00', '20', '1'),
('18335', '92', '5', '2023', 'BASIC PAY', '502941.00', '1', '1'),
('18336', '92', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18337', '92', '5', '2023', 'HOUSING', '75441.00', '3', '1'),
('18338', '92', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18339', '92', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18340', '92', '5', '2023', 'GROSS SALARY', '578382.00', '7', '1'),
('18341', '92', '5', '2023', 'NSSF', '57838.20', '8', '1'),
('18342', '92', '5', '2023', 'TAXABLE INCOME', '520543.80', '9', '1'),
('18343', '92', '5', '2023', 'PAYE', '20108.76', '10', '1'),
('18344', '92', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18345', '92', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18346', '92', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18347', '92', '5', '2023', 'LATE', '0.00', '14', '1'),
('18348', '92', '5', '2023', 'Loan', '0.00', '15', '1'),
('18349', '92', '5', '2023', 'Other', '0.00', '16', '1'),
('18350', '92', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18351', '92', '5', '2023', 'NETPAY', '500435.04', '20', '1'),
('18352', '93', '5', '2023', 'BASIC PAY', '2523120.00', '1', '1'),
('18353', '93', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18354', '93', '5', '2023', 'HOUSING', '378468.00', '3', '1'),
('18355', '93', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18356', '93', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18357', '93', '5', '2023', 'GROSS SALARY', '2901588.00', '7', '1'),
('18358', '93', '5', '2023', 'NSSF', '290158.80', '8', '1'),
('18359', '93', '5', '2023', 'TAXABLE INCOME', '2611429.20', '9', '1'),
('18360', '93', '5', '2023', 'PAYE', '611428.76', '10', '1'),
('18361', '93', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18362', '93', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18363', '93', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18364', '93', '5', '2023', 'LATE', '0.00', '14', '1'),
('18365', '93', '5', '2023', 'Loan', '0.00', '15', '1'),
('18366', '93', '5', '2023', 'Other', '0.00', '16', '1'),
('18367', '93', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18368', '93', '5', '2023', 'NETPAY', '2000000.44', '20', '1'),
('18369', '94', '5', '2023', 'BASIC PAY', '331476.00', '1', '1'),
('18370', '94', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18371', '94', '5', '2023', 'HOUSING', '49721.00', '3', '1'),
('18372', '94', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18373', '94', '5', '2023', 'OVERTIME', '118481.42', '6', '1'),
('18374', '94', '5', '2023', 'GROSS SALARY', '499678.42', '7', '1'),
('18375', '94', '5', '2023', 'NSSF', '49967.84', '8', '1'),
('18376', '94', '5', '2023', 'TAXABLE INCOME', '449710.58', '9', '1'),
('18377', '94', '5', '2023', 'PAYE', '14376.85', '10', '1'),
('18378', '94', '5', '2023', 'SALARY ADVANCE', '100000.00', '11', '1'),
('18379', '94', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18380', '94', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18381', '94', '5', '2023', 'LATE', '0.00', '14', '1'),
('18382', '94', '5', '2023', 'Loan', '0.00', '15', '1'),
('18383', '94', '5', '2023', 'Other', '0.00', '16', '1'),
('18384', '94', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18385', '94', '5', '2023', 'NETPAY', '335333.73', '20', '1'),
('18386', '95', '5', '2023', 'BASIC PAY', '509979.00', '1', '1'),
('18387', '95', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18388', '95', '5', '2023', 'HOUSING', '76497.00', '3', '1'),
('18389', '95', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18390', '95', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18391', '95', '5', '2023', 'GROSS SALARY', '586476.00', '7', '1'),
('18392', '95', '5', '2023', 'NSSF', '0.00', '8', '1'),
('18393', '95', '5', '2023', 'TAXABLE INCOME', '586476.00', '9', '1'),
('18394', '95', '5', '2023', 'PAYE', '33295.20', '10', '1'),
('18395', '95', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18396', '95', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18397', '95', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18398', '95', '5', '2023', 'LATE', '0.00', '14', '1'),
('18399', '95', '5', '2023', 'Loan', '0.00', '15', '1'),
('18400', '95', '5', '2023', 'Other', '0.00', '16', '1'),
('18401', '95', '5', '2023', 'STAFF LOAN', '140000.00', '18', '1'),
('18402', '95', '5', '2023', 'NETPAY', '413180.80', '20', '1'),
('18403', '96', '5', '2023', 'BASIC PAY', '3676613.00', '1', '1'),
('18404', '96', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18405', '96', '5', '2023', 'HOUSING', '551492.00', '3', '1'),
('18406', '96', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18407', '96', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18408', '96', '5', '2023', 'GROSS SALARY', '4228105.00', '7', '1'),
('18409', '96', '5', '2023', 'NSSF', '422810.50', '8', '1'),
('18410', '96', '5', '2023', 'TAXABLE INCOME', '3805294.50', '9', '1'),
('18411', '96', '5', '2023', 'PAYE', '969588.35', '10', '1'),
('18412', '96', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18413', '96', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18414', '96', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18415', '96', '5', '2023', 'LATE', '0.00', '14', '1'),
('18416', '96', '5', '2023', 'Loan', '0.00', '15', '1'),
('18417', '96', '5', '2023', 'Other', '0.00', '16', '1'),
('18418', '96', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18419', '96', '5', '2023', 'NETPAY', '2835706.15', '20', '1'),
('18420', '97', '5', '2023', 'BASIC PAY', '177293.00', '1', '1'),
('18421', '97', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18422', '97', '5', '2023', 'HOUSING', '26594.00', '3', '1'),
('18423', '97', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18424', '97', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18425', '97', '5', '2023', 'GROSS SALARY', '203887.00', '7', '1'),
('18426', '97', '5', '2023', 'NSSF', '20388.70', '8', '1'),
('18427', '97', '5', '2023', 'TAXABLE INCOME', '183498.30', '9', '1'),
('18428', '97', '5', '2023', 'PAYE', '0.00', '10', '1'),
('18429', '97', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18430', '97', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18431', '97', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18432', '97', '5', '2023', 'LATE', '0.00', '14', '1'),
('18433', '97', '5', '2023', 'Loan', '0.00', '15', '1'),
('18434', '97', '5', '2023', 'Other', '0.00', '16', '1'),
('18435', '97', '5', '2023', 'STAFF LOAN', '50000.00', '18', '1'),
('18436', '97', '5', '2023', 'NETPAY', '133498.30', '20', '1'),
('18437', '98', '5', '2023', 'BASIC PAY', '3370638.00', '1', '1'),
('18438', '98', '5', '2023', 'Allowance', '0.00', '2', '1'),
('18439', '98', '5', '2023', 'HOUSING', '505596.00', '3', '1'),
('18440', '98', '5', '2023', 'LEAVE SOLD', '0.00', '5', '1'),
('18441', '98', '5', '2023', 'OVERTIME', '0.00', '6', '1'),
('18442', '98', '5', '2023', 'GROSS SALARY', '3876234.00', '7', '1'),
('18443', '98', '5', '2023', 'NSSF', '387623.40', '8', '1');
INSERT INTO `salaryfields` (`SalaryFieldId`, `EmpId`, `PayrollMonth`, `PayrollYear`, `SalaryFieldName`, `Amount`, `No`, `CompanyId`) VALUES
('18444', '98', '5', '2023', 'TAXABLE INCOME', '3488610.60', '9', '1'),
('18445', '98', '5', '2023', 'PAYE', '874583.18', '10', '1'),
('18446', '98', '5', '2023', 'SALARY ADVANCE', '0.00', '11', '1'),
('18447', '98', '5', '2023', 'NHIF', '0.00', '12', '1'),
('18448', '98', '5', '2023', 'ABSENT', '0.00', '13', '1'),
('18449', '98', '5', '2023', 'LATE', '0.00', '14', '1'),
('18450', '98', '5', '2023', 'Loan', '0.00', '15', '1'),
('18451', '98', '5', '2023', 'Other', '0.00', '16', '1'),
('18452', '98', '5', '2023', 'STAFF LOAN', '0.00', '18', '1'),
('18453', '98', '5', '2023', 'NETPAY', '2614027.42', '20', '1');

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

--
-- Table structure for table `sdl`
--

CREATE TABLE `sdl` (
  `SdlId` int(11) NOT NULL,
  `Sdlper` decimal(4,2) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `SDLExempt` int(11) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `sdl`
--

INSERT INTO `sdl` (`SdlId`, `Sdlper`, `CompanyId`, `SDLExempt`, `status`) VALUES
(4, '3.50', '1', NULL, '1');

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

--
-- Table structure for table `serial`
--

CREATE TABLE `serial` (
  `SerialID` decimal(18,0) NOT NULL,
  `SerialNo` decimal(18,0) DEFAULT NULL,
  `SerialFlag` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `serial`
--

INSERT INTO `serial` (`SerialID`, `SerialNo`, `SerialFlag`) VALUES
('1', '1001', 0),
('2', '1002', 0),
('3', '1003', 0),
('4', '1004', 0),
('5', '1005', 0),
('6', '1006', 0),
('7', '1007', 0),
('8', '1008', 0),
('9', '1009', 0),
('10', '1010', 0),
('11', '1011', 0),
('12', '1012', 0),
('13', '1013', 0),
('14', '1014', 0),
('15', '1015', 0),
('16', '1016', 0),
('17', '1017', 0),
('18', '1018', 0),
('19', '1019', 0),
('20', '1020', 0),
('21', '1021', 0),
('22', '1022', 0),
('23', '1023', 0),
('24', '1024', 0),
('25', '1025', 0),
('26', '1026', 0),
('27', '1027', 0),
('28', '1028', 0),
('29', '1029', 0),
('30', '1030', 0),
('31', '1031', 0),
('32', '1032', 0),
('33', '1033', 0),
('34', '1034', 0),
('35', '1035', 0),
('36', '1036', 0),
('37', '1037', 0),
('38', '1038', 0),
('39', '1039', 0),
('40', '1040', 0),
('41', '1041', 0),
('42', '1042', 0),
('43', '1043', 0),
('44', '1044', 0),
('45', '1045', 0),
('46', '1046', 0),
('47', '1047', 0),
('48', '1048', 0),
('49', '1049', 0),
('50', '1050', 0),
('51', '1051', 0),
('52', '1052', 0),
('53', '1053', 0),
('54', '1054', 0),
('55', '1055', 0),
('56', '1056', 0),
('57', '1057', 0),
('58', '1058', 0),
('59', '1059', 0),
('60', '1060', 0),
('61', '1061', 0),
('62', '1062', 0),
('63', '1063', 0),
('64', '1064', 0),
('65', '1065', 0),
('66', '1066', 0),
('67', '1067', 0),
('68', '1068', 0),
('69', '1069', 0),
('70', '1070', 0),
('71', '1071', 0),
('72', '1072', 0),
('73', '1073', 0),
('74', '1074', 0),
('75', '1075', 0),
('76', '1076', 0),
('77', '1077', 0),
('78', '1078', 0),
('79', '1079', 0),
('80', '1080', 0),
('81', '1081', 0),
('82', '1082', 0),
('83', '1083', 0),
('84', '1084', 0),
('85', '1085', 0),
('86', '1086', 0),
('87', '1087', 0),
('88', '1088', 0),
('89', '1089', 0),
('90', '1090', 0),
('91', '1091', 0),
('92', '1092', 0),
('93', '1093', 0),
('94', '1094', 0),
('95', '1095', 0),
('96', '1096', 0),
('97', '1097', 0),
('98', '1098', 0),
('99', '1099', 0),
('100', '1100', 0),
('101', '1101', 0),
('102', '1102', 0),
('103', '1103', 0),
('104', '1104', 0),
('105', '1105', 0),
('106', '1106', 0),
('107', '1107', 0),
('108', '1108', 0),
('109', '1109', 0),
('110', '1110', 0),
('111', '1111', 0),
('112', '1112', 0),
('113', '1113', 0),
('114', '1114', 0),
('115', '1115', 0),
('116', '1116', 0),
('117', '1117', 0),
('118', '1118', 0),
('119', '1119', 0),
('120', '1120', 0),
('121', '1121', 0),
('122', '1122', 0),
('123', '1123', 0),
('124', '1124', 0),
('125', '1125', 0),
('126', '1126', 0),
('127', '1127', 0),
('128', '1128', 0),
('129', '1129', 0),
('130', '1130', 0),
('131', '1131', 0),
('132', '1132', 0),
('133', '1133', 0),
('134', '1134', 0),
('135', '1135', 0),
('136', '1136', 0),
('137', '1137', 0),
('138', '1138', 0),
('139', '1139', 0),
('140', '1140', 0),
('141', '1141', 0),
('142', '1142', 0),
('143', '1143', 0),
('144', '1144', 0),
('145', '1145', 0),
('146', '1146', 0),
('147', '1147', 0),
('148', '1148', 0),
('149', '1149', 0),
('150', '1150', 0),
('151', '1151', 0),
('152', '1152', 0),
('153', '1153', 0),
('154', '1154', 0),
('155', '1155', 0),
('156', '1156', 0),
('157', '1157', 0),
('158', '1158', 0),
('159', '1159', 0),
('160', '1160', 0),
('161', '1161', 0),
('162', '1162', 0),
('163', '1163', 0),
('164', '1164', 0),
('165', '1165', 0),
('166', '1166', 0),
('167', '1167', 0),
('168', '1168', 0),
('169', '1169', 0),
('170', '1170', 0),
('171', '1171', 0),
('172', '1172', 0),
('173', '1173', 0),
('174', '1174', 0),
('175', '1175', 0),
('176', '1176', 0),
('177', '1177', 0),
('178', '1178', 0),
('179', '1179', 0),
('180', '1180', 0),
('181', '1181', 0),
('182', '1182', 0),
('183', '1183', 0),
('184', '1184', 0),
('185', '1185', 0),
('186', '1186', 0),
('187', '1187', 0),
('188', '1188', 0),
('189', '1189', 0),
('190', '1190', 0),
('191', '1191', 0),
('192', '1192', 0),
('193', '1193', 0),
('194', '1194', 0),
('195', '1195', 0),
('196', '1196', 0),
('197', '1197', 0),
('198', '1198', 0),
('199', '1199', 0),
('200', '1200', 0),
('201', '1201', 0),
('202', '1202', 0),
('203', '1203', 0),
('204', '1204', 0),
('205', '1205', 0),
('206', '1206', 0),
('207', '1207', 0),
('208', '1208', 0),
('209', '1209', 0),
('210', '1210', 0),
('211', '1211', 0),
('212', '1212', 0),
('213', '1213', 0),
('214', '1214', 0),
('215', '1215', 0),
('216', '1216', 0),
('217', '1217', 0),
('218', '1218', 0),
('219', '1219', 0),
('220', '1220', 0),
('221', '1221', 0),
('222', '1222', 0),
('223', '1223', 0),
('224', '1224', 0),
('225', '1225', 0),
('226', '1226', 0),
('227', '1227', 0),
('228', '1228', 0),
('229', '1229', 0),
('230', '1230', 0),
('231', '1231', 0),
('232', '1232', 0),
('233', '1233', 0),
('234', '1234', 0),
('235', '1235', 0),
('236', '1236', 0),
('237', '1237', 0),
('238', '1238', 0),
('239', '1239', 0),
('240', '1240', 0),
('241', '1241', 0),
('242', '1242', 0),
('243', '1243', 0),
('244', '1245', 0),
('245', '1246', 0),
('246', '1247', 0),
('247', '1248', 0),
('248', '1249', 0),
('249', '1250', 0),
('250', '1251', 0),
('251', '1252', 0),
('252', '1253', 0),
('253', '1254', 0),
('254', '1255', 0),
('255', '1256', 0),
('256', '1257', 0),
('257', '1258', 0),
('258', '1259', 0),
('259', '1260', 0),
('260', '1261', 0),
('261', '1262', 0),
('262', '1263', 0),
('263', '1264', 0),
('264', '1265', 0),
('265', '1266', 0),
('266', '1267', 1);

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

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `street` varchar(255) NOT NULL,
  `tel` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `tin` varchar(255) NOT NULL,
  `fax` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `alert` int(11) NOT NULL,
  `redlist` int(11) NOT NULL,
  `emailpass` varchar(255) NOT NULL,
  `emailhost` varchar(255) NOT NULL,
  `emailport` varchar(255) NOT NULL,
  `smsuser` varchar(255) NOT NULL,
  `smspass` varchar(255) NOT NULL,
  `smsname` varchar(255) NOT NULL,
  `emailstat` varchar(255) NOT NULL,
  `smsstat` varchar(255) NOT NULL,
  `startdate` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `name`, `logo`, `address`, `street`, `tel`, `mobile`, `tin`, `fax`, `email`, `alert`, `redlist`, `emailpass`, `emailhost`, `emailport`, `smsuser`, `smspass`, `smsname`, `emailstat`, `smsstat`, `startdate`) VALUES
(1, 'ETO (T) LTD', 'images/logo.png', 'P O Box 38331', '', '+255 222126966', '+255 713514515', ' 104 - 714 - 218', '+255 222126986', 'info@eto.co.tz', 5, 3, '', 'smtp.gmail.com', '587', '', '', '', 'on', 'on', '2017-04-01');

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

--
-- Table structure for table `shiftmaster`
--

CREATE TABLE `shiftmaster` (
  `ShiftId` int(11) NOT NULL,
  `ShiftName` varchar(50) DEFAULT NULL,
  `CompanyId` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `shifts`
--

CREATE TABLE `shifts` (
  `ShiftId` int(11) NOT NULL,
  `ShiftName` varchar(50) DEFAULT NULL,
  `ShiftDesc` varchar(50) DEFAULT NULL,
  `TimeIn` time DEFAULT NULL,
  `BreakTime` decimal(18,0) DEFAULT NULL,
  `TimeOut` time DEFAULT NULL,
  `GracePeriod` decimal(18,0) DEFAULT NULL,
  `TotalHrs` double DEFAULT NULL,
  `ChkNextDay` varchar(50) DEFAULT NULL,
  `ChkMon` varchar(50) DEFAULT NULL,
  `ChkTue` varchar(50) DEFAULT NULL,
  `ChkWed` varchar(50) DEFAULT NULL,
  `ChkThu` varchar(50) DEFAULT NULL,
  `ChkFri` varchar(50) DEFAULT NULL,
  `ChkSat` varchar(50) DEFAULT NULL,
  `ChkSun` varchar(50) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `shifts`
--

INSERT INTO `shifts` (`ShiftId`, `ShiftName`, `ShiftDesc`, `TimeIn`, `BreakTime`, `TimeOut`, `GracePeriod`, `TotalHrs`, `ChkNextDay`, `ChkMon`, `ChkTue`, `ChkWed`, `ChkThu`, `ChkFri`, `ChkSat`, `ChkSun`, `CompanyId`, `status`) VALUES
(1, 'Morning', 'Morning', '08:30:00', '1', '17:00:00', '10', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1');

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

--
-- Table structure for table `startingovertime`
--

CREATE TABLE `startingovertime` (
  `StartOTId` decimal(18,0) NOT NULL,
  `StartOTDay` decimal(4,2) DEFAULT NULL,
  `StartOTSat` decimal(4,2) DEFAULT NULL,
  `StartOTWEnd` decimal(4,2) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `subdivision`
--

CREATE TABLE `subdivision` (
  `SubDivisionId` int(11) NOT NULL,
  `SubDivisionName` varchar(150) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `subdivision`
--

INSERT INTO `subdivision` (`SubDivisionId`, `SubDivisionName`, `CompanyId`, `status`) VALUES
(1, 'test sub division', '1', '0');

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

--
-- Table structure for table `submenu`
--

CREATE TABLE `submenu` (
  `SubmenuId` int(11) NOT NULL,
  `ParentId` decimal(18,0) NOT NULL,
  `SubmenuName` varchar(50) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL,
  `enable_view` int(11) DEFAULT NULL,
  `enable_add` int(11) DEFAULT NULL,
  `enable_edit` int(11) DEFAULT NULL,
  `enable_delete` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `systemdate`
--

CREATE TABLE `systemdate` (
  `Id` decimal(18,0) DEFAULT NULL,
  `Systemdate` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tallypayrollnames`
--

CREATE TABLE `tallypayrollnames` (
  `TallyPayrollId` decimal(18,0) NOT NULL,
  `PayrollNames` varchar(150) DEFAULT NULL,
  `TallyNames` varchar(150) DEFAULT NULL,
  `DrCr` varchar(50) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tallysetting`
--

CREATE TABLE `tallysetting` (
  `TallySettingId` decimal(18,0) NOT NULL,
  `PortNo` decimal(18,0) DEFAULT NULL,
  `IP` varchar(150) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `tallytransfer`
--

CREATE TABLE `tallytransfer` (
  `TallyTransferId` decimal(18,0) NOT NULL,
  `PayrollMonth` decimal(18,0) DEFAULT NULL,
  `PayrollYear` decimal(18,0) DEFAULT NULL,
  `LedgerName` varchar(150) DEFAULT NULL,
  `LedgerAmount` decimal(15,3) DEFAULT NULL,
  `DrCr` varchar(50) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `taxratetype`
--

CREATE TABLE `taxratetype` (
  `TaxRateTypeId` int(11) NOT NULL,
  `TaxRateName` varchar(150) DEFAULT NULL,
  `TaxRate` decimal(16,2) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `taxratetype`
--

INSERT INTO `taxratetype` (`TaxRateTypeId`, `TaxRateName`, `TaxRate`, `CompanyId`, `status`) VALUES
(1, 'PRIMARY', '0.00', '1', '1'),
(2, 'SECONDARY', '30.00', '1', '1'),
(3, 'DIRECTOR`S FEE (NON FULL TIME)', '15.00', '1', '1'),
(4, 'NON-RESIDENT', '15.00', '1', '1');

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

--
-- Table structure for table `taxtable`
--

CREATE TABLE `taxtable` (
  `TaxId` int(11) NOT NULL,
  `TaxMinRange` decimal(15,0) DEFAULT NULL,
  `TaxMaxRange` decimal(15,0) DEFAULT NULL,
  `TaxPercent` decimal(15,0) DEFAULT NULL,
  `TaxAddAmount` decimal(15,0) DEFAULT NULL,
  `Companyid` decimal(18,0) DEFAULT NULL,
  `Status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `taxtable`
--

INSERT INTO `taxtable` (`TaxId`, `TaxMinRange`, `TaxMaxRange`, `TaxPercent`, `TaxAddAmount`, `Companyid`, `Status`) VALUES
(1, '0', '270000', '0', '0', '1', '1'),
(2, '270001', '520000', '8', '0', '1', '1'),
(3, '520001', '760000', '20', '20000', '1', '1'),
(4, '760001', '1000000', '25', '68000', '1', '1'),
(5, '1000001', '9999999999', '80', '128000', '1', '1');

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

--
-- Table structure for table `terminationtype`
--

CREATE TABLE `terminationtype` (
  `TerminationTypeId` int(11) NOT NULL,
  `TerminationName` varchar(150) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `terminationtype`
--

INSERT INTO `terminationtype` (`TerminationTypeId`, `TerminationName`, `CompanyId`, `status`) VALUES
(1, 'CONTRACT EXPIRY', '1', '1'),
(2, 'Resigned', '1', '1');

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

--
-- Table structure for table `timings`
--

CREATE TABLE `timings` (
  `TimingId` int(11) NOT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `DayTimeIn` time DEFAULT NULL,
  `DayTimeOut` time DEFAULT NULL,
  `DayBreak` double DEFAULT NULL,
  `DayHrsWorked` double DEFAULT NULL,
  `SatTImeIn` time DEFAULT NULL,
  `SatTimeOut` time DEFAULT NULL,
  `SatBreak` double DEFAULT NULL,
  `SatHrsWorked` double DEFAULT NULL,
  `WEndTimeIn` time DEFAULT NULL,
  `WEndTimeOut` time DEFAULT NULL,
  `WEndBreak` double DEFAULT NULL,
  `WEndHrsWorked` double DEFAULT NULL,
  `TimingType` int(11) DEFAULT NULL,
  `OvertimeStart` int(11) DEFAULT NULL,
  `WorkOnWeekEnd` int(11) DEFAULT NULL,
  `TotalHrsDays` decimal(4,2) DEFAULT NULL,
  `TotalHrsSat` decimal(4,2) DEFAULT NULL,
  `WorkSunHol` int(11) DEFAULT NULL,
  `TotalHrsSunHol` decimal(4,2) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `timings`
--

INSERT INTO `timings` (`TimingId`, `CompanyId`, `DayTimeIn`, `DayTimeOut`, `DayBreak`, `DayHrsWorked`, `SatTImeIn`, `SatTimeOut`, `SatBreak`, `SatHrsWorked`, `WEndTimeIn`, `WEndTimeOut`, `WEndBreak`, `WEndHrsWorked`, `TimingType`, `OvertimeStart`, `WorkOnWeekEnd`, `TotalHrsDays`, `TotalHrsSat`, `WorkSunHol`, `TotalHrsSunHol`, `status`) VALUES
(1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, '1');

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

--
-- Table structure for table `tmploantransaction`
--

CREATE TABLE `tmploantransaction` (
  `Id` decimal(18,0) NOT NULL,
  `Month` decimal(18,0) DEFAULT NULL,
  `Year` decimal(18,0) DEFAULT NULL,
  `MonthlyDeduction` double DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tmploantransaction`
--

INSERT INTO `tmploantransaction` (`Id`, `Month`, `Year`, `MonthlyDeduction`) VALUES
('40186', '5', '2023', 80000),
('40187', '6', '2023', 80000),
('40188', '7', '2023', 80000),
('40189', '8', '2023', 80000),
('40190', '9', '2023', 80000),
('40191', '10', '2023', 80000),
('40192', '11', '2023', 80000),
('40193', '12', '2023', 80000),
('40194', '1', '2024', 80000),
('40195', '2', '2024', 80000);

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

--
-- Table structure for table `tuico`
--

CREATE TABLE `tuico` (
  `TuicoId` decimal(18,0) NOT NULL,
  `Tuicoper` decimal(4,2) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `userrights`
--

CREATE TABLE `userrights` (
  `Id` decimal(18,0) NOT NULL,
  `UserId` decimal(18,0) DEFAULT NULL,
  `RightId` decimal(18,0) DEFAULT NULL,
  `Rights` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `userrights`
--

INSERT INTO `userrights` (`Id`, `UserId`, `RightId`, `Rights`) VALUES
('1525', '1', '2', '1111'),
('1526', '1', '3', '1111'),
('1527', '1', '4', '1111'),
('1528', '1', '5', '1111'),
('1529', '1', '6', '1111'),
('1530', '1', '7', '1111'),
('1531', '1', '8', '1111'),
('1532', '1', '9', '1111'),
('1533', '1', '10', '0000'),
('1534', '1', '11', '1111'),
('1535', '1', '12', '1111'),
('1536', '1', '13', '1111'),
('1537', '1', '14', '1111'),
('1538', '1', '15', '1111'),
('1539', '1', '16', '1111'),
('1540', '1', '17', '1111'),
('1541', '1', '18', '1111'),
('1542', '1', '21', '1111'),
('1543', '1', '22', '1111'),
('1544', '1', '23', '0000'),
('1545', '1', '24', '1111'),
('1546', '1', '25', '1111'),
('1547', '1', '26', '0000'),
('1548', '1', '59', '1111'),
('1549', '1', '60', '1111'),
('1550', '1', '78', '0000'),
('1551', '1', '80', '1111'),
('1552', '1', '87', '1111'),
('1553', '1', '106', '1111'),
('1554', '1', '107', '1111'),
('1555', '1', '108', '1111'),
('1556', '1', '109', '1111'),
('1557', '1', '118', '1111'),
('1558', '1', '128', '1111'),
('1559', '1', '129', '1111'),
('1560', '1', '130', '1111'),
('1561', '1', '131', '1111'),
('1562', '1', '132', '1111'),
('1563', '1', '151', '0000'),
('1564', '1', '152', '0000'),
('1565', '1', '28', '1111'),
('1566', '1', '79', '1111'),
('1567', '1', '81', '1111'),
('1568', '1', '99', '0000'),
('1569', '1', '100', '0000'),
('1570', '1', '101', '0000'),
('1571', '1', '160', '0000'),
('1572', '1', '30', '1111'),
('1573', '1', '31', '1111'),
('1574', '1', '32', '1111'),
('1575', '1', '33', '1111'),
('1576', '1', '34', '1111'),
('1577', '1', '35', '1111'),
('1578', '1', '36', '1111'),
('1579', '1', '37', '1111'),
('1580', '1', '53', '1111'),
('1581', '1', '133', '1111'),
('1582', '1', '153', '1111'),
('1583', '1', '161', '0000'),
('1584', '1', '163', '1111'),
('1585', '1', '164', '1111'),
('1586', '1', '165', '1111'),
('1587', '1', '39', '0'),
('1588', '1', '40', '0'),
('1589', '1', '41', '0'),
('1590', '1', '42', '0'),
('1591', '1', '44', '1'),
('1592', '1', '45', '1'),
('1593', '1', '46', '1'),
('1594', '1', '47', '0'),
('1595', '1', '48', '1'),
('1596', '1', '51', '1'),
('1597', '1', '52', '1'),
('1598', '1', '57', '1'),
('1599', '1', '61', '0'),
('1600', '1', '62', '1'),
('1601', '1', '63', '1'),
('1602', '1', '64', '1'),
('1603', '1', '67', '1'),
('1604', '1', '69', '1'),
('1605', '1', '70', '1'),
('1606', '1', '71', '1'),
('1607', '1', '72', '1'),
('1608', '1', '73', '1'),
('1609', '1', '74', '1'),
('1610', '1', '75', '1'),
('1611', '1', '76', '1'),
('1612', '1', '77', '1'),
('1613', '1', '84', '1'),
('1614', '1', '85', '1'),
('1615', '1', '88', '1'),
('1616', '1', '89', '1'),
('1617', '1', '90', '1'),
('1618', '1', '91', '1'),
('1619', '1', '92', '1'),
('1620', '1', '93', '1'),
('1621', '1', '94', '1'),
('1622', '1', '95', '1'),
('1623', '1', '96', '1'),
('1624', '1', '97', '1'),
('1625', '1', '98', '1'),
('1626', '1', '102', '1'),
('1627', '1', '104', '1'),
('1628', '1', '105', '1'),
('1629', '1', '110', '1'),
('1630', '1', '111', '1'),
('1631', '1', '112', '1'),
('1632', '1', '113', '1'),
('1633', '1', '114', '1'),
('1634', '1', '115', '1'),
('1635', '1', '116', '1'),
('1636', '1', '117', '1'),
('1637', '1', '119', '1'),
('1638', '1', '120', '1'),
('1639', '1', '121', '1'),
('1640', '1', '122', '1'),
('1641', '1', '123', '1'),
('1642', '1', '124', '1'),
('1643', '1', '125', '1'),
('1644', '1', '126', '1'),
('1645', '1', '127', '1'),
('1646', '1', '134', '1'),
('1647', '1', '135', '1'),
('1648', '1', '136', '1'),
('1649', '1', '137', '1'),
('1650', '1', '138', '1'),
('1651', '1', '139', '1'),
('1652', '1', '140', '1'),
('1653', '1', '141', '1'),
('1654', '1', '142', '1'),
('1655', '1', '143', '1'),
('1656', '1', '144', '1'),
('1657', '1', '146', '1'),
('1658', '1', '147', '1'),
('1659', '1', '148', '1'),
('1660', '1', '149', '1'),
('1661', '1', '150', '1'),
('1662', '1', '154', '1'),
('1663', '1', '157', '1'),
('1664', '1', '158', '1'),
('1665', '1', '159', '1'),
('1666', '1', '162', '0'),
('1667', '1', '166', '1'),
('1668', '1', '167', '1'),
('1669', '1', '168', '1'),
('1670', '1', '169', '1'),
('1671', '1', '170', '1'),
('1672', '1', '171', '1'),
('1673', '1', '172', '1'),
('1674', '1', '50', '1'),
('1675', '1', '56', '0'),
('1676', '1', '65', '1'),
('1677', '1', '66', '0'),
('1678', '1', '68', '1'),
('1679', '1', '82', '1'),
('1680', '1', '83', '1'),
('1681', '1', '103', '0'),
('1682', '1', '145', '1'),
('1683', '1', '155', '1'),
('1684', '1', '156', '1');

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

--
-- Table structure for table `wcfrate`
--

CREATE TABLE `wcfrate` (
  `Id` int(11) NOT NULL,
  `WCFRate` decimal(17,1) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `WCFEffectedByOT` int(11) DEFAULT NULL,
  `WCFEffectedByLeaveSold` int(11) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `wcfrate`
--

INSERT INTO `wcfrate` (`Id`, `WCFRate`, `CompanyId`, `WCFEffectedByOT`, `WCFEffectedByLeaveSold`, `status`) VALUES
(10, '0.5', '1', 1, 0, '1');

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

--
-- Table structure for table `withholdingtaxrate`
--

CREATE TABLE `withholdingtaxrate` (
  `WHId` int(11) NOT NULL,
  `WHTaxRate` decimal(16,2) DEFAULT NULL,
  `CompanyId` decimal(18,0) DEFAULT NULL,
  `status` decimal(18,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `absent`
--
ALTER TABLE `absent`
  ADD PRIMARY KEY (`absentid`);

--
-- Indexes for table `absent_late`
--
ALTER TABLE `absent_late`
  ADD PRIMARY KEY (`AbId`);

--
-- Indexes for table `adminportalemail`
--
ALTER TABLE `adminportalemail`
  ADD PRIMARY KEY (`AdminPortalId`);

--
-- Indexes for table `advancerequest`
--
ALTER TABLE `advancerequest`
  ADD PRIMARY KEY (`AdvanceId`);

--
-- Indexes for table `attendance`
--
ALTER TABLE `attendance`
  ADD PRIMARY KEY (`AttendanceId`);

--
-- Indexes for table `attendancedownload`
--
ALTER TABLE `attendancedownload`
  ADD PRIMARY KEY (`AttDLoadId`);

--
-- Indexes for table `bank`
--
ALTER TABLE `bank`
  ADD PRIMARY KEY (`BankId`);

--
-- Indexes for table `branch`
--
ALTER TABLE `branch`
  ADD PRIMARY KEY (`BranchId`);

--
-- Indexes for table `casualprocessdates`
--
ALTER TABLE `casualprocessdates`
  ADD PRIMARY KEY (`CasualProcessId`);

--
-- Indexes for table `casualtransaction`
--
ALTER TABLE `casualtransaction`
  ADD PRIMARY KEY (`CasualTrid`);

--
-- Indexes for table `company`
--
ALTER TABLE `company`
  ADD PRIMARY KEY (`CompanyId`);

--
-- Indexes for table `companypaymentdetails`
--
ALTER TABLE `companypaymentdetails`
  ADD PRIMARY KEY (`PaymentDetailId`);

--
-- Indexes for table `companypension`
--
ALTER TABLE `companypension`
  ADD PRIMARY KEY (`CompanyPensionId`);

--
-- Indexes for table `contractclauses`
--
ALTER TABLE `contractclauses`
  ADD PRIMARY KEY (`ContractTrId`);

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

--
-- Indexes for table `department`
--
ALTER TABLE `department`
  ADD PRIMARY KEY (`DeptId`);

--
-- Indexes for table `designation`
--
ALTER TABLE `designation`
  ADD PRIMARY KEY (`DesignationId`);

--
-- Indexes for table `empbankdetails`
--
ALTER TABLE `empbankdetails`
  ADD PRIMARY KEY (`EmpBankId`);

--
-- Indexes for table `empbankverification`
--
ALTER TABLE `empbankverification`
  ADD PRIMARY KEY (`EmpBankVerifyId`);

--
-- Indexes for table `empcontract`
--
ALTER TABLE `empcontract`
  ADD PRIMARY KEY (`EmpContractId`);

--
-- Indexes for table `empcontractdetails`
--
ALTER TABLE `empcontractdetails`
  ADD PRIMARY KEY (`EmpContractDetailsId`);

--
-- Indexes for table `empdeductionsdetails`
--
ALTER TABLE `empdeductionsdetails`
  ADD PRIMARY KEY (`EmpDedId`);

--
-- Indexes for table `empdeductionshistory`
--
ALTER TABLE `empdeductionshistory`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `empdynamicdeductions`
--
ALTER TABLE `empdynamicdeductions`
  ADD PRIMARY KEY (`EmpDynamicDeductionId`);

--
-- Indexes for table `empdynamicpayments`
--
ALTER TABLE `empdynamicpayments`
  ADD PRIMARY KEY (`EmpDynamicPaymentId`);

--
-- Indexes for table `empguarantors`
--
ALTER TABLE `empguarantors`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `empkins`
--
ALTER TABLE `empkins`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `empleavedetails`
--
ALTER TABLE `empleavedetails`
  ADD PRIMARY KEY (`EmpLeaveId`);

--
-- Indexes for table `empleavedetailshistory`
--
ALTER TABLE `empleavedetailshistory`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `employeeitems`
--
ALTER TABLE `employeeitems`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `employeeitemshistory`
--
ALTER TABLE `employeeitemshistory`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `empmonthconsultantsalary`
--
ALTER TABLE `empmonthconsultantsalary`
  ADD PRIMARY KEY (`ProcessWHId`);

--
-- Indexes for table `empmonthdeductions`
--
ALTER TABLE `empmonthdeductions`
  ADD PRIMARY KEY (`EmpMonthDedId`);

--
-- Indexes for table `empmonthloan`
--
ALTER TABLE `empmonthloan`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `empmonthpayments`
--
ALTER TABLE `empmonthpayments`
  ADD PRIMARY KEY (`EmpMonthPaymentId`),
  ADD UNIQUE KEY `EmpMonthPaymentId` (`EmpMonthPaymentId`);

--
-- Indexes for table `empmonthsalary`
--
ALTER TABLE `empmonthsalary`
  ADD PRIMARY KEY (`ProcessId`);

--
-- Indexes for table `emppaymentdetails`
--
ALTER TABLE `emppaymentdetails`
  ADD PRIMARY KEY (`EmpPaymentId`);

--
-- Indexes for table `emppaymentshistory`
--
ALTER TABLE `emppaymentshistory`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `empqualification`
--
ALTER TABLE `empqualification`
  ADD PRIMARY KEY (`EmpQualificationId`);

--
-- Indexes for table `empshiftdetails`
--
ALTER TABLE `empshiftdetails`
  ADD PRIMARY KEY (`EmpShiftid`);

--
-- Indexes for table `empshifthistory`
--
ALTER TABLE `empshifthistory`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `formulas`
--
ALTER TABLE `formulas`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `holidays`
--
ALTER TABLE `holidays`
  ADD PRIMARY KEY (`HolidayId`);

--
-- Indexes for table `housingrate`
--
ALTER TABLE `housingrate`
  ADD PRIMARY KEY (`HousingRateId`);

--
-- Indexes for table `inventoryitems`
--
ALTER TABLE `inventoryitems`
  ADD PRIMARY KEY (`InventoryId`);

--
-- Indexes for table `late`
--
ALTER TABLE `late`
  ADD PRIMARY KEY (`LateId`);

--
-- Indexes for table `leaveapproval`
--
ALTER TABLE `leaveapproval`
  ADD PRIMARY KEY (`LeaveAppId`);

--
-- Indexes for table `leavetransaction`
--
ALTER TABLE `leavetransaction`
  ADD PRIMARY KEY (`LeaveTrId`);

--
-- Indexes for table `leavetype`
--
ALTER TABLE `leavetype`
  ADD PRIMARY KEY (`LeaveId`);

--
-- Indexes for table `loanchange`
--
ALTER TABLE `loanchange`
  ADD PRIMARY KEY (`LoanChangeId`);

--
-- Indexes for table `loaninstallment`
--
ALTER TABLE `loaninstallment`
  ADD PRIMARY KEY (`LoanInstallId`);

--
-- Indexes for table `loanoutstanding`
--
ALTER TABLE `loanoutstanding`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `loanpayment`
--
ALTER TABLE `loanpayment`
  ADD PRIMARY KEY (`LoanPaymentId`);

--
-- Indexes for table `loanrequest`
--
ALTER TABLE `loanrequest`
  ADD PRIMARY KEY (`LReqId`);

--
-- Indexes for table `loantransactions`
--
ALTER TABLE `loantransactions`
  ADD PRIMARY KEY (`LoanTrId`);

--
-- Indexes for table `loantype`
--
ALTER TABLE `loantype`
  ADD PRIMARY KEY (`LoanTypeId`);

--
-- Indexes for table `maindivision`
--
ALTER TABLE `maindivision`
  ADD PRIMARY KEY (`MainDivisionId`);

--
-- Indexes for table `menu`
--
ALTER TABLE `menu`
  ADD PRIMARY KEY (`MenuId`);

--
-- Indexes for table `nationality`
--
ALTER TABLE `nationality`
  ADD PRIMARY KEY (`NationalityId`);

--
-- Indexes for table `nhif`
--
ALTER TABLE `nhif`
  ADD PRIMARY KEY (`NHIFId`);

--
-- Indexes for table `overtime`
--
ALTER TABLE `overtime`
  ADD PRIMARY KEY (`OvertimeId`);

--
-- Indexes for table `overtimerate`
--
ALTER TABLE `overtimerate`
  ADD PRIMARY KEY (`OvertimeId`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`PaymentId`);

--
-- Indexes for table `payrollmonthyear`
--
ALTER TABLE `payrollmonthyear`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `pension`
--
ALTER TABLE `pension`
  ADD PRIMARY KEY (`PensionId`);

--
-- Indexes for table `pensionreceipt`
--
ALTER TABLE `pensionreceipt`
  ADD PRIMARY KEY (`PensionRectId`);

--
-- Indexes for table `pensiontransfer`
--
ALTER TABLE `pensiontransfer`
  ADD PRIMARY KEY (`PensionTransferId`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `processhistory`
--
ALTER TABLE `processhistory`
  ADD PRIMARY KEY (`ProcessHistoryId`);

--
-- Indexes for table `processmaster`
--
ALTER TABLE `processmaster`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `qualification`
--
ALTER TABLE `qualification`
  ADD PRIMARY KEY (`Qualificationid`);

--
-- Indexes for table `religion`
--
ALTER TABLE `religion`
  ADD PRIMARY KEY (`ReligionId`);

--
-- Indexes for table `remindermonth`
--
ALTER TABLE `remindermonth`
  ADD PRIMARY KEY (`ReminderId`);

--
-- Indexes for table `returnitems`
--
ALTER TABLE `returnitems`
  ADD PRIMARY KEY (`ReturnItemId`);

--
-- Indexes for table `rights`
--
ALTER TABLE `rights`
  ADD PRIMARY KEY (`RightsId`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`RoleId`);

--
-- Indexes for table `salaryfields`
--
ALTER TABLE `salaryfields`
  ADD PRIMARY KEY (`SalaryFieldId`);

--
-- Indexes for table `sdl`
--
ALTER TABLE `sdl`
  ADD PRIMARY KEY (`SdlId`);

--
-- Indexes for table `serial`
--
ALTER TABLE `serial`
  ADD PRIMARY KEY (`SerialID`);

--
-- Indexes for table `shiftmaster`
--
ALTER TABLE `shiftmaster`
  ADD PRIMARY KEY (`ShiftId`);

--
-- Indexes for table `shifts`
--
ALTER TABLE `shifts`
  ADD PRIMARY KEY (`ShiftId`);

--
-- Indexes for table `startingovertime`
--
ALTER TABLE `startingovertime`
  ADD PRIMARY KEY (`StartOTId`);

--
-- Indexes for table `subdivision`
--
ALTER TABLE `subdivision`
  ADD PRIMARY KEY (`SubDivisionId`);

--
-- Indexes for table `submenu`
--
ALTER TABLE `submenu`
  ADD PRIMARY KEY (`SubmenuId`);

--
-- Indexes for table `tallypayrollnames`
--
ALTER TABLE `tallypayrollnames`
  ADD PRIMARY KEY (`TallyPayrollId`);

--
-- Indexes for table `tallysetting`
--
ALTER TABLE `tallysetting`
  ADD PRIMARY KEY (`TallySettingId`);

--
-- Indexes for table `tallytransfer`
--
ALTER TABLE `tallytransfer`
  ADD PRIMARY KEY (`TallyTransferId`);

--
-- Indexes for table `taxratetype`
--
ALTER TABLE `taxratetype`
  ADD PRIMARY KEY (`TaxRateTypeId`);

--
-- Indexes for table `taxtable`
--
ALTER TABLE `taxtable`
  ADD PRIMARY KEY (`TaxId`);

--
-- Indexes for table `terminationtype`
--
ALTER TABLE `terminationtype`
  ADD PRIMARY KEY (`TerminationTypeId`);

--
-- Indexes for table `timings`
--
ALTER TABLE `timings`
  ADD PRIMARY KEY (`TimingId`);

--
-- Indexes for table `tmploantransaction`
--
ALTER TABLE `tmploantransaction`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `tuico`
--
ALTER TABLE `tuico`
  ADD PRIMARY KEY (`TuicoId`);

--
-- Indexes for table `userrights`
--
ALTER TABLE `userrights`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `wcfrate`
--
ALTER TABLE `wcfrate`
  ADD PRIMARY KEY (`Id`);

--
-- Indexes for table `withholdingtaxrate`
--
ALTER TABLE `withholdingtaxrate`
  ADD PRIMARY KEY (`WHId`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `absent_late`
--
ALTER TABLE `absent_late`
  MODIFY `AbId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=102;

--
-- AUTO_INCREMENT for table `advancerequest`
--
ALTER TABLE `advancerequest`
  MODIFY `AdvanceId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10071;

--
-- AUTO_INCREMENT for table `bank`
--
ALTER TABLE `bank`
  MODIFY `BankId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `branch`
--
ALTER TABLE `branch`
  MODIFY `BranchId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `casualtransaction`
--
ALTER TABLE `casualtransaction`
  MODIFY `CasualTrid` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `companypaymentdetails`
--
ALTER TABLE `companypaymentdetails`
  MODIFY `PaymentDetailId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

--
-- AUTO_INCREMENT for table `contractclauses`
--
ALTER TABLE `contractclauses`
  MODIFY `ContractTrId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;

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

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

--
-- AUTO_INCREMENT for table `designation`
--
ALTER TABLE `designation`
  MODIFY `DesignationId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

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

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

--
-- AUTO_INCREMENT for table `empdynamicdeductions`
--
ALTER TABLE `empdynamicdeductions`
  MODIFY `EmpDynamicDeductionId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT for table `empdynamicpayments`
--
ALTER TABLE `empdynamicpayments`
  MODIFY `EmpDynamicPaymentId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

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

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

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

--
-- AUTO_INCREMENT for table `empmonthdeductions`
--
ALTER TABLE `empmonthdeductions`
  MODIFY `EmpMonthDedId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=210;

--
-- AUTO_INCREMENT for table `empmonthloan`
--
ALTER TABLE `empmonthloan`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=683;

--
-- AUTO_INCREMENT for table `empmonthpayments`
--
ALTER TABLE `empmonthpayments`
  MODIFY `EmpMonthPaymentId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2618;

--
-- AUTO_INCREMENT for table `empmonthsalary`
--
ALTER TABLE `empmonthsalary`
  MODIFY `ProcessId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2560;

--
-- AUTO_INCREMENT for table `emppaymentdetails`
--
ALTER TABLE `emppaymentdetails`
  MODIFY `EmpPaymentId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80184;

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

--
-- AUTO_INCREMENT for table `empshiftdetails`
--
ALTER TABLE `empshiftdetails`
  MODIFY `EmpShiftid` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `holidays`
--
ALTER TABLE `holidays`
  MODIFY `HolidayId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

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

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

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

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

--
-- AUTO_INCREMENT for table `loaninstallment`
--
ALTER TABLE `loaninstallment`
  MODIFY `LoanInstallId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=86;

--
-- AUTO_INCREMENT for table `loantransactions`
--
ALTER TABLE `loantransactions`
  MODIFY `LoanTrId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `loantype`
--
ALTER TABLE `loantype`
  MODIFY `LoanTypeId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `menu`
--
ALTER TABLE `menu`
  MODIFY `MenuId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

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

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

--
-- AUTO_INCREMENT for table `overtime`
--
ALTER TABLE `overtime`
  MODIFY `OvertimeId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1100;

--
-- AUTO_INCREMENT for table `overtimerate`
--
ALTER TABLE `overtimerate`
  MODIFY `OvertimeId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `PaymentId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10006;

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

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

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

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

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

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `RoleId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

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

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

--
-- AUTO_INCREMENT for table `submenu`
--
ALTER TABLE `submenu`
  MODIFY `SubmenuId` int(11) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `terminationtype`
--
ALTER TABLE `terminationtype`
  MODIFY `TerminationTypeId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `wcfrate`
--
ALTER TABLE `wcfrate`
  MODIFY `Id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `withholdingtaxrate`
--
ALTER TABLE `withholdingtaxrate`
  MODIFY `WHId` int(11) NOT NULL AUTO_INCREMENT;
COMMIT;

