SET @processor_id :=(SELECT id FROM `ohrm_wizard_section_processor` WHERE `name` LIKE 'PimContactDetailsFormFactory');
INSERT INTO `ohrm_pim_field` (`validation_message`, `field_name`, `max_length`, `is_mandatory`, `is_visible`, `order`, `form_input_type_id`, `getter`, `setter`, `validator`, `processor_id`, `label`, `read_only`, `data_service`, `js_action`, `entity`, `enabled`) VALUES
('', 'province_us', '0', '0', '1', '324', '2', 'getProvince', 'setProvince', '{\n \"condition\": \"employeeWizard.model.PimContactDetailsFormFactory.country == \'US\' && employeeWizard.isStateProvinceFieldAvailable\"\n}', @processor_id, 'State/Province', '1', '{\r\n \"service\": \"provinces\",\r\n \"value\": \"province_code\",\r\n \"name\": \"province_name\"\r\n}', '', '', '1');

UPDATE `ohrm_pim_field` SET `validator` = '{\r\n \"condition\": \"employeeWizard.model.PimContactDetailsFormFactory.country != \'US\'\"\r\n}' WHERE `ohrm_pim_field`.`field_name` = 'province';