TOOL FOR RECOVER SUSPECTED SQL DATABASES

Tool For Recover Suspected Database In SQL 2005 / 2008

Script and Developed by : Rajesh C R Compatible SQL Version : SQL 2005 / 2008 Password : dopadmin
Contact Developer: rajeshcr2007@gmail.com

This Tool is only for Recover Suspected database in SQL 2005 only

Instruction

• Download the attached Tool from PoTools.
• Execute from Suspected Server Machine.

Note: This Tool is not applicable for SQL 2000 server.

 Download

                                                                  Download

RELAXATION TO TRAVEL BY PRIVATE AIRLINES TO VISIT J&K – DOPT ORDERS ON 28.11.2014

Entitled and not entitled officers to travel by air may also travel by private airlines subject to the conditions laid in the previous orders.

(i) Officers entitled to travel by air may also travel by private airlines from their headquarters; 

(ii) Officers not entitled to travel by air may be permitted to travel by private airlines between Delhi /Amritsar and any place in J&K.

 

No.31011/7/2014-Estt.(A-IV)

Government of India

Ministry of Personnel, Public Grievances and Pensions

Department of Personnel and Training

North Block, New Delhi-110 001

Dated: 28th November, 2014

OFFICE MEMORANDUM

Subject:- Central Civil Services (Leave Travel Concession) Rules, 1988 — Relaxation to travel by private airlines to visit J&K.

The undersigned is directed to refer to this Ministry’s O.M. No.31011/3/2014- Estt.(A-1V) dated 26th September, 2014. It has been decided that the Government servants while availing Leave Travel Concession (LTC) to Jammu and Kashmir (J&K) under the special dispensation scheme allowed by the aforesaid O.M. may also travel

by private airlines subject to the following conditions:-

(i) Officers entitled to travel by air may also travel by private airlines from their headquarters;

(ii) Officers not entitled to travel by air may be permitted to travel by private airlines between Delhi /Amritsar and any place in J&K.

2. Air travel by private airlines is to be performed in Economy Class only an at LTC- 80 fare of Air India or less.

3. Air Tickets to be purchased directly from the airlines (Booking counters, website of airlines) or by utilizing the service of Authorized Travel Agents viz. ‘M/s Balmer Lawrie & Company’, ‘M/s Ashok Travels & Tours’ and ‘IRCTC’ (to the extent IRCTC is

authorized as per DoPT’s O.M. No. 31011/6/2002-Estt.(A) dated 02.12.2009) while undertaking LTC journey. Booking of tickets through other agencies is not permitted.

4. All other conditions prescribed in this Ministry’s O.M. No. 31011/3/2014-Estt.(AIV) dated 26.09.2014 would continue to apply.

5. The order will remain in force for a period of one year from the date of issue of this order.

sd/-

(B. Bandyopadhyay)

Under Secretary to the Govt of India

Click Here to view Original orders

NREGAEMO UPDATE CHECK BY CEPT MYSORE

NREGAEMO Update Check

• NREGA eMO Check Available in CEPT. 
• Download from FTP, CEPT

NregaeMO Check Screenshot:

Download From Official Site

Download Here

FLOOD OF LETTERS TO PM MAKES POSTAL OFFICIALS ROLL UP SLEEVES

NEW DELHI: Call it a growing desire among citizens to directly connect with the PM, the postal department has witnessed a phenomenal upsurge in letters addressed to the country's highest office in the past few months.

While the PMO used to receive anywhere between 5,000 and 10,000 letters per month during Manmonhan Singh's tenure, the figure has been 1-2 lakh every month since July, barely two months after Narendra Modi took over as the , said officials. From the pathetic condition of a school to suggestions to generate power from alternative and renewable sources, people seem to be writing to Modi on everything under the sun.

While this could be an indicator of Modi's popularity among the masses, the sudden increase in the volume of letters has had the post office at Nirman Bhawan, which deals with the PMO letters, on its toes. This has prompted the officials, who were accustomed to dealing with just one fourth of these numbers, to increase the staff strength at the PMO dak unit and upgrade infrastructure. The team led by post master general Vishwamurti and the senior superintendent (central division) Binti Chaudhry had also put in place a better delivery system.

According to an official, letters are first diverted to two beats, which are dedicated to the PMO, where they undergo a security scan. Subsequently, these are segregated on the basis of mode of post such as speed post, ordinary post etc. "We make the entries in our computers and then send the letters to the PMO latest by 11pm each day," the official said.

A team of around 50 officials is at work at the Nirman Bhawan post office for the disposal of the letters marked for the PMO.

The letters, once read by the PMO officials, are sent to various departments located in Shashtri Bhawan, Rail Bhawan etc depending on the nature of complaints. The ones that require to be read by the PM are brought to his notice.

Officials recall how they were taken aback when they received over a lakh letters in July. "On an average, the daks used to be around 5,000-10,000. But in July and August, we had received around 1.26 lakh. The number shot up to around 2.7 lakh in September during Modi's birthday and the Kashmir floods," an official said.

"The postal department used to receive around 100 e-Money Orders daily, which were sent as donations to the PM's relief fund, in the aftermath of the floods in J&K. Apart from birthday wishes sent through lakhs of letters, the post office received 3,000 "e-Post messages" on the PM's birthday, another official said.

The trend, officials say, is unprecedented at a time when internet and e-mail have touched every nook and corner of the country. They say this will not only help revive the practice of writing letters, but also give a new lease life to the long-dormant postal department.

INCLUSION OF AADHAAR (UNIQUE IDENTIFICATION) NUMBER IN SERVICE BOOK OF GOVERNMENT SERVANTS

No.Z-20025/9/2014-Estt.(AL)

Government of India

Ministry of Personnel, Public Grievances & Pensions

Department of Personnel & Training

Block-IV, Old JNU Campus,

New Delhi, November 3rd 2014

OFFICE MEMORANDUM

Subject: Inclusion of Aadhaar (Unique Identification) number in Service Book of Government servants -

The undersigned is directed to invite attention to the provisions of the Supplementary Rules which relate to maintaining records of service of a Government employee. As per provisions of SR 199 every step in a Government servants’ official life must be recorded in his Service Book and each entry attested by the Head Of Office. As per SR 202, Heads of Offices are to obtain the signatures of the Government servants in token of their having inspected their Service Books annually. Further Rule 32 of the CCS (Pension) Rules 1972 provides for issuing a communication on completion of 18 years of service, as part of preparatory work for sanctioning pensionary benefits. The Service Books at present contains details of bio data, posting details, qualifying service, security details, HBA, CGHS, CGEGIS, LTC, etc.

2. It has been decided to include the respective Aadhaar numbers also of all Government servants in their Service Books. The e-Service Book format already provides fields forAadhaar number of the Government servant.

3. All Ministries / Departments of the Government of India are requested to ensure that the Service Books of all employees have an entry  of  the employees’  Aadhaar number. Theattached and subordinate offices under their control may also be suitably instructed for compliance,

(Mukul Ratra)

Director

Download DOPT Office Memorandum No.Z-20025/9/2014-Estt.(AL) dated 03.11.2014

INTRODUCTION OF MANDATORY INDUCTION TRAINING FOR PROBATION CLEARANCE - REGARDING.

The Dopt order says, during the period probation, or any extension thereof, candidates may be required by Government to undergo such courses of training and instructions to pass examinations and tests as Government may deem fit as a condition to satisfactory completion of the probation.

No. 28020/I/2010-Estt(C)

Government of India

Ministry of Personnel, Public Grievances and Pensions

(Department of Personnel & Training)

North Block, New Delhi

Dated the 30th october 2014

OFFICE MEMORANDUM

Subject: Introduction of mandatory Induction Training for Probation clearance-regarding.

The undersigned is directed to refer to this Department’s O.M of even number dated 21 July, 2014 wherein consolidated instructions on Probation/ Confirmation in Central Services were issued for ready reference to all concerned. As per extant instructions during the period probation, or any extension thereof, candidates may be required by Government to undergo such courses of training and instructions to pass examinations and tests as Government may deem fit as a condition to satisfactory completion of the probation.

2. It has been decided that in all cases of direct recruitment there should be a mandatory induction training of atleast two weeks duration. Successful completion of the training may be made a pre-requisite for completion of probation. The syllabus for the training may be prescribed by the Cadre authorities and the Training Division of DOPT can be consulted, if required.

3. The recruitment rules for all posts, wherever such a provision does not already exist, may be amended to provide for such mandatory training. Till such time as the Recruitment Rides are amended, a clause on the above lines may be included in the offer of appointment.

sd/-

(J.A.Vaidyanatahn)

Director (Establishment)

Source: www.persmin.gov.in

[http://ccis.nic.in/WriteReadData/CircularPortal/D2/D02est/28020_1_2010-Estt-C.pdf]

RPLI COMMISSION PREPARATION TOOL FOR SUBOFFICE

12:26  DHIRENDRA SINGH SINDAL  NO COMMENTS

Download RPLI Commission Preparation Tool For SO

RPLI Commission Preparation Tool for Sub Office has been developed by KarunaGaran SA Tiruppatur.

RPLI Commission Preparation Tool

Instruction 

• Enter SQL Information of MM Server in This Tool.
• Click on RPLI commn Preparation option to Prepare Commission list.
• Take Report using Reports Option.

• .

Download

RPLI Commision tool

DELETE DUPLICATE COD IN POSTMAN 7.9 BY CEPT

DELETE DUPLICATE COD IN POSTMAN 7.9 BY CEPT

12:27  Dhirendra singh sindal  NO COMMENTS

Delete Duplicate COD Solution Given By CEPT

In most of the Time while fetch COD articles in Postman 7.9 it shows an duplicate entries of Same COD Article message.

Solution given by CEPT, Mysore.

Solution

Delete COD Articles Appearing more than Once @ Invoicing.. 

1. Download attached Script Provided by CEPT.
2. Execute Script using MM Script Tool, before Invoicing

Download from here       Duplicate COD Solution 

POINT OF SALE SHIFT END ERROR : STATISTICAL DATA NOT UPDATED

While do the Point of Sale Shift End it may show the error message like below.

These errors are typically caused by some sort of database corruption, either in-memory or on-disk. Essentially, the server is requesting a page from the buffer pool, and the page number/object ID on the page differs from the one that was requested.

Solution

• Copy below Script from PoTools.
• Execute at Once using SQL Query Analyzer to Repair Tables.

Use POSPCC

dbcc checktable('articlessent') WITH ALL_ERRORMSGS, NO_INFOMSGS​

FINACLE MENU OPERATIONS AT CBS POST OFFICES

FINACLE  MENU  OPERATIONS  AT  CBS  POST  OFFICES	UPDATE   UPTO	22.11.2014
EXPANSION	OPERATOR  MENU	VERIFY  MENU
SERVICE OUTLET                      :                                               SOL
CUSTOMER INFORMATION FILE  :                                         CIF
OFFICE ACCOUNT BASICS   :                                                  OAB
OFFICE ACCOUNT POINTING   :                                            OAP
SOL ID       :                                                 PINCODE  +  NON  DLY  CODE
VAULT ACCOUNT        :                             SOL  ID + 0403
POSTMASTER A/C       :                               SOL  ID + 0340
GENL SUNDRY A/C      :                             SOL ID + 0324
SUNDRY TD A/C :                                      SOL ID + 0335
BO SETTLEMENT A/C   :                            SOL ID   + 0339
KVP SUBVENTION R/C FIELD:                  45089000
BEGINNING OF DAY    :                           BOD
END  OF DAY              :                             EOD
CIF
CUSTOM CREATE RETAIL CIF	CCRC	CCRC
CUSTOM  MODIFY RETAIL CIF	CMRC	CMRC
CUSTOM  RELATIONSHIP VIEW	HCRV	………
CIF DATA ENTRY DUPLICATE	CDEDUP	……..
CHANGE OF CIF ID OF ACCOUNT	HCCA	HCCA
INVENTORY
INVENTORY MOVEMENT CONNECTIONS	HIMC	HIMC
INVENTORY INQUIRY ALL	HIIA	……….
INVENTORY MOVEMENT INQUIRY	HIMI	……….
INVENTORY SPLIT AND INQUIRY – OWN LOCATION	HISAI	HISAI
INVENTORY SPLIT AND INQUIRY – OTHER LOCATION	HISIA	HISIA
INVENTORY MERGE AND INQUIRY – OWN LOCATION	HIMAI	HIMAI
INVENTORY MERGE AND INQUIRY – OTHER LOCATION	HIMIA	HIMIA
INVENTORY STOCK REPORT	HISR	……….
ISSUE CHEQUE BOOKS	HICHB	HICHB
STOP PAYMENT PROCESSING	HSPP	HSPPAU
ACCOUNT LIEN MAINTENANCE	HALM	HALM
ACCOUNT FREEZE STATUS MAINTENANCE	HAFSM	HAFSM
INQUIRE ACCOUNT ID FOR A CHEQUE	HINQACHQ	………..
CHEQUE BOOK MAINTENANCE	HCHBM	……..
CHEQUE BOOK ISSUED REGISTER	HCHBIR	……..
ISSUE CHEQUE BOOK TO CUSTOMER	HICHB	……...
COMMON
CHANGE CONTEXT SOL ID	HCCS	……..
PRINT QUEUE INQUIRY	HPR	………
FIND TRANSACTION ID	HFTI	……..
SSTANDING INSTRUCTION MAINTENANCE	HSSIM	HSSIM
SSTANDING INSTRUCTION INQUIRY	HSSII	…….
STANDING INSTRUCTION PRINT	HSIRP	…….
SI  EXECUTED  TODAYS REPORT	HSIETR	……….
CUSTOMER  BECOMING  MAJOR	HCBM	………
ACCOUNT  INTERSET  BEFORE CLOSURE	HACINT	……….
CASH PENDING TRANSACTION	HCASHPND	HTM
CUSTOMER TRANSACTION MAINTENANCE	CTM	CTM
TRANSACTIONS MAINTENANCE	HTM	HTM
CASH TRANSFER	CXFER	CXFER
PASS BOOK PRINTING	HPBP	……..
ACCOUNT  DETAILS	HACCDET	………
CUSTOM   NEW ACCOUNT	CNAC	……..
ACCOUNT LEDGER INQIRY	HACLI	………
TELLER CASH POSITION INQUIRY AN EMPLOYEE	HTCPIAE	……..
FINACLE REPORT	HFINRPT	………
ACCOUNT SELECTION LIST	HACS	……..
BO ACCOUNT CLOSURE WARRANT	HACACCR	HACACCR
DEPOSIT TRANSACTIONS REPORT SUMMARY	HDTRS	………….
TRANSFER OF ACCOUNTS	HACXFSOL	HACXFSOL
SB
CUSTOM A/C SB ACCOUNT OPEN	CASBAO	CASBAV
CUSTOM A/C  SB ACCOUNT OPEN MODIFY ( BEFORE VERIFICATION )	CASBAOM	CASBAV
CUSTOM ACCOUNT SB ACCOUNT MODIFY  ( AFTER VERIFICATION  )	CASBAM	CASBAM
CUSTOM ACCOUNT AFTER CLOSURE              (  CLOSURE  )	HCAAC	HCAAC
ACCOUNT TRANSFER BETWEEN SCHEMES	HACXFRSC	HACXFRSC
TD  /  MIS
CUSTOM MIS / TD ACCOUNT OPEN	CMISAOP	CMISAOPV
CUSTOM MIS / TD ACCOUNT OPEN MODIFY	CMISAOPM	CMISAOPV
MODIFICATION AFTER VERIFICATION	CMISAM	CMISAM
TIME DEPOSIT TRANSACTIONS DETAILS	HTDTRAN	………
TIME DEPOSIT RENEWAL	HTDREN	HTDREN
TIME DEPOSIT CLOSURE	HCAACTD	HCAACVTD
MIS A/C INDIVIDUAL HOLDING STATUS	CLIMIT	………..
SCSS
CUSTOM SENIOR CITIZEN ACCOUNT OPEN	CSCAOP	CSCAOPV
CUSTOM SCSS  ACCOUNT OPEN MODIFY	CSCAOPM	CSCAOPV
MODIFICATION AFTER VERIFICATION	CSCAM	CSCAM
SCSS  CLOSURE	HCAACTD	HCAACVTD
SCSS TRANSACTIONS DETAILS	HTDTRAN	…………….
SCSS ACCOUNT RENEWAL	HTDREN	HTDREN
NSC
CUSTOM MENU FOR SAVINGS CERT OPENING	CSCOAAC	CSCOAACV
MODIFICATON BEFORE VFN	CSCOAACM	CSCOAACV
MODIFICATION AFTER VFN	CSCACM	CSCACM
NSC DEPOSIT RECEIPT PRINT	HDRP	……..
CLOSURE OF SAVINGS CERTIFICATE	CSCCAAC	CSCCAAC
BALANCE INQIURY OF KVP	HACLITD	………
RD
RD ACCOUNT OPEN CUSTOM  MENU	CRDOAAC	CRDOAACV
RD A/C MODIFY BEFORE VERIFICATION	CRDOAACM	CRDOAACV
RD A/C MODIFY AFTER VERIFICATION	CRDACM	CRDACM
RD DEPOSIT	RDAMT / CRDP	RDAMT
RD PENDING INSTALLMENT LIST	HPLIST	………
RD DSAGENTS  MASTER MAINTENANCE	HDSAMM	HDSAMM
RD AGENT BULK POSTING MENU	HAGTXP	HAGTXP
RD ACCOUNT CLOSURE	CRDCAAC	CRDCAAC
RD LOAN
CUSTOM ACCOUNT OPEN LOAN A/C RD	CAOLARD	CAOVLARD
MODIFY LOAN A/C BEFORE VFN	CAOMLARD	CAOVLARD
MODIFY LOAN A/C AFTER VFN	CACMLARD	CACMLARD
LARD ACCOUNT DISBURSEMENT	LARDD	LARDD
RD UNSCHEDULE LOAN REPAYMENT	HLAUPAY	HLAUPAY
RD SCHEDULE LOAN REPAYMENT	HLASPAY	HLASPAY
RD LOAN PAY OFF PROCESS	HPAYOFF	HPAYOFF
RD CLOSE LOAN A/C	CAACLA	CAACLA
EXTENSION OF RD	HPRDCM	HPRDCM
PPF
CUSTOM PPF ACCOUNT OPENING	CPPFAO	CPPFAV
CUSTOM PPF MODIFY BEFORE VFN	CPPFAOM	CPPFAV
CUSTOM PPF MODIFY AFTER VFN	CPPFAM	CPPFAM
CUSTOM PPF DEPOSIT TRANSACTION MAINTENANCE	CPDTM	CPDTM
CUSTOM PPF WDL TRANSACTION MAINTENANCE	CPWTM	CPWTM
PPF ACCOUNT EXTENSION	PPFAEXT	PPFAEXT
PPF ACCOUNT CLOSURE	HCAAC	HCAAC
PPF LOAN
CUSTOM LOAN PPF ACCOUNT OPEN	CLPPFAO	CLPPFAOV
CUSTOM LOAN PPF ACCOUNT OPEN MODIFY BEFORE VFN	CLPPFAOM	CLPPFAOV
CUSTOM LOAN PPF ACCOUNT OPEN MODIFY AFTER VFN	CLPPFAM	CLPPFAM
CLOSURE OF LOAN A/C PPF STEP 1	CLPR
CLOSURE OF LOAN A/C PPF STEP 2	HACINT
CLOSURE OF LOAN A/C PPF STEP 3	HCAAC	HCAAC
SB DISCONTINUED  PRODUCTS
CLOSURE OF ACCOUNTS	HXFER	HXFER
COD
STEP 1	HTCPIAE	…………
STEP 2	HFTI	………..
STEP 3	HSSI	………….
SOL  CHANGE  OF  OPERATING  DATE         STEP 4	………….	HSCOD
CHEQUE  INWARD  CLEARING  PROCESS
1.  OPEN ZONE		HIMICZ
2.  INSTRUMENT  ENTRY	HICTM
3.  VERIFY		HICTM
4.  SUSPENSION  OF  ZONE		HIMICZ
5.  VALIDATION		HIMICZ
6.  POST ZONE		HIMICZ
7.  CLOSE ZONE		HIMICZ
CHEQUE  OUTWARD  CLEARING  PROCESS
AT  SO  LEVEL :   1.  LODGING INSTRUMENT	HOMSO
2.  VERIFY		HOMSO
3.  REPORTS	HOMSOEX
AT  HO  LEVEL :  1. OPEN ZONE		HMCLZOH
2. REPORTS		HOMSOEX
3. FILE DOWNLOADING		HTRFTOPC
4. FILE UPLOADING		HCLUPLD
5. HO CHEQUES  ENTRY	HOCTM
6. VERIFICATION		HOCTM
7. SUSPENSION		HMCLZOH
8. RELEASE SHADOW  BALANCE		HMCLZOH
9. REGULARISE SHADOW BALANCE		HMCLZOH
Visit : http://sapost.blogspot.in/