Saturday, December 19, 2015

Postings on promotions/transfers of Private Secretary

Download Original Order Copy from India Post Official Site

New Point of Sale 7.9.4 for McCamish Migrated Offices

Point of Sale 7.9.4 Available for McCamish migrated Offices

Separate Point Of Sale exe is provided for McCamish rolled out offices where PLI transactions will not be available.
MM 7.9.4 Point of Sale - for McCamish Migrated offices is also available in the below link.

Update of IT Modernisation Project in DoP - Nov 2015


The latest position of implementation is as follows: 

  1. Primary Data Centre has started functioning at Navi Mumbai since 3rd April, 2013. Disaster Recovery Centre has been powered on at Mysore on 15-05-15. 
  2. 27702 Departmental Post offices including mail offices and administrative offices have been networked at single Wide Area Network (WAN) and connected to Data Centre. 
  3. Core Banking Solution (CBS) has been rolled out in 9583 Post Offices. 
  4. ATMs have been installed in 125 locations. 
  5. Core Insurance solution (CIS-PLI) has been rolled out in 20378 Post Offices. 
  6. CSI pilot roll out has started in Mysore Division of Karnataka Circle on 01.10.2015. 
  7. Rural Hardware vendor has been finalized and contract has been signed. Development of software is underway and once it is ready deployment of hardware in pilot Branch Post Offices will start.

Non Receipt of COD Data in Postman Module

  • COD article received 2ND time at your office.
  • Remark on 1st receipt is RTS at your office.
  • The article delivered to Sender.
  • Then you did not get article details in Postman module though you request.
  • Goto and enter COD article number and track it.

  • For confirmation of  “This article has already returned to Sender by 2. Hence, this article can only be delivered to Sender only “ Remark,
  • Visit and login with user id as “dop” and password as “india” 
  • Select COD ARTICLE DETAILS option under COD REPORTS tab and enter article number, click on SEARCH then you will get details.
  • Now you can send the article to Sender by manual entry without any hesitation.
For any queries mail to me

Solution for NSC-KVP accounts having invalid remarks for discharged accounts in binder

Query to solve NSC/KVP accounts having invalid remarks for discharged accounts in binder discrepancy noticed in DPT V 7.3 .

Note : Kindly verify each and every account status manually in Gardfile before going to apply the below solution. The below query is created by admin is based account status of gardfile of NSC/KVP. The blog / author of this post is not responsible for data loss/ incorrect updation.
update dcl.nsc_binder
set remarks='DISCHARGED'
WHERE REMARKS='PURCHASED' and slno in (select slno from dcl.nsc_gardfile where remarks='DISCHARGED')
update dcl.nsc_binder
set remarks='PURCHASED'
WHERE REMARKS='DISCHARGED' and slno in (select slno from dcl.nsc_gardfile where remarks='PURCHASED')
update dcl.kvp_binder
set remarks='DISCHARGED'
WHERE REMARKS='PURCHASED' and slno in (select slno from dcl.kvp_gardfile where remarks='DISCHARGED')
update dcl.kvp_binder
set remarks='PURCHASED'
WHERE REMARKS='DISCHARGED' and slno in (select slno from dcl.kvp_gardfile where remarks='PURCHASED')
The above query may be executed by the System Admin with his/her Own risk. Best advise take Backup before going to apply the above query.
Dhrubajyoti Rudra. SA,Belgharia H.O. North Presidency Division

Technical integration with customers of India Post


The booking information is collected electronically from the servers of the customers. The information is made available at the Booking office. After receipt of the articles, with single click the article can be booked. Information regarding booking, bagging and delivery of the articles booked by the customer are electronically transferred to the customer's server. This gives great facility to customers who are sending huge volumes because they have all the information at their server. Presently this facility is being availed for Speed Post by M/s. Amazon, M/s., Flipkart, M/s. Myntra and M/s. Yepme.

e-Payment with TNEB: 

