Health Information System Developer/ Consultant (HISD) Job at HLB Zambia (On Behalf of Morehouse School of Medicine) - Career Opportunity in Zambia
Website :
1726 Days Ago
Linkedid Twitter Share on facebook

Vacancy title:
Health Information System Developer/ Consultant (HISD)

[ Type: FULL TIME , Industry: Financial Services , Category: Healthcare ]

Jobs at:

HLB Zambia (On Behalf of Morehouse School of Medicine)

Deadline of this Job:
27 August 2020  

Duty Station:
Within Zambia , Lusaka , South - Central Africa

Summary
Date Posted: Friday, August 21, 2020 , Base Salary: Not Disclosed


JOB DETAILS:
Our client, Morehouse School of Medicine, is looking for an eligible and qualified individual to fill the position of Health Information System Developer/ Consultant (HISD).
COMPANY DESCRIPTION
The Morehouse School of Medicine (MSM) is a Historically Black College and University (HBCU) based in Atlanta, Georgia, USA and is part of the HBCU Global Health Consortium (GHC). The HBCU GHC consists of four historically black colleges and universities (HBCUs) in the United States: MSM, Charles R. Drew University of Medicine and Science (CDU), Meharry Medical College (MMC), and Howard University (HU). Funded by the US President’s Emergency Plan for AIDS Relief (PEPFAR) through the Health Resources and Services Administration (HRSA), HIV/AIDS Bureau, Division of Global HIV Programs, the HBCU GHC project is a multi-year initiative. The HBCU GHC was established to develop and implement strategies to address the social determinants and health inequalities found within the context of the clinical transformation that will enhance and improve the provision of HIV/AIDS services in Lusaka, Zambia.
PROJECT DESCRIPTION
The overall aim of the MSM project in Zambia is to improve patient outcomes by addressing the 95-95-95 cascade and improve HIV testing rates, patient retention, anti-retroviral treatment and viral load testing/ reporting through: 1.) Clinic Workflow Re-design 2.) Optimizing Referral Systems for better Care Coordination, and 3.) Utilizing Digital Technology to improve Data Management. The Project is being implemented in Chilenje, Chawama, Kanyama, and Matero First Level Hospitals in Lusaka, Zambia.
POSITION DESCRIPTION
This is a Lusaka based position and applicants can be individuals or a firm. The selected candidate will be hired as a contractor/ consultant with the option of the position being converted into a full-time position depending on future project needs (individuals). All materials and applications developed under this role will be the property of the Ministry of Health (MOH), the SmartCare Implementing Partner, and the Morehouse University School of Medicine.
The Health Information System Developer/ Consultant (HISD) will assume a leadership position for overseeing and managing MSM’s efforts to contribute to the improvement of the Electronic Health Record (EHR) SmartCare system to improve the use of clinical data in service delivery. S/He will be a dynamic, energetic, highly organized and experienced individual who will be responsible for coordination between the SmartCare implementing partner in Zambia, MOH and other relevant implementing partners. S/he will oversee the project implementation and management and working with the MSM staff at the health facilities. The successful candidate must demonstrate a proven track record in establishing and delivering successful methodologies and expertise at the program level. S/He should have experience in the development and implementation of large scale multi-faceted electronic health systems, use of project management tools and a proven track record for fostering collaborative work environments, able to mentor all levels of the project implementation staff and demonstrate excellent leadership, diplomatic, and conflict resolution skills. The successful candidate will have strong technical experience with respect to understanding and translating system-wide and end-user requirements into practical solutions. .

