New Data Extraction Tool

1. New Data Extraction Tool

2. DATA FROM POST OFFICE DATA BASE AND WEB-ENTERED DATA IS USED TO CREATE A KPI-BASED PERFORMANCE DASHBOARD 2 Example Data Data extracted from PO • Details of Regd articles • Details of Speed Post articles • Details of eMO • Details of SB accounts • Details of Financial variables 1 Data Repository Meghdoot 100% = all data required for KPIs Sanchay Post Reporting Engine Operational dashboard reports 93% 3 100% Data manually entered through web based system Example Data 07% • Number of Ord articles received • Number of Ord articles not delivered • Data repository would store data collected from individual PO Online web-based tool 2

3. Flow of flat files in the system. • Transmission of files from Post Office server to NIC server is fully automated. • Server at PTC Mysore receives flat files from Post Office server 24 hrs • Server at PTC Mysore pushes files to NIC server every 30 minutes from 0430 hrs to 2359 hrs • NIC server updates files four time a day- • 6:00 am, 11:00 am,3:00 pm and 8:30 pm

4. Captures data from the Post Office server for 78 fields Captures data for KPIs for Mail, Savings Bank and Accounts Captures data from Point of Sale, Postman, Treasury modules of Meghdoot Captures data from Sanchay Post database Proper functioning of tool requires Meghdoot 6.6, Sanchay Post 6.5, Speed Net3.1.1 all connected through LAN

5. New DET- Field Details - Meghdoot • 1 Mail in Deposit(Speed Post) • 2 Mail received today(Speed Post) • 3 Mail Issued to Postman out of fresh receipt(Speed Post) • 4 Total Mail Issued to Postman(speed post) • 5 Mail brought back for deposit(Speed Post) • 6 Mail in Deposit (Regd. Post) • 7 Mail received today(Regd. Post) • 8 Mail Issued to Postman out of fresh receipt(Regd .Post) • 9 Total Mail Issued to Postman(Regd. Post) • 10 Mail brought back for deposit (Regd Post) • 11 Count of electronic account for SB • 12 Count of electronic account for RD • 13 Count of electronic account for MIS • 14 Count of electronic account for SB • 14b Count of electronic account other than SB • 15 Count of requests for Account Closure, not actioned • 16 Count of Request for account transfer , not actioned • 17 Average time between Account Closure Request and today(for all open account closure request) • 18 Average time between account transfer request and today(for all open account transfer requests) • 19 Number of banking transaction (sum across all services) for the day

6. 20 Cash balance at end of day • 21 Average time between cash withdrawal request and today(for all open transfer request) • 22 Average time between MO received in a PO and MO delivered as of today(for all open MO) • 23 MO in Deposit • 24 MO received today • 25 MOs Issued to Postman out of fresh receipt • 26 Total MOs Issued to Postman • 27 MO brought back for deposit • 28 eMOs in Deposit • 29 eMOs received today • 30 eMOs Issued to Postman out of fresh receipt • 31 Total eMOs issued to Postman • 32 eMOs brought back for deposit • 33 Number of all transaction for MPCM counters • 34 Sum of all transaction for SB counters • 35 Avg. transaction time for SB counter • 36 Max transaction time for SB counter • 37 Min transaction time for SB counter • 38 Postage realized in Cash in a day • 39 MO Commission received in a day • 40 Indian Postal Order Commission in a day • 41 PLI and RPLI premium collection

7. 42 Maximum age of Account Closure request • 43 Maximum age of Account transfer request • 44 Max time between MO received and paid • 45 Total number of scanned SB accounts in the database • 46 Total number of scanned RD accounts in the database • 47 Total number of scanned MIS accounts in the database • 48 Total number of scanned NSS accounts in the database • 49 Total number of scanned accounts in the database(SCS,TD,PPF) • 50 Mail in Deposit(Regd Parcel Post) • 51 Mail received today(Regd Parcel Post) • 52 Mail Issued to Postman out of fresh receipt(Regd Parcel Post) • 53 Total Mail Issued to postman(Regd Parcel Post) • 54 Mail Brought back for deposit(Regd Parcel Post) • 55 Number of MOs Booked • 56 Number of VPMOs booked • 57 Number of eMOs booked • 58 Missent Speed Post Articles Received • 59 Missent Regd Letters Received • 60 Missent Money Orders Received • 61 Missent eMOs Received • 62 Missent Regd Parcels Received

