MOON
Server: Apache
System: Linux nserver.cafsindia.com 4.18.0-553.104.1.lve.el8.x86_64 #1 SMP Tue Feb 10 20:07:30 UTC 2026 x86_64
User: cafsindia (1002)
PHP: 8.2.30
Disabled: NONE
$ pwd: /home/cafsindia/uds.cafsinfotech.in/form_setting_query/
Upload Files
File: /home/cafsindia/uds.cafsinfotech.in/form_setting_query/form_queries_file.txt
UPDATE cw_form_setting SET input_view_type = '1',input_for = '205',prime_module_id = 'direct_leave_entry' ,field_type = '5',label_name = 'component_value',view_name = 'Component Value',short_name = 'component value',text_type = '0',date_type = '0',field_length = '0',field_decimals = '0',pick_list = 'prime_status_mode_id,status_mode_value',pick_list_type = '1',pick_list_import = '2',pick_table = 'cw_status_mode',auto_prime_id = ' ',auto_dispaly_value = ' ',field_isdefault = '1',default_value = '0',mandatory_field = '1',upd_mandatory_field = '0',unique_field = '0',pick_display_value = 'status_mode_value',field_show = '1',field_for = '1,2,3,4,5',file_type = '',upload_extension = '',upload_file_size = '0',table_show = '1',search_show = '1',transaction_type = '0',gross_check = '0',taxable_check = '0',earn_month_check = '0',earn_payroll_check = '0',ded_payroll_check = '0',benefit_check = '0',increment_check = '0',arrear_pf_check = '0',fandf_check = '0',deduction_check = '0',deduction_month_check = '0',loan_check = '0',uniform_check = '0',edit_read = '0',picklist_data = '0',duplicate_data = '0',trans_updated_by = '1',trans_updated_date = '2022-04-22 21:52:43' WHERE prime_form_id = '1366';

ALTER TABLE cw_direct_leave_entry CHANGE prime_direct_leave_entry_id prime_direct_leave_entry_id int(11) NOT NULL AUTO_INCREMENT,CHANGE mp_reason mp_reason varchar(100) NULL DEFAULT '0', CHANGE financial_setting_id financial_setting_id int(10) NULL DEFAULT '0', CHANGE contact_no contact_no varchar(100) NULL DEFAULT '', CHANGE leaving_station leaving_station varchar(100) NULL DEFAULT '0', CHANGE vacation_address vacation_address TEXT NULL, CHANGE reason reason TEXT NULL, CHANGE change_shift change_shift varchar(100) NULL DEFAULT '0', CHANGE current_shift current_shift varchar(100) NULL DEFAULT '0', CHANGE shift_date shift_date date NULL DEFAULT NULL, CHANGE total_time total_time time NULL DEFAULT NULL, CHANGE out_time out_time time NULL DEFAULT NULL, CHANGE in_time in_time time NULL DEFAULT NULL, CHANGE shift_name shift_name varchar(100) NULL DEFAULT '0', CHANGE day_type day_type varchar(100) NULL DEFAULT '0', CHANGE out_date out_date date NULL DEFAULT NULL, CHANGE in_date in_date date NULL DEFAULT NULL, CHANGE permission_type permission_type varchar(100) NULL DEFAULT '0', CHANGE permission_date permission_date date NULL DEFAULT NULL, CHANGE no_of_days no_of_days decimal(15,2) NULL DEFAULT '0', CHANGE to_date_type to_date_type varchar(100) NULL DEFAULT '0', CHANGE to_date to_date date NULL DEFAULT NULL, CHANGE from_date_type from_date_type varchar(100) NULL DEFAULT '0', CHANGE from_date from_date date NULL DEFAULT NULL, CHANGE leave_balance leave_balance decimal(15,2) NULL DEFAULT '0', CHANGE leave_type leave_type varchar(100) NULL DEFAULT '0', CHANGE request_type request_type varchar(100) NULL DEFAULT '0', CHANGE request_date request_date date NULL DEFAULT NULL, CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL, CHANGE component_value component_value varchar(100) NULL DEFAULT '0', CHANGE employee_code employee_code varchar(100) NULL DEFAULT '0';

UPDATE cw_form_setting SET input_view_type = '1',input_for = '205',prime_module_id = 'direct_leave_entry' ,field_type = '5',label_name = 'employee_code',view_name = 'Employee Code',short_name = 'employee code',text_type = '0',date_type = '0',field_length = '0',field_decimals = '0',pick_list = 'employee_code,emp_name',pick_list_type = '1',pick_list_import = '2',pick_table = 'cw_employees',auto_prime_id = ' ',auto_dispaly_value = ' ',field_isdefault = '1',default_value = '0',mandatory_field = '1',upd_mandatory_field = '0',unique_field = '0',pick_display_value = 'employee_code,emp_name',field_show = '1',field_for = '1,2,3,4,5',file_type = '',upload_extension = '',upload_file_size = '0',table_show = '1',search_show = '1',transaction_type = '0',gross_check = '0',taxable_check = '0',earn_month_check = '0',earn_payroll_check = '0',ded_payroll_check = '0',benefit_check = '0',increment_check = '0',arrear_pf_check = '0',fandf_check = '0',deduction_check = '0',deduction_month_check = '0',loan_check = '0',uniform_check = '0',edit_read = '0',picklist_data = '0',duplicate_data = '0',trans_updated_by = '1',trans_updated_date = '2022-04-22 21:52:46' WHERE prime_form_id = '1365';

ALTER TABLE cw_direct_leave_entry CHANGE prime_direct_leave_entry_id prime_direct_leave_entry_id int(11) NOT NULL AUTO_INCREMENT,CHANGE mp_reason mp_reason varchar(100) NULL DEFAULT '0', CHANGE financial_setting_id financial_setting_id int(10) NULL DEFAULT '0', CHANGE contact_no contact_no varchar(100) NULL DEFAULT '', CHANGE leaving_station leaving_station varchar(100) NULL DEFAULT '0', CHANGE vacation_address vacation_address TEXT NULL, CHANGE reason reason TEXT NULL, CHANGE change_shift change_shift varchar(100) NULL DEFAULT '0', CHANGE current_shift current_shift varchar(100) NULL DEFAULT '0', CHANGE shift_date shift_date date NULL DEFAULT NULL, CHANGE total_time total_time time NULL DEFAULT NULL, CHANGE out_time out_time time NULL DEFAULT NULL, CHANGE in_time in_time time NULL DEFAULT NULL, CHANGE shift_name shift_name varchar(100) NULL DEFAULT '0', CHANGE day_type day_type varchar(100) NULL DEFAULT '0', CHANGE out_date out_date date NULL DEFAULT NULL, CHANGE in_date in_date date NULL DEFAULT NULL, CHANGE permission_type permission_type varchar(100) NULL DEFAULT '0', CHANGE permission_date permission_date date NULL DEFAULT NULL, CHANGE no_of_days no_of_days decimal(15,2) NULL DEFAULT '0', CHANGE to_date_type to_date_type varchar(100) NULL DEFAULT '0', CHANGE to_date to_date date NULL DEFAULT NULL, CHANGE from_date_type from_date_type varchar(100) NULL DEFAULT '0', CHANGE from_date from_date date NULL DEFAULT NULL, CHANGE leave_balance leave_balance decimal(15,2) NULL DEFAULT '0', CHANGE leave_type leave_type varchar(100) NULL DEFAULT '0', CHANGE request_type request_type varchar(100) NULL DEFAULT '0', CHANGE request_date request_date date NULL DEFAULT NULL, CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL, CHANGE component_value component_value varchar(100) NULL DEFAULT '0', CHANGE employee_code employee_code varchar(100) NULL DEFAULT '0';

UPDATE  cw_role_base_condition SET role_module_id = "direct_leave_entry",role_condition_for = "1,2,4,6,7,8",user_condition_type = "readonly",input_columns = "component_value,date_of_joining,request_date",trans_updated_by = "1",trans_updated_date = "2022-04-22 09:52:53" where prime_role_base_condition_id = "2";

UPDATE cw_form_setting SET input_view_type = '2',input_for = '1',prime_module_id = 'employees' ,field_type = '5',label_name = 'personal_code',view_name = 'Personal Area',short_name = 'Personal Area',text_type = '0',date_type = '0',field_length = '0',field_decimals = '0',pick_list = 'personal_code,personal_name',pick_list_type = '1',pick_list_import = '2',pick_table = 'cw_sap_personal_area',auto_prime_id = ' ',auto_dispaly_value = ' ',field_isdefault = '1',default_value = '0',mandatory_field = '1',upd_mandatory_field = '0',unique_field = '0',pick_display_value = 'personal_name',field_show = '1',field_for = '1,2,3,4,5',file_type = '',upload_extension = '',upload_file_size = '0',table_show = '1',search_show = '1',transaction_type = '4',gross_check = '0',taxable_check = '0',earn_month_check = '0',earn_payroll_check = '0',ded_payroll_check = '0',benefit_check = '0',increment_check = '0',arrear_pf_check = '0',fandf_check = '0',deduction_check = '0',deduction_month_check = '0',loan_check = '0',uniform_check = '0',edit_read = '0',picklist_data = '0',duplicate_data = '0',trans_updated_by = '1',trans_updated_date = '2022-04-22 21:53:28' WHERE prime_form_id = '1789';

ALTER TABLE cw_employees CHANGE prime_employees_id prime_employees_id int(11) NOT NULL AUTO_INCREMENT,CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0', CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0', CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0', CHANGE gross gross decimal(15,2) NULL DEFAULT '0', CHANGE da da decimal(15,2) NULL DEFAULT '0', CHANGE hra hra decimal(15,2) NULL DEFAULT '0', CHANGE basic basic decimal(15,2) NULL DEFAULT '0', CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0', CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0', CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0', CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0', CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0', CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0', CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0', CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0', CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0', CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0', CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0', CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0', CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0', CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0', CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0', CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0', CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0', CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0', CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0', CHANGE wt10 wt10 varchar(10) NULL DEFAULT '', CHANGE sap_code_status sap_code_status int(10) NULL DEFAULT '0', CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0', CHANGE payroll payroll varchar(100) NULL DEFAULT '1', CHANGE sap_remarks sap_remarks varchar(50) NULL DEFAULT '', CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0', CHANGE wt9 wt9 varchar(10) NULL DEFAULT '', CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0', CHANGE user_right user_right varchar(100) NULL DEFAULT '3', CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0', CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0', CHANGE sap_status sap_status varchar(100) NULL DEFAULT '2', CHANGE role role varchar(100) NULL DEFAULT '0', CHANGE wt8 wt8 varchar(10) NULL DEFAULT '', CHANGE department department varchar(100) NULL DEFAULT '0', CHANGE process_month process_month varchar(100) NULL DEFAULT '0', CHANGE epf epf decimal(15,2) NULL DEFAULT '0', CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0', CHANGE branch branch varchar(100) NULL DEFAULT '0', CHANGE branch_hr branch_hr varchar(100) NULL DEFAULT '0', CHANGE emp_name emp_name varchar(100) NULL DEFAULT '', CHANGE income_tax_type income_tax_type varchar(100) NULL DEFAULT '0', CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0', CHANGE wt7 wt7 varchar(10) NULL DEFAULT '', CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0', CHANGE hr_remark hr_remark TEXT NULL, CHANGE emp_location emp_location varchar(25) NULL DEFAULT '', CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0', CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0', CHANGE hr_status hr_status varchar(100) NULL DEFAULT '1', CHANGE emp_street_no emp_street_no varchar(30) NULL DEFAULT '', CHANGE wt6 wt6 varchar(10) NULL DEFAULT '', CHANGE uan_number uan_number varchar(13) NULL DEFAULT '', CHANGE pan_number pan_number varchar(10) NULL DEFAULT '', CHANGE manager_remark manager_remark TEXT NULL, CHANGE emp_pincode emp_pincode varchar(10) NULL DEFAULT '', CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0', CHANGE pf_account_number pf_account_number varchar(100) NULL DEFAULT '', CHANGE manager_reason manager_reason varchar(100) NULL DEFAULT '0', CHANGE wt5 wt5 varchar(10) NULL DEFAULT '', CHANGE emp_address_code emp_address_code varchar(100) NULL DEFAULT '0', CHANGE tds tds decimal(15,2) NULL DEFAULT '0', CHANGE tl_report tl_report varchar(100) NULL DEFAULT '0', CHANGE marital_code marital_code varchar(100) NULL DEFAULT '0', CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0', CHANGE second_level_approval second_level_approval varchar(100) NULL DEFAULT '0', CHANGE country_code country_code varchar(100) NULL DEFAULT '0', CHANGE wt4 wt4 varchar(10) NULL DEFAULT '', CHANGE esi_number esi_number varchar(100) NULL DEFAULT '', CHANGE first_level_approval first_level_approval varchar(100) NULL DEFAULT '0', CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0', CHANGE emp_age emp_age int(10) NULL DEFAULT '0', CHANGE approve_type approve_type varchar(100) NULL DEFAULT '1', CHANGE increment_third_level increment_third_level varchar(100) NULL DEFAULT '0', CHANGE wt3 wt3 varchar(10) NULL DEFAULT '', CHANGE date_of_birth date_of_birth date NULL DEFAULT NULL, CHANGE esi_location esi_location varchar(100) NULL DEFAULT '0', CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0', CHANGE gender gender varchar(100) NULL DEFAULT '0', CHANGE increment_second_level increment_second_level varchar(100) NULL DEFAULT '0', CHANGE emp_firstname emp_firstname varchar(25) NULL DEFAULT '', CHANGE wt2 wt2 varchar(10) NULL DEFAULT '', CHANGE stop_pay_remarks stop_pay_remarks TEXT NULL, CHANGE increment_first_level increment_first_level varchar(100) NULL DEFAULT '0', CHANGE increment_approve_type increment_approve_type varchar(100) NULL DEFAULT '1', CHANGE title_code title_code varchar(100) NULL DEFAULT '0', CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0', CHANGE bank_account_number bank_account_number varchar(100) NULL DEFAULT '', CHANGE stop_pay_status stop_pay_status varchar(10) NULL DEFAULT '0', CHANGE ptax_code ptax_code varchar(100) NULL DEFAULT '0', CHANGE wt1 wt1 varchar(10) NULL DEFAULT '', CHANGE hold_reason hold_reason varchar(40) NULL DEFAULT '', CHANGE personal_email_id personal_email_id varchar(150) NULL DEFAULT NULL, CHANGE bank_branch bank_branch varchar(200) NULL DEFAULT '', CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0', CHANGE manager_status manager_status varchar(100) NULL DEFAULT '1', CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0', CHANGE mode_code mode_code varchar(100) NULL DEFAULT '0', CHANGE company_email_id company_email_id varchar(150) NULL DEFAULT NULL, CHANGE separation_reason separation_reason TEXT NULL, CHANGE manager_report manager_report varchar(100) NULL DEFAULT '0', CHANGE sub_group_code sub_group_code varchar(100) NULL DEFAULT '0', CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0', CHANGE pay_code pay_code varchar(100) NULL DEFAULT '0', CHANGE emp_percentage emp_percentage decimal(15,2) NULL DEFAULT '0', CHANGE action_reason action_reason varchar(100) NULL DEFAULT '0', CHANGE info_passed_on info_passed_on date NULL DEFAULT NULL, CHANGE additional_mobile_number additional_mobile_number varchar(10) NULL DEFAULT NULL, CHANGE last_working_date last_working_date date NULL DEFAULT NULL, CHANGE emp_group_code emp_group_code varchar(100) NULL DEFAULT '0', CHANGE sub_group_name sub_group_name varchar(100) NULL DEFAULT '0', CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0', CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0', CHANGE emp_cost_center_code emp_cost_center_code varchar(100) NULL DEFAULT '0', CHANGE emp_uan emp_uan varchar(20) NULL DEFAULT '', CHANGE emp_aadhar_name emp_aadhar_name varchar(30) NULL DEFAULT '', CHANGE wci_code wci_code varchar(100) NULL DEFAULT '0', CHANGE action_code action_code varchar(100) NULL DEFAULT '0', CHANGE family_gender_code family_gender_code varchar(100) NULL DEFAULT '0', CHANGE emp_esi_location emp_esi_location varchar(40) NULL DEFAULT '', CHANGE ifsc_code ifsc_code varchar(100) NULL DEFAULT '0', CHANGE info_passed_by info_passed_by varchar(40) NULL DEFAULT '', CHANGE mobile_number mobile_number varchar(10) NULL DEFAULT NULL, CHANGE metro metro varchar(100) NULL DEFAULT '0', CHANGE resignation_letter_upload resignation_letter_upload TEXT NULL, CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0', CHANGE id_proof id_proof TEXT NULL, CHANGE esi esi decimal(15,2) NULL DEFAULT '0', CHANGE emp_company_code emp_company_code varchar(100) NULL DEFAULT '0', CHANGE emp_pf_no emp_pf_no varchar(20) NULL DEFAULT '', CHANGE emp_esi_no emp_esi_no varchar(20) NULL DEFAULT '', CHANGE challange_code challange_code varchar(100) NULL DEFAULT '0', CHANGE activity_no activity_no varchar(100) NULL DEFAULT '0', CHANGE pf_celling pf_celling varchar(50) NULL DEFAULT '', CHANGE family_first_name family_first_name varchar(25) NULL DEFAULT '', CHANGE bank_name bank_name varchar(18) NULL DEFAULT '', CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL, CHANGE hold_pay_code hold_pay_code varchar(100) NULL DEFAULT '0', CHANGE aadhar_card_no aadhar_card_no varchar(20) NULL DEFAULT '', CHANGE separation_type separation_type varchar(100) NULL DEFAULT '0', CHANGE personal_code personal_code varchar(100) NULL DEFAULT '0', CHANGE employee_code employee_code varchar(10) NULL DEFAULT '', CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0', CHANGE pf pf decimal(15,2) NULL DEFAULT '0', CHANGE emp_cost_code emp_cost_code varchar(100) NULL DEFAULT '0', CHANGE emp_pf_code emp_pf_code varchar(100) NULL DEFAULT '0', CHANGE statutory_code statutory_code varchar(100) NULL DEFAULT '0001', CHANGE network_id network_id varchar(100) NULL DEFAULT '0', CHANGE sap_client_name sap_client_name varchar(100) NULL DEFAULT '0', CHANGE bank_key bank_key varchar(100) NULL DEFAULT '0', CHANGE family_address_code family_address_code varchar(100) NULL DEFAULT '0', CHANGE designation designation varchar(100) NULL DEFAULT '0', CHANGE com_address_code com_address_code varchar(100) NULL DEFAULT '0', CHANGE aadhar_address_code aadhar_address_code varchar(100) NULL DEFAULT '0', CHANGE stop_pay_code stop_pay_code varchar(100) NULL DEFAULT '0', CHANGE blood_group blood_group varchar(100) NULL DEFAULT '0', CHANGE professional_tax_location professional_tax_location varchar(100) NULL DEFAULT '0', CHANGE resignation_date resignation_date date NULL DEFAULT NULL, CHANGE profile_picture profile_picture TEXT NULL;

