|
id
|
int(11)
|
|
|
|
|
emp_id
|
int(11)
|
|
|
|
|
pen_id
|
varchar(6)
|
latin1_swedish_ci
|
|
|
|
Name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Gender_tmp
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
Father_Name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Mother_Name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Marital_Status
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
Spouse_Name
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Nationality
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
Category
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
Appointed_Against
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
Religion
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
DOB_tmp
|
date
|
|
|
|
|
Staff_Type
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
Employment_Type
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
Designation_tmp
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
School_tmp
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Department_tmp
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Centre
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Section
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Other_Entities
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
Date_of_Join
|
date
|
|
|
|
|
Superannuation_Date
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
permanent_address
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
permanent_city
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
permanent_state
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
permanent_pincode
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
communication_address
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
communication_city
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
communication_state
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
communication_pincode
|
varchar(500)
|
latin1_swedish_ci
|
|
|
|
mobile_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
phone_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
email_id
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
blood_group
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
disability
|
char(1)
|
latin1_swedish_ci
|
|
|
|
place_of_birth
|
varchar(50)
|
latin1_swedish_ci
|
|
|
|
home_town
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
quitted_service
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
quitted_service_type
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
quitted_service_sub_type
|
varchar(100)
|
latin1_swedish_ci
|
|
|
|
salary_account_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
sav_contrib_type
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
gpf_cpf_nps_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
society_no
|
varchar(5)
|
latin1_swedish_ci
|
|
|
|
pan_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
health_card_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
height
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
personal_identification_marks
|
text
|
latin1_swedish_ci
|
|
|
|
aadhar_no
|
varchar(20)
|
latin1_swedish_ci
|
|
|
|
date_created
|
datetime
|
|
|
|
|
date_modified
|
datetime
|
|
|
|
