text: -- phpMyAdmin SQL Dump
  -- version 4.5.4.1deb2ubuntu2
  -- http://www.phpmyadmin.net
  --
  -- Host: localhost
  -- Generation Time: Jul 12, 2018 at 11:11 PM
  -- Server version: 5.7.22-0ubuntu0.16.04.1
  -- PHP Version: 7.0.30-0ubuntu0.16.04.1
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `cp_backoffice`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `psychometricEvaluationQuestions`
  --
  
  CREATE TABLE `psychometricEvaluationQuestions` (
    `psychometricEvaluationQuestionID` int(5) NOT NULL,
    `psychometricEvaluationQuestion` text NOT NULL,
    `psychometricE1psychometricEvaluationQuestionOptions` longtext NOT NULL,
    `addedAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `active` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `psychometricEvaluationQuestions`
  --
  
  INSERT INTO `psychometricEvaluationQuestions` (`psychometricEvaluationQuestionID`, `psychometricEvaluationQuestion`, `psychometricE1psychometricEvaluationQuestionOptions`, `addedAt`, `active`) VALUES
  (1, '<p>Work on your team is difficult because of the other two individuals. The work has been divided among the three of you, but each time your team meets Janet and Jim disagree about the progress that the team has made on the project. Janet is convinced that Jim&#39;s lack ofprogress is because he is inherently lazy and not because some information is still not available to him because Janet has not completed some of her work according to the schedule she agreed to.The truth seems to be that Janet is not doing her part of the work.&nbsp;You have to meet the deadline irrespectively, what will you do?</p>\r\n', '{"option1":{"option":"<p>Try to communicate with janet and jim, get them to work with you.<\\/p>\\r\\n","category":"1"},"option2":{"option":"<p>Tell the manager about the situation and take his guidance in the situation.<\\/p>\\r\\n","category":"2"},"option3":{"option":"<p>Work hard and complete the task alone.<\\/p>\\r\\n","category":"4"},"option4":{"option":"<p>Pump up other team members and try to meet the deadline.<\\/p>\\r\\n","category":"3"}}', '2018-07-12 16:21:50', 1),
  (2, '<p>Your manager is not well, and your team has to meet the deadline regardless. In the absence of the manger, team mates are working hard but have lost their direction. What will you do?</p>\n', '{"option1":{"option":"<p>Cheer up all the team members, wait to talk to the other senior manager and coordinate the work.<\\/p>\\r\\n","category":"3"},"option2":{"option":"<p>Talk to the manager, arrange a video call with him.<\\/p>\\r\\n","category":"4"},"option3":{"option":"<p>Ask the most senior team member to take charge and help the team to follow the right track.<\\/p>\\r\\n","category":"1"},"option4":{"option":"<p>Dont wait, make decisions as the team is running low on time and you have to meet the deadline.<\\/p>\\r\\n","category":"5"}}', '2018-07-12 16:23:06', 1),
  (3, '<p>Today, your manager got hold of one mishap in your department that you were part of along with your colleague. If you own upto it, it can affect your career in the firm. Meanwhile your colleague has already owned up for the mishap. what will you do?</p>\n', '{"option1":{"option":"<p>Own upto the mistake along with your colleague and not care about getting fired.<\\/p>\\r\\n","category":"5"},"option2":{"option":"<p>You will own upto the mistake and relieve your colleague from this as his financial conditions are not good.<\\/p>\\r\\n","category":"1"},"option3":{"option":"<p>You will tell your manager the whole situation honestly and try to figure out a way out together.<\\/p>\\r\\n","category":"6"},"option4":{"option":"<p>You will convince the manager that you were not involved in the mishap and try to save your job<\\/p>\\r\\n","category":"2"}}', '2018-07-12 16:29:42', 1),
  (4, '<p>You are a department manager and you have recently thought of a new procedure that you believe would improve the work process. Some of the employees in your department agree with the change and some do not. One of your employees openly criticises the idea to your director. What would you do?</p>\r\n', '{"option1":{"option":"<p>You decide not to respond to the critics in order to avoid unnecessary conflict.<\\/p>\\r\\n","category":"4"},"option2":{"option":"<p>You meet the employee for a talk and explain that bypassing your authority is unacceptable.<\\/p>\\r\\n","category":"1"},"option3":{"option":"<p>Employee(s) trust in their manager is important so you decide to implement only some of the changes to keep employees satisfied.<\\/p>\\r\\n","category":"6"},"option4":{"option":"<p>You will convince your employees to take up the new procedure and implement it then.<\\/p>\\r\\n","category":"2"}}', '2018-07-12 16:40:23', 1),
  (5, '<p>At a marketing meeting with your supervisor and the senior marketing manager you find yourself in the midst of a conflict between them. You know that the two do not get along professionally and that they are in constant disagreement. They are now arguing about strategies for a new campaign, and are asking you to pick a side.What would you do?</p>\r\n', '{"option1":{"option":"<p>You accept the idea of your supervisor and not the senior manager. Since he is directly above you and is more like a team member to you, therefore it is politically wiser to support him.<\\/p>\\r\\n","category":"1"},"option2":{"option":"<p>You weigh up the advantages and disadvantages of each side and decide accordingly without getting involved in their personal conflict.<\\/p>\\r\\n","category":"4"},"option3":{"option":"<p>You believe that getting involved in this dispute would be detrimental to you as both sides are superior to you.Therefore, you refuse to pick a side saying that both strategies are equally successful.<\\/p>\\r\\n","category":"2"},"option4":{"option":"<p>You try to solve their personal conflicts as it would help your firm without caring about the consequences.<\\/p>\\r\\n","category":"3"}}', '2018-07-12 16:38:58', 1),
  (6, '<p>After you have served two years as manager of the sales team, the director of your company appoints a new deputy manager. Although you have been able to work together, you and your team&#39;s impressions of her are negative - you all find her arrogant and disloyal. The director has now considered sending her on a course that would create an opportunity for her relocation to a different position within the company. However, it would also speed up her promotion.</p>\r\n\r\n<p>What will you do?</p>\r\n', '{"option1":{"option":"<p>Since this course is likely to result in the relocation of the deputy manager, you approve her participation in the course.<\\/p>\\r\\n","category":"3"},"option2":{"option":"<p>You contact your director immediately and tell her about the entire situation and the views of your team members.<\\/p>\\r\\n","category":"4"},"option3":{"option":"<p>You veto her participation in the course and discuss it with her. You express your concerns and you try to work out your differences. You update your director.<\\/p>\\r\\n","category":"1"},"option4":{"option":"<p>You approve her participation in the course since it was offered by the director. However, you voice your concerns over a meeting with the director.<\\/p>\\r\\n","category":"6"}}', '2018-07-12 16:37:20', 1),
  (7, '<p>You have been working as a salesperson for the past year and have consistently achieved great sales numbers. Due to personal reasons, you have recently been unfocused at work and as a result your work performance has declined. Additionally, due to changes in the market, the sales figures of your team have decreased as well. Your director does not seem to be taking the changes in the market into account and is blaming your poor performance on poor leadership on your part. What would you do?</p>\r\n', '{"option1":{"option":"<p>You explain your personal situation to the director and apologise for the decline in the performance of my team.<br \\/>\\r\\nYou ask to take a few days off to recuperate.<\\/p>\\r\\n","category":"6"},"option2":{"option":"<p>You make a decision to put aside your personal situation and consult other sales directors regarding their ways of coping with a volatile market. You devote yourself entirely to your work.<\\/p>\\r\\n","category":"4"},"option3":{"option":"<p>You update the director on the changes in the market and explain that there is nothing that can be done at the moment to improve sales.<\\/p>\\r\\n","category":"2"},"option4":{"option":"<p>You understand the concerns of your director and hence you build up yourself, work harder and try to improve sales.<\\/p>\\r\\n","category":"3"}}', '2018-07-12 16:35:59', 1),
  (8, '<p>You have been working in the same place for the past three years and have managed to work your way up. Lately, you have been feeling that you have reached your potential in the company so you start pursuing options for advancing your career in other companies. You are now in the midst of negotiations for a new position. Rumours that you are leaving have spread in your current work place. What would you do?</p>\r\n', '{"option1":{"option":"<p>Since the rumour is already out, you update all your acquaintances in the organisation that you are in the midst of negotiations for a new position. This may even encourage your directors to promote you within the company.<\\/p>\\r\\n","category":"6"},"option2":{"option":"<p>Since it is only a rumour, you dont update anyone until you actually hand in your notice. Nothing has been decided yet.<\\/p>\\r\\n","category":"2"},"option3":{"option":"<p>Since the rumour is already out and you will probably leave, you invest very little time in completing the work.<\\/p>\\r\\n","category":"5"},"option4":{"option":"<p>Because the rumour is out you update your manager and only him about your intention of leaving. Since you are still an employee there, you keep working normally<\\/p>\\r\\n","category":"4"}}', '2018-07-12 16:34:08', 1),
  (9, '<p>The company you work for is experiencing financial difficulties. You have thought of a creative solution that will enable it to recruit more clients. However, the downside is that the company will have to let go a stable, loyal but not so profitable client (due to a conflict of interest). Two out of three marketing people agree with you while your manager does not because she believes this is too risky. What would you do?</p>\n', '{"option1":{"option":"<p>You trust your manager(s) judgement and withdraw your proposition. There is no point in going against her better judgement.\\r\\n&nbsp;<\\/p>\\r\\n","category":"1"},"option2":{"option":"<p>You present a document to your manager systematically detailing the advantages of your proposition and its contribution to the company. If she keeps insisting, you will support her decision.\\r\\n&nbsp;<\\/p>\\r\\n","category":"4"},"option3":{"option":"<p>You implement your proposition despite the manager(s) resistance. Since you have a lot of faith in this proposition, you decide to trust your judgement and go behind her back this once for the benefit of the company.\\r\\n&nbsp;<\\/p>\\r\\n","category":"5"},"option4":{"option":"<p>You confront your manager on the issue and insist that she accept your proposal. You are positive that you are right. You have the marketing people to back you and will not give up until you convince your manager otherwise.\\r\\n&nbsp;<\\/p>\\r\\n","category":"3"}}', '2018-07-12 16:32:28', 1),
  (10, '<p>A co-worker is undermining you. Currently, he is at a less senior position than you in the company and has not been working there for long. However, he is better educated than you and is also considered a fast learner. You know from a third party that he is interested in taking over some of your responsibilities. What would you do?</p>\r\n', '{"option1":{"option":"<p>You wait to see how things develop; at the moment this information is merely hearsay.<\\/p>\\r\\n","category":"5"},"option2":{"option":"<p>You call your co-worker in for a talk. You explain that cooperation is an essential feature of any workplace and tell him you believe both of you can learn from one another. If he refuses to understand, you take more serious steps.<\\/p>\\r\\n","category":"1"},"option3":{"option":"<p>You do not want to take any chances with such issues. You report the matter to your supervisor and advise him to consider replacing your co-worker.<\\/p>\\r\\n","category":"6"},"option4":{"option":"<p>Since you do not want to make a big deal out of the issue, you ask a third party to intimate to your co-worker that his behaviour is unacceptable.<\\/p>\\r\\n","category":"2"}}', '2018-07-12 16:20:53', 1),
  (11, '<p>In the past month one of your employees has shown a major decline in sales performance. Although the decline has been ongoing for a couple of months, it has been particularly steep during the past two weeks. In addition, she has started coming in late and seems very frustrated with her work. Her behaviour is influencing the atmosphere in the office as she is popular employee and has been working for the company for the past two years. What would you do?</p>\r\n', '{"option1":{"option":"<p>You meet with the employee and explain that her negative behaviour is affecting not only her performance but that of the entire office. You express a sincere desire to help her during her rough patch on condition that she cooperate with you and improve her attitude.<\\/p>\\r\\n","category":"1"},"option2":{"option":"<p>You feel that since she is a very popular employee it is crucial that she be replaced temporarily or else office performance will suffer. You assign her to back office tasks for the time being and promise her that once her performance improves, you will re-instate her in her former position..<\\/p>\\r\\n","category":"6"},"option3":{"option":"<p>You call a staff meeting to talk about the negative atmosphere in the office. You single out the problematic employee and discuss her contribution to this atmosphere in the hope that her behaviour will improve.<\\/p>\\r\\n","category":"3"},"option4":{"option":"<p>You decide to let it blow over. She has been a consistently good employee until recently and you feel you need to cut her some slack. Part of your job is to be sensitive to your employee(s) needs when necessary.<\\/p>\\r\\n","category":"5"}}', '2018-07-12 16:19:20', 1),
  (12, '<p>An organisational restructure saw the administration department taking responsibility for payroll, which was previously managed by finance administrators. During this transition period, the finance team still holds most of the key payroll related information, which will be transferred to the administration team over the coming months. The finance department however, operates in another building, making internal communication difficult. They rarely answer phone calls and take an excessively long time to reply to emails. This makes managing payroll very difficult, and you fear that staff may not be paid on time.</p>\r\n', '{"option1":{"option":"<p>Refuse to manage payroll until the finance team start cooperating with the admin team.<\\/p>\\r\\n","category":"2"},"option2":{"option":"<p>Take no additional action and let the financial team take responsibility.<\\/p>\\r\\n","category":"5"},"option3":{"option":"<p>Ensure that the finance team coordinates well with the administration.<\\/p>\\r\\n","category":"3"},"option4":{"option":"<p>Arrange regular conference calls with the finance team, ensuring the exchange of information.<\\/p>\\r\\n","category":"6"}}', '2018-07-12 16:18:10', 1),
  (13, '<p>You have recently invoiced a client for products sold and services rendered, but you feel the client is being evasive. Two weeks after receiving your invoice, the client requested an alternative invoice format, stating their system cannot process the invoice in its current state. You oblige and resend the invoice, but after another week they request that additional account information be presented on the invoice, which is highly unusual. Based on conversations with your manager, it seems the client is experiencing financial problems, and may be unable to pay the invoice at this time.</p>\n', '{"option1":{"option":"<p>Refuse to update the invoice and remind the client of their obligation to pay.<\\/p>\\r\\n","category":"2"},"option2":{"option":"<p>Write-off the costs as a loss and talk to your seniors as they have been your clients since a long time<\\/p>\\r\\n","category":"3"},"option3":{"option":"<p>Call the client, discuss an alternative payment plan to better suit their financial situation.<\\/p>\\r\\n","category":"6"},"option4":{"option":"<p>Offer to invoice for products and services separately, making each invoice easier to pay.<\\/p>\\r\\n","category":"5"}}', '2018-07-12 16:15:16', 1),
  (14, '<p>A client engagement team has booked the main meeting room, inviting a large potential client for an initial meeting. This prospective client represents one of the largest opportunities of the year, and winning their business is considered the top priority for the engagement team. However, due to a technical error with the room booking software, the room is now double booked. The managing director (MD) had previously booked to room, having arranged a meeting with a smaller existing client. Both the new and prospective client are on their way to their respective meetings, and every other meeting room has been booked. How you will respond to this situation?</p>\r\n', '{"option1":{"option":"<p>Take charges of the confusion and coordinate with the team to manage another meeting room as soon as possible.<\\/p>\\r\\n","category":"5"},"option2":{"option":"<p>Take no action and pretend that you were unaware of the double booking when the delegates arrive.<\\/p>\\r\\n","category":"2"},"option3":{"option":"<p>Call the managing director, explain the situation and ask how they would like you to proceed.<\\/p>\\r\\n","category":"6"},"option4":{"option":"<p>Call both the engagement team and the MD, see if either suggest alternative meeting arrangements.<\\/p>\\r\\n","category":"4"}}', '2018-07-12 16:52:07', 1),
  (15, '<p>Your manager is assigning your team a new innovative project which he believes could increase revenue tremendously. He is very excited about it and seems to expect that you would feel the same, leading the team that would work on the project. However, when he describes the project&#39;s details, you begin to have doubts that&nbsp;the costs seem high and you are not sure that customers would show as much interest in the product as your manager expects them to go along with the project. Your manager has more information than you do and probably thought everything through. There&#39;s no reason to drop a project he believes in so much before it even began.</p>\r\n', '{"option1":{"option":"<p>Show appreciation for his choice to assign the project to your team, but mention that you have some additional thoughts on the matter and speak your concerns.<\\/p>\\r\\n","category":"6"},"option2":{"option":"<p>Talk to your team members to get their opinion over the same.<\\/p>\\r\\n","category":"1"},"option3":{"option":"<p>Take the project and thank your manager. Later, make adjustments to his plan to make it work, hoping it will be better.<\\/p>\\r\\n","category":"5"},"option4":{"option":"<p>Be hopeful that your manager has thought it through and start putting efforts with your team.<\\/p>\\r\\n","category":"3"}}', '2018-07-12 16:10:45', 1);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `psychometricEvaluationQuestions`
  --
  ALTER TABLE `psychometricEvaluationQuestions`
    ADD PRIMARY KEY (`psychometricEvaluationQuestionID`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `psychometricEvaluationQuestions`
  --
  ALTER TABLE `psychometricEvaluationQuestions`
    MODIFY `psychometricEvaluationQuestionID` int(5) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  