-- Table structure for table `node_revision__field_funding_research`
--

CREATE TABLE `node_revision__field_funding_research` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_funding_research_value` tinyint(4) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_funding…';

--
-- Dumping data for table `node_revision__field_funding_research`
--

INSERT INTO `node_revision__field_funding_research` VALUES ('initiative',0,1,2,'en',0,0),('initiative',0,1,3,'en',0,0),('initiative',0,1,5,'en',0,0),('initiative',0,1,7,'en',0,0),('initiative',0,306,314,'en',0,1),('initiative',0,307,315,'en',0,1),('initiative',0,309,318,'en',0,1),('initiative',0,310,319,'en',0,0),('initiative',0,516,525,'en',0,1),('initiative',0,518,528,'en',0,1),('initiative',0,519,529,'en',0,0),('initiative',0,520,530,'en',0,0),('initiative',0,521,531,'en',0,0),('initiative',0,522,532,'en',0,0),('initiative',0,523,533,'en',0,1),('initiative',0,524,534,'en',0,1),('initiative',0,525,535,'en',0,0),('initiative',0,526,536,'en',0,1),('initiative',0,527,537,'en',0,1),('initiative',0,528,538,'en',0,1),('initiative',0,529,539,'en',0,1),('initiative',0,530,540,'en',0,0),('initiative',0,531,541,'en',0,1),('initiative',0,534,544,'en',0,0),('initiative',0,535,545,'en',0,0),('initiative',0,536,546,'en',0,0),('initiative',0,537,547,'en',0,0),('initiative',0,538,548,'en',0,1),('initiative',0,539,549,'en',0,1),('initiative',0,540,550,'en',0,0),('initiative',0,541,551,'en',0,1),('initiative',0,542,552,'en',0,0),('initiative',0,543,553,'en',0,1),('initiative',0,544,554,'en',0,0),('initiative',0,545,555,'en',0,0),('initiative',0,546,556,'en',0,0),('initiative',0,555,565,'en',0,1),('initiative',0,556,566,'en',0,0),('initiative',0,557,567,'en',0,0),('initiative',0,564,582,'en',0,1),('initiative',0,572,599,'en',0,1),('initiative',0,589,616,'en',0,0),('initiative',0,590,617,'en',0,1),('initiative',0,592,621,'en',0,1),('initiative',0,593,622,'en',0,1);

--
-- Table structure for table `node_revision__field_geographical_coverage`
--

CREATE TABLE `node_revision__field_geographical_coverage` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_geographical_coverage_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_geographical_coverage_value` (`field_geographical_coverage_value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_geographical…';

--
-- Dumping data for table `node_revision__field_geographical_coverage`
--

INSERT INTO `node_revision__field_geographical_coverage` VALUES ('initiative',0,1,3,'en',0,'Europe'),('initiative',0,1,3,'en',1,'Afghanistan'),('initiative',0,1,5,'en',0,'Europe'),('initiative',0,1,5,'en',1,'Afghanistan'),('initiative',0,1,7,'en',0,'Europe'),('initiative',0,1,7,'en',1,'Afghanistan'),('initiative',0,306,314,'en',0,'Afghanistan'),('initiative',0,307,315,'en',0,'Europe'),('initiative',0,309,318,'en',0,'Andorra'),('initiative',0,309,318,'en',1,'Antigua and Barbuda'),('initiative',0,310,319,'en',0,'Afghanistan'),('initiative',0,516,525,'en',0,'Europe'),('initiative',0,518,528,'en',0,'Afghanistan'),('initiative',0,519,529,'en',0,'Afghanistan'),('initiative',0,520,530,'en',0,'Afghanistan'),('initiative',0,521,531,'en',0,'Afghanistan'),('initiative',0,522,532,'en',0,'Europe'),('initiative',0,523,533,'en',0,'Europe'),('initiative',0,524,534,'en',0,'Europe'),('initiative',0,525,535,'en',0,'Europe'),('initiative',0,526,536,'en',0,'Afghanistan'),('initiative',0,527,537,'en',0,'World'),('initiative',0,528,538,'en',0,'Europe'),('initiative',0,528,538,'en',1,'Afghanistan'),('initiative',0,529,539,'en',0,'Argentina'),('initiative',0,529,539,'en',1,'Australia'),('initiative',0,529,539,'en',2,'Austria'),('initiative',0,529,539,'en',3,'Belgium'),('initiative',0,530,540,'en',0,'Andorra'),('initiative',0,530,540,'en',1,'Argentina'),('initiative',0,531,541,'en',0,'World'),('initiative',0,534,544,'en',0,'Italy'),('initiative',0,535,545,'en',0,'World'),('initiative',0,536,546,'en',0,'Europe'),('initiative',0,537,547,'en',0,'Europe'),('initiative',0,538,548,'en',0,'Europe'),('initiative',0,539,549,'en',0,'Europe'),('initiative',0,540,550,'en',0,'Poland'),('initiative',0,541,551,'en',0,'Europe'),('initiative',0,542,552,'en',0,'Europe'),('initiative',0,543,553,'en',0,'World'),('initiative',0,544,554,'en',0,'Czechia (Czech Republic)'),('initiative',0,544,554,'en',1,'Denmark'),('initiative',0,545,555,'en',0,'Europe'),('initiative',0,546,556,'en',0,'Europe'),('initiative',0,555,565,'en',0,'World'),('initiative',0,556,566,'en',0,'Finland'),('initiative',0,557,567,'en',0,'World'),('initiative',0,564,582,'en',0,'Austria'),('initiative',0,572,599,'en',0,'World'),('initiative',0,589,616,'en',0,'Europe'),('initiative',0,590,617,'en',0,'World'),('initiative',0,592,621,'en',0,'World'),('initiative',0,593,622,'en',0,'Europe');

--
-- Table structure for table `node_revision__field_image`
--

CREATE TABLE `node_revision__field_image` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_image_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the file entity.',
  `field_image_alt` varchar(512) DEFAULT NULL COMMENT 'Alternative image text, for the image''s ''alt'' attribute.',
  `field_image_title` varchar(1024) DEFAULT NULL COMMENT 'Image title text, for the image''s ''title'' attribute.',
  `field_image_width` int(10) unsigned DEFAULT NULL COMMENT 'The width of the image in pixels.',
  `field_image_height` int(10) unsigned DEFAULT NULL COMMENT 'The height of the image in pixels.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_image_target_id` (`field_image_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_image.';

--
-- Dumping data for table `node_revision__field_image`
--


--
-- Table structure for table `node_revision__field_indicator`
--

CREATE TABLE `node_revision__field_indicator` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_indicator_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_indicator_target_id` (`field_indicator_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_indicator.';

--
-- Dumping data for table `node_revision__field_indicator`
--

INSERT INTO `node_revision__field_indicator` VALUES ('impact_analysis',0,532,542,'en',0,399),('impact_analysis',0,533,543,'en',0,400),('impact_analysis',0,559,577,'en',0,402),('impact_analysis',0,560,578,'en',0,419),('impact_analysis',0,561,579,'en',0,500),('impact_analysis',0,562,580,'en',0,419),('impact_analysis',0,563,581,'en',0,439),('impact_analysis',0,565,583,'en',0,405),('impact_analysis',0,566,584,'en',0,498),('impact_analysis',0,567,585,'en',0,451),('impact_analysis',0,568,586,'en',0,434),('impact_analysis',0,569,587,'en',0,549),('impact_analysis',0,574,601,'en',0,503),('impact_analysis',0,575,602,'en',0,440),('impact_analysis',0,576,603,'en',0,409),('impact_analysis',0,577,604,'en',0,550),('impact_analysis',0,578,605,'en',0,419),('impact_analysis',0,579,606,'en',0,467),('impact_analysis',0,580,607,'en',0,436),('impact_analysis',0,581,608,'en',0,425),('impact_analysis',0,582,609,'en',0,439),('impact_analysis',0,583,610,'en',0,436),('impact_analysis',0,584,611,'en',0,438),('impact_analysis',0,586,613,'en',0,549),('impact_analysis',0,587,614,'en',0,439),('impact_analysis',0,588,615,'en',0,550),('impact_analysis',0,591,620,'en',0,551);

--
-- Table structure for table `node_revision__field_indicator_code`
--

CREATE TABLE `node_revision__field_indicator_code` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_indicator_code_value` int(11) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_indicator…';

--
-- Dumping data for table `node_revision__field_indicator_code`
--

INSERT INTO `node_revision__field_indicator_code` VALUES ('indicator',0,399,408,'en',0,1),('indicator',0,400,409,'en',0,2),('indicator',0,401,410,'en',0,3),('indicator',0,402,411,'en',0,4),('indicator',0,403,412,'en',0,5),('indicator',0,404,413,'en',0,6),('indicator',0,405,414,'en',0,7),('indicator',0,406,415,'en',0,8),('indicator',0,407,416,'en',0,9),('indicator',0,408,417,'en',0,10),('indicator',0,409,418,'en',0,11),('indicator',0,410,419,'en',0,12),('indicator',0,411,420,'en',0,13),('indicator',0,412,421,'en',0,14),('indicator',0,413,422,'en',0,15),('indicator',0,414,423,'en',0,16),('indicator',0,415,424,'en',0,17),('indicator',0,416,425,'en',0,18),('indicator',0,417,426,'en',0,19),('indicator',0,418,427,'en',0,20),('indicator',0,419,428,'en',0,21),('indicator',0,420,429,'en',0,22),('indicator',0,421,430,'en',0,23),('indicator',0,422,431,'en',0,24),('indicator',0,423,432,'en',0,25),('indicator',0,424,433,'en',0,26),('indicator',0,425,434,'en',0,27),('indicator',0,426,435,'en',0,28),('indicator',0,427,436,'en',0,29),('indicator',0,428,437,'en',0,30),('indicator',0,429,438,'en',0,31),('indicator',0,430,439,'en',0,32),('indicator',0,431,440,'en',0,33),('indicator',0,432,441,'en',0,34),('indicator',0,433,442,'en',0,35),('indicator',0,434,443,'en',0,36),('indicator',0,435,444,'en',0,37),('indicator',0,436,445,'en',0,38),('indicator',0,437,446,'en',0,39),('indicator',0,438,447,'en',0,40),('indicator',0,439,448,'en',0,41),('indicator',0,440,449,'en',0,42),('indicator',0,441,450,'en',0,43),('indicator',0,442,451,'en',0,44),('indicator',0,443,452,'en',0,45),('indicator',0,444,453,'en',0,46),('indicator',0,445,454,'en',0,47),('indicator',0,446,455,'en',0,48),('indicator',0,447,456,'en',0,49),('indicator',0,448,457,'en',0,50),('indicator',0,449,458,'en',0,51),('indicator',0,450,459,'en',0,52),('indicator',0,451,460,'en',0,53),('indicator',0,452,461,'en',0,55),('indicator',0,453,462,'en',0,56),('indicator',0,454,463,'en',0,57),('indicator',0,455,464,'en',0,58),('indicator',0,456,465,'en',0,59),('indicator',0,457,466,'en',0,60),('indicator',0,458,467,'en',0,61),('indicator',0,459,468,'en',0,62),('indicator',0,460,469,'en',0,63),('indicator',0,461,470,'en',0,64),('indicator',0,462,471,'en',0,65),('indicator',0,463,472,'en',0,66),('indicator',0,464,473,'en',0,67),('indicator',0,465,474,'en',0,68),('indicator',0,466,475,'en',0,69),('indicator',0,467,476,'en',0,70),('indicator',0,468,477,'en',0,71),('indicator',0,469,478,'en',0,72),('indicator',0,470,479,'en',0,73),('indicator',0,471,480,'en',0,74),('indicator',0,472,481,'en',0,75),('indicator',0,473,482,'en',0,76),('indicator',0,474,483,'en',0,77),('indicator',0,475,484,'en',0,79),('indicator',0,476,485,'en',0,80),('indicator',0,477,486,'en',0,81),('indicator',0,478,487,'en',0,82),('indicator',0,479,488,'en',0,83),('indicator',0,480,489,'en',0,84),('indicator',0,481,490,'en',0,85),('indicator',0,482,491,'en',0,86),('indicator',0,483,492,'en',0,87),('indicator',0,484,493,'en',0,88),('indicator',0,485,494,'en',0,89),('indicator',0,486,495,'en',0,90),('indicator',0,487,496,'en',0,91),('indicator',0,488,497,'en',0,92),('indicator',0,489,498,'en',0,93),('indicator',0,490,499,'en',0,94),('indicator',0,491,500,'en',0,95),('indicator',0,492,501,'en',0,96),('indicator',0,493,502,'en',0,97),('indicator',0,494,503,'en',0,98),('indicator',0,495,504,'en',0,99),('indicator',0,496,505,'en',0,100),('indicator',0,497,506,'en',0,101),('indicator',0,498,507,'en',0,102),('indicator',0,499,508,'en',0,103),('indicator',0,500,509,'en',0,104),('indicator',0,501,510,'en',0,105),('indicator',0,502,511,'en',0,106),('indicator',0,503,512,'en',0,107),('indicator',0,504,513,'en',0,108),('indicator',0,505,514,'en',0,109),('indicator',0,506,515,'en',0,110),('indicator',0,507,516,'en',0,111),('indicator',0,508,517,'en',0,113),('indicator',0,509,518,'en',0,114),('indicator',0,510,519,'en',0,115),('indicator',0,512,521,'en',0,54),('indicator',0,547,557,'en',0,78),('indicator',0,548,558,'en',0,112),('indicator',0,549,559,'en',0,183),('indicator',0,550,560,'en',0,184),('indicator',0,551,561,'en',0,185),('indicator',0,552,562,'en',0,186),('indicator',0,553,563,'en',0,181),('indicator',0,554,564,'en',0,154);

--
-- Table structure for table `node_revision__field_indicator_in_use`
--

CREATE TABLE `node_revision__field_indicator_in_use` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_indicator_in_use_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_indicator_in_use_value` (`field_indicator_in_use_value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_indicator_in…';

--
-- Dumping data for table `node_revision__field_indicator_in_use`
--

INSERT INTO `node_revision__field_indicator_in_use` VALUES ('indicator',0,399,408,'en',0,'Yes'),('indicator',0,400,409,'en',0,'Yes'),('indicator',0,401,410,'en',0,'Yes'),('indicator',0,402,411,'en',0,'Yes'),('indicator',0,403,412,'en',0,'No'),('indicator',0,404,413,'en',0,'No'),('indicator',0,405,414,'en',0,'Yes'),('indicator',0,406,415,'en',0,'Yes'),('indicator',0,407,416,'en',0,'No'),('indicator',0,408,417,'en',0,'No'),('indicator',0,409,418,'en',0,'Yes'),('indicator',0,410,419,'en',0,'Yes'),('indicator',0,411,420,'en',0,'Yes'),('indicator',0,412,421,'en',0,'Yes'),('indicator',0,413,422,'en',0,'No'),('indicator',0,414,423,'en',0,'No'),('indicator',0,415,424,'en',0,'No'),('indicator',0,416,425,'en',0,'No'),('indicator',0,417,426,'en',0,'Yes'),('indicator',0,418,427,'en',0,'Yes'),('indicator',0,419,428,'en',0,'Yes'),('indicator',0,420,429,'en',0,'Yes'),('indicator',0,421,430,'en',0,'No'),('indicator',0,422,431,'en',0,'No'),('indicator',0,423,432,'en',0,'Yes'),('indicator',0,424,433,'en',0,'Yes'),('indicator',0,425,434,'en',0,'Yes'),('indicator',0,426,435,'en',0,'Yes'),('indicator',0,427,436,'en',0,'Yes'),('indicator',0,428,437,'en',0,'No'),('indicator',0,429,438,'en',0,'Yes'),('indicator',0,430,439,'en',0,'Yes'),('indicator',0,431,440,'en',0,'No'),('indicator',0,432,441,'en',0,'Yes'),('indicator',0,433,442,'en',0,'Yes'),('indicator',0,434,443,'en',0,'No'),('indicator',0,435,444,'en',0,'Yes'),('indicator',0,436,445,'en',0,'Yes'),('indicator',0,437,446,'en',0,'Yes'),('indicator',0,438,447,'en',0,'No'),('indicator',0,439,448,'en',0,'No'),('indicator',0,440,449,'en',0,'Yes'),('indicator',0,441,450,'en',0,'Yes'),('indicator',0,442,451,'en',0,'Yes'),('indicator',0,443,452,'en',0,'Yes'),('indicator',0,444,453,'en',0,'Yes'),('indicator',0,445,454,'en',0,'No'),('indicator',0,446,455,'en',0,'Yes'),('indicator',0,447,456,'en',0,'No'),('indicator',0,448,457,'en',0,'No'),('indicator',0,449,458,'en',0,'Yes'),('indicator',0,450,459,'en',0,'No'),('indicator',0,451,460,'en',0,'No'),('indicator',0,452,461,'en',0,'No'),('indicator',0,453,462,'en',0,'No'),('indicator',0,454,463,'en',0,'Yes'),('indicator',0,455,464,'en',0,'No'),('indicator',0,456,465,'en',0,'No'),('indicator',0,457,466,'en',0,'Yes'),('indicator',0,458,467,'en',0,'Yes'),('indicator',0,459,468,'en',0,'Yes'),('indicator',0,460,469,'en',0,'Yes'),('indicator',0,461,470,'en',0,'No'),('indicator',0,462,471,'en',0,'No'),('indicator',0,463,472,'en',0,'Yes'),('indicator',0,464,473,'en',0,'No'),('indicator',0,465,474,'en',0,'No'),('indicator',0,466,475,'en',0,'Yes'),('indicator',0,467,476,'en',0,'No'),('indicator',0,468,477,'en',0,'No'),('indicator',0,469,478,'en',0,'No'),('indicator',0,470,479,'en',0,'No'),('indicator',0,471,480,'en',0,'No'),('indicator',0,472,481,'en',0,'Yes'),('indicator',0,473,482,'en',0,'Yes'),('indicator',0,474,483,'en',0,'Yes'),('indicator',0,475,484,'en',0,'Yes'),('indicator',0,476,485,'en',0,'No'),('indicator',0,477,486,'en',0,'Yes'),('indicator',0,478,487,'en',0,'No'),('indicator',0,479,488,'en',0,'No'),('indicator',0,480,489,'en',0,'Yes'),('indicator',0,481,490,'en',0,'Yes'),('indicator',0,482,491,'en',0,'No'),('indicator',0,483,492,'en',0,'Yes'),('indicator',0,484,493,'en',0,'Yes'),('indicator',0,485,494,'en',0,'Yes'),('indicator',0,486,495,'en',0,'Yes'),('indicator',0,487,496,'en',0,'Yes'),('indicator',0,488,497,'en',0,'Yes'),('indicator',0,489,498,'en',0,'Yes'),('indicator',0,490,499,'en',0,'No'),('indicator',0,491,500,'en',0,'Yes'),('indicator',0,492,501,'en',0,'No'),('indicator',0,493,502,'en',0,'Yes'),('indicator',0,494,503,'en',0,'Yes'),('indicator',0,495,504,'en',0,'Yes'),('indicator',0,496,505,'en',0,'No'),('indicator',0,497,506,'en',0,'Yes'),('indicator',0,498,507,'en',0,'Yes'),('indicator',0,499,508,'en',0,'Yes'),('indicator',0,500,509,'en',0,'Yes'),('indicator',0,501,510,'en',0,'Yes'),('indicator',0,502,511,'en',0,'Yes'),('indicator',0,503,512,'en',0,'No'),('indicator',0,504,513,'en',0,'No'),('indicator',0,505,514,'en',0,'Yes'),('indicator',0,506,515,'en',0,'Yes'),('indicator',0,507,516,'en',0,'Yes'),('indicator',0,508,517,'en',0,'Yes'),('indicator',0,509,518,'en',0,'No'),('indicator',0,510,519,'en',0,'Yes'),('indicator',0,512,521,'en',0,'No'),('indicator',0,547,557,'en',0,'Yes'),('indicator',0,548,558,'en',0,'Yes'),('indicator',0,549,559,'en',0,'Yes'),('indicator',0,550,560,'en',0,'Yes'),('indicator',0,551,561,'en',0,'Yes'),('indicator',0,552,562,'en',0,'Yes'),('indicator',0,553,563,'en',0,'Yes'),('indicator',0,554,564,'en',0,'Yes'),('indicator',0,585,612,'en',0,'Yes');

--
-- Table structure for table `node_revision__field_inherits_parent_s_assesmen`
--

CREATE TABLE `node_revision__field_inherits_parent_s_assesmen` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_inherits_parent_s_assesmen_value` tinyint(4) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_inherits…';

--
-- Dumping data for table `node_revision__field_inherits_parent_s_assesmen`
--

INSERT INTO `node_revision__field_inherits_parent_s_assesmen` VALUES ('initiative',0,1,7,'en',0,0),('initiative',0,306,314,'en',0,0),('initiative',0,307,315,'en',0,0),('initiative',0,309,318,'en',0,0),('initiative',0,310,319,'en',0,1),('initiative',0,516,525,'en',0,0),('initiative',0,518,528,'en',0,0),('initiative',0,519,529,'en',0,0),('initiative',0,520,530,'en',0,0),('initiative',0,521,531,'en',0,0),('initiative',0,522,532,'en',0,0),('initiative',0,523,533,'en',0,1),('initiative',0,524,534,'en',0,0),('initiative',0,525,535,'en',0,0),('initiative',0,526,536,'en',0,0),('initiative',0,527,537,'en',0,0),('initiative',0,528,538,'en',0,0),('initiative',0,529,539,'en',0,0),('initiative',0,530,540,'en',0,1),('initiative',0,531,541,'en',0,0),('initiative',0,534,544,'en',0,0),('initiative',0,535,545,'en',0,1),('initiative',0,536,546,'en',0,0),('initiative',0,537,547,'en',0,0),('initiative',0,538,548,'en',0,0),('initiative',0,539,549,'en',0,0),('initiative',0,540,550,'en',0,0),('initiative',0,541,551,'en',0,0),('initiative',0,542,552,'en',0,0),('initiative',0,543,553,'en',0,1),('initiative',0,544,554,'en',0,0),('initiative',0,545,555,'en',0,0),('initiative',0,546,556,'en',0,0),('initiative',0,555,565,'en',0,0),('initiative',0,556,566,'en',0,0),('initiative',0,557,567,'en',0,0),('initiative',0,564,582,'en',0,0),('initiative',0,572,599,'en',0,0),('initiative',0,589,616,'en',0,0),('initiative',0,590,617,'en',0,0),('initiative',0,592,621,'en',0,0),('initiative',0,593,622,'en',0,0);

--
-- Table structure for table `node_revision__field_initiative`
--

CREATE TABLE `node_revision__field_initiative` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_initiative_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_initiative_target_id` (`field_initiative_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_initiative.';

--
-- Dumping data for table `node_revision__field_initiative`
--

INSERT INTO `node_revision__field_initiative` VALUES ('impact_analysis',0,532,542,'en',0,518),('impact_analysis',0,533,543,'en',0,529),('impact_analysis',0,559,577,'en',0,530),('impact_analysis',0,560,578,'en',0,537),('impact_analysis',0,561,579,'en',0,537),('impact_analysis',0,562,580,'en',0,537),('impact_analysis',0,563,581,'en',0,537),('impact_analysis',0,565,583,'en',0,537),('impact_analysis',0,566,584,'en',0,540),('impact_analysis',0,567,585,'en',0,540),('impact_analysis',0,568,586,'en',0,540),('impact_analysis',0,569,587,'en',0,540),('impact_analysis',0,574,601,'en',0,557),('impact_analysis',0,575,602,'en',0,557),('impact_analysis',0,576,603,'en',0,557),('impact_analysis',0,577,604,'en',0,557),('impact_analysis',0,578,605,'en',0,557),('impact_analysis',0,579,606,'en',0,557),('impact_analysis',0,580,607,'en',0,557),('impact_analysis',0,581,608,'en',0,557),('impact_analysis',0,582,609,'en',0,557),('impact_analysis',0,583,610,'en',0,538),('impact_analysis',0,584,611,'en',0,538),('impact_analysis',0,586,613,'en',0,535),('impact_analysis',0,587,614,'en',0,535),('impact_analysis',0,588,615,'en',0,535),('impact_analysis',0,591,620,'en',0,540);

--
-- Table structure for table `node_revision__field_initiative_type`
--

CREATE TABLE `node_revision__field_initiative_type` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_initiative_type_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_initiative_type_value` (`field_initiative_type_value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_initiative…';

--
-- Dumping data for table `node_revision__field_initiative_type`
--

INSERT INTO `node_revision__field_initiative_type` VALUES ('initiative',0,1,7,'en',0,'Project'),('initiative',0,306,314,'en',0,'Programme'),('initiative',0,307,315,'en',0,'Project'),('initiative',0,309,318,'en',0,'Programme'),('initiative',0,310,319,'en',0,'Project'),('initiative',0,516,525,'en',0,'Project'),('initiative',0,518,528,'en',0,'Programme'),('initiative',0,519,529,'en',0,'Programme'),('initiative',0,520,530,'en',0,'Project'),('initiative',0,521,531,'en',0,'Project'),('initiative',0,522,532,'en',0,'Project'),('initiative',0,523,533,'en',0,'Project'),('initiative',0,524,534,'en',0,'Project'),('initiative',0,525,535,'en',0,'Programme'),('initiative',0,526,536,'en',0,'Programme'),('initiative',0,527,537,'en',0,'Project'),('initiative',0,528,538,'en',0,'Programme'),('initiative',0,529,539,'en',0,'Programme'),('initiative',0,530,540,'en',0,'Project'),('initiative',0,531,541,'en',0,'Project'),('initiative',0,534,544,'en',0,'Project'),('initiative',0,535,545,'en',0,'Programme'),('initiative',0,536,546,'en',0,'Project'),('initiative',0,537,547,'en',0,'Project'),('initiative',0,538,548,'en',0,'Programme'),('initiative',0,539,549,'en',0,'Project'),('initiative',0,540,550,'en',0,'Project'),('initiative',0,541,551,'en',0,'Programme'),('initiative',0,542,552,'en',0,'Programme'),('initiative',0,543,553,'en',0,'Programme'),('initiative',0,544,554,'en',0,'Project'),('initiative',0,545,555,'en',0,'Project'),('initiative',0,546,556,'en',0,'Programme'),('initiative',0,555,565,'en',0,'Programme'),('initiative',0,556,566,'en',0,'Programme'),('initiative',0,557,567,'en',0,'Project'),('initiative',0,564,582,'en',0,'Project'),('initiative',0,572,599,'en',0,'Programme'),('initiative',0,589,616,'en',0,'Project'),('initiative',0,590,617,'en',0,'Project'),('initiative',0,592,621,'en',0,'Project'),('initiative',0,593,622,'en',0,'Project');

--
-- Table structure for table `node_revision__field_invitation_list`
--

CREATE TABLE `node_revision__field_invitation_list` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_invitation_list_value` varchar(254) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_invitation…';

--
-- Dumping data for table `node_revision__field_invitation_list`
--

INSERT INTO `node_revision__field_invitation_list` VALUES ('webform',0,594,623,'en',0,'vassilakis@open.gr'),('webform',0,594,623,'en',1,'mimia@techlink.gr'),('webform',0,594,623,'en',2,'amimi@open.gr'),('webform',0,594,623,'en',3,'annamimi9@gmail.com'),('webform',0,594,623,'en',4,'costas.vassilakis@gmail.com');

--
-- Table structure for table `node_revision__field_invitation_sent`
--

CREATE TABLE `node_revision__field_invitation_sent` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_invitation_sent_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_invitation_sent_value` (`field_invitation_sent_value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_invitation…';

--
-- Dumping data for table `node_revision__field_invitation_sent`
--

INSERT INTO `node_revision__field_invitation_sent` VALUES ('webform',0,594,623,'en',0,'yes');

--
-- Table structure for table `node_revision__field_invited_list`
--

CREATE TABLE `node_revision__field_invited_list` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_invited_list_value` varchar(254) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_invited_list.';

--
-- Dumping data for table `node_revision__field_invited_list`
--

INSERT INTO `node_revision__field_invited_list` VALUES ('webform',0,594,623,'en',0,'mimia@techlink.gr'),('webform',0,594,623,'en',1,'amimi@open.gr'),('webform',0,594,623,'en',2,'annamimi9@gmail.com'),('webform',0,594,623,'en',3,'vassilakis@open.gr'),('webform',0,594,623,'en',4,'costas.vassilakis@gmail.com');

--
-- Table structure for table `node_revision__field_limitations`
--

CREATE TABLE `node_revision__field_limitations` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_limitations_value` longtext NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_limitations.';

--
-- Dumping data for table `node_revision__field_limitations`
--

INSERT INTO `node_revision__field_limitations` VALUES ('indicator',0,399,408,'en',0,'The information and data required to produce this indicator could not be easy to find, particularly if there is no formal policy regarding intellectual property.'),('indicator',0,400,409,'en',0,'Comprehensiveness might come at the expense of producing overburdening information.'),('indicator',0,401,410,'en',0,'The indicator does not provide information on the quality of the audit conducted.'),('indicator',0,402,411,'en',0,'Comprehensiveness might come at the expense of overburdening information.'),('indicator',0,403,412,'en',0,'Providing a thorough description might require a large amount of information.'),('indicator',0,404,413,'en',0,'Providing a thorough description might require a large amount of information.'),('indicator',0,405,414,'en',0,'Accurately disaggregating the economic value and attributing it to stakeholders might be difficult and time-consuming.'),('indicator',0,406,415,'en',0,'Althought the ROI specific for health reseach can provide valuable economic and financial information, its calculation might be difficult for some initiatives/projects.'),('indicator',0,407,416,'en',0,'Estimating the direct operating income directly attributed to the exploitation of research findings might be difficult due to the complexity of allocating the operating expenses that are directly related to their obtention. If the initiative/project cannot estimate them, it can use the overall operating income as proxy if its main activity is performing research.'),('indicator',0,408,417,'en',0,'The indicator only evaluates the economic return of patents, but it does not capture the actual effect that the application of patents has on patients.'),('indicator',0,409,418,'en',0,'The indicator requires that all costs and benefits can be identified and appropriately quantified. Assessing monetary values of health outcomes can be difficult.'),('indicator',0,410,419,'en',0,'The indicator only evaluates the economic return of patents, but it does not capture their actual application.'),('indicator',0,411,420,'en',0,'The indicator does not reflect the quality or impact of projects. It needs to be complemented with that information.'),('indicator',0,412,421,'en',0,'The indicator does not account for the products/treatments\' efficacy or impact on patients nor society. It needs to be complemented.'),('indicator',0,413,422,'en',0,'Difficulties in performing the survey and reaching the proper stakeholders.'),('indicator',0,414,423,'en',0,'There might be difficulties in attribution issues regarding costs included in the calculation and indirect costs involved in the production process.'),('indicator',0,415,424,'en',0,'The uncertainty of estimations and the differences in choices of measurement of costs and benefits significantly impact the interpretation of the information. Difficulty of attributing the specific contribution to cost saving of the initiative/project.'),('indicator',0,416,425,'en',0,'The indicator does not inform about the effects on the initiative/project (possibility of wrong judgements). The indicator is particularly relevant for pharma industry.'),('indicator',0,417,426,'en',0,'The indicator does not inform about the quality and long-term horizon of the jobs created.'),('indicator',0,419,428,'en',0,'Combining the data from different sources could be difficult.'),('indicator',0,420,429,'en',0,'Failure to prescribe drugs can also indicate lack of availability in some settings, and this need for local interpretation requires that this be a complementary indicator.'),('indicator',0,421,430,'en',0,'This indicator requires the direct engagement of the research initiative/project and health administrative bodies to identify the development and/or improvement of governance models.'),('indicator',0,422,431,'en',0,'It is hard to estimate and collect data. It needs precise clarification of which impacts are going to be assessed.'),('indicator',0,423,432,'en',0,'Not all individuals participate in screening, so the sample may be biased towards those who care about their health.'),('indicator',0,424,433,'en',0,'The availability of digital technologies may vary depending on the scale and relevance of the initiative/project.'),('indicator',0,425,434,'en',0,'Estimating the denominatar and numerator of the indicator might be complicated and time consuming.'),('indicator',0,426,435,'en',0,'Data disclosed by company needs to be verified by an independent third party.'),('indicator',0,427,436,'en',0,'Quality of data might vary across regions.'),('indicator',0,428,437,'en',0,'Data availability might prove problematic. Percentage does not tell much about the multidisciplinary interventions or their effectiveness.'),('indicator',0,429,438,'en',0,'The indicator requires gathering data from several training providers.'),('indicator',0,431,440,'en',0,'Quality indicators are not a direct measure of quality, because quality is multidimensional requiring many different indicators.'),('indicator',0,432,441,'en',0,'Requires large amount of information on long timescale. Risk is assessed at population level not an individual patient level.'),('indicator',0,433,442,'en',0,'It might be difficult to identify all potentially preventable hospitalisations. Some hospitalisations may not be avoidable. The term \"preventable\" might be understood at different levels for different stakeholders.'),('indicator',0,434,443,'en',0,'Health and safety are relative concepts. The plans developed describe only the risks detected under certain circumstances. Reporting might be time-consuming requiring large amount of data collection.'),('indicator',0,435,444,'en',0,'The indicator has a limited end-user perspective. It does not consider how useful guidelines are for patients.'),('indicator',0,436,445,'en',0,'Calculating QALY or cost effectiveness thresholds is particularly complex. The calculation methodology may need refinement to realize the financial advantages and opportunity costs. '),('indicator',0,437,446,'en',0,'Assessing if a given intervention has contributed to reducing mortality rates among PwMS might be difficult.'),('indicator',0,438,447,'en',0,'Qualitative information is difficult to express in a uniform, comparable fashion.'),('indicator',0,439,448,'en',0,'The measurement of patient satisfaction is disease-specific.'),('indicator',0,440,449,'en',0,'The breath of the information that might be included under this indicator makes it difficult to encapsulate it in a particular format.'),('indicator',0,441,450,'en',0,'Comprehensiveness might come at the expense of producing overburdening information.'),('indicator',0,442,451,'en',0,'The indicator can be used for academic gaming, encouraging researchers to publish papers in high-impact journals and to ignore national channels (valuable for community/society). If the initiative publishes interdisciplinary research across different research areas, the indicator could be difficult to compare (differences of publication cultures/subject areas/research fieds, language used).'),('indicator',0,443,452,'en',0,'The indicator does not account for the long-term relationship of collaborations and whether they have been stable over time.'),('indicator',0,444,453,'en',0,'When interpreting this indicator, users need to consider that publication fees may prevent publishing in open access journals. The possibilities of publishing in open access varies across research topics (number of OA journals). Therefore, some initiatives/projects might have low or null values in this indicator due to the difficulties mentioned above.\r\nThe data can be provided in a graphic (see example).'),('indicator',0,445,454,'en',0,'Although the indicator informs about the level of use of anticipatory design it does not inform the impact of these techniques for patients. It needs to be complemented with additional information.'),('indicator',0,446,455,'en',0,'Citations is just one dimension of the quality of publications. Not all citations are necessarily recorded since not all publications are indexed.'),('indicator',0,447,456,'en',0,'Calculation requires a complex formula and additional citation searching.'),('indicator',0,448,457,'en',0,'Citations may not reflect what is considered valuable in academic terms (basic research)'),('indicator',0,449,458,'en',0,'The indicator does no inform about the quality or intensity of activities. This limitation can be solved considering the quality and the number of participants in the activities.'),('indicator',0,450,459,'en',0,'The indicator does not capture the scope of communication (e.g., how many people have been reached).'),('indicator',0,451,460,'en',0,'The selection of adequate analytic tool/competence needed and the time spent for analysis.'),('indicator',0,452,461,'en',0,'Although the indicator informs about the compliance with clinical guidelines, it does not offer assurance of compliance level. Other limitations are the difficulty and cost of data collection.'),('indicator',0,453,462,'en',0,'The information disclosed in this indicator might be difficult to interpret for layperson stakeholders. To overcome this issue, the description should be clear and try to avoid complicated technical jargon to simplify its understading.'),('indicator',0,454,463,'en',0,'This indicator measures procedures and performance. If bureaucracy timings of the ethical committee are slow this indicator can become too time consuming.'),('indicator',0,455,464,'en',0,'This indicator is descriptive. It might be limited by the fact that it does not include measures of deviation from values, principles, standards and norms of behavior.'),('indicator',0,456,465,'en',0,'Comprehensiveness might come at the expense of producing overburdening information.'),('indicator',0,457,466,'en',0,'The indicator does not account for the success of the research funded with the grants.'),('indicator',0,458,467,'en',0,'The indicator does not inform about the quality or intensity of the collaboration.'),('indicator',0,459,468,'en',0,'The indicator does not inform about the quality or intensity of the public engagement.'),('indicator',0,460,469,'en',0,'The indicator requires a large amount of information.'),('indicator',0,461,470,'en',0,'Comprehensiveness might come at the expense of producing overburdening information.'),('indicator',0,462,471,'en',0,'Comprehensiveness might come at the expense of producing overburdening information.'),('indicator',0,463,472,'en',0,'Comprehensiveness in describing the changes might come at the expense of producing overburdening information.'),('indicator',0,464,473,'en',0,'The indicator does not inform about the quality of research.'),('indicator',0,465,474,'en',0,'Comprehensiveness might come at the expense of producing overburdening information.'),('indicator',0,467,476,'en',0,'The indicator may not reflect the same level of outcomes compared to academic results.'),('indicator',0,468,477,'en',0,'Comprehensiveness might come at the expense of detailed information. It is difficult to evaluate the accuracy and update of information.'),('indicator',0,469,478,'en',0,'The successful implementation of new clinical practices resulting from research outcomes is time consuming and it may take several years before the impact of research is perceived.'),('indicator',0,470,479,'en',0,'In some cases, it might be difficult for the initiative to calculate the actual number of patents that are being applied by the pharma industry. In these situations, the initiative/project should only consider those with evidence proving its actual application.'),('indicator',0,471,480,'en',0,'This indicator evaluates intellectual property sharing, but it does not assess whether the sharing actually leads to new significant discoveries.'),('indicator',0,472,481,'en',0,'This indicator does not evaluate whether or not the patents are being actually applied.'),('indicator',0,473,482,'en',0,'This indicator can give insufficient credit to basic science.\r\nThis indicator could be invalid for research projects not involving clinical trials (rehabilitation, e-Health ICT development, etc).'),('indicator',0,474,483,'en',0,'Comprehensiveness might come at the expense of detailed information. It is difficult to evaluate the accuracy and update of information.'),('indicator',0,475,484,'en',0,'The indicator does not tell about the usefulness of the products for users or their actual influence on patients and their recovery.'),('indicator',0,476,485,'en',0,'The indicator does not inform about the usefulness of the therapeutic advances or their actual influence on patients and their recovery.'),('indicator',0,478,487,'en',0,'The indicator describes the potential effect of new developments, but it does not offer information on their actual effect on patients.'),('indicator',0,479,488,'en',0,'The indicator does not inform about the quality or intensity of collaboration. '),('indicator',0,480,489,'en',0,'The indicator does not tell much about the quality or intensivity of involvement.'),('indicator',0,481,490,'en',0,'The indicator does not tell much about the success of the application efforts.'),('indicator',0,482,491,'en',0,'It needs to be calculated at the individual level (single researchers) and then aggregated at organizational level.'),('indicator',0,483,492,'en',0,'The indicator needs to be calculated at individual level (single researchers or specific programes) and then aggregated at initiative/project level.'),('indicator',0,484,493,'en',0,'The indicator assimilates the contribution to human capital of all people within the same category.'),('indicator',0,485,494,'en',0,'Comprehensiveness might come at the expense of producing overburdening information.'),('indicator',0,486,495,'en',0,'The indicator does not consider the existence of policies to enhance women representation.'),('indicator',0,487,496,'en',0,'The indicator does not consider the existence of policies to enhance women representation.'),('indicator',0,488,497,'en',0,'The company needs to clearly allocate costs to each research project.'),('indicator',0,490,499,'en',0,'The indicator is hard to define, with a lot of possible variation and its outputs are so intangible that it is not possible to come up with a single universal assessment system.'),('indicator',0,491,500,'en',0,'This indicator might require the disclosure of large amounts of information. Additionally, the governance model might be different among research bodies, which could hinder their comparison. To overcome this obstacles, the governance model established by MULTI-ACT might work as a benchmark when producing this indicator.'),('indicator',0,492,501,'en',0,'This indicator provides one way to analyze the relevance of research findings to clinical practice. Stakeholders should be aware about the fact that few or none outreach visits have been paid does not necessarily imply that the practical relevance of research findings is low.'),('indicator',0,493,502,'en',0,'The development of new methodologies might not always be related to future impacts. Therefore, the quality of the methodological improvements needs to be assessed.'),('indicator',0,494,503,'en',0,'The indicator does not tell much about the quality or intensity of collaboration. The perspective/experience of target groups is missing.'),('indicator',0,495,504,'en',0,'The indicator does not provide information on the quality or intensity of the engagement.'),('indicator',0,496,505,'en',0,'The indicator does not provide information on the quality of the engagement.'),('indicator',0,497,506,'en',0,'Computing the indicator requires the use of surveys and interviews to identify the social perception of research.'),('indicator',0,498,507,'en',0,'This indicator measures procedures but not performance (results).'),('indicator',0,499,508,'en',0,'This indicator can suffer for the unclear definition of \"infection\". The idea is to keep this indicator broad and it would consider all sort of accidents.'),('indicator',0,500,509,'en',0,'The information is mainly qualitative, which can be difficult to compare between initiatives/projects.'),('indicator',0,501,510,'en',0,'Employee turnover could be misleading in this sector, as mobility could be a problem, but excellence in research also requires the mobility of talent.'),('indicator',0,503,512,'en',0,'It can be challenging to distinguish how specific research informs a particular policy.'),('indicator',0,504,513,'en',0,'Identifying best practices to adopt improving measures can be time consuming. It requires the establishment of effective identification methodologies.'),('indicator',0,505,514,'en',0,'The breath of the information that might be included under this indicator may be general information about stakeholder engagement.'),('indicator',0,506,515,'en',0,'Informing about the results of environmental audits can be compromising.'),('indicator',0,507,516,'en',0,'This is a rough indicator to measure eco-efficiency. Difficulty in obtaining all the information necessary.'),('indicator',0,508,517,'en',0,'Difficulty in obtaining all the information necessary to calculate GHG emissions for research.'),('indicator',0,509,518,'en',0,'The indicator does not reveal the effectiveness or content of the community development and the engagement actions taken.'),('indicator',0,512,521,'en',0,'Although the indicator informs about the consideration of RRI standards, it does not offers assurance of whether or not the consideration is being effective.'),('indicator',0,547,557,'en',0,'The indicator does not provide information about the quality or intensity of the engagement.'),('indicator',0,548,558,'en',0,'The indicator might be negative in many case which does not necessarily imply lack of transparency. Producing external information could be costly and some research initiatives/projects might not be able to do it.'),('indicator',0,549,559,'en',0,'The measurement of patient satisfaction is diagnosis-specific. '),('indicator',0,550,560,'en',0,'The measurement of patient satisfaction is diagnosis-specific. '),('indicator',0,551,561,'en',0,'The measurement of patient satisfaction is diagnosis-specific. '),('indicator',0,552,562,'en',0,'The measurement of patient satisfaction is diagnosis-specific. '),('indicator',0,553,563,'en',0,'The measurement of patient satisfaction is diagnosis-specific. '),('indicator',0,554,564,'en',0,'The measurement of patient satisfaction is diagnosis-specific. '),('indicator',0,585,612,'en',0,'The measurement of patient satisfaction is diagnosis-specific. ');

--
-- Table structure for table `node_revision__field_links`
--

CREATE TABLE `node_revision__field_links` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_links_value` longtext NOT NULL,
  `field_links_format` varchar(255) CHARACTER SET ascii DEFAULT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_links_format` (`field_links_format`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_links.';

--
-- Dumping data for table `node_revision__field_links`
--

INSERT INTO `node_revision__field_links` VALUES ('indicator',0,403,412,'en',0,'<p>Kalucy, E. C., Jackson-Bowers, E., McIntyre, E., &amp; Reed, R. (2009). The feasibility of determining the impact of primary health care research projects using the Payback Framework.&nbsp;<em>Health Research Policy and Systems</em>,&nbsp;<em>7</em>(1), 11.</p>\r\n\r\n<p>See Table 1.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://link.springer.com/article/10.1186/1478-4505-7-11\">https://link.springer.com/article/10.1186/1478-4505-7-11</a></p>\r\n','basic_html'),('indicator',0,404,413,'en',0,'<p>GRI Standards 2016. GRI 203:&nbsp;Indirect Economic Impacts.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.globalreporting.org/standards/gri-standards-download-center/gri-203-indirect-economic-impacts/\">https://www.globalreporting.org/standards/gri-standards-download-center/gri-203-indirect-economic-impacts/</a></p>\r\n','basic_html'),('indicator',0,406,415,'en',0,'<p>For more information on how to compute the ROI specific for health research, see&nbsp;KPMG, Economic Impact of Medical Research in Australia (2018).</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://aamri.org.au/wp-content/uploads/2018/10/Economic-Impact-of-Medical-Research-exec-summary.pdf\">https://aamri.org.au/wp-content/uploads/2018/10/Economic-Impact-of-Medical-Research-exec-summary.pdf</a></p>\r\n','basic_html'),('indicator',0,407,416,'en',0,'<p>Shabaninejad, H., Mirsalehian, M. H., &amp; Mehralian, G. (2014). Development of an integrated performance measurement (PM) model for pharmaceutical industry.&nbsp;<em>Iranian Journal of Pharmaceutical Research: IJPR</em>,&nbsp;<em>13</em>(Suppl), 207.</p>\r\n\r\n<p>See Table 4.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3977072/\">https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3977072/</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Process to calculate it considering the information provided in financial statements. For instance, in the&nbsp;Burnet Institute 2018 Financial Report,&nbsp;divide \"total liabilities\" (p. 10) by \"results from operating activity\" (p. 9) times 100.</p>\r\n\r\n<p>The&nbsp;Burnet Institute 2018 Financial Report is available at:&nbsp;<a href=\"https://www.burnet.edu.au/system/annual_report/file/25/Financial_Report_2018_-_digital.pdf\">https://www.burnet.edu.au/system/annual_report/file/25/Financial_Report_2018_-_digital.pdf</a></p>\r\n','basic_html'),('indicator',0,408,417,'en',0,'<p>Banzi, R., Moja, L., Pistotti, V., Facchini, A., &amp; Liberati, A. (2011). Conceptual frameworks and empirical approaches used to assess the impact of health research: an overview of reviews.&nbsp;<em>Health Research Policy and Systems</em>,&nbsp;<em>9</em>(1), 26.</p>\r\n\r\n<p>See Table 2.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://link.springer.com/article/10.1186/1478-4505-9-26\">https://link.springer.com/article/10.1186/1478-4505-9-26</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Example on how to calculate it: Sanofi 2018 Annual report: divide \"other intangible assets\" (see note D.35.3 - page F111) by &nbsp;\"carrying amount of products, trademarks and other rights\" (see note D.4 - page F44)<br />\r\nIf the indicator is difficult to calculate to some initiatives, it could be simplified by dividing the revenues obtained from the exploitation of patents and intellectual property rights by the total number of patents/intellectual property rights owned by &nbsp;the initiative.<br />\r\n&nbsp;</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.sanofi.com/-/media/Project/One-Sanofi-Web/Websites/Global/Sanofi-COM/Home/common/docs/investors/Sanofi-20-F-2018-EN-PDF-e-accessible_01.pdf?la=en&amp;hash=6AC303E769D68FF95508C93D1CBF6F1A\">https://www.sanofi.com/-/media/Project/One-Sanofi-Web/Websites/Global/Sanofi-COM/Home/common/docs/investors/Sanofi-20-F-2018-EN-PDF-e-accessible_01.pdf?la=en&amp;hash=6AC303E769D68FF95508C93D1CBF6F1A</a></p>\r\n','basic_html'),('indicator',0,413,422,'en',0,'<p>Krizanova, A., Gajanova, L., &amp; Nadanyiova, M. (2018). Design of a CRM level and performance measurement model.&nbsp;<em>Sustainability</em>,&nbsp;<em>10</em>(7), 2567.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.mdpi.com/2071-1050/10/7/2567\">https://www.mdpi.com/2071-1050/10/7/2567</a></p>\r\n','basic_html'),('indicator',0,414,423,'en',0,'<p>Parisi, C. (2013). The Use of Causal Mapping in the Design of Sustainability Performance Measurement Systems: Evidence from Novo Nordisk.&nbsp;<em>Studies in Managerial and Financial Accounting</em>,&nbsp;<em>26</em>, 231-264.</p>\r\n\r\n<p>See Figure 2.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.emerald.com/insight/content/doi/10.1108/S1479-3512(2013)0000026007/full/html\">https://www.emerald.com/insight/content/doi/10.1108/S1479-3512(2013)0000026007/full/html</a></p>\r\n','basic_html'),('indicator',0,415,424,'en',0,'<p>Kuruvilla, S., Mays, N., Pleasant, A., &amp; Walt, G. (2006). Describing the impact of health research: a Research Impact Framework.&nbsp;<em>BMC Health Services Research</em>,&nbsp;<em>6</em>(1), 134.</p>\r\n\r\n<p>See p. 12</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://link.springer.com/article/10.1186/1472-6963-6-134\">https://link.springer.com/article/10.1186/1472-6963-6-134</a></p>\r\n','basic_html'),('indicator',0,416,425,'en',0,'<p>Access to Medicine Index 2018 - Methodology Report<br />\r\nIndicator D.III.5&nbsp;(p. 50).<br />\r\nAvailable at: <a href=\"https://accesstomedicineindex.org/media/atmi/2017-Methodology-2018-Access-to-Medicine-Index.pdf\">https://accesstomedicineindex.org/media/atmi/2017-Methodology-2018-Access-to-Medicine-Index.pdf</a></p>\r\n','basic_html'),('indicator',0,421,430,'en',0,'<p>Department of Health and Human Services. Victoria State Government.</p>\r\n\r\n<p>Available at:&nbsp;<em><a href=\"https://fac.dhhs.vic.gov.au/policies-and-procedures\">https://fac.dhhs.vic.gov.au/policies-and-procedures</a></em></p>\r\n','basic_html'),('indicator',0,422,431,'en',0,'<p>Oortwijn, W. J., Hanney, S. R., Ligtvoet, A., Hoorens, S., Wooding, S., Grant, J., ... &amp; Bouter, L. M. (2008). Assessing the impact of health technology assessment in the Netherlands.&nbsp;<em>International Journal of Technology Assessment in Health Care</em>,&nbsp;<em>24</em>(3), 259-269.</p>\r\n\r\n<p>See Table 1. Sections 5a and 5b.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.rand.org/pubs/external_publications/EP20080616.html?src=mobile\">https://www.rand.org/pubs/external_publications/EP20080616.html?src=mobile</a></p>\r\n','basic_html'),('indicator',0,428,437,'en',0,'<p>Lindström, J., Wikström, K., Maggini, M., Icks, A., Kuske, S., Rothe, U., ... &amp; Zaletel, J. (2015). Quality indicators for diabetes prevention programs in health care targeted at people at high risk.&nbsp;<em>Annali dell\'Istituto Superiore di Sanità</em>,&nbsp;<em>51</em>, 187-191.</p>\r\n\r\n<p>See Table 1.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.scielosp.org/article/aiss/2015.v51n3/187-191/en/\">https://www.scielosp.org/article/aiss/2015.v51n3/187-191/en/</a></p>\r\n','basic_html'),('indicator',0,431,440,'en',0,'<p>Kuruvilla, S., Mays, N., Pleasant, A., &amp; Walt, G. (2006). Describing the impact of health research: a Research Impact Framework.&nbsp;<em>BMC Health Services Research</em>,&nbsp;<em>6</em>(1), 134.</p>\r\n\r\n<p>See p.11</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://link.springer.com/article/10.1186/1472-6963-6-134\">https://link.springer.com/article/10.1186/1472-6963-6-134</a></p>\r\n','basic_html'),('indicator',0,434,443,'en',0,'<p>Department of Health and Human Services. Victoria State Government (2012).&nbsp;Children with problem sexual behaviours and their families.&nbsp;Best interests case practice model Specialist practice resource.</p>\r\n\r\n<p>See p. 46.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.dhhs.vic.gov.au/sites/default/files/documents/201705/Children_with_problem_sexual_behaviours_-and-_their_families-2012_0.pdf\">https://www.dhhs.vic.gov.au/sites/default/files/documents/201705/Children_with_problem_sexual_behaviours_-and-_their_families-2012_0.pdf</a></p>\r\n','basic_html'),('indicator',0,438,447,'en',0,'<p>Ng, J., Scahill, S., &amp; Harrison, J. (2018). Stakeholder views do matter: a conceptual framework for medication safety measurement.&nbsp;<em>Journal of Pharmaceutical Health Services Research</em>,&nbsp;<em>9</em>(1), 21-31.</p>\r\n\r\n<p>See Table 2.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://onlinelibrary.wiley.com/doi/abs/10.1111/jphs.12203\">https://onlinelibrary.wiley.com/doi/abs/10.1111/jphs.12203</a></p>\r\n','basic_html'),('indicator',0,445,454,'en',0,'<p>Yaghmaei, E. (2018). Responsible research and innovation key performance indicators in industry.&nbsp;<em>Journal of Information, Communication and Ethics in Society 16</em>(2).</p>\r\n\r\n<p>See Table IV.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.emerald.com/insight/content/doi/10.1108/JICES-11-2017-0066/full/html\">https://www.emerald.com/insight/content/doi/10.1108/JICES-11-2017-0066/full/html</a></p>\r\n','basic_html'),('indicator',0,446,455,'en',0,'<p>More information on the use of Google Scholar to estimate the impact of research:</p>\r\n\r\n<p>Van Aalst, Jan. \"Using Google Scholar to estimate the impact of journal articles in education.\"&nbsp;<em>Educational Researcher</em>&nbsp;39.5 (2010): 387-400.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://journals.sagepub.com/doi/full/10.3102/0013189X10371120\">https://journals.sagepub.com/doi/full/10.3102/0013189X10371120</a></p>\r\n','basic_html'),('indicator',0,447,456,'en',0,'<p>Innovative Medicine Initiative (2012).&nbsp;Bibliometric analysis of ongoing projects: Innovative Medicines Initiative Joint Undertaking (IMI).</p>\r\n\r\n<p>See p. 11</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.imi.europa.eu/sites/default/files/uploads/documents/reference-documents/IMI%20JU%20Bibliometric%20Report%201_FINAL.pdf\">https://www.imi.europa.eu/sites/default/files/uploads/documents/reference-documents/IMI%20JU%20Bibliometric%20Report%201_FINAL.pdf</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>Carley S, &amp; Porter A (2012). A forward diversity index. Scientometrics, 90:407-427. Available at: <a href=\"https://link.springer.com/article/10.1007/s11192-011-0528-1\">https://link.springer.com/article/10.1007/s11192-011-0528-1</a></p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<p>See a bibliometric analysis of citations of papers in differentes disciplines by&nbsp;Innovative Medicines Initiative Joint Undertaking (IMI)&nbsp;( p. 25).&nbsp;This data can be used to compute the indicator. Available at:&nbsp;<a href=\"https://www.imi.europa.eu/sites/default/files/uploads/documents/reference-documents/IMI%20JU%20Bibliometric%20Report%201_FINAL.pdf\">https://www.imi.europa.eu/sites/default/files/uploads/documents/reference-documents/IMI%20JU%20Bibliometric%20Report%201_FINAL.pdf</a></p>\r\n','basic_html'),('indicator',0,448,457,'en',0,'<p>Sarli, C. C., Dubinsky, E. K., &amp; Holmes, K. L. (2010). Beyond citation analysis: a model for assessment of research impact.&nbsp;<em>Journal of the Medical Library Association: JMLA</em>,&nbsp;<em>98</em>(1), 17.</p>\r\n\r\n<p>See Table 3.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2801963/\">https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2801963/</a></p>\r\n','basic_html'),('indicator',0,450,459,'en',0,'<p>JPND (2016). Recalibrated Monitoring and Evaluation Framework for the EU Joint Programme – Neurodegenerative Disease Research.<br />\r\nSee outcome 44 (p. 10)<br />\r\nAvailable at: <a href=\"https://www.neurodegenerationresearch.eu/wp-content/uploads/2012/05/2016-JPND-Recalibrated-Monitoring-and-Evaluation-Framework.pdf\">https://www.neurodegenerationresearch.eu/wp-content/uploads/2012/05/2016-JPND-Recalibrated-Monitoring-and-Evaluation-Framework.pdf</a></p>\r\n','basic_html'),('indicator',0,451,460,'en',0,'<p>Sarli, C. C., Dubinsky, E. K., &amp; Holmes, K. L. (2010). Beyond citation analysis: a model for assessment of research impact.&nbsp;<em>Journal of the Medical Library Association: JMLA</em>,&nbsp;<em>98</em>(1), 17-23.</p>\r\n\r\n<p>See Table 2.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2801963/\">https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2801963/</a></p>\r\n','basic_html'),('indicator',0,452,461,'en',0,'<p>Banzi, R., Moja, L., Pistotti, V., Facchini, A., &amp; Liberati, A. (2011). Conceptual frameworks and empirical approaches used to assess the impact of health research: an overview of reviews.&nbsp;<em>Health Research Policy and Systems</em>,&nbsp;<em>9</em>(1), 26.</p>\r\n\r\n<p>See Table 2.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://link.springer.com/article/10.1186/1478-4505-9-26\">https://link.springer.com/article/10.1186/1478-4505-9-26</a></p>\r\n\r\n<p>&nbsp;</p>\r\n','basic_html'),('indicator',0,453,462,'en',0,'<p>Yaghmaei, E. (2018). Responsible research and innovation key performance indicators in industry.&nbsp;<em>Journal of Information, Communication and Ethics in Society 16</em>(2).</p>\r\n\r\n<p>See Table V.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.emerald.com/insight/content/doi/10.1108/JICES-11-2017-0066/full/html\">https://www.emerald.com/insight/content/doi/10.1108/JICES-11-2017-0066/full/html</a></p>\r\n\r\n<p>&nbsp;</p>\r\n','basic_html'),('indicator',0,455,464,'en',0,'<p>GRI Standards 2016. General Disclosures.</p>\r\n\r\n<p>Disclosure&nbsp;102-16 Values, principles, standards, and norms of behavior.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.globalreporting.org/standards/gri-standards-download-center/gri-102-general-disclosures/\">https://www.globalreporting.org/standards/gri-standards-download-center/gri-102-general-disclosures/</a></p>\r\n','basic_html'),('indicator',0,456,465,'en',0,'<p>MoRRI – The Evolution and Benefits of Responsible Research and Innovation.<br />\r\nSee p. 74<br />\r\nAvailable at: <a href=\"https://op.europa.eu/en/publication-detail/-/publication/2c5a0fb6-c070-11e8-9893-01aa75ed71a1\">https://op.europa.eu/en/publication-detail/-/publication/2c5a0fb6-c070-11e8-9893-01aa75ed71a1</a></p>\r\n','basic_html'),('indicator',0,461,470,'en',0,'<p>Innovative Medicines Initiative (2018). Annual Activity Report 2017.</p>\r\n\r\n<p>See&nbsp;IMI2 KPI 11</p>\r\n\r\n<p>Available at:<a href=\" https://www.imi.europa.eu/sites/default/files/uploads/documents/About-IMI/Governance/Governing-Board/IMI2-GB-DEC-2018-17_Decision%20AAR%202017-GB%20Assessment_signed%2026JUN.pdf\">&nbsp;https://www.imi.europa.eu/sites/default/files/uploads/documents/About-IMI/Governance/Governing-Board/IMI2-GB-DEC-2018-17_Decision%20AAR%202017-GB%20Assessment_signed%2026JUN.pdf</a></p>\r\n','basic_html'),('indicator',0,462,471,'en',0,'<p>Innovative Medicines Initiative (2018). Annual Activity Report 2017.</p>\r\n\r\n<p>See&nbsp;IMI2 KPI 18</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.imi.europa.eu/sites/default/files/uploads/documents/About-IMI/Governance/Governing-Board/IMI2-GB-DEC-2018-17_Decision%20AAR%202017-GB%20Assessment_signed%2026JUN.pdf\">https://www.imi.europa.eu/sites/default/files/uploads/documents/About-IMI/Governance/Governing-Board/IMI2-GB-DEC-2018-17_Decision%20AAR%202017-GB%20Assessment_signed%2026JUN.pdf</a></p>\r\n','basic_html'),('indicator',0,464,473,'en',0,'<p>Oortwijn, W. J., Hanney, S. R., Ligtvoet, A., Hoorens, S., Wooding, S., Grant, J., ... &amp; Bouter, L. M. (2008). Assessing the impact of health technology assessment in the Netherlands.&nbsp;<em>International Journal of Technology Assessessment in Health Care</em>,&nbsp;<em>24</em>(3), 259-269.</p>\r\n\r\n<p>See Table 1 (section 2b)</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.rand.org/pubs/external_publications/EP20080616.html?src=mobile\">https://www.rand.org/pubs/external_publications/EP20080616.html?src=mobile</a></p>\r\n','basic_html'),('indicator',0,465,474,'en',0,'<p>CAHS (2009). Making an impact.&nbsp;A Preferred Framework and Indicators to Measure Returns on Investment in Health Research.&nbsp;Report of the Panel on the Return on Investments in Health Research January 2009.</p>\r\n\r\n<p>See p. 109</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.cahs-acss.ca/wp-content/uploads/2011/09/ROI_FullReport.pdf\">https://www.cahs-acss.ca/wp-content/uploads/2011/09/ROI_FullReport.pdf</a></p>\r\n','basic_html'),('indicator',0,467,476,'en',0,'<p>JPND (2016).&nbsp;Recalibrated Monitoring and Evaluation Framework for the EU Joint Programme&nbsp;–&nbsp;Neurodegenerative Disease Research.</p>\r\n\r\n<p>See outcome 13 (p. 12)</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.neurodegenerationresearch.eu/wp-content/uploads/2012/05/2016-JPND-Recalibrated-Monitoring-and-Evaluation-Framework.pdf\">https://www.neurodegenerationresearch.eu/wp-content/uploads/2012/05/2016-JPND-Recalibrated-Monitoring-and-Evaluation-Framework.pdf</a></p>\r\n','basic_html'),('indicator',0,468,477,'en',0,'<p>MoRRI – The Evolution and Benefits of Responsible Research and Innovation.</p>\r\n\r\n<p>See p. 78</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://op.europa.eu/en/publication-detail/-/publication/2c5a0fb6-c070-11e8-9893-01aa75ed71a1\">https://op.europa.eu/en/publication-detail/-/publication/2c5a0fb6-c070-11e8-9893-01aa75ed71a1</a></p>\r\n','basic_html'),('indicator',0,469,478,'en',0,'<p>Weiss, A. P. (2007). Measuring the impact of medical research: moving from outputs to outcomes.&nbsp;<em>American Journal of Psychiatry</em>,&nbsp;<em>164</em>(2), 206-214.</p>\r\n\r\n<p>See pp. 208-209.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://ajp.psychiatryonline.org/doi/abs/10.1176/ajp.2007.164.2.206\">https://ajp.psychiatryonline.org/doi/abs/10.1176/ajp.2007.164.2.206</a></p>\r\n','basic_html'),('indicator',0,470,479,'en',0,'<p>D’Este, P., Tribó, J. A., &amp; García-Romero, A. (2008). Colaboración con universidades y desempeño innovador en la industria farmacéutica española (2003-2005).&nbsp;<em>Medicina Clínica</em>,&nbsp;<em>131</em>, 66-70.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.sciencedirect.com/science/article/pii/S0025775308764108\">https://www.sciencedirect.com/science/article/pii/S0025775308764108</a></p>\r\n','basic_html'),('indicator',0,471,480,'en',0,'<p>Access to Medicine Index 2018 - Methodology Report</p>\r\n\r\n<p>Indicator&nbsp;E.III.2 (p. 51).</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://accesstomedicineindex.org/media/atmi/2017-Methodology-2018-Access-to-Medicine-Index.pdf\">https://accesstomedicineindex.org/media/atmi/2017-Methodology-2018-Access-to-Medicine-Index.pdf</a></p>\r\n','basic_html'),('indicator',0,476,485,'en',0,'<p>ERA-NET NEURON.&nbsp;‘Development and advancement in methods and technologies towards the understanding of brain diseases’ Joint Transnational Call 2009-&nbsp;Impact Report</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"ERA-NET NEURON ‘Development and advancement in methods and technol- ogies towards the understanding of brain diseases’ Joint Transnational Call 2009 Impact Report\">ERA-NET NEURON ‘Development and advancement in methods and technol- ogies towards the understanding of brain diseases’ Joint Transnational Call 2009 Impact Report</a></p>\r\n','basic_html'),('indicator',0,478,487,'en',0,'<p>Ovseiko, P. V., Oancea, A., &amp; Buchan, A. M. (2012). Assessing research impact in academic clinical medicine: a study using Research Excellence Framework pilot impact indicators.&nbsp;<em>BMC Health Services Research</em>,&nbsp;<em>12</em>(1), 1-23.</p>\r\n\r\n<p>See pp. 13-14.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://bmchealthservres.biomedcentral.com/articles/10.1186/1472-6963-12-478\">https://bmchealthservres.biomedcentral.com/articles/10.1186/1472-6963-12-478</a></p>\r\n\r\n<p>&nbsp;</p>\r\n','basic_html'),('indicator',0,479,488,'en',0,'<p>Graham, K. E., Chorzempa, H. L., Valentine, P. A., &amp; Magnan, J. (2012). Evaluating health research impact: Development and implementation of the Alberta Innovates–Health Solutions impact framework.&nbsp;<em>Research Evaluation</em>,&nbsp;<em>21</em>(5), 354-367.</p>\r\n\r\n<p>See Table 1. \"Outreach\" indicator.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://academic.oup.com/rev/article-abstract/21/5/354/1559212\">https://academic.oup.com/rev/article-abstract/21/5/354/1559212</a></p>\r\n','basic_html'),('indicator',0,482,491,'en',0,'<p>Kuruvilla, S., Mays, N., Pleasant, A., &amp; Walt, G. (2006). Describing the impact of health research: a Research Impact Framework.&nbsp;<em>BMC Health Services Research</em>,&nbsp;<em>6</em>(1), 134.</p>\r\n\r\n<p>See p. 7-8.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://link.springer.com/article/10.1186/1472-6963-6-134\">https://link.springer.com/article/10.1186/1472-6963-6-134</a></p>\r\n','basic_html'),('indicator',0,490,499,'en',0,'<p>Loughney, D., Claus, B. L., &amp; Johnson, S. R. (2011). To measure is to know: an approach to CADD performance metrics.&nbsp;<em>Drug Discovery Today</em>,&nbsp;<em>16</em>(13-14), 548-554.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.sciencedirect.com/science/article/pii/S1359644611001462\">https://www.sciencedirect.com/science/article/pii/S1359644611001462</a></p>\r\n','basic_html'),('indicator',0,492,501,'en',0,'<p>Sarli, C. C., Dubinsky, E. K., &amp; Holmes, K. L. (2010). Beyond citation analysis: a model for assessment of research impact.&nbsp;<em>Journal of the Medical Library Association: JMLA</em>,&nbsp;<em>98</em>(1), 17.</p>\r\n\r\n<p>See Table 1.</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2801963/\">https://www.ncbi.nlm.nih.gov/pmc/articles/PMC2801963/</a></p>\r\n\r\n<p>&nbsp;</p>\r\n','basic_html'),('indicator',0,496,505,'en',0,'<p>Graham, K. E., Chorzempa, H. L., Valentine, P. A., &amp; Magnan, J. (2012). Evaluating health research impact: Development and implementation of the Alberta Innovates–Health Solutions impact framework.&nbsp;<em>Research Evaluation</em>,&nbsp;<em>21</em>(5), 354-367.</p>\r\n\r\n<p>Table 1. \"Interactions\" indicator</p>\r\n\r\n<p>Available at:&nbsp;<a href=\"https://academic.oup.com/rev/article/21/5/354/1559212\">https://academic.oup.com/rev/article/21/5/354/1559212</a></p>\r\n','basic_html'),('indicator',0,499,508,'en',0,'<p>Information on injury frequency rate:&nbsp;<a href=\"http://www.hse.gov.uk/statistics/adhoc-analysis/index.htm\">http://www.hse.gov.uk/statistics/adhoc-analysis/index.htm</a></p>\r\n','basic_html'),('indicator',0,503,512,'en',0,'<p>Milat, A. J., Laws, R., King, L., Newson, R., Rychetnik, L., Rissel, C., ... &amp; Bennie, J. (2013). Policy and practice impacts of applied research: a case study analysis of the New South Wales Health Promotion Demonstration Research Grants Scheme 2000–2006.&nbsp;<em>Health research policy and systems</em>,&nbsp;<em>11</em>(1), 5.</p>\r\n\r\n<p>Available at:</p>\r\n\r\n<p><a href=\"https://link.springer.com/article/10.1186/1478-4505-11-5\">https://link.springer.com/article/10.1186/1478-4505-11-5</a></p>\r\n','basic_html'),('indicator',0,504,513,'en',0,'<p>MoRRI (2018).&nbsp;Monitoring the evolution and benefits of responsible Research and Innovation.&nbsp;The evolution of Responsible Research and Innovation&nbsp;–&nbsp;the Indicators report.</p>\r\n\r\n<p>Indicator GOV2</p>\r\n\r\n<p>Available at:</p>\r\n\r\n<p><a href=\"https://op.europa.eu/en/publication-detail/-/publication/2c5a0fb6-c070-11e8-9893-01aa75ed71a1/language-en\">https://op.europa.eu/en/publication-detail/-/publication/2c5a0fb6-c070-11e8-9893-01aa75ed71a1/language-en</a></p>\r\n','basic_html'),('indicator',0,506,515,'en',0,'<p>ISO 14001 provides the guidance for use an environmental management system: &nbsp;<a href=\"https://www.iso.org/standard/60857.html\">https://www.iso.org/standard/60857.html</a></p>\r\n','basic_html'),('indicator',0,507,516,'en',0,'<p>See GRI standards (GRI 301)&nbsp;for more information on how to calculate the indicator:&nbsp;<a href=\"https://www.globalreporting.org/standards/\">https://www.globalreporting.org/standards/</a></p>\r\n','basic_html'),('indicator',0,509,518,'en',0,'<p>GRI Standard 413. Local Communities.</p>\r\n\r\n<p>Available at:</p>\r\n\r\n<p><a href=\"https://www.globalreporting.org/standards/gri-standards-download-center/gri-413-local-communities-2016/\">https://www.globalreporting.org/standards/gri-standards-download-center/gri-413-local-communities-2016/</a></p>\r\n','basic_html'),('indicator',0,512,521,'en',0,'<p>Yaghmaei, E. (2018). Responsible research and innovation key performance indicators in industry.&nbsp;<em>Journal of Information, Communication and Ethics in Society 16 </em>(2), 214-234.</p>\r\n\r\n<p>Available at:&nbsp;</p>\r\n\r\n<p><a href=\"https://www.emerald.com/insight/content/doi/10.1108/JICES-11-2017-0066/full/html\">https://www.emerald.com/insight/content/doi/10.1108/JICES-11-2017-0066/full/html</a></p>\r\n','basic_html'),('indicator',0,549,559,'en',0,'<p><span><span><span><span><span><a href=\"https://pubmed.ncbi.nlm.nih.gov/31659583/\"><span><span><span>https://pubmed.ncbi.nlm.nih.gov/31659583/</span></span></span></a></span></span></span></span></span></p>\r\n','basic_html'),('indicator',0,550,560,'en',0,'<p><span><span><span><span><span><a href=\"https://pubmed.ncbi.nlm.nih.gov/31659583/\"><span><span><span>https://pubmed.ncbi.nlm.nih.gov/31659583/</span></span></span></a></span></span></span></span></span></p>\r\n','basic_html'),('indicator',0,551,561,'en',0,'<p><span><span><span><span><span><a href=\"https://pubmed.ncbi.nlm.nih.gov/31659583/\"><span><span><span>https://pubmed.ncbi.nlm.nih.gov/31659583/</span></span></span></a></span></span></span></span></span></p>\r\n','basic_html'),('indicator',0,552,562,'en',0,'<p><span><span><span><span><span><a href=\"https://pubmed.ncbi.nlm.nih.gov/31659583/\"><span><span><span>https://pubmed.ncbi.nlm.nih.gov/31659583/</span></span></span></a></span></span></span></span></span></p>\r\n','basic_html'),('indicator',0,553,563,'en',0,'<p><span><span><span><span><span><a href=\"https://pubmed.ncbi.nlm.nih.gov/31659583/\"><span><span><span>https://pubmed.ncbi.nlm.nih.gov/31659583/</span></span></span></a></span></span></span></span></span></p>\r\n','basic_html'),('indicator',0,554,564,'en',0,'<p><span><span><span><span><span><a href=\"https://pubmed.ncbi.nlm.nih.gov/31659583/\"><span><span><span>https://pubmed.ncbi.nlm.nih.gov/31659583/</span></span></span></a></span></span></span></span></span></p>\r\n','basic_html');

--
-- Table structure for table `node_revision__field_meta`
--

CREATE TABLE `node_revision__field_meta` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_meta_value` longtext NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_meta.';

--
-- Dumping data for table `node_revision__field_meta`
--

INSERT INTO `node_revision__field_meta` VALUES ('page',0,305,618,'en',0,'a:1:{s:6:\"google\";s:94:\"<meta name=\"google-site-verification\" content=\"XxW8buV32HOTpK6O-m27gG1nha30Ngu6Gm13pOIfGRA\" />\";}'),('page',0,305,619,'en',0,'a:1:{s:6:\"google\";s:43:\"XxW8buV32HOTpK6O-m27gG1nha30Ngu6Gm13pOIfGRA\";}');

--
-- Table structure for table `node_revision__field_method_of_measurement_`
--

CREATE TABLE `node_revision__field_method_of_measurement_` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_method_of_measurement__value` longtext NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_method_of…';

--
-- Dumping data for table `node_revision__field_method_of_measurement_`
--

INSERT INTO `node_revision__field_method_of_measurement_` VALUES ('indicator',0,399,408,'en',0,'Provide a narrative description of the policy of the initiative/project regarding its intelectual property strategy. The initiative/project can provide a link to a document where it is disclosed.'),('indicator',0,400,409,'en',0,'Compute a percentage that accounts for the deviations identified. There are different alternatives:\r\n- Number of projects with cost overrun issues / total number of projects\r\n- Number of projects with schedule overrun issues / total number of projects\r\n- Total cost overrun by all the project / expected cost by all the projects\r\nThis information should ideally compared with the previous year or with targets.'),('indicator',0,401,410,'en',0,'Provide the number of observations/audits performed during the reporting period.\r\nThis information should ideally be compared with the two previous years or with targets.'),('indicator',0,402,411,'en',0,'Provide a narrative description of the economic impact for society of commercializing research outputs, for example, creation of employment, import substitution and drug cost. When possible, provide the monetary value of those impacts (e.g. reduced drug cost).'),('indicator',0,403,412,'en',0,'Provide a narrative description of the economic impact on workforce related to the improvement of employees\' health and wellbeing resulting from the initiative/project\'s research.'),('indicator',0,404,413,'en',0,'Provide a narrative description of how the initiative/project\'s research findings lead to the enhancement of well-being and economic conditions among community members.'),('indicator',0,405,414,'en',0,'Provide a table disaggregating the total direct economic value generated (financial resources obtained - financial resources produced) for each stakeholder type to which the initiative/project relates.'),('indicator',0,406,415,'en',0,'There are two alternative methods. The initiative/project can decide to provide one or both.\r\n1) Specific for health research initiatives: Calculate the percentage that health gains and wider economics gain represent relative to the investment in medical research, with a lag between expenditure and outcomes, adjusting for inflation and discounting at a rate of 5% (More detailed information on how to calculate the ratio is provided in KPMG, Economic Impact of Medical Research in Australia (2018)).\r\n2) General ROI: Calculate the percentage that the income generated by the initiative represents respect to the value of its assets.'),('indicator',0,407,416,'en',0,'Divide the total debt registered in the balance sheet of the initiative/project by the operating income registered in the profit and loss statement that can be directly attributed to research result exploitation, and multiple the result times 100.'),('indicator',0,408,417,'en',0,'Divide the revenues obtained from the exploitation of patents and other intellectual property rights during the reporting period by the total value of the patents and intellectual property registered in the balance sheet of the initiative/project, and multiply the result times 100.'),('indicator',0,409,418,'en',0,'Divide the (discounted) benefits of a project expressed in monetary terms by the (discounted) incremental costs. Monetary benefits can be assessed, for instance, through willingness to pay techniques.'),('indicator',0,410,419,'en',0,'Provide the total amount of income (in euros or the domestic currency of the initiative/project) that the initiative obtained from the exploitation of their patents and other intellectual property rights. For the sake of comparison, the initiative shall report the same figure for the two prior periods.'),('indicator',0,411,420,'en',0,'Provide the number and percentage of strategic/plans completed and milestones met.'),('indicator',0,412,421,'en',0,'Count the number of past/potential products and treatments developed by the initiative/project.'),('indicator',0,413,422,'en',0,'Description of the relationships with stakeholders related to the research initiative/project.\r\nQuantitative scores given by stakeholders in surveys disaggregated by stakeholder type.'),('indicator',0,414,423,'en',0,'Calculate the overall costs per unit divided by the number of units (please note that the unit can vary from products to services and processes).'),('indicator',0,415,424,'en',0,'Provide a narrative description of cost-containment strategies as well as monetary information describing the effectiveness of those strategies. Cost-effectiveness can be studied by analyzing research-related changes in health systems in terms of both expenditure and related health outcomes.'),('indicator',0,416,425,'en',0,'Narrative description and numbers of products tracked and whether this information is publicly disclosed (where, when and why a drug recall has taken place).'),('indicator',0,417,426,'en',0,'Count the total number of job created and expected to be created (i.e. the total number of employees) disaggregated by gender.'),('indicator',0,418,427,'en',0,'Calculate the total number and percentage of employee by age group, gender and region.'),('indicator',0,419,428,'en',0,'Calculate the average number of medications used for a certain disease. Provide the change (increase/decrease) in the average number of medications used.'),('indicator',0,420,429,'en',0,'Divide the number of consultations in which no drug is prescribed by the number of consultations surveyed.'),('indicator',0,421,430,'en',0,'Provide a narrative description of the responsible governance structures and monitoring systems that result from the implementation of research results. The initiative can provide a link to a document where it is disclosed.\r\nConsider the Governance Model elaborated by MULTI-ACT.'),('indicator',0,422,431,'en',0,'Assess the degree of the project impact on health benefits using a five-point Likert scale (direct-considerable-moderate-identifiable-non). Describe the broader (societal) impact on health benefits (health gains, improved cost-efficiency/accessibility, qualitative improvements etc.) justifying the selection of the score. Degree of impact on health benefits can be described as free text or classified/quantified as:\r\n10 – At least one of the health benefits was almost solely based on the project’s evidence in a direct instrumental way.\r\n8 – The project made a considerable impact on the health benefits.\r\n6 – The project made a moderate impact on the health benefits.\r\n4 – The project made some identifiable impact on the health benefits.\r\n2 – A claim for impact made but no details given, or details given of a claim for expected future impacts.\r\n0 – No impact on health benefits.'),('indicator',0,423,432,'en',0,'Divide the number of population screened for the disease in which the research of the initiative/project focuses on by the number of the total population. When possible, compute this percentage disaggregated by women and men. '),('indicator',0,424,433,'en',0,'Provide a narrative description of the eHealth/eServices used by the initiative/project.'),('indicator',0,425,434,'en',0,'Calculate the percentage of PwMS receiving treatments respect to the total number of PwMS in a given area.'),('indicator',0,426,435,'en',0,'Indicate whether or not the initiative/project reports on access to medicine issues (Yes/No).'),('indicator',0,427,436,'en',0,'Divide the number of people belonging to marginalized groups (e.g. gender/ethnic) without access to healthcare with the total number of the population. Percentage of men/women/other with access to health services.'),('indicator',0,428,437,'en',0,'Divide the number of interventions using multidisciplinary approach by the number of total interventions.'),('indicator',0,429,438,'en',0,'Calculate number of training courses available for health professionals.'),('indicator',0,430,439,'en',0,'Calculate the number of university employed academics who also work as practitioners that participate in the initiative/project. Provide the share of men/women respect to the total number of employed academics.'),('indicator',0,431,440,'en',0,'Describe how the process was improved (what was done for the patients and how effective) and/or describe the possible outcomes of the improved health care delivery process (impacts on patients health). Improvement efforts of quality of health care may address the perspectives of efficacy, availability and accessibility, responsiveness to population health needs, utilization or coverage of health services etc. After the data collection, evaluate the efforts at national, regional, local level or at hospital/clinical units. These can be specific interventions or processes aiming to improve quality of care.'),('indicator',0,432,441,'en',0,'Describe the risk stratification model applied and the results of its application. A level of risk can be calculated by using diagnosis/procedures codes, for mortality and length-of-stay by using logistic regression/Cox proportional hazards modeling, together these generates an RSI.'),('indicator',0,433,442,'en',0,'Calculate the percentage of potentially preventable hospitalisations (PPH) by dividing hospital admissions (number of visits and people admitted) relative to the patient diagnoses codes in hospital admissions data. PPH is reported using the broad categories of chronic, acute and vaccine preventable conditions and using age-standardized hospitalisation rates (the number of potentially preventable hospitalisations per 1 000 or 100 000 population or the number of hospital bed days per patients admitted for a potentially preventable hospitalization).'),('indicator',0,434,443,'en',0,'Describe how health and safety issues are controlled in practice and identify preventive actions needed.'),('indicator',0,435,444,'en',0,'Count the number of each type of guidelines and tools developed/customized for patient care.'),('indicator',0,436,445,'en',0,'There are several ways to estimate QALY. For instance, calculate the years of life remaining for a patient and weight each year with a quality-of-life score (on a 0 to 1 scale). \"The basic idea underlying the QALY is simple: it assumes that a year of life lived in perfect health is worth 1 QALY (1 Year of Life × 1 Utility = 1 QALY) and that a year of life lived in a state of less than this perfect health is worth less than 1. In order to determine the exact QALY value, it is sufficient to multiply the utility value associated with a given state of health by the years lived in that state.\" (Prieto & Sacristán, 2003, p. 2).'),('indicator',0,437,446,'en',0,'Calculate the number of deaths for the specific population (disease in which the initiative research focuses on) in a given period of time and area and divide it by the number of death in the total population. Describe how the research findings of the initiative project contribute to reducing the mortality rate.'),('indicator',0,438,447,'en',0,'Provide a narrative description of the potential influence on life expectancy of the actions and research outcomes of the initiative/project.'),('indicator',0,439,448,'en',0,'Provide the change in the percentage of patient satisfaction respect to the previous survey. Questions included in the scales should be distinctive to capture the disease-specific issues. The indicator is normalized by measuring the change in patient satisfaction.'),('indicator',0,440,449,'en',0,'Provide a narrative description of the collaboration with other societal stakeholders in health promotion . The initiative can provide a link to a document where it is disclosed.'),('indicator',0,441,450,'en',0,'Provide a narrative description of the engagement activities with relevant patient groups. The initiative can provide a link to a document where it is disclosed.'),('indicator',0,442,451,'en',0,'Count the number of scientific articles published during the period. For the sake of comparison, the initiative shall report the same figure for the two prior periods. Provide a list of the complete references of the publications. Indicate the percentage of publications in high-impact journal by dividing the number of articles in those journals by the total number of publications during the period. The initiative can provide a link to a document where the list of publications is disclosed.'),('indicator',0,443,452,'en',0,'Count the number of scientific articles published during the reporting period resulting from the collaboration with researchers from organizations located in different countries or operating in different sectors.\r\nIndicate the number of organizations with which members of the initiative/project have published articles. For the sake of comparison, the initiative/project shall report the same figure for the two prior reporting periods.'),('indicator',0,444,453,'en',0,'For the number of open access articles: Count the number of open access scientific articles (total/gold/green) published during the reporting period by the initiative/project. For the sake of comparison, the initiative/project shall report the same figure for the two prior reporting periods. For the percentage of open access articles: divide the total number of open access scientific articles (total/gold/green) by the total number of publications during the reporting period, and multiply the result times 100.'),('indicator',0,445,454,'en',0,'Describe the extent to which anticipatory design policies and actions are considered in health research processes.'),('indicator',0,446,455,'en',0,'Count the number of citations of publications resulting from the the initiative/project\'s research since they were published. '),('indicator',0,447,456,'en',0,'Number and disparateness of the fields from citing publications, summarized in a diffusion score developed by Carley and Porter. Score ranges from 0 to 1.\r\nFor more information, see Carley S, & Porter A (2012).'),('indicator',0,448,457,'en',0,'Count the number of times that a publications/research output is cited in guidelines'),('indicator',0,449,458,'en',0,'Provide the number of dissemination activities carried out during the period.'),('indicator',0,450,459,'en',0,'Count the number of times that the initiative/project has been mentioned in the media as a consequence of the relevance of their research findings.'),('indicator',0,451,460,'en',0,'Provide the number of page views, unique visitors, and/or requests from the public/health care providers/researchers for more information.'),('indicator',0,452,461,'en',0,'Provide a narrative description of the extent to the initiative/project complies with clinical guidelines.'),('indicator',0,453,462,'en',0,'Provide a narrative description of the processes that the initiative/project follows to identify potential risks related to the research process and how these risks are managed. The initiative can provide a link to a document where it is disclosed.'),('indicator',0,454,463,'en',0,'Indicate Yes/No depending on the existence of an ethical committee to manage research. If yes, provide a description of f its structure (indicating its composition and gender distribution) and functions.'),('indicator',0,455,464,'en',0,'Provide a narrative description of the initiative/project’s values, principles and standards. Provide a detail description of how they have been  approved, developed, and implemented in the health research process.'),('indicator',0,456,465,'en',0,'Provide a description of whether and how the health research initiative/project integrated any type of ethical assessment/review in its funding decisions. '),('indicator',0,457,466,'en',0,'Count the total number of grants that the initiative/project has received to carry out research. For each grant, indicate the funding organization, amount and duration.'),('indicator',0,458,467,'en',0,'Count the number and the monetary amount of collaborative research projects funded through joint calls.'),('indicator',0,459,468,'en',0,'Indicate Yes/No depending on whether the initiative/project takes public engagement elements into account for the development or evaluation of R&I projects.\r\nProvide a narrative description of how public engagement is taken into account.'),('indicator',0,460,469,'en',0,'Provide the number of new taxonomies of diseases and new stratifications (such as the definition of patient subpopulations, development, validation and use of new diagnostics) developed, expressed as net figure. '),('indicator',0,461,470,'en',0,'Provide a narrative description of the overall impacts for patients (considering both positive and negative impacts) driven by the research and activities carried out by the initiative/project.'),('indicator',0,462,471,'en',0,'Provide a narrative description of the overall impacts for society (considering both positive and negative impacts) driven by the research and activities carried out by the initiative/project.'),('indicator',0,463,472,'en',0,'Provide a narrative description of the expected or targeted changes in knowledge, attitudes and behavior as a result of research dissemination and implementation strategies. The initiative can provide a link to a document where it is disclosed.'),('indicator',0,464,473,'en',0,'Use the following scoring scale and justify the score given:\r\n10 – The initiative/project made a considerable contribution to more than 1 follow-on project by the team and/or by others.\r\n8 – The initiative/project made a contribution to more than 1 follow-on project, considerable in at least one case.\r\n6 – The initiative/project made a contribution to more than 1 follow-on project, moderate in at least one case.\r\n4 – The initiative/project made a moderate contribution to 1 follow-on project, or any contribution to more than one follow-on project.\r\n2 – The initiative/project made a contribution to at least 1 follow-on project.\r\n0 – The initiative/project made no contribution to targeting of future research.'),('indicator',0,465,474,'en',0,'Provide a narrative description of the influence on shaping the R&D agenda.'),('indicator',0,466,475,'en',0,'Narrative description of the adopted research priorities or strategies that mirror the impact of the initiative/project. A questionnaire can be used to collect data.'),('indicator',0,467,476,'en',0,'Count the number of potential outcomes that can be applied in practice or in policy development. When possible, classify and describe the outcomes per type. '),('indicator',0,468,477,'en',0,'Describe the country specific activities and opportunities related to the use of science in decision-making: one dimension concerns the extent of formalized procedures feeding knowledge in decision-making (e.g. institutional sites dealing with these processes), the other dimension concerns the extent to which knowledge and advice have a real impact on decisions.'),('indicator',0,469,478,'en',0,'Describe the use of science in clinical context (e.g. trials, treatment recommendations, algorithms). For example, surveys or “market research” type methods can be useful in assessing the clinical awareness of published research results. The tracking can vary from small scale (e.g. conference posters) to large scale (e.g. international/national reports).'),('indicator',0,470,479,'en',0,'Divide the number of patents or other intellectual property rights owned by the initiative that are or have been exploited by the pharma industry by the total number of patents and other intellectual property rights owned by the initiative. For the sake of comparison, the initiative shall report the same figure for the two prior reporting periods.'),('indicator',0,471,480,'en',0,'Count the research institutions with which the initiative/project has shared intellectual property or research findings during the reporting period to collaborate in and advance the development of R&D. For the sake of comparison, the initiative/project shall report the figure for the two prior reporting periods.'),('indicator',0,472,481,'en',0,'Count the total number of patents that the initiative owns and was awarded during the reporting period. When breaking down the patents considering the options listed in the description, provide a table that summarizes the figures (see examples). For the sake of comparison, the initiative shall report the same figure for the two prior reporting periods.'),('indicator',0,473,482,'en',0,'Provide the total number of advanced phase clinical/pragmatic trials and/or Public Health research project where patient have been engaged. When possible, classify them based on their phase.'),('indicator',0,474,483,'en',0,'Provide a narrative description of how potential users are engaged in the research process.\r\nConsider the Patient Engagement model developed by MultiAct.'),('indicator',0,475,484,'en',0,'Count the total number of new drugs and other products that the initiative developed during the reporting period. For the sake of comparison, the initiative shall report the same figure for the two prior reporting periods. \r\nProvide a list of the products and drugs developed and being developed, indicating their stage.'),('indicator',0,476,485,'en',0,'Count the total number of new therapeutic advances that the initiative/project developed during the reporting period. For the sake of comparison, the initiative/project shall report the same figure for the two prior reporting periods.'),('indicator',0,477,486,'en',0,'Count the total number of spin-offs created during the reporting period. For the sake of comparison, the initiative/project shall report the same figure for the two prior reporting periods. Provide the main information about the spin-offs (e.g. main timeline of the spin-off, description of its business, debt ratios, detailed information of the new listed company etc.).'),('indicator',0,478,487,'en',0,'Provide a narrative description of the new developments generated by the initiative/project (drugs, products, therapeutic treatments, medical interventions, etcetera) and explain their effect on the wellbeing of patients and how they can contribute to solving, mitigating or paliating diseases.'),('indicator',0,479,488,'en',0,'Number and description of the collaborations and partnerships.'),('indicator',0,480,489,'en',0,'Divide the number of projects of the initiative that involve patient organizations in their advisory board by the total number of projects of the initiative.\r\nConsider the Patient Engagement model developed by MultiAct.'),('indicator',0,481,490,'en',0,'Number of consortia applying for traslational funding. Differentiate between total number of submissions and total number of successfull projects.'),('indicator',0,482,491,'en',0,'Calculate:\r\n• Number of public recognition of leadership: (i) number and type of prestigious fellowships, (ii) number and type of awards that mark significant achievement in research, (iii) number and type of membership in honorary scientific societies.\r\n• (i) Number and type of membership of regional, national or international research bodies; (ii) number and type of review boards; (iii) number and type of funding bodies.\r\n• (i) Number and type of editorship of journals, (ii) number and type of membership on journal editorial boards and (iii) number and type of advisory committees.'),('indicator',0,483,492,'en',0,'Provide the number of prizes and awards that were given to researchers or research programs of the initiative/project during the reporting period.'),('indicator',0,484,493,'en',0,'Count the number of each type of researcher  depending on their academic level (e.g. Senior research, Postdoc, Predoc) and gender.'),('indicator',0,485,494,'en',0,'Provide a narrative description of the skills, knowledge and experience of the staff, considering also the equipment and technology required  to complete their work.'),('indicator',0,486,495,'en',0,'Count the number of women on committees. Calculate the percentage of females respect to the total number of committee members.'),('indicator',0,487,496,'en',0,'Divide the number of females by the total number of researchers.'),('indicator',0,488,497,'en',0,'Provide the total amount of money (R&D expenses) invested in each project.'),('indicator',0,489,498,'en',0,'Provide a narrative description of the components and strategies of the research organizational structure.\r\nConsider the Corporate Governance model developed by MultiAct.'),('indicator',0,490,499,'en',0,'Total number of projects with significant impact of knowldege work over total projects. The identification of knowldege work is based on different criteria (for example, criteria established by experts in the field).'),('indicator',0,491,500,'en',0,'Provide a narrative description of the governance structures (indicating their composition and gender distribution)  and procedures that have been established to manage and monitor the research process.'),('indicator',0,492,501,'en',0,'Count the number of outreach visits and people attending them.'),('indicator',0,493,502,'en',0,'Count the number of methodologies advanced or developed by the initiative/project.\r\nProvide a narrative description of those advances and developments'),('indicator',0,494,503,'en',0,'Provide the number of target groups that attend events organized to engage stakeholders and distribute them according to the different categories of stakeholders identified.\r\nThis information should ideally be presented in a table and compared with the previous year data or with targets.'),('indicator',0,495,504,'en',0,'Provide the number of mechanisms applied to interact with citizens and societal stakeholders. Provide a narrative description of the mechanisms and instruments used to engage these stakeholders.'),('indicator',0,496,505,'en',0,'Provide the number of stakeholders consulted by the initiative/project in a given period.\r\nThis information should ideally be compared with previous year or with expected targets.'),('indicator',0,497,506,'en',0,'Provide a narrative description of the social reputation of the research project/initiative.'),('indicator',0,498,507,'en',0,'Indicate Yes/No depending on whether the initiative/project has clearly defined enforcement procedures and (where there has been misconduct) provide evidence of taking disciplinary action against employees or third parties who have violated its code of conduct for ethical marketing or anti-corruption. Provide a description of evidence of follow-up actions taken to mitigate the risk of future breaches.'),('indicator',0,499,508,'en',0,'Calculate the frequency rate of accidents as the number of accidents suffered during the period, divided by the total hours worked in the same period and multiplied by 1,000,000.'),('indicator',0,500,509,'en',0,'Provide a narrative description of the impact on labour at the national/regional/local levels driven by the effect of research findings.'),('indicator',0,501,510,'en',0,'Calculate the employee turnover during the reporting period by age group and gender at the local/regional/national levels.\r\nEmployee turnover is the percentage of employees leaving the organization in a period, relative to the average number of employees during this period.'),('indicator',0,502,511,'en',0,'Divide the hours of training programs for research employees dissagregated by gender group in the reporting period by the average number of research employees during this period. '),('indicator',0,503,512,'en',0,'Provide the number and description of policies and guidelines informed by the research initiative/project. The initiative can provide a link to a document where it is disclosed.'),('indicator',0,504,513,'en',0,'Provide a narrative description of the measures adopted by the project/initiative to improve the governance and organization of its research activities. The initiative/project can provide a link to a document where the description is disclosed.'),('indicator',0,505,514,'en',0,'Narrative description of the interaction between the research initiative/project and external relevant actors (e.g. government agencies). The initiative can provide a link to a document where it is disclosed.'),('indicator',0,506,515,'en',0,'Provide the number of internal and/or external environmental audits conducted.'),('indicator',0,507,516,'en',0,'Identify the total materials used (raw materials, natural resources, materials needed for the manufacturing process, parts, components and materials for packaging purposes). Report the total weight or volume of all raw material needed for developing, producing and packaging the primary products (or services):\r\ni. non-renewable materials used;\r\nii. renewable materials used.'),('indicator',0,508,517,'en',0,'Calculate direct GHG emissions using relevant global warming potential (GWP) rates to translate the amount of emissions of a GHG into CO2 equivalents. Considering the characteristics of research funding and performing initiatives/projects, it could be advisable to consider the change in emissions to demonstrate reduction, rather than the absolute amount of GHG emissions. Following GRI and the Greenhouse Gas Protocol, GHG emissions are measured according to three scopes:\r\n• Direct (Scope 1)\r\n• Energy indirect (Scope 2)\r\n• Other indirect (Scope 3) emissions.'),('indicator',0,509,518,'en',0,'Identify the total number of actions aimed to improve community development and calculate the percentage of actions that have been executed in practice respect to the planned actions (local community engagement, impact assessment, or development programs).'),('indicator',0,510,519,'en',0,'Provide a narrative description of the activities organized by the initiative/project to promote the engagement with community members. The initiative can provide a link to a document where it is disclosed. Patient Engagement model elaborated by MultiAct provides information about engagement activities.'),('indicator',0,512,521,'en',0,'Provide a narrative description of the extent to which standards and regulations regarding RRI are acknowledged, complied with and embedded in the research process.'),('indicator',0,547,557,'en',0,'Provide a narrative description of how the initiative/project engages with clinicians and patients to implement research strategies and research outcomes in health care practice.\r\nConsider the Patient Engagement model developed by MultiAct.\r\n'),('indicator',0,548,558,'en',0,'Indicate whether there is publicly available information on the economic, social and environmental impacts resulting from the research and/or how they are being managed. Provide a reference or link to access the information. '),('indicator',0,549,559,'en',0,'Change in the percentage of patients satisfaction with respect to the previous questionnaire. Questions included in the scales are distinctive to capture the disease-specific issues. The indicator is normalized by measuring the change in patient satisfaction.\r\n'),('indicator',0,550,560,'en',0,'Change in the percentage of patients satisfaction with respect to the previous questionnaire. Questions included in the scales are distinctive to capture the disease-specific issues. The indicator is normalized by measuring the change in patient satisfaction.'),('indicator',0,551,561,'en',0,'The indicator facilitates comparisons. Considering that the measurement of patients\' satisfaction with their level of bladder functions is disease-specific, the measurement of the percentage change provides a standardized measure of patient satisfaction. \r\n'),('indicator',0,552,562,'en',0,'Change in the percentage of patients satisfaction with respect to the previous questionnaire. Questions included in the scales are distinctive to capture the disease-specific issues. The indicator is normalized by measuring the change in patient satisfaction.'),('indicator',0,553,563,'en',0,'Change in the percentage of patients satisfaction with respect to the previous questionnaire. Questions included in the scales are distinctive to capture the disease-specific issues. The indicator is normalized by measuring the change in patient satisfaction.'),('indicator',0,554,564,'en',0,'Change in the percentage of patients satisfaction with respect to the previous questionnaire. Questions included in the scales are distinctive to capture the disease-specific issues. The indicator is normalized by measuring the change in patient satisfaction.'),('indicator',0,585,612,'en',0,'Change in the percentage of patients satisfaction with respect to the previous questionnaire. Questions included in the scales are distinctive to capture the disease-specific issues. The indicator is normalized by measuring the change in patient satisfaction.');

--
-- Table structure for table `node_revision__field_monitoring_evaluation_fram`
--

CREATE TABLE `node_revision__field_monitoring_evaluation_fram` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_monitoring_evaluation_fram_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_monitoring_evaluation_fram_value` (`field_monitoring_evaluation_fram_value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_monitoring…';

--
-- Dumping data for table `node_revision__field_monitoring_evaluation_fram`
--

INSERT INTO `node_revision__field_monitoring_evaluation_fram` VALUES ('indicator',0,399,408,'en',0,'Process'),('indicator',0,400,409,'en',0,'Process'),('indicator',0,401,410,'en',0,'Process'),('indicator',0,402,411,'en',0,'Impact'),('indicator',0,403,412,'en',0,'Impact'),('indicator',0,404,413,'en',0,'Impact'),('indicator',0,405,414,'en',0,'Outcome'),('indicator',0,406,415,'en',0,'Output'),('indicator',0,407,416,'en',0,'Output'),('indicator',0,408,417,'en',0,'Output'),('indicator',0,409,418,'en',0,'Outcome'),('indicator',0,410,419,'en',0,'Output'),('indicator',0,411,420,'en',0,'Process'),('indicator',0,412,421,'en',0,'Output'),('indicator',0,413,422,'en',0,'Outcome'),('indicator',0,414,423,'en',0,'Input'),('indicator',0,415,424,'en',0,'Outcome'),('indicator',0,416,425,'en',0,'Process'),('indicator',0,417,426,'en',0,'Input'),('indicator',0,418,427,'en',0,'Input'),('indicator',0,419,428,'en',0,'Outcome'),('indicator',0,420,429,'en',0,'Outcome'),('indicator',0,421,430,'en',0,'Process'),('indicator',0,422,431,'en',0,'Impact'),('indicator',0,423,432,'en',0,'Output'),('indicator',0,424,433,'en',0,'Process'),('indicator',0,425,434,'en',0,'Outcome'),('indicator',0,426,435,'en',0,'Process'),('indicator',0,427,436,'en',0,'Impact'),('indicator',0,428,437,'en',0,'Process'),('indicator',0,429,438,'en',0,'Outcome'),('indicator',0,430,439,'en',0,'Input'),('indicator',0,431,440,'en',0,'Outcome'),('indicator',0,432,441,'en',0,'Outcome'),('indicator',0,433,442,'en',0,'Outcome'),('indicator',0,434,443,'en',0,'Process'),('indicator',0,435,444,'en',0,'Outcome'),('indicator',0,436,445,'en',0,'Impact'),('indicator',0,437,446,'en',0,'Outcome'),('indicator',0,438,447,'en',0,'Impact'),('indicator',0,439,448,'en',0,'Outcome'),('indicator',0,440,449,'en',0,'Process'),('indicator',0,441,450,'en',0,'Process'),('indicator',0,442,451,'en',0,'Output'),('indicator',0,443,452,'en',0,'Output'),('indicator',0,444,453,'en',0,'Output'),('indicator',0,445,454,'en',0,'Process'),('indicator',0,446,455,'en',0,'Outcome'),('indicator',0,447,456,'en',0,'Outcome'),('indicator',0,448,457,'en',0,'Outcome'),('indicator',0,449,458,'en',0,'Output'),('indicator',0,450,459,'en',0,'Output'),('indicator',0,451,460,'en',0,'Output'),('indicator',0,452,461,'en',0,'Process'),('indicator',0,453,462,'en',0,'Outcome'),('indicator',0,454,463,'en',0,'Process'),('indicator',0,455,464,'en',0,'Process'),('indicator',0,456,465,'en',0,'Process'),('indicator',0,457,466,'en',0,'Input'),('indicator',0,458,467,'en',0,'Outcome'),('indicator',0,459,468,'en',0,'Process'),('indicator',0,460,469,'en',0,'Impact'),('indicator',0,461,470,'en',0,'Impact'),('indicator',0,462,471,'en',0,'Impact'),('indicator',0,463,472,'en',0,'Impact'),('indicator',0,464,473,'en',0,'Impact'),('indicator',0,465,474,'en',0,'Impact'),('indicator',0,466,475,'en',0,'Impact'),('indicator',0,467,476,'en',0,'Impact'),('indicator',0,468,477,'en',0,'Impact'),('indicator',0,469,478,'en',0,'Impact'),('indicator',0,470,479,'en',0,'Output'),('indicator',0,471,480,'en',0,'Output'),('indicator',0,472,481,'en',0,'Output'),('indicator',0,473,482,'en',0,'Process'),('indicator',0,474,483,'en',0,'Process'),('indicator',0,475,484,'en',0,'Output'),('indicator',0,476,485,'en',0,'Output'),('indicator',0,477,486,'en',0,'Output'),('indicator',0,478,487,'en',0,'Output'),('indicator',0,479,488,'en',0,'Input'),('indicator',0,480,489,'en',0,'Input'),('indicator',0,481,490,'en',0,'Input'),('indicator',0,482,491,'en',0,'Output'),('indicator',0,483,492,'en',0,'Outcome'),('indicator',0,484,493,'en',0,'Input'),('indicator',0,485,494,'en',0,'Input'),('indicator',0,486,495,'en',0,'Process'),('indicator',0,487,496,'en',0,'Input'),('indicator',0,488,497,'en',0,'Input'),('indicator',0,489,498,'en',0,'Process'),('indicator',0,490,499,'en',0,'Outcome'),('indicator',0,491,500,'en',0,'Process'),('indicator',0,492,501,'en',0,'Output'),('indicator',0,493,502,'en',0,'Input'),('indicator',0,494,503,'en',0,'Outcome'),('indicator',0,495,504,'en',0,'Process'),('indicator',0,496,505,'en',0,'Process'),('indicator',0,497,506,'en',0,'Outcome'),('indicator',0,498,507,'en',0,'Process'),('indicator',0,499,508,'en',0,'Impact'),('indicator',0,500,509,'en',0,'Impact'),('indicator',0,501,510,'en',0,'Input'),('indicator',0,502,511,'en',0,'Input'),('indicator',0,503,512,'en',0,'Impact'),('indicator',0,504,513,'en',0,'Process'),('indicator',0,505,514,'en',0,'Outcome'),('indicator',0,506,515,'en',0,'Process'),('indicator',0,507,516,'en',0,'Input'),('indicator',0,508,517,'en',0,'Output'),('indicator',0,509,518,'en',0,'Outcome'),('indicator',0,510,519,'en',0,'Outcome'),('indicator',0,512,521,'en',0,'Process'),('indicator',0,547,557,'en',0,'Process'),('indicator',0,548,558,'en',0,'Process'),('indicator',0,549,559,'en',0,'Outcome'),('indicator',0,550,560,'en',0,'Outcome'),('indicator',0,551,561,'en',0,'Outcome'),('indicator',0,552,562,'en',0,'Outcome'),('indicator',0,553,563,'en',0,'Outcome'),('indicator',0,554,564,'en',0,'Outcome'),('indicator',0,585,612,'en',0,'Outcome');

--
-- Table structure for table `node_revision__field_number_of_organizations_in`
--

CREATE TABLE `node_revision__field_number_of_organizations_in` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_number_of_organizations_in_value` int(11) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_number_of…';

--
-- Dumping data for table `node_revision__field_number_of_organizations_in`
--

INSERT INTO `node_revision__field_number_of_organizations_in` VALUES ('initiative',0,1,1,'en',0,2),('initiative',0,1,2,'en',0,2),('initiative',0,1,3,'en',0,2),('initiative',0,1,5,'en',0,2),('initiative',0,1,7,'en',0,2),('initiative',0,306,314,'en',0,2),('initiative',0,307,315,'en',0,2),('initiative',0,309,318,'en',0,3),('initiative',0,310,319,'en',0,1),('initiative',0,516,525,'en',0,28),('initiative',0,518,528,'en',0,2),('initiative',0,519,529,'en',0,3),('initiative',0,520,530,'en',0,6),('initiative',0,521,531,'en',0,5),('initiative',0,522,532,'en',0,14),('initiative',0,523,533,'en',0,18),('initiative',0,524,534,'en',0,2),('initiative',0,525,535,'en',0,4),('initiative',0,526,536,'en',0,5),('initiative',0,527,537,'en',0,3),('initiative',0,528,538,'en',0,2),('initiative',0,529,539,'en',0,3),('initiative',0,530,540,'en',0,3),('initiative',0,531,541,'en',0,3),('initiative',0,534,544,'en',0,5),('initiative',0,535,545,'en',0,10),('initiative',0,536,546,'en',0,3),('initiative',0,537,547,'en',0,1),('initiative',0,538,548,'en',0,2),('initiative',0,539,549,'en',0,12),('initiative',0,540,550,'en',0,7),('initiative',0,541,551,'en',0,20),('initiative',0,542,552,'en',0,8),('initiative',0,543,553,'en',0,22),('initiative',0,544,554,'en',0,1),('initiative',0,545,555,'en',0,3),('initiative',0,546,556,'en',0,2),('initiative',0,555,565,'en',0,1),('initiative',0,556,566,'en',0,5),('initiative',0,557,567,'en',0,6),('initiative',0,564,582,'en',0,12),('initiative',0,572,599,'en',0,4),('initiative',0,589,616,'en',0,5),('initiative',0,590,617,'en',0,2),('initiative',0,592,621,'en',0,25),('initiative',0,593,622,'en',0,10);

--
-- Table structure for table `node_revision__field_parent_initiative`
--

CREATE TABLE `node_revision__field_parent_initiative` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_parent_initiative_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_parent_initiative_target_id` (`field_parent_initiative_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_parent…';

--
-- Dumping data for table `node_revision__field_parent_initiative`
--

INSERT INTO `node_revision__field_parent_initiative` VALUES ('initiative',0,1,5,'en',0,2),('initiative',0,1,7,'en',0,519),('initiative',0,307,315,'en',0,518),('initiative',0,310,319,'en',0,309),('initiative',0,516,525,'en',0,306),('initiative',0,520,530,'en',0,519),('initiative',0,523,533,'en',0,522),('initiative',0,530,540,'en',0,529);

--
-- Table structure for table `node_revision__field_permissions_tags`
--

CREATE TABLE `node_revision__field_permissions_tags` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_permissions_tags_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_permissions_tags_target_id` (`field_permissions_tags_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_permissions…';

--
-- Dumping data for table `node_revision__field_permissions_tags`
--

INSERT INTO `node_revision__field_permissions_tags` VALUES ('webform',0,594,623,'en',0,266);

--
-- Table structure for table `node_revision__field_preferred_data_sources`
--

CREATE TABLE `node_revision__field_preferred_data_sources` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_preferred_data_sources_value` longtext NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_preferred…';

--
-- Dumping data for table `node_revision__field_preferred_data_sources`
--

INSERT INTO `node_revision__field_preferred_data_sources` VALUES ('indicator',0,399,408,'en',0,'Initiative/project\'s internal data'),('indicator',0,400,409,'en',0,'Initiative/project\'s internal data'),('indicator',0,401,410,'en',0,'Initiative/project\'s internal data'),('indicator',0,402,411,'en',0,'Information compiled internally by the organization with the input of other stakeholders (if needed)'),('indicator',0,403,412,'en',0,'Initiative/project\'s internal data\r\nNational/regional/local registries'),('indicator',0,404,413,'en',0,'Initiative/project\'s internal data'),('indicator',0,405,414,'en',0,'Annual report\r\nFinancial statement\r\nInitiative/project\'s internal data'),('indicator',0,406,415,'en',0,'Financial report'),('indicator',0,407,416,'en',0,'Initiative/project financial report'),('indicator',0,408,417,'en',0,'Initiative/project financial report'),('indicator',0,409,418,'en',0,'Annual report'),('indicator',0,410,419,'en',0,'Scientific report\r\nFinancial report'),('indicator',0,411,420,'en',0,'Initiative/project\'s internal data'),('indicator',0,412,421,'en',0,'Initiative/project\'s internal data'),('indicator',0,413,422,'en',0,'Surveys'),('indicator',0,414,423,'en',0,'Financial statements\r\nInternal management control systems'),('indicator',0,415,424,'en',0,'National/Regional/Local health systems\' records and financial statements\r\nExpert consultation'),('indicator',0,416,425,'en',0,'Annual report'),('indicator',0,417,426,'en',0,'Annual report\r\nInitiative/project\'s internal data'),('indicator',0,418,427,'en',0,'Initiative/project\'s internal data'),('indicator',0,419,428,'en',0,'Electronic medical records\r\nPatient records'),('indicator',0,420,429,'en',0,'Electronic medical records\r\nPatient records'),('indicator',0,421,430,'en',0,'Initiative/project\'s internal data'),('indicator',0,422,431,'en',0,'Review of research documents\r\nExpert survey'),('indicator',0,423,432,'en',0,'Health care providers\' records\r\nClinical information systems\r\nElectronic health record system\r\nPatient records, surveys and interviews'),('indicator',0,424,433,'en',0,'Initiative/project management control systems'),('indicator',0,425,434,'en',0,'Surveys\r\nRecords of service delivery\r\nAdministrative data'),('indicator',0,426,435,'en',0,'Annual report\r\nSustainability report'),('indicator',0,427,436,'en',0,'Local, regional and national statistics'),('indicator',0,428,437,'en',0,'Administrative/clinical/hospital data\r\nSurveys'),('indicator',0,429,438,'en',0,'Professional associations'),('indicator',0,430,439,'en',0,'Initiative/project\'s internal data\r\nHealthcare providers\r\nClinical academics'),('indicator',0,431,440,'en',0,'Research reports\r\nClinical information system\r\nSurveys and interviews'),('indicator',0,432,441,'en',0,'Hospital record information systems'),('indicator',0,433,442,'en',0,'Hospital record information systems\r\nHealth surveys'),('indicator',0,434,443,'en',0,'Annual report\r\nHuman resource management report'),('indicator',0,435,444,'en',0,'Clinical/treatment guidelines'),('indicator',0,436,445,'en',0,'Medical costs\r\nQuestionaires used in trials\r\nPreference surveys\r\nExpected duration of life and degree of diability'),('indicator',0,437,446,'en',0,'Electronic medical records\r\nAdministrative/clinical/hospital data'),('indicator',0,438,447,'en',0,'Interviews and/or surveys with practitioners/experts'),('indicator',0,439,448,'en',0,'Surveys'),('indicator',0,440,449,'en',0,'Initiative/project\'s internal data'),('indicator',0,441,450,'en',0,'Initiative/project\'s internal data'),('indicator',0,442,451,'en',0,'Initiative scientific report\r\nRankings of journals (e.g. JCR, SJR)'),('indicator',0,443,452,'en',0,'Initiative/project scientific report\r\nBibliometric datasources\r\nAcademic search databases'),('indicator',0,444,453,'en',0,'Initiative/project scientific report\r\nClassification of journals with open access options, such as DOAJ list (Directory of Open Access Journals), PMC (PubMed Central), the ROAD list (Directory of Open Access scholarly Resources), CrossRef, and OpenAIRE'),('indicator',0,445,454,'en',0,'Surveys/ Questionnaires\r\nSustainablity report'),('indicator',0,446,455,'en',0,'Google Scholar\r\nWeb of Science (WoS)\r\nScopus'),('indicator',0,447,456,'en',0,'Google scholar\r\nWeb of Science (WoS)\r\nScopus'),('indicator',0,448,457,'en',0,'Guidelines'),('indicator',0,449,458,'en',0,'Scientific report\r\nInitiative/project\'s internal data'),('indicator',0,450,459,'en',0,'Internal reports by press office'),('indicator',0,451,460,'en',0,'Google analytics or similar web engines'),('indicator',0,452,461,'en',0,'Initiative/project\'s internal data\r\nDesk analysis, database and interviews\r\nCase studies'),('indicator',0,453,462,'en',0,'Initiative/project\'s internal data\r\nDesk analysis, database and interviews\r\nCase studies'),('indicator',0,454,463,'en',0,'Code of ethics/conduct'),('indicator',0,455,464,'en',0,'Code of ethics/conduct\r\nMission statement\r\nInitiative/project\'s internal data'),('indicator',0,456,465,'en',0,'Initiative/project\'s internal data'),('indicator',0,457,466,'en',0,'Annual report\r\nScientific report'),('indicator',0,458,467,'en',0,'Initiative/project\'s internal data'),('indicator',0,459,468,'en',0,'Official documents specifying the criteria to evaluate research proposals'),('indicator',0,460,469,'en',0,'Scientific report\r\nInitiative/project\'s internal data'),('indicator',0,461,470,'en',0,'Dedicated survey'),('indicator',0,462,471,'en',0,'Dedicated survey'),('indicator',0,463,472,'en',0,'Initiative/project\'s internal data'),('indicator',0,464,473,'en',0,'Initiative/project\'s internal data\r\nExternal expert (if needed)'),('indicator',0,465,474,'en',0,'Initiative/project\'s internal data'),('indicator',0,466,475,'en',0,'Initiative/project\'s internal data'),('indicator',0,467,476,'en',0,'Research report'),('indicator',0,468,477,'en',0,'Research report'),('indicator',0,469,478,'en',0,'Interviews with practitioners/clinicians\r\nMarket surveys\r\nCase studies'),('indicator',0,470,479,'en',0,'Initiative scientific report\r\nWorld Intellectual Property Organization Database'),('indicator',0,471,480,'en',0,'Initiative scientific report\r\nInitiative/project\'s internal data'),('indicator',0,472,481,'en',0,'Initiative scientific report\r\nWorld Intellectual Property Organization Database'),('indicator',0,473,482,'en',0,'Information compiled internally by the organization with the input of other stakeholders as patients (if needed)'),('indicator',0,474,483,'en',0,'Initiative/project\'s internal data'),('indicator',0,475,484,'en',0,'Initiative\'s scientific report'),('indicator',0,476,485,'en',0,'Initiative scientific report'),('indicator',0,477,486,'en',0,'Initiative scientific report\r\nInitiative financial report'),('indicator',0,478,487,'en',0,'Initiative scientific report\r\nResearch report\r\nResearchers\' expertise'),('indicator',0,479,488,'en',0,'Initiative/project\'s internal data'),('indicator',0,480,489,'en',0,'Initiative/project\'s internal data'),('indicator',0,481,490,'en',0,'Initiative/project\'s internal data.'),('indicator',0,482,491,'en',0,'Information compiled internally by the organization, with the engagement of the researchers that have been involved in the specific research programme'),('indicator',0,483,492,'en',0,'Initiative/project\'s internal data.'),('indicator',0,484,493,'en',0,'Annual report\r\nScientific report'),('indicator',0,485,494,'en',0,'Annual report\r\nSustainability report'),('indicator',0,486,495,'en',0,'Annual report\r\nSustainability report\r\n'),('indicator',0,487,496,'en',0,'Annual report\r\nSustainability report'),('indicator',0,488,497,'en',0,'Initiative/project\'s internal data'),('indicator',0,489,498,'en',0,'Initiative/project\'s internal data'),('indicator',0,490,499,'en',0,'Information compiled internally by the initiative/project with the input of other stakeholders as experienced workers.'),('indicator',0,491,500,'en',0,'Annual report\r\nPolicy report'),('indicator',0,492,501,'en',0,'Scientific report\r\nInitiative/project\'s internal information'),('indicator',0,493,502,'en',0,'Scientific report\r\nInitiative/project\'s internal data'),('indicator',0,494,503,'en',0,'Initiative/project\'s internal data'),('indicator',0,495,504,'en',0,'Initiative/project\'s internal data'),('indicator',0,496,505,'en',0,'Initiative/project\'s internal data'),('indicator',0,497,506,'en',0,'Surveys\r\nInterviews'),('indicator',0,498,507,'en',0,'Initiative Code of Ethics/Conduct.\r\nThe initiative should provide a link to the public documents where the code of ethics/conduct is provided.'),('indicator',0,499,508,'en',0,'Annual report\r\nSustainability report\r\nInternal report'),('indicator',0,500,509,'en',0,'Sustainability report'),('indicator',0,501,510,'en',0,'Initiative/project\'s internal data\r\nNational/regional/local data registries'),('indicator',0,502,511,'en',0,'Sustainability report'),('indicator',0,503,512,'en',0,'Initiative/project\'s internal data'),('indicator',0,504,513,'en',0,'Initiative/project\'s internal data'),('indicator',0,505,514,'en',0,'Initiative/project\'s internal data'),('indicator',0,506,515,'en',0,'Environmental management system documentary\r\nAnnual report\r\nSustainability report'),('indicator',0,507,516,'en',0,'Production and research sites of the company\r\nSustainabitly report\r\nBilling and accounting systems, procurement or supply management department'),('indicator',0,508,517,'en',0,'Initiative/project management control systems'),('indicator',0,509,518,'en',0,'Initiative/project\'s internal data\r\nSocial/gender/health/environmental impact assessments\r\nStakeholder engagement/community development plans'),('indicator',0,510,519,'en',0,'Initiative/project\'s internal data'),('indicator',0,512,521,'en',0,'Initiative/project\'s internal data'),('indicator',0,547,557,'en',0,'Initiative/project\'s internal data\r\n'),('indicator',0,548,558,'en',0,'Sustainability report\r\nStrategy documents\r\nAnnual report'),('indicator',0,549,559,'en',0,'Questionnaires (also in the form of digital data collection)'),('indicator',0,550,560,'en',0,'Questionnaires (also in the form of digital data collection)'),('indicator',0,551,561,'en',0,'Questionnaires (also in the form of digital data collection)'),('indicator',0,552,562,'en',0,'Questionnaires (also in the form of digital data collection)'),('indicator',0,553,563,'en',0,'Questionnaires (also in the form of digital data collection)'),('indicator',0,554,564,'en',0,'Questionnaires (also in the form of digital data collection)'),('indicator',0,585,612,'en',0,'Questionnaires (also in the form of digital data collection)');

--
-- Table structure for table `node_revision__field_rationale`
--

CREATE TABLE `node_revision__field_rationale` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_rationale_value` longtext NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_rationale.';

--
-- Dumping data for table `node_revision__field_rationale`
--

INSERT INTO `node_revision__field_rationale` VALUES ('indicator',0,399,408,'en',0,'The indicator evaluates if intellectual property strategies are employed to contribute to access to medicine (e.g. companies pressure governments not to adopt TRIPS flexibilities), at least in developing countries.'),('indicator',0,400,409,'en',0,'The analysis of deviation allows identifying their causes, as well as reformulate programs and implement corrective actions.'),('indicator',0,401,410,'en',0,'Audits produce preventive effects in control. The indicator is easy to obtain.\r\nCertifications could be used as a proxy.'),('indicator',0,402,411,'en',0,'The indicator assesses the effect that research findings may have on the overall economy when been commercialized.'),('indicator',0,403,412,'en',0,'The indicator informs about the contribution to a healthy workforce i.e., work-life balance.'),('indicator',0,404,413,'en',0,'The indicator informs about how research findings affect the economic conditions of communities.'),('indicator',0,405,414,'en',0,'This indicator evaluates how the financial resources of the of the initiative/project are distributed among stakeholders.'),('indicator',0,406,415,'en',0,'The indicator evaluates the capacity of the initiative/project to generate economic profits. It measures its economic efficiency. The calculation of the indicator is simple and enables a high level of comparability.'),('indicator',0,407,416,'en',0,'The indicator evaluates the capacity of an initiative/project to pay back their debt through the profit generated by its research activity. The indicator is standard, easy to calculate and enables comparison with other initiatives.'),('indicator',0,408,417,'en',0,'The indicator assesses the generation of income of the initiative/project through the exploitation of their reseach findings compared to the cost or value of obtaining the right to exploit them. The indicator is easy to calculate, and the information required for its computation is accesible.'),('indicator',0,409,418,'en',0,'The indicator measures the overall economic value generated by the initiative/project.'),('indicator',0,410,419,'en',0,'The indicator assesses the initiative/project\'s capacity to generate economic revenues from the exploitation of their patents and intellectual property rights. The indicator is easy to calculate, and the information required for its computation is accesible.'),('indicator',0,411,420,'en',0,'The indicator is clear and applicable to every initiative/project.'),('indicator',0,412,421,'en',0,'The indicator is clear and related to efficacy. It also allows evaluating the scope of the treatment/product audience.'),('indicator',0,413,422,'en',0,'The indicator evaluates the capacity of the initiative/project to develop a multi-stakeholder and the long term perspective, which is key for RR&I.'),('indicator',0,414,423,'en',0,'Cost per unit of product/service/contracted process provides an accepted measure of economic efficiency.'),('indicator',0,415,424,'en',0,'The indicator assesses the influence of research on reducing the cost of health systems and health care delivery.'),('indicator',0,416,425,'en',0,'The indicator provides details on the effectiveness of drug recall systems.'),('indicator',0,417,426,'en',0,'The indicator informs about the capacity of the initiative/project to contribute to employment.'),('indicator',0,418,427,'en',0,'The indicator offers a description of the employees of the initiative/project.'),('indicator',0,419,428,'en',0,'The indicator allows monitoring the increase or decrease in the number and use of drugs for treating a certain disease.'),('indicator',0,420,429,'en',0,'The indicator measures the proportion of patients who are counseled and/or treated without being prescribed with drugs. This indicator can be very revealing for the initiative/project as it allows to identify and foster new research projects.'),('indicator',0,421,430,'en',0,'The indicator provides information to evaluate the impact of the initiative/project\'s research to foster more responsible governance structures that monitor and supervise the management of health service organizations.'),('indicator',0,422,431,'en',0,'The indicator allows an overview of the impact on health benefits. It is strategic to assess the level of achievement of a certain mission.'),('indicator',0,423,432,'en',0,'The indicator allows an overview of the population that the initiative/project can help by improving health management through research.'),('indicator',0,424,433,'en',0,'The indicator provides information on the use of technologies to improve health care.'),('indicator',0,425,434,'en',0,'The indicator gives a comprehensive overview of health service coverage because it is a composite indicator.'),('indicator',0,426,435,'en',0,'The indicator helps to assess whether the initiative/project is transparent about its activities regarding access to medicine.'),('indicator',0,427,436,'en',0,'The indicator takes into consideration that equity of access to healthcare often depends on gender and/or ethnicity.'),('indicator',0,428,437,'en',0,'The indicator measures the proportion of health interventions that have engaged diverse stakeholders among the target group to ensure a comprehensive approach.'),('indicator',0,429,438,'en',0,'The indicator allows to identify the level of training of health professionals and possible gaps to be fulfilled. It also provides information on the contribution to research degrees (PhD) or to training of specific tasks related to research capacity building.'),('indicator',0,430,439,'en',0,'The indicator provides an overview of the level of human capital of healthcare practitioners within the initiative/project.'),('indicator',0,431,440,'en',0,'The indicator allows evaluating the impact that research has on the day-to-day health care delivery.'),('indicator',0,432,441,'en',0,'The indicator identifies the patients likely to be at high risk and prioritizing actions needed for improving management of their care.'),('indicator',0,433,442,'en',0,'The indicator provides a measure to evaluate health care delivery effectiveness.'),('indicator',0,434,443,'en',0,'The indicator allows identifying how the initiative/project manages health and safety risks.'),('indicator',0,435,444,'en',0,'The indicator allows to screen the capability of research activities in supporting patients through guidelines and tools.'),('indicator',0,436,445,'en',0,'The indicator helps to evaluate the health outcomes of interventions/programs and to allocate healthcare resources (health benefits and value for money).'),('indicator',0,437,446,'en',0,'The indicator evaluates how the initiative/project contributes to reducing the mortality rate of the disease on which its research focuses.'),('indicator',0,438,447,'en',0,'The indicator describes actions carried out by the initiative/project that are expected to increase the average life expectancy of patients.'),('indicator',0,439,448,'en',0,'The indicator facilitates comparisons. Considering that the measurement of patient satisfaction needs to be disease-specific, the measurement of the percentage change provides a standardized measure of patient satisfaction.'),('indicator',0,440,449,'en',0,'The indicator describes how the actors collaborate in promoting health.'),('indicator',0,441,450,'en',0,'The indicator describes how the patient groups are taken into account.'),('indicator',0,442,451,'en',0,'The indicator evaluates the extent and level of the academic production of the initiative/project.'),('indicator',0,443,452,'en',0,'The indicator measures the collaboration in publications as a proxy for the quality and broadness of the initiative/project\'s research capacity.'),('indicator',0,444,453,'en',0,'The indicator informs about the committment of the initiative towards transparency by faciliting the transference and openess of their research results and making them accesible to the general public.'),('indicator',0,445,454,'en',0,'The indicator evaluates foresight techniques. Moreover, this indicator has been identified as \"key\" for experts in the field through the interviews carried out in D3.5.'),('indicator',0,446,455,'en',0,'The indicator shows the number of times the article has been cited as proxy for the academic relevance of research outputs.'),('indicator',0,447,456,'en',0,'The indicator measures the applicability of research findings across subject areas, represents the robustness of the findings, incorporates features of traditional measures of diversity in assessing the balance and distribution of citations arising from different topic/subject categories. For example, if an article A is cited by Physics and Chemistry and an article B by Math, Music and Forestry the diffusion score would be greater for article B since there is greater heterogeneity among its citing subject categories.'),('indicator',0,448,457,'en',0,'The indicator shows how the findings are disseminating and cumulating knowledge. It measures the diffusion of research outputs into knowledge transfer, clinical implementation, or community benefit outcomes resulting from research studies.'),('indicator',0,449,458,'en',0,'The indicators reports on the dissemination activities to promote and communicate research outcomes.'),('indicator',0,450,459,'en',0,'The indicator measures the results of public relationship efforts.'),('indicator',0,451,460,'en',0,'The indicator shows the activity of the webpage of the initiative/project.'),('indicator',0,452,461,'en',0,'The indicator provides a starting point to analyze whether the research process is being responsible by fulfilling the basic requirement of complying with clinical guidelines to guarantee the adequate treatment of patients.'),('indicator',0,453,462,'en',0,'The indicator promotes accountability as it allows stakeholders to evaluate the potential risks that could emerge as a result of the research process. Additionally, it also provides benefits to the initiative/project because it helps it to make a self-assessment of its research process.'),('indicator',0,454,463,'en',0,'The indicator provides information that allows evaluating the consideration of ethical issues in research.'),('indicator',0,455,464,'en',0,'The indicator describes in detail the values, principles, standards and norms of behavior of the initiative/project.'),('indicator',0,456,465,'en',0,'The indicator is based on the dedicated survey of the funding organizations and its question ‘Has your organization integrated any type of ethics assessment/review in its funding decisions?’ (MORRI, 2017).'),('indicator',0,457,466,'en',0,'The indicator measures the researh funding obtained from grant applications.'),('indicator',0,458,467,'en',0,'The indicator shows the success of the initiative/project in aligning its research agenda with other partners.'),('indicator',0,459,468,'en',0,'The indicator shows how the public engagement elements are taken into account as evaluative criteria in research proposal evaluations and developments.'),('indicator',0,460,469,'en',0,'The indicator shows the development in defining the diagnosis, treatment, and mechanisms of diseases.'),('indicator',0,461,470,'en',0,'The indicator describes the positive and negative impacts for patients driven by the research and activities carried out by the initiative/project.'),('indicator',0,462,471,'en',0,'The indicator describes the positive and negative impacts for society driven by the research and activities carried out by the initiative/project.'),('indicator',0,463,472,'en',0,'The indicator evaluates whether the excellence of knowledge generated by health research goes together with practice changes in the application of the knowledge generated.'),('indicator',0,464,473,'en',0,'The indicator measures targeting of future research (follow-on projects).'),('indicator',0,465,474,'en',0,'The indicator informs about impact on future research.'),('indicator',0,466,475,'en',0,'The indicator informs about the adopted research priorities or strategies that mirror the impact of the initiative/project.'),('indicator',0,467,476,'en',0,'The indicator informs about the practical/clinical outcomes of projects.'),('indicator',0,468,477,'en',0,'The indicator informs about the extent to which knowledge generated by the initiative/project is effectively used in policy-making.'),('indicator',0,469,478,'en',0,'The indicator informs about how key clinical decision makers are aware of scientific evidence which is important for closing the gap between science and clinical care.'),('indicator',0,470,479,'en',0,'The indicator evaluates the extent to which the initiative/project develops research outputs that are actually being exploited.'),('indicator',0,471,480,'en',0,'The indicator assesses the willingness of the initiative/project to collaborate and share intellectual property with other research institutions to generate more advanced and improved research outputs with the capacity to generate an impact on patients\' wellbeing. Sharing intellectual property can accelerate the development of new products and treatments to maximize their potential.'),('indicator',0,472,481,'en',0,'This indicator evaluates the capacity of the initiative to generate research findings with applicable and economic exploitable potential. The indicator is clear and easy to calculate.'),('indicator',0,473,482,'en',0,'The clinical trial in human beings is a significant indicator for research assessment. Research projects can be assessed on the basis of whether they have progressed to clinical trials.'),('indicator',0,474,483,'en',0,'The indicator describes how potential users were taken into account by the research initiative/project.'),('indicator',0,475,484,'en',0,'The indicator evaluates the generation of drugs and other products that will be administered to patients as part of their treatment.'),('indicator',0,476,485,'en',0,'The indicator evaluates the capacity of the initiative to produce treatments and medical interventions that will improve the health and care of patients.'),('indicator',0,477,486,'en',0,'The indicator evaluates spin-offs as a result of the initiative/project.'),('indicator',0,478,487,'en',0,'The indicator evaluates the potential effect that the new developments of the initiative/project might have on patients.'),('indicator',0,479,488,'en',0,'The indicator evaluates the capacity of the initiative/project to collaborate with external partners.'),('indicator',0,480,489,'en',0,'The indicator shows the collaboration with potential users.'),('indicator',0,481,490,'en',0,'The indicator informs about the capacity to fund the commercialization of research findings.'),('indicator',0,482,491,'en',0,'The indicator is clear and easy to calculate.'),('indicator',0,483,492,'en',0,'This indicator evaluates the social recognition and prestige of the research initiative. The indicator is clear and easy to calculate.'),('indicator',0,484,493,'en',0,'The indicator evaluates the composition of the human capital of the initiative/project.'),('indicator',0,485,494,'en',0,'The indicator describes skills, knowledge and experience of the staff. It takes into account the needed equipment and technology to complete their work.'),('indicator',0,486,495,'en',0,'The indicator monitors female participation in decision-making and the overall gender balance of the decision-making process.'),('indicator',0,487,496,'en',0,'The indicator evaluates the representation of women across the whole initiative/project\'s researchers.'),('indicator',0,488,497,'en',0,'The indicator allows identifying the R&D expenses.'),('indicator',0,489,498,'en',0,'This indicator provides a comprehensive picture of the research organizational structure and its contribution to achieving the research strategy of the initiative/project.'),('indicator',0,490,499,'en',0,'The indicator allows to monitor the performance of research activities in the upstream research effort (e.g. computer-assited drug design).'),('indicator',0,491,500,'en',0,'The indicator provides information to evaluate the governance model and allows stakeholders to evaluate its participatory approch to engage them in the research process.'),('indicator',0,492,501,'en',0,'The indicator evaluates the direct engagement between researchers and practitioners to foster the implementation of research findings in clinical practice. By informing on the number of people that attend outreach visits, it assesses the level at which research findings are considered relevant by practitioners.'),('indicator',0,493,502,'en',0,'The indicator describes the long-term contribution of an initiative/project to improving future research, thereby leading to further knowledge that could lead to creating positive impacts.'),('indicator',0,494,503,'en',0,'The indicator shows the success and extent of participation. According to Graham et al. (2012) \'reach\' covers an aspect of stakeholder engagement that provides a measure of the \'who\' and the ‘interactions’ of stakeholder engagement.'),('indicator',0,495,504,'en',0,'D5.4 recommends (Recommendation 5.2.1) to “Implement structures and processes allowing to inform, engage, and seek feedback from internal and external stakeholders, including concerns about the initiative and its development”.\r\nFurther, D5.4 recommends to report on the number of consultation events with stakeholders.'),('indicator',0,496,505,'en',0,'The indicator provides a simple measure to evaluate the stakeholder engagement of the research initiative/project.'),('indicator',0,497,506,'en',0,'The indicator allows evaluating how research is perceived by society.'),('indicator',0,498,507,'en',0,'The indicator is feasible for research funding and performing organizations. The existence of enforcement procedures for the compliance with the code of ethical marketing and anti-corruption denotes the existence of such code.'),('indicator',0,499,508,'en',0,'The indicator evaluates the effectiveness of health, safety and security policy.'),('indicator',0,500,509,'en',0,'The indicator describes the impact on labour at the national/regional/local levels driven by the effect of research findings.'),('indicator',0,501,510,'en',0,'The comparison of this indicator contributes to evaluate the influence of the initiative/project on the overall labour condition by comparing its trend to the ones of the initiative/project.'),('indicator',0,502,511,'en',0,'The indicator evaluates the contribution of the initiative to improve the human capital and education of its research employees.'),('indicator',0,503,512,'en',0,'The indicator provides an overview of the influence of the research initiative/project in the development of health policies and guidelines.'),('indicator',0,504,513,'en',0,'The indicator allows the initiative/project to self-evaluate the governance and organization its research activities and identify best practices and measures that could help to improve them.'),('indicator',0,505,514,'en',0,'The indicator allows identifying new/closer external relevant actors (e.g. government agencies). The lack of relationships can be a weak point of a research initiative/project. Importance to enhance the possibility of research results to influence policy and practice.'),('indicator',0,506,515,'en',0,'The indicator allows stakeholders to evaluate the commitment regarding the management of environmental impacts resulting from research.'),('indicator',0,507,516,'en',0,'The indicator can be computed by applying clear guidelines. Considering the characteristics of research funding and performing organizations, it could be advisable to consider a relative measure of material intensity.'),('indicator',0,508,517,'en',0,'The indicator informs about the effect of the initiative/project on climate change through their GHG emissions. By providing data of the current and prior reporting periods, stakeholders can evaluate the evolution (reduction or increase) of emissions. Emissions can be computed using clear available guidelines.'),('indicator',0,509,518,'en',0,'The indicator seeks to identify the scope of community engagement efforts applied by the initiative/project.'),('indicator',0,510,519,'en',0,'The indicator provides information on the actions taken by the initiative/project to foster and increase the collaboration with communities.'),('indicator',0,512,521,'en',0,'The indicator informs about the consideration of RRI standards when performing research. In so doing, it provides stakeholders with information to assess the responsibility and ethics of the initiative/project\'s research process.'),('indicator',0,547,557,'en',0,'The indicator describes how the initiative/project takes into account patients and practitioners to implement research findings in health care practice.\r\n'),('indicator',0,548,558,'en',0,'The indicator demonstrates the accountability and transparency of research by providing information for stakeholders to evaluate it.'),('indicator',0,549,559,'en',0,'The indicator facilitates comparisons. Considering that the measurement of patients\' satisfaction with their level of Anxiety and Depression, the measurement of the percentage change provides a standardized measure of patient satisfaction. \r\n'),('indicator',0,550,560,'en',0,'The indicator facilitates comparisons. Considering that the measurement of patients\' satisfaction with their level of functional domains evaluated by the scale is disease-specific (MS), the measurement of the percentage change provides a standardized measure of patient satisfaction. \r\n'),('indicator',0,551,561,'en',0,'The indicator facilitates comparisons. Considering that the measurement of patients\' satisfaction with their level of bladder functions is disease-specific, the measurement of the percentage change provides a standardized measure of patient satisfaction. '),('indicator',0,552,562,'en',0,'The indicator facilitates comparisons. Considering that the measurement of patients\' satisfaction with the level of motor, cognitive, psyco-social fatigue is disease-specific (MS), the measurement of the percentage change provides a standardized measure of patient satisfaction. '),('indicator',0,553,563,'en',0,'The indicator facilitates comparisons. Considering that the measurement of patient satisfaction is disease-specific, the measurement of the percentage change provides a standardized measure of patient satisfaction. '),('indicator',0,554,564,'en',0,'The indicator facilitates comparisons. Considering that the measurement of patients\' satisfaction with their level of upper-limb dexterity is disease-specific, the measurement of the percentage change provides a standardized measure of patient satisfaction. '),('indicator',0,585,612,'en',0,'The indicator facilitates comparisons. Considering that the measurement of patients\' satisfaction with the level of locomotion is disease-specific (MS), the measurement of the percentage change provides a standardized measure of patient satisfaction. ');

--
-- Table structure for table `node_revision__field_scorecard_reference`
--

CREATE TABLE `node_revision__field_scorecard_reference` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_scorecard_reference_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_scorecard_reference_target_id` (`field_scorecard_reference_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_scorecard…';

--
-- Dumping data for table `node_revision__field_scorecard_reference`
--

INSERT INTO `node_revision__field_scorecard_reference` VALUES ('indicator',0,399,408,'en',0,24),('indicator',0,400,409,'en',0,25),('indicator',0,401,410,'en',0,25),('indicator',0,402,411,'en',0,26),('indicator',0,403,412,'en',0,26),('indicator',0,404,413,'en',0,26),('indicator',0,405,414,'en',0,26),('indicator',0,406,415,'en',0,27),('indicator',0,407,416,'en',0,28),('indicator',0,408,417,'en',0,29),('indicator',0,409,418,'en',0,30),('indicator',0,410,419,'en',0,31),('indicator',0,411,420,'en',0,32),('indicator',0,412,421,'en',0,33),('indicator',0,413,422,'en',0,34),('indicator',0,414,423,'en',0,35),('indicator',0,415,424,'en',0,36),('indicator',0,416,425,'en',0,37),('indicator',0,417,426,'en',0,100),('indicator',0,418,427,'en',0,100),('indicator',0,419,428,'en',0,108),('indicator',0,420,429,'en',0,109),('indicator',0,421,430,'en',0,177),('indicator',0,422,431,'en',0,112),('indicator',0,423,432,'en',0,112),('indicator',0,424,433,'en',0,112),('indicator',0,425,434,'en',0,113),('indicator',0,426,435,'en',0,114),('indicator',0,427,436,'en',0,113),('indicator',0,428,437,'en',0,115),('indicator',0,429,438,'en',0,115),('indicator',0,430,439,'en',0,115),('indicator',0,431,440,'en',0,116),('indicator',0,432,441,'en',0,117),('indicator',0,433,442,'en',0,118),('indicator',0,434,443,'en',0,119),('indicator',0,435,444,'en',0,120),('indicator',0,436,445,'en',0,121),('indicator',0,437,446,'en',0,122),('indicator',0,438,447,'en',0,123),('indicator',0,439,448,'en',0,263),('indicator',0,440,449,'en',0,125),('indicator',0,441,450,'en',0,126),('indicator',0,442,451,'en',0,127),('indicator',0,443,452,'en',0,127),('indicator',0,444,453,'en',0,127),('indicator',0,445,454,'en',0,128),('indicator',0,446,455,'en',0,129),('indicator',0,447,456,'en',0,129),('indicator',0,448,457,'en',0,129),('indicator',0,449,458,'en',0,130),('indicator',0,450,459,'en',0,131),('indicator',0,451,460,'en',0,130),('indicator',0,452,461,'en',0,133),('indicator',0,453,462,'en',0,134),('indicator',0,454,463,'en',0,135),('indicator',0,455,464,'en',0,135),('indicator',0,456,465,'en',0,135),('indicator',0,457,466,'en',0,136),('indicator',0,458,467,'en',0,136),('indicator',0,459,468,'en',0,136),('indicator',0,460,469,'en',0,137),('indicator',0,461,470,'en',0,137),('indicator',0,462,471,'en',0,137),('indicator',0,463,472,'en',0,138),('indicator',0,464,473,'en',0,139),('indicator',0,465,474,'en',0,139),('indicator',0,466,475,'en',0,139),('indicator',0,467,476,'en',0,140),('indicator',0,468,477,'en',0,141),('indicator',0,469,478,'en',0,142),('indicator',0,470,479,'en',0,143),('indicator',0,471,480,'en',0,144),('indicator',0,472,481,'en',0,145),('indicator',0,473,482,'en',0,146),('indicator',0,474,483,'en',0,147),('indicator',0,475,484,'en',0,148),('indicator',0,476,485,'en',0,148),('indicator',0,477,486,'en',0,148),('indicator',0,478,487,'en',0,148),('indicator',0,479,488,'en',0,149),('indicator',0,480,489,'en',0,149),('indicator',0,481,490,'en',0,149),('indicator',0,482,491,'en',0,150),('indicator',0,483,492,'en',0,151),('indicator',0,484,493,'en',0,152),('indicator',0,485,494,'en',0,152),('indicator',0,486,495,'en',0,153),('indicator',0,487,496,'en',0,153),('indicator',0,488,497,'en',0,154),('indicator',0,489,498,'en',0,155),('indicator',0,490,499,'en',0,156),('indicator',0,491,500,'en',0,157),('indicator',0,492,501,'en',0,158),('indicator',0,493,502,'en',0,159),('indicator',0,494,503,'en',0,160),('indicator',0,495,504,'en',0,161),('indicator',0,496,505,'en',0,160),('indicator',0,497,506,'en',0,162),('indicator',0,498,507,'en',0,163),('indicator',0,499,508,'en',0,164),('indicator',0,500,509,'en',0,165),('indicator',0,501,510,'en',0,165),('indicator',0,502,511,'en',0,166),('indicator',0,503,512,'en',0,167),('indicator',0,504,513,'en',0,168),('indicator',0,505,514,'en',0,169),('indicator',0,506,515,'en',0,170),('indicator',0,507,516,'en',0,171),('indicator',0,508,517,'en',0,173),('indicator',0,509,518,'en',0,174),('indicator',0,510,519,'en',0,175),('indicator',0,512,521,'en',0,132),('indicator',0,547,557,'en',0,147),('indicator',0,548,558,'en',0,172),('indicator',0,549,559,'en',0,184),('indicator',0,550,560,'en',0,263),('indicator',0,551,561,'en',0,185),('indicator',0,552,562,'en',0,188),('indicator',0,553,563,'en',0,263),('indicator',0,554,564,'en',0,189),('indicator',0,585,612,'en',0,265);

--
-- Table structure for table `node_revision__field_stakeholder_member_types`
--

CREATE TABLE `node_revision__field_stakeholder_member_types` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_stakeholder_member_types_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_stakeholder_member_types_target_id` (`field_stakeholder_member_types_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_stakeholder…';

--
-- Dumping data for table `node_revision__field_stakeholder_member_types`
--

INSERT INTO `node_revision__field_stakeholder_member_types` VALUES ('initiative',0,1,1,'en',0,1),('initiative',0,1,1,'en',1,4),('initiative',0,1,2,'en',0,1),('initiative',0,1,2,'en',1,4),('initiative',0,1,3,'en',0,1),('initiative',0,1,3,'en',1,4),('initiative',0,1,5,'en',0,1),('initiative',0,1,5,'en',1,4),('initiative',0,1,7,'en',0,1),('initiative',0,1,7,'en',1,4),('initiative',0,306,314,'en',0,2),('initiative',0,306,314,'en',1,3),('initiative',0,307,315,'en',0,1),('initiative',0,307,315,'en',1,2),('initiative',0,309,318,'en',0,1),('initiative',0,310,319,'en',0,1),('initiative',0,516,525,'en',0,5),('initiative',0,516,525,'en',1,6),('initiative',0,518,528,'en',0,1),('initiative',0,518,528,'en',1,4),('initiative',0,519,529,'en',0,5),('initiative',0,519,529,'en',1,6),('initiative',0,520,530,'en',0,3),('initiative',0,520,530,'en',1,5),('initiative',0,521,531,'en',0,6),('initiative',0,521,531,'en',1,7),('initiative',0,522,532,'en',0,2),('initiative',0,522,532,'en',1,4),('initiative',0,522,532,'en',2,8),('initiative',0,523,533,'en',0,1),('initiative',0,523,533,'en',1,2),('initiative',0,523,533,'en',2,4),('initiative',0,523,533,'en',3,8),('initiative',0,524,534,'en',0,2),('initiative',0,524,534,'en',1,4),('initiative',0,525,535,'en',0,1),('initiative',0,525,535,'en',1,7),('initiative',0,526,536,'en',0,4),('initiative',0,526,536,'en',1,6),('initiative',0,527,537,'en',0,1),('initiative',0,527,537,'en',1,3),('initiative',0,528,538,'en',0,1),('initiative',0,528,538,'en',1,3),('initiative',0,529,539,'en',0,2),('initiative',0,529,539,'en',1,5),('initiative',0,530,540,'en',0,2),('initiative',0,530,540,'en',1,4),('initiative',0,531,541,'en',0,1),('initiative',0,531,541,'en',1,3),('initiative',0,534,544,'en',0,1),('initiative',0,534,544,'en',1,3),('initiative',0,534,544,'en',2,4),('initiative',0,534,544,'en',3,8),('initiative',0,535,545,'en',0,4),('initiative',0,536,546,'en',0,5),('initiative',0,536,546,'en',1,6),('initiative',0,536,546,'en',2,8),('initiative',0,537,547,'en',0,3),('initiative',0,537,547,'en',1,4),('initiative',0,537,547,'en',2,5),('initiative',0,537,547,'en',3,8),('initiative',0,538,548,'en',0,3),('initiative',0,538,548,'en',1,4),('initiative',0,538,548,'en',2,5),('initiative',0,538,548,'en',3,6),('initiative',0,538,548,'en',4,7),('initiative',0,538,548,'en',5,8),('initiative',0,539,549,'en',0,3),('initiative',0,539,549,'en',1,4),('initiative',0,539,549,'en',2,6),('initiative',0,539,549,'en',3,7),('initiative',0,539,549,'en',4,8),('initiative',0,540,550,'en',0,1),('initiative',0,540,550,'en',1,2),('initiative',0,540,550,'en',2,3),('initiative',0,540,550,'en',3,4),('initiative',0,540,550,'en',4,5),('initiative',0,540,550,'en',5,6),('initiative',0,540,550,'en',6,7),('initiative',0,540,550,'en',7,8),('initiative',0,541,551,'en',0,1),('initiative',0,541,551,'en',1,2),('initiative',0,541,551,'en',2,4),('initiative',0,541,551,'en',3,6),('initiative',0,541,551,'en',4,8),('initiative',0,542,552,'en',0,1),('initiative',0,542,552,'en',1,2),('initiative',0,542,552,'en',2,3),('initiative',0,542,552,'en',3,4),('initiative',0,542,552,'en',4,6),('initiative',0,542,552,'en',5,7),('initiative',0,542,552,'en',6,8),('initiative',0,543,553,'en',0,1),('initiative',0,543,553,'en',1,2),('initiative',0,543,553,'en',2,3),('initiative',0,543,553,'en',3,4),('initiative',0,543,553,'en',4,7),('initiative',0,543,553,'en',5,8),('initiative',0,544,554,'en',0,3),('initiative',0,544,554,'en',1,6),('initiative',0,544,554,'en',2,7),('initiative',0,544,554,'en',3,8),('initiative',0,545,555,'en',0,4),('initiative',0,545,555,'en',1,8),('initiative',0,546,556,'en',0,2),('initiative',0,555,565,'en',0,1),('initiative',0,556,566,'en',0,2),('initiative',0,556,566,'en',1,4),('initiative',0,556,566,'en',2,5),('initiative',0,557,567,'en',0,8),('initiative',0,564,582,'en',0,7),('initiative',0,572,599,'en',0,1),('initiative',0,572,599,'en',1,2),('initiative',0,572,599,'en',2,4),('initiative',0,572,599,'en',3,8),('initiative',0,589,616,'en',0,3),('initiative',0,589,616,'en',1,8),('initiative',0,590,617,'en',0,1),('initiative',0,592,621,'en',0,2),('initiative',0,592,621,'en',1,3),('initiative',0,592,621,'en',2,4),('initiative',0,592,621,'en',3,8),('initiative',0,593,622,'en',0,1),('initiative',0,593,622,'en',1,2),('initiative',0,593,622,'en',2,4),('initiative',0,593,622,'en',3,6),('initiative',0,593,622,'en',4,8);

--
-- Table structure for table `node_revision__field_starting_year`
--

CREATE TABLE `node_revision__field_starting_year` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_starting_year_value` int(11) DEFAULT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_starting_year_value` (`field_starting_year_value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_starting_year.';

--
-- Dumping data for table `node_revision__field_starting_year`
--

INSERT INTO `node_revision__field_starting_year` VALUES ('initiative',0,1,1,'en',0,1960),('initiative',0,1,2,'en',0,1960),('initiative',0,1,3,'en',0,1960),('initiative',0,1,5,'en',0,1960),('initiative',0,1,7,'en',0,1960),('initiative',0,306,314,'en',0,2019),('initiative',0,307,315,'en',0,2018),('initiative',0,309,318,'en',0,1961),('initiative',0,310,319,'en',0,1977),('initiative',0,516,525,'en',0,1994),('initiative',0,518,528,'en',0,1962),('initiative',0,519,529,'en',0,1961),('initiative',0,520,530,'en',0,1960),('initiative',0,522,532,'en',0,2014),('initiative',0,523,533,'en',0,2016),('initiative',0,524,534,'en',0,1974),('initiative',0,525,535,'en',0,1972),('initiative',0,526,536,'en',0,1975),('initiative',0,527,537,'en',0,1960),('initiative',0,528,538,'en',0,1964),('initiative',0,529,539,'en',0,1974),('initiative',0,530,540,'en',0,1975),('initiative',0,531,541,'en',0,1975),('initiative',0,534,544,'en',0,2019),('initiative',0,535,545,'en',0,2019),('initiative',0,536,546,'en',0,1978),('initiative',0,537,547,'en',0,1989),('initiative',0,538,548,'en',0,2017),('initiative',0,539,549,'en',0,2016),('initiative',0,540,550,'en',0,1987),('initiative',0,541,551,'en',0,2019),('initiative',0,542,552,'en',0,2002),('initiative',0,543,553,'en',0,2012),('initiative',0,544,554,'en',0,2019),('initiative',0,545,555,'en',0,2015),('initiative',0,546,556,'en',0,2000),('initiative',0,555,565,'en',0,1976),('initiative',0,556,566,'en',0,2019),('initiative',0,557,567,'en',0,2019),('initiative',0,564,582,'en',0,1964),('initiative',0,572,599,'en',0,2020),('initiative',0,589,616,'en',0,2020),('initiative',0,590,617,'en',0,1973),('initiative',0,592,621,'en',0,2013),('initiative',0,593,622,'en',0,2020);

--
-- Table structure for table `node_revision__field_tags`
--

CREATE TABLE `node_revision__field_tags` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_tags_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_tags_target_id` (`field_tags_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_tags.';

--
-- Dumping data for table `node_revision__field_tags`
--


--
-- Table structure for table `node_revision__field_type_of_information_to_be_`
--

CREATE TABLE `node_revision__field_type_of_information_to_be_` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_type_of_information_to_be__value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_type_of_information_to_be__value` (`field_type_of_information_to_be__value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_type_of…';

--
-- Dumping data for table `node_revision__field_type_of_information_to_be_`
--

INSERT INTO `node_revision__field_type_of_information_to_be_` VALUES ('indicator',0,399,408,'en',0,'Free text'),('indicator',0,400,409,'en',0,'Percentage, with numerator and denominator'),('indicator',0,401,410,'en',0,'Number in physical units'),('indicator',0,401,410,'en',1,'Table with absolute numbers disaggregated per categories'),('indicator',0,402,411,'en',0,'Free text'),('indicator',0,402,411,'en',1,'Number in monetary units'),('indicator',0,403,412,'en',0,'Free text'),('indicator',0,404,413,'en',0,'Free text'),('indicator',0,405,414,'en',0,'Table with monetary units disaggregated per categories'),('indicator',0,406,415,'en',0,'Percentage, with numerator and denominator'),('indicator',0,407,416,'en',0,'Percentage, with numerator and denominator'),('indicator',0,408,417,'en',0,'Percentage, with numerator and denominator'),('indicator',0,409,418,'en',0,'Percentage, with numerator and denominator'),('indicator',0,410,419,'en',0,'Number in monetary units'),('indicator',0,411,420,'en',0,'Number in physical units'),('indicator',0,411,420,'en',1,'Percentage, with numerator and denominator'),('indicator',0,412,421,'en',0,'Number in physical units'),('indicator',0,413,422,'en',0,'Free text'),('indicator',0,413,422,'en',1,'Table with absolute numbers and ratios disaggregated per categories'),('indicator',0,414,423,'en',0,'Number in monetary units'),('indicator',0,415,424,'en',0,'Free text'),('indicator',0,415,424,'en',1,'Number in monetary units'),('indicator',0,416,425,'en',0,'Free text'),('indicator',0,416,425,'en',1,'Number in physical units'),('indicator',0,417,426,'en',0,'Number in physical units'),('indicator',0,418,427,'en',0,'Table with percentage disaggregated per categories'),('indicator',0,418,427,'en',1,'Table with absolute numbers disaggregated per categories'),('indicator',0,419,428,'en',0,'Number in physical units'),('indicator',0,420,429,'en',0,'Percentage, with numerator and denominator'),('indicator',0,421,430,'en',0,'Free text'),('indicator',0,422,431,'en',0,'Free text'),('indicator',0,422,431,'en',1,'Ordinal option list'),('indicator',0,423,432,'en',0,'Percentage, with numerator and denominator'),('indicator',0,424,433,'en',0,'Free text'),('indicator',0,425,434,'en',0,'Percentage, with numerator and denominator'),('indicator',0,426,435,'en',0,'Yes/No'),('indicator',0,427,436,'en',0,'Percentage, with numerator and denominator'),('indicator',0,428,437,'en',0,'Percentage, with numerator and denominator'),('indicator',0,429,438,'en',0,'Number in physical units'),('indicator',0,430,439,'en',0,'Number in physical units'),('indicator',0,430,439,'en',1,'Percentage, with numerator and denominator'),('indicator',0,431,440,'en',0,'Free text'),('indicator',0,432,441,'en',0,'Free text'),('indicator',0,432,441,'en',1,'Number in physical units'),('indicator',0,432,441,'en',2,'Table with absolute numbers and ratios disaggregated per categories'),('indicator',0,433,442,'en',0,'Percentage, with numerator and denominator'),('indicator',0,434,443,'en',0,'Free text'),('indicator',0,435,444,'en',0,'Number in physical units'),('indicator',0,436,445,'en',0,'Number in physical units'),('indicator',0,436,445,'en',1,'Proportion/Ratio, with numerator and denominator'),('indicator',0,437,446,'en',0,'Free text'),('indicator',0,437,446,'en',1,'Percentage, with numerator and denominator'),('indicator',0,438,447,'en',0,'Free text'),('indicator',0,439,448,'en',0,'Percentage, with numerator and denominator'),('indicator',0,440,449,'en',0,'Free text'),('indicator',0,441,450,'en',0,'Free text'),('indicator',0,442,451,'en',0,'Free text'),('indicator',0,442,451,'en',1,'Number in physical units'),('indicator',0,442,451,'en',2,'Percentage, with numerator and denominator'),('indicator',0,443,452,'en',0,'Number in physical units'),('indicator',0,444,453,'en',0,'Number in physical units'),('indicator',0,444,453,'en',1,'Percentage, with numerator and denominator'),('indicator',0,445,454,'en',0,'Free text'),('indicator',0,446,455,'en',0,'Number in physical units'),('indicator',0,447,456,'en',0,'Table with percentage disaggregated per categories'),('indicator',0,448,457,'en',0,'Number in physical units'),('indicator',0,449,458,'en',0,'Number in physical units'),('indicator',0,450,459,'en',0,'Number in physical units'),('indicator',0,451,460,'en',0,'Number in physical units'),('indicator',0,452,461,'en',0,'Free text'),('indicator',0,453,462,'en',0,'Free text'),('indicator',0,454,463,'en',0,'Free text'),('indicator',0,454,463,'en',1,'Yes/No'),('indicator',0,455,464,'en',0,'Free text'),('indicator',0,456,465,'en',0,'Free text'),('indicator',0,456,465,'en',1,'Yes/No'),('indicator',0,457,466,'en',0,'Table with absolute numbers disaggregated per categories'),('indicator',0,458,467,'en',0,'Number in monetary units'),('indicator',0,458,467,'en',1,'Number in physical units'),('indicator',0,459,468,'en',0,'Free text'),('indicator',0,459,468,'en',1,'Yes/No'),('indicator',0,460,469,'en',0,'Number in physical units'),('indicator',0,461,470,'en',0,'Free text'),('indicator',0,462,471,'en',0,'Free text'),('indicator',0,463,472,'en',0,'Free text'),('indicator',0,464,473,'en',0,'Free text'),('indicator',0,464,473,'en',1,'Ordinal option list'),('indicator',0,465,474,'en',0,'Free text'),('indicator',0,466,475,'en',0,'Free text'),('indicator',0,467,476,'en',0,'Free text'),('indicator',0,467,476,'en',1,'Number in physical units'),('indicator',0,468,477,'en',0,'Free text'),('indicator',0,469,478,'en',0,'Free text'),('indicator',0,470,479,'en',0,'Percentage, with numerator and denominator'),('indicator',0,471,480,'en',0,'Number in physical units'),('indicator',0,472,481,'en',0,'Number in physical units'),('indicator',0,472,481,'en',1,'Table with absolute numbers disaggregated per categories'),('indicator',0,473,482,'en',0,'Table with absolute numbers disaggregated per categories'),('indicator',0,474,483,'en',0,'Free text'),('indicator',0,475,484,'en',0,'Free text'),('indicator',0,475,484,'en',1,'Number in physical units'),('indicator',0,476,485,'en',0,'Number in physical units'),('indicator',0,477,486,'en',0,'Free text'),('indicator',0,477,486,'en',1,'Number in physical units'),('indicator',0,478,487,'en',0,'Free text'),('indicator',0,479,488,'en',0,'Free text'),('indicator',0,479,488,'en',1,'Number in physical units'),('indicator',0,480,489,'en',0,'Percentage, with numerator and denominator'),('indicator',0,481,490,'en',0,'Number in physical units'),('indicator',0,482,491,'en',0,'Table with absolute numbers disaggregated per categories'),('indicator',0,483,492,'en',0,'Number in physical units'),('indicator',0,484,493,'en',0,'Table with absolute numbers disaggregated per categories'),('indicator',0,485,494,'en',0,'Free text'),('indicator',0,486,495,'en',0,'Number in physical units'),('indicator',0,486,495,'en',1,'Percentage, with numerator and denominator'),('indicator',0,487,496,'en',0,'Percentage, with numerator and denominator'),('indicator',0,488,497,'en',0,'Number in monetary units'),('indicator',0,489,498,'en',0,'Free text'),('indicator',0,490,499,'en',0,'Percentage, with numerator and denominator'),('indicator',0,491,500,'en',0,'Free text'),('indicator',0,492,501,'en',0,'Number in physical units'),('indicator',0,493,502,'en',0,'Free text'),('indicator',0,493,502,'en',1,'Number in physical units'),('indicator',0,494,503,'en',0,'Table with absolute numbers disaggregated per categories'),('indicator',0,495,504,'en',0,'Free text'),('indicator',0,495,504,'en',1,'Number in physical units'),('indicator',0,496,505,'en',0,'Number in physical units'),('indicator',0,497,506,'en',0,'Free text'),('indicator',0,498,507,'en',0,'Free text'),('indicator',0,498,507,'en',1,'Yes/No'),('indicator',0,499,508,'en',0,'Number in physical units'),('indicator',0,500,509,'en',0,'Free text'),('indicator',0,501,510,'en',0,'Percentage, with numerator and denominator'),('indicator',0,502,511,'en',0,'Number in physical units'),('indicator',0,503,512,'en',0,'Free text'),('indicator',0,503,512,'en',1,'Number in physical units'),('indicator',0,504,513,'en',0,'Free text'),('indicator',0,505,514,'en',0,'Free text'),('indicator',0,506,515,'en',0,'Number in physical units'),('indicator',0,507,516,'en',0,'Number in physical units'),('indicator',0,508,517,'en',0,'Number in physical units'),('indicator',0,509,518,'en',0,'Number in physical units'),('indicator',0,509,518,'en',1,'Percentage, with numerator and denominator'),('indicator',0,510,519,'en',0,'Free text'),('indicator',0,512,521,'en',0,'Free text'),('indicator',0,547,557,'en',0,'Free text'),('indicator',0,548,558,'en',0,'Free text'),('indicator',0,548,558,'en',1,'Yes/No'),('indicator',0,549,559,'en',0,'Percentage, with numerator and denominator'),('indicator',0,550,560,'en',0,'Percentage, with numerator and denominator'),('indicator',0,551,561,'en',0,'Percentage, with numerator and denominator'),('indicator',0,552,562,'en',0,'Percentage, with numerator and denominator'),('indicator',0,553,563,'en',0,'Percentage, with numerator and denominator'),('indicator',0,554,564,'en',0,'Percentage, with numerator and denominator'),('indicator',0,585,612,'en',0,'Percentage, with numerator and denominator');

--
-- Table structure for table `node_revision__field_unit_of_measure`
--

CREATE TABLE `node_revision__field_unit_of_measure` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_unit_of_measure_value` longtext NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_unit_of…';

--
-- Dumping data for table `node_revision__field_unit_of_measure`
--

INSERT INTO `node_revision__field_unit_of_measure` VALUES ('indicator',0,399,408,'en',0,'N/A'),('indicator',0,400,409,'en',0,'Percentage'),('indicator',0,401,410,'en',0,'Absolute number'),('indicator',0,402,411,'en',0,'Local currency'),('indicator',0,403,412,'en',0,'N/A'),('indicator',0,404,413,'en',0,'N/A'),('indicator',0,405,414,'en',0,'Local currency'),('indicator',0,406,415,'en',0,'Percentage'),('indicator',0,407,416,'en',0,'Percentage'),('indicator',0,408,417,'en',0,'Percentage'),('indicator',0,409,418,'en',0,'Percentage'),('indicator',0,410,419,'en',0,'Local currency'),('indicator',0,411,420,'en',0,'Project/Milestone\r\nPercentage'),('indicator',0,412,421,'en',0,'Products and treatments'),('indicator',0,413,422,'en',0,'N/A'),('indicator',0,414,423,'en',0,'Local currency'),('indicator',0,415,424,'en',0,'Local currency'),('indicator',0,416,425,'en',0,'Product recall'),('indicator',0,417,426,'en',0,'Number of new employees'),('indicator',0,418,427,'en',0,'Employees\r\nPercentage'),('indicator',0,419,428,'en',0,'Number of medications'),('indicator',0,420,429,'en',0,'Percentage'),('indicator',0,421,430,'en',0,'N/A'),('indicator',0,422,431,'en',0,'Scale'),('indicator',0,423,432,'en',0,'Percentage'),('indicator',0,424,433,'en',0,'N/A'),('indicator',0,425,434,'en',0,'Percentage'),('indicator',0,426,435,'en',0,'N/A'),('indicator',0,427,436,'en',0,'Percentage'),('indicator',0,428,437,'en',0,'Percentage'),('indicator',0,429,438,'en',0,'Number of courses'),('indicator',0,430,439,'en',0,'People\r\nPercentage'),('indicator',0,431,440,'en',0,'N/A'),('indicator',0,432,441,'en',0,'Ratio; physical units'),('indicator',0,433,442,'en',0,'Percentage'),('indicator',0,434,443,'en',0,'N/A'),('indicator',0,435,444,'en',0,'Number of guidelines'),('indicator',0,436,445,'en',0,'Years\r\nQuality score (0 to 1)'),('indicator',0,437,446,'en',0,'Percentage'),('indicator',0,438,447,'en',0,'N/A'),('indicator',0,439,448,'en',0,'Percentage'),('indicator',0,440,449,'en',0,'N/A'),('indicator',0,441,450,'en',0,'N/A'),('indicator',0,442,451,'en',0,'Number of articles\r\nPercentage'),('indicator',0,443,452,'en',0,'Number of articles\r\nNumber of collaborating organizations'),('indicator',0,444,453,'en',0,'Number of articles\r\nPercentage'),('indicator',0,445,454,'en',0,'N/A'),('indicator',0,446,455,'en',0,'Citations'),('indicator',0,447,456,'en',0,'Percentage'),('indicator',0,448,457,'en',0,'Number of research studies that have been cited in guidelines'),('indicator',0,449,458,'en',0,'Number of activities'),('indicator',0,450,459,'en',0,'Number of mentions'),('indicator',0,451,460,'en',0,'Number of page views\r\nNumber of visitors\r\nNumber of requests'),('indicator',0,452,461,'en',0,'N/A'),('indicator',0,453,462,'en',0,'N/A'),('indicator',0,454,463,'en',0,'N/A'),('indicator',0,455,464,'en',0,'N/A'),('indicator',0,456,465,'en',0,'N/A'),('indicator',0,457,466,'en',0,'Local currency'),('indicator',0,458,467,'en',0,'Number of projects\r\nLocal currency'),('indicator',0,459,468,'en',0,'N/A'),('indicator',0,460,469,'en',0,'Number of taxonomies'),('indicator',0,461,470,'en',0,'N/A'),('indicator',0,462,471,'en',0,'N/A'),('indicator',0,463,472,'en',0,'N/A'),('indicator',0,464,473,'en',0,'Scale'),('indicator',0,465,474,'en',0,'N/A'),('indicator',0,466,475,'en',0,'N/A'),('indicator',0,467,476,'en',0,'Number of potential outcomes'),('indicator',0,468,477,'en',0,'N/A'),('indicator',0,469,478,'en',0,'N/A'),('indicator',0,470,479,'en',0,'Percentage'),('indicator',0,471,480,'en',0,'Number of research institutions'),('indicator',0,472,481,'en',0,'Number of patents'),('indicator',0,473,482,'en',0,'Number of clinical trials'),('indicator',0,474,483,'en',0,'N/A'),('indicator',0,475,484,'en',0,'Number of new drugs and other products developed'),('indicator',0,476,485,'en',0,'Number of new therapeutic advances developed'),('indicator',0,477,486,'en',0,'Number of spin-offs'),('indicator',0,478,487,'en',0,'Free text'),('indicator',0,479,488,'en',0,'Collaboration'),('indicator',0,480,489,'en',0,'Percentage'),('indicator',0,481,490,'en',0,'Number of consortia'),('indicator',0,482,491,'en',0,'Number of recognitions, awards, memberships, editorships, and advisory committees '),('indicator',0,483,492,'en',0,'Awards/prizes'),('indicator',0,484,493,'en',0,'Absolute number'),('indicator',0,485,494,'en',0,'N/A'),('indicator',0,486,495,'en',0,'Number of women\r\nPercentage'),('indicator',0,487,496,'en',0,'Percentage'),('indicator',0,488,497,'en',0,'Local currency'),('indicator',0,489,498,'en',0,'N/A'),('indicator',0,490,499,'en',0,'Percentage'),('indicator',0,491,500,'en',0,'N/A'),('indicator',0,492,501,'en',0,'Number of visits and number of people'),('indicator',0,493,502,'en',0,'Number of methodologies'),('indicator',0,494,503,'en',0,'Number of attendees per stakeholder category'),('indicator',0,495,504,'en',0,'Number of stakeholder engagement mechanisms'),('indicator',0,496,505,'en',0,'Number of stakeholders'),('indicator',0,497,506,'en',0,'N/A'),('indicator',0,498,507,'en',0,'N/A'),('indicator',0,499,508,'en',0,'Frequency rate'),('indicator',0,500,509,'en',0,'N/A'),('indicator',0,501,510,'en',0,'Percentage'),('indicator',0,502,511,'en',0,'Hour/employee'),('indicator',0,503,512,'en',0,'N/A'),('indicator',0,504,513,'en',0,'N/A'),('indicator',0,505,514,'en',0,'N/A'),('indicator',0,506,515,'en',0,'Physical units'),('indicator',0,507,516,'en',0,'Physical units'),('indicator',0,508,517,'en',0,'Tons'),('indicator',0,509,518,'en',0,'Physical units\r\nPercentage'),('indicator',0,510,519,'en',0,'N/A'),('indicator',0,512,521,'en',0,'N/A'),('indicator',0,547,557,'en',0,'N/A'),('indicator',0,548,558,'en',0,'N/A'),('indicator',0,549,559,'en',0,'Percentage'),('indicator',0,550,560,'en',0,'Percentage'),('indicator',0,551,561,'en',0,'Percentage'),('indicator',0,552,562,'en',0,'Percentage'),('indicator',0,553,563,'en',0,'PercentageAt the end of overall data collection and analysis\r\n'),('indicator',0,554,564,'en',0,'Percentage'),('indicator',0,585,612,'en',0,'Percentage\r\n');

--
-- Table structure for table `node_revision__field_use_indicator`
--

CREATE TABLE `node_revision__field_use_indicator` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_use_indicator_value` tinyint(4) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_use_indicator.';

--
-- Dumping data for table `node_revision__field_use_indicator`
--

INSERT INTO `node_revision__field_use_indicator` VALUES ('impact_analysis',0,532,542,'en',0,0),('impact_analysis',0,533,543,'en',0,0),('impact_analysis',0,559,577,'en',0,1),('impact_analysis',0,560,578,'en',0,0),('impact_analysis',0,561,579,'en',0,1),('impact_analysis',0,562,580,'en',0,1),('impact_analysis',0,563,581,'en',0,1),('impact_analysis',0,565,583,'en',0,1),('impact_analysis',0,566,584,'en',0,1),('impact_analysis',0,567,585,'en',0,1),('impact_analysis',0,568,586,'en',0,1),('impact_analysis',0,569,587,'en',0,1),('impact_analysis',0,574,601,'en',0,1),('impact_analysis',0,575,602,'en',0,1),('impact_analysis',0,576,603,'en',0,1),('impact_analysis',0,577,604,'en',0,1),('impact_analysis',0,578,605,'en',0,1),('impact_analysis',0,579,606,'en',0,1),('impact_analysis',0,580,607,'en',0,1),('impact_analysis',0,581,608,'en',0,1),('impact_analysis',0,582,609,'en',0,1),('impact_analysis',0,583,610,'en',0,1),('impact_analysis',0,584,611,'en',0,1),('impact_analysis',0,586,613,'en',0,1),('impact_analysis',0,587,614,'en',0,1),('impact_analysis',0,588,615,'en',0,1),('impact_analysis',0,591,620,'en',0,1);

--
-- Table structure for table `node_revision__field_user_id`
--

CREATE TABLE `node_revision__field_user_id` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_user_id_target_id` int(10) unsigned NOT NULL COMMENT 'The ID of the target entity.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_user_id_target_id` (`field_user_id_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_user_id.';

--
-- Dumping data for table `node_revision__field_user_id`
--

INSERT INTO `node_revision__field_user_id` VALUES ('impact_analysis',0,532,542,'en',0,1),('impact_analysis',0,533,543,'en',0,19),('impact_analysis',0,559,577,'en',0,19),('impact_analysis',0,560,578,'en',0,26),('impact_analysis',0,561,579,'en',0,26),('impact_analysis',0,562,580,'en',0,26),('impact_analysis',0,563,581,'en',0,26),('impact_analysis',0,565,583,'en',0,26),('impact_analysis',0,566,584,'en',0,21),('impact_analysis',0,567,585,'en',0,21),('impact_analysis',0,568,586,'en',0,21),('impact_analysis',0,569,587,'en',0,21),('impact_analysis',0,574,601,'en',0,45),('impact_analysis',0,575,602,'en',0,45),('impact_analysis',0,576,603,'en',0,45),('impact_analysis',0,577,604,'en',0,45),('impact_analysis',0,578,605,'en',0,45),('impact_analysis',0,579,606,'en',0,45),('impact_analysis',0,580,607,'en',0,45),('impact_analysis',0,581,608,'en',0,45),('impact_analysis',0,582,609,'en',0,45),('impact_analysis',0,583,610,'en',0,22),('impact_analysis',0,584,611,'en',0,22),('impact_analysis',0,586,613,'en',0,23),('impact_analysis',0,587,614,'en',0,23),('impact_analysis',0,588,615,'en',0,23),('impact_analysis',0,591,620,'en',0,21);

--
-- Table structure for table `node_revision__field_your_stakeholder_type`
--

CREATE TABLE `node_revision__field_your_stakeholder_type` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `field_your_stakeholder_type_value` varchar(255) NOT NULL,
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `field_your_stakeholder_type_value` (`field_your_stakeholder_type_value`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field field_your…';

--
-- Dumping data for table `node_revision__field_your_stakeholder_type`
--

INSERT INTO `node_revision__field_your_stakeholder_type` VALUES ('initiative',0,309,318,'en',0,'Industry'),('initiative',0,310,319,'en',0,'Patients'),('initiative',0,516,525,'en',0,'Industry'),('initiative',0,518,528,'en',0,'Industry'),('initiative',0,519,529,'en',0,'Patients'),('initiative',0,520,530,'en',0,'Industry'),('initiative',0,521,531,'en',0,'Payers and Purchasers'),('initiative',0,522,532,'en',0,'Research and Education Organizations'),('initiative',0,523,533,'en',0,'Patients Organizations'),('initiative',0,524,534,'en',0,'Industry'),('initiative',0,525,535,'en',0,'Industry'),('initiative',0,526,536,'en',0,'Industry'),('initiative',0,527,537,'en',0,'Care providers'),('initiative',0,528,538,'en',0,'Patients'),('initiative',0,529,539,'en',0,'Patients'),('initiative',0,530,540,'en',0,'Industry'),('initiative',0,531,541,'en',0,'Care providers'),('initiative',0,534,544,'en',0,'Patients Organizations'),('initiative',0,535,545,'en',0,'Patients Organizations'),('initiative',0,536,546,'en',0,'Research and Education Organizations'),('initiative',0,537,547,'en',0,'Research and Education Organizations'),('initiative',0,538,548,'en',0,'Care providers'),('initiative',0,539,549,'en',0,'Research and Education Organizations'),('initiative',0,540,550,'en',0,'Policy makers'),('initiative',0,541,551,'en',0,'Research and Education Organizations'),('initiative',0,542,552,'en',0,'Research and Education Organizations'),('initiative',0,543,553,'en',0,'Patients Organizations'),('initiative',0,544,554,'en',0,'Research and Education Organizations'),('initiative',0,545,555,'en',0,'Research and Education Organizations'),('initiative',0,546,556,'en',0,'Industry'),('initiative',0,555,565,'en',0,'Industry'),('initiative',0,556,566,'en',0,'Patients'),('initiative',0,557,567,'en',0,'Research and Education Organizations'),('initiative',0,564,582,'en',0,'Policy makers'),('initiative',0,572,599,'en',0,'Patients Organizations'),('initiative',0,589,616,'en',0,'Patients Organizations'),('initiative',0,590,617,'en',0,'Care providers'),('initiative',0,592,621,'en',0,'Patients Organizations'),('initiative',0,593,622,'en',0,'Research and Education Organizations');

--
-- Table structure for table `node_revision__webform`
--

CREATE TABLE `node_revision__webform` (
  `bundle` varchar(128) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The field instance bundle to which this row belongs, used when deleting a field instance',
  `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'A boolean indicating whether this data item has been deleted',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'The entity id this data is attached to',
  `revision_id` int(10) unsigned NOT NULL COMMENT 'The entity revision id this data is attached to',
  `langcode` varchar(32) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code for this data item.',
  `delta` int(10) unsigned NOT NULL COMMENT 'The sequence number for this data item, used for multi-value fields',
  `webform_target_id` varchar(32) CHARACTER SET ascii NOT NULL COMMENT 'The ID of the webform entity.',
  `webform_default_data` text DEFAULT NULL COMMENT 'Default submission data.',
  `webform_status` varchar(20) DEFAULT NULL COMMENT 'Flag to control whether this webform should be open, closed, or scheduled for new submissions.',
  `webform_open` varchar(20) DEFAULT NULL COMMENT 'The open date/time.',
  `webform_close` varchar(20) DEFAULT NULL COMMENT 'The close date/time.',
  PRIMARY KEY (`entity_id`,`revision_id`,`deleted`,`delta`,`langcode`),
  KEY `bundle` (`bundle`),
  KEY `revision_id` (`revision_id`),
  KEY `webform_target_id` (`webform_target_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='Revision archive storage for node field webform.';

--
-- Dumping data for table `node_revision__webform`
--

INSERT INTO `node_revision__webform` VALUES ('webform',0,514,523,'en',0,'demo_application',NULL,'open','',''),('webform',0,515,524,'en',0,'adherence_questionnaire','','open','',''),('webform',0,594,623,'en',0,'mscu_ecf_2020','','open','','');

--
-- Table structure for table `old_5e1593_url_alias`
--

CREATE TABLE `old_5e1593_url_alias` (
  `pid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'A unique path alias identifier.',
  `source` varchar(255) NOT NULL DEFAULT '' COMMENT 'The Drupal path this alias is for. e.g. node/12.',
  `alias` varchar(255) NOT NULL DEFAULT '' COMMENT 'The alias for this path. e.g. title-of-the-story.',
  `langcode` varchar(12) CHARACTER SET ascii NOT NULL DEFAULT '' COMMENT 'The language code this alias is for. if ''und'', the alias will be used for unknown languages. Each Drupal path can have an alias for each supported language.',
  PRIMARY KEY (`pid`),
  KEY `alias_langcode_pid` (`alias`(191),`langcode`,`pid`),
  KEY `source_langcode_pid` (`source`(191),`langcode`,`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COMMENT='A list of URL aliases for Drupal paths. a user may visit…';

--
-- Dumping data for table `old_5e1593_url_alias`
--

INSERT INTO `old_5e1593_url_alias` VALUES (1,'/node/305','/','en'),(2,'/webform/contact','/form/contact','en'),(3,'/webform/contact','/form/contact','und'),(4,'/webform/contact/confirmation','/form/contact/confirmation','en'),(5,'/webform/contact/confirmation','/form/contact/confirmation','und'),(6,'/webform/contact/submissions','/form/contact/submissions','en'),(7,'/webform/contact/submissions','/form/contact/submissions','und'),(8,'/webform/contact/drafts','/form/contact/drafts','en'),(9,'/webform/contact/drafts','/form/contact/drafts','und'),(10,'/webform/demo_application_evaluation','/form/demo-application-evaluation','en'),(11,'/webform/demo_application_evaluation','/form/demo-application-evaluation','und'),(12,'/webform/demo_application_evaluation/confirmation','/form/demo-application-evaluation/confirmation','en'),(13,'/webform/demo_application_evaluation/confirmation','/form/demo-application-evaluation/confirmation','und'),(14,'/webform/demo_application_evaluation/submissions','/form/demo-application-evaluation/submissions','en'),(15,'/webform/demo_application_evaluation/submissions','/form/demo-application-evaluation/submissions','und'),(16,'/webform/demo_application_evaluation/drafts','/form/demo-application-evaluation/drafts','en'),(17,'/webform/demo_application_evaluation/drafts','/form/demo-application-evaluation/drafts','und'),(18,'/webform/demo_application','/form/demo-application','en'),(19,'/webform/demo_application','/form/demo-application','und'),(20,'/webform/demo_application/confirmation','/form/demo-application/confirmation','en'),(21,'/webform/demo_application/confirmation','/form/demo-application/confirmation','und'),(22,'/webform/demo_application/submissions','/form/demo-application/submissions','en'),(23,'/webform/demo_application/submissions','/form/demo-application/submissions','und'),(24,'/webform/demo_application/drafts','/form/demo-application/drafts','en'),(25,'/webform/demo_application/drafts','/form/demo-application/drafts','und'),(26,'/webform/adherence_questionnaire','/form/adherence-questionnaire','en'),(27,'/webform/adherence_questionnaire','/form/adherence-questionnaire','und'),(28,'/webform/adherence_questionnaire/confirmation','/form/adherence-questionnaire/confirmation','en'),(29,'/webform/adherence_questionnaire/confirmation','/form/adherence-questionnaire/confirmation','und'),(30,'/webform/adherence_questionnaire/submissions','/form/adherence-questionnaire/submissions','en'),(31,'/webform/adherence_questionnaire/submissions','/form/adherence-questionnaire/submissions','und'),(32,'/webform/adherence_questionnaire/drafts','/form/adherence-questionnaire/drafts','en'),(33,'/webform/adherence_questionnaire/drafts','/form/adherence-questionnaire/drafts','und'),(35,'/webform/multi_act_framework_baseline_ana','/form/multi-act-framework-baseline-ana','en'),(36,'/webform/multi_act_framework_baseline_ana','/form/multi-act-framework-baseline-ana','und'),(37,'/webform/multi_act_framework_baseline_ana/confirmation','/form/multi-act-framework-baseline-ana/confirmation','en'),(38,'/webform/multi_act_framework_baseline_ana/confirmation','/form/multi-act-framework-baseline-ana/confirmation','und'),(39,'/webform/multi_act_framework_baseline_ana/submissions','/form/multi-act-framework-baseline-ana/submissions','en'),(40,'/webform/multi_act_framework_baseline_ana/submissions','/form/multi-act-framework-baseline-ana/submissions','und'),(41,'/webform/multi_act_framework_baseline_ana/drafts','/form/multi-act-framework-baseline-ana/drafts','en'),(42,'/webform/multi_act_framework_baseline_ana/drafts','/form/multi-act-framework-baseline-ana/drafts','und'),(43,'/node/532','/impact-analysis/Impact-Analysis-test','en'),(44,'/node/533','/impact-analysis/ms-initiative-01','en');

--
-- Table structure for table `path_alias`
--

CREATE TABLE `path_alias` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `revision_id` int(10) unsigned DEFAULT NULL,
  `uuid` varchar(128) CHARACTER SET ascii NOT NULL,
  `langcode` varchar(12) CHARACTER SET ascii NOT NULL,
  `path` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `path_alias_field__uuid__value` (`uuid`),
  UNIQUE KEY `path_alias__revision_id` (`revision_id`),
  KEY `path_alias__status` (`status`,`id`),
  KEY `path_alias__alias_langcode_id_status` (`alias`(191),`langcode`,`id`,`status`),
  KEY `path_alias__path_langcode_id_status` (`path`(191),`langcode`,`id`,`status`)
) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8mb4 COMMENT='The base table for path_alias entities.';

--
-- Dumping data for table `path_alias`
--

INSERT INTO `path_alias` VALUES (1,1,'ffb1a124-28e5-4016-9b34-9c1b5a05731b','en','/node/305','/',1),(2,2,'aeba9fe8-9a29-4e5a-ada0-3da2be263165','en','/webform/contact','/form/contact',1),(3,3,'40395329-7539-4e05-ac01-d29ee885823f','und','/webform/contact','/form/contact',1),(4,4,'4496446e-c494-4135-91fa-aacd5d77dc16','en','/webform/contact/confirmation','/form/contact/confirmation',1),(5,5,'99c83829-835b-499d-9932-5eb3cc30365f','und','/webform/contact/confirmation','/form/contact/confirmation',1),(6,6,'07112d9c-166c-457b-8469-a6dec9af7880','en','/webform/contact/submissions','/form/contact/submissions',1),(7,7,'41a52e75-4d7b-450e-a577-99f5d979ef39','und','/webform/contact/submissions','/form/contact/submissions',1),(8,8,'c0b1e128-a553-4640-bee6-49923e11ceab','en','/webform/contact/drafts','/form/contact/drafts',1),(9,9,'cc4c22fc-fe6a-42b9-9acc-6e8e643059c0','und','/webform/contact/drafts','/form/contact/drafts',1),(10,10,'328d5e61-7839-4825-9be7-28ae932e1301','en','/webform/demo_application_evaluation','/form/demo-application-evaluation',1),(11,11,'cd683e72-2f7a-470b-819d-647fe4778fff','und','/webform/demo_application_evaluation','/form/demo-application-evaluation',1),(12,12,'11b103df-c05d-4f04-8fad-7c5896ed1178','en','/webform/demo_application_evaluation/confirmation','/form/demo-application-evaluation/confirmation',1),(13,13,'7ebdea7b-2ccc-422f-9a4e-09b6162e5d62','und','/webform/demo_application_evaluation/confirmation','/form/demo-application-evaluation/confirmation',1),(14,14,'29add955-7ffd-43ea-8d05-2c07ca8a4914','en','/webform/demo_application_evaluation/submissions','/form/demo-application-evaluation/submissions',1),(15,15,'acec9c3a-682d-4d47-9fdc-21cee6382a63','und','/webform/demo_application_evaluation/submissions','/form/demo-application-evaluation/submissions',1),(16,16,'4c37f153-8ea3-4ef6-8798-9137d31b3ae8','en','/webform/demo_application_evaluation/drafts','/form/demo-application-evaluation/drafts',1),(17,17,'166e70a4-f9a0-4022-9cd4-7876484d15e9','und','/webform/demo_application_evaluation/drafts','/form/demo-application-evaluation/drafts',1),(18,18,'441446fe-7afd-4203-940b-b7ff2ee22a01','en','/webform/demo_application','/form/demo-application',1),(19,19,'d9fd65af-f796-4795-ad81-c017ba83452f','und','/webform/demo_application','/form/demo-application',1),(20,20,'f0d48ca4-d506-4ade-bbe9-cc3221d30362','en','/webform/demo_application/confirmation','/form/demo-application/confirmation',1),(21,21,'6520ad97-4e04-469a-840f-75d645acddf7','und','/webform/demo_application/confirmation','/form/demo-application/confirmation',1),(22,22,'d36fe515-d5b2-43fe-88ff-e3736a863b31','en','/webform/demo_application/submissions','/form/demo-application/submissions',1),(23,23,'ddf77a90-d486-4cbf-95ff-6c72eccbd785','und','/webform/demo_application/submissions','/form/demo-application/submissions',1),(24,24,'a9ee4781-7d55-4eea-a421-bf657f4f0290','en','/webform/demo_application/drafts','/form/demo-application/drafts',1),(25,25,'0e64ba6e-3518-499b-998e-725c324aac9f','und','/webform/demo_application/drafts','/form/demo-application/drafts',1),(26,26,'92833712-013c-442c-9e0e-6b2bcb0b98c3','en','/webform/adherence_questionnaire','/form/adherence-questionnaire',1),(27,27,'a9217ee2-3c7e-471e-884c-b236b8a2d102','und','/webform/adherence_questionnaire','/form/adherence-questionnaire',1),(28,28,'87dd929d-becc-4ca2-9be9-063049345ad6','en','/webform/adherence_questionnaire/confirmation','/form/adherence-questionnaire/confirmation',1),(29,29,'4fb92b0b-d99e-4b2f-b09e-e6730d084d5b','und','/webform/adherence_questionnaire/confirmation','/form/adherence-questionnaire/confirmation',1),(30,30,'34a4a73f-ca64-403a-aae0-7395ff9ce6f0','en','/webform/adherence_questionnaire/submissions','/form/adherence-questionnaire/submissions',1),(31,31,'abd0c1b6-8eca-45cf-90c5-53c48bbcaf8f','und','/webform/adherence_questionnaire/submissions','/form/adherence-questionnaire/submissions',1),(32,32,'99f0c02b-ab3a-4fe3-8bf3-bb657fa56356','en','/webform/adherence_questionnaire/drafts','/form/adherence-questionnaire/drafts',1),(33,33,'b8033d94-db83-4c60-b0a1-4c378f53380b','und','/webform/adherence_questionnaire/drafts','/form/adherence-questionnaire/drafts',1),(43,43,'733dd6db-f675-4bae-a9d6-351c5bbd79fc','en','/node/532','/impact-analysis/Impact-Analysis-test',1),(44,44,'c73abdee-dc64-4bd9-8231-05d25d4bbbad','en','/node/533','/impact-analysis/ms-initiative-01',1),(45,45,'353b6de9-cef4-4b16-b7f1-b15055d3e944','en','/webform/multi_act_framework_baseline_ana','/form/multi-act-framework-baseline-ana',1),(46,46,'1c059e07-deb1-4992-931c-6b20affe4f9c','und','/webform/multi_act_framework_baseline_ana','/form/multi-act-framework-baseline-ana',1),(47,47,'e266e8d7-115a-424b-84c7-fc000234dcd5','en','/webform/multi_act_framework_baseline_ana/confirmation','/form/multi-act-framework-baseline-ana/confirmation',1),(48,48,'078c2ad5-e60e-4700-ae98-b9de2a62cc9a','und','/webform/multi_act_framework_baseline_ana/confirmation','/form/multi-act-framework-baseline-ana/confirmation',1),(49,49,'c91024b8-551c-4e5c-8d6c-bbb25069b008','en','/webform/multi_act_framework_baseline_ana/submissions','/form/multi-act-framework-baseline-ana/submissions',1),(50,50,'05d63a5d-d191-4501-b819-caa96244e58c','und','/webform/multi_act_framework_baseline_ana/submissions','/form/multi-act-framework-baseline-ana/submissions',1),(51,51,'ffbe780a-5bbb-4d9b-868d-afa5b84fe813','en','/webform/multi_act_framework_baseline_ana/drafts','/form/multi-act-framework-baseline-ana/drafts',1),(52,52,'33b93841-190f-4435-8a3b-983bf970d546','und','/webform/multi_act_framework_baseline_ana/drafts','/form/multi-act-framework-baseline-ana/drafts',1),(53,53,'3aba59ac-57ea-42e1-9ed1-99889c5d549b','en','/webform/variables_to_be_included_in_the_','/form/variables-to-be-included-in-the-',1),(54,54,'6f1c9fe0-8839-4a8c-b409-4e12a1d05dea','und','/webform/variables_to_be_included_in_the_','/form/variables-to-be-included-in-the-',1),(55,55,'4696fb4a-2a4e-4d75-8ed7-0b92fab2f0af','en','/webform/variables_to_be_included_in_the_/confirmation','/form/variables-to-be-included-in-the-/confirmation',1),(56,56,'3ac7f2d5-62e7-4936-b3f1-588b1ea37904','und','/webform/variables_to_be_included_in_the_/confirmation','/form/variables-to-be-included-in-the-/confirmation',1),(57,57,'5174883d-a0cd-42ab-a5af-e67b42e56792','en','/webform/variables_to_be_included_in_the_/submissions','/form/variables-to-be-included-in-the-/submissions',1),(58,58,'0a064c5a-4474-4b8c-923c-e31c84727726','und','/webform/variables_to_be_included_in_the_/submissions','/form/variables-to-be-included-in-the-/submissions',1),(59,59,'09c688fc-708d-4a98-8ba4-d950137d3698','en','/webform/variables_to_be_included_in_the_/drafts','/form/variables-to-be-included-in-the-/drafts',1),(60,60,'d98a4618-0fa4-4459-a108-f9bdfd5cdecd','und','/webform/variables_to_be_included_in_the_/drafts','/form/variables-to-be-included-in-the-/drafts',1),(61,61,'598f7631-2be3-4a09-b240-2ce3ff336b4d','en','/webform/mscu_ecf_2018_practising_neurolo','/form/mscu-ecf-2018-practising-neurolo',1),(62,62,'d46cef28-d253-4185-877f-0f00e975eea2','und','/webform/mscu_ecf_2018_practising_neurolo','/form/mscu-ecf-2018-practising-neurolo',1),(63,63,'a8ca56e7-a862-4595-8db0-5b0fd6c42c45','en','/webform/mscu_ecf_2018_practising_neurolo/confirmation','/form/mscu-ecf-2018-practising-neurolo/confirmation',1),(64,64,'3497073a-28ef-47dc-a30a-45835c329ade','und','/webform/mscu_ecf_2018_practising_neurolo/confirmation','/form/mscu-ecf-2018-practising-neurolo/confirmation',1),(65,65,'b10a7a5e-5bea-4869-81f2-cf2ece27590f','en','/webform/mscu_ecf_2018_practising_neurolo/submissions','/form/mscu-ecf-2018-practising-neurolo/submissions',1),(66,66,'79a6de26-a9c9-41aa-b7cf-e524d5fc60af','und','/webform/mscu_ecf_2018_practising_neurolo/submissions','/form/mscu-ecf-2018-practising-neurolo/submissions',1),(67,67,'41b723df-0291-449e-bd48-dcd9855abbae','en','/webform/mscu_ecf_2018_practising_neurolo/drafts','/form/mscu-ecf-2018-practising-neurolo/drafts',1),(68,68,'716aa250-be25-4c13-8c0b-62245736503e','und','/webform/mscu_ecf_2018_practising_neurolo/drafts','/form/mscu-ecf-2018-practising-neurolo/drafts',1),(69,69,'01fdbaf0-09dd-4eb9-8243-b8ba34570051','en','/node/558','/MS-Care-Unit-Baseline-Analysis',1),(70,70,'617f146b-8459-4136-9134-b4abf30eb1d7','en','/webform/mscu_ecf_2018_academic_mscu','/form/mscu-ecf-2018-academic-mscu',1),(71,71,'36fa5e8f-4127-4c61-869e-b2227acda675','und','/webform/mscu_ecf_2018_academic_mscu','/form/mscu-ecf-2018-academic-mscu',1),(72,72,'f1adc36b-b7a0-40d0-b7dd-4c4b2bd65731','en','/webform/mscu_ecf_2018_academic_mscu/confirmation','/form/mscu-ecf-2018-academic-mscu/confirmation',1),(73,73,'760665b2-f2b6-408b-9657-56864a3f4a31','und','/webform/mscu_ecf_2018_academic_mscu/confirmation','/form/mscu-ecf-2018-academic-mscu/confirmation',1),(74,74,'30908d6a-79b1-4012-bd40-812a1a44dbf4','en','/webform/mscu_ecf_2018_academic_mscu/submissions','/form/mscu-ecf-2018-academic-mscu/submissions',1),(75,75,'168e95a3-4720-4130-8db4-1a6fbdad0509','und','/webform/mscu_ecf_2018_academic_mscu/submissions','/form/mscu-ecf-2018-academic-mscu/submissions',1),(76,76,'58c7352b-4578-4f6f-8913-0e1ae1bfd8ad','en','/webform/mscu_ecf_2018_academic_mscu/drafts','/form/mscu-ecf-2018-academic-mscu/drafts',1),(77,77,'e6e4cb39-63eb-4a6a-82eb-18d462e52eef','und','/webform/mscu_ecf_2018_academic_mscu/drafts','/form/mscu-ecf-2018-academic-mscu/drafts',1),(78,78,'607131cb-4cba-4ae5-8cab-5044b3208792','en','/webform/mscu_ecf_2018_academic_mscu_init','/form/mscu-ecf-2018-academic-mscu-init',1),(79,79,'081a3801-7dc1-4afd-b636-4c950bc90c7d','und','/webform/mscu_ecf_2018_academic_mscu_init','/form/mscu-ecf-2018-academic-mscu-init',1),(80,80,'decf0f8c-028f-4f27-a122-ce3bb11ef048','en','/webform/mscu_ecf_2018_academic_mscu_init/confirmation','/form/mscu-ecf-2018-academic-mscu-init/confirmation',1),(81,81,'7a14cb28-4ac8-463d-a78f-eec2a07f70b0','und','/webform/mscu_ecf_2018_academic_mscu_init/confirmation','/form/mscu-ecf-2018-academic-mscu-init/confirmation',1),(82,82,'2d39f896-528b-4205-bee7-f63d513b8831','en','/webform/mscu_ecf_2018_academic_mscu_init/submissions','/form/mscu-ecf-2018-academic-mscu-init/submissions',1),(83,83,'09fe933d-362a-4212-b0a2-1069403f79e9','und','/webform/mscu_ecf_2018_academic_mscu_init/submissions','/form/mscu-ecf-2018-academic-mscu-init/submissions',1),(84,84,'b238415c-c305-4839-bea0-82bc34c7d7f4','en','/webform/mscu_ecf_2018_academic_mscu_init/drafts','/form/mscu-ecf-2018-academic-mscu-init/drafts',1),(85,85,'c7b791ea-2e72-44dd-84f3-4fe4a21cb59b','und','/webform/mscu_ecf_2018_academic_mscu_init/drafts','/form/mscu-ecf-2018-academic-mscu-init/drafts',1),(86,86,'46fc057a-cad7-49fa-bdae-b2b339f3a383','en','/webform/materiality_analysis','/form/materiality-analysis',1),(87,87,'0f628737-5333-4b3f-87f8-ba5750bbe21a','und','/webform/materiality_analysis','/form/materiality-analysis',1),(88,88,'0ddca0d6-552b-4275-9134-e01146867464','en','/webform/materiality_analysis/confirmation','/form/materiality-analysis/confirmation',1),(89,89,'968bfeed-8768-4216-8ebc-cab8a9752526','und','/webform/materiality_analysis/confirmation','/form/materiality-analysis/confirmation',1),(90,90,'06bf3f7b-ab75-432e-8210-c9178b047411','en','/webform/materiality_analysis/submissions','/form/materiality-analysis/submissions',1),(91,91,'12a9f7c5-55eb-4f98-8112-70b3f4182572','und','/webform/materiality_analysis/submissions','/form/materiality-analysis/submissions',1),(92,92,'cb076b72-601a-42b7-b2b6-8df8a72e0f44','en','/webform/materiality_analysis/drafts','/form/materiality-analysis/drafts',1),(93,93,'013c40a0-a0fd-46a8-8a5a-e0340bb9a808','und','/webform/materiality_analysis/drafts','/form/materiality-analysis/drafts',1),(94,94,'0be87043-b3bd-4116-a814-3c3b6fe1b9bb','en','/webform/mscu_ecf_2018_non_academic_mscu','/form/mscu-ecf-2018-non-academic-mscu',1),(95,95,'74f6e975-93bc-4eea-bd9b-19eaad64e23d','und','/webform/mscu_ecf_2018_non_academic_mscu','/form/mscu-ecf-2018-non-academic-mscu',1),(96,96,'8094048d-a3d6-44fc-96d6-cdb29f2b0ae3','en','/webform/mscu_ecf_2018_non_academic_mscu/confirmation','/form/mscu-ecf-2018-non-academic-mscu/confirmation',1),(97,97,'524ed018-1342-4f81-8554-48c553e561e2','und','/webform/mscu_ecf_2018_non_academic_mscu/confirmation','/form/mscu-ecf-2018-non-academic-mscu/confirmation',1),(98,98,'655cd995-e733-438e-820c-3fa8cecdd83d','en','/webform/mscu_ecf_2018_non_academic_mscu/submissions','/form/mscu-ecf-2018-non-academic-mscu/submissions',1),(99,99,'0f58dd8a-3e7b-402c-9757-ec3ad21229b3','und','/webform/mscu_ecf_2018_non_academic_mscu/submissions','/form/mscu-ecf-2018-non-academic-mscu/submissions',1),(100,100,'491b7089-8c2c-4efd-9863-54496b8a57af','en','/webform/mscu_ecf_2018_non_academic_mscu/drafts','/form/mscu-ecf-2018-non-academic-mscu/drafts',1),(101,101,'5abae5ac-b3ef-4784-a110-6d565bae73e5','und','/webform/mscu_ecf_2018_non_academic_mscu/drafts','/form/mscu-ecf-2018-non-academic-mscu/drafts',1),(103,103,'80819d82-0d21-4d2f-9537-aac7a9cd8e2f','en','/webform/mscu_ecf_2020','/form/mscu-ecf-2020',1),(104,104,'2b553b90-59e4-4e49-a935-d84d3968cc3a','und','/webform/mscu_ecf_2020','/form/mscu-ecf-2020',1),(105,105,'2d25a810-2d2f-436c-b9e7-4071ce3a830d','en','/webform/mscu_ecf_2020/confirmation','/form/mscu-ecf-2020/confirmation',1),(106,106,'baefe8a0-4399-4008-b5e1-5bdd923b3d40','und','/webform/mscu_ecf_2020/confirmation','/form/mscu-ecf-2020/confirmation',1),(107,107,'fd50ff0d-8508-4ad7-a153-8a81a787ae15','en','/webform/mscu_ecf_2020/submissions','/form/mscu-ecf-2020/submissions',1),(108,108,'bd412236-1b49-4030-835e-963e760242f0','und','/webform/mscu_ecf_2020/submissions','/form/mscu-ecf-2020/submissions',1),(109,109,'d19c8c20-e5ba-4e68-af4a-fdc9644179af','en','/webform/mscu_ecf_2020/drafts','/form/mscu-ecf-2020/drafts',1),(110,110,'22b874f3-376e-4b21-9e13-7727c79a3e8f','und','/webform/mscu_ecf_2020/drafts','/form/mscu-ecf-2020/drafts',1),(111,111,'c50a9075-0363-4df7-a616-31163cf3999b','en','/webform/mscu_ecf_2020_for_check_','/form/mscu-ecf-2020-for-check-',1),(112,112,'e21134db-4c2a-4611-9b13-cf87eae24274','und','/webform/mscu_ecf_2020_for_check_','/form/mscu-ecf-2020-for-check-',1),(113,113,'482d0455-99c8-4320-a58f-454e4d9680e9','en','/webform/mscu_ecf_2020_for_check_/confirmation','/form/mscu-ecf-2020-for-check-/confirmation',1),(114,114,'68474916-cb54-4426-9b11-10221c72d6c2','und','/webform/mscu_ecf_2020_for_check_/confirmation','/form/mscu-ecf-2020-for-check-/confirmation',1),(115,115,'87bad6d1-d2b8-4c26-bb90-53f65e6b095a','en','/webform/mscu_ecf_2020_for_check_/submissions','/form/mscu-ecf-2020-for-check-/submissions',1),(116,116,'4fbc3392-0a6c-410b-9b2d-186d8cf41dbf','und','/webform/mscu_ecf_2020_for_check_/submissions','/form/mscu-ecf-2020-for-check-/submissions',1),(117,117,'0a97eb57-8b16-4352-9acf-ed893c28dc5c','en','/webform/mscu_ecf_2020_for_check_/drafts','/form/mscu-ecf-2020-for-check-/drafts',1),(118,118,'5cf58d24-71c3-4916-aad0-91feb3aef4d2','und','/webform/mscu_ecf_2020_for_check_/drafts','/form/mscu-ecf-2020-for-check-/drafts',1),(119,119,'2f06fc7f-8429-47c0-8acd-522f169b502f','en','/webform/open','/form/open',1),(120,120,'73041a94-5e17-4452-9ac1-990c8d531647','und','/webform/open','/form/open',1),(121,121,'b0f596b1-f903-402f-ae47-0a20de45483f','en','/webform/open/confirmation','/form/open/confirmation',1),(122,122,'37a001b1-0c81-4ffb-960b-17d9d6a4d21c','und','/webform/open/confirmation','/form/open/confirmation',1),(123,123,'c1ef7a24-4228-436c-8718-0c8a19953d1d','en','/webform/open/submissions','/form/open/submissions',1),(124,124,'9432cddc-8f67-43ee-94b4-1bbf4bca053f','und','/webform/open/submissions','/form/open/submissions',1),(125,125,'d26ed564-e09a-4cf7-8d64-803e3ad5b8e9','en','/webform/open/drafts','/form/open/drafts',1),(126,126,'a051b688-0da7-4e5f-a5a8-3e024e4b02ce','und','/webform/open/drafts','/form/open/drafts',1),(127,127,'870d0727-c415-4e9f-98b4-e713bec20b71','en','/webform/mail_invitation','/form/mail-invitation',1),(128,128,'f69a16fb-8bb5-4691-b9e9-20512ef0277a','und','/webform/mail_invitation','/form/mail-invitation',1),(129,129,'aa08b38b-5560-4cc7-aa92-0c7ed4e71c07','en','/webform/mail_invitation/confirmation','/form/mail-invitation/confirmation',1),(130,130,'a4d132bc-f867-4dea-9815-35ce7d78a576','und','/webform/mail_invitation/confirmation','/form/mail-invitation/confirmation',1),(131,131,'198f4cb0-1d71-48d3-8048-4f76f8aec260','en','/webform/mail_invitation/submissions','/form/mail-invitation/submissions',1),(132,132,'6aaa6e89-764c-4002-be86-10f8ec16f296','und','/webform/mail_invitation/submissions','/form/mail-invitation/submissions',1),(133,133,'4d6bffcc-dc2a-40e1-94b1-91f2164f4fd8','en','/webform/mail_invitation/drafts','/form/mail-invitation/drafts',1),(134,134,'6b15b073-2323-4d60-9fe0-618fc575c70e','und','/webform/mail_invitation/drafts','/form/mail-invitation/drafts',1),(135,135,'9d278896-bc02-48b4-9db2-910d9989154a','en','/webform/email_reminder','/form/email-reminder',1),(136,136,'4609759c-905d-4cfa-89ac-b96ea4cec1cb','und','/webform/email_reminder','/form/email-reminder',1),(137,137,'81354bdd-0e3f-4992-bedf-5d30424f526e','en','/webform/email_reminder/confirmation','/form/email-reminder/confirmation',1),(138,138,'8fb71169-7baa-4289-8f94-4f12bd8cb850','und','/webform/email_reminder/confirmation','/form/email-reminder/confirmation',1),(139,139,'d77643e3-1de2-4d80-8555-21a0a56f6e61','en','/webform/email_reminder/submissions','/form/email-reminder/submissions',1),(140,140,'94474b8e-93db-4ed5-ae8f-5301012c05f0','und','/webform/email_reminder/submissions','/form/email-reminder/submissions',1),(141,141,'48f565db-97ef-4fa1-bb69-f5f4b27d28b7','en','/webform/email_reminder/drafts','/form/email-reminder/drafts',1),(142,142,'c4b30d5f-beae-418c-815c-b09d8ffc66ee','und','/webform/email_reminder/drafts','/form/email-reminder/drafts',1),(143,143,'1566433a-cdda-4610-8edd-21582481b0b4','en','/webform/submission_list','/form/submission-list',1),(144,144,'3d8663a0-e0b8-4a08-828e-8039e1ce4d45','und','/webform/submission_list','/form/submission-list',1),(145,145,'fac166fa-9005-4c7e-93c9-92ad8e03a582','en','/webform/submission_list/confirmation','/form/submission-list/confirmation',1),(146,146,'7f68248c-a3e9-4b7c-85ae-e5cca0daf453','und','/webform/submission_list/confirmation','/form/submission-list/confirmation',1),(147,147,'8c0532b7-1549-4194-bcb5-12a2f671409a','en','/webform/submission_list/submissions','/form/submission-list/submissions',1),(148,148,'1fdc0cd5-4cdb-413d-84de-2439d2296697','und','/webform/submission_list/submissions','/form/submission-list/submissions',1),(149,149,'643c6e22-2b8c-4c5d-90e2-bcac6915fc50','en','/webform/submission_list/drafts','/form/submission-list/drafts',1),(150,150,'fb2f8ddd-5483-43a5-814f-10249ae27311','und','/webform/submission_list/drafts','/form/submission-list/drafts',1);

--
-- Table structure for table `path_alias_revision`
--

CREATE TABLE `path_alias_revision` (
  `id` int(10) unsigned NOT NULL,
  `revision_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `langcode` varchar(12) CHARACTER SET ascii NOT NULL,
  `path` varchar(255) DEFAULT NULL,
  `alias` varchar(255) DEFAULT NULL,
  `status` tinyint(4) NOT NULL,
  `revision_default` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`revision_id`),
  KEY `path_alias__id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=151 DEFAULT CHARSET=utf8mb4 COMMENT='The revision table for path_alias entities.';

--
-- Dumping data for table `path_alias_revision`
--

INSERT INTO `path_alias_revision` VALUES (1,1,'en','/node/305','/',1,1),(2,2,'en','/webform/contact','/form/contact',1,1),(3,3,'und','/webform/contact','/form/contact',1,1),(4,4,'en','/webform/contact/confirmation','/form/contact/confirmation',1,1),(5,5,'und','/webform/contact/confirmation','/form/contact/confirmation',1,1),(6,6,'en','/webform/contact/submissions','/form/contact/submissions',1,1),(7,7,'und','/webform/contact/submissions','/form/contact/submissions',1,1),(8,8,'en','/webform/contact/drafts','/form/contact/drafts',1,1),(9,9,'und','/webform/contact/drafts','/form/contact/drafts',1,1),(10,10,'en','/webform/demo_application_evaluation','/form/demo-application-evaluation',1,1),(11,11,'und','/webform/demo_application_evaluation','/form/demo-application-evaluation',1,1),(12,12,'en','/webform/demo_application_evaluation/confirmation','/form/demo-application-evaluation/confirmation',1,1),(13,13,'und','/webform/demo_application_evaluation/confirmation','/form/demo-application-evaluation/confirmation',1,1),(14,14,'en','/webform/demo_application_evaluation/submissions','/form/demo-application-evaluation/submissions',1,1),(15,15,'und','/webform/demo_application_evaluation/submissions','/form/demo-application-evaluation/submissions',1,1),(16,16,'en','/webform/demo_application_evaluation/drafts','/form/demo-application-evaluation/drafts',1,1),(17,17,'und','/webform/demo_application_evaluation/drafts','/form/demo-application-evaluation/drafts',1,1),(18,18,'en','/webform/demo_application','/form/demo-application',1,1),(19,19,'und','/webform/demo_application','/form/demo-application',1,1),(20,20,'en','/webform/demo_application/confirmation','/form/demo-application/confirmation',1,1),(21,21,'und','/webform/demo_application/confirmation','/form/demo-application/confirmation',1,1),(22,22,'en','/webform/demo_application/submissions','/form/demo-application/submissions',1,1),(23,23,'und','/webform/demo_application/submissions','/form/demo-application/submissions',1,1),(24,24,'en','/webform/demo_application/drafts','/form/demo-application/drafts',1,1),(25,25,'und','/webform/demo_application/drafts','/form/demo-application/drafts',1,1),(26,26,'en','/webform/adherence_questionnaire','/form/adherence-questionnaire',1,1),(27,27,'und','/webform/adherence_questionnaire','/form/adherence-questionnaire',1,1),(28,28,'en','/webform/adherence_questionnaire/confirmation','/form/adherence-questionnaire/confirmation',1,1),(29,29,'und','/webform/adherence_questionnaire/confirmation','/form/adherence-questionnaire/confirmation',1,1),(30,30,'en','/webform/adherence_questionnaire/submissions','/form/adherence-questionnaire/submissions',1,1),(31,31,'und','/webform/adherence_questionnaire/submissions','/form/adherence-questionnaire/submissions',1,1),(32,32,'en','/webform/adherence_questionnaire/drafts','/form/adherence-questionnaire/drafts',1,1),(33,33,'und','/webform/adherence_questionnaire/drafts','/form/adherence-questionnaire/drafts',1,1),(43,43,'en','/node/532','/impact-analysis/Impact-Analysis-test',1,1),(44,44,'en','/node/533','/impact-analysis/ms-initiative-01',1,1),(45,45,'en','/webform/multi_act_framework_baseline_ana','/form/multi-act-framework-baseline-ana',1,1),(46,46,'und','/webform/multi_act_framework_baseline_ana','/form/multi-act-framework-baseline-ana',1,1),(47,47,'en','/webform/multi_act_framework_baseline_ana/confirmation','/form/multi-act-framework-baseline-ana/confirmation',1,1),(48,48,'und','/webform/multi_act_framework_baseline_ana/confirmation','/form/multi-act-framework-baseline-ana/confirmation',1,1),(49,49,'en','/webform/multi_act_framework_baseline_ana/submissions','/form/multi-act-framework-baseline-ana/submissions',1,1),(50,50,'und','/webform/multi_act_framework_baseline_ana/submissions','/form/multi-act-framework-baseline-ana/submissions',1,1),(51,51,'en','/webform/multi_act_framework_baseline_ana/drafts','/form/multi-act-framework-baseline-ana/drafts',1,1),(52,52,'und','/webform/multi_act_framework_baseline_ana/drafts','/form/multi-act-framework-baseline-ana/drafts',1,1),(53,53,'en','/webform/variables_to_be_included_in_the_','/form/variables-to-be-included-in-the-',1,1),(54,54,'und','/webform/variables_to_be_included_in_the_','/form/variables-to-be-included-in-the-',1,1),(55,55,'en','/webform/variables_to_be_included_in_the_/confirmation','/form/variables-to-be-included-in-the-/confirmation',1,1),(56,56,'und','/webform/variables_to_be_included_in_the_/confirmation','/form/variables-to-be-included-in-the-/confirmation',1,1),(57,57,'en','/webform/variables_to_be_included_in_the_/submissions','/form/variables-to-be-included-in-the-/submissions',1,1),(58,58,'und','/webform/variables_to_be_included_in_the_/submissions','/form/variables-to-be-included-in-the-/submissions',1,1),(59,59,'en','/webform/variables_to_be_included_in_the_/drafts','/form/variables-to-be-included-in-the-/drafts',1,1),(60,60,'und','/webform/variables_to_be_included_in_the_/drafts','/form/variables-to-be-included-in-the-/drafts',1,1),(61,61,'en','/webform/mscu_ecf_2018_practising_neurolo','/form/mscu-ecf-2018-practising-neurolo',1,1),(62,62,'und','/webform/mscu_ecf_2018_practising_neurolo','/form/mscu-ecf-2018-practising-neurolo',1,1),(63,63,'en','/webform/mscu_ecf_2018_practising_neurolo/confirmation','/form/mscu-ecf-2018-practising-neurolo/confirmation',1,1),(64,64,'und','/webform/mscu_ecf_2018_practising_neurolo/confirmation','/form/mscu-ecf-2018-practising-neurolo/confirmation',1,1),(65,65,'en','/webform/mscu_ecf_2018_practising_neurolo/submissions','/form/mscu-ecf-2018-practising-neurolo/submissions',1,1),(66,66,'und','/webform/mscu_ecf_2018_practising_neurolo/submissions','/form/mscu-ecf-2018-practising-neurolo/submissions',1,1),(67,67,'en','/webform/mscu_ecf_2018_practising_neurolo/drafts','/form/mscu-ecf-2018-practising-neurolo/drafts',1,1),(68,68,'und','/webform/mscu_ecf_2018_practising_neurolo/drafts','/form/mscu-ecf-2018-practising-neurolo/drafts',1,1),(69,69,'en','/node/558','/MS-Care-Unit-Baseline-Analysis',1,1),(70,70,'en','/webform/mscu_ecf_2018_academic_mscu','/form/mscu-ecf-2018-academic-mscu',1,1),(71,71,'und','/webform/mscu_ecf_2018_academic_mscu','/form/mscu-ecf-2018-academic-mscu',1,1),(72,72,'en','/webform/mscu_ecf_2018_academic_mscu/confirmation','/form/mscu-ecf-2018-academic-mscu/confirmation',1,1),(73,73,'und','/webform/mscu_ecf_2018_academic_mscu/confirmation','/form/mscu-ecf-2018-academic-mscu/confirmation',1,1),(74,74,'en','/webform/mscu_ecf_2018_academic_mscu/submissions','/form/mscu-ecf-2018-academic-mscu/submissions',1,1),(75,75,'und','/webform/mscu_ecf_2018_academic_mscu/submissions','/form/mscu-ecf-2018-academic-mscu/submissions',1,1),(76,76,'en','/webform/mscu_ecf_2018_academic_mscu/drafts','/form/mscu-ecf-2018-academic-mscu/drafts',1,1),(77,77,'und','/webform/mscu_ecf_2018_academic_mscu/drafts','/form/mscu-ecf-2018-academic-mscu/drafts',1,1),(78,78,'en','/webform/mscu_ecf_2018_academic_mscu_init','/form/mscu-ecf-2018-academic-mscu-init',1,1),(79,79,'und','/webform/mscu_ecf_2018_academic_mscu_init','/form/mscu-ecf-2018-academic-mscu-init',1,1),(80,80,'en','/webform/mscu_ecf_2018_academic_mscu_init/confirmation','/form/mscu-ecf-2018-academic-mscu-init/confirmation',1,1),(81,81,'und','/webform/mscu_ecf_2018_academic_mscu_init/confirmation','/form/mscu-ecf-2018-academic-mscu-init/confirmation',1,1),(82,82,'en','/webform/mscu_ecf_2018_academic_mscu_init/submissions','/form/mscu-ecf-2018-academic-mscu-init/submissions',1,1),(83,83,'und','/webform/mscu_ecf_2018_academic_mscu_init/submissions','/form/mscu-ecf-2018-academic-mscu-init/submissions',1,1),(84,84,'en','/webform/mscu_ecf_2018_academic_mscu_init/drafts','/form/mscu-ecf-2018-academic-mscu-init/drafts',1,1),(85,85,'und','/webform/mscu_ecf_2018_academic_mscu_init/drafts','/form/mscu-ecf-2018-academic-mscu-init/drafts',1,1),(86,86,'en','/webform/materiality_analysis','/form/materiality-analysis',1,1),(87,87,'und','/webform/materiality_analysis','/form/materiality-analysis',1,1),(88,88,'en','/webform/materiality_analysis/confirmation','/form/materiality-analysis/confirmation',1,1),(89,89,'und','/webform/materiality_analysis/confirmation','/form/materiality-analysis/confirmation',1,1),(90,90,'en','/webform/materiality_analysis/submissions','/form/materiality-analysis/submissions',1,1),(91,91,'und','/webform/materiality_analysis/submissions','/form/materiality-analysis/submissions',1,1),(92,92,'en','/webform/materiality_analysis/drafts','/form/materiality-analysis/drafts',1,1),(93,93,'und','/webform/materiality_analysis/drafts','/form/materiality-analysis/drafts',1,1),(94,94,'en','/webform/mscu_ecf_2018_non_academic_mscu','/form/mscu-ecf-2018-non-academic-mscu',1,1),(95,95,'und','/webform/mscu_ecf_2018_non_academic_mscu','/form/mscu-ecf-2018-non-academic-mscu',1,1),(96,96,'en','/webform/mscu_ecf_2018_non_academic_mscu/confirmation','/form/mscu-ecf-2018-non-academic-mscu/confirmation',1,1),(97,97,'und','/webform/mscu_ecf_2018_non_academic_mscu/confirmation','/form/mscu-ecf-2018-non-academic-mscu/confirmation',1,1),(98,98,'en','/webform/mscu_ecf_2018_non_academic_mscu/submissions','/form/mscu-ecf-2018-non-academic-mscu/submissions',1,1),(99,99,'und','/webform/mscu_ecf_2018_non_academic_mscu/submissions','/form/mscu-ecf-2018-non-academic-mscu/submissions',1,1),(100,100,'en','/webform/mscu_ecf_2018_non_academic_mscu/drafts','/form/mscu-ecf-2018-non-academic-mscu/drafts',1,1),(101,101,'und','/webform/mscu_ecf_2018_non_academic_mscu/drafts','/form/mscu-ecf-2018-non-academic-mscu/drafts',1,1),(103,103,'en','/webform/mscu_ecf_2020','/form/mscu-ecf-2020',1,1),(104,104,'und','/webform/mscu_ecf_2020','/form/mscu-ecf-2020',1,1),(105,105,'en','/webform/mscu_ecf_2020/confirmation','/form/mscu-ecf-2020/confirmation',1,1),(106,106,'und','/webform/mscu_ecf_2020/confirmation','/form/mscu-ecf-2020/confirmation',1,1),(107,107,'en','/webform/mscu_ecf_2020/submissions','/form/mscu-ecf-2020/submissions',1,1),(108,108,'und','/webform/mscu_ecf_2020/submissions','/form/mscu-ecf-2020/submissions',1,1),(109,109,'en','/webform/mscu_ecf_2020/drafts','/form/mscu-ecf-2020/drafts',1,1),(110,110,'und','/webform/mscu_ecf_2020/drafts','/form/mscu-ecf-2020/drafts',1,1),(111,111,'en','/webform/mscu_ecf_2020_for_check_','/form/mscu-ecf-2020-for-check-',1,1),(112,112,'und','/webform/mscu_ecf_2020_for_check_','/form/mscu-ecf-2020-for-check-',1,1),(113,113,'en','/webform/mscu_ecf_2020_for_check_/confirmation','/form/mscu-ecf-2020-for-check-/confirmation',1,1),(114,114,'und','/webform/mscu_ecf_2020_for_check_/confirmation','/form/mscu-ecf-2020-for-check-/confirmation',1,1),(115,115,'en','/webform/mscu_ecf_2020_for_check_/submissions','/form/mscu-ecf-2020-for-check-/submissions',1,1),(116,116,'und','/webform/mscu_ecf_2020_for_check_/submissions','/form/mscu-ecf-2020-for-check-/submissions',1,1),(117,117,'en','/webform/mscu_ecf_2020_for_check_/drafts','/form/mscu-ecf-2020-for-check-/drafts',1,1),(118,118,'und','/webform/mscu_ecf_2020_for_check_/drafts','/form/mscu-ecf-2020-for-check-/drafts',1,1),(119,119,'en','/webform/open','/form/open',1,1),(120,120,'und','/webform/open','/form/open',1,1),(121,121,'en','/webform/open/confirmation','/form/open/confirmation',1,1),(122,122,'und','/webform/open/confirmation','/form/open/confirmation',1,1),(123,123,'en','/webform/open/submissions','/form/open/submissions',1,1),(124,124,'und','/webform/open/submissions','/form/open/submissions',1,1),(125,125,'en','/webform/open/drafts','/form/open/drafts',1,1),(126,126,'und','/webform/open/drafts','/form/open/drafts',1,1),(127,127,'en','/webform/mail_invitation','/form/mail-invitation',1,1),(128,128,'und','/webform/mail_invitation','/form/mail-invitation',1,1),(129,129,'en','/webform/mail_invitation/confirmation','/form/mail-invitation/confirmation',1,1),(130,130,'und','/webform/mail_invitation/confirmation','/form/mail-invitation/confirmation',1,1),(131,131,'en','/webform/mail_invitation/submissions','/form/mail-invitation/submissions',1,1),(132,132,'und','/webform/mail_invitation/submissions','/form/mail-invitation/submissions',1,1),(133,133,'en','/webform/mail_invitation/drafts','/form/mail-invitation/drafts',1,1),(134,134,'und','/webform/mail_invitation/drafts','/form/mail-invitation/drafts',1,1),(135,135,'en','/webform/email_reminder','/form/email-reminder',1,1),(136,136,'und','/webform/email_reminder','/form/email-reminder',1,1),(137,137,'en','/webform/email_reminder/confirmation','/form/email-reminder/confirmation',1,1),(138,138,'und','/webform/email_reminder/confirmation','/form/email-reminder/confirmation',1,1),(139,139,'en','/webform/email_reminder/submissions','/form/email-reminder/submissions',1,1),(140,140,'und','/webform/email_reminder/submissions','/form/email-reminder/submissions',1,1),(141,141,'en','/webform/email_reminder/drafts','/form/email-reminder/drafts',1,1),(142,142,'und','/webform/email_reminder/drafts','/form/email-reminder/drafts',1,1),(143,143,'en','/webform/submission_list','/form/submission-list',1,1),(144,144,'und','/webform/submission_list','/form/submission-list',1,1),(145,145,'en','/webform/submission_list/confirmation','/form/submission-list/confirmation',1,1),(146,146,'und','/webform/submission_list/confirmation','/form/submission-list/confirmation',1,1),(147,147,'en','/webform/submission_list/submissions','/form/submission-list/submissions',1,1),(148,148,'und','/webform/submission_list/submissions','/form/submission-list/submissions',1,1),(149,149,'en','/webform/submission_list/drafts','/form/submission-list/drafts',1,1),(150,150,'und','/webform/submission_list/drafts','/form/submission-list/drafts',1,1);

--