UPDATE cw_form_setting SET input_view_type = '2',input_for = '1',prime_module_id = 'employees' ,field_type = '5',label_name = 'designation',view_name = 'Position',short_name = 'Position',text_type = '0',date_type = '0',field_length = '0',field_decimals = '0',pick_list = 'position_code,position_name',pick_list_type = '1',pick_list_import = '2',pick_table = 'cw_sap_position',auto_prime_id = ' ',auto_dispaly_value = ' ',field_isdefault = '1',default_value = '0',mandatory_field = '0',upd_mandatory_field = '0',unique_field = '0',pick_display_value = 'position_name',field_show = '1',field_for = '1,2,3,4,5',file_type = '',upload_extension = '',upload_file_size = '500',table_show = '0',search_show = '0',transaction_type = '1',gross_check = '0',taxable_check = '0',earn_month_check = '0',earn_payroll_check = '1',ded_payroll_check = '0',benefit_check = '0',increment_check = '0',arrear_pf_check = '0',fandf_check = '0',deduction_check = '0',deduction_month_check = '0',loan_check = '0',uniform_check = '0',edit_read = '0',picklist_data = '0',duplicate_data = '0',trans_updated_by = '1',trans_updated_date = '2022-04-22 21:54:29' WHERE prime_form_id = '68';

ALTER TABLE cw_employees CHANGE prime_employees_id prime_employees_id int(11) NOT NULL AUTO_INCREMENT,CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0', CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0', CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0', CHANGE gross gross decimal(15,2) NULL DEFAULT '0', CHANGE da da decimal(15,2) NULL DEFAULT '0', CHANGE hra hra decimal(15,2) NULL DEFAULT '0', CHANGE basic basic decimal(15,2) NULL DEFAULT '0', CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0', CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0', CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0', CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0', CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0', CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0', CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0', CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0', CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0', CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0', CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0', CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0', CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0', CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0', CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0', CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0', CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0', CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0', CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0', CHANGE wt10 wt10 varchar(10) NULL DEFAULT '', CHANGE sap_code_status sap_code_status int(10) NULL DEFAULT '0', CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0', CHANGE payroll payroll varchar(100) NULL DEFAULT '1', CHANGE sap_remarks sap_remarks varchar(50) NULL DEFAULT '', CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0', CHANGE wt9 wt9 varchar(10) NULL DEFAULT '', CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0', CHANGE user_right user_right varchar(100) NULL DEFAULT '3', CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0', CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0', CHANGE sap_status sap_status varchar(100) NULL DEFAULT '2', CHANGE role role varchar(100) NULL DEFAULT '0', CHANGE wt8 wt8 varchar(10) NULL DEFAULT '', CHANGE department department varchar(100) NULL DEFAULT '0', CHANGE process_month process_month varchar(100) NULL DEFAULT '0', CHANGE epf epf decimal(15,2) NULL DEFAULT '0', CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0', CHANGE branch branch varchar(100) NULL DEFAULT '0', CHANGE branch_hr branch_hr varchar(100) NULL DEFAULT '0', CHANGE emp_name emp_name varchar(100) NULL DEFAULT '', CHANGE income_tax_type income_tax_type varchar(100) NULL DEFAULT '0', CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0', CHANGE wt7 wt7 varchar(10) NULL DEFAULT '', CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0', CHANGE hr_remark hr_remark TEXT NULL, CHANGE emp_location emp_location varchar(25) NULL DEFAULT '', CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0', CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0', CHANGE hr_status hr_status varchar(100) NULL DEFAULT '1', CHANGE emp_street_no emp_street_no varchar(30) NULL DEFAULT '', CHANGE wt6 wt6 varchar(10) NULL DEFAULT '', CHANGE uan_number uan_number varchar(13) NULL DEFAULT '', CHANGE pan_number pan_number varchar(10) NULL DEFAULT '', CHANGE manager_remark manager_remark TEXT NULL, CHANGE emp_pincode emp_pincode varchar(10) NULL DEFAULT '', CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0', CHANGE pf_account_number pf_account_number varchar(100) NULL DEFAULT '', CHANGE manager_reason manager_reason varchar(100) NULL DEFAULT '0', CHANGE wt5 wt5 varchar(10) NULL DEFAULT '', CHANGE emp_address_code emp_address_code varchar(100) NULL DEFAULT '0', CHANGE tds tds decimal(15,2) NULL DEFAULT '0', CHANGE tl_report tl_report varchar(100) NULL DEFAULT '0', CHANGE marital_code marital_code varchar(100) NULL DEFAULT '0', CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0', CHANGE second_level_approval second_level_approval varchar(100) NULL DEFAULT '0', CHANGE country_code country_code varchar(100) NULL DEFAULT '0', CHANGE wt4 wt4 varchar(10) NULL DEFAULT '', CHANGE esi_number esi_number varchar(100) NULL DEFAULT '', CHANGE first_level_approval first_level_approval varchar(100) NULL DEFAULT '0', CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0', CHANGE emp_age emp_age int(10) NULL DEFAULT '0', CHANGE approve_type approve_type varchar(100) NULL DEFAULT '1', CHANGE increment_third_level increment_third_level varchar(100) NULL DEFAULT '0', CHANGE wt3 wt3 varchar(10) NULL DEFAULT '', CHANGE date_of_birth date_of_birth date NULL DEFAULT NULL, CHANGE esi_location esi_location varchar(100) NULL DEFAULT '0', CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0', CHANGE gender gender varchar(100) NULL DEFAULT '0', CHANGE increment_second_level increment_second_level varchar(100) NULL DEFAULT '0', CHANGE emp_firstname emp_firstname varchar(25) NULL DEFAULT '', CHANGE wt2 wt2 varchar(10) NULL DEFAULT '', CHANGE stop_pay_remarks stop_pay_remarks TEXT NULL, CHANGE increment_first_level increment_first_level varchar(100) NULL DEFAULT '0', CHANGE increment_approve_type increment_approve_type varchar(100) NULL DEFAULT '1', CHANGE title_code title_code varchar(100) NULL DEFAULT '0', CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0', CHANGE bank_account_number bank_account_number varchar(100) NULL DEFAULT '', CHANGE stop_pay_status stop_pay_status varchar(10) NULL DEFAULT '0', CHANGE ptax_code ptax_code varchar(100) NULL DEFAULT '0', CHANGE wt1 wt1 varchar(10) NULL DEFAULT '', CHANGE hold_reason hold_reason varchar(40) NULL DEFAULT '', CHANGE personal_email_id personal_email_id varchar(150) NULL DEFAULT NULL, CHANGE bank_branch bank_branch varchar(200) NULL DEFAULT '', CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0', CHANGE manager_status manager_status varchar(100) NULL DEFAULT '1', CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0', CHANGE mode_code mode_code varchar(100) NULL DEFAULT '0', CHANGE company_email_id company_email_id varchar(150) NULL DEFAULT NULL, CHANGE separation_reason separation_reason TEXT NULL, CHANGE manager_report manager_report varchar(100) NULL DEFAULT '0', CHANGE sub_group_code sub_group_code varchar(100) NULL DEFAULT '0', CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0', CHANGE pay_code pay_code varchar(100) NULL DEFAULT '0', CHANGE emp_percentage emp_percentage decimal(15,2) NULL DEFAULT '0', CHANGE action_reason action_reason varchar(100) NULL DEFAULT '0', CHANGE info_passed_on info_passed_on date NULL DEFAULT NULL, CHANGE additional_mobile_number additional_mobile_number varchar(10) NULL DEFAULT NULL, CHANGE last_working_date last_working_date date NULL DEFAULT NULL, CHANGE emp_group_code emp_group_code varchar(100) NULL DEFAULT '0', CHANGE sub_group_name sub_group_name varchar(100) NULL DEFAULT '0', CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0', CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0', CHANGE emp_cost_center_code emp_cost_center_code varchar(100) NULL DEFAULT '0', CHANGE emp_uan emp_uan varchar(20) NULL DEFAULT '', CHANGE emp_aadhar_name emp_aadhar_name varchar(30) NULL DEFAULT '', CHANGE wci_code wci_code varchar(100) NULL DEFAULT '0', CHANGE action_code action_code varchar(100) NULL DEFAULT '0', CHANGE family_gender_code family_gender_code varchar(100) NULL DEFAULT '0', CHANGE emp_esi_location emp_esi_location varchar(40) NULL DEFAULT '', CHANGE ifsc_code ifsc_code varchar(100) NULL DEFAULT '0', CHANGE info_passed_by info_passed_by varchar(40) NULL DEFAULT '', CHANGE mobile_number mobile_number varchar(10) NULL DEFAULT NULL, CHANGE metro metro varchar(100) NULL DEFAULT '0', CHANGE resignation_letter_upload resignation_letter_upload TEXT NULL, CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0', CHANGE id_proof id_proof TEXT NULL, CHANGE esi esi decimal(15,2) NULL DEFAULT '0', CHANGE emp_company_code emp_company_code varchar(100) NULL DEFAULT '0', CHANGE emp_pf_no emp_pf_no varchar(20) NULL DEFAULT '', CHANGE emp_esi_no emp_esi_no varchar(20) NULL DEFAULT '', CHANGE challange_code challange_code varchar(100) NULL DEFAULT '0', CHANGE activity_no activity_no varchar(100) NULL DEFAULT '0', CHANGE pf_celling pf_celling varchar(50) NULL DEFAULT '', CHANGE family_first_name family_first_name varchar(25) NULL DEFAULT '', CHANGE bank_name bank_name varchar(18) NULL DEFAULT '', CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL, CHANGE hold_pay_code hold_pay_code varchar(100) NULL DEFAULT '0', CHANGE aadhar_card_no aadhar_card_no varchar(20) NULL DEFAULT '', CHANGE separation_type separation_type varchar(100) NULL DEFAULT '0', CHANGE personal_code personal_code varchar(100) NULL DEFAULT '0', CHANGE employee_code employee_code varchar(10) NULL DEFAULT '', CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0', CHANGE pf pf decimal(15,2) NULL DEFAULT '0', CHANGE emp_cost_code emp_cost_code varchar(100) NULL DEFAULT '0', CHANGE emp_pf_code emp_pf_code varchar(100) NULL DEFAULT '0', CHANGE statutory_code statutory_code varchar(100) NULL DEFAULT '0001', CHANGE network_id network_id varchar(100) NULL DEFAULT '0', CHANGE sap_client_name sap_client_name varchar(100) NULL DEFAULT '0', CHANGE bank_key bank_key varchar(100) NULL DEFAULT '0', CHANGE family_address_code family_address_code varchar(100) NULL DEFAULT '0', CHANGE designation designation varchar(100) NULL DEFAULT '0', CHANGE com_address_code com_address_code varchar(100) NULL DEFAULT '0', CHANGE aadhar_address_code aadhar_address_code varchar(100) NULL DEFAULT '0', CHANGE stop_pay_code stop_pay_code varchar(100) NULL DEFAULT '0', CHANGE blood_group blood_group varchar(100) NULL DEFAULT '0', CHANGE professional_tax_location professional_tax_location varchar(100) NULL DEFAULT '0', CHANGE resignation_date resignation_date date NULL DEFAULT NULL, CHANGE profile_picture profile_picture TEXT NULL;

UPDATE cw_form_setting SET input_view_type = '2',input_for = '1',prime_module_id = 'employees' ,field_type = '5',label_name = 'designation',view_name = 'Position',short_name = 'Position',text_type = '0',date_type = '0',field_length = '0',field_decimals = '0',pick_list = 'position_code,position_name',pick_list_type = '1',pick_list_import = '2',pick_table = 'cw_sap_position',auto_prime_id = ' ',auto_dispaly_value = ' ',field_isdefault = '1',default_value = '0',mandatory_field = '0',upd_mandatory_field = '0',unique_field = '0',pick_display_value = 'position_name',field_show = '1',field_for = '1,2,3,4,5',file_type = '',upload_extension = '',upload_file_size = '500',table_show = '0',search_show = '0',transaction_type = '1',gross_check = '0',taxable_check = '0',earn_month_check = '0',earn_payroll_check = '1',ded_payroll_check = '0',benefit_check = '0',increment_check = '0',arrear_pf_check = '0',fandf_check = '0',deduction_check = '0',deduction_month_check = '0',loan_check = '0',uniform_check = '0',edit_read = '0',picklist_data = '0',duplicate_data = '0',trans_updated_by = '1',trans_updated_date = '2022-04-22 21:55:25' WHERE prime_form_id = '68';

ALTER TABLE cw_employees CHANGE prime_employees_id prime_employees_id int(11) NOT NULL AUTO_INCREMENT,CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0', CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0', CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0', CHANGE gross gross decimal(15,2) NULL DEFAULT '0', CHANGE da da decimal(15,2) NULL DEFAULT '0', CHANGE hra hra decimal(15,2) NULL DEFAULT '0', CHANGE basic basic decimal(15,2) NULL DEFAULT '0', CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0', CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0', CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0', CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0', CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0', CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0', CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0', CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0', CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0', CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0', CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0', CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0', CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0', CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0', CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0', CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0', CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0', CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0', CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0', CHANGE wt10 wt10 varchar(10) NULL DEFAULT '', CHANGE sap_code_status sap_code_status int(10) NULL DEFAULT '0', CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0', CHANGE payroll payroll varchar(100) NULL DEFAULT '1', CHANGE sap_remarks sap_remarks varchar(50) NULL DEFAULT '', CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0', CHANGE wt9 wt9 varchar(10) NULL DEFAULT '', CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0', CHANGE user_right user_right varchar(100) NULL DEFAULT '3', CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0', CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0', CHANGE sap_status sap_status varchar(100) NULL DEFAULT '2', CHANGE role role varchar(100) NULL DEFAULT '0', CHANGE wt8 wt8 varchar(10) NULL DEFAULT '', CHANGE department department varchar(100) NULL DEFAULT '0', CHANGE process_month process_month varchar(100) NULL DEFAULT '0', CHANGE epf epf decimal(15,2) NULL DEFAULT '0', CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0', CHANGE branch branch varchar(100) NULL DEFAULT '0', CHANGE branch_hr branch_hr varchar(100) NULL DEFAULT '0', CHANGE emp_name emp_name varchar(100) NULL DEFAULT '', CHANGE income_tax_type income_tax_type varchar(100) NULL DEFAULT '0', CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0', CHANGE wt7 wt7 varchar(10) NULL DEFAULT '', CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0', CHANGE hr_remark hr_remark TEXT NULL, CHANGE emp_location emp_location varchar(25) NULL DEFAULT '', CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0', CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0', CHANGE hr_status hr_status varchar(100) NULL DEFAULT '1', CHANGE emp_street_no emp_street_no varchar(30) NULL DEFAULT '', CHANGE wt6 wt6 varchar(10) NULL DEFAULT '', CHANGE uan_number uan_number varchar(13) NULL DEFAULT '', CHANGE pan_number pan_number varchar(10) NULL DEFAULT '', CHANGE manager_remark manager_remark TEXT NULL, CHANGE emp_pincode emp_pincode varchar(10) NULL DEFAULT '', CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0', CHANGE pf_account_number pf_account_number varchar(100) NULL DEFAULT '', CHANGE manager_reason manager_reason varchar(100) NULL DEFAULT '0', CHANGE wt5 wt5 varchar(10) NULL DEFAULT '', CHANGE emp_address_code emp_address_code varchar(100) NULL DEFAULT '0', CHANGE tds tds decimal(15,2) NULL DEFAULT '0', CHANGE tl_report tl_report varchar(100) NULL DEFAULT '0', CHANGE marital_code marital_code varchar(100) NULL DEFAULT '0', CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0', CHANGE second_level_approval second_level_approval varchar(100) NULL DEFAULT '0', CHANGE country_code country_code varchar(100) NULL DEFAULT '0', CHANGE wt4 wt4 varchar(10) NULL DEFAULT '', CHANGE esi_number esi_number varchar(100) NULL DEFAULT '', CHANGE first_level_approval first_level_approval varchar(100) NULL DEFAULT '0', CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0', CHANGE emp_age emp_age int(10) NULL DEFAULT '0', CHANGE approve_type approve_type varchar(100) NULL DEFAULT '1', CHANGE increment_third_level increment_third_level varchar(100) NULL DEFAULT '0', CHANGE wt3 wt3 varchar(10) NULL DEFAULT '', CHANGE date_of_birth date_of_birth date NULL DEFAULT NULL, CHANGE esi_location esi_location varchar(100) NULL DEFAULT '0', CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0', CHANGE gender gender varchar(100) NULL DEFAULT '0', CHANGE increment_second_level increment_second_level varchar(100) NULL DEFAULT '0', CHANGE emp_firstname emp_firstname varchar(25) NULL DEFAULT '', CHANGE wt2 wt2 varchar(10) NULL DEFAULT '', CHANGE stop_pay_remarks stop_pay_remarks TEXT NULL, CHANGE increment_first_level increment_first_level varchar(100) NULL DEFAULT '0', CHANGE increment_approve_type increment_approve_type varchar(100) NULL DEFAULT '1', CHANGE title_code title_code varchar(100) NULL DEFAULT '0', CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0', CHANGE bank_account_number bank_account_number varchar(100) NULL DEFAULT '', CHANGE stop_pay_status stop_pay_status varchar(10) NULL DEFAULT '0', CHANGE ptax_code ptax_code varchar(100) NULL DEFAULT '0', CHANGE wt1 wt1 varchar(10) NULL DEFAULT '', CHANGE hold_reason hold_reason varchar(40) NULL DEFAULT '', CHANGE personal_email_id personal_email_id varchar(150) NULL DEFAULT NULL, CHANGE bank_branch bank_branch varchar(200) NULL DEFAULT '', CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0', CHANGE manager_status manager_status varchar(100) NULL DEFAULT '1', CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0', CHANGE mode_code mode_code varchar(100) NULL DEFAULT '0', CHANGE company_email_id company_email_id varchar(150) NULL DEFAULT NULL, CHANGE separation_reason separation_reason TEXT NULL, CHANGE manager_report manager_report varchar(100) NULL DEFAULT '0', CHANGE sub_group_code sub_group_code varchar(100) NULL DEFAULT '0', CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0', CHANGE pay_code pay_code varchar(100) NULL DEFAULT '0', CHANGE emp_percentage emp_percentage decimal(15,2) NULL DEFAULT '0', CHANGE action_reason action_reason varchar(100) NULL DEFAULT '0', CHANGE info_passed_on info_passed_on date NULL DEFAULT NULL, CHANGE additional_mobile_number additional_mobile_number varchar(10) NULL DEFAULT NULL, CHANGE last_working_date last_working_date date NULL DEFAULT NULL, CHANGE emp_group_code emp_group_code varchar(100) NULL DEFAULT '0', CHANGE sub_group_name sub_group_name varchar(100) NULL DEFAULT '0', CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0', CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0', CHANGE emp_cost_center_code emp_cost_center_code varchar(100) NULL DEFAULT '0', CHANGE emp_uan emp_uan varchar(20) NULL DEFAULT '', CHANGE emp_aadhar_name emp_aadhar_name varchar(30) NULL DEFAULT '', CHANGE wci_code wci_code varchar(100) NULL DEFAULT '0', CHANGE action_code action_code varchar(100) NULL DEFAULT '0', CHANGE family_gender_code family_gender_code varchar(100) NULL DEFAULT '0', CHANGE emp_esi_location emp_esi_location varchar(40) NULL DEFAULT '', CHANGE ifsc_code ifsc_code varchar(100) NULL DEFAULT '0', CHANGE info_passed_by info_passed_by varchar(40) NULL DEFAULT '', CHANGE mobile_number mobile_number varchar(10) NULL DEFAULT NULL, CHANGE metro metro varchar(100) NULL DEFAULT '0', CHANGE resignation_letter_upload resignation_letter_upload TEXT NULL, CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0', CHANGE id_proof id_proof TEXT NULL, CHANGE esi esi decimal(15,2) NULL DEFAULT '0', CHANGE emp_company_code emp_company_code varchar(100) NULL DEFAULT '0', CHANGE emp_pf_no emp_pf_no varchar(20) NULL DEFAULT '', CHANGE emp_esi_no emp_esi_no varchar(20) NULL DEFAULT '', CHANGE challange_code challange_code varchar(100) NULL DEFAULT '0', CHANGE activity_no activity_no varchar(100) NULL DEFAULT '0', CHANGE pf_celling pf_celling varchar(50) NULL DEFAULT '', CHANGE family_first_name family_first_name varchar(25) NULL DEFAULT '', CHANGE bank_name bank_name varchar(18) NULL DEFAULT '', CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL, CHANGE hold_pay_code hold_pay_code varchar(100) NULL DEFAULT '0', CHANGE aadhar_card_no aadhar_card_no varchar(20) NULL DEFAULT '', CHANGE separation_type separation_type varchar(100) NULL DEFAULT '0', CHANGE personal_code personal_code varchar(100) NULL DEFAULT '0', CHANGE employee_code employee_code varchar(10) NULL DEFAULT '', CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0', CHANGE pf pf decimal(15,2) NULL DEFAULT '0', CHANGE emp_cost_code emp_cost_code varchar(100) NULL DEFAULT '0', CHANGE emp_pf_code emp_pf_code varchar(100) NULL DEFAULT '0', CHANGE statutory_code statutory_code varchar(100) NULL DEFAULT '0001', CHANGE network_id network_id varchar(100) NULL DEFAULT '0', CHANGE sap_client_name sap_client_name varchar(100) NULL DEFAULT '0', CHANGE bank_key bank_key varchar(100) NULL DEFAULT '0', CHANGE family_address_code family_address_code varchar(100) NULL DEFAULT '0', CHANGE designation designation varchar(100) NULL DEFAULT '0', CHANGE com_address_code com_address_code varchar(100) NULL DEFAULT '0', CHANGE aadhar_address_code aadhar_address_code varchar(100) NULL DEFAULT '0', CHANGE stop_pay_code stop_pay_code varchar(100) NULL DEFAULT '0', CHANGE blood_group blood_group varchar(100) NULL DEFAULT '0', CHANGE professional_tax_location professional_tax_location varchar(100) NULL DEFAULT '0', CHANGE resignation_date resignation_date date NULL DEFAULT NULL, CHANGE profile_picture profile_picture TEXT NULL;

UPDATE cw_form_setting SET input_view_type = '2',input_for = '1',prime_module_id = 'employees' ,field_type = '5',label_name = 'sub_group_name',view_name = 'Personal Subarea',short_name = 'Personal subarea',text_type = '0',date_type = '0',field_length = '0',field_decimals = '0',pick_list = 'sub_area_code,sub_area_name',pick_list_type = '1',pick_list_import = '2',pick_table = 'cw_sap_personal_sub_area',auto_prime_id = ' ',auto_dispaly_value = ' ',field_isdefault = '1',default_value = '0',mandatory_field = '1',upd_mandatory_field = '0',unique_field = '0',pick_display_value = 'sub_area_name',field_show = '1',field_for = '1,2,3,4,5',file_type = '',upload_extension = '',upload_file_size = '0',table_show = '1',search_show = '1',transaction_type = '4',gross_check = '0',taxable_check = '0',earn_month_check = '0',earn_payroll_check = '0',ded_payroll_check = '0',benefit_check = '0',increment_check = '0',arrear_pf_check = '0',fandf_check = '0',deduction_check = '0',deduction_month_check = '0',loan_check = '0',uniform_check = '0',edit_read = '0',picklist_data = '0',duplicate_data = '0',trans_updated_by = '1',trans_updated_date = '2022-04-22 21:56:20' WHERE prime_form_id = '1792';

ALTER TABLE cw_employees CHANGE prime_employees_id prime_employees_id int(11) NOT NULL AUTO_INCREMENT,CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0', CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0', CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0', CHANGE gross gross decimal(15,2) NULL DEFAULT '0', CHANGE da da decimal(15,2) NULL DEFAULT '0', CHANGE hra hra decimal(15,2) NULL DEFAULT '0', CHANGE basic basic decimal(15,2) NULL DEFAULT '0', CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0', CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0', CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0', CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0', CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0', CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0', CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0', CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0', CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0', CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0', CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0', CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0', CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0', CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0', CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0', CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0', CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0', CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0', CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0', CHANGE wt10 wt10 varchar(10) NULL DEFAULT '', CHANGE sap_code_status sap_code_status int(10) NULL DEFAULT '0', CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0', CHANGE payroll payroll varchar(100) NULL DEFAULT '1', CHANGE sap_remarks sap_remarks varchar(50) NULL DEFAULT '', CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0', CHANGE wt9 wt9 varchar(10) NULL DEFAULT '', CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0', CHANGE user_right user_right varchar(100) NULL DEFAULT '3', CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0', CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0', CHANGE sap_status sap_status varchar(100) NULL DEFAULT '2', CHANGE role role varchar(100) NULL DEFAULT '0', CHANGE wt8 wt8 varchar(10) NULL DEFAULT '', CHANGE department department varchar(100) NULL DEFAULT '0', CHANGE process_month process_month varchar(100) NULL DEFAULT '0', CHANGE epf epf decimal(15,2) NULL DEFAULT '0', CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0', CHANGE branch branch varchar(100) NULL DEFAULT '0', CHANGE branch_hr branch_hr varchar(100) NULL DEFAULT '0', CHANGE emp_name emp_name varchar(100) NULL DEFAULT '', CHANGE income_tax_type income_tax_type varchar(100) NULL DEFAULT '0', CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0', CHANGE wt7 wt7 varchar(10) NULL DEFAULT '', CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0', CHANGE hr_remark hr_remark TEXT NULL, CHANGE emp_location emp_location varchar(25) NULL DEFAULT '', CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0', CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0', CHANGE hr_status hr_status varchar(100) NULL DEFAULT '1', CHANGE emp_street_no emp_street_no varchar(30) NULL DEFAULT '', CHANGE wt6 wt6 varchar(10) NULL DEFAULT '', CHANGE uan_number uan_number varchar(13) NULL DEFAULT '', CHANGE pan_number pan_number varchar(10) NULL DEFAULT '', CHANGE manager_remark manager_remark TEXT NULL, CHANGE emp_pincode emp_pincode varchar(10) NULL DEFAULT '', CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0', CHANGE pf_account_number pf_account_number varchar(100) NULL DEFAULT '', CHANGE manager_reason manager_reason varchar(100) NULL DEFAULT '0', CHANGE wt5 wt5 varchar(10) NULL DEFAULT '', CHANGE emp_address_code emp_address_code varchar(100) NULL DEFAULT '0', CHANGE tds tds decimal(15,2) NULL DEFAULT '0', CHANGE tl_report tl_report varchar(100) NULL DEFAULT '0', CHANGE marital_code marital_code varchar(100) NULL DEFAULT '0', CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0', CHANGE second_level_approval second_level_approval varchar(100) NULL DEFAULT '0', CHANGE country_code country_code varchar(100) NULL DEFAULT '0', CHANGE wt4 wt4 varchar(10) NULL DEFAULT '', CHANGE esi_number esi_number varchar(100) NULL DEFAULT '', CHANGE first_level_approval first_level_approval varchar(100) NULL DEFAULT '0', CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0', CHANGE emp_age emp_age int(10) NULL DEFAULT '0', CHANGE approve_type approve_type varchar(100) NULL DEFAULT '1', CHANGE increment_third_level increment_third_level varchar(100) NULL DEFAULT '0', CHANGE wt3 wt3 varchar(10) NULL DEFAULT '', CHANGE date_of_birth date_of_birth date NULL DEFAULT NULL, CHANGE esi_location esi_location varchar(100) NULL DEFAULT '0', CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0', CHANGE gender gender varchar(100) NULL DEFAULT '0', CHANGE increment_second_level increment_second_level varchar(100) NULL DEFAULT '0', CHANGE emp_firstname emp_firstname varchar(25) NULL DEFAULT '', CHANGE wt2 wt2 varchar(10) NULL DEFAULT '', CHANGE stop_pay_remarks stop_pay_remarks TEXT NULL, CHANGE increment_first_level increment_first_level varchar(100) NULL DEFAULT '0', CHANGE increment_approve_type increment_approve_type varchar(100) NULL DEFAULT '1', CHANGE title_code title_code varchar(100) NULL DEFAULT '0', CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0', CHANGE bank_account_number bank_account_number varchar(100) NULL DEFAULT '', CHANGE stop_pay_status stop_pay_status varchar(10) NULL DEFAULT '0', CHANGE ptax_code ptax_code varchar(100) NULL DEFAULT '0', CHANGE wt1 wt1 varchar(10) NULL DEFAULT '', CHANGE hold_reason hold_reason varchar(40) NULL DEFAULT '', CHANGE personal_email_id personal_email_id varchar(150) NULL DEFAULT NULL, CHANGE bank_branch bank_branch varchar(200) NULL DEFAULT '', CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0', CHANGE manager_status manager_status varchar(100) NULL DEFAULT '1', CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0', CHANGE mode_code mode_code varchar(100) NULL DEFAULT '0', CHANGE company_email_id company_email_id varchar(150) NULL DEFAULT NULL, CHANGE separation_reason separation_reason TEXT NULL, CHANGE manager_report manager_report varchar(100) NULL DEFAULT '0', CHANGE sub_group_code sub_group_code varchar(100) NULL DEFAULT '0', CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0', CHANGE pay_code pay_code varchar(100) NULL DEFAULT '0', CHANGE emp_percentage emp_percentage decimal(15,2) NULL DEFAULT '0', CHANGE action_reason action_reason varchar(100) NULL DEFAULT '0', CHANGE info_passed_on info_passed_on date NULL DEFAULT NULL, CHANGE additional_mobile_number additional_mobile_number varchar(10) NULL DEFAULT NULL, CHANGE last_working_date last_working_date date NULL DEFAULT NULL, CHANGE emp_group_code emp_group_code varchar(100) NULL DEFAULT '0', CHANGE sub_group_name sub_group_name varchar(100) NULL DEFAULT '0', CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0', CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0', CHANGE emp_cost_center_code emp_cost_center_code varchar(100) NULL DEFAULT '0', CHANGE emp_uan emp_uan varchar(20) NULL DEFAULT '', CHANGE emp_aadhar_name emp_aadhar_name varchar(30) NULL DEFAULT '', CHANGE wci_code wci_code varchar(100) NULL DEFAULT '0', CHANGE action_code action_code varchar(100) NULL DEFAULT '0', CHANGE family_gender_code family_gender_code varchar(100) NULL DEFAULT '0', CHANGE emp_esi_location emp_esi_location varchar(40) NULL DEFAULT '', CHANGE ifsc_code ifsc_code varchar(100) NULL DEFAULT '0', CHANGE info_passed_by info_passed_by varchar(40) NULL DEFAULT '', CHANGE mobile_number mobile_number varchar(10) NULL DEFAULT NULL, CHANGE metro metro varchar(100) NULL DEFAULT '0', CHANGE resignation_letter_upload resignation_letter_upload TEXT NULL, CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0', CHANGE id_proof id_proof TEXT NULL, CHANGE esi esi decimal(15,2) NULL DEFAULT '0', CHANGE emp_company_code emp_company_code varchar(100) NULL DEFAULT '0', CHANGE emp_pf_no emp_pf_no varchar(20) NULL DEFAULT '', CHANGE emp_esi_no emp_esi_no varchar(20) NULL DEFAULT '', CHANGE challange_code challange_code varchar(100) NULL DEFAULT '0', CHANGE activity_no activity_no varchar(100) NULL DEFAULT '0', CHANGE pf_celling pf_celling varchar(50) NULL DEFAULT '', CHANGE family_first_name family_first_name varchar(25) NULL DEFAULT '', CHANGE bank_name bank_name varchar(18) NULL DEFAULT '', CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL, CHANGE hold_pay_code hold_pay_code varchar(100) NULL DEFAULT '0', CHANGE aadhar_card_no aadhar_card_no varchar(20) NULL DEFAULT '', CHANGE separation_type separation_type varchar(100) NULL DEFAULT '0', CHANGE personal_code personal_code varchar(100) NULL DEFAULT '0', CHANGE employee_code employee_code varchar(10) NULL DEFAULT '', CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0', CHANGE pf pf decimal(15,2) NULL DEFAULT '0', CHANGE emp_cost_code emp_cost_code varchar(100) NULL DEFAULT '0', CHANGE emp_pf_code emp_pf_code varchar(100) NULL DEFAULT '0', CHANGE statutory_code statutory_code varchar(100) NULL DEFAULT '0001', CHANGE network_id network_id varchar(100) NULL DEFAULT '0', CHANGE sap_client_name sap_client_name varchar(100) NULL DEFAULT '0', CHANGE bank_key bank_key varchar(100) NULL DEFAULT '0', CHANGE family_address_code family_address_code varchar(100) NULL DEFAULT '0', CHANGE designation designation varchar(100) NULL DEFAULT '0', CHANGE com_address_code com_address_code varchar(100) NULL DEFAULT '0', CHANGE aadhar_address_code aadhar_address_code varchar(100) NULL DEFAULT '0', CHANGE stop_pay_code stop_pay_code varchar(100) NULL DEFAULT '0', CHANGE blood_group blood_group varchar(100) NULL DEFAULT '0', CHANGE professional_tax_location professional_tax_location varchar(100) NULL DEFAULT '0', CHANGE resignation_date resignation_date date NULL DEFAULT NULL, CHANGE profile_picture profile_picture TEXT NULL;