8. New DET- Field Details - Meghdoot • 63 Regd Letters Booked • 64 Regd Letters Despatched • 65 Regd Parcels Booked • 66 Regd Parcels Despatched • 67 Speed Post Articles Booked • 68 BNPL/Bulk Speed Post Articles Booked • 69 Speed Post Articles Despatched • 70 Express Parcel Post Articles Booked • 71 Express Parcel Post Articles Despatched • 72 Prefixed Postage Revenue • 73 eMO commission • 74 Maximum time at which last postman submitted returns • 75 Maximum time at which last postman received cash • 76 ePayment Commission • 77 Postage stamp sales revenue • 78 Publication sale

9. KPIs and Scoring Logic • DET measures performance on 19 KPIs • Performance of each office/circle is measured on a scale of 0 to 100. • Marks are reduced for each KPI if the performance falls below the target value

10. KPIs and scoring logic

11. KPIs and Scoring Logic

12. Reports by New DET

13. Reports by New DET- Circle Extracted Data • Reflects data for all 78 fields for all or Phasewise Post Offices of Circles • Helpful to extract raw data for analysis

14. Reports by New DET- PO Summary • Reflects data for Post Offices in single sheet • Helpful for circle programme office to compare Post Offices

15. Reports by New DET – Mail delivery report • Reflects mail KPIs- Mail not sent and Mail not delivered for all Post Offices in circles

16. Reports by New DET – Mail dispatch

17. Reports by New DET – Mail dispatch Helpful for circle programme office to track the transmission of New DET files by Project Arrow Offices

18. Reports by New DET – Log Details

19. FAQs Q-What is the role of Day End in generation of flat file by New DET tool ? What is the Proper sequencing of Day End in Meghdoot for generation of flat file ? If day end does not take place properly then statistical data will not get updated. There is no requirement for following any sequence. DET should be executed after day end in all modules. Q-If my Office does Day End in one module, next day, will New DET generate the flat file for the previous day? Day End has to be done on the same day. If it has not happened, DET file will not get generated. Q-What is the correct sequencing of running various communication module for generation of flat files ? For DET flat file generation, running Meghdoot Accounts MIS Client will suffice. No need for any other communication module.

20. Q - My office is regularly sending data on Speednet and the same is reflected in SpeedNet MIS but in DET reports, the Speed Post dispatched is nil. What are the possible reasons for this variation?  There are two possible reasons for this: • SpeedNet and Meghdoot are functioning on the same server and SpeedNet despatch data is fed in despatch module instead of SpeedNet application • Speednet and Meghdoot are functioning on different servers and they are not on LAN. Q- My treasury closes at 0830 PM but my night counter closes at 2300 hrs. How the flat file for this tool will be generated. • As the statistical data is updated at the time of day end, Accounts MIS client should be executed after 2300 hours in all such cases. Accounts MIS client application can be scheduled to execute automatically.

21. Q- When I try to send the DET file the system generates the following error” Accounts MIS error in registering channel. The channel http is already registered.”   • By restarting the machine, and using the option “Transmit pending files”, the problem will get resolved . Q- When I send the DET file, the system generates the message “The data has been successfully Transferred to the central server. But when I check the accounts MIS server my office file is shown as Not Received. • There can be two reasons • Pin code and ND code configured at client are not matching with the central server values • Without actually generating the file, if “Transmit pending files” option is used then also it will show this message. • If the case is not falling in the above two possibilities, send the data folder of your office to PTC Mysore for resolving the issue. It has to be checked that no files are existing in Data folder.

22. Q- When I use DET, “Accounts MISCommn-sendData1A: Error in Transmitting file in files txd” message is appearing. • Check for a file with name trxcheck.log in the data folder/ Log folder and delete that file. Then use the option, “Transmit pending files” to transmit the files. Q- The system generates the ODBL error • This may be due to incorrect up gradation of an existing required table. By sending a mail to ptcdesk@gmail.com, this script can be obtained and on execution, from the date of execution, the problem will get solved. • It has to be noted that, an error which appeared on a previous day relating to Day end in any of the module cannot be resolved by applying a solution on the next day. Hence proper care has to be taken in doing day end of all modules on the same day. There is a practice in some of the offices to take shift report the next day (especially in Sanchay Post), this has to stopped.

23. Q- My office is using the despatch module but despatch figures are not reflected on New DET Sequencing of operations has to be done as follows: 1. SpeedNet despatch /delivery has to be finished first 2. Postman and despatch module day end has to be done next. 3. Point of Sale Day end has to be done last. Q- Signature scan data for Savings bank is not coming consistently on New DET • For Sanchay Post, old client interface package has to be deleted and must not be executed. Execution of that package makes the signature scanning data as NA. A detailed FAQ on this information is put up in SBLAN web page.

24. Proposed modifications in New DET • Details of local articles ( Speed Post, Registered letter, Registered Parcels and EEP) booked by offices • Details of NSC and KCP issued by offices • Details of NSC,KVP and IVP discharged by offices

25. THANK YOU