{"iTotalDisplayRecords":"0","query":"\r\n SELECT SQL_CALC_FOUND_ROWS `hr_employee_id`, `hr_employee_user`, `hr_employee_name`, `hr_employee_current_address`, `hr_employee_permanent_address`, `hr_employee_father_name`, `hr_employee_mother_name`, `hr_employee_dob`, `hr_employee_gender`, `hr_employee_blood_group`, `hr_employee_employment_date`, `hr_employee_week_off`, `hr_employee_department`, `hr_employee_manager`, `hr_employee_designation`, `hr_employee_maritial_status`, `hr_employee_company`, `hr_employee_code`, `hr_employee_personal_phone_number`, `hr_employee_personal_email_id`, `hr_employee_office_phone_number`, `hr_employee_pf_number`, `hr_employee_pf_uan`, `hr_employee_esi_number`, `hr_employee_insurance_name`, `hr_employee_insurance_number`, `hr_employee_insurance_amount`, `hr_employee_pan_number`, `hr_employee_aadhar_number`, `hr_employee_status`, `hr_employment_type`, `hr_employee_remarks`, `hr_employee_added_by`, `hr_employee_added_on`, `hr_employee_salary_type`, `hr_employee_esi_applicable`, `hr_employee_employment_end_date`, `department_name`, `manager_user_name`, `designation_name`, `company_master_name`, `added_user_name`, `insurance_company_name`, `employement_type_name`\r\n FROM hr_employee_view\r\n \r\n ORDER BY hr_employee_name ASC\r\n \r\n ","aaData":[]}