Monday, 9 January 2012

CCS (Leave) (Fifth Amendment) Rules, 2011 - “Seamen’s sick leave”

“In the First Schedule to the Central Civil Services (Leave) Rules, 1972, against Sl.No. (I) in column 2 after the words "Seamen's Sick Leave" the words "Paternity Leave, Child Adoption Leave, Paternity Leave for Child Adoption and Child Care Leave: shall be inserted.”
[TO BE PUBLISHED IN THE GAZETTE OF INDIA, EXTRAORDINARY, PART II, SECTION 3, SUB-SECTION (i)]
Government of India
Ministry of Personnel, Public Grievances and Pensions
Department of Personnel and Training
Notification
New Delhi, the, 27.12.2011.
G.S.R. In exercise of the powers conferred by the proviso to article 302 read with clause (5) of article 148 of the Constitution and after consultation with the Comptroller and Auditor General of India in relation to the persons serving in the Indian Audit Accounts Department, the President hereby make the following rules further to amend the Central Civil Services (Leave) Rules, 1972, namely :-
1. (1) These rules may be called the Central Civil Services (Leave) (Fifth Amendment) Rules, 2011.
(2) In the First Schedule to the Central Civil Services (Leave) Rules, 1972, against Sl.No. (I) in column 2 after the words "Seamen's Sick Leave" the words "Paternity Leave, Child Adoption Leave, Paternity Leave for Child Adoption and Child Care Leave: shall be inserted.
sd/-
(Mamta Kundra)
Joint Secretary
Source: www.persmin.nic.in
[http://circulars.nic.in/WriteReadData/CircularPortal/D2/D02est/13026_4_2011-Estt-L-27122011.pdf]

A more detailed definition is given in the brochure of Central Civil Services (Leave) Rules, 1972 about the Seamen’s sick leave...
47. Seamen’s sick leave
(1) A Government servant serving as an officer, warrant officer or petty officer on a Government vessel may, while undergoing medical treatment for sickness or injury, either on his vessel or in hospital, be granted leave, by an authority competent to grant leave, on leave salary equal to full pay for a period not exceeding six weeks:
Provided that such shall not be granted if a Government Medical officer certifies that the Government servant is malingering or that his ill health is due to drunkenness or similar self-indulgence or to his own action in will fully causing  or aggravating disease or injury. 
(2) A seaman disabled in the exercise of his duty may be allowed leave on leave salary equal to full pay for a maximum period not exceeding three months, if the following conditions are fulfilled, namely:-
(a) a Government Medical Officer must certify the disability;
(b) the disability must not be due to the seaman’s own carelessness or inexperience’
(c) the vacancy cause by his absence must not be filled.
(3) (a) In the case of a person to whom the Workmen’s Compensation Act, 1923 (8of 1923), applies, the amount of leave salary payable under this rule shall be reduced by the amount of compensation payable under Clause (d) of sub-section (1) of Section 4 of the said Act.
(b) In the case of a person to whom the Employees’ State Insurance Act, 1948 (34 of 1948), applies, the amount of leave salary payable under this rule shall be reduced by the amount of benefit payable under the said Act for the corresponding period.

eMO Communication Error









Sir,
Please do the following carefully.

warning ! Please do the following carefully.


1. stop the eMO Client application if running.
2. Open the data folder Inside RXD Folder of eMO client installation path.
3. Select details option in View menu on the top of explorer.(View->details). All files will be shown with file type and date modified.
4. Sort the files by modified date(Click on date modified column once or twice).
5. Select and cut all the files received on oldest date and time and  copy into to seperate folder on desktop.( these file might be corrupted).
6. Delete all the files with file type qsq_tmp in data folder of rxd.
7. start the eMO client application.
8. Check the eMO after 10-15 minutes.

Inspector Software ( for IPOs / ASPs)










Inspector Software Setup 1.2.0 : Setup

Inspector Version 2.1 : Update

Inspector Version 2.2 : Update

Some basic information about SQL


SQL Essentials


With just a dozen commands and functions, a developer is able to perform most activities related to querying and manipulating a database.
Commands  like  Select , insert , delete  , update , create    
Function  like   Sum ()  Avg ()  Max()  , Min() Count()
The SQL declarations, or commands, are divided into two main categories: DDL and DML
DDL, or data definition language, is the part of SQL used to define the data and objects in a database. When these commands are used, entries are made in a data dictionary in the SQL server. Following are some DDL commands:
Create Table-, Create  Index , Alter Table, Drop Table, Drop Index

DML, the language for manipulating data, is the part of SQL used to recover or manipulate data. Its commands are responsible for the queries and changes made to tables. These are some of the most important commands in this category:
Select , insert  ,  update  rollback
Data  Type  in SQL

Char
Character data type with fixed size of up to 254 characters.
Date
Stores only the date.
Datetime or Timestamp
When part of the input argument is omitted, SQLBase assumes the default 0, which converts the date to 30/12/1899 and 12:00 a.m.
Decimal or Dec
Supports up to 15 digits (999999999999999 to +999999999999999). If nothing is specified, the precision 5 and scale 0 are assumed.
Double precision
Numeric data type of floating-point and double precision.
Float
When the precision is between 1 and 21, the data type will have simple precision. Between 22 and 53, the precision is double.
Integer or Int
An integer data type with precision of up to 10 digits (2,147,483,648 up to + 2,147,483,647).
Long Varchar
Stores characters or binary objects. This is equivalent to the data type blob.
Number
This is a super set from other data types. It supports precision of up to 22 digits.
Real
Numeric data type of floating-point and simple precision.
Smallint
This data type has no fractional digits. The digits to the right of the decimal point are truncated. You can have precision of up to five digits (from 32,768 to +32,767).
Time
Stores only the hour.
Varchar
Character data type with fixed size of up to 254 characters.


Select command is the essence of the SQL language
Basic syntax:

SELECT [*] [ALL | DISTINCT]

[name =] expression

[expression [AS name]]

FROM [correlation_name]

WHERE

[GROUP BY ] ]

