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

CREATE TABLE extract_from_the_regulated_professions_database_rpd_data (
  "origin_country_code" VARCHAR  -- Origin Country (code),
  "origin_country_name" VARCHAR  -- Origin Country (name),
  "host_country_code" VARCHAR  -- Host Country (code),
  "host_country_name" VARCHAR  -- Host Country (name),
  "profession" VARCHAR,
  "year_from" BIGINT,
  "year_to" BIGINT,
  "establishment" VARCHAR,
  "type_of_decision" VARCHAR,
  "pos_neg_neutral" VARCHAR,
  "category_eca" VARCHAR  -- Category (ECA),
  "total" BIGINT,
  "recognition_system" VARCHAR,
  "eca_analysis" VARCHAR,
  "qualification_level" VARCHAR
);

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

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

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

CREATE TABLE extract_from_the_regulated_professions_database_rpd_figure_20 (
  "country" VARCHAR,
  "appeal" DOUBLE,
  "automatic_recognition_of_professional_experience_crafts" DOUBLE  -- Automatic Recognition Of Professional Experience ('crafts'),
  "being_examined" DOUBLE,
  "check_of_qualifications_article_7_4_3_negative_after_c_3cdf8611" DOUBLE  -- Check Of Qualifications (Article 7.4(3)) - Negative After Compensation Measure,
  "check_of_qualifications_article_7_4_3_positive_after_c_cfc6c57e" DOUBLE  -- Check Of Qualifications (Article 7.4(3)) - Positive After Compensation Measure,
  "check_of_qualifications_article_7_4_2_negative_automatic" DOUBLE  -- Check Of Qualifications (Article 7.4.(2)) - Negative Automatic,
  "check_of_qualifications_article_7_4_2_positive_automatic" DOUBLE  -- Check Of Qualifications (Article 7.4.(2)) - Positive Automatic,
  "declarations_received_by_the_host_country_art_7_1_exce_1fa0b35a" DOUBLE  -- Declarations Received By The Host Country (Art. 7.1)- Except Cases Covered By Art. 7.4,
  "negative_after_adaptation_period_general_system" DOUBLE  -- Negative After Adaptation Period (general System),
  "negative_after_aptitude_test_general_system" DOUBLE  -- Negative After Aptitude Test (general System),
  "negative_automatic_general_system_and_professional_exp_c9284bb5" DOUBLE  -- Negative Automatic General System And Professional Experience ('crafts'),
  "negative_automatic_sectoral_professions" DOUBLE,
  "negative_partial_access" DOUBLE,
  "no_check_of_qualifications_article_7_4_2_positive_automatic" DOUBLE  -- No Check Of Qualifications (Article 7.4.(2)) - Positive Automatic,
  "no_reaction_within_deadline_article_7_4_4_positive_tacit" DOUBLE  -- No Reaction Within Deadline (Article 7.4(4)) - Positive Tacit,
  "positive_after_adaptation_period_general_system" DOUBLE  -- Positive After Adaptation Period (general System),
  "positive_after_aptitude_test_general_system" DOUBLE  -- Positive After Aptitude Test (general System),
  "positive_automatic_general_system_no_compensation_meas_62d0a2ca" BIGINT  -- Positive Automatic General System (no Compensation Measures Imposed),
  "positive_automatic_sectoral_professions" BIGINT,
  "positive_partial_access" DOUBLE,
  "undergoing_adaptation_period" DOUBLE,
  "grand_total" BIGINT
);

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

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

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

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

