INSERT INTO `kra_master` (`kra_id`, `employee_id`, `perspective_id`, `kra_name`, `measures`, `target`, `weight`, `approved_date`, `submit_date`, `common_self`, `year`, `ee`, `ot`, `ni`, `be`, `total_weight`, `January`, `February`, `March`, `April`, `May`, `June`, `July`, `August`, `September`, `October`, `November`, `December`, `sendback_note`, `create_date`, `status`, `another_status`, `evalution_approved_date`) VALUES
(8614, '223', 2, 'Internal Customer Survey (Quality of Delivery & Quality of Service)', 'Ensure completion of feedback received on Internal Customer Service Effectiveness Feedback tool online.Analyse Results from the Internal Customer Survey (Every department Head must use the Standardised Survey tool available in the HCM Portal, with common parameters and questions for all Support Functions).Identify 2 low score areas and work on improving them with clear actions. Compare and report improvement in scores in next survey in 6 months.', 'August 31, 2020 September 30, 20 Move the 2 low score areas by at least 0.5 from the current Apr-20', '5', NULL, '2020-03-16', 2, 2020, NULL, NULL, NULL, NULL, '95.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8615, '223', 2, 'Improve Customer pass rate from 80% to 90%', 'Increase FTT, OQC pass rate, QA pass rate ', '90%', '10', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '95.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8616, '223', 2, 'Reduce Customer complaints from 1.6% to 1.00% of orders shipped', 'Customer pass rate, QA pass rate, OQC pass rate', '1% of order shipped', '10', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '95.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8617, '223', 3, '360-degree Feedback for self', 'Submit request for feedback on online HCM portal tool and receive feedback by.Based on results Identify and select at least one area to develop .Complete the next feedback in 12 months.', 'October 31, 2020 Increase lowest scoring area by at least 0.5 from current score in 12 months October 31, 2021', '10', NULL, '2020-03-16', 2, 2020, NULL, NULL, NULL, NULL, '95.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8618, '223', 3, 'Develop  PQC & OQC to improve the Quality sense', '% On time training delivery % Average evaluation score % Rejection decreased (after training)', '100% 85% <2%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '95.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8619, '223', 3, 'Floor PQC and OQC team will capable to do all related internal report', '% On time accurate report submission', '100%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '95.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8620, '223', 4, 'Kaizen', 'Number of Kaizens submitted by the department every  month Number of Kaizens submitted per staff  ', 'Minimum 4At least 1 Kaizen per staff  per month / Minimum 10 Kaizens each in 12 months', '10', NULL, '2020-03-16', 2, 2020, NULL, NULL, NULL, NULL, '95.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8621, '223', 4, 'S6S', 'Minimum Target Score achievement irrespective of Zone / Sub-Zone', '60%', '10', NULL, '2020-03-16', 2, 2020, NULL, NULL, NULL, NULL, '95.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8622, '223', 4, 'Floor QA team will play their role IQC & Pilot stage', 'Follow as per Pilot schedule, QCO schedule', '100%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '95.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8623, '223', 4, 'Weekly Floor quality Audit and report accuracy', '% On time accurate report submission', '100%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '95.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8624, '223', 4, 'Conduct Unified meeting and ensure the bulk quality', 'As per QCO schedule', '100%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '95.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8625, '101', 1, 'Reduce Quality Rework rate to 4.5% to 2.5% base on total order quantity', 'Quality Standard set up during QCO, Reduce the final inspection rejection', '2.5%', '10', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8626, '101', 1, 'Reduce the floor basis Quality Labor Loss hour by 50% from 2019 monthly average (1027 hours)', '# Avg Quality rework loss hour / month', '100 H', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8627, '101', 2, 'Internal Customer Survey (Quality of Delivery & Quality of Service)', 'Ensure completion of feedback received on Internal Customer Service Effectiveness Feedback tool online.Analyse Results from the Internal Customer Survey (Every department Head must use the Standardised Survey tool available in the HCM Portal, with common parameters and questions for all Support Functions).Identify 2 low score areas and work on improving them with clear actions. Compare and report improvement in scores in next survey in 6 months.', 'August 31, 2020 September 30, 20 Move the 2 low score areas by at least 0.5 from the current Apr-20', '5', NULL, '2020-03-16', 2, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8628, '101', 2, 'Improve Customer pass rate from 80% to 90%', 'Increase FTT, OQC pass rate, QA pass rate ', '90%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8629, '101', 2, 'Reduce Customer complaints from 1.6% to 1.00% of orders shipped', 'Customer pass rate, QA pass rate, OQC pass rate', '1% of order shipped', '10', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8630, '101', 3, '360-degree Feedback for self', 'Submit request for feedback on online HCM portal tool and receive feedback by.Based on results Identify and select at least one area to develop .Complete the next feedback in 12 months.', 'October 31, 2020 Increase lowest scoring area by at least 0.5 from current score in 12 months October 31, 2021', '10', NULL, '2020-03-16', 2, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8631, '101', 3, 'Floor wise 50% of IPQC to be upgraded to FQC activities', 'Practical training, skill matrix, ', '50%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8632, '101', 3, 'Improve QC skill inventory by 15% through calibration and training', ' QC skill inventory calibration and training', '15%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8633, '101', 4, 'Kaizen', 'Number of Kaizens submitted by the department every  month Number of Kaizens submitted per staff  ', 'Minimum 4At least 1 Kaizen per staff  per month / Minimum 10 Kaizens each in 12 months', '10', NULL, '2020-03-16', 2, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8634, '101', 4, 'S6S', 'Minimum Target Score achievement irrespective of Zone / Sub-Zone', '60%', '10', NULL, '2020-03-16', 2, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8635, '101', 4, 'QC team will capable to do all related internal report', '% On time accurate report submission', '100%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8636, '101', 4, 'Monthly updated quality memory and QC file', '% On time accurate report submission', '100%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8637, '101', 4, 'QC work plan implementation', 'Number of Mismatch in line (0/<1)', '0/<1', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8638, '101', 4, 'Achieve TQM Audit score of 85%', 'Monthly Quality lean tools and quality system audit', '85%', '10', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8639, '224', 1, 'Reduce Quality Rework rate to 4.5% to 2.5% base on total order quantity', 'Quality Standard set up during QCO, Reduce the final inspection rejection', '2.5%', '10', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8640, '224', 1, 'Reduce the floor basis Quality Labor Loss hour by 50% from 2019 monthly average (1027 hours)', '# Avg Quality rework loss hour / month $ Customer claim on quality', '100 H', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8641, '224', 2, 'Internal Customer Survey (Quality of Delivery & Quality of Service)', 'Ensure completion of feedback received on Internal Customer Service Effectiveness Feedback tool online.Analyse Results from the Internal Customer Survey (Every department Head must use the Standardised Survey tool available in the HCM Portal, with common parameters and questions for all Support Functions).Identify 2 low score areas and work on improving them with clear actions. Compare and report improvement in scores in next survey in 6 months.', 'August 31, 2020 September 30, 20 Move the 2 low score areas by at least 0.5 from the current Apr-20', '5', NULL, '2020-03-16', 2, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8642, '224', 2, 'Improve Customer pass rate from 80% to 90%', 'Increase FTT, OQC pass rate, QA pass rate ', '90%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8643, '224', 2, 'Reduce Customer complaints from 1.6% to 1.00% of orders shipped', 'Customer pass rate, QA pass rate, OQC pass rate', '1% of order shipped', '10', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8644, '224', 3, '360-degree Feedback for self', 'Submit request for feedback on online HCM portal tool and receive feedback by.Based on results Identify and select at least one area to develop .Complete the next feedback in 12 months.', 'October 31, 2020 Increase lowest scoring area by at least 0.5 from current score in 12 months October 31, 2021', '10', NULL, '2020-03-16', 2, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8645, '224', 3, 'Floor wise 50% of IPQC to be upgraded to FQC activities', 'Practical training, skill matrix, ', '50%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8646, '224', 3, 'Improve QC skill inventory by 15% through calibration and training', 'MK standard training evaluation', '15%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8647, '224', 4, 'Kaizen', 'Number of Kaizens submitted by the department every  month Number of Kaizens submitted per staff  ', 'Minimum 4At least 1 Kaizen per staff  per month / Minimum 10 Kaizens each in 12 months', '10', NULL, '2020-03-16', 2, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8648, '224', 4, 'S6S', 'Minimum Target Score achievement irrespective of Zone / Sub-Zone', '60%', '10', NULL, '2020-03-16', 2, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8649, '224', 4, 'QC team will capable to do all related internal report', '% On time accurate report submission', '100%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8650, '224', 4, 'Monthly updated quality memory and QC file', '% On time accurate report submission', '100%', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8651, '224', 4, 'QC work plan implementation', 'Number of Mismatch in line (0/<1) % Workflow compliance (100%) Monitoring QC workflow', '0/<1 100% % On time shipment delivery', '5', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8652, '224', 4, 'Achieve TQM Audit score of 85%', 'Monthly Quality lean tools and quality system audit', '85%', '10', NULL, '2020-03-16', 1, 2020, NULL, NULL, NULL, NULL, '35.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-16', 2, 1, NULL),
(8653, '28', 1, 'Reduce Quality Rework rate to 4.5% to 2.5% base on total order quantity', 'Quality Standard set up during QCO, Reduce the final inspection rejection', '2.5%', '10', NULL, NULL, 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-18', 1, 1, NULL),
(8654, '28', 2, 'Internal Customer Survey (Quality of Delivery & Quality of Service)', 'Ensure completion of feedback received on Internal Customer Service Effectiveness Feedback tool online.Analyse Results from the Internal Customer Survey (Every department Head must use the Standardised Survey tool available in the HCM Portal, with common parameters and questions for all Support Functions).Identify 2 low score areas and work on improving them with clear actions. Compare and report improvement in scores in next survey in 6 months.', 'August 31, 2020 September 30, 20 Move the 2 low score areas by at least 0.5 from the current Apr-20', '5', NULL, NULL, 2, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-18', 1, 1, NULL),
(8655, '28', 2, 'Improve Customer pass rate from 80% to 90%', 'Increase FTT, OQC pass rate, QA pass rate ', '90%', '5', NULL, NULL, 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-18', 1, 1, NULL),
(8656, '28', 2, 'Reduce Customer complaints from 1.6% to 1.00% of orders shipped', 'Customer pass rate, QA pass rate, OQC pass rate', '1%', '10', NULL, NULL, 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-18', 1, 1, NULL),
(8657, '28', 3, '360-degree Feedback for self', 'Submit request for feedback on online HCM portal tool and receive feedback by.Based on results Identify and select at least one area to develop .Complete the next feedback in 12 months.', 'October 31, 2020 Increase lowest scoring area by at least 0.5 from current score in 12 months October 31, 2021', '10', NULL, NULL, 2, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-18', 1, 1, NULL),
(8658, '28', 3, 'Develop QA team as per QA work flow', '% On time training delivery', '100%', '10', NULL, NULL, 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-18', 1, 1, NULL),
(8659, '28', 3, 'QA team will capable to do all related customer report', '% On time accurate report submission', '100%', '05', NULL, NULL, 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-18', 1, 1, NULL),
(8660, '28', 4, 'Kaizen', 'Number of Kaizens submitted by the department every  month Number of Kaizens submitted per staff  ', 'Minimum 4At least 1 Kaizen per staff  per month / Minimum 10 Kaizens each in 12 months', '10', NULL, NULL, 2, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-18', 1, 1, NULL),
(8661, '28', 4, 'S6S', 'Minimum Target Score achievement irrespective of Zone / Sub-Zone', '60%', '10', NULL, NULL, 2, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-18', 1, 1, NULL),
(8662, '28', 4, 'Finished goods delivery on time', 'To maintain as per shipment schedule', '100%', '5', NULL, NULL, 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-18', 1, 1, NULL),
(8663, '28', 4, 'QA work plan implementation', '% Workflow compliance (100%)', '100%', '10', NULL, NULL, 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-18', 1, 1, NULL),
(8664, '28', 4, 'Achieve 90% of CSS hoshin kanri QA action plan goals in 2020', 'Evaluate skill improvement based on a Test and on the job performance, monthly monitoring, ', '90%', '10', NULL, NULL, 1, 2020, NULL, NULL, NULL, NULL, '100.00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, '2020-03-18', 1, 1, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `level_competencies`
--

CREATE TABLE `level_competencies` (
  `competencies_id` bigint(20) NOT NULL,
  `role_id` int(11) NOT NULL,
  `behaviours` varchar(150) NOT NULL,
  `competency` varchar(800) DEFAULT NULL,
  `chinese_for` varchar(400) NOT NULL,
  `desired_level` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `level_competencies`
--

INSERT INTO `level_competencies` (`competencies_id`, `role_id`, `behaviours`, `competency`, `chinese_for`, `desired_level`) VALUES
(1, 2, 'Drive for excellence  推动卓越', 'Shows exceptional drive for achieving results ahead of others. Sets own high standards and continuously seek to improve it.\n', '对于追求结果，显示出超人的进取心。树立自我高标准，不断寻求提高 ', '4'),
(2, 2, 'Drive for Results \n追求成果', 'Takes complete ownership for outcomes, both positive and negative. Does not blame situations or people, but tries to identify the How of getting results. Works with a clear action plan. Completes tasks and achieves goals and deadlines. Monitors progress continuously and pushes self and others to meet commitments. Good at knowing what is necessary to get things done. Ability to focus efforts towards solutions rather than barriers. Does not stop when going gets tough, persists till the results are achieved.', '对积极和消极的结果拥有完全的自主权。不归责于状况或人，为如何得到结果而努力。有明确的行动计划。完成任务并达到目标和时限。持续监控进展，并推动自己和他人履行承诺。善于了解完成工作所需的必要条件。有专注于解决问题而不是障碍的能力。遇到困难不止步，坚持直到取得成果 ', '3'),
(3, 2, 'Learning & Improving\n学习和提高/改善', 'Seeks feedback constructively and learns actively, without shying away, in spite of feedback being uncomfortable. Appreciates feedback and acts on it. Takes responsibility for personal development. Committed to learning and continuous improvement. Learns quickly when facing new situations or problems. Open to change, willing to try new or unfamiliar tasks.', '寻求建设性的反馈并积极学习，即使反馈给人以不适感，也绝不回避。对反馈意见表示赞赏并付诸行动。对个人发展负责。致力于学习和持续改进。在面对新的情况或问题时快速学习。乐于改变，愿意尝试新的或不熟悉的任务', '4'),
(4, 2, 'Achieve more with Less effort \n用更少的努力实现更多', 'Gets many things done through effective prioritization, planning & delegation. Prefers to work Smart than hard. Works with a clear project plan and uses minimum resources to get maximum benefit.', '通过有效的优先级、计划和授权完成许多事情。宁用聪明而不用努力工作。使用明确的项目计划，并使用最少的资源来获得最大的收益', '3'),
(5, 2, 'Personal Agility \n个人敏捷性', 'Respond quickly to changing environment. Adapts quickly to unfamiliar situations. Learn from mistakes. Is able to bounce back and try again. Adapts to changes in priorities, assigned responsibilities and projects. Maintains a positive outlook even under pressure.', '对变化的环境做出快速反应。快速适应不熟悉的情况。从错误中学习。能够反弹，并再次尝试。适应变化的优先事项，分配的责任和项目。即使在压力下也要保持乐观的态度', '3'),
(6, 2, 'Accepts new challenges 接受新的挑战', 'Motivated to take on new challenges, and does not require permission to do so. Even if there is failure, does not give up when confronted with difficult situations. \n', '积极接受新挑战，并且不需要获得许可。即使失败，面对困难也不放弃', '3'),
(7, 2, 'Desire to take on higher responsibilities \n渴望承担更高的责任', 'Shows constant desire to move up the ladder and provides constant assurance to shoulder higher responsibilities. Learns what is required to meet the new responsibility and takes help from others as and when required.', '表现寻求提升的渴望，为承担更高的责任提供持续的保证。学习满足新职责所需的条件，并在需要时接受他人的帮助', '4'),
(8, 2, 'Strategic and Customer Perspective \n战略和客户角度', 'Thinks ahead and beyond own area. Focuses on internal and external customer perspectives. Simplifies complex solutions. Seeks to initiate new or better ways to increase customer satisfaction.', '要超前地思考问题。关注内部和外部客户的观点。简化复杂的解决方案。寻求新的或更好的方法来提高客户满意度', '4'),
(9, 2, 'Thinking and Decision Making \n思考和决策', 'Makes Hard / Tough Decisions. Analyses information effectively. Looks beyond the obvious and seeks creative solutions. Evaluates risks and makes timely decisions.Asks good questions, probing issues from different angles. Evaluates opportunities and risks in a given situation. Makes effective and timely decisions based on a mixture of logic, experience and intuition.', '做难或艰难的决策。有效地分析信息。越过表象来看问题，并寻求创造性的解决办法。评估风险并及时做决策。提出好的问题，从不同的角度探讨问题。评估既定情况下的机会和风险。基于逻辑、经验和直觉的结合，做出有效和及时的决策', '4'),
(10, 2, 'Coaching/Supervising Others\n教练/指导其他人', 'Defines clear and challenging expectations. Monitors progress and encourages learning.Handles people problems by adapting a coaching style to different situations. Invites open discussions and is prepared to listen. Gives honest feedback. Recognizes and reinforces achievements and contributions.Takes opportunity to celebrate individual and team successes.Actively supports development of employees on current job and seeks or creates opportunities for employees’ career growth.', '定义明确和具有挑战性的期望。监控进度并鼓励学习。根据不同的情况调整教练的风格来处理人们的问题。邀请公开讨论并准备聆听。给予诚实的反馈。承认并加强成就和贡献。抓住机会庆祝个人和团队的成功。积极支持员工在现有工作中的发展，并为员工的职业发展寻求或创造机会', '4'),
(11, 2, 'Building collaborative partnerships\n建立协作伙伴关系', 'Seeks and influences new relationships outside own unit and identifies new collaborative partnerships that better position Ventura\'s programs and services.Identifies and creates opportunities to partner through networking and participating in cross-functional, multi-stakeholder groups.Establishes connections that help the achievement of common organizational objectives. Keeps networks active by sharing information and communicating frequently and openly with stakeholders. Looks for a win-win solution.', '寻求和影响本单元以外的新关系，并确立新的合作伙伴关系，以更好地定位VENTURA的方案和服务。通过网络和参与跨职能、多利益相关的团体，确定并创造机会成为伙伴。建立有助于实现共同组织目标的关系。通过分享信息和经常性地公开地与利益相关者沟通来保持网络的活跃。寻求一种双赢的解决方案', '4'),
(12, 2, 'High Impact communication \n高影响力通信', 'Obtains inputs from others as and when needed. Expresses opinions, views and ideas in a friendly manner. Provides timely updates. Ensures information is shared with others as required. Uses the right communication medium to express views. Commits realistic deadlines and meets commitments.', '在需要时从他人处获得讯息。以友好的方式表达意见、观点和想法。提供及时的更新。确保按要求与他人共享信息。使用正确的沟通媒介来表达观点。保证实际的时限并履行承诺', '4'),
(13, 2, 'Attention to Detail\n关注细节', 'Performs tasks with care; Is thorough. Makes very few or any errors. Continuously checks work to ensure accuracy and completeness. Compares observations or finished work to what is expected. Remains alert and takes care of details that others  overlook or dismiss as insignificant.', '仔细完成任务。很少出错或无任何错误。持续检查工作，以确保准确性和完整性。将观察结果或完成的工作与期望进行比较。保持警觉，注意别人忽视或疏忽的细节', '4'),
(14, 3, 'Drive for excellence  推动卓越', 'Shows exceptional drive for achieving results ahead of others. Sets own high standards and continuously seek to improve it. ', '对于追求结果，显示出超人的进取心。树立自我高标准，不断寻求提高 ', '3'),
(15, 3, 'Drive for Results \n追求成果', 'Takes complete ownership for outcomes, both positive and negative. Does not blame situations or people, but tries to identify the How of getting results. Works with a clear action plan. Completes tasks and achieves goals and deadlines. Monitors progress continuously and pushes self and others to meet commitments. Good at knowing what is necessary to get things done. Ability to focus efforts towards solutions rather than barriers. Does not stop when going gets tough, persists till the results are achieved.', '对积极和消极的结果拥有完全的自主权。不归责于状况或人，为如何得到结果而努力。有明确的行动计划。完成任务并达到目标和时限。持续监控进展，并推动自己和他人履行承诺。善于了解完成工作所需的必要条件。有专注于解决问题而不是障碍的能力。遇到困难不止步，坚持直到取得成果 ', '3'),
(16, 3, 'Learning & Improving\n学习和提高/改善', 'Seeks feedback constructively and learns actively, without shying away, in spite of feedback being uncomfortable. Appreciates feedback and acts on it. Takes responsibility for personal development. Committed to learning and continuous improvement. Learns quickly when facing new situations or problems. Open to change, willing to try new or unfamiliar tasks.', '寻求建设性的反馈并积极学习，即使反馈给人以不适感，也绝不回避。对反馈意见表示赞赏并付诸行动。对个人发展负责。致力于学习和持续改进。在面对新的情况或问题时快速学习。乐于改变，愿意尝试新的或不熟悉的任务', '3'),
(17, 3, 'Achieve more with Less effort \n用更少的努力实现更多', 'Gets many things done through effective prioritization, planning & delegation. Prefers to work Smart than hard. Works with a clear project plan and uses minimum resources to get maximum benefit.', '通过有效的优先级、计划和授权完成许多事情。宁用聪明而不用努力工作。使用明确的项目计划，并使用最少的资源来获得最大的收益', '3'),
(18, 3, 'Personal Agility \n个人敏捷性', 'Respond quickly to changing environment. Adapts quickly to unfamiliar situations. Learn from mistakes. Is able to bounce back and try again. Adapts to changes in priorities, assigned responsibilities and projects. Maintains a positive outlook even under pressure.', '对变化的环境做出快速反应。快速适应不熟悉的情况。从错误中学习。能够反弹，并再次尝试。适应变化的优先事项，分配的责任和项目。即使在压力下也要保持乐观的态度', '3'),
(19, 3, 'Accepts new challenges 接受新的挑战', 'Motivated to take on new challenges, and does not require permission to do so. Even if there is failure, does not give up when confronted with difficult situations. ', '积极接受新挑战，并且不需要获得许可。即使失败，面对困难也不放弃', '3'),
(20, 3, 'Desire to take on higher responsibilities \n渴望承担更高的责任', 'Shows constant desire to move up the ladder and provides constant assurance to shoulder higher responsibilities. Learns what is required to meet the new responsibility and takes help from others as and when required.', '表现寻求提升的渴望，为承担更高的责任提供持续的保证。学习满足新职责所需的条件，并在需要时接受他人的帮助', '3'),
(21, 3, 'Strategic and Customer Perspective \n战略和客户角度', 'Thinks ahead and beyond own area. Focuses on internal and external customer perspectives. Simplifies complex solutions. Seeks to initiate new or better ways to increase customer satisfaction. \n', '要超前地思考问题。关注内部和外部客户的观点。简化复杂的解决方案。寻求新的或更好的方法来提高客户满意度', '3'),
(22, 3, 'Thinking and Decision Making \n思考和决策', 'Makes Hard / Tough Decisions. Analyses information effectively. Looks beyond the obvious and seeks creative solutions. Evaluates risks and makes timely decisions.Asks good questions, probing issues from different angles. Evaluates opportunities and risks in a given situation. Makes effective and timely decisions based on a mixture of logic, experience and intuition. ', '做难或艰难的决策。有效地分析信息。越过表象来看问题，并寻求创造性的解决办法。评估风险并及时做决策。提出好的问题，从不同的角度探讨问题。评估既定情况下的机会和风险。基于逻辑、经验和直觉的结合，做出有效和及时的决策', '3'),
(23, 3, 'Coaching/Supervising Others\n教练/指导其他人', 'Defines clear and challenging expectations. Monitors progress and encourages learning.Handles people problems by adapting a coaching style to different situations. Invites open discussions and is prepared to listen. Gives honest feedback. Recognizes and reinforces achievements and contributions.Takes opportunity to celebrate individual and team successes.Actively supports development of employees on current job and seeks or creates opportunities for employees’ career growth. ', '定义明确和具有挑战性的期望。监控进度并鼓励学习。根据不同的情况调整教练的风格来处理人们的问题。邀请公开讨论并准备聆听。给予诚实的反馈。承认并加强成就和贡献。抓住机会庆祝个人和团队的成功。积极支持员工在现有工作中的发展，并为员工的职业发展寻求或创造机会', '3'),
(24, 3, 'Building collaborative partnerships\n建立协作伙伴关系', 'Seeks and influences new relationships outside own unit and identifies new collaborative partnerships that better position Ventura\'s programs and services.Identifies and creates opportunities to partner through networking and participating in cross-functional, multi-stakeholder groups.Establishes connections that help the achievement of common organizational objectives. Keeps networks active by sharing information and communicating frequently and openly with stakeholders. Looks for a win-win solution.', '寻求和影响本单元以外的新关系，并确立新的合作伙伴关系，以更好地定位VENTURA的方案和服务。通过网络和参与跨职能、多利益相关的团体，确定并创造机会成为伙伴。建立有助于实现共同组织目标的关系。通过分享信息和经常性地公开地与利益相关者沟通来保持网络的活跃。寻求一种双赢的解决方案', '3'),
(25, 3, 'High Impact communication \n高影响力通信', 'Obtains inputs from others as and when needed. Expresses opinions, views and ideas in a friendly manner. Provides timely updates. Ensures information is shared with others as required. Uses the right communication medium to express views. Commits realistic deadlines and meets commitments.', '在需要时从他人处获得讯息。以友好的方式表达意见、观点和想法。提供及时的更新。确保按要求与他人共享信息。使用正确的沟通媒介来表达观点。保证实际的时限并履行承诺', '3'),
(26, 3, 'Attention to Detail\n关注细节', 'Performs tasks with care; Is thorough. Makes very few or any errors. Continuously checks work to ensure accuracy and completeness. Compares observations or finished work to what is expected. Remains alert and takes care of details that others  overlook or dismiss as insignificant.', '仔细完成任务。很少出错或无任何错误。持续检查工作，以确保准确性和完整性。将观察结果或完成的工作与期望进行比较。保持警觉，注意别人忽视或疏忽的细节', '3'),
(27, 4, 'Drive for excellence  推动卓越', 'Shows exceptional drive for achieving results ahead of others. Sets own high standards and continuously seek to improve it.', '对于追求结果，显示出超人的进取心。树立自我高标准，不断寻求提高 ', '2'),
(28, 4, 'Drive for Results \n追求成果', 'Takes complete ownership for outcomes, both positive and negative. Does not blame situations or people, but tries to identify the How of getting results. Works with a clear action plan. Completes tasks and achieves goals and deadlines. Monitors progress continuously and pushes self and others to meet commitments. Good at knowing what is necessary to get things done. Ability to focus efforts towards solutions rather than barriers. Does not stop when going gets tough, persists till the results are achieved.\n', '对积极和消极的结果拥有完全的自主权。不归责于状况或人，为如何得到结果而努力。有明确的行动计划。完成任务并达到目标和时限。持续监控进展，并推动自己和他人履行承诺。善于了解完成工作所需的必要条件。有专注于解决问题而不是障碍的能力。遇到困难不止步，坚持直到取得成果 ', '2'),
(29, 4, 'Learning & Improving\n学习和提高/改善', 'Seeks feedback constructively and learns actively, without shying away, in spite of feedback being uncomfortable. Appreciates feedback and acts on it. Takes responsibility for personal development. Committed to learning and continuous improvement. Learns quickly when facing new situations or problems. Open to change, willing to try new or unfamiliar tasks.', '寻求建设性的反馈并积极学习，即使反馈给人以不适感，也绝不回避。对反馈意见表示赞赏并付诸行动。对个人发展负责。致力于学习和持续改进。在面对新的情况或问题时快速学习。乐于改变，愿意尝试新的或不熟悉的任务', '3'),
(30, 4, 'Achieve more with Less effort \n用更少的努力实现更多', 'Gets many things done through effective prioritization, planning & delegation. Prefers to work Smart than hard. Works with a clear project plan and uses minimum resources to get maximum benefit.', '通过有效的优先级、计划和授权完成许多事情。宁用聪明而不用努力工作。使用明确的项目计划，并使用最少的资源来获得最大的收益', '3'),
(31, 4, 'Personal Agility \n个人敏捷性', 'Respond quickly to changing environment. Adapts quickly to unfamiliar situations. Learn from mistakes. Is able to bounce back and try again. Adapts to changes in priorities, assigned responsibilities and projects. Maintains a positive outlook even under pressure.', '对变化的环境做出快速反应。快速适应不熟悉的情况。从错误中学习。能够反弹，并再次尝试。适应变化的优先事项，分配的责任和项目。即使在压力下也要保持乐观的态度', '3'),
(32, 4, 'Accepts new challenges 接受新的挑战', 'Motivated to take on new challenges, and does not require permission to do so. Even if there is failure, does not give up when confronted with difficult situations.', '积极接受新挑战，并且不需要获得许可。即使失败，面对困难也不放弃', '3'),
(33, 4, 'Desire to take on higher responsibilities \n渴望承担更高的责任', 'Shows constant desire to move up the ladder and provides constant assurance to shoulder higher responsibilities. Learns what is required to meet the new responsibility and takes help from others as and when required. ', '表现寻求提升的渴望，为承担更高的责任提供持续的保证。学习满足新职责所需的条件，并在需要时接受他人的帮助', '3'),
(34, 4, 'Strategic and Customer Perspective \n战略和客户角度', 'Thinks ahead and beyond own area. Focuses on internal and external customer perspectives. Simplifies complex solutions. Seeks to initiate new or better ways to increase customer satisfaction. \n', '要超前地思考问题。关注内部和外部客户的观点。简化复杂的解决方案。寻求新的或更好的方法来提高客户满意度', '2'),
(35, 4, 'Thinking and Decision Making \n思考和决策', 'Makes Hard / Tough Decisions. Analyses information effectively. Looks beyond the obvious and seeks creative solutions. Evaluates risks and makes timely decisions.Asks good questions, probing issues from different angles. Evaluates opportunities and risks in a given situation. Makes effective and timely decisions based on a mixture of logic, experience and intuition.', '做难或艰难的决策。有效地分析信息。越过表象来看问题，并寻求创造性的解决办法。评估风险并及时做决策。提出好的问题，从不同的角度探讨问题。评估既定情况下的机会和风险。基于逻辑、经验和直觉的结合，做出有效和及时的决策', '2'),
(36, 4, 'Coaching/Supervising Others\n教练/指导其他人', 'Defines clear and challenging expectations. Monitors progress and encourages learning.Handles people problems by adapting a coaching style to different situations. Invites open discussions and is prepared to listen. Gives honest feedback. Recognizes and reinforces achievements and contributions.Takes opportunity to celebrate individual and team successes.Actively supports development of employees on current job and seeks or creates opportunities for employees’ career growth.', '定义明确和具有挑战性的期望。监控进度并鼓励学习。根据不同的情况调整教练的风格来处理人们的问题。邀请公开讨论并准备聆听。给予诚实的反馈。承认并加强成就和贡献。抓住机会庆祝个人和团队的成功。积极支持员工在现有工作中的发展，并为员工的职业发展寻求或创造机会', '2'),
(37, 4, 'Building collaborative partnerships\n建立协作伙伴关系', 'Seeks and influences new relationships outside own unit and identifies new collaborative partnerships that better position Ventura\'s programs and services.Identifies and creates opportunities to partner through networking and participating in cross-functional, multi-stakeholder groups.Establishes connections that help the achievement of common organizational objectives. Keeps networks active by sharing information and communicating frequently and openly with stakeholders. Looks for a win-win solution.', '寻求和影响本单元以外的新关系，并确立新的合作伙伴关系，以更好地定位VENTURA的方案和服务。通过网络和参与跨职能、多利益相关的团体，确定并创造机会成为伙伴。建立有助于实现共同组织目标的关系。通过分享信息和经常性地公开地与利益相关者沟通来保持网络的活跃。寻求一种双赢的解决方案', '2'),
(38, 4, 'High Impact communication \n高影响力通信', 'Obtains inputs from others as and when needed. Expresses opinions, views and ideas in a friendly manner. Provides timely updates. Ensures information is shared with others as required. Uses the right communication medium to express views. Commits realistic deadlines and meets commitments.', '在需要时从他人处获得讯息。以友好的方式表达意见、观点和想法。提供及时的更新。确保按要求与他人共享信息。使用正确的沟通媒介来表达观点。保证实际的时限并履行承诺', '2'),
(39, 4, 'Attention to Detail\n关注细节', 'Performs tasks with care; Is thorough. Makes very few or any errors. Continuously checks work to ensure accuracy and completeness. Compares observations or finished work to what is expected. Remains alert and takes care of details that others  overlook or dismiss as insignificant.', '仔细完成任务。很少出错或无任何错误。持续检查工作，以确保准确性和完整性。将观察结果或完成的工作与期望进行比较。保持警觉，注意别人忽视或疏忽的细节', '2'),
(40, 5, 'Drive for excellence  推动卓越', 'Shows exceptional drive for achieving results ahead of others. Sets own high standards and continuously seek to improve it.', '对于追求结果，显示出超人的进取心。树立自我高标准，不断寻求提高 ', '2'),
(41, 5, 'Drive for Results \n追求成果', 'Takes complete ownership for outcomes, both positive and negative. Does not blame situations or people, but tries to identify the How of getting results. Works with a clear action plan. Completes tasks and achieves goals and deadlines. Monitors progress continuously and pushes self and others to meet commitments. Good at knowing what is necessary to get things done. Ability to focus efforts towards solutions rather than barriers. Does not stop when going gets tough, persists till the results are achieved', '对积极和消极的结果拥有完全的自主权。不归责于状况或人，为如何得到结果而努力。有明确的行动计划。完成任务并达到目标和时限。持续监控进展，并推动自己和他人履行承诺。善于了解完成工作所需的必要条件。有专注于解决问题而不是障碍的能力。遇到困难不止步，坚持直到取得成果 ', '2'),
(42, 5, 'Learning & Improving\n学习和提高/改善', 'Seeks feedback constructively and learns actively, without shying away, in spite of feedback being uncomfortable. Appreciates feedback and acts on it. Takes responsibility for personal development. Committed to learning and continuous improvement. Learns quickly when facing new situations or problems. Open to change, willing to try new or unfamiliar tasks.', '寻求建设性的反馈并积极学习，即使反馈给人以不适感，也绝不回避。对反馈意见表示赞赏并付诸行动。对个人发展负责。致力于学习和持续改进。在面对新的情况或问题时快速学习。乐于改变，愿意尝试新的或不熟悉的任务', '2'),
(43, 5, 'Achieve more with Less effort \n用更少的努力实现更多', 'Gets many things done through effective prioritization, planning & delegation. Prefers to work Smart than hard. Works with a clear project plan and uses minimum resources to get maximum benefit.', '通过有效的优先级、计划和授权完成许多事情。宁用聪明而不用努力工作。使用明确的项目计划，并使用最少的资源来获得最大的收益', '3'),
(44, 5, 'Personal Agility \n个人敏捷性', 'Respond quickly to changing environment. Adapts quickly to unfamiliar situations. Learn from mistakes. Is able to bounce back and try again. Adapts to changes in priorities, assigned responsibilities and projects. Maintains a positive outlook even under pressure.', '对变化的环境做出快速反应。快速适应不熟悉的情况。从错误中学习。能够反弹，并再次尝试。适应变化的优先事项，分配的责任和项目。即使在压力下也要保持乐观的态度', '3'),
(45, 5, 'Accepts new challenges 接受新的挑战', 'Motivated to take on new challenges, and does not require permission to do so. Even if there is failure, does not give up when confronted with difficult situations.', '积极接受新挑战，并且不需要获得许可。即使失败，面对困难也不放弃', '3'),
(46, 5, 'Desire to take on higher responsibilities \n渴望承担更高的责任', 'Shows constant desire to move up the ladder and provides constant assurance to shoulder higher responsibilities. Learns what is required to meet the new responsibility and takes help from others as and when required.', '表现寻求提升的渴望，为承担更高的责任提供持续的保证。学习满足新职责所需的条件，并在需要时接受他人的帮助', '3'),
(47, 5, 'Strategic and Customer Perspective \n战略和客户角度', 'Thinks ahead and beyond own area. Focuses on internal and external customer perspectives. Simplifies complex solutions. Seeks to initiate new or better ways to increase customer satisfaction.', '要超前地思考问题。关注内部和外部客户的观点。简化复杂的解决方案。寻求新的或更好的方法来提高客户满意度', '2'),
(48, 5, 'Thinking and Decision Making \n思考和决策', 'Makes Hard / Tough Decisions. Analyses information effectively. Looks beyond the obvious and seeks creative solutions. Evaluates risks and makes timely decisions.Asks good questions, probing issues from different angles. Evaluates opportunities and risks in a given situation. Makes effective and timely decisions based on a mixture of logic, experience and intuition.', '做难或艰难的决策。有效地分析信息。越过表象来看问题，并寻求创造性的解决办法。评估风险并及时做决策。提出好的问题，从不同的角度探讨问题。评估既定情况下的机会和风险。基于逻辑、经验和直觉的结合，做出有效和及时的决策', '2'),
(49, 5, 'Coaching/Supervising Others\n教练/指导其他人', 'Defines clear and challenging expectations. Monitors progress and encourages learning.Handles people problems by adapting a coaching style to different situations. Invites open discussions and is prepared to listen. Gives honest feedback. Recognizes and reinforces achievements and contributions.Takes opportunity to celebrate individual and team successes.Actively supports development of employees on current job and seeks or creates opportunities for employees’ career growth.', '定义明确和具有挑战性的期望。监控进度并鼓励学习。根据不同的情况调整教练的风格来处理人们的问题。邀请公开讨论并准备聆听。给予诚实的反馈。承认并加强成就和贡献。抓住机会庆祝个人和团队的成功。积极支持员工在现有工作中的发展，并为员工的职业发展寻求或创造机会', '2'),
(50, 5, 'Building collaborative partnerships\n建立协作伙伴关系', 'Seeks and influences new relationships outside own unit and identifies new collaborative partnerships that better position Ventura\'s programs and services.Identifies and creates opportunities to partner through networking and participating in cross-functional, multi-stakeholder groups.Establishes connections that help the achievement of common organizational objectives. Keeps networks active by sharing information and communicating frequently and openly with stakeholders. Looks for a win-win solution.', '寻求和影响本单元以外的新关系，并确立新的合作伙伴关系，以更好地定位VENTURA的方案和服务。通过网络和参与跨职能、多利益相关的团体，确定并创造机会成为伙伴。建立有助于实现共同组织目标的关系。通过分享信息和经常性地公开地与利益相关者沟通来保持网络的活跃。寻求一种双赢的解决方案', '2'),
(51, 5, 'High Impact communication \n高影响力通信', 'Obtains inputs from others as and when needed. Expresses opinions, views and ideas in a friendly manner. Provides timely updates. Ensures information is shared with others as required. Uses the right communication medium to express views. Commits realistic deadlines and meets commitments.', '在需要时从他人处获得讯息。以友好的方式表达意见、观点和想法。提供及时的更新。确保按要求与他人共享信息。使用正确的沟通媒介来表达观点。保证实际的时限并履行承诺', '2'),
(52, 5, 'Attention to Detail\n关注细节', 'Performs tasks with care; Is thorough. Makes very few or any errors. Continuously checks work to ensure accuracy and completeness. Compares observations or finished work to what is expected. Remains alert and takes care of details that others  overlook or dismiss as insignificant.', '仔细完成任务。很少出错或无任何错误。持续检查工作，以确保准确性和完整性。将观察结果或完成的工作与期望进行比较。保持警觉，注意别人忽视或疏忽的细节', '2');

-- --------------------------------------------------------

--
-- Table structure for table `manager_list`
--

CREATE TABLE `manager_list` (
  `manager_id` int(11) NOT NULL,
  `manager_name` varchar(100) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `email_address` varchar(200) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `manager_list`
--

INSERT INTO `manager_list` (`manager_id`, `manager_name`, `employee_id`, `email_address`, `status`) VALUES
(1, 'Malik Ma', 200, 'malik.ma@hkthewell.com', 1),
(2, 'Jwel Ahmmed', 8, 'jwel.ahmmed@bdventura.com', 1),
(3, 'Md. Sarwar Hossen', 23, '', 1),
(4, 'Taufiq Anwar Hemel', 12, 'taufiq.anwar@bdventura.com', 1),
(5, 'Indike Jayalal', 202, '', 1),
(6, 'Nazmul Islam', 19, '', 1),
(7, 'Thomas Zou', 135, '', 1),
(8, 'Evan Cheng', 137, '', 1),
(9, 'A B M Fazle Rabbi', 113, '', 1),
(10, 'Aminur Islam', 112, '', 1),
(11, 'Jack Tang', 156, '', 1),
(12, 'IDA FU', 136, '', 1),
(13, 'John Qu', 163, '', 1),
(14, 'Lulu Duan', 131, '', 1),
(15, 'Md. Akram Hossain', 9, 'akram.hossain@bdventura.com', 1),
(16, 'Nelson', 125, '', 1),
(17, 'Nick Wu', 145, '', 1),
(18, 'Norman', 138, '', 1),
(19, 'S.M Syful Islam', 6, '', 1),
(20, 'Spark Zhong', 141, '', 1),
(21, 'Steven Xu', 132, '', 1),
(22, 'Yonger. Tong', 188, '', 1),
(24, 'Abdur Rahman', 45, '', 1),
(25, 'Ahad Ali', 55, '', 1),
(26, 'Ajay Kumar Roy', 30, '', 1),
(27, 'Aynal Haque', 17, 'aynal.haque@bdventura.com', 1),
(28, 'Mehedi Hasan', 83, '', 1),
(29, 'Abul Kalam Azad', 10, '', 1),
(30, 'Shakhawat Hossen', 7, '', 1),
(31, 'Razebul Hasan Ruman', 27, '', 1),
(32, 'Melody. Xie', 129, '', 1),
(33, 'Mr. Lawrence', 201, '', 1),
(34, 'Mr. Franco', 128, '', 1),
(35, 'Mr. Tobi Zhang', 149, '', 1),
(36, 'Md. Fajle Rabbi', 26, '', 1),
(37, 'Roc. Tan', 181, '', 1),
(38, 'Mr. Robert', 126, '', 1),
(39, 'Liang Feizhen', 170, '', 1),
(40, 'Chen. Lianhua', 167, '', 1),
(41, 'Maya.Hu', 152, '', 1),
(42, 'Oliullah Siddique', 43, '', 1),
(43, 'Md. Ashraf Ullah', 42, '', 1),
(44, 'Syed Atiqul Islam', 123, 'atiqul.islam@bdventura.com', 1),
(45, 'Sarah Duan', 130, '', 1),
(47, 'Austin.Xu', 127, '', 1),
(48, 'Kausar Hossain', 5, 'm.k.hossain@bdventura.com', 1),
(49, 'S.M Zahidur Rahman', 18, 'zahidur.rahman@bdventura.com', 1),
(50, 'Kazi Mahmudul Hossain', 33, 'kazi.mahmudul@bdventura.com', 1),
(51, 'Anupam Paul', 75, 'anupam.paul@bdventura.com', 1),
(52, 'Md. Rasaduzzaman', 109, 'rasel@bdventura.com', 1),
(53, 'Lily.xiao', 158, 'lily.xiao@bdventura.com', 1),
(54, 'Md. Rokunuzzaman', 50, 'rokunuzzaman@bdventura.com', 1),
(55, 'Charles.liao', 148, '', 1),
(56, 'Sophia.Lai', 88, 'sophia.lai@bdventura.com', 1),
(57, 'Jason', 215, 'jason.zhou@bdventura.com', 1),
(58, 'Md Rakibuzzaman', 80, 'rakibuzzaman@bdventura.com', 1),
(59, 'Quazi Md. Sayed-ur Rahman', 49, 'sayed.rahman@bdventura.com', 1),
(60, 'Quazi Md. Sayed-ur Rahman', 49, 'sayed.rahman@bdventura.com', 1),
(61, 'Steven Xu', 9, 'steven.xu@bdventura.com', 1);

-- --------------------------------------------------------

--
-- Table structure for table `nomination_table`
--

CREATE TABLE `nomination_table` (
  `nomination_id` int(11) NOT NULL,
  `per_appr_id` int(11) NOT NULL,
  `period1` varchar(150) DEFAULT NULL,
  `period2` varchar(150) DEFAULT NULL,
  `period3` varchar(150) DEFAULT NULL,
  `appraiser_name1` varchar(150) DEFAULT NULL,
  `appraiser_name2` varchar(150) DEFAULT NULL,
  `appraiser_name3` varchar(120) NOT NULL,
  `reviewer_name1` varchar(120) DEFAULT NULL,
  `reviewer_name2` varchar(120) DEFAULT NULL,
  `reviewer_name3` varchar(120) DEFAULT NULL,
  `rating1` decimal(11,2) DEFAULT NULL,
  `rating2` decimal(11,2) DEFAULT NULL,
  `rating3` decimal(11,2) DEFAULT NULL,
  `potential_min` int(11) DEFAULT NULL,
  `potential_rec` int(11) DEFAULT NULL,
  `panel_min` int(11) DEFAULT NULL,
  `panel_rec` int(11) DEFAULT NULL,
  `on_the_min` int(11) DEFAULT NULL,
  `on_the_rec` int(11) DEFAULT NULL,
  `written_min` int(11) DEFAULT NULL,
  `written_rec` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `nomination_table`
--

INSERT INTO `nomination_table` (`nomination_id`, `per_appr_id`, `period1`, `period2`, `period3`, `appraiser_name1`, `appraiser_name2`, `appraiser_name3`, `reviewer_name1`, `reviewer_name2`, `reviewer_name3`, `rating1`, `rating2`, `rating3`, `potential_min`, `potential_rec`, `panel_min`, `panel_rec`, `on_the_min`, `on_the_rec`, `written_min`, `written_rec`) VALUES
(1, 7, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(2, 8, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(3, 11, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(4, 31, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(5, 38, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(6, 44, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(7, 48, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(8, 50, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(9, 55, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(10, 68, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(11, 71, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(12, 72, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(13, 73, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(14, 84, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(15, 89, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(16, 90, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(17, 91, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(18, 93, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(19, 99, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(20, 100, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(21, 109, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 4, 0, 0, 0, 0, 0, 0),
(22, 117, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(23, 118, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(24, 120, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(25, 114, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 4, 0, 0, 0, 0, 0, 0),
(26, 124, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(27, 128, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(28, 136, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(29, 138, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(30, 111, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(31, 116, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(32, 151, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(33, 158, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(34, 163, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(35, 177, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(36, 181, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(37, 183, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(38, 179, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(39, 185, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(40, 186, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(41, 189, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(42, 191, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(43, 176, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(44, 199, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(45, 200, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(46, 204, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(47, 205, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(48, 206, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(49, 211, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(50, 217, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(51, 224, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(52, 225, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(53, 228, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(54, 229, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(55, 232, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(56, 236, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(57, 240, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(58, 243, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(59, 250, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(60, 251, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(61, 254, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(62, 257, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(63, 271, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(64, 273, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(66, 279, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(67, 286, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(68, 288, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(69, 284, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(70, 295, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(72, 300, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(73, 301, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(74, 303, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(75, 304, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(76, 308, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(77, 309, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(78, 310, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(79, 311, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(80, 312, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(81, 315, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(82, 324, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(83, 335, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(84, 339, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(85, 342, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(86, 345, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(87, 323, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(88, 350, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(89, 298, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(90, 359, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(91, 362, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(92, 367, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(93, 373, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(94, 374, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(95, 377, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(96, 378, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(97, 381, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(98, 385, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(99, 386, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(100, 387, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(101, 388, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(102, 389, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(103, 390, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(104, 391, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(105, 399, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(106, 402, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(107, 414, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(108, 407, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(109, 417, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(110, 421, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(111, 428, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(112, 430, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(113, 438, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(114, 439, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(115, 440, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(116, 446, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(117, 448, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(118, 456, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(119, 460, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(120, 465, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(121, 470, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(122, 475, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(123, 477, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(124, 480, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(125, 431, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(126, 485, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(127, 487, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(128, 488, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(129, 492, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(130, 494, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(131, 495, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(132, 497, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(133, 510, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(134, 511, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(135, 515, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(136, 516, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(137, 517, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(138, 518, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(139, 519, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(140, 520, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(141, 521, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(142, 533, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(144, 536, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(145, 543, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(146, 568, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(147, 584, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(148, 591, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(149, 603, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(150, 627, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(151, 628, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(152, 631, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(153, 639, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(154, 640, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(155, 641, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(156, 644, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(157, 646, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(158, 654, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(159, 659, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(160, 660, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(161, 661, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(162, 662, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(163, 663, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(164, 671, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(165, 682, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(166, 686, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(167, 685, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(168, 690, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(169, 693, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(170, 698, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(171, 684, '2022', '2023', '', 'Md. Sajadul Islam', 'Md. Sajadul Islam', '', 'Md. Sarwar Hossen', 'Md. Sarwar Hossen', '', '3.50', '3.53', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(172, 709, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(173, 687, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(174, 718, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(175, 721, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(176, 730, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(177, 740, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(178, 741, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(179, 747, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(180, 753, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(181, 758, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(182, 760, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(183, 761, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0),
(184, 767, '', '', '', '', '', '', '', '', '', '0.00', '0.00', '0.00', 0, 0, 0, 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Table structure for table `objective_setting`
--

CREATE TABLE `objective_setting` (
  `objective_setting_id` bigint(20) NOT NULL,
  `per_appr_id` bigint(20) DEFAULT NULL,
  `category` tinyint(4) DEFAULT NULL COMMENT '1-Financial.2-Delivery ,3-People ,4-Process ',
  `objective` varchar(250) NOT NULL,
  `target` varchar(150) NOT NULL,
  `weight` tinyint(4) NOT NULL,
  `weight_rating` decimal(11,2) NOT NULL,
  `target_date` varchar(20) DEFAULT NULL,
  `rating` smallint(6) DEFAULT NULL,
  `justification` varchar(200) DEFAULT NULL,
  `department_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `org_info`
--

CREATE TABLE `org_info` (
  `org_id` tinyint(4) NOT NULL,
  `org_name` varchar(120) NOT NULL,
  `phone_no` varchar(20) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  `address` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `org_info`
--

INSERT INTO `org_info` (`org_id`, `org_name`, `phone_no`, `email`, `address`) VALUES
(1, 'VLMDB', '01725888', 'opex@gmail.com', 'USA');

-- --------------------------------------------------------

--
-- Table structure for table `post`
--

CREATE TABLE `post` (
  `post_id` smallint(6) NOT NULL,
  `post_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `post`
--

INSERT INTO `post` (`post_id`, `post_name`) VALUES
(2, 'Manager'),
(4, 'Asst. Manager'),
(5, 'Senior Officer'),
(6, 'Officer'),
(17, 'Sr. Technician'),
(18, 'Senior Manager'),
(19, 'Supervisor');

-- --------------------------------------------------------

--
-- Table structure for table `promotion_details`
--

CREATE TABLE `promotion_details` (
  `promotion_id` bigint(20) NOT NULL,
  `per_month` tinyint(4) NOT NULL DEFAULT 1 COMMENT '2-October,1-April',
  `year` int(11) DEFAULT NULL,
  `employee_id` int(11) NOT NULL,
  `last_promotion_date` varchar(15) DEFAULT NULL,
  `promotion_yes_no` varchar(10) DEFAULT 'YES',
  `average` decimal(11,2) DEFAULT 0.00,
  `explain_in_about` varchar(500) DEFAULT NULL,
  `proposed_increment` decimal(11,2) DEFAULT 0.00,
  `role_id` smallint(6) DEFAULT NULL,
  `employee_grade` varchar(50) DEFAULT NULL,
  `function_name` varchar(100) DEFAULT NULL,
  `previous_ass` varchar(10) NOT NULL DEFAULT 'NO',
  `pre_ass_date` varchar(20) DEFAULT NULL,
  `proposed_designation` int(11) DEFAULT NULL,
  `m_employee_id` int(11) DEFAULT NULL,
  `provide_reason` varchar(800) DEFAULT NULL,
  `department_id` int(11) NOT NULL,
  `kpi_rating_average` decimal(11,2) DEFAULT NULL,
  `ba_self_total` int(11) DEFAULT NULL,
  `ba_manager_total` int(11) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `appraisal_status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1-draft,2-submit,3 approved',
  `previous_status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1-new,2-Old',
  `create_date` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `promotion_details`
--

INSERT INTO `promotion_details` (`promotion_id`, `per_month`, `year`, `employee_id`, `last_promotion_date`, `promotion_yes_no`, `average`, `explain_in_about`, `proposed_increment`, `role_id`, `employee_grade`, `function_name`, `previous_ass`, `pre_ass_date`, `proposed_designation`, `m_employee_id`, `provide_reason`, `department_id`, `kpi_rating_average`, `ba_self_total`, `ba_manager_total`, `user_id`, `appraisal_status`, `previous_status`, `create_date`) VALUES
(2, 1, NULL, 38, NULL, 'YES', '3.91', 'He deserves the position based on his capability and management ability ', '20.00', 4, 'D5A', 'Warehouse', 'NO', '', 4, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-02'),
(3, 1, NULL, 38, NULL, 'YES', '3.82', 'Dynamic and energetic ', '0.00', 0, 'D5A', 'Warehouse', 'NO', '', 4, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2022-03-01'),
(4, 1, NULL, 38, NULL, 'YES', '3.18', 'Recommended for Promotion.', '20.00', 4, 'D5A', 'Warehouse', 'NO', '', 4, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2022-03-03'),
(5, 1, NULL, 38, NULL, 'YES', '3.64', 'Deputy level is yet to be developed, good potential for future leadership', '14.00', 4, 'D5A', 'Warehouse', 'NO', '', 4, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-01'),
(6, 1, NULL, 46, NULL, 'YES', '3.36', 'Taken over senior position roles', '14.00', 0, 'D5A', '', 'NO', '', 5, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-01'),
(7, 1, NULL, 46, NULL, 'YES', '3.73', 'dynamic and creative ', '0.00', 0, 'D5A', '', 'NO', '', 5, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2022-03-01'),
(8, 1, NULL, 73, NULL, 'YES', '2.73', 'Reflecting through above evaluation', '0.00', 0, 'D5A', '', 'NO', '2018-04-01', 5, 7, NULL, 0, NULL, NULL, NULL, 29, 2, 1, '2022-03-01'),
(9, 1, NULL, 46, NULL, 'YES', '2.64', 'I am expressing through above evaluation', '0.00', 0, 'D5A', '', 'NO', '01/03/2022', 5, 7, NULL, 0, NULL, NULL, NULL, 29, 2, 1, '2022-03-01'),
(10, 1, NULL, 73, NULL, 'YES', '3.55', 'active ', '0.00', 0, 'D5A', '', 'NO', '2018-04-01', 6, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2022-03-01'),
(11, 1, NULL, 73, NULL, 'YES', '3.27', 'Needs to improve FTT of layout', '12.00', 0, 'D5A', '', 'NO', '2018-04-01', 5, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-01'),
(13, 1, NULL, 72, NULL, 'YES', '2.82', 'Need involvement with multi-skill work', '0.00', 0, 'D5A', '', 'NO', '2018-04-01', 5, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2022-03-01'),
(14, 1, NULL, 38, NULL, 'YES', '3.36', 'Job knowledge , Skill and capability. ', '25.00', 4, 'D5A', 'Warehouse', 'NO', '', 4, 9, NULL, 0, NULL, NULL, NULL, 16, 2, 1, '2022-03-02'),
(15, 1, NULL, 72, NULL, 'YES', '2.64', 'Good potential for job rotation', '0.00', 0, 'D5A', '', 'NO', '2018-04-01', 5, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-01'),
(16, 1, NULL, 46, NULL, 'YES', '3.36', 'recommended for Promotion', '20.00', 0, 'D5A', '', 'NO', '', 5, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2022-03-01'),
(17, 1, NULL, 73, NULL, 'YES', '3.36', 'recommended for Promotion', '0.18', 0, 'D5A', '', 'NO', '2018-04-01', 5, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2022-03-01'),
(18, 1, NULL, 72, NULL, 'YES', '3.18', '\nneed to engage Import & Export related task and manage team as well. there is chance to improvement for him.\nRecommended for Promotion.', '17.00', 0, 'D5A', '', 'NO', '2018-04-01', 5, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2022-03-01'),
(20, 1, NULL, 387, NULL, 'YES', '2.36', 'Fit for the next position', '1.00', 0, 'D5A', '', 'NO', '', 6, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2022-03-01'),
(21, 1, NULL, 387, NULL, 'YES', '2.27', '* Not so confident \n* lack of making hard decision ', '10.00', 0, 'D5A', '', 'NO', '', 6, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2022-03-01'),
(22, 1, NULL, 387, NULL, 'YES', '2.73', 'Ambitious in multiskilling & localization', '9.00', 0, 'D5A', '', 'NO', '', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-01'),
(23, 1, NULL, 394, NULL, 'YES', '2.91', '* Confident ', '1.00', 0, 'D5A', '', 'NO', '', 6, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2022-03-01'),
(24, 1, NULL, 389, NULL, 'YES', '2.55', 'He is fit for next role', '10.00', 0, 'D5A', '', 'NO', '', 6, 30, NULL, 0, NULL, NULL, NULL, 25, 2, 1, '2022-03-01'),
(25, 1, NULL, 389, NULL, 'YES', '2.55', '* Capable for next level ', '1.00', 0, 'D5A', '', 'NO', '', 6, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2022-03-01'),
(26, 1, NULL, 389, NULL, 'YES', '2.45', 'Considering his current Job, responsibility, performance, professionalism, he deserves promotion. ', '1.00', 0, 'D5A', '', 'NO', '', 6, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2022-03-01'),
(27, 1, NULL, 408, NULL, 'YES', '2.36', '* Not so Bad ', '1.00', 5, 'D5A', 'HRMS', 'NO', '', 6, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2022-03-01'),
(28, 1, NULL, 408, NULL, 'YES', '2.45', 'He can fit for the next role', '10.00', 5, 'D5A', 'HRMS', 'NO', '', 6, 30, NULL, 0, NULL, NULL, NULL, 25, 2, 1, '2022-03-01'),
(29, 1, NULL, 408, NULL, 'YES', '3.36', 'Ambitious ', '8.00', 5, 'D5A', 'HRMS', 'NO', '', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-01'),
(30, 1, NULL, 408, NULL, 'YES', '2.45', 'Well deserves to be promoted ', '1.00', 5, 'D5A', 'HRMS', 'NO', '', 6, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2022-03-01'),
(31, 1, NULL, 389, NULL, 'YES', '3.55', 'Stable career plan', '14.00', 0, 'D5A', '', 'NO', '', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-01'),
(32, 1, NULL, 82, NULL, 'YES', '2.64', 'He fit for the next role', '15.00', 5, 'D5A', 'TPM', 'NO', '', 6, 30, NULL, 0, NULL, NULL, NULL, 25, 2, 1, '2022-03-01'),
(33, 1, NULL, 82, NULL, 'YES', '2.73', 'Very positive to improve.\nPlaying Mid level rules for long run. \nConfident and smart enough.\nEnergetic and potential as local citizen. ', '1.00', 5, 'D5A', 'TPM', 'NO', '', 6, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2022-03-01'),
(34, 1, NULL, 82, NULL, 'YES', '2.55', 'Good ', '1.00', 5, 'D5A', 'TPM', 'NO', '', 6, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2022-03-01'),
(35, 1, NULL, 82, NULL, 'YES', '2.82', 'Stably long career focused.', '12.00', 5, 'D5A', 'TPM', 'NO', '', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 3, 1, '2022-03-01'),
(36, 1, NULL, 73, NULL, 'YES', '2.64', 'Oral and Written - Speaks and writes clearly to the point and understands others\' point of view,  Listen, Understand & Respond - Is a good listener, does no interrupt others, listens completely before responding', '20.00', 0, 'D5A', '', 'NO', '2018-04-01', 5, 9, NULL, 0, NULL, NULL, NULL, 16, 2, 1, '2022-03-02'),
(37, 1, NULL, 72, NULL, 'YES', '2.45', 'Is a good listener, does no interrupt others, listens completely before responding.', '15.00', 0, 'D5A', '', 'NO', '2018-04-01', 5, 9, NULL, 0, NULL, NULL, NULL, 16, 2, 1, '2022-03-02'),
(38, 1, NULL, 391, NULL, 'YES', '2.64', 'Fit for next role ', '10.00', 0, 'D5A', '', 'NO', '', 6, 30, NULL, 0, NULL, NULL, NULL, 25, 2, 1, '2022-03-02'),
(39, 1, NULL, 391, NULL, 'YES', '1.18', 'Not enough qualified for the next level, Lack of confident, Poor communication skill', '1.00', 0, 'D5A', '', 'NO', '', 6, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2022-03-02'),
(40, 1, NULL, 391, NULL, 'YES', '2.45', '* Good ', '1.00', 0, 'D5A', '', 'NO', '', 6, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2022-03-02'),
(41, 1, NULL, 208, NULL, 'YES', '1.27', 'Very lack in Communication, not enough qualified for the next level, improper management thoughts', '1.00', 5, 'D5A', 'Production', 'NO', '', 6, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2022-03-02'),
(42, 1, NULL, 208, NULL, 'YES', '2.00', '* Not so good in details work. ', '1.00', 5, 'D5A', 'Production', 'NO', '', 6, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2022-03-02'),
(43, 1, NULL, 208, NULL, 'YES', '2.18', 'Need to improve management skills as Officer grade.', '0.00', 5, 'D5A', 'Production', 'NO', '', 6, 30, NULL, 0, NULL, NULL, NULL, 25, 2, 1, '2022-03-02'),
(44, 1, NULL, 390, NULL, 'YES', '2.91', 'Good fit for next role', '15.00', 0, 'D5A', '', 'NO', '', 6, 30, NULL, 0, NULL, NULL, NULL, 25, 2, 1, '2022-03-02'),
(45, 1, NULL, 390, NULL, 'YES', '2.91', '* Confident. ', '1.00', 0, 'D5A', '', 'NO', '', 6, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2022-03-02'),
(46, 1, NULL, 390, NULL, 'YES', '2.82', 'Very confident, Professional, Carrier oriented, Motivational, Energetic, Smart enough  ', '1.00', 0, 'D5A', '', 'NO', '', 6, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2022-03-02'),
(47, 1, NULL, 383, NULL, 'YES', '2.64', 'Good fit for this position', '15.00', 0, 'D5A', '', 'NO', '', 6, 30, NULL, 0, NULL, NULL, NULL, 25, 2, 1, '2022-03-02'),
(48, 1, NULL, 383, NULL, 'YES', '2.64', '* Confident ', '1.00', 0, 'D5A', '', 'NO', '', 6, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2022-03-02'),
(49, 1, NULL, 390, NULL, 'YES', '2.91', 'Stably ambitious, learning focused.', '12.00', 0, 'D5A', '', 'NO', '', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-02'),
(50, 1, NULL, 391, NULL, 'YES', '2.36', 'Already taken over the roles for the position.', '12.00', 0, 'D5A', '', 'NO', '', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-02'),
(51, 1, NULL, 383, NULL, 'YES', '2.64', 'Capable to take care of leading position, Positive and open minded, Enough energetic, Potential  ', '1.00', 0, 'D5A', '', 'NO', '', 6, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2022-03-02'),
(53, 1, NULL, 213, NULL, 'YES', '2.36', 'Need improve', '0.00', 0, 'D5A', 'Warehouse', 'NO', '2018-04-01', 6, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2022-03-02'),
(54, 1, NULL, 213, NULL, 'YES', '2.82', 'recommended for promotion', '15.00', 0, 'D5A', 'Warehouse', 'NO', '2018-04-01', 6, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2022-03-02'),
(55, 1, NULL, 385, NULL, 'YES', '2.36', 'Need improvement ', '0.00', 0, 'D5A', '', 'NO', '', 6, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2022-03-02'),
(56, 1, NULL, 398, NULL, 'YES', '3.18', 'Dynamic and energetic', '0.00', 0, 'D5A', '', 'NO', '', 6, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2022-03-02'),
(57, 1, NULL, 213, NULL, 'YES', '2.36', 'Requires broader understanding of role complexity', '9.00', 0, 'D5A', 'Warehouse', 'NO', '2018-04-01', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-02'),
(58, 1, NULL, 385, NULL, 'YES', '3.00', 'High adaptability', '12.00', 0, 'D5A', '', 'NO', '', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-02'),
(59, 1, NULL, 398, NULL, 'YES', '3.09', 'Highly ambitious, hard working, data focused. `', '10.00', 0, 'D5A', '', 'NO', '', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-02'),
(60, 1, NULL, 385, NULL, 'YES', '0.00', NULL, '0.00', 0, 'D5A', '', 'NO', '', 6, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2022-03-02'),
(61, 1, NULL, 421, NULL, 'YES', '3.00', 'Energetic', '0.00', 5, 'D5A', 'Purchase', 'NO', '', 6, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2022-03-02'),
(62, 1, NULL, 421, NULL, 'YES', '2.91', 'High adaptability', '10.00', 5, 'D5A', 'Purchase', 'NO', '', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-02'),
(63, 1, NULL, 398, NULL, 'YES', '3.18', 'Recommended for promotion', '20.00', 0, 'D5A', '', 'NO', '', 6, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2022-03-02'),
(64, 1, NULL, 421, NULL, 'YES', '3.27', 'recommended for Promotion', '20.00', 5, 'D5A', 'Purchase', 'NO', '', 6, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2022-03-02'),
(65, 1, NULL, 212, NULL, 'YES', '2.27', 'Need improvement ', '0.00', 0, 'D5A', 'Warehouse', 'NO', '2018-04-01', 6, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2022-03-02'),
(66, 1, NULL, 212, NULL, 'YES', '1.91', 'need more understanding about departmental task and overall work process.\nneed more training about management task.', '0.00', 0, 'D5A', 'Warehouse', 'NO', '2018-04-01', 6, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2022-03-02'),
(67, 1, NULL, 212, NULL, 'YES', '2.64', 'Low perspective other than work area, long term retention focused. ', '8.00', 0, 'D5A', 'Warehouse', 'NO', '2018-04-01', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-02'),
(68, 1, NULL, 46, NULL, 'YES', '3.64', 'He is absolutely fit for the proposed position ', '25.00', 0, 'D5A', '', 'NO', '', 5, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-02'),
(69, 1, NULL, 73, NULL, 'YES', '3.45', 'He is absolutely fit for the proposed position ', '25.00', 0, 'D5A', '', 'NO', '2018-04-01', 5, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-02'),
(70, 1, NULL, 72, NULL, 'YES', '3.00', 'he is fit for the proposed position', '25.00', 0, 'D5A', '', 'NO', '2018-04-01', 5, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-02'),
(71, 1, NULL, 387, NULL, 'YES', '3.00', 'he is fit for the proposed position', '20.00', 0, 'D5A', '', 'NO', '', 6, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-02'),
(72, 1, NULL, 289, NULL, 'YES', '2.55', 'Confident, wiling to learn and improvement, Fit for next level ', '1.00', 0, 'D5A', '', 'NO', '', 7, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2022-03-03'),
(73, 1, NULL, 394, NULL, 'YES', '3.36', 'he is fit for the proposed position ', '25.00', 0, 'D5A', '', 'NO', '', 6, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-03'),
(74, 1, NULL, 38, NULL, 'YES', '3.00', 'Prefer candidate to get some proffessional education on relevant SCM work ,so could get  his plan and promote after get it.', '10.00', 4, 'D5A', 'Warehouse', 'NO', '01/03/2022', 4, 5, NULL, 0, NULL, NULL, NULL, 45, 1, 1, '2022-03-03'),
(75, 1, NULL, 389, NULL, 'YES', '3.45', 'he is absolutely fit for the promotion ', '25.00', 0, 'D5A', '', 'NO', '', 6, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-03'),
(76, 1, NULL, 408, NULL, 'YES', '2.36', 'ok for promotion', '15.00', 5, 'D5A', 'HRMS', 'NO', '', 6, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-03'),
(77, 1, NULL, 82, NULL, 'YES', '3.27', 'he is fit for the promotion ', '25.00', 5, 'D5A', 'TPM', 'NO', '', 6, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-03'),
(78, 1, NULL, 391, NULL, 'YES', '2.73', 'he is fit for promotion ', '20.00', 0, 'D5A', '', 'NO', '', 6, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-03'),
(79, 1, NULL, 208, NULL, 'YES', '3.00', 'he is fit for promotion', '20.00', 5, 'D5A', 'Production', 'NO', '', 6, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-03'),
(80, 1, NULL, 390, NULL, 'YES', '3.55', 'he is absolutely fit for the promotion', '25.00', 0, 'D5A', '', 'NO', '', 6, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-03'),
(81, 1, NULL, 383, NULL, 'YES', '3.27', 'he is absolutely fit for the promotion ', '25.00', 0, 'D5A', '', 'NO', '', 6, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-03'),
(82, 1, NULL, 289, NULL, 'YES', '2.82', 'he is fit for the promotion ', '20.00', 0, 'D5A', '', 'NO', '', 7, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-03'),
(83, 1, NULL, 391, NULL, 'YES', '2.00', 'not fit for the promotion', '5.00', 0, 'D5A', '', 'NO', '01/03/2022', 6, 5, NULL, 0, NULL, NULL, NULL, 45, 2, 1, '2022-03-03'),
(84, 1, NULL, 258, NULL, 'YES', '2.09', 'Not fit for the next role', '0.00', 0, 'D5A', '', 'NO', '', 7, 30, NULL, 0, NULL, NULL, NULL, 25, 2, 1, '2022-03-03'),
(85, 1, NULL, 258, NULL, 'YES', '2.00', 'he is not fit  for the promotion ', '10.00', 0, 'D5A', '', 'NO', '', 7, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-03'),
(86, 1, NULL, 258, NULL, 'YES', '1.36', 'Lack of communication skill, knowledge, confident. Need to improve all part of his area', '1.00', 0, 'D5A', '', 'NO', '', 7, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2022-03-03'),
(87, 1, NULL, 208, NULL, 'YES', '2.91', 'fit for the promotion', '15.00', 5, 'D5A', 'Production', 'NO', '02/03/2022', 6, 5, NULL, 0, NULL, NULL, NULL, 45, 2, 1, '2022-03-03'),
(88, 1, NULL, 289, NULL, 'YES', '2.45', '* Good ', '1.00', 0, 'D5A', '', 'NO', '', 7, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2022-03-03'),
(89, 1, NULL, 398, NULL, 'YES', '2.91', 'Works positively ,Listen, Understand & Respond', '25.00', 0, 'D5A', '', 'NO', '', 6, 9, NULL, 0, NULL, NULL, NULL, 16, 2, 1, '2022-03-03'),
(90, 1, NULL, 385, NULL, 'YES', '2.82', 'Keeping Commitments and Work completion ', '20.00', 0, 'D5A', '', 'NO', '', 6, 9, NULL, 0, NULL, NULL, NULL, 16, 2, 1, '2022-03-03'),
(91, 1, NULL, 258, NULL, 'YES', '1.64', '* not capable ', '1.00', 0, 'D5A', '', 'NO', '', 7, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2022-03-03'),
(92, 1, NULL, 212, NULL, 'YES', '2.55', 'Willingness to improve existing processes and procedures and find better ways of doing things, in terms of effectiveness and/or efficiency.', '18.00', 0, 'D5A', 'Warehouse', 'NO', '2018-04-01', 6, 9, NULL, 0, NULL, NULL, NULL, 16, 2, 1, '2022-03-03'),
(93, 1, NULL, 278, NULL, 'YES', '2.00', '* good ', '1.00', 0, 'D5A', '', 'NO', '', 7, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2022-03-03'),
(94, 1, NULL, 278, NULL, 'YES', '2.45', 'fit for promotion ', '20.00', 0, 'D5A', '', 'NO', '', 7, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-03'),
(95, 1, NULL, 278, NULL, 'YES', '2.18', 'Need to develop management skills', '0.00', 0, 'D5A', '', 'NO', '', 7, 30, NULL, 0, NULL, NULL, NULL, 25, 2, 1, '2022-03-03'),
(96, 1, NULL, 390, NULL, 'YES', '2.91', 'fit for the promotion ', '15.00', 0, 'D5A', '', 'NO', '', 6, 5, NULL, 0, NULL, NULL, NULL, 45, 2, 1, '2022-03-03'),
(97, 1, NULL, 213, NULL, 'YES', '2.64', 'Focus to reduce  errors/defects in  work  by monitoring, checking and compliance with standards and procedures.  Has good Attention to Detail.', '18.00', 0, 'D5A', 'Warehouse', 'NO', '2018-04-01', 6, 9, NULL, 0, NULL, NULL, NULL, 16, 2, 1, '2022-03-03'),
(98, 1, NULL, 383, NULL, 'YES', '2.55', 'fit for the promotion', '10.00', 0, 'D5A', '', 'NO', '02/03/2022', 6, 5, NULL, 0, NULL, NULL, NULL, 45, 2, 1, '2022-03-03'),
(99, 1, NULL, 421, NULL, 'YES', '2.55', 'Listen, Understand & Respond - Is a good listener, does no interrupt others, listens completely before responding.', '15.00', 5, 'D5A', 'Purchase', 'NO', '', 6, 9, NULL, 0, NULL, NULL, NULL, 16, 2, 1, '2022-03-03'),
(100, 1, NULL, 278, NULL, 'YES', '1.64', 'Communication lacking, Not confident, need to improve a lot', '1.00', 0, 'D5A', '', 'NO', '', 7, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2022-03-03'),
(101, 1, NULL, 213, NULL, 'YES', '2.55', 'fit for the promotion', '15.00', 0, 'D5A', 'Warehouse', 'NO', '2018-04-01', 6, 5, NULL, 0, NULL, NULL, NULL, 45, 2, 1, '2022-03-03'),
(102, 1, NULL, 278, NULL, 'YES', '2.00', 'Requires to acquire broader perspective in problem solving skills', '8.00', 0, 'D5A', '', 'NO', '', 7, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-03'),
(103, 1, NULL, 385, NULL, 'YES', '2.91', 'Fit for the promotion ', '15.00', 0, 'D5A', '', 'NO', '02/03/2022', 6, 5, NULL, 0, NULL, NULL, NULL, 45, 2, 1, '2022-03-03'),
(104, 1, NULL, 297, NULL, 'YES', '1.82', 'Lack of communication, Less confident, insufficient  knowledge of staff level', '1.00', 0, 'D5A', '', 'NO', '', 7, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2022-03-03'),
(105, 1, NULL, 297, NULL, 'YES', '2.73', 'Fit for the next role', '0.00', 0, 'D5A', '', 'NO', '', 7, 30, NULL, 0, NULL, NULL, NULL, 25, 2, 1, '2022-03-03'),
(106, 1, NULL, 297, NULL, 'YES', '2.00', '* Not so good ', '1.00', 0, 'D5A', '', 'NO', '', 7, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2022-03-03'),
(107, 1, NULL, 297, NULL, 'YES', '2.64', 'he is fit for promotion ', '20.00', 0, 'D5A', '', 'NO', '', 7, 23, NULL, 0, NULL, NULL, NULL, 6, 2, 1, '2022-03-03'),
(108, 1, NULL, 387, NULL, 'YES', '2.64', 'fit to promote ', '10.00', 0, 'D5A', '', 'NO', '01/03/2022', 6, 5, NULL, 0, NULL, NULL, NULL, 45, 2, 1, '2022-03-03'),
(109, 1, NULL, 394, NULL, 'YES', '2.64', 'fit to promote ', '10.00', 0, 'D5A', '', 'NO', '01/03/2022', 6, 5, NULL, 0, NULL, NULL, NULL, 45, 2, 1, '2022-03-03'),
(110, 1, NULL, 408, NULL, 'YES', '2.18', 'Not fit for promotion', '5.00', 5, 'D5A', 'HRMS', 'NO', '01/03/2022', 6, 5, NULL, 0, NULL, NULL, NULL, 45, 2, 1, '2022-03-03'),
(111, 1, NULL, 82, NULL, 'YES', '2.91', 'fit to promote ', '15.00', 5, 'D5A', 'TPM', 'NO', '01/03/2022', 6, 5, NULL, 0, NULL, NULL, NULL, 45, 2, 1, '2022-03-03'),
(112, 1, NULL, 309, NULL, 'YES', '2.27', 'Continuity focus ', '0.00', 0, 'D5A', '', 'NO', '', 7, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2022-03-03'),
(113, 1, NULL, 309, NULL, 'YES', '0.00', NULL, '0.00', 0, 'D5A', '', 'NO', '03/03/2022', 7, 7, NULL, 0, NULL, NULL, NULL, 29, 2, 1, '2022-03-03'),
(114, 1, NULL, 309, NULL, 'YES', '2.73', 'recommended for Promotion', '20.00', 0, 'D5A', '', 'NO', '', 6, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2022-03-03'),
(115, 1, NULL, 309, NULL, 'YES', '2.36', 'High adaptability', '12.00', 0, 'D5A', '', 'NO', '', 7, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2022-03-03'),
(116, 1, NULL, 25, NULL, 'YES', '3.45', 'Energatics ', '0.00', 0, 'D5A', '', 'NO', '', 5, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2022-03-03'),
(117, 1, NULL, 25, NULL, 'YES', '2.64', 'Reflecting by above scores', '0.00', 0, 'D5A', '', 'NO', '03/03/2022', 5, 7, NULL, 0, NULL, NULL, NULL, 29, 2, 1, '2022-03-03'),
(118, 1, NULL, 25, NULL, 'YES', '3.09', 'Recommended for Promotion', '20.00', 0, 'D5A', '', 'NO', '', 5, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2022-03-03'),
(119, 1, NULL, 25, NULL, 'YES', '2.36', 'Needs to be much responsive and collaborative', '8.00', 0, 'D5A', '', 'NO', '', 5, 123, NULL, 0, NULL, NULL, NULL, 42, 3, 1, '2022-03-03'),
(120, 1, NULL, 409, NULL, 'YES', '2.36', 'Need skill developments ', '0.00', 5, 'D5A', '', 'NO', '', 6, 12, NULL, 0, NULL, NULL, NULL, 3, 3, 1, '2022-03-03'),
(121, 1, NULL, 409, NULL, 'YES', '2.73', 'Reflecting by above score', '0.00', 5, 'D5A', '', 'NO', '03/03/2022', 6, 7, NULL, 0, NULL, NULL, NULL, 29, 3, 1, '2022-03-03'),
(122, 1, NULL, 409, NULL, 'YES', '3.27', 'Recommended for Promotion', '20.00', 5, 'D5A', '', 'NO', '', 6, 10, NULL, 0, NULL, NULL, NULL, 28, 3, 1, '2022-03-03'),
(123, 1, NULL, 301, NULL, 'YES', '1.82', 'Need improvements', '0.00', 0, 'D5A', '', 'NO', '', 7, 12, NULL, 0, NULL, NULL, NULL, 3, 3, 1, '2022-03-03'),
(124, 1, NULL, 301, NULL, 'YES', '2.64', 'Dadication at work\ngood Team work \nConfident \nso Recoemndation for Promotion', '20.00', 0, 'D5A', '', 'NO', '', 7, 10, NULL, 0, NULL, NULL, NULL, 28, 3, 1, '2022-03-03'),
(125, 1, NULL, 408, NULL, 'YES', '0.00', NULL, '0.00', 5, 'D5A', 'HRMS', 'NO', '', 7, 408, NULL, 0, NULL, NULL, NULL, 71, 1, 1, '2022-03-05'),
(126, 1, NULL, 301, NULL, 'YES', '2.45', 'Listen, Understand & Respond - Is a good listener, does no interrupt others, listens completely before responding.', '15.00', 0, 'D5A', '', 'NO', '', 7, 9, NULL, 0, NULL, NULL, NULL, 16, 3, 1, '2022-03-05'),
(127, 1, NULL, 6, NULL, 'YES', '0.00', NULL, '0.00', 0, 'D5A', '', 'NO', '', 14, 2, NULL, 0, NULL, NULL, NULL, 72, 1, 1, '2022-03-08'),
(128, 1, NULL, 9, NULL, 'YES', '0.00', NULL, '0.00', 0, 'D5A', 'Production', 'NO', '', 4, 392, NULL, 0, NULL, NULL, NULL, 89, 1, 1, '2022-03-08'),
(132, 1, NULL, 208, NULL, 'YES', '2.36', 'Re-interview with Sarwar, Hemel, Biton, Ruman, Ajay & Atiq', '12.00', 5, 'D5A', 'Production', 'NO', '', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 3, 1, '2022-04-17'),
(134, 2, NULL, 478, NULL, 'YES', '2.36', 'Not having clear concept on machine utilization. ', '15.00', 5, 'D5A', 'IE', 'NO', '', 6, 9, NULL, 0, NULL, NULL, NULL, 16, 3, 1, '2022-09-20'),
(135, 2, NULL, 478, NULL, 'YES', '2.91', 'Need to focus on Continuous Improvement for the next roll', '0.00', 5, 'D5A', 'IE', 'NO', '20/09/2022', 6, 7, NULL, 0, NULL, NULL, NULL, 29, 3, 1, '2022-09-20'),
(136, 2, NULL, 478, NULL, 'YES', '2.64', 'Calm, focused to KPIs, needs to improve understanding of machine allocations and future roles. ', '12.00', 5, 'D5A', 'IE', 'NO', '', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 3, 1, '2022-09-20'),
(138, 2, NULL, 258, NULL, 'YES', '2.09', 'Committed, requires further communication achievements for future roles.', '10.00', 0, 'D5A', '', 'NO', '', 7, 123, NULL, 0, NULL, NULL, NULL, 42, 3, 1, '2022-09-20'),
(139, 2, NULL, 395, NULL, 'YES', '2.82', 'good presentation during promotion interview.\npositive approach to support production.', '20.00', 0, 'D5A', '', 'NO', '', 6, 10, NULL, 0, NULL, NULL, NULL, 28, 3, 1, '2022-09-20'),
(140, 2, NULL, 478, NULL, 'YES', '2.45', 'within short time, build good team relation with workshop management.\nidentify issue SLG workshop and communication with Concern dept, so recomendation for promotion.', '20.00', 5, 'D5A', 'IE', 'NO', '', 6, 10, NULL, 0, NULL, NULL, NULL, 28, 3, 1, '2022-09-20'),
(141, 2, NULL, 258, NULL, 'YES', '3.27', 'Need to improve communication for future role', '0.00', 0, 'D5A', '', 'NO', '20/09/2022', 7, 7, NULL, 0, NULL, NULL, NULL, 29, 3, 1, '2022-09-20'),
(142, 2, NULL, 395, NULL, 'YES', '0.00', NULL, '0.00', 0, 'D5A', '', 'NO', '', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 1, 1, '2022-09-20'),
(143, 2, NULL, 395, NULL, 'YES', '3.00', 'Need to improvement on communication for the next role', '0.00', 0, 'D5A', '', 'NO', '20/09/2022', 6, 7, NULL, 0, NULL, NULL, NULL, 29, 3, 1, '2022-09-20'),
(144, 2, NULL, 258, NULL, 'YES', '2.55', 'Technically sound in production to improve productivity and quality.\n', '20.00', 0, 'D5A', '', 'NO', '', 7, 10, NULL, 0, NULL, NULL, NULL, 28, 3, 1, '2022-09-20'),
(145, 2, NULL, 395, NULL, 'YES', '2.73', 'He is clear on his strength and weakness..', '18.00', 0, 'D5A', '', 'NO', '', 6, 9, NULL, 0, NULL, NULL, NULL, 16, 3, 1, '2022-09-21'),
(146, 1, NULL, 2, NULL, 'YES', '0.00', NULL, '0.00', 5, 'D5A', 'Production', 'NO', '', 16, 123, NULL, 0, NULL, NULL, NULL, 42, 1, 1, '2023-02-06'),
(147, 1, NULL, 271, NULL, 'YES', '3.09', 'we may promote him ', '0.00', 0, 'D5A', '', 'NO', '', 17, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2023-03-30'),
(149, 1, NULL, 271, NULL, 'YES', '2.00', 'Average', '0.00', 0, 'D5A', '', 'NO', '', 17, 7, NULL, 0, NULL, NULL, NULL, 29, 2, 1, '2023-03-30'),
(150, 1, NULL, 271, NULL, 'YES', '1.45', 'Incapable of measuring subordinates\' performance, lacks Kaizen skills to improve existing work process.', '8.00', 0, 'D5A', '', 'NO', '', 17, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2023-03-30'),
(151, 1, NULL, 271, NULL, 'YES', '2.09', 'trusted, skill....but lack of leadership skill', '15.00', 0, 'D5A', '', 'NO', '', 6, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2023-03-30'),
(152, 1, NULL, 249, NULL, 'YES', '2.00', 'Poor communication skill ', '10.00', 0, 'D5A', '', 'NO', '', 6, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2023-03-30'),
(154, 1, NULL, 249, NULL, 'YES', '1.91', 'Need skill development ', '0.00', 0, 'D5A', '', 'NO', '', 6, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2023-03-30'),
(155, 1, NULL, 249, NULL, 'YES', '2.09', 'Average', '0.00', 0, 'D5A', '', 'NO', '30/03/2023', 6, 7, NULL, 0, NULL, NULL, NULL, 29, 2, 1, '2023-03-30'),
(156, 1, NULL, 214, NULL, 'YES', '2.91', 'English skill need improve ', '0.00', 0, 'D5A', 'Floor (SLG)', 'NO', '2018-04-01', 5, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2023-03-30'),
(157, 1, NULL, 214, NULL, 'YES', '2.27', 'Need to improve on decision making ability. ', '0.00', 0, 'D5A', 'Floor (SLG)', 'NO', '30/03/2023', 5, 7, NULL, 0, NULL, NULL, NULL, 29, 2, 1, '2023-03-30'),
(158, 1, NULL, 214, NULL, 'YES', '1.91', 'too fast for promotion nomination as Sr. officer.   technically sound but work area is not wider.', '0.00', 0, 'D5A', 'Floor (SLG)', 'NO', '2018-04-01', 5, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2023-03-30'),
(159, 1, NULL, 102, NULL, 'YES', '2.09', 'Lacks communication skills and measuring subordinates\' performance.', '8.00', 0, 'D5A', '', 'NO', '', 6, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2023-03-30'),
(160, 1, NULL, 214, NULL, 'YES', '2.91', 'Though requires presentation, analytical, and communication skills need to be developed,  yet he demonstrated his commitment.', '15.00', 0, 'D5A', 'Floor (SLG)', 'NO', '2018-04-01', 5, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2023-04-01'),
(161, 1, NULL, 77, NULL, 'YES', '2.27', 'Work scope is not as wide as the position (Sr. Officer ) hold.', '15.00', 5, 'D5A', 'IMP (IQC)', 'NO', '', 5, 9, NULL, 0, NULL, NULL, NULL, 16, 2, 1, '2023-03-30'),
(162, 1, NULL, 77, NULL, 'YES', '2.55', 'Optimistic, & add value in service.\nneed to utilize his skill in thier task, as well.\n', '18.00', 5, 'D5A', 'IMP (IQC)', 'NO', '30/03/2023', 5, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2023-03-30'),
(163, 1, NULL, 77, NULL, 'YES', '2.00', 'Energetic and dedicated to work. Less scope of work in his area. Lack of leadership quality and capability. ', '0.00', 5, 'D5A', 'IMP (IQC)', 'NO', '', 5, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2023-03-30'),
(164, 1, NULL, 271, NULL, 'YES', '3.27', 'could be promoted ', '20.00', 0, 'D5A', '', 'NO', '30/03/2023', 17, 5, NULL, 0, NULL, NULL, NULL, 45, 2, 1, '2023-03-30'),
(165, 1, NULL, 740, NULL, 'YES', '2.91', 'English skill need improve', '0.00', 0, '', '', 'NO', '', 6, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2023-03-30'),
(166, 1, NULL, 249, NULL, 'YES', '3.55', 'could be promoted', '20.00', 0, 'D5A', '', 'NO', '30/03/2023', 6, 5, NULL, 0, NULL, NULL, NULL, 45, 2, 1, '2023-03-30'),
(167, 1, NULL, 214, NULL, 'YES', '2.64', 'need to have more time to grow to promote', '10.00', 0, 'D5A', 'Floor (SLG)', 'NO', '2018-04-01', 5, 5, NULL, 0, NULL, NULL, NULL, 45, 2, 1, '2023-03-30'),
(168, 1, NULL, 740, NULL, 'YES', '2.27', 'Lack of Self confidence , analytical thinking and problem solving ', '15.00', 0, '', '', 'NO', '', 6, 9, NULL, 0, NULL, NULL, NULL, 16, 2, 1, '2023-03-30'),
(169, 1, NULL, 740, NULL, 'YES', '1.36', 'Potential as working for long time. Not fit to be promoted as Officer. Communication, related Knowledge & experience not enough for the next level.', '0.00', 0, '', '', 'NO', '', 6, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2023-03-30'),
(170, 1, NULL, 115, NULL, 'YES', '2.36', 'Need improvement ', '0.00', 0, 'D5A', '', 'NO', '', 5, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2023-04-01'),
(171, 1, NULL, 115, NULL, 'YES', '2.27', 'Need to develop on analytical, willing to learn & communications', '0.00', 0, 'D5A', '', 'NO', '01/04/2023', 5, 7, NULL, 0, NULL, NULL, NULL, 29, 2, 1, '2023-04-01'),
(172, 1, NULL, 115, NULL, 'YES', '2.09', 'Couldn\'t recognize his value addition to the org. Mostly involved in clerical functions and plans to do the same in future. ', '8.00', 0, 'D5A', '', 'NO', '', 5, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2023-04-01'),
(173, 1, NULL, 115, NULL, 'YES', '2.18', 'work area is not wider as sr. officer.. ', '0.00', 0, 'D5A', '', 'NO', '', 5, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2023-04-01'),
(174, 1, NULL, 39, NULL, 'YES', '2.45', 'recommended.. ', '0.00', 0, 'D5A', '', 'NO', '', 5, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2023-04-01'),
(175, 1, NULL, 39, NULL, 'YES', '2.55', 'Need improvement skill ', '0.00', 0, 'D5A', '', 'NO', '', 5, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2023-04-01'),
(176, 1, NULL, 39, NULL, 'YES', '2.55', 'Need to improve o Analytical thinking and continuous improvement ', '0.00', 0, 'D5A', '', 'NO', '01/04/2023', 5, 7, NULL, 0, NULL, NULL, NULL, 29, 2, 1, '2023-04-01'),
(177, 1, NULL, 39, NULL, 'YES', '2.82', 'Needs to focus on transformational functions', '12.00', 0, 'D5A', '', 'NO', '', 5, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2023-04-01'),
(178, 1, NULL, 386, NULL, 'YES', '3.27', 'Dynamic and energetic', '0.00', 0, 'D5A', '', 'NO', '', 5, 12, NULL, 0, NULL, NULL, NULL, 3, 2, 1, '2023-04-01'),
(179, 1, NULL, 386, NULL, 'YES', '3.45', 'Needs to study more about advanced solutions of existing problems in Production. ', '15.00', 0, 'D5A', '', 'NO', '', 5, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2023-04-01'),
(180, 1, NULL, 386, NULL, 'YES', '2.45', 'recommended ', '0.00', 0, 'D5A', '', 'NO', '', 5, 27, NULL, 0, NULL, NULL, NULL, 30, 2, 1, '2023-04-01'),
(181, 1, NULL, 386, NULL, 'YES', '2.73', 'Need to improve on continuous improvement ', '0.00', 0, 'D5A', '', 'NO', '01/04/2023', 5, 7, NULL, 0, NULL, NULL, NULL, 29, 2, 1, '2023-04-01'),
(182, 1, NULL, 88, NULL, 'YES', '2.73', 'Well understand the requirement he should follow, Very positive attitude, Confident. Fit for the next position. He needs more sub-ordinates to lead after promotion. ', '0.00', 0, 'D5A', '', 'NO', '01/04/2021', 5, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2023-04-01'),
(183, 1, NULL, 88, NULL, 'YES', '3.18', 'Works positively with other team members  to resolve issues without blaming others.', '25.00', 0, 'D5A', '', 'NO', '', 5, 9, NULL, 0, NULL, NULL, NULL, 16, 2, 1, '2023-04-01'),
(184, 1, NULL, 88, NULL, 'YES', '3.09', 'very good in communication \npositive minded.\ncollaborate all related department concern about Materials info.', '20.00', 0, 'D5A', '', 'NO', '', 5, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2023-04-01'),
(185, 1, NULL, 88, NULL, 'YES', '2.82', 'Good on the job training provider to new comers. ', '12.00', 0, 'D5A', '', 'NO', '', 5, 123, NULL, 0, NULL, NULL, NULL, 42, 2, 1, '2023-04-01'),
(186, 1, NULL, 34, NULL, 'YES', '2.82', 'good collaboration with others department task.', '18.00', 0, 'D5A', 'Merchandising', 'NO', '2018-04-01', 5, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2023-04-01'),
(187, 1, NULL, 34, NULL, 'YES', '2.55', 'Works positively with other team members  to resolve issues without blaming others', '20.00', 0, 'D5A', 'Merchandising', 'NO', '2018-04-01', 5, 9, NULL, 0, NULL, NULL, NULL, 16, 2, 1, '2023-04-01'),
(188, 1, NULL, 34, NULL, 'YES', '2.91', 'Very positive attitude, well communication capability, Willing to learn and involve more tasks. ', '0.00', 0, 'D5A', 'Merchandising', 'NO', '2018-04-01', 5, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2023-04-01'),
(189, 1, NULL, 34, NULL, 'YES', '3.00', 'Needs to improve analytical, forecasting skills.', '15.00', 0, 'D5A', 'Merchandising', 'NO', '2018-04-01', 5, 123, NULL, 0, NULL, NULL, NULL, 42, 1, 1, '2023-04-01'),
(190, 1, NULL, 558, NULL, 'YES', '2.18', 'base on role & responsibilty, he able to promot', '18.00', 0, 'D5A', '', 'NO', '', 6, 10, NULL, 0, NULL, NULL, NULL, 28, 2, 1, '2023-04-01'),
(191, 1, NULL, 558, NULL, 'YES', '2.55', 'Well capable, Good in communication, Dedicated to work, Positive personality. Nervous with seniors. Overall he deserve Promoted to the next level ', '0.00', 0, 'D5A', '', 'NO', '', 6, 8, NULL, 0, NULL, NULL, NULL, 5, 2, 1, '2023-04-01'),
(192, 1, NULL, 558, NULL, 'YES', '3.09', 'Trusted Person - Can be trusted with work or with information to be carried out without follow-up.Oral and Written - Speaks and writes clearly to the point and understands others\' point of view', '25.00', 0, 'D5A', '', 'NO', '', 6, 9, NULL, 0, NULL, NULL, NULL, 16, 2, 1, '2023-04-01'),
(193, 1, NULL, 5, NULL, 'YES', '0.00', NULL, '0.00', 0, 'D5A', 'Sourcing', 'NO', '2018-04-01', 6, 95, NULL, 0, NULL, NULL, NULL, 1, 1, 1, '2024-02-26'),
(194, 1, NULL, 2, NULL, 'YES', '0.00', NULL, '0.00', 5, 'D5A', 'Production', 'NO', '', 6, 95, NULL, 0, NULL, NULL, NULL, 1, 1, 1, '2024-02-26'),
(196, 2, NULL, 3, NULL, 'YES', '0.00', NULL, '0.00', 0, 'D5A', 'Finance & Accounts (F&A)', 'NO', '4/1/2018', 2, 95, NULL, 0, NULL, NULL, NULL, 1, 1, 1, '2024-03-10');

-- --------------------------------------------------------

--
-- Table structure for table `promotion_rating`
--

CREATE TABLE `promotion_rating` (
  `ass_rating_id` int(11) NOT NULL,
  `average` decimal(8,2) NOT NULL DEFAULT 0.00,
  `adaptability` tinyint(4) NOT NULL,
  `collaborative` tinyint(4) NOT NULL,
  `trusted` tinyint(4) NOT NULL,
  `communication` tinyint(4) NOT NULL,
  `pressure` tinyint(4) NOT NULL,
  `learnability` tinyint(4) NOT NULL,
  `eye_detail` tinyint(4) NOT NULL,
  `analytical` tinyint(4) NOT NULL,
  `improvement` tinyint(4) NOT NULL,
  `listen` tinyint(4) NOT NULL,
  `commitment` tinyint(4) NOT NULL,
  `promotion_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `promotion_rating`
--

INSERT INTO `promotion_rating` (`ass_rating_id`, `average`, `adaptability`, `collaborative`, `trusted`, `communication`, `pressure`, `learnability`, `eye_detail`, `analytical`, `improvement`, `listen`, `commitment`, `promotion_id`) VALUES
(1, '3.64', 4, 4, 3, 3, 4, 4, 3, 3, 4, 4, 4, 5),
(2, '3.82', 4, 3, 4, 4, 4, 4, 4, 4, 4, 4, 3, 3),
(3, '3.73', 4, 4, 4, 4, 4, 4, 3, 3, 4, 4, 3, 7),
(4, '2.64', 3, 2, 3, 3, 2, 3, 3, 2, 3, 3, 2, 9),
(5, '3.55', 3, 3, 3, 4, 4, 4, 3, 3, 4, 4, 4, 10),
(6, '2.73', 3, 2, 3, 3, 3, 3, 3, 2, 2, 3, 3, 8),
(7, '3.27', 4, 3, 4, 2, 4, 3, 3, 3, 3, 3, 4, 11),
(8, '2.82', 3, 3, 2, 3, 3, 3, 3, 2, 3, 3, 3, 13),
(9, '3.36', 3, 3, 3, 3, 3, 3, 3, 4, 4, 4, 4, 14),
(10, '2.64', 2, 2, 3, 2, 3, 3, 3, 2, 3, 3, 3, 15),
(11, '3.36', 4, 3, 3, 2, 3, 4, 3, 3, 4, 4, 4, 6),
(12, '3.36', 3, 4, 3, 4, 3, 4, 3, 4, 3, 3, 3, 16),
(13, '3.36', 3, 4, 3, 3, 3, 4, 4, 3, 4, 3, 3, 17),
(14, '3.18', 3, 4, 4, 3, 3, 3, 3, 3, 3, 3, 3, 18),
(15, '2.27', 2, 2, 3, 2, 1, 3, 3, 2, 3, 2, 2, 21),
(16, '2.91', 2, 3, 3, 3, 4, 3, 3, 3, 3, 3, 2, 23),
(17, '2.36', 2, 3, 3, 2, 2, 3, 2, 2, 3, 2, 2, 20),
(18, '2.55', 3, 2, 2, 2, 3, 2, 2, 3, 3, 3, 3, 25),
(19, '2.45', 2, 3, 4, 2, 2, 2, 2, 2, 2, 3, 3, 26),
(20, '2.55', 2, 3, 3, 2, 3, 3, 2, 2, 2, 3, 3, 24),
(21, '2.73', 3, 3, 3, 2, 3, 2, 3, 3, 3, 2, 3, 22),
(22, '3.36', 4, 3, 3, 3, 4, 4, 3, 4, 3, 3, 3, 29),
(23, '3.55', 3, 3, 4, 4, 3, 4, 3, 3, 4, 4, 4, 31),
(24, '2.45', 2, 2, 3, 3, 2, 3, 2, 3, 2, 2, 3, 28),
(25, '2.45', 3, 3, 3, 2, 2, 3, 2, 2, 2, 2, 3, 30),
(26, '2.73', 3, 3, 3, 3, 3, 3, 3, 3, 2, 2, 2, 33),
(27, '2.36', 2, 3, 3, 3, 2, 2, 3, 2, 2, 2, 2, 27),
(28, '2.55', 2, 3, 2, 3, 3, 2, 3, 3, 3, 2, 2, 34),
(29, '2.64', 2, 2, 3, 2, 3, 3, 2, 3, 3, 3, 3, 32),
(30, '2.82', 3, 3, 2, 2, 3, 3, 3, 3, 3, 3, 3, 35),
(31, '2.64', 2, 2, 2, 3, 3, 3, 3, 3, 3, 3, 2, 36),
(32, '2.45', 2, 3, 3, 3, 2, 2, 2, 2, 3, 3, 2, 37),
(33, '1.18', 1, 1, 2, 1, 2, 1, 1, 1, 1, 1, 1, 39),
(34, '2.45', 2, 3, 2, 3, 3, 3, 3, 2, 2, 2, 2, 40),
(35, '2.64', 3, 3, 3, 2, 3, 3, 3, 2, 2, 3, 2, 38),
(36, '2.00', 2, 2, 2, 1, 2, 2, 2, 2, 2, 2, 3, 42),
(37, '2.18', 2, 2, 2, 2, 3, 2, 3, 2, 2, 2, 2, 43),
(38, '1.27', 1, 1, 2, 1, 2, 2, 1, 1, 1, 1, 1, 41),
(39, '2.91', 3, 3, 2, 3, 3, 2, 3, 3, 3, 4, 3, 45),
(40, '2.91', 3, 3, 3, 3, 3, 3, 3, 2, 3, 3, 3, 44),
(41, '2.82', 3, 3, 4, 3, 2, 3, 2, 3, 3, 3, 2, 46),
(42, '2.91', 4, 3, 2, 3, 3, 3, 3, 2, 3, 3, 3, 49),
(43, '2.36', 3, 3, 2, 1, 2, 2, 3, 1, 3, 3, 3, 50),
(44, '2.64', 2, 3, 2, 3, 2, 2, 3, 3, 3, 3, 3, 48),
(45, '2.64', 3, 2, 3, 3, 2, 3, 2, 2, 3, 3, 3, 47),
(46, '2.64', 3, 3, 3, 3, 2, 3, 3, 2, 3, 2, 2, 51),
(47, '2.36', 2, 2, 3, 2, 3, 2, 2, 2, 3, 3, 2, 53),
(48, '2.82', 3, 3, 3, 2, 3, 3, 3, 3, 3, 3, 2, 54),
(49, '2.36', 2, 2, 2, 3, 3, 2, 2, 2, 3, 3, 2, 55),
(50, '2.36', 3, 3, 2, 2, 3, 2, 2, 1, 2, 3, 3, 57),
(51, '3.00', 3, 4, 3, 3, 3, 3, 2, 2, 3, 4, 3, 58),
(52, '3.18', 3, 3, 3, 3, 3, 4, 3, 4, 3, 3, 3, 56),
(53, '3.09', 3, 3, 3, 2, 3, 3, 2, 4, 3, 4, 4, 59),
(54, '2.91', 3, 3, 3, 3, 3, 3, 3, 2, 3, 4, 2, 62),
(55, '3.18', 3, 3, 3, 4, 3, 4, 4, 2, 3, 3, 3, 63),
(56, '3.00', 3, 3, 3, 3, 3, 3, 4, 2, 3, 3, 3, 61),
(57, '3.27', 3, 4, 3, 4, 3, 3, 3, 3, 3, 4, 3, 64),
(58, '1.91', 2, 2, 1, 2, 2, 2, 2, 2, 2, 2, 2, 66),
(59, '2.27', 3, 2, 2, 2, 2, 3, 2, 2, 3, 2, 2, 65),
(60, '2.64', 3, 3, 3, 2, 3, 2, 2, 2, 3, 3, 3, 67),
(61, '3.91', 4, 4, 4, 4, 4, 4, 4, 4, 4, 3, 4, 2),
(62, '3.64', 4, 4, 4, 3, 4, 4, 3, 3, 3, 4, 4, 68),
(63, '3.45', 3, 4, 4, 3, 4, 3, 3, 3, 4, 3, 4, 69),
(64, '3.00', 3, 3, 4, 3, 3, 3, 3, 2, 3, 3, 3, 70),
(65, '3.00', 3, 3, 4, 3, 3, 3, 3, 2, 3, 3, 3, 71),
(66, '3.36', 4, 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 73),
(67, '3.45', 4, 4, 4, 3, 3, 3, 3, 3, 3, 4, 4, 75),
(68, '2.36', 2, 3, 3, 2, 2, 2, 2, 2, 3, 2, 3, 76),
(69, '3.27', 3, 4, 4, 3, 4, 3, 3, 3, 3, 3, 3, 77),
(70, '2.73', 3, 3, 4, 3, 3, 2, 3, 2, 2, 3, 2, 78),
(71, '3.00', 3, 3, 4, 3, 3, 3, 3, 2, 3, 3, 3, 79),
(72, '3.55', 4, 4, 4, 4, 3, 4, 3, 3, 4, 3, 3, 80),
(73, '3.00', 3, 3, 3, 3, 3, 3, 3, 4, 2, 3, 3, 74),
(74, '3.27', 4, 4, 4, 3, 3, 3, 3, 3, 3, 3, 3, 81),
(75, '2.82', 3, 3, 3, 2, 3, 3, 3, 2, 3, 3, 3, 82),
(76, '2.55', 3, 3, 3, 2, 2, 2, 3, 3, 3, 2, 2, 72),
(77, '2.00', 2, 2, 2, 2, 2, 2, 3, 2, 2, 1, 2, 83),
(78, '2.45', 2, 2, 3, 3, 2, 2, 3, 3, 3, 2, 2, 88),
(79, '2.91', 3, 3, 3, 3, 2, 3, 3, 3, 3, 3, 3, 87),
(80, '2.00', 2, 2, 3, 2, 2, 2, 2, 2, 2, 1, 2, 85),
(81, '2.91', 3, 3, 3, 3, 3, 3, 2, 3, 3, 3, 3, 89),
(82, '2.82', 2, 3, 3, 3, 3, 2, 3, 3, 3, 2, 4, 90),
(83, '1.64', 2, 2, 1, 1, 1, 2, 1, 2, 3, 1, 2, 91),
(84, '2.09', 2, 2, 2, 2, 2, 2, 3, 2, 2, 2, 2, 84),
(85, '2.55', 2, 3, 3, 2, 2, 2, 3, 2, 3, 3, 3, 92),
(86, '1.36', 1, 2, 2, 1, 2, 1, 2, 1, 1, 1, 1, 86),
(87, '2.91', 3, 3, 3, 3, 3, 3, 3, 3, 3, 2, 3, 96),
(88, '2.55', 3, 3, 3, 2, 2, 2, 3, 2, 3, 2, 3, 98),
(89, '2.64', 2, 3, 3, 2, 2, 2, 3, 3, 3, 3, 3, 97),
(90, '2.55', 2, 3, 2, 3, 3, 3, 2, 2, 3, 3, 2, 99),
(91, '2.55', 3, 2, 3, 3, 2, 2, 3, 2, 3, 2, 3, 101),
(92, '2.45', 3, 3, 3, 2, 3, 3, 2, 2, 2, 2, 2, 94),
(93, '1.64', 1, 1, 2, 1, 2, 2, 2, 2, 2, 1, 2, 100),
(94, '2.91', 3, 3, 3, 3, 3, 2, 3, 3, 3, 3, 3, 103),
(95, '2.18', 2, 2, 2, 2, 3, 2, 2, 2, 2, 2, 3, 95),
(96, '2.00', 2, 2, 2, 2, 2, 2, 2, 1, 2, 3, 2, 93),
(97, '1.82', 2, 2, 2, 1, 2, 2, 2, 2, 2, 1, 2, 104),
(98, '2.64', 3, 2, 3, 3, 2, 3, 3, 3, 2, 3, 2, 107),
(99, '2.00', 2, 1, 2, 2, 2, 2, 1, 3, 2, 2, 3, 106),
(100, '2.73', 3, 3, 3, 3, 3, 2, 3, 2, 2, 3, 3, 105),
(101, '2.64', 3, 2, 3, 2, 3, 3, 3, 2, 3, 2, 3, 108),
(102, '2.64', 3, 2, 3, 2, 3, 3, 3, 2, 3, 2, 3, 109),
(103, '2.18', 2, 2, 3, 2, 2, 2, 2, 2, 2, 2, 3, 110),
(104, '2.91', 3, 3, 4, 3, 2, 3, 2, 3, 3, 3, 3, 111),
(105, '2.27', 2, 2, 2, 2, 3, 3, 2, 2, 3, 2, 2, 112),
(106, '2.73', 3, 3, 3, 2, 2, 3, 2, 3, 3, 3, 3, 114),
(107, '3.18', 3, 4, 3, 4, 3, 3, 3, 3, 3, 3, 3, 4),
(108, '2.36', 3, 3, 2, 3, 2, 2, 1, 2, 2, 4, 2, 115),
(109, '3.45', 3, 3, 4, 3, 4, 4, 3, 3, 4, 4, 3, 116),
(110, '3.09', 3, 4, 3, 3, 3, 4, 3, 3, 2, 3, 3, 118),
(111, '2.64', 3, 3, 3, 2, 2, 3, 2, 2, 3, 3, 3, 117),
(112, '2.36', 3, 2, 3, 2, 2, 3, 2, 2, 2, 3, 2, 119),
(113, '2.36', 2, 2, 3, 2, 3, 3, 3, 2, 2, 2, 2, 120),
(114, '3.27', 4, 3, 4, 3, 3, 3, 3, 3, 3, 4, 3, 122),
(115, '2.73', 3, 3, 3, 2, 3, 3, 2, 2, 3, 3, 3, 121),
(116, '1.82', 2, 2, 2, 1, 2, 2, 2, 1, 2, 2, 2, 123),
(117, '2.64', 3, 3, 3, 2, 3, 2, 3, 3, 2, 2, 3, 124),
(118, '2.00', 2, 2, 3, 1, 2, 2, 2, 1, 2, 3, 2, 102),
(119, '2.45', 2, 2, 3, 2, 2, 3, 2, 2, 3, 3, 3, 126),
(120, '2.36', 3, 2, 3, 1, 3, 2, 2, 2, 2, 3, 3, 132),
(121, '2.36', 3, 2, 3, 2, 2, 2, 2, 2, 2, 3, 3, 134),
(122, '2.64', 3, 4, 3, 2, 2, 2, 2, 3, 2, 3, 3, 136),
(123, '2.91', 3, 3, 4, 3, 3, 3, 3, 2, 2, 3, 3, 135),
(124, '2.09', 1, 3, 3, 2, 3, 1, 2, 1, 2, 2, 3, 138),
(125, '3.27', 3, 4, 4, 3, 3, 3, 4, 3, 3, 3, 3, 141),
(126, '2.45', 3, 3, 2, 3, 2, 3, 2, 2, 2, 2, 3, 140),
(127, '2.82', 3, 3, 3, 2, 3, 3, 2, 3, 3, 3, 3, 139),
(128, '2.55', 3, 3, 3, 2, 2, 2, 3, 2, 2, 3, 3, 144),
(129, '3.00', 3, 3, 3, 2, 4, 3, 3, 3, 3, 3, 3, 143),
(130, '2.73', 3, 3, 3, 2, 3, 3, 2, 2, 3, 3, 3, 145),
(131, '1.45', 2, 2, 2, 1, 1, 1, 1, 1, 1, 2, 2, 150),
(132, '2.09', 2, 3, 3, 1, 2, 2, 2, 2, 2, 2, 2, 151),
(133, '3.09', 3, 3, 3, 3, 3, 4, 3, 3, 3, 3, 3, 147),
(134, '2.00', 2, 2, 3, 1, 2, 1, 2, 1, 2, 3, 3, 149),
(135, '2.09', 2, 2, 3, 1, 2, 2, 2, 2, 2, 2, 3, 155),
(136, '1.91', 2, 2, 2, 1, 2, 2, 2, 2, 2, 2, 2, 154),
(137, '2.00', 2, 2, 2, 1, 2, 2, 3, 2, 2, 2, 2, 152),
(138, '2.09', 3, 3, 4, 1, 2, 1, 2, 1, 1, 2, 3, 159),
(139, '2.27', 2, 2, 3, 2, 3, 2, 2, 2, 2, 3, 2, 157),
(140, '2.91', 3, 3, 3, 2, 3, 3, 3, 3, 3, 3, 3, 156),
(141, '1.91', 2, 1, 2, 2, 2, 2, 2, 2, 2, 2, 2, 158),
(142, '2.55', 2, 3, 3, 2, 2, 3, 2, 3, 2, 3, 3, 162),
(143, '3.27', 3, 3, 4, 3, 4, 3, 3, 3, 4, 3, 3, 164),
(144, '3.55', 3, 3, 4, 3, 4, 4, 4, 3, 4, 3, 4, 166),
(145, '2.64', 3, 3, 2, 3, 3, 3, 2, 2, 3, 2, 3, 167),
(146, '2.91', 3, 3, 3, 3, 3, 3, 3, 2, 3, 3, 3, 165),
(147, '2.27', 2, 2, 3, 3, 2, 2, 2, 2, 2, 2, 3, 161),
(148, '2.27', 3, 2, 2, 2, 2, 3, 2, 2, 2, 3, 2, 168),
(149, '2.00', 2, 2, 3, 2, 2, 2, 2, 2, 2, 1, 2, 163),
(150, '1.36', 1, 2, 2, 1, 1, 1, 1, 1, 1, 2, 2, 169),
(151, '2.91', 3, 3, 4, 3, 2, 3, 3, 2, 2, 3, 4, 160),
(152, '2.36', 2, 2, 3, 2, 3, 2, 2, 2, 2, 3, 3, 170),
(153, '2.09', 2, 2, 2, 2, 3, 1, 2, 1, 2, 4, 2, 172),
(154, '2.27', 2, 3, 2, 2, 3, 2, 2, 2, 2, 3, 2, 171),
(155, '2.18', 3, 3, 2, 2, 2, 2, 2, 1, 2, 3, 2, 173),
(156, '2.55', 2, 3, 3, 3, 3, 2, 2, 2, 2, 3, 3, 175),
(157, '2.45', 3, 3, 2, 3, 2, 2, 3, 2, 2, 3, 2, 174),
(158, '2.82', 3, 3, 2, 3, 4, 2, 3, 2, 2, 4, 3, 177),
(159, '2.55', 2, 3, 3, 2, 3, 2, 3, 2, 2, 3, 3, 176),
(160, '2.45', 3, 2, 2, 3, 3, 3, 2, 2, 2, 2, 3, 180),
(161, '3.27', 3, 3, 4, 3, 3, 3, 4, 4, 3, 3, 3, 178),
(162, '2.73', 3, 2, 3, 3, 3, 3, 3, 3, 2, 2, 3, 181),
(163, '3.45', 3, 4, 3, 4, 4, 3, 3, 4, 3, 4, 3, 179),
(164, '3.18', 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, 4, 183),
(165, '3.09', 3, 3, 3, 3, 2, 3, 4, 3, 4, 3, 3, 184),
(166, '2.82', 4, 4, 2, 2, 3, 3, 2, 2, 3, 3, 3, 185),
(167, '2.73', 3, 3, 4, 3, 2, 2, 2, 2, 3, 3, 3, 182),
(168, '2.55', 3, 3, 3, 3, 2, 2, 2, 2, 2, 3, 3, 187),
(169, '3.00', 3, 3, 3, 4, 4, 2, 2, 2, 3, 4, 3, 189),
(170, '2.82', 3, 2, 3, 3, 2, 3, 3, 3, 3, 3, 3, 186),
(171, '2.91', 3, 3, 3, 3, 3, 2, 3, 3, 3, 3, 3, 188),
(172, '2.55', 3, 3, 3, 2, 2, 2, 3, 2, 2, 3, 3, 191),
(173, '2.18', 3, 3, 3, 2, 2, 2, 1, 1, 2, 2, 3, 190),
(174, '3.09', 3, 3, 3, 3, 3, 3, 3, 3, 3, 4, 3, 192);

-- --------------------------------------------------------

--
-- Table structure for table `role_table`
--

CREATE TABLE `role_table` (
  `role_id` int(11) NOT NULL,
  `role_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `role_table`
--

INSERT INTO `role_table` (`role_id`, `role_name`) VALUES
(1, 'BUSINESS LEADER'),
(2, 'STRATEGIC LEADER'),
(3, 'TACTICAL LEADER'),
(4, 'OPERATIONAL LEADER'),
(5, 'ACTION LEADER'),
(6, 'GROUP LEADER'),
(7, 'TEAM MEMBER');

-- --------------------------------------------------------

--
-- Table structure for table `sys_menu`
--

CREATE TABLE `sys_menu` (
  `menu_id` int(11) NOT NULL,
  `menu_label` varchar(100) NOT NULL,
  `chinese_label` varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
  `link` varchar(100) NOT NULL DEFAULT '#',
  `icon` varchar(100) NOT NULL DEFAULT 'fa fa-external-link-square',
  `parent` int(11) NOT NULL DEFAULT 0,
  `sort` int(11) NOT NULL,
  `user_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1-admin,2-user'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `sys_menu`
--

INSERT INTO `sys_menu` (`menu_id`, `menu_label`, `chinese_label`, `link`, `icon`, `parent`, `sort`, `user_type`) VALUES
(1, 'Dashboard', '仪表板', 'dashboard', 'fa fa-dashboard', 0, 1, 2),
(69, 'Configuration', '组态', '#', 'fa fa-gears', 0, 12, 0),
(70, 'Update Company Info', 'Update Company Info', 'configcontroller/changeCompanyInfo', 'fa fa-external-link-square', 69, 11, 0),
(71, 'Manage User', '管理用户', 'configcontroller/userList', 'fa fa-external-link-square', 69, 10, 0),
(72, 'Change Password 更改密码', '更改密码', 'configcontroller/changePassword', 'fa fa-external-link-square', 0, 13, 2),
(78, 'Manage Department', '管理部', 'department/lists', 'fa fa-puzzle-piece', 69, 6, 0),
(85, 'Manage Designation', '管理指定', 'configcontroller/postList', 'fa fa-external-link-square', 69, 10, 0),
(101, 'Reports for Staff', '报告', '#', 'fa fa-paste', 0, 5, 0),
(102, 'PD April', '日期明智的报告', 'pdapril/lists', 'fa fa-paste', 101, 1, 0),
(108, 'PDS & Promotion', '绩效对', 'performance/lists', 'fa fa-list', 0, 2, 2),
(109, 'PD October', NULL, 'pdoctober/lists', 'fa fa-paste', 101, 2, 0),
(110, 'Competency List', NULL, 'competency/lists', 'fa fa-list', 69, 1, 0),
(112, 'Employee Lists', NULL, 'employee/lists', 'fa fa-users', 69, 1, 0),
(113, 'Reporting Manager List', NULL, 'manager/lists', 'fa fa-users', 69, 2, 0),
(114, 'GL Evaluation', NULL, 'glevaluation/lists', 'fa fa-paste', 0, 3, 2),
(115, 'TL Evaluation', NULL, 'tlevaluation/lists', 'fa fa-paste', 0, 4, 0),
(116, 'Reports for GL', NULL, '#', 'fa fa-paste', 0, 6, 0),
(117, 'April Report', NULL, 'aglevaluation/lists', 'fa fa-paste', 116, 1, 0),
(118, 'October Report', NULL, 'oglevaluation/lists', 'fa fa-paste', 116, 2, 0),
(119, 'GL List', NULL, 'glinfo/lists', 'fa fa-users', 69, 1, 0),
(120, 'Promotion Interview', NULL, 'promotion/lists', 'fa fa-paste', 0, 4, 2),
(121, 'Promotion Report', NULL, 'rpromotion/lists', 'fa fa-paste', 101, 3, 0);

-- --------------------------------------------------------

--
-- Table structure for table `sys_user_role`
--

CREATE TABLE `sys_user_role` (
  `user_role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `menu_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `sys_user_role`
--

INSERT INTO `sys_user_role` (`user_role_id`, `user_id`, `menu_id`) VALUES
(344, 9, 1),
(345, 9, 72),
(346, 9, 90),
(347, 9, 83),
(348, 9, 87),
(349, 9, 88),
(350, 9, 89),
(351, 9, 91),
(352, 9, 93),
(353, 9, 94),
(354, 9, 95),
(355, 9, 96),
(356, 9, 99),
(395, 9, 1),
(396, 9, 69),
(397, 9, 70),
(398, 9, 71),
(399, 9, 78),
(400, 9, 85),
(401, 9, 72),
(402, 9, 101),
(403, 9, 102),
(404, 9, 108),
(424, 14, 1),
(425, 14, 72),
(426, 14, 108),
(427, 15, 1),
(428, 15, 72),
(429, 15, 108),
(433, 17, 1),
(434, 17, 72),
(435, 17, 108),
(439, 13, 1),
(440, 13, 72),
(441, 13, 108),
(442, 12, 1),
(443, 12, 72),
(444, 12, 108),
(445, 18, 1),
(446, 18, 72),
(447, 18, 108),
(460, 19, 1),
(461, 19, 72),
(462, 19, 108),
(463, 10, 1),
(464, 10, 72),
(465, 10, 101),
(466, 10, 102),
(467, 10, 109),
(468, 10, 108),
(469, 1, 1),
(470, 1, 69),
(471, 1, 70),
(472, 1, 71),
(473, 1, 72),
(478, 2, 1),
(479, 2, 72),
(480, 2, 101),
(481, 2, 102),
(482, 2, 109),
(485, 57, 1),
(498, 59, 1),
(499, 59, 72),
(500, 59, 108),
(501, 60, 1),
(502, 60, 72),
(503, 60, 108),
(504, 61, 1),
(505, 61, 72),
(506, 61, 108),
(550, 71, 1),
(551, 71, 69),
(552, 71, 71),
(553, 71, 112),
(554, 71, 119),
(555, 71, 72),
(556, 71, 114),
(560, 73, 1),
(561, 73, 72),
(562, 73, 114),
(567, 75, 1),
(568, 75, 72),
(569, 75, 114),
(573, 77, 1),
(574, 77, 72),
(575, 77, 114),
(576, 78, 1),
(577, 78, 72),
(578, 78, 114),
(579, 79, 1),
(580, 79, 72),
(581, 79, 114),
(585, 81, 1),
(586, 81, 72),
(587, 81, 114),
(591, 83, 1),
(592, 83, 72),
(593, 83, 114),
(597, 85, 1),
(598, 85, 72),
(599, 85, 114),
(600, 86, 1),
(601, 86, 72),
(602, 86, 114),
(606, 88, 1),
(607, 88, 72),
(608, 88, 114),
(612, 87, 1),
(613, 87, 72),
(614, 87, 114),
(623, 35, 1),
(624, 35, 72),
(625, 35, 108),
(638, 4, 1),
(639, 4, 72),
(640, 4, 108),
(647, 58, 1),
(648, 58, 72),
(649, 58, 108),
(653, 42, 1),
(654, 42, 72),
(655, 42, 101),
(656, 42, 102),
(657, 42, 109),
(658, 42, 121),
(659, 42, 108),
(660, 42, 114),
(661, 42, 116),
(662, 42, 117),
(663, 42, 118),
(664, 42, 120),
(665, 33, 1),
(666, 33, 72),
(667, 33, 108),
(668, 3, 1),
(669, 3, 72),
(670, 3, 108),
(671, 3, 120),
(672, 91, 1),
(673, 91, 72),
(674, 91, 108),
(678, 93, 1),
(679, 93, 72),
(680, 93, 108),
(681, 94, 1),
(682, 94, 72),
(683, 94, 108),
(684, 6, 1),
(685, 6, 72),
(686, 6, 108),
(687, 6, 120),
(688, 76, 1),
(689, 76, 72),
(690, 76, 114),
(691, 92, 1),
(692, 92, 72),
(693, 92, 108),
(715, 31, 1),
(716, 31, 72),
(717, 31, 108),
(718, 8, 1),
(719, 8, 72),
(720, 8, 108),
(721, 53, 1),
(722, 53, 72),
(723, 53, 108),
(724, 99, 1),
(725, 99, 72),
(726, 99, 108),
(727, 99, 114),
(728, 98, 1),
(729, 98, 72),
(730, 98, 108),
(731, 98, 114),
(732, 97, 1),
(733, 97, 72),
(734, 97, 108),
(735, 97, 114),
(736, 96, 1),
(737, 96, 72),
(738, 96, 108),
(739, 96, 114),
(747, 67, 1),
(748, 67, 72),
(749, 67, 108),
(750, 67, 114),
(755, 16, 1),
(756, 16, 72),
(757, 16, 108),
(758, 16, 114),
(759, 16, 120),
(760, 70, 1),
(761, 70, 72),
(762, 70, 108),
(763, 70, 114),
(764, 72, 1),
(765, 72, 72),
(766, 72, 114),
(773, 66, 1),
(774, 66, 72),
(775, 66, 108),
(776, 66, 114),
(777, 51, 1),
(778, 51, 72),
(779, 51, 108),
(780, 21, 1),
(781, 21, 72),
(782, 21, 108),
(793, 100, 1),
(794, 100, 72),
(795, 100, 114),
(796, 64, 1),
(797, 64, 72),
(798, 64, 114),
(806, 101, 1),
(807, 101, 72),
(808, 101, 108),
(809, 102, 1),
(810, 102, 72),
(811, 102, 114),
(818, 63, 1),
(819, 63, 72),
(820, 63, 108),
(821, 63, 114),
(822, 24, 1),
(823, 24, 72),
(824, 24, 108),
(825, 24, 114),
(826, 74, 1),
(827, 74, 72),
(828, 74, 114),
(832, 11, 1),
(833, 11, 72),
(834, 11, 108),
(835, 11, 114),
(836, 104, 1),
(837, 104, 72),
(838, 104, 108),
(839, 104, 114),
(840, 105, 1),
(841, 105, 72),
(842, 105, 114),
(843, 106, 1),
(844, 106, 72),
(845, 106, 114),
(846, 107, 1),
(847, 107, 72),
(848, 107, 114),
(849, 89, 1),
(850, 89, 72),
(851, 89, 108),
(852, 89, 114),
(853, 80, 1),
(854, 80, 72),
(855, 80, 114),
(856, 108, 1),
(857, 108, 72),
(858, 108, 114),
(868, 29, 1),
(869, 29, 72),
(870, 29, 108),
(871, 29, 120),
(876, 25, 1),
(877, 25, 72),
(878, 25, 108),
(879, 25, 120),
(900, 36, 1),
(901, 36, 72),
(902, 36, 108),
(903, 90, 1),
(904, 90, 72),
(905, 90, 108),
(910, 110, 1),
(911, 110, 72),
(912, 110, 108),
(913, 110, 114),
(914, 82, 1),
(915, 82, 72),
(916, 82, 108),
(917, 82, 114),
(918, 84, 1),
(919, 84, 72),
(920, 84, 108),
(921, 84, 114),
(932, 112, 101),
(933, 112, 109),
(934, 112, 116),
(935, 112, 117),
(936, 112, 118),
(971, 113, 69),
(972, 113, 71),
(995, 114, 115),
(996, 115, 1),
(997, 115, 72),
(998, 115, 114),
(1007, 116, 1),
(1008, 116, 72),
(1009, 116, 114),
(1010, 62, 1),
(1011, 62, 72),
(1012, 62, 108),
(1013, 62, 114),
(1014, 117, 1),
(1015, 117, 72),
(1016, 117, 108),
(1017, 117, 114),
(1021, 95, 1),
(1022, 95, 72),
(1023, 95, 114),
(1024, 5, 1),
(1025, 5, 72),
(1026, 5, 108),
(1027, 5, 120),
(1028, 45, 1),
(1029, 45, 72),
(1030, 45, 108),
(1031, 45, 114),
(1032, 45, 120),
(1033, 118, 1),
(1034, 118, 72),
(1035, 118, 114),
(1036, 109, 1),
(1037, 109, 72),
(1038, 109, 114),
(1043, 103, 1),
(1044, 103, 72),
(1045, 103, 108),
(1046, 103, 114),
(1050, 119, 1),
(1051, 119, 72),
(1052, 119, 114),
(1054, 120, 1),
(1055, 120, 72),
(1056, 120, 114),
(1057, 121, 1),
(1058, 121, 72),
(1059, 121, 114),
(1060, 122, 1),
(1061, 122, 72),
(1062, 122, 114),
(1063, 123, 1),
(1064, 123, 72),
(1065, 123, 114),
(1066, 68, 1),
(1067, 68, 72),
(1068, 68, 108),
(1069, 68, 114),
(1070, 40, 1),
(1071, 28, 1),
(1072, 28, 72),
(1073, 28, 108),
(1074, 28, 114),
(1075, 28, 120),
(1076, 30, 1),
(1077, 30, 72),
(1078, 30, 108),
(1079, 30, 120),
(1080, 124, 1),
(1081, 124, 72),
(1082, 124, 114),
(1083, 125, 1),
(1084, 125, 72),
(1085, 125, 114),
(1086, 126, 1),
(1087, 126, 72),
(1088, 126, 114),
(1089, 127, 1),
(1090, 127, 72),
(1091, 127, 114),
(1092, 128, 1),
(1093, 128, 72),
(1094, 128, 114),
(1095, 129, 1),
(1096, 129, 72),
(1097, 129, 114),
(1098, 130, 1),
(1099, 130, 72),
(1100, 130, 114),
(1101, 131, 1),
(1102, 131, 72),
(1103, 131, 114),
(1104, 111, 1),
(1105, 111, 69),
(1106, 111, 71),
(1107, 111, 112),
(1108, 111, 119),
(1109, 111, 72),
(1110, 111, 108),
(1111, 111, 114),
(1115, 47, 1),
(1116, 47, 72),
(1117, 47, 108),
(1118, 133, 1),
(1119, 133, 72),
(1120, 133, 114),
(1121, 134, 1),
(1122, 134, 72),
(1123, 134, 108),
(1124, 134, 114),
(1125, 48, 1),
(1126, 48, 72),
(1127, 48, 108),
(1134, 132, 1),
(1135, 132, 72),
(1136, 132, 108),
(1153, 65, 1),
(1154, 65, 72),
(1155, 65, 114),
(1156, 135, 1),
(1157, 135, 72),
(1158, 135, 114),
(1163, 69, 1),
(1164, 69, 72),
(1165, 69, 108),
(1166, 69, 114),
(1167, 56, 1),
(1168, 56, 72),
(1169, 56, 108),
(1170, 136, 1),
(1171, 136, 72),
(1172, 136, 108),
(1173, 136, 114);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `assesment_rating`
--
ALTER TABLE `assesment_rating`
  ADD PRIMARY KEY (`ass_rating_id`);

--
-- Indexes for table `basic_details`
--
ALTER TABLE `basic_details`
  ADD PRIMARY KEY (`per_appr_id`);

--
-- Indexes for table `company_info`
--
ALTER TABLE `company_info`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `competencies`
--
ALTER TABLE `competencies`
  ADD PRIMARY KEY (`competencies_id`);

--
-- Indexes for table `department_info`
--
ALTER TABLE `department_info`
  ADD PRIMARY KEY (`department_id`);

--
-- Indexes for table `development_action`
--
ALTER TABLE `development_action`
  ADD PRIMARY KEY (`development_action_id`);

--
-- Indexes for table `employee_info`
--
ALTER TABLE `employee_info`
  ADD PRIMARY KEY (`employee_id`);

--
-- Indexes for table `function_table`
--
ALTER TABLE `function_table`
  ADD PRIMARY KEY (`function_id`);

--
-- Indexes for table `gltl_detail`
--
ALTER TABLE `gltl_detail`
  ADD PRIMARY KEY (`gltl_detail_id`);

--
-- Indexes for table `gltl_master`
--
ALTER TABLE `gltl_master`
  ADD PRIMARY KEY (`master_id`);

--
-- Indexes for table `gltl_question`
--
ALTER TABLE `gltl_question`
  ADD PRIMARY KEY (`question_id`);

--
-- Indexes for table `grade_table`
--
ALTER TABLE `grade_table`
  ADD PRIMARY KEY (`grade_id`);

--
-- Indexes for table `kra_master`
--
ALTER TABLE `kra_master`
  ADD PRIMARY KEY (`kra_id`);

--
-- Indexes for table `level_competencies`
--
ALTER TABLE `level_competencies`
  ADD PRIMARY KEY (`competencies_id`);

--
-- Indexes for table `manager_list`
--
ALTER TABLE `manager_list`
  ADD PRIMARY KEY (`manager_id`);

--
-- Indexes for table `nomination_table`
--
ALTER TABLE `nomination_table`
  ADD PRIMARY KEY (`nomination_id`);

--
-- Indexes for table `objective_setting`
--
ALTER TABLE `objective_setting`
  ADD PRIMARY KEY (`objective_setting_id`);

--
-- Indexes for table `org_info`
--
ALTER TABLE `org_info`
  ADD PRIMARY KEY (`org_id`);

--
-- Indexes for table `post`
--
ALTER TABLE `post`
  ADD PRIMARY KEY (`post_id`);

--
-- Indexes for table `promotion_details`
--
ALTER TABLE `promotion_details`
  ADD PRIMARY KEY (`promotion_id`);

--
-- Indexes for table `promotion_rating`
--
ALTER TABLE `promotion_rating`
  ADD PRIMARY KEY (`ass_rating_id`);

--
-- Indexes for table `role_table`
--
ALTER TABLE `role_table`
  ADD PRIMARY KEY (`role_id`);

--
-- Indexes for table `sys_menu`
--
ALTER TABLE `sys_menu`
  ADD PRIMARY KEY (`menu_id`);

--
-- Indexes for table `sys_user_role`
--
ALTER TABLE `sys_user_role`
  ADD PRIMARY KEY (`user_role_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `assesment_rating`
--
ALTER TABLE `assesment_rating`
  MODIFY `ass_rating_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=677;

--
-- AUTO_INCREMENT for table `basic_details`
--
ALTER TABLE `basic_details`
  MODIFY `per_appr_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=770;

--
-- AUTO_INCREMENT for table `company_info`
--
ALTER TABLE `company_info`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `competencies`
--
ALTER TABLE `competencies`
  MODIFY `competencies_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=456;

--
-- AUTO_INCREMENT for table `department_info`
--
ALTER TABLE `department_info`
  MODIFY `department_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `development_action`
--
ALTER TABLE `development_action`
  MODIFY `development_action_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `employee_info`
--
ALTER TABLE `employee_info`
  MODIFY `employee_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=868;

--
-- AUTO_INCREMENT for table `function_table`
--
ALTER TABLE `function_table`
  MODIFY `function_id` smallint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=74;

--
-- AUTO_INCREMENT for table `gltl_detail`
--
ALTER TABLE `gltl_detail`
  MODIFY `gltl_detail_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5034;

--
-- AUTO_INCREMENT for table `gltl_master`
--
ALTER TABLE `gltl_master`
  MODIFY `master_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=745;

--
-- AUTO_INCREMENT for table `gltl_question`
--
ALTER TABLE `gltl_question`
  MODIFY `question_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `grade_table`
--
ALTER TABLE `grade_table`
  MODIFY `grade_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `kra_master`
--
ALTER TABLE `kra_master`
  MODIFY `kra_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8665;

--
-- AUTO_INCREMENT for table `level_competencies`
--
ALTER TABLE `level_competencies`
  MODIFY `competencies_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

--
-- AUTO_INCREMENT for table `manager_list`
--
ALTER TABLE `manager_list`
  MODIFY `manager_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=62;

--
-- AUTO_INCREMENT for table `nomination_table`
--
ALTER TABLE `nomination_table`
  MODIFY `nomination_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=185;

--
-- AUTO_INCREMENT for table `objective_setting`
--
ALTER TABLE `objective_setting`
  MODIFY `objective_setting_id` bigint(20) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `org_info`
--
ALTER TABLE `org_info`
  MODIFY `org_id` tinyint(4) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `post`
--
ALTER TABLE `post`
  MODIFY `post_id` smallint(6) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `promotion_details`
--
ALTER TABLE `promotion_details`
  MODIFY `promotion_id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=197;

--
-- AUTO_INCREMENT for table `promotion_rating`
--
ALTER TABLE `promotion_rating`
  MODIFY `ass_rating_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=176;

--
-- AUTO_INCREMENT for table `role_table`
--
ALTER TABLE `role_table`
  MODIFY `role_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `sys_menu`
--
ALTER TABLE `sys_menu`
  MODIFY `menu_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=122;

--
-- AUTO_INCREMENT for table `sys_user_role`
--
ALTER TABLE `sys_user_role`
  MODIFY `user_role_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1174;
COMMIT;

