Monday 15 December 2014

SQL DATA BASE RECOVERY TOOL FOR POST OFFICE

DB Recovery Tool By Dinesh

A handy tool to recover your corrupt database using queries!
It helps you to recover you corrupt SQL database using queries mentioned in it. A backup is obviously preferred but if that doesn't work, this tool may help you! Click here to download it or click here for latest updates.
  • Click Config Button to configure your Server details and restart the application. 
  • Then select any of the Database listed below or check "None of Below DB" to enter database name manually. 
  • First Check the status of database clicking Status and Check Button (using DBCC Check Command). 
  • Then click Recover button to recover database. All the queries have been given in About form (Click About Link). 
  • Various database status has been explained under "?" button and for SQL proficient User advance mode has also given if none of the other options in tools recover the database. 
  • Write me back if you find it useful.

Download DB Recovery Tool


Download

Developed by Dinesh Kumar Asotra, System Manager Una

DPT FIX VERSION 4.1 DOWNLOAD FROM GOOGLE DRIVE

DPT Fix V4.1 Download

Developed by Rajesh C R Version : 4.1 dated 12.12.2014

 More Options Are Added

  • RD Unpaid Default fee in DB Analyzer Discrepancies
  • RD Paid Unpaid DF in DBA.
  • RD Mismatch in month count.
  • Account Linked as agent but not having agent details.
Special Characters in name and address fields.

Download DPT Fix V4.1

NOT ABLE TO OPEN NEW ACCOUNT IN TD DATA ENTRY MODULE

Problem With TD Data Entry V7.5 Patch 8.1

After Update Patch 5 or Patch 6 or Patch 8 or Patch 8.1
  • Not able to Open New Account.
  • Could not click on Amount field.

Solution : TD Data Entry

In Sanchay Post 7.5 after service pack 1 update we are unable to access TD Data entry.

  • Use Data Entry Module alone in Sanchay Post 7.5
Note: This is only for TD Data Entry

Download

RE-ESTABLISH CONNECTION BETWEEN CLIENT AND AV SERVER

Reestablished Connection Between Symantec Antivirus And AV Server

If the required FW port 8014 is open (Secar Test is successful.) and SEP client is not getting updated. You need to follow these steps:-
  • Open the AV client and click on ‘Help’
  • Click on ‘Troubleshooting’
  • If the Server is in ‘Offline’ mode
  • In such case, you need to download Symantec Communication Updater (SCU) using following URL

Download SCU

  • Extract zip file and you will get the following files.
  • Double Click on ‘SylinkDrop.exe. The connection will be re-established.

Amendment to Rule 3 of CCS (Conduct) Rules, 1964, Need for code of Ethics and Values of Civil Services.

Amendment to Rule 3 of CCS (Conduct) Rules, 1964, Need for code of Ethics and Values of Civil Services.

Click Here to view

Introduction of Bio-Metric Attendance

Press Information Bureau 
Government of India
Ministry of Personnel, Public Grievances & Pensions

11-December-2014 14:44 IST
Introduction of Bio-Metric Attendance

It has been decided to use an AADHAR Enabled Bio-metric Attendance System (AEBAS) in all offices of the Central Government, including attached / sub-ordinate offices, in India. An Office Memorandum dated 21st November, 2014 regarding introduction of AEBAS by the Government has been issued in this regard.

The system will be installed in the offices located in Delhi / New Delhi by 31st December, 2014. In other places this will be installed by 26th January 2015. The manual system of marking of attendance will be phased out accordingly.

This was stated by the Minister of State for Personnel, Public Grievances & Pensions, Dr. Jitendra Singh in a written reply to Smt. Ambika Soni and Dr. T. Subbarami Reddy in the Rajya Sabha today.

Proposed revision in the Recruitment Rules (RRs) of Indian Postal Service, Group 'A'

To view Directorate's memo No.4-10/2013-SPG dated 11th December, 2014 please CLICK HERE

Modified Assured Career Progression Scheme for the Central Government Employees – Clarification issued by Dopt on 10.12.2014

Recommendations of the Screening Committee henceforth be placed before the Appointing Authority of the post in both cases where the Committee is constituted in the Ministry/Department or in other cases for approval with regard to grant of financial upgradation under MACP Scheme.

No.35034/3/2008-Estt(D) (Vol.II)
Government of India
Ministry of Personnel, Public Grievances and Pensions
(Department of Personnel and Training)
New Delhi 110001
Dated the 10th December, 2014