CREATE TABLE responses_to_the_survey_data (
  "ms" VARCHAR,
  "id" VARCHAR  -- ID*,
  "n_3_does_your_authority_take_decisions_as_a_competent__7f6c2dfe" VARCHAR  -- 3. Does Your Authority Take Decisions As A Competent Authority On The Recognition Of Professional Qualifications As Governed By Directive 2005/36/EC?*,
  "n_4_as_of_today_for_how_many_regulated_professions_is__e0d5dafc" VARCHAR  -- 4. As Of Today, For How Many Regulated Professions Is Your Authority Responsible?*,
  "n_5_as_of_today_has_the_competent_authority_charged_fe_6b203295" VARCHAR  -- 5. As Of Today, Has The Competent Authority Charged Fees To The Applicant (Yes/No)?*,
  "n_6_are_you_aware_of_the_approximate_real_costs_per_ap_754c64a6" VARCHAR  -- 6. Are You Aware Of The Approximate Real Costs Per Application Incurred By Your Authority For The Recognition Of Professional Qualifications?*,
  "n_6_1_if_you_know_the_estimated_real_costs_what_refere_39dac7b0" VARCHAR  -- 6.1 If You Know The Estimated Real Costs, What Reference Year Did You Take For Your Calculation?*,
  "n_6_2_for_the_year_you_selected_above_refer_to_questio_e26e5657" VARCHAR  -- 6.2 For The Year You Selected Above (refer To Question 6.1), What Were The Estimated Real Costs Incurred By Your Authority Per Application For The Recognition Of Professional Qualifications?,
  "n_6_3_for_the_year_you_selected_above_refer_to_questio_4889cf9c" VARCHAR  -- 6.3 For The Year You Selected Above (refer To Question 6.1), Does The Competent Authority Charge Fees To The Applicant? (Yes / No)*,
  "n_7_how_are_applicants_able_to_submit_their_applicatio_3a3c4c3f" VARCHAR  -- 7. How Are Applicants Able To Submit Their Applications, Including Supporting Documents, To Your Authority?*,
  "n_7_1_in_addition_to_the_submission_referred_to_in_que_32c89d7e" VARCHAR  -- 7.1 In Addition To The Submission Referred To In Question 7, Does Your Authority Also Require The Applicants To Provide Supporting Documents To The Application Physically?*,
  "eca_analysis" VARCHAR,
  "n_7_2_which_kind_of_documents_do_you_require_from_the__43fe810c" VARCHAR  -- 7.2 Which Kind Of Documents Do You Require From The Applicants?*,
  "n_8_if_applicants_need_to_undergo_compensation_measure_0f4980b8" VARCHAR  -- 8. If Applicants Need To Undergo Compensation Measures (for The Purpose Of Establishment), What Are The Options Your Authority Offer To The Applicants With Regard To Adaptation Periods Or Aptitude Tests?,
  "n_8_1_did_it_concern_a_profession_s_requiring_a_specif_3ffbc577" VARCHAR  -- 8.1 Did It Concern (a) Profession(s) Requiring A Specific Knowledge Of The National Law?,
  "n_10_in_case_of_establishment_and_temporary_mobility_d_f17c3a80" VARCHAR  -- 10. In Case Of Establishment And Temporary Mobility, Does Your Authority Carry Out Language Checks Before Taking A (recognition) Decision?*,
  "n_10_1_why_does_your_authority_carry_out_the_language_checks" VARCHAR  -- 10.1 Why Does Your Authority Carry Out The Language Checks?,
  "n_11_if_full_access_to_a_regulated_profession_cannot_b_d0c23dc0" VARCHAR  -- 11. If Full Access To A Regulated Profession Cannot Be Granted, Do You Inform Applicants That They Can Apply For Partial Access?*,
  "n_12_for_the_period_2017_2021_under_which_systems_did__b6122640" VARCHAR  -- 12. For The Period 2017-2021, Under Which Systems Did Your Authority Take (recognition) Decisions?,
  "n_12_1_concerning_the_general_system_of_recognition_fo_61fcc2c6" VARCHAR  -- 12.1 Concerning The General System Of Recognition For Establishment, How Many Days Are Needed, On Average, For Your Authority To Take A Recognition Decision, After The Receipt Of All The Required Documents?,
  "n_12_2_concerning_the_automatic_recognition_on_the_bas_5aca58c9" VARCHAR  -- 12.2 Concerning The Automatic Recognition On The Basis Of Professional Experience (Annex IV) For Establishment, How Many Days Are Needed, On Average, For Your Authority To Take A Recognition Decision, After The Receipt Of All The Required Documents?,
  "n_12_3_concerning_the_automatic_recognition_on_the_bas_76663e9c" VARCHAR  -- 12.3 Concerning The Automatic Recognition On The Basis Of Coordination Of Minimum Training Conditions (Annex V) For Establishment, How Many Days Are Needed, On Average, For Your Authority To Take A Recognition Decision, After The Receipt Of All The Requir,
  "n_12_4_concerning_the_automatic_recognition_on_the_bas_126003a5" VARCHAR  -- 12.4 Concerning The Automatic Recognition On The Basis Of Common Training Principles For Establishment, How Many Days Are Needed, On Average, For Your Authority To Take A Recognition Decision, After The Receipt Of All The Required Documents?,
  "n_12_5_concerning_the_temporary_mobility_declarations__f4ecbb88" VARCHAR  -- 12.5 Concerning The Temporary Mobility (declarations - No Prior Checks), How Many Days Are Needed, On Average, For Your Authority To Inform The Applicant On The Decision, After The Receipt Of All The Required Documents?,
  "n_12_6_concerning_the_temporary_mobility_declarations__97d37eeb" VARCHAR  -- 12.6 Concerning The Temporary Mobility (declarations - Prior Checks), How Many Days Are Needed, On Average, For Your Authority To Inform The Applicant On The Decision, After The Receipt Of All The Required Documents?,
  "n_13_when_you_as_host_member_state_are_processing_appl_0386fc29" VARCHAR  -- 13. When You (as Host Member State) Are Processing Applications For The Recognition Of Professional Qualifications, Have You Already Asked Competent Authorities Established In Other Member States (the Applicants' Home Member States) For Additional Information On Applications?,
  "n_13_1_how_do_you_usually_contact_competent_authoritie_2b788df5" VARCHAR  -- 13.1 How Do You Usually Contact Competent Authorities In Home Member States To Ask For Additional Information On Applications?,
  "n_13_2_to_what_extent_do_you_agree_with_this_statement_7af6acb2" VARCHAR  -- 13.2 To What Extent Do You Agree With This Statement? "The Competent Authorities We Contact Provide Adequate And Timely Replies (within 2 Weeks) To Requests We Send Them On Applications We Are Processing As A Host Member State".*,
  "n_14a_to_what_extent_would_you_agree_with_the_followin_de9fc04f" VARCHAR  -- 14a. To What Extent Would You Agree With The Following Statements About The Internal Market Information System (IMI)?: "IMI Is A User Friendly And Easy To Use Tool",
  "n_14b_to_what_extent_would_you_agree_with_the_followin_da833386" VARCHAR  -- 14b. To What Extent Would You Agree With The Following Statements About The Internal Market Information System (IMI)?: "IMI Helps To Identify The Relevant Competent Authority In The Applicant’s Home Member State",
  "n_14c_to_what_extent_would_you_agree_with_the_followin_ad1f2ed1" VARCHAR  -- 14c. To What Extent Would You Agree With The Following Statements About The Internal Market Information System (IMI)?: "IMI Helps To Speed Up The Processing Of Requests By Setting Clear Deadlines",
  "n_14d_to_what_extent_would_you_agree_with_the_followin_f722f626" VARCHAR  -- 14d. To What Extent Would You Agree With The Following Statements About The Internal Market Information System (IMI)?: "IMI Contributes To Overcome Language Barriers",
  "n_14e_to_what_extent_would_you_agree_with_the_followin_04d91ae2" VARCHAR  -- 14e. To What Extent Would You Agree With The Following Statements About The Internal Market Information System (IMI)?: "IMI Would Be More Efficient If It Would Be Available In English Language Only",
  "n_15_do_you_use_measures_to_simplify_the_recognition_o_a9194d48" VARCHAR  -- 15. Do You Use Measures To Simplify The Recognition Of Professional Qualifications With Certain Member States, Other Than Those Described In Directive 2005/36/EC? For Example, Do You Have Bilateral Agreements With Those Member States?*,
  "n_16a_do_you_agree_that_the_following_simplification_m_23c7c526" VARCHAR  -- 16a. Do You Agree That The Following Simplification Measures Should Be Extended To Other Professions?: European Professional Card (EPC)*,
  "n_16b_do_you_agree_that_the_following_simplification_m_9d91d939" VARCHAR  -- 16b. Do You Agree That The Following Simplification Measures Should Be Extended To Other Professions?: Automatic Recognition On The Basis Of Coordination Of Minimum Training Conditions (Annex V To Directive 2005/36/EC)*,
  "n_16c_do_you_agree_that_the_following_simplification_m_064bb542" VARCHAR  -- 16c. Do You Agree That The Following Simplification Measures Should Be Extended To Other Professions?: Automatic Recognition On The Basis Of A Common Training Framework (Article 49a Of Directive 2005/36/EC)*,
  "n_16d_do_you_agree_that_the_following_simplification_m_ee4a5901" VARCHAR  -- 16d. Do You Agree That The Following Simplification Measures Should Be Extended To Other Professions?: Automatic Recognition On The Basis Of A Common Training Test (CTT) (Article 49b Of Directive 2005/36/EC)*
);

CREATE TABLE responses_to_the_survey_figure_12 (
  "ms" VARCHAR,
  "n_12_2_compliance" BIGINT  -- 12.2 Compliance,
  "n_12_3_compliance" BIGINT  -- 12.3 Compliance,
  "n_12_4_compliance" BIGINT  -- 12.4 Compliance,
  "n_12_2_non_compliance" BIGINT  -- 12.2 Non-compliance,
  "n_12_3_non_compliance" BIGINT  -- 12.3 Non-compliance,
  "n_12_4_non_compliance" BIGINT  -- 12.4 Non-compliance,
  "total_compliance" BIGINT,
  "total_non_compliance" BIGINT,
  "total" BIGINT,
  "compliance_pct" DOUBLE,
  "non_compliance_pct" DOUBLE
);

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_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),
  "internal_market_information_system_imi_e_mail" BIGINT  -- Internal Market Information System (IMI);E-Mail,
  "internal_market_information_system_imi_e_mail_phone_call" DOUBLE  -- Internal Market Information System (IMI);E-Mail;Phone Call,
  "internal_market_information_system_imi_e_mail_phone_call_post" DOUBLE  -- Internal Market Information System (IMI);E-Mail;Phone Call;Post,
  "internal_market_information_system_imi_e_mail_post" DOUBLE  -- Internal Market Information System (IMI);E-Mail;Post,
  "internal_market_information_system_imi_other" DOUBLE  -- Internal Market Information System (IMI);Other,
  "other" DOUBLE,
  "post" 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 responses_to_the_survey_figure_7 (
  "country_code" VARCHAR,
  "no_fees_charged" DOUBLE,
  "more_than_eur_250" DOUBLE,
  "eur_51_250" DOUBLE  -- EUR 51 - 250,
  "eur_1_50" DOUBLE  -- EUR 1 - 50,
  "grand_total" BIGINT
);

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