|
1
|
use salarymarket;
|
|
2
|
-- 1) Quiz definition
|
|
3
|
INSERT INTO solution_quiz (id, quizCode, quiz_image, averagetime)
|
|
4
|
VALUES
|
|
5
|
(6, 'quiz_6_Sales_Force_Management',
|
|
6
|
'Gestion de la force de vente.jpg',
|
|
7
|
20);
|
|
8
|
-- 2) Quiz translations
|
|
9
|
INSERT INTO solution_quiz_translate (quizCode, title, description, short_description, languageId)
|
|
10
|
VALUES
|
|
11
|
('quiz_6_Sales_Force_Management',
|
|
12
|
'Questionnaire 6 – Gestion de la force de vente',
|
|
13
|
'Étude des pratiques de gestion de la force de vente',
|
|
14
|
'Étude des pratiques de gestion de la force de vente',
|
|
15
|
2),
|
|
16
|
('quiz_6_Sales_Force_Management',
|
|
17
|
'Quiz 6 – Sales Force Management',
|
|
18
|
'Survey of sales force management practices',
|
|
19
|
'Survey of sales force management practices',
|
|
20
|
1);
|
|
21
|
-- 3) Single Section
|
|
22
|
INSERT INTO solution_quiz_section (sectionCode, quizCode, section_order)
|
|
23
|
VALUES
|
|
24
|
('Sales_Force_Management', 'quiz_6_Sales_Force_Management', 1);
|
|
25
|
-- 4) Section translations
|
|
26
|
INSERT INTO solution_quiz_section_translate (sectionCode, title, languageId)
|
|
27
|
VALUES
|
|
28
|
('Sales_Force_Management', 'Sales Force Management', 1),
|
|
29
|
('Sales_Force_Management', 'Gestion de la force de vente', 2);
|
|
30
|
-- 5) Questions & chart types
|
|
31
|
INSERT INTO solution_quiz_section_questions
|
|
32
|
(questionCode, sectionCode, quizCode, idparent, type, question_order, echartType)
|
|
33
|
VALUES
|
|
34
|
-- Parent question
|
|
35
|
('Q6-SFM-1', 'Sales_Force_Management', 'quiz_6_Sales_Force_Management', NULL, 'CU', 1, 'Pie'),
|
|
36
|
|
|
37
|
-- Child questions
|
|
38
|
('Q6-SFM-2', 'Sales_Force_Management', 'quiz_6_Sales_Force_Management', 'Q6-SFM-1', 'CU', 2, 'Table'),
|
|
39
|
('Q6-SFM-3', 'Sales_Force_Management', 'quiz_6_Sales_Force_Management', 'Q6-SFM-1', 'CU', 3, 'Pie'),
|
|
40
|
('Q6-SFM-4', 'Sales_Force_Management', 'quiz_6_Sales_Force_Management', 'Q6-SFM-3', 'CU', 4, 'Pie'),
|
|
41
|
('Q6-SFM-5', 'Sales_Force_Management', 'quiz_6_Sales_Force_Management', 'Q6-SFM-3', 'CU', 5, 'Pie'),
|
|
42
|
('Q6-SFM-6', 'Sales_Force_Management', 'quiz_6_Sales_Force_Management', 'Q6-SFM-1', 'CU', 6, 'Table'),
|
|
43
|
('Q6-SFM-7', 'Sales_Force_Management', 'quiz_6_Sales_Force_Management','Q6-SFM-1', 'CU', 7, 'Pie'),
|
|
44
|
('Q6-SFM-8', 'Sales_Force_Management', 'quiz_6_Sales_Force_Management', 'Q6-SFM-1', 'CM', 8, 'Table'),
|
|
45
|
('Q6-SFM-9', 'Sales_Force_Management', 'quiz_6_Sales_Force_Management', 'Q6-SFM-1', 'CM', 9, 'Table'),
|
|
46
|
('Q6-SFM-10', 'Sales_Force_Management', 'quiz_6_Sales_Force_Management', 'Q6-SFM-1', 'CM', 10, 'Table'),
|
|
47
|
('Q6-SFM-11', 'Sales_Force_Management', 'quiz_6_Sales_Force_Management', 'Q6-SFM-1', 'CU', 11, 'Pie'),
|
|
48
|
('Q6-SFM-12', 'Sales_Force_Management', 'quiz_6_Sales_Force_Management', 'Q6-SFM-1', 'CM', 12, 'Bar');
|
|
49
|
-- 6) Question translations
|
|
50
|
INSERT INTO solution_quiz_section_questions_translate (questionCode, title, languageId)
|
|
51
|
VALUES
|
|
52
|
-- Parent question
|
|
53
|
('Q6-SFM-1', 'Disposez-vous de plans d''incitation/de commissions sur les ventes', 2),
|
|
54
|
('Q6-SFM-1', 'Do you have sales incentive/commission plans', 1),
|
|
55
|
|
|
56
|
-- Child questions
|
|
57
|
('Q6-SFM-2', 'Nombre de plans d''incitation/de commissions sur les ventes', 2),
|
|
58
|
('Q6-SFM-2', 'Number of sales incentive/commission plans', 1),
|
|
59
|
|
|
60
|
('Q6-SFM-3', 'Quels types de rémunération spécifique sont proposés pour la force de vente ?', 2),
|
|
61
|
('Q6-SFM-3', 'What types of specific compensation are offered for the sales force?', 1),
|
|
62
|
|
|
63
|
('Q6-SFM-4', 'Disposez-vous d''un plafond de rémunération pour les commissions basées sur les objectifs', 2),
|
|
64
|
('Q6-SFM-4', 'Do you have a compensation cap for goal-based commissions', 1),
|
|
65
|
|
|
66
|
('Q6-SFM-5', 'Disposez-vous d''un plafond de rémunération pour les primes de performance', 2),
|
|
67
|
('Q6-SFM-5', 'Do you have a compensation cap for performance bonuses', 1),
|
|
68
|
|
|
69
|
('Q6-SFM-6', 'A partir de quand les nouveaux embauchés peuvent participer à un plan d''incitation à la vente/à la commission', 2),
|
|
70
|
('Q6-SFM-6', 'When can new hires participate in a sales/commission incentive plan', 1),
|
|
71
|
|
|
72
|
('Q6-SFM-7', 'L''organisation dispose-t-elle un plan d''incitation à long terme', 2),
|
|
73
|
('Q6-SFM-7', 'Does the organization have a long-term incentive plan', 1),
|
|
74
|
|
|
75
|
('Q6-SFM-8', 'Quelles sont les principales mesures des résultats des ventes utilisées', 2),
|
|
76
|
('Q6-SFM-8', 'What are the main sales performance measures used', 1),
|
|
77
|
|
|
78
|
('Q6-SFM-9', 'Quelles sont les mesures supplémentaires des résultats des ventes', 2),
|
|
79
|
('Q6-SFM-9', 'What are the additional sales performance measures', 1),
|
|
80
|
|
|
81
|
('Q6-SFM-10', 'Quelles sont les autres mesures des résultats des ventes', 2),
|
|
82
|
('Q6-SFM-10', 'What are the other sales performance measures', 1),
|
|
83
|
|
|
84
|
('Q6-SFM-11', 'Quelle est la fréquence de révision des cibles de vente et des plans d''incitation / de commission ?', 2),
|
|
85
|
('Q6-SFM-11', 'What is the frequency of review of sales targets and incentive/commission plans?', 1),
|
|
86
|
|
|
87
|
('Q6-SFM-12', 'Quels outils ou supports votre entreprise met-elle en place pour aider la force de vente à atteindre ses objectifs ?', 2),
|
|
88
|
('Q6-SFM-12', 'What tools or support does your company provide to help the sales force achieve their goals?', 1);
|
|
89
|
-- Insert all response items
|
|
90
|
INSERT INTO solution_reponses_items (itemCode, itemName)
|
|
91
|
VALUES
|
|
92
|
|
|
93
|
-- Number of plans
|
|
94
|
('1-5', '1-5 plans'),
|
|
95
|
('6-10', '6-10 plans'),
|
|
96
|
('11-20', '11-20 plans'),
|
|
97
|
|
|
98
|
-- Compensation types
|
|
99
|
('commissions', 'Commissions'),
|
|
100
|
('performance_bonus', 'Performance bonuses'),
|
|
101
|
('annual_bonus', 'Annual bonuses'),
|
|
102
|
('other_compensation', 'Other compensation'),
|
|
103
|
|
|
104
|
-- Eligibility
|
|
105
|
('at_hiring', 'At hiring'),
|
|
106
|
('after_period', 'After defined period'),
|
|
107
|
|
|
108
|
|
|
109
|
('other_eligibility', 'Other eligibility'),
|
|
110
|
|
|
111
|
-- Long-term incentive
|
|
112
|
('yes_all', 'Yes, all employees'),
|
|
113
|
('yes_certain_level', 'Yes, from certain level'),
|
|
114
|
|
|
115
|
-- Sales measures
|
|
116
|
('revenue', 'Revenue'),
|
|
117
|
('sales_volume', 'Sales volume'),
|
|
118
|
('profit_value', 'Profit value'),
|
|
119
|
('profit_market_share', 'Profit percentage Market share'),
|
|
120
|
('other_measure', 'Other measure'),
|
|
121
|
|
|
122
|
-- Objectives
|
|
123
|
('individual_objectives', 'Individual objectives'),
|
|
124
|
('team_objectives', 'Team objectives'),
|
|
125
|
('company_objectives', 'Company objectives'),
|
|
126
|
('none', 'None'),
|
|
127
|
('other_objective', 'Other objective'),
|
|
128
|
|
|
129
|
-- Review frequency
|
|
130
|
('monthly', 'Monthly'),
|
|
131
|
('other_frequency', 'Other frequency'),
|
|
132
|
|
|
133
|
-- Support tools
|
|
134
|
('training', 'Training'),
|
|
135
|
('tech_tools', 'Technological tools'),
|
|
136
|
('coaching', 'Support and coaching'),
|
|
137
|
('motivation_meetings', 'Motivation meetings'),
|
|
138
|
('other_tool', 'Other tool');
|
|
139
|
|
|
140
|
-- 8) Add translations for all items
|
|
141
|
INSERT INTO solution_quiz_question_items_translate (itemCode, itemValue, languageId)
|
|
142
|
VALUES
|
|
143
|
-- Number of plans
|
|
144
|
('1-5', '1-5 plans', 1),
|
|
145
|
('1-5', '1-5 plans', 2),
|
|
146
|
('6-10', '6-10 plans', 1),
|
|
147
|
('6-10', '6-10 plans', 2),
|
|
148
|
('11-20', '11-20 plans', 1),
|
|
149
|
('11-20', '11-20 plans', 2),
|
|
150
|
-- Compensation types
|
|
151
|
('commissions', 'Commissions', 1),
|
|
152
|
('commissions', 'Commissions', 2),
|
|
153
|
('performance_bonus', 'Performance bonuses', 1),
|
|
154
|
('performance_bonus', 'Primes de performance', 2),
|
|
155
|
('annual_bonus', 'Annual bonuses', 1),
|
|
156
|
('annual_bonus', 'Bonus annuels', 2),
|
|
157
|
('other_compensation', 'Other (please specify)', 1),
|
|
158
|
('other_compensation', 'Autre (veuillez préciser)', 2),
|
|
159
|
-- Eligibility
|
|
160
|
('at_hiring', 'At hiring (first day of entry into the organization)', 1),
|
|
161
|
('at_hiring', 'A l''embauche (le premier jour de l''entrée dans l''organisation)', 2),
|
|
162
|
('after_period', 'Eligible after a defined period', 1),
|
|
163
|
('after_period', 'Admissible après une période définie', 2),
|
|
164
|
('other_eligibility', 'Other eligibility policy', 1),
|
|
165
|
('other_eligibility', 'Autre politique d''éligibilité', 2),
|
|
166
|
-- Long-term incentive
|
|
167
|
('yes_all', 'Yes, all employees are concerned', 1),
|
|
168
|
('yes_all', 'Oui, tout les collaborateurs sont concernés', 2),
|
|
169
|
('yes_certain_level', 'Yes, only from a certain level', 1),
|
|
170
|
('yes_certain_level', 'Oui, uniquement à partir d''un certain niveau', 2),
|
|
171
|
-- Sales measures
|
|
172
|
('revenue', 'Revenue', 1),
|
|
173
|
('revenue', 'Chiffre d''affaires', 2),
|
|
174
|
('sales_volume', 'Sales volume', 1),
|
|
175
|
('sales_volume', 'Volume des ventes', 2),
|
|
176
|
('profit_value', 'Profit value', 1),
|
|
177
|
('profit_value', 'Valeur du bénéfice', 2),
|
|
178
|
('profit_market_share', 'Profit percentage Market share', 1),
|
|
179
|
('profit_market_share', 'Pourcentage du bénéfice Part de marché', 2),
|
|
180
|
('other_measure', 'Other (please specify)', 1),
|
|
181
|
('other_measure', 'Autre (veuillez préciser)', 2),
|
|
182
|
-- Objectives
|
|
183
|
('individual_objectives', 'Individual objectives', 1),
|
|
184
|
('individual_objectives', 'Objectifs individuels', 2),
|
|
185
|
('team_objectives', 'Team objectives', 1),
|
|
186
|
('team_objectives', 'Objectifs de l''équipe', 2),
|
|
187
|
('company_objectives', 'Company objectives', 1),
|
|
188
|
('company_objectives', 'Objectifs de l''entreprise', 2),
|
|
189
|
('none', 'None', 1),
|
|
190
|
('none', 'Aucune', 2),
|
|
191
|
('other_objective', 'Other (please specify)', 1),
|
|
192
|
('other_objective', 'Autre (veuillez préciser)', 2),
|
|
193
|
-- Review frequency
|
|
194
|
('monthly', 'Monthly', 1),
|
|
195
|
('monthly', 'Mensuelle', 2),
|
|
196
|
('other_frequency', 'Other (please specify)', 1),
|
|
197
|
('other_frequency', 'Autre (veuillez préciser)', 2),
|
|
198
|
-- Support tools
|
|
199
|
('training', 'Training', 1),
|
|
200
|
('training', 'Formations', 2),
|
|
201
|
('tech_tools', 'Technological tools (CRM, sales software)', 1),
|
|
202
|
('tech_tools', 'Outils technologiques (CRM, logiciels de vente)', 2),
|
|
203
|
('coaching', 'Support and coaching', 1),
|
|
204
|
('coaching', 'Accompagnement et coaching', 2),
|
|
205
|
('motivation_meetings', 'Motivation meetings', 1),
|
|
206
|
('motivation_meetings', 'Réunions de motivation', 2),
|
|
207
|
('other_tool', 'Other (please specify)', 1),
|
|
208
|
('other_tool', 'Autre (veuillez préciser)', 2);
|
|
209
|
-- Then insert the new links
|
|
210
|
INSERT INTO solution_quiz_section_questions_items (itemCode, questionCode, itemParentId, isOther)
|
|
211
|
VALUES
|
|
212
|
-- Parent question (Q6-SFM-1)
|
|
213
|
('yes', 'Q6-SFM-1', NULL, 0),
|
|
214
|
('no', 'Q6-SFM-1', NULL, 0),
|
|
215
|
-- Q6-SFM-2 (Number of plans)
|
|
216
|
('1-5', 'Q6-SFM-2', 'yes', 0),
|
|
217
|
('6-10', 'Q6-SFM-2', 'yes', 0),
|
|
218
|
('11-20', 'Q6-SFM-2', 'yes', 0),
|
|
219
|
-- Q6-SFM-3 (Types of compensation)
|
|
220
|
('commissions', 'Q6-SFM-3', 'yes', 0),
|
|
221
|
('performance_bonus', 'Q6-SFM-3', 'yes', 0),
|
|
222
|
('annual_bonus', 'Q6-SFM-3', 'yes', 0),
|
|
223
|
('other_compensation', 'Q6-SFM-3', 'yes', 1),
|
|
224
|
-- Q6-SFM-4 (Commission cap)
|
|
225
|
('yes', 'Q6-SFM-4', 'commissions', 0),
|
|
226
|
('no', 'Q6-SFM-4', 'commissions', 0),
|
|
227
|
-- Q6-SFM-5 (Performance bonus cap)
|
|
228
|
('yes', 'Q6-SFM-5', 'performance_bonus', 0),
|
|
229
|
('no', 'Q6-SFM-5', 'performance_bonus', 0),
|
|
230
|
-- Q6-SFM-6 (New hire eligibility)
|
|
231
|
('at_hiring', 'Q6-SFM-6', 'yes', 0),
|
|
232
|
('after_period', 'Q6-SFM-6', 'yes', 0),
|
|
233
|
('other_eligibility', 'Q6-SFM-6', 'yes', 1),
|
|
234
|
-- Q6-SFM-7 (Long-term incentive)
|
|
235
|
('yes_all', 'Q6-SFM-7', 'yes', 0),
|
|
236
|
('yes_certain_level', 'Q6-SFM-7', 'yes', 0),
|
|
237
|
('no', 'Q6-SFM-7', 'yes', 0),
|
|
238
|
-- Q6-SFM-8 (Main sales measures)
|
|
239
|
('revenue', 'Q6-SFM-8', 'yes', 0),
|
|
240
|
('sales_volume', 'Q6-SFM-8', 'yes', 0),
|
|
241
|
('profit_value', 'Q6-SFM-8', 'yes', 0),
|
|
242
|
('profit_market_share', 'Q6-SFM-8', 'yes', 0),
|
|
243
|
('other_measure', 'Q6-SFM-8', 'yes', 1),
|
|
244
|
-- Q6-SFM-9 (Additional sales measures)
|
|
245
|
('revenue', 'Q6-SFM-9', 'yes', 0),
|
|
246
|
('sales_volume', 'Q6-SFM-9', 'yes', 0),
|
|
247
|
('profit_value', 'Q6-SFM-9', 'yes', 0),
|
|
248
|
('profit_market_share', 'Q6-SFM-9', 'yes', 0),
|
|
249
|
('other_measure', 'Q6-SFM-9', 'yes', 1),
|
|
250
|
-- Q6-SFM-10 (Other sales measures)
|
|
251
|
('individual_objectives', 'Q6-SFM-10', 'yes', 0),
|
|
252
|
('team_objectives', 'Q6-SFM-10', 'yes', 0),
|
|
253
|
('company_objectives', 'Q6-SFM-10', 'yes', 0),
|
|
254
|
('none', 'Q6-SFM-10', 'yes', 0),
|
|
255
|
('other_objective', 'Q6-SFM-10', 'yes', 1),
|
|
256
|
-- Q6-SFM-11 (Review frequency)
|
|
257
|
('monthly', 'Q6-SFM-11', 'yes', 0),
|
|
258
|
('quarterly', 'Q6-SFM-11', 'yes', 0),
|
|
259
|
('annually', 'Q6-SFM-11', 'yes', 0),
|
|
260
|
('other_frequency', 'Q6-SFM-11', 'yes', 1),
|
|
261
|
-- Q6-SFM-12 (Support tools)
|
|
262
|
('training', 'Q6-SFM-12', 'yes', 0),
|
|
263
|
('tech_tools', 'Q6-SFM-12', 'yes', 0),
|
|
264
|
('coaching', 'Q6-SFM-12', 'yes', 0),
|
|
265
|
('motivation_meetings', 'Q6-SFM-12', 'yes', 0),
|
|
266
|
('other_tool', 'Q6-SFM-12', 'yes', 1);
|