INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,sms_setting,email_setting,left_freeze,right_freeze,menu_type,menu_icon,trans_created_by, trans_created_date) VALUES ("214","employee_self_portal","Employee Self Portal","custome","5","3","1,2,3,4","1,2","1","","","","","","","3","3","2","","1","2023-01-03 12:46:48");

INSERT INTO cw_permissions (permission_id, module_id) VALUES ("employee_self_portal","employee_self_portal");

INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("employee_self_portal","1","1","1","1","1","1","1");

INSERT INTO cw_modules (sort, module_id,module_name,module_type,menu_id,sub_menu_id,module_for,rights_to,show_module,quicklink,import_module,pdf_module,custom_module,sms_setting,email_setting,left_freeze,right_freeze,menu_type,menu_icon,trans_created_by, trans_created_date) VALUES ("215","audit_trial","Audit Trial","custome","5","3","1,2,3,4","1,2","1","","","","","","","3","3","2","","1","2023-01-03 12:48:50");

INSERT INTO cw_permissions (permission_id, module_id) VALUES ("audit_trial","audit_trial");

INSERT INTO cw_grants (permission_id, prime_employees_id, access_add, access_update,access_delete,access_search,access_export,access_import) VALUES ("audit_trial","1","1","1","1","1","1","1");

INSERT INTO cw_form_view_setting 
			(prime_view_module_id,form_view_type,form_view_type_mode,form_view_label_name,form_view_heading,form_view_for,view_user_right,form_view_show,form_view_sort,
			trans_created_by,trans_created_date) VALUES ('audit_trial','2','','audit_trial_details','audit trial details','1,2,3,4','1,2,4,6,7,8,10,11,12,13','1','1','1','2023-01-04 12:25:12');

UPDATE cw_form_setting SET input_view_type = '2' WHERE input_for = '18970';

INSERT INTO cw_form_setting (input_view_type,input_for,prime_module_id,field_type,label_name,view_name,short_name,text_type,date_type,field_length,field_decimals,pick_list,field_isdefault,default_value,mandatory_field,unique_field,field_show,field_sort,pick_list_type,pick_list_import,pick_table,dependent_pick_list,dependent_pick_input,table_column1,table_column2,auto_prime_id,auto_dispaly_value,field_for,user_right_for,file_type,upload_extension,upload_file_size,pick_display_value,table_show,search_show,transaction_type,gross_check,taxable_check,earn_month_check,earn_payroll_check,ded_payroll_check,benefit_check,increment_check,arrear_pf_check,fandf_check,deduction_check,deduction_month_check,loan_check,uniform_check,edit_read,picklist_data,duplicate_data,onboard_input,trans_created_by,trans_created_date) VALUES ('2','242','audit_trial','1','employee_code','Employee Code','employee code','2','0','50','0',' ','1','','1','0','1','1','0','2',' ','2','','','',' ',' ','1,2,3,4','1,2,4,6,7,8,10,11,12,13','','','0','','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','2023-01-04 12:32:38');

CREATE TABLE IF NOT EXISTS cw_audit_trial(prime_audit_trial_id int(11) NOT NULL AUTO_INCREMENT,employee_code varchar(50) NULL DEFAULT '', trans_created_by INT(11) NULL DEFAULT '0', trans_created_date DATETIME NULL DEFAULT NULL, trans_updated_by INT(11) NULL DEFAULT '0', trans_updated_date DATETIME NULL DEFAULT NULL, trans_deleted_by INT(11) NULL DEFAULT '0', trans_deleted_date DATETIME NULL DEFAULT NULL,trans_status INT(11) NULL DEFAULT '1',PRIMARY KEY (`prime_audit_trial_id`));

