The World Bank Report No: ISR11786 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: 7 Status: ARCHIVED Archive Date: 19-Oct-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 15-Apr-2013 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 Moderate Implementation Status Overview Page 1 of 8 The World Bank Report No: ISR11786 Project implementation continues to be satisfactory. Project resources are both committed and executed in a high percentage. The activities of most components have been completed, in compliance with project objectives and goals. Locations Public Disclosure Copy 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 30-Jun-2013 31-Dec-2013 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 30-Jun-2013 31-Dec-2013 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 30-Jun-2013 31-Dec-2013 online on a monthly basis within the first week Comments Achieved and reported - IFR of the following month. December 2012. The transparency portal is active and will be officially launched in a CONPES by the Minister of Finance. 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 30-Jun-2013 31-Dec-2013 Public Disclosure Copy Comments DIAN suggested the methodological revision of the indicator in order to achieve a target of 6.8 hours 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 30-Jun-2013 01-Dec-2012 collection/DIAN's executed budget from 103.2 Comments to 103.7 Page 2 of 8 The World Bank Report No: ISR11786 Number of studies completed to strengthen Number Value 0.00 9.00 9.00 fiscal and macroeconomic planning Date 01-Dec-2009 30-Jun-2013 31-Dec-2013 Comments Achieved. The indicator was Public Disclosure Copy revised in 2012 to achieve target. To date, 9 studies have been developed. SIIF and SUIFP information on the allocation Text Value 100 and execution of budget items is fully Date 18-Nov-2009 30-Jun-2013 31-Dec-2013 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 30-Jun-2013 31-Dec-2013 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 30-Jun-2013 31-Dec-2013 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 Public Disclosure Copy practices Date 18-Nov-2009 30-Jun-2013 31-Dec-2013 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 30-Jun-2013 31-Dec-2013 Comments Achieved and reported - IFR Achieved December 2012 Page 3 of 8 The World Bank Report No: ISR11786 The ration between programmed budgetary Number Value 81.60 105.00 92.00 resources for investment projects and Date 18-Nov-2009 30-Jun-2013 31-Dec-2013 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 111% 90 projects programmed and the number of Date 18-Nov-2009 30-Jun-2013 31-Dec-2013 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 30-Jun-2013 31-Dec-2013 Comments DIAN proposed a methodological revision of the indicator to take into consideration both committed and complementary services. 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 30-Jun-2013 31-Dec-2013 Comments Partially achieved (497,751) Target not likely to be met by 2012 will extend target The average number of physicaldocuments Number Value 12.00 9.00 5.00 required for customsclearance has been Date 18-Nov-2009 30-Jun-2013 31-Dec-2013 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 Public Disclosure Copy quality audits by DIAN's internal quality control Date 18-Nov-2009 31-Dec-2011 31-Dec-2013 procedures has increased from 67 to 199 Comments Target Achieved as of June 2013 - 199 procedures subject to quality audits. Expected to increase in 49 by December 2013 Page 4 of 8 The World Bank Report No: ISR11786 Progress on development of virtual learning Percentage Value 21.54 32.30 100.00 program for improving technical capacity of Date 01-Dec-2010 30-Jun-2013 31-Dec-2013 DIAN staff Comments 7 virtual processes are being year 3 indicator Public Disclosure Copy developed. 3 in virtualization process and 4 in design phase. 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 30-Jun-2013 31-Dec-2013 project closing. Comments for year 2007-2008 Corporacion Transparencia por Colombia will carry out the evaluation of transparency indexes of public entities in 2013. Target is subject to evaluation. Number of Systems Services (Servicios Number Value 12.00 19.00 40.00 Informáticos Electrónicos), transfered to Date 18-Dec-2009 30-Jun-2013 31-Dec-2013 DIAN’s technology area increases from 12 Comments Value for indicator remains Target for not likely to be to 40 unmodified. A methodological reached. revision was proposed in order to transfer at least 35 information services to DIAN's Technology Unit Carry out pilots allowing the disaggregation of Text Value limited interoperability of 1 pilot program expenditure information systems Date 18-Nov-2009 30-Jun-2013 31-Dec-2013 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 30-Jun-2013 31-Dec-2013 Public Disclosure Copy 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 30-Jun-2013 31-Dec-2013 Comments Achieved and reported - IFR December 2012 Page 5 of 8 The World Bank Report No: ISR11786 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 30-Jun-2013 31-Dec-2013 Public Disclosure Copy 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 30-Jun-2013 31-Dec-2013 treasury & debt management system is in Comments no baseline available Progress in the indicator will year 4 indicator operation within the DGCPTN (the current debt system is maintained temporarilly depend on the definition of a line of business and software 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 30-Jun-2013 31-Dec-2013 and effectively does so, has increased from 0% Comments Progress in the indicator will year 4 indicator to 100% depend on the definition of a line of business and software for DGCPTN The number of methodologies and processes Text Value 8 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 The increase in the number year 4 indicator shows an improvement in the analytical capacity of DGCPTN 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 30-Jun-2013 31-Dec-2013 from 15 to 25 Comments No progress reported year 4 indicator Studies have been conducted on the economic Text Value limited capacity to carry out in 30 studies Studies completed and social impact of global warming depth and strategic studies Date 18-Nov-2009 30-Jun-2013 31-Dec-2013 Public Disclosure Copy Comments 30 studies were finished in Measured annually 2012. An additional study is being developed in 2013 for a total of 31 studies 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 30-Jun-2013 31-Dec-2013 Comments 4 studies completed in 2012. An additional study is programmed for 2013 Page 6 of 8 The World Bank Report No: ISR11786 Plan for the Implementation of Decree 28 Text Value Plan for the implementation of Decree 28 Date 18-Nov-2009 30-Jun-2013 31-Dec-2013 Public Disclosure Copy 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 is oriented towards budget process have been compliance rather than drafted effectiveness and efficiency Date 16-Nov-2009 30-Jun-2013 31-Dec-2013 Comments Achieved and reported - IFR year 3 indicator December 20112 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 30-Jun-2013 31-Dec-2013 Comments New reports and updates on year 4 indicator security functionalities and communications for The Economic Transparency Portal (PTE) were designed. Data on Financial Performance (as of 02-Aug-2013) Financial Agreement(s) Key Dates Public Disclosure Copy 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 P106628 IBRD-78310 Effective USD 25.00 25.00 0.00 19.42 5.58 78.00 Disbursement Graph Page 7 of 8 The World Bank Report No: ISR11786 Public Disclosure Copy Key Decisions Regarding Implementation Bank implementation support mission carried out in August 2013. Restructuring History Level two Approved on 14-Feb-2013 Related Projects There are no related projects. Public Disclosure Copy Page 8 of 8