Showing posts with label AIMS : Accounting Information Management System. Show all posts
Showing posts with label AIMS : Accounting Information Management System. Show all posts

CIPS : Centralize Integrated Payment Solution

Centralized Integrated payment Solution is developed by CRIS as part of IPAS. It is just like On-Line payment. It facilitates secured payment to railway customers as well as employees. It has been rolled out on 06-09-2019 under railway board letter reference 2018/ACII/9/5 dated 05-09-2019. 

Features:
  • It captures digital signature of officers for payment files.
  • Automatically & securely transfer payment files to SBI server through SFTP (Secured File Transfer Protocol). 
  • SBI system, after digitally verification of payment files, processes payment. 
  • After receiving digital E-Scroll, payment file is being updated in IPAS for reconciliation. 
  • NEFT/RTGS/STEP (Core Banking) payment can be processed through CIPS.
Working Process:
  • IPAS has provided facilities to register Digital Signature Certificate (DSC) (having document signing facility). 1st signatory must be gazetted officer and second signatory will be gazetted officer or Senior section officer (for small unit where only one accounts officer). But for SSO as a signing authority, name of SSO must be approved by PFA. After successful registration, DSC code is being updated in SBI file by a process initiated by CRIS.
  • Once abstract is prepared, it is being confirmed by Books SSO. After confirmation, abstract is being auto forwarded to 1st signatory for other then cash/DD payment.
  • 1st signatory will sign on the text file and mandate file first. After that, abstract is being auto forwarded to 2nd signatory. 2nd signatory will sign on the text file and mandate file.
  • During signing process it must be ensured that DSC token is attached with the system and CrisSigner is running. It is also to ensure that Digital Signature Certificate (DSC) has sufficient validity. Digital Certificates need to be procured well in advance before it is expired. 
  • After completion of signing process, books section should verify mandate and zip text file. After confirming green sign for both the signatory, BOOKS SSO will forward zipped file (containing digitally signed Mandate, Payment file in Text format & 2 signature files) to bank for further process for payment. 
  • To view Mandate file, it must be ensured that Adobe Acrobat Reader is installed on the computer.
  • After Zip file is received by bank, it is being verified by bank for following: i. Text file is in proper structure.
    ii. Text file is not tampered.
    iii. Text file is signed by authorized signatories.
  • The verified text file is then sent by SBI to its CORE Banking System, where it is processed for payment to beneficiaries. 
  • After payment is made to beneficiaries, debit scroll is sent by SBI to IPAS on T+1 (working) day. Scrolls data, sent by CMP Hyderabad, is captured in IPAS along with UTR number and settlement date for each transaction and reconciliation statements are shown to the concerned Accounting Unit. 
  • It may happen that a transaction is shown “Unpaid” even after initially it was shown as successful in its scroll. All unpaid transactions are shown in Exception Report. Headquarter of each zonal railway can view the payment status/reconciliation statement of all of its unit. Similarly, Railway Board can view status of IR level.
  • Cash/DD payment can be submitted to bank by manual cheque signing process.
Benefits :
  • This eliminated presentation of physical cheque and manual intervention to transfer beneficiary data through CD/mail. 
  • It is a faster and secure way of payment.
  • Reconciliation of transactions is made automatically by the system. 
  • It will eliminate manual cheque reconciliation.
  • Day wise reconciliation.
  • Abstract wise reconciliation.
In case of any issue related to payment/signatures/scroll, the escalation matrix is as under (As provided by CRIS):
  • L1 Support:- email id: newportalsupport@sbi.co.in 
    • Chandu kumar–9952966298 
    • Shravani Narahari–40-23466591 
    • Sh. G. Kishore-7680073952 
  • L2 Support:- email id: L2support.cmp@sbi.co.in 
    • Damodar–9884816464 
    • Rajesh Sharma-7666017773

                                                                                                                                                                                                     Source : AIMS

IPAS : Integrated Payroll and Accounting System

IPAS is the integration of Railway Payroll and Railway Accounts. This application software has been developed by CRIS on web based 3-tier centralized architecture using Java and Oracle. It brings a common application to all Railways on a centralized platform so that similar processes are followed across Railways in terms of accounting practices. A key benefit of such centralization would be faster change management and integration of effort along with automation of processes. 

IPAS application is undergoing a continuous up-gradation exercise to achieve better efficiency, security and safety. IPAS will provide real time access to financial transaction data across IR and will also bring financial and fiscal discipline. Although core design of IPAS application is same as design of PRIME/AFRES.

It includes the following modules:

Personal Department Module :
  • Payroll
  • Cadre
  • Electricity
  • Quarter
  • Loan
  • Cadre Management

Executive Department Module:
  • Executive Bill

Accounts Department Module:
  • Bill Passing (Older name Internal Check)
  • PF
  • NPS
  • Pension
  • Books
  • Budget
  • Cash MCR
  • Cash CRN
  • E-Suspense
  • G-Suspense (Deposits)
  • Pay
  • Stores Accounts

Advantages of IPAS:

Technology Level

  • Centralized Architecture.
  • Web based Application. It doesn’t require any client software on end-users’ PCs. 
  • Designed and developed using state of the art open Java technology. As the programs are developed in Java, it can run on any Operating System, any Application Server (i.e. of any company product) and any hardware. 
  • Java is futuristic technology specially designed for web based application as compared to existing Oracle Forms based technology of PRIME/AFRES which has become obsolete. 
  • High Availability (24*7) as all the servers have been clustered to run in fail-over mode. 
  • Centralized maintenance and management of Infrastructure (Application Software, Hardware & Systems Software). 
  • Disaster Recovery. Being Centralized Architecture, it is easy to replicate data as well as switching of sites from Data Center (DC) to Disaster Recovery (DR) and vice versa.
