Version 2.0 Service Pack 2 Release Notes

Version 2.0

Service Pack 2

Release Notes

Commonwealth Secretariat

© 2016 Commonwealth Secretariat, all rights reserved Copyright of the whole and any part of this document is owned by the Commonwealth Secretariat, London. No reproduction of the whole or any part of this document is to be made without authority of the Commonwealth Secretariat.

All enquiries should be directed to: Head, Debt Management Unit Commonwealth Secretariat Marlborough House Pall Mall London SW1Y 5HX United Kingdom

Contents

A. Introduction ... 4

B. New Functions, Features and Enhancements ... 6

B1. Liability Management Operations ...6

B2. Creditor Practices and Instrument Terms ...7

B3. Management Tools ...8

B4. Reports and Dashboard ... 10

B5. Data Exports ... 14

B6. Usability ... 14

C. Bug Fixes ...17

D. Hardware and System Software Requirements ...20

D1. Hardware Requirements ... 20

D2. System Software Requirements ... 20

E. Software Installation and Database Upgrade ...22

E1. Pathway for clients moving from CS-DRMS v1.3 or earlier versions to CS-DRMS Version 2 Service Pack 2 ... 22

E2. Pathway for clients moving from CS-DRMS Version 2 to CS-DRMS Version 2 Service Pack 2 ... 22

A. Introduction

These release notes relate to the deployment of CS-DRMS Version 2.0 Service Pack 2 and highlight the features and enhancements introduced in this new version to further improve the functional richness of CS-DRMS and provide better support to Debt Managers. To keep CS-DRMS in line with technological shifts, CS-DRMS is now supported on Windows Server 2012 platform. On the database side, CS-DRMS is now further supported on SQL Server 2012 and Oracle 12c.

This document outlines the major functional changes included in the new CS-DRMS as well as a list of the bugs that were identified in previous versions and now fixed in the new CS-DRMS. Some of the major changes provided with Service Pack 2 are:

• Enhancements to existing functionality of Liability Management

Operations (LMO) with addition of an option for ‘Prepayment’ that enables countries to record a prepayment of their remaining obligation in full or partially. LMO has also been enriched with the inclusion of Accelerated Repayment. This option may be used by countries that become credit worthy for IBRD borrowing and the country’s per capita Gross National Income (GNI) reaches or exceeds the operational cut-off for IDA eligibility.

• A facility to record loans which are interest-free, for part or whole of their life.

• Management Tools module now includes enhanced Sensitivity

Analysis to assist debt managers make more informed decisions.

• The Dashboard, which was released with CS-DRMS Version 2, has

also been enhanced to improve data precision when reporting figures on its various summaries.

• Standard reporting has been enhanced with specific changes to certain reports. Some of these changes bring specific reports more in line with the reporting requirements of the External Debt Statistics: Guide for Compilers and Users. Data Export capability of the system has been improved to align the QEDS/GDDS Data Export facility with the revised template recently introduced by the World Bank.

• The underlying database structure for CS-DRMS has been

normalized to bring in significant improvement in the system’s performance during processing and aggregation. Removal of sizeable data repetition along with splitting of key tables and reorganisation of data within tables has led to measurable performance gains to aggregation.

In order to assist users install the new CS-DRMS and upgrade from the previous version, these notes include a section on installation and upgrade. The release notes are therefore organised as follows:

i. New Functions, Features and Enhancements

ii. Bug Fixes

iii. Hardware & System Software Requirements

iv. Software Installation and Database Upgrade

B. New Functions, Features

and Enhancements

B1. Liability Management Operations

The Loans module in CS-DRMS version 2 includes a tool to implement various embedded options that can be executed on loan agreements. As most international creditors also offer additional options in their financial products, the Liability Management Operations tool in CS-DRMS has been upgraded with the addition of Prepayment and Accelerated Repayment facilities to better model product terms.

1. Prepayment

Prepayment allows the borrower to prepay the remaining loan obligation in full or partially. In the case of partial payments, CS-DRMS has four in-built methods for precomputing the cash-flow based on the outstanding debt. The methods are Front Loaded, Reverse Maturity, Prorata and Custom.

2. Accelerated Repayment

‘Accelerated Repayment’ is another option added in Service Pack 2 which raises each repayment by a given multiple and accordingly reduces the remaining maturity of the instrument. The ‘Acceleration Clause’ can be switched on or off in the system for a given instrument. If the ‘Acceleration Clause’ is switched off, the amortization schedule will revert to the original schedule from the next payment.

X Accelerated Repayment option execution and adjusted schedule.

B2. Creditor Practices and Instrument Terms

3. Interest Free and Service Fees Free Forecasting Rule Type CS-DRMS Version 2 does not have a facility to stop a loan from charging interest (i.e. convert the loan to an Interest Free Loan). Earlier versions of CS-DRMS allowed the addition of an Interest Rule with Interest Rate = 0, however CS-DRMS Version 2 does not allow users to do the same. With this Service Pack, users can create a new interest free rule to cover periods when an instrument does not attract any interest. On the same lines, a new forecasting rule type has been added which allows users to have Service Fees Free loans in the system.

B3. Management Tools

The Sensitivity Series in Management Tools has now been de-linked from Scenarios and therefore the same series (set of variations to Exchange Rates, Interest Rates and Macro variables) can be used for different scenarios and for Sensitivity Analysis.

5. Aggregation Wizard Reporting

While creating custom reports using the Aggregate Wizard in Management Tools, users can now apply Scenarios for data comparison purposes.

6. Standard Reports

Certain standard reports now give users the option to choose and include Scenarios created in Management Tools for data comparison.

X Standard Report 729 in Management Tools with Scenario included for data comparison.

B4. Reports and Dashboard

Report 614 – EDG Table 7.1 Gross External Debt Position : Short Term Remaining Maturity – By Sector

This report provides short-term debt stock (based on remaining maturity) which now includes Disbursed and Outstanding Debt, Interest Arrears, Principal Arrears and Accrued Interest. It also shows the long-term debt (based on original maturity) which includes arrears of principal and interest for the reporting period, sum of principal payments falling due in the next 365 days and the accrued interest.

Report 618: EDG Table 7.5 – Gross External Debt Position: Principal and Interest Payment Due in One Year or Less.

This report has been revised to keep it in line with the External Debt Guide Table 7.5 requirements.

8. Dashboard

i. The Dashboard, which was released as a new feature with

CS-DRMS Version 2.0 has been enhanced to ensure reported figures in the various summaries are more precise.

ii. The Data Quality Summary now excludes exchange rates for

instruments that have matured or are no longer reported on, when determining the score.

iii. The performance of the Currency Composition Summary has been enhanced to render data faster.

iv. Stocks Charting Tool and Flows Charting Tool, which previously

only reported stock and flow figures in local currency have now been enhanced to ensure that users can report not only in local currency but also in other currencies flagged as an

Aggregate Currency.

X Stock Charting Tool – Reporting option in Local and Aggregate Currency

X Flow Charting Tool – Reporting option in Local and Aggregate

Currency

v. Dashboard Layouts allow users to add summaries to the

dashboard and save the state for future reference. Users now have the option to delete saved dashboard layouts, change the name of the layout and also change the layout’s availability from private to public and vice versa. When public, all users of CS-DRMS are able to view the specific dashboard layout; while in private mode, only the specific user who has created the layout can view it.

9. Aggregation Wizard

Users are now able to edit or delete reports which are created using the Aggregate Reports Wizard.

This function can be accessed from the ‘Reports > Aggregate Reports’ option that allows users to amend the name of the saved report, settings of their private or public entries along with the option to make them available/ hidden in the standard report explorer. It allows users to create a new aggregate report, delete any saved report and also open any saved reports in the wizard and amend their settings.

B5. Data Exports

10. QEDS-GDDS Data Export

The QEDS-GDDS Data Export facility has been revised in-line with the new World Bank/IMF template introduced in October 2014. The older version only reported four tables while six tables, that are compliant with the revised GDDS-QEDS template, are exported in this new version. Visit: http://datatopics.worldbank.org/debt/gdds-methodology for more information on the changes to the QEDS-GDDS data template.

X QEDS/GDDS Data Export: New Version 11. World Bank DRS Purpose Codes

Changes have been made in CS-DRMS to incorporate the new World Bank Debtor Reporting System (DRS) purpose codes, in line with the System of National Accounts (SNA) codes. Both csv and SDMX outputs have been modified to include this revision.

B6. Usability

12. Period End Processing

The “Period End Processing” facility now has a ‘List’ option which provides more information to the user about the state of instruments.

Clear categories of ‘Processing required’, ‘Aggregation required’ and ‘Processed and Aggregated’ are shown. This will assist users to quickly identify instruments which are preventing the ‘Period-End Processing’ from commencing. Additional information pertaining to each of the instruments detailing their instrument id and type along with tranche and bid details (in case of securities) is also presented to the user. Double clicking on an instrument in the list navigates the user directly to the instrument itself. Users can process all the listed instruments at one go using the “Process All” option.

X Period End Processing 13. Instrument Explorer Flags

A “blue” flag has been introduced in the instrument explorer to identify instruments that require “aggregation only”. This enhancement complements the “red” flag that is displayed for instruments that require processing and aggregation.

X Blue “requires aggregation only” flag. Red flag denotes “requires processing and aggregation”.

14. Instrument Processing Performance

The performance of the system, while processing and aggregating instruments, has been improved significantly which will ensure that sites with large databases will be able to use the system more efficiently.

15. Performance improvement in specific Oracle reports

Speed and performance in data computation for specific reports have been enhanced to ensure that these are quickly presented to users for both Oracle and SQL Server databases.

16. Accrued Interest Computation for Securities

CS-DRMS has been enhanced to also compute accrued interest for Securities which is used in Report 610 (External Debt by Borrower Sector). This is also available within the Aggregation Wizard.

C. Bug Fixes

The table below displays a list of the major bugs identified with previous versions that have been fixed in Service Pack 2.

Module Issue Client

Dashboard Data Quality Summary: the Actual Transactions. This data quality

indicator measures how many forecast transactions after the cut-off date up until 7 days prior to the current date do not have actual transactions.

The system not catering for situations where instruments do not have any forecast transactions in the period being measured.

Fiji

Aggregate Wizard

Creditor Reference to be made available as a dimension on aggregate wizard and pivot grid filters.

Kenya

MTDS The MTDS does not work if the

participant code for the selected agency is not 4 characters long. This should work irrespective of the size of the participant code. St Kitts and Nevis Additional forecast transaction for 365 days T-Bills

A 365 day T-Bill generating an additional discount payment transaction after the maturity date.

St Kitts and Nevis

Country

Reports

If users run a Country Report, they receive the following error:

“Access violation at address 031901E6 in module ‘rbRCL77.bpl’. Read of address 0000002C”

Trinidad & Tobago

Module Issue Client

Loan Details When instruments are sorted (order by) or filtered using the ‘Budget Finance’ field in the Instrument Explorer, the instruments listed under the respective ‘Budget Finance’ group not necessarily flagged as ‘Budget Finance’ and vice versa.

Crown Agents

Securities In case of buybacks, not possible to capture prices with decimal values

Barbados

Forecasting

Rules

“Edit” and “Delete” buttons enabled when no “Forecasting Rules” exist.

Using any of these two buttons when no rules existed resulted in system exceptions.

Other

Frame Agreements

Frame Agreement instruments remain marked as ‘Un- aggregated’ even when they have been processed. They are listed in the dashboard summary for ‘Unprocessed Instruments’ but not in the instrument explorer when the filter ‘Instruments processed=False’ is applied.

Other

Management Tools

As a NON-CWS user, the action of deleting an instrument does not actually delete the instrument neither does the process of cancelling the creation of instrument work as expected.

Other

System Parameters

The Local Currency value is not saved when modified in System Parameters. Although, change is actually effected on the screen but new value is not updated in the database.

Other

Loans

Restructuring

Processing of Multi-Tranche Restructured instruments leads to duplication of transactions in the database and the instrument subsequently fails to process successfully.

Module Issue Client

Exchange Rates

When changes made to exchange rates for aggregate currencies, the system is not marking active instruments ready for aggregation and processing on or after the entered exchange rate date.

Other

Restructuring

(Securities)

Buy Back of Securities

Buy backs in case of securities which have been reopened previously, reported incorrect face value of the security. This issue has been resolved such that reopened securities reflect the correct face value by including the “reopened amount” to its face value.

Other

Management Tools

User allowed to select currency without aggregate figures in the Portfolio Analysis-->Snapshot page. Dropdown has been limited to just the aggregate currencies.

Other

Management Tools

Entries within the Sensitivity Rate Names for Macro Economic Data using start of year instead of end of year.

D. Hardware and System Software

Requirements

CS-DRMS Version 2.0 Service Pack 2, with a client/server architecture, operates on a Windows platform and supports both MS SQL Server and Oracle databases.

D1. Hardware Requirements

Sites should have the following hardware set up for operating Version 2 Service Pack 2:

Server • Processor: Intel Xeon X5570 2.93 GHz Quad Core or faster

• Memory: 8 GB RAM

• HDD: 160 GB

Workstations

(client)

• Processor: Pentium ® Core i3n 2.1 GHz or

faster

• Memory: 4 GB RAM

• HDD: 80 GB

D2. System Software Requirements

The following environment is required for running CS-DRMS Version 2.0 Service Pack 2

a. Operating System

– Server – Windows Server 2008, 2012

b. Supported Databases

– Microsoft SQL Server1 2005, 2008 R2, 2012

– Oracle 10g , 11g2, 12c

c. Other System Software

• Server

– Microsoft .NET framework 43

• Client

– Microsoft Office

– Adobe Acrobat Reader

– Microsoft .NET framework 4

1 Ensure that SQL Server Authentication is enabled (mode = mixed mode)

2 The server can be 64-bit but for running CS-DRMS, the 32-bit oracle client should be installed

E. Software Installation and

Database Upgrade

E1. Pathway for clients moving from CS-DRMS v1.3 or

earlier versions to CS-DRMS Version 2 Service Pack 2

Follow the installation and upgrade instructions provided in the document Installation_Notes.pdf.

E2. Pathway for clients moving from CS-DRMS Version 2 to

CS-DRMS Version 2 Service Pack 2

The Installation of CS-DRMS Version 2 with Service Pack 2 consists of the following steps:

– Uninstalling older version of CS-DRMS

– Installing CS-DRMS Version 2 with Service Pack 2

– Upgrading the database

– Data Validation

NOTE: A back-up of the CS-DRMS database should be made and kept in a safe place before software installation and database upgrade.

a. Uninstalling Older Version of CS-DRMS

If you have older version of CS-DRMS installed on your system, uninstall this existing version through the Windows control panel. Tip: Please take a copy of the CSDRMS_Connections.ini file before you uninstall CS-DRMS. This file is in the same folder where you have installed CS-DRMS.

NOTE: After uninstalling the software, ensure that the installation folder for CS-DRMS is also deleted.

b. Installing CS-DRMS Version 2 with Service Pack 2

Insert the CS-DRMS Version 2 with Service Pack 2 CD and run the Setup.exe file. After CS-DRMS Version 2 with Service Pack 2 is installed, put the CSDRMS_Connections.ini file that you had saved

in step (a) back in the folder where you have now installed CS-DRMS. This will overwrite any CSDRMS_Connections.ini file which has come along with the installation.

c. Upgrading the database

NOTES:

– The following steps should be performed on the “Server” only.

– Before performing the following steps, please back up your

database(s).

i. To upgrade the database version to match the service

pack application version, go to Start->All Programs->The Commonwealth->Database Upgrade

ii. In the screen that appears, click Login on the top left corner of the screen and log into the appropriate CS-DRMS database you would like to upgrade. For MSSQL, log in with the ‘sa’ account while for ORACLE login with the ‘system’ account

iii. On successful login, click on the ‘Upgrade’ button to start the upgrade. This process might take some time to complete. When it is finished, a message will popup indicating that the process has been completed.

NOTE:

The upgrade process is interactive and will show the various activities being executed on the database. Activities that are completed with errors will be highlighted.

Once the process is completed, a pop-up message will be displayed indicating whether there were any errors encountered during the upgrade process. If there are any errors, save the upgrade log file using the ‘Save Results’ button and send the file to COMSEC ([email protected] ) for further investigation. It is important to investigate these errors before proceeding to the next stage to ensure that none of the errors are critical.

d. Data Validation

To ensure the integrity of data once the database has been migrated to Version 2 Service Pack 2, users should undertake a database validation after the upgrade process to resolve any data corrections identified for the system since the previous releases. The steps for performing data validation are given below. However, refer to the Section 3.6 in the Installation_Notes.pdf document for details. NOTE:

– The following steps should be performed on the “Server only”

– It is strongly recommended that the post-upgrade validation

should be undertaken in the presence of a CS-DRMS user so that any validation errors are fixed by the CS-DRMS user.

i. Go to Start->All Programs->The Commonwealth->CS-DRMS

Server tools

ii. In the screen that appears, click Login on the top left corner of the screen and log into the appropriate CS-DRMS database you would like to validate. For SQL Server, log in with the ‘sa’ account while for ORACLE login with the ‘system’ account

iii. On successful login, click on the ‘Validate Data’ button visible on the left menu under the Database Utilities. Expand and tick all the options shown on the right and the click on ‘Run Selected Validation’ button on the top to start the validation.

iv. The CS-DRMS Validate feature will go through the database

to validate the integrity of the data and where possible provide a solution to fix the data. Select each validation by expanding the validation name and ticking the option. It is advisable that validations are selected and run one at a time. Click on ‘Run Selected validation’

v. Review the issues that the validation has identified and only apply the provided solution if you are happy with the proposed solution. This is not an action that should be taken lightly. Often you will have the option to select a different solution or to

resolve the issue directly within the system itself. To apply the solution check the apply column for each issue; Select ‘Check All’ to select all the validation errors; and click on ‘Apply Selected Solution’ to fix the identified validation issues.

vi. Validation issues that have recommended solutions are not

automatically applied. Users still have to tick the check box to indicate that they wish to apply the solution and then click the Apply Selected Solutions button to resolve the issue. Those resolved will be marked as ‘resolved’

In case of any doubts or clarifications,  it is always advisable to save the validation file using the   ‘Save Results’ button and send the file to COMSEC ([email protected] ) for investigation and advice.

F. Getting Support

The CS-DRMS team as usual is fully committed to supporting and guiding clients during the software installation and database upgrade phase. In case users need any assistance, the support team can be contacted through e-mail on [email protected]. The Secretariat also operates a service via the internet where the CS-DRMS support team can remotely and securely log into clients’ systems for virtually onsite interaction, if this is deemed necessary and upon request by users.

Marlborough House, Pall Mall London SW1Y 5HX

United Kingdom