{"TRIGGER_NAME":"clear_answer_attachments","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_answer","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DELETE FROM ohrm_answer_attachment where id = OLD.attachment_answer;\n END","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"clear_answers","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_candidate_answer","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DELETE FROM ohrm_answer where id = OLD.answer_id;\n END","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"clear_candidate_answer","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_job_candidate","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DELETE FROM ohrm_candidate_answer where candidate_id = OLD.id;\n END","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"clear_past_candidate_vacancy_answer_attachments","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_past_candidate_vacancy_answer","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DELETE FROM ohrm_past_candidate_vacancy_answer_attachment where id = OLD.attachment_answer;\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"clear_vacancy_user_config","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_job_vacancy","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DELETE FROM `ohrm_user_config` where `key` = CONCAT('recruitment.candidate_filter_for_vacancy.',OLD.id);\n END","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"ohrm_custom_field_display_order","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_custom_field","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n\tSET @row_count:=(SELECT COUNT(id) FROM ohrm_custom_field);\n\tSET NEW.display_order=@row_count+1;\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"ohrm_search_inside_resume_clear_attachment_text","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_job_candidate_attachment","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n INSERT INTO `ohrm_job_candidate_attachment_text`(`attachment_id`, `candidate_id`, `content`) VALUES\n (NEW.`id`, NEW.`candidate_id`, '') ON DUPLICATE KEY UPDATE `content` = '';\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"ohrm_search_inside_resume_update_attachment_text","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"ohrm_job_candidate_attachment","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n IF NEW.`file_content` <> OLD.`file_content` THEN\n INSERT INTO `ohrm_job_candidate_attachment_text`(`attachment_id`, `candidate_id`, `content`) VALUES\n (NEW.`id`, NEW.`candidate_id`, '') ON DUPLICATE KEY UPDATE `content` = '';\n END IF;\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"ohrm_search_inside_resume_watch_delete_attachment","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_job_candidate_attachment","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DELETE FROM `ohrm_job_candidate_attachment_text` WHERE `attachment_id` = OLD.`id`;\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"ohrm_search_inside_resume_watch_delete_candidate","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_job_candidate","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DELETE FROM `ohrm_job_candidate_attachment_text` WHERE `candidate_id` = OLD.`id`;\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"ohrm_vas_custom_field_display_order","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_requestdesk_custom_field","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n SET @ROW_COUNT:=(SELECT COUNT(id) FROM ohrm_requestdesk_custom_field);\n SET NEW.display_order=@ROW_COUNT+1;\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_evaluator","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_performance_appraisal_evaluator","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DELETE FROM ohrm_answer WHERE ohrm_answer.id IN ( SELECT `answer_id` FROM `ohrm_performance_evaluator_answer` WHERE `employee_appraisal_evaluator_id`=OLD.id);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_hs_hr_emp_dependents","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"hs_hr_emp_dependents","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_dependents_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_dependents LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_dependents.emp_number WHERE hs_hr_employee.emp_number = OLD.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_delete_hs_hr_emp_dependents(@orangehrm_user, orangehrm_user_name, 'DELETE DEPENDENT DETAILS', new_version, OLD.emp_number, affected_entity_name, OLD.ed_name, OLD.ed_relationship_type, OLD.ed_relationship, OLD.ed_date_of_birth, OLD.ed_nation_code);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_hs_hr_emp_emergency_contacts","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"hs_hr_emp_emergency_contacts","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_emergency_contacts_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_emergency_contacts LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_emergency_contacts.emp_number WHERE hs_hr_employee.emp_number = OLD.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_delete_hs_hr_emp_emergency_contacts(@orangehrm_user, orangehrm_user_name, 'DELETE EMERGENCY CONTACT DETAILS', new_version, OLD.emp_number, affected_entity_name, OLD.eec_name, OLD.eec_relationship, OLD.eec_home_no, OLD.eec_mobile_no, OLD.eec_office_no);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_hs_hr_emp_language","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"hs_hr_emp_language","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_qualification_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_language LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_language.emp_number WHERE hs_hr_employee.emp_number = OLD.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_delete_hs_hr_emp_language(@orangehrm_user, orangehrm_user_name, 'DELETE LANGUAGE DETAILS', new_version, OLD.emp_number, affected_entity_name, OLD.lang_id, OLD.fluency,OLD.competency,OLD.comments);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_hs_hr_emp_member_detail","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"hs_hr_emp_member_detail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_emp_member_detail_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_member_detail LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_member_detail.emp_number WHERE hs_hr_employee.emp_number = OLD.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_delete_hs_hr_emp_member_detail(@orangehrm_user, orangehrm_user_name, 'DELETE MEMBERSHIP DETAILS', new_version, OLD.emp_number, affected_entity_name, OLD.membship_code, OLD.ememb_subscript_ownership, OLD.ememb_subscript_amount, OLD.ememb_subs_currency, OLD.ememb_commence_date, OLD.ememb_renewal_date);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_hs_hr_emp_passport","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"hs_hr_emp_passport","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_passport_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_passport LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_passport.emp_number WHERE hs_hr_employee.emp_number = OLD.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n\n CALL audit_delete_hs_hr_emp_passport(@orangehrm_user, orangehrm_user_name, 'DELETE IMMIGRATION DETAILS', new_version, OLD.emp_number, affected_entity_name, OLD.ep_passport_num, OLD.ep_passportissueddate, OLD.ep_passportexpiredate, OLD.ep_comments, OLD.ep_passport_type_flg, OLD.ep_i9_status, OLD.ep_i9_review_date, OLD.cou_code);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_hs_hr_emp_reportto","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"hs_hr_emp_reportto","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_reportto_trail` WHERE `affected_entity_id` = OLD.erep_sub_emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name = (SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name = (SELECT CONCAT(`emp_firstname`, ' ',`emp_middle_name`, ' ', `emp_lastname`) FROM `hs_hr_employee` WHERE `emp_number` = OLD.erep_sub_emp_number);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_delete_hs_hr_emp_reportto(@orangehrm_user, orangehrm_user_name, 'DELETE SUPERVISOR', new_version, OLD.erep_sub_emp_number, affected_entity_name, OLD.erep_sup_emp_number, OLD.erep_reporting_mode);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_hs_hr_emp_skill","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"hs_hr_emp_skill","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_qualification_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_skill LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_skill.emp_number WHERE hs_hr_employee.emp_number = OLD.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_delete_hs_hr_emp_skill(@orangehrm_user, orangehrm_user_name, 'DELETE SKILL DETAILS', new_version, OLD.emp_number, affected_entity_name, OLD.skill_id,OLD.years_of_exp, OLD.comments);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_hs_hr_emp_us_tax","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"hs_hr_emp_us_tax","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_us_tax_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_us_tax LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_us_tax.emp_number WHERE hs_hr_employee.emp_number = OLD.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_delete_hs_hr_emp_us_tax(@orangehrm_user, orangehrm_user_name, 'DELETE TAX EXEMPTION DETAILS', new_version, OLD.emp_number, affected_entity_name, OLD.tax_federal_status, OLD.tax_federal_exceptions, OLD.tax_state, OLD.tax_state_status, OLD.tax_state_exceptions, OLD.tax_unemp_state,OLD.tax_work_state);\n\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_hs_hr_emp_work_experience","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"hs_hr_emp_work_experience","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_qualification_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_work_experience LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_work_experience.emp_number WHERE hs_hr_employee.emp_number = OLD.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_delete_hs_hr_emp_work_experience(@orangehrm_user, orangehrm_user_name, 'DELETE WORK EXPERIENCE DETAILS', new_version, OLD.emp_number, affected_entity_name, OLD.eexp_employer, OLD.eexp_jobtit);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_hs_hr_employee","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"hs_hr_employee","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_personal_details_trail` WHERE `affected_entity_id` = OLD.employee_id) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(emp_firstname,' ' , hs_hr_employee.emp_middle_name , ' ' , emp_lastname) FROM hs_hr_employee WHERE emp_number = OLD.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_DELETE_hs_hr_employee(@orangehrm_user, orangehrm_user_name, 'DELETE EMPLOYEE DETAILS', new_version, OLD.emp_number, affected_entity_name, OLD.employee_id, OLD.emp_firstname, OLD.emp_middle_name, OLD.emp_lastname, OLD.emp_other_id, OLD.emp_dri_lice_num, OLD.emp_dri_lice_exp_date, OLD.emp_gender, OLD.emp_marital_status, OLD.nation_code, OLD.emp_birthday, OLD.emp_street1 ,OLD.emp_street2 ,OLD.city_code, OLD.provin_code, OLD.emp_zipcode, OLD.coun_code, OLD.emp_hm_telephone, OLD.emp_mobile,OLD.emp_work_telephone, OLD.emp_work_email, OLD.emp_oth_email, OLD.emp_ssn_num, OLD.emp_sin_num, OLD.emp_nick_name, OLD.emp_military_service, OLD.emp_smoker);\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_ohrm_emp_education","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_emp_education","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_qualification_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM ohrm_emp_education LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_emp_education.emp_number WHERE hs_hr_employee.emp_number = OLD.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_delete_ohrm_emp_education(@orangehrm_user, orangehrm_user_name, 'DELETE EDUCATION QUALIFICATION DETAILS', new_version, OLD.emp_number, affected_entity_name, OLD.education_id, OLD.institute, OLD.major, OLD.year, OLD.score, OLD.start_date, OLD.end_date);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_ohrm_emp_license","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_emp_license","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_qualification_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM ohrm_emp_license LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_emp_license.emp_number WHERE hs_hr_employee.emp_number = OLD.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_delete_ohrm_emp_license(@orangehrm_user, orangehrm_user_name, 'DELETE LICENSE DETAILS', new_version, OLD.emp_number, affected_entity_name, OLD.license_id, OLD.license_no, OLD.license_issued_date, OLD.license_expiry_date);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_ohrm_hiring_managers","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_hiring_managers","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_is_template TINYINT(1);\n DECLARE affected_template_entity_id VARCHAR(20);\n\n SET affected_entity_is_template=(SELECT is_template FROM ohrm_job_vacancy WHERE id = OLD.vacancy_id LIMIT 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n\n IF (affected_entity_is_template IS NULL) THEN\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_recruitment_job_vacancy_trail` WHERE `affected_entity_id` = OLD.vacancy_id) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET affected_entity_name=(SELECT name FROM ohrm_job_vacancy WHERE id = OLD.vacancy_id LIMIT 1);\n CALL audit_delete_ohrm_hiring_managers(@orangehrm_user, orangehrm_user_name, @orangehrm_action_name, new_version, OLD.vacancy_id, affected_entity_name, OLD.employee_id);\n ELSEIF (affected_entity_is_template = 1) THEN\n SET affected_template_entity_id=(SELECT id FROM ohrm_vacancy_template_details WHERE vacancy_id = OLD.vacancy_id LIMIT 1);\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_recruitment_job_vacancy_template_trail` WHERE `affected_entity_id` = affected_template_entity_id) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET affected_entity_name=(SELECT name FROM ohrm_vacancy_template_details WHERE vacancy_id = OLD.vacancy_id LIMIT 1);\n CALL audit_delete_ohrm_hiring_managers_for_vacancy_template(@orangehrm_user, orangehrm_user_name, @orangehrm_action_name, new_version, affected_entity_name, affected_template_entity_id, OLD.employee_id);\n END IF;\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_ohrm_job_vacancy","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_job_vacancy","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE template_name VARCHAR(100) CHARSET UTF8;\n DECLARE template_description TEXT CHARSET UTF8;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n IF (OLD.is_template IS NULL ) THEN\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_recruitment_job_vacancy_trail` WHERE `affected_entity_id` = OLD.id) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET affected_entity_name=(SELECT name FROM ohrm_job_vacancy WHERE id = OLD.id LIMIT 1);\n CALL audit_delete_ohrm_job_vacancy(@orangehrm_user, orangehrm_user_name, @orangehrm_action_name, new_version, OLD.id, affected_entity_name, OLD.job_title_code, OLD.name , OLD.no_of_positions , OLD.location_id , OLD.sub_unit_id , OLD.status , OLD.description, OLD.request_consent, OLD.is_resume_required, OLD.include_archived_candidate_on_dynamic_rule_filter);\n CALL archive_reference('ohrm_job_vacancy', OLD.id, CONCAT(OLD.name, ' - ', (IFNULL((SELECT `job_title` FROM `ohrm_job_title` WHERE `id` = OLD.job_title_code), 'NULL'))));\n ELSEIF (OLD.is_template =1) THEN\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_recruitment_job_vacancy_template_trail` WHERE `affected_entity_id` = OLD.id) + 1;\n SET template_name = (SELECT name FROM `ohrm_vacancy_template_details` WHERE `vacancy_id` = OLD.id);\n SET template_description = (SELECT description FROM `ohrm_vacancy_template_details` WHERE `vacancy_id` = OLD.id);\n SET new_version = IFNULL(new_version, 1);\n SET affected_entity_name=(SELECT name FROM ohrm_vacancy_template_details WHERE vacancy_id = OLD.id LIMIT 1);\n CALL audit_delete_ohrm_job_vacancy_template_from_job_vacancy(@orangehrm_user, orangehrm_user_name, @orangehrm_action_name, new_version, OLD.id, affected_entity_name, OLD.job_title_code, OLD.name , OLD.no_of_positions , OLD.location_id , OLD.sub_unit_id , OLD.status , OLD.description, OLD.request_consent, OLD.is_resume_required, template_name, template_description);\n END IF ;\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_performance_competency","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_performance_competency","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE questionId INT(11) ; \n SET questionId = (SELECT question_id FROM `ohrm_performance_competency_question` WHERE ohrm_performance_competency_question.employee_competency_id=OLD.id); \n DELETE FROM ohrm_question WHERE ohrm_question.id = questionId;\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_delete_performance_goal","EVENT_MANIPULATION":"DELETE","EVENT_OBJECT_TABLE":"ohrm_performance_goal","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n \n DECLARE questionId INT(11) ; \n SET questionId = (SELECT question_id FROM `ohrm_performance_goal_question` WHERE ohrm_performance_goal_question.employee_goal_id=OLD.id); \n DELETE FROM ohrm_question WHERE ohrm_question.id = questionId;\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_config","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_config","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\r\n INSERT INTO ohrm_config_log (`property`, `current_value`) VALUES (NEW.`property`, NEW.`value`);\r\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_hs_hr_emp_dependents","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"hs_hr_emp_dependents","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_dependents LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_dependents.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_insert_hs_hr_emp_dependents(@orangehrm_user, orangehrm_user_name, 'ADD DEPENDENT DETAILS', new_version, NEW.emp_number, affected_entity_name, NEW.ed_name, NEW.ed_relationship_type, NEW.ed_relationship, NEW.ed_date_of_birth, NEW.ed_nation_code );\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_hs_hr_emp_emergency_contacts","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"hs_hr_emp_emergency_contacts","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_emergency_contacts LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_emergency_contacts.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_insert_hs_hr_emp_emergency_contacts(@orangehrm_user, orangehrm_user_name, 'ADD EMERGENCY CONTACT DETAILS', new_version, NEW.emp_number, affected_entity_name, NEW.eec_name, NEW.eec_relationship, NEW.eec_home_no, NEW.eec_mobile_no, NEW.eec_office_no);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_hs_hr_emp_language","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"hs_hr_emp_language","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_language LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_language.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_insert_hs_hr_emp_language(@orangehrm_user, orangehrm_user_name, 'ADD LANGUAGE DETAILS', new_version, NEW.emp_number, affected_entity_name, NEW.lang_id, NEW.fluency,NEW.competency,NEW.comments);\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_hs_hr_emp_member_detail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"hs_hr_emp_member_detail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_member_detail LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_member_detail.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_insert_hs_hr_emp_member_detail(@orangehrm_user, orangehrm_user_name, 'ADD MEMBERSHIP DETAILS', new_version, NEW.emp_number, affected_entity_name, NEW.membship_code, NEW.ememb_subscript_ownership, NEW.ememb_subscript_amount, NEW.ememb_subs_currency, NEW.ememb_commence_date, NEW.ememb_renewal_date);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_hs_hr_emp_passport","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"hs_hr_emp_passport","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_passport LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_passport.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n\n CALL audit_insert_hs_hr_emp_passport(@orangehrm_user, orangehrm_user_name, 'ADD IMMIGRATION DETAILS', new_version, NEW.emp_number, affected_entity_name, NEW.ep_passport_num, NEW.ep_passportissueddate, NEW.ep_passportexpiredate, NEW.ep_comments, NEW.ep_passport_type_flg, NEW.ep_i9_status, NEW.ep_i9_review_date, NEW.cou_code);\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_hs_hr_emp_picture","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"hs_hr_emp_picture","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300) CHARSET UTF8;\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_picture LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_picture.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_insert_hs_hr_emp_picture(@orangehrm_user, orangehrm_user_name, 'ADD PROFILE PICTURE', new_version, NEW.emp_number, affected_entity_name, NEW.epic_filename);\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_hs_hr_emp_reportto","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"hs_hr_emp_reportto","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_reportto LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_reportto.erep_sub_emp_number WHERE hs_hr_employee.emp_number = NEW.erep_sub_emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_insert_hs_hr_emp_reportto(@orangehrm_user, orangehrm_user_name, 'ADD SUPERVISOR', new_version, NEW.erep_sub_emp_number, affected_entity_name, NEW.erep_sup_emp_number, NEW.erep_reporting_mode);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_hs_hr_emp_skill","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"hs_hr_emp_skill","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_skill LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_skill.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_insert_hs_hr_emp_skill(@orangehrm_user, orangehrm_user_name, 'ADD SKILL DETAILS', new_version, NEW.emp_number, affected_entity_name, NEW.skill_id,NEW.years_of_exp, NEW.comments);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_hs_hr_emp_us_tax","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"hs_hr_emp_us_tax","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_us_tax LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_us_tax.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_insert_hs_hr_emp_us_tax(@orangehrm_user, orangehrm_user_name, 'ADD TAX EXEMPTION DETAILS', new_version, NEW.emp_number, affected_entity_name, NEW.tax_federal_status, NEW.tax_federal_exceptions, NEW.tax_state, NEW.tax_state_status, NEW.tax_state_exceptions, NEW.tax_unemp_state,NEW.tax_work_state);\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_hs_hr_emp_work_experience","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"hs_hr_emp_work_experience","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_work_experience LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_work_experience.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_insert_hs_hr_emp_work_experience(@orangehrm_user, orangehrm_user_name, 'ADD WORK EXPERIENCE DETAILS', new_version, NEW.emp_number, affected_entity_name, NEW.eexp_employer, NEW.eexp_jobtit, NEW.eexp_from_date, NEW.eexp_to_date, NEW.eexp_comments,NEW.eexp_creditable);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_hs_hr_employee","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"hs_hr_employee","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE employee_added_location VARCHAR(110 ) CHARSET UTF8;\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(emp_firstname,' ' , hs_hr_employee.emp_middle_name , ' ' , emp_lastname) FROM hs_hr_employee WHERE emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n SET employee_added_location = (SELECT name FROM ohrm_location WHERE id = NEW.location_id);\n\n CALL audit_insert_hs_hr_employee(@orangehrm_user, orangehrm_user_name, 'ADD EMPLOYEE DETAILS', new_version, NEW.emp_number, affected_entity_name, NEW.emp_number, NEW.emp_firstname, NEW.emp_middle_name, NEW.emp_lastname, employee_added_location, NEW.joined_date);\n\nCALL audit_update_hs_hr_employee(\n@orangehrm_user,\norangehrm_user_name,\n'UPDATE PERSONAL DETAILS',\nnew_version, \nNEW.emp_number, \naffected_entity_name,\nNULL, NULL, \nNULL, NULL, \nNULL, NULL, \nNEW.employee_id , NULL, \nNEW.emp_other_id,NULL, \n\nNEW.emp_dri_lice_num, NULL, \nNEW.emp_dri_lice_exp_date, NULL, \nNEW.emp_gender, NULL, \nNEW.emp_marital_status, NULL, \n\nNEW.nation_code,NULL, \nNEW.emp_birthday, NULL,\n\nNEW.emp_street1 ,NULL ,\nNEW.emp_street2 ,NULL,\nNEW.city_code, NULL,\n\nNEW.provin_code,NULL, \nNEW.emp_zipcode, NULL, \nNEW.coun_code,NULL, \n\nNEW.emp_hm_telephone, NULL, \nNEW.emp_mobile, NULL, \nNEW.emp_work_telephone, NULL, \nNEW.emp_work_email, NULL, \n\nNEW.emp_oth_email, NULL, \nNEW.emp_ssn_num,NULL, \nNEW.emp_sin_num,NULL, \n\nNEW.emp_nick_name, NULL, \nNEW.emp_military_service, NULL, \nNULL, NULL,\nNEW.termination_id, NEW.termination_id,\nNEW.eeo_race_ent, NULL);\n\n\n CALL audit_update_hs_hr_employee_termination(@orangehrm_user, orangehrm_user_name, new_version, NEW.emp_number, affected_entity_name, NEW.termination_id, NULL);\n\n\n\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_leave_working_weekend_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_leave_working_weekend_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Working Weekends');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_custom_tab_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_custom_tab_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Custom Tab');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_contact_custom_field_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_contact_custom_field_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Contact Custom Fields');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_contact_info_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_contact_info_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Contact Information');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_custom_field_section_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_custom_field_section_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Custom Field Section');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_custom_field_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_custom_field_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Custom Field');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_dependents_custom_field_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_dependents_custom_field_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Dependent Custom Fields');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_dependents_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_dependents_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Dependent');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_emergency_contacts_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_emergency_contacts_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Emergency Contacts');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_emergency_custom_field_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_emergency_custom_field_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Emergency Custom Fields');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_emp_member_detail_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_emp_member_detail_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Membership');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_employee_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_employee_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Employee');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_immigration_custom_field_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_immigration_custom_field_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Immigration Custom Fields');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_job_custom_field_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_job_custom_field_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Job Custom Fields');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_job_record_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_job_record_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Job Details');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_membership_custom_field_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_membership_custom_field_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Membership Custom Fields');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_passport_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_passport_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Immigration');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_personal_custom_field_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_personal_custom_field_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Personal Details Custom Fields');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_personal_details_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_personal_details_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Personal Details');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_profile_picture_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_profile_picture_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Profile');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_qualification_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_qualification_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Qualification');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_reportto_custom_field_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_reportto_custom_field_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Supervisor\/Subordinate Custom Fields');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_reportto_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_reportto_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Supervisor\/Subordinate');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_salary_custom_field_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_salary_custom_field_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Salary Custom Fields');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_salary_record_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_salary_record_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Salary');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_tab_custom_field_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_tab_custom_field_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_ohrm_audittrail_pim_tab_custom_field_trail(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,NEW.pim_tab);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_tax_custom_field_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_tax_custom_field_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Tax Custom Fields');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_audittrail_pim_us_tax_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_us_tax_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Tax Exemptions');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_emp_education","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_emp_education","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM ohrm_emp_education LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_emp_education.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_insert_ohrm_emp_education(@orangehrm_user, orangehrm_user_name, 'ADD EDUCATION QUALIFICATION DETAILS', new_version, NEW.emp_number, affected_entity_name, NEW.education_id, NEW.institute, NEW.major, NEW.year, NEW.score, NEW.start_date, NEW.end_date);\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_emp_license","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_emp_license","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM ohrm_emp_license LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_emp_license.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_insert_ohrm_emp_license(@orangehrm_user, orangehrm_user_name, 'ADD LICENSE DETAILS', new_version, NEW.emp_number, affected_entity_name, NEW.license_id, NEW.license_no, NEW.license_issued_date, NEW.license_expiry_date);\n\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_hiring_managers","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_hiring_managers","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_is_template TINYINT(1);\n DECLARE affected_template_entity_id VARCHAR(20);\n\n SET affected_entity_is_template=(SELECT is_template FROM ohrm_job_vacancy WHERE id = NEW.vacancy_id LIMIT 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n\n IF (affected_entity_is_template IS NULL) THEN\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_recruitment_job_vacancy_trail` WHERE `affected_entity_id` = NEW.vacancy_id) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET affected_entity_name=(SELECT name FROM ohrm_job_vacancy WHERE id = NEW.vacancy_id LIMIT 1);\n CALL audit_insert_ohrm_hiring_managers(@orangehrm_user, orangehrm_user_name, @orangehrm_action_name, new_version, affected_entity_name, NEW.vacancy_id, NEW.employee_id);\n ELSEIF (affected_entity_is_template = 1) THEN\n SET affected_template_entity_id=(SELECT id FROM ohrm_vacancy_template_details WHERE vacancy_id = NEW.vacancy_id LIMIT 1);\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_recruitment_job_vacancy_template_trail` WHERE `affected_entity_id` = affected_template_entity_id) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET affected_entity_name=(SELECT name FROM ohrm_vacancy_template_details WHERE vacancy_id = NEW.vacancy_id LIMIT 1);\n CALL audit_insert_ohrm_hiring_managers_for_vacancy_template(@orangehrm_user, orangehrm_user_name, @orangehrm_action_name, new_version, affected_entity_name, affected_template_entity_id, NEW.employee_id);\n END IF;\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_job_vacancy","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_job_vacancy","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n IF(NEW.is_template IS NULL ) THEN\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT name FROM ohrm_job_vacancy WHERE id = NEW.id LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_insert_ohrm_job_vacancy(@orangehrm_user, orangehrm_user_name, @orangehrm_action_name, new_version, NEW.id, affected_entity_name, NEW.job_title_code, NEW.name , NEW.no_of_positions , NEW.location_id , NEW.sub_unit_id , NEW.status , NEW.description, NEW.request_consent, NEW.is_resume_required, NEW.include_archived_candidate_on_dynamic_rule_filter);\n END IF ;\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_job_vacancy_template","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_vacancy_template_details","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE job_title INT(4);\n DECLARE location INT(4);\n DECLARE status INT(4);\n DECLARE vacancy_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE request_consent INT(4);\n DECLARE is_resume_required INT(4);\n SET new_version = 1;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT name FROM ohrm_vacancy_template_details WHERE id = NEW.id LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n SET job_title = (SELECT ohrm_job_vacancy.job_title_code FROM ohrm_job_vacancy WHERE ohrm_job_vacancy.id=NEW.vacancy_id LIMIT 1);\n SET location = (SELECT ohrm_job_vacancy.location_id FROM ohrm_job_vacancy WHERE ohrm_job_vacancy.id=NEW.vacancy_id LIMIT 1);\n SET status = (SELECT ohrm_job_vacancy.status FROM ohrm_job_vacancy WHERE ohrm_job_vacancy.id=NEW.vacancy_id LIMIT 1);\n SET vacancy_name = (SELECT ohrm_job_vacancy.name FROM ohrm_job_vacancy WHERE ohrm_job_vacancy.id=NEW.vacancy_id LIMIT 1);\n SET request_consent = (SELECT ohrm_job_vacancy.request_consent FROM ohrm_job_vacancy WHERE ohrm_job_vacancy.id=NEW.vacancy_id LIMIT 1);\n SET is_resume_required = (SELECT ohrm_job_vacancy.is_resume_required FROM ohrm_job_vacancy WHERE ohrm_job_vacancy.id=NEW.vacancy_id LIMIT 1);\n CALL audit_insert_ohrm_job_vacancy_template(@orangehrm_user, orangehrm_user_name, @orangehrm_action_name, new_version, job_title,location,status,vacancy_name,request_consent,NEW.id, affected_entity_name, NEW.name , NEW.description, is_resume_required);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_ohrm_qualifications_custom_field_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_pim_qualifications_custom_field_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_all(NEW.action_time, NEW.action_owner_id, NEW.action_owner_name, NEW.action,NEW.action_description,NEW.version_id,NEW.affected_entity_id,NEW.affected_entity_name,'Qualifications Custom Field');\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_onboarding_task","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_task","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n\nINSERT INTO `ohrm_onboarding_task_notification` (`task_id`) VALUES (new.id);\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_insert_training_online_course_trail","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_audittrail_training_online_course_trail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n CALL audit_insert_to_ohrm_audittrail_online_training(\n NEW.action_time,\n NEW.action_owner_id,\n NEW.action_owner_name,\n NEW.action,\n NEW.action_description,\n NEW.version_id,\n NEW.affected_entity_id,\n NEW.affected_entity_name\n );\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_ohrm_bulk_appraisal_archives_insert","EVENT_MANIPULATION":"INSERT","EVENT_OBJECT_TABLE":"ohrm_bulk_appraisal_archives","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n SET NEW.file_identity = UUID();\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"BEFORE","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_hs_hr_emp_dependents","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"hs_hr_emp_dependents","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_dependents_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_dependents LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_dependents.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_update_hs_hr_emp_dependents(@orangehrm_user,orangehrm_user_name, 'UPDATE DEPENDENT DETAILS', new_version, NEW.emp_number,affected_entity_name, NEW.ed_name, OLD.ed_name, NEW.ed_relationship_type, OLD.ed_relationship_type, NEW.ed_relationship, OLD.ed_relationship, NEW.ed_date_of_birth, OLD.ed_date_of_birth, NEW.ed_nation_code, OLD.ed_nation_code);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_hs_hr_emp_emergency_contacts","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"hs_hr_emp_emergency_contacts","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_emergency_contacts_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_emergency_contacts LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_emergency_contacts.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_update_hs_hr_emp_emergency_contacts(@orangehrm_user, orangehrm_user_name, 'UPDATE EMERGENCY CONTACT DETAILS', new_version, NEW.emp_number, affected_entity_name, NEW.eec_name, OLD.eec_name, NEW.eec_relationship, OLD.eec_relationship, NEW.eec_home_no, OLD.eec_home_no, NEW.eec_mobile_no, OLD.eec_mobile_no, NEW.eec_office_no, OLD.eec_office_no);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_hs_hr_emp_language","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"hs_hr_emp_language","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_qualification_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_language LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_language.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_update_hs_hr_emp_language(@orangehrm_user, orangehrm_user_name, 'UPDATE LANGUAGE DETAILS', new_version, OLD.emp_number, affected_entity_name, NEW.lang_id, OLD.lang_id, NEW.fluency, OLD.fluency, NEW.competency, OLD.competency, NEW.comments, OLD.comments);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_hs_hr_emp_member_detail","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"hs_hr_emp_member_detail","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_emp_member_detail_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_member_detail LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_member_detail.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_update_hs_hr_emp_member_detail(@orangehrm_user, orangehrm_user_name, 'UPDATE MEMBERSHIP DETAILS', new_version, OLD.emp_number, affected_entity_name, NEW.membship_code, OLD.membship_code, NEW.ememb_subscript_ownership, OLD.ememb_subscript_ownership, NEW.ememb_subscript_amount, OLD.ememb_subscript_amount, NEW.ememb_subs_currency, OLD.ememb_subs_currency, NEW.ememb_commence_date, OLD.ememb_commence_date, NEW.ememb_renewal_date, OLD.ememb_renewal_date);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_hs_hr_emp_passport","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"hs_hr_emp_passport","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_passport_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_passport LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_passport.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n\n CALL audit_update_hs_hr_emp_passport(@orangehrm_user, orangehrm_user_name, 'UPDATE IMMIGRATION DETAILS', new_version, OLD.emp_number, affected_entity_name, NEW.ep_passport_num, OLD.ep_passport_num, NEW.ep_passportissueddate, OLD.ep_passportissueddate, NEW.ep_passportexpiredate, OLD.ep_passportexpiredate, NEW.ep_comments, OLD.ep_comments, NEW.ep_passport_type_flg, OLD.ep_passport_type_flg, NEW.ep_i9_status, OLD.ep_i9_status, NEW.ep_i9_review_date, OLD.ep_i9_review_date, NEW.cou_code, OLD.cou_code);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_hs_hr_emp_picture","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"hs_hr_emp_picture","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_profile_picture_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_picture LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_picture.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_update_hs_hr_emp_picture(@orangehrm_user, orangehrm_user_name, 'UPDATE PROFILE PICTURE', new_version, OLD.emp_number, affected_entity_name, NEW.epic_filename, OLD.epic_filename, NEW.epic_picture, OLD.epic_picture);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_hs_hr_emp_reportto","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"hs_hr_emp_reportto","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_reportto_trail` WHERE `affected_entity_id` = OLD.erep_sub_emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_reportto LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_reportto.erep_sup_emp_number WHERE hs_hr_employee.emp_number = NEW.erep_sup_emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_update_hs_hr_emp_reportto(@orangehrm_user, orangehrm_user_name, 'UPDATE REPORT TO DETAILS', new_version, OLD.erep_sub_emp_number, affected_entity_name, NEW.erep_sup_emp_number, OLD.erep_sup_emp_number, NEW.erep_reporting_mode, OLD.erep_reporting_mode);\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_hs_hr_emp_skill","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"hs_hr_emp_skill","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_qualification_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_skill LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_skill.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_update_hs_hr_emp_skill(@orangehrm_user, orangehrm_user_name, 'UPDATE SKILL DETAILS', new_version, OLD.emp_number, affected_entity_name, NEW.skill_id, OLD.skill_id, NEW.years_of_exp, OLD.years_of_exp, NEW.comments, OLD.comments);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_hs_hr_emp_us_tax","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"hs_hr_emp_us_tax","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_us_tax_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_us_tax LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_us_tax.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_update_hs_hr_emp_us_tax(@orangehrm_user, orangehrm_user_name, 'UPDATE TAX EXEMPTION DETAILS', new_version, OLD.emp_number, affected_entity_name, NEW.tax_federal_status, OLD.tax_federal_status, NEW.tax_federal_exceptions, OLD.tax_federal_exceptions, NEW.tax_state, OLD.tax_state, NEW.tax_state_status, OLD.tax_state_status, NEW.tax_state_exceptions, OLD.tax_state_exceptions, NEW.tax_unemp_state, OLD.tax_unemp_state, NEW.tax_work_state, OLD.tax_work_state);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_hs_hr_emp_work_experience","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"hs_hr_emp_work_experience","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_qualification_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM hs_hr_emp_work_experience LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = hs_hr_emp_work_experience.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_update_hs_hr_emp_work_experience(@orangehrm_user, orangehrm_user_name, 'UPDATE WORK EXPERIENCE DETAILS', new_version, OLD.emp_number, affected_entity_name, NEW.eexp_employer, OLD.eexp_employer, NEW.eexp_jobtit, OLD.eexp_jobtit, CONVERT(NEW.eexp_from_date, DATE), CONVERT(OLD.eexp_from_date, DATE), CONVERT(NEW.eexp_to_date, DATE), CONVERT(OLD.eexp_to_date, DATE), NEW.eexp_comments, OLD.eexp_comments,NEW.eexp_creditable,OLD.eexp_creditable);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_hs_hr_employee","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"hs_hr_employee","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_personal_details_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(emp_firstname,' ' , hs_hr_employee.emp_middle_name , ' ' , emp_lastname) FROM hs_hr_employee WHERE emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n\nCALL audit_update_hs_hr_employee(\n@orangehrm_user,\norangehrm_user_name,\n'UPDATE PERSONAL DETAILS',\nnew_version,\nOLD.emp_number,\naffected_entity_name,\nNEW.emp_firstname, OLD.emp_firstname,\nNEW.emp_middle_name, OLD.emp_middle_name,\nNEW.emp_lastname, OLD.emp_lastname,\nNEW.employee_id, OLD.employee_id,\nNEW.emp_other_id,OLD.emp_other_id,\n\nNEW.emp_dri_lice_num, OLD.emp_dri_lice_num,\nNEW.emp_dri_lice_exp_date, OLD.emp_dri_lice_exp_date,\nNEW.emp_gender, OLD.emp_gender,\nNEW.emp_marital_status, OLD.emp_marital_status,\n\nNEW.nation_code, OLD.nation_code,\nNEW.emp_birthday, OLD.emp_birthday,\n\nNEW.emp_street1 ,OLD.emp_street1 ,\nNEW.emp_street2 ,OLD.emp_street2 ,\nNEW.city_code, OLD.city_code,\n\nNEW.provin_code,OLD.provin_code,\nNEW.emp_zipcode, OLD.emp_zipcode,\nNEW.coun_code, OLD.coun_code,\n\nNEW.emp_hm_telephone, OLD.emp_hm_telephone,\nNEW.emp_mobile, OLD.emp_mobile,\nNEW.emp_work_telephone, OLD.emp_work_telephone,\nNEW.emp_work_email, OLD.emp_work_email,\n\nNEW.emp_oth_email, OLD.emp_oth_email,\nNEW.emp_ssn_num, OLD.emp_ssn_num,\nNEW.emp_sin_num, OLD.emp_sin_num,\n\nNEW.emp_nick_name, OLD.emp_nick_name,\nNEW.emp_military_service, OLD.emp_military_service,\nNEW.emp_smoker, OLD.emp_smoker,\nNEW.termination_id, OLD.termination_id,\nNEW.eeo_race_ent, OLD.eeo_race_ent\n);\n\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_employee_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n CALL audit_update_hs_hr_employee_termination(@orangehrm_user, orangehrm_user_name, new_version, OLD.emp_number, affected_entity_name, NEW.termination_id, OLD.termination_id);\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_ohrm_config","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"ohrm_config","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\r\n INSERT INTO ohrm_config_log (`property`, `prev_value`, `current_value`) VALUES (NEW.`property`, OLD.`value`, NEW.`value`);\r\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_ohrm_emp_education","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"ohrm_emp_education","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_qualification_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM ohrm_emp_education LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_emp_education.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_update_ohrm_emp_education(@orangehrm_user, orangehrm_user_name, 'UPDATE EDUCATION QUALIFICATION DETAILS', new_version, OLD.emp_number, affected_entity_name, NEW.education_id, OLD.education_id, NEW.institute, OLD.institute, NEW.major, OLD.major, NEW.year, OLD.year, NEW.score, OLD.score, NEW.start_date, OLD.start_date, NEW.end_date, OLD.end_date);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_ohrm_emp_license","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"ohrm_emp_license","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_pim_qualification_trail` WHERE `affected_entity_id` = OLD.emp_number) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname) FROM ohrm_emp_license LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_emp_license.emp_number WHERE hs_hr_employee.emp_number = NEW.emp_number LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_update_ohrm_emp_license(@orangehrm_user, orangehrm_user_name, 'UPDATE LICENSE DETAILS', new_version, OLD.emp_number, affected_entity_name, NEW.license_id, OLD.license_id, NEW.license_no, OLD.license_no, NEW.license_issued_date, OLD.license_issued_date, NEW.license_expiry_date, OLD.license_expiry_date);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_ohrm_job_vacancy","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"ohrm_job_vacancy","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n IF (NEW.is_template IS NULL ) THEN\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_recruitment_job_vacancy_trail` WHERE `affected_entity_id` = OLD.id) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET affected_entity_name=(SELECT name FROM ohrm_job_vacancy WHERE id = OLD.id LIMIT 1);\n CALL audit_update_ohrm_job_vacancy(@orangehrm_user, orangehrm_user_name, @orangehrm_action_name, new_version, OLD.id, affected_entity_name, NEW.job_title_code, OLD.job_title_code, NEW.name, OLD.name, NEW.no_of_positions, OLD.no_of_positions, NEW.location_id, OLD.location_id, NEW.sub_unit_id, OLD.sub_unit_id, NEW.status, OLD.status, NEW.description, OLD.description, NEW.request_consent, OLD.request_consent, NEW.is_resume_required, OLD.is_resume_required, NEW.include_archived_candidate_on_dynamic_rule_filter, OLD.include_archived_candidate_on_dynamic_rule_filter);\n ELSEIF (NEW.is_template =1) THEN\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_recruitment_job_vacancy_template_trail` WHERE `affected_entity_id` = OLD.id) + 1;\n SET new_version = IFNULL(new_version, 1);\n SET affected_entity_name=(SELECT name FROM ohrm_vacancy_template_details WHERE vacancy_id = OLD.id LIMIT 1);\n CALL audit_update_ohrm_job_vacancy_template_from_job_vacancy_update(@orangehrm_user, orangehrm_user_name, @orangehrm_action_name, new_version, OLD.id, affected_entity_name, NEW.job_title_code, OLD.job_title_code, NEW.name, OLD.name, NEW.no_of_positions, OLD.no_of_positions, NEW.location_id, OLD.location_id, NEW.sub_unit_id, OLD.sub_unit_id, NEW.status, OLD.status, NEW.description, OLD.description, NEW.request_consent, OLD.request_consent, NEW.is_resume_required, OLD.is_resume_required);\n END IF ;\n END","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_ohrm_job_vacancy_template","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"ohrm_vacancy_template_details","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE new_version INT;\n DECLARE orangehrm_user_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE affected_entity_name VARCHAR(300 ) CHARSET UTF8;\n DECLARE current_action_description TEXT CHARSET UTF8;\n\n SET new_version = (SELECT MAX(`version_id`) FROM `ohrm_audittrail_recruitment_job_vacancy_template_trail` WHERE `affected_entity_id` = OLD.id);\n SET current_action_description = (SELECT action_description FROM ohrm_audittrail_recruitment_job_vacancy_template_trail WHERE affected_entity_id = NEW.id AND version_id= new_version LIMIT 1);\n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET affected_entity_name=(SELECT name FROM ohrm_vacancy_template_details WHERE id = NEW.id LIMIT 1);\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, current_user());\n CALL audit_update_ohrm_job_vacancy_template(new_version,NEW.id, NEW.name ,OLD.name, NEW.description, OLD.description, current_action_description);\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_onboarding_task","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"ohrm_task","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n\nSET @task_id = (SELECT `task_id` FROM `ohrm_onboarding_task_notification` WHERE `task_id` = new.id);\n\nIF ((NEW.owner_num <> OLD.owner_num) AND @task_id IS NULL) THEN\n INSERT INTO `ohrm_onboarding_task_notification` (`task_id`) VALUES (NEW.id);\nEND IF;\n\nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"} {"TRIGGER_NAME":"watch_update_performance_appraisal_evaluator","EVENT_MANIPULATION":"UPDATE","EVENT_OBJECT_TABLE":"ohrm_performance_appraisal_evaluator","ACTION_CONDITION":null,"ACTION_STATEMENT":"BEGIN\n DECLARE orangehrm_user_name VARCHAR(300) CHARSET UTF8;\n DECLARE prev_evaluator_name VARCHAR(300) CHARSET UTF8;\n DECLARE new_evaluator_name VARCHAR(300) CHARSET UTF8;\n DECLARE orangehrm_user_name_in_sentence_case VARCHAR(300) CHARSET UTF8;\n DECLARE statusName VARCHAR(100);\n DECLARE comment MEDIUMTEXT;\n IF (SELECT @no_review_history IS NULL) THEN \n SET orangehrm_user_name=(SELECT IFNULL(CONCAT(hs_hr_employee.emp_firstname, ' ' , hs_hr_employee.emp_middle_name ,' ', hs_hr_employee.emp_lastname),ohrm_user.user_name) FROM ohrm_user LEFT JOIN hs_hr_employee ON hs_hr_employee.emp_number = ohrm_user.emp_number WHERE ohrm_user.id = @orangehrm_user );\n SET orangehrm_user_name = IFNULL(orangehrm_user_name, 'admin');\n SET orangehrm_user_name_in_sentence_case = IF(orangehrm_user_name='admin', 'Admin',orangehrm_user_name);\n SET statusName='invalid';\n SET comment='';\n IF(NEW.comment_added_time != Old.comment_added_time or (Old.comment_added_time is null and NEW.comment_added_time is not null)) THEN\n SET comment = NEW.admin_comment;\n END IF;\n IF (comment = '') THEN\n IF @workflow_action = 'Replaced' THEN\n SET prev_evaluator_name = (SELECT CONCAT(emp_firstname, IF(emp_middle_name IS NULL OR emp_middle_name = '', '', CONCAT(' ', emp_middle_name)),' ', emp_lastname, IF(termination_id IS NULL, '', ' (Past Employee)')) FROM hs_hr_employee WHERE emp_number = OLD.employee_id);\n SET new_evaluator_name = (SELECT CONCAT(emp_firstname, IF(emp_middle_name IS NULL OR emp_middle_name = '', '', CONCAT(' ', emp_middle_name)),' ', emp_lastname) FROM hs_hr_employee WHERE emp_number = NEW.employee_id);\n SET comment = CONCAT(orangehrm_user_name_in_sentence_case,' has ',@workflow_action, ' ',prev_evaluator_name,' by ',new_evaluator_name, '\\n', 'Existing ratings and comments from the previous evaluator have been allocated to the new evaluator');\n ELSE\n SET comment = (SELECT CONCAT_WS(' ',orangehrm_user_name_in_sentence_case,'has',@workflow_action,pa.description) FROM ohrm_performance_appraisal_evaluator pae LEFT JOIN ohrm_performance_appraisal pa ON pa.id = pae.employee_appraisal_id WHERE pae.id = NEW.id);\n END IF;\n END IF;\n SET statusName = @workflow_action;\n IF(statusName != 'invalid') THEN\n INSERT INTO `ohrm_performance_appraisal_history`\n SET\n action_time=CURRENT_TIMESTAMP,\n action_owner_id = @orangehrm_user,\n action_owner_name= orangehrm_user_name,\n action=statusName,\n evaluator_id = NEW.id,\n action_description=comment;\n END IF;\n END IF; \nEND","ACTION_ORIENTATION":"ROW","ACTION_TIMING":"AFTER","ACTION_REFERENCE_OLD_TABLE":null,"ACTION_REFERENCE_NEW_TABLE":null,"ACTION_REFERENCE_OLD_ROW":"OLD","ACTION_REFERENCE_NEW_ROW":"NEW","SQL_MODE":"","CHARACTER_SET_CLIENT":"utf8","COLLATION_CONNECTION":"utf8_general_ci"}