U.S. Department of State Fiscal Year 2020 Agency Financial Report

B usiness I ntelligence P rogram The Department’s Business Intelligence program consists of the COAST Reporting, COAST Payroll Reporting, and the Global BI Reporting. Global BI enables users to access financial information from standard, prepared reports or customized queries. It also provides, on a daily basis, critical financial information to the Department’s enterprise data warehouse. During 2020, the GFMS data warehouse (DW) was retired and a migration of all reporting content into the Global BI reporting tool was completed. The GFMS DW was officially retired on October 1, 2020. In 2017, the Department implemented the Global BI application, building on the infrastructure being used for the DW, and adding an in-memory appliance and a new data analytics tool. In 2018, the Global BI application continued to be used to import, reconcile, and export data that meets the requirements of the DATA Act and FADR. The Global BI application was updated to complete the full suite of our systems. The Global Foreign Affairs Compensation System (GFACS) will leverage a rules-based, table-driven architecture to promote compliance with the complex statutes found across the Foreign and Civil Service Acts and local laws and practices applicable to all the countries in which civilian agencies operate. The last pay module to be implemented in GFACS is American payroll. It is currently in final testing prior to full implementation. The web-based global time and attendance product, based on the same technology as GFACS, will follow the American payroll implementation. This product has the capability of remote accessibility, electronic routing and approval, and self-service features. As a result, it will bring a more efficient and modern process to the Department’s workforce. 150 | U ni ted S tates D epartment of S tate 2020 A gency F inanci al R eport OTHER INFORMATION | RESOURCE MANAGEMENT SYSTEMS SUMMARY