{"iTotalDisplayRecords":"23","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `employee_incentive_id`, `employee_id`, `paid_salary_id`, `incentive_amount`, `incentive_title`, `payable_month`, `incentive_status`, `remarks`, `added_by`, `added_on`, `approved_by`, `approved_on`, `hr_employee_name`, `hr_employee_code`, `hr_employee_department`, `hr_employee_company`, `general_task_department_name`, `added_user_name`, `approved_user_name`, `paid_salary_from_date`\r\n    FROM employee_incentive_view\r\n    \r\n    ORDER BY payable_month ASC\r\n    \r\n    ","aaData":[{"employee_incentive_id":"1","employee_id":"145898173447688900","paid_salary_id":"720","incentive_amount":"100","incentive_title":"iii","payable_month":"2020-11-01","incentive_status":"Approved","remarks":"iii","added_by":"143620071466608200","added_on":"2020-11-09 12:18:03","approved_by":"143620071466608200","approved_on":"0000-00-00 00:00:00","hr_employee_name":"VENKATA RAMANAIAH YETURU","hr_employee_code":"293","hr_employee_department":"13","hr_employee_company":"1","general_task_department_name":"PROCESS EXCELLENCE","added_user_name":"NANJEGOWDA","approved_user_name":"NANJEGOWDA","paid_salary_from_date":"2020-11-01"},{"employee_incentive_id":"2","employee_id":"145898173447688900","paid_salary_id":"0","incentive_amount":"1000","incentive_title":"testttt","payable_month":"2020-11-01","incentive_status":"Reject","remarks":"testingg","added_by":"143620071466608200","added_on":"2020-11-09 12:33:02","approved_by":"143620071466608200","approved_on":"2020-11-09 12:34:31","hr_employee_name":"VENKATA RAMANAIAH YETURU","hr_employee_code":"293","hr_employee_department":"13","hr_employee_company":"1","general_task_department_name":"PROCESS EXCELLENCE","added_user_name":"NANJEGOWDA","approved_user_name":"NANJEGOWDA","paid_salary_from_date":null},{"employee_incentive_id":"4","employee_id":"160267676254326500","paid_salary_id":"826","incentive_amount":"18000","incentive_title":"Monthly Incentive","payable_month":"2020-12-01","incentive_status":"Approved","remarks":"Monthly Incentive","added_by":"144102554647936900","added_on":"2021-01-01 16:41:51","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"RAKSHITH.J","hr_employee_code":"439","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2020-12-01"},{"employee_incentive_id":"5","employee_id":"159853556987468900","paid_salary_id":"0","incentive_amount":"3000","incentive_title":"SOLD IN DECEMBER-2020 MONTH 1 PLOT AND AGREEMENT EXECUTED","payable_month":"2020-12-01","incentive_status":"Reject","remarks":"SOLD IN DECEMBER-2020 MONTH 1 PLOT AND AGREEMENT EXECUTED","added_by":"14589688607813600","added_on":"2021-01-04 11:22:53","approved_by":"144102554647936900","approved_on":"2021-03-02 11:38:43","hr_employee_name":"AVINASH.B.V","hr_employee_code":"423","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":null,"approved_user_name":"JAGANNATH ","paid_salary_from_date":null},{"employee_incentive_id":"3","employee_id":"159853556987468900","paid_salary_id":"750","incentive_amount":"3000","incentive_title":"Monthly Incentive","payable_month":"2020-12-01","incentive_status":"Approved","remarks":"Monthly sales Incentive","added_by":"144102554647936900","added_on":"2021-01-01 16:40:52","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"AVINASH.B.V","hr_employee_code":"423","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2020-12-01"},{"employee_incentive_id":"7","employee_id":"159946638519418800","paid_salary_id":"1215","incentive_amount":"21000","incentive_title":"Feb Incentive","payable_month":"2021-02-01","incentive_status":"Approved","remarks":"Incentive to be paid","added_by":"144102554647936900","added_on":"2021-03-02 11:38:02","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"SANJAY.S.S","hr_employee_code":"429","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2021-02-01"},{"employee_incentive_id":"6","employee_id":"159853556987468900","paid_salary_id":"0","incentive_amount":"6000","incentive_title":"Monthly Incentive","payable_month":"2021-02-01","incentive_status":"Approved","remarks":"To be paid","added_by":"144102554647936900","added_on":"2021-03-02 11:36:28","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"AVINASH.B.V","hr_employee_code":"423","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":null},{"employee_incentive_id":"8","employee_id":"159886849788847700","paid_salary_id":"1226","incentive_amount":"3000","incentive_title":"Feb Incentive","payable_month":"2021-02-01","incentive_status":"Approved","remarks":"Incentive to be paid","added_by":"144102554647936900","added_on":"2021-03-02 11:38:33","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"TEJESHWAR.M.S","hr_employee_code":"425","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2021-02-01"},{"employee_incentive_id":"9","employee_id":"159946638519418800","paid_salary_id":"1350","incentive_amount":"15000","incentive_title":"Monthly","payable_month":"2021-03-01","incentive_status":"Approved","remarks":"5X3","added_by":"144102554647936900","added_on":"2021-03-31 14:29:46","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"SANJAY.S.S","hr_employee_code":"429","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2021-03-01"},{"employee_incentive_id":"10","employee_id":"159853556987468900","paid_salary_id":"1249","incentive_amount":"12000","incentive_title":"Monthly","payable_month":"2021-03-01","incentive_status":"Approved","remarks":"4X3","added_by":"144102554647936900","added_on":"2021-03-31 14:30:21","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"AVINASH.B.V","hr_employee_code":"423","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2021-03-01"},{"employee_incentive_id":"12","employee_id":"159946638519418800","paid_salary_id":"1489","incentive_amount":"3000","incentive_title":"Monthly Incentive","payable_month":"2021-04-01","incentive_status":"Approved","remarks":"To be paid ","added_by":"144102554647936900","added_on":"2021-05-03 10:02:40","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"SANJAY.S.S","hr_employee_code":"429","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2021-04-01"},{"employee_incentive_id":"11","employee_id":"159853556987468900","paid_salary_id":"1405","incentive_amount":"6000","incentive_title":"Monthly Incentive","payable_month":"2021-04-01","incentive_status":"Approved","remarks":"To be paid","added_by":"144102554647936900","added_on":"2021-05-03 10:02:10","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"AVINASH.B.V","hr_employee_code":"423","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2021-04-01"},{"employee_incentive_id":"13","employee_id":"161604236412510800","paid_salary_id":"1761","incentive_amount":"3000","incentive_title":"Monthly Incentive","payable_month":"2021-06-01","incentive_status":"Approved","remarks":"Sales Incen.","added_by":"144102554647936900","added_on":"2021-07-06 16:29:30","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"M.ARUN","hr_employee_code":"478","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2021-06-01"},{"employee_incentive_id":"14","employee_id":"161604236412510800","paid_salary_id":"1938","incentive_amount":"6000","incentive_title":"Monthly Incentive","payable_month":"2021-07-01","incentive_status":"Approved","remarks":"Monthly incentive","added_by":"144102554647936900","added_on":"2021-08-04 15:23:16","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"M.ARUN","hr_employee_code":"478","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2021-07-01"},{"employee_incentive_id":"15","employee_id":"159946638519418800","paid_salary_id":"2723","incentive_amount":"3000","incentive_title":"Monthly Incentive","payable_month":"2021-11-01","incentive_status":"Approved","remarks":"1 sale","added_by":"144102554647936900","added_on":"2021-11-09 16:13:59","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"SANJAY.S.S","hr_employee_code":"429","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2021-11-01"},{"employee_incentive_id":"18","employee_id":"159946638519418800","paid_salary_id":"0","incentive_amount":"6000","incentive_title":"Monthly Incentive","payable_month":"2021-11-01","incentive_status":"Approved","remarks":"Approved","added_by":"144102554647936900","added_on":"2021-12-01 12:01:59","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"SANJAY.S.S","hr_employee_code":"429","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":null},{"employee_incentive_id":"19","employee_id":"160267676254326500","paid_salary_id":"2712","incentive_amount":"18000","incentive_title":"Monthly Incentive","payable_month":"2021-11-01","incentive_status":"Approved","remarks":"Incentive","added_by":"144102554647936900","added_on":"2021-12-01 12:05:06","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"RAKSHITH.J","hr_employee_code":"439","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2021-11-01"},{"employee_incentive_id":"17","employee_id":"161604236412510800","paid_salary_id":"0","incentive_amount":"9000","incentive_title":"Monthly Incentive","payable_month":"2021-11-01","incentive_status":"Approved","remarks":"Approved","added_by":"144102554647936900","added_on":"2021-12-01 12:01:16","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"M.ARUN","hr_employee_code":"478","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":null},{"employee_incentive_id":"16","employee_id":"161604236412510800","paid_salary_id":"2652","incentive_amount":"6000","incentive_title":"Monthly Incentive","payable_month":"2021-11-01","incentive_status":"Approved","remarks":"2 sales","added_by":"144102554647936900","added_on":"2021-11-09 16:14:44","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"M.ARUN","hr_employee_code":"478","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2021-11-01"},{"employee_incentive_id":"21","employee_id":"161604236412510800","paid_salary_id":"3439","incentive_amount":"48000","incentive_title":"Monthly","payable_month":"2022-03-01","incentive_status":"Approved","remarks":"Till mrch","added_by":"144102554647936900","added_on":"2022-04-25 13:37:17","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"M.ARUN","hr_employee_code":"478","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2022-03-01"},{"employee_incentive_id":"20","employee_id":"164335425438091800","paid_salary_id":"3552","incentive_amount":"6000","incentive_title":"Monthly","payable_month":"2022-03-01","incentive_status":"Approved","remarks":"Monthly","added_by":"144102554647936900","added_on":"2022-04-25 13:36:37","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"VIDYASHREE.N","hr_employee_code":"557","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2022-03-01"},{"employee_incentive_id":"23","employee_id":"161604236412510800","paid_salary_id":"3630","incentive_amount":"27000","incentive_title":"Incentive","payable_month":"2022-04-01","incentive_status":"Approved","remarks":"A","added_by":"144102554647936900","added_on":"2022-05-19 16:15:32","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"M.ARUN","hr_employee_code":"478","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2022-04-01"},{"employee_incentive_id":"22","employee_id":"164335425438091800","paid_salary_id":"3742","incentive_amount":"6000","incentive_title":"Incentive","payable_month":"2022-04-01","incentive_status":"Approved","remarks":"Monthly","added_by":"144102554647936900","added_on":"2022-05-19 16:14:15","approved_by":"144102554647936900","approved_on":"0000-00-00 00:00:00","hr_employee_name":"VIDYASHREE.N","hr_employee_code":"557","hr_employee_department":"1","hr_employee_company":"1","general_task_department_name":"SALES","added_user_name":"JAGANNATH ","approved_user_name":"JAGANNATH ","paid_salary_from_date":"2022-04-01"}]}