Security Level

  • Secured Socket Layer (SSL) software has been enabled to encrypt the data so that any transaction of IPAS including passwords of users can not be hacked by hackers. 
  • Role based access to the end users which can be administered by Administrators nominated at each unit. Provision for security of each screen/report is available in IPAS. 
  • Audit trails to monitor the changes made by any user including Administrators. 
  • Credentials of users are stored in encrypted way, which can not be decrypted by any algorithm.
  • Mobile based OTP facility has been provided to restrict unauthorized user access. 
  • No access of database has been given to anyone for security reasons. For running adhoc queries, a utility has been provided by CRIS to extract the data, as per requirement, by writing Oracle SQL queries.
Trust Level

  • IPAS has been developed entirely In-house by CRIS using its own team of software professionals. Similar to other IR Application such as PRS, FOIS, UTS, CMS, COA etc, the complete knowledge base of the application is with CRIS and in any case, Railways need not be dependent upon outside IT companies for the Software Maintenance.  
  • Source code of IPAS is the property of Railways and therefore in long run, there is no issue of Intellectual Property Right (IPR).
Database level

  • PRIME and AFRES databases have been merged into single database and all the redundant tables have been dropped. 
  • Few tables have been merged for storing similar data (e.g. Tables for Current & continuous Allowances/Recoveries) 
  • Processes written in Pro*C (e.g. Salary Processing, Income Tax etc.) have been converted into Oracle Stored Procedure for performance enhancement.
Application Level

  • Inter-related data capturing screens have been merged into single screen to reduce navigations. (eg. GIS/PF/Gratuity have been given through single screen; change card entries have been merged into single screen). This makes the work easier for the bill clerks. 
  • No Pay Rates form for entry of Basic Pay, DA, HRA and Transport Allow. While processing of salary, data for Basic Pay, HRA, and Transport Allowance are fetched from Employees’ Bio-data. iii) Steps for salary processing have been merged to reduce the work of end-users. 
  • The salary and income tax processing to be done by respective bill clerks. 
  • Salary Bill passing screen has enriched functionality now. The screen compares allowances/recoveries/allocations with that of previous month for individual employee to check. In addition, variations are shown in red colour. Moreover, the user has been provided all the information required for passing the salary bill.
  • Format of Numbers like CO6, CO7, PPO have been changed to maintain uniqueness at Zone/IR level. 
  • All the interrelated modules are integrated. PF deductions/Loan recoveries through regular/ supplementary salary are credited in the employee's respective ledger as soon as abstract is prepared. PF withdrawals are also automatically debited along with automatic start of recovery from next month. Deposit of PF through MCR is linked with PF module. Cash authorisation under Budget Module is linked with Internal Check. Bill passing has been linked with Agreement.
  • Where-ever possible, data during entry has been validated as per extant rules e.g. Nursing Allowances can be given to Nursing category only. 
  • No duplication of PF data between Personnel and Accounts department. PF application can be processed on-line by Personnel department. 
  • Posting of Transfer inwards and outwards (Divisional) for maintenance of transfer inwards and outwards (divisional) does not require any separate transaction. The issuing division changes Bill unit only as and when any employee transferred and the receiving units get the data automatically and they need to confirm the data by entering JV number. This is secure data with in-built checks and least manual intervention.
Interface with Other Applications

  • IPAS has integration with Integrated Material Management System (IMMS). As both the systems are interfaced, Stores bills are passed through IMMS and the cheques are issued through IPAS. 
  • Design of Works Register is compatible with IRPSM (Indian Railways Projects Sanctions and Management). Similarly, Budget Outlay allotted through IRPSM will be linked to Works Register. 
  • Design of Budget Module is compatible with RBCS (Rail Budget Compilation System) of Budget Directorate. IPAS in Centralized architecture, RBCS can be linked with Budget Module of IPAS for August Review, RE/BE & FM. Similarly, Budget allotted under Revenue Demands through RBCS will be linked to Budget Module. 
  • IPAS is integrated with Crew Management System (CMS) for allowances of running staff. All the above applications have been designed, developed and implemented on centralized architecture by CRIS and are hosted in CRIS Data Centre. 
  • IPAS is also integrated with IREPS (Indian Railway Electronic Procurement System) and GeM (Government E-Market Place) portal for seamless flow of data for payment to vendors without manual intervention.
Other:

  • As application is based on Centralized Architecture, Real Time Information of IR level can be provided to Board. 
  • Being a uniform application similar to any other IR applications (eg PRS, FOIS etc.), all the business rules and report formats are uniform over IR. Compliance of any rules/circular of Board (such as DA Arrear, Bonus etc.) can be made speedily. 
  • Easy monitoring and control over expenditure by Board in line with PRS/FOIS. 
  • Transfer of employees from one unit to another would not require physical movement of his service data (service card, LPC, leave etc) and financial data (PF, loans etc) in order to enable the new unit to access his data. Mere change of Bill Unit of the employee would enable the new Unit to access his entire data viz. PF, Loans, leave, service details etc. before the physical communication is made. There is no need for fresh entry of data by the new unit for previous months. 

AIMS : Accounting Information Management System

AIMS is the revolution in Indian Railway Accounts department. This is the first step towards switching from Government accounting system to Commercial accounting system. Various software are under development. Since railway has there own IT department, software development has been with CRIS (Center For Railway Information System : PSU under control of Railway Board). 

Followings are the few software examples under AIMS:

IPAS : Integrated Payroll and Accounting System.
WAMS : Workshop Accounts Management System.
TAMS : Traffic Accounts Management System.
HRMS : Human Resource Management System.
CIPS : Centralized Integrated Payment Solution.
ARMS : Accounting Reform Management System.
PFMS : Public Finance Management System.