Claims Assurance Assistant - Eldoret job at Avenue Healthcare
Website :
16 Days Ago
Linkedid Twitter Share on facebook
Claims Assurance Assistant - Eldoret
2025-06-06T14:09:09+00:00
Avenue Healthcare
https://cdn.greatkenyanjobs.com/jsjobsdata/data/employer/comp_8065/logo/avenue.png
FULL_TIME
 
Eldoret
Nairobi
00100
Kenya
Healthcare
Finance, Insurance & Real Estate
KES
 
MONTH
2025-06-12T17:00:00+00:00
 
Kenya
8

Main Purpose of the Job- (Job Summary)

To support the claims process by preparing and verifying claim documents and assisting with patient billing issues. The role focuses on ensuring documentation is complete for timely claims submission and preventing rejections.

Key Responsibilities: 

Claims Documentation & Support

  • Obtain and verify pre-authorizations for insured patients before billing.
  • Ensure claim forms are complete — including diagnosis, doctor’s notes/signatures, QR codes, and patient details.
  • Check for consistency across patient charts, invoices, and claim attachments.

Invoice Preparation & Submission

  • Generate, verify, and close accurate invoices in the billing system for cash, credit, and insurance patients.
  • Match invoices to corresponding authorization codes and patient service records.
  • Prepare claims for submission (physical and digital) and ensure daily dispatch logs are updated.

Reconciliation & Billing Follow-Up

  • Track and follow up on claims pending due to exceeded limits, missing documentation, or rejections.
  • Assist in reconciling billed amounts with insurer remittances or SHA statements.
  • Log rejections and errors for trend analysis and continuous improvement reporting.

Patient & Interdepartmental Liaison

  • Respond to patient billing queries with professionalism and accuracy.
  • Liaise with clinical, front office, and finance teams to clarify service dates, diagnosis codes, or authorization needs.
  • Alert relevant departments of billing or claim anomalies requiring correction.

Data Management & Compliance

  • File and organize claim documents in line with internal filing protocols (digital and physical).
  • Ensure compliance with patient data privacy laws (e.g., Data Protection Act, 2019).
  • Update claim and invoice trackers to support real-time reporting.

Reporting & Administrative Support

  • Generate basic reports on daily claims submitted, claims pending, and invoice status.
  • Assist in updating SOP manuals or process checklists as needed.
  • Support preparation for internal audits or insurer reviews by locating and compiling required documentation.

Continuous Learning & Systems Use

  • Stay updated on SHA and private insurer billing requirements.
  • Participate in internal training on claims, invoicing, and accounting systems.
  • Contribute ideas for improving claims turnaround and documentation accuracy.

Support the revenue cycle team with ad hoc tasks aligned with the role’s scope.

Any other duties as may be assigned by the supervisor

Key Deliverables of this position

  • 100% accuracy and completeness of insurance and credit documentation before delivery of service.
  • Reduction in claim rejections through proactive documentation checks and SOP compliance.
  • Effective coordination across departments to ensure timely claims submission and revenue assurance.

Essential   

  • Diploma in Accounts, Business Administration, Health Records, , or a related field.

Desirable

  • CPA training is desirable

Work Experience & Skills

Essential 

  • Minimum 1-2 years of experience in a medical billing/revenue cycle role, preferably in a hospital or insurance setting.

Desirable 

  • Knowledge of medical insurance procedures in Kenya (including SHA/SHIF, private insurance payers, etc.).

Key Competencies

Essential 

  • Knowledge of medical billing software and EMR systems
  • Strong attention to detail and accuracy
  • Problem-solving and critical thinking abilities
  • Excellent communication and interpersonal skills

Desirable 

  • Ability to work in a fast-paced environment and under pressure
Claims Documentation & Support Obtain and verify pre-authorizations for insured patients before billing. Ensure claim forms are complete — including diagnosis, doctor’s notes/signatures, QR codes, and patient details. Check for consistency across patient charts, invoices, and claim attachments. Invoice Preparation & Submission Generate, verify, and close accurate invoices in the billing system for cash, credit, and insurance patients. Match invoices to corresponding authorization codes and patient service records. Prepare claims for submission (physical and digital) and ensure daily dispatch logs are updated. Reconciliation & Billing Follow-Up Track and follow up on claims pending due to exceeded limits, missing documentation, or rejections. Assist in reconciling billed amounts with insurer remittances or SHA statements. Log rejections and errors for trend analysis and continuous improvement reporting. Patient & Interdepartmental Liaison Respond to patient billing queries with professionalism and accuracy. Liaise with clinical, front office, and finance teams to clarify service dates, diagnosis codes, or authorization needs. Alert relevant departments of billing or claim anomalies requiring correction. Data Management & Compliance File and organize claim documents in line with internal filing protocols (digital and physical). Ensure compliance with patient data privacy laws (e.g., Data Protection Act, 2019). Update claim and invoice trackers to support real-time reporting. Reporting & Administrative Support Generate basic reports on daily claims submitted, claims pending, and invoice status. Assist in updating SOP manuals or process checklists as needed. Support preparation for internal audits or insurer reviews by locating and compiling required documentation. Continuous Learning & Systems Use Stay updated on SHA and private insurer billing requirements. Participate in internal training on claims, invoicing, and accounting systems. Contribute ideas for improving claims turnaround and documentation accuracy. Support the revenue cycle team with ad hoc tasks aligned with the role’s scope. Any other duties as may be assigned by the supervisor
 
