Special Report 10/2024: The Recognition Of Professional Qualifications In The EU

CREATE TABLE extract_from_the_regulated_professions_database_rpd_figure_1 (
  "row_labels" VARCHAR,
  "sum_of_total" BIGINT
);

CREATE TABLE other_figures_figure_5 (
  "country_code" VARCHAR,
  "sum_of_regulated_professions_december_2023" BIGINT,
  "sum_of_average" BIGINT
);

CREATE TABLE extract_from_the_regulated_professions_database_rpd_figure_2 (
  "row_labels" VARCHAR,
  "sum_of_total" BIGINT,
  "percentage" DOUBLE
);

CREATE TABLE responses_to_the_survey_figure_18 (
  "country" VARCHAR,
  "e_mail" DOUBLE,
  "e_mail_other" DOUBLE,
  "e_mail_phone_call" DOUBLE,
  "internal_market_information_system_imi" DOUBLE,
  "internal_market_information_system_imi_e_mail" BIGINT,
  "internal_market_information_system_imi_e_mail_phone_call" DOUBLE,
  "internal_market_information_system_imi_e_mail_phone_call_post" DOUBLE,
  "internal_market_information_system_imi_e_mail_post" DOUBLE,
  "internal_market_information_system_imi_other" DOUBLE,
  "other" DOUBLE,
  "post" DOUBLE,
  "grand_total" BIGINT
);

CREATE TABLE responses_to_the_survey_figure_8 (
  "country" VARCHAR,
  "no" BIGINT,
  "yes" DOUBLE,
  "grand_total" BIGINT
);

CREATE TABLE responses_to_the_survey_figure_13 (
  "country" VARCHAR,
  "compliance" BIGINT,
  "non_compliance" DOUBLE,
  "grand_total" BIGINT
);

CREATE TABLE responses_to_the_survey_figure_12 (
  "ms" VARCHAR,
  "n_12_2_compliance" BIGINT,
  "n_12_3_compliance" BIGINT,
  "n_12_4_compliance" BIGINT,
  "n_12_2_non_compliance" BIGINT,
  "n_12_3_non_compliance" BIGINT,
  "n_12_4_non_compliance" BIGINT,
  "total_compliance" BIGINT,
  "total_non_compliance" BIGINT,
  "total" BIGINT,
  "compliance_pct" DOUBLE,
  "non_compliance_pct" DOUBLE
);

CREATE TABLE responses_to_the_survey_data (
  "ms" VARCHAR,
  "id" VARCHAR,
  "n_3_does_your_authority_take_decisions_as_a_competent__7f6c2dfe" VARCHAR,
  "n_4_as_of_today_for_how_many_regulated_professions_is__e0d5dafc" VARCHAR,
  "n_5_as_of_today_has_the_competent_authority_charged_fe_6b203295" VARCHAR,
  "n_6_are_you_aware_of_the_approximate_real_costs_per_ap_754c64a6" VARCHAR,
  "n_6_1_if_you_know_the_estimated_real_costs_what_refere_39dac7b0" VARCHAR,
  "n_6_2_for_the_year_you_selected_above_refer_to_questio_e26e5657" VARCHAR,
  "n_6_3_for_the_year_you_selected_above_refer_to_questio_4889cf9c" VARCHAR,
  "n_7_how_are_applicants_able_to_submit_their_applicatio_3a3c4c3f" VARCHAR,
  "n_7_1_in_addition_to_the_submission_referred_to_in_que_32c89d7e" VARCHAR,
  "eca_analysis" VARCHAR,
  "n_7_2_which_kind_of_documents_do_you_require_from_the__43fe810c" VARCHAR,
  "n_8_if_applicants_need_to_undergo_compensation_measure_0f4980b8" VARCHAR,
  "n_8_1_did_it_concern_a_profession_s_requiring_a_specif_3ffbc577" VARCHAR,
  "n_10_in_case_of_establishment_and_temporary_mobility_d_f17c3a80" VARCHAR,
  "n_10_1_why_does_your_authority_carry_out_the_language_checks" VARCHAR,
  "n_11_if_full_access_to_a_regulated_profession_cannot_b_d0c23dc0" VARCHAR,
  "n_12_for_the_period_2017_2021_under_which_systems_did__b6122640" VARCHAR,
  "n_12_1_concerning_the_general_system_of_recognition_fo_61fcc2c6" VARCHAR,
  "n_12_2_concerning_the_automatic_recognition_on_the_bas_5aca58c9" VARCHAR,
  "n_12_3_concerning_the_automatic_recognition_on_the_bas_76663e9c" VARCHAR,
  "n_12_4_concerning_the_automatic_recognition_on_the_bas_126003a5" VARCHAR,
  "n_12_5_concerning_the_temporary_mobility_declarations__f4ecbb88" VARCHAR,
  "n_12_6_concerning_the_temporary_mobility_declarations__97d37eeb" VARCHAR,
  "n_13_when_you_as_host_member_state_are_processing_appl_0386fc29" VARCHAR,
  "n_13_1_how_do_you_usually_contact_competent_authoritie_2b788df5" VARCHAR,
  "n_13_2_to_what_extent_do_you_agree_with_this_statement_7af6acb2" VARCHAR,
  "n_14a_to_what_extent_would_you_agree_with_the_followin_de9fc04f" VARCHAR,
  "n_14b_to_what_extent_would_you_agree_with_the_followin_da833386" VARCHAR,
  "n_14c_to_what_extent_would_you_agree_with_the_followin_ad1f2ed1" VARCHAR,
  "n_14d_to_what_extent_would_you_agree_with_the_followin_f722f626" VARCHAR,
  "n_14e_to_what_extent_would_you_agree_with_the_followin_04d91ae2" VARCHAR,
  "n_15_do_you_use_measures_to_simplify_the_recognition_o_a9194d48" VARCHAR,
  "n_16a_do_you_agree_that_the_following_simplification_m_23c7c526" VARCHAR,
  "n_16b_do_you_agree_that_the_following_simplification_m_9d91d939" VARCHAR,
  "n_16c_do_you_agree_that_the_following_simplification_m_064bb542" VARCHAR,
  "n_16d_do_you_agree_that_the_following_simplification_m_ee4a5901" VARCHAR
);

CREATE TABLE responses_to_the_survey_annex_ii (
  "member_state" VARCHAR,
  "invitations" BIGINT,
  "reply" BIGINT,
  "response_rate" DOUBLE
);

CREATE TABLE other_figures_figure_10 (
  "n_7_semb" VARCHAR,
  "pr" BIGINT
);

CREATE TABLE extract_from_the_regulated_professions_database_rpd_figure_20 (
  "country" VARCHAR,
  "appeal" DOUBLE,
  "automatic_recognition_of_professional_experience_crafts" DOUBLE,
  "being_examined" DOUBLE,
  "check_of_qualifications_article_7_4_3_negative_after_c_3cdf8611" DOUBLE,
  "check_of_qualifications_article_7_4_3_positive_after_c_cfc6c57e" DOUBLE,
  "check_of_qualifications_article_7_4_2_negative_automatic" DOUBLE,
  "check_of_qualifications_article_7_4_2_positive_automatic" DOUBLE,
  "declarations_received_by_the_host_country_art_7_1_exce_1fa0b35a" DOUBLE,
  "negative_after_adaptation_period_general_system" DOUBLE,
  "negative_after_aptitude_test_general_system" DOUBLE,
  "negative_automatic_general_system_and_professional_exp_c9284bb5" DOUBLE,
  "negative_automatic_sectoral_professions" DOUBLE,
  "negative_partial_access" DOUBLE,
  "no_check_of_qualifications_article_7_4_2_positive_automatic" DOUBLE,
  "no_reaction_within_deadline_article_7_4_4_positive_tacit" DOUBLE,
  "positive_after_adaptation_period_general_system" DOUBLE,
  "positive_after_aptitude_test_general_system" DOUBLE,
  "positive_automatic_general_system_no_compensation_meas_62d0a2ca" BIGINT,
  "positive_automatic_sectoral_professions" BIGINT,
  "positive_partial_access" DOUBLE,
  "undergoing_adaptation_period" DOUBLE,
  "grand_total" BIGINT
);

CREATE TABLE responses_to_the_survey_figure_6 (
  "country" VARCHAR,
  "e_mail" DOUBLE,
  "fully_electronic" DOUBLE,
  "in_person_only" DOUBLE,
  "not_electronic" DOUBLE,
  "grand_total" BIGINT
);

CREATE TABLE extract_from_the_regulated_professions_database_rpd_data (
  "origin_country_code" VARCHAR,
  "origin_country_name" VARCHAR,
  "host_country_code" VARCHAR,
  "host_country_name" VARCHAR,
  "profession" VARCHAR,
  "year_from" BIGINT,
  "year_to" BIGINT,
  "establishment" VARCHAR,
  "type_of_decision" VARCHAR,
  "pos_neg_neutral" VARCHAR,
  "category_eca" VARCHAR,
  "total" BIGINT,
  "recognition_system" VARCHAR,
  "eca_analysis" VARCHAR,
  "qualification_level" VARCHAR
);

CREATE TABLE responses_to_the_survey_figure_7 (
  "country_code" VARCHAR,
  "no_fees_charged" DOUBLE,
  "more_than_eur_250" DOUBLE,
  "eur_51_250" DOUBLE,
  "eur_1_50" DOUBLE,
  "grand_total" BIGINT
);

CREATE TABLE extract_from_the_regulated_professions_database_rpd_figure_16 (
  "host_country_name" VARCHAR,
  "negative_partial_access" DOUBLE,
  "positive_partial_access" DOUBLE,
  "sum_neg_pos" BIGINT,
  "sum_of_total" BIGINT,
  "percentage_of_total" DOUBLE
);

CREATE TABLE other_figures_figure_19 (
  "profession" VARCHAR,
  "number_of_imi_alerts" BIGINT
);