use  socle;

--  Insert into solution_quiz for Quiz 3 Attraction, Rétention et fin de contrat
INSERT INTO solution_quiz (id, quizCode, quiz_image, averagetime)
VALUES
  (3, 'quiz_3_Attraction_Retention_and_Termination',
   'Questionnaire 3 -Attraction, Rétention et fin de contrat.jpg',
   15);

-- Insert into solution_quiz_translate for Quiz 3 (French & English)
INSERT INTO solution_quiz_translate (quizCode, title, description, short_description, languageId)
VALUES
  ('quiz_3_Attraction_Retention_and_Termination',
   'Questionnaire 3 -Attraction, Rétention et fin de contrat',
   'Évaluation des stratégies d\'attraction et de rétention des talents, ainsi que des processus de fin de contrat',
   'Évaluation des stratégies d\'attraction, rétention et fin de contrat', 2),
  ('quiz_3_Attraction_Retention_and_Termination',
   'Quiz 3 - Talent Attraction, Retention & Offboarding',
   'Assessment of talent attraction and retention strategies, and employee offboarding processes',
   'Assessment of attraction, retention & offboarding strategies', 1);

-- Insert into solution_quiz_section for Quiz 3
INSERT INTO solution_quiz_section (sectionCode, quizCode, section_order)
VALUES
  ('Talent_Attraction_Strategies','quiz_3_Attraction_Retention_and_Termination', 1),
  ('Talent_Retention_Strategies','quiz_3_Attraction_Retention_and_Termination', 2),
  ('Employment_Termination_Process', 'quiz_3_Attraction_Retention_and_Termination', 3);

--  Insert translations for those sections
INSERT INTO solution_quiz_section_translate (sectionCode, title, languageId)
VALUES
  -- English
  ('Talent_Attraction_Strategies', 'Talent Attraction Strategies', 1),
  ('Talent_Retention_Strategies', 'Talent Retention Strategies', 1),
  ('Employment_Termination_Process', 'Employment Termination Process', 1),
  -- French
  ('Talent_Attraction_Strategies', 'Stratégies d\'Attraction des Talents', 2),
  ('Talent_Retention_Strategies',  'Stratégies de Rétention des Talents', 2),
  ('Employment_Termination_Process','Cessation d\'Emploi', 2);

-- Insert questions for each section
INSERT INTO solution_quiz_section_questions
  (quizCode, questionCode, sectionCode, idparent, type, question_order, echartType)
VALUES
  -- Section 1: Talent_Attraction_Strategies (Q3-ATS-1 → Q3-ATS-4)
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-ATS-1', 'Talent_Attraction_Strategies', NULL, 'CM', 1, 'Bar'),
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-ATS-2', 'Talent_Attraction_Strategies', NULL, 'CM', 2, 'Bar'),
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-ATS-3', 'Talent_Attraction_Strategies', NULL, 'CM', 3, 'Bar'),
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-ATS-4', 'Talent_Attraction_Strategies', NULL, 'CM', 4, 'Bar'),

  -- Section 2: Talent_Retention_Strategies (Q3-RTS-5 → Q3-RTS-9)
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-RTS-5', 'Talent_Retention_Strategies', NULL,      'CM', 5, 'Bar'),
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-RTS-6', 'Talent_Retention_Strategies', NULL,      'CM', 6, 'Bar'),
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-RTS-7', 'Talent_Retention_Strategies', NULL,      'CU', 7, 'Pie'),
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-RTS-8', 'Talent_Retention_Strategies', 'Q3-RTS-7', 'CU', 8, 'Bar'),
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-RTS-9', 'Talent_Retention_Strategies', NULL,      'CM', 9, 'Bar'),

  -- Section 3: Employment_Termination_Process (Q3-ET-10 → Q3-ET-14)
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-ET-10', 'Employment_Termination_Process', NULL,      'CM', 10, 'Bar'),
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-ET-11', 'Employment_Termination_Process', NULL,      'CU', 11, 'Pie'),
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-ET-12', 'Employment_Termination_Process', 'Q3-ET-11', 'CM', 12, 'Bar'),
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-ET-13', 'Employment_Termination_Process', NULL,      'CM', 13, 'Bar'),
  ('quiz_3_Attraction_Retention_and_Termination', 'Q3-ET-14', 'Employment_Termination_Process', NULL,      'CU', 14, 'Pie');


