id | int(11) |
|
|
|
emp_id | varchar(10) |
|
|
|
pay_month | varchar(10) |
|
|
|
financial_year | varchar(10) |
|
|
|
pay_date | date |
|
|
|
da_arrear | varchar(20) |
|
|
|
ta_arrear | varchar(20) |
|
|
|
hra_arrear | varchar(10) |
|
|
|
pay_arrear | varchar(20) |
|
|
|
bonus | varchar(20) |
|
|
|
honorarium | varchar(20) |
|
|
|
remuneration | varchar(20) |
|
|
|
consultancy_fee | varchar(10) |
|
|
|
ota | varchar(20) |
|
|
|
el_encashment | varchar(20) |
|
|
|
spl_encash | varchar(20) |
|
|
|
tuition_reimburse | varchar(20) |
|
|
|
medical_reimburse | varchar(20) |
|
|
|
fixed_med_allow | varchar(5) |
|
|
|
tds_refund | varchar(20) |
|
|
|
hpl | varchar(20) |
|
|
|
convey_allow | varchar(10) |
|
|
|
oth_refund | varchar(20) |
|
|
|
ded_refund | varchar(20) |
|
|
|
contrib_nps_uni | varchar(10) |
|
|
|
date_created | datetime |
|
|
CURRENT_TIMESTAMP
|
date_modified | datetime |
|
|
CURRENT_TIMESTAMP
|