The World Bank Report No: ISR9676 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: 6 Status: ARCHIVED Archive Date: 15-Apr-2013 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 21-Aug-2012 Effectiveness Date 13-Jan-2010 Revised Closing Date 31-Dec-2013 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) 8.00 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 Moderately Satisfactory Overall Implementation Progress (IP) Moderately Satisfactory Moderately Satisfactory Overall Risk Rating Implementation Status Overview Project implementation continues satisfactorily. Page 1 of 8 The World Bank Report No: ISR9676 Locations Country First Administrative Division Location Planned Actual Colombia Not Entered Bogota Public Disclosure Copy 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-Aug-2011 31-Dec-2012 increases from 85% to 100% of the total Comments Achieved Achieved amount of the National Budget (Presupuesto General de la Nación # PGN) 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-2012 31-Dec-2012 decentraslized entities, reduced from up to 35 Comments Achieved. The reduction of Achieved days to 1 day. time applies to all Central Government and decentralized entities. 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-Aug-2011 31-Dec-2012 online on a monthly basis within the first week Comments Achieved. A transparency of the following month. portal was created and information is published within 24 hours. Average time to clear customs decreases from Hours Value 48.00 22.21 8.00 48 hours to less than 8 hours Date 18-Nov-2009 31-Aug-2011 31-Dec-2012 Comments End target needs to revised. Public Disclosure Copy 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 01-Dec-2012 collection/DIAN's executed budget from 103.2 Comments to 103.7 Number of studies completed to strengthen Number Value 0.00 9.00 fiscal and macroeconomic planning Date 01-Dec-2009 01-Dec-2013 Comments year 4 indicator Page 2 of 8 The World Bank Report No: ISR9676 SIIF and SUIFP information on the allocation Text Value 100 and execution of budget items is fully Date 18-Nov-2009 31-Dec-2011 31-Dec-2012 consistent Comments Achieved. The SUIFP feeds Public Disclosure Copy the SIIF all information related to budget and execution of public investment. 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 01-Jun-2011 31-Dec-2012 central administration and 100 AU in Comments Achieved. SIIF-NACION was Achieved decentralized entities) launched in January 2011 and has been implemented in 100% of central administration. 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-2011 31-Dec-2012 Comments Baseline was established at Achieved. Measured Achieved. System in place for 3.6 in 2009 annually. Last measurement annual evaluations with for 2011 was 4.15 on a scale performance improvement of 1-5. Lower than year plans. before but still hitting target 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 Public Disclosure Copy Date 18-Nov-2009 31-Dec-2011 31-Dec-2012 Comments Achieved. System SMGI Achieved implemented. Certification of quality has beenobtained for Text Value 2011-50% SUG 2012-100% Date 18-Nov-2009 31-Dec-2011 31-Dec-2012 Comments In july of 2010 the certification Achieved for ISO 9001:2008 was Page 3 of 8 The World Bank Report No: ISR9676 received. An audit in 2011 maintained the certification. The ration between programmed budgetary Number Value 81.60 97.00 92.00 resources for investment projects and Public Disclosure Copy Date 18-Nov-2009 31-Dec-2011 31-Dec-2012 requested budgetary resources for investment Comments Achieved. Target for 2011 Achieved projectshas increased from 81.6% to 92% 85%. Ratio as of December 31, 2011. The ration between the number of investment Text Value 86.8 90 projects programmed and the number of Date 18-Nov-2009 31-Dec-2011 31-Dec-2012 investment projects registered has increased Comments Achieved. Target for 2011 Achieved from86.8% to 90% 88%. 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-2011 31-Dec-2012 Comments Target for 2011 24%. achieved. However, progress on these modernization processes are reported in terms of physical progress whichvary from process to process. Number of pending obligations (compromisos) Number Value 0.00 369050.00 540000.00 normalized has increased from 0 to 540,000 Date 18-Nov-2009 31-Dec-2011 31-Dec-2012 Comments Partially achieved (255,710) Target not likely to be met by Target for end of year not 2012 will extend target likely to be met due to lack of human resources. The average number of physicaldocuments Number Value 12.00 9.00 5.00 required for customsclearance has been Date 18-Nov-2009 31-Dec-2011 31-Dec-2012 reduced from 12to 5 Comments No progress in 2011. 3 Public Disclosure Copy Processes are in progress and another 4 possibly by end of the year but finalization depends on the status of the new 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 31-Dec-2012 procedures has increased from 67 to 199 Comments Target for 2011 150. Achieved. Page 4 of 8 The World Bank Report No: ISR9676 Progress on development of virtual learning Percentage Value 21.54 100.00 program for improving technical capacity of Date 01-Dec-2010 01-Dec-2012 DIAN staff Comments year 3 indicator Public Disclosure Copy 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-2011 31-Dec-2012 project closing. Comments for year 2007-2008 The independent body that measures this indication has not done a measurement since the 2008-2009 index. Cannot be monitored fromwithin. 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-2011 31-Dec-2012 DIAN’s technology area increases from 12 Comments Indicator still remains the Target for 2012 not likely to to 40 same as in 2010 only 7 be reached. additional services were transferred. The others depend on on-going processes. Carry out pilots allowing the disaggregation of Text Value limited interoperability of 1 pilot program expenditure information systems Date 18-Nov-2009 31-Dec-2011 31-Dec-2012 Comments ongoing. Pilot programs with SILOG of the Ministry of Defense, SUIPF of DNP, public debt and procurement at MHCP 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-2011 31-Dec-2012 Public Disclosure Copy Comments Pilot programs with SILOG of the Ministry of Defense, SUIPF of DNP, public debt and procurement at MHCP Full interoperability of Nacion with SECOP and Text Value limited interoperability of 100% Public Debt systems Date 18-Nov-2009 31-Dec-2011 31-Dec-2012 Comments Target for 2011 = 100%. SECOP is functioning but is not fully operational. Pilot Page 5 of 8 The World Bank Report No: ISR9676 using SECOP through the web will begin as soon as system development is finalized. The implementation Public Disclosure Copy of CUN can affect the target. 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-2011 31-Dec-2012 Comments Target for 2011 = 50% achieved. Payments are already done through the Banco de la Republica. The pilot with SILOG is still on- going. The implementation of CUN can affect the target. The DGCPTN's integrated management Percentage Value 100.00 system, SEIGI, is fully operational. No other Date 01-Dec-2013 treasury & debt management system is in Comments no baseline available year 4 indicator operation within the DGCPTN (the current debt system is maintained temporarilly The percentage of DGCPTN staff that is Percentage Value 0.00 100.00 required to use the new information system, Date 01-Nov-2009 01-Dec-2013 and effectively does so, has increased from 0% Comments year 4 indicator to 100% The number of methodologies and processes Text Value 10 designed for front, middle and back office Date 18-Nov-2009 31-Dec-2011 01-Dec-2013 operations has increased from 2 to 10 Comments Dec. 2011 target of 4 year 4 indicator achieved. The number of instruments that the DGCPTN Number Value 15.00 25.00 is able to register in the system has increased Date 18-Nov-2009 01-Dec-2013 from 15 to 25 Public Disclosure Copy Comments year 4 indicator 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-2011 31-Dec-2012 Comments Studies completed for 2011. Measured annually 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-2011 31-Dec-2012 Comments One study completed in 2011. Measured annually Page 6 of 8 The World Bank Report No: ISR9676 Plan for the Implementation of Decree 28 is Text Value Plan for the implementation of prepared Decree 28 Date 18-Nov-2009 31-Aug-2011 31-Dec-2012 Public Disclosure Copy Comments Plan submitted for Bank's Achieved review in 2010. 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 is oriented towards budget process have been compliance rather than drafted effectiveness and efficiency Date 16-Nov-2009 31-Dec-2012 Comments year 3 indicator 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 making. Insufficient dashboards for decision information for managerial making. decision making Date 16-Nov-2009 31-Dec-2013 Comments year 4 indicator Data on Financial Performance (as of 08-Feb-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 31-Dec-2013 Disbursements (in Millions) Project Ln/Cr/Tf Status Currency Original Revised Cancelled Disbursed Undisbursed % Disbursed Public Disclosure Copy P106628 IBRD-78310 Effective USD 25.00 25.00 0.00 19.34 5.66 77.00 Disbursement Graph Page 7 of 8 The World Bank Report No: ISR9676 Public Disclosure Copy Key Decisions Regarding Implementation Bank-approved project restructuring revises several outcome indicators. Restructuring History Level two Approved on 14-Feb-2013 Related Projects There are no related projects. Public Disclosure Copy Page 8 of 8