FUNCTIONAL RESPONSIBILITIES
The tasks listed below are representative of the nature and level of work assigned and are not necessarily all inclusive.
SQL Code Development and Implementation
• Design, develop and maintain database business processes and SmartCare database applications to allow facility-based staff to run SQL scripts to extract data from the SmartCare relational database to support project implementation activities
• Develop SQL codes to extract data from SmartCare and routinely monitor backend changes to SmartCare data tables to make sure developed SQL codes are valid
• Create necessary technical and architectural documentation
• Support implementation of SmartCare database SQL codes and database objects at the site-level in collaboration with the SmartCare
Capacity Building
• Develop SmartCare SQL script development training course including curriculum and associated training materials
• Provide ongoing training to in-country teams on how to develop SQL codes and applications
• Actively identify training, education and development activities to improve in-country team’s knowledge and performance to sustain and enhance professional development
Database Development
• Collaborate with SmartCare implementing partners (IPs) to conduct needs analysis for the development of new systems and/or the modification of existing systems from a database perspective to improve clinical data capture and reporting
• Collaborate with SmartCare IPs to plan and coordinate systems integration and data migrations between systems related to SmartCare
• Maintain and develop database documentation, including entity relationship diagram and database schemas for SmartCare as required by IPs, MOH, and Morehouse School of Medicine
• Adhere to security schemes as outlined by IPs, MOH, and Morehouse School of Medicine relating to the database and ensure the integrity and security of data
• Other duties as assigned.
Representation
• Represent Morehouse School of Medicine and collaborating partners at technical working group meetings related to SmartCare
• Document outcomes of all meeting with IPs and MOH related to SmartCare for distribution to project leadership


\Skills Required:
• Strong MS SQL Server skills (SQL Server 2012-2019)
• Experience in migration of data from other systems (e.g. MS Access) to MS SQL Server strongly preferred
• QL Server database Stored Procedures/Triggers and database development
• .NET Framework 4.8, 4.7, 4.5, 4.0, etc.
• Expert C# Programming
• XML, TXT files, preferred
• PL/SQL programming


QUALIFICATIONS AND EXPERIENCE
• Expert knowledge of SmartCare database structure required
• Five (5) years relevant work experience in database programming, analysis and application server.
• Significant (5+) years of frontend and backend experience with SmartCare highly desired
• 3+ years of experience in Development – SQL Development
• Experience in structured relational Database Design and ERD, as well as in Application Server
• Ability to write concise and accurate technical instructions throughout program development
• Ability to troubleshoot database programming issues, errors, and subsequent modifications; must be able to do this with the work of other programmers
• Fundamental skills in data analysis and data modeling
• Excellent interpersonal, organizational and analytical skills
• Ability to work independently and as a team member; manage strict deadlines; and work in a results and solution-oriented environment
• Experience working on PEPFAR and other donor funded health projects highly desired
• Extensive experience working with and supporting MOH highly desired
Education
• Bachelors of Science in Computer Science or equivalent two-year certification in computer studies required
Masters of Science in Computer Science and /or Information Systems or higher desired


Job Education Requirements: Not Specified


Job Experience Requirements: Five (5) years


Work Hours: 8

 

{module 312}

Job application procedure
If interested in this opportunity, kindly send the following items to hr@hlb.co.zm  by Tuesday, 25 August 2020 by 23:59 hours:
1. Your CV/ resume or company profile outlining how you meet the above requirements
2. Application letter with hourly rate (in Kwacha or USD)
3. Photocopies of original professional certificates, degrees (please combine all these documents into 1 PDF file)
4. Contact information of five professional references
Please do not submit additional materials. Kindly put “MSM HISD Application” in the email subject line. Applicants who fail to follow these application instructions will be disqualified from further consideration.
Please note that only shortlisted candidates that have followed these specific instructions will be considered and contacted. Please note that if you have not heard from us by the 27th of August 2020, kindly consider your application unsuccessful. However, your CV will be kept in our database for any suitable positions that might arise in the future.


All Jobs

QUICK ALERT SUBSCRIPTION

{module 316}

Job Info
Job Category: Consultant/ Contractual jobs in Zambia
Job Type: Full-time
Deadline of this Job: 25 August 2020
Duty Station: Lusaka
Posted: 21-08-2020
No of Jobs: 1
Start Publishing: 21-08-2020
Stop Publishing (Put date of 2030): 21-08-2065
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60.268MBMemory Usage646msRequest 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" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1747166198 "last" => 1747166198...
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.greatzambiajobs.com/how-to-app...
JSItemid
"190"
  • afterLoad (4.12MB) (18.92ms)
  • afterInitialise (11.09MB) (93.02ms)
  • afterRoute (5.06MB) (35.11ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (240μs)
  • afterRenderComponent com_jsjobs (3.14MB) (54.81ms)
  • Before Access::preloadComponents (all components) (239.64KB) (11.62ms)
  • After Access::preloadComponents (all components) (132.72KB) (1.09ms)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (21μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (349μs)
  • afterDispatch (2.37MB) (156ms)
  • afterRender (31.48MB) (275ms)
  • 1 x afterRender (31.48MB) (42.5%)
    274.69ms
    1 x afterDispatch (2.37MB) (24.08%)
    155.67ms
    1 x afterInitialise (11.09MB) (14.39%)
    93.02ms
    1 x afterRenderComponent com_jsjobs (3.14MB) (8.48%)
    54.81ms
    1 x afterRoute (5.06MB) (5.43%)
    35.11ms
    1 x afterLoad (4.12MB) (2.93%)
    18.92ms
    1 x Before Access::preloadComponents (all components) (239.64KB) (1.8%)
    11.62ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.17%)
    1.09ms
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.05%)
    349μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    240μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    21μs
89 statements were executed, 23 of which were duplicates, 66 unique43.98ms294.22KB
  • SELECT @@SESSION.sql_mode;47μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?71μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 175μ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)7.52ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`71μ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` = :guest115μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'58μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`55μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'120μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config128μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'81μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'71μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'67μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'83μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Health-Information-System-Developer-Consultant-HISD-Job-at-HLB-Zambia-On-Behalf-of-Morehouse-School-of-Medicine-Career-Opportunity-in-Zambia-18680%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Health-Information-System-Developer-Consultant-HISD-Job-at-HLB-Zambia-On-Behalf-of-Morehouse-School-of-Medicine-Career-Opportunity-in-Zambia-18680%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Health-Information-System-Developer-Consultant-HISD-Job-at-HLB-Zambia-On-Behalf-of-Morehouse-School-of-Medicine-Career-Opportunity-in-Zambia-18680%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC276μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Health-Information-System-Developer-Consultant-HISD-Job-at-HLB-Zambia-On-Behalf-of-Morehouse-School-of-Medicine-Career-Opportunity-in-Zambia-18680%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Health-Information-System-Developer-Consultant-HISD-Job-at-HLB-Zambia-On-Behalf-of-Morehouse-School-of-Medicine-Career-Opportunity-in-Zambia-18680%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Health-Information-System-Developer-Consultant-HISD-Job-at-HLB-Zambia-On-Behalf-of-Morehouse-School-of-Medicine-Career-Opportunity-in-Zambia-18680%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC277μs4.25KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • 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.id178μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'341μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'284μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'264μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'309μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'240μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'89μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'74μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'237μ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 = 18680583μs36.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'238μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 1868017.92ms48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'236μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering322μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'223μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'223μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering260μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'241μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'246μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'79μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'71μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'278μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'222μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'86μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'72μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2161μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2145μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'545μ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'511μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2186μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2158μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2164μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'290μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'378μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'267μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering183μ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,:preparedArray50)674μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0136μs920B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22148μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24224μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28146μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38187μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40148μ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` = 0103μ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.lft404μ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.lft281μ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.lft521μs2.3KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Health-Information-System-Developer-Consultant-HISD-Job-at-HLB-Zambia-On-Behalf-of-Morehouse-School-of-Medicine-Career-Opportunity-in-Zambia-18680' AND `published` = 1115μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Health-Information-System-Developer-Consultant-HISD-Job-at-HLB-Zambia-On-Behalf-of-Morehouse-School-of-Medicine-Career-Opportunity-in-Zambia-18680'77μs8.94KB/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration277μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'125μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field127μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'116μ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` = 1124μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'193μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`314μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'76μ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 desc240μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`336μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid145μ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` = :muserid222μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Health-Information-System-Developer-Consultant-HISD-Job-at-HLB-Zambia-On-Behalf-of-Morehouse-School-of-Medicine-Career-Opportunity-in-Zambia-18680'102μ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` = 187μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"363μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES1.05ms8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin128μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin119μ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`104μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'114μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'315μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 316287μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?143μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?495μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy