functional specification - accounts - version 1 0 -june 25-6-2008

Upload: aditham-subba-rao

Post on 07-Apr-2018

215 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    1/53

    RESERVE BANK OF INDIA

    PDONDS COMPUTERISATION PROJECT

    CENTRAL DEBTS DIVISION (CDD)

    Version 1.0

    Prepared by

    May 2008Confidential and controlled document

    Unauthorized access or copying is prohibited

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    2/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    Document Release Notice

    Project Name:

    Document Detail:

    Name Version No. Description

    Functional

    Specifications

    Accounts

    1.0 This document contains the high-level

    functional specifications for Central Debts

    Division.

    Revision List

    Action Taken

    (Add/Del/Chg.)

    Previous

    Page No.

    New Page No. Revision Description

    This document and any revised pages are subject to document control.

    Please keep them up-to-date using release notice from the distributor of

    the document.

    Prepared By: TCS Limited Date:

    Reviewed/Approved By: Date:

    Authorized By: RBI Date:

    TCS RBI Confidential Page 2 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    3/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    CONTENTS

    ACCOUNTS SECTION .......................................................................................... 4

    1.2 Activities related to compensation bonds:................................................... 45

    1.3 Report on Audit of Paid Vouchers: ............................................................. 48

    APPENDIX I: ACRONYMS AND ABBREVIATION ...........................................53

    TCS RBI Confidential Page 3 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    4/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    ACCOUNTS SECTION

    The services and functions that CDD Accounts module must consist are discussed

    in this section. Account section primarily deals with maintenance of central

    accounts of public debt of the Central Government and State Governments,

    agreement and verification of loan balances, writing off of the outstanding balances

    of discharged loans, recovery of half-yearly management commission and budget

    estimation in respect of interest payment and repayment.

    2.2.1 Central Loan Ledger Maintenance

    Central Debt Divisions Central loan ledger module must fulfill the following

    requirements:

    Item Functions Descriptions

    1.1 Central Loan LedgerManagement

    Query/add/change/delete the details ofCentral Loan Ledger

    1.2 Reconciliation registersmanagement

    Query/add/change/delete details inReconciliation Register

    1.3 Generation of quarterlystatement for theAGs/Financedepartment/Governmentof India

    Query/add/change/delete details ofquarterly statement

    1.4 Search list of loans duefor redemption for the nextfinancial year

    Query loans details

    1.5 Generation of quarterlystatement of T.Bills sentto CCA

    Query/add/change/delete details ofquarterly statement

    1.Loan circular to be made available to Accounts Section is available in

    PDO-NDS server.

    TCS RBI Confidential Page 4 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    5/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    2. Data of PDO-225 received from the loan section is available in PDO-NDS

    server. CDD can dispense with PDO-225. CDD user can view and print the

    details of PDO-225 in report format.

    3. Quarterly RD/NT statements are sent to the Section by all PDOs. This

    statement is already incorporated in the PDONDS system and thus all the

    details are available. Provision to be also provided for generation of reports

    on quarterly basis.

    4. For Generation of quarterly statement of T.Bills sent to CCA provision to

    be provided to PDO issuing T.Bills, PAD Kolkata and CAS. The opening

    balance, new issue, repayment and closing outstanding balance of T.Bill will

    be entered by the offices concerned and will be consolidated in CDD

    database. The outstanding balance pertaing to following T.Bills needs to be

    captured.

    a) 14 days T.Bill

    b) 91 days T.Bill

    c) 182 days T.Bill

    d) 364 days T.Bill

    5. For the reconciliation register (maintained in excel sheet) maintained by

    the system, the following details can be picked up directly from the PDONDS

    system:

    a) Inter-PDO transfer balances against relevant PDOs

    b) PDO wise balances for the loans

    c) Total Central ledger balance for the loans

    d) Difference (if any)

    6. For the central loan ledger maintained by the Section, the following details

    can be picked up directly from the PDONDS system:

    TCS RBI Confidential Page 5 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    6/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    a) Opening balance

    b) Date

    c) PDO-wise issues/repayments and adjustments

    d) Closing balances

    e) Maturity date

    4. For the quarterly statement generated by the Section for the

    GOI/AGs/Finance department, the following details can be picked up from

    the PDONDS system:

    a) Nomenclature of the loan (in case of State Government, details of

    Power Bonds to be captured from PDO-NDS).

    b) Opening balances for the quarter

    c) Amount of script issued during the quarter

    d) Disbursements during the quarter

    e) Closing balance for the quarter

    f) Total of each column for matured loans

    g) Total of each column for Terminable loans including unfunded debt

    (meant for GOI)

    h) PDO wise new issues/repayments during the quarter loan-wise

    i) Total balances PDO wise for new issues/repayments during the

    quarter

    The following details may need to be entered by the PDO users through a

    GUI to be provided:

    a) Total of each column for special issues of GOI

    b) PDO-wise holding of special issues

    5. In respect of ADC and VDS, in the current

    implementation of PDONDS at the PDOs, the data for these schemes has not

    been migrated. Therefore, the Rupee Debt Statement will not cover these

    schemes and, resultantly, the data will not flow to the central database for

    TCS RBI Confidential Page 6 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    7/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    automatic updation/generation of central loan ledger. The authorized PDO

    user needs to enter the details of ADC and VDS through GUI. All details will

    be captured in CDD database and authorized CDD users can also have

    access to the data.

    6.The communication received by the CAG/AGs/Finance Departments, if there

    were any discrepancies found in the balances sent by DGBA and PADs, is

    used for the communication to the respective PDOs / PADs and CAS for

    rectification of the difference. (The communication should be manual).

    1.1.1 Post condition1. CDD needs to dispense with quarterly RD/NT statement, as

    these data is available in PDONDS.

    2. CDD needs to dispense with PDO-225 as these data is

    available in PDONDS.

    3. VDS and ADC data need to be entered manually into the

    CDD system by authorized PDO users.

    1.1 Management Commission

    Central Debt Divisions Management commission module must fulfill the following

    requirements:

    Item Functions Descriptions

    1.1 Central and StateGovernment Commissioncalculation on outstandingloan balance

    Query/add/change/delete commissioncalculation details

    1.2 Commission calculationfor Annuity DepositCertificates

    Query/add/change/delete commissioncalculation details

    1.3 Commission calculationfor Voluntary DepositCertificates

    Query/add/change/delete commissioncalculation details

    1.4 Commission Registermaintenance

    Query/add/change/delete commissiondetails

    1.5 TRA details Query/Edit/Add/Delete the TRA details

    TCS RBI Confidential Page 7 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    8/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    1. The statement regarding the outstanding balances of loans is available in

    PDONDS.

    2. For the statement received from the PDO regarding the recently matured

    (Matured less than a year ago) and current loans, the following data can

    be directly picked up from PDONDS:

    Central Government Loan and State Government Loan

    a. New Issue

    i. Nomenclature of loan

    ii. Outstanding amount

    b. Cancellation

    i. Nomenclature of loan

    ii. Outstanding amount

    3. As the PDONDS does not contain the balances of the following loans.

    They may be entered through a GUI screen.

    i) Balances held by the Ministry of Finance

    a. Outstanding Amount

    ii)Statement of Stock Certificates for Rs. 50,000 and above held by

    the Government Official Administrator/Administrator Post and

    Telegraph Department

    a. Nomenclature of loan

    b. Outstanding Balance

    iii) Particulars about the 10 year Annuity Deposit Certificate(Second Series, 1964 and 1966)

    a. Nomenclature of loan

    b. No. of securities

    c. Outstanding amount

    TCS RBI Confidential Page 8 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    9/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    iv) Particulars of perpetual loan

    a. Outstanding amount

    4. For the statement from the PAD/PDO regarding the central/state

    government securities for Rs. 50,000 and above held by the administrator,

    the following data may have to be entered through a GUI

    i) Nomenclature of the Loan

    ii) Face Value

    5. For the communication sent to the PDOs asking them to send the

    information on the securities held by the government officials, which is in

    text form. Provision is to be provided to authorized, PAD Mumbai, user to

    enter the details on securities held by government officials for calculating

    management commission.

    6. For the statement received from the BRIS, the following data can be

    entered by authorized CDD user for management commission calculation:

    i) Rupee security held in the Issue Department under Normal

    and Market Stabilization Scheme

    a. Outstanding amount

    ii) Rupee security held in the Banking Department under the

    Normal and Market Stabilization Scheme

    a. Outstanding amount

    7. The consolidations/calculations in the excel sheet that contains the half

    yearly commission value, prepared by this Section, can be made availabledirectly by the CDD system on the basis of the data entered above and

    will contain the following fields:

    a. Amount on which commission has to be charged for the central

    government loans.

    TCS RBI Confidential Page 9 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    10/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    b. Amount on which commission has to be charged for the state

    government loans.

    c. Deduct the following figures from the central government loan

    outstanding balances:

    i. Balances for 15 years Annuity Certificates [2nd Series]

    ii. Balances for 10 years Annuity Certificates [1964

    Scheme]

    iii. Balances for 10 years Annuity Certificates [1966

    Scheme]

    iv. Balances for 4.5 % 10 Years Defence Deposit

    Certificates

    v. Balances on amount of securities held by the Issue

    Department

    vi. Amount of stock certificates / balances in SGL Account

    for Rs. 50,000/- and upwards held by other government

    officials / Reserve Bank of India, Ministry of Finance and

    individual administrators.

    d. Add the following figures from the central government loan

    commission:

    i. Balances on the perpetual loan

    ii. Loans not bearing interest but accounted for commission

    (one year from the date of maturity).

    e. After this arrive at the commission figure @ Rs. 2000/- per crore

    per annum and than Add the following figures

    i. Commission on Treasury bills

    ii. Fixed allowance of Rs. 1000 (only if securities held byGOI officials is more than one crore.

    A copy of the letter forwarding the bill is sent to CAS Nagpur, in case of State

    Government (except Jammu & Kashmir and Sikkim) and PDO Delhi in case

    TCS RBI Confidential Page 10 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    11/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    of Central Government. The details pertaining to management commission

    will be maintained in commission register.

    8. The rough register prepared to track has the following data that can be

    picked up directly from PDONDS. The maintaining of rough register

    should be stopped as data is there in PDONDS and it would be available

    to CDD user.

    b.The loans that have recently matured and on which the

    commission has to be charged.

    9. The final figure for provisional commission sent to the DBA has the

    following data that can be directly picked up from CDD system. The

    communication sent to the DBA is manual.

    a. Commission amount for central government loans

    b. Commission Amount for state government loans

    c. Total amount

    d. Add the commission not realized from the last half-yearly

    commission claimede. Final total commission

    10. For the communication from BRIS containing the outstanding balances of

    rupee securities of the Bank the following data can be picked up directly

    from the PDONDS system:

    The following data may have to be entered by the CDD user through a

    GUI

    a) Letter number

    b) Rupee securities held in Issue Department as on end of the quarter

    c) Rupee securities held in Banking Department as on end of the

    quarter

    TCS RBI Confidential Page 11 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    12/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    11.For consolidating, calculating and maintaining the commission on the

    central government loans and treasury bills, a separate field will have to

    be provided in the CDD database. Then, the following data can be picked

    up from the PDONDS system into CDD database and the commission

    calculation can be done there.

    a) Outstanding balances of active loans in that half-year

    b) Balances of loans not bearing interest but accounted for

    commission (Matured within 1 year from calculation of

    commission)

    c) Balances of 91 days T-Bills

    d) Balances of 182 days T-Bills

    e) Balances of 364 days T-Bills

    The following data may have to be entered by the user through a GUI

    a) End date of Half year for which commission is being

    calculated

    b) All required calculations could be done on the basis of input

    or generated information

    c) Loans not accounted for commission for example,- 15 years

    annuity certificates and others

    d) Amount of securities held by government officials and others

    e) Any adjustments for last commission calculation

    f) Rupee securities held by RBI under Issue Department

    g) Rupee securities held by RBI under Banking Department

    h) Balances of 14 days Intermediate T-Bills

    i) Balances of 14 days T-Bills

    j) Bill numberk) Bill date

    12. For the copy of the communication of PDO Delhi to the finance

    department to inform about the amount debited to the government account

    TCS RBI Confidential Page 12 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    13/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    for the half-yearly commission, the following data can be picked up directly

    from the PDONDS system:

    a) Total amount of half yearly commission

    The following data may be entered by the user through a GUI screen:

    b) Letter number of Finance Department allowing debit of their

    account

    c) Date of communication of Finance Department allowing

    debit of their account.

    d) Date of communication

    e) Letter number

    13. For the TRA sent by Delhi PDO to debit them through RBI General

    Account and credit the commission account held by DGBA, the following

    data can be picked up directly from the PDONDS system:

    a) Total amount of half yearly commission

    The following may have to be entered by the user through a GUI

    screen:

    b) Advice number

    c) Schedule number

    d) Date of TRA

    14.For the TRA advice sent to Public Debt Office Delhi to inform them about

    crediting of DGBA commission account, the following data may have to be

    entered by the user through a GUI screen:

    a) Date of responding advice

    b) Schedule number of advicec) Amount of half yearly commission

    ii) State government commission (except Sikkim and Jammu and Kashmir):

    TCS RBI Confidential Page 13 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    14/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    1. There is no provision in PDONDS for consolidating and calculating the

    commission on the state government loans. A separate field will have to

    be provided for the same and maintain the commission and generate the

    bill state-wise. Then, the following data can be picked up from the

    PDONDS system into CDD database and the commission calculation can

    be done there.

    a) End date of half year for which commission is being

    calculated

    b) Nomenclature of current loans (including discharged loans

    which have not completed one year from the date of discharge),

    which are eligible for commission

    c) Individual outstanding balance for each loan as mentioned

    earlier

    d) Nomenclature of current loans (including discharged loans

    that have not completed one year from the date of discharge),

    which are eligible for commission. (In case of newly formed

    states the loans before the date of re-organization of states)

    e) Individual outstanding balance for each loan as mentioned

    above

    f) Nomenclature of power bonds

    g) Individual outstanding balances for Power bonds

    h) Name of state/s

    i) Date of bill

    All required calculations could be done on the basis of input or generated

    information.

    The following information can be entered into the system through aGUI screen

    a) Amount of current securities above Rs 50,000 and held by

    government officials

    TCS RBI Confidential Page 14 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    15/53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    16/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    4. For the TRA advice sent back to CAS to inform them about crediting of

    DGBA commission account, the following data may have to be entered

    through the GUI screen:

    a) Date of responding advice

    b) Schedule number of advice

    c) Amount of half yearly commission

    5. In case the bill is not realized within 3 months from date of bill CDD

    user is to receive a system generated alert and accordingly a reminder

    sent to CAS Nagpur.

    iii) State Government commission for Sikkim

    1. The mapping for half yearly commission calculation and generating

    the Bill for the Sikkim is already taken care of in the earlier Section of

    State government commission for state government except Sikkim and

    Jammu and Kashmir.

    2. On receipt of cheque by PDO Guwahati, the following data may be

    entered into the system by PDO user through a GUI:

    a) Date of communication

    b) Cheque number

    c) Cheque date

    d) Amount of half yearly commission

    e) End of half year date for which commission is being paid

    f)The letter number

    3. For the fax from PDO Guwahati to inform the Section that the credit

    has been received from government of Sikkim, the following data may

    have to be entered into the system through a GUI

    TCS RBI Confidential Page 16 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    17/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    a) Date of fax

    b) Amount of half yearly commission

    c) Double of half yearly commission

    d) End date of half year for which commission is being paid

    e) The letter/fax number

    4. For the TRA from PDO Guwahati to credit the commission account

    held by Department of Government and Bank Accounts, the following

    details can be entered into the system through a GUI:

    a) Advice number

    b) Total amount of half yearly commission

    c) Schedule number

    d) Date of TRA

    5. For the TRA advice sent back to PDO Guwahati to inform them

    about crediting of DGBA commission account, the following details can

    be can be entered into the system through a GUI:

    a)Date of responding advice

    b) Schedule number of advice

    c) Amount of Half yearly commission

    iv) State Government commission for Jammu and Kashmir.

    1. The mapping for half yearly commission calculation and generating

    the Bill for the J&K is already taken care of in the earlier Section of

    State government commission for state government except Sikkim and

    Jammu and Kashmir.

    2. On receipt of cheque from J&K Bank to PDO Delhi, the following

    data may have to be entered into the system by PDO user through a

    GUI:

    TCS RBI Confidential Page 17 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    18/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    g) Date of communication

    h) Cheque number

    i) Cheque date

    j) Amount of Half yearly commission

    k) End of half year date for which commission is being paid

    l) The letter number.

    3. For the fax from PDO Delhi to inform the Section that the credit has

    been received from government of J&K, the following data may have to

    be entered into the system through a GUI:

    a) Date of fax

    b) Amount of half yearly commission

    c) Double of half yearly commission

    d) End date of half year for which commission is being paid

    e) The letter/fax.

    4. For the TRA from PDO Delhi to credit the commission account held

    by Department of Government and Bank Accounts, the following

    details can be entered into the system through a GUI:

    a) Total amount of half yearly commission

    b) Advice number

    c) Schedule number

    d) Date of TRA

    5. For the TRA advice sent back to PDO Delhi to inform them about

    crediting of DGBA commission account, the following details can beentered into the system through a GUI:

    a)Date ofresponding advice

    b) Schedule number of advice

    c) Amount of Half yearly commission

    TCS RBI Confidential Page 18 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    19/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    v) Commission for Annuity Deposit Certificates (1964 and 1966):

    1. The letter sent every June and December end to all PDOs to send

    the number of outstanding certificates in the schemes has text but has

    the letter number and date as relevant data that can be entered into

    the system through a GUI.

    2. The data for ADC is not present in PDONDS currently. Provision is

    to be provided to authorized PDO user to enter the number of

    outstanding certificates at the end of the half year through a GUI:

    )a Nomenclature of loan

    )b No of outstanding certificates

    )c Total commission chargeable on the basis of Rs 1.95 per

    outstanding certificate.

    )d Date

    3. For the data entered into the passbook and the total

    amount calculated and verified, the following data may be entered

    directly through a GUI:

    )a Nomenclature

    )b Half-year end date for which handling charges are calculated

    )c PDOs name

    )d Amount of charges for each Public Debt Office

    )e Total amount of charges for half year

    4. For the bill to be sent to the Finance Department, thefollowing data may be entered directly through a GUI:

    a) Scheme names

    b) End date for which charges are calculated

    c) Total amount of charges

    TCS RBI Confidential Page 19 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    20/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    d) PDO-wise break up of charges

    e) Letter number

    f) Letter date

    5. For the copy of the communication of PDO Delhi to the

    finance department to inform them about the debit done to the

    government account for the half-yearly handling charges, the following

    data may have to be entered by the user through a GUI screen:

    a) Date of communication

    b) Letter number of communication for finance department

    allowing debit of their account

    c) Date of communication for finance department allowing

    debit of their account

    d) Total amount of half yearly handling charges

    e) Letter number

    vi) Commission for 5.75 % Voluntary Deposit Scheme (1985):

    1. The letter sent every June and December end to all PDOs to send

    the number of repayments done during the half year for the scheme has text

    but has the letter number and date as relevant data and these can be entered

    into the system through a GUI.

    2. The data for VDS is not present in PDONDS currentlyProvision is to

    be provided to authorized PDO user to enter thenumber of repayments done

    during the half year through a GUI:a) Nomenclature of loan

    b) Number of bonds passed for repayment

    c) Total commission chargeable on the basis of Rs 100 per bond

    repaid.

    TCS RBI Confidential Page 20 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    21/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    d) Date

    3. If data is not migrated for the bill to be sent to the Finance Department and

    PDO then the following data may be entered directly through a GUI:

    a) Scheme names

    b) End date for which charges are calculated

    c) Total amount of charges

    d) PDOs wise break up of charges

    e) Letter number

    f)Letter date

    4. For the copy of the communication of PDO Delhi to the finance

    department to inform them about the debit done to the government account

    for the half-yearly handling charges, the following data may be entered by the

    user through a GUI screen:

    a) Date of communication

    b) Letter number of communication for finance department

    allowing debit of their account

    c) Date of communication for finance department allowingdebit of their account.

    d) Total amount of half yearly handling charges

    e) Letter number

    1.1.2 Prerequisites / Pre-conditionsThe following preconditions are to be met before the CDD system becomes

    operational.

    1. PDONDS does not contain the balances of the following loans.

    The details of the following loans need to be migrated into the system.

    T-Bill Data issued at PAD Kolkata and CAS needs to be migrated

    into PDONDS system.

    Perpetual loan data need to be manually entered into the system

    TCS RBI Confidential Page 21 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    22/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    1.1.3 Post Condition1. Rough register maintenance should be stopped, as data is there

    in PDONDS and it would be available to CDD user.

    2. Only one bill will be generated for management commission for

    Central Government Loans which will contains details of market loans

    and various schemes (such as ADC and VDS).

    2.4.1. Budget estimation

    Central Debt Divisions Budget estimation module must fulfill the following

    requirements:

    Item Functions Descriptions1.1 Revised estimation Query/add/change/delete commission

    calculation details

    1.2 Budget estimation Query/add/change/delete commissioncalculation details

    1.3 Management chargescalculation

    Query/add/change/delete managementcharges calculation details

    1.4 Search details ofconversion of specialsecurities into marketloans and Treasury bills

    Query/add/change/delete details of specialsecurities converted into market loans andTreasury bills

    For the Communication from the Budget Division, DEA and MOF in textual

    form along with the format in which data is expected from this Section, the

    schemes/segments covered are market loans (excluding MSS issues),

    special securities converted to market loans, special securities such as

    UTI, Nationalized bank, Oil bonds, FCI, IFCI, IIBI, Fertilizer bond. Special

    Securities needs to be identified by CDD system.

    1. For the Budget estimation reporting the following data is mainly required.

    Revised Estimate for the current year:

    a. Receipts

    b. Repayments

    c. Total Interest payable during the yearTCS RBI Confidential Page 22 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    23/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    Budget Estimate for the next year:

    a. Receipts

    b. Repayments

    c. Total Interest payable during the year

    2. CDD receives from IDMD estimated amount of the borrowing and coupon

    rate for the following year which forms the basis for calculation of receipts

    and Interest Liability for BE. Provision to be provided to CDD user to enter

    the details of Receipts for revised estimate reporting for the current year

    and receipts for budgeted estimate for the next year.

    3. For the budgeted estimate and revised estimate repayments and total

    interest payable during the year the calculation is to be automated in CDD

    module as all the data will be available in the CDD database.

    4. Provision to be provided to CDD user to generate report for GOI. The

    format will be similar to the existing format used by CDD user for

    reporting.

    5. The various reports which are to be generated at CDD and which acts as

    a base for preparation of BE and RE are mentioned below. The format of

    all the reports would be similar to existing format used by CDD.

    Annexure I

    Annexure I consists of the following details.

    Revised Estimate for the current year:a. Receipts

    b. Repayments

    c. Total Interest payable during the year

    Budget Estimate for the next year:

    TCS RBI Confidential Page 23 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    24/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    d. Receipts

    e. Repayments

    f. Total Interest payable during the year

    Summary of Worksheets (Annexure II to V)

    i. Current Market loan balance & Interest liability as on December 31 of

    current financial year (Annexure II) Value of the following fields are

    received from Annexure II

    a. Loan Balance

    b. Interest Liability - Current year (RE)

    c.Interest Liability- Next financial year (BE)

    ii. Current Floating rate bonds & Interest liability as on December 31 of

    current financial year (Annexure III) - Value of the following fields are

    received from Annexure III

    a. Loan Balance

    b. Interest Liability Current year (RE)

    c. Interest Liability Next financial year (BE)

    iii. Total current market loan balance & interest liability as on December

    31 of current financial year (Calculated by adding the values

    obtained in the above two step).

    a. Loan Balance

    b. Interest Liability Current year (RE)

    c. Interest Liability Next financial year (BE)

    iv. Interest on special securities converted into market loans (Annexure

    IV) Value of the following fields are received from Annexure IV

    a. Interest Liability Current year (RE)

    b. Interest Liability Next financial year (BE)

    TCS RBI Confidential Page 24 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    25/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    v. Interest on Securities issued under MSS (Annexure V) - Value of the

    following fields are received from Annexure V)

    a. Interest Liability Current year (RE)

    b. Interest Liability Next financial year (BE)

    vi. Add the figure obtained in steps iv and v and subtract it from the

    figure obtained in step iii to arrive at the given value

    a. Interest Liability Current year (RE)

    b. Interest Liability Next financial year (BE)

    vii. Provision to be provided to CDD user to enter the estimated interest

    liability on proposed issuance of loan during the quarter Jan-March of

    current financial year (Amount of loan to be floated to be entered by

    CDD user through a GUI. The following field is to be entered through

    a GUI.

    a. Interest Liability Current year (RE)

    b. Interest Liability Next financial year (BE)

    viii. Provision to be provided to CDD user to enter the estimated interest

    liability on proposed issuance of loan during the next financial year

    (Coupon rate and amount to be entered through a GUI). The

    following field is to be entered through a GUI.

    a. Interest Liability Next financial year (BE)

    Add the figures obtained in steps vii and viii with the figure obtained in step 6 toarrive at the estimated Interest Liability.

    Annexure II

    TCS RBI Confidential Page 25 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    26/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    i. Statement showing the balances of the central government loans as

    on December 31, of current year the following data can be picked up

    directly from PDONDS.

    a. Loan year wise maturity.

    b. Loan Balance.

    c. Rate of interest.

    d. Date-Month-year of issue.

    e. Year of maturity.

    f. Interest Liability (Current year)

    g. Financial year.

    h. Interest Liability (Next financial year)

    i. Total of Loan Balance

    Annexure III

    i. Statement showing Government of India floating rate bonds as on

    December 31 of current financial year. Rate of Interest will be

    automatically picked up from PDO-NDS system and will update the

    CDD system on a daily basis. The following data can be picked up

    directly from PDONDS.

    a. Loan year wise maturity.

    b. Loan Balance.

    c. Rate of interest.

    d. Date-Month-year of issue.

    e. Year of maturity.

    f. Interest Liability (Current year)

    g. Financial year.h. Interest Liability (Next financial year)

    i. Total of Loan Balance, Interest Liability (Current

    year), Interest Liability (Next financial year).

    TCS RBI Confidential Page 26 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    27/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    Annexure IV

    i. Statement showing the special securities converted into market loan

    as on December 31 of current financial year, the following data can

    be picked up directly from CDD database as all details pertaining to

    special securities will be stored at CDD database.

    a. Loan year wise maturity.

    b. Loan Balance.

    c. Rate of interest.

    d. Date-Month-year of issue.

    e. Year of maturity.

    f. Interest Liability (Current year)

    g. Financial year.

    h. Interest Liability (Next financial year)

    i. Total of Loan Balance Interest Liability (Current year),

    Interest Liability (Next financial year).

    6. Provision to be provided to CDD user to generate a report mentioning the

    premium amount / discounted amount and interest received for broken

    period for a particular financial year on loan issued (normal and MSS

    separately.

    7. For the communication from the IDMD/FMD regarding the new loans

    proposed to be floated during the next financial year, the following data

    maybe entered into the system through a GUI screen:

    a. Amount to be raised from dated securities (Normal and MSS

    separately).

    8. Management Charges:

    Management charges details will be captured from commission register

    (electronic format) which will be part of CDD module. For the estimation of

    TCS RBI Confidential Page 27 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    28/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    management commission reporting the various reports to send to GOI is

    mentioned below:

    Management charges for Central Government loans:

    I. ANNEX 1

    The following field is required for this report. The value of various field is

    calculated and will be captured from the other reports. The value of

    Management charges can be picked up from Annex II report. The value

    for Floatation charges can be picked up from Annex III report. The value

    for Relief / Savings bonds can be picked up from Annex IV reports. The

    following field is necessary for this report.

    i. Total amount of bills presented / paid upto September of

    current year

    1) Market Loans

    (a) Management Charges (Annex II)

    (b) Floatation Charges (Annex III)

    2) Relief / Saving Bonds (Annex IV)

    3) Total Amount (Rs.)

    ii. Total Amount of bills likely to be presented during the rest of

    the year i.e. October 2007 to March 2008

    1) Market Loans

    (a) Management Charges (Annex II)

    (b) Floatation Charges (Annex III)

    (2) Relief / Saving Bonds (Annex IV)

    (3) Total Amount (Rs.)

    iii. Anticipated expenditure during the next year 2008-2009

    1) Market Loans

    (a) Management Charges (Annex II)

    TCS RBI Confidential Page 28 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    29/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    (b) Floatation Charges (Annex III)

    2) Relief / Saving Bonds (Annex IV)

    3) Total Amount (Rs.)

    II. Annexure I

    Provision is to be provided to CDD user for generating report in the

    existing format used by CDD user for reporting to GOI. Actual bill till

    June of the current year will be available in CDD system.

    i. Total amount of bills presented / paid upto September of

    current year

    1) Market Loans

    (a) Management Charges (Annex II)

    ii. Total Amount of bills likely to be presented during the rest of

    the year i.e. October 2007 to March 2008

    1) Market Loans

    (a) Management Charges (Annex II)

    iii. Anticipated expenditure during the next year 2008-2009

    1) Market Loans

    (a) Management Charges (Annex II)

    III. Annexure II

    i. For the above report the following fields are required

    a. Total amount of bills presented / paid upto September of

    current year. The following figure can be picked up from CDDdatabase.

    1) Management Charges on Market Loans

    TCS RBI Confidential Page 29 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    30/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    b. Total Amount of bills likely to be presented during the rest of

    the year i.e. October 2007 up to March 2008 and settled in the

    financial year 2007-08. The below mentioned figure is to be

    calculated by CDD system.

    1) Management Charges on Market Loans

    c. Anticipated expenditure during the next year 2008-2009. The

    below mentioned figure is to be calculated by adding the figure

    obtained in steps a. and b. above and also adding the

    commission on estimated net central market borrowing for the

    next financial year. A GUI is to be provided to CDD user to

    enter the value for estimated net central market borrowing for

    the next financial year.

    1. Management Charges on Market Loans

    IV. The procedure for calculating the management charges is shown in

    another report. The report should be in the below mentioned format.

    The following field is required. The figure in row 1 can be obtained

    from PDONDS system, Provision is to be provided to CDD user to

    enter value in row 2 and 3. Value in row 4 is arrived by adding values

    obtained in row 1,2,3. Redemption details mentioned in row 6 can be

    obtained from PDONDS system. Provision to be provided to CDD

    user to enter the details of row 9. The grand total figure mentioned in

    row 10 can be arrived by adding the figures of row 8 and row 9.

    Estimated Management Charges December Current year

    Issuances Amount (incrore)

    1 Dated Securities (Normal & MSS) issuedduring the July September current year

    TCS RBI Confidential Page 30 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    31/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    2 Dated Securities (Normal) to be issuedduring the quarter October Decembercurrent year (as per Issuance Calendar)

    3 Dated Securities (MSS) to be issuedduring the quarter October Decembercurrent year

    4 TOTAL (a)

    5 Redemptions

    6 Dated Securities maturing duringJuly December current year

    7 Total (b)

    8 Net (a-b)9 Incremental increase in r/o T.Bill (MSS)

    10 Grand Total

    Note: The outstanding balances of T.Bills (Normal) as on December31, current year is assumed to be at the same level as on June 30,current year.

    Mgt. Charges @ Rs.2000/- per crore p.a on Rs. (Figure obtained inrow 10) crore = Rs._____ cr (claimed @ Rs.1000/- per crore in eachhalf year)

    Mgt. Charges for q.e. December current year = total amount of bill

    presented and paid upto September current year + management

    charges figure obtained above = ____ crore.

    Charges for Relief and Savings bonds

    V. ANNEXURE IV

    The following field is required for this report. The value of various fields is

    calculated and will be captured from the other reports. The value for Relief

    / Savings bonds can be picked up from Annex IV reports. The following

    field is necessary for this report.

    i. Total amount of bills presented / paid upto September of

    current year

    TCS RBI Confidential Page 31 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    32/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    ii. Total Amount of bills likely to be presented during the rest of

    the year.

    iii. Anticipated expenditure during the next year

    Annexure IV

    Workings of Management Expenses in respect of Relief / Savings Bonds

    (Rs. in crore)

    Sr.No.

    Particulars

    1. Total amount of billspresented and paid up to

    ________.

    i) For half yearended June 06 =

    2. Total amount of bills likely tobe presented up to March

    _____ and settled in thefinancial year _______

    i) For half yearended _____ = crore(For workings, pleaserefer @ below)

    3. Anticipated Expenses duringthe next financial year

    ________

    For two half years ended _______ and ________Rs. 00.00 crore #

    @ Estimation of bills for half-year ended _______________

    Progressive bal. of subs. of 8 % SB 2003 as on ___________ = Rs. __________

    Progressive bal. of subs. of 8 % SB 2003 as on ___________ = Rs. __________

    Subs. received during _____ months ended ______________ = Rs. __________

    Estimated subs. For __________ (1/5 of the above) = Rs. ____________

    Total estimated subs. for half year ended ___________ = Rs. ____________

    Total estimated charges Brokerage @ 1 % = Rs. _____________Commission @ 1/32 of 1 % = Rs._______________

    Service ch., Printing ch., Postage etc = Rs. _______________(Based on actual of previous half yearly charges) -------------------------Total estimated charges for h. y. ended Dec. 2006 =Rs ________________

    Rounded off to Rs. ________________

    TCS RBI Confidential Page 32 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    33/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    i. For calculating total amount of bills presented / paid upto

    particular month of current year, provision is to be provided to

    CAS and PDO user to enter the details through a GUI. Thetotal amount entered by various users is to be added at CDD

    system, which forms the basis for the input for total amount of

    bills, presented / paid upto particular month of current year.

    ii. For calculating Total Amount of Bills likely to be presented

    during the rest of the year provision is to be provided to CAS

    user to enter the following details

    1) Progressive bal. of subs. of 8 % SB 2003 as for given

    duration of particularyear

    Provision to be provided to CDD user to enter the following details

    2) Service charges., Printing charges., Postage etc (Based on

    actual of previous half yearly charges)

    This input will form the basis for calculation of Total Amount of Bills likely to be

    presented during the rest of the year

    iii. For calculating anticipated Expenses during the next financial

    year the value obtained in the steps i. and ii. is added.

    9. There will be no communication from Loan Section furnishing data in

    respect of management charges for Relief Bonds and Saving Bonds, to

    Account section. All data (calculated above) in respect of management

    charges for relief bonds and savings bonds will be available in CDDsystem and can be picked up from there for reporting to GOI, the following

    data can be picked up directly from the CDD database.:

    a. Total amount of bills presented /paid up till now

    TCS RBI Confidential Page 33 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    34/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    b. Total amount of bills likely to be presented during the

    rest of the year

    c. Anticipated Expenditure during the next year

    10. There will be no communication from Loan Section furnishing data in

    respect of floatation charges to Account section. All data (calculated

    above) in respect of floatation charges will be available in CDD system

    and can be picked up from there for reporting to GOI, the following data

    can be picked up directly from the CDD database.:

    a. Total amount of bills presented /paid up till now

    b. Total amount of bills likely to be presented during the

    rest of the year

    c. Anticipated Expenditure during the next year

    11. For the extract of the Receipt Budget (Receipt / Repayment / Interest

    Liability of GOI, the following data can be picked up directly from the

    PDONDS system:

    a. Nomenclature of the loans

    b. Date of maturity

    c. Outstanding balance at every year-end loan-wise.

    The actuals upto December can be obtained from PDO-NDS. Provision is

    to be provided to CDD user to enter following data may be calculated by

    the system based on the projections (entered as a parameter in the

    system), if the past data can be made available from the system:

    a. Revised Estimateb. Budget Estimate

    12. In case of fresh conversion, the following data can be picked up directly

    from the PDONDS system. The details of Special securities converted into

    TCS RBI Confidential Page 34 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    35/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    market loans is to be maintained at CDD system, which can be viewed by

    the user as and when required:

    a. Date of issue - issued in lieu of conversion/ re

    issued against buyback

    b. Nomenclature of the security

    c. Coupon rate

    d. Amount converted

    13. For the Analysis of the use of budgetary provision towards

    interest/repayment received from the Budget Division DEA, on the basis of

    the past data available in the system and the data input by the user, the

    following can be either directly picked up or calculated by the system:

    a. Nomenclature of the bonds

    b. Budget estimate for the year

    c. Total provision/final requirement

    d. Actual as per RBI

    e. Excess/Saving

    The following data maybe entered into the system through a GUI screen

    a. Actual as per CCA

    14. For the Information provided to DEAP relating to a maturity profile of the

    outstanding market loans - central and state governments till last year,

    year-wise for rupee loans, the following data may be directly picked up

    from the PDONDS system: (This report will be part of report module of

    CDD)

    a. Outstanding balance of undated loansb. Outstanding balance of loans maturing under 5

    years

    c. Outstanding balance of loans maturing

    between 5 and 10 years

    TCS RBI Confidential Page 35 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    36/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    d. Outstanding balance of loans maturing over 10

    years

    e. Outstanding balance of total loans maturing

    15. At the FR (Final requirement) stage which takes place mid of February.

    the following data can be picked up or calculated from the CDD system on

    the basis of a parameter (entered into the system):

    a. Original Budgeted estimate for

    the current year

    b. Final appropriation/revised

    estimate

    c. Actuals

    d. Variation between original and

    final appropriation, if any

    e. Variation between final

    appropriation and actual, if any

    16. For monitoring of budget provisions for the current year under the

    specified major heads - market loans, Securities issued to the RBI in

    conversion of Treasury Bills, CIB, Relief bonds, Savings bonds, Special

    bearer bonds, Special Securities, Bonds against IRAQ exports, Special

    Deposit Provident Superannuation, Special securities issued to UTI,

    Special securities issued to Nationalized Bank, Interest on deposit on NRI

    Bonds Scheme, Other Interest payment out of the data items which are

    received from CAS in the statement of consolidated statement of interest

    paid the items related to savings and relief bonds and T-Bills, thefollowing data can be picked up or calculated directly from the system:

    a. Total Interest paid

    b. Budgeted

    TCS RBI Confidential Page 36 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    37/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    c. Deviation (budgeted

    - actual)

    d. Actual paid as a %

    of budgeted

    For the rest of the items to be directly calculated, the migration of data

    relating to those will have to take place.

    17. For Saving Note Audit queries received from the DEA, MOF out of the

    following data which is given under Major heads, internal debt of the

    central government and external debt of the central government for

    individual loan types only for savings, relief bonds and T-Bills, the

    following data can be entered through a GUI screen:

    a. Total provision (original supplementary)

    b. Actual expenditure

    c. Savings

    d. Excess

    e. Total of total provision

    f. Total of actual expenditure

    g. Total of savings.

    h. Total of excess.

    18.For the communication in textual form the Department of Expenditure,

    MOF asking for reasons for variation in discount/interest between the

    actuals reported by RBI and CCA (F) scheme-wise, on the basis of the

    past data available in the system and the data input by the user, the

    following can be either directly picked up from CDD system provided thepast data of Budget estimation is migrated into CDD system or calculated

    by the system:

    a. Original (BE) Estimates

    b. Total provision/final requirement

    TCS RBI Confidential Page 37 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    38/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    c. Actual as per Reserve Bank of India

    d. Excess/Saving

    The following data maybe entered into the system through a GUI screen:

    a. Actual as per CCA

    19. For the provision of the following data to the IDMD to be sent

    subsequently to Planning Commission, it can be calculated or directly

    picked up from the PDONDS system: (This will be part of report module of

    CDD system)

    a. Loan year wise

    b. Opening Balance on the last day of the

    quarter

    c. Rate of Interest

    d. Date-Month-Year of Issue

    e. Year of maturity

    f. Financial year

    g. Interest Liability

    20.For the communication where reasons are given in textual form for

    variations in use of budgetary provisions, sent by Section to GOI on the

    basis of statements received from PDOs/PADs/IDMD, the letter number

    and letter date may be entered into the system through a GUI screen.

    21.For the communication where reasons are given in textual form for

    variations sent by Section to GOI on the basis of statements received from

    PDOs/PADs/IDMD for appropriation accounts, the letter number and letterdate may be entered into the system through a GUI screen.

    TCS RBI Confidential Page 38 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    39/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    22. For the communication for the saving note sent to the IDMD, for

    comments/suggestions which is in textual format, the letter number and

    letter date may be entered into the system through a GUI screen.

    23.For the communication to GOI regarding suggestions/comments for

    savings note in textual format, the letter number and letter date may be

    entered into the system through a GUI screen.

    24. For the Communication in textual form from this Section to the Budget

    Division, DEA, MOF providing suggestions for budget formulation process,

    the letter number and letter date may be entered into the system through a

    GUI screen.

    1.1.4 Prerequisites / Precondition

    PDONDS does not contain the balances of the following loans. The details of the

    following loans need to be migrated into the system.

    1. T-Bill Data issued at PAD Kolkata and CAS needs to be migrated into

    PDONDS system.

    2. The details of Special securities converted into market loans are to be

    maintained at CDD system, which can be viewed by the user as and when

    required.

    2.4.2. Write Off

    Central Debt Divisions Write off module must fulfill the following requirements:

    Item Functions Descriptions

    1.1 Write off of the maturedloans

    Query/add/change/delete write off registers

    1.2 Write off the currentunclaimed securities

    Query/add/change/delete write off registers

    1.3 Maintenance of write ofregister

    Query/add/change/delete write off registers

    1.4 Readmission of the Query/add/change/delete write off registers

    TCS RBI Confidential Page 39 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    40/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    written off loans

    A. Write off of the matured loans

    1) For preparing a statement at the beginning of the year, the following

    details can be directly picked up from the PDONDS system:

    a) Name of the Public Debt Office

    b) Nomenclature of the loan

    c) Balance Amount against loan Public Debt Office-wise

    d) Total amount

    e) Date of Issue loan-wise

    f) Date of maturity

    g) Due date of write off

    2) For maintenance of write-off register, it is not available in the system

    currently but the format can be provided. If it is to be included in the

    system, then the following details can be directly picked up from PDONDS

    system for it:

    a) Nomenclature of loanb) Due date for write off

    c) Total amount to be written off Public Debt Office-wise

    The following data may have to be entered through a GUI screen:

    a) Letter No. and the date of government concurrence

    b) Amount to be written off Public Debt Office wise

    c) Date of writing off Public Debt Office wise

    d) Detail of Public Debt Office form 131

    3. For the communication to receive the form 131 from PDOs, the

    following data can be picked up from the PDONDS system. The following

    TCS RBI Confidential Page 40 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    41/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    data pertaining to form 131 can be picked up from PDONDS. CDD can

    dispense with from 131:

    a) Nomenclature of the loan

    b) Break up of loan in the different holding type

    c) Outstanding amount

    d) Number of GP/Stock Certificate

    4. Communication received from the Public Debt Office that there is

    no claim existing against the balance is in a textual form. The letter

    number and date may be entered into the system through a GUI screen.

    5.Communication sent to the CCA/AG 1 month before the write off seeking

    their approval is in textual form. The letter number and date may be

    entered into the system through a GUI screen.

    6.For the communication to the CCA/AG to confirm the balance is in

    textual form, the letter number and date may be entered into the system

    through a GUI screen

    7.For the confirmation received from the CCA/AG for the proposed write

    off is in textual form, the letter number and date may be entered into the

    system through a GUI screen.

    8.For the textual communication sent to the Public Debt Office/PAD to

    furnish all the required details to the government concerned for enabling

    the reconciliation process, the letter number and date may be entered into

    the system through a GUI screen.

    9.For the copy of the note sent to the CCA/AG received from PDOs, the

    following data can be directly picked up from the PDONDS system . The

    communication / report can be transferred to the reporting server:

    TCS RBI Confidential Page 41 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    42/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    a) Nomenclature of the loan

    b) Date of writing off of the security

    c) Amount, with Public Debt Office, written off

    10. For the data sent to the government if there are any discrepancies

    found during re-conciliation, the following data can entered through a GUI

    screen. The communication / report can be transferred to the reporting

    server.

    a) Year

    b) Month

    c) Public Debt Office name

    d) Outstanding Amount

    11. For sending a note to the PDO Mumbai advising them to write off is in

    textual form, the letter number and date may be entered into the system

    through a GUI screen.

    B. Write off the current unclaimed securities

    1. For the PDOs sending a statement, the following details can be

    entered by authorized PDO user:

    a) Security No.

    b) Nomenclature of loan

    c) Amount

    2. For tracking and consolidating the receipts from all PDOs, the following

    data maintained by the Section can be entered by authorized PDO user:a) Public Debt Office name

    b) Current securities unclaimed for more than 20 years

    c) Amount

    TCS RBI Confidential Page 42 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    43/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    3. For the file maintained by the Section containing the consolidated

    positions, the following data can be entered by authorized PDO user:

    a) Security No.

    b) Nomenclature of loan

    c) Amount

    d) Total amount

    4. For sending the textual communication to the Public Debt Office on

    receipt of the statement, the letter number and date may be entered into

    the system through a GUI screen.

    5. Communication sent to the government to approve the write-off is in

    textual form. The letter number and date may be entered into the system

    through a GUI screen.The communication / report can be transferred to

    the reporting server. Communication is also to be sent for publication in

    the gazette.

    6. The communication received from the Government to approve write-off

    is in text format, so the letter number and date may be entered into the

    system through a GUI screen.

    7. For sending the textual communication to the PDO Mumbai to carry

    out the write off, the letter number and date may be entered into the

    system through a GUI screen.

    8. The confirmation received from PDO Mumbai for write off is in textual

    format, so the letter number and date and amount may be entered into the

    system through a GUI screen. If the data will be available in PDO-NDS

    than it can be captured from there.

    TCS RBI Confidential Page 43 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    44/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    9. The details to be entered into the write-off register have the following

    data that can be picked up from the PDONDS system:

    a) Amount written off Public Debt Office-wise

    b) Date of writing off Public Debt Office-wise

    The following details may be entered through a GUI screen

    a)Details of Public Debt Office form 131

    C. Re-admission of written off securities:

    1. Provision to be provided to PDO user to enter the following details

    pertaining to Readmission of written of securities. Validation of written of

    amount is to be done in CDD module. These details will be captured in

    write-off register:

    a. Nomenclature of loan.

    b. Amount.

    c. Letter number authorizing re-

    admission.

    d. Date of letter authorizing re-

    admission.

    e. Re-admission date.

    2. Data relating to state compensation bond is to be incorporated in

    the quarterly statements to various governments. Provision is to be

    provided to PDOs to enter the details of compensation bonds through a

    GUI.

    1.1.5 Post conditions

    1. CDD can dispense with PDO-131 as data pertaining to this is already

    captured in PDO-NDS mainframes

    TCS RBI Confidential Page 44 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    45/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    Miscellaneous Activities

    Other activities carried out by the Accounts module of CDD system are as

    follows:

    1.2 Activities related to compensation bonds:

    1) CDD receives form PDO 273 from the PDOs every monthly and record the

    opening balance, bonds issued (number and amount), bonds cancelled

    (number and amount) and amount of principal reduced on account of

    payment and closing balance in the register maintained for the purpose.

    Provision to be given to PDOs to enter the details of form PDO 273. The

    details of form PDO 273 is to be entered manually by authorized PublicDebt Office user through a GUI. The detail of Public Debt Office 273 is to

    be stored in CDD database and authorized CDD user can view the details

    in the report format. PDOs should be able to print the report as a copy of

    the same has to be forwarded to AG & Secretary (State Government). The

    following field is to be captured.

    a. Date

    b. Opening Balance

    c. Number of Bonds issued

    d. Bonds Issued Amount

    e. Number of Bonds Cancelled

    f. Bonds Cancelled Amount

    g. Principal Amount Reduced on account of payment of installment.

    h. Closing Balance

    i. Progressive Figures of Bonds Issued and cancelled so far

    i. No. Of Bonds issued

    ii. Bonds Issued Amount

    iii. Number of Bonds Cancelled

    iv. Bonds Cancelled Amount

    TCS RBI Confidential Page 45 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    46/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    v. Principal Amount Reduced

    2) The Section record data annually (previously it was quarterly) on the

    expenditure incurred with respect to the issue and management of

    compensation bonds, details of which are entered in the register

    maintained for the purpose of tracking. The new rate structure for

    management charges for compensation bonds which is applicable from

    1st January 2008 is mentioned below

    PARTICULARS RATE

    REPAYMENT RS. 10/- FOR EVERY BOND REPAID.OUTSTANDING

    BONDS

    RS. 10/- FOR EVERY BOND OUTSTANDING

    AS ON JUNE 30, SUBJECT TO A MINIMUM

    AMOUNT OF RS. 10,000/- PER ANNUM.NEW ISSUE THE BANK RESERVES THE RIGHT TO

    SPECIFY BOND ISSUANCE CHARGES

    DEPENDING UPON THE VOLUME OF NEW

    ISSUANCE.

    PDOs should have the option to capture the details for multiple bonds as

    some states have issued multiple compensation bond. Provision is to be

    given to PDOs to enter the details of Issue and management charges of

    compensation bonds through a GUI. The detail of Issue and management

    charges of compensation bonds is to be entered manually by authorized

    Public Debt Office user. The detail of Issue and management charges of

    compensation bonds is to be stored in CDD database and the CDD user cansee the details in the report format. The reference number and date should be

    standardized so that it should be uniquely identified. The following field is to

    be captured.

    TCS RBI Confidential Page 46 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    47/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    a. Instrument Nomenclature

    b. Date

    c. Reference Number and Date

    d. Amount Claimed

    e. Total amount claimed

    f. Amount reimbursed

    g. Total amount pending

    h. Reference number and date of advice

    i. Remarks

    3) Receives information from the PDOs half yearly (March and September)

    regarding the number of indents raised, number of bonds issued and

    amount. This information is recorded in the rough register maintained for

    the purpose. Provision to be given to PDOs to enter the details of indents

    raised, number of bonds issued and amount through a GUI. The detail is

    to be entered manually by authorized Public Debt Office user. The detail

    of indents raised / disposed, number of bonds issued and amount is to be

    stored in CDD database and the CDD user can view the details in the

    report format. The following field is to be captured.

    a. Date

    b. By Balance as on

    i. No. Of Indents

    ii. No. Of Bonds covered by indents

    iii. Amount of Bonds

    c. Receipt (To balance as on, new indents received wise)i. No. Of Indents

    ii. No. Of Bonds Required to be Issued

    iii. Amount of Bonds

    TCS RBI Confidential Page 47 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    48/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    d. Disposal (By bonds issued and dispatched, By indents returned

    under objection wise)

    i. No. Of Indents

    ii. No. Of Bonds covered by indents

    iii. Amount of Bonds

    e. Progressive Figures of Bonds Issued and Dispatched so far

    vi. No. Of Indents

    vii. No. Of Bonds covered by indents

    viii. Amount of Bonds

    4) The Section receives Notification from the State Governments, which it

    uses for reference as and when necessary. The notification would be part

    of generic Document Management module. No register is being

    maintained currently by the Section for tracking the Notifications so

    received. This results in extensive search when references to Notifications

    become inevitable. An on-online tracking system wherein not only the

    Notification details and but also the file wherein it is kept can be stored

    along with summary details of periodical amendments, will facilitate quick

    retrieval as a search operation could be provided using which the user can

    search the database for a Notification on various parameters i.e.

    Notification number, Notification date, Notification month, Notification year,

    Notification subject, etc. This can be achieved by a suitable document

    management system also.

    1.3 Report on Audit of Paid Vouchers:

    1) The Section receives half yearly - June and December end - a statement

    in PDO Form 218 on the audit of paid vouchers from all the PDOs. The

    paid vouchers relating to interest / installment payments made at the

    treasuries, branches of State Bank of India and Associate Banks in regard

    TCS RBI Confidential Page 48 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    49/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    to various State / Central Government market loans are received by the

    PDO via Audit Offices i.e. the respective Accountant General in case of

    State Government loans and the Pay & Account Officer, MOF in case of

    Central Government loans. This is used by the PDO to mark-off in their

    books and the loan balance (debt liability) with respect to the respective

    State Governments & Central Government is reduced. The Section on

    receiving the statement makes entry into the register maintained for

    tracking the same. The Section also keeps a track on the number of

    irregularities occurred and issues letters to the PDO asking for the action

    taken report in regard to the matter from time to time. Provision to be

    given to PDOs to enter the details of the statement on the audit of paid

    vouchers through a GUI. The detail is to be entered manually by

    authorized Public Debt Office user. The detail of the audit of paid vouchers

    is to be stored in CDD database and the CDD user can view the details in

    the report format. The Screen design should be similar to PDO-218. The

    following field is to be captured.

    a. Name of the Accountant General

    b. Total number of vouchers received during the half year (as per

    covering schedules received from the concerned authority.

    c. Name of Public Debt Office

    d. Date of Letter

    e. Balance of vouchers of the previous half year

    I. To be posted

    II. To be checked

    f. Total number of vouchers forI. Posting

    II. Checking

    g. Work done during the half-year

    I. Posted

    TCS RBI Confidential Page 49 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    50/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    II. checked

    h. Arrears of work to be done at the end of the half year

    I. To be posted

    II. To be checked

    i. Remarks (indicate the half year upto which work is complete)

    In case of Details of irregularities in case of paid vouchers detected and recorded

    by the Public Debt Office the following field needs to be captured.

    j. Nature of irregularity

    k. No. of irregularities outstanding as at the beginning of the half year

    l. No. of irregularities detected during the half year

    m. No. of irregularities settled during the half year

    I. of previous half year

    II. of this half year

    n. No. or irregularities outstanding

    I. of previous half year

    II. of this half year

    o. Remarks

    In case of Details of paid interest vouchers returned to treasury officers for

    reconciliation of discrepancies.

    p. Total no of vouchers

    q. No. of vouchers sent by ordinary post

    r. No. of vouchers sent by registered posts. No. of vouchers sent lost through post

    t. Remarks

    TCS RBI Confidential Page 50 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    51/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    1.3.1 Historical data maintenanceThe data regarding to few other bonds and few pre independence securities will

    be maintained as historical data.

    Other Bonds:There were certain bonds, which were issued and serviced in the past by RBI on

    behalf of the GOI. These bonds were issued for meeting certain specified

    objectives of the GOI at the material time and all the schemes under which these

    bonds were issued have since been closed and the bonds matured long back.

    However, some balances in respect of some of these bonds are reported to be

    still outstanding and hence the proposal to include these in the computerized

    system being contemplated for processing the sections activities.

    Following details of will be entered for the bonds that are not present in the

    PDONDS system.

    1. Nomenclature

    2. New Issues

    3. Repayment

    4. Closing Balance

    5. ISIN No

    6. Loan code

    7. Date of Issue

    8. Date of Interest payment

    The transactional data processing like new issues, repayments pertaining to the

    bonds will be provided to the CDD and PDOs users under the Historical data

    maintenance module.

    Indo Pak securities and Securities whose balances are held at SBI -London:

    These Indo Pakistan securities and the securities whose balances held at SBI London are given below:

    TCS RBI Confidential Page 51 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    52/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    1. 3% Loan 1896 972. 3% Conversion Loan 1946

    The above securities data is not present in the PDONDS system. Provision will

    be made in the CDD system for the PDO users (PDO Calcutta, PDO Mumbai) toenter the details of the securities along with their balances.

    PDO users will be given the provision to enter the balances held at Pakistan and

    SBI London (obtained from PDO Calcutta)

    Following details will be entered for these securities that are not present in the

    PDONDS system.

    1. Nomenclature

    2. New Issues

    3. Repayment

    4. Closing Balance

    5. ISIN No

    6. Loan code

    7. Date of Issue

    8. Date of Interestpayment

    The transactional data processing like new issues, repayments pertaining to the

    securities will be provided to the CDD and PDOs users under the Historical data

    maintenance module.

    TCS RBI Confidential Page 52 of 53

  • 8/6/2019 Functional Specification - Accounts - Version 1 0 -June 25-6-2008

    53/53

    CDD Computerization Project Functional Specifications

    Central Debt Division Version 1.0

    APPENDIX I: ACRONYMS AND ABBREVIATION

    The following table lists the acronyms and abbreviations used in this document.

    Abbreviations Description

    CDD Central Debt Division

    CCIL Clearing Corporation of India Limited

    CDBMS Central Database Management System

    CGSEC Central Government Securities

    DGBA Department of Governments and Bank

    Accounts

    DIT Department of Information Technology

    IDMD Internal Debt Management Department

    NDS Negotiated Dealing System

    PDO Public Debt OfficesSG SEC State Government Securities

    SGL Subsidiary General Ledger

    IT Information Technology

    MVC Model-View-Controller

    J2EE Java 2 Enterprise Edition