[HAVING ]

[ORDER BY [ASC] [DESC]] ]


Selects all the columns in a
table.


ALL
The default in a SELECT command is to recover all the rows.
DISTINCT
Does not show duplicated rows.
expression
A selection list of expressions separated by commas. An expression can be a column name, a constant, a checked variable, the result of a function, or a system keyword.
FROM
Contains the names of the tables or views resulting in a set of rows.
correlation_name

A related name can be used to designate a preceding table or view.
WHERE

Specifies a search condition for the basic tables or views. The search condition cannot contain aggregate functions.
GROUP BY

This clause groups the resulting rows of a query, according to the column names. When the column by which the grouping occurs is an expression with more than one column, you must specify the number that indicates its relative position in the selection list.
HAVING

This clause allows you to establish a search condition with a group of rows resulting from a GROUP BY clause or by grouped columns.
ORDER BY

Specifies the order of rows in a result table. The rows can be ordered by more than one column. When the order column is derived from a function or arithmetic expression, the column must be specified by an integer that indicates the relative number of its position in the SELECT command. Optionally, ASC or DESC, indicating the ascending or descending order, can follow each column name or number.


Instead of showing all the columns, you can request a list of specific columns
This list must contain the names of the columns separated by commas. The order of the columns is not important. The code below selects the columns containing the first name, last name, and telephone number of each author.
 
SELECT au_fname, au_lname, phone FROM authors;

Collected and prepared by S Jayachandran,

Clarification regarding Relaxation for travel by air to visit J&K against All India LTC

Controller General of Defence Accounts,
Ulan Batar Road, PaIam, Delhi Cantt-110010
AN/XIV/14162/VIth CPC/Circular/VoI-IV
Dated: 28/12/2011
To,
All PCsDA/CsDA
(Through CGDA Mail Server)
Sub: Clarification regarding Relaxation for travel by air to visit J&K against All India LTC.
The following doubts regarding admissibility of LTC claim on account of air travel to NER/J&K against all India LTC availed by a Government servant (being non entitled to travel by Air) whose HQrs. Office and home town is the same was taken up with DoP&T for clarification:
(i) Whether an individual who is not entitled to Home Town Concession (due to his HQrs and home town being same) can convert his All India LTC to
visit NER/J&K, and,
(Ii) Whether he will be allowed to travel by air to NER/J&K on conversion of his All India LTC (being non-entitled to travel by air) or not, in terms of
the guidelines laid down In GoI, D0P&T OM No. 31011/4/2007-Estt(A) dated 02.05.2008 and OM No. 31011/2/2003-Estt.(A-IV) dated 18.06.2010.
2. The D0P&T has clarified vide its OM No. 31011/8/2010-Estt.(A) dated 21st December 2011 that “a Government employee can avail All India LTC to visit J&K by air and those who are not entitled to travel by air may be allowed to travel by air to a city in the J&K from Delhi or Amritsar. And journey upto Delhi/Amritsar will have to be taken as per their entitlement.”
This is for your information, guidance and necessary action please.
Please acknowledge receipt.

sd/-
(R.K. Bhatt)
For CGDA