29E.25 本次级方案面临的挑战是，核查文件必须手工生成，十分耗时，需要熟练的信息技术人员的干预。要创建该文件，必须从几个来源(“团结”系统和上个月的核查文件)调取信息。一旦这些信息被逐个调取，技术人员就使用若干工具/技术(数据库、宏、数据透视表和查找功能)来编制可用于核查的工作文件。在每次薪金模拟运行后，该程序每月至少重复 3 次。这一程序十分耗时，并且由于需要审查大量的薪金单条目，很容易出现潜在错误付款。对此，本次级方案确定了一个技术可以解决这一问题的领域，并将利用商业智能工具开发和试验一个系统，该系统能够在规定的时间间隔内自动从“团结”系统提取数据，然后利用算法确定和突显需要进一步分析和调查的项目。分析结果随后将自动交付给流程中的上游利益攸关方，包括次级方案 1 和 2，以采取适当的预防行动，从而将资源集中用于预防性定性分析，而不是预付款和事后审查。本次级方案一旦完成，将向其他办事处推广试点结果，以期在其他工作地点实施这一程序。
Internal challenge and response 29E.25 The challenge for the subprogramme was that the verification file must be created manually, which is time-consuming and requires the intervention of skilled information technology technicians. To create the file, information must be retrieved from several sources (Umoja and the previous month’s verification file). Once this information is retrieved individually, the technicians use a combination of tools/techniques (databases, macros, pivot tables and lookup functions) to prepare a working file that can be used for verification. This process is repeated at least three times a month, after every payroll simulation run. The process is time-consuming and prone to potentially erroneous payments owing to the large volume of payroll entries that need to be reviewed. In response, the subprogramme has identified an area where technology could address the issue and will develop and pilot a system, using business intelligence tools, that automatically extracts the data from Umoja at specified intervals and then uses algorithms to identify and highlight those items that require further analysis and investigation. The results from the analysis would then be delivered automatically to the upstream stakeholders in the process, including subprogrammes 1 and 2, to undertake appropriate preventive action, thereby focusing resources on preventive qualitative analysis instead of on advance payments and ex post facto reviews. The subprogramme will reach out to other offices with the pilot results, once completed, with a view to implementing the process in other duty stations.