|
1
|
use salarymarket;
|
|
2
|
-- 1) Quiz definition
|
|
3
|
INSERT INTO solution_quiz (id, quizCode, quiz_image, averagetime)
|
|
4
|
VALUES
|
|
5
|
(9, 'quiz_9_Parcours_et_Performances', '', 15);
|
|
6
|
-- 2) Quiz translations
|
|
7
|
INSERT INTO solution_quiz_translate (quizCode, title, description, short_description, languageId)
|
|
8
|
VALUES
|
|
9
|
('quiz_9_Parcours_et_Performances',
|
|
10
|
'Questionnaire 9 – Parcours et Performances',
|
|
11
|
'Questionnaire sur le système d’évaluation, l’attribution des grades et le chemin de carrière',
|
|
12
|
'Questionnaire sur le système d’évaluation, l’attribution des grades et le chemin de carrière',
|
|
13
|
2),
|
|
14
|
('quiz_9_Parcours_et_Performances',
|
|
15
|
'Quiz 9 – Performance, Grades & Career Pathways',
|
|
16
|
'Survey on performance evaluation systems, grade assignment, and career paths',
|
|
17
|
'Survey on performance evaluation systems, grade assignment, and career paths',
|
|
18
|
1);
|
|
19
|
-- 3) Sections
|
|
20
|
INSERT INTO solution_quiz_section (sectionCode, quizCode, section_order)
|
|
21
|
VALUES
|
|
22
|
('Performance_Evaluation_System', 'quiz_9_Parcours_et_Performances', 1),
|
|
23
|
('Grades_and_Promotions', 'quiz_9_Parcours_et_Performances', 2),
|
|
24
|
('Career_Management', 'quiz_9_Parcours_et_Performances', 3);
|
|
25
|
-- 4) Section translations
|
|
26
|
INSERT INTO solution_quiz_section_translate (sectionCode, title, languageId)
|
|
27
|
VALUES
|
|
28
|
('Performance_Evaluation_System', 'Performance Evaluation System', 1),
|
|
29
|
('Performance_Evaluation_System', 'Système d’évaluation de la performance', 2),
|
|
30
|
('Grades_and_Promotions', 'Grades and Promotions', 1),
|
|
31
|
('Grades_and_Promotions', 'Attribution des grades et promotions', 2),
|
|
32
|
('Career_Management', 'Career Management', 1),
|
|
33
|
('Career_Management', 'Gestion des parcours professionnels', 2);
|
|
34
|
-- 5) Questions & chart types
|
|
35
|
INSERT INTO solution_quiz_section_questions
|
|
36
|
(questionCode, sectionCode, quizCode, idparent, type, question_order, echartType)
|
|
37
|
VALUES
|
|
38
|
-- Section 1: Performance Evaluation System
|
|
39
|
('Q9-PES-1', 'Performance_Evaluation_System', 'quiz_9_Parcours_et_Performances', NULL, 'CU', 1, 'Pie'),
|
|
40
|
('Q9-PES-2', 'Performance_Evaluation_System', 'quiz_9_Parcours_et_Performances', 'Q9-PES-1', 'CU', 2, 'Pie'),
|
|
41
|
('Q9-PES-3', 'Performance_Evaluation_System', 'quiz_9_Parcours_et_Performances', 'Q9-PES-1', 'CM', 3, 'Bar'),
|
|
42
|
('Q9-PES-4', 'Performance_Evaluation_System', 'quiz_9_Parcours_et_Performances', 'Q9-PES-1', 'CU', 4, 'Pie'),
|
|
43
|
('Q9-PES-5', 'Performance_Evaluation_System', 'quiz_9_Parcours_et_Performances', 'Q9-PES-1', 'CM', 5, 'Bar'),
|
|
44
|
-- Section 2: Grades and Promotions
|
|
45
|
('Q9-GP-1', 'Grades_and_Promotions', 'quiz_9_Parcours_et_Performances', NULL, 'CU', 6, 'Pie'),
|
|
46
|
('Q9-GP-2', 'Grades_and_Promotions', 'quiz_9_Parcours_et_Performances', 'Q9-GP-1', 'CM', 7, 'Bar'),
|
|
47
|
('Q9-GP-3', 'Grades_and_Promotions', 'quiz_9_Parcours_et_Performances', NULL, 'CU', 8, 'Pie'),
|
|
48
|
('Q9-GP-4', 'Grades_and_Promotions', 'quiz_9_Parcours_et_Performances', NULL, 'CU', 9, 'Pie'),
|
|
49
|
-- Section 3: Career Management
|
|
50
|
('Q9-CM-1', 'Career_Management', 'quiz_9_Parcours_et_Performances', NULL, 'CU', 10, 'Pie'),
|
|
51
|
('Q9-CM-2', 'Career_Management', 'quiz_9_Parcours_et_Performances', NULL, 'CM', 11, 'Bar'),
|
|
52
|
('Q9-CM-3', 'Career_Management', 'quiz_9_Parcours_et_Performances', Null, 'CM', 12, 'Bar'),
|
|
53
|
('Q9-CM-4', 'Career_Management', 'quiz_9_Parcours_et_Performances', NULL, 'CU', 13, 'Pie');
|
|
54
|
-- 6) Question translations (French & English)
|
|
55
|
INSERT INTO solution_quiz_section_questions_translate (questionCode, title, languageId)
|
|
56
|
VALUES
|
|
57
|
-- Section 1: Performance Evaluation System
|
|
58
|
('Q9-PES-1', 'Votre entreprise dispose-t-elle d’un système formalisé d’évaluation de la performance ?', 2),
|
|
59
|
('Q9-PES-1', 'Does your company have a formalized performance evaluation system?', 1),
|
|
60
|
('Q9-PES-2', 'A quelle fréquence les évaluations sont-elles réalisées ?', 2),
|
|
61
|
('Q9-PES-2', 'How often are performance evaluations conducted?', 1),
|
|
62
|
('Q9-PES-3', 'Quels outils ou méthodes utilisez-vous pour l’évaluation ?', 2),
|
|
63
|
('Q9-PES-3', 'What tools or methods do you use for evaluation?', 1),
|
|
64
|
('Q9-PES-4', 'Les critères d’évaluation sont-ils homogènes pour l’ensemble des métiers ?', 2),
|
|
65
|
('Q9-PES-4', 'Are evaluation criteria homogeneous for all job types?', 1),
|
|
66
|
('Q9-PES-5', 'Les résultats de l’évaluation influencent-ils directement:', 2),
|
|
67
|
('Q9-PES-5', 'Do evaluation results directly influence:', 1),
|
|
68
|
-- Section 2: Grades and Promotions
|
|
69
|
('Q9-GP-1', 'Disposez-vous d’une grille de grades formalisée ?', 2),
|
|
70
|
('Q9-GP-1', 'Do you have a formalized grade grid?', 1),
|
|
71
|
('Q9-GP-2', 'Quels sont les principaux critères pour accéder à un grade supérieur ?', 2),
|
|
72
|
('Q9-GP-2', 'What are the main criteria for accessing a higher grade?', 1),
|
|
73
|
('Q9-GP-3', 'Les décisions de promotion sont-elles prises selon un processus standardisé ?', 2),
|
|
74
|
('Q9-GP-3', 'Are promotion decisions made according to a standardized process?', 1),
|
|
75
|
('Q9-GP-4', 'Disposez vous d\'une politique de communication autour des promotions', 2),
|
|
76
|
('Q9-GP-4', 'Do you have a communication policy around promotions?', 1),
|
|
77
|
-- Section 3: Career Management
|
|
78
|
('Q9-CM-1', 'Disposez vous d\'une politique formelle de gestion des parcours professionnels ?', 2),
|
|
79
|
('Q9-CM-1', 'Do you have a formal career management policy?', 1),
|
|
80
|
('Q9-CM-2', 'Quelles dispositifs mettez-vous en place pour favoriser l’évolution de carrière ?', 2),
|
|
81
|
('Q9-CM-2', 'What measures do you implement to support career development?', 1),
|
|
82
|
('Q9-CM-3', 'Ces dispositifs sont-ils accessibles à :', 2),
|
|
83
|
('Q9-CM-3', 'Are these measures accessible to:', 1),
|
|
84
|
('Q9-CM-4', 'Existe-t-il des parcours différenciés selon les profils ou les métiers ?', 2),
|
|
85
|
('Q9-CM-4', 'Are there differentiated career paths according to profiles or job types?', 1);
|
|
86
|
-- 7) Only insert new items (with English names, standardized codes)
|
|
87
|
INSERT INTO solution_reponses_items (itemCode, itemName)
|
|
88
|
VALUES
|
|
89
|
('semiannual', 'Semiannual'),
|
|
90
|
('annual_interview', 'Annual interview'),
|
|
91
|
('evaluation_360', '360° evaluation'),
|
|
92
|
('self_evaluation', 'Self‑evaluation'),
|
|
93
|
('digital_platform', 'Digital evaluation platform'),
|
|
94
|
('salary_increase', 'Salary increases'),
|
|
95
|
('training_needs', 'Training needs'),
|
|
96
|
('in_progress', 'In progress'),
|
|
97
|
('organizational_needs', 'Organizational needs'),
|
|
98
|
('hierarchical_recommendation', 'Hierarchical recommendation'),
|
|
99
|
('standardized_process', 'Standardized process'),
|
|
100
|
('informal_practices', 'Informal practices'),
|
|
101
|
('communication_policy', 'Communication policy'),
|
|
102
|
('career_plan', 'Career plan'),
|
|
103
|
('internal_mobility_device', 'Internal mobility'),
|
|
104
|
('individual_development_plan', 'Individual development plan'),
|
|
105
|
('skills_assessment', 'Skills assessment'),
|
|
106
|
('managerial_support', 'Managerial support'),
|
|
107
|
('career_interview', 'Career interview'),
|
|
108
|
('all_employees', 'All employees'),
|
|
109
|
('technical_experts', 'Technical experts'),
|
|
110
|
('identified_talents', 'Identified talents'),
|
|
111
|
('promotion', 'Promotion'),
|
|
112
|
('internal_mobility', 'Internal mobility'),
|
|
113
|
('evaluation_results', 'Evaluation results'),
|
|
114
|
('skills_certifications','Skills certifications'),
|
|
115
|
('yes_for_all','yes for all professions'),
|
|
116
|
('yes_career_plans_coaching','Yes (career plans, coaching...)'),
|
|
117
|
('under_development', 'Under development');
|
|
118
|
-- 8) Translations for new items (French and English)
|
|
119
|
INSERT INTO solution_quiz_question_items_translate (itemCode, itemValue, languageId)
|
|
120
|
VALUES
|
|
121
|
('semiannual', 'Semestrielle', 2), ('semiannual', 'Semiannual', 1),
|
|
122
|
('annual_interview', 'Entretiens annuels', 2),
|
|
123
|
('annual_interview', 'Annual interview', 1),
|
|
124
|
('evaluation_360', 'Évaluation 360°', 2),
|
|
125
|
('evaluation_360', '360° evaluation', 1),
|
|
126
|
('self_evaluation', 'Auto-évaluation', 2),
|
|
127
|
('self_evaluation', 'Self-evaluation', 1),
|
|
128
|
('digital_platform', 'Plateformes numériques d’évaluation', 2),
|
|
129
|
('digital_platform', 'Digital evaluation platform', 1),
|
|
130
|
('salary_increase', 'Les augmentations salariales', 2),
|
|
131
|
('salary_increase', 'Salary increases', 1),
|
|
132
|
('training_needs', 'Les besoins en formation', 2),
|
|
133
|
('training_needs', 'Training needs', 1),
|
|
134
|
('in_progress', 'En cours de structuration', 2),
|
|
135
|
('in_progress', 'In progress', 1),
|
|
136
|
('organizational_needs', 'Besoins organisationnels', 2),
|
|
137
|
('organizational_needs', 'Organizational needs', 1),
|
|
138
|
('hierarchical_recommendation', 'Recommandation hiérarchique', 2),
|
|
139
|
('hierarchical_recommendation', 'Hierarchical recommendation', 1),
|
|
140
|
('standardized_process', 'Oui (processus écrit, comités, validation RH)', 2),
|
|
141
|
('standardized_process', 'Yes (written process, committees, HR validation', 1),
|
|
142
|
('informal_practices', 'Partiellement (pratiques informelles encadrées)', 2),
|
|
143
|
('informal_practices', 'Partially (structured informal practices)', 1),
|
|
144
|
('communication_policy', 'Politique de communication', 2),
|
|
145
|
('communication_policy', 'Communication policy', 1),
|
|
146
|
('career_plan', 'Plans de carrière', 2), ('career_plan', 'Career plan', 1),
|
|
147
|
('internal_mobility_device', 'Mobilité interne', 2),
|
|
148
|
('internal_mobility_device', 'Internal mobility', 1),
|
|
149
|
('individual_development_plan', 'Plan de développement individuel', 2),
|
|
150
|
('individual_development_plan', 'Individual development plan', 1),
|
|
151
|
('skills_assessment', 'Bilan de compétences', 2), ('skills_assessment', 'Skills assessment', 1),
|
|
152
|
('managerial_support', 'Accompagnement managérial', 2), ('managerial_support', 'Managerial support', 1),
|
|
153
|
('career_interview', 'Entretien de carrière', 2), ('career_interview', 'Career interview', 1),
|
|
154
|
('all_employees', 'Tous les collaborateurs', 2), ('all_employees', 'All employees', 1),
|
|
155
|
('technical_experts', 'Experts Techniques', 2), ('technical_experts', 'Technical experts', 1),
|
|
156
|
('identified_talents', 'Les Talents identifiés', 2), ('identified_talents', 'Identified talents', 1),
|
|
157
|
('under_development', 'En cours d''élaboration', 2), ('under_development', 'Under development', 1),
|
|
158
|
('skills_certifications', 'Compétences / certifications', 2), -- French
|
|
159
|
('skills_certifications', 'Skills certifications', 1), -- English
|
|
160
|
('promotion', 'Les promotions', 2), -- French
|
|
161
|
('promotion', 'Promotion', 1), -- English
|
|
162
|
('internal_mobility', 'La mobilité Interne', 2), -- French
|
|
163
|
('internal_mobility', 'Internal mobility', 1), -- English
|
|
164
|
('yes_for_all', 'Oui pour tous les métiers', 2), -- French
|
|
165
|
('yes_for_all', 'Yes for all professions', 1), -- English
|
|
166
|
('yes_career_plans_coaching',"Oui (plans de carrière, coaching...)", 2),
|
|
167
|
('yes_career_plans_coaching',"Yes (career plans, coaching...)", 1),
|
|
168
|
('evaluation_results', 'Résultats de l’évaluation de performance', 2), -- French
|
|
169
|
('evaluation_results', 'Evaluation results', 1); -- English
|
|
170
|
-- 9) Link items to Quiz 9 questions (use standardized codes)
|
|
171
|
INSERT INTO solution_quiz_section_questions_items (itemCode, questionCode, itemParentId, isOther)
|
|
172
|
VALUES
|
|
173
|
-- Q9-PES-1 (Performance evaluation system)
|
|
174
|
('yes', 'Q9-PES-1', NULL, 0),
|
|
175
|
('no', 'Q9-PES-1', NULL, 0),
|
|
176
|
-- Q9-PES-2 (Frequency)
|
|
177
|
('annually', 'Q9-PES-2', 'yes', 0),
|
|
178
|
('semiannual', 'Q9-PES-2', 'yes', 0),
|
|
179
|
('quarterly', 'Q9-PES-2', 'yes', 0),
|
|
180
|
('other_frequency', 'Q9-PES-2', 'yes', 1),
|
|
181
|
-- Q9-PES-3 (Methods)
|
|
182
|
('annual_interview', 'Q9-PES-3', 'yes', 0),
|
|
183
|
('evaluation_360', 'Q9-PES-3', 'yes', 0),
|
|
184
|
('self_evaluation', 'Q9-PES-3', 'yes', 0),
|
|
185
|
('digital_platform', 'Q9-PES-3', 'yes', 0),
|
|
186
|
('other_option', 'Q9-PES-3', 'yes', 1),
|
|
187
|
-- Q9-PES-4 (Homogeneity)
|
|
188
|
('yes', 'Q9-PES-4', 'yes', 0),
|
|
189
|
('partially', 'Q9-PES-4','yes', 0),
|
|
190
|
('no', 'Q9-PES-4', 'yes', 0),
|
|
191
|
-- Q9-PES-5 (Influence)
|
|
192
|
('salary_increase', 'Q9-PES-5', 'yes', 0),
|
|
193
|
('promotion', 'Q9-PES-5', 'yes', 0),
|
|
194
|
('training_needs', 'Q9-PES-5', 'yes', 0),
|
|
195
|
('internal_mobility', 'Q9-PES-5', 'yes', 0),
|
|
196
|
('no', 'Q9-PES-5', 'yes', 0),
|
|
197
|
('other_option', 'Q9-PES-5', 'yes', 1),
|
|
198
|
-- Q9-GP-1 (Grade grid)
|
|
199
|
('yes_for_all', 'Q9-GP-1', NULL, 0),
|
|
200
|
('partially', 'Q9-GP-1', NULL, 0),
|
|
201
|
('no', 'Q9-GP-1', NULL, 0),
|
|
202
|
('in_progress', 'Q9-GP-1', NULL, 0),
|
|
203
|
-- Q9-GP-2 (Criteria for grade)
|
|
204
|
('seniority', 'Q9-GP-2', 'yes_for_all', 0),
|
|
205
|
('evaluation_results', 'Q9-GP-2', 'yes_for_all', 0),
|
|
206
|
('skills_certifications', 'Q9-GP-2', 'yes_for_all', 0),
|
|
207
|
('organizational_needs', 'Q9-GP-2', 'yes_for_all', 0),
|
|
208
|
('hierarchical_recommendation', 'Q9-GP-2', 'yes_for_all', 0),
|
|
209
|
('other-hiring', 'Q9-GP-2', 'yes_for_all', 1),
|
|
210
|
-- Q9-GP-3 (Promotion process)
|
|
211
|
('standardized_process', 'Q9-GP-3', NULL, 0),
|
|
212
|
('informal_practices', 'Q9-GP-3', NULL, 0),
|
|
213
|
('no', 'Q9-GP-3', NULL, 0),
|
|
214
|
-- Q9-GP-4 (Promotion communication)
|
|
215
|
('yes', 'Q9-GP-4', NULL, 0),
|
|
216
|
('no', 'Q9-GP-4', NULL, 0),
|
|
217
|
-- Q9-CM-1 (Career management policy)
|
|
218
|
('yes_career_plans_coaching', 'Q9-CM-1', NULL, 0),
|
|
219
|
('no', 'Q9-CM-1', NULL, 0),
|
|
220
|
('in_progress', 'Q9-CM-1', NULL, 0),
|
|
221
|
-- Q9-CM-2 (Career development measures)
|
|
222
|
('internal_mobility_device', 'Q9-CM-2', NULL, 0),
|
|
223
|
('training', 'Q9-CM-2', NULL, 0),
|
|
224
|
('individual_development_plan', 'Q9-CM-2', NULL, 0),
|
|
225
|
('skills_assessment', 'Q9-CM-2', NULL, 0),
|
|
226
|
('managerial_support', 'Q9-CM-2', NULL, 0),
|
|
227
|
('career_interview', 'Q9-CM-2', NULL, 0),
|
|
228
|
('other-hiring', 'Q9-CM-2', NULL, 1),
|
|
229
|
-- Q9-CM-3 (Beneficiaries)
|
|
230
|
('all_employees', 'Q9-CM-3', NULL, 0),
|
|
231
|
('managers', 'Q9-CM-3', NULL, 0),
|
|
232
|
('technical_experts', 'Q9-CM-3', NULL, 0),
|
|
233
|
('identified_talents', 'Q9-CM-3', NULL, 0),
|
|
234
|
('other-please-specify', 'Q9-CM-3', NULL, 1),
|
|
235
|
-- Q9-CM-4 (Differentiated paths)
|
|
236
|
('yes', 'Q9-CM-4', NULL, 0),
|
|
237
|
('no', 'Q9-CM-4', NULL, 0),
|
|
238
|
('under_development', 'Q9-CM-4', NULL, 0);
|