Consultancy to Review and Update the Finance, Procurement and Human Resource Manual tender at Civil Society for Poverty Reduction
Website :
490 Days Ago
Linkedid Twitter Share on facebook

CONSULTANCY TO REVIEW AND UPDATE THE FINANCE,PROCUREMENT AND HUMAN RESOURCE MANUAL

Background 

The Civil Society for Poverty Reduction (CSPR) is an anti-poverty civil society network that has been building a voice for the poor in the fight against poverty. It was established in 2000, primarily to ensure that civil society effectively and meaningfully participates in the design, formulation, and implementation of the National Development Plans.  See our website for more information:  http://www.csprzambia.org

2. Objective of the Consultancy

The main objective of this assignment is to comprehensively review and update the current financial management, internal controls and procurement manual to ensure smooth, effective and efficient operations that guarantee the highest returns and value for money across CSPR’s operations. Since the development of the existing Finance and Procurement manual, CSPR has significantly grown necessitating the revisions of the manual to reflect the current structure, focus and strategic direction of the organisation. In addition, CSPR has diversified her funding models and partners, these grants come with the requirements, terms and conditions and hence the need for their incorporation within the finance, internal controls, and procurement policies and procedures manual. The consultant will work closely with the Finance team and the Senior Management Team to deliver on the objectives of the assignment. CSPR will facilitate access to information on its operating environment and on its current internal control systems.

3. Scope of Work

The consultant selected for this work will be responsible to deliver fully on the objective of this consultancy. Specifically, the consultant will be expected to:

  • Update the Finance and procurement manual with the following critical items
  • Robust substantive internal control, compliance, and audit policies and procedures;
  • Best practices on fraud detection, prevention and mitigation policies and procedures; and
  • Guidance on topics that include taxes regulations in Zambia and some donor requirements.
  • Review and update the current Finance and Procurement policies and procedures manual to incorporate the following but not limited to:
  • Audit recommendations in the last five (5) years;
  • The structure of operations within the organization;
  • The strategic Plan 2022-2026;
  • Existing Government regulations in Zambia)
  • CSPR current donor requirements;
  • CSPR’s revised operational manuals;
  • New developments and best practices in the field of Accounting, Finance and Auditing
  • Procurement and contracting policies and procedures including CSPR’s procurement tool kit,
  • Grants Management procedures
  • Cost allocation policy for projects and donor proposals
  • Assess the current Finance and Procurement policies and procedures manual.
  • The assessment shall cover specific finance policies (e.g. budgeting, payroll, travel and subsistence, asset management, grants management, fraud management),
  • key minimum standards, and Specific Finance Procedures (e.g. Procurement, banking, and accounting routines), Chart of accounts among others.
  • Presentation of the draft report to CSPR’s management and leadership team.
  • Training CSPR’s staff and partners on the revised Finance and Procurement policies and procedure manual.

4. Core Deliverables

The Consultant will be expected to deliver the six (6) outputs specified below:

I.  An inception report with detailed scope of work and work breakdown schedule that outlines the work plan, timelines, milestones and deliverables;

II.  An updated Finance policies and manual; iii. An updated Procurement policy and procedures manual;

III. A report to the management on improvements or upgrades that can be made to improve the financial management of the organization;

IV.  Develop training materials for CSPR’S staff on the revised policies, procedures or guidelines;

V.  Training CSPR’s employees and partners; and

VI.  A detailed report on awareness/training of CSPR’s employees and partners.

 5. Methodology

It is expected that the consultant will carry out a number of activities:

I.  Propose and design a mixed-method approach in responding to different deliverables of this assignment;

II. Conduct consultations with CSPR’s staff members, donors and stakeholders.

III.  Review current CSPR Finance and Procurement policies and procedures manual; iv) Use both SWOC and PESTEL models and other frontier models in developing CSPR’s strategic direction and positioning;

IV. Apply relevant analytical to assess CSPR’s financial and procurement processes, their risks and propose mitigation measures;

V. Apply and introduce contemporary Finance, Accounting, Auditing and Supply Chains/Procurement best practices in reviewing and updating the existing Finance and Procurement policies and procedures manual.

 6. Minimum Requirements and Competencies

The consultant team must meet the following minimum requirements:

I. Accredited consultant with a minimum of 10 years’ progressive experience in financial management or institutional strengthening for the NGO sector with sound background in Finance, Accounting, Auditing and Procurement. Experience in working in is desirable and an added advantage.

II. Minimum of a master’s degree in accounting, Finance, Auditing or a business-related field and a Member of ZICA, ACCA, CFA, CIA, CIPS and in good standing;

III.  Knowledge and experience in managing multiple donor funds for program/project implementation and is familiar with various international donor expectations, audit and grant compliance;

IV.  Solid knowledge in financial management applicable to General Accepted Accounting Principles (GAAP), International Financial Reporting Standards (IFRS), International Standards on Auditing (ISA), Financial Statements Analysis and public financial management;

V.  Ability and experience in assessing financial management training needs and preparing related training materials for international NGOs, particularly in Africa;

VI.At least 7 years’ experience in supply chain and procurement procedures of an international research based and training NGO in Africa is desirable;

VII. Excellent leadership, organisational and time management skills; and

VIII. Excellent communication skills including in editing, writing and presentations.

 7. Supervision

The Consultant will be expected to be self-motivated and able to work independently. CSPR’S Head, Finance and Administration will provide supervision and support including induction to the work, provision of the relevant background documents, and links to the relevant internal and external stakeholders. CSPR’s Senior Management Team will provide a general guidance and advice.

8. Timeframes

It is anticipated that the assignment will be completed within 20 working days from the date of the signing of the contract between CSPR and the Service Provider.

9. Response to the EOI

Please respond to this EOI with not more than 15 pages technical and financial proposal (including all attachments) to cspr@csprzambia.org  by 12:00pm CAT Wednesday 20th  December 2023.

The EOI proposal should cover:

  • Your understanding of the assignment;
  • Evidence of past work experience;
  • A proposed approach and methodology for carrying out the assignment;
  • Core team, responsibilities and level of effort;
  • A detailed work plan, timeframes and milestones.
  • A financial proposal that indicates the all-inclusive fixed total contract price, supported by a breakdown of costs for each task or element in the ToR.

Any Inquiries can be sent to the same email and shall be collectively responded to not later than Wednesday 20th December 2023.

Job Info
Job Category: Tenders in Zambia
Job Type: Full-time
Deadline of this Job: Monday, December 23 2024
Duty Station: Lusaka
Posted: 11-12-2023
No of Jobs: 1
Start Publishing: 11-12-2023
Stop Publishing (Put date of 2030): 11-12-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
59.743MBMemory Usage367msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.28-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "091d0fd0da593ceeb7e40d00c7fb3d5f" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 8 "timer" => array:3 [ "start" => 1744687649 "last" => 1744687660...
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) (16.53ms)
  • afterInitialise (11.13MB) (59.26ms)
  • afterRoute (5.06MB) (24.11ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (157μs)
  • afterRenderComponent com_jsjobs (3.12MB) (27.2ms)
  • Before Access::preloadComponents (all components) (239.64KB) (4.8ms)
  • After Access::preloadComponents (all components) (132.72KB) (735μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (15μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (296μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.51MB) (49.16ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (54.71ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (5μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (276μs)
  • afterDispatch (79.35KB) (96μs)
  • afterRender (13.75MB) (129ms)
  • 1 x afterRender (13.75MB) (35.19%)
    129.25ms
    1 x afterInitialise (11.13MB) (16.13%)
    59.26ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (14.9%)
    54.71ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.51MB) (13.38%)
    49.16ms
    1 x afterRenderComponent com_jsjobs (3.12MB) (7.4%)
    27.20ms
    1 x afterRoute (5.06MB) (6.56%)
    24.11ms
    1 x afterLoad (4.12MB) (4.5%)
    16.53ms
    1 x Before Access::preloadComponents (all components) (239.64KB) (1.31%)
    4.80ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.2%)
    735μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.08%)
    296μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.08%)
    276μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    157μs
    1 x afterDispatch (79.35KB) (0.03%)
    96μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    15μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    5μs
90 statements were executed, 23 of which were duplicates, 67 unique16.78ms224.23KB
  • SELECT @@SESSION.sql_mode;73μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?89μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 165μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `icop0_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id789μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`107μs1.55KB/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` = :guest129μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'83μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`73μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'174μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config91μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'66μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'56μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'54μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'53μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultancy-to-Review-and-Update-the-Finance%2C-Procurement-and-Human-Resource-Manual-tender-at-Civil-Society-for-Poverty-Reduction-53880%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Consultancy-to-Review-and-Update-the-Finance%2C-Procurement-and-Human-Resource-Manual-tender-at-Civil-Society-for-Poverty-Reduction-53880%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultancy-to-Review-and-Update-the-Finance%2C-Procurement-and-Human-Resource-Manual-tender-at-Civil-Society-for-Poverty-Reduction-53880%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC288μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultancy-to-Review-and-Update-the-Finance%2C-Procurement-and-Human-Resource-Manual-tender-at-Civil-Society-for-Poverty-Reduction-53880%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Consultancy-to-Review-and-Update-the-Finance%2C-Procurement-and-Human-Resource-Manual-tender-at-Civil-Society-for-Poverty-Reduction-53880%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Consultancy-to-Review-and-Update-the-Finance%2C-Procurement-and-Human-Resource-Manual-tender-at-Civil-Society-for-Poverty-Reduction-53880%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC242μ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.id217μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'308μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • 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 = 'social'228μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'298μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'232μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'76μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'76μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'243μ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 = 53880807μs36.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'234μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 53880359μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'238μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering282μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'230μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'273μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering225μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'224μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'163μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'70μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'91μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'211μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'196μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'123μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'82μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2103μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 283μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'300μ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'344μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2174μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 285μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 282μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'138μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'165μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'264μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering163μ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)441μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 0125μs936B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22115μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24116μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2882μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38119μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 3999μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 4087μ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` = 0139μ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.lft299μ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.lft251μ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.lft339μ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-Consultancy-to-Review-and-Update-the-Finance,-Procurement-and-Human-Resource-Manual-tender-at-Civil-Society-for-Poverty-Reduction-53880' AND `published` = 1138μs9.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Consultancy-to-Review-and-Update-the-Finance,-Procurement-and-Human-Resource-Manual-tender-at-Civil-Society-for-Poverty-Reduction-53880'114μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration213μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'115μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field74μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'68μ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` = 1125μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'121μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`203μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'111μ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 desc147μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`300μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid81μ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` = :muserid140μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Consultancy-to-Review-and-Update-the-Finance,-Procurement-and-Human-Resource-Manual-tender-at-Civil-Society-for-Poverty-Reduction-53880'63μ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` = 172μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"366μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES718μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin60μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin63μ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`90μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'116μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'170μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 396563μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?77μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?650μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy