INSERT INTO `ohrm_config` (`property`, `value`) VALUES('pim_wizard_status', '0');

CREATE TABLE IF NOT EXISTS `ohrm_wizard_section_processor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name`  varchar(255) NOT NULL UNIQUE,
  `topic` varchar(200) NOT NULL,
  `menu_item_id` int(11) DEFAULT NULL,
  `has_list` tinyint(2) NOT NULL,
  `enabled` tinyint(2) NOT NULL,
  `data_group_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `fk_ohrm_wizard_section_processor_data_group_id` FOREIGN KEY (`data_group_id`) REFERENCES `ohrm_data_group` (`id`),
  CONSTRAINT `fk_ohrm_data_group_menu_item_id` FOREIGN KEY (`menu_item_id`) REFERENCES `ohrm_menu_item` (`id`)
) ENGINE=InnoDB  DEFAULT charset=utf8 ;

SET @personalDetailsMenuId := (SELECT `id` FROM `ohrm_menu_item` WHERE `menu_title` = 'Personal Details' AND `menu_category`='pim_left_menu' AND uisref != 'pim.employees.profile.custom_pimTab');
SET @contactDetailsMenuId := (SELECT `id` FROM `ohrm_menu_item` WHERE `menu_title` = 'Contact Details' AND `menu_category`='pim_left_menu' AND uisref != 'pim.employees.profile.custom_pimTab');
SET @emergencyContactDetailsMenuId := (SELECT `id` FROM `ohrm_menu_item` WHERE `menu_title` = 'Emergency Contacts' AND `menu_category`='pim_left_menu' AND uisref != 'pim.employees.profile.custom_pimTab');
SET @jobDetailsMenuId := (SELECT `id` FROM `ohrm_menu_item` WHERE `menu_title` = 'Job' AND `menu_category`='pim_left_menu' AND uisref != 'pim.employees.profile.custom_pimTab');
SET @socialMediaMenuId := (SELECT `id` FROM `ohrm_menu_item` WHERE `menu_title` = 'Social Media Details' AND `menu_category`='pim_left_menu' AND uisref != 'pim.employees.profile.custom_pimTab');
SET @reportToMenuId := (SELECT `id` FROM `ohrm_menu_item` WHERE `menu_title` = 'Report-to' AND `menu_category`='pim_left_menu' AND uisref != 'pim.employees.profile.custom_pimTab');
SET @dependentMenuId := (SELECT `id` FROM `ohrm_menu_item` WHERE `menu_title` = 'Dependents' AND `menu_category`='pim_left_menu' AND uisref != 'pim.employees.profile.custom_pimTab');
SET @salaryMenuId := (SELECT `id` FROM `ohrm_menu_item` WHERE `menu_title` = 'Salary' AND `menu_category`='pim_left_menu' AND uisref != 'pim.employees.profile.custom_pimTab');
SET @qualificationMenuId := (SELECT `id` FROM `ohrm_menu_item` WHERE `menu_title` = 'Qualifications' AND `menu_category`='pim_left_menu' AND uisref != 'pim.employees.profile.custom_pimTab');
SET @membershipMenuId := (SELECT `id` FROM `ohrm_menu_item` WHERE `menu_title` = 'Memberships' AND `menu_category`='pim_left_menu' AND uisref != 'pim.employees.profile.custom_pimTab');
SET @directDepositMenuId := (SELECT `id` FROM `ohrm_menu_item` WHERE `menu_title` = 'Direct Deposit' AND `menu_category`='pim_left_menu' AND uisref != 'pim.employees.profile.custom_pimTab');
SET @immigrationMenuId := (SELECT `id` FROM `ohrm_menu_item` WHERE `menu_title` = 'Immigration' AND `menu_category`='pim_left_menu' AND uisref != 'pim.employees.profile.custom_pimTab');

SET @personalDetailsDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'personal_information');
SET @contactDetailsDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'contact_details');
SET @emergencyContactDetailsDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'emergency_contacts');
SET @jobDetailsDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'job_history_details');
SET @socialMediaDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'social_media');
SET @supervisorDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'supervisor');
SET @subordinateDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'subordinates');
SET @dependentDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'dependents');
SET @salaryDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'salary_history_details');
SET @workExpDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'qualification_work');
SET @educationDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'qualification_education');
SET @skillsDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'qualification_skills');
SET @languageDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'qualification_languages');
SET @licenseDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'qualification_license');
SET @membershipDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'membership');
SET @directDepositDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'salary_history_details');
SET @immigrationDataGroupId := (SELECT `id` FROM `ohrm_data_group` WHERE `name` = 'immigration');


INSERT INTO `ohrm_wizard_section_processor` (`id`, `name`, `topic`, `menu_item_id`, `has_list`,`enabled`,`data_group_id`) VALUES
  (1, 'PimPersonalDetailFormFactory', 'Personal Details',@personalDetailsMenuId, 0,1,@personalDetailsDataGroupId),
  (4, 'PimContactDetailsFormFactory', 'Contact Details', @contactDetailsMenuId, 0,1,@contactDetailsDataGroupId),
  (5, 'PimSocialMediaFormFactory', 'Social Media Details', @socialMediaMenuId, 1,0,@socialMediaDataGroupId),
  (6, 'PimEmergencyContactsFormFactory', 'Emergency Contacts',  @emergencyContactDetailsMenuId, 1,0,@emergencyContactDetailsDataGroupId),
  (2, 'PimJobFormFactory', 'Job', @jobDetailsMenuId, 0,1,@jobDetailsDataGroupId),
  (9, 'PimSupervisorFormFactory', 'Supervisor', @reportToMenuId, 1,0,@supervisorDataGroupId),
  (10, 'PimSubordinateFormFactory', 'Subordinate',  @reportToMenuId, 1,0,@subordinateDataGroupId),
  (7, 'PimDependentFormFactory', 'Dependent',  @dependentMenuId, 1,0,@dependentDataGroupId),
  (8, 'PimImmigrationDetailsFormFactory', 'Immigration', @immigrationMenuId, 1,0,@immigrationDataGroupId),
  (17, 'PimDirectDepositFormFactory', 'Direct Deposit', @directDepositMenuId, 1,0,1),
  (16, 'PimMembershipFormFactory', 'Memberships',  @membershipMenuId, 1,0,@membershipDataGroupId),
  (11, 'PimWorkExperienceFormFactory', 'Work Experience',  @qualificationMenuId, 1,0,@workExpDataGroupId),
  (12, 'PimEducationFormFactory', 'Education',  @qualificationMenuId, 1,0,@educationDataGroupId),
  (13, 'PimSkillFormFactory', 'Skill',  @qualificationMenuId, 1,0,@skillsDataGroupId),
  (14, 'PimLanguageFormFactory', 'Language', @qualificationMenuId, 1,0,@languageDataGroupId),
  (15, 'PimLicenseFormFactory', 'License',@qualificationMenuId, 1,0,@licenseDataGroupId),
  (3, 'PimSalaryFormFactory', 'Salary',  @salaryMenuId, 0,0,@salaryDataGroupId);

CREATE TABLE IF NOT EXISTS `ohrm_form_input_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8;


CREATE TABLE IF NOT EXISTS `ohrm_pim_field` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `validation_message` varchar(500) NOT NULL,
  `field_name` varchar(100) NOT NULL,
  `max_length` int(11) NOT NULL,
  `is_mandatory` tinyint(2) NOT NULL,
  `is_visible` tinyint(2) NOT NULL,
  `order` int(11) NOT NULL,
  `form_input_type_id` int(11) NOT NULL,
  `getter` varchar(500) NOT NULL,
  `setter` varchar(500) NOT NULL,
  `validator` TEXT NOT NULL,
  `processor_id` int(11) NOT NULL,
  `label` varchar(500) NOT NULL,
  `read_only` tinyint(2) NOT NULL,
  `data_service` varchar(1000) NOT NULL,
  `js_action` varchar(500) NOT NULL,
  `entity` varchar(1500) NOT NULL,
  `enabled` tinyint(2) NOT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `fk_ohrm_pim_field_form_input_type`
  FOREIGN KEY (`form_input_type_id`) REFERENCES  `ohrm_form_input_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 ;

INSERT INTO `ohrm_form_input_type` (`id`, `name`) VALUES
  (1, 'text'),
  (2, 'select'),
  (3, 'date'),
  (5, 'auto-complete'),
  (6, 'textarea'),
  (7, 'checkbox'),
  (8, 'radiobuttons'),
  (9, 'cost-centre-auto-complete'),
  (10, 'radios-with-validators');


INSERT INTO `ohrm_pim_field` (`id`, `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
(1, '', 'nationality', 10, 0, 1, 10, 2, 'getNationCode', 'setNationCode', '', 1, 'Nationality', 1, '{\n  "service": "nationality",\n  "name": "name",\n  "value": "id"\n}', '', '', 1),
(2, '', 'txtLicExpDate', 10, 0, 1, 23, 3, 'getEmpDriLiceExpDate', 'setEmpDriLiceExpDate', '{\n    "datePickerConfig": {\n    "type": "CUSTOM",\n    "name": "datePickerConfig",\n    "additionalParam": {\n       "config":{\n    	"selectMonths"  : "true",\n    	"selectYears"   : "100"	\n	}\n    }\n  }\n}', 1, 'License Expiry Date', 1, '', '', '', 1),
(3, '', 'maritalStatus', 10, 0, 1, 8, 2, 'getEmpMaritalStatus', 'setEmpMaritalStatus', '', 1, 'Marital Status', 1, '{"choices":[\n    {"key":"Single", "value":"Single"},\n    {"key":"Married", "value":"Married"},\n    {"key":"Other", "value":"Other"}\n]}', '', '', 1),
(4, '', 'gender', 0, 0, 1, 9, 10, 'getEmpGender', 'setEmpGender', '', 1, 'Gender', 1, '{"choices":[\n    {"key":"1", "value":"Male"},\n    {"key":"2", "value":"Female"}\n]}', '{\n    "action": "onChange",\n    "function": "genderValidation"\n}', '', 1),
(5, '', 'dateOfBirth', 0, 0, 1, 7, 3, 'getEmpBirthday', 'setEmpBirthday', '{\n    "datePickerConfig": {\n    "type": "CUSTOM",\n    "name": "datePickerConfig",\n    "additionalParam": {\n       "config" :{\n	"isDateOfBirth" : "true",\n    	"selectMonths"  : "true",\n    	"selectYears"   : "100"	\n	}\n    }\n  }\n}', 1, 'Date of Birth', 1, '', '', '', 1),
(6, '', 'txtLicenNo', 30, 0, 1, 14, 1, 'getLicenseNo', 'setLicenseNo', '', 1, 'Driver''s License Number', 1, '', '', '', 1),
(7, '', 'employeeId', 50, 1, 1, 5, 1, 'getEmployeeId', 'setEmployeeId', '', 1, 'Employee Id', 1, '', '', '', 1),
(8, '', 'mainId', 30, 0, 1, 6, 1, 'getSsn', 'setSsn', '', 1, 'Main Id', 1, '', '', '', 1),
(9, '', 'street1', 70, 0, 1, 310, 1, 'getStreet1', 'setStreet1', '', 4, 'Address Street 1', 1, '', '{\n    "action": "onChange",\n    "function": "workAndOtherEmailUniquenessValidation"\n}', '', 1),
(10, '', 'street2', 70, 0, 1, 311, 1, 'getStreet2', 'setStreet2', '', 4, 'Address Street 2', 1, '', '{\n    "action": "onChange",\n    "function": "otherAndWorkEmailUniquenessValidation"\n}', '', 1),
(11, '', 'city', 70, 0, 1, 312, 1, 'getCity', 'setCity', '', 4, 'City', 1, '', '', '', 1),
(12, '', 'province', 70, 0, 1, 324, 1, 'getProvince', 'setProvince', '', 4, 'State/Province', 1, '', '', '', 1),
(13, '', 'emp_zipcode', 10, 0, 1, 315, 1, 'getEmpZipcode', 'setEmpZipcode', '', 4, 'Zip/PostalCode', 1, '', '', '', 1),
(14, '', 'country', 0, 0, 1, 313, 2, 'getCountry', 'setCountry', '', 4, 'Country', 1, '{\n  "service": "countries",\n  "value": "cou_code",\n  "name": "cou_name"\n}', '', '', 1),
(15, '{\n  "phoneNumber": {\n    "type": "VALHELPER",\n    "message": "phoneNumber"\n  }\n\n}', 'emp_hm_telephone', 25, 0, 1, 320, 1, 'getEmpHmTelephone', 'setEmpHmTelephone', '{\n  "phoneNumber": {\n    "type": "FORMHELPER",\n    "name": "phoneNumber"\n  }}', 4, 'Home Telephone', 1, '', '', '', 1),
(16, '{\n  "phoneNumber": {\n    "type": "VALHELPER",\n    "message": "phoneNumber"\n  }\n\n}', 'emp_mobile', 25, 0, 1, 321, 1, 'getEmpMobile', 'setEmpMobile', '{\n  "phoneNumber": {\n    "type": "FORMHELPER",\n    "name": "phoneNumber"\n  }}', 4, 'Mobile', 1, '', '', '', 1),
(17, '{\n  "phoneNumber": {\n    "type": "VALHELPER",\n    "message": "phoneNumber"\n  }\n\n}', 'emp_work_telephone', 25, 0, 1, 322, 1, 'getEmpWorkTelephone', 'setEmpWorkTelephone', '{\n  "phoneNumber": {\n    "type": "FORMHELPER",\n    "name": "phoneNumber"\n  }}', 4, 'Work Telephone', 1, '', '', '', 1),
(18, '{\n  "workEmailValidation": {\n    "type": "CUSTOM",\n    "message": "Already exists"\n  },\n  "email": {\n    "type": "VALHELPER",\n    "message": "email"\n  },\n  "workAndOtherEmailUniquenessValidation": {\n    "type": "CUSTOM",\n    "message": "Already exists"\n  }\n}', 'emp_work_email', 50, 0, 1, 333, 1, 'getEmpWorkEmail', 'setEmpWorkEmail', '{\n  "workEmailValidation": {\n    "type": "CUSTOM",\n    "name": "workEmailUniquenessValidator"\n  },\n  "email": {\n    "type": "FORMHELPER",\n    "name": "email"\n  }\n}', 4, 'Work Email', 1, '', '{\n    "action": "onChange",\n    "function": "workAndOtherEmailUniquenessValidation"\n}', '', 1),
(19, '{\n  "otherEmailValidation": {\n    "type": "CUSTOM",\n    "message": "Already exists"\n  },\n  "email": {\n    "type": "VALHELPER",\n    "message": "email"\n  },\n  "otherAndWorkEmailUniquenessValidation": {\n    "type": "CUSTOM",\n    "message": "Already exists"\n  }\n}', 'emp_oth_email', 50, 0, 1, 334, 1, 'getEmpOthEmail', 'setEmpOthEmail', '{\n  "otherEmailValidation": {\n    "type": "CUSTOM",\n    "name": "otherEmailUniquenessValidator"\n  },\n  "email": {\n    "type": "FORMHELPER",\n    "name": "email"\n  }\n}', 4, 'Other Email', 1, '', '{\n    "action": "onChange",\n    "function": "otherAndWorkEmailUniquenessValidation"\n}', '', 1),
(20, '{\n  "beforeToDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or before the permanency and probation end date"\n  }\n\n}', 'joined_date', 0, 0, 1, 104, 3, 'getJoinedDate', 'setJoinedDate', '{\n	"beforeToDate": {\n		"type": "CUSTOM",\n		"name": "beforeToDate",\n		"additionalParam": {\n			"fieldId": "joined_date",\n			"compare": [\n				"probation_end_date", "date_of_permanency"\n			],\n			"formProcessor": "PimJobFormFactory",\n			"onChange": "validateJoinDates"\n		}\n	},\n	"datePickerConfig": {\n		"type": "CUSTOM",\n		"name": "datePickerConfig",\n		"additionalParam": {\n			"config": {\n				"selectMonths": "true",\n				"selectYears": "100"\n			}\n		}\n	}\n}', 2, 'Joined Date', 1, '', '', '', 1),
(25, '', 'typeId', 1, 1, 1, 410, 2, 'getTypeId', 'setTypeId', '', 5, 'Type', 0, '{\n  "service": "socialMediaTypes",\n  "value": "id",\n  "name": "name"\n}', '', '{"entity":"SocialMediaService","service":"SocialMediaService","functionName":"getSocialMediaTypeById","key":"getId","value":"getName"}', 1),
(26, '', 'profileName', 50, 1, 1, 430, 1, 'getProfileName', 'setProfileName', '', 5, 'Handle', 0, '', '', '', 1),
(27, '{\n  "url": {\n    "type": "VALHELPER",\n    "message": "url"\n  }\n\n}', 'profileLink', 50, 0, 1, 420, 1, 'getProfileLink', 'setProfileLink', '{\n  "url": {\n    "type": "FORMHELPER",\n    "name": "url"\n  }}', 5, 'Link', 1, '', '', '', 1),
(28, '', 'name', 50, 1, 1, 510, 1, 'getName', 'setName', '', 6, 'Name', 0, '', '', '', 1),
(29, '', 'relationship', 30, 1, 1, 520, 1, 'getRelationship', 'setRelationship', '', 6, 'Relationship', 0, '', '', '', 1),
(30, '{\n  "phoneNumber": {\n    "type": "VALHELPER",\n    "message": "phoneNumber"\n  }\n\n}', 'home_phone', 25, 1, 1, 540, 1, 'getHomePhone', 'setHomePhone', '{\n  "phoneNumber": {\n    "type": "FORMHELPER",\n    "name": "phoneNumber"\n  }}', 6, 'Home Telephone', 0, '', '', '', 1),
(31, '{\n  "phoneNumber": {\n    "type": "VALHELPER",\n    "message": "phoneNumber"\n  }\n\n}', 'mobile_phone', 25, 0, 0, 550, 1, 'getMobilePhone', 'setMobilePhone', '{\n  "phoneNumber": {\n    "type": "FORMHELPER",\n    "name": "phoneNumber"\n  }}', 6, 'Mobile', 1, '', '', '', 1),
(32, '{\n  "phoneNumber": {\n    "type": "VALHELPER",\n    "message": "phoneNumber"\n  }\n\n}', 'office_phone', 25, 0, 1, 560, 1, 'getOfficePhone', 'setOfficePhone', '{\n  "phoneNumber": {\n    "type": "FORMHELPER",\n    "name": "phoneNumber"\n  }}', 6, 'Work Telephone', 1, '', '', '', 1),
(34, '{\n  "afterFromDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or after the Joined Date"\n  }\n\n}', 'probation_end_date', 0, 0, 1, 105, 3, 'getProbationEndDate', 'setProbationEndDate', '{\n	"afterFromDate": {\n		"type": "CUSTOM",\n		"name": "afterFromDate",\n		"additionalParam": {\n			"fieldId": "probation_end_date",\n			"compare": [\n				"joined_date"\n			],\n			"formProcessor": "PimJobFormFactory",\n			"onChange": "validateJoinDates"\n		}\n	},\n	"datePickerConfig": {\n		"type": "CUSTOM",\n		"name": "datePickerConfig",\n		"additionalParam": {\n			"config": {\n				"selectMonths": "true",\n				"selectYears": "100"\n			}\n		}\n	}\n}', 2, 'Probation End Date', 1, '', '', '', 1),
(35, '{\n  "afterFromDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or after the Joined Date"\n  }\n\n}', 'date_of_permanency', 0, 0, 1, 106, 3, 'getDateOfPermanency', 'setDateOfPermanency', '{\n	"afterFromDate": {\n		"type": "CUSTOM",\n		"name": "afterFromDate",\n		"additionalParam": {\n			"fieldId": "date_of_permanency",\n			"compare": [\n				"joined_date"\n			],\n			"formProcessor": "PimJobFormFactory",\n			"onChange": "validateJoinDates"\n		}\n	},\n	"datePickerConfig": {\n		"type": "CUSTOM",\n		"name": "datePickerConfig",\n		"additionalParam": {\n			"config": {\n				"selectMonths": "true",\n				"selectYears": "100"\n			}\n		}\n	}\n}', 2, 'Date Of Permanency', 1, '', '', '', 1),
(36, '', 'job_title_id', 0, 0, 1, 107, 2, 'getJobTitleId', 'setJobTitleId', '', 2, 'Job Title', 1, '{\n  "service": "jobTitles",\n  "value": "id",\n  "name": "jobTitleName"\n}', '', '', 1),
(37, '', 'supervisorId', 0, 1, 1, 850, 5, 'getSupervisorId', 'setSupervisorId', '', 9, 'Name', 0, '', '{    "action": "onChange",    "function": "selectedEmployee"}', '{"entity":"Supervisor","service":"EmployeeService","functionName":"getEmployee","key":"getEmpNumber","value":"getFullName"}', 1),
(38, '', 'subordinateId', 0, 1, 1, 950, 5, 'getSubordinateId', 'setSubordinateId', '', 10, 'Name', 0, '', '{    "action": "onChange",    "function": "selectedEmployee"}', '{"entity":"Supervisor","service":"EmployeeService","functionName":"getEmployee","key":"getEmpNumber","value":"getFullName"}', 1),
(39, '', 'reportingMethodId', 0, 1, 1, 820, 2, 'getReportingMethodId', 'setReportingMethodId', '', 9, 'Reporting Method', 0, '{\n  "service": "employeeReportingMethods",\n  "value": "id",\n  "name": "name"\n}', '', '{"entity":"ReportTo","service":"ReportingMethodConfigurationService","functionName":"getReportingMethod","key":"getId","value":"getName"}', 1),
(40, '', 'employment_status_id', 0, 0, 1, 108, 2, 'getEmploymentStatusId', 'setEmploymentStatusId', '', 2, 'Employment Status', 1, '{\n  "service": "employmentStatus",\n  "value": "id",\n  "name": "name"\n}', '', '', 1),
(41, '', 'job_category_id', 0, 0, 1, 109, 2, 'getJobCategoryId', 'setJobCategoryId', '', 2, 'Job Category', 1, '{\n  "service": "jobCategories",\n  "value": "id",\n  "name": "name"\n}', '', '', 1),
(42, '', 'subunit_id', 0, 0, 1, 112, 2, 'getSubunitId', 'setSubunitId', '', 2, 'Sub Unit', 1, '{\n  "service": "subunits",\n  "value": "id",\n  "name": "name"\n}', '{    "action": "onChange",    "function": "changeCostCentre"}', '', 1),
(43, '', 'location', 0, 1, 1, 114, 2, 'getLocationId', 'setLocationId', '', 2, 'Location', 0, '{\n  "service": "employees/locations",\n  "value": "id",\n  "name": "name"\n}', '{\n    "action": "onChange",\n    "function": "isEeoApplicable"\n}', '', 1),
(44, '', 'work_shift_id', 0, 0, 1, 115, 2, 'getEmployeeWorkShiftId', '', '', 2, 'Work Shift', 1, '{\n  "service": "workShifts",\n  "value": "id",\n  "name": "name"\n}', '', '', 1),
(45, '', 'comment', 250, 0, 1, 170, 6, 'getComment', 'setComment', '', 2, 'Comment', 1, '', '', '', 1),
(46, '{\n  "beforeContractEndDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or before contract start date"\n  }\n\n}', 'contractStartDate', 0, 0, 1, 116, 3, 'getContractStartDate', 'setContractStartDate', '{\n	"beforeContractEndDate": {\n		"type": "CUSTOM",\n		"name": "beforeContractEndDate",\n		"additionalParam": {\n			"compare": [\n				"contractEndDate"\n			],\n			"formProcessor": "PimJobFormFactory",\n			"onChange": "validateContractDates"\n		}\n	},\n	"datePickerConfig": {\n		"type": "CUSTOM",\n		"name": "datePickerConfig",\n		"additionalParam": {\n			"config": {\n				"selectMonths": "true",\n				"selectYears": "100"\n			}\n		}\n	}\n}', 2, 'Contract Start Date', 1, '', '', '', 1),
(47, '{\n  "afterContractStartDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or after the contract end date"\n  }\n\n}', 'contractEndDate', 0, 0, 1, 117, 3, 'getContractEndDate', 'setContractEndDate', '{\n    "afterContractStartDate": {\n    "type": "CUSTOM",\n        "name": "afterContractStartDate",\n        "additionalParam": {\n        "compare": [\n            "contractEndDate"\n        ],\n            "formProcessor": "PimJobFormFactory",\n            "onChange":"validateContractDates"\n    }\n},\n"datePickerConfig": {\n    "type": "CUSTOM",\n    "name": "datePickerConfig",\n    "additionalParam": {\n       "config":{\n    	"selectMonths"  : "true",\n    	"selectYears"   : "100"	\n	}\n    }\n  }\n}', 2, 'Contract End Date', 1, '', '', '', 1),
(48, '', 'firstName', 30, 1, 1, 3, 1, 'getFirstName', 'setFirstName', '', 1, 'First Name', 0, '', '', '', 1),
(49, '', 'lastName', 30, 1, 1, 4, 1, 'getLastName', 'setLastName', '', 1, 'Last Name', 0, '', '', '', 1),
(50, '', 'reportingMethodId', 0, 1, 1, 920, 2, 'getReportingMethodId', 'setReportingMethodId', '', 10, 'Subordinate Reporting Method', 0, '{\n  "service": "employeeReportingMethods",\n  "value": "id",\n  "name": "name"\n}', '', '{"entity":"ReportTo","service":"ReportingMethodConfigurationService","functionName":"getReportingMethod","key":"getId","value":"getName"}', 1),
(51, '', 'name', 50, 1, 1, 610, 1, 'getName', 'setName', '', 7, 'Name', 0, '', '', '', 1),
(52, '', 'relationship', 0, 1, 1, 620, 2, 'getRelationshipType', 'setRelationshipType', '', 7, 'Relationship', 0, '{"choices":[\n    {"key":"child", "value":"Child"},\n    {"key":"other", "value":"Other"}\n]}', '', '', 1),
(53, '', 'date_of_birth', 0, 0, 1, 630, 3, 'getDateOfBirth', 'setDateOfBirth', '{\n    "datePickerConfig": {\n    "type": "CUSTOM",\n    "name": "datePickerConfig",\n    "additionalParam": {\n       "config" :{\n	"isDateOfBirth" : "true",\n    	"selectMonths"  : "true",\n    	"selectYears"   : "100"	\n	}\n    }\n  }\n}', 7, 'Date of Birth', 1, '', '', '', 1),
(54, '', 'type', 0, 1, 1, 710, 2, 'gettype', 'settype', '', 8, 'Document', 0, '{"choices":[\n    {"key":"1", "value":"Passport"},\n    {"key":"2", "value":"Visa"}\n]}', '', '', 1),
(55, '', 'number', 30, 1, 1, 720, 1, 'getNumber', 'setNumber', '', 8, 'Number', 0, '', '', '', 1),
(56, '{\n  "beforeToDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or before the expiry date"\n  }\n\n}', 'issuedDate', 0, 0, 1, 750, 3, 'getIssuedDate', 'setIssuedDate', '{\n    "beforeToDate": {\n    "type": "CUSTOM",\n        "name": "beforeToDate",\n        "additionalParam": {\n"fieldId":"issuedDate",\n        "compare": [\n            "expiryDate"\n        ],\n            "formProcessor": "PimImmigrationDetailsFormFactory",\n            "onChange":"onChangeValidation"\n    }\n},\n "datePickerConfig": {\n    "type": "CUSTOM",\n    "name": "datePickerConfig",\n    "additionalParam": {\n       "config":{\n    	"selectMonths"  : "true",\n    	"selectYears"   : "100"	\n	}\n    }\n  }\n}', 8, 'Issued Date', 1, '', '', '', 1),
(57, '{\n  "afterFromDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or after the issued date"\n  }\n\n}', 'expiryDate', 0, 0, 1, 760, 3, 'getExpiryDate', 'setExpiryDate', '{\n	"afterFromDate": {\n		"type": "CUSTOM",\n		"name": "afterFromDate",\n		"additionalParam": {\n			"fieldId": "expiryDate",\n			"compare": [\n				"issuedDate"\n			],\n			"formProcessor": "PimImmigrationDetailsFormFactory",\n			"onChange": "onChangeValidation"\n		}\n	},\n	"datePickerConfig": {\n		"type": "CUSTOM",\n		"name": "datePickerConfig",\n		"additionalParam": {\n			"config": {\n				"selectMonths": "true",\n				"selectYears": "100"\n			}\n		}\n	}\n}', 8, 'Expiry Date', 1, '', '', '', 1),
(58, '', 'immigrationStatus', 30, 0, 1, 730, 1, 'getStatus', 'setStatus', '', 8, 'Eligible Status', 1, '', '', '', 1),
(59, '', 'countryCode', 0, 0, 1, 740, 2, 'getCouCode', 'setCouCode', '', 8, 'Issued By', 1, '{\n  "service": "countries",\n  "value": "cou_code",\n  "name": "cou_name"\n}', '', '{"entity":"Country","service":"CountryService","functionName":"getCountryByCountryCode","key":"getCouCode","value":"getName"}', 1),
(60, '', 'reviewDate', 0, 0, 1, 770, 3, 'getReviewDate', 'setReviewDate', '{\n	"datePickerConfig": {\n		"type": "CUSTOM",\n		"name": "datePickerConfig",\n		"additionalParam": {\n			"config": {\n				"selectMonths": "true",\n				"selectYears": "100"\n			}\n		}\n	}\n}', 8, 'Eligible Review Date', 1, '', '', '', 1),
(61, '', 'notes', 250, 0, 1, 780, 6, 'getNotes', 'setNotes', '', 8, 'Comments', 1, '', '', '', 1),
(62, '{\n"validateMaxAmount": {\n    "type": "CUSTOM",\n    "message": "Should be less than 1000,000,000"\n},\n  "numericValidation": {\n    "type": "CUSTOM",\n    "message": "Should be a valid number"\n  }\n}', 'amount', 0, 1, 1, 1609, 1, 'getAmount', 'setAmount', '{\n"validateMaxAmount": {\n    "type": "CUSTOM",\n    "name": "validateMaxAmount",\n    "additionalParam": {\n        "maxValue":"1000000000"\n    }\n  },\n  "numericValidation": {\n    "type": "CUSTOM",\n    "name": "numericValidation"\n  }\n}', 17, 'Amount', 0, '', '', '', 1),
(63, '', 'account_number', 100, 1, 1, 1610, 1, 'getAccountNumber', 'setAccountNumber', '', 17, 'Account Number', 0, '', '', '', 1),
(64, '', 'institute_name', 255, 0, 1, 1612, 1, 'getInstituteName', 'setInstituteName', '', 17, 'Financial Institute', 1, '', '', '', 1),
(65, '', 'account_type', 0, 0, 1, 1622, 2, 'getAccountType', 'setAccountType', '', 17, 'Account Type', 1, '{"choices":[\n    {"key":"Check", "value":"Check"},\n    {"key":"Saving", "value":"Saving"}\n]}', '', '', 1),
(66, '', 'branch_location', 255, 0, 1, 1624, 1, 'getBranchLocation', 'setBranchLocation', '', 17, 'Branch Location', 1, '', '', '', 1),
(67, '', 'routing_number', 255, 0, 1, 1640, 1, 'getRoutingNumber', 'setRoutingNumber', '', 17, 'Routing Number', 1, '', '', '', 1),
(68, '', 'membershipId', 0, 1, 1, 1510, 2, 'getMembershipId', 'setMembershipId', '', 16, 'Membership', 0, '{\n  "service": "memberships",\n  "value": "id",\n  "name": "name"\n}', '', '{"entity":"MembershipService","service":"MembershipService","functionName":"getMembershipById","key":"getId","value":"getName"}', 1),
(69, '', 'subscriptionPaidBy', 0, 0, 1, 1511, 2, 'getSubscriptionPaidBy', 'setSubscriptionPaidBy', '', 16, 'Subscription Paid By', 1, '{"choices":[\n    {"key":"Company", "value":"Company"},\n    {"key":"Individual", "value":"Individual"}\n]}', '', '', 1),
(70, '', 'subscriptionCurrency', 0, 0, 1, 1512, 2, 'getSubscriptionCurrency', 'setSubscriptionCurrency', '', 16, 'Currency', 1, '{\n  "service": "currency",\n  "value": "currency_id",\n  "name": "currency_name"\n}', '', '', 1),
(71, '{\n  "beforeToDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or before the subscription renewal date"\n  }\n\n}', 'subscriptionCommenceDate', 0, 0, 1, 1535, 3, 'getSubscriptionCommenceDate', 'setSubscriptionCommenceDate', '{\n    "beforeToDate": {\n    "type": "CUSTOM",\n        "name": "beforeToDate",\n        "additionalParam": {\n"fieldId":"subscriptionCommenceDate",\n        "compare": [\n            "subscriptionRenewalDate"\n        ],\n            "formProcessor": "PimMembershipFormFactory",\n            "onChange":"onChangeValidation"\n    }\n},\n"datePickerConfig": {\n    "type": "CUSTOM",\n    "name": "datePickerConfig",\n    "additionalParam": {\n       "config":{\n    	"selectMonths"  : "true",\n    	"selectYears"   : "100"	\n	}\n    }\n  }\n}', 16, 'Subscription Commence Date', 1, '', '', '', 1),
(72, '{\n  "afterFromDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or after the  commence date"\n  }\n\n}', 'subscriptionRenewalDate', 0, 0, 1, 1513, 3, 'getSubscriptionRenewalDate', 'setSubscriptionRenewalDate', '{\n	"afterFromDate": {\n		"type": "CUSTOM",\n		"name": "afterFromDate",\n		"additionalParam": {\n			"fieldId": "subscriptionRenewalDate",\n			"compare": [\n				"subscriptionCommenceDate"\n			],\n			"formProcessor": "PimMembershipFormFactory",\n			"onChange": "onChangeValidation"\n		}\n	},\n	"datePickerConfig": {\n		"type": "CUSTOM",\n		"name": "datePickerConfig",\n		"additionalParam": {\n			"config": {\n				"selectMonths": "true",\n				"selectYears": "100"\n			}\n		}\n	}\n}', 16, 'Subscription Renewal Date', 1, '', '', '', 1),
(73, '{\n	"validateMaxAmount": {\n		"type": "CUSTOM",\n		"message": "Should be less than 1000,000,000.00"\n	},\n	"numericValidation": {\n		"type": "CUSTOM",\n		"message": "Should be a valid number"\n	}\n}', 'subscriptionFee', 0, 0, 1, 1562, 1, 'getSubscriptionFee', 'setSubscriptionFee', '{\n	"validateMaxAmount": {\n		"type": "CUSTOM",\n		"name": "validateMaxAmount",\n		"additionalParam": {\n			"maxValue": "1000000000"\n		}\n	},\n	"numericValidation": {\n		"type": "CUSTOM",\n		"name": "numericValidation"\n	}\n}', 16, 'Subscription Amount', 1, '', '', '', 1),
(74, '', 'employer', 100, 1, 1, 1010, 1, 'getEmployer', 'setEmployer', '', 11, 'Company', 0, '', '', '', 1),
(75, '', 'jobtitle', 100, 1, 1, 1020, 1, 'getJobtitle', 'setJobtitle', '', 11, 'Job Title', 0, '', '', '', 1),
(76, '{\n  "beforeToDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or before the to date"\n  }\n\n}', 'from_date', 0, 0, 0, 1050, 3, 'getFromDate', 'setFromDate', '{\n    "beforeToDate": {\n    "type": "CUSTOM",\n        "name": "beforeToDate",\n        "additionalParam": {\n"fieldId":"from_date",\n        "compare": [\n            "to_date"\n        ],\n            "formProcessor": "PimWorkExperienceFormFactory",\n            "onChange":"onChangeValidation"\n    }\n},\n "datePickerConfig": {\n    "type": "CUSTOM",\n    "name": "datePickerConfig",\n    "additionalParam": {\n       "config":{\n    	"selectMonths"  : "true",\n    	"selectYears"   : "100"	\n	}\n    }\n  }\n}', 11, 'From', 1, '', '', '', 1),
(77, '{\n  "afterFromDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or after the from date"\n  }\n\n}', 'to_date', 0, 0, 0, 1060, 3, 'getToDate', 'setToDate', '{\n	"afterFromDate": {\n		"type": "CUSTOM",\n		"name": "afterFromDate",\n		"additionalParam": {\n			"fieldId": "to_date",\n			"compare": [\n				"from_date"\n			],\n			"formProcessor": "PimWorkExperienceFormFactory",\n			"onChange": "onChangeValidation"\n		}\n	},\n	"datePickerConfig": {\n		"type": "CUSTOM",\n		"name": "datePickerConfig",\n		"additionalParam": {\n			"config": {\n				"selectMonths": "true",\n				"selectYears": "100"\n			}\n		}\n	}\n}', 11, 'To', 1, '', '', '', 1),
(78, '', 'comments', 0, 0, 0, 1090, 1, 'getComments', 'setComments', '', 11, 'Comment', 1, '', '', '', 1),
(79, '', 'licenseId', 0, 1, 1, 1410, 2, 'getLicenseId', 'setLicenseId', '', 15, 'License Type', 0, '{\n  "service": "employees/employeeLicenseList",\n  "value": "id",\n  "name": "name"\n}', '', '{"entity":"LicenseService","service":"LicenseService","functionName":"getLicenseById","key":"getId","value":"getName"}', 1),
(80, '', 'licenseNo', 0, 0, 1, 1420, 1, 'getLicenseNo', 'setLicenseNo', '', 15, 'License Number', 1, '', '', '', 1),
(81, '{\n  "beforeToDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or before the expiry date"\n  }\n\n}', 'licenseIssuedDate', 0, 1, 1, 1430, 3, 'getLicenseIssuedDate', 'setLicenseIssuedDate', '{\n    "beforeToDate": {\n    "type": "CUSTOM",\n        "name": "beforeToDate",\n        "additionalParam": {\n"fieldId":"licenseIssuedDate",\n        "compare": [\n            "licenseExpiryDate"\n        ],\n            "formProcessor": "PimLicenseFormFactory",\n            "onChange":"onChangeValidation"\n    }\n},\n "datePickerConfig": {\n    "type": "CUSTOM",\n    "name": "datePickerConfig",\n    "additionalParam": {\n       "config":{\n    	"selectMonths"  : "true",\n    	"selectYears"   : "100"	\n	}\n    }\n  }\n}', 15, 'Issued Date', 1, '', '', '', 1),
(82, '{\n  "afterFromDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or after the issued date"\n  }\n\n}', 'licenseExpiryDate', 0, 1, 1, 1445, 3, 'getLicenseExpiryDate', 'setLicenseExpiryDate', '{\n	"afterFromDate": {\n		"type": "CUSTOM",\n		"name": "afterFromDate",\n		"additionalParam": {\n			"fieldId": "licenseExpiryDate",\n			"compare": [\n				"licenseIssuedDate"\n			],\n			"formProcessor": "PimLicenseFormFactory",\n			"onChange": "onChangeValidation"\n		}\n	},"datePickerConfig": {\n    "type": "CUSTOM",\n    "name": "datePickerConfig",\n    "additionalParam": {\n       "config":{\n    	"selectMonths"  : "true",\n    	"selectYears"   : "100"	\n	}\n    }\n  }\n\n}', 15, 'Expiry Date', 1, '', '', '', 1),
(83, '', 'langId', 0, 1, 1, 1310, 2, 'getLangId', 'setLangId', '', 14, 'Language', 0, '{\n  "service": "employees/employeeLanguageList",\n  "value": "id",\n  "name": "name"\n}', '', '{"entity":"LanguageService","service":"LanguageService","functionName":"getLanguageById","key":"getId","value":"getName"}', 1),
(84, '', 'competency', 0, 1, 1, 1320, 2, 'getCompetency', 'setCompetency', '', 14, 'Skill', 0, '{"choices":[\n    {"key":"1","value":"Writing"},\n    {"key":"2", "value":"Speaking"},{"key":"3", "value":"Reading"}\n]}', '', '', 1),
(85, '', 'fluency', 0, 1, 1, 1325, 2, 'getFluency', 'setFluency', '', 14, 'Fluency Level', 0, '{"choices":[\n    {"key":"1","value":"Poor"},\n    {"key":"2", "value":"Basic"},{"key":"3", "value":"Good"},{"key":"4", "value":"Mother Tongue"}\n]}', '', '', 1),
(86, '', 'comments', 0, 0, 1, 1390, 6, 'getComments', 'setComments', '', 14, 'Comments', 1, '', '', '', 1),
(87, '', 'skillId', 0, 1, 1, 1230, 2, 'getSkillId', 'setSkillId', '', 13, 'Skills', 0, '{\n  "service": "skills",\n  "value": "id",\n  "name": "name"\n}', '', '{"entity":"SkillService","service":"SkillService","functionName":"getSkillById","key":"getId","value":"getName"}', 1),
(88, '{\n	"validateMaxAmount": {\n		"type": "CUSTOM",\n		"message": "Should be less than 100"\n	},\n	"numericValidation": {\n		"type": "CUSTOM",\n		"message": "Should be a valid number"\n	}\n}', 'years_of_exp', 2, 1, 1, 1235, 1, 'getYearsOfExp', 'setYearsOfExp', '{\n	"validateMaxAmount": {\n		"type": "CUSTOM",\n		"name": "validateMaxAmount",\n		"additionalParam": {\n			"maxValue": "99"\n		}\n	},\n	"numericValidation": {\n		"type": "CUSTOM",\n		"name": "numericValidation"\n	}\n}', 13, 'Year of Experience', 1, '', '', '', 1),
(89, '', 'comments', 0, 0, 1, 1240, 6, 'getComments', 'setComments', '', 13, 'Comments', 0, '', '', '', 1),
(90, '', 'educationId', 0, 1, 1, 1110, 2, 'getEducationId', 'setEducationId', '', 12, 'Level', 0, '{\n  "service": "education",\n  "value": "id",\n  "name": "name"\n}', '', '{"entity":"Education","service":"EducationService","functionName":"getEducationById","key":"getId","value":"getName"}', 1),
(91, '', 'major', 100, 0, 1, 1130, 1, 'getMajor', 'setMajor', '', 12, 'Major/Specialization', 1, '', '', '', 1),
(92, '{\n  "numeric": {\n    "type": "VALHELPER",\n    "message": "numeric"\n  },\n  "validateMaxAmount": {\n    "type": "CUSTOM",\n    "message": "Should be less than 10000"\n}\n\n\n}', 'year', 0, 0, 1, 1140, 1, 'getYear', 'setYear', '{\n	"numeric": {\n		"type": "FORMHELPER",\n		"name": "numeric"\n	},\n	"validateMaxAmount": {\n		"type": "CUSTOM",\n		"name": "validateMaxAmount",\n		"additionalParam": {\n			"maxValue": "10000"\n		}\n	}\n}', 12, 'Year', 1, '', '', '', 1),
(93, '{\n  "numericWithDigits": {\n    "type": "VALHELPER",\n    "message": "numericWithDigits"\n  }\n\n}', 'score', 25, 0, 1, 1150, 1, 'getScore', 'setScore', '{\n  "numericWithDigits": {\n    "type": "FORMHELPER",\n    "name": "numericWithDigits"\n  }}', 12, 'GPA/Score', 1, '', '', '', 1),
(94, '{\n  "beforeToDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or before the end date"\n  }\n\n}', 'startDate', 0, 0, 1, 1160, 3, 'getStartDate', 'setStartDate', '{\n	"beforeToDate": {\n		"type": "CUSTOM",\n		"name": "beforeToDate",\n		"additionalParam": {\n			"fieldId": "startDate",\n			"compare": [\n				"endDate"\n			],\n			"formProcessor": "PimEducationFormFactory",\n			"onChange": "onChangeValidation"\n		}\n	},\n	"datePickerConfig": {\n		"type": "CUSTOM",\n		"name": "datePickerConfig",\n		"additionalParam": {\n			"config": {\n				"selectMonths": "true",\n				"selectYears": "100"\n			}\n		}\n	}\n}', 12, 'Start Date', 1, '', '', '', 1),
(95, '{\n  "afterFromDate": {\n    "type": "CUSTOM",\n    "message": "Should be on or after the start date"\n  }\n\n}', 'endDate', 0, 0, 1, 1170, 3, 'getEndDate', 'setEndDate', '{\n	"afterFromDate": {\n		"type": "CUSTOM",\n		"name": "afterFromDate",\n		"additionalParam": {\n			"fieldId": "endDate",\n			"compare": [\n				"startDate"\n			],\n			"formProcessor": "PimEducationFormFactory",\n			"onChange": "onChangeValidation"\n		}\n	},\n	"datePickerConfig": {\n		"type": "CUSTOM",\n		"name": "datePickerConfig",\n		"additionalParam": {\n			"config": {\n				"selectMonths": "true",\n				"selectYears": "100"\n			}\n		}\n	}\n\n}', 12, 'End Date', 1, '', '', '', 1),
(96, '', 'payGradeId', 0, 0, 1, 220, 2, 'getPayGradeId', 'setPayGradeId', '', 3, 'Pay Grade', 1, '{\n  "service": "payGrades",\n  "value": "id",\n  "name": "name"\n}', '', '', 1),
(97, '', 'currencyId', 0, 0, 1, 230, 2, 'getCurrencyId', 'setCurrencyId', '', 3, 'Currency', 1, '{\n  "service": "currencyType",\n  "value": "currency_id",\n  "name": "currency_name"\n}', '', '', 1),
(98, '', 'comments', 0, 0, 1, 270, 6, 'getComment', 'setComment', '', 3, 'Comments', 1, '', '', '', 1),
(99, '{\n  "numeric": {\n    "type": "VALHELPER",\n    "message": "numeric"\n  }\n\n}', 'amount', 0, 1, 1, 240, 1, '', '', '{\n  "numeric": {\n    "type": "FORMHELPER",\n    "name": "numeric"\n  }}', 3, 'Annual Basic Payment(amount)', 0, '', '', '', 1),
(100, '', 'effective_date', 0, 0, 1, 210, 3, '', '', '{\n        "datePickerConfig": {\n            "type": "CUSTOM",\n            "name": "datePickerConfig",\n            "additionalParam": {\n                "config": {\n                    "selectMonths": "true",\n                    "selectYears": "100"\n                }\n            }\n        }\n    }\n', 3, 'Effective Date', 1, '', '', '', 1),
(101, '', 'institute', 100, 0, 1, 1120, 1, 'getInstitute', 'setInstitute', '', 12, 'Institute', 1, '', '', '', 1),
(103, '', 'specify', 100, 1, 1, 689, 1, '', '', '{\n	"condition": "employeeWizard.model.PimDependentFormFactory.relationship==''other''"\n}', 7, 'Please Specify', 1, '', '', '', 1),
(104, '', 'creditable', 0, 0, 1, 1080, 7, 'getCreditable', 'setCreditable', '', 11, 'Creditable', 0, '', '', '', 1),
(105, '', 'smoker', 0, 0, 1, 1080, 7, 'getSmoker', 'setSmoker', '', 1, 'Smoker', 1, '', '', '', 0),
(106, '', 'nickName', 30, 0, 1, 1080, 1, 'getNickName', 'setNickName', '', 1, 'Nick Name', 1, '', '', '', 0),
(107, '', 'militaryService', 30, 0, 1, 1080, 1, 'getMilitaryService', 'setMilitaryService', '', 1, 'Military Service', 1, '', '', '', 0),
(108, '', 'costCentre', 0, 0, 1, 120, 9, '', '', '', 2, 'Cost Center', 1, '', '', '', 0),
(109, '', 'event', 0, 1, 1, 140, 2, 'getEventName', 'setEventName', '', 2, 'Event', 0, '{\r\n  "choices": [\r\n    {\r\n      "key": "joined",\r\n      "value": "Joined"\r\n    },\r\n    {\r\n      "key": "promoted",\r\n      "value": "Promoted"\r\n    },\r\n    {\r\n      "key": "salary_increment",\r\n      "value": "Salary Increment"\r\n    },\r\n    {\r\n      "key": "initial_contract",\r\n      "value": "Initial Contract"\r\n    },\r\n    {\r\n      "key": "contract_renewal",\r\n      "value": "Contract Renewal"\r\n    },\r\n    {\r\n      "key": "other",\r\n      "value": "Other"\r\n    },\r\n    {\r\n      "key": "error_correction",\r\n      "value": "Error Correction"\r\n    }\r\n    \r\n  ]\r\n}', '', '', 0),
(110, '', 'changes_Effective_from', 0, 1, 1, 180, 3, 'getEffectiveDate', 'setEffectiveDate', '', 2, 'Effective From', 0, '', '', '', 1),
(111, '', 'sin', 30, 0, 1, 120, 1, 'getSin', 'setSin', '', 1, 'SIN Number', 1, '', '', '', 0),
(112, '', 'eeo_race_and_ethnicity', 0, 1, 1, 1000, 2, 'getEeoRaceEnt', 'setEeoRaceEnt', '{\n	"condition": "employeeWizard.eeoEnabled"\n}', 1, 'EEO Race and Ethnicity', 0, '{\n  "service": "eeoEthnicity",\n  "value": "id",\n  "name": "name"\n}', '', '', 0),
(113, '', 'flsa_exempt', 0, 0, 1, 150, 7, 'getFlsaExempt', 'setFlsaExempt', '{\n	"condition": "employeeWizard.eeoEnabled"\n}', 2, 'FLSA Exempt', 1, '', '', '', 0),
(114, '', 'eeo_job_category', 0, 0, 1, 160, 2, 'getEeoJobCategory', 'setEeoJobCategory', '{\n	"condition": "employeeWizard.eeoEnabled"\n}', 2, 'EEO Job Category', 1, '{\n  "service": "eeoJobCategories",\n  "value": "id",\n  "name": "name"\n}', '', '', 0),
(115, '', 'eeo_eeo_paygrade', 0, 0, 1, 250, 2, 'getEeoPaygrade', 'setEeoPaygrade', '{\r\n	"condition": "employeeWizard.eeoEnabled"\r\n}', 3, 'EEO Pay Band', 1, '{\n  "service": "eeoEmpPayGrades",\n  "value": "id",\n  "name": "name"\n}', '', '', 0);
SET @module_id = (SELECT `id` FROM `ohrm_module` WHERE `name` = 'pim');


INSERT INTO `ohrm_screen` (`name`, `module_id`, `action_url`)
VALUES ('Add Employee Wizard', @module_id, 'pimFieldConfiguration');

SET @screenId := (SELECT LAST_INSERT_ID());
SET @parentId := (SELECT id FROM `ohrm_menu_item` WHERE `menu_title` = 'Configuration' AND `parent_id` in (SELECT id FROM `ohrm_menu_item` WHERE `menu_title` = 'PIM'));

INSERT INTO `ohrm_menu_item` (`menu_title`, `menu_category`, `screen_id`, `parent_id`, `level`, `order_hint`, `url_extras`, `status`,`uisref`)
VALUES ('Add Employee Wizard', NULL, @screenId, @parentId, '3', 400, NULL, '1','pim.configure_employee_wizard');

SET @menuItemId := (SELECT LAST_INSERT_ID());

INSERT INTO `ohrm_data_group` (`name`, `description`, `can_read`, `can_create`, `can_update`, `can_delete`)
VALUES ('add_employee_wizard', 'PIM - Configure - Add Employee Wizard', '1', '1', '1', '1');

SET @addEmployeeWizardDataGroupId := (SELECT LAST_INSERT_ID());

SET @userRoleTypeId := (SELECT `id` FROM  `ohrm_user_role_type` WHERE  `name` ='Admin');

