The World Bank Report No: ISR13747 Implementation Status & Results Colombia Consolidation of National Public Management Information Systems (P106628) Public Disclosure Copy Operation Name: Consolidation of National Public Management Information Project Stage: Implementation Seq.No: 8 Status: ARCHIVED Archive Date: 10-Mar-2014 Systems (P106628) Country: Colombia Approval FY: 2010 Product Line: IBRD/IDA Region: LATIN AMERICA AND CARIBBEAN Lending Instrument: Technical Assistance Loan Implementing Agency(ies): Key Dates Board Approval Date 17-Dec-2009 Original Closing Date 31-Dec-2012 Planned Mid Term Review Date Last Archived ISR Date 19-Oct-2013 Effectiveness Date 13-Jan-2010 Revised Closing Date 15-Dec-2014 Actual Mid Term Review Date 22-Aug-2011 Project Development Objectives Project Development Objective (from Project Appraisal Document) The objective of the proposed operation is to improve the transparency, coverage, operation and interoperability of key national financial management information systems that will allow Government decision makers to link performance measures with planning, budgeting and other managerial actions. Has the Project Development Objective been changed since Board Approval of the Project? Yes No Component(s) Component Name Component Cost Strengthening of Public Management Information Systems within MHCP 8.80 Strengthening of Public Management Information Systems within DNP 1.20 Expansion of DIAN's Integrated Tax and Customs Administration Model (MUISCA) 6.61 Improving the Inter-operability of other key IT Systems and Strategic Use of Information 5.80 Project Management 1.20 Public Disclosure Copy Overall Ratings Previous Rating Current Rating Progress towards achievement of PDO Moderately Satisfactory Satisfactory Overall Implementation Progress (IP) Moderately Satisfactory Moderately Satisfactory Overall Risk Rating Moderate Low Implementation Status Overview On December 24, 2013 the Bank approved a level II restructuring for this project which included the: (i) extension of closing date until December 15, 2014 for a cumulative extension Page 1 of 8 The World Bank Report No: ISR13747 of 23.5 months; (ii) redefinition of selected activities for Subcomponent 4.2; and (iii) partial cancellation of the Loan with respect to original allocation for Component 3 (DIAN). With the exception of Subcomponent 4.2 Strengthening of the Public Credit and Treasury Directorate, Project resources have been mostly committed and executed, with substantial activities reaching their completion in compliance with stated Project objectives and goals. In addition to most results indicators being achieved, progress has been reported in Public Disclosure Copy intermediate indicators (e.g. additional studies have been completed, budget execution information is available on-line and consolidated for decision making). Overall, the approved extension will also help consolidate further the achievement of the PDO. Locations Country First Administrative Division Location Planned Actual Colombia Not Entered Bogota Results Project Development Objective Indicators Indicator Name Core Unit of Measure Baseline Current End Target Information on budget execution#i.e., revenues Percentage Value 85.00 100.00 100.00 and expenditures#that is available daily Date 01-Jan-2010 31-Dec-2013 15-Dec-2014 increases from 85% to 100% of the total Comments Achieved and reported - IFR Achieved amount of the National Budget (Presupuesto General de la Nación # PGN) December 2012 Time lag to produce aggregate financial data Days Value 35.00 1.00 1.00 for the central government, including Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 decentraslized entities, reduced from up to 35 Comments Achieved and reported - IFR Achieved days to 1 day. December 2012. 100% of consolidated budget information (at Percentage Value 0.00 100.00 100.00 the level of individual entities) is published Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 online on a monthly basis within the first week Comments Achieved and reported - IFR Achieved of the following month. December 2012. Public Disclosure Copy Average time to clear customs decreases from Hours Value 48.00 23.00 8.00 48 hours to less than 8 hours Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 Comments Tax administration efficiency increases, as Number Value 103.20 103.70 reflected by an increase in the ration of total tax Date 01-Dec-2009 31-Dec-2013 15-Dec-2014 collection/DIAN's executed budget from 103.2 Comments to 103.7 Page 2 of 8 The World Bank Report No: ISR13747 Number of studies completed to strengthen Number Value 0.00 9.00 9.00 fiscal and macroeconomic planning Date 01-Dec-2009 31-Dec-2013 15-Dec-2014 Comments Achieved Public Disclosure Copy SIIF and SUIFP information on the allocation Text Value 100 and execution of budget items is fully Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 consistent Comments Achieved and reported - IFR December 2012 Intermediate Results Indicators Indicator Name Core Unit of Measure Baseline Current End Target SIIF-Nación implemented throughout of the Percentage Value 0.00 100.00 100.00 central administration (i.e., 63 AU within the Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 central administration and 100 AU in Comments Achieved and reported on IFR Achieved decentralized entities) December 2012 Gap between required and actual Text Value 3.6 annual increases in a scale of competencies has been gradually reduced 1-5 Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 Comments Baseline was established at Achieved and reported IFR Achieved. System in place for 3.6 in 2009 December 2012. annual evaluations with performance improvement plans. A Monitoring and Evaluation system is in place Text Value No mechanisms 50% - 2011 in place to ensure 100%-2012 quality and efficiency of MHCP's management practices Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 Public Disclosure Copy Comments Achieved and reported - IFR Achieved December 2012 Certification of quality has beenobtained for Text Value 2011-50% SUG 2012-100% Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 Comments Achieved and reported - IFR Achieved December 2012 Page 3 of 8 The World Bank Report No: ISR13747 The ration between programmed budgetary Number Value 81.60 105.00 92.00 resources for investment projects and Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 requested budgetary resources for investment Comments Target achieved and Achieved projectshas increased from 81.6% to 92% Public Disclosure Copy exceeded. 105% reported June 2013 The ration between the number of investment Text Value 86.8 90 projects programmed and the number of Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 investment projects registered has increased Comments Target achieved and Achieved from86.8% to 90% exceeded. 111% reported on June 2012 The number of high-impact DIAN procedures Text Value 20 2011-30 that have been modernized has increased from 2012-40 - 100% increase 20 to 40 (100%) Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 Comments Number of pending obligations (compromisos) Number Value 0.00 497751.00 540000.00 normalized has increased from 0 to 540,000 Date 18-Nov-2009 31-Dec-2013 31-Dec-2013 Comments Partially achieved (497,751) The average number of physicaldocuments Number Value 12.00 9.00 5.00 required for customsclearance has been Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 reduced from 12to 5 Comments 9 physical documents. Accomplishment of indicator still depends on the issuance of a Decree in the context of Customs Statute. The number of procedures that are subject to Number Value 67.00 199.00 199.00 quality audits by DIAN's internal quality control Date 18-Nov-2009 31-Dec-2011 15-Dec-2014 procedures has increased from 67 to 199 Comments Target Achieved as of June 2013 - 199 procedures subject to quality audits. Public Disclosure Copy Progress on development of virtual learning Percentage Value 21.54 32.30 100.00 program for improving technical capacity of Date 01-Dec-2010 31-Dec-2013 15-Dec-2014 DIAN staff Comments A total of 15 processes were year 3 indicator developed Improve DIAN’s National Transparency Number Value 81.25 0.00 89.51 Index from 81.25 (2007-2008) to 89.51 by Date 18-Dec-2009 31-Dec-2013 15-Dec-2014 project closing. Comments for year 2007-2008 Page 4 of 8 The World Bank Report No: ISR13747 Number of Systems Services (Servicios Number Value 12.00 19.00 40.00 Informáticos Electrónicos), transfered to Date 18-Dec-2009 31-Dec-2013 15-Dec-2014 DIAN’s technology area increases from 12 Comments Value for indicator remains Target for not likely to be to 40 Public Disclosure Copy unmodified. reached. Carry out pilots allowing the disaggregation of Text Value limited interoperability of 1 pilot program expenditure information systems Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 Comments Achieved and reported - IFR December 2012 Carry out pilots integrating data generated by Text Value limited interoperability of 1 pilot program the different goverment systems systems Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 Comments Achieved and reported - IFR December 2012 Full interoperability of Nacion with SECOP and Text Value limited interoperability of 100% Public Debt systems Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 Comments Achieved and reported - IFR December 2012 Full interoperability of SIIF Nacion with the Text Value limited interoperability of 100% following systems PAGOS (Banco Republica) systems SILOG (Defensa) and SOBRETASA (MHCP) Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 Comments Achieved and reported - IFR December 2012 The DGCPTN's integrated management Percentage Value 0.00 100.00 system, SEIGI, is fully operational. No other Date 31-Dec-2013 15-Dec-2014 treasury & debt management system is in Comments no baseline available Progress in the indicator still year 4 indicator operation within the DGCPTN (the current debt system is maintained temporarilly depends on the definition of a line of business and software Public Disclosure Copy for DGCPTN The percentage of DGCPTN staff that is Percentage Value 0.00 0.00 100.00 required to use the new information system, Date 01-Nov-2009 31-Dec-2013 15-Dec-2014 and effectively does so, has increased from 0% Comments Progress in the indicator still year 4 indicator to 100% depends on the definition of a line of business and software for DGCPTN Page 5 of 8 The World Bank Report No: ISR13747 The number of methodologies and processes Text Value 10 designed for front middle and back office Date 18-Nov-2009 31-Dec-2013 01-Dec-2013 operations has increased from 2 to 10 Comments Achieved year 4 indicator Public Disclosure Copy The number of instruments that the DGCPTN Number Value 15.00 15.00 25.00 is able to register in the system has increased Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 from 15 to 25 Comments Progress in the indicator still year 4 indicator depends on the definition of a line of business and software for DGCPTN Studies have been conducted on the economic Text Value limited capacity to carry out in Studies completed and social impact of global warming depth and strategic studies Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 Comments 30 studies were finished in Measured annually 2012 plus an additional one in 2013 for a total of 31 studies completed. Studies have been conducted on the economic Text Value limited capacity to carry out in Studies completed and social impact of alternative social security depth and strategic studies reform alternatives Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 Comments 4 studies completed in 2012. 2 additional in 2013 for a total of 6 studies completed. Plan for the Implementation of Decree 28 Text Value Plan for the implementation of Decree 28 Date 18-Nov-2009 31-Dec-2013 15-Dec-2014 Comments Achieved and reported - IFR Achieved December 2012 Decrees and other legal norms to promote Text Value The legal framework requires Documents with proposed efficiency and effectiveness have been drafted inefficient procedures; adjustments to the legal oversight of budget execution norms that regulate the Public Disclosure Copy is oriented towards budget process have been compliance rather than drafted effectiveness and efficiency Date 16-Nov-2009 31-Dec-2013 15-Dec-2014 Comments Achieved and reported - IFR year 3 indicator December 20112 Page 6 of 8 The World Bank Report No: ISR13747 Tools for managerial decision-making, budget Text Value Tools and information Budget execution information monitoring and evaluation are available. systems oriented towards is on-line and consolidated as process administration and a tool of information and not for managerial decision communication, with digital Public Disclosure Copy making. Insufficient dashboards for decision information for managerial making. decision making Date 16-Nov-2009 31-Dec-2013 15-Dec-2014 Comments Information of budget year 4 indicator execution is available online and consolidated as and information and communication tool. Data on Financial Performance (as of 26-Dec-2013) Financial Agreement(s) Key Dates Project Ln/Cr/Tf Status Approval Date Signing Date Effectiveness Date Original Closing Date Revised Closing Date P106628 IBRD-78310 Effective 17-Dec-2009 29-Dec-2009 13-Jan-2010 31-Dec-2012 15-Dec-2014 Disbursements (in Millions) Project Ln/Cr/Tf Status Currency Original Revised Cancelled Disbursed Undisbursed % Disbursed P106628 IBRD-78310 Effective USD 25.00 23.61 1.39 19.59 4.02 83.00 Disbursement Graph Public Disclosure Copy Page 7 of 8 The World Bank Report No: ISR13747 Public Disclosure Copy Key Decisions Regarding Implementation Bank supervision mission carried out on January 23, 2014 Restructuring History Level two Approved on 14-Feb-2013, Level 2 CD Decision on 24-Dec-2013 Related Projects There are no related projects. Public Disclosure Copy Page 8 of 8