-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               8.0.23 - MySQL Community Server - GPL
-- Server OS:                    Win64
-- HeidiSQL Version:             11.2.0.6213
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

-- Dumping structure for table peoplei_300_people_qa_20230518.cb_payroll_process_log
DROP TABLE IF EXISTS `cb_payroll_process_log`;
CREATE TABLE IF NOT EXISTS `cb_payroll_process_log` (
  `payroll_process_log_id` int NOT NULL AUTO_INCREMENT,
  `payroll_process_id` int DEFAULT NULL,
  `payroll_process_info_id` int DEFAULT NULL,
  `payroll_emf_id` int DEFAULT NULL,
  `payroll_emf_file_info_id` int DEFAULT NULL,
  `proll_employee_id` int DEFAULT NULL,
  `people_code` int DEFAULT NULL,
  `emp_id` varchar(50) DEFAULT NULL,
  `basic_salary` float(9,2) DEFAULT NULL,
  `housing_allow` float(9,2) DEFAULT NULL,
  `utility_allow` float(9,2) DEFAULT NULL,
  `medical_allow` float(9,2) DEFAULT NULL,
  `car_allow` float(9,2) DEFAULT NULL,
  `fuel_allow` float(9,2) DEFAULT NULL,
  `mobile_allow` float(9,2) DEFAULT NULL,
  `food_allow` float(9,2) DEFAULT NULL,
  `special_allow` float(9,2) DEFAULT NULL,
  `school_allow` float(9,2) DEFAULT NULL,
  `hardship_allow` float(9,2) DEFAULT NULL,
  `transporation_allow` float(9,2) DEFAULT NULL,
  `representation_allow` float(9,2) DEFAULT NULL,
  `assignment_allow` float(9,2) DEFAULT NULL,
  `security_allow` float(9,2) DEFAULT NULL,
  `pension_allow` float(9,2) DEFAULT NULL,
  `seniority_allow` float(9,2) DEFAULT NULL,
  `general_fuel_allow` float(9,2) DEFAULT NULL,
  `electricity_allow` float(9,2) DEFAULT NULL,
  `water_allow` float(9,2) DEFAULT NULL,
  `domestic_allow` float(9,2) DEFAULT NULL,
  `family_allow` float(9,2) DEFAULT NULL,
  `furnishing_allow` float(9,2) DEFAULT NULL,
  `t_e_allow` float(9,2) DEFAULT NULL,
  `leave_allow` float(9,2) DEFAULT NULL,
  `performance_allow` float(9,2) DEFAULT NULL,
  `internet_allow` float(9,2) DEFAULT NULL,
  `pam_allow` float(9,2) DEFAULT NULL,
  `standby_allow` float(9,2) DEFAULT NULL,
  `evening_allow` float(9,2) DEFAULT NULL,
  `gazetted_allow` float(9,2) DEFAULT NULL,
  `abaya_allow` float(9,2) DEFAULT NULL,
  `relationship_allow` float(9,2) DEFAULT NULL,
  `bdu_allow` float(9,2) DEFAULT NULL,
  `cf_fuel_allow` float(9,2) DEFAULT NULL,
  `mobility_relocation_allow` float(9,2) DEFAULT NULL,
  `dsa_allow` float(9,2) DEFAULT NULL,
  `sra_allow` float(9,2) DEFAULT NULL,
  `washing_allow` float(9,2) DEFAULT NULL,
  `hajj_allow` float(9,2) DEFAULT NULL,
  `retainer_allow` float(9,2) DEFAULT NULL,
  `site_allow` float(9,2) DEFAULT NULL,
  `dearness_allow` float(9,2) DEFAULT NULL,
  `other_allow` float(9,2) DEFAULT NULL,
  `sunday_allow` float(9,2) DEFAULT NULL,
  `saturday_allow` float(9,2) DEFAULT NULL,
  `last_month_overtime_hours` float(9,2) DEFAULT NULL,
  `last_month_overtime_amount` float(9,2) DEFAULT NULL,
  `overtime_type` varchar(50) DEFAULT NULL,
  `overtime_hours` float(9,2) DEFAULT NULL,
  `overtime_amount` float(9,2) DEFAULT NULL,
  `Arrears` float(9,2) DEFAULT NULL,
  `Other_Additions` float(9,2) DEFAULT NULL,
  `other_incentive` float(9,2) DEFAULT NULL,
  `collection_incentive` float(9,2) DEFAULT NULL,
  `recovery_incentive` float(9,2) DEFAULT NULL,
  `lsf_incentive` float(9,2) DEFAULT NULL,
  `referral_incentive_for_disbursement` float(9,2) DEFAULT NULL,
  `prepaid_card_incentive` float(9,2) DEFAULT NULL,
  `kpi_incenitve` float(9,2) DEFAULT NULL,
  `inbound_incentive` float(9,2) DEFAULT NULL,
  `autos_incentive` float(9,2) DEFAULT NULL,
  `banca_scorecard_disbursement` float(9,2) DEFAULT NULL,
  `bancassurance` float(9,2) DEFAULT NULL,
  `reward` float(9,2) DEFAULT NULL,
  `agri_fuel` float(9,2) DEFAULT NULL,
  `phone_banking` float(9,2) DEFAULT NULL,
  `rrm` float(9,2) DEFAULT NULL,
  `pil` float(9,2) DEFAULT NULL,
  `btf` float(9,2) DEFAULT NULL,
  `barkat_auto_finance` float(9,2) DEFAULT NULL,
  `barkat_housing_finance` float(9,2) DEFAULT NULL,
  `mutual_fund_incentive` float(9,2) DEFAULT NULL,
  `rush_hour_campaign_winners_award` float(9,2) DEFAULT NULL,
  `turbo_charge_sales_commission` float(9,2) DEFAULT NULL,
  `cash_plus_commission` float(9,2) DEFAULT NULL,
  `credit_card_commission` float(9,2) DEFAULT NULL,
  `auto_commission` float(9,2) DEFAULT NULL,
  `uad_commission` float(9,2) DEFAULT NULL,
  `casa_commission` float(9,2) DEFAULT NULL,
  `_13th_month_Pay` float(9,2) DEFAULT NULL,
  `bonus` float(9,2) DEFAULT NULL,
  `referral_bonus` float(9,2) DEFAULT NULL,
  `statutory_bonus` float(9,2) DEFAULT NULL,
  `aip_bonus` float(9,2) DEFAULT NULL,
  `laip_bonus` float(9,2) DEFAULT NULL,
  `Inflation_Bonus` float(9,2) DEFAULT NULL,
  `Utilization_Bonus` float(9,2) DEFAULT NULL,
  `Goal_Achived_Bonus` float(9,2) DEFAULT NULL,
  `Other_Bonus_Eid_Bonus` float(9,2) DEFAULT NULL,
  `reimbursement` float(9,2) DEFAULT NULL,
  `maternity_reimbursment` float(9,2) DEFAULT NULL,
  `airticket` float(9,2) DEFAULT NULL,
  `transportation_travel_expense` float(9,2) DEFAULT NULL,
  `opd_medical_expense` float(9,2) DEFAULT NULL,
  `fuel_reimbursement` float(9,2) DEFAULT NULL,
  `ta_da` float(9,2) DEFAULT NULL,
  `mobile_bill_expense` float(9,2) DEFAULT NULL,
  `meal_expense` float(9,2) DEFAULT NULL,
  `commuting_mileage` float(9,2) DEFAULT NULL,
  `PF_Withholdings` float(9,2) DEFAULT NULL,
  `vehicle_of_service` float(9,2) DEFAULT NULL,
  `house_rent_advance` float(9,2) DEFAULT NULL,
  `leave_salary_holidays_pay` float(9,2) DEFAULT NULL,
  `loan_claim` float(9,2) DEFAULT NULL,
  `security_deposit_return` float(9,2) DEFAULT NULL,
  `extra_already_paid` float(9,2) DEFAULT NULL,
  `extra_not_paid` float(9,2) DEFAULT NULL,
  `tesidency_` varchar(50) DEFAULT NULL,
  `mobile_payment` float(9,2) DEFAULT NULL,
  `gratification` varchar(50) DEFAULT NULL,
  `income_tax_refund` float(9,2) DEFAULT NULL,
  `increment_amount` float(9,2) DEFAULT NULL,
  `gratuity` float(9,2) DEFAULT NULL,
  `end_of_service` float(9,2) DEFAULT NULL,
  `notice_pay` float(9,2) DEFAULT NULL,
  `exgratia_payment` float(9,2) DEFAULT NULL,
  `severance_pay` float(9,2) DEFAULT NULL,
  `leave_encashment` float(9,2) DEFAULT NULL,
  `out_of_payroll_mobile` varchar(50) DEFAULT NULL,
  `out_of_payroll_laip` varchar(50) DEFAULT NULL,
  `out_of_payroll_others` varchar(50) DEFAULT NULL,
  `out_of_payroll_relocation` varchar(50) DEFAULT NULL,
  `taxable_benefit_amount` float(9,2) DEFAULT NULL,
  `non_ cash_taxable_amount` float(9,2) DEFAULT NULL,
  `lwop_days` varchar(50) DEFAULT NULL,
  `lwop_deduction` float(9,2) DEFAULT NULL,
  `other_deduction_from_gross` float(9,2) DEFAULT NULL,
  `shortage_deduction` float(9,2) DEFAULT NULL,
  `income_tax` float(9,2) DEFAULT NULL,
  `l_s_t_deduction` float(9,2) DEFAULT NULL,
  `tax_adjustment` float(9,2) DEFAULT NULL,
  `advance_leave_salary_deduction` float(9,2) DEFAULT NULL,
  `recovery` float(9,2) DEFAULT NULL,
  `other_deduction` float(9,2) DEFAULT NULL,
  `gosi_deduction` float(9,2) DEFAULT NULL,
  `pension_contribution_employee` float(9,2) DEFAULT NULL,
  `medical_insurance_deduction` float(9,2) DEFAULT NULL,
  `nssf_cnss` float(9,2) DEFAULT NULL,
  `provident_fund_contribution_employee` float(9,2) DEFAULT NULL,
  `pf_arrears` float(9,2) DEFAULT NULL,
  `eobi_deduction` float(9,2) DEFAULT NULL,
  `eobi_arrears_deduction` float(9,2) DEFAULT NULL,
  `advance_salary_loan_deduction` float(9,2) DEFAULT NULL,
  `laundry_charges_deduction` float(9,2) DEFAULT NULL,
  `extra_food_deduction` float(9,2) DEFAULT NULL,
  `excess_mobile_deduction` float(9,2) DEFAULT NULL,
  `unserved_notice_period` float(9,2) DEFAULT NULL,
  `hra_adjustments` float(9,2) DEFAULT NULL,
  `espp_contribution` float(9,2) DEFAULT NULL,
  `housing_loan_deduction` float(9,2) DEFAULT NULL,
  `credit_union` float(9,2) DEFAULT NULL,
  `data_bank_deduction` float(9,2) DEFAULT NULL,
  `loan_repayment` float(9,2) DEFAULT NULL,
  `nhif` float(9,2) DEFAULT NULL,
  `coop_contribution` float(9,2) DEFAULT NULL,
  `coop_loan_repayment` float(9,2) DEFAULT NULL,
  `christmas_bonus` float(9,2) DEFAULT NULL,
  `utilities_electricity_security` float(9,2) DEFAULT NULL,
  `travel_advance_recovery` float(9,2) DEFAULT NULL,
  `education_support_deduction` float(9,2) DEFAULT NULL,
  `helb_loan` float(9,2) DEFAULT NULL,
  `kcb_loan_check_off` float(9,2) DEFAULT NULL,
  `scb_loan_check_off` float(9,2) DEFAULT NULL,
  `bbk_loan_check_off` float(9,2) DEFAULT NULL,
  `sacco_bonus_sch` float(9,2) DEFAULT NULL,
  `ngid` float(9,2) DEFAULT NULL,
  `safaricom_investment` float(9,2) DEFAULT NULL,
  `nhf` float(9,2) DEFAULT NULL,
  `sacco_deduction` float(9,2) DEFAULT NULL,
  `gli_deduction` float(9,2) DEFAULT NULL,
  `ghi_deduction` float(9,2) DEFAULT NULL,
  `security_deposit_from_employee` float(9,2) DEFAULT NULL,
  `disbursement_deduction_from_employee` float(9,2) DEFAULT NULL,
  `breakage_snatch_deduction` float(9,2) DEFAULT NULL,
  `security_deduction_from_employee` float(9,2) DEFAULT NULL,
  `id_card_deduction` float(9,2) DEFAULT NULL,
  `uniform_deduction` float(9,2) DEFAULT NULL,
  `penalty_deduction` float(9,2) DEFAULT NULL,
  `commuting_deduction` float(9,2) DEFAULT NULL,
  `cli_deduction` float(9,2) DEFAULT NULL,
  `pf_loan_ded` float(9,2) DEFAULT NULL,
  `online_charges` float(9,2) DEFAULT NULL,
  `brc_ded` float(9,2) DEFAULT NULL,
  `emergency_fund` float(9,2) DEFAULT NULL,
  `pension_contribution_employer` float(9,2) DEFAULT NULL,
  `provident_fund_contribution_employer` float(9,2) DEFAULT NULL,
  `pf_arrears_employer` float(9,2) DEFAULT NULL,
  `eobi_contribution` float(9,2) DEFAULT NULL,
  `eobi_arrears_contribution` float(9,2) DEFAULT NULL,
  `professional_fees` float(9,2) DEFAULT NULL,
  `abattement` float(9,2) DEFAULT NULL,
  `nef` float(9,2) DEFAULT NULL,
  `nsitf` float(9,2) DEFAULT NULL,
  `itf` float(9,2) DEFAULT NULL,
  `wcf` float(9,2) DEFAULT NULL,
  `sdl` float(9,2) DEFAULT NULL,
  `training_tax_apprendiship_tax_fdfp` float(9,2) DEFAULT NULL,
  `regime_general` float(9,2) DEFAULT NULL,
  `expatries` float(9,2) DEFAULT NULL,
  `retraite` float(9,2) DEFAULT NULL,
  `accident_travail` float(9,2) DEFAULT NULL,
  `prest_familiale` float(9,2) DEFAULT NULL,
  `social_security` float(9,2) DEFAULT NULL,
  `social_security_arrears` float(9,2) DEFAULT NULL,
  `education_cess` float(9,2) DEFAULT NULL,
  `education_cess_arrears` float(9,2) DEFAULT NULL,
  `gli_contritbution` float(9,2) DEFAULT NULL,
  `gli_arrears` float(9,2) DEFAULT NULL,
  `ghi_contribution` float(9,2) DEFAULT NULL,
  `ghi_arrears` float(9,2) DEFAULT NULL,
  `cli` float(9,2) DEFAULT NULL,
  `cli_arrears` float(9,2) DEFAULT NULL,
  `cti` float(9,2) DEFAULT NULL,
  `cti_arrears` float(9,2) DEFAULT NULL,
  `gratuity_claimed` float(9,2) DEFAULT NULL,
  `gratuity_claimed_arrears` float(9,2) DEFAULT NULL,
  `pension_fund_contribution` float(9,2) DEFAULT NULL,
  `laptop_security` float(9,2) DEFAULT NULL,
  `uniform_charges` float(9,2) DEFAULT NULL,
  `bank_charges_from_client` float(9,2) DEFAULT NULL,
  `cnic_verification` int DEFAULT NULL,
  `id_card_charges` float(9,2) DEFAULT NULL,
  `laptop_charges` float(9,2) DEFAULT NULL,
  `executive_search` varchar(50) DEFAULT NULL,
  `service_charges` float(9,2) DEFAULT NULL,
  `sales_tax` float(9,2) DEFAULT NULL,
  `tax_add_back_wht` float(9,2) DEFAULT NULL,
  `status` int DEFAULT NULL,
  `iteration` int DEFAULT NULL,
  `taxable_salary_component` float DEFAULT NULL,
  `taxable_variable_allowance` float DEFAULT NULL,
  `taxable_income` float(9,2) DEFAULT NULL,
  `variable_allowances` float(9,2) DEFAULT NULL,
  `total_reimbursement` float(9,2) DEFAULT NULL,
  `net_pay` float(9,2) DEFAULT NULL,
  `created_by` int DEFAULT NULL,
  `updated_by` int DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `taxable_netpay` float DEFAULT NULL,
  `gross_salary` float DEFAULT NULL,
  `base_salary` float DEFAULT NULL,
  `other_deduction_employee` float DEFAULT NULL,
  `excess_mobile_deduction_employee` float DEFAULT NULL,
  `loan_repayment_employee` float DEFAULT NULL,
  `ghi_deduction_employee` float DEFAULT NULL,
  `gli_contritbution_employee` float DEFAULT NULL,
  `non_taxable_netpay` float DEFAULT NULL,
  `payroll_cost` float DEFAULT NULL,
  `invoice_amount` float DEFAULT NULL,
  `advance_salary_loan_deduction_employee` float DEFAULT NULL,
  `lwop_new_joiner` float DEFAULT NULL,
  `ghi_contritbution` float DEFAULT NULL,
  `increment` float DEFAULT NULL,
  `actual_gross_salary` float DEFAULT NULL,
  PRIMARY KEY (`payroll_process_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- Data exporting was unselected.

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