UPDATE cw_form_setting SET input_view_type = '2',input_for = '1',prime_module_id = 'employees' ,field_type = '5',label_name = 'sub_group_name',view_name = 'Personal Subarea',short_name = 'Personal subarea',text_type = '0',date_type = '0',field_length = '0',field_decimals = '0',pick_list = 'sub_area_code,sub_area_name',pick_list_type = '1',pick_list_import = '2',pick_table = 'cw_sap_personal_sub_area',auto_prime_id = ' ',auto_dispaly_value = ' ',field_isdefault = '1',default_value = '0',mandatory_field = '1',upd_mandatory_field = '0',unique_field = '0',pick_display_value = 'sub_area_name',field_show = '1',field_for = '1,2,3,4,5',file_type = '',upload_extension = '',upload_file_size = '0',table_show = '1',search_show = '1',transaction_type = '4',gross_check = '0',taxable_check = '0',earn_month_check = '0',earn_payroll_check = '0',ded_payroll_check = '0',benefit_check = '0',increment_check = '0',arrear_pf_check = '0',fandf_check = '0',deduction_check = '0',deduction_month_check = '0',loan_check = '0',uniform_check = '0',edit_read = '0',picklist_data = '0',duplicate_data = '0',trans_updated_by = '1',trans_updated_date = '2022-04-22 22:05:41' WHERE prime_form_id = '1792';

ALTER TABLE cw_employees CHANGE prime_employees_id prime_employees_id int(11) NOT NULL AUTO_INCREMENT,CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0', CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0', CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0', CHANGE gross gross decimal(15,2) NULL DEFAULT '0', CHANGE da da decimal(15,2) NULL DEFAULT '0', CHANGE hra hra decimal(15,2) NULL DEFAULT '0', CHANGE basic basic decimal(15,2) NULL DEFAULT '0', CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0', CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0', CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0', CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0', CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0', CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0', CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0', CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0', CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0', CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0', CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0', CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0', CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0', CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0', CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0', CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0', CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0', CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0', CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0', CHANGE wt10 wt10 varchar(10) NULL DEFAULT '', CHANGE sap_code_status sap_code_status int(10) NULL DEFAULT '0', CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0', CHANGE payroll payroll varchar(100) NULL DEFAULT '1', CHANGE sap_remarks sap_remarks varchar(50) NULL DEFAULT '', CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0', CHANGE wt9 wt9 varchar(10) NULL DEFAULT '', CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0', CHANGE user_right user_right varchar(100) NULL DEFAULT '3', CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0', CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0', CHANGE sap_status sap_status varchar(100) NULL DEFAULT '2', CHANGE role role varchar(100) NULL DEFAULT '0', CHANGE wt8 wt8 varchar(10) NULL DEFAULT '', CHANGE department department varchar(100) NULL DEFAULT '0', CHANGE process_month process_month varchar(100) NULL DEFAULT '0', CHANGE epf epf decimal(15,2) NULL DEFAULT '0', CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0', CHANGE branch branch varchar(100) NULL DEFAULT '0', CHANGE branch_hr branch_hr varchar(100) NULL DEFAULT '0', CHANGE emp_name emp_name varchar(100) NULL DEFAULT '', CHANGE income_tax_type income_tax_type varchar(100) NULL DEFAULT '0', CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0', CHANGE wt7 wt7 varchar(10) NULL DEFAULT '', CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0', CHANGE hr_remark hr_remark TEXT NULL, CHANGE emp_location emp_location varchar(25) NULL DEFAULT '', CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0', CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0', CHANGE hr_status hr_status varchar(100) NULL DEFAULT '1', CHANGE emp_street_no emp_street_no varchar(30) NULL DEFAULT '', CHANGE wt6 wt6 varchar(10) NULL DEFAULT '', CHANGE uan_number uan_number varchar(13) NULL DEFAULT '', CHANGE pan_number pan_number varchar(10) NULL DEFAULT '', CHANGE manager_remark manager_remark TEXT NULL, CHANGE emp_pincode emp_pincode varchar(10) NULL DEFAULT '', CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0', CHANGE pf_account_number pf_account_number varchar(100) NULL DEFAULT '', CHANGE manager_reason manager_reason varchar(100) NULL DEFAULT '0', CHANGE wt5 wt5 varchar(10) NULL DEFAULT '', CHANGE emp_address_code emp_address_code varchar(100) NULL DEFAULT '0', CHANGE tds tds decimal(15,2) NULL DEFAULT '0', CHANGE tl_report tl_report varchar(100) NULL DEFAULT '0', CHANGE marital_code marital_code varchar(100) NULL DEFAULT '0', CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0', CHANGE second_level_approval second_level_approval varchar(100) NULL DEFAULT '0', CHANGE country_code country_code varchar(100) NULL DEFAULT '0', CHANGE wt4 wt4 varchar(10) NULL DEFAULT '', CHANGE esi_number esi_number varchar(100) NULL DEFAULT '', CHANGE first_level_approval first_level_approval varchar(100) NULL DEFAULT '0', CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0', CHANGE emp_age emp_age int(10) NULL DEFAULT '0', CHANGE approve_type approve_type varchar(100) NULL DEFAULT '1', CHANGE increment_third_level increment_third_level varchar(100) NULL DEFAULT '0', CHANGE wt3 wt3 varchar(10) NULL DEFAULT '', CHANGE date_of_birth date_of_birth date NULL DEFAULT NULL, CHANGE esi_location esi_location varchar(100) NULL DEFAULT '0', CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0', CHANGE gender gender varchar(100) NULL DEFAULT '0', CHANGE increment_second_level increment_second_level varchar(100) NULL DEFAULT '0', CHANGE emp_firstname emp_firstname varchar(25) NULL DEFAULT '', CHANGE wt2 wt2 varchar(10) NULL DEFAULT '', CHANGE stop_pay_remarks stop_pay_remarks TEXT NULL, CHANGE increment_first_level increment_first_level varchar(100) NULL DEFAULT '0', CHANGE increment_approve_type increment_approve_type varchar(100) NULL DEFAULT '1', CHANGE title_code title_code varchar(100) NULL DEFAULT '0', CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0', CHANGE bank_account_number bank_account_number varchar(100) NULL DEFAULT '', CHANGE stop_pay_status stop_pay_status varchar(10) NULL DEFAULT '0', CHANGE ptax_code ptax_code varchar(100) NULL DEFAULT '0', CHANGE wt1 wt1 varchar(10) NULL DEFAULT '', CHANGE hold_reason hold_reason varchar(40) NULL DEFAULT '', CHANGE personal_email_id personal_email_id varchar(150) NULL DEFAULT NULL, CHANGE bank_branch bank_branch varchar(200) NULL DEFAULT '', CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0', CHANGE manager_status manager_status varchar(100) NULL DEFAULT '1', CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0', CHANGE mode_code mode_code varchar(100) NULL DEFAULT '0', CHANGE company_email_id company_email_id varchar(150) NULL DEFAULT NULL, CHANGE separation_reason separation_reason TEXT NULL, CHANGE manager_report manager_report varchar(100) NULL DEFAULT '0', CHANGE sub_group_code sub_group_code varchar(100) NULL DEFAULT '0', CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0', CHANGE pay_code pay_code varchar(100) NULL DEFAULT '0', CHANGE emp_percentage emp_percentage decimal(15,2) NULL DEFAULT '0', CHANGE action_reason action_reason varchar(100) NULL DEFAULT '0', CHANGE info_passed_on info_passed_on date NULL DEFAULT NULL, CHANGE additional_mobile_number additional_mobile_number varchar(10) NULL DEFAULT NULL, CHANGE last_working_date last_working_date date NULL DEFAULT NULL, CHANGE emp_group_code emp_group_code varchar(100) NULL DEFAULT '0', CHANGE sub_group_name sub_group_name varchar(100) NULL DEFAULT '0', CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0', CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0', CHANGE emp_cost_center_code emp_cost_center_code varchar(100) NULL DEFAULT '0', CHANGE emp_uan emp_uan varchar(20) NULL DEFAULT '', CHANGE emp_aadhar_name emp_aadhar_name varchar(30) NULL DEFAULT '', CHANGE wci_code wci_code varchar(100) NULL DEFAULT '0', CHANGE action_code action_code varchar(100) NULL DEFAULT '0', CHANGE family_gender_code family_gender_code varchar(100) NULL DEFAULT '0', CHANGE emp_esi_location emp_esi_location varchar(40) NULL DEFAULT '', CHANGE ifsc_code ifsc_code varchar(100) NULL DEFAULT '0', CHANGE info_passed_by info_passed_by varchar(40) NULL DEFAULT '', CHANGE mobile_number mobile_number varchar(10) NULL DEFAULT NULL, CHANGE metro metro varchar(100) NULL DEFAULT '0', CHANGE resignation_letter_upload resignation_letter_upload TEXT NULL, CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0', CHANGE id_proof id_proof TEXT NULL, CHANGE esi esi decimal(15,2) NULL DEFAULT '0', CHANGE emp_company_code emp_company_code varchar(100) NULL DEFAULT '0', CHANGE emp_pf_no emp_pf_no varchar(20) NULL DEFAULT '', CHANGE emp_esi_no emp_esi_no varchar(20) NULL DEFAULT '', CHANGE challange_code challange_code varchar(100) NULL DEFAULT '0', CHANGE activity_no activity_no varchar(100) NULL DEFAULT '0', CHANGE pf_celling pf_celling varchar(50) NULL DEFAULT '', CHANGE family_first_name family_first_name varchar(25) NULL DEFAULT '', CHANGE bank_name bank_name varchar(18) NULL DEFAULT '', CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL, CHANGE hold_pay_code hold_pay_code varchar(100) NULL DEFAULT '0', CHANGE aadhar_card_no aadhar_card_no varchar(20) NULL DEFAULT '', CHANGE separation_type separation_type varchar(100) NULL DEFAULT '0', CHANGE personal_code personal_code varchar(100) NULL DEFAULT '0', CHANGE employee_code employee_code varchar(10) NULL DEFAULT '', CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0', CHANGE pf pf decimal(15,2) NULL DEFAULT '0', CHANGE emp_cost_code emp_cost_code varchar(100) NULL DEFAULT '0', CHANGE emp_pf_code emp_pf_code varchar(100) NULL DEFAULT '0', CHANGE statutory_code statutory_code varchar(100) NULL DEFAULT '0001', CHANGE network_id network_id varchar(100) NULL DEFAULT '0', CHANGE sap_client_name sap_client_name varchar(100) NULL DEFAULT '0', CHANGE bank_key bank_key varchar(100) NULL DEFAULT '0', CHANGE family_address_code family_address_code varchar(100) NULL DEFAULT '0', CHANGE designation designation varchar(100) NULL DEFAULT '0', CHANGE com_address_code com_address_code varchar(100) NULL DEFAULT '0', CHANGE aadhar_address_code aadhar_address_code varchar(100) NULL DEFAULT '0', CHANGE stop_pay_code stop_pay_code varchar(100) NULL DEFAULT '0', CHANGE blood_group blood_group varchar(100) NULL DEFAULT '0', CHANGE professional_tax_location professional_tax_location varchar(100) NULL DEFAULT '0', CHANGE resignation_date resignation_date date NULL DEFAULT NULL, CHANGE profile_picture profile_picture TEXT NULL;

UPDATE cw_zct_12 SET cw_zct_12_status = "0";

UPDATE cw_zct_12 SET cw_zct_12_status = "1" WHERE FIND_IN_SET(cw_zct_12_value,"Resigned,Abscond,Terminated,Separation");

UPDATE cw_zct_12 SET cw_zct_12_status = "1" WHERE FIND_IN_SET(cw_zct_12_value,"Resigned,Abscond,Terminated,Separation");

UPDATE cw_zct_12 SET cw_zct_12_status = "1" WHERE FIND_IN_SET(cw_zct_12_value,"Resigned,Abscond,Terminated,Separation");

UPDATE cw_zct_12 SET cw_zct_12_status = "1" WHERE FIND_IN_SET(cw_zct_12_value,"Resigned,Abscond,Terminated,Separation");

UPDATE cw_zct_13 SET cw_zct_13_status = "0";

UPDATE cw_zct_13 SET cw_zct_13_status = "1" WHERE FIND_IN_SET(cw_zct_13_value,"Hold For FandF,Hold For other,Unhold,Supplementry Day");

UPDATE cw_zct_13 SET cw_zct_13_status = "1" WHERE FIND_IN_SET(cw_zct_13_value,"Hold For FandF,Hold For other,Unhold,Supplementry Day");

UPDATE cw_zct_13 SET cw_zct_13_status = "1" WHERE FIND_IN_SET(cw_zct_13_value,"Hold For FandF,Hold For other,Unhold,Supplementry Day");

UPDATE cw_zct_13 SET cw_zct_13_status = "1" WHERE FIND_IN_SET(cw_zct_13_value,"Hold For FandF,Hold For other,Unhold,Supplementry Day");

UPDATE cw_zct_26 SET cw_zct_26_status = "0";

UPDATE cw_zct_26 SET cw_zct_26_status = "1" WHERE FIND_IN_SET(cw_zct_26_value,"Not Joining,Resigned,Abscond,Terminated");

UPDATE cw_zct_26 SET cw_zct_26_status = "1" WHERE FIND_IN_SET(cw_zct_26_value,"Not Joining,Resigned,Abscond,Terminated");

UPDATE cw_zct_26 SET cw_zct_26_status = "1" WHERE FIND_IN_SET(cw_zct_26_value,"Not Joining,Resigned,Abscond,Terminated");

UPDATE cw_zct_26 SET cw_zct_26_status = "1" WHERE FIND_IN_SET(cw_zct_26_value,"Not Joining,Resigned,Abscond,Terminated");

UPDATE cw_zct_42 SET cw_zct_42_status = "0";

UPDATE cw_zct_42 SET cw_zct_42_status = "1" WHERE FIND_IN_SET(cw_zct_42_value,"Separated,Rejoined");

UPDATE cw_zct_42 SET cw_zct_42_status = "1" WHERE FIND_IN_SET(cw_zct_42_value,"Separated,Rejoined");

UPDATE cw_zct_49 SET cw_zct_49_status = "0";

UPDATE cw_zct_49 SET cw_zct_49_status = "1" WHERE FIND_IN_SET(cw_zct_49_value,"With Declaration,Without Declaration(New)");

UPDATE cw_zct_49 SET cw_zct_49_status = "1" WHERE FIND_IN_SET(cw_zct_49_value,"With Declaration,Without Declaration(New)");

ALTER TABLE cw_transactions_dlt CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0', CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0', CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0', CHANGE gross gross decimal(15,2) NULL DEFAULT '0', CHANGE da da decimal(15,2) NULL DEFAULT '0', CHANGE hra hra decimal(15,2) NULL DEFAULT '0', CHANGE basic basic decimal(15,2) NULL DEFAULT '0', CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0', CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0', CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0', CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0', CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0', CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0', CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0', CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0', CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0', CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0', CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0', CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0', CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0', CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0', CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0', CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0', CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0', CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0', CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0', CHANGE wt10 wt10 varchar(10) NULL DEFAULT '', CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0', CHANGE payroll payroll varchar(100) NULL DEFAULT '1', CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0', CHANGE wt9 wt9 varchar(10) NULL DEFAULT '', CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0', CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0', CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0', CHANGE role role varchar(100) NULL DEFAULT '0', CHANGE wt8 wt8 varchar(10) NULL DEFAULT '', CHANGE department department varchar(100) NULL DEFAULT '0', CHANGE process_month process_month varchar(100) NULL DEFAULT '0', CHANGE epf epf decimal(15,2) NULL DEFAULT '0', CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0', CHANGE branch branch varchar(100) NULL DEFAULT '0', CHANGE emp_name emp_name varchar(100) NULL DEFAULT '', CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0', CHANGE wt7 wt7 varchar(10) NULL DEFAULT '', CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0', CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0', CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0', CHANGE wt6 wt6 varchar(10) NULL DEFAULT '', CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0', CHANGE wt5 wt5 varchar(10) NULL DEFAULT '', CHANGE tds tds decimal(15,2) NULL DEFAULT '0', CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0', CHANGE wt4 wt4 varchar(10) NULL DEFAULT '', CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0', CHANGE wt3 wt3 varchar(10) NULL DEFAULT '', CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0', CHANGE wt2 wt2 varchar(10) NULL DEFAULT '', CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0', CHANGE wt1 wt1 varchar(10) NULL DEFAULT '', CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0', CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0', CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0', CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0', CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0', CHANGE metro metro varchar(100) NULL DEFAULT '0', CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0', CHANGE esi esi decimal(15,2) NULL DEFAULT '0', CHANGE employee_code employee_code varchar(10) NULL DEFAULT '', CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0', CHANGE pf pf decimal(15,2) NULL DEFAULT '0', CHANGE designation designation varchar(100) NULL DEFAULT '0', CHANGE resignation_date resignation_date date NULL DEFAULT NULL;

ALTER TABLE cw_transactions CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0', CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0', CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0', CHANGE gross gross decimal(15,2) NULL DEFAULT '0', CHANGE da da decimal(15,2) NULL DEFAULT '0', CHANGE hra hra decimal(15,2) NULL DEFAULT '0', CHANGE basic basic decimal(15,2) NULL DEFAULT '0', CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0', CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0', CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0', CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0', CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0', CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0', CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0', CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0', CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0', CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0', CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0', CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0', CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0', CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0', CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0', CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0', CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0', CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0', CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0', CHANGE wt10 wt10 varchar(10) NULL DEFAULT '', CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0', CHANGE payroll payroll varchar(100) NULL DEFAULT '1', CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0', CHANGE wt9 wt9 varchar(10) NULL DEFAULT '', CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0', CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0', CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0', CHANGE role role varchar(100) NULL DEFAULT '0', CHANGE wt8 wt8 varchar(10) NULL DEFAULT '', CHANGE department department varchar(100) NULL DEFAULT '0', CHANGE process_month process_month varchar(100) NULL DEFAULT '0', CHANGE epf epf decimal(15,2) NULL DEFAULT '0', CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0', CHANGE branch branch varchar(100) NULL DEFAULT '0', CHANGE emp_name emp_name varchar(100) NULL DEFAULT '', CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0', CHANGE wt7 wt7 varchar(10) NULL DEFAULT '', CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0', CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0', CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0', CHANGE wt6 wt6 varchar(10) NULL DEFAULT '', CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0', CHANGE wt5 wt5 varchar(10) NULL DEFAULT '', CHANGE tds tds decimal(15,2) NULL DEFAULT '0', CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0', CHANGE wt4 wt4 varchar(10) NULL DEFAULT '', CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0', CHANGE wt3 wt3 varchar(10) NULL DEFAULT '', CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0', CHANGE wt2 wt2 varchar(10) NULL DEFAULT '', CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0', CHANGE wt1 wt1 varchar(10) NULL DEFAULT '', CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0', CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0', CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0', CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0', CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0', CHANGE metro metro varchar(100) NULL DEFAULT '0', CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0', CHANGE esi esi decimal(15,2) NULL DEFAULT '0', CHANGE employee_code employee_code varchar(10) NULL DEFAULT '', CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0', CHANGE pf pf decimal(15,2) NULL DEFAULT '0', CHANGE designation designation varchar(100) NULL DEFAULT '0', CHANGE resignation_date resignation_date date NULL DEFAULT NULL;

ALTER TABLE cw_monthly_input CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0', CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0', CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0', CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0', CHANGE process_month process_month varchar(100) NULL DEFAULT '0', CHANGE emp_name emp_name varchar(100) NULL DEFAULT '', CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0', CHANGE tds tds decimal(15,2) NULL DEFAULT '0', CHANGE date_of_birth date_of_birth date NULL DEFAULT NULL, CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL, CHANGE employee_code employee_code varchar(10) NULL DEFAULT '';

ALTER TABLE cw_tax_ind_cal CHANGE da da decimal(15,2) NULL DEFAULT '0',CHANGE hra hra decimal(15,2) NULL DEFAULT '0',CHANGE basic basic decimal(15,2) NULL DEFAULT '0';

ALTER TABLE cw_custom_employees CHANGE prime_custom_employees_id prime_custom_employees_id int(11) NOT NULL AUTO_INCREMENT,CHANGE role role varchar(100) NULL DEFAULT '0',CHANGE employee_code employee_code varchar(10) NULL DEFAULT '',CHANGE emp_name emp_name varchar(100) NULL DEFAULT '',CHANGE department department varchar(100) NULL DEFAULT '0',CHANGE designation designation varchar(100) NULL DEFAULT '0',CHANGE gender gender varchar(100) NULL DEFAULT '0',CHANGE date_of_birth date_of_birth date NULL DEFAULT NULL,CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL,CHANGE branch branch varchar(100) NULL DEFAULT '0',CHANGE mobile_number mobile_number varchar(10) NULL DEFAULT NULL,CHANGE additional_mobile_number additional_mobile_number varchar(10) NULL DEFAULT NULL,CHANGE company_email_id company_email_id varchar(150) NULL DEFAULT NULL,CHANGE personal_email_id personal_email_id varchar(150) NULL DEFAULT NULL,CHANGE blood_group blood_group varchar(100) NULL DEFAULT '0',CHANGE metro metro varchar(100) NULL DEFAULT '0',CHANGE professional_tax_location professional_tax_location varchar(100) NULL DEFAULT '0',CHANGE esi_location esi_location varchar(100) NULL DEFAULT '0',CHANGE bank_branch bank_branch varchar(200) NULL DEFAULT '',CHANGE pf_account_number pf_account_number varchar(100) NULL DEFAULT '',CHANGE bank_account_number bank_account_number varchar(100) NULL DEFAULT '',CHANGE uan_number uan_number varchar(13) NULL DEFAULT '',CHANGE pan_number pan_number varchar(10) NULL DEFAULT '',CHANGE esi_number esi_number varchar(100) NULL DEFAULT '',CHANGE bank_name bank_name varchar(18) NULL DEFAULT '',CHANGE emp_age emp_age int(10) NULL DEFAULT '0',CHANGE ifsc_code ifsc_code varchar(100) NULL DEFAULT '0',CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0',CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0',CHANGE process_month process_month varchar(100) NULL DEFAULT '0',CHANGE resignation_date resignation_date date NULL DEFAULT NULL,CHANGE resignation_letter_upload resignation_letter_upload TEXT NULL,CHANGE separation_type separation_type varchar(100) NULL DEFAULT '0',CHANGE last_working_date last_working_date date NULL DEFAULT NULL,CHANGE separation_reason separation_reason TEXT NULL,CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0',CHANGE stop_pay_status stop_pay_status varchar(10) NULL DEFAULT '0',CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0',CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0',CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0',CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0',CHANGE pf pf decimal(15,2) NULL DEFAULT '0',CHANGE esi esi decimal(15,2) NULL DEFAULT '0',CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0',CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0',CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0',CHANGE epf epf decimal(15,2) NULL DEFAULT '0',CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0',CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0',CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0',CHANGE user_right user_right varchar(100) NULL DEFAULT '3',CHANGE profile_picture profile_picture TEXT NULL,CHANGE tl_report tl_report varchar(100) NULL DEFAULT '0',CHANGE manager_report manager_report varchar(100) NULL DEFAULT '0',CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0',CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0',CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0',CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0',CHANGE basic basic decimal(15,2) NULL DEFAULT '0',CHANGE da da decimal(15,2) NULL DEFAULT '0',CHANGE hra hra decimal(15,2) NULL DEFAULT '0',CHANGE gross gross decimal(15,2) NULL DEFAULT '0',CHANGE manager_status manager_status varchar(100) NULL DEFAULT '1',CHANGE manager_reason manager_reason varchar(100) NULL DEFAULT '0',CHANGE manager_remark manager_remark TEXT NULL,CHANGE hr_status hr_status varchar(100) NULL DEFAULT '1',CHANGE hr_remark hr_remark TEXT NULL,CHANGE id_proof id_proof TEXT NULL,CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0',CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0',CHANGE payroll payroll varchar(100) NULL DEFAULT '1',CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0',CHANGE stop_pay_remarks stop_pay_remarks TEXT NULL,CHANGE branch_hr branch_hr varchar(100) NULL DEFAULT '0',CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0',CHANGE increment_approve_type increment_approve_type varchar(100) NULL DEFAULT '1',CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0',CHANGE tds tds decimal(15,2) NULL DEFAULT '0',CHANGE first_level_approval first_level_approval varchar(100) NULL DEFAULT '0',CHANGE second_level_approval second_level_approval varchar(100) NULL DEFAULT '0',CHANGE approve_type approve_type varchar(100) NULL DEFAULT '1',CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0',CHANGE increment_first_level increment_first_level varchar(100) NULL DEFAULT '0',CHANGE increment_second_level increment_second_level varchar(100) NULL DEFAULT '0',CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0',CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0',CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0',CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0',CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0',CHANGE increment_third_level increment_third_level varchar(100) NULL DEFAULT '0',CHANGE income_tax_type income_tax_type varchar(100) NULL DEFAULT '0',CHANGE personal_code personal_code varchar(100) NULL DEFAULT '0',CHANGE emp_group_code emp_group_code varchar(100) NULL DEFAULT '0',CHANGE sub_group_code sub_group_code varchar(100) NULL DEFAULT '0',CHANGE sub_group_name sub_group_name varchar(100) NULL DEFAULT '0',CHANGE ptax_code ptax_code varchar(100) NULL DEFAULT '0',CHANGE title_code title_code varchar(100) NULL DEFAULT '0',CHANGE emp_firstname emp_firstname varchar(25) NULL DEFAULT '',CHANGE country_code country_code varchar(100) NULL DEFAULT '0',CHANGE marital_code marital_code varchar(100) NULL DEFAULT '0',CHANGE emp_street_no emp_street_no varchar(30) NULL DEFAULT '',CHANGE emp_pincode emp_pincode varchar(10) NULL DEFAULT '',CHANGE emp_location emp_location varchar(25) NULL DEFAULT '',CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0',CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0',CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0',CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0',CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0',CHANGE wt1 wt1 varchar(10) NULL DEFAULT '',CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0',CHANGE wt2 wt2 varchar(10) NULL DEFAULT '',CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0',CHANGE wt3 wt3 varchar(10) NULL DEFAULT '',CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0',CHANGE wt4 wt4 varchar(10) NULL DEFAULT '',CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0',CHANGE wt5 wt5 varchar(10) NULL DEFAULT '',CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0',CHANGE wt6 wt6 varchar(10) NULL DEFAULT '',CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0',CHANGE wt7 wt7 varchar(10) NULL DEFAULT '',CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0',CHANGE wt8 wt8 varchar(10) NULL DEFAULT '',CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0',CHANGE wt9 wt9 varchar(10) NULL DEFAULT '',CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0',CHANGE wt10 wt10 varchar(10) NULL DEFAULT '',CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0',CHANGE pay_code pay_code varchar(100) NULL DEFAULT '0',CHANGE emp_cost_code emp_cost_code varchar(100) NULL DEFAULT '0',CHANGE emp_company_code emp_company_code varchar(100) NULL DEFAULT '0',CHANGE emp_cost_center_code emp_cost_center_code varchar(100) NULL DEFAULT '0',CHANGE emp_percentage emp_percentage decimal(15,2) NULL DEFAULT '0',CHANGE emp_pf_code emp_pf_code varchar(100) NULL DEFAULT '0',CHANGE emp_pf_no emp_pf_no varchar(20) NULL DEFAULT '',CHANGE emp_uan emp_uan varchar(20) NULL DEFAULT '',CHANGE statutory_code statutory_code varchar(100) NULL DEFAULT '0001',CHANGE emp_esi_no emp_esi_no varchar(20) NULL DEFAULT '',CHANGE emp_aadhar_name emp_aadhar_name varchar(30) NULL DEFAULT '',CHANGE challange_code challange_code varchar(100) NULL DEFAULT '0',CHANGE network_id network_id varchar(100) NULL DEFAULT '0',CHANGE activity_no activity_no varchar(100) NULL DEFAULT '0',CHANGE sap_client_name sap_client_name varchar(100) NULL DEFAULT '0',CHANGE pf_celling pf_celling varchar(50) NULL DEFAULT '',CHANGE wci_code wci_code varchar(100) NULL DEFAULT '0',CHANGE action_code action_code varchar(100) NULL DEFAULT '0',CHANGE action_reason action_reason varchar(100) NULL DEFAULT '0',CHANGE emp_address_code emp_address_code varchar(100) NULL DEFAULT '0',CHANGE bank_key bank_key varchar(100) NULL DEFAULT '0',CHANGE family_address_code family_address_code varchar(100) NULL DEFAULT '0',CHANGE family_first_name family_first_name varchar(25) NULL DEFAULT '',CHANGE family_gender_code family_gender_code varchar(100) NULL DEFAULT '0',CHANGE emp_esi_location emp_esi_location varchar(40) NULL DEFAULT '',CHANGE com_address_code com_address_code varchar(100) NULL DEFAULT '0',CHANGE aadhar_address_code aadhar_address_code varchar(100) NULL DEFAULT '0',CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0',CHANGE stop_pay_code stop_pay_code varchar(100) NULL DEFAULT '0',CHANGE hold_pay_code hold_pay_code varchar(100) NULL DEFAULT '0',CHANGE info_passed_by info_passed_by varchar(40) NULL DEFAULT '',CHANGE info_passed_on info_passed_on date NULL DEFAULT NULL,CHANGE mode_code mode_code varchar(100) NULL DEFAULT '0',CHANGE hold_reason hold_reason varchar(40) NULL DEFAULT '',CHANGE sap_status sap_status varchar(100) NULL DEFAULT '2',CHANGE aadhar_card_no aadhar_card_no varchar(20) NULL DEFAULT '',CHANGE sap_remarks sap_remarks varchar(50) NULL DEFAULT '',CHANGE sap_code_status sap_code_status int(10) NULL DEFAULT '0';