INSERT INTO cw_form_setting (input_view_type,input_for,prime_module_id,field_type,label_name,view_name,short_name,text_type,date_type,field_length,field_decimals,pick_list,field_isdefault,default_value,mandatory_field,unique_field,field_show,field_sort,pick_list_type,pick_list_import,pick_table,dependent_pick_list,dependent_pick_input,table_column1,table_column2,auto_prime_id,auto_dispaly_value,field_for,user_right_for,file_type,upload_extension,upload_file_size,pick_display_value,table_show,search_show,transaction_type,gross_check,taxable_check,earn_month_check,earn_payroll_check,ded_payroll_check,benefit_check,increment_check,arrear_pf_check,fandf_check,deduction_check,deduction_month_check,loan_check,uniform_check,edit_read,picklist_data,duplicate_data,onboard_input,trans_created_by,trans_created_date) VALUES ('2','242','audit_trial','1','emp_name','EMPLOYEE NAME','EMPLOYEE NAME','2','0','100','0',' ','1','','1','0','1','2','0','2',' ','2','','','',' ',' ','1,2,3,4','1,2,4,6,7,8,10,11,12,13','','','0','','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','2023-01-04 12:33:46');

ALTER TABLE cw_audit_trial CHANGE prime_audit_trial_id prime_audit_trial_id int(11) NOT NULL AUTO_INCREMENT,ADD emp_name varchar(100) NULL DEFAULT '' AFTER employee_code,CHANGE employee_code employee_code varchar(50) NULL DEFAULT '';

INSERT INTO cw_form_setting (input_view_type,input_for,prime_module_id,field_type,label_name,view_name,short_name,text_type,date_type,field_length,field_decimals,pick_list,field_isdefault,default_value,mandatory_field,unique_field,field_show,field_sort,pick_list_type,pick_list_import,pick_table,dependent_pick_list,dependent_pick_input,table_column1,table_column2,auto_prime_id,auto_dispaly_value,field_for,user_right_for,file_type,upload_extension,upload_file_size,pick_display_value,table_show,search_show,transaction_type,gross_check,taxable_check,earn_month_check,earn_payroll_check,ded_payroll_check,benefit_check,increment_check,arrear_pf_check,fandf_check,deduction_check,deduction_month_check,loan_check,uniform_check,edit_read,picklist_data,duplicate_data,onboard_input,trans_created_by,trans_created_date) VALUES ('2','242','audit_trial','5','audit_status','Audit Status','Audit status','0','0','0','0','prime_approval_status_id,approval_status_value','1','0','1','0','1','3','1','2','cw_approval_status','2','','','',' ',' ','1,2,3,4','1,2,4,6,7,8,10,11,12,13','','','0','approval_status_value','1','1','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','2023-01-04 12:36:05');

ALTER TABLE cw_audit_trial CHANGE prime_audit_trial_id prime_audit_trial_id int(11) NOT NULL AUTO_INCREMENT,ADD audit_status varchar(100) NULL DEFAULT '0' AFTER emp_name,CHANGE emp_name emp_name varchar(100) NULL DEFAULT '',CHANGE employee_code employee_code varchar(50) NULL DEFAULT '';

UPDATE cw_form_setting SET input_view_type = '2',input_for = '242',prime_module_id = 'audit_trial' ,field_type = '5',label_name = 'audit_status',view_name = 'Audit Status',short_name = 'Audit status',text_type = '0',date_type = '0',field_length = '0',field_decimals = '0',pick_list = 'prime_approval_status_id,approval_status_value',pick_list_type = '1',pick_list_import = '2',pick_table = 'cw_approval_status',dependent_pick_list = '2',dependent_pick_input = '',table_column1 = '',table_column2 = '',auto_prime_id = ' ',auto_dispaly_value = ' ',field_isdefault = '1',default_value = '1',mandatory_field = '1',unique_field = '0',pick_display_value = 'approval_status_value',field_show = '1',field_for = '1,2,3,4',user_right_for = '1,2,4,6,7,8,10,11,12,13',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',onboard_input = '0',trans_updated_by = '1',trans_updated_date = '2023-01-04 15:54:00' WHERE prime_form_id = '2023';

ALTER TABLE cw_audit_trial CHANGE prime_audit_trial_id prime_audit_trial_id int(11) NOT NULL AUTO_INCREMENT,CHANGE audit_status audit_status varchar(100) NULL DEFAULT '1',CHANGE emp_name emp_name varchar(100) NULL DEFAULT '',CHANGE employee_code employee_code varchar(50) NULL DEFAULT '';

UPDATE cw_form_setting SET input_view_type = '2',input_for = '242',prime_module_id = 'audit_trial' ,field_type = '1',label_name = 'emp_name',view_name = 'Employee Name',short_name = 'Employee Name',text_type = '2',date_type = '0',field_length = '100',field_decimals = '0',pick_list = ' ',pick_list_type = '0',pick_list_import = '2',pick_table = ' ',dependent_pick_list = '2',dependent_pick_input = '',table_column1 = '',table_column2 = '',auto_prime_id = ' ',auto_dispaly_value = ' ',field_isdefault = '1',default_value = '',mandatory_field = '1',unique_field = '0',pick_display_value = '',field_show = '1',field_for = '1,2,3,4',user_right_for = '1,2,4,6,7,8,10,11,12,13',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',onboard_input = '0',trans_updated_by = '1',trans_updated_date = '2023-01-04 16:56:57' WHERE prime_form_id = '2022';

ALTER TABLE cw_audit_trial CHANGE prime_audit_trial_id prime_audit_trial_id int(11) NOT NULL AUTO_INCREMENT,CHANGE audit_status audit_status varchar(100) NULL DEFAULT '1',CHANGE emp_name emp_name varchar(100) NULL DEFAULT '',CHANGE employee_code employee_code varchar(50) NULL DEFAULT '';

UPDATE cw_form_setting SET input_view_type = '2',input_for = '242',prime_module_id = 'audit_trial' ,field_type = '5',label_name = 'audit_status',view_name = 'Audit Status',short_name = 'Audit status',text_type = '0',date_type = '0',field_length = '0',field_decimals = '0',pick_list = 'prime_manager_status_id,manager_status',pick_list_type = '1',pick_list_import = '2',pick_table = 'cw_manager_status',dependent_pick_list = '2',dependent_pick_input = '',table_column1 = '',table_column2 = '',auto_prime_id = ' ',auto_dispaly_value = ' ',field_isdefault = '1',default_value = '1',mandatory_field = '1',unique_field = '0',pick_display_value = 'manager_status',field_show = '1',field_for = '1,2,3,4',user_right_for = '1,2,4,6,7,8,10,11,12,13',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',onboard_input = '0',trans_updated_by = '1',trans_updated_date = '2023-01-04 17:48:18' WHERE prime_form_id = '2023';

ALTER TABLE cw_audit_trial CHANGE prime_audit_trial_id prime_audit_trial_id int(11) NOT NULL AUTO_INCREMENT,CHANGE audit_status audit_status varchar(100) NULL DEFAULT '1',CHANGE emp_name emp_name varchar(100) NULL DEFAULT '',CHANGE employee_code employee_code varchar(50) NULL DEFAULT '';

INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("audit_trial","1","and cw_audit_trial.audit_status in(^1^)","1","2023-01-06 10:16:47");

INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("audit_trial","2","and cw_audit_trial.audit_status in(^1^)","1","2023-01-06 10:17:24");

INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("audit_trial","4","and cw_audit_trial.audit_status in(^1^)","1","2023-01-06 10:17:32");

INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("audit_trial","6","and cw_audit_trial.audit_status in(^1^)","1","2023-01-06 10:17:49");

INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("audit_trial","7","and cw_audit_trial.audit_status in(^1^)","1","2023-01-06 10:17:55");

INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("audit_trial","12","and cw_audit_trial.audit_status in(^1^)","1","2023-01-06 10:18:05");

INSERT INTO cw_form_table_search (query_module_id, query_for,where_condition,trans_created_by, trans_created_date) VALUES ("audit_trial","13","and cw_audit_trial.audit_status in(^1^)","1","2023-01-06 10:18:15");

UPDATE  cw_form_table_search SET query_module_id = "audit_trial",query_for = "1",where_condition = "and cw_audit_trial.audit_status in(^1^)  and  ^@logged_user_role@^= 1",trans_updated_by = "1",trans_updated_date = "2023-01-06 03:52:32" where prime_table_id = "48";

UPDATE  cw_form_table_search SET query_module_id = "audit_trial",query_for = "1",where_condition = "and cw_audit_trial.audit_status in(^1^)",trans_updated_by = "1",trans_updated_date = "2023-01-06 03:54:36" where prime_table_id = "48";

INSERT INTO cw_form_setting (input_view_type,input_for,prime_module_id,field_type,label_name,view_name,short_name,text_type,date_type,field_length,field_decimals,pick_list,field_isdefault,default_value,mandatory_field,unique_field,field_show,field_sort,pick_list_type,pick_list_import,pick_table,dependent_pick_list,dependent_pick_input,table_column1,table_column2,auto_prime_id,auto_dispaly_value,field_for,user_right_for,file_type,upload_extension,upload_file_size,pick_display_value,table_show,search_show,transaction_type,gross_check,taxable_check,earn_month_check,earn_payroll_check,ded_payroll_check,benefit_check,increment_check,arrear_pf_check,fandf_check,deduction_check,deduction_month_check,loan_check,uniform_check,edit_read,picklist_data,duplicate_data,onboard_input,trans_created_by,trans_created_date) VALUES ('2','100','company_information','5','self_edit_checker','Self Edit Checker','Self Edit Checker','0','0','0','0','prime_user_role_id,role_name','1','0','1','0','1','24','1','2','cw_user_role','2','','','',' ',' ','1,2,3,4','1,2,4,6,7,8,10,11,12,13','','','0','role_name','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','1','2023-01-06 15:59:57');

ALTER TABLE cw_company_information CHANGE prime_company_information_id prime_company_information_id int(11) NOT NULL AUTO_INCREMENT,ADD self_edit_checker varchar(100) NULL DEFAULT '0' AFTER confirm_period,CHANGE password_column password_column varchar(50) NULL DEFAULT '0',CHANGE max_effective_months max_effective_months int(10) NULL DEFAULT '0',CHANGE maximum_age maximum_age int(10) NULL DEFAULT '60',CHANGE minimum_age minimum_age int(10) NULL DEFAULT '18',CHANGE creation creation varchar(100) NULL DEFAULT '0',CHANGE manager_approval manager_approval varchar(100) NULL DEFAULT '0',CHANGE hr_approval hr_approval varchar(100) NULL DEFAULT '0',CHANGE increment_type increment_type varchar(100) NULL DEFAULT '0',CHANGE company_logo company_logo TEXT NULL,CHANGE pan pan varchar(20) NULL DEFAULT '',CHANGE gstin gstin varchar(50) NULL DEFAULT '',CHANGE website website varchar(255) NULL DEFAULT '',CHANGE country country varchar(100) NULL DEFAULT '',CHANGE state state varchar(100) NULL DEFAULT '',CHANGE city city varchar(100) NULL DEFAULT '',CHANGE address address TEXT NULL,CHANGE fax fax varchar(255) NULL DEFAULT '',CHANGE confirm_period confirm_period varchar(50) NULL DEFAULT '6',CHANGE email email varchar(255) NULL DEFAULT '',CHANGE allow_future_date allow_future_date int(10) NULL DEFAULT '0',CHANGE land_line land_line varchar(255) NULL DEFAULT '',CHANGE allow_past_date allow_past_date int(10) NULL DEFAULT '0',CHANGE alt_mobile_number alt_mobile_number varchar(255) NULL DEFAULT '',CHANGE send_otp_url send_otp_url varchar(250) NULL DEFAULT '',CHANGE sms_password sms_password varchar(50) NULL DEFAULT '',CHANGE mobile_number mobile_number varchar(10) NULL DEFAULT '',CHANGE generate_otp_url generate_otp_url varchar(250) NULL DEFAULT '',CHANGE payslip_based_on payslip_based_on varchar(100) NULL DEFAULT '0',CHANGE sms_username sms_username varchar(50) NULL DEFAULT '',CHANGE secondary_color secondary_color varchar(50) NULL DEFAULT '',CHANGE company_short_name company_short_name varchar(255) NULL DEFAULT '',CHANGE payroll_process_type payroll_process_type varchar(100) NULL DEFAULT 'role',CHANGE aadhar_token aadhar_token TEXT NULL,CHANGE sms_sender_id sms_sender_id varchar(50) NULL DEFAULT '',CHANGE primary_color primary_color varchar(50) NULL DEFAULT '',CHANGE company_name company_name varchar(255) NULL DEFAULT '',CHANGE mi_process_type mi_process_type varchar(100) NULL DEFAULT 'role',CHANGE aadhar_validation aadhar_validation varchar(100) NULL DEFAULT '2',CHANGE sms_url sms_url varchar(50) NULL DEFAULT '';

UPDATE cw_zct_23 SET cw_zct_23_status = "0";

UPDATE cw_zct_23 SET cw_zct_23_status = "1" WHERE FIND_IN_SET(cw_zct_23_value,"payroll");

UPDATE cw_zct_24 SET cw_zct_24_status = "0";

UPDATE cw_zct_24 SET cw_zct_24_status = "1" WHERE FIND_IN_SET(cw_zct_24_value,"payroll");

UPDATE cw_zct_25 SET cw_zct_25_status = "0";

UPDATE cw_zct_25 SET cw_zct_25_status = "1" WHERE FIND_IN_SET(cw_zct_25_value,"Active,Inactive");

UPDATE cw_zct_25 SET cw_zct_25_status = "1" WHERE FIND_IN_SET(cw_zct_25_value,"Active,Inactive");

UPDATE cw_zct_48 SET cw_zct_48_status = "0";

UPDATE cw_zct_48 SET cw_zct_48_status = "1" WHERE FIND_IN_SET(cw_zct_48_value,"Approval Process,Direct Entry");

UPDATE cw_zct_48 SET cw_zct_48_status = "1" WHERE FIND_IN_SET(cw_zct_48_value,"Approval Process,Direct Entry");

UPDATE cw_form_setting SET input_view_type = '2',input_for = '100',prime_module_id = 'company_information' ,field_type = '7',label_name = 'self_edit_checker',view_name = 'Self Edit Checker',short_name = 'Self Edit Checker',text_type = '0',date_type = '0',field_length = '0',field_decimals = '0',pick_list = 'prime_user_role_id,role_name',pick_list_type = '1',pick_list_import = '2',pick_table = 'cw_user_role',dependent_pick_list = '2',dependent_pick_input = '',table_column1 = '',table_column2 = '',auto_prime_id = ' ',auto_dispaly_value = ' ',field_isdefault = '1',default_value = '0',mandatory_field = '1',unique_field = '0',pick_display_value = 'role_name',field_show = '1',field_for = '1,2,3,4',user_right_for = '1,2,4,6,7,8,10,11,12,13',file_type = '',upload_extension = '',upload_file_size = '0',table_show = '0',search_show = '0',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',onboard_input = '0',trans_updated_by = '1',trans_updated_date = '2023-01-06 16:14:10' WHERE prime_form_id = '2024';

ALTER TABLE cw_company_information CHANGE prime_company_information_id prime_company_information_id int(11) NOT NULL AUTO_INCREMENT,CHANGE self_edit_checker self_edit_checker varchar(100) NULL DEFAULT '0',CHANGE password_column password_column varchar(50) NULL DEFAULT '0',CHANGE max_effective_months max_effective_months int(10) NULL DEFAULT '0',CHANGE maximum_age maximum_age int(10) NULL DEFAULT '60',CHANGE minimum_age minimum_age int(10) NULL DEFAULT '18',CHANGE creation creation varchar(100) NULL DEFAULT '0',CHANGE manager_approval manager_approval varchar(100) NULL DEFAULT '0',CHANGE hr_approval hr_approval varchar(100) NULL DEFAULT '0',CHANGE increment_type increment_type varchar(100) NULL DEFAULT '0',CHANGE company_logo company_logo TEXT NULL,CHANGE pan pan varchar(20) NULL DEFAULT '',CHANGE gstin gstin varchar(50) NULL DEFAULT '',CHANGE website website varchar(255) NULL DEFAULT '',CHANGE country country varchar(100) NULL DEFAULT '',CHANGE state state varchar(100) NULL DEFAULT '',CHANGE city city varchar(100) NULL DEFAULT '',CHANGE address address TEXT NULL,CHANGE fax fax varchar(255) NULL DEFAULT '',CHANGE confirm_period confirm_period varchar(50) NULL DEFAULT '6',CHANGE email email varchar(255) NULL DEFAULT '',CHANGE allow_future_date allow_future_date int(10) NULL DEFAULT '0',CHANGE land_line land_line varchar(255) NULL DEFAULT '',CHANGE allow_past_date allow_past_date int(10) NULL DEFAULT '0',CHANGE alt_mobile_number alt_mobile_number varchar(255) NULL DEFAULT '',CHANGE send_otp_url send_otp_url varchar(250) NULL DEFAULT '',CHANGE sms_password sms_password varchar(50) NULL DEFAULT '',CHANGE mobile_number mobile_number varchar(10) NULL DEFAULT '',CHANGE generate_otp_url generate_otp_url varchar(250) NULL DEFAULT '',CHANGE payslip_based_on payslip_based_on varchar(100) NULL DEFAULT '0',CHANGE sms_username sms_username varchar(50) NULL DEFAULT '',CHANGE secondary_color secondary_color varchar(50) NULL DEFAULT '',CHANGE company_short_name company_short_name varchar(255) NULL DEFAULT '',CHANGE payroll_process_type payroll_process_type varchar(100) NULL DEFAULT 'role',CHANGE aadhar_token aadhar_token TEXT NULL,CHANGE sms_sender_id sms_sender_id varchar(50) NULL DEFAULT '',CHANGE primary_color primary_color varchar(50) NULL DEFAULT '',CHANGE company_name company_name varchar(255) NULL DEFAULT '',CHANGE mi_process_type mi_process_type varchar(100) NULL DEFAULT 'role',CHANGE aadhar_validation aadhar_validation varchar(100) NULL DEFAULT '2',CHANGE sms_url sms_url varchar(50) NULL DEFAULT '';

UPDATE cw_zct_23 SET cw_zct_23_status = "0";

UPDATE cw_zct_23 SET cw_zct_23_status = "1" WHERE FIND_IN_SET(cw_zct_23_value,"payroll");

UPDATE cw_zct_24 SET cw_zct_24_status = "0";

UPDATE cw_zct_24 SET cw_zct_24_status = "1" WHERE FIND_IN_SET(cw_zct_24_value,"payroll");

UPDATE cw_zct_25 SET cw_zct_25_status = "0";

UPDATE cw_zct_25 SET cw_zct_25_status = "1" WHERE FIND_IN_SET(cw_zct_25_value,"Active,Inactive");

UPDATE cw_zct_25 SET cw_zct_25_status = "1" WHERE FIND_IN_SET(cw_zct_25_value,"Active,Inactive");

UPDATE cw_zct_48 SET cw_zct_48_status = "0";

UPDATE cw_zct_48 SET cw_zct_48_status = "1" WHERE FIND_IN_SET(cw_zct_48_value,"Approval Process,Direct Entry");

UPDATE cw_zct_48 SET cw_zct_48_status = "1" WHERE FIND_IN_SET(cw_zct_48_value,"Approval Process,Direct Entry")