OFFICE MEMORANDUM

Subject:- Modified Assured Career Progression Scheme for the Central Government Employee-Clarification regarding.

The undersigned is directed to invite reference to the Para 5 of the Modified Assured Career Progression Scheme issued vide the Department of Personnel and Training Office Memorandum No. 35034/3/2008-Estt.(D) dated May 19, 2009 providing that the recommendations of the Screening Committee shall be placed before the Secretary in cases where the Committee is constituted in the Ministry/Department or before the Head of the organisation/competent authority in other cases for approval.

2. References have been received from various Ministries/Departments with regard to delegation of powers of Secretary to a Joint Secretary level officer as a large number of files on various matters are referred to the Secretary for approval and it is an administrative matter of routine nature which can be disposed of at the level of Joint Secretary.

3. The matter has been considered in this Department and it has been decided that the recommendations of the Screening Committee henceforth be placed before the Appointing Authority
of the post in both cases where the Committee is constituted in the Ministry/Department or in other cases for approval with regard to grant of financial upgradation under MACP Scheme.

4. Ministries/Departments are requested to bring these instructions to the notice of all concerned including their attached and subordinate offices.

sd/-
(Mukta Goel)
Director(E-I)


Source : http://ccis.nic.in/WriteReadData/CircularPortal/D2/D02est/35034_3_2008-Estt.D_Vol.II-10122014.pdf

Guidelines on Referral System in CGHS

The referral system in CGHS is based on the following set of guidelines-


Treatment at CGHS empanelled hospitals

I.                   Treatment under medical emergency:  

No referral is required and beneficiary can directly go to any private empanelled hospital for availing treatment. 

II.               Elective treatment at Empanelled  hospitals in Delhi/NCR : 

-         CGHS/Government Specialist advises specific treatment procedure required. Permission letter has to be obtained from CGHS Wellness centre /Addl. Director of CGHS in case of pensioners, ex-MPs, etc., and from the department in case of serving employees for undergoing the treatment at any of the CGHS empanelled   hospitals of his /her choice. 

-         In satellite towns of NCR, viz., Faridabad, Ghaziabad, Gurgaon and Noida, CMO i/c of CGHS Wellness centres can refer the CGHS beneficiaries directly to private empanelled hospitals for treatment and management. In such cases permission for specific treatment procedure is to be obtained from competent authority i.e., from CGHS in case of pensioners, etc., and from the department in case of serving employees. 

III.            Treatment at Empanelled hospitals in other CGHS covered cities outside Delhi/NCR :

-         CGHS beneficiaries must compulsorily be referred to Polyclinics wherever set up by the CGHS.  On the advice/opinion of the Specialists/ Post graduate GDMOs, CMO In-charge, AD/ JDs may refer CGHS beneficiary to private empanelled hospitals of the choice of the beneficiary. 

-         In those cities which do not have polyclinics and if GDMOs who are post Graduate are available, their services as specialist may be utilized and patients may be referred to the dispensary in which such PG. GDMOs are posted or if space is available in a centrally located dispensary, the PG GDMOs may be posted there.


-         In the event of neither a specialist nor PG GDMO is available in a city CMO In-charge shall make a provisional diagnosis and refer the patients to private empanelled hospital for specialist consultation. If any specific treatment/ procedure is advised (except in emergency) by private empanelled hospital, It must be counter-signed by CMO I/c before the services are availed to check possible misuse. 

The processes of referral through Government/ CGHS specialists provide a check and balance in the system, so far as correct diagnosis and treatment is concerned.

The MoS, Ministry of Health and Family Welfare, Shri Shripad Yesso Naiks tated this in a written reply in the Lok Sabha here today.

Source : PIB

AGENT PORTAL IN FINACLE - FAQ

    AGENT PORTAL

(i) What is the procedure to get eBanking User Id and Password?

Solution: eBanking user ID and Password will be forwarded on the day of migration by DMCC team only for agents (MPKBY/SAS/PRSS) who were linked with SB account in Sanchay Post. For agents created in Finacle after migration , DSA ID along with SOL ID and other mandatory details should be sent to fsihelpdesk for generation of eBanking User Id and Password.

(ii) eBanking user Id and Password created in wrong name.

Solution: eBanking user id and password will be generated in the name of the Primary (First) account holder of the linked SB commission credit account. Suppose an MPKBY agent Kala has linked Joint Account as commission credit account with Primary(First) account holder name as Ravi, eBanking user id will be generated in the name of RAVI only and not in the name of Kala. This will not have any effect anywhere. If the agent wants eBanking User Id generated in their own name, either single account should be given as commission credit account or their name should be primary account holder in Joint accounts. This is added as a discrepancy in DBA Plus

(iii) Unable to Login. Please try again or contact bank for more details – Agent Portal 

Solution: Either the user name / password is incorrect or Agent portal not functioning. Agent portal will not function when the Finacle Core is down

(iv) What to do when Agents User ID and password is locked due to wrong entry of 
       password for more than ten times. 

Solution: Password will get locked if entered wrongly for 10 times. Agent should contact their 
respective Post office and in turn PO will raise a request to CPC who in turn will raise ticket with FSI helpdesk with details of DSA ID and SOL ID to get the password reset for the agents. Agents should not contact Help Desk directly.



(v) Whether SAS agents can use Agent Portal?

Solution: SAS agents will also be provided with eBanking User Id and Password. SAS agents can logon to portal but no accounts will be linked to these agents. This DSA ID to be noted on the account opening form for getting the commission credited to their SB accounts. 

(vi) Agent Portal Host Error

Solution: Agent Portal is down or Finacle server is down. Try after sometime.

(vii) Agent Portal could not be logged on in newly migrated offices

Solution: Ensure whether the port access for accessing the agent portal is given by SIFY. 

(viii) eBanking User Id and Password is generated more than once for many agents

Solution: eBanking user Id and Password will be generated for all the agents migrated to finacle including license expired agents / duplicate agent id. In order to avoid this, ensure that the license expired agents and duplicate IDs are not linked with SB account number.

(ix) No RD accounts are linked while logging in to portal

Solution:

During Go Live Migration - Transformation Layer, Agent Reconciliation excel sheet is shared with the Postmaster to ensure 100% migration of agents. Finacle DSA ID, Agent Type and number of accounts columns are available. Postmaster to check the correct DSA ID from Reconciliation Excel and logon by using that DSA ID before raising the issue.Suppose if a single agent is having both SAS and MPKBY. Two ebanking user Id and Password will 
be generated. Use the appropriate eBanking User Id. Suppose three more eBanking user Ids are generated for the same agent due to duplicate IDs in Sanchay post, logon with appropriate eBanking user ID.

(x) Some RD accounts are not linked / not visible in the Agent Portal

Solution: Discontinued / Closed accounts will not be visible in Agent Portal. Ensure that RD account was linked to correct Agent in Sanchay Post. Inquire the RD account using CRDACM menu to check the DSA ID linked. If any account is not linked to any agent, user should link that account with correct 

DSA ID by using CRDACM menu.

(xi) How to prepare Bulk list with default fee 

Solution:

a. Default fee is automatically fetched from Finacle Core and displayed in separate column 

b. Suppose in one account there are 4 months default, only one month default will be shown 

c. If the customer wants to pay more than one defaults, in the edit screen , click on radio 

d. Enter the number of months to be paid and click on “Get Default and Rebate”. System will 

e. Click on Save

f. In the first part of the screen against the RD account, new default fee will be displayed 

g. Once all the accounts are selected and edited, click on “Pay all modified instalments” to 
     generate the eBanking bulk reference number.

(xii) How to prepare Bulk list with Rebate 

Solution:

Rebate is automatically fetched from Finacle Core and displayed in separate column “Rebate”

a. Rebate will be calculated if, 6 or more months instalments are paid. If the customer wants pay more than one month instalment, in the edit screen , click on radio button in the appropriate RD account .

b. Enter the number of months to be paid and click on “Get Default and Rebate”. System will 

c. Click on Save

d. In the first part of the screen against the RD account, Rebate will be displayed and the ‘     MODIFIED” column will become “YES”

e. Once all the accounts are selected and edited, click on “Pay all modified instalments” to 
    generate the eBanking bulk reference number.

(xiii) Whether the Default fee and Rebate to be added in the cheque?

Solution: In the DOP/Non Dop cheque, Default fee should be added and Rebate to be deducted along with monthly instalments. Suppose in an account with Rs.200/- denomination, there is a default of one month. If the customer wants to get rebate, 6 months instalments has to be paid. Already one default is there. Hence the customer should pay 7 months instalments to get rebate.

200 x 7 = Rs.1400, plus Default fee – Rs.2/- less rebate – Rs.12

Total cheque amount – 1400 + 2 – 12 = Rs.1390/-

(xiv) In case of cheques, can the default fee accepted as cash and monthly instalments as cheque?

Solution: No. Partial cash and partial cheque not allowed. While posting system will check 
for the total amount (Monthly instalment plus Default less Rebate) for that account. If there is 
a difference, an error “CHEQUE NOT CLEARED” will be thrown.

(xv) Process of posting Non DOP cheques

Solution:

(a) It is presumed that the MPKBY agent has prepared the bulk list NDC34245 using Non DOP option with all required details like BANK NAME, CHEQUE NUMBER ) When an agent prepares the bulk list with cheque number with 0 as prefix, 0s are truncated while storing in agent portal. 

(b) If the cheques are not handled through outward clearing, the following process should be (PLEASE NOTE: This process should not be followed if OUTWARD CLEARING PROCESS is followed)


Solution:

a. User to invoke CXFER MENU in finacle.

b. Debit SBI (Sundry) account( SOL id followed by 0007 as debit account eg 

600002000007)

c. Credit the following account 

d. RD Retail / Bulk – SOLID0017 (Outward Clearing account)

e. For RD Retail / Bulk the cheque number SHOULD BE ENTERED in the Transaction   Particular field (CXFER) without fail as described below

Procedure

i) Invoke CXFER , Dr Acct and Cr Account as above and

ii) Enter the cheque number in the “Transaction Particulars” field by removing 

iii) Cheque number should be of 6 digits

iv) Cheque number should be entered without prefix 0 (ie) cheque number 

f. To ensure that the amount of Bulk list is credited, Invoke HACLINQ and enter the Outward Clearing Account Number SOLID followed by 17.(0017)

g. Ensure that the Bulk list amount is credited along with the cheque details in the remarks column. the word “BY TRANSFER”00234 should be entered as 234.


(xvi) Truncation of 0 

Since 0s in cheque number are truncated in outward clearing, while preparing the bulk list also the 0s are truncated while storing even if the cheque number is entered with 0 prefix. 

(xvii) Agent cannot generate bulk list for more than Rs.10,000/- if mode is payment is Cash

Solution: An error will be thrown if agent tries to generate bulk list for more than Rs.10,000/- if the mode of payment is CASH. For DOP and Non DOP cheques there is not limit. But in a list only 50 accounts can be selected.

(xviii) How many accounts can a bulk list contain?

Solution: A bulk list should contain maximum of 50 RD accounts or it should not exceed Rs.10,000/- if paid in cash whichever is applicable

(xix) Can a cheque paid for more than one account?

Solution: Single Cheque can be paid for multiple accounts. Suppose if there are 8 RD accounts in the list and serial number 2, 4, 7 are paid by same cheque eg INDIAN BANK CHEQUE with cheque number 002345.

Click on 2nd INDIAN BANK as IND BANK, enter the cheque number – 002345 , account no for RD instalment – Indian Bank Savings Bank account number of this cheque eg 643567 (This field will not be validated). Click on Save.


Click on 4th RD account, enter the BANK NAME in the field. Enter the bank name as IND BANK only as entered in the 2nd account ( Here the bank name should not be entered as IND. BANK or IND BK or any other format. The bank name entered here should be exactly equal to the Bank name entered in the 2nd record), enter the cheque number – 002345 , account no for RD instalment – Indian Bank Savings Bank account number of this cheque eg 643567 (This field will not be validated). Click on Save.

 Click on 7th RD account, enter the BANK NAME in the field. Enter the bank name as IND BANK only as entered in the 2nd account. (Here the bank name should not be entered as IND. BANK or IND BKor any other format. The bank name entered here should be exactly equal to the Bank name entered in the 2nd record), enter the cheque number –002345 , account no for RD instalment – Indian Bank Savings Bank account number of this cheque eg 643567 (This field will not be validated) Click on Save.



(xx) Agent ID gets blocked

Solution: Agent ID gets locked when the password is entered wrongly for 10 times. 

(xxi) At Nagpur City Ho 440002 there comes error while verifying lot.Lots are prepared by agent on 16/03/2014 in there prepared list default does not shown. Counter PA accept the lot on counter and send the lot for verification. But at the time of verification the it shows different types of error that does not exist, default fee is different etc. Due to which lot not verified. 

Solution: Suppose agent prepares bulk list (Cash Mode) on 8th to 15th from 1st

. Finacle will calculate Default fee when the Agent presents the same bulk list at PO counter after 

 . When the operator tries to the post the Bulk list, only those accounts without default fee will get 

posted and accounts with default fee will be rejected. Remarks “ERROR - DEFAULT FEE/REBATE 

CALCULATION INCORRECT” will be thrown. New bulk list need to be prepared for those rejected 

accounts .

(xxii) How many accounts will be displayed per page in the portal?

Solution:- 10 accounts will be displayed per page. Total number of accounts linked to the agent will be displayed as 10 of 247 on the right side corner. Only first 500 accounts will be listed in the first screen. If there are more number of accounts, click on the option “Click here to fetch more accounts”, another set of 500 accounts will be displayed and by clicking this option, any number of accounts can 

 RD account, enter the BANK NAME in the field. Suppose you enter the bank name 

 account ( Here the bank name should not be entered as IND. BANK or IND BK 

 account. (Here the bank name should not be entered as IND. BANK or IND BK 

 wherein few RD accounts opened dates are available. No default fee will be generated during bulk list generation on be displayed in the portal

(xxiii) Can the RD accounts be sorted account number wise enabling easy selection of 
account for generation of bulk list

Solution:-When we click on the Account Number column, the RD accounts will get sorted either by ascending order or by descending order. Agent can select the required RD accounts by browsing through the pages. Agent can directly move to required page by entering the required page number and click on Go.Agents can use any of the below three options for searching

a. Sort the account numbers and select the accounts manually by browsing through the 

b. Entering the RD account number in the Searcher field. This option can be used to select 

c. Click on the File icon on the top right corner. Soft copy of the entire list of account will be 
only one record.displayed. Required RD account can be searched using Find option (Ctrl + F) and thereby exact page number can be identified and can directly move to the respective page and select the RD account.(gopi – icon)

(xxiv) The Fonts in the portal are very small. Is there any option to increase the size of the 

There are three Font icons on the top right corner. Click on the icon to increase or decrease the font.

(xxv) Agent portal session ends frequently. Not able to generate even a single bulk list.

Agent Portal session will automatically logout in 30 minutes if remains idle. There will be a message alerting the user to “Continue the session” for another 30 minutes. By continuing the session agent can remain the portal for hours together.

(xxvi) All the Ebanking reference numbers are printed together while taking print out of E 

Banking Lists:-

Click on the Reports – Enter the from and to date – enter the required eBanking reference number – 
select the status as Success and click on Search. Only the required eBanking reference number with 
Success status will be listed. Select the downloadable format either pdf or .xls and click on OK. RD Instalment report with the required eBanking reference number can be either saved or printed.

(xxvii) Can an agent pay the default fee alone by cash and monthly instalment by cheque.

No, agent cannot pay the bulk list partially by cash and partially by cheque. Default fee should be added in the cheque itself. The bulk list will be posted only if the cheque number matches with the entire amount (monthly instalment along with default fee)

(xxviii) Is it compulsory to change the login password for the agent portal?

Yes. The agent should change the login password once in 180 days.

(xxix) Can the RD accounts linked to agent be paid across the counter?

Agent linked accounts cannot be paid across the counter. An error will be thrown while accepting the RD deposit across the counter. However if the customer still wants to pay across the counter, the Counter PA can delink the Agent DSA ID using CRDACM menu and after verification, accept the monthly deposit. Agent commission will not flow as the account is delinked from agent ID. For this purpose, depositor has to submit application in manuscript. 

(xxx) Suppose a customer with RD account of Rs.5,000/- denomination want to pay for one year. How to prepare bulk list (Cash) with Rebate for denomination of Rs.5000/- 

Solution: Prepare two Cash bulk list for two months simultaneously. Each bulk list will have two 
months with Rs.10,000/-. These two bulk list needs to be posted. On successful posting of two 
list only, Agent should prepare the third list for two months. While preparing the 3rd
show rebate as 6thpresented for posting in the counter.Please do not prepare THREE LIST simultaneously in the above scenario. Only two list to be prepared and third list to be prepared on successful posting of two lists.

(xxxi) “Host not available” in Agent Portal on clicking the “AGENT ENQUIRE AND UPDATE SCREEN”


Technical issue due to Network/Port access. Check the portal after few hours