Wednesday, November 11, 2015

Remuneration payable to Full Time/Part Time Casual Labourers

Implementation of Directorate’s OM No. 2-53/2011-PCC dated 22.01.2015 regarding remuneration payable to Full Time/Part Time Casual Labourers.

SQL database Suspect Solution

  • Sometimes when you connect to your database server, you may find it in suspect mode. 
  • Your database server won’t allow you to perform any operation on that database until the database is repaired. 
  • A database can go in suspect mode for many reasons like improper shutdown of the database server, corruption of the database files etc. 
  • To get the exact reason of a database going into suspect mode can be found using the following uery
  • Output of the above query will give the errors in the database. To repair the database, run the follow in queries in Query Analyzer, 
  • You should keep one thing in mind while using the above queries that the repair mode used here , REPAIR_ALLOW_DATA_LOSS, is a one way operation 
i.e. once the database is repaired all the actions performed by these queries can’t be undone. 
  • There is no way to go back to the previous state of the database. So as a precautionary step you should take backup of your database before executing above mentioned queries

Collection of Important and Useful Docs

Click Below Link to Download Training Materials on DOP - CBS

Click Below Link to Download Latest CBS -FAQs. It's a collection of Solutions that PO Users daily faces

Tool for finding new account ID from old account in DOP Finacle

We are here submitting a tool for finding out the new account number from the Old account for PO finacle .

How to Use ?

1 Install Sanchay finacle account msi and run the tool
2. Enter SOL ID (for first time )
3. Click Tool Menu Then select File Upload option 
4. Upload “Oldaccountnew account mapping CSV “ file which is received with Load report from DMCC(while upload the load report please ensure that application is not interrupted )
Then re run the application 
If any suggestion please mail


Schedule 7.9.3 PLI / RPLI Runtime error '13' - Type Mismatch

Schedule error and Solution

While doing PLI / RPLI data entry in Schedule 7.9.3 dated 19.10.2015, it will generate the error message 
Run-time error '13': Type Mismatch


  • Execute the attached solutiionusing script tool in the following order then replace the latest schedule exe which is available in CEPT FTP.


Service Tax for Swachh bharat cess @ 0.5% w.e.f 15th Nov 2015

This notification has increased the rate of service tax 0.5% for swachh bharat cess w.e.f 15.11.2015. Due care should be taken of the negative list. All the other items not included in the negative list are liable to be taxed.

Read Full Document / Download Order Copy

Issues facing after McCamish migration

1) While processing matuirty settlement of policies, after the approver has approved for payment, while cheque disbursement, after entering the bnk details a message appears " error , contact SA"

2) While accepting new policies, error appears when logged in as quality checker

3) Many of the policies are not seen migrated. "Policy not found" appears when entering certain policies

4) Credits are seen missing whereas actually customer has credited. Last month (September) not updated in most of the cases

5) In two cases, an additional credit was seen in Mc Camish

6) Receipt printing is not possible. Now the receipt is being copied to a word file and then printout taken , which consumes a lot of time and there are chances of errors while copy-paste.

If you are facing any other problems, please comment here. I will include that in this article. 

Thank you ....

List of PAs promoted to LSG Cadre in TN Circle

Email Policy of Department of Posts

DOP eMail Policy v1.0


Email communication that includes data transmission between users,both within the country and outside, is being widely used by the Department of Posts [DoP] as an official communication. 

Through this document the DoP is laying down the “E-mail Policy” mail Services” be CSI Vendor of India Post IT Modernization Project. 


All government employees working within the DoP shall use DoP email services for all the official communication apart from the written official communication. The use of e-mail service of other private service providers shall be strictly limited to unofficial/personal communication and shall not be used for any official communication.

This email policy shall be applicable to all those employees of the Department of Posts who have been provided with an official email ID under India Post Domain i.e. email id ending with and those who use the email services of the department. The directives contained in this policy are to be followed by all such employees without any exception.

Sub Account 7.9.3 Floppy Download Error and Solution

Sub Account v7.9.3 Floppy Download

Error Reading the file -*.txt Subscript out of range.


  • Please use the latest subaccounts exe dt 18-10-15 available at

Clarification on non-financial transactions S B Order No. 07/2015

Clarification on non-financial transactions ( especially CIF Modification & Account Modification ) S B Order No. 07/2015

Source : ATP Post

FAQ : All About Sovereign Gold Bond

Sovereign Gold Bond Scheme 2015

1. What is Sovereign Gold Bond (SGB)? Who is the issuer?

SGBs are government securities denominated in grams of gold. They are substitutes for holding physical gold. Investors have to pay the issue price in cash and the bonds will be redeemed in cash on maturity. The Bond is issued by Reserve Bank on behalf of Government of India.

2. Why should I buy SGB rather than physical gold? What are the benefits?

The quantity of gold for which the investor pays is protected, since he receives the ongoing market price at the time of redemption/ premature redemption. The SGB offers a superior alternative to holding gold in physical form. The risks and costs of storage are eliminated. Investors are assured of the market value of gold at the time of maturity and periodical interest. SGB is free from issues like making charges and purity in the case of gold in jewellery form. The bonds are held in the books of the RBI or in demat form eliminating risk of loss of scrip etc.

3. Are there any risks in investing in SGBs?

There may be a risk of capital loss if the market price of gold declines. However, the investor does not lose in terms of the units of gold which he has paid for.

4. Who is eligible to invest in the SGBs?

Persons resident in India as defined under Foreign Exchange Management Act, 1999 are eligible to invest in SGB. Eligible investors include individuals, HUFs, trusts, universities, charitable institutions, etc.

5. Whether joint holding will be allowed?

Yes, joint holding is allowed.

6. Can a Minor invest in SGB?

Yes. The application on behalf of the minor has to be made by his / her guardian.

7. Where can investors get the application form?

The application form will be provided by the issuing banks/designated Post Offices/agents. It can also be downloaded from the RBI’s website. Banks may also provide online application facility.

8. What are the Know-Your-Customer (KYC) norms?

Know-Your-Customer (KYC) norms will be the same as that for purchase of physical form of gold. Identification documents such as Aadhaar card/PAN or TAN /Passport / Voter ID card will be required. KYC will be done by the issuing banks/Post Offices/agents.

9. What is the minimum and maximum limit for investment?

The Bonds are issued in denominations of one gram of gold and in multiples thereof. Minimum investment in the Bond shall be two grams with a maximum buying limit of 500 grams per person per fiscal year (April – March). In case of joint holding, the limit applies to the first applicant.

10. Can I buy 500 grams in the name of each of my family members?

Yes, each family member can hold the bond if they satisfy the eligibility criteria as defined at Q No.4.

11. Can I buy 500 grams worth of SGB every v year?

Yes. One can buy 500 grams worth of gold every year as the ceiling has been fixed on a fiscal year (April-March) basis.

12. Is the limit of 500 grams of gold applicable if I buy on the Exchanges?

The limit of 500 grams per financial year is applicable even if the bond is bought on the exchanges.

13 What is the rate of interest and how will the interest be paid?

The Bonds bear interest at the rate of 2.75 per cent (fixed rate) per annum on the amount of initial investment. Interest will be credited semiannually to the bank account of the investor and the last interest will be payable on maturity along with the principal.

14. Who are the authorized agencies selling the SGBs?

Bonds are sold through scheduled commercial banks and designated Post Offices either directly or through their agents like NBFCs, NSC agents, etc.

15 Is it necessary for me to apply through my bank?

It is not necessary for the customer to apply through the bank where he/she has his/ her account. A customer can apply through another bank or Post Office.

16. If I apply, am I assured of allotment?

If the customer meets the eligibility criteria, produces a valid identification document and remits the application money on time, he/she will receive the allotment.

17. When will the customers be issued Holding Certificate?

The customers will be issued Certificate of Holding on the date of issuance of the SGB. Certificate of Holding can be collected from the issuing banks/Post Offices/agents or obtained directly from RBI on email, if email address is provided in the application form.

18. Can I apply online?

Yes. A customer can apply online through the website of the listed scheduled commercial banks.

19. At what price the bonds are sold?

Price of bond will be fixed in Indian Rupees on the basis of the previous week’s (Monday – Friday) simple average price for gold of 999 purity published by the India Bullion and Jewellers Association Ltd. (IBJA). The issue price will be disseminated by the Reserve Bank of India

20. Will RBI publish the rate of gold applicable every day?

The price of gold for the relevant tranche will be published on RBI website two days before the issue opens.

21. What will I get on redemption?

On maturity, the redemption proceeds will be equivalent to the prevailing market value of grams of gold originally invested in Indian Rupees. The redemption price will be based on simple average of previous week’s (Monday-Friday) price of closing gold price for 999 purity published by the IBJA.

22. How will I get the redemption amount?

Both interest and redemption proceeds will be credited to the bank account furnished by the customer at the time of buying the bond.

23. What are the procedures involved during redemption?

The investor will be advised one month before maturity regarding the ensuing maturity of the bond.
On the date of maturity, the maturity proceeds will be credited to the bank account as per the details on record.
In case there are changes in any details, such as, account number, email ids, then the investor must intimate the bank/PO promptly.

24. Can I encash the bond anytime I want? Is premature redemption allowed?

Though the tenor of the bond is 8 years, early encashment/redemption of the bond is allowed after fifth year from the date of issue on coupon payment dates. The bond will be tradable on Exchanges, if held in demat form. It can also be transferred to any other eligible investor.

25. What do I have to do if I want to exit my investment?

In case of premature redemption, investors can approach the concerned bank/Post Office/agent thirty days before the coupon payment date. Request for premature redemption can only be entertained if the investor approaches the concerned bank/post office at least one day before the coupon payment date. The proceeds will be credited to the customer’s bank account provided at the time of applying for the bond.

26. Can I gift the bonds to a relative or friend on some occasion?

The bond can be gifted/transferable to a relative/friend/anybody who fulfills the eligibility criteria (as mentioned at Q. no. 4). The Bonds shall be transferable in accordance with the provisions of the Government Securities Act 2006 and the Government Securities Regulations 2007 before maturity by execution of an instrument of transfer which is available with the issuing agents.

27. Can I use these securities as collateral for loans?

Yes, these securities are eligible to be used as collateral for loans from banks, financial Institutions and Non-Banking Financial Companies (NBFC). The Loan to Value ratio will be same as applicable to ordinary gold loan mandated by the RBI from time to time.

28. What are the tax implications on i) interest and ii) capital gain?

Interest on the Bonds will be taxable as per the provisions of the Income-tax Act, 1961(43 of 1961). Capital gains tax treatment will be the same as that for physical gold.

29. Is tax deducted at source (TDS) applicable on the bond?

TDS is not applicable on the bond. However, it is the responsibility of the bond holder to comply with the tax laws.

30. Who will provide other customer services to the investors after issuance of the bonds?

The issuing banks/Post Offices/agents through which these securities have been purchased will provide other customer services such as change of address, early redemption, nomination, etc.

31. What are the payment options for investing in the Sovereign Gold Bonds?

Payment can be made through cash/cheques/demand draft/electronic fund transfer.

32. Whether nomination facility is available for these investments?

Yes, nomination facility is available as per the provisions of the Government Securities Act 2006 and Government Securities Regulations, 2007. A nomination form is available along with Application form.

33. Is the maximum limit of 500 gms applicable in case of joint holding?

The maximum limit will be applicable for the first applicant in case of a joint holding for the specific application.

34. Are institutions like banks allowed to invest in Sovereign Gold Bonds?

There is no bar on investment by banks in Sovereign Gold Bonds. These will qualify for SLR.

35. Can I get the bonds in demat form?

The bonds can be held in demat account.

36. Can I trade these bonds?

The bonds are tradable on stock exchanges from the date to be notified by RBI. The bonds can also be sold and transferred as per provisions of Government Securities Act.

37. Can I get part repayment of these bonds at the time of exercising put option?

Yes, part holdings can be redeemed in multiples of one gm.

Finacle- McCamish Desktop Settings for Restore

Finacle McCamish Settings for Restore

Finacle and McCamish Settings were made by using as per document settings. Download attached settings and restore using downloaded software.

Rajesh H System Administrator Puttur(DK) HPO-574201