ALTER TABLE cw_custom_employees_log CHANGE prime_custom_employees_log_id prime_custom_employees_log_id int(11) NOT NULL AUTO_INCREMENT,CHANGE role role varchar(100) NULL DEFAULT '0',CHANGE employee_code employee_code varchar(10) NULL DEFAULT '',CHANGE emp_name emp_name varchar(100) NULL DEFAULT '',CHANGE department department varchar(100) NULL DEFAULT '0',CHANGE designation designation varchar(100) NULL DEFAULT '0',CHANGE gender gender varchar(100) NULL DEFAULT '0',CHANGE date_of_birth date_of_birth date NULL DEFAULT NULL,CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL,CHANGE branch branch varchar(100) NULL DEFAULT '0',CHANGE mobile_number mobile_number varchar(10) NULL DEFAULT NULL,CHANGE additional_mobile_number additional_mobile_number varchar(10) NULL DEFAULT NULL,CHANGE company_email_id company_email_id varchar(150) NULL DEFAULT NULL,CHANGE personal_email_id personal_email_id varchar(150) NULL DEFAULT NULL,CHANGE blood_group blood_group varchar(100) NULL DEFAULT '0',CHANGE metro metro varchar(100) NULL DEFAULT '0',CHANGE professional_tax_location professional_tax_location varchar(100) NULL DEFAULT '0',CHANGE esi_location esi_location varchar(100) NULL DEFAULT '0',CHANGE bank_branch bank_branch varchar(200) NULL DEFAULT '',CHANGE pf_account_number pf_account_number varchar(100) NULL DEFAULT '',CHANGE bank_account_number bank_account_number varchar(100) NULL DEFAULT '',CHANGE uan_number uan_number varchar(13) NULL DEFAULT '',CHANGE pan_number pan_number varchar(10) NULL DEFAULT '',CHANGE esi_number esi_number varchar(100) NULL DEFAULT '',CHANGE bank_name bank_name varchar(18) NULL DEFAULT '',CHANGE emp_age emp_age int(10) NULL DEFAULT '0',CHANGE ifsc_code ifsc_code varchar(100) NULL DEFAULT '0',CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0',CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0',CHANGE process_month process_month varchar(100) NULL DEFAULT '0',CHANGE resignation_date resignation_date date NULL DEFAULT NULL,CHANGE resignation_letter_upload resignation_letter_upload TEXT NULL,CHANGE separation_type separation_type varchar(100) NULL DEFAULT '0',CHANGE last_working_date last_working_date date NULL DEFAULT NULL,CHANGE separation_reason separation_reason TEXT NULL,CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0',CHANGE stop_pay_status stop_pay_status varchar(10) NULL DEFAULT '0',CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0',CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0',CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0',CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0',CHANGE pf pf decimal(15,2) NULL DEFAULT '0',CHANGE esi esi decimal(15,2) NULL DEFAULT '0',CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0',CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0',CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0',CHANGE epf epf decimal(15,2) NULL DEFAULT '0',CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0',CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0',CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0',CHANGE user_right user_right varchar(100) NULL DEFAULT '3',CHANGE profile_picture profile_picture TEXT NULL,CHANGE tl_report tl_report varchar(100) NULL DEFAULT '0',CHANGE manager_report manager_report varchar(100) NULL DEFAULT '0',CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0',CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0',CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0',CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0',CHANGE basic basic decimal(15,2) NULL DEFAULT '0',CHANGE da da decimal(15,2) NULL DEFAULT '0',CHANGE hra hra decimal(15,2) NULL DEFAULT '0',CHANGE gross gross decimal(15,2) NULL DEFAULT '0',CHANGE manager_status manager_status varchar(100) NULL DEFAULT '1',CHANGE manager_reason manager_reason varchar(100) NULL DEFAULT '0',CHANGE manager_remark manager_remark TEXT NULL,CHANGE hr_status hr_status varchar(100) NULL DEFAULT '1',CHANGE hr_remark hr_remark TEXT NULL,CHANGE id_proof id_proof TEXT NULL,CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0',CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0',CHANGE payroll payroll varchar(100) NULL DEFAULT '1',CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0',CHANGE stop_pay_remarks stop_pay_remarks TEXT NULL,CHANGE branch_hr branch_hr varchar(100) NULL DEFAULT '0',CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0',CHANGE increment_approve_type increment_approve_type varchar(100) NULL DEFAULT '1',CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0',CHANGE tds tds decimal(15,2) NULL DEFAULT '0',CHANGE first_level_approval first_level_approval varchar(100) NULL DEFAULT '0',CHANGE second_level_approval second_level_approval varchar(100) NULL DEFAULT '0',CHANGE approve_type approve_type varchar(100) NULL DEFAULT '1',CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0',CHANGE increment_first_level increment_first_level varchar(100) NULL DEFAULT '0',CHANGE increment_second_level increment_second_level varchar(100) NULL DEFAULT '0',CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0',CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0',CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0',CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0',CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0',CHANGE increment_third_level increment_third_level varchar(100) NULL DEFAULT '0',CHANGE income_tax_type income_tax_type varchar(100) NULL DEFAULT '0',CHANGE personal_code personal_code varchar(100) NULL DEFAULT '0',CHANGE emp_group_code emp_group_code varchar(100) NULL DEFAULT '0',CHANGE sub_group_code sub_group_code varchar(100) NULL DEFAULT '0',CHANGE sub_group_name sub_group_name varchar(100) NULL DEFAULT '0',CHANGE ptax_code ptax_code varchar(100) NULL DEFAULT '0',CHANGE title_code title_code varchar(100) NULL DEFAULT '0',CHANGE emp_firstname emp_firstname varchar(25) NULL DEFAULT '',CHANGE country_code country_code varchar(100) NULL DEFAULT '0',CHANGE marital_code marital_code varchar(100) NULL DEFAULT '0',CHANGE emp_street_no emp_street_no varchar(30) NULL DEFAULT '',CHANGE emp_pincode emp_pincode varchar(10) NULL DEFAULT '',CHANGE emp_location emp_location varchar(25) NULL DEFAULT '',CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0',CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0',CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0',CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0',CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0',CHANGE wt1 wt1 varchar(10) NULL DEFAULT '',CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0',CHANGE wt2 wt2 varchar(10) NULL DEFAULT '',CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0',CHANGE wt3 wt3 varchar(10) NULL DEFAULT '',CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0',CHANGE wt4 wt4 varchar(10) NULL DEFAULT '',CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0',CHANGE wt5 wt5 varchar(10) NULL DEFAULT '',CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0',CHANGE wt6 wt6 varchar(10) NULL DEFAULT '',CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0',CHANGE wt7 wt7 varchar(10) NULL DEFAULT '',CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0',CHANGE wt8 wt8 varchar(10) NULL DEFAULT '',CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0',CHANGE wt9 wt9 varchar(10) NULL DEFAULT '',CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0',CHANGE wt10 wt10 varchar(10) NULL DEFAULT '',CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0',CHANGE pay_code pay_code varchar(100) NULL DEFAULT '0',CHANGE emp_cost_code emp_cost_code varchar(100) NULL DEFAULT '0',CHANGE emp_company_code emp_company_code varchar(100) NULL DEFAULT '0',CHANGE emp_cost_center_code emp_cost_center_code varchar(100) NULL DEFAULT '0',CHANGE emp_percentage emp_percentage decimal(15,2) NULL DEFAULT '0',CHANGE emp_pf_code emp_pf_code varchar(100) NULL DEFAULT '0',CHANGE emp_pf_no emp_pf_no varchar(20) NULL DEFAULT '',CHANGE emp_uan emp_uan varchar(20) NULL DEFAULT '',CHANGE statutory_code statutory_code varchar(100) NULL DEFAULT '0001',CHANGE emp_esi_no emp_esi_no varchar(20) NULL DEFAULT '',CHANGE emp_aadhar_name emp_aadhar_name varchar(30) NULL DEFAULT '',CHANGE challange_code challange_code varchar(100) NULL DEFAULT '0',CHANGE network_id network_id varchar(100) NULL DEFAULT '0',CHANGE activity_no activity_no varchar(100) NULL DEFAULT '0',CHANGE sap_client_name sap_client_name varchar(100) NULL DEFAULT '0',CHANGE pf_celling pf_celling varchar(50) NULL DEFAULT '',CHANGE wci_code wci_code varchar(100) NULL DEFAULT '0',CHANGE action_code action_code varchar(100) NULL DEFAULT '0',CHANGE action_reason action_reason varchar(100) NULL DEFAULT '0',CHANGE emp_address_code emp_address_code varchar(100) NULL DEFAULT '0',CHANGE bank_key bank_key varchar(100) NULL DEFAULT '0',CHANGE family_address_code family_address_code varchar(100) NULL DEFAULT '0',CHANGE family_first_name family_first_name varchar(25) NULL DEFAULT '',CHANGE family_gender_code family_gender_code varchar(100) NULL DEFAULT '0',CHANGE emp_esi_location emp_esi_location varchar(40) NULL DEFAULT '',CHANGE com_address_code com_address_code varchar(100) NULL DEFAULT '0',CHANGE aadhar_address_code aadhar_address_code varchar(100) NULL DEFAULT '0',CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0',CHANGE stop_pay_code stop_pay_code varchar(100) NULL DEFAULT '0',CHANGE hold_pay_code hold_pay_code varchar(100) NULL DEFAULT '0',CHANGE info_passed_by info_passed_by varchar(40) NULL DEFAULT '',CHANGE info_passed_on info_passed_on date NULL DEFAULT NULL,CHANGE mode_code mode_code varchar(100) NULL DEFAULT '0',CHANGE hold_reason hold_reason varchar(40) NULL DEFAULT '',CHANGE sap_status sap_status varchar(100) NULL DEFAULT '2',CHANGE aadhar_card_no aadhar_card_no varchar(20) NULL DEFAULT '',CHANGE sap_remarks sap_remarks varchar(50) NULL DEFAULT '',CHANGE sap_code_status sap_code_status int(10) NULL DEFAULT '0';

UPDATE cw_form_setting SET input_view_type = '2',input_for = '1',prime_module_id = 'employees' ,field_type = '5',label_name = 'sap_status',view_name = 'Sap Status',short_name = 'sap status',text_type = '0',date_type = '0',field_length = '0',field_decimals = '0',pick_list = 'prime_sap_status_id,sap_status',pick_list_type = '1',pick_list_import = '2',pick_table = 'cw_sap_status',auto_prime_id = ' ',auto_dispaly_value = ' ',field_isdefault = '1',default_value = '2',mandatory_field = '0',upd_mandatory_field = '0',unique_field = '0',pick_display_value = 'sap_status',field_show = '1',field_for = '1,2,3,4,5',file_type = '',upload_extension = '',upload_file_size = '0',table_show = '0',search_show = '0',transaction_type = '4',gross_check = '0',taxable_check = '0',earn_month_check = '0',earn_payroll_check = '0',ded_payroll_check = '0',benefit_check = '0',increment_check = '0',arrear_pf_check = '0',fandf_check = '0',deduction_check = '0',deduction_month_check = '0',loan_check = '0',uniform_check = '0',edit_read = '0',picklist_data = '0',duplicate_data = '0',trans_updated_by = '1',trans_updated_date = '2022-04-22 22:05:55' WHERE prime_form_id = '1872';

ALTER TABLE cw_employees CHANGE prime_employees_id prime_employees_id int(11) NOT NULL AUTO_INCREMENT,CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0', CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0', CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0', CHANGE gross gross decimal(15,2) NULL DEFAULT '0', CHANGE da da decimal(15,2) NULL DEFAULT '0', CHANGE hra hra decimal(15,2) NULL DEFAULT '0', CHANGE basic basic decimal(15,2) NULL DEFAULT '0', CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0', CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0', CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0', CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0', CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0', CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0', CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0', CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0', CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0', CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0', CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0', CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0', CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0', CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0', CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0', CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0', CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0', CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0', CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0', CHANGE wt10 wt10 varchar(10) NULL DEFAULT '', CHANGE sap_code_status sap_code_status int(10) NULL DEFAULT '0', CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0', CHANGE payroll payroll varchar(100) NULL DEFAULT '1', CHANGE sap_remarks sap_remarks varchar(50) NULL DEFAULT '', CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0', CHANGE wt9 wt9 varchar(10) NULL DEFAULT '', CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0', CHANGE user_right user_right varchar(100) NULL DEFAULT '3', CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0', CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0', CHANGE sap_status sap_status varchar(100) NULL DEFAULT '2', CHANGE role role varchar(100) NULL DEFAULT '0', CHANGE wt8 wt8 varchar(10) NULL DEFAULT '', CHANGE department department varchar(100) NULL DEFAULT '0', CHANGE process_month process_month varchar(100) NULL DEFAULT '0', CHANGE epf epf decimal(15,2) NULL DEFAULT '0', CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0', CHANGE branch branch varchar(100) NULL DEFAULT '0', CHANGE branch_hr branch_hr varchar(100) NULL DEFAULT '0', CHANGE emp_name emp_name varchar(100) NULL DEFAULT '', CHANGE income_tax_type income_tax_type varchar(100) NULL DEFAULT '0', CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0', CHANGE wt7 wt7 varchar(10) NULL DEFAULT '', CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0', CHANGE hr_remark hr_remark TEXT NULL, CHANGE emp_location emp_location varchar(25) NULL DEFAULT '', CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0', CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0', CHANGE hr_status hr_status varchar(100) NULL DEFAULT '1', CHANGE emp_street_no emp_street_no varchar(30) NULL DEFAULT '', CHANGE wt6 wt6 varchar(10) NULL DEFAULT '', CHANGE uan_number uan_number varchar(13) NULL DEFAULT '', CHANGE pan_number pan_number varchar(10) NULL DEFAULT '', CHANGE manager_remark manager_remark TEXT NULL, CHANGE emp_pincode emp_pincode varchar(10) NULL DEFAULT '', CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0', CHANGE pf_account_number pf_account_number varchar(100) NULL DEFAULT '', CHANGE manager_reason manager_reason varchar(100) NULL DEFAULT '0', CHANGE wt5 wt5 varchar(10) NULL DEFAULT '', CHANGE emp_address_code emp_address_code varchar(100) NULL DEFAULT '0', CHANGE tds tds decimal(15,2) NULL DEFAULT '0', CHANGE tl_report tl_report varchar(100) NULL DEFAULT '0', CHANGE marital_code marital_code varchar(100) NULL DEFAULT '0', CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0', CHANGE second_level_approval second_level_approval varchar(100) NULL DEFAULT '0', CHANGE country_code country_code varchar(100) NULL DEFAULT '0', CHANGE wt4 wt4 varchar(10) NULL DEFAULT '', CHANGE esi_number esi_number varchar(100) NULL DEFAULT '', CHANGE first_level_approval first_level_approval varchar(100) NULL DEFAULT '0', CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0', CHANGE emp_age emp_age int(10) NULL DEFAULT '0', CHANGE approve_type approve_type varchar(100) NULL DEFAULT '1', CHANGE increment_third_level increment_third_level varchar(100) NULL DEFAULT '0', CHANGE wt3 wt3 varchar(10) NULL DEFAULT '', CHANGE date_of_birth date_of_birth date NULL DEFAULT NULL, CHANGE esi_location esi_location varchar(100) NULL DEFAULT '0', CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0', CHANGE gender gender varchar(100) NULL DEFAULT '0', CHANGE increment_second_level increment_second_level varchar(100) NULL DEFAULT '0', CHANGE emp_firstname emp_firstname varchar(25) NULL DEFAULT '', CHANGE wt2 wt2 varchar(10) NULL DEFAULT '', CHANGE stop_pay_remarks stop_pay_remarks TEXT NULL, CHANGE increment_first_level increment_first_level varchar(100) NULL DEFAULT '0', CHANGE increment_approve_type increment_approve_type varchar(100) NULL DEFAULT '1', CHANGE title_code title_code varchar(100) NULL DEFAULT '0', CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0', CHANGE bank_account_number bank_account_number varchar(100) NULL DEFAULT '', CHANGE stop_pay_status stop_pay_status varchar(10) NULL DEFAULT '0', CHANGE ptax_code ptax_code varchar(100) NULL DEFAULT '0', CHANGE wt1 wt1 varchar(10) NULL DEFAULT '', CHANGE hold_reason hold_reason varchar(40) NULL DEFAULT '', CHANGE personal_email_id personal_email_id varchar(150) NULL DEFAULT NULL, CHANGE bank_branch bank_branch varchar(200) NULL DEFAULT '', CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0', CHANGE manager_status manager_status varchar(100) NULL DEFAULT '1', CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0', CHANGE mode_code mode_code varchar(100) NULL DEFAULT '0', CHANGE company_email_id company_email_id varchar(150) NULL DEFAULT NULL, CHANGE separation_reason separation_reason TEXT NULL, CHANGE manager_report manager_report varchar(100) NULL DEFAULT '0', CHANGE sub_group_code sub_group_code varchar(100) NULL DEFAULT '0', CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0', CHANGE pay_code pay_code varchar(100) NULL DEFAULT '0', CHANGE emp_percentage emp_percentage decimal(15,2) NULL DEFAULT '0', CHANGE action_reason action_reason varchar(100) NULL DEFAULT '0', CHANGE info_passed_on info_passed_on date NULL DEFAULT NULL, CHANGE additional_mobile_number additional_mobile_number varchar(10) NULL DEFAULT NULL, CHANGE last_working_date last_working_date date NULL DEFAULT NULL, CHANGE emp_group_code emp_group_code varchar(100) NULL DEFAULT '0', CHANGE sub_group_name sub_group_name varchar(100) NULL DEFAULT '0', CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0', CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0', CHANGE emp_cost_center_code emp_cost_center_code varchar(100) NULL DEFAULT '0', CHANGE emp_uan emp_uan varchar(20) NULL DEFAULT '', CHANGE emp_aadhar_name emp_aadhar_name varchar(30) NULL DEFAULT '', CHANGE wci_code wci_code varchar(100) NULL DEFAULT '0', CHANGE action_code action_code varchar(100) NULL DEFAULT '0', CHANGE family_gender_code family_gender_code varchar(100) NULL DEFAULT '0', CHANGE emp_esi_location emp_esi_location varchar(40) NULL DEFAULT '', CHANGE ifsc_code ifsc_code varchar(100) NULL DEFAULT '0', CHANGE info_passed_by info_passed_by varchar(40) NULL DEFAULT '', CHANGE mobile_number mobile_number varchar(10) NULL DEFAULT NULL, CHANGE metro metro varchar(100) NULL DEFAULT '0', CHANGE resignation_letter_upload resignation_letter_upload TEXT NULL, CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0', CHANGE id_proof id_proof TEXT NULL, CHANGE esi esi decimal(15,2) NULL DEFAULT '0', CHANGE emp_company_code emp_company_code varchar(100) NULL DEFAULT '0', CHANGE emp_pf_no emp_pf_no varchar(20) NULL DEFAULT '', CHANGE emp_esi_no emp_esi_no varchar(20) NULL DEFAULT '', CHANGE challange_code challange_code varchar(100) NULL DEFAULT '0', CHANGE activity_no activity_no varchar(100) NULL DEFAULT '0', CHANGE pf_celling pf_celling varchar(50) NULL DEFAULT '', CHANGE family_first_name family_first_name varchar(25) NULL DEFAULT '', CHANGE bank_name bank_name varchar(18) NULL DEFAULT '', CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL, CHANGE hold_pay_code hold_pay_code varchar(100) NULL DEFAULT '0', CHANGE aadhar_card_no aadhar_card_no varchar(20) NULL DEFAULT '', CHANGE separation_type separation_type varchar(100) NULL DEFAULT '0', CHANGE personal_code personal_code varchar(100) NULL DEFAULT '0', CHANGE employee_code employee_code varchar(10) NULL DEFAULT '', CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0', CHANGE pf pf decimal(15,2) NULL DEFAULT '0', CHANGE emp_cost_code emp_cost_code varchar(100) NULL DEFAULT '0', CHANGE emp_pf_code emp_pf_code varchar(100) NULL DEFAULT '0', CHANGE statutory_code statutory_code varchar(100) NULL DEFAULT '0001', CHANGE network_id network_id varchar(100) NULL DEFAULT '0', CHANGE sap_client_name sap_client_name varchar(100) NULL DEFAULT '0', CHANGE bank_key bank_key varchar(100) NULL DEFAULT '0', CHANGE family_address_code family_address_code varchar(100) NULL DEFAULT '0', CHANGE designation designation varchar(100) NULL DEFAULT '0', CHANGE com_address_code com_address_code varchar(100) NULL DEFAULT '0', CHANGE aadhar_address_code aadhar_address_code varchar(100) NULL DEFAULT '0', CHANGE stop_pay_code stop_pay_code varchar(100) NULL DEFAULT '0', CHANGE blood_group blood_group varchar(100) NULL DEFAULT '0', CHANGE professional_tax_location professional_tax_location varchar(100) NULL DEFAULT '0', CHANGE resignation_date resignation_date date NULL DEFAULT NULL, CHANGE profile_picture profile_picture TEXT NULL;

UPDATE cw_zct_12 SET cw_zct_12_status = "0";

UPDATE cw_zct_12 SET cw_zct_12_status = "1" WHERE FIND_IN_SET(cw_zct_12_value,"Resigned,Abscond,Terminated,Separation");

UPDATE cw_zct_12 SET cw_zct_12_status = "1" WHERE FIND_IN_SET(cw_zct_12_value,"Resigned,Abscond,Terminated,Separation");

UPDATE cw_zct_12 SET cw_zct_12_status = "1" WHERE FIND_IN_SET(cw_zct_12_value,"Resigned,Abscond,Terminated,Separation");

UPDATE cw_zct_12 SET cw_zct_12_status = "1" WHERE FIND_IN_SET(cw_zct_12_value,"Resigned,Abscond,Terminated,Separation");

UPDATE cw_zct_13 SET cw_zct_13_status = "0";

UPDATE cw_zct_13 SET cw_zct_13_status = "1" WHERE FIND_IN_SET(cw_zct_13_value,"Hold For FandF,Hold For other,Unhold,Supplementry Day");

UPDATE cw_zct_13 SET cw_zct_13_status = "1" WHERE FIND_IN_SET(cw_zct_13_value,"Hold For FandF,Hold For other,Unhold,Supplementry Day");

UPDATE cw_zct_13 SET cw_zct_13_status = "1" WHERE FIND_IN_SET(cw_zct_13_value,"Hold For FandF,Hold For other,Unhold,Supplementry Day");

UPDATE cw_zct_13 SET cw_zct_13_status = "1" WHERE FIND_IN_SET(cw_zct_13_value,"Hold For FandF,Hold For other,Unhold,Supplementry Day");

UPDATE cw_zct_26 SET cw_zct_26_status = "0";

UPDATE cw_zct_26 SET cw_zct_26_status = "1" WHERE FIND_IN_SET(cw_zct_26_value,"Not Joining,Resigned,Abscond,Terminated");

UPDATE cw_zct_26 SET cw_zct_26_status = "1" WHERE FIND_IN_SET(cw_zct_26_value,"Not Joining,Resigned,Abscond,Terminated");

UPDATE cw_zct_26 SET cw_zct_26_status = "1" WHERE FIND_IN_SET(cw_zct_26_value,"Not Joining,Resigned,Abscond,Terminated");

UPDATE cw_zct_26 SET cw_zct_26_status = "1" WHERE FIND_IN_SET(cw_zct_26_value,"Not Joining,Resigned,Abscond,Terminated");

UPDATE cw_zct_42 SET cw_zct_42_status = "0";

UPDATE cw_zct_42 SET cw_zct_42_status = "1" WHERE FIND_IN_SET(cw_zct_42_value,"Separated,Rejoined");

UPDATE cw_zct_42 SET cw_zct_42_status = "1" WHERE FIND_IN_SET(cw_zct_42_value,"Separated,Rejoined");

UPDATE cw_zct_49 SET cw_zct_49_status = "0";

UPDATE cw_zct_49 SET cw_zct_49_status = "1" WHERE FIND_IN_SET(cw_zct_49_value,"With Declaration,Without Declaration(New)");

UPDATE cw_zct_49 SET cw_zct_49_status = "1" WHERE FIND_IN_SET(cw_zct_49_value,"With Declaration,Without Declaration(New)");

ALTER TABLE cw_transactions_dlt CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0', CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0', CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0', CHANGE gross gross decimal(15,2) NULL DEFAULT '0', CHANGE da da decimal(15,2) NULL DEFAULT '0', CHANGE hra hra decimal(15,2) NULL DEFAULT '0', CHANGE basic basic decimal(15,2) NULL DEFAULT '0', CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0', CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0', CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0', CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0', CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0', CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0', CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0', CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0', CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0', CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0', CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0', CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0', CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0', CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0', CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0', CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0', CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0', CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0', CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0', CHANGE wt10 wt10 varchar(10) NULL DEFAULT '', CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0', CHANGE payroll payroll varchar(100) NULL DEFAULT '1', CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0', CHANGE wt9 wt9 varchar(10) NULL DEFAULT '', CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0', CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0', CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0', CHANGE role role varchar(100) NULL DEFAULT '0', CHANGE wt8 wt8 varchar(10) NULL DEFAULT '', CHANGE department department varchar(100) NULL DEFAULT '0', CHANGE process_month process_month varchar(100) NULL DEFAULT '0', CHANGE epf epf decimal(15,2) NULL DEFAULT '0', CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0', CHANGE branch branch varchar(100) NULL DEFAULT '0', CHANGE emp_name emp_name varchar(100) NULL DEFAULT '', CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0', CHANGE wt7 wt7 varchar(10) NULL DEFAULT '', CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0', CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0', CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0', CHANGE wt6 wt6 varchar(10) NULL DEFAULT '', CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0', CHANGE wt5 wt5 varchar(10) NULL DEFAULT '', CHANGE tds tds decimal(15,2) NULL DEFAULT '0', CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0', CHANGE wt4 wt4 varchar(10) NULL DEFAULT '', CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0', CHANGE wt3 wt3 varchar(10) NULL DEFAULT '', CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0', CHANGE wt2 wt2 varchar(10) NULL DEFAULT '', CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0', CHANGE wt1 wt1 varchar(10) NULL DEFAULT '', CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0', CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0', CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0', CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0', CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0', CHANGE metro metro varchar(100) NULL DEFAULT '0', CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0', CHANGE esi esi decimal(15,2) NULL DEFAULT '0', CHANGE employee_code employee_code varchar(10) NULL DEFAULT '', CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0', CHANGE pf pf decimal(15,2) NULL DEFAULT '0', CHANGE designation designation varchar(100) NULL DEFAULT '0', CHANGE resignation_date resignation_date date NULL DEFAULT NULL;

ALTER TABLE cw_transactions CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0', CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0', CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0', CHANGE gross gross decimal(15,2) NULL DEFAULT '0', CHANGE da da decimal(15,2) NULL DEFAULT '0', CHANGE hra hra decimal(15,2) NULL DEFAULT '0', CHANGE basic basic decimal(15,2) NULL DEFAULT '0', CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0', CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0', CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0', CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0', CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0', CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0', CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0', CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0', CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0', CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0', CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0', CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0', CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0', CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0', CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0', CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0', CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0', CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0', CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0', CHANGE wt10 wt10 varchar(10) NULL DEFAULT '', CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0', CHANGE payroll payroll varchar(100) NULL DEFAULT '1', CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0', CHANGE wt9 wt9 varchar(10) NULL DEFAULT '', CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0', CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0', CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0', CHANGE role role varchar(100) NULL DEFAULT '0', CHANGE wt8 wt8 varchar(10) NULL DEFAULT '', CHANGE department department varchar(100) NULL DEFAULT '0', CHANGE process_month process_month varchar(100) NULL DEFAULT '0', CHANGE epf epf decimal(15,2) NULL DEFAULT '0', CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0', CHANGE branch branch varchar(100) NULL DEFAULT '0', CHANGE emp_name emp_name varchar(100) NULL DEFAULT '', CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0', CHANGE wt7 wt7 varchar(10) NULL DEFAULT '', CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0', CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0', CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0', CHANGE wt6 wt6 varchar(10) NULL DEFAULT '', CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0', CHANGE wt5 wt5 varchar(10) NULL DEFAULT '', CHANGE tds tds decimal(15,2) NULL DEFAULT '0', CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0', CHANGE wt4 wt4 varchar(10) NULL DEFAULT '', CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0', CHANGE wt3 wt3 varchar(10) NULL DEFAULT '', CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0', CHANGE wt2 wt2 varchar(10) NULL DEFAULT '', CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0', CHANGE wt1 wt1 varchar(10) NULL DEFAULT '', CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0', CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0', CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0', CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0', CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0', CHANGE metro metro varchar(100) NULL DEFAULT '0', CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0', CHANGE esi esi decimal(15,2) NULL DEFAULT '0', CHANGE employee_code employee_code varchar(10) NULL DEFAULT '', CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0', CHANGE pf pf decimal(15,2) NULL DEFAULT '0', CHANGE designation designation varchar(100) NULL DEFAULT '0', CHANGE resignation_date resignation_date date NULL DEFAULT NULL;

ALTER TABLE cw_monthly_input CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0', CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0', CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0', CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0', CHANGE process_month process_month varchar(100) NULL DEFAULT '0', CHANGE emp_name emp_name varchar(100) NULL DEFAULT '', CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0', CHANGE tds tds decimal(15,2) NULL DEFAULT '0', CHANGE date_of_birth date_of_birth date NULL DEFAULT NULL, CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL, CHANGE employee_code employee_code varchar(10) NULL DEFAULT '';

ALTER TABLE cw_tax_ind_cal CHANGE da da decimal(15,2) NULL DEFAULT '0',CHANGE hra hra decimal(15,2) NULL DEFAULT '0',CHANGE basic basic decimal(15,2) NULL DEFAULT '0';

ALTER TABLE cw_custom_employees CHANGE prime_custom_employees_id prime_custom_employees_id int(11) NOT NULL AUTO_INCREMENT,CHANGE role role varchar(100) NULL DEFAULT '0',CHANGE employee_code employee_code varchar(10) NULL DEFAULT '',CHANGE emp_name emp_name varchar(100) NULL DEFAULT '',CHANGE department department varchar(100) NULL DEFAULT '0',CHANGE designation designation varchar(100) NULL DEFAULT '0',CHANGE gender gender varchar(100) NULL DEFAULT '0',CHANGE date_of_birth date_of_birth date NULL DEFAULT NULL,CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL,CHANGE branch branch varchar(100) NULL DEFAULT '0',CHANGE mobile_number mobile_number varchar(10) NULL DEFAULT NULL,CHANGE additional_mobile_number additional_mobile_number varchar(10) NULL DEFAULT NULL,CHANGE company_email_id company_email_id varchar(150) NULL DEFAULT NULL,CHANGE personal_email_id personal_email_id varchar(150) NULL DEFAULT NULL,CHANGE blood_group blood_group varchar(100) NULL DEFAULT '0',CHANGE metro metro varchar(100) NULL DEFAULT '0',CHANGE professional_tax_location professional_tax_location varchar(100) NULL DEFAULT '0',CHANGE esi_location esi_location varchar(100) NULL DEFAULT '0',CHANGE bank_branch bank_branch varchar(200) NULL DEFAULT '',CHANGE pf_account_number pf_account_number varchar(100) NULL DEFAULT '',CHANGE bank_account_number bank_account_number varchar(100) NULL DEFAULT '',CHANGE uan_number uan_number varchar(13) NULL DEFAULT '',CHANGE pan_number pan_number varchar(10) NULL DEFAULT '',CHANGE esi_number esi_number varchar(100) NULL DEFAULT '',CHANGE bank_name bank_name varchar(18) NULL DEFAULT '',CHANGE emp_age emp_age int(10) NULL DEFAULT '0',CHANGE ifsc_code ifsc_code varchar(100) NULL DEFAULT '0',CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0',CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0',CHANGE process_month process_month varchar(100) NULL DEFAULT '0',CHANGE resignation_date resignation_date date NULL DEFAULT NULL,CHANGE resignation_letter_upload resignation_letter_upload TEXT NULL,CHANGE separation_type separation_type varchar(100) NULL DEFAULT '0',CHANGE last_working_date last_working_date date NULL DEFAULT NULL,CHANGE separation_reason separation_reason TEXT NULL,CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0',CHANGE stop_pay_status stop_pay_status varchar(10) NULL DEFAULT '0',CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0',CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0',CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0',CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0',CHANGE pf pf decimal(15,2) NULL DEFAULT '0',CHANGE esi esi decimal(15,2) NULL DEFAULT '0',CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0',CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0',CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0',CHANGE epf epf decimal(15,2) NULL DEFAULT '0',CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0',CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0',CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0',CHANGE user_right user_right varchar(100) NULL DEFAULT '3',CHANGE profile_picture profile_picture TEXT NULL,CHANGE tl_report tl_report varchar(100) NULL DEFAULT '0',CHANGE manager_report manager_report varchar(100) NULL DEFAULT '0',CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0',CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0',CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0',CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0',CHANGE basic basic decimal(15,2) NULL DEFAULT '0',CHANGE da da decimal(15,2) NULL DEFAULT '0',CHANGE hra hra decimal(15,2) NULL DEFAULT '0',CHANGE gross gross decimal(15,2) NULL DEFAULT '0',CHANGE manager_status manager_status varchar(100) NULL DEFAULT '1',CHANGE manager_reason manager_reason varchar(100) NULL DEFAULT '0',CHANGE manager_remark manager_remark TEXT NULL,CHANGE hr_status hr_status varchar(100) NULL DEFAULT '1',CHANGE hr_remark hr_remark TEXT NULL,CHANGE id_proof id_proof TEXT NULL,CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0',CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0',CHANGE payroll payroll varchar(100) NULL DEFAULT '1',CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0',CHANGE stop_pay_remarks stop_pay_remarks TEXT NULL,CHANGE branch_hr branch_hr varchar(100) NULL DEFAULT '0',CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0',CHANGE increment_approve_type increment_approve_type varchar(100) NULL DEFAULT '1',CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0',CHANGE tds tds decimal(15,2) NULL DEFAULT '0',CHANGE first_level_approval first_level_approval varchar(100) NULL DEFAULT '0',CHANGE second_level_approval second_level_approval varchar(100) NULL DEFAULT '0',CHANGE approve_type approve_type varchar(100) NULL DEFAULT '1',CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0',CHANGE increment_first_level increment_first_level varchar(100) NULL DEFAULT '0',CHANGE increment_second_level increment_second_level varchar(100) NULL DEFAULT '0',CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0',CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0',CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0',CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0',CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0',CHANGE increment_third_level increment_third_level varchar(100) NULL DEFAULT '0',CHANGE income_tax_type income_tax_type varchar(100) NULL DEFAULT '0',CHANGE personal_code personal_code varchar(100) NULL DEFAULT '0',CHANGE emp_group_code emp_group_code varchar(100) NULL DEFAULT '0',CHANGE sub_group_code sub_group_code varchar(100) NULL DEFAULT '0',CHANGE sub_group_name sub_group_name varchar(100) NULL DEFAULT '0',CHANGE ptax_code ptax_code varchar(100) NULL DEFAULT '0',CHANGE title_code title_code varchar(100) NULL DEFAULT '0',CHANGE emp_firstname emp_firstname varchar(25) NULL DEFAULT '',CHANGE country_code country_code varchar(100) NULL DEFAULT '0',CHANGE marital_code marital_code varchar(100) NULL DEFAULT '0',CHANGE emp_street_no emp_street_no varchar(30) NULL DEFAULT '',CHANGE emp_pincode emp_pincode varchar(10) NULL DEFAULT '',CHANGE emp_location emp_location varchar(25) NULL DEFAULT '',CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0',CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0',CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0',CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0',CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0',CHANGE wt1 wt1 varchar(10) NULL DEFAULT '',CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0',CHANGE wt2 wt2 varchar(10) NULL DEFAULT '',CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0',CHANGE wt3 wt3 varchar(10) NULL DEFAULT '',CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0',CHANGE wt4 wt4 varchar(10) NULL DEFAULT '',CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0',CHANGE wt5 wt5 varchar(10) NULL DEFAULT '',CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0',CHANGE wt6 wt6 varchar(10) NULL DEFAULT '',CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0',CHANGE wt7 wt7 varchar(10) NULL DEFAULT '',CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0',CHANGE wt8 wt8 varchar(10) NULL DEFAULT '',CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0',CHANGE wt9 wt9 varchar(10) NULL DEFAULT '',CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0',CHANGE wt10 wt10 varchar(10) NULL DEFAULT '',CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0',CHANGE pay_code pay_code varchar(100) NULL DEFAULT '0',CHANGE emp_cost_code emp_cost_code varchar(100) NULL DEFAULT '0',CHANGE emp_company_code emp_company_code varchar(100) NULL DEFAULT '0',CHANGE emp_cost_center_code emp_cost_center_code varchar(100) NULL DEFAULT '0',CHANGE emp_percentage emp_percentage decimal(15,2) NULL DEFAULT '0',CHANGE emp_pf_code emp_pf_code varchar(100) NULL DEFAULT '0',CHANGE emp_pf_no emp_pf_no varchar(20) NULL DEFAULT '',CHANGE emp_uan emp_uan varchar(20) NULL DEFAULT '',CHANGE statutory_code statutory_code varchar(100) NULL DEFAULT '0001',CHANGE emp_esi_no emp_esi_no varchar(20) NULL DEFAULT '',CHANGE emp_aadhar_name emp_aadhar_name varchar(30) NULL DEFAULT '',CHANGE challange_code challange_code varchar(100) NULL DEFAULT '0',CHANGE network_id network_id varchar(100) NULL DEFAULT '0',CHANGE activity_no activity_no varchar(100) NULL DEFAULT '0',CHANGE sap_client_name sap_client_name varchar(100) NULL DEFAULT '0',CHANGE pf_celling pf_celling varchar(50) NULL DEFAULT '',CHANGE wci_code wci_code varchar(100) NULL DEFAULT '0',CHANGE action_code action_code varchar(100) NULL DEFAULT '0',CHANGE action_reason action_reason varchar(100) NULL DEFAULT '0',CHANGE emp_address_code emp_address_code varchar(100) NULL DEFAULT '0',CHANGE bank_key bank_key varchar(100) NULL DEFAULT '0',CHANGE family_address_code family_address_code varchar(100) NULL DEFAULT '0',CHANGE family_first_name family_first_name varchar(25) NULL DEFAULT '',CHANGE family_gender_code family_gender_code varchar(100) NULL DEFAULT '0',CHANGE emp_esi_location emp_esi_location varchar(40) NULL DEFAULT '',CHANGE com_address_code com_address_code varchar(100) NULL DEFAULT '0',CHANGE aadhar_address_code aadhar_address_code varchar(100) NULL DEFAULT '0',CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0',CHANGE stop_pay_code stop_pay_code varchar(100) NULL DEFAULT '0',CHANGE hold_pay_code hold_pay_code varchar(100) NULL DEFAULT '0',CHANGE info_passed_by info_passed_by varchar(40) NULL DEFAULT '',CHANGE info_passed_on info_passed_on date NULL DEFAULT NULL,CHANGE mode_code mode_code varchar(100) NULL DEFAULT '0',CHANGE hold_reason hold_reason varchar(40) NULL DEFAULT '',CHANGE sap_status sap_status varchar(100) NULL DEFAULT '2',CHANGE aadhar_card_no aadhar_card_no varchar(20) NULL DEFAULT '',CHANGE sap_remarks sap_remarks varchar(50) NULL DEFAULT '',CHANGE sap_code_status sap_code_status int(10) NULL DEFAULT '0';

ALTER TABLE cw_custom_employees_log CHANGE prime_custom_employees_log_id prime_custom_employees_log_id int(11) NOT NULL AUTO_INCREMENT,CHANGE role role varchar(100) NULL DEFAULT '0',CHANGE employee_code employee_code varchar(10) NULL DEFAULT '',CHANGE emp_name emp_name varchar(100) NULL DEFAULT '',CHANGE department department varchar(100) NULL DEFAULT '0',CHANGE designation designation varchar(100) NULL DEFAULT '0',CHANGE gender gender varchar(100) NULL DEFAULT '0',CHANGE date_of_birth date_of_birth date NULL DEFAULT NULL,CHANGE date_of_joining date_of_joining date NULL DEFAULT NULL,CHANGE branch branch varchar(100) NULL DEFAULT '0',CHANGE mobile_number mobile_number varchar(10) NULL DEFAULT NULL,CHANGE additional_mobile_number additional_mobile_number varchar(10) NULL DEFAULT NULL,CHANGE company_email_id company_email_id varchar(150) NULL DEFAULT NULL,CHANGE personal_email_id personal_email_id varchar(150) NULL DEFAULT NULL,CHANGE blood_group blood_group varchar(100) NULL DEFAULT '0',CHANGE metro metro varchar(100) NULL DEFAULT '0',CHANGE professional_tax_location professional_tax_location varchar(100) NULL DEFAULT '0',CHANGE esi_location esi_location varchar(100) NULL DEFAULT '0',CHANGE bank_branch bank_branch varchar(200) NULL DEFAULT '',CHANGE pf_account_number pf_account_number varchar(100) NULL DEFAULT '',CHANGE bank_account_number bank_account_number varchar(100) NULL DEFAULT '',CHANGE uan_number uan_number varchar(13) NULL DEFAULT '',CHANGE pan_number pan_number varchar(10) NULL DEFAULT '',CHANGE esi_number esi_number varchar(100) NULL DEFAULT '',CHANGE bank_name bank_name varchar(18) NULL DEFAULT '',CHANGE emp_age emp_age int(10) NULL DEFAULT '0',CHANGE ifsc_code ifsc_code varchar(100) NULL DEFAULT '0',CHANGE total_deductions total_deductions decimal(15,2) NULL DEFAULT '0',CHANGE pt_projection pt_projection decimal(15,2) NULL DEFAULT '0',CHANGE process_month process_month varchar(100) NULL DEFAULT '0',CHANGE resignation_date resignation_date date NULL DEFAULT NULL,CHANGE resignation_letter_upload resignation_letter_upload TEXT NULL,CHANGE separation_type separation_type varchar(100) NULL DEFAULT '0',CHANGE last_working_date last_working_date date NULL DEFAULT NULL,CHANGE separation_reason separation_reason TEXT NULL,CHANGE termination_status termination_status varchar(10) NULL DEFAULT '0',CHANGE stop_pay_status stop_pay_status varchar(10) NULL DEFAULT '0',CHANGE total_earnings total_earnings decimal(15,2) NULL DEFAULT '0',CHANGE paid_days paid_days decimal(15,2) NULL DEFAULT '0',CHANGE lop_days lop_days decimal(15,2) NULL DEFAULT '0',CHANGE month_days month_days decimal(15,2) NULL DEFAULT '0',CHANGE pf pf decimal(15,2) NULL DEFAULT '0',CHANGE esi esi decimal(15,2) NULL DEFAULT '0',CHANGE professional_tax professional_tax decimal(15,2) NULL DEFAULT '0',CHANGE pf_gross pf_gross decimal(15,2) NULL DEFAULT '0',CHANGE esi_gross esi_gross decimal(15,2) NULL DEFAULT '0',CHANGE epf epf decimal(15,2) NULL DEFAULT '0',CHANGE fpf fpf decimal(15,2) NULL DEFAULT '0',CHANGE epf_gross epf_gross decimal(15,2) NULL DEFAULT '0',CHANGE fpf_gross fpf_gross decimal(15,2) NULL DEFAULT '0',CHANGE user_right user_right varchar(100) NULL DEFAULT '3',CHANGE profile_picture profile_picture TEXT NULL,CHANGE tl_report tl_report varchar(100) NULL DEFAULT '0',CHANGE manager_report manager_report varchar(100) NULL DEFAULT '0',CHANGE fixed_basic fixed_basic decimal(15,2) NULL DEFAULT '0',CHANGE fixed_da fixed_da decimal(15,2) NULL DEFAULT '0',CHANGE fixed_hra fixed_hra decimal(15,2) NULL DEFAULT '0',CHANGE fixed_gross fixed_gross decimal(15,2) NULL DEFAULT '0',CHANGE basic basic decimal(15,2) NULL DEFAULT '0',CHANGE da da decimal(15,2) NULL DEFAULT '0',CHANGE hra hra decimal(15,2) NULL DEFAULT '0',CHANGE gross gross decimal(15,2) NULL DEFAULT '0',CHANGE manager_status manager_status varchar(100) NULL DEFAULT '1',CHANGE manager_reason manager_reason varchar(100) NULL DEFAULT '0',CHANGE manager_remark manager_remark TEXT NULL,CHANGE hr_status hr_status varchar(100) NULL DEFAULT '1',CHANGE hr_remark hr_remark TEXT NULL,CHANGE id_proof id_proof TEXT NULL,CHANGE emi_loan emi_loan decimal(15,2) NULL DEFAULT '0',CHANGE differential_deduction differential_deduction decimal(15,2) NULL DEFAULT '0',CHANGE payroll payroll varchar(100) NULL DEFAULT '1',CHANGE other_deduction other_deduction decimal(15,2) NULL DEFAULT '0',CHANGE stop_pay_remarks stop_pay_remarks TEXT NULL,CHANGE branch_hr branch_hr varchar(100) NULL DEFAULT '0',CHANGE emp_esi emp_esi decimal(15,2) NULL DEFAULT '0',CHANGE increment_approve_type increment_approve_type varchar(100) NULL DEFAULT '1',CHANGE gratuity gratuity decimal(15,2) NULL DEFAULT '0',CHANGE tds tds decimal(15,2) NULL DEFAULT '0',CHANGE first_level_approval first_level_approval varchar(100) NULL DEFAULT '0',CHANGE second_level_approval second_level_approval varchar(100) NULL DEFAULT '0',CHANGE approve_type approve_type varchar(100) NULL DEFAULT '1',CHANGE monthly_tds monthly_tds decimal(15,2) NULL DEFAULT '0',CHANGE increment_first_level increment_first_level varchar(100) NULL DEFAULT '0',CHANGE increment_second_level increment_second_level varchar(100) NULL DEFAULT '0',CHANGE incentive incentive decimal(15,2) NULL DEFAULT '0',CHANGE differential_day differential_day decimal(15,2) NULL DEFAULT '0',CHANGE separation_day separation_day decimal(15,2) NULL DEFAULT '0',CHANGE total_esi total_esi decimal(15,2) NULL DEFAULT '0',CHANGE total_pf total_pf decimal(15,2) NULL DEFAULT '0',CHANGE increment_third_level increment_third_level varchar(100) NULL DEFAULT '0',CHANGE income_tax_type income_tax_type varchar(100) NULL DEFAULT '0',CHANGE personal_code personal_code varchar(100) NULL DEFAULT '0',CHANGE emp_group_code emp_group_code varchar(100) NULL DEFAULT '0',CHANGE sub_group_code sub_group_code varchar(100) NULL DEFAULT '0',CHANGE sub_group_name sub_group_name varchar(100) NULL DEFAULT '0',CHANGE ptax_code ptax_code varchar(100) NULL DEFAULT '0',CHANGE title_code title_code varchar(100) NULL DEFAULT '0',CHANGE emp_firstname emp_firstname varchar(25) NULL DEFAULT '',CHANGE country_code country_code varchar(100) NULL DEFAULT '0',CHANGE marital_code marital_code varchar(100) NULL DEFAULT '0',CHANGE emp_street_no emp_street_no varchar(30) NULL DEFAULT '',CHANGE emp_pincode emp_pincode varchar(10) NULL DEFAULT '',CHANGE emp_location emp_location varchar(25) NULL DEFAULT '',CHANGE work_schedule_rule work_schedule_rule varchar(100) NULL DEFAULT '0',CHANGE pay_scale_type pay_scale_type varchar(100) NULL DEFAULT '0',CHANGE pay_scale_area pay_scale_area varchar(100) NULL DEFAULT '0',CHANGE pay_scale_group pay_scale_group varchar(100) NULL DEFAULT '0',CHANGE emp_working_hours emp_working_hours decimal(15,2) NULL DEFAULT '0',CHANGE wt1 wt1 varchar(10) NULL DEFAULT '',CHANGE wt1amt wt1amt decimal(15,2) NULL DEFAULT '0',CHANGE wt2 wt2 varchar(10) NULL DEFAULT '',CHANGE wt2amt wt2amt decimal(15,2) NULL DEFAULT '0',CHANGE wt3 wt3 varchar(10) NULL DEFAULT '',CHANGE wt3amt wt3amt decimal(15,2) NULL DEFAULT '0',CHANGE wt4 wt4 varchar(10) NULL DEFAULT '',CHANGE wt4amt wt4amt decimal(15,2) NULL DEFAULT '0',CHANGE wt5 wt5 varchar(10) NULL DEFAULT '',CHANGE wt5amt wt5amt decimal(15,2) NULL DEFAULT '0',CHANGE wt6 wt6 varchar(10) NULL DEFAULT '',CHANGE wt6amt wt6amt decimal(15,2) NULL DEFAULT '0',CHANGE wt7 wt7 varchar(10) NULL DEFAULT '',CHANGE wt7amt wt7amt decimal(15,2) NULL DEFAULT '0',CHANGE wt8 wt8 varchar(10) NULL DEFAULT '',CHANGE wt8amt wt8amt decimal(15,2) NULL DEFAULT '0',CHANGE wt9 wt9 varchar(10) NULL DEFAULT '',CHANGE wt9amt wt9amt decimal(15,2) NULL DEFAULT '0',CHANGE wt10 wt10 varchar(10) NULL DEFAULT '',CHANGE wt10amt wt10amt decimal(15,2) NULL DEFAULT '0',CHANGE pay_code pay_code varchar(100) NULL DEFAULT '0',CHANGE emp_cost_code emp_cost_code varchar(100) NULL DEFAULT '0',CHANGE emp_company_code emp_company_code varchar(100) NULL DEFAULT '0',CHANGE emp_cost_center_code emp_cost_center_code varchar(100) NULL DEFAULT '0',CHANGE emp_percentage emp_percentage decimal(15,2) NULL DEFAULT '0',CHANGE emp_pf_code emp_pf_code varchar(100) NULL DEFAULT '0',CHANGE emp_pf_no emp_pf_no varchar(20) NULL DEFAULT '',CHANGE emp_uan emp_uan varchar(20) NULL DEFAULT '',CHANGE statutory_code statutory_code varchar(100) NULL DEFAULT '0001',CHANGE emp_esi_no emp_esi_no varchar(20) NULL DEFAULT '',CHANGE emp_aadhar_name emp_aadhar_name varchar(30) NULL DEFAULT '',CHANGE challange_code challange_code varchar(100) NULL DEFAULT '0',CHANGE network_id network_id varchar(100) NULL DEFAULT '0',CHANGE activity_no activity_no varchar(100) NULL DEFAULT '0',CHANGE sap_client_name sap_client_name varchar(100) NULL DEFAULT '0',CHANGE pf_celling pf_celling varchar(50) NULL DEFAULT '',CHANGE wci_code wci_code varchar(100) NULL DEFAULT '0',CHANGE action_code action_code varchar(100) NULL DEFAULT '0',CHANGE action_reason action_reason varchar(100) NULL DEFAULT '0',CHANGE emp_address_code emp_address_code varchar(100) NULL DEFAULT '0',CHANGE bank_key bank_key varchar(100) NULL DEFAULT '0',CHANGE family_address_code family_address_code varchar(100) NULL DEFAULT '0',CHANGE family_first_name family_first_name varchar(25) NULL DEFAULT '',CHANGE family_gender_code family_gender_code varchar(100) NULL DEFAULT '0',CHANGE emp_esi_location emp_esi_location varchar(40) NULL DEFAULT '',CHANGE com_address_code com_address_code varchar(100) NULL DEFAULT '0',CHANGE aadhar_address_code aadhar_address_code varchar(100) NULL DEFAULT '0',CHANGE net_pay net_pay decimal(15,2) NULL DEFAULT '0',CHANGE stop_pay_code stop_pay_code varchar(100) NULL DEFAULT '0',CHANGE hold_pay_code hold_pay_code varchar(100) NULL DEFAULT '0',CHANGE info_passed_by info_passed_by varchar(40) NULL DEFAULT '',CHANGE info_passed_on info_passed_on date NULL DEFAULT NULL,CHANGE mode_code mode_code varchar(100) NULL DEFAULT '0',CHANGE hold_reason hold_reason varchar(40) NULL DEFAULT '',CHANGE sap_status sap_status varchar(100) NULL DEFAULT '2',CHANGE aadhar_card_no aadhar_card_no varchar(20) NULL DEFAULT '',CHANGE sap_remarks sap_remarks varchar(50) NULL DEFAULT '',CHANGE sap_code_status sap_code_status int(10) NULL DEFAULT '0';

UPDATE cw_form_for_input SET trans_status = 0 , trans_deleted_by = "1",trans_deleted_date = DATE_FORMAT(NOW(), "%Y-%m-%d %H:%i:%S") WHERE input_for_cond_id = "3" and input_for_cond_module_id = "employees" and line_input_for NOT IN("date_of_birth");

UPDATE cw_form_bind_input SET trans_status = 0 , trans_deleted_by = "1",trans_deleted_date = DATE_FORMAT(NOW(), "%Y-%m-%d %H:%i:%S") WHERE input_cond_id = "3" and input_cond_module_id = "employees" and line_input_bind_to NOT IN("emp_age");

UPDATE `cw_form_condition_formula` SET tab_sort = "1" where trans_status = 1 and cond_module_id = "employees" and condition_bind_to = "emp_age"
@ Telegram