Diploma in Accounts, Business Administration, Health Records, , or a related field. Desirable CPA training is desirable Work Experience & Skills Essential  Minimum 1-2 years of experience in a medical billing/revenue cycle role, preferably in a hospital or insurance setting
bachelor degree
24
JOB-6842f68525a72

Vacancy title:
Claims Assurance Assistant - Eldoret

[Type: FULL_TIME, Industry: Healthcare, Category: Finance, Insurance & Real Estate]

Jobs at:
Avenue Healthcare

Deadline of this Job:
Thursday, June 12 2025

Duty Station:
Eldoret | Nairobi | Kenya

Summary
Date Posted: Friday, June 6 2025, Base Salary: Not Disclosed

Similar Jobs in Kenya
Learn more about Avenue Healthcare
Avenue Healthcare jobs in Kenya

JOB DETAILS:

Main Purpose of the Job- (Job Summary)

To support the claims process by preparing and verifying claim documents and assisting with patient billing issues. The role focuses on ensuring documentation is complete for timely claims submission and preventing rejections.

Key Responsibilities: 

Claims Documentation & Support

  • Obtain and verify pre-authorizations for insured patients before billing.
  • Ensure claim forms are complete — including diagnosis, doctor’s notes/signatures, QR codes, and patient details.
  • Check for consistency across patient charts, invoices, and claim attachments.

Invoice Preparation & Submission

  • Generate, verify, and close accurate invoices in the billing system for cash, credit, and insurance patients.
  • Match invoices to corresponding authorization codes and patient service records.
  • Prepare claims for submission (physical and digital) and ensure daily dispatch logs are updated.

Reconciliation & Billing Follow-Up

  • Track and follow up on claims pending due to exceeded limits, missing documentation, or rejections.
  • Assist in reconciling billed amounts with insurer remittances or SHA statements.
  • Log rejections and errors for trend analysis and continuous improvement reporting.

Patient & Interdepartmental Liaison

  • Respond to patient billing queries with professionalism and accuracy.
  • Liaise with clinical, front office, and finance teams to clarify service dates, diagnosis codes, or authorization needs.
  • Alert relevant departments of billing or claim anomalies requiring correction.

Data Management & Compliance

  • File and organize claim documents in line with internal filing protocols (digital and physical).
  • Ensure compliance with patient data privacy laws (e.g., Data Protection Act, 2019).
  • Update claim and invoice trackers to support real-time reporting.

Reporting & Administrative Support

  • Generate basic reports on daily claims submitted, claims pending, and invoice status.
  • Assist in updating SOP manuals or process checklists as needed.
  • Support preparation for internal audits or insurer reviews by locating and compiling required documentation.

Continuous Learning & Systems Use

  • Stay updated on SHA and private insurer billing requirements.
  • Participate in internal training on claims, invoicing, and accounting systems.
  • Contribute ideas for improving claims turnaround and documentation accuracy.

Support the revenue cycle team with ad hoc tasks aligned with the role’s scope.

Any other duties as may be assigned by the supervisor

Key Deliverables of this position

  • 100% accuracy and completeness of insurance and credit documentation before delivery of service.
  • Reduction in claim rejections through proactive documentation checks and SOP compliance.
  • Effective coordination across departments to ensure timely claims submission and revenue assurance.

Essential   

  • Diploma in Accounts, Business Administration, Health Records, , or a related field.

Desirable

  • CPA training is desirable

Work Experience & Skills

Essential 

  • Minimum 1-2 years of experience in a medical billing/revenue cycle role, preferably in a hospital or insurance setting.

Desirable 

  • Knowledge of medical insurance procedures in Kenya (including SHA/SHIF, private insurance payers, etc.).

Key Competencies

Essential 

  • Knowledge of medical billing software and EMR systems
  • Strong attention to detail and accuracy
  • Problem-solving and critical thinking abilities
  • Excellent communication and interpersonal skills

Desirable 

  • Ability to work in a fast-paced environment and under pressure

 

Work Hours: 8

Experience in Months: 24

Level of Education: bachelor degree

Job application procedure

Interested and qualified? Click Here

 

All Jobs | QUICK ALERT SUBSCRIPTION

Job Info
Job Category: Accounting/ Finance jobs in Kenya
Job Type: Full-time
Deadline of this Job: Thursday, June 12 2025
Duty Station: Eldoret | Nairobi | Kenya
Posted: 06-06-2025
No of Jobs: 1
Start Publishing: 06-06-2025
Stop Publishing (Put date of 2030): 06-06-2065
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
58.737MBMemory Usage469msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.29-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:63 [ "USER" => "greatkenyanjobs" "HOME" => "/home/greatkenyanjobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1750658999 "last" => 1750658999...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
jsjobcur_usr
0
jsjobconfig_dft
array:171 [ "actk" => "0" "applybuttonredirecturl" => "http://www.greatkenyanjobs.com/how-to-app...
JSItemid
"190"
  • afterLoad (4.12MB) (28.22ms)
  • afterInitialise (11.17MB) (92.3ms)
  • afterRoute (5.06MB) (36.7ms)
  • beforeRenderComponent com_jsjobs (9.7KB) (220μs)
  • afterRenderComponent com_jsjobs (3.17MB) (38.6ms)
  • Before Access::preloadComponents (all components) (247.64KB) (7.19ms)
  • After Access::preloadComponents (all components) (130.74KB) (1.06ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.91KB) (18μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (320μs)
  • afterDispatch (494.27KB) (9.27ms)
  • afterRender (32.2MB) (253ms)
  • 1 x afterRender (32.2MB) (54.05%)
    253.46ms
    1 x afterInitialise (11.17MB) (19.68%)
    92.30ms
    1 x afterRenderComponent com_jsjobs (3.17MB) (8.23%)
    38.60ms
    1 x afterRoute (5.06MB) (7.83%)
    36.70ms
    1 x afterLoad (4.12MB) (6.02%)
    28.22ms
    1 x afterDispatch (494.27KB) (1.98%)
    9.27ms
    1 x Before Access::preloadComponents (all components) (247.64KB) (1.53%)
    7.19ms
    1 x After Access::preloadComponents (all components) (130.74KB) (0.23%)
    1.06ms
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.07%)
    320μs
    1 x beforeRenderComponent com_jsjobs (9.7KB) (0.05%)
    220μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.91KB) (0%)
    18μs
87 statements were executed, 23 of which were duplicates, 64 unique21.13ms278.13KB
  • SELECT @@SESSION.sql_mode;57μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?128μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 1134μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `icop0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.34ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`100μs1.59KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `icop0_usergroups` AS `a` LEFT JOIN `icop0_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest182μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'112μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`109μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'162μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config133μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'87μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'76μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'75μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'73μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Claims-Assurance-Assistant-Eldoret-job-at-Avenue-Healthcare-103106%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Claims-Assurance-Assistant-Eldoret-job-at-Avenue-Healthcare-103106%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Claims-Assurance-Assistant-Eldoret-job-at-Avenue-Healthcare-103106%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC222μs4.23KB/plugins/system/jlexblock/jlexblock.php:147Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Claims-Assurance-Assistant-Eldoret-job-at-Avenue-Healthcare-103106%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Claims-Assurance-Assistant-Eldoret-job-at-Avenue-Healthcare-103106%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Claims-Assurance-Assistant-Eldoret-job-at-Avenue-Healthcare-103106%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC293μs4.25KB/plugins/system/jlexblock/jlexblock.php:147Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM icop0_template_styles AS s WHERE s.client_id = 0 AND s.template = 'jl_education_pro' ORDER BY s.id227μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'313μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'226μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'228μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'289μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'214μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'116μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'83μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'240μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT job.params,job.id,job.title,job.city,job.metakeywords,job.metadescription,job.description,job.created,job.isgoldjob,job.isfeaturedjob,job.gender , job.jobcategory,job.duration,job.hidesalaryrange,job.zipcode,job.iseducationminimax,job.degreetitle,job.isexperienceminimax , job.startpublishing,job.requiredtravel,job.noofjobs,job.hits,job.stoppublishing,job.video,job.prefferdskills,job.qualifications,job.agreement,job.experiencetext,job.longitude,job.latitude , cat.cat_title, subcat.title as subcategory, company.name as companyname, jobtype.title AS jobtypetitle , jobstatus.title AS jobstatustitle, shift.title as shifttitle, company.url as companywebsite, company.contactname AS companycontactname, company.contactemail AS companycontactemail,company.since AS companysince,company.logofilename AS companylogo , department.name AS departmentname, company.id companyid,job.educationminimax,job.experienceminimax , salaryfrom.rangestart AS salaryfrom, salaryto.rangestart AS salaryto, salarytype.title AS salarytype , education.title AS educationtitle ,mineducation.title AS mineducationtitle, maxeducation.title AS maxeducationtitle , experience.title AS experiencetitle ,minexperience.title AS minexperiencetitle, maxexperience.title AS maxexperiencetitle , currency.symbol,CONCAT(job.alias,'-',job.id) AS jobaliasid, agefrom.title AS agefromtitle, ageto.title AS agetotitle ,company.isgoldcompany,company.isfeaturedcompany ,CONCAT(company.alias,'-',company.id) AS companyaliasid, workpermit.name as workpermitcountry ,company.endgolddate,company.endfeatureddate, job.jobapplylink,job.joblink, careerlevel.title AS careerleveltitle ,(SELECT COUNT(id) FROM `icop0_js_job_jobapply` WHERE jobid = job.id) AS totalapply FROM `icop0_js_job_jobs` AS job JOIN `icop0_js_job_categories` AS cat ON job.jobcategory = cat.id JOIN `icop0_js_job_companies` AS company ON job.companyid = company.id JOIN `icop0_js_job_jobtypes` AS jobtype ON job.jobtype = jobtype.id LEFT JOIN `icop0_js_job_ages` AS agefrom ON agefrom.id = job.agefrom LEFT JOIN `icop0_js_job_ages` AS ageto ON ageto.id = job.ageto LEFT JOIN `icop0_js_job_subcategories` AS subcat ON job.subcategoryid = subcat.id LEFT JOIN `icop0_js_job_jobstatus` AS jobstatus ON job.jobstatus = jobstatus.id LEFT JOIN `icop0_js_job_departments` AS department ON job.departmentid = department.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryfrom ON job.salaryrangefrom = salaryfrom.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryto ON job.salaryrangeto = salaryto.id LEFT JOIN `icop0_js_job_salaryrangetypes` AS salarytype ON job.salaryrangetype = salarytype.id LEFT JOIN `icop0_js_job_heighesteducation` AS education ON job.educationid = education.id LEFT JOIN `icop0_js_job_heighesteducation` AS mineducation ON job.mineducationrange = mineducation.id LEFT JOIN `icop0_js_job_heighesteducation` AS maxeducation ON job.maxeducationrange = maxeducation.id LEFT JOIN `icop0_js_job_experiences` AS experience ON job.experienceid = experience.id LEFT JOIN `icop0_js_job_experiences` AS minexperience ON job.minexperiencerange = minexperience.id LEFT JOIN `icop0_js_job_experiences` AS maxexperience ON job.maxexperiencerange = maxexperience.id LEFT JOIN `icop0_js_job_shifts` AS shift ON job.shift = shift.id LEFT JOIN `icop0_js_job_currencies` AS currency ON currency.id = job.currencyid LEFT JOIN `icop0_js_job_countries` AS workpermit ON workpermit.id = job.workpermit LEFT JOIN `icop0_js_job_careerlevels` AS careerlevel ON job.careerlevel = careerlevel.id WHERE job.id = 103106756μs76.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'244μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 103106326μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'1.33ms992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering307μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'208μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'227μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering263μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'227μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'240μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'80μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'70μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'227μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'233μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'81μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'78μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2164μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2159μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'567μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield918' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'554μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2194μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2162μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2170μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'234μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'265μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'235μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering214μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `icop0_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49)644μs8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0119μs888B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22152μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24135μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 37160μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `icop0_menu_types` AS `a` WHERE `a`.`client_id` = 0108μs1.19KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft364μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'distribution-channels' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft267μs1.17KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'categories-list' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft557μs2.3KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-Claims-Assurance-Assistant-Eldoret-job-at-Avenue-Healthcare-103106' AND `published` = 1135μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-Claims-Assurance-Assistant-Eldoret-job-at-Avenue-Healthcare-103106'70μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration380μs24.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'189μs10.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field221μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'191μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `icop0_scheduler_tasks` AS `a` WHERE `a`.`state` = 1131μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'154μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`282μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'64μs912B/libraries/src/Table/Table.php:755Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc178μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`318μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid144μs4.41KBParams/libraries/src/Table/User.php:104Copy
  • SELECT `g`.`id`,`g`.`title` FROM `icop0_usergroups` AS `g` INNER JOIN `icop0_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid118μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-Claims-Assurance-Assistant-Eldoret-job-at-Avenue-Healthcare-103106'71μs1.05KB/plugins/system/jmap/jmap.php:1135Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `icop0_jmap_text_replacements` WHERE `published` = 195μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"401μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.08ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin94μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin94μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM icop0_usergroups AS `groups`92μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'151μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'203μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 524183μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?146μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?500μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy