Payments and Financial Transactions Reconciliations Officer job at Standard Chartered Bank
Website :
798 Days Ago
Linkedid Twitter Share on facebook

Vacancy title: Payments and Financial Transactions Reconciliations Officer

[ Type: FULL TIME , Industry: Banking , Category: Accounting & Finance ]

Jobs at:

Standard Chartered Bank

Deadline of this Job:
21 March 2023  

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

Summary
Date Posted: Monday, March 06, 2023 , Base Salary: Not Disclosed

Similar Jobs in Zambia
Learn more about Standard Chartered Bank
Standard Chartered Bank jobs in Zambia

JOB DETAILS:
The Role Responsibilities
• The Payments and Financial Transacting Reconciliation Officer role has been established under the CPBB Servicing and Transacting function, under the Payments and Financial transacting unit.
• The purpose of this role to undertake and have oversight over reconciliations within the function which involves Mobile Money (NFS) platforms, Loan Operating Systems Reconciliations (Disbursements, Insurance, Repayments), VISA Settlements (ATMS & POS) and provide oversight over reconciliation activities of all suspense that the SnT function supports.
• The role will actively be involved in the Financial Controls System management ensuring items processes are fully substantiated and provide oversight over outsourced arrangements that impact on reconciliations.
Strategy
• Customer satisfaction through quality and timely support of branches and other supported channels
• Enhance Banks image by providing high level customer service
• To assist the departmental head to create and sustain of a strong operational risk control environment by adhering periodic self-assessment of key controls to access the proper functioning and adequacy of existing controls and assist in coordinating, facilitating and promoting the understanding of operational risk and implementation and management of operational risk within the unit.
• To manage and have oversight on the clearing, loan repayment and reconciliation process to ensure good quality of service and process governance.
• Effective Query Management within bank’s TAT recommendations
• To ensure compliance with local Policies, national legal regulatory and government bodies requirements
Business
• Ensure Bank profitability through efficient Operational Cost Management
• Reduce operational risk through effective reconciliation processes.
• Scrutinize high value unreconciled items and over aged items for effective decision making
• To ensure all transactions are properly authorised as per policy and banks guidelines
• Ensure excellent quality of service
• To manage and have oversight on the suspense account reconciliations and finding solutions for open items, including NFS, VISA, Mobile Money and other related transactions
• Management of the FCS substantiation, reconciliations and uploads
• To manage and have oversight on the TPGL exceptions
Processes
• To reconcile suspense accounts and ensure no items are above life span, i.e NFS, Mobile Money, Lending, Visa and other related accounts.
• Ensure timely and accurate data entry for both Hub (GBS) and Country postings
• Manage and achieve all defined and agreed service quality measures in all outsourced/migrated services
• Ensure compliance to credit policy guidelines
• Processing oversight of Direct Receipt Entries, Capital Reduction, Refunds, Early settlements
• Processing oversight of Credit Cards Repayment and Reconciliations
• Processing oversight of Overdraft processing and Reconciliations
• Processing, investigating and oversight of all suspense accounts and their reconciliations under SnT i.e Visa, NFS, MoMo, Clearing, Lending Lisa, Disbursement accounts, Insurance accounts, Agency Banking etc.
• Processing and monitoring of Cardless withdraws.
• Processing all FCS submissions with the agreed time frames, with the correct narrations and closure remarks
• Having oversight on all TPGL reconciliations and resolving breaks arising.
• Manage application process to achieve agreed loan turnaround times and maximize approval rates
• Maintain healthy relations with Credit and Credit Operations with view to harmonize workflows and quality of service.
• Management and resolution of client complaints
People and Talent
• Judgement required in prioritising work
• Judgement is exercised in rectifying operational problems
• Recognise transactions of irregular nature with a potential for frauds
• Good judgement required in controlling workflow to ensure all processing deadlines are met
• Continuously upgrade and develop new skills using the available internal and external platforms for knowledge sources.
Risk Management
• To ensure I remain alert to the risk of money laundering and assist in the banks efforts in combating it by adhering to the key principles in relation to; identifying your customer, knowing your customer, reporting suspicions, safeguarding records and not disclosing suspicions to customers.
• Understands products and target market as well as the risk associated with the business
• Understands the relevant law, regulations and practices to understand how they increase/ mitigate risk
Governance
• Ensure Clearing and posting adheres to the highest standards of regulatory and compliance practices, is in full compliance with all regulations and controls as set by the bank and external authorities; which includes compliance with local banking laws and anti-money laundering regulations and related guidelines.
• Fully comply with all policies and procedures and KCS to achieve satisfactory audit grades in local & Group audits
• Ensure you remain alert to the risk of money laundering and assist in the Bank’s efforts in combating it by adhering to the key principles in relation to: identifying your customer, knowing your customer, reporting suspicions, safeguarding records and not disclosing suspicions to customers.
• Ensure governance and control over outsourced processes to achieve compliance to local regulations and group policies and procedures.
Regulatory and Business Conduct
• Display exemplary conduct and live by the Group’s Values and Code of Conduct.
• Take personal responsibility for embedding the highest standards of ethics, including regulatory and business conduct, across Standard Chartered Bank. This includes understanding and ensuring compliance with, in letter and spirit, all applicable laws, regulations, guidelines and the Group Code of Conduct.
• Lead the Zambia / Servicing and Transacting business unit / Payments and Financial Transacting reconciliations team to achieve the outcomes set out in the Bank’s Conduct Principles: Fair Outcomes for Clients; Effective Financial Markets; Financial Crime Compliance; The Right Environment.
• Effectively and collaboratively identify, escalate, mitigate and resolve risk, conduct and compliance matters.
• Bank of Zambia, Zambia Electronic Clearing House Compliance with local Banking laws and anti-money Laundering regulations and related guidelines.

Key stakeholders
• Consumer Private and Business Banking clients
• Internal staff
• All banks participating in Clearing under ZECHL
• Zambia Electronic Clearing House
• Digital Banking Product Team
• Asset and Liabilities Product Team
• ront line staff
• GBS team
• GRU
• Systems Support teams

Other Responsibilities
• Embed Here for good and Group’s brand and values in Zambia, Servicing and Transacting team, Perform other responsibilities assigned under Group, Country, Business or Functional policies and procedures; Multiple functions (double hats);

To support the local and foreign clearing and Governance functions that is:
• Ensure cheque returns are done without causing excesses on the customer accounts
• To ensure all inwards received for the day are validated and work balanced before end of day
• To investigate and attend to queries pertaining to customer accounts
• To validate and approve entries posted in eBBS
• To ensure regulatory returns are submitted before deadline to avoid penalties
• To ensure work and in coming cheques conform to money laundering regulations
• Ensure risks identified are resolved in an appropriate and timely manner
• Hold prime keys to the strong room
• Ensure adherence to the Group and local DOI and process notes in the processing of all activities
• Continuously update the DOI to reflect current practices.

Other Tasks will include:
• To validate all cheques and internally raised vouchers (LCY & FCY)
• To ensure Technical verifications are performed correctly
• To ensure Inwards and Outwards are processed through Sybrin
• To ensure all unpaids are processed in eBBS through ICRS and sent to ZECHL through Sybrin system
• To ensure cheques validated agree amounts in words and in figures
• To ensure Yufig messages are sent promptly for cheques unpaid with technical reasons before cut off times set by the Clearing house.
• Ensure effective monitoring of the outsourced clearing processes
• Retain the function of back office for all clearing activities for business continuity
• Any other responsibilities as assigned by the Line Manager

Our Ideal Candidate
• Minimum of 5 O’Levels Credits or better including Mathematics and English
• Degree (or equivalent) in banking related field
• Minimum of 3 years Banking experience
• Computer literate
• Customer focused
• Ability to interpret instructions
• Good communication skills
• Ability to plan, monitor and control effectively
• High organisational skills
• Strong interpersonal skills to build relationships with staff

Role Specific Competencies
• Accuracy and Attention to Detail
• Knowledge of Banking Products
• Knowledge of mobile Money products (NFS)
• General Ledger (G-L)
• Experience in Banking and Managing Suspense accounts

About Standard Chartered
We’re an international bank, nimble enough to act, big enough for impact. For more than 160 years, we’ve worked to make a positive difference for our clients, communities, and each other. We question the status quo, love a challenge and enjoy finding new opportunities to grow and do better than before. If you’re looking for a career with purpose and you want to work for a bank making a difference, we want to hear from you. You can count on us to celebrate your unique talents. And we can’t wait to see the talents you can bring us.
Our purpose, to drive commerce and prosperity through our unique diversity, together with our brand promise, to be here for good are achieved by how we each live our valued behaviours. When you work with us, you’ll see how we value difference and advocate inclusion. Together we:
• Do the right thing and are assertive, challenge one another, and live with integrity, while putting the client at the heart of what we do
• Never settle, continuously striving to improve and innovate, keeping things simple and learning from doing well, and not so well
• Be better together, we can be ourselves, be inclusive, see more good in others, and work collectively to build for the long term
• In line with our Fair Pay Charter, we offer a competitive salary and benefits to support your mental, physical, financial and social wellbeing.
• Core bank funding for retirement savings, medical and life insurance, with flexible and voluntary benefits available in some locations
• Time-off including annual, parental/maternity (20 weeks), sabbatical (12 weeks maximum) and volunteering leave (3 days), along with minimum global standards for annual and public holiday, which is combined to 30 days minimum
• Flexible working options based around home and office locations, with flexible working patterns
• Proactive wellbeing support through Unmind, a market-leading digital wellbeing platform, development courses for resilience and other human skills, global Employee Assistance Programme, sick leave, mental health first-aiders and all sorts of self-help toolkits
• A continuous learning culture to support your growth, with opportunities to reskill and upskill and access to physical, virtual and digital learning
• Being part of an inclusive and values driven organisation, one that embraces and celebrates our unique diversity, across our teams, business functions and geographies – everyone feels respected and can realise their full potential.
• Recruitment assessments – some of our roles use assessments to help us understand how suitable you are for the role you’ve applied to. If you are invited to take an assessment, this is great news. It means your application has progressed to an important stage of our recruitment process.

Work Hours: 8


Experience in Months: 36

Level of Education:
Bachelor Degree

Job application procedure
Click here to apply now

All Jobs

QUICK ALERT SUBSCRIPTION

Job Info
Job Category: Accounting/ Finance jobs in Zambia
Job Type: Full-time
Deadline of this Job: 21 March 2023
Duty Station: Lusaka
Posted: 06-03-2023
No of Jobs: 1
Start Publishing: 06-03-2023
Stop Publishing (Put date of 2030): 06-03-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60.333MBMemory Usage374msRequest 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
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "e755397fbd648ccc1507810c8889ac9e" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 3 "timer" => array:3 [ "start" => 1747098240 "last" => 1747098244...
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.54ms)
  • afterInitialise (11.13MB) (58.12ms)
  • afterRoute (5.03MB) (22.67ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (159μs)
  • afterRenderComponent com_jsjobs (3.16MB) (26.52ms)
  • Before Access::preloadComponents (all components) (251.64KB) (4.57ms)
  • After Access::preloadComponents (all components) (132.72KB) (898μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (12μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (221μs)
  • afterDispatch (2.38MB) (55.3ms)
  • afterRender (31.52MB) (188ms)
  • 1 x afterRender (31.52MB) (50.32%)
    188.06ms
    1 x afterInitialise (11.13MB) (15.55%)
    58.12ms
    1 x afterDispatch (2.38MB) (14.8%)
    55.30ms
    1 x afterRenderComponent com_jsjobs (3.16MB) (7.1%)
    26.52ms
    1 x afterRoute (5.03MB) (6.07%)
    22.67ms
    1 x afterLoad (4.12MB) (4.43%)
    16.54ms
    1 x Before Access::preloadComponents (all components) (251.64KB) (1.22%)
    4.57ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.24%)
    898μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    221μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    159μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    12μs
89 statements were executed, 23 of which were duplicates, 66 unique16.29ms334.25KB
  • SELECT @@SESSION.sql_mode;73μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?141μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 191μ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_id100μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`61μ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` = :guest296μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'76μ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'139μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config134μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'59μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'43μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'43μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'47μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Payments-and-Financial-Transactions-Reconciliations-Officer-job-at-Standard-Chartered-Bank-43699%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Payments-and-Financial-Transactions-Reconciliations-Officer-job-at-Standard-Chartered-Bank-43699%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Payments-and-Financial-Transactions-Reconciliations-Officer-job-at-Standard-Chartered-Bank-43699%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC150μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Payments-and-Financial-Transactions-Reconciliations-Officer-job-at-Standard-Chartered-Bank-43699%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Payments-and-Financial-Transactions-Reconciliations-Officer-job-at-Standard-Chartered-Bank-43699%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Payments-and-Financial-Transactions-Reconciliations-Officer-job-at-Standard-Chartered-Bank-43699%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC143μ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.id103μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'279μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'142μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'226μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'303μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • 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 = 'default_login_from'64μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'64μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'245μ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 = 436991.01ms76.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'229μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 43699313μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'235μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering277μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'141μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'221μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering217μs15.48KB/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 = 'listjob'229μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'63μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'57μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'235μs1.38KB/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 configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'60μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'56μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2131μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2133μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'459μ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'514μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2161μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2118μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2116μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • 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 = 'default'272μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'226μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering148μ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)675μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 083μs920B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2273μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2493μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2870μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38127μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 4099μ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` = 098μ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.lft383μ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.lft241μ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.lft483μ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-Payments-and-Financial-Transactions-Reconciliations-Officer-job-at-Standard-Chartered-Bank-43699' AND `published` = 1144μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Payments-and-Financial-Transactions-Reconciliations-Officer-job-at-Standard-Chartered-Bank-43699'92μs8.94KB/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration256μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'95μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field85μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'87μ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` = 1142μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'147μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`292μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'66μ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 desc242μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`362μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid138μ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` = :muserid170μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Payments-and-Financial-Transactions-Reconciliations-Officer-job-at-Standard-Chartered-Bank-43699'99μ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` = 160μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"194μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES669μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin59μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin65μ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`62μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'125μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'185μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 251792μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?153μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?190μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy