December 2023 - February 2024
February 5, 2024
Image
The team has been focused on completing a migration of data from Census to GSA. This update covers mid-December to the current week.
Historic data transfer
Single Audit submissions from 2016–present are now available from the GSA FAC, and the Census Bureau is shutting down their data distribution. Single Audits from prior years will appear in our search results. This is a major milestone, and future work will involve documenting the data migration, our continued curation of this data, and improvements to how this data is queried and used.
The migration caused some disruptions to service. With 10 times more data, our system has struggled to keep up with volume for some of our search filters. The most affected filter is the ALN search. Results for this filter show whether an audit contains findings (“Findings My ALN/Findings Other ALN”). Before the migration, this filter applied to small amounts of data, but after adding prior years, this began crashing the system. We've removed this feature to resolve the system strain. Our team is working on a replacement feature to handle the larger amount of data.
What we delivered
We work in an agile manner. That means we have a long-term strategy, medium-term features we work to deliver, and make continuous improvement and bug fixes to the existing product.
Customer experience
We achieved “helpdesk zero” in the last week of January. We had no questions come in on a workday, and we emptied our queue so we had no support questions left to answer. We have continued to empty our question queue on a near-daily basis.
The team currently replies to a ticket within 1.5 hours of receipt, and closes 75% of tickets within 8 hours. The helpdesk remains an excellent place to get timely support.
UX/Design
We completed user testing on navigation changes for FAC.gov. This validated a new site structure that will be easier for users to navigate.
The team finalized a research plan around audit resolution work. We began interviews with audit resolution officials, IG offices, and other users.
Submission improvements
We made multiple improvements to the submission experience. We use research and interviews with our users, as well as issues reported in the helpdesk, to guide this work.
-
Added an SF-SAC summary report, allowing users to review the form data for in-progress and completed audits (PR 3025).
-
Significantly sped up PDF validation (PR 3057).
-
Submitters can now unlock an in-progress audit anytime up to the time of final submission (PR 3136).
-
Synchronization fixes between the audit state and submission checklist (PR 3144).
-
Users no longer have to log out and back in for changes to user access (e.g. changing the Auditee Certifying Official email address) to take effect. (PR 3194).
-
Simplified the submission checklist after an audit is validated and locked for certification. (PR 3197).
-
Improved validations regarding reference numbers (PR 3221).
-
Added the ability to download Audit Report Packages and the SF-SAC for in-progress review (PR 3212).
-
Many search performance improvements (PR 3283).
-
Fixes around our new “testing” banner and pre-certification report generation (PRs 3261, 3326, 3333).
-
Improved validation error reporting around ALNs (PR 3230).
-
Improved validation and error reporting around empty/zero loan balances (PR 3335).
Intake, Search, and API
We also made multiple improvements to the audit search experience.
-
A small update to SF-SAC summary exports (PR 3296) that adds ALNs to the Federal Awards sheet.
-
Fixed a performance bug within the FAC API (PR 3355).
What's next?
We're anticipating March to be a busy month. To support this, we'll be:
-
Focusing on performance improvements and growing our team’s capacity for user support so that the auditors and auditees are well-supported during this time.
-
Providing documentation regarding the migration of Census data to GSA and how to use it effectively.
-
Improving search, both to support Federal oversight work as well as the public’s experience with FAC data.
-
Adding Tribal data access to the API (PR 3359) and writing documentation and legal agreements to accompany it.