Tamilnadu Electricity Board bill payments are accepted through e-Payment. The billing information is obtained from TNEB servers dynamically when the customer visits Post Office. The payment is accepted on the basis of information received from TNEB. The bill payment information is also transmitted to the TNEB electronically through automated software.
This gives greater comfort to the customer and huge convenience and savings in terms of updating their records to the TNEB.

e-Payment with BESCOM:

In Karnataka State the Electricity bills are collected through e-payment. The data from the BESCOM servers is received on daily basis by CEPT. This updated data will be utilized by Post offices while accepting payments. The payment information is electronically transferred to BESCOM.

Philately Promotion in Odisha Circle

Two Special Covers and three stamp booklets were released during "Boudhpex" District Level Philatelic Exhibition held from 18-19 November 2015. 

Swachh Bharat Campaign in Post Offices from 18 to 27 Dec'15

Swachh Bharat Campaign in Post Offices from 18 to 27 Dec'15

Sale of TTD Calenders/Diaries through Post Offices

  1. Cost of Calender is Rs. 90- and Diary is Rs. 115 (including all charges)
  2. Advance Booking period in BOs/SOs/HOs: 21.12.2015 to 31.12.2015
  3. Amount to be collected in MS-87(a) in BO and in UCR in SO and total amount to be credited under UCR in SOs under Sale of TTD Publications

Suspect Query SQL 2000 – Recover suspect SQL 2000 databases

Suspect Query SQL 2000 – Recover suspect SQL 2000 databases

I got this simple solution when I was troubled with restoring a suspect ‘ Counter’ db and found it working fine for recovering SQL 2000 databases.

All Steps are given below:

  1. Right click on suspected database and select option - Take Offline
  2. Stop SQL Server 2000 Service Manager and copy .mdf and .ldf files of suspect database to a safe location.
  3. Rename log file ( .ldf file ) of suspect database. 
  4. Copy .ldf file path (with file name before renaming) and paste in below query ( in no.7 )
  5. Start SQL Server 2000 Service Manager - Open Query analyzer and execute the query. 
Use master
sp_configure 'allow updates', 1
Reconfigure with override
5. From Query Analyzer execute script
Update sysdatabases set status= 32768 where name = 'Counter '
6. Restart MSSQLSERVER service, the database will be in Emergency mode
7. Rebuild Log. From QA execute script
DBCC REBUILD_LOG ('Counter', 'D:\Databases\Counter_log.ldf')
You got a 
Message - Warning: The log for database 'postman' has been rebuilt.
8. From QA execute script
Use master
sp_configure 'allow updates', 0
Enter suspect database name and path of log file within single quote.
6.Right click on suspect data base and select refresh option and see it changes to dbo use only.
7.Right click on dbo use only db and select Properties - select Options tab - Access – and remove tick mark on Restrict access and click OK.
Note: If data base changed to " suspect/emergency " mode and unable to do anything further due to double click or selecting other options , 

then do the following steps: 