INSERT INTO `ohrm_menu_item_data_group` (`menu_item_id`, `data_group_id`)
VALUES (@menuItemId, @addEmployeeWizardDataGroupId);

INSERT INTO `ohrm_data_group_screen` (`data_group_id`, `screen_id`, `permission`, `self`)
VALUES (@addEmployeeWizardDataGroupId, @screenId, '1', '0');

SET @userRoleId := (SELECT `id` FROM `ohrm_user_role` WHERE `name` = 'Admin');

INSERT INTO `ohrm_user_role_screen` (`user_role_id`, `screen_id`, `can_read`, `can_create`, `can_update`, `can_delete`)
VALUES (@userRoleId, @screenId, '1', '1', '1', '1');

INSERT INTO `ohrm_user_role_data_group` (`user_role_id`, `data_group_id`, `can_read`, `can_create`, `can_update`, `can_delete`, `self`)
VALUES (@userRoleId, @addEmployeeWizardDataGroupId, '1', '1', '1', '1', '0');

INSERT INTO `ohrm_user_role_type_data_group` (`user_role_type_id`, `data_group_id`, `can_read`, `can_create`, `can_update`, `can_delete`) VALUES (@userRoleTypeId, @addEmployeeWizardDataGroupId, '1', '0', '1', '0');
