--
-- Host: localhost    Database: unza_payroll
-- ------------------------------------------------------


--
-- Table structure for table `audits`
--

CREATE TABLE `audits` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_type` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `event` varchar(255) NOT NULL,
  `auditable_type` varchar(255) NOT NULL,
  `auditable_id` bigint(20) unsigned NOT NULL,
  `old_values` text DEFAULT NULL,
  `new_values` text DEFAULT NULL,
  `url` text DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` varchar(1023) DEFAULT NULL,
  `tags` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `audits_auditable_type_auditable_id_index` (`auditable_type`,`auditable_id`),
  KEY `audits_user_id_user_type_index` (`user_id`,`user_type`)
) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `audits`
--

INSERT INTO `audits` VALUES (1,NULL,NULL,'created','App\\Models\\PamEmpSalaryScaleNotch',1,'[]','{\"id\":1,\"salary_scale\":7,\"name\":\"Notch One\",\"basic_pay\":\"23549\",\"notch_order\":1,\"description\":\"Salary Notch\",\"created_by\":12,\"updated_by\":12,\"updated_at\":\"2024-01-22 19:41:08\",\"created_at\":\"2024-01-22 19:41:08\"}','artisan migrate:refresh --seed','127.0.0.1','Symfony',NULL,'2024-01-22 17:41:08','2024-01-22 17:41:08'),(2,NULL,NULL,'created','App\\Models\\PamEmpSalaryScaleNotch',4,'[]','{\"id\":4,\"salary_scale\":7,\"name\":\"Notch Two\",\"basic_pay\":\"40000\",\"notch_order\":2,\"description\":\"Salary Notch\",\"created_by\":12,\"updated_by\":12,\"updated_at\":\"2024-01-22 19:41:08\",\"created_at\":\"2024-01-22 19:41:08\"}','artisan migrate:refresh --seed','127.0.0.1','Symfony',NULL,'2024-01-22 17:41:08','2024-01-22 17:41:08'),(3,NULL,NULL,'created','App\\Models\\PamEmpSalaryScaleNotch',5,'[]','{\"id\":5,\"salary_scale\":7,\"name\":\"Notch Two\",\"basic_pay\":\"54000\",\"notch_order\":3,\"description\":\"Salary Notch\",\"created_by\":12,\"updated_by\":12,\"updated_at\":\"2024-01-22 19:41:08\",\"created_at\":\"2024-01-22 19:41:08\"}','artisan migrate:refresh --seed','127.0.0.1','Symfony',NULL,'2024-01-22 17:41:08','2024-01-22 17:41:08'),(4,NULL,NULL,'created','App\\Models\\PamEmpSalaryScaleNotch',6,'[]','{\"id\":6,\"salary_scale\":2,\"name\":\"Notch One\",\"basic_pay\":\"10000\",\"notch_order\":1,\"description\":\"Salary Notch\",\"created_by\":12,\"updated_by\":12,\"updated_at\":\"2024-01-22 19:41:08\",\"created_at\":\"2024-01-22 19:41:08\"}','artisan migrate:refresh --seed','127.0.0.1','Symfony',NULL,'2024-01-22 17:41:08','2024-01-22 17:41:08'),(5,NULL,NULL,'created','App\\Models\\PamEmpSalaryScaleNotch',7,'[]','{\"id\":7,\"salary_scale\":1,\"name\":\"Notch One\",\"basic_pay\":\"20000\",\"notch_order\":1,\"description\":\"Salary Notch\",\"created_by\":12,\"updated_by\":12,\"updated_at\":\"2024-01-22 19:41:08\",\"created_at\":\"2024-01-22 19:41:08\"}','artisan migrate:refresh --seed','127.0.0.1','Symfony',NULL,'2024-01-22 17:41:08','2024-01-22 17:41:08'),(6,NULL,NULL,'created','App\\Models\\PamEmpSalaryScaleNotch',8,'[]','{\"id\":8,\"salary_scale\":35,\"name\":\"Notch One\",\"basic_pay\":\"30000\",\"notch_order\":1,\"description\":\"Salary Notch\",\"created_by\":12,\"updated_by\":12,\"updated_at\":\"2024-01-22 19:41:08\",\"created_at\":\"2024-01-22 19:41:08\"}','artisan migrate:refresh --seed','127.0.0.1','Symfony',NULL,'2024-01-22 17:41:08','2024-01-22 17:41:08'),(7,NULL,NULL,'created','App\\Models\\PamEmpSalaryScaleNotch',9,'[]','{\"id\":9,\"salary_scale\":9,\"name\":\"Notch One\",\"basic_pay\":\"15000\",\"notch_order\":1,\"description\":\"Salary Notch\",\"created_by\":12,\"updated_by\":12,\"updated_at\":\"2024-01-22 19:41:08\",\"created_at\":\"2024-01-22 19:41:08\"}','artisan migrate:refresh --seed','127.0.0.1','Symfony',NULL,'2024-01-22 17:41:08','2024-01-22 17:41:08'),(8,'App\\Models\\User',12,'created','App\\Models\\PamPayroll',1,'[]','{\"code\":\"DEMO\",\"short_description\":\"DEMO\",\"working_days\":\"22\",\"status\":\"active\",\"current_social_security_id\":\"1\",\"current_tax_table_id\":\"1\",\"start_date\":\"2023-01-01 00:00:00\",\"comments\":null,\"current_period_year\":null,\"current_period_month\":null,\"current_pay_run_id\":null,\"created_by\":12,\"updated_by\":12,\"updated_at\":\"2024-01-22 20:02:25\",\"created_at\":\"2024-01-22 20:02:25\",\"id\":1}','http://localhost:8000/pam-payrolls','127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36',NULL,'2024-01-22 18:02:25','2024-01-22 18:02:25'),(9,'App\\Models\\User',12,'created','App\\Models\\PamPayEarnDef',1,'[]','{\"mode_of_calculation\":\"fixed\",\"earn_def_id\":1,\"earn_def_code\":\"BASICPAY\",\"payroll_id\":1,\"status\":\"active\",\"short_description\":\"Basic Pay\",\"created_by\":12,\"updated_by\":12,\"updated_at\":\"2024-01-22 20:02:25\",\"created_at\":\"2024-01-22 20:02:25\",\"id\":1}','http://localhost:8000/pam-payrolls','127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36',NULL,'2024-01-22 18:02:25','2024-01-22 18:02:25'),(10,'App\\Models\\User',12,'created','App\\Models\\PamPayDeduDef',1,'[]','{\"mode_of_calculation\":\"fixed\",\"dedu_def_id\":1,\"dedu_def_code\":\"PAYE\",\"payroll_id\":1,\"status\":\"active\",\"short_description\":\"Pay As You Earn\",\"created_by\":12,\"updated_by\":12,\"updated_at\":\"2024-01-22 20:02:25\",\"created_at\":\"2024-01-22 20:02:25\",\"id\":1}','http://localhost:8000/pam-payrolls','127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36',NULL,'2024-01-22 18:02:25','2024-01-22 18:02:25'),(11,'App\\Models\\User',12,'created','App\\Models\\PamPayDeduDef',2,'[]','{\"mode_of_calculation\":\"fixed\",\"dedu_def_id\":2,\"dedu_def_code\":\"NAPSA\",\"payroll_id\":1,\"status\":\"active\",\"short_description\":\"NAPSA\",\"created_by\":12,\"updated_by\":12,\"updated_at\":\"2024-01-22 20:02:25\",\"created_at\":\"2024-01-22 20:02:25\",\"id\":2}','http://localhost:8000/pam-payrolls','127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36',NULL,'2024-01-22 18:02:25','2024-01-22 18:02:25'),(12,'App\\Models\\User',12,'created','App\\Models\\PamPayRun',1,'[]','{\"payroll_id\":1,\"pay_run_period_id\":1,\"tax_table_id\":\"1\",\"prev_pay_run_id\":null,\"next_pay_run_id\":null,\"pay_run_status\":\"open\",\"active\":true,\"transaction_date\":\"2024-01-22T20:02:25.883819Z\",\"actual_processing_date\":\"2024-01-22T20:02:25.883883Z\",\"release_to_ess\":false,\"created_by\":12,\"updated_by\":12,\"updated_at\":\"2024-01-22 20:02:25\",\"created_at\":\"2024-01-22 20:02:25\",\"id\":1}','http://localhost:8000/pam-payrolls','127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36',NULL,'2024-01-22 18:02:25','2024-01-22 18:02:25'),(13,'App\\Models\\User',12,'updated','App\\Models\\PamPayroll',1,'{\"current_period_year\":null,\"current_period_month\":null,\"current_pay_run_id\":null}','{\"current_period_year\":2023,\"current_period_month\":1,\"current_pay_run_id\":1}','http://localhost:8000/pam-payrolls','127.0.0.1','Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36',NULL,'2024-01-22 18:02:25','2024-01-22 18:02:25'),(14,'App\\Models\\User',13,'updated','App\\Models\\PamPayRun',1,'{\"pay_run_status\":\"open\",\"release_to_ess\":0,\"updated_at\":\"2024-01-22 20:02:25\"}','{\"pay_run_status\":\"closed\",\"release_to_ess\":1,\"updated_at\":\"2024-01-22 20:51:30\"}','http://localhost:8000/pam-pay-runs/1/close-payroll-run','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-22 18:51:30','2024-01-22 18:51:30'),(15,'App\\Models\\User',13,'updated','App\\Models\\PamPayRun',1,'{\"pay_run_status\":\"closed\",\"release_to_ess\":1,\"updated_at\":\"2024-01-22 20:51:30\"}','{\"pay_run_status\":\"open\",\"release_to_ess\":0,\"updated_at\":\"2024-01-22 20:52:08\"}','http://localhost:8000/pam-pay-runs/1/open-payroll-run','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-22 18:52:08','2024-01-22 18:52:08'),(16,'App\\Models\\User',13,'updated','App\\Models\\PamPayRun',1,'{\"pay_run_status\":\"open\",\"release_to_ess\":0,\"updated_at\":\"2024-01-22 20:52:08\"}','{\"pay_run_status\":\"closed\",\"release_to_ess\":1,\"updated_at\":\"2024-01-22 20:53:15\"}','http://localhost:8000/pam-pay-runs/1/close-payroll-run','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-22 18:53:15','2024-01-22 18:53:15'),(20,'App\\Models\\User',13,'updated','App\\Models\\PamPayRun',1,'{\"pay_run_status\":\"closed\",\"release_to_ess\":1,\"updated_at\":\"2024-01-22 20:53:15\"}','{\"pay_run_status\":\"open\",\"release_to_ess\":0,\"updated_at\":\"2024-01-22 21:03:59\"}','http://localhost:8000/pam-pay-runs/1/open-payroll-run','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-22 19:03:59','2024-01-22 19:03:59'),(21,'App\\Models\\User',13,'updated','App\\Models\\PamPayRun',1,'{\"pay_run_status\":\"open\",\"release_to_ess\":0,\"updated_at\":\"2024-01-22 21:03:59\"}','{\"pay_run_status\":\"closed\",\"release_to_ess\":1,\"updated_at\":\"2024-01-22 21:04:12\"}','http://localhost:8000/pam-pay-runs/1/close-payroll-run','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-22 19:04:12','2024-01-22 19:04:12'),(22,'App\\Models\\User',13,'updated','App\\Models\\PamPayRun',1,'{\"pay_run_status\":\"closed\",\"release_to_ess\":1,\"updated_at\":\"2024-01-22 21:04:12\"}','{\"pay_run_status\":\"open\",\"release_to_ess\":0,\"updated_at\":\"2024-01-22 21:36:12\"}','http://localhost:8000/pam-pay-runs/1/open-payroll-run','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-22 19:36:12','2024-01-22 19:36:12'),(23,'App\\Models\\User',12,'updated','App\\Models\\User',12,'{\"remember_token\":\"kOdlYcgsunUZHffktGoyg78Y1RCNRxX6YHXiXDLQL7k8RTDr9AhOd0uZ0l4S\"}','{\"remember_token\":\"prZzgrBHmhPIrt9XO6GnMCek58DVze9H9X5XgGIpSJ96l2qSnkrSYHICDAcN\"}','http://localhost:8000/logout','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:32:33','2024-01-23 07:32:33'),(24,'App\\Models\\User',13,'updated','App\\Models\\PamPayRun',1,'{\"pay_run_status\":\"open\",\"release_to_ess\":0,\"updated_at\":\"2024-01-22 21:36:12\"}','{\"pay_run_status\":\"closed\",\"release_to_ess\":1,\"updated_at\":\"2024-01-23 09:33:09\"}','http://localhost:8000/pam-pay-runs/1/close-payroll-run','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:33:09','2024-01-23 07:33:09'),(25,'App\\Models\\User',13,'updated','App\\Models\\PamPayRun',1,'{\"pay_run_status\":\"closed\",\"release_to_ess\":1,\"updated_at\":\"2024-01-23 09:33:09\"}','{\"pay_run_status\":\"open\",\"release_to_ess\":0,\"updated_at\":\"2024-01-23 09:35:10\"}','http://localhost:8000/pam-pay-runs/1/open-payroll-run','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:10','2024-01-23 07:35:10'),(26,'App\\Models\\User',13,'updated','App\\Models\\PamEmp',15,'{\"updated_at\":\"2024-01-16 13:47:52\",\"payroll_id\":null}','{\"updated_at\":\"2024-01-23 09:35:20\",\"payroll_id\":\"1\"}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:20','2024-01-23 07:35:20'),(27,'App\\Models\\User',13,'created','App\\Models\\PamPayslip',1,'[]','{\"emp_id\":15,\"pay_run_id\":1,\"pay_run_period_id\":1,\"gross_earnings\":0,\"deductions\":0,\"net_pay\":0,\"leave_days\":0,\"payed_total_year_to_date\":0,\"taxable_income\":0,\"non_taxable_income\":0,\"tax_paid\":0,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:35:20\",\"updated_at\":\"2024-01-23 09:35:20\",\"id\":1}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:20','2024-01-23 07:35:20'),(28,'App\\Models\\User',13,'created','App\\Models\\PamEmpEarnDef',1,'[]','{\"emp_id\":15,\"earn_def_id\":1,\"payroll_id\":1,\"earn_def_code\":\"BASICPAY\",\"short_description\":\"Basic Pay\",\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"start_date\":\"2023-01-31 23:59:59\",\"status\":\"active\",\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:35:20\",\"created_at\":\"2024-01-23 09:35:20\",\"id\":1}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:20','2024-01-23 07:35:20'),(29,'App\\Models\\User',13,'created','App\\Models\\PamPayslipEarnDef',1,'[]','{\"emp_id\":15,\"man_number\":\"8588\",\"earn_def_id\":1,\"pay_run_id\":1,\"payslip_id\":1,\"pay_run_period_id\":1,\"earn_def_code\":\"BASICPAY\",\"units\":22,\"emp_rate\":909.0909090909091,\"input_amount\":20000,\"amount\":20000,\"mandatory\":true,\"earn_type_code\":\"BASIC\",\"earn_group_code\":\"TAXABLE\",\"start_date\":\"2023-01-31 23:59:59\",\"created_by\":13,\"updated_by\":13,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"updated_at\":\"2024-01-23 09:35:20\",\"created_at\":\"2024-01-23 09:35:20\",\"id\":1}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:20','2024-01-23 07:35:20'),(30,'App\\Models\\User',13,'created','App\\Models\\PamPayslipEarn',1,'[]','{\"earn_def_id\":1,\"earn_def_code\":\"BASICPAY\",\"payslip_id\":1,\"emp_id\":15,\"man_number\":\"8588\",\"pay_run_id\":1,\"pay_run_period_id\":1,\"units\":22,\"fixed_amount\":20000,\"recurrence_amount\":20000,\"recurrence_count\":1,\"amount\":20000,\"total\":20000,\"previous_total\":20000,\"taxable_amount\":20000,\"balance\":20000,\"month_to_date_total\":20000,\"year_to_date_total\":20000,\"month_to_date_units\":22,\"year_to_date_units\":22,\"month_to_date_taxable_amount\":20000,\"year_to_date_taxable_amount\":20000,\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"earn_group_code\":\"TAXABLE\",\"earn_type_code\":\"BASIC\",\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:35:20\",\"updated_at\":\"2024-01-23 09:35:20\",\"id\":1}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:20','2024-01-23 07:35:20'),(31,'App\\Models\\User',13,'created','App\\Models\\PamEmpDeduDef',1,'[]','{\"emp_id\":15,\"dedu_def_id\":1,\"payroll_id\":1,\"dedu_def_code\":\"PAYE\",\"short_description\":\"Pay As You Earn\",\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"start_date\":\"2023-01-31 23:59:59\",\"status\":\"active\",\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:35:20\",\"created_at\":\"2024-01-23 09:35:20\",\"id\":1}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:20','2024-01-23 07:35:20'),(32,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',1,'[]','{\"emp_id\":15,\"man_number\":\"8588\",\"dedu_def_id\":1,\"pay_run_id\":1,\"payslip_id\":1,\"pay_run_period_id\":1,\"dedu_def_code\":\"PAYE\",\"units\":1,\"emp_rate\":1,\"input_amount\":0,\"amount\":0,\"mandatory\":true,\"dedu_type_code\":\"INCTAX\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"created_by\":13,\"updated_by\":13,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"updated_at\":\"2024-01-23 09:35:20\",\"created_at\":\"2024-01-23 09:35:20\",\"id\":1}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:20','2024-01-23 07:35:20'),(33,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',1,'[]','{\"dedu_def_id\":1,\"dedu_def_code\":\"PAYE\",\"payslip_id\":1,\"emp_id\":15,\"man_number\":\"8588\",\"pay_run_id\":1,\"pay_run_period_id\":1,\"units\":1,\"fixed_amount\":0,\"recurrence_amount\":0,\"recurrence_count\":1,\"amount\":0,\"total\":0,\"previous_total\":0,\"taxable_amount\":0,\"balance\":0,\"month_to_date_total\":0,\"year_to_date_total\":0,\"month_to_date_units\":1,\"year_to_date_units\":1,\"month_to_date_taxable_amount\":0,\"year_to_date_taxable_amount\":0,\"dedu_type_code\":\"INCTAX\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:35:20\",\"updated_at\":\"2024-01-23 09:35:20\",\"id\":1}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:20','2024-01-23 07:35:20'),(34,'App\\Models\\User',13,'created','App\\Models\\PamEmpDeduDef',2,'[]','{\"emp_id\":15,\"dedu_def_id\":2,\"payroll_id\":1,\"dedu_def_code\":\"NAPSA\",\"short_description\":\"NAPSA\",\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"start_date\":\"2023-01-31 23:59:59\",\"status\":\"active\",\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:35:20\",\"created_at\":\"2024-01-23 09:35:20\",\"id\":2}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:20','2024-01-23 07:35:20'),(35,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',2,'[]','{\"emp_id\":15,\"man_number\":\"8588\",\"dedu_def_id\":2,\"pay_run_id\":1,\"payslip_id\":1,\"pay_run_period_id\":1,\"dedu_def_code\":\"NAPSA\",\"units\":1,\"emp_rate\":1,\"input_amount\":0,\"amount\":0,\"mandatory\":true,\"dedu_type_code\":\"SOCIALSECURITY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"created_by\":13,\"updated_by\":13,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"updated_at\":\"2024-01-23 09:35:20\",\"created_at\":\"2024-01-23 09:35:20\",\"id\":2}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(36,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',2,'[]','{\"dedu_def_id\":2,\"dedu_def_code\":\"NAPSA\",\"payslip_id\":1,\"emp_id\":15,\"man_number\":\"8588\",\"pay_run_id\":1,\"pay_run_period_id\":1,\"units\":1,\"fixed_amount\":0,\"recurrence_amount\":0,\"recurrence_count\":1,\"amount\":0,\"total\":0,\"previous_total\":0,\"taxable_amount\":0,\"balance\":0,\"month_to_date_total\":0,\"year_to_date_total\":0,\"month_to_date_units\":1,\"year_to_date_units\":1,\"month_to_date_taxable_amount\":0,\"year_to_date_taxable_amount\":0,\"dedu_type_code\":\"SOCIALSECURITY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:35:21\",\"updated_at\":\"2024-01-23 09:35:21\",\"id\":2}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(37,'App\\Models\\User',13,'created','App\\Models\\PamEmpDeduDef',3,'[]','{\"emp_id\":15,\"dedu_def_id\":5,\"payroll_id\":1,\"dedu_def_code\":\"PEL\",\"short_description\":\"Personal Levy\",\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"start_date\":\"2023-01-31 23:59:59\",\"status\":\"active\",\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:35:21\",\"created_at\":\"2024-01-23 09:35:21\",\"id\":3}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(38,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',3,'[]','{\"emp_id\":15,\"man_number\":\"8588\",\"dedu_def_id\":5,\"pay_run_id\":1,\"payslip_id\":1,\"pay_run_period_id\":1,\"dedu_def_code\":\"PEL\",\"units\":1,\"emp_rate\":1,\"input_amount\":\"7.50\",\"amount\":\"7.50\",\"mandatory\":true,\"dedu_type_code\":\"LEVY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"created_by\":13,\"updated_by\":13,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"updated_at\":\"2024-01-23 09:35:21\",\"created_at\":\"2024-01-23 09:35:21\",\"id\":3}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(39,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',3,'[]','{\"dedu_def_id\":5,\"dedu_def_code\":\"PEL\",\"payslip_id\":1,\"emp_id\":15,\"man_number\":\"8588\",\"pay_run_id\":1,\"pay_run_period_id\":1,\"units\":1,\"fixed_amount\":\"7.50\",\"recurrence_amount\":\"7.50\",\"recurrence_count\":1,\"amount\":\"7.50\",\"total\":\"7.50\",\"previous_total\":\"7.50\",\"taxable_amount\":\"7.50\",\"balance\":\"7.50\",\"month_to_date_total\":\"7.50\",\"year_to_date_total\":\"7.50\",\"month_to_date_units\":1,\"year_to_date_units\":1,\"month_to_date_taxable_amount\":\"7.50\",\"year_to_date_taxable_amount\":\"7.50\",\"dedu_type_code\":\"LEVY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:35:21\",\"updated_at\":\"2024-01-23 09:35:21\",\"id\":3}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(40,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',4,'[]','{\"emp_id\":15,\"man_number\":\"8588\",\"dedu_def_id\":2,\"pay_run_id\":1,\"payslip_id\":1,\"pay_run_period_id\":1,\"dedu_def_code\":\"NAPSA\",\"units\":22,\"emp_rate\":1,\"input_amount\":0,\"amount\":0,\"mandatory\":true,\"dedu_type_code\":\"SOCIALSECURITY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"created_by\":13,\"updated_by\":13,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"updated_at\":\"2024-01-23 09:35:21\",\"created_at\":\"2024-01-23 09:35:21\",\"id\":4}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(41,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',4,'[]','{\"dedu_def_id\":2,\"dedu_def_code\":\"NAPSA\",\"payslip_id\":1,\"emp_id\":15,\"man_number\":\"8588\",\"pay_run_id\":1,\"pay_run_period_id\":1,\"units\":22,\"fixed_amount\":0,\"recurrence_amount\":0,\"recurrence_count\":1,\"amount\":0,\"total\":0,\"previous_total\":0,\"taxable_amount\":0,\"balance\":0,\"month_to_date_total\":0,\"year_to_date_total\":0,\"month_to_date_units\":22,\"year_to_date_units\":22,\"month_to_date_taxable_amount\":0,\"year_to_date_taxable_amount\":0,\"dedu_type_code\":\"SOCIALSECURITY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:35:21\",\"updated_at\":\"2024-01-23 09:35:21\",\"id\":4}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(42,'App\\Models\\User',13,'updated','App\\Models\\PamPayslipDeduDef',4,'{\"units\":22,\"input_amount\":0,\"amount\":0}','{\"units\":\"22.00\",\"input_amount\":1000,\"amount\":1000}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(43,'App\\Models\\User',13,'updated','App\\Models\\PamPayslipDedu',4,'{\"fixed_amount\":\"0.00\",\"recurrence_amount\":\"0.00\",\"amount\":\"0.00\",\"total\":\"0.00\",\"previous_total\":\"0.00\",\"taxable_amount\":\"0.00\",\"balance\":\"0.00\",\"month_to_date_total\":\"0.00\",\"year_to_date_total\":\"0.00\",\"month_to_date_taxable_amount\":\"0.00\",\"year_to_date_taxable_amount\":\"0.00\"}','{\"fixed_amount\":1000,\"recurrence_amount\":1000,\"amount\":1000,\"total\":1000,\"previous_total\":1000,\"taxable_amount\":1000,\"balance\":1000,\"month_to_date_total\":1000,\"year_to_date_total\":1000,\"month_to_date_taxable_amount\":1000,\"year_to_date_taxable_amount\":1000}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(44,'App\\Models\\User',13,'updated','App\\Models\\PamPayslipDedu',4,'{\"amount\":\"1000.00\"}','{\"amount\":1000}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(45,'App\\Models\\User',13,'updated','App\\Models\\PamPayslipDeduDef',1,'{\"units\":\"1.00\",\"input_amount\":\"0.00\",\"amount\":\"0.00\",\"updated_at\":\"2024-01-23 09:35:20\"}','{\"units\":\"22.00\",\"input_amount\":5192.5025,\"amount\":5192.5025,\"updated_at\":\"2024-01-23 09:35:21\"}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(46,'App\\Models\\User',13,'updated','App\\Models\\PamPayslipDedu',1,'{\"units\":\"1.00\",\"amount\":\"0.00\",\"updated_at\":\"2024-01-23 09:35:20\"}','{\"units\":\"22.00\",\"amount\":5192.5025,\"updated_at\":\"2024-01-23 09:35:21\"}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(47,'App\\Models\\User',13,'updated','App\\Models\\PamPayslip',1,'{\"gross_earnings\":\"0.00\",\"deductions\":\"0.00\",\"net_pay\":\"0.00\",\"taxable_income\":\"0.00\",\"non_taxable_income\":\"0.00\",\"tax_paid\":\"0.00\",\"updated_at\":\"2024-01-23 09:35:20\"}','{\"gross_earnings\":\"20000.00\",\"deductions\":\"6200.00\",\"net_pay\":13800,\"taxable_income\":\"20000.00\",\"non_taxable_income\":0,\"tax_paid\":5192.5025,\"updated_at\":\"2024-01-23 09:35:21\"}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(48,'App\\Models\\User',13,'updated','App\\Models\\PamEmp',13,'{\"updated_at\":\"2024-01-16 09:28:23\",\"payroll_id\":null}','{\"updated_at\":\"2024-01-23 09:35:26\",\"payroll_id\":\"1\"}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:26','2024-01-23 07:35:26'),(49,'App\\Models\\User',13,'created','App\\Models\\PamPayslip',2,'[]','{\"emp_id\":13,\"pay_run_id\":1,\"pay_run_period_id\":1,\"gross_earnings\":0,\"deductions\":0,\"net_pay\":0,\"leave_days\":0,\"payed_total_year_to_date\":0,\"taxable_income\":0,\"non_taxable_income\":0,\"tax_paid\":0,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:35:26\",\"updated_at\":\"2024-01-23 09:35:26\",\"id\":2}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:26','2024-01-23 07:35:26'),(50,'App\\Models\\User',13,'created','App\\Models\\PamEmpEarnDef',2,'[]','{\"emp_id\":13,\"earn_def_id\":1,\"payroll_id\":1,\"earn_def_code\":\"BASICPAY\",\"short_description\":\"Basic Pay\",\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"start_date\":\"2023-01-31 23:59:59\",\"status\":\"active\",\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:35:26\",\"created_at\":\"2024-01-23 09:35:26\",\"id\":2}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:26','2024-01-23 07:35:26'),(51,'App\\Models\\User',13,'created','App\\Models\\PamPayslipEarnDef',2,'[]','{\"emp_id\":13,\"man_number\":\"10574\",\"earn_def_id\":1,\"pay_run_id\":1,\"payslip_id\":2,\"pay_run_period_id\":1,\"earn_def_code\":\"BASICPAY\",\"units\":22,\"emp_rate\":2454.5454545454545,\"input_amount\":54000,\"amount\":54000,\"mandatory\":true,\"earn_type_code\":\"BASIC\",\"earn_group_code\":\"TAXABLE\",\"start_date\":\"2023-01-31 23:59:59\",\"created_by\":13,\"updated_by\":13,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"updated_at\":\"2024-01-23 09:35:26\",\"created_at\":\"2024-01-23 09:35:26\",\"id\":2}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:26','2024-01-23 07:35:26'),(52,'App\\Models\\User',13,'created','App\\Models\\PamPayslipEarn',2,'[]','{\"earn_def_id\":1,\"earn_def_code\":\"BASICPAY\",\"payslip_id\":2,\"emp_id\":13,\"man_number\":\"10574\",\"pay_run_id\":1,\"pay_run_period_id\":1,\"units\":22,\"fixed_amount\":54000,\"recurrence_amount\":54000,\"recurrence_count\":1,\"amount\":54000,\"total\":54000,\"previous_total\":54000,\"taxable_amount\":54000,\"balance\":54000,\"month_to_date_total\":54000,\"year_to_date_total\":54000,\"month_to_date_units\":22,\"year_to_date_units\":22,\"month_to_date_taxable_amount\":54000,\"year_to_date_taxable_amount\":54000,\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"earn_group_code\":\"TAXABLE\",\"earn_type_code\":\"BASIC\",\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:35:26\",\"updated_at\":\"2024-01-23 09:35:26\",\"id\":2}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:26','2024-01-23 07:35:26'),(53,'App\\Models\\User',13,'created','App\\Models\\PamEmpDeduDef',4,'[]','{\"emp_id\":13,\"dedu_def_id\":1,\"payroll_id\":1,\"dedu_def_code\":\"PAYE\",\"short_description\":\"Pay As You Earn\",\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"start_date\":\"2023-01-31 23:59:59\",\"status\":\"active\",\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:35:26\",\"created_at\":\"2024-01-23 09:35:26\",\"id\":4}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:26','2024-01-23 07:35:26'),(54,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',5,'[]','{\"emp_id\":13,\"man_number\":\"10574\",\"dedu_def_id\":1,\"pay_run_id\":1,\"payslip_id\":2,\"pay_run_period_id\":1,\"dedu_def_code\":\"PAYE\",\"units\":1,\"emp_rate\":1,\"input_amount\":0,\"amount\":0,\"mandatory\":true,\"dedu_type_code\":\"INCTAX\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"created_by\":13,\"updated_by\":13,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"updated_at\":\"2024-01-23 09:35:26\",\"created_at\":\"2024-01-23 09:35:26\",\"id\":5}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:26','2024-01-23 07:35:26'),(55,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',5,'[]','{\"dedu_def_id\":1,\"dedu_def_code\":\"PAYE\",\"payslip_id\":2,\"emp_id\":13,\"man_number\":\"10574\",\"pay_run_id\":1,\"pay_run_period_id\":1,\"units\":1,\"fixed_amount\":0,\"recurrence_amount\":0,\"recurrence_count\":1,\"amount\":0,\"total\":0,\"previous_total\":0,\"taxable_amount\":0,\"balance\":0,\"month_to_date_total\":0,\"year_to_date_total\":0,\"month_to_date_units\":1,\"year_to_date_units\":1,\"month_to_date_taxable_amount\":0,\"year_to_date_taxable_amount\":0,\"dedu_type_code\":\"INCTAX\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:35:27\",\"updated_at\":\"2024-01-23 09:35:27\",\"id\":5}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(56,'App\\Models\\User',13,'created','App\\Models\\PamEmpDeduDef',5,'[]','{\"emp_id\":13,\"dedu_def_id\":2,\"payroll_id\":1,\"dedu_def_code\":\"NAPSA\",\"short_description\":\"NAPSA\",\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"start_date\":\"2023-01-31 23:59:59\",\"status\":\"active\",\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:35:27\",\"created_at\":\"2024-01-23 09:35:27\",\"id\":5}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(57,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',6,'[]','{\"emp_id\":13,\"man_number\":\"10574\",\"dedu_def_id\":2,\"pay_run_id\":1,\"payslip_id\":2,\"pay_run_period_id\":1,\"dedu_def_code\":\"NAPSA\",\"units\":1,\"emp_rate\":1,\"input_amount\":0,\"amount\":0,\"mandatory\":true,\"dedu_type_code\":\"SOCIALSECURITY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"created_by\":13,\"updated_by\":13,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"updated_at\":\"2024-01-23 09:35:27\",\"created_at\":\"2024-01-23 09:35:27\",\"id\":6}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(58,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',6,'[]','{\"dedu_def_id\":2,\"dedu_def_code\":\"NAPSA\",\"payslip_id\":2,\"emp_id\":13,\"man_number\":\"10574\",\"pay_run_id\":1,\"pay_run_period_id\":1,\"units\":1,\"fixed_amount\":0,\"recurrence_amount\":0,\"recurrence_count\":1,\"amount\":0,\"total\":0,\"previous_total\":0,\"taxable_amount\":0,\"balance\":0,\"month_to_date_total\":0,\"year_to_date_total\":0,\"month_to_date_units\":1,\"year_to_date_units\":1,\"month_to_date_taxable_amount\":0,\"year_to_date_taxable_amount\":0,\"dedu_type_code\":\"SOCIALSECURITY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:35:27\",\"updated_at\":\"2024-01-23 09:35:27\",\"id\":6}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(59,'App\\Models\\User',13,'created','App\\Models\\PamEmpDeduDef',6,'[]','{\"emp_id\":13,\"dedu_def_id\":5,\"payroll_id\":1,\"dedu_def_code\":\"PEL\",\"short_description\":\"Personal Levy\",\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"start_date\":\"2023-01-31 23:59:59\",\"status\":\"active\",\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:35:27\",\"created_at\":\"2024-01-23 09:35:27\",\"id\":6}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(60,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',7,'[]','{\"emp_id\":13,\"man_number\":\"10574\",\"dedu_def_id\":5,\"pay_run_id\":1,\"payslip_id\":2,\"pay_run_period_id\":1,\"dedu_def_code\":\"PEL\",\"units\":1,\"emp_rate\":1,\"input_amount\":\"7.50\",\"amount\":\"7.50\",\"mandatory\":true,\"dedu_type_code\":\"LEVY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"created_by\":13,\"updated_by\":13,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"updated_at\":\"2024-01-23 09:35:27\",\"created_at\":\"2024-01-23 09:35:27\",\"id\":7}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(61,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',7,'[]','{\"dedu_def_id\":5,\"dedu_def_code\":\"PEL\",\"payslip_id\":2,\"emp_id\":13,\"man_number\":\"10574\",\"pay_run_id\":1,\"pay_run_period_id\":1,\"units\":1,\"fixed_amount\":\"7.50\",\"recurrence_amount\":\"7.50\",\"recurrence_count\":1,\"amount\":\"7.50\",\"total\":\"7.50\",\"previous_total\":\"7.50\",\"taxable_amount\":\"7.50\",\"balance\":\"7.50\",\"month_to_date_total\":\"7.50\",\"year_to_date_total\":\"7.50\",\"month_to_date_units\":1,\"year_to_date_units\":1,\"month_to_date_taxable_amount\":\"7.50\",\"year_to_date_taxable_amount\":\"7.50\",\"dedu_type_code\":\"LEVY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:35:27\",\"updated_at\":\"2024-01-23 09:35:27\",\"id\":7}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(62,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',8,'[]','{\"emp_id\":13,\"man_number\":\"10574\",\"dedu_def_id\":2,\"pay_run_id\":1,\"payslip_id\":2,\"pay_run_period_id\":1,\"dedu_def_code\":\"NAPSA\",\"units\":22,\"emp_rate\":1,\"input_amount\":0,\"amount\":0,\"mandatory\":true,\"dedu_type_code\":\"SOCIALSECURITY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"created_by\":13,\"updated_by\":13,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"updated_at\":\"2024-01-23 09:35:27\",\"created_at\":\"2024-01-23 09:35:27\",\"id\":8}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(63,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',8,'[]','{\"dedu_def_id\":2,\"dedu_def_code\":\"NAPSA\",\"payslip_id\":2,\"emp_id\":13,\"man_number\":\"10574\",\"pay_run_id\":1,\"pay_run_period_id\":1,\"units\":22,\"fixed_amount\":0,\"recurrence_amount\":0,\"recurrence_count\":1,\"amount\":0,\"total\":0,\"previous_total\":0,\"taxable_amount\":0,\"balance\":0,\"month_to_date_total\":0,\"year_to_date_total\":0,\"month_to_date_units\":22,\"year_to_date_units\":22,\"month_to_date_taxable_amount\":0,\"year_to_date_taxable_amount\":0,\"dedu_type_code\":\"SOCIALSECURITY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:35:27\",\"updated_at\":\"2024-01-23 09:35:27\",\"id\":8}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(64,'App\\Models\\User',13,'updated','App\\Models\\PamPayslipDeduDef',8,'{\"units\":22,\"input_amount\":0,\"amount\":0}','{\"units\":\"22.00\",\"input_amount\":\"1221.81\",\"amount\":\"1221.81\"}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(65,'App\\Models\\User',13,'updated','App\\Models\\PamPayslipDedu',8,'{\"fixed_amount\":\"0.00\",\"recurrence_amount\":\"0.00\",\"amount\":\"0.00\",\"total\":\"0.00\",\"previous_total\":\"0.00\",\"taxable_amount\":\"0.00\",\"balance\":\"0.00\",\"month_to_date_total\":\"0.00\",\"year_to_date_total\":\"0.00\",\"month_to_date_taxable_amount\":\"0.00\",\"year_to_date_taxable_amount\":\"0.00\"}','{\"fixed_amount\":\"1221.81\",\"recurrence_amount\":\"1221.81\",\"amount\":\"1221.81\",\"total\":\"1221.81\",\"previous_total\":\"1221.81\",\"taxable_amount\":\"1221.81\",\"balance\":\"1221.81\",\"month_to_date_total\":\"1221.81\",\"year_to_date_total\":\"1221.81\",\"month_to_date_taxable_amount\":\"1221.81\",\"year_to_date_taxable_amount\":\"1221.81\"}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(66,'App\\Models\\User',13,'updated','App\\Models\\PamPayslipDeduDef',5,'{\"units\":\"1.00\",\"input_amount\":\"0.00\",\"amount\":\"0.00\",\"updated_at\":\"2024-01-23 09:35:26\"}','{\"units\":\"22.00\",\"input_amount\":17942.5025,\"amount\":17942.5025,\"updated_at\":\"2024-01-23 09:35:27\"}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(67,'App\\Models\\User',13,'updated','App\\Models\\PamPayslipDedu',5,'{\"units\":\"1.00\",\"amount\":\"0.00\"}','{\"units\":\"22.00\",\"amount\":17942.5025}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(68,'App\\Models\\User',13,'updated','App\\Models\\PamPayslip',2,'{\"gross_earnings\":\"0.00\",\"deductions\":\"0.00\",\"net_pay\":\"0.00\",\"taxable_income\":\"0.00\",\"non_taxable_income\":\"0.00\",\"tax_paid\":\"0.00\",\"updated_at\":\"2024-01-23 09:35:26\"}','{\"gross_earnings\":\"54000.00\",\"deductions\":\"19171.81\",\"net_pay\":34828.19,\"taxable_income\":\"54000.00\",\"non_taxable_income\":0,\"tax_paid\":17942.5025,\"updated_at\":\"2024-01-23 09:35:27\"}','http://localhost:8000/pam-emps','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(69,'App\\Models\\User',13,'updated','App\\Models\\PamPayRun',1,'{\"pay_run_status\":\"open\",\"release_to_ess\":0,\"updated_at\":\"2024-01-23 09:35:10\"}','{\"pay_run_status\":\"closed\",\"release_to_ess\":1,\"updated_at\":\"2024-01-23 09:36:16\"}','http://localhost:8000/pam-pay-runs/1/close-payroll-run','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:36:16','2024-01-23 07:36:16'),(70,'App\\Models\\User',13,'created','App\\Models\\PamPayRun',3,'[]','{\"payroll_id\":1,\"pay_run_period_id\":2,\"tax_table_id\":1,\"prev_pay_run_id\":1,\"next_pay_run_id\":null,\"pay_run_status\":\"open\",\"active\":true,\"transaction_date\":\"2024-01-23T09:37:12.970825Z\",\"actual_processing_date\":\"2024-01-23T09:37:12.970842Z\",\"release_to_ess\":false,\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:37:12\",\"created_at\":\"2024-01-23 09:37:12\",\"id\":3}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:12','2024-01-23 07:37:12'),(71,'App\\Models\\User',13,'updated','App\\Models\\PamPayRun',1,'{\"next_pay_run_id\":null,\"active\":1,\"updated_at\":\"2024-01-23 09:36:16\"}','{\"next_pay_run_id\":3,\"active\":false,\"updated_at\":\"2024-01-23 09:37:12\"}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:12','2024-01-23 07:37:12'),(72,'App\\Models\\User',13,'updated','App\\Models\\PamPayroll',1,'{\"current_period_month\":1,\"current_pay_run_id\":1,\"updated_at\":\"2024-01-22 20:02:25\"}','{\"current_period_month\":2,\"current_pay_run_id\":3,\"updated_at\":\"2024-01-23 09:37:12\"}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:12','2024-01-23 07:37:12'),(73,'App\\Models\\User',13,'created','App\\Models\\PamPayslip',3,'[]','{\"emp_id\":13,\"pay_run_id\":3,\"pay_run_period_id\":2,\"gross_earnings\":\"54000.00\",\"deductions\":\"19171.81\",\"net_pay\":\"34828.19\",\"leave_days\":\"0.00\",\"payed_total_year_to_date\":\"0.00\",\"taxable_income\":\"54000.00\",\"non_taxable_income\":\"0.00\",\"tax_paid\":\"17942.50\",\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:37:12\",\"created_at\":\"2024-01-23 09:37:12\",\"id\":3}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(74,'App\\Models\\User',13,'created','App\\Models\\PamPayslipEarnDef',3,'[]','{\"emp_id\":13,\"earn_def_id\":1,\"pay_run_id\":3,\"pay_run_period_id\":2,\"earn_def_code\":\"BASICPAY\",\"payslip_id\":3,\"man_number\":\"10574\",\"units\":22,\"emp_rate\":\"2454.55\",\"input_amount\":\"54000.00\",\"amount\":\"54000.00\",\"mandatory\":1,\"earn_type_code\":\"BASIC\",\"earn_group_code\":\"TAXABLE\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:37:13\",\"created_at\":\"2024-01-23 09:37:13\",\"id\":3}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(75,'App\\Models\\User',13,'created','App\\Models\\PamPayslipEarn',3,'[]','{\"earn_def_id\":1,\"earn_def_code\":\"BASICPAY\",\"payslip_id\":3,\"emp_id\":13,\"man_number\":\"10574\",\"pay_run_id\":3,\"pay_run_period_id\":2,\"units\":22,\"fixed_amount\":\"54000.00\",\"recurrence_amount\":\"54000.00\",\"recurrence_count\":1,\"amount\":\"54000.00\",\"total\":\"54000.00\",\"previous_total\":\"54000.00\",\"taxable_amount\":\"54000.00\",\"balance\":\"54000.00\",\"month_to_date_total\":\"54000.00\",\"year_to_date_total\":\"54000.00\",\"month_to_date_units\":22,\"year_to_date_units\":22,\"month_to_date_taxable_amount\":\"54000.00\",\"year_to_date_taxable_amount\":\"54000.00\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"earn_group_code\":\"TAXABLE\",\"earn_type_code\":\"BASIC\",\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:37:13\",\"updated_at\":\"2024-01-23 09:37:13\",\"id\":3}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(76,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',9,'[]','{\"emp_id\":13,\"dedu_def_id\":1,\"pay_run_id\":3,\"loan_id\":null,\"pay_run_period_id\":2,\"dedu_def_code\":\"PAYE\",\"payslip_id\":3,\"man_number\":\"10574\",\"units\":22,\"emp_rate\":\"1.00\",\"input_amount\":\"17942.50\",\"amount\":\"17942.50\",\"mandatory\":1,\"dedu_type_code\":\"INCTAX\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:37:13\",\"created_at\":\"2024-01-23 09:37:13\",\"id\":9}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(77,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',9,'[]','{\"dedu_def_id\":1,\"dedu_def_code\":\"PAYE\",\"payslip_id\":3,\"emp_id\":13,\"man_number\":\"10574\",\"pay_run_id\":3,\"pay_run_period_id\":2,\"units\":22,\"fixed_amount\":\"17942.50\",\"recurrence_amount\":\"17942.50\",\"recurrence_count\":1,\"amount\":\"17942.50\",\"total\":\"17942.50\",\"previous_total\":\"17942.50\",\"taxable_amount\":\"17942.50\",\"balance\":\"17942.50\",\"month_to_date_total\":\"17942.50\",\"year_to_date_total\":\"17942.50\",\"month_to_date_units\":22,\"year_to_date_units\":22,\"month_to_date_taxable_amount\":\"17942.50\",\"year_to_date_taxable_amount\":\"17942.50\",\"dedu_type_code\":\"INCTAX\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:37:13\",\"updated_at\":\"2024-01-23 09:37:13\",\"id\":9}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(78,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',10,'[]','{\"emp_id\":13,\"dedu_def_id\":5,\"pay_run_id\":3,\"loan_id\":null,\"pay_run_period_id\":2,\"dedu_def_code\":\"PEL\",\"payslip_id\":3,\"man_number\":\"10574\",\"units\":22,\"emp_rate\":\"1.00\",\"input_amount\":\"7.50\",\"amount\":\"7.50\",\"mandatory\":1,\"dedu_type_code\":\"LEVY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:37:13\",\"created_at\":\"2024-01-23 09:37:13\",\"id\":10}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(79,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',10,'[]','{\"dedu_def_id\":5,\"dedu_def_code\":\"PEL\",\"payslip_id\":3,\"emp_id\":13,\"man_number\":\"10574\",\"pay_run_id\":3,\"pay_run_period_id\":2,\"units\":22,\"fixed_amount\":\"7.50\",\"recurrence_amount\":\"7.50\",\"recurrence_count\":1,\"amount\":\"7.50\",\"total\":\"7.50\",\"previous_total\":\"7.50\",\"taxable_amount\":\"7.50\",\"balance\":\"7.50\",\"month_to_date_total\":\"7.50\",\"year_to_date_total\":\"7.50\",\"month_to_date_units\":22,\"year_to_date_units\":22,\"month_to_date_taxable_amount\":\"7.50\",\"year_to_date_taxable_amount\":\"7.50\",\"dedu_type_code\":\"LEVY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:37:13\",\"updated_at\":\"2024-01-23 09:37:13\",\"id\":10}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(80,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',11,'[]','{\"emp_id\":13,\"dedu_def_id\":2,\"pay_run_id\":3,\"loan_id\":null,\"pay_run_period_id\":2,\"dedu_def_code\":\"NAPSA\",\"payslip_id\":3,\"man_number\":\"10574\",\"units\":22,\"emp_rate\":\"1.00\",\"input_amount\":\"1221.81\",\"amount\":\"1221.81\",\"mandatory\":1,\"dedu_type_code\":\"SOCIALSECURITY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:37:13\",\"created_at\":\"2024-01-23 09:37:13\",\"id\":11}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(81,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',11,'[]','{\"dedu_def_id\":2,\"dedu_def_code\":\"NAPSA\",\"payslip_id\":3,\"emp_id\":13,\"man_number\":\"10574\",\"pay_run_id\":3,\"pay_run_period_id\":2,\"units\":22,\"fixed_amount\":\"1221.81\",\"recurrence_amount\":\"1221.81\",\"recurrence_count\":1,\"amount\":\"1221.81\",\"total\":\"1221.81\",\"previous_total\":\"1221.81\",\"taxable_amount\":\"1221.81\",\"balance\":\"1221.81\",\"month_to_date_total\":\"1221.81\",\"year_to_date_total\":\"1221.81\",\"month_to_date_units\":22,\"year_to_date_units\":22,\"month_to_date_taxable_amount\":\"1221.81\",\"year_to_date_taxable_amount\":\"1221.81\",\"dedu_type_code\":\"SOCIALSECURITY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:37:13\",\"updated_at\":\"2024-01-23 09:37:13\",\"id\":11}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(82,'App\\Models\\User',13,'created','App\\Models\\PamPayslip',4,'[]','{\"emp_id\":15,\"pay_run_id\":3,\"pay_run_period_id\":2,\"gross_earnings\":\"20000.00\",\"deductions\":\"6200.00\",\"net_pay\":\"13800.00\",\"leave_days\":\"0.00\",\"payed_total_year_to_date\":\"0.00\",\"taxable_income\":\"20000.00\",\"non_taxable_income\":\"0.00\",\"tax_paid\":\"5192.50\",\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:37:13\",\"created_at\":\"2024-01-23 09:37:13\",\"id\":4}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(83,'App\\Models\\User',13,'created','App\\Models\\PamPayslipEarnDef',4,'[]','{\"emp_id\":15,\"earn_def_id\":1,\"pay_run_id\":3,\"pay_run_period_id\":2,\"earn_def_code\":\"BASICPAY\",\"payslip_id\":4,\"man_number\":\"8588\",\"units\":22,\"emp_rate\":\"909.09\",\"input_amount\":\"20000.00\",\"amount\":\"20000.00\",\"mandatory\":1,\"earn_type_code\":\"BASIC\",\"earn_group_code\":\"TAXABLE\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:37:13\",\"created_at\":\"2024-01-23 09:37:13\",\"id\":4}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(84,'App\\Models\\User',13,'created','App\\Models\\PamPayslipEarn',4,'[]','{\"earn_def_id\":1,\"earn_def_code\":\"BASICPAY\",\"payslip_id\":4,\"emp_id\":15,\"man_number\":\"8588\",\"pay_run_id\":3,\"pay_run_period_id\":2,\"units\":22,\"fixed_amount\":\"20000.00\",\"recurrence_amount\":\"20000.00\",\"recurrence_count\":1,\"amount\":\"20000.00\",\"total\":\"20000.00\",\"previous_total\":\"20000.00\",\"taxable_amount\":\"20000.00\",\"balance\":\"20000.00\",\"month_to_date_total\":\"20000.00\",\"year_to_date_total\":\"20000.00\",\"month_to_date_units\":22,\"year_to_date_units\":22,\"month_to_date_taxable_amount\":\"20000.00\",\"year_to_date_taxable_amount\":\"20000.00\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"earn_group_code\":\"TAXABLE\",\"earn_type_code\":\"BASIC\",\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:37:13\",\"updated_at\":\"2024-01-23 09:37:13\",\"id\":4}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(85,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',12,'[]','{\"emp_id\":15,\"dedu_def_id\":1,\"pay_run_id\":3,\"loan_id\":null,\"pay_run_period_id\":2,\"dedu_def_code\":\"PAYE\",\"payslip_id\":4,\"man_number\":\"8588\",\"units\":22,\"emp_rate\":\"1.00\",\"input_amount\":\"5192.50\",\"amount\":\"5192.50\",\"mandatory\":1,\"dedu_type_code\":\"INCTAX\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:37:13\",\"created_at\":\"2024-01-23 09:37:13\",\"id\":12}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(86,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',12,'[]','{\"dedu_def_id\":1,\"dedu_def_code\":\"PAYE\",\"payslip_id\":4,\"emp_id\":15,\"man_number\":\"8588\",\"pay_run_id\":3,\"pay_run_period_id\":2,\"units\":22,\"fixed_amount\":\"5192.50\",\"recurrence_amount\":\"5192.50\",\"recurrence_count\":1,\"amount\":\"5192.50\",\"total\":\"5192.50\",\"previous_total\":\"5192.50\",\"taxable_amount\":\"5192.50\",\"balance\":\"5192.50\",\"month_to_date_total\":\"5192.50\",\"year_to_date_total\":\"5192.50\",\"month_to_date_units\":22,\"year_to_date_units\":22,\"month_to_date_taxable_amount\":\"5192.50\",\"year_to_date_taxable_amount\":\"5192.50\",\"dedu_type_code\":\"INCTAX\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:37:13\",\"updated_at\":\"2024-01-23 09:37:13\",\"id\":12}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(87,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',13,'[]','{\"emp_id\":15,\"dedu_def_id\":5,\"pay_run_id\":3,\"loan_id\":null,\"pay_run_period_id\":2,\"dedu_def_code\":\"PEL\",\"payslip_id\":4,\"man_number\":\"8588\",\"units\":22,\"emp_rate\":\"1.00\",\"input_amount\":\"7.50\",\"amount\":\"7.50\",\"mandatory\":1,\"dedu_type_code\":\"LEVY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:37:13\",\"created_at\":\"2024-01-23 09:37:13\",\"id\":13}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(88,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',13,'[]','{\"dedu_def_id\":5,\"dedu_def_code\":\"PEL\",\"payslip_id\":4,\"emp_id\":15,\"man_number\":\"8588\",\"pay_run_id\":3,\"pay_run_period_id\":2,\"units\":22,\"fixed_amount\":\"7.50\",\"recurrence_amount\":\"7.50\",\"recurrence_count\":1,\"amount\":\"7.50\",\"total\":\"7.50\",\"previous_total\":\"7.50\",\"taxable_amount\":\"7.50\",\"balance\":\"7.50\",\"month_to_date_total\":\"7.50\",\"year_to_date_total\":\"7.50\",\"month_to_date_units\":22,\"year_to_date_units\":22,\"month_to_date_taxable_amount\":\"7.50\",\"year_to_date_taxable_amount\":\"7.50\",\"dedu_type_code\":\"LEVY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:37:13\",\"updated_at\":\"2024-01-23 09:37:13\",\"id\":13}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(89,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDeduDef',14,'[]','{\"emp_id\":15,\"dedu_def_id\":2,\"pay_run_id\":3,\"loan_id\":null,\"pay_run_period_id\":2,\"dedu_def_code\":\"NAPSA\",\"payslip_id\":4,\"man_number\":\"8588\",\"units\":22,\"emp_rate\":\"1.00\",\"input_amount\":\"1000.00\",\"amount\":\"1000.00\",\"mandatory\":1,\"dedu_type_code\":\"SOCIALSECURITY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"recurrence_period_1\":1,\"recurrence_period_2\":1,\"recurrence_period_3\":1,\"recurrence_period_4\":1,\"recurrence_period_5\":1,\"recurrence_period_6\":1,\"recurrence_period_7\":1,\"recurrence_period_8\":1,\"recurrence_period_9\":1,\"recurrence_period_10\":1,\"recurrence_period_11\":1,\"recurrence_period_12\":1,\"created_by\":13,\"updated_by\":13,\"updated_at\":\"2024-01-23 09:37:13\",\"created_at\":\"2024-01-23 09:37:13\",\"id\":14}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(90,'App\\Models\\User',13,'created','App\\Models\\PamPayslipDedu',14,'[]','{\"dedu_def_id\":2,\"dedu_def_code\":\"NAPSA\",\"payslip_id\":4,\"emp_id\":15,\"man_number\":\"8588\",\"pay_run_id\":3,\"pay_run_period_id\":2,\"units\":22,\"fixed_amount\":\"1000.00\",\"recurrence_amount\":\"1000.00\",\"recurrence_count\":1,\"amount\":\"1000.00\",\"total\":\"1000.00\",\"previous_total\":\"1000.00\",\"taxable_amount\":\"1000.00\",\"balance\":\"1000.00\",\"month_to_date_total\":\"1000.00\",\"year_to_date_total\":\"1000.00\",\"month_to_date_units\":22,\"year_to_date_units\":22,\"month_to_date_taxable_amount\":\"1000.00\",\"year_to_date_taxable_amount\":\"1000.00\",\"dedu_type_code\":\"SOCIALSECURITY\",\"dedu_group_code\":\"STATUTORY\",\"start_date\":\"2023-01-31 23:59:59\",\"end_date\":null,\"loan_id\":null,\"created_by\":13,\"updated_by\":13,\"created_at\":\"2024-01-23 09:37:13\",\"updated_at\":\"2024-01-23 09:37:13\",\"id\":14}','http://localhost:8000/pam-payroll-rollovers/1/rollover','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(91,'App\\Models\\User',13,'updated','App\\Models\\User',13,'{\"remember_token\":\"hy0S5vGkP3VAaF3hMVOsiDAg4h7qlrLqLeaRqu9mCevvAkLSArmLgGWxj100\"}','{\"remember_token\":\"75Q1HeXxY7WuYgJnk9fkr9bemd3i327XjihPM9I4oVUfUkl36gA6BB76WHMW\"}','http://localhost:8000/logout','127.0.0.1','Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:109.0) Gecko/20100101 Firefox/119.0',NULL,'2024-01-23 09:40:40','2024-01-23 09:40:40');

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8893 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (6933,'2014_10_12_000000_create_users_table',1),(6943,'2023_08_11_053021_create_pam_cont_types_table',1),(6944,'2023_08_11_054510_create_pam_cont_groups_table',1),(6946,'2023_08_11_061615_create_pam_dedu_types_table',1),(6947,'2023_08_11_061901_create_pam_dedu_groups_table',1),(6949,'2023_08_11_062420_create_pam_earn_types_table',1),(6950,'2023_08_11_062727_create_pam_earn_groups_table',1),(6952,'2023_08_11_062956_create_pam_tax_years_table',1),(6954,'2023_08_11_063250_create_pam_social_securities_table',1),(6955,'2023_08_11_063252_create_pam_tax_tables_table',1),(6956,'2023_08_11_063253_create_pam_tax_bands_table',1),(7764,'2023_08_14_102738_create_pam_loans_table',2),(7970,'2023_08_11_063321_create_pam_emps_table',3),(8254,'2023_08_11_063240_create_pam_pay_run_periods_table',4),(8310,'2023_08_11_060005_create_pam_cont_defs_table',5),(8311,'2023_08_11_062140_create_pam_dedu_defs_table',5),(8312,'2023_08_11_062738_create_pam_earn_defs_table',5),(8860,'2014_10_12_100000_create_password_reset_tokens_table',6),(8861,'2014_10_12_100000_create_password_resets_table',6),(8862,'2016_06_01_000001_create_oauth_auth_codes_table',6),(8863,'2016_06_01_000002_create_oauth_access_tokens_table',6),(8864,'2016_06_01_000003_create_oauth_refresh_tokens_table',6),(8865,'2016_06_01_000004_create_oauth_clients_table',6),(8866,'2016_06_01_000005_create_oauth_personal_access_clients_table',6),(8867,'2019_08_19_000000_create_failed_jobs_table',6),(8868,'2019_12_14_000001_create_personal_access_tokens_table',6),(8869,'2023_08_11_063300_create_pam_payrolls_table',6),(8870,'2023_08_11_063301_create_pam_banks_table',6),(8871,'2023_08_11_063302_create_pam_bank_branches_table',6),(8872,'2023_08_11_063310_create_pam_emp_salary_scale_notches_table',6),(8873,'2023_08_11_063843_create_pam_pay_runs_table',6),(8874,'2023_08_11_070350_create_pam_pay_cont_defs_table',6),(8875,'2023_08_11_070351_create_pam_pay_earn_defs_table',6),(8876,'2023_08_11_070406_create_pam_pay_dedu_defs_table',6),(8877,'2023_08_11_071038_create_pam_emp_dedu_defs_table',6),(8878,'2023_08_11_071050_create_pam_emp_cont_defs_table',6),(8879,'2023_08_11_071050_create_pam_emp_earn_defs_table',6),(8880,'2023_08_11_071551_create_pam_payslips_table',6),(8881,'2023_08_11_102738_create_pam_loans_table',6),(8882,'2023_08_11_102739_create_pam_loan_payments_table',6),(8883,'2023_08_11_121835_create_pam_payslip_dedus_table',6),(8884,'2023_08_11_121840_create_pam_payslip_earns_table',6),(8885,'2023_08_22_222715_create_permission_tables',6),(8886,'2023_09_08_090149_create_pam_claims_table',6),(8887,'2023_09_12_093855_create_pam_payslip_dedu_defs_table',6),(8888,'2023_09_12_093930_create_pam_emp_ytd_totals_table ',6),(8889,'2023_09_12_093930_create_pam_payslip_earn_defs_table',6),(8890,'2023_11_05_135831_create_jobs_table',6),(8891,'2023_11_29_131608_create_pam_approved_claims_table',6),(8892,'2024_01_16_130644_create_audits_table',6);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(1,'App\\Models\\User',2),(1,'App\\Models\\User',3),(1,'App\\Models\\User',4),(1,'App\\Models\\User',5),(1,'App\\Models\\User',6),(1,'App\\Models\\User',7),(1,'App\\Models\\User',8),(1,'App\\Models\\User',9),(1,'App\\Models\\User',10),(1,'App\\Models\\User',11),(1,'App\\Models\\User',12),(1,'App\\Models\\User',16),(1,'App\\Models\\User',17),(3,'App\\Models\\User',13);

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `client_id` bigint(20) unsigned NOT NULL,
  `scopes` text DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--


--
-- Table structure for table `pam_approved_claims`
--

CREATE TABLE `pam_approved_claims` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` bigint(20) unsigned NOT NULL,
  `earn_def_id` bigint(20) unsigned NOT NULL,
  `approved_on_payslip_id` bigint(20) unsigned DEFAULT NULL,
  `approved_on_pay_run_id` bigint(20) unsigned DEFAULT NULL,
  `aggregate_amount` double DEFAULT NULL,
  `payment_status` varchar(255) DEFAULT NULL,
  `paid_on_payslip_id` bigint(20) unsigned DEFAULT NULL,
  `paid_amount` double DEFAULT NULL,
  `comments` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_approved_claims_created_by_foreign` (`created_by`),
  KEY `pam_approved_claims_updated_by_foreign` (`updated_by`),
  KEY `pam_approved_claims_earn_def_id_foreign` (`earn_def_id`),
  KEY `pam_approved_claims_approved_on_payslip_id_foreign` (`approved_on_payslip_id`),
  KEY `pam_approved_claims_approved_on_pay_run_id_foreign` (`approved_on_pay_run_id`),
  CONSTRAINT `pam_approved_claims_approved_on_pay_run_id_foreign` FOREIGN KEY (`approved_on_pay_run_id`) REFERENCES `pam_pay_runs` (`id`),
  CONSTRAINT `pam_approved_claims_approved_on_payslip_id_foreign` FOREIGN KEY (`approved_on_payslip_id`) REFERENCES `pam_payslips` (`id`),
  CONSTRAINT `pam_approved_claims_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_approved_claims_earn_def_id_foreign` FOREIGN KEY (`earn_def_id`) REFERENCES `pam_earn_defs` (`id`),
  CONSTRAINT `pam_approved_claims_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_approved_claims`
--


--
-- Table structure for table `pam_bank_branches`
--

CREATE TABLE `pam_bank_branches` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `bank_id` bigint(20) unsigned NOT NULL,
  `branch_code` varchar(255) NOT NULL,
  `bank_code` varchar(255) NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_bank_branches_branch_code_unique` (`branch_code`),
  KEY `pam_bank_branches_created_by_foreign` (`created_by`),
  KEY `pam_bank_branches_updated_by_foreign` (`updated_by`),
  KEY `pam_bank_branches_bank_id_foreign` (`bank_id`),
  CONSTRAINT `pam_bank_branches_bank_id_foreign` FOREIGN KEY (`bank_id`) REFERENCES `pam_banks` (`id`),
  CONSTRAINT `pam_bank_branches_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_bank_branches_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_bank_branches`
--


--
-- Table structure for table `pam_banks`
--

CREATE TABLE `pam_banks` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_banks_code_unique` (`code`),
  UNIQUE KEY `pam_banks_short_description_unique` (`short_description`),
  KEY `pam_banks_created_by_foreign` (`created_by`),
  KEY `pam_banks_updated_by_foreign` (`updated_by`),
  CONSTRAINT `pam_banks_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_banks_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_banks`
--


--
-- Table structure for table `pam_claims`
--

CREATE TABLE `pam_claims` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` bigint(20) unsigned NOT NULL,
  `earn_def_id` bigint(20) unsigned NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `units` varchar(255) DEFAULT NULL,
  `quantity` double DEFAULT NULL,
  `rate` double DEFAULT NULL,
  `claim_amount` double DEFAULT NULL,
  `supervisor_id` varchar(255) DEFAULT NULL,
  `workflow_status` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `status_date` date DEFAULT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_claims_created_by_foreign` (`created_by`),
  KEY `pam_claims_updated_by_foreign` (`updated_by`),
  KEY `pam_claims_earn_def_id_foreign` (`earn_def_id`),
  CONSTRAINT `pam_claims_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_claims_earn_def_id_foreign` FOREIGN KEY (`earn_def_id`) REFERENCES `pam_earn_defs` (`id`),
  CONSTRAINT `pam_claims_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_claims`
--


--
-- Table structure for table `pam_cont_defs`
--

CREATE TABLE `pam_cont_defs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `general_ledger_code` varchar(255) NOT NULL,
  `cont_type_id` bigint(20) unsigned NOT NULL,
  `cont_group_id` bigint(20) unsigned NOT NULL,
  `cont_type_code` varchar(255) NOT NULL,
  `cont_group_code` varchar(255) NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `employee_contribution_rate` decimal(15,2) DEFAULT NULL,
  `employer_contribution_rate` decimal(15,2) DEFAULT NULL,
  `employee_contribution_fixed_amount` decimal(15,2) DEFAULT NULL,
  `employer_contribution_fixed_amount` decimal(15,2) DEFAULT NULL,
  `employee_maximum_ceiling` decimal(15,2) DEFAULT NULL,
  `employer_maximum_ceiling` decimal(15,2) DEFAULT NULL,
  `recurrence_period_1` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_2` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_3` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_4` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_5` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_6` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_7` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_8` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_9` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_10` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_11` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_12` int(11) NOT NULL DEFAULT 0,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_cont_defs_code_unique` (`code`),
  UNIQUE KEY `pam_cont_defs_short_description_unique` (`short_description`),
  KEY `pam_cont_defs_created_by_foreign` (`created_by`),
  KEY `pam_cont_defs_updated_by_foreign` (`updated_by`),
  KEY `pam_cont_defs_cont_type_id_foreign` (`cont_type_id`),
  KEY `pam_cont_defs_cont_group_id_foreign` (`cont_group_id`),
  CONSTRAINT `pam_cont_defs_cont_group_id_foreign` FOREIGN KEY (`cont_group_id`) REFERENCES `pam_cont_groups` (`id`),
  CONSTRAINT `pam_cont_defs_cont_type_id_foreign` FOREIGN KEY (`cont_type_id`) REFERENCES `pam_cont_types` (`id`),
  CONSTRAINT `pam_cont_defs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_cont_defs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_cont_defs`
--

INSERT INTO `pam_cont_defs` VALUES (1,'NAPSA','NAPSA',1,1,'SOCIALSECURITY','STATUTORY','NAPSA','NAPSA is a social security scheme that provides basic cover to all eligible employees in Zambia. The NAPSA Act No. 40 of 1996 of the Laws of Zambia established the National Pension Scheme Authority.',0.00,0.00,NULL,NULL,0.00,0.00,0,0,0,0,0,0,0,0,0,0,0,0,'active',11,11,'2023-11-29 17:28:19','2023-11-29 17:28:19'),(2,'SDL','SDL',2,1,'LEVY','STATUTORY','Skills Development Levy','Skills Development Levy',0.00,0.00,NULL,NULL,0.00,0.00,0,0,0,0,0,0,0,0,0,0,0,0,'active',11,11,'2023-11-29 17:28:19','2023-11-29 17:28:19'),(3,'PEL','PEL',2,1,'LEVY','STATUTORY','Personal Levy','Personal Levy',0.00,0.00,NULL,NULL,0.00,0.00,0,0,0,0,0,0,0,0,0,0,0,0,'active',11,11,'2023-11-29 17:28:19','2023-11-29 17:28:19');

--
-- Table structure for table `pam_cont_groups`
--

CREATE TABLE `pam_cont_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `cont_group_parent_id` bigint(20) unsigned DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_cont_groups_code_unique` (`code`),
  UNIQUE KEY `pam_cont_groups_short_description_unique` (`short_description`),
  KEY `pam_cont_groups_created_by_foreign` (`created_by`),
  KEY `pam_cont_groups_updated_by_foreign` (`updated_by`),
  KEY `pam_cont_groups_cont_group_parent_id_foreign` (`cont_group_parent_id`),
  CONSTRAINT `pam_cont_groups_cont_group_parent_id_foreign` FOREIGN KEY (`cont_group_parent_id`) REFERENCES `pam_cont_groups` (`id`),
  CONSTRAINT `pam_cont_groups_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_cont_groups_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_cont_groups`
--

INSERT INTO `pam_cont_groups` VALUES (1,'STATUTORY','Statutory','Statutory',NULL,'Active',9,9,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(2,'OTHER','Other','Other',NULL,'Active',9,9,'2023-11-02 11:08:15','2023-11-02 11:08:15');

--
-- Table structure for table `pam_cont_types`
--

CREATE TABLE `pam_cont_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `comment` text DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_cont_types_code_unique` (`code`),
  UNIQUE KEY `pam_cont_types_short_description_unique` (`short_description`),
  KEY `pam_cont_types_created_by_foreign` (`created_by`),
  KEY `pam_cont_types_updated_by_foreign` (`updated_by`),
  CONSTRAINT `pam_cont_types_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_cont_types_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_cont_types`
--

INSERT INTO `pam_cont_types` VALUES (1,'SOCIALSECURITY','Social Security','Social Security (NAPSA)',NULL,'Active',6,6,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(2,'LEVY','LEVY','LEVY',NULL,'Active',6,6,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(3,'UNION','Union','Union ',NULL,'Active',6,6,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(4,'PENSION','Pension Fund','Pension Fund',NULL,'Active',6,6,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(5,'MEDAID','Medical Aid','Medical Aid',NULL,'Active',6,6,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(6,'OTHER','Other','Other',NULL,'Active',6,6,'2023-11-02 11:08:15','2023-11-02 11:08:15');

--
-- Table structure for table `pam_dedu_defs`
--

CREATE TABLE `pam_dedu_defs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `general_ledger_code` varchar(255) NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `cont_def_id` bigint(20) unsigned DEFAULT NULL,
  `dedu_type_id` bigint(20) unsigned NOT NULL,
  `dedu_group_id` bigint(20) unsigned NOT NULL,
  `dedu_type_code` varchar(255) NOT NULL,
  `dedu_group_code` varchar(255) NOT NULL,
  `percentage` decimal(8,2) DEFAULT NULL,
  `fixed_amount` decimal(8,2) DEFAULT NULL,
  `mode_of_calculation` varchar(255) NOT NULL,
  `calculation_basis` varchar(255) NOT NULL,
  `recurrence_period_1` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_2` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_3` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_4` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_5` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_6` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_7` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_8` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_9` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_10` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_11` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_12` int(11) NOT NULL DEFAULT 0,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_dedu_defs_code_unique` (`code`),
  UNIQUE KEY `pam_dedu_defs_short_description_unique` (`short_description`),
  KEY `pam_dedu_defs_cont_def_id_foreign` (`cont_def_id`),
  KEY `pam_dedu_defs_dedu_type_id_foreign` (`dedu_type_id`),
  KEY `pam_dedu_defs_created_by_foreign` (`created_by`),
  KEY `pam_dedu_defs_updated_by_foreign` (`updated_by`),
  KEY `pam_dedu_defs_dedu_group_id_foreign` (`dedu_group_id`),
  CONSTRAINT `pam_dedu_defs_cont_def_id_foreign` FOREIGN KEY (`cont_def_id`) REFERENCES `pam_cont_defs` (`id`),
  CONSTRAINT `pam_dedu_defs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_dedu_defs_dedu_group_id_foreign` FOREIGN KEY (`dedu_group_id`) REFERENCES `pam_dedu_groups` (`id`),
  CONSTRAINT `pam_dedu_defs_dedu_type_id_foreign` FOREIGN KEY (`dedu_type_id`) REFERENCES `pam_dedu_types` (`id`),
  CONSTRAINT `pam_dedu_defs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_dedu_defs`
--

INSERT INTO `pam_dedu_defs` VALUES (1,'PAYE','PAYE','Pay As You Earn','Pay As You Earn (PAYE) is a tax on employee\'s income. It is deducted from salaries and wages by employers who are registered with the Kenya Revenue Authority (KRA) and paid to the KRA on a monthly basis.',NULL,1,1,'INCTAX','STATUTORY',NULL,NULL,'fixed','gross',0,0,0,0,0,0,0,0,0,0,0,0,'active',9,9,'2023-11-29 17:28:19','2023-11-29 17:28:19'),(2,'NAPSA','NAPSA','NAPSA','NAPSA is a social security scheme that provides basic cover to all eligible employees in Zambia. The NAPSA Act No. 40 of 1996 of the Laws of Zambia established the National Pension Scheme Authority.',NULL,3,1,'SOCIALSECURITY','STATUTORY',NULL,NULL,'fixed','gross',0,0,0,0,0,0,0,0,0,0,0,0,'active',9,9,'2023-11-29 17:28:19','2023-11-29 17:28:19'),(3,'STANCHART','STANCHART','STANDARD CHARTERED LOAN','STANDARD CHARTERED LOAN',NULL,7,2,'LOAN','OTHER',NULL,0.00,'fixed','gross',0,0,0,0,0,0,0,0,0,0,0,0,'active',12,12,'2023-11-30 09:58:38','2023-11-30 09:58:38'),(4,'nnn','hhh','nnn','mm',NULL,7,2,'LOAN','OTHER',NULL,0.00,'fixed','gross',0,0,0,0,0,0,0,0,0,0,0,0,'active',12,12,'2023-12-08 14:20:20','2023-12-08 14:20:20'),(5,'PEL','PEL','Personal Levy','Personal Levy',3,8,1,'LEVY','STATUTORY',NULL,7.50,'fixed','gross',0,0,0,0,0,0,0,0,0,0,0,0,'active',12,12,'2023-12-29 07:55:02','2023-12-29 08:09:53');

--
-- Table structure for table `pam_dedu_groups`
--

CREATE TABLE `pam_dedu_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `dedu_group_parent_id` bigint(20) unsigned DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_dedu_groups_code_unique` (`code`),
  UNIQUE KEY `pam_dedu_groups_short_description_unique` (`short_description`),
  KEY `pam_dedu_groups_created_by_foreign` (`created_by`),
  KEY `pam_dedu_groups_updated_by_foreign` (`updated_by`),
  KEY `pam_dedu_groups_dedu_group_parent_id_foreign` (`dedu_group_parent_id`),
  CONSTRAINT `pam_dedu_groups_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_dedu_groups_dedu_group_parent_id_foreign` FOREIGN KEY (`dedu_group_parent_id`) REFERENCES `pam_dedu_types` (`id`),
  CONSTRAINT `pam_dedu_groups_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_dedu_groups`
--

INSERT INTO `pam_dedu_groups` VALUES (1,'STATUTORY','Statutory','Statutory',NULL,'Active',7,7,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(2,'OTHER','Other','Other',NULL,'Active',7,7,'2023-11-02 11:08:15','2023-11-02 11:08:15');

--
-- Table structure for table `pam_dedu_types`
--

CREATE TABLE `pam_dedu_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_dedu_types_code_unique` (`code`),
  UNIQUE KEY `pam_dedu_types_short_description_unique` (`short_description`),
  KEY `pam_dedu_types_created_by_foreign` (`created_by`),
  KEY `pam_dedu_types_updated_by_foreign` (`updated_by`),
  CONSTRAINT `pam_dedu_types_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_dedu_types_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_dedu_types`
--

INSERT INTO `pam_dedu_types` VALUES (1,'INCTAX','Income Tax','Income Tax (PAYE)','Active',2,2,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(2,'ADDTAX','Additional Tax','Additional Tax (PAYE)','Active',2,2,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(3,'SOCIALSECURITY','Social Security','Social Security (NAPSA)','Active',2,2,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(4,'UNION','Union Dues','Union Dues','Active',2,2,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(5,'MEDICAL','Medical','Medical','Active',2,2,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(6,'OTHER','Other Deductions','Other Deductions','Active',2,2,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(7,'LOAN','LOAN','LOAN','Active',2,2,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(8,'LEVY','LEVY','LEVY','Active',2,2,'2023-11-27 09:33:43','2023-11-27 09:33:43');

--
-- Table structure for table `pam_earn_defs`
--

CREATE TABLE `pam_earn_defs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `general_ledger_code` varchar(255) NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `earn_type_id` bigint(20) unsigned NOT NULL,
  `earn_group_id` bigint(20) unsigned NOT NULL,
  `earn_type_code` varchar(255) NOT NULL,
  `earn_group_code` varchar(255) NOT NULL,
  `percentage` decimal(8,2) DEFAULT NULL,
  `fixed_amount` decimal(8,2) DEFAULT NULL,
  `mode_of_calculation` varchar(255) NOT NULL,
  `overtime_rate` decimal(8,2) DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `recurrence_period_1` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_2` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_3` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_4` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_5` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_6` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_7` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_8` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_9` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_10` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_11` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_12` int(11) NOT NULL DEFAULT 0,
  `can_prorata` int(11) NOT NULL DEFAULT 0,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_earn_defs_code_unique` (`code`),
  UNIQUE KEY `pam_earn_defs_short_description_unique` (`short_description`),
  KEY `pam_earn_defs_earn_type_id_foreign` (`earn_type_id`),
  KEY `pam_earn_defs_created_by_foreign` (`created_by`),
  KEY `pam_earn_defs_updated_by_foreign` (`updated_by`),
  KEY `pam_earn_defs_earn_group_id_foreign` (`earn_group_id`),
  CONSTRAINT `pam_earn_defs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_earn_defs_earn_group_id_foreign` FOREIGN KEY (`earn_group_id`) REFERENCES `pam_earn_groups` (`id`),
  CONSTRAINT `pam_earn_defs_earn_type_id_foreign` FOREIGN KEY (`earn_type_id`) REFERENCES `pam_earn_types` (`id`),
  CONSTRAINT `pam_earn_defs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_earn_defs`
--

INSERT INTO `pam_earn_defs` VALUES (1,'BASICPAY','BASICPAY','Basic Pay','Basic Pay is the amount of money an employee receives before any extras are added or taken off, such as bonuses, overtime, tax, and deductions. It does not include bonuses, overtime and any other allowances.',1,1,'BASIC','TAXABLE',NULL,NULL,'fixed',NULL,'active',0,0,0,0,0,0,0,0,0,0,0,0,0,7,7,'2023-11-29 17:28:19','2023-11-29 17:28:19'),(3,'TEST','TEST','TEST','TEST',2,1,'INCPAYE','TAXABLE',NULL,0.00,'fixed',0.00,'active',0,0,0,0,0,0,0,0,0,0,0,0,0,12,12,'2024-01-09 20:24:40','2024-01-09 20:24:40'),(5,'DEMO','DEMO','DEMO','DEMO',2,1,'INCPAYE','TAXABLE',NULL,400.00,'fixed',0.00,'active',0,0,0,0,0,0,0,0,0,0,0,0,0,12,12,'2024-01-16 11:21:37','2024-01-16 11:21:37');

--
-- Table structure for table `pam_earn_groups`
--

CREATE TABLE `pam_earn_groups` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `earn_group_parent_id` bigint(20) unsigned DEFAULT NULL,
  `code` varchar(255) NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_earn_groups_code_unique` (`code`),
  UNIQUE KEY `pam_earn_groups_short_description_unique` (`short_description`),
  KEY `pam_earn_groups_created_by_foreign` (`created_by`),
  KEY `pam_earn_groups_updated_by_foreign` (`updated_by`),
  KEY `pam_earn_groups_earn_group_parent_id_foreign` (`earn_group_parent_id`),
  CONSTRAINT `pam_earn_groups_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_earn_groups_earn_group_parent_id_foreign` FOREIGN KEY (`earn_group_parent_id`) REFERENCES `pam_earn_types` (`id`),
  CONSTRAINT `pam_earn_groups_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_earn_groups`
--

INSERT INTO `pam_earn_groups` VALUES (1,NULL,'TAXABLE','Taxable Income','Taxable Income','Active',4,4,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(2,NULL,'NONTAXABLE','Non Taxable Income','Non Taxable Income','Active',4,4,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(3,NULL,'OTHER','Other','Other','Active',4,4,'2023-11-02 11:08:15','2023-11-02 11:08:15');

--
-- Table structure for table `pam_earn_types`
--

CREATE TABLE `pam_earn_types` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_earn_types_code_unique` (`code`),
  UNIQUE KEY `pam_earn_types_short_description_unique` (`short_description`),
  KEY `pam_earn_types_created_by_foreign` (`created_by`),
  KEY `pam_earn_types_updated_by_foreign` (`updated_by`),
  CONSTRAINT `pam_earn_types_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_earn_types_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_earn_types`
--

INSERT INTO `pam_earn_types` VALUES (1,'BASIC','Basic Income','Basic Income','Active',1,1,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(2,'INCPAYE','Other Income - Taxable','Other Income - Taxable','Active',1,1,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(3,'INCNOPAYE','Other Income - Non-Taxable','Other Income - Non-Taxable)','Active',1,1,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(4,'PENSION','Pension','Pension','Active',1,1,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(5,'LEAVEALL','Leave Allowance','Leave Allowance','Active',1,1,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(6,'LEAVEPAY','Leave Pay','Leave Pay','Active',1,1,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(7,'OVERTIME','Overtime','Overtime','Active',1,1,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(8,'BONUS','Bonus','Bonus','Active',1,1,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(9,'COMMISSION','Commission','Commission','Active',1,1,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(10,'OTHER','Other Allowances','Other Allowances','Active',1,1,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(11,'GRATUITY','Gratuity','Gratuity','Active',1,1,'2023-11-02 11:08:15','2023-11-02 11:08:15'),(12,'CLAIM','Claim','Claim','Active',1,1,'2023-11-02 11:08:15','2023-11-02 11:08:15');

--
-- Table structure for table `pam_emp_cont_defs`
--

CREATE TABLE `pam_emp_cont_defs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cont_def_id` bigint(20) unsigned NOT NULL,
  `cont_def_code` varchar(255) NOT NULL,
  `emp_id` bigint(20) unsigned NOT NULL,
  `payroll_id` bigint(20) unsigned NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `recurrence_period_1` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_2` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_3` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_4` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_5` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_6` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_7` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_8` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_9` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_10` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_11` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_12` int(11) NOT NULL DEFAULT 0,
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_emp_cont_defs_created_by_foreign` (`created_by`),
  KEY `pam_emp_cont_defs_updated_by_foreign` (`updated_by`),
  KEY `pam_emp_cont_defs_cont_def_id_foreign` (`cont_def_id`),
  KEY `pam_emp_cont_defs_payroll_id_foreign` (`payroll_id`),
  CONSTRAINT `pam_emp_cont_defs_cont_def_id_foreign` FOREIGN KEY (`cont_def_id`) REFERENCES `pam_cont_defs` (`id`),
  CONSTRAINT `pam_emp_cont_defs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_emp_cont_defs_payroll_id_foreign` FOREIGN KEY (`payroll_id`) REFERENCES `pam_payrolls` (`id`),
  CONSTRAINT `pam_emp_cont_defs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_emp_cont_defs`
--


--
-- Table structure for table `pam_emp_dedu_defs`
--

CREATE TABLE `pam_emp_dedu_defs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `dedu_def_id` bigint(20) unsigned NOT NULL,
  `dedu_def_code` varchar(255) NOT NULL,
  `emp_id` bigint(20) unsigned NOT NULL,
  `payroll_id` bigint(20) unsigned NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `recurrence_period_1` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_2` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_3` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_4` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_5` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_6` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_7` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_8` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_9` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_10` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_11` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_12` int(11) NOT NULL DEFAULT 0,
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_emp_dedu_defs_created_by_foreign` (`created_by`),
  KEY `pam_emp_dedu_defs_updated_by_foreign` (`updated_by`),
  KEY `pam_emp_dedu_defs_dedu_def_id_foreign` (`dedu_def_id`),
  KEY `pam_emp_dedu_defs_payroll_id_foreign` (`payroll_id`),
  CONSTRAINT `pam_emp_dedu_defs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_emp_dedu_defs_dedu_def_id_foreign` FOREIGN KEY (`dedu_def_id`) REFERENCES `pam_dedu_defs` (`id`),
  CONSTRAINT `pam_emp_dedu_defs_payroll_id_foreign` FOREIGN KEY (`payroll_id`) REFERENCES `pam_payrolls` (`id`),
  CONSTRAINT `pam_emp_dedu_defs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_emp_dedu_defs`
--

INSERT INTO `pam_emp_dedu_defs` VALUES (1,1,'PAYE',15,1,'Pay As You Earn','Pay As You Earn (PAYE) is a tax on employee\'s income. It is deducted from salaries and wages by employers who are registered with the Kenya Revenue Authority (KRA) and paid to the KRA on a monthly basis.',1,1,1,1,1,1,1,1,1,1,1,1,'2023-01-31 23:59:59',NULL,'active',13,13,'2024-01-23 07:35:20','2024-01-23 07:35:20'),(2,2,'NAPSA',15,1,'NAPSA','NAPSA is a social security scheme that provides basic cover to all eligible employees in Zambia. The NAPSA Act No. 40 of 1996 of the Laws of Zambia established the National Pension Scheme Authority.',1,1,1,1,1,1,1,1,1,1,1,1,'2023-01-31 23:59:59',NULL,'active',13,13,'2024-01-23 07:35:20','2024-01-23 07:35:20'),(3,5,'PEL',15,1,'Personal Levy','Personal Levy',1,1,1,1,1,1,1,1,1,1,1,1,'2023-01-31 23:59:59',NULL,'active',13,13,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(4,1,'PAYE',13,1,'Pay As You Earn','Pay As You Earn (PAYE) is a tax on employee\'s income. It is deducted from salaries and wages by employers who are registered with the Kenya Revenue Authority (KRA) and paid to the KRA on a monthly basis.',1,1,1,1,1,1,1,1,1,1,1,1,'2023-01-31 23:59:59',NULL,'active',13,13,'2024-01-23 07:35:26','2024-01-23 07:35:26'),(5,2,'NAPSA',13,1,'NAPSA','NAPSA is a social security scheme that provides basic cover to all eligible employees in Zambia. The NAPSA Act No. 40 of 1996 of the Laws of Zambia established the National Pension Scheme Authority.',1,1,1,1,1,1,1,1,1,1,1,1,'2023-01-31 23:59:59',NULL,'active',13,13,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(6,5,'PEL',13,1,'Personal Levy','Personal Levy',1,1,1,1,1,1,1,1,1,1,1,1,'2023-01-31 23:59:59',NULL,'active',13,13,'2024-01-23 07:35:27','2024-01-23 07:35:27');

--
-- Table structure for table `pam_emp_earn_defs`
--

CREATE TABLE `pam_emp_earn_defs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `earn_def_id` bigint(20) unsigned NOT NULL,
  `earn_def_code` varchar(255) NOT NULL,
  `emp_id` bigint(20) unsigned NOT NULL,
  `payroll_id` bigint(20) unsigned NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `recurrence_period_1` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_2` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_3` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_4` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_5` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_6` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_7` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_8` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_9` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_10` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_11` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_12` int(11) NOT NULL DEFAULT 0,
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_emp_earn_defs_created_by_foreign` (`created_by`),
  KEY `pam_emp_earn_defs_updated_by_foreign` (`updated_by`),
  KEY `pam_emp_earn_defs_earn_def_id_foreign` (`earn_def_id`),
  KEY `pam_emp_earn_defs_payroll_id_foreign` (`payroll_id`),
  CONSTRAINT `pam_emp_earn_defs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_emp_earn_defs_earn_def_id_foreign` FOREIGN KEY (`earn_def_id`) REFERENCES `pam_earn_defs` (`id`),
  CONSTRAINT `pam_emp_earn_defs_payroll_id_foreign` FOREIGN KEY (`payroll_id`) REFERENCES `pam_payrolls` (`id`),
  CONSTRAINT `pam_emp_earn_defs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_emp_earn_defs`
--

INSERT INTO `pam_emp_earn_defs` VALUES (1,1,'BASICPAY',15,1,'Basic Pay','Basic Pay is the amount of money an employee receives before any extras are added or taken off, such as bonuses, overtime, tax, and deductions. It does not include bonuses, overtime and any other allowances.',1,1,1,1,1,1,1,1,1,1,1,1,'2023-01-31 23:59:59',NULL,'active',13,13,'2024-01-23 07:35:20','2024-01-23 07:35:20'),(2,1,'BASICPAY',13,1,'Basic Pay','Basic Pay is the amount of money an employee receives before any extras are added or taken off, such as bonuses, overtime, tax, and deductions. It does not include bonuses, overtime and any other allowances.',1,1,1,1,1,1,1,1,1,1,1,1,'2023-01-31 23:59:59',NULL,'active',13,13,'2024-01-23 07:35:26','2024-01-23 07:35:26');

--
-- Table structure for table `pam_emp_salary_scale_notches`
--

CREATE TABLE `pam_emp_salary_scale_notches` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `salary_scale` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `basic_pay` decimal(8,2) NOT NULL,
  `notch_order` int(11) NOT NULL,
  `description` varchar(255) DEFAULT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_emp_salary_scale_notches_created_by_foreign` (`created_by`),
  KEY `pam_emp_salary_scale_notches_updated_by_foreign` (`updated_by`),
  CONSTRAINT `pam_emp_salary_scale_notches_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_emp_salary_scale_notches_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_emp_salary_scale_notches`
--

INSERT INTO `pam_emp_salary_scale_notches` VALUES (1,7,'Notch One',23549.00,1,'Salary Notch',12,12,'2024-01-22 17:41:08','2024-01-22 17:41:08'),(4,7,'Notch Two',40000.00,2,'Salary Notch',12,12,'2024-01-22 17:41:08','2024-01-22 17:41:08'),(5,7,'Notch Two',54000.00,3,'Salary Notch',12,12,'2024-01-22 17:41:08','2024-01-22 17:41:08'),(6,2,'Notch One',10000.00,1,'Salary Notch',12,12,'2024-01-22 17:41:08','2024-01-22 17:41:08'),(7,1,'Notch One',20000.00,1,'Salary Notch',12,12,'2024-01-22 17:41:08','2024-01-22 17:41:08'),(8,35,'Notch One',30000.00,1,'Salary Notch',12,12,'2024-01-22 17:41:08','2024-01-22 17:41:08'),(9,9,'Notch One',15000.00,1,'Salary Notch',12,12,'2024-01-22 17:41:08','2024-01-22 17:41:08');

--
-- Table structure for table `pam_emp_ytd_totals`
--

CREATE TABLE `pam_emp_ytd_totals` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` bigint(20) unsigned NOT NULL,
  `man_number` varchar(255) NOT NULL,
  `tax_year_id` bigint(20) unsigned NOT NULL,
  `tax_year_code` int(11) NOT NULL,
  `ytd_basic_pay` decimal(8,2) NOT NULL,
  `ytd_taxable_pay` decimal(8,2) NOT NULL,
  `ytd_non_taxable_pay` decimal(8,2) NOT NULL,
  `ytd_gross_pay` decimal(8,2) NOT NULL,
  `ytd_deductions` decimal(8,2) NOT NULL,
  `ytd_tax` decimal(8,2) NOT NULL,
  `ytd_net_pay` decimal(8,2) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_emp_ytd_totals_created_by_foreign` (`created_by`),
  KEY `pam_emp_ytd_totals_updated_by_foreign` (`updated_by`),
  KEY `pam_emp_ytd_totals_tax_year_id_foreign` (`tax_year_id`),
  CONSTRAINT `pam_emp_ytd_totals_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_emp_ytd_totals_tax_year_id_foreign` FOREIGN KEY (`tax_year_id`) REFERENCES `pam_tax_years` (`id`),
  CONSTRAINT `pam_emp_ytd_totals_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_emp_ytd_totals`
--


--
-- Table structure for table `pam_loan_payments`
--

CREATE TABLE `pam_loan_payments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` bigint(20) unsigned NOT NULL,
  `loan_id` bigint(20) unsigned NOT NULL,
  `pay_run_id` bigint(20) unsigned NOT NULL,
  `pay_run_period_id` bigint(20) unsigned NOT NULL,
  `dedu_def_id` bigint(20) unsigned NOT NULL,
  `dedu_def_code` varchar(255) NOT NULL,
  `dedu_group_code` varchar(255) NOT NULL,
  `dedu_type_code` varchar(255) NOT NULL,
  `man_number` varchar(255) NOT NULL,
  `principal_amount` decimal(8,2) NOT NULL,
  `interest_amount` decimal(8,2) NOT NULL,
  `amount` decimal(8,2) NOT NULL,
  `payment_reference` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `payment_date` datetime NOT NULL,
  `payment_period` datetime NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_loan_payments_pay_run_id_foreign` (`pay_run_id`),
  KEY `pam_loan_payments_pay_run_period_id_foreign` (`pay_run_period_id`),
  KEY `pam_loan_payments_created_by_foreign` (`created_by`),
  KEY `pam_loan_payments_updated_by_foreign` (`updated_by`),
  KEY `pam_loan_payments_dedu_def_id_foreign` (`dedu_def_id`),
  KEY `pam_loan_payments_loan_id_foreign` (`loan_id`),
  CONSTRAINT `pam_loan_payments_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_loan_payments_dedu_def_id_foreign` FOREIGN KEY (`dedu_def_id`) REFERENCES `pam_dedu_defs` (`id`),
  CONSTRAINT `pam_loan_payments_loan_id_foreign` FOREIGN KEY (`loan_id`) REFERENCES `pam_loans` (`id`),
  CONSTRAINT `pam_loan_payments_pay_run_id_foreign` FOREIGN KEY (`pay_run_id`) REFERENCES `pam_pay_runs` (`id`),
  CONSTRAINT `pam_loan_payments_pay_run_period_id_foreign` FOREIGN KEY (`pay_run_period_id`) REFERENCES `pam_pay_run_periods` (`id`),
  CONSTRAINT `pam_loan_payments_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_loan_payments`
--


--
-- Table structure for table `pam_loans`
--

CREATE TABLE `pam_loans` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `dedu_def_id` bigint(20) unsigned NOT NULL,
  `emp_id` bigint(20) unsigned NOT NULL,
  `dedu_def_code` varchar(255) NOT NULL,
  `dedu_type_code` varchar(255) NOT NULL,
  `dedu_group_code` varchar(255) NOT NULL,
  `man_number` varchar(255) NOT NULL,
  `tenure` int(11) NOT NULL,
  `principal_amount` decimal(8,2) NOT NULL,
  `interest_amount` decimal(8,2) NOT NULL,
  `loan_amount` decimal(8,2) NOT NULL,
  `monthly_instalment` decimal(8,2) NOT NULL,
  `monthly_instalment_deducted` decimal(8,2) NOT NULL,
  `interest_paid_to_date` decimal(8,2) NOT NULL,
  `principal_paid_to_date` decimal(8,2) NOT NULL,
  `total_paid_to_date` decimal(8,2) NOT NULL,
  `loan_balance_amount` decimal(8,2) NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date DEFAULT NULL,
  `last_payment_date` date NOT NULL,
  `next_payment_date` date DEFAULT NULL,
  `number_of_payments` int(11) DEFAULT NULL,
  `number_of_payments_made` int(11) DEFAULT NULL,
  `number_of_payments_remaining` int(11) DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_loans_created_by_foreign` (`created_by`),
  KEY `pam_loans_updated_by_foreign` (`updated_by`),
  KEY `pam_loans_dedu_def_id_foreign` (`dedu_def_id`),
  CONSTRAINT `pam_loans_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_loans_dedu_def_id_foreign` FOREIGN KEY (`dedu_def_id`) REFERENCES `pam_dedu_defs` (`id`),
  CONSTRAINT `pam_loans_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_loans`
--


--
-- Table structure for table `pam_pay_cont_defs`
--

CREATE TABLE `pam_pay_cont_defs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `cont_def_code` varchar(255) NOT NULL,
  `cont_def_id` bigint(20) unsigned NOT NULL,
  `payroll_id` bigint(20) unsigned NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `frequency` int(11) DEFAULT NULL,
  `employee_percentage` decimal(8,2) DEFAULT NULL,
  `employer_percentage` decimal(8,2) DEFAULT NULL,
  `employee_fixed_amount` decimal(8,2) DEFAULT NULL,
  `employer_fixed_amount` decimal(8,2) DEFAULT NULL,
  `mode_of_calculation` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_pay_cont_defs_created_by_foreign` (`created_by`),
  KEY `pam_pay_cont_defs_updated_by_foreign` (`updated_by`),
  KEY `pam_pay_cont_defs_cont_def_id_foreign` (`cont_def_id`),
  KEY `pam_pay_cont_defs_payroll_id_foreign` (`payroll_id`),
  CONSTRAINT `pam_pay_cont_defs_cont_def_id_foreign` FOREIGN KEY (`cont_def_id`) REFERENCES `pam_cont_defs` (`id`),
  CONSTRAINT `pam_pay_cont_defs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_pay_cont_defs_payroll_id_foreign` FOREIGN KEY (`payroll_id`) REFERENCES `pam_payrolls` (`id`),
  CONSTRAINT `pam_pay_cont_defs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_pay_cont_defs`
--


--
-- Table structure for table `pam_pay_dedu_defs`
--

CREATE TABLE `pam_pay_dedu_defs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `dedu_def_id` bigint(20) unsigned NOT NULL,
  `dedu_def_code` varchar(255) NOT NULL,
  `payroll_id` bigint(20) unsigned NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `percentage` decimal(8,2) DEFAULT NULL,
  `fixed_amount` decimal(8,2) DEFAULT NULL,
  `mode_of_calculation` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_pay_dedu_defs_created_by_foreign` (`created_by`),
  KEY `pam_pay_dedu_defs_updated_by_foreign` (`updated_by`),
  KEY `pam_pay_dedu_defs_dedu_def_id_foreign` (`dedu_def_id`),
  KEY `pam_pay_dedu_defs_payroll_id_foreign` (`payroll_id`),
  CONSTRAINT `pam_pay_dedu_defs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_pay_dedu_defs_dedu_def_id_foreign` FOREIGN KEY (`dedu_def_id`) REFERENCES `pam_dedu_defs` (`id`),
  CONSTRAINT `pam_pay_dedu_defs_payroll_id_foreign` FOREIGN KEY (`payroll_id`) REFERENCES `pam_payrolls` (`id`),
  CONSTRAINT `pam_pay_dedu_defs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_pay_dedu_defs`
--

INSERT INTO `pam_pay_dedu_defs` VALUES (1,1,'PAYE',1,'Pay As You Earn','Pay As You Earn (PAYE) is a tax on employee\'s income. It is deducted from salaries and wages by employers who are registered with the Kenya Revenue Authority (KRA) and paid to the KRA on a monthly basis.',NULL,NULL,'fixed','active',12,12,'2024-01-22 18:02:25','2024-01-22 18:02:25'),(2,2,'NAPSA',1,'NAPSA','NAPSA is a social security scheme that provides basic cover to all eligible employees in Zambia. The NAPSA Act No. 40 of 1996 of the Laws of Zambia established the National Pension Scheme Authority.',NULL,NULL,'fixed','active',12,12,'2024-01-22 18:02:25','2024-01-22 18:02:25');

--
-- Table structure for table `pam_pay_earn_defs`
--

CREATE TABLE `pam_pay_earn_defs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `earn_def_id` bigint(20) unsigned NOT NULL,
  `earn_def_code` varchar(255) NOT NULL,
  `payroll_id` bigint(20) unsigned NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `percentage` decimal(8,2) DEFAULT NULL,
  `fixed_amount` decimal(8,2) DEFAULT NULL,
  `mode_of_calculation` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_pay_earn_defs_created_by_foreign` (`created_by`),
  KEY `pam_pay_earn_defs_updated_by_foreign` (`updated_by`),
  KEY `pam_pay_earn_defs_earn_def_id_foreign` (`earn_def_id`),
  KEY `pam_pay_earn_defs_payroll_id_foreign` (`payroll_id`),
  CONSTRAINT `pam_pay_earn_defs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_pay_earn_defs_earn_def_id_foreign` FOREIGN KEY (`earn_def_id`) REFERENCES `pam_earn_defs` (`id`),
  CONSTRAINT `pam_pay_earn_defs_payroll_id_foreign` FOREIGN KEY (`payroll_id`) REFERENCES `pam_payrolls` (`id`),
  CONSTRAINT `pam_pay_earn_defs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_pay_earn_defs`
--

INSERT INTO `pam_pay_earn_defs` VALUES (1,1,'BASICPAY',1,'Basic Pay','Basic Pay is the amount of money an employee receives before any extras are added or taken off, such as bonuses, overtime, tax, and deductions. It does not include bonuses, overtime and any other allowances.',NULL,NULL,'fixed','active',12,12,'2024-01-22 18:02:25','2024-01-22 18:02:25');

--
-- Table structure for table `pam_pay_run_periods`
--

CREATE TABLE `pam_pay_run_periods` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `period_status` varchar(255) NOT NULL,
  `processing_status` varchar(255) NOT NULL,
  `capture_status` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `tax_year_id` bigint(20) unsigned NOT NULL,
  `calendar_year` bigint(20) unsigned NOT NULL,
  `calendar_month` bigint(20) unsigned NOT NULL,
  `calendar_days_in_period` bigint(20) unsigned NOT NULL,
  `work_days_in_period` bigint(20) unsigned NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_pay_run_periods_created_by_foreign` (`created_by`),
  KEY `pam_pay_run_periods_updated_by_foreign` (`updated_by`),
  KEY `pam_pay_run_periods_tax_year_id_foreign` (`tax_year_id`),
  CONSTRAINT `pam_pay_run_periods_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_pay_run_periods_tax_year_id_foreign` FOREIGN KEY (`tax_year_id`) REFERENCES `pam_tax_years` (`id`),
  CONSTRAINT `pam_pay_run_periods_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_pay_run_periods`
--

INSERT INTO `pam_pay_run_periods` VALUES (1,'Active','Pending','Open','2023-01-01 00:00:00','2023-01-31 23:59:59',1,2023,1,31,31,12,12,'2023-11-29 17:12:14','2023-11-29 17:12:14'),(2,'Active','Pending','Open','2023-03-01 00:00:00','2023-03-31 23:59:59',1,2023,2,28,28,12,12,'2023-11-29 17:12:14','2023-11-29 17:12:14'),(3,'Active','Pending','Open','2023-03-01 00:00:00','2023-03-31 23:59:59',1,2023,3,31,31,12,12,'2023-11-29 17:12:14','2023-11-29 17:12:14'),(4,'Active','Pending','Open','2023-04-01 00:00:00','2023-04-30 23:59:59',1,2023,4,30,30,12,12,'2023-11-29 17:12:14','2023-11-29 17:12:14'),(5,'Active','Pending','Open','2023-05-01 00:00:00','2023-05-31 23:59:59',1,2023,5,31,31,12,12,'2023-11-29 17:12:14','2023-11-29 17:12:14'),(6,'Active','Pending','Open','2023-06-01 00:00:00','2023-06-30 23:59:59',1,2023,6,30,30,12,12,'2023-11-29 17:12:14','2023-11-29 17:12:14'),(7,'Active','Pending','Open','2023-07-01 00:00:00','2023-07-31 23:59:59',1,2023,7,31,31,12,12,'2023-11-29 17:12:14','2023-11-29 17:12:14'),(8,'Active','Pending','Open','2023-08-01 00:00:00','2023-08-31 23:59:59',1,2023,8,31,31,12,12,'2023-11-29 17:12:14','2023-11-29 17:12:14'),(9,'Active','Pending','Open','2023-09-01 00:00:00','2023-09-30 23:59:59',1,2023,9,30,30,12,12,'2023-11-29 17:12:14','2023-11-29 17:12:14'),(10,'Active','Pending','Open','2023-10-01 00:00:00','2023-10-31 23:59:59',1,2023,10,31,31,12,12,'2023-11-29 17:12:14','2023-11-29 17:12:14'),(11,'Active','Pending','Open','2023-11-01 00:00:00','2023-11-30 23:59:59',1,2023,11,30,30,12,12,'2023-11-29 17:12:14','2023-11-29 17:12:14'),(12,'Active','Pending','Open','2023-12-01 00:00:00','2023-12-31 23:59:59',1,2023,12,31,31,12,12,'2023-11-29 17:12:14','2023-11-29 17:12:14'),(13,'Active','Pending','Open','2024-01-01 00:00:00','2024-01-31 23:59:59',3,2024,1,31,30,12,12,'2024-01-16 14:10:32','2024-01-16 14:10:32'),(14,'Active','Pending','Open','2024-02-01 00:00:00','2024-02-29 23:59:59',3,2024,2,29,28,12,12,'2024-01-16 14:10:32','2024-01-16 14:10:32'),(15,'Active','Pending','Open','2024-03-01 00:00:00','2024-03-31 23:59:59',3,2024,3,31,30,12,12,'2024-01-16 14:10:32','2024-01-16 14:10:32'),(16,'Active','Pending','Open','2024-04-01 00:00:00','2024-04-30 23:59:59',3,2024,4,30,29,12,12,'2024-01-16 14:10:32','2024-01-16 14:10:32'),(17,'Active','Pending','Open','2024-05-01 00:00:00','2024-05-31 23:59:59',3,2024,5,31,30,12,12,'2024-01-16 14:10:32','2024-01-16 14:10:32'),(18,'Active','Pending','Open','2024-06-01 00:00:00','2024-06-30 23:59:59',3,2024,6,30,29,12,12,'2024-01-16 14:10:32','2024-01-16 14:10:32'),(19,'Active','Pending','Open','2024-07-01 00:00:00','2024-07-31 23:59:59',3,2024,7,31,30,12,12,'2024-01-16 14:10:32','2024-01-16 14:10:32'),(20,'Active','Pending','Open','2024-08-01 00:00:00','2024-08-31 23:59:59',3,2024,8,31,30,12,12,'2024-01-16 14:10:32','2024-01-16 14:10:32'),(21,'Active','Pending','Open','2024-09-01 00:00:00','2024-09-30 23:59:59',3,2024,9,30,29,12,12,'2024-01-16 14:10:32','2024-01-16 14:10:32'),(22,'Active','Pending','Open','2024-10-01 00:00:00','2024-10-31 23:59:59',3,2024,10,31,30,12,12,'2024-01-16 14:10:32','2024-01-16 14:10:32'),(23,'Active','Pending','Open','2024-11-01 00:00:00','2024-11-30 23:59:59',3,2024,11,30,29,12,12,'2024-01-16 14:10:32','2024-01-16 14:10:32'),(24,'Active','Pending','Open','2024-12-01 00:00:00','2024-12-31 23:59:59',3,2024,12,31,30,12,12,'2024-01-16 14:10:32','2024-01-16 14:10:32'),(25,'Active','Pending','Open','2015-01-01 00:00:00','2015-01-31 23:59:59',4,2015,1,31,31,12,12,'2024-01-16 14:14:59','2024-01-16 14:14:59'),(26,'Active','Pending','Open','2015-02-01 00:00:00','2015-02-28 23:59:59',4,2015,2,28,28,12,12,'2024-01-16 14:14:59','2024-01-16 14:14:59'),(27,'Active','Pending','Open','2015-03-01 00:00:00','2015-03-31 23:59:59',4,2015,3,31,31,12,12,'2024-01-16 14:14:59','2024-01-16 14:14:59'),(28,'Active','Pending','Open','2015-04-01 00:00:00','2015-04-30 23:59:59',4,2015,4,30,30,12,12,'2024-01-16 14:14:59','2024-01-16 14:14:59'),(29,'Active','Pending','Open','2015-05-01 00:00:00','2015-05-31 23:59:59',4,2015,5,31,31,12,12,'2024-01-16 14:14:59','2024-01-16 14:14:59'),(30,'Active','Pending','Open','2015-06-01 00:00:00','2015-06-30 23:59:59',4,2015,6,30,30,12,12,'2024-01-16 14:14:59','2024-01-16 14:14:59'),(31,'Active','Pending','Open','2015-07-01 00:00:00','2015-07-31 23:59:59',4,2015,7,31,31,12,12,'2024-01-16 14:14:59','2024-01-16 14:14:59'),(32,'Active','Pending','Open','2015-08-01 00:00:00','2015-08-31 23:59:59',4,2015,8,31,31,12,12,'2024-01-16 14:14:59','2024-01-16 14:14:59'),(33,'Active','Pending','Open','2015-09-01 00:00:00','2015-09-30 23:59:59',4,2015,9,30,30,12,12,'2024-01-16 14:14:59','2024-01-16 14:14:59'),(34,'Active','Pending','Open','2015-10-01 00:00:00','2015-10-31 23:59:59',4,2015,10,31,31,12,12,'2024-01-16 14:14:59','2024-01-16 14:14:59'),(35,'Active','Pending','Open','2015-11-01 00:00:00','2015-11-30 23:59:59',4,2015,11,30,30,12,12,'2024-01-16 14:14:59','2024-01-16 14:14:59'),(36,'Active','Pending','Open','2015-12-01 00:00:00','2015-12-31 23:59:59',4,2015,12,31,31,12,12,'2024-01-16 14:14:59','2024-01-16 14:14:59');

--
-- Table structure for table `pam_pay_runs`
--

CREATE TABLE `pam_pay_runs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `payroll_id` bigint(20) unsigned NOT NULL,
  `tax_table_id` bigint(20) unsigned NOT NULL,
  `social_security_id` bigint(20) unsigned DEFAULT NULL,
  `pay_run_period_id` bigint(20) unsigned DEFAULT NULL,
  `prev_pay_run_id` bigint(20) unsigned DEFAULT NULL,
  `next_pay_run_id` bigint(20) unsigned DEFAULT NULL,
  `pay_run_status` varchar(255) NOT NULL,
  `active` tinyint(1) NOT NULL,
  `transaction_date` datetime DEFAULT NULL,
  `actual_processing_date` datetime DEFAULT NULL,
  `release_to_ess` tinyint(1) NOT NULL DEFAULT 0,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_pay_runs_created_by_foreign` (`created_by`),
  KEY `pam_pay_runs_updated_by_foreign` (`updated_by`),
  KEY `pam_pay_runs_payroll_id_foreign` (`payroll_id`),
  KEY `pam_pay_runs_pay_run_period_id_foreign` (`pay_run_period_id`),
  KEY `pam_pay_runs_prev_pay_run_id_foreign` (`prev_pay_run_id`),
  KEY `pam_pay_runs_next_pay_run_id_foreign` (`next_pay_run_id`),
  KEY `pam_pay_runs_tax_table_id_foreign` (`tax_table_id`),
  KEY `pam_pay_runs_social_security_id_foreign` (`social_security_id`),
  CONSTRAINT `pam_pay_runs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_pay_runs_next_pay_run_id_foreign` FOREIGN KEY (`next_pay_run_id`) REFERENCES `pam_pay_runs` (`id`),
  CONSTRAINT `pam_pay_runs_pay_run_period_id_foreign` FOREIGN KEY (`pay_run_period_id`) REFERENCES `pam_pay_run_periods` (`id`),
  CONSTRAINT `pam_pay_runs_payroll_id_foreign` FOREIGN KEY (`payroll_id`) REFERENCES `pam_payrolls` (`id`),
  CONSTRAINT `pam_pay_runs_prev_pay_run_id_foreign` FOREIGN KEY (`prev_pay_run_id`) REFERENCES `pam_pay_runs` (`id`),
  CONSTRAINT `pam_pay_runs_social_security_id_foreign` FOREIGN KEY (`social_security_id`) REFERENCES `pam_social_securities` (`id`),
  CONSTRAINT `pam_pay_runs_tax_table_id_foreign` FOREIGN KEY (`tax_table_id`) REFERENCES `pam_tax_tables` (`id`),
  CONSTRAINT `pam_pay_runs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_pay_runs`
--

INSERT INTO `pam_pay_runs` VALUES (1,1,1,NULL,1,NULL,3,'closed',0,'2024-01-22 20:02:25','2024-01-22 20:02:25',1,12,12,'2024-01-22 18:02:25','2024-01-23 07:37:12'),(3,1,1,NULL,2,1,NULL,'open',1,'2024-01-23 09:37:12','2024-01-23 09:37:12',0,13,13,'2024-01-23 07:37:12','2024-01-23 07:37:12');

--
-- Table structure for table `pam_payrolls`
--

CREATE TABLE `pam_payrolls` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `short_description` varchar(255) NOT NULL,
  `long_description` longtext NOT NULL,
  `working_days` int(11) NOT NULL DEFAULT 0,
  `start_date` datetime NOT NULL,
  `current_period_year` bigint(20) unsigned DEFAULT NULL,
  `current_period_month` bigint(20) unsigned DEFAULT NULL,
  `current_pay_run_id` bigint(20) unsigned DEFAULT NULL,
  `current_social_security_id` bigint(20) unsigned DEFAULT NULL,
  `current_tax_table_id` bigint(20) unsigned DEFAULT NULL,
  `comments` longtext DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `earnings` int(11) NOT NULL DEFAULT 0,
  `deductions` int(11) NOT NULL DEFAULT 0,
  `contributions` int(11) NOT NULL DEFAULT 0,
  `pension` int(11) NOT NULL DEFAULT 0,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_payrolls_code_unique` (`code`),
  UNIQUE KEY `pam_payrolls_short_description_unique` (`short_description`),
  KEY `pam_payrolls_created_by_foreign` (`created_by`),
  KEY `pam_payrolls_updated_by_foreign` (`updated_by`),
  KEY `pam_payrolls_current_social_security_id_foreign` (`current_social_security_id`),
  KEY `pam_payrolls_current_tax_table_id_foreign` (`current_tax_table_id`),
  CONSTRAINT `pam_payrolls_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_payrolls_current_social_security_id_foreign` FOREIGN KEY (`current_social_security_id`) REFERENCES `pam_social_securities` (`id`),
  CONSTRAINT `pam_payrolls_current_tax_table_id_foreign` FOREIGN KEY (`current_tax_table_id`) REFERENCES `pam_tax_tables` (`id`),
  CONSTRAINT `pam_payrolls_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_payrolls`
--

INSERT INTO `pam_payrolls` VALUES (1,'DEMO','DEMO','DEMO',22,'2023-01-01 00:00:00',2023,2,3,1,1,NULL,'active',0,0,0,0,12,12,'2024-01-22 18:02:25','2024-01-23 07:37:12');

--
-- Table structure for table `pam_payslip_dedu_defs`
--

CREATE TABLE `pam_payslip_dedu_defs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pay_run_id` bigint(20) unsigned NOT NULL,
  `dedu_def_id` bigint(20) unsigned NOT NULL,
  `dedu_def_code` varchar(255) NOT NULL,
  `payslip_id` bigint(20) unsigned NOT NULL,
  `emp_id` bigint(20) unsigned NOT NULL,
  `man_number` varchar(255) NOT NULL,
  `loan_id` bigint(20) unsigned DEFAULT NULL,
  `units` decimal(8,2) NOT NULL,
  `emp_rate` decimal(8,2) NOT NULL,
  `input_amount` decimal(8,2) NOT NULL,
  `amount` decimal(8,2) NOT NULL,
  `recurrence_period_1` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_2` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_3` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_4` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_5` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_6` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_7` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_8` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_9` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_10` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_11` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_12` int(11) NOT NULL DEFAULT 0,
  `mandatory` tinyint(1) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `dedu_group_code` varchar(255) NOT NULL,
  `dedu_type_code` varchar(255) NOT NULL,
  `pay_run_period_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_payslip_dedu_defs_pay_run_id_foreign` (`pay_run_id`),
  KEY `pam_payslip_dedu_defs_pay_run_period_id_foreign` (`pay_run_period_id`),
  KEY `pam_payslip_dedu_defs_created_by_foreign` (`created_by`),
  KEY `pam_payslip_dedu_defs_updated_by_foreign` (`updated_by`),
  KEY `pam_payslip_dedu_defs_dedu_def_id_foreign` (`dedu_def_id`),
  KEY `pam_payslip_dedu_defs_payslip_id_foreign` (`payslip_id`),
  KEY `pam_payslip_dedu_defs_loan_id_foreign` (`loan_id`),
  CONSTRAINT `pam_payslip_dedu_defs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_payslip_dedu_defs_dedu_def_id_foreign` FOREIGN KEY (`dedu_def_id`) REFERENCES `pam_dedu_defs` (`id`),
  CONSTRAINT `pam_payslip_dedu_defs_loan_id_foreign` FOREIGN KEY (`loan_id`) REFERENCES `pam_loans` (`id`),
  CONSTRAINT `pam_payslip_dedu_defs_pay_run_id_foreign` FOREIGN KEY (`pay_run_id`) REFERENCES `pam_pay_runs` (`id`),
  CONSTRAINT `pam_payslip_dedu_defs_pay_run_period_id_foreign` FOREIGN KEY (`pay_run_period_id`) REFERENCES `pam_pay_run_periods` (`id`),
  CONSTRAINT `pam_payslip_dedu_defs_payslip_id_foreign` FOREIGN KEY (`payslip_id`) REFERENCES `pam_payslips` (`id`),
  CONSTRAINT `pam_payslip_dedu_defs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_payslip_dedu_defs`
--

INSERT INTO `pam_payslip_dedu_defs` VALUES (1,1,1,'PAYE',1,15,'8588',NULL,22.00,1.00,5192.50,5192.50,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:35:20','2024-01-23 07:35:21','2023-01-31 23:59:59',NULL,'STATUTORY','INCTAX',1),(3,1,5,'PEL',1,15,'8588',NULL,1.00,1.00,7.50,7.50,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:35:21','2024-01-23 07:35:21','2023-01-31 23:59:59',NULL,'STATUTORY','LEVY',1),(4,1,2,'NAPSA',1,15,'8588',NULL,22.00,1.00,1000.00,1000.00,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:35:21','2024-01-23 07:35:21','2023-01-31 23:59:59',NULL,'STATUTORY','SOCIALSECURITY',1),(5,1,1,'PAYE',2,13,'10574',NULL,22.00,1.00,17942.50,17942.50,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:35:26','2024-01-23 07:35:27','2023-01-31 23:59:59',NULL,'STATUTORY','INCTAX',1),(7,1,5,'PEL',2,13,'10574',NULL,1.00,1.00,7.50,7.50,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:35:27','2024-01-23 07:35:27','2023-01-31 23:59:59',NULL,'STATUTORY','LEVY',1),(8,1,2,'NAPSA',2,13,'10574',NULL,22.00,1.00,1221.81,1221.81,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:35:27','2024-01-23 07:35:27','2023-01-31 23:59:59',NULL,'STATUTORY','SOCIALSECURITY',1),(9,3,1,'PAYE',3,13,'10574',NULL,22.00,1.00,17942.50,17942.50,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13','2023-01-31 23:59:59',NULL,'STATUTORY','INCTAX',2),(10,3,5,'PEL',3,13,'10574',NULL,22.00,1.00,7.50,7.50,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13','2023-01-31 23:59:59',NULL,'STATUTORY','LEVY',2),(11,3,2,'NAPSA',3,13,'10574',NULL,22.00,1.00,1221.81,1221.81,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13','2023-01-31 23:59:59',NULL,'STATUTORY','SOCIALSECURITY',2),(12,3,1,'PAYE',4,15,'8588',NULL,22.00,1.00,5192.50,5192.50,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13','2023-01-31 23:59:59',NULL,'STATUTORY','INCTAX',2),(13,3,5,'PEL',4,15,'8588',NULL,22.00,1.00,7.50,7.50,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13','2023-01-31 23:59:59',NULL,'STATUTORY','LEVY',2),(14,3,2,'NAPSA',4,15,'8588',NULL,22.00,1.00,1000.00,1000.00,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13','2023-01-31 23:59:59',NULL,'STATUTORY','SOCIALSECURITY',2);

--
-- Table structure for table `pam_payslip_dedus`
--

CREATE TABLE `pam_payslip_dedus` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pay_run_id` bigint(20) unsigned NOT NULL,
  `dedu_def_id` bigint(20) unsigned NOT NULL,
  `dedu_def_code` varchar(255) NOT NULL,
  `payslip_id` bigint(20) unsigned NOT NULL,
  `loan_id` bigint(20) unsigned DEFAULT NULL,
  `emp_id` bigint(20) unsigned NOT NULL,
  `man_number` varchar(255) NOT NULL,
  `units` decimal(8,2) NOT NULL,
  `fixed_amount` decimal(8,2) NOT NULL,
  `recurrence_amount` decimal(8,2) NOT NULL,
  `recurrence_count` bigint(20) unsigned NOT NULL,
  `amount` decimal(8,2) NOT NULL,
  `total` decimal(8,2) NOT NULL,
  `previous_total` decimal(8,2) NOT NULL,
  `taxable_amount` decimal(8,2) NOT NULL,
  `balance` decimal(8,2) NOT NULL,
  `month_to_date_total` decimal(8,2) NOT NULL,
  `year_to_date_total` decimal(8,2) NOT NULL,
  `month_to_date_units` decimal(8,2) NOT NULL,
  `year_to_date_units` decimal(8,2) NOT NULL,
  `month_to_date_taxable_amount` decimal(8,2) NOT NULL,
  `year_to_date_taxable_amount` decimal(8,2) NOT NULL,
  `recurrence_period_1` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_2` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_3` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_4` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_5` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_6` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_7` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_8` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_9` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_10` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_11` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_12` int(11) NOT NULL DEFAULT 0,
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `dedu_group_code` varchar(255) NOT NULL,
  `dedu_type_code` varchar(255) NOT NULL,
  `pay_run_period_id` bigint(20) unsigned NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_payslip_dedus_pay_run_id_foreign` (`pay_run_id`),
  KEY `pam_payslip_dedus_pay_run_period_id_foreign` (`pay_run_period_id`),
  KEY `pam_payslip_dedus_created_by_foreign` (`created_by`),
  KEY `pam_payslip_dedus_updated_by_foreign` (`updated_by`),
  KEY `pam_payslip_dedus_dedu_def_id_foreign` (`dedu_def_id`),
  KEY `pam_payslip_dedus_payslip_id_foreign` (`payslip_id`),
  KEY `pam_payslip_dedus_loan_id_foreign` (`loan_id`),
  CONSTRAINT `pam_payslip_dedus_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_payslip_dedus_dedu_def_id_foreign` FOREIGN KEY (`dedu_def_id`) REFERENCES `pam_dedu_defs` (`id`),
  CONSTRAINT `pam_payslip_dedus_loan_id_foreign` FOREIGN KEY (`loan_id`) REFERENCES `pam_loans` (`id`),
  CONSTRAINT `pam_payslip_dedus_pay_run_id_foreign` FOREIGN KEY (`pay_run_id`) REFERENCES `pam_pay_runs` (`id`),
  CONSTRAINT `pam_payslip_dedus_pay_run_period_id_foreign` FOREIGN KEY (`pay_run_period_id`) REFERENCES `pam_pay_run_periods` (`id`),
  CONSTRAINT `pam_payslip_dedus_payslip_id_foreign` FOREIGN KEY (`payslip_id`) REFERENCES `pam_payslips` (`id`),
  CONSTRAINT `pam_payslip_dedus_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_payslip_dedus`
--

INSERT INTO `pam_payslip_dedus` VALUES (1,1,1,'PAYE',1,NULL,15,'8588',22.00,0.00,0.00,1,5192.50,0.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'STATUTORY','INCTAX',1,13,13,'2024-01-23 07:35:20','2024-01-23 07:35:21'),(3,1,5,'PEL',1,NULL,15,'8588',1.00,7.50,7.50,1,7.50,7.50,7.50,7.50,7.50,7.50,7.50,1.00,1.00,7.50,7.50,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'STATUTORY','LEVY',1,13,13,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(4,1,2,'NAPSA',1,NULL,15,'8588',22.00,1000.00,1000.00,1,1000.00,1000.00,1000.00,1000.00,1000.00,1000.00,1000.00,22.00,22.00,1000.00,1000.00,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'STATUTORY','SOCIALSECURITY',1,13,13,'2024-01-23 07:35:21','2024-01-23 07:35:21'),(5,1,1,'PAYE',2,NULL,13,'10574',22.00,0.00,0.00,1,17942.50,0.00,0.00,0.00,0.00,0.00,0.00,1.00,1.00,0.00,0.00,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'STATUTORY','INCTAX',1,13,13,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(7,1,5,'PEL',2,NULL,13,'10574',1.00,7.50,7.50,1,7.50,7.50,7.50,7.50,7.50,7.50,7.50,1.00,1.00,7.50,7.50,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'STATUTORY','LEVY',1,13,13,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(8,1,2,'NAPSA',2,NULL,13,'10574',22.00,1221.81,1221.81,1,1221.81,1221.81,1221.81,1221.81,1221.81,1221.81,1221.81,22.00,22.00,1221.81,1221.81,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'STATUTORY','SOCIALSECURITY',1,13,13,'2024-01-23 07:35:27','2024-01-23 07:35:27'),(9,3,1,'PAYE',3,NULL,13,'10574',22.00,17942.50,17942.50,1,17942.50,17942.50,17942.50,17942.50,17942.50,17942.50,17942.50,22.00,22.00,17942.50,17942.50,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'STATUTORY','INCTAX',2,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(10,3,5,'PEL',3,NULL,13,'10574',22.00,7.50,7.50,1,7.50,7.50,7.50,7.50,7.50,7.50,7.50,22.00,22.00,7.50,7.50,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'STATUTORY','LEVY',2,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(11,3,2,'NAPSA',3,NULL,13,'10574',22.00,1221.81,1221.81,1,1221.81,1221.81,1221.81,1221.81,1221.81,1221.81,1221.81,22.00,22.00,1221.81,1221.81,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'STATUTORY','SOCIALSECURITY',2,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(12,3,1,'PAYE',4,NULL,15,'8588',22.00,5192.50,5192.50,1,5192.50,5192.50,5192.50,5192.50,5192.50,5192.50,5192.50,22.00,22.00,5192.50,5192.50,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'STATUTORY','INCTAX',2,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(13,3,5,'PEL',4,NULL,15,'8588',22.00,7.50,7.50,1,7.50,7.50,7.50,7.50,7.50,7.50,7.50,22.00,22.00,7.50,7.50,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'STATUTORY','LEVY',2,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(14,3,2,'NAPSA',4,NULL,15,'8588',22.00,1000.00,1000.00,1,1000.00,1000.00,1000.00,1000.00,1000.00,1000.00,1000.00,22.00,22.00,1000.00,1000.00,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'STATUTORY','SOCIALSECURITY',2,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13');

--
-- Table structure for table `pam_payslip_earn_defs`
--

CREATE TABLE `pam_payslip_earn_defs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pay_run_id` bigint(20) unsigned NOT NULL,
  `earn_def_id` bigint(20) unsigned NOT NULL,
  `earn_def_code` varchar(255) NOT NULL,
  `payslip_id` bigint(20) unsigned NOT NULL,
  `emp_id` bigint(20) unsigned NOT NULL,
  `man_number` varchar(255) NOT NULL,
  `units` decimal(8,2) NOT NULL,
  `emp_rate` decimal(8,2) NOT NULL,
  `input_amount` decimal(8,2) NOT NULL,
  `amount` decimal(8,2) NOT NULL,
  `recurrence_period_1` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_2` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_3` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_4` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_5` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_6` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_7` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_8` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_9` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_10` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_11` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_12` int(11) NOT NULL DEFAULT 0,
  `mandatory` tinyint(1) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `earn_group_code` varchar(255) NOT NULL,
  `earn_type_code` varchar(255) NOT NULL,
  `pay_run_period_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_payslip_earn_defs_pay_run_id_foreign` (`pay_run_id`),
  KEY `pam_payslip_earn_defs_pay_run_period_id_foreign` (`pay_run_period_id`),
  KEY `pam_payslip_earn_defs_created_by_foreign` (`created_by`),
  KEY `pam_payslip_earn_defs_updated_by_foreign` (`updated_by`),
  KEY `pam_payslip_earn_defs_earn_def_id_foreign` (`earn_def_id`),
  KEY `pam_payslip_earn_defs_payslip_id_foreign` (`payslip_id`),
  CONSTRAINT `pam_payslip_earn_defs_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_payslip_earn_defs_earn_def_id_foreign` FOREIGN KEY (`earn_def_id`) REFERENCES `pam_earn_defs` (`id`),
  CONSTRAINT `pam_payslip_earn_defs_pay_run_id_foreign` FOREIGN KEY (`pay_run_id`) REFERENCES `pam_pay_runs` (`id`),
  CONSTRAINT `pam_payslip_earn_defs_pay_run_period_id_foreign` FOREIGN KEY (`pay_run_period_id`) REFERENCES `pam_pay_run_periods` (`id`),
  CONSTRAINT `pam_payslip_earn_defs_payslip_id_foreign` FOREIGN KEY (`payslip_id`) REFERENCES `pam_payslips` (`id`),
  CONSTRAINT `pam_payslip_earn_defs_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_payslip_earn_defs`
--

INSERT INTO `pam_payslip_earn_defs` VALUES (1,1,1,'BASICPAY',1,15,'8588',22.00,909.09,20000.00,20000.00,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:35:20','2024-01-23 07:35:20','2023-01-31 23:59:59',NULL,'TAXABLE','BASIC',1),(2,1,1,'BASICPAY',2,13,'10574',22.00,2454.55,54000.00,54000.00,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:35:26','2024-01-23 07:35:26','2023-01-31 23:59:59',NULL,'TAXABLE','BASIC',1),(3,3,1,'BASICPAY',3,13,'10574',22.00,2454.55,54000.00,54000.00,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13','2023-01-31 23:59:59',NULL,'TAXABLE','BASIC',2),(4,3,1,'BASICPAY',4,15,'8588',22.00,909.09,20000.00,20000.00,1,1,1,1,1,1,1,1,1,1,1,1,1,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13','2023-01-31 23:59:59',NULL,'TAXABLE','BASIC',2);

--
-- Table structure for table `pam_payslip_earns`
--

CREATE TABLE `pam_payslip_earns` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `pay_run_id` bigint(20) unsigned NOT NULL,
  `earn_def_id` bigint(20) unsigned NOT NULL,
  `earn_def_code` varchar(255) NOT NULL,
  `payslip_id` bigint(20) unsigned NOT NULL,
  `emp_id` bigint(20) unsigned NOT NULL,
  `man_number` varchar(255) NOT NULL,
  `units` decimal(8,2) NOT NULL,
  `fixed_amount` decimal(8,2) NOT NULL,
  `recurrence_amount` decimal(8,2) NOT NULL,
  `recurrence_count` bigint(20) unsigned NOT NULL,
  `amount` decimal(8,2) NOT NULL,
  `total` decimal(8,2) NOT NULL,
  `previous_total` decimal(8,2) NOT NULL,
  `taxable_amount` decimal(8,2) NOT NULL,
  `balance` decimal(8,2) NOT NULL,
  `month_to_date_total` decimal(8,2) NOT NULL,
  `year_to_date_total` decimal(8,2) NOT NULL,
  `month_to_date_units` decimal(8,2) NOT NULL,
  `year_to_date_units` decimal(8,2) NOT NULL,
  `month_to_date_taxable_amount` decimal(8,2) NOT NULL,
  `year_to_date_taxable_amount` decimal(8,2) NOT NULL,
  `recurrence_period_1` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_2` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_3` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_4` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_5` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_6` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_7` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_8` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_9` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_10` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_11` int(11) NOT NULL DEFAULT 0,
  `recurrence_period_12` int(11) NOT NULL DEFAULT 0,
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `earn_group_code` varchar(255) NOT NULL,
  `earn_type_code` varchar(255) NOT NULL,
  `pay_run_period_id` bigint(20) unsigned NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_payslip_earns_pay_run_id_foreign` (`pay_run_id`),
  KEY `pam_payslip_earns_pay_run_period_id_foreign` (`pay_run_period_id`),
  KEY `pam_payslip_earns_created_by_foreign` (`created_by`),
  KEY `pam_payslip_earns_updated_by_foreign` (`updated_by`),
  KEY `pam_payslip_earns_earn_def_id_foreign` (`earn_def_id`),
  KEY `pam_payslip_earns_payslip_id_foreign` (`payslip_id`),
  CONSTRAINT `pam_payslip_earns_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_payslip_earns_earn_def_id_foreign` FOREIGN KEY (`earn_def_id`) REFERENCES `pam_earn_defs` (`id`),
  CONSTRAINT `pam_payslip_earns_pay_run_id_foreign` FOREIGN KEY (`pay_run_id`) REFERENCES `pam_pay_runs` (`id`),
  CONSTRAINT `pam_payslip_earns_pay_run_period_id_foreign` FOREIGN KEY (`pay_run_period_id`) REFERENCES `pam_pay_run_periods` (`id`),
  CONSTRAINT `pam_payslip_earns_payslip_id_foreign` FOREIGN KEY (`payslip_id`) REFERENCES `pam_payslips` (`id`),
  CONSTRAINT `pam_payslip_earns_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_payslip_earns`
--

INSERT INTO `pam_payslip_earns` VALUES (1,1,1,'BASICPAY',1,15,'8588',22.00,20000.00,20000.00,1,20000.00,20000.00,20000.00,20000.00,20000.00,20000.00,20000.00,22.00,22.00,20000.00,20000.00,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'TAXABLE','BASIC',1,13,13,'2024-01-23 07:35:20','2024-01-23 07:35:20'),(2,1,1,'BASICPAY',2,13,'10574',22.00,54000.00,54000.00,1,54000.00,54000.00,54000.00,54000.00,54000.00,54000.00,54000.00,22.00,22.00,54000.00,54000.00,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'TAXABLE','BASIC',1,13,13,'2024-01-23 07:35:26','2024-01-23 07:35:26'),(3,3,1,'BASICPAY',3,13,'10574',22.00,54000.00,54000.00,1,54000.00,54000.00,54000.00,54000.00,54000.00,54000.00,54000.00,22.00,22.00,54000.00,54000.00,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'TAXABLE','BASIC',2,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13'),(4,3,1,'BASICPAY',4,15,'8588',22.00,20000.00,20000.00,1,20000.00,20000.00,20000.00,20000.00,20000.00,20000.00,20000.00,22.00,22.00,20000.00,20000.00,0,0,0,0,0,0,0,0,0,0,0,0,'2023-01-31 23:59:59',NULL,'TAXABLE','BASIC',2,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13');

--
-- Table structure for table `pam_payslips`
--

CREATE TABLE `pam_payslips` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `emp_id` bigint(20) unsigned NOT NULL,
  `pay_run_id` bigint(20) unsigned NOT NULL,
  `pay_run_period_id` bigint(20) unsigned NOT NULL,
  `gross_earnings` decimal(8,2) NOT NULL,
  `deductions` decimal(8,2) NOT NULL,
  `net_pay` decimal(8,2) NOT NULL,
  `taxable_income` decimal(8,2) NOT NULL,
  `non_taxable_income` decimal(8,2) NOT NULL,
  `tax_paid` decimal(8,2) NOT NULL,
  `leave_days` decimal(8,2) NOT NULL,
  `payed_total_year_to_date` decimal(8,2) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_payslips_created_by_foreign` (`created_by`),
  KEY `pam_payslips_updated_by_foreign` (`updated_by`),
  KEY `pam_payslips_pay_run_id_foreign` (`pay_run_id`),
  KEY `pam_payslips_pay_run_period_id_foreign` (`pay_run_period_id`),
  CONSTRAINT `pam_payslips_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_payslips_pay_run_id_foreign` FOREIGN KEY (`pay_run_id`) REFERENCES `pam_pay_runs` (`id`),
  CONSTRAINT `pam_payslips_pay_run_period_id_foreign` FOREIGN KEY (`pay_run_period_id`) REFERENCES `pam_pay_run_periods` (`id`),
  CONSTRAINT `pam_payslips_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_payslips`
--

INSERT INTO `pam_payslips` VALUES (1,15,1,1,20000.00,6200.00,13800.00,20000.00,0.00,5192.50,0.00,0.00,13,13,'2024-01-23 07:35:20','2024-01-23 07:35:21'),(2,13,1,1,54000.00,19171.81,34828.19,54000.00,0.00,17942.50,0.00,0.00,13,13,'2024-01-23 07:35:26','2024-01-23 07:35:27'),(3,13,3,2,54000.00,19171.81,34828.19,54000.00,0.00,17942.50,0.00,0.00,13,13,'2024-01-23 07:37:12','2024-01-23 07:37:12'),(4,15,3,2,20000.00,6200.00,13800.00,20000.00,0.00,5192.50,0.00,0.00,13,13,'2024-01-23 07:37:13','2024-01-23 07:37:13');

--
-- Table structure for table `pam_social_securities`
--

CREATE TABLE `pam_social_securities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `tax_year_id` bigint(20) unsigned NOT NULL,
  `tax_year_code` varchar(255) NOT NULL,
  `minimum_monthly_gross_income` decimal(15,2) NOT NULL,
  `employee_contribution_rate` decimal(15,2) NOT NULL,
  `employer_contribution_rate` decimal(15,2) NOT NULL,
  `employee_maximum_ceiling` decimal(15,2) NOT NULL,
  `employer_maximum_ceiling` decimal(15,2) NOT NULL,
  `employee_age_limit` int(11) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_social_securities_code_unique` (`code`),
  KEY `pam_social_securities_created_by_foreign` (`created_by`),
  KEY `pam_social_securities_updated_by_foreign` (`updated_by`),
  KEY `pam_social_securities_tax_year_id_foreign` (`tax_year_id`),
  CONSTRAINT `pam_social_securities_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_social_securities_tax_year_id_foreign` FOREIGN KEY (`tax_year_id`) REFERENCES `pam_tax_years` (`id`),
  CONSTRAINT `pam_social_securities_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_social_securities`
--

INSERT INTO `pam_social_securities` VALUES (1,'2023',1,'2023',0.00,5.00,5.00,1221.81,1221.81,65,'active',12,12,'2023-11-02 13:56:07','2023-11-02 13:56:07');

--
-- Table structure for table `pam_tax_bands`
--

CREATE TABLE `pam_tax_bands` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tax_table_id` bigint(20) unsigned NOT NULL,
  `tax_table_code` varchar(255) NOT NULL,
  `from_amount` decimal(15,2) NOT NULL,
  `to_amount` decimal(15,2) NOT NULL,
  `taxable_amount` decimal(15,2) NOT NULL,
  `tax_percentage` decimal(8,2) NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_tax_bands_tax_table_id_foreign` (`tax_table_id`),
  KEY `pam_tax_bands_created_by_foreign` (`created_by`),
  KEY `pam_tax_bands_updated_by_foreign` (`updated_by`),
  CONSTRAINT `pam_tax_bands_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_tax_bands_tax_table_id_foreign` FOREIGN KEY (`tax_table_id`) REFERENCES `pam_tax_tables` (`id`),
  CONSTRAINT `pam_tax_bands_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_tax_bands`
--

INSERT INTO `pam_tax_bands` VALUES (1,1,'2023',0.00,4800.00,0.00,0.00,'active',12,12,'2023-11-02 11:13:06','2023-11-02 11:13:06'),(2,1,'2023',4800.01,6800.00,2000.00,20.00,'active',12,12,'2023-11-02 11:14:19','2023-11-02 11:14:19'),(3,1,'2023',6800.01,8900.00,2100.00,30.00,'active',12,12,'2023-11-02 11:15:06','2023-11-02 11:15:06'),(4,1,'2023',8900.01,99999999.00,99999999.00,37.50,'active',12,12,'2023-11-02 11:16:03','2023-11-02 11:16:03');

--
-- Table structure for table `pam_tax_tables`
--

CREATE TABLE `pam_tax_tables` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tax_year_id` bigint(20) unsigned NOT NULL,
  `tax_year_code` int(11) NOT NULL,
  `code` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `pam_tax_tables_tax_year_id_foreign` (`tax_year_id`),
  KEY `pam_tax_tables_created_by_foreign` (`created_by`),
  KEY `pam_tax_tables_updated_by_foreign` (`updated_by`),
  CONSTRAINT `pam_tax_tables_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_tax_tables_tax_year_id_foreign` FOREIGN KEY (`tax_year_id`) REFERENCES `pam_tax_years` (`id`),
  CONSTRAINT `pam_tax_tables_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_tax_tables`
--

INSERT INTO `pam_tax_tables` VALUES (1,1,2023,'2023','2023','2023-01-01 00:00:00',NULL,'active',12,12,'2023-11-02 11:12:38','2023-11-02 11:12:38'),(2,2,2014,'2014','2014','2024-01-01 00:00:00',NULL,'active',12,12,'2023-11-24 11:26:41','2023-11-24 11:26:41');

--
-- Table structure for table `pam_tax_years`
--

CREATE TABLE `pam_tax_years` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL,
  `start_date` datetime NOT NULL,
  `end_date` datetime NOT NULL,
  `status` varchar(255) NOT NULL,
  `created_by` bigint(20) unsigned NOT NULL,
  `updated_by` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `pam_tax_years_code_unique` (`code`),
  KEY `pam_tax_years_created_by_foreign` (`created_by`),
  KEY `pam_tax_years_updated_by_foreign` (`updated_by`),
  CONSTRAINT `pam_tax_years_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`),
  CONSTRAINT `pam_tax_years_updated_by_foreign` FOREIGN KEY (`updated_by`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pam_tax_years`
--

INSERT INTO `pam_tax_years` VALUES (1,'2023','Tax Year 2023','2023-01-01 00:00:00','2023-12-31 23:59:59','active',12,12,'2023-11-02 11:10:58','2023-11-02 11:10:58'),(2,'2014','Tax Year 2014','2014-01-01 00:00:00','2014-12-31 23:59:59','active',12,12,'2023-11-24 11:25:08','2023-11-24 11:25:08'),(3,'2024','Tax Year 2024','2024-01-01 00:00:00','2024-12-31 23:59:59','active',12,12,'2024-01-16 14:10:32','2024-01-16 14:10:32'),(4,'2015','Tax Year 2015','2015-01-01 00:00:00','2015-12-31 23:59:59','active',12,12,'2024-01-16 14:14:59','2024-01-16 14:14:59');

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

CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` VALUES (1,'Manage roles','web','2024-01-22 17:41:07','2024-01-22 17:41:07'),(2,'Manage users','web','2024-01-22 17:41:07','2024-01-22 17:41:07'),(3,'Manage contribution types','web','2024-01-22 17:41:07','2024-01-22 17:41:07'),(4,'Manage contribution groups','web','2024-01-22 17:41:07','2024-01-22 17:41:07'),(5,'Manage contribution definitions','web','2024-01-22 17:41:07','2024-01-22 17:41:07'),(6,'Manage deduction types','web','2024-01-22 17:41:07','2024-01-22 17:41:07'),(7,'Manage deduction groups','web','2024-01-22 17:41:07','2024-01-22 17:41:07'),(8,'Manage deduction definitions','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(9,'Manage earning types','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(10,'Manage earning groups','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(11,'Manage earning definitions','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(12,'Manage tax years','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(13,'Manage tax tables','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(14,'Manage payrolls','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(15,'Manage employees','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(16,'Manage payslips','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(17,'Manage loans','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(18,'Run payrolls','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(19,'Close payroll processing','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(20,'Open payroll processing','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(21,'Rollover payrolls','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(22,'Import data','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(23,'Export data','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(24,'View roles','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(25,'View users','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(26,'View contribution types','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(27,'View contribution groups','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(28,'View contribution definitions','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(29,'View deduction types','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(30,'View deduction groups','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(31,'View deduction definitions','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(32,'View earning types','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(33,'View earning groups','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(34,'View earning definitions','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(35,'View tax years','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(36,'View tax tables','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(37,'View payrolls','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(38,'View employees','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(39,'View payslips','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(40,'Show claims','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(41,'Submit claims','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(42,'Approve claims','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(43,'View claims','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(44,'View Reports','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(45,'View historical data','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(46,'Manage deductions','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(47,'View deductions','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(48,'Manage earnings','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(49,'View earnings','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(50,'View audit trail','web','2024-01-22 17:41:08','2024-01-22 17:41:08');

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

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `role_has_permissions` VALUES (1,1),(1,2),(1,3),(2,1),(2,3),(3,1),(3,3),(4,1),(4,3),(5,1),(5,2),(5,3),(6,1),(6,3),(7,1),(7,3),(8,1),(8,3),(9,1),(9,3),(10,1),(10,3),(11,1),(11,3),(12,1),(12,3),(13,1),(13,3),(14,1),(14,3),(15,1),(15,3),(16,1),(17,1),(17,3),(18,1),(18,3),(19,1),(19,3),(20,1),(20,3),(21,1),(21,3),(22,1),(23,1),(23,3),(24,1),(24,2),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(31,1),(32,1),(33,1),(34,1),(35,1),(36,1),(37,1),(38,1),(39,1),(40,1),(41,1),(42,1),(43,1),(43,3),(44,1),(45,1),(46,1),(47,1),(48,1),(49,1),(50,1),(50,3);

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

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` VALUES (1,'Admin','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(2,'User','web','2024-01-22 17:41:08','2024-01-22 17:41:08'),(3,'Test','web','2024-01-22 17:47:02','2024-01-22 17:47:02');