--  Insert translations for all questions (English & French)
INSERT INTO solution_quiz_section_questions_translate (questionCode, title, languageId)
VALUES
  -- English
  ('Q3-ATS-1', 'Which recruitment channels do you use to attract new talent?',1),
  ('Q3-ATS-2', 'Which aspects of your company are most attractive to potential hires?', 1),
  ('Q3-ATS-3', 'What initiatives do you implement to onboard new employees?',1),
  ('Q3-ATS-4', 'How do you enhance your employer brand?', 1),

  ('Q3-RTS-5', 'What factors drive employee satisfaction and engagement?', 1),
  ('Q3-RTS-6', 'Which programs have you implemented to retain key talent?',1),
  ('Q3-RTS-7', 'Do you conduct employee satisfaction and engagement surveys?', 1),
  ('Q3-RTS-8', 'How often do you run these surveys?',1),
  ('Q3-RTS-9', 'How are outstanding employee performances recognized and rewarded?', 1),

  ('Q3-ET-10','What are the most common reasons employees leave your company?',1),
  ('Q3-ET-11','Do you conduct exit interviews to understand departure reasons?',1),
  ('Q3-ET-12','How do you use the insights gathered from exit interviews?', 1),
  ('Q3-ET-13','What measures have you implemented to prevent voluntary turnover?', 1),
  ('Q3-ET-14','Do you have a succession plan for key-role departures?', 1),

  -- French
  ('Q3-ATS-1', 'Quels canaux de recrutement utilisez-vous pour attirer de nouveaux talents ?', 2),
  ('Q3-ATS-2', 'Quels éléments de votre entreprise sont les plus attractifs pour les candidats potentiels ?', 2),
  ('Q3-ATS-3', 'Quelles initiatives mettez-vous en place pour faciliter l’intégration des nouveaux employés ?', 2),
  ('Q3-ATS-4', 'Comment travaillez-vous à améliorer la marque employeur de votre entreprise ?', 2),

  ('Q3-RTS-5', 'Quels sont les principaux éléments qui contribuent à la satisfaction et à l’engagement des employés ?', 2),
  ('Q3-RTS-6', 'Quels programmes spécifiques avez-vous mis en place pour retenir vos talents clés ?', 2),
  ('Q3-RTS-7', 'Réalisez-vous des enquêtes de satisfaction et d’engagement des employés ?', 2),
  ('Q3-RTS-8', 'À quelle fréquence réalisez-vous ces enquêtes ?', 2),
  ('Q3-RTS-9', 'Comment les performances exceptionnelles des employés sont-elles reconnues et récompensées ?', 2),

  ('Q3-ET-10','Quels sont les motifs les plus courants pour lesquels les employés quittent votre entreprise ?', 2),
  ('Q3-ET-11','Menez-vous des entretiens de départ pour comprendre les raisons du départ des employés ?', 2),
  ('Q3-ET-12','Comment utilisez-vous les informations recueillies lors des entretiens de départ ?', 2),
  ('Q3-ET-13','Quelles mesures avez-vous mises en place pour prévenir les départs volontaires ?', 2),
  ('Q3-ET-14','Avez-vous un plan de succession en place pour assurer la continuité des activités en cas de départ d’un employé clé ?', 2);

--   all item codes & names 
INSERT INTO solution_reponses_items (itemCode, itemName)
VALUES
  -- Q3-ATS-1
  ('online_job_sites',          'Online job sites (Indeed, Monster, etc.)'),
  ('internal_referrals',        'Internal referrals'),
  ('external_agencies',         'External recruitment agencies'),
  ('job_fairs',                 'Job fairs & recruiting events'),
  ('university_partnerships',   'University / school partnerships'),
  ('other_attraction',          'Other (please specify)'),

  -- Q3-ATS-2
  ('company_culture',           'Company culture (values, mission)'),
  ('career_opportunities',      'Career development opportunities'),
  ('competitive_compensation',  'Competitive pay & benefits'),
  ('work_flexibility',          'Work flexibility (remote, hours)'),
  ('brand_reputation',          'Employer brand & reputation'),
  ('innovation_tech',           'Innovation & technology used'),
  ('other_attractive',          'Other (please specify)'),

  -- Q3-ATS-3
  ('formal_onboarding',         'Formal onboarding programs'),
  ('mentoring_program',         'Mentoring / buddy programs'),
  ('initial_training',          'Initial training sessions'),
  ('welcome_meetings',          'Welcome meetings with leadership'),
  ('other_onboarding',          'Other (please specify)'),

  -- Q3-ATS-4
  ('employer_rankings',         'Participation in employer rankings'),
  ('internal_ambassadors',      'Internal ambassador programs'),
  ('social_media_campaigns',    'Social media employer campaigns'),
  ('employee_testimonials',     'Employee testimonials'),
  ('other_employer_brand',      'Other (please specify)'),

  -- Q3-RTS-5
  ('recognition_rewards',       'Recognition & rewards'),
  ('career_development',        'Career development paths'),
  ('positive_culture',          'Positive work culture'),
  ('benefits',                  'Employee benefits'),
  ('work_life_balance',         'Work-life balance'),
  ('leadership_quality',        'Leadership & management quality'),
  ('other_retention',           'Other (please specify)'),

  -- Q3-RTS-6
  ('personalized_plans',        'Personalized career plans'),
  ('performance_increases',     'Performance-based salary increases'),
  ('stock_options',             'Stock option / equity plans'),
  ('mentorship_programs',       'Mentorship & development programs'),
  ('wellness_programs',         'Wellness & well-being programs'),
  ('flexible_benefits',         'Flexible benefits'),
  ('other_retention_programs',  'Other (please specify)'),

  -- Q3-RTS-8
  ('semi_annually',             'Semi-annually'),
  ('other_survey_frequency',    'Other (please specify)'),

  -- Q3-RTS-9
  ('monetary_rewards',          'Monetary rewards'),
  ('public_recognition',        'Public recognition'),
  ('training_opportunities',    'Training & development opportunities'),
  ('promotions_internal',       'Promotions & internal mobility'),
  ('other_rewards',             'Other (please specify)'),

  -- Q3-ET-10
  ('better_opportunity',        'Better opportunity elsewhere'),
  ('salary_dissatisfaction',    'Salary dissatisfaction'),
  ('career_stagnation',         'Lack of career progression'),
  ('internal_conflict',         'Internal conflicts'),
  ('burnout',                   'Burnout or stress'),
  ('worklife_search',           'Seeking better work-life balance'),
  ('other_exit_reasons',        'Other (please specify)'),

  -- Q3-ET-12
  ('adjust_hr_practices',       'To adjust HR practices'),
  ('review_talent_policies',    'To review talent policies'),
  ('improve_work_conditions',   'To improve working conditions'),
  ('inform_future_retention',   'To inform future retention strategies'),
  ('other_exit_interview',      'Other (please specify)'),

  -- Q3-ET-13
  ('preventive_measures',       'Preventive turnover measures'),
  ('improve_conditions',        'Improve working conditions'),
  ('wellness_initiatives',      'Wellness & well-being initiatives'),
  ('regular_hr_reviews',        'Regular HR policy reviews'),
  ('other_preventive',          'Other (please specify)'),

  -- Q3-ET-14
  ('succession_for_all',        'Yes, for all critical roles'),
  ('succession_selective',      'Yes, but only for select roles'),
  ('no_plan',                   'No formal succession plan'),
  
  ('social_networks','Social networks (LinkedIn, Facebook, etc.)');

--  Link items to questions
INSERT INTO solution_quiz_section_questions_items
  (itemCode, questionCode, itemParentId, isOther)
VALUES
  -- Q3-ATS-1
  ('social_networks', 'Q3-ATS-1', NULL, 0),
  ('online_job_sites','Q3-ATS-1', NULL, 0),
  ('internal_referrals', 'Q3-ATS-1', NULL, 0),
  ('external_agencies',  'Q3-ATS-1', NULL, 0),
  ('job_fairs', 'Q3-ATS-1', NULL, 0),
  ('university_partnerships', 'Q3-ATS-1', NULL, 0),
  ('other_attraction', 'Q3-ATS-1', NULL, 1),

  -- Q3-ATS-2
  ('company_culture',  'Q3-ATS-2', NULL, 0),
  ('career_opportunities', 'Q3-ATS-2', NULL, 0),
  ('competitive_compensation','Q3-ATS-2', NULL, 0),
  ('work_flexibility', 'Q3-ATS-2', NULL, 0),
  ('brand_reputation','Q3-ATS-2', NULL, 0),
  ('innovation_tech','Q3-ATS-2', NULL, 0),
  ('other_attractive', 'Q3-ATS-2', NULL, 1),

  -- Q3-ATS-3
  ('formal_onboarding','Q3-ATS-3', NULL, 0),
  ('mentoring_program','Q3-ATS-3', NULL, 0),
  ('initial_training','Q3-ATS-3', NULL, 0),
  ('welcome_meetings','Q3-ATS-3', NULL, 0),
  ('other_onboarding', 'Q3-ATS-3', NULL, 1),

  -- Q3-ATS-4
  ('employer_rankings','Q3-ATS-4', NULL, 0),
  ('internal_ambassadors','Q3-ATS-4', NULL, 0),
  ('social_media_campaigns', 'Q3-ATS-4', NULL, 0),
  ('employee_testimonials', 'Q3-ATS-4', NULL, 0),
  ('other_employer_brand', 'Q3-ATS-4', NULL, 1),

  -- Q3-RTS-5
  ('recognition_rewards', 'Q3-RTS-5', NULL, 0),
  ('career_development', 'Q3-RTS-5', NULL, 0),
  ('positive_culture',   'Q3-RTS-5', NULL, 0),
  ('benefits', 'Q3-RTS-5', NULL, 0),
  ('work_life_balance','Q3-RTS-5', NULL, 0),
  ('leadership_quality','Q3-RTS-5', NULL, 0),
  ('other_retention',  'Q3-RTS-5', NULL, 1),

  -- Q3-RTS-6
  ('personalized_plans','Q3-RTS-6', NULL, 0),
  ('performance_increases','Q3-RTS-6', NULL, 0),
  ('stock_options','Q3-RTS-6', NULL, 0),
  ('mentorship_programs','Q3-RTS-6', NULL, 0),
  ('wellness_programs','Q3-RTS-6', NULL, 0),
  ('flexible_benefits', 'Q3-RTS-6', NULL, 0),
  ('other_retention_programs','Q3-RTS-6', NULL, 1),

  -- Q3-RTS-7
  ('yes','Q3-RTS-7', NULL, 0),
  ('no','Q3-RTS-7', NULL, 0),

  -- Q3-RTS-8
  ('quarterly','Q3-RTS-8', NULL, 0),
  ('semi_annually','Q3-RTS-8', NULL, 0),
  ('annually','Q3-RTS-8', NULL, 0),
  ('other_survey_frequency', 'Q3-RTS-8', NULL, 1),

  -- Q3-RTS-9
  ('monetary_rewards','Q3-RTS-9', NULL, 0),
  ('public_recognition', 'Q3-RTS-9', NULL, 0),
  ('training_opportunities', 'Q3-RTS-9', NULL, 0),
  ('promotions_internal', 'Q3-RTS-9', NULL, 0),
  ('other_rewards','Q3-RTS-9', NULL, 1),

  -- Q3-ET-10
  ('better_opportunity', 'Q3-ET-10', NULL, 0),
  ('salary_dissatisfaction',  'Q3-ET-10', NULL, 0),
  ('career_stagnation','Q3-ET-10', NULL, 0),
  ('internal_conflict','Q3-ET-10', NULL, 0),
  ('burnout','Q3-ET-10', NULL, 0),
  ('worklife_search','Q3-ET-10', NULL, 0),
  ('other_exit_reasons',  'Q3-ET-10', NULL, 1),

  -- Q3-ET-11
  ('yes', 'Q3-ET-11', NULL, 0),
  ('no', 'Q3-ET-11', NULL, 0),

  -- Q3-ET-12
  ('adjust_hr_practices',  'Q3-ET-12', NULL, 0),
  ('review_talent_policies',  'Q3-ET-12', NULL, 0),
  ('improve_work_conditions', 'Q3-ET-12', NULL, 0),
  ('inform_future_retention', 'Q3-ET-12', NULL, 0),
  ('other_exit_interview',    'Q3-ET-12', NULL, 1),

  -- Q3-ET-13
  ('preventive_measures','Q3-ET-13', NULL, 0),
  ('improve_conditions', 'Q3-ET-13', NULL, 0),
  ('wellness_initiatives','Q3-ET-13', NULL, 0),
  ('regular_hr_reviews', 'Q3-ET-13', NULL, 0),
  ('other_preventive',  'Q3-ET-13', NULL, 1),

  -- Q3-ET-14
  ('succession_for_all', 'Q3-ET-14', NULL, 0),
  ('succession_selective',  'Q3-ET-14', NULL, 0),
  ('no_plan', 'Q3-ET-14', NULL, 0);

-- Insert translations for each item ( French)
INSERT INTO solution_quiz_question_items_translate (itemCode, itemValue, languageId)
VALUES
  -- Q3-ATS-1
  ('online_job_sites',   'Sites de recrutement en ligne (Indeed, Monster, etc.)', 2),
  ('internal_referrals', 'Recommandations internes',  2),
  ('external_agencies', 'Cabinets de recrutement externes',   2),
  ('job_fairs',  'Foires et événements de recrutement',  2),
  ('university_partnerships', 'Partenariats avec universités/écoles', 2),
  ('other_attraction',        'Autre (précisez)',  2),

  -- Q3-ATS-2
  ('company_culture', 'Culture d''entreprise (valeurs, mission)', 2),
  ('career_opportunities','Opportunités de développement de carrière', 2),
  ('competitive_compensation','Rémunération compétitive et avantages sociaux',2),
  ('work_flexibility', 'Flexibilité du travail (télétravail, horaires)', 2),
  ('brand_reputation', 'Réputation et image de marque',    2),
  ('innovation_tech','Innovation et technologies utilisées',  2),
  ('other_attractive', 'Autre (précisez)',  2),

  -- Q3-ATS-3
  ('formal_onboarding', 'Programmes d''intégration formels', 2),
  ('mentoring_program','Parrainage ou mentorat',  2),
  ('initial_training','Sessions de formation initiale', 2),
  ('welcome_meetings','Réunions d''accueil avec la direction', 2),
  ('other_onboarding','Autre (précisez)',    2),

  -- Q3-ATS-4
  ('employer_rankings', 'Participation à des classements d''employeurs',  2),
  ('internal_ambassadors',    'Programme d''ambassadeurs internes', 2),
  ('social_media_campaigns',  'Campagnes sur les réseaux sociaux', 2),
  ('employee_testimonials',   'Témoignages de salariés', 2),
  ('other_employer_brand',    'Autre (précisez)',  2),

  -- Q3-RTS-5
  ('recognition_rewards',  'Reconnaissance et récompenses', 2),
  ('career_development', 'Possibilités d''évolution de carrière',   2),
  ('positive_culture', 'Culture de travail positive', 2),
  ('benefits',   'Avantages sociaux', 2),
  ('work_life_balance','Équilibre travail-vie privée',2),
  ('leadership_quality', 'Leadership et gestion',   2),
  ('other_retention',  'Autre (précisez)',   2),

  -- Q3-RTS-6
  ('personalized_plans', 'Plans de carrière personnalisés', 2),
  ('performance_increases', 'Augmentations basées sur la performance', 2),
  ('stock_options',           'Plans d''actions ou participation', 2),
  ('mentorship_programs',   'Programmes de mentorat',  2),
  ('wellness_programs',  'Programmes de bien-être',  2),
  ('flexible_benefits', 'Avantages flexibles', 2),
  ('other_retention_programs','Autre (précisez)',  2),

  -- Q3-RTS-8
  ('quarterly', 'Trimestriellement',  2),
  ('semi_annually', 'Semestriellement',2),
  ('other_survey_frequency',  'Autre (précisez)',   2),

  -- Q3-RTS-9
  ('monetary_rewards',  'Récompenses monétaires',  2),
  ('public_recognition','Reconnaissance publique', 2),
  ('training_opportunities',  'Opportunités de formation',  2),
  ('promotions_internal',  'Promotions et mobilité interne', 2),
  ('other_rewards',  'Autre (précisez)',2),

  -- Q3-ET-10
  ('better_opportunity',  'Meilleure opportunité ailleurs',2),
  ('salary_dissatisfaction',  'Insatisfaction salariale',  2),
  ('career_stagnation', 'Manque de progression', 2),
  ('internal_conflict','Conflits internes',  2),
  ('burnout', 'Épuisement professionnel',2),
  ('worklife_search', 'Recherche d''équilibre travail-vie privée',  2),
  ('other_exit_reasons', 'Autre (précisez)',2),

  -- Q3-ET-12
  ('adjust_hr_practices', 'Pour ajuster les pratiques RH',2),
  ('review_talent_policies',  'Pour revoir les politiques de talents', 2),
  ('improve_work_conditions', 'Pour améliorer les conditions de travail',  2),
  ('inform_future_retention', 'Pour informer les stratégies futures',2),
  ('other_exit_interview', 'Autre (précisez)', 2),

  -- Q3-ET-13
  ('preventive_measures', 'Mesures préventives contre le turnover',  2),
  ('improve_conditions',  'Amélioration des conditions', 2),
  ('wellness_initiatives', 'Initiatives bien-être', 2),
  ('regular_hr_reviews', 'Revue régulière des politiques RH',  2),
  ('other_preventive','Autre (précisez)', 2),

  -- Q3-ET-14
  ('succession_for_all', 'Oui, pour tous les postes critiques',2),
  ('succession_selective', 'Oui, mais seulement pour certains postes', 2),
  ('no_plan','Non, pas de plan formel',2),
    ('social_networks', 'Réseaux sociaux (LinkedIn, Facebook, etc.)', 2);

  
  
  
  INSERT INTO solution_quiz_question_items_translate (itemCode, itemValue, languageId)
VALUES
  -- Q3-ATS-1
  ('online_job_sites',  'Online job sites (Indeed, Monster, etc.)',   1),
  ('internal_referrals', 'Internal referrals',    1),
  ('external_agencies', 'External recruitment agencies',  1),
  ('job_fairs',  'Job fairs & recruiting events',   1),
  ('university_partnerships', 'University / school partnerships',1),
  ('other_attraction','Other (please specify)',  1),

  -- Q3-ATS-2
  ('company_culture', 'Company culture (values, mission)', 1),
  ('career_opportunities', 'Career development opportunities', 1),
  ('competitive_compensation','Competitive pay & benefits', 1),
  ('work_flexibility','Work flexibility (remote, hours)',1),
  ('brand_reputation', 'Employer brand & reputation',1),
  ('innovation_tech',  'Innovation & technology used',1),
  ('other_attractive', 'Other (please specify)',    1),

  -- Q3-ATS-3
  ('formal_onboarding', 'Formal onboarding programs', 1),
  ('mentoring_program','Mentoring / buddy programs',   1),
  ('initial_training','Initial training sessions',  1),
  ('welcome_meetings', 'Welcome meetings with leadership',  1),
  ('other_onboarding', 'Other (please specify)', 1),

  -- Q3-ATS-4
  ('employer_rankings',   'Participation in employer rankings',  1),
  ('internal_ambassadors', 'Internal ambassador programs', 1),
  ('social_media_campaigns','Social media employer campaigns', 1),
  ('employee_testimonials','Employee testimonials', 1),
  ('other_employer_brand','Other (please specify)',1),

  -- Q3-RTS-5
  ('recognition_rewards','Recognition & rewards',1),
  ('career_development', 'Career development paths', 1),
  ('positive_culture', 'Positive work culture', 1),
  ('benefits', 'Employee benefits', 1),
  ('work_life_balance', 'Work–life balance',1),
  ('leadership_quality','Leadership & management quality',1),
  ('other_retention',  'Other (please specify)', 1),

  -- Q3-RTS-6
  ('personalized_plans', 'Personalized career plans',1),
  ('performance_increases', 'Performance-based salary increases', 1),
  ('stock_options', 'Stock option / equity plans',  1),
  ('mentorship_programs', 'Mentorship & development programs', 1),
  ('wellness_programs',  'Wellness & well-being programs', 1),
  ('flexible_benefits', 'Flexible benefits',   1),
  ('other_retention_programs','Other (please specify)', 1),

  -- Q3-RTS-8
  ('quarterly',  'Quarterly', 1),
  ('semi_annually','Semi-annually', 1),
  ('other_survey_frequency',  'Other (please specify)',1),

  -- Q3-RTS-9
  ('monetary_rewards','Monetary rewards', 1),
  ('public_recognition',  'Public recognition', 1),
  ('training_opportunities',  'Training & development opportunities',1),
  ('promotions_internal', 'Promotions & internal mobility',1),
  ('other_rewards','Other (please specify)',1),

  -- Q3-ET-10
  ('better_opportunity','Better opportunity elsewhere',1),
  ('salary_dissatisfaction',  'Salary dissatisfaction',1),
  ('career_stagnation',  'Lack of career progression',1),
  ('internal_conflict', 'Internal conflicts',1),
  ('burnout', 'Burnout or stress',  1),
  ('worklife_search', 'Seeking better work–life balance',1),
  ('other_exit_reasons', 'Other (please specify)', 1),

  -- Q3-ET-12
  ('adjust_hr_practices', 'To adjust HR practices', 1),
  ('review_talent_policies', 'To review talent policies', 1),
  ('improve_work_conditions', 'To improve working conditions',1),
  ('inform_future_retention', 'To inform future retention strategies', 1),
  ('other_exit_interview',    'Other (please specify)',  1),

  -- Q3-ET-13
  ('preventive_measures', 'Preventive turnover measures', 1),
  ('improve_conditions', 'Improve working conditions',  1),
  ('wellness_initiatives',  'Wellness & well-being initiatives', 1),
  ('regular_hr_reviews', 'Regular HR policy reviews', 1),
  ('other_preventive', 'Other (please specify)', 1),

  -- Q3-ET-14
  ('succession_for_all','Yes, for all critical roles', 1),
  ('succession_selective','Yes, but only for select roles',1),
('social_networks', 'Social networks (LinkedIn, Facebook, etc.)', 1),
  ('no_plan','No formal succession plan',1);