|
1
|
use salarymarket;
|
|
2
|
-- Quiz 7: Travel and Expenses Management
|
|
3
|
INSERT INTO solution_quiz (id, quizCode, quiz_image, averagetime)
|
|
4
|
VALUES
|
|
5
|
(7, 'quiz_7_Travel_Expenses', 'Travel and Expenses.jpg', 15);
|
|
6
|
-- Quiz translations
|
|
7
|
INSERT INTO solution_quiz_translate (quizCode, title, description, short_description, languageId)
|
|
8
|
VALUES
|
|
9
|
('quiz_7_Travel_Expenses',
|
|
10
|
'Questionnaire 7 -La Politique de Déplacements Professionnels',
|
|
11
|
'Étude des pratiques de gestion des déplacements professionnels',
|
|
12
|
'Étude des pratiques de gestion des déplacements professionnels',
|
|
13
|
2),
|
|
14
|
('quiz_7_Travel_Expenses',
|
|
15
|
'Quiz 7 - Professional Travel Policy Survey',
|
|
16
|
'Survey of professional travel management practices',
|
|
17
|
'Survey of professional travel management practices',
|
|
18
|
1);
|
|
19
|
-- 3) Create section
|
|
20
|
INSERT INTO solution_quiz_section (sectionCode, quizCode, section_order)
|
|
21
|
VALUES
|
|
22
|
('Travel_Expenses', 'quiz_7_Travel_Expenses', 1);
|
|
23
|
-- 4) Section translations
|
|
24
|
INSERT INTO solution_quiz_section_translate (sectionCode, title, languageId)
|
|
25
|
VALUES
|
|
26
|
('Travel_Expenses', 'Professional Travel Management', 1),
|
|
27
|
('Travel_Expenses', 'Gestion des Déplacements Professionnels', 2);
|
|
28
|
-- Questions
|
|
29
|
INSERT INTO solution_quiz_section_questions
|
|
30
|
(questionCode, sectionCode, quizCode, idparent, type, question_order, echartType)
|
|
31
|
VALUES
|
|
32
|
-- Main questions
|
|
33
|
('Q7-TE-1', 'Travel_Expenses', 'quiz_7_Travel_Expenses', NULL, 'CU', 1, 'Pie'),
|
|
34
|
('Q7-TE-2', 'Travel_Expenses', 'quiz_7_Travel_Expenses', 'Q7-TE-1', 'CM', 2, 'Pie'),
|
|
35
|
('Q7-TE-3', 'Travel_Expenses', 'quiz_7_Travel_Expenses', 'Q7-TE-2', 'CM_all', 3, 'Table'),
|
|
36
|
('Q7-TE-4', 'Travel_Expenses', 'quiz_7_Travel_Expenses', 'Q7-TE-2', 'CM_all', 4, 'Table'),
|
|
37
|
('Q7-TE-5', 'Travel_Expenses', 'quiz_7_Travel_Expenses', 'Q7-TE-2', 'CM_all', 5, 'Table'),
|
|
38
|
('Q7-TE-6', 'Travel_Expenses', 'quiz_7_Travel_Expenses', NULL, 'CU', 6, 'Pie'),
|
|
39
|
('Q7-TE-7', 'Travel_Expenses', 'quiz_7_Travel_Expenses', 'Q7-TE-6', 'CU', 7, 'Pie'),
|
|
40
|
('Q7-TE-8', 'Travel_Expenses', 'quiz_7_Travel_Expenses', 'Q7-TE-6', 'CM', 8, 'Table'),
|
|
41
|
('Q7-TE-9', 'Travel_Expenses', 'quiz_7_Travel_Expenses', 'Q7-TE-6', 'CM', 9, 'Pie'),
|
|
42
|
('Q7-TE-10', 'Travel_Expenses', 'quiz_7_Travel_Expenses', 'Q7-TE-9', 'CU', 10, 'Pie'),
|
|
43
|
('Q7-TE-11', 'Travel_Expenses', 'quiz_7_Travel_Expenses', 'Q7-TE-9', 'CU', 11, 'Pie'),
|
|
44
|
('Q7-TE-12', 'Travel_Expenses', 'quiz_7_Travel_Expenses', NULL, 'CU', 12, 'Bar'),
|
|
45
|
('Q7-TE-13', 'Travel_Expenses', 'quiz_7_Travel_Expenses', 'Q7-TE-12', 'CU', 13, 'Pie'),
|
|
46
|
('Q7-TE-14', 'Travel_Expenses', 'quiz_7_Travel_Expenses', NULL, 'CU', 14, 'Bar'),
|
|
47
|
('Q7-TE-15', 'Travel_Expenses', 'quiz_7_Travel_Expenses', 'Q7-TE-14', 'CU', 15, 'Pie');
|
|
48
|
-- Question translations
|
|
49
|
INSERT INTO solution_quiz_section_questions_translate (questionCode, title, languageId)
|
|
50
|
VALUES
|
|
51
|
('Q7-TE-1', 'Votre entreprise a-t-elle une politique formelle pour les déplacements professionnels ?', 2),
|
|
52
|
('Q7-TE-1', 'Does your company have a formal policy for professional travel?', 1),
|
|
53
|
|
|
54
|
('Q7-TE-2', 'Quels types de déplacements professionnels sont courants dans votre entreprise ?', 2),
|
|
55
|
('Q7-TE-2', 'What types of professional travel are common in your company?', 1),
|
|
56
|
|
|
57
|
('Q7-TE-3', 'Quelles catégories de personnel éligibles aux déplacements professionnels locaux ?', 2),
|
|
58
|
('Q7-TE-3', 'Which staff categories are eligible for local professional travel?', 1),
|
|
59
|
|
|
60
|
('Q7-TE-4', 'Quelles catégories de personnel éligibles aux déplacements professionnels nationaux ?', 2),
|
|
61
|
('Q7-TE-4', 'Which staff categories are eligible for national professional travel?', 1),
|
|
62
|
|
|
63
|
('Q7-TE-5', 'Quelles catégories de personnel éligibles aux déplacements professionnels internationaux?', 2),
|
|
64
|
('Q7-TE-5', 'Which staff categories are eligible for international professional travel?', 1),
|
|
65
|
|
|
66
|
('Q7-TE-6', 'Existe-t-il une politique de remboursement des frais de déplacement professionnels ?', 2),
|
|
67
|
('Q7-TE-6', 'Is there a policy for reimbursing professional travel expenses?', 1),
|
|
68
|
|
|
69
|
('Q7-TE-7', 'Quelle est la base de remboursement des déplacements professionnels ?', 2),
|
|
70
|
('Q7-TE-7', 'What is the basis for reimbursing professional travel?', 1),
|
|
71
|
|
|
72
|
('Q7-TE-8', 'Quels sont les taux journaliers prévalents pour les déplacements professionnels dans chaque région ?', 2),
|
|
73
|
('Q7-TE-8', 'What are the prevailing daily rates for professional travel in each region?', 1),
|
|
74
|
|
|
75
|
('Q7-TE-9', 'Quels frais sont couverts lors des déplacements professionnels ?', 2),
|
|
76
|
('Q7-TE-9', 'What expenses are covered during professional travel?', 1),
|
|
77
|
|
|
78
|
('Q7-TE-10', 'Les frais d''hébergement lors des déplacements professionnels sont-ils couverts ?', 2),
|
|
79
|
('Q7-TE-10', 'Are accommodation expenses covered during professional travel?', 1),
|
|
80
|
|
|
81
|
('Q7-TE-11', 'Les frais de repas lors des déplacements professionnels sont-ils couverts ?', 2),
|
|
82
|
('Q7-TE-11', 'Are meal expenses covered during professional travel?', 1),
|
|
83
|
|
|
84
|
('Q7-TE-12', 'Des accords particuliers sont-ils mis en place avec des compagnies de transport pour les déplacements professionnels ?', 2),
|
|
85
|
('Q7-TE-12', 'Are special agreements in place with transport companies for professional travel?', 1),
|
|
86
|
|
|
87
|
('Q7-TE-13', 'Quels avantages ces accords offrent-ils?', 2),
|
|
88
|
('Q7-TE-13', 'What benefits do these agreements offer?', 1),
|
|
89
|
|
|
90
|
('Q7-TE-14', 'Des accords particuliers sont-ils mis en place avec des hôtels pour les déplacements professionnels ?', 2),
|
|
91
|
('Q7-TE-14', 'Are special agreements in place with hotels for professional travel?', 1),
|
|
92
|
|
|
93
|
('Q7-TE-15', 'Quels avantages ces accords offrent-ils?', 2),
|
|
94
|
('Q7-TE-15', 'What benefits do these agreements offer?', 1);
|
|
95
|
-- Insert response items
|
|
96
|
INSERT INTO solution_reponses_items (itemCode, itemName)
|
|
97
|
VALUES
|
|
98
|
('local_travel', 'Local travel'),
|
|
99
|
('national_travel', 'National travel'),
|
|
100
|
('international_travel', 'International travel'),
|
|
101
|
('yes_with_limit', 'Yes with a defined limit'),
|
|
102
|
('yes_without_limit', 'Yes without a defined limit'),
|
|
103
|
('conditional', 'Under conditions (specify)'),
|
|
104
|
('expense_receipts', 'Expense receipts only'),
|
|
105
|
('daily_allowance', 'Daily allowance only'),
|
|
106
|
('both_expense_allowance', 'Both expense receipts and daily allowance'),
|
|
107
|
('local', 'Local'),
|
|
108
|
('national', 'National'),
|
|
109
|
('africa', 'Africa'),
|
|
110
|
('asia_pacific', 'Asia-Pacific'),
|
|
111
|
('europe', 'Europe'),
|
|
112
|
('latin_america', 'Latin America'),
|
|
113
|
('middle_east', 'Middle East'),
|
|
114
|
('north_america', 'North America'),
|
|
115
|
('southeast_asia', 'Southeast Asia'),
|
|
116
|
('transport', 'Transport (plane, train, car)'),
|
|
117
|
('accommodation', 'Accommodation'),
|
|
118
|
('meals', 'Meals'),
|
|
119
|
('communications', 'Communications (phone, internet)'),
|
|
120
|
('other_expenses', 'Other expenses (specify)'),
|
|
121
|
('fully', 'Fully'),
|
|
122
|
('partially', 'Partially'),
|
|
123
|
('air_transport', 'Yes, for air transport'),
|
|
124
|
('rail_transport', 'Yes, for rail transport'),
|
|
125
|
('car_rental', 'Yes, for car rental services'),
|
|
126
|
('other_transport', 'Yes, for other transport modes (specify)'),
|
|
127
|
('preferred_rates', 'Preferred rates'),
|
|
128
|
('flexible_conditions', 'Flexible modification or cancellation conditions'),
|
|
129
|
('premium_services', 'Premium services'),
|
|
130
|
('national_hotels', 'Yes, for national hotels'),
|
|
131
|
('international_hotels', 'Yes, for international hotels'),
|
|
132
|
('specific_chains', 'Yes, for specific hotel chains'),
|
|
133
|
('reduced_rates', 'Reduced rates'),
|
|
134
|
('room_upgrades', 'Room upgrades'),
|
|
135
|
('free_cancellations', 'Free cancellations'),
|
|
136
|
('loyalty_programs', 'Specific loyalty programs'),
|
|
137
|
('professional_support', 'Professional Support');
|
|
138
|
-- Add translations for all items
|
|
139
|
INSERT INTO solution_quiz_question_items_translate (itemCode, itemValue, languageId)
|
|
140
|
VALUES
|
|
141
|
|
|
142
|
('local_travel', 'Déplacements locaux', 2),
|
|
143
|
('local_travel', 'Local travel', 1),
|
|
144
|
('national_travel', 'Déplacements nationaux', 2),
|
|
145
|
('national_travel', 'National travel', 1),
|
|
146
|
('international_travel', 'Déplacements internationaux', 2),
|
|
147
|
('international_travel', 'International travel', 1),
|
|
148
|
('yes_with_limit', 'Oui avec un plafond défini', 2),
|
|
149
|
('yes_with_limit', 'Yes with a defined limit', 1),
|
|
150
|
('yes_without_limit', 'Oui sans un plafond défini', 2),
|
|
151
|
('yes_without_limit', 'Yes without a defined limit', 1),
|
|
152
|
('conditional', 'Sous conditions (précisez)', 2),
|
|
153
|
('conditional', 'Under conditions (specify)', 1),
|
|
154
|
|
|
155
|
('expense_receipts', 'Notes de frais et reçus uniquement', 2),
|
|
156
|
('expense_receipts', 'Expense receipts only', 1),
|
|
157
|
('daily_allowance', 'Indemnité journalière uniquement', 2),
|
|
158
|
('daily_allowance', 'Daily allowance only', 1),
|
|
159
|
('both_expense_allowance', 'Les notes de frais/reçus et l''indemnité journalière', 2),
|
|
160
|
('both_expense_allowance', 'Both expense receipts and daily allowance', 1),
|
|
161
|
|
|
162
|
('local', 'Local', 2),
|
|
163
|
('local', 'Local', 1),
|
|
164
|
('national', 'National', 2),
|
|
165
|
('national', 'National', 1),
|
|
166
|
('africa', 'Afrique', 2),
|
|
167
|
('africa', 'Africa', 1),
|
|
168
|
('asia_pacific', 'Asie-Pacifique', 2),
|
|
169
|
('asia_pacific', 'Asia-Pacific', 1),
|
|
170
|
('europe', 'Europe', 2),
|
|
171
|
('europe', 'Europe', 1),
|
|
172
|
('latin_america', 'Amérique latine', 2),
|
|
173
|
('latin_america', 'Latin America', 1),
|
|
174
|
('middle_east', 'Moyen-Orient', 2),
|
|
175
|
('middle_east', 'Middle East', 1),
|
|
176
|
('north_america', 'Amérique du Nord', 2),
|
|
177
|
('north_america', 'North America', 1),
|
|
178
|
('southeast_asia', 'Asie du Sud-Est', 2),
|
|
179
|
('southeast_asia', 'Southeast Asia', 1),
|
|
180
|
|
|
181
|
('transport', 'Transport (avion, train, voiture)', 2),
|
|
182
|
('transport', 'Transport (plane, train, car)', 1),
|
|
183
|
('accommodation', 'Hébergement', 2),
|
|
184
|
('accommodation', 'Accommodation', 1),
|
|
185
|
('meals', 'Repas', 2),
|
|
186
|
('meals', 'Meals', 1),
|
|
187
|
('communications', 'Communications (téléphone, internet)', 2),
|
|
188
|
('communications', 'Communications (phone, internet)', 1),
|
|
189
|
('other_expenses', 'Autres frais (précisez)', 2),
|
|
190
|
('other_expenses', 'Other expenses (specify)', 1),
|
|
191
|
|
|
192
|
('fully', 'Entièrement', 2),
|
|
193
|
('fully', 'Fully', 1),
|
|
194
|
('partially', 'Partiellement', 2),
|
|
195
|
('partially', 'Partially', 1),
|
|
196
|
|
|
197
|
('air_transport', 'Oui, pour le transport aérien', 2),
|
|
198
|
('air_transport', 'Yes, for air transport', 1),
|
|
199
|
('rail_transport', 'Oui, pour le transport ferroviaire', 2),
|
|
200
|
('rail_transport', 'Yes, for rail transport', 1),
|
|
201
|
('car_rental', 'Oui, pour les services de location de véhicules', 2),
|
|
202
|
('car_rental', 'Yes, for car rental services', 1),
|
|
203
|
('other_transport', 'Oui, pour d''autres modes de transport (précisez)', 2),
|
|
204
|
('other_transport', 'Yes, for other transport modes (specify)', 1),
|
|
205
|
|
|
206
|
('preferred_rates', 'Tarifs préférentiels', 2),
|
|
207
|
('preferred_rates', 'Preferred rates', 1),
|
|
208
|
('flexible_conditions', 'Conditions flexibles de modification ou d''annulation', 2),
|
|
209
|
('flexible_conditions', 'Flexible modification or cancellation conditions', 1),
|
|
210
|
('premium_services', 'Services premium', 2),
|
|
211
|
('premium_services', 'Premium services', 1),
|
|
212
|
|
|
213
|
('national_hotels', 'Oui, pour des hôtels nationaux', 2),
|
|
214
|
('national_hotels', 'Yes, for national hotels', 1),
|
|
215
|
('international_hotels', 'Oui, pour des hôtels internationaux', 2),
|
|
216
|
('international_hotels', 'Yes, for international hotels', 1),
|
|
217
|
('specific_chains', 'Oui, pour des chaînes hôtelières spécifiques', 2),
|
|
218
|
('specific_chains', 'Yes, for specific hotel chains', 1),
|
|
219
|
|
|
220
|
('reduced_rates', 'Tarifs réduits', 2),
|
|
221
|
('reduced_rates', 'Reduced rates', 1),
|
|
222
|
('room_upgrades', 'Surclassements', 2),
|
|
223
|
('room_upgrades', 'Room upgrades', 1),
|
|
224
|
('free_cancellations', 'Annulations gratuites', 2),
|
|
225
|
('free_cancellations', 'Free cancellations', 1),
|
|
226
|
('loyalty_programs', 'Programmes de fidélité spécifiques', 2),
|
|
227
|
('loyalty_programs', 'Specific loyalty programs', 1),
|
|
228
|
('professional_support', 'Support Professionnel', 2),
|
|
229
|
('professional_support', 'Professional Support', 1);
|
|
230
|
|
|
231
|
-- Link items to questions
|
|
232
|
INSERT INTO solution_quiz_section_questions_items (itemCode, questionCode, itemParentId, isOther)
|
|
233
|
VALUES
|
|
234
|
-- Q7-TE-1 (Travel policy)
|
|
235
|
('yes', 'Q7-TE-1', NULL, 0),
|
|
236
|
('no', 'Q7-TE-1', NULL, 0),
|
|
237
|
|
|
238
|
-- Q7-TE-2 (Travel types)
|
|
239
|
('local_travel', 'Q7-TE-2', 'yes', 0),
|
|
240
|
('national_travel', 'Q7-TE-2', 'yes', 0),
|
|
241
|
('international_travel', 'Q7-TE-2', 'yes', 0),
|
|
242
|
|
|
243
|
-- Q7-TE-3 (Local travel staff)
|
|
244
|
('executives', 'Q7-TE-3', 'local_travel', 0),
|
|
245
|
('middle_managers', 'Q7-TE-3', 'local_travel', 0),
|
|
246
|
('managers', 'Q7-TE-3', 'local_travel', 0),
|
|
247
|
('sales', 'Q7-TE-3', 'local_travel', 0),
|
|
248
|
('professionals', 'Q7-TE-3', 'local_travel', 0),
|
|
249
|
('technical-staff', 'Q7-TE-3', 'local_travel', 0),
|
|
250
|
('professional_support', 'Q7-TE-3', 'local_travel', 0),
|
|
251
|
('labor', 'Q7-TE-3', 'local_travel', 0),
|
|
252
|
|
|
253
|
-- Q7-TE-4 (National travel staff)
|
|
254
|
('executives', 'Q7-TE-4', 'national_travel', 0),
|
|
255
|
('middle_managers', 'Q7-TE-4', 'national_travel', 0),
|
|
256
|
('managers', 'Q7-TE-4', 'national_travel', 0),
|
|
257
|
('sales', 'Q7-TE-4', 'national_travel', 0),
|
|
258
|
('professionals', 'Q7-TE-4', 'national_travel', 0),
|
|
259
|
('technical-staff', 'Q7-TE-4', 'national_travel', 0),
|
|
260
|
('professional_support', 'Q7-TE-4', 'national_travel', 0),
|
|
261
|
('labor', 'Q7-TE-4', 'national_travel', 0),
|
|
262
|
|
|
263
|
-- Q7-TE-5 (International travel staff)
|
|
264
|
('executives', 'Q7-TE-5', 'international_travel', 0),
|
|
265
|
('middle_managers', 'Q7-TE-5', 'international_travel', 0),
|
|
266
|
('managers', 'Q7-TE-5', 'international_travel', 0),
|
|
267
|
('sales', 'Q7-TE-5', 'international_travel', 0),
|
|
268
|
('professionals', 'Q7-TE-5', 'international_travel', 0),
|
|
269
|
('technical-staff', 'Q7-TE-5', 'international_travel', 0),
|
|
270
|
('professional_support', 'Q7-TE-5', 'international_travel', 0),
|
|
271
|
('labor', 'Q7-TE-5', 'international_travel', 0),
|
|
272
|
|
|
273
|
-- Q7-TE-6 (Reimbursement policy)
|
|
274
|
('yes_with_limit', 'Q7-TE-6', NULL, 0),
|
|
275
|
('yes_without_limit', 'Q7-TE-6', NULL, 0),
|
|
276
|
('conditional', 'Q7-TE-6', NULL, 1),
|
|
277
|
('no', 'Q7-TE-6', NULL, 0),
|
|
278
|
|
|
279
|
-- Q7-TE-7 (Reimbursement basis)
|
|
280
|
('expense_receipts', 'Q7-TE-7', 'yes_with_limit', 0),
|
|
281
|
('daily_allowance', 'Q7-TE-7', 'yes_with_limit', 0),
|
|
282
|
('both_expense_allowance', 'Q7-TE-7', 'yes_with_limit', 0),
|
|
283
|
|
|
284
|
-- Q7-TE-8 (Daily rates by region)
|
|
285
|
('local', 'Q7-TE-8', 'yes_with_limit', 1),
|
|
286
|
('national', 'Q7-TE-8', 'yes_with_limit', 1),
|
|
287
|
('africa', 'Q7-TE-8', 'yes_with_limit', 1),
|
|
288
|
('asia_pacific', 'Q7-TE-8', 'yes_with_limit', 1),
|
|
289
|
('europe', 'Q7-TE-8', 'yes_with_limit', 1),
|
|
290
|
('latin_america', 'Q7-TE-8', 'yes_with_limit', 1),
|
|
291
|
('middle_east', 'Q7-TE-8', 'yes_with_limit', 1),
|
|
292
|
('north_america', 'Q7-TE-8', 'yes_with_limit', 1),
|
|
293
|
('southeast_asia', 'Q7-TE-8', 'yes_with_limit', 1),
|
|
294
|
|
|
295
|
-- Q7-TE-9 (Covered expenses)
|
|
296
|
('transport', 'Q7-TE-9', 'yes_with_limit', 0),
|
|
297
|
('accommodation', 'Q7-TE-9', 'yes_with_limit', 0),
|
|
298
|
('meals', 'Q7-TE-9', 'yes_with_limit', 0),
|
|
299
|
('communications', 'Q7-TE-9', 'yes_with_limit', 0),
|
|
300
|
('other_expenses', 'Q7-TE-9', 'yes_with_limit', 1),
|
|
301
|
|
|
302
|
-- Q7-TE-10 (Accommodation coverage)
|
|
303
|
('fully', 'Q7-TE-10', 'accommodation', 0),
|
|
304
|
('partially', 'Q7-TE-10', 'accommodation', 0),
|
|
305
|
|
|
306
|
-- Q7-TE-11 (Meal coverage)
|
|
307
|
('fully', 'Q7-TE-11', 'meals', 0),
|
|
308
|
('partially', 'Q7-TE-11', 'meals', 0),
|
|
309
|
|
|
310
|
-- Q7-TE-12 (Transport agreements)
|
|
311
|
('air_transport', 'Q7-TE-12', NULL, 0),
|
|
312
|
('rail_transport', 'Q7-TE-12', NULL, 0),
|
|
313
|
('car_rental', 'Q7-TE-12', NULL, 0),
|
|
314
|
('other_transport', 'Q7-TE-12', NULL, 1),
|
|
315
|
('no', 'Q7-TE-12', NULL, 0),
|
|
316
|
|
|
317
|
-- Q7-TE-13 (Transport benefits)
|
|
318
|
('preferred_rates', 'Q7-TE-13', 'air_transport', 0),
|
|
319
|
('flexible_conditions', 'Q7-TE-13', 'air_transport', 0),
|
|
320
|
('premium_services', 'Q7-TE-13', 'air_transport', 0),
|
|
321
|
|
|
322
|
('preferred_rates', 'Q7-TE-13', 'rail_transport', 0),
|
|
323
|
('flexible_conditions', 'Q7-TE-13', 'rail_transport', 0),
|
|
324
|
('premium_services', 'Q7-TE-13', 'rail_transport', 0),
|
|
325
|
|
|
326
|
('preferred_rates', 'Q7-TE-13', 'car_rental', 0),
|
|
327
|
('flexible_conditions', 'Q7-TE-13', 'car_rental', 0),
|
|
328
|
('premium_services', 'Q7-TE-13', 'car_rental', 0),
|
|
329
|
|
|
330
|
('preferred_rates', 'Q7-TE-13', 'other_transport', 0),
|
|
331
|
('flexible_conditions', 'Q7-TE-13', 'other_transport', 0),
|
|
332
|
('premium_services', 'Q7-TE-13', 'other_transport', 0),
|
|
333
|
|
|
334
|
-- Q7-TE-14 (Hotel agreements)
|
|
335
|
('national_hotels', 'Q7-TE-14', NULL, 0),
|
|
336
|
('international_hotels', 'Q7-TE-14', NULL, 0),
|
|
337
|
('specific_chains', 'Q7-TE-14', NULL, 0),
|
|
338
|
('no', 'Q7-TE-14', NULL, 0),
|
|
339
|
|
|
340
|
-- Q7-TE-15 (Hotel benefits)
|
|
341
|
('reduced_rates', 'Q7-TE-15', 'national_hotels', 0),
|
|
342
|
('room_upgrades', 'Q7-TE-15', 'national_hotels', 0),
|
|
343
|
('free_cancellations', 'Q7-TE-15', 'national_hotels', 0),
|
|
344
|
('loyalty_programs', 'Q7-TE-15', 'national_hotels', 0),
|
|
345
|
|
|
346
|
('reduced_rates', 'Q7-TE-15', 'international_hotels', 0),
|
|
347
|
('room_upgrades', 'Q7-TE-15', 'international_hotels', 0),
|
|
348
|
('free_cancellations', 'Q7-TE-15', 'international_hotels', 0),
|
|
349
|
('loyalty_programs', 'Q7-TE-15', 'international_hotels', 0),
|
|
350
|
|
|
351
|
('reduced_rates', 'Q7-TE-15', 'specific_chains', 0),
|
|
352
|
('room_upgrades', 'Q7-TE-15', 'specific_chains', 0),
|
|
353
|
('free_cancellations', 'Q7-TE-15', 'specific_chains', 0),
|
|
354
|
('loyalty_programs', 'Q7-TE-15', 'specific_chains', 0);
|