UPDATE ohrm_menu_item SET menu_title = REPLACE(menu_title, 'On/Off Boarding', 'On/Offboarding') WHERE menu_title LIKE '%On/Off Boarding%';

UPDATE `ohrm_report_folder` SET `name`='On/Offboarding' WHERE `name`= 'On/Off Boarding';

UPDATE `ohrm_advanced_report` SET `name`='On/Offboarding Dashboard' WHERE `unique_name`= 'onboarding_dashboard_summary_1';

UPDATE `ohrm_workflow` SET label = 'On/Offboarding - Task' WHERE name = 'onboardTask';
UPDATE `ohrm_workflow` SET label = 'On/Offboarding - Event' WHERE name = 'onboardJob';

UPDATE ohrm_data_group
SET `description` = REPLACE(description, 'On/Off Boarding', 'On/Offboarding')
WHERE `description` LIKE '%On/Off Boarding%';

UPDATE ohrm_notification
SET `name` = REPLACE(name, 'On/Off Boarding', 'On/Offboarding')
WHERE `name` LIKE '%On/Off Boarding%';

UPDATE ohrm_notification_subscriber_subscription_template t LEFT JOIN ohrm_notification n ON (t.notification_id = n.id) SET t.subject = REPLACE(t.subject, 'On/Off Boarding', 'On/Offboarding') WHERE n.module_id IN (SELECT id from ohrm_module where name = 'onboarding') AND t.subject LIKE '%On/Off Boarding%';

UPDATE `ohrm_symfony_task` SET name = 'On/Offboarding Notification' WHERE name = 'On/Off Boarding Notification';
UPDATE `ohrm_symfony_task` SET name = 'On/Offboarding Quick Notification' WHERE name = 'On/Off Boarding Quick Notification';

UPDATE ohrm_symfony_task
SET `short_description` = REPLACE(short_description, 'On/Off Boarding', 'On/Offboarding')
WHERE `short_description` LIKE '%On/Off Boarding%';

UPDATE ohrm_symfony_task
SET `long_description` = REPLACE(long_description, 'On/Off Boarding', 'On/Offboarding')
WHERE `long_description` LIKE '%On/Off Boarding%';

UPDATE `ohrm_audittrail_module` SET `name`='On/Offboarding' WHERE `name`= 'On/Off Boarding';