1.Delete that suspect database , delete .mdf and .ldf files of that db and create a new database in the same name of that Suspect DB or restore with any old backup file of that DB.
2. Copy and paste .mdf and .ldf files of Suspect database to the original database file location (eg:- 'D:\Databases\ ' from where the files are copied in Step 2 
3. See the database again changed to suspect mode only
4.Repeat steps 3 to 7. 

Thanks to Sri. Aswaj Sivadas, System Administrator, Calicut Civil HO 

Shared by: Roy.K.J, Sulthan Bathery MDG -673592.

Interesting Statistics from the 7th Pay Commission Report

Interesting Statistics from the 7th Pay Commission Report According to the 7th Central Pay Commission Report, close to 29% of the employees are in the age group of 50 to 60 years. More than 44% of the employees are in the age group of 20 to 40 years. The average per capita expenditure on pay & allowances of a central government employee is 3.92 lakh rupees for the financial year 2012-13. 
The Part 1 of this series looked at the number of vacancies, number of employees in various ministries/departments and number of employees by different categories in Government of India. Below are a few more interesting statistics from the CPC report. 

Employee Age Profile 

There is more or less an even spread of employees in different age groups. 22% of the employees are between 20 and 30 years while an equal percentage are between 30 and 40 years. 26% of the employees are between 40 and 50 years while the remaining 29% are between 50 and 60 years.
There are stark differences within ministries in the age profile of employees. The Ministry of Home Affairs has the highest percentage of employees in the 20 to 30 years bracket at 40%. This could be due to the fact that most of them come from the central armed forces. The Ministry of Petroleum & Ministry of Textiles, both have just 2% employees each in this age group. 
In the 30 to 40 years age group, Ministry of Youth Affairs has the highest percentage at 29% and Ministry of Coal has the least at 7%. In the 40 to 50 years age group, Ministry of Tourism has the highest percentage with a whopping 65% while the Ministry of Textiles has the least percentage at 15%.

 In the 50 to 60 years age group, Ministry of Textiles has the highest at 75%. Coupled with the other figures, 90% of the employees in the Ministry of Textiles are above 40 years. The Ministry of Home Affairs has only 7% employees in this age group.
Expenditure on Pay & Allowances The Government of India extends various types of allowances to the employees apart from their regular pay. The government expenditure on pay & allowances has been steadily growing. From 51664 crore rupees in 2007-08, the expenditure went up to 129599 crore rupees in 2012-13, an increase of more than 150%. The growth has been steady except in 2010-11 where it increased only marginally.
Of the total expenditure, the highest expenditure is on the Ministry of Railways, followed by the Ministry of Home Affairs. This is only natural because they employ the maximum number of people. 

Per Capita Expenditure on Pay & Allowances 

The per capita expenditure on pay & allowances indicates that the government has spent Rs 3.92 lakh per employee during the financial year 2012-13 towards pay and allowances. The highest per capita expenditure on pay & allowances is for the employees of the Ministry of External Affairs at Rs 34.95 lakh per annum. This is an aberration since it also includes pay & allowances paid abroad. Second in the list is Ministry of Renewable Energy with 10.65 lakh rupees followed by Ministry of Food Processing at 8.29 lakh rupees. Department of Electronics & IT and Ministry of Power make up the top five. The per capita expenditure for these departments & ministries is substantially higher than the average.
While the Ministry of Railways & Home Affairs have seen the highest expenditure for pay & allowances, their per capita expenditure compared to the average is not the highest. The average pay & allowances was least for the Ministry of Railways at Rs 2.97 lakh while it was Rs 4.18 lakh for Ministry of Home Affairs.

Meghdoot Version 7.9.4 dated 17.12.2015

Consequent on release of Meghdoot Update 7.9.3 on 09.10.2015, the following new requirements/ orders have been issued by the Directorate.

1) PA Wing, Directorate letter F.No. PA Book I/ST VOL VI/2015-16/D-4460 TO 4510 dated 09.11.2015 communicating the Service Tax Notification for introduction of Swachh Bharat Cess @ 0.5 % wherever Service Tax is applicable w.e.f. 15.11.2015.

2) Directorate of PLI letter No.29-9/2013-LI dated 16.11.2015 communicating the Swachh Bharat Cess applicable on PLI/RPLI Premia @ 3.62 % [Service Tax 3.5% and SBC 0.12%] on First Year Premia and @ 1.81 % [Service Tax 1.75% and SBC 0.06%] on Renewal Premia collected.

3) Directorate, New Delhi letter No.1-20/2014-15/T&C dated 26.11.2015 communicating the Gazette Notification for revision of foreign postage rates on letter post items w.e.f. 1.12.2015.

In addition to the above major requirements, many other minor modifications/improvements have been done and hence this release. Complete list of enhancements/modifications in each module are furnished in Section 5 of this document.

Meghdoot Update 7.9.3 released on 09.10.2015. 

Meghdoot Version 7.9.4  released on 17.12.15 Download

This Update contains the following applications:

1 ePayment
2 Point of Sale 
3 Treasury
4 Sub Accounts
5 BNPL-Parcel 
6 Accounts
7 Accounts PBS
8 MO Compilation