Navigation Path:
Finance -> Data Validation – DDO -> Post Master Data Validation

Upl
|
District
|
To Code
|
DDO Code
|
Office Name
|
CPS/GPF/TPF Number
|
|
Text
|
Text
|
Text
|
Text
|
Text
|
|
KARUR
|
2801
|
MB201
|
DEAN GOVERNMENT MEDICAL COLLEGE,KARUR
|
7131607/MEDL
|
Employee name and PAN (10 digit) details shall be corrected / added if not available.
Employee Number
|
Employee Name
|
Corrected Employee Name
|
PAN Number
|
Corrected PAN Number
|
Text
|
Text
|
Text
|
Text
|
Text
|
19030061517
|
Nandhakumar B
|
|
AEWPN8120N
|
|
DOB, DOJ in service and employee type should be corrected if wrongly entered. Based on DOJ, employee GPF/CPS element would be attached.
Rule:
DOJ <= 01-04-2003 – GPF Element. DOJ >= 01-04-2003 – CPS Element
Based on Employee Type, rules would be applicable for pay components (Dues and Deductions for IAS, Judicial, ICDS, NMP employees etc.).
DOB
|
Corrected DOB
|
DOJ
|
Corrected DOJ
|
Employee Type
|
Corrected Employee Type
|
Date
|
DD-MON-YYYY
|
Date
|
DD-MON-YYYY
|
Text
|
List - Text
|
29-Dec-1975
|
|
01-Nov-2006
|
01-Nov-2006
|
TN GOVT SERVENT
|
|
If post is wrongly mapped, it can be corrected in corrected post column.
Post Name
|
Post Type
|
HOA
|
GO Number and Date
|
Corrected Post Name
|
Text
|
Text
|
Text
|
Text
|
List - Text
|
Tutor / Senior Assistant Surgeon Rank| |1483572
|
Temporary
|
221005105CB
|
G.O.MS.NO.142/H&FW(E2) DEPT 02-APR-2019
|
|
If HRA (Due / Deduction) value is not correct, it can also be corrected.
Residence Type
|
Corrected Residence Type
|
Quarters Type
|
Corrected Quarters Type
|
Text
|
List - Text
|
Text
|
List - Text
|
Occupying Own or Private Rented House
|
|
|
|
If bill group is wrongly tagged, that shall be corrected.
Rented Quarter City Grade
|
Corrected Rented Quarters City Grade
|
Bill Group
|
Corrected Bill Group
|
Text
|
List - Text
|
Text
|
List - Text
|
|
|
TEMPORARY 142
|
|
Medical Allowance eligibility flag should be corrected as “Yes“ if marked as “No”. Only if Flag is “Yes”, Medical Allowance component would be attached for employees.
Medical Allowance
|
Corrected Medical Allowance
|
Grade Name
|
Corrected Grade Name
|
Text
|
List - Text
|
Text
|
List - Text
|
Y
|
|
TNGS Time Scale.Level 23 (56900 - 180500)
|
|
EL & GPF balance shall be provided as on Dec 19.
Transferred TO Code
|
Transferred DDO Code
|
Transferred Office Name
|
Earned Leave Balance as on 01-Dec-2019
|
GPF Balance as on 01-Dec-2019
|
Text
|
Text
|
List - Text
|
Number
|
Text
|
|
|
|
128
|
|
If any Pay is corrected, then Pay Reason and Salary Effective date is Mandatory. Without that, pay will not be updated.
PAY
|
Corrected PAY
|
Pay Reason
|
Corrected Pay Reason
|
Salary CHANGE_DATE
|
Corrected Change Date
|
Number
|
Number
|
Text
|
List - Text
|
Date
|
DD-MON-YYYY
|
83600
|
86100
|
Annual Increment
|
|
01-Oct-2019
|
01-Apr-2019
|
NEXT_INC_DATE
|
Corrected Next Increment Date
|
Personal Pay
|
Corrected Personal Pay
|
Date
|
DD-MON-YYYY
|
Number
|
Number
|
01-Oct-2020
|
|
|
|
Duplicate Flag?
If an Employee id has been generated multiple time with same CPS/GPF/TPF, the number shall have “Yes“ duplicate flag. Wrong employee id has to be deleted from respective office.
For Transfer, Death, Retirement and Deputation, Duplicate flag should not be used. If used, they shall be provided for Audit L1 & L2 where remarks have to be provided.
Transfer Flag, Transferred TO Code, Transferred DDO Code & Transferred Office Name:
If an employee has been transferred to another office, Transfer flag shall be marked as “Yes”. Enter the details for respective office, Transferred TO Code, Transferred DDO Code and Transferred Office name.
Special Pay
|
Corrected Special Pay
|
Duplicate Flag?
|
Transfer Flag
|
DDO Verified?
|
Number
|
Number
|
List - Text
|
List - Text
|
* List - Text
|
|
900
|
No
|
N
|
Yes
|
Employee Type:
House Rent Allowance: Based on Residence Type, HRA and Recovery would be calculated.
Residence Type:
Quarters Type:
HRA City Grade:
Grade Name:

Data Validation Analysis on Corrected Data
1. Office Master:
1) Abbreviated names of Offices of Treasury Department (ST, DT & PAOs) are to be expanded. Except for the Treasury department offices, others can be corrected.
2. Position Master:
1) In one of the Block Educational Office, the Head Master Post is updated as Secondary Grade Teacher or BT Assistant. Also, Secondary Grade Teacher or BT Assistant is updated as Head Master. 2) Grade/ Groups in the Post Name should be updated in the Unit Name. If the updated Unit Name is not required, correcting/removing the same will be made possible. 3) While selecting the Post Title, the proper Items from the list should be selected. Incorrect List values will be removed from the list. 4) Values in HOA need to be updated properly as user may have entered 2 digits instead of full HOA code.
3. Employee Master:
1) Please enter values in the correction Field only when a correction is required. This is applicable for all the Columns given for correction in all the 3 masters. Eg:
EMPLOYEE NUMBER
|
FULL NAME
|
FULL NAME CORRECTED
|
43020044383
|
Jayakodi L
|
Jayakodi L
|
43020044384
|
Chithra P
|
Chithra P
|
43020044382
|
Jayaprakash V
|
Jayaprakash V
|
2) In case of Employee Retirement, please update correction values only. Eg. of wrong entries:
EMPLOYEE NUMBER
|
FULL NAME
|
FULL NAME CORRECTED
|
12020148948
|
Subramanian V
|
Retirement
|
05050071466
|
Leelavathi R
|
double entry
|
43030020215
|
Kandasamy P
|
DEATH
|
3) Difference in DOB is high. Users need to validate the same.
EMPLOYEE NUMBER
|
DOB
|
DOB CORRECTED
|
DOB WEB PAYROLL
|
41020526926
|
24-DEC-1985
|
02-MAY-1970
|
24-DEC-1985
|
4) Difference in DOJ is also high and requires validation. On changing the DOJ, Salary Effective date should be updated properly.
EMPLOYEE NUMBER
|
DOJ
|
DOJ CORRECTED
|
43020064972
|
03-AUG-1995
|
12-JUN-2018
|
42020050231
|
01-DEC-1996
|
29-OCT-2014
|
45040552597
|
01-SEP-2017
|
09-MAY-1985
|
43030060795
|
11-JUL-1991
|
05-AUG-2011
|
42020990611
|
27-APR-2018
|
01-DEC-1996
|
5) Past Dates are being entered in the Next Increment Date.
EMPLOYEE NUMBER
|
NEXT INCREMENT DATE
|
NEXT INCREMENT DATE CORRECTED
|
41020050290
|
01-APR-2020
|
01-APR-2016
|
41020044666
|
01-JUL-2020
|
01-APR-2017
|
41020050345
|
01-APR-2020
|
01-APR-2017
|
03010563939
|
01-JAN-2020
|
01-APR-2019
|
41020050292
|
01-APR-2019
|
01-APR-2018
|
6) Employees are tagged as Duplicates in offices where only one employee is available against the CPS Number/Name-DOB combination. 650 Employees are tagged as duplicates in Karur District and the same has to be validated.
In the below example, only 3 employees are available in the office and one of them is tagged as Duplicate.
TO CODE
|
DDO CODE
|
OFFICENAME
|
EMPLOYEE NUMBER
|
FULL NAME
|
DUPLICATE FLAG
|
SRNO
|
2803
|
RE405
|
16 GOVERNMENT HIGH SCHOOL, PERIYAKULATHUPALAYAM
|
42020043433
|
Banumathi K
|
No
|
5083030/NMP
|
2803
|
RE405
|
16 GOVERNMENT HIGH SCHOOL, PERIYAKULATHUPALAYAM
|
42020043432
|
Nagalakshmi R
|
No
|
5083029/NMP
|
2803
|
RE405
|
16 GOVERNMENT HIGH SCHOOL, PERIYAKULATHUPALAYAM
|
42020073236
|
Valarmathi M
|
Yes
|
5100015456/NMP
|