Grupo de Trabajo. Fecha/hora recepción: 2016-03-13 17:22:41Eje temático: 2. Administración y Gestión Pública
Coordinador GT Principal: Remei Perpinyà. Professora titular. Escuela Superior de Archivística y Gestión de Documentos. Universidad Autónoma de Barcelona (España). (España)remei.perpinya@uab.cat
Coordinador auxiliar: Anahí Casadesús de Mingoanahi.casadesus@uab.cat
2016-A10. Edificio Anexo. Sala 1. Lunes 3 de octubre de 17:30 a 19:30
Sesión: http://sched.co/808h
Los retos de la administración electrónica y las exigencias ciudadanas de mayor transparencia administrativa ponen en el centro del debate la gestión de documentos y la gobernanza de la información. El grupo de trabajo abordará los conceptos, métodos y técnicas de la gestión de documentos para conseguir administraciones menos burocráticas y más eficientes, así como más accesibles y transparentes. No es posible una administración transparente sin una buena organización de la información y la documentación que abra los archivos a la ciudadanía. Las coordinadoras han trabajado en este ámbito en diferentes proyectos en el marco de la Escuela Superior de Archivística y Gestión de Documentos (ESAGED-UAB).
Algunos ejemplos de temáticas que se incluyen en este grupo de trabajo son: experiencias innovadoras en implantación de sistemas de gestión de documentos; análisis de circuitos administrativos para la simplificación administrativa; auditoría y propuestas de mejora en la gestión de la información; análisis y gestión de riesgos de la información; evaluación de documentos; políticas de ingresos y transferencias; datos abiertos en archivos históricos y administrativos; archivos de altos cargos; portales de transparencia y acceso a los archivos. El grupo cuenta ya con dos propuestas de ponencias sobre dos de las temáticas del GT: gestión del riesgo y archivos de altos cargos.
Se trata de una propuesta de GT innovadora y que pretende tratar aspectos no tratados en anteriores GIGAPP pero sí muy relacionados con los ejes del congreso. El grupo cuenta ya con dos propuestas de ponencias sobre dos de las temáticas del GT: gestión del riesgo y archivos de altos cargos.
2016-405. Transparencia en riesgo: la gestión de documentos como estrategia de prevención Autor(a). Casadesús de Mingo, Anahí. Universitat Autónoma de Barcelona. Escuela Superior de Archivística y Gestión de Documentos. España
Coautor(a). Perpinyà Morera, Remei. Universitat Autónoma de Barcelona. Escuela Superior de Archivística y Gestión de Documentos. España http://www.gigapp.org/index.php/component/jresearch/publication/show/2217?Itemid=101
2016-418. Una propuesta para la Gestión de Documentos en la Presidencia de la República de Chile en el marco de la Transparencia, Gobierno Abierto y Políticas Públicas Autor(a). Díaz Ellis, Pilar Andrea. ONG Archiveros sin Fronteras. Chile http://www.gigapp.org/index.php/component/jresearch/publication/show/2204?Itemid=101
2016-423. ECO-Sistema Documental en la transformación digital de las Entidades Locales (Otra Administración Pública es posible, y necesaria) Autor(a). Faus Mascarell, Joan Carles. Ayuntamiento de Gandia. España
Coautor(a). Pérez Sarrión, Lorenzo. Ayuntamiento de Gandia. España http://www.gigapp.org/index.php/component/jresearch/publication/show/2199?Itemid=101
2016-463. De políticas de transparencia a políticas de archivo: El caso del Consejo para la Transparencia (Chile). Autor(a). Bravo Castillo, Paulina. Universitat Autónoma de Barcelona. Escuela Superior de Archivística y Gestión de Documentos. España
Coautor(a). Rojas Rojo, Valentina. Archivo Nacional. Chile http://www.gigapp.org/index.php/component/jresearch/publication/show/2159?Itemid=101
2016-495. Utilización del Software Libre y su uso en la elaboración de Mapas Temáticos Autor(a). Martín García, Felipe. Ayuntamiento de Madrid. España
Coautor(a). Melús Gil, Isabel. Ayuntamiento de Madrid. España http://www.gigapp.org/index.php/component/jresearch/publication/show/2127?Itemid=101
2016-497. La gestion documental como indicador de transparencia en las organizaciones Autor(a). Lopaz, Rosario. FundacIón Ciencias de la Documentación. http://www.gigapp.org/index.php/component/jresearch/publication/show/?Itemid=101
{ "__default": { "session": { "counter": 1, "timer": { "start": 1575668812, "last": 1575668812, "now": 1575668812 }, "token": "lqjMZXZ8rwe7mIhhE8QKcjcJLyTZdNqG" }, "registry": {}, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 } }, "__jresearch": { "citedRecords": [] }, "__com_jresearch": { "project": { "190": { "visited": true } } } }
SELECT `data` FROM `jos_session` WHERE `session_id` = '4p9scoa2fqg9tjiimli91gori4'
SELECT `session_id` FROM `jos_session` WHERE `session_id` = '4p9scoa2fqg9tjiimli91gori4' LIMIT 1
INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('4p9scoa2fqg9tjiimli91gori4', 1, 1575668812, 0, '', 0)
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
SELECT id, rules FROM `jos_viewlevels`
SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM jos_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering
UPDATE jos_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id WHERE m.published = 1 AND m.parent_id > 0 AND m.client_id = 0 ORDER BY m.lft
SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id WHERE s.client_id = 0 AND e.enabled = 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'library' AND `element` = 'joomla'
UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"e5e1738f0825a56e0ba82d4948ee769c\"}' WHERE `type` = 'library' AND `element` = 'joomla'
SELECT * FROM jos_languages WHERE published=1 ORDER BY ordering ASC
SHOW FULL COLUMNS FROM `jos_jresearch_project`
SELECT * FROM jos_jresearch_project WHERE `id` = '190'
UPDATE jos_jresearch_project SET `hits` = (`hits` + 1) WHERE `id` = '190'
SELECT p.* FROM `jos_jresearch_publication` p JOIN `jos_jresearch_project_publication` pp WHERE p.id = pp.id_publication AND p.published = 1 AND p.internal = 1 AND pp.id_project = '190' ORDER BY p.year DESC, p.created DESC LIMIT 0, 15
SELECT count(pp.id_publication) FROM `jos_jresearch_publication` p JOIN `jos_jresearch_project_publication` pp WHERE p.id = pp.id_publication AND p.published = 1 AND p.internal = 1 AND pp.id_project = '190'
SELECT id, name, published FROM jos_jresearch_research_area WHERE id IN (3) AND id > 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-12-06 21:46:52') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-06 21:46:52') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 112 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 13 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 22 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 16 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 25 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 26 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 45 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 40 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 30 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 46 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id WHERE fv.item_id = 18 AND f.context = "com_content.categories" AND f.language IN ("*", "es-ES") AND f.access = 1
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM jos_modules AS m WHERE m.id = 135 AND m.published = 1 AND m.access IN (1,1,5)
SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djcatalog2','com_djimageslider','com_finder','com_installer','com_j2xml','com_jaextmanager','com_jce','com_joomailermailchimpintegration','com_joomlaupdate','com_jresearch','com_jsocialfeed','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id WHERE c.published = 1 AND a.state = 1 AND a.featured = 0 AND a.catid IN (46) AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-12-06 21:46:52') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-12-06 21:46:52') ORDER BY a.publish_up DESC LIMIT 2
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt) WHERE (c.extension='com_content' OR c.extension='system') AND c.access IN (1,1,5) AND c.published = 1 AND s.id = 46 ORDER BY c.lft
10 × SELECT fv.value, fg.title AS gtitle, f.title AS ftitle, f.name FROM jos_fields_values fv LEFT JOIN jos_fields f ON fv.field_id = f.id LEFT JOIN jos_fields_groups fg ON fg.id = f.group_id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions`
2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN c.published = 2 AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state, CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name, CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft, CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count FROM jos_content AS a LEFT JOIN jos_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.created_by LEFT JOIN jos_users AS uam ON uam.id = a.modified_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM jos_modules AS m
1 × SELECT `data` FROM `jos_session`
1 × SELECT count(pp.id_publication) FROM `jos_jresearch_publication` p JOIN `jos_jresearch_project_publication` pp
1 × SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jos_extensions AS e ON e.element = m.module AND e.client_id = m.client_id
1 × SELECT id, name, published FROM jos_jresearch_research_area
1 × SELECT * FROM jos_jresearch_project
1 × SELECT p.* FROM `jos_jresearch_publication` p JOIN `jos_jresearch_project_publication` pp
1 × SELECT `session_id` FROM `jos_session`
1 × SELECT * FROM jos_languages
1 × SELECT id, home, template, s.params FROM jos_template_styles as s LEFT JOIN jos_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM jos_extensions
1 × SELECT b.id FROM jos_usergroups AS a LEFT JOIN jos_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT id, rules FROM `jos_viewlevels
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug FROM `jos_categories` AS `s` INNER JOIN `jos_categories` AS `c` ON (s.lft <= c.lft AND c.lft < s.rgt) OR (c.lft < s.lft AND s.rgt < c.rgt)
1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('4p9scoa2fqg9tjiimli91gori4', 1, 1575668812, 0, '', 0
1 × UPDATE jos_extensions SET enabled=1
1 × UPDATE `jos_extensions` SET `params` = '{\"mediaversion\":\"e5e1738f0825a56e0ba82d4948ee769c\"}'
1 × SHOW FULL COLUMNS FROM `jos_jresearch_project
1 × UPDATE jos_jresearch_project SET `hits` = (`hits` + 1)