Correspondence 21-27 To 14-20 Intervention Fields

DG REGIO

@esifunds.n_4s7y_iy43

Table List

1 table(39.71 KB)

Table 1

@esifunds.n_4s7y_iy43.table_1

39.71 KB
182 rows
15 columns

n__21_27_intervention_field 21–27 Intervention Field	n__21_27_intervention_field_1 21–27 Intervention Field 1	n__21_27_intervention_field_2 21–27 Intervention Field 2	n__21_27_intervention_fied 21–27 Intervention Fied	n__21_27_policy_objective 21–27 Policy Objective	indicative_specific_objective Indicative Specific Objective	n__21_27_code_equivalent 21–27 Code Equivalent	n__14_20_intervention_field 14–20 Intervention Field	n__14_20_intervention_field_1 14–20 Intervention Field 1	n__14_20_intervention_field_2 14–20 Intervention Field 2	n__14_20_intervention_field_3 14–20 Intervention Field 3
1	Investment in fixed assets, including research infrastructure, in micro enterprises directly linked to research and innovation activities	001 R+I fixed asset investment in micro enterprises		PO1	RSO1.1	001	56	Investment in infrastructure, capacities and equipment in SMEs directly linked to research and innovation activities
2	Investment in fixed assets, including research infrastructure, in small and medium‑sized enterprises (including private research centres) directly linked to research and innovation activities	002 R+I fixed asset investment in SMEs		PO1	RSO1.1	002	59	Research and innovation infrastructure (private, including science parks)
3	Investment in fixed assets, including research infrastructure, in large enterprises directly linked to research and innovation activities	003 R+I fixed asset investment in large enterprises	Large enterprises are all enterprises other than SMEs, including small mid-cap companies.	PO1	RSO1.1	002bis	59	Research and innovation infrastructure (private, including science parks)	57	Investment in infrastructure, capacities and equipment in large companies directly linked to research and innovation activities
4	Investment in fixed assets, including research infrastructure, in public research centres and higher education directly linked to research and innovation activities	004 R+I fixed asset investment: Public research centres + HEI		PO1	RSO1.1	003	58	Research and innovation infrastructure (public)
5	Investment in intangible assets in micro enterprises directly linked to research and innovation activities	005 R+I intangible asset in micro enterprises		PO1	RSO1.1	004	59	Research and innovation infrastructure (private, including science parks)	1	Generic productive investment in small and medium-sized enterprises (‘SMEs’)
6	Investment in intangible assets in SMEs (including private research centres) directly linked to research and innovation activities	006 R+I intangible asset in SMEs		PO1	RSO1.1	005	59	Research and innovation infrastructure (private, including science parks)	1	Generic productive investment in small and medium-sized enterprises (‘SMEs’)
7	Investment in intangible assets in large enterprises directly linked to research and innovation activities	007 R+I intangible asset investment in large enterprises		PO1	RSO1.1	005bis	61	Research and innovation activities in private research centres including networking
8	Investment in intangible assets in public research centres and higher education directly linked to research and innovation activities	008 R+I Intangible assets in public research centres + HEI		PO1	RSO1.1	006	60	Research and innovation activities in public research centres and centres of competence including networking
9	Research and innovation activities in micro enterprises including networking (industrial research, experimental development, feasibility studies)	009 R+I activities in micro enterprises		PO1	RSO1.1	007	61	Research and innovation activities in private research centres including networking
10	Research and innovation activities in SMEs, including networking	010 R+I activities in SMEs		PO1	RSO1.1	008	61	Research and innovation activities in private research centres including networking


CREATE TABLE table_1 (
  "n__21_27_intervention_field" BIGINT,
  "n__21_27_intervention_field_1" VARCHAR,
  "n__21_27_intervention_field_2" VARCHAR,
  "n__21_27_intervention_fied" VARCHAR,
  "n__21_27_coefficient_for_the" DOUBLE,
  "n__21_27_coefficient_for_the_1" DOUBLE,
  "n__21_27_policy_objective" VARCHAR,
  "indicative_specific_objective" VARCHAR,
  "n__21_27_code_equivalent" VARCHAR,
  "n__14_20_intervention_field" DOUBLE,
  "n__14_20_intervention_field_1" VARCHAR,
  "n__14_20_intervention_field_2" DOUBLE,
  "n__14_20_intervention_field_3" VARCHAR,
  "n__14_20_intervention_field_4" DOUBLE,
  "n__14_20_intervention_field_5" VARCHAR
);