id |
int(11) |
|
|
|
|
mst_www_userid |
int(11) |
|
|
|
|
emp_site |
varchar(10) |
latin1_swedish_ci |
|
|
|
employment_type |
varchar(15) |
latin1_swedish_ci |
|
|
|
employee_type |
varchar(15) |
latin1_swedish_ci |
|
|
|
emp_code |
varchar(40) |
latin1_swedish_ci |
|
|
|
emp_name |
varchar(100) |
latin1_swedish_ci |
|
|
|
fh_name |
varchar(100) |
latin1_swedish_ci |
|
|
|
nationality |
varchar(50) |
latin1_swedish_ci |
|
|
|
religion |
varchar(50) |
latin1_swedish_ci |
|
|
|
dob |
date |
|
|
|
|
doj |
date |
|
|
|
|
dol |
date |
|
|
|
|
department |
varchar(20) |
latin1_swedish_ci |
|
|
|
emp_shift |
int(11) |
|
|
|
|
emp_weekly_off |
int(11) |
|
|
|
|
designation |
varchar(20) |
latin1_swedish_ci |
|
|
|
marital_status |
varchar(10) |
latin1_swedish_ci |
|
|
|
marriage |
date |
|
|
|
|
wh_name |
varchar(50) |
latin1_swedish_ci |
|
|
|
sons |
int(5) |
|
|
|
|
daughters |
int(5) |
|
|
|
|
sex |
varchar(10) |
latin1_swedish_ci |
|
|
|
grade |
varchar(20) |
latin1_swedish_ci |
|
|
|
personalEmail |
varchar(255) |
latin1_swedish_ci |
|
|
|
offEmail |
varchar(255) |
latin1_swedish_ci |
|
|
|
PFno |
varchar(50) |
latin1_swedish_ci |
|
|
|
ESIno |
varchar(50) |
latin1_swedish_ci |
|
|
|
leave_eff_date |
date |
|
|
|
|
bachelor |
varchar(10) |
latin1_swedish_ci |
|
|
|
other_bachelor |
varchar(60) |
latin1_swedish_ci |
|
|
|
master |
varchar(10) |
latin1_swedish_ci |
|
|
|
other_master |
varchar(60) |
latin1_swedish_ci |
|
|
|
basic_perc |
double(10,2) |
|
|
|
|
basic_salary |
double(10,2) |
|
|
|
|
allow_tot |
double(10,2) |
|
|
|
|
deduct_tot |
double(10,2) |
|
|
|
|
gross_sal |
double(10,2) |
|
|
|
|
gross |
double(16,2) |
|
|
|
|
net_sal |
double(10,2) |
|
|
|
|
eff_sal_date |
date |
|
|
|
|
pf_calculation |
varchar(20) |
latin1_swedish_ci |
|
|
|
adv_amount |
double(10,2) |
|
|
|
|
adv_date |
date |
|
|
|
|
over_time |
varchar(5) |
latin1_swedish_ci |
|
|
|
overtime_salary |
double(10,2) |
|
|
|
|
image |
varchar(30) |
latin1_swedish_ci |
|
|
|
document2 |
varchar(50) |
latin1_swedish_ci |
|
|
|
document3 |
varchar(50) |
latin1_swedish_ci |
|
|
|
document |
varchar(30) |
latin1_swedish_ci |
|
|
|
bank_account |
varchar(100) |
latin1_swedish_ci |
|
|
|
bank_name |
varchar(100) |
latin1_swedish_ci |
|
|
|
ESI_account |
varchar(100) |
latin1_swedish_ci |
|
|
|
PF_accountno |
varchar(100) |
latin1_swedish_ci |
|
|
|
payment_mode |
varchar(10) |
latin1_swedish_ci |
|
|
|
created_by |
varchar(10) |
latin1_swedish_ci |
|
|
|
created_date |
date |
|
|
|
|
CompanyId |
int(10) |
|
|
|
|
blocked |
int(11) |
|
|
|
|
bloodgroup |
varchar(50) |
latin1_swedish_ci |
|
|
|
course1 |
varchar(50) |
latin1_swedish_ci |
|
|
|
course2 |
varchar(50) |
latin1_swedish_ci |
|
|
|
course3 |
varchar(50) |
latin1_swedish_ci |
|
|
|
pf_Reimbursement_per |
double(10,2) |
|
|
|
|
pf_Reimbursement |
double(10,2) |
|
|
|
|
medical_Reimbursement_per |
double(10,2) |
|
|
|
|
medical_Reimbursement |
double(10,2) |
|
|
|
|
tenth_standard |
varchar(10) |
latin1_swedish_ci |
|
|
|
tenthplus2_standard |
varchar(10) |
latin1_swedish_ci |
|
|
|
pending_wo |
int(4) |
|
|
|
|
multi_site_att |
int(1) |
|
|
|
|
otapplicable |
varchar(255) |
latin1_swedish_ci |
|
|
|
ottype |
varchar(255) |
latin1_swedish_ci |
|
|
|
auth |
enum('yes', 'no') |
latin1_swedish_ci |
|
|
|
status |
varchar(6) |
latin1_swedish_ci |
|
|
|
loan_ledger |
int(11) |
|
|
|
|
advance_ledger |
int(11) |
|
|
|
|
staff_type |
varchar(20) |
latin1_swedish_ci |
|
|
|
biomatric_id |
int(11) |
|
|
|
|