The New Jersey Department of Education (NJDOE) Office of Grants Management (OGM) understands the need to be compliant with FFATA reporting in accordance with the Uniform Guidance. Internal controls and processes are in place to ensure NJDOE’s FFATA reporting process is working efficiently and timely...
The New Jersey Department of Education (NJDOE) Office of Grants Management (OGM) understands the need to be compliant with FFATA reporting in accordance with the Uniform Guidance. Internal controls and processes are in place to ensure NJDOE’s FFATA reporting process is working efficiently and timely. This noncompliance finding is not due to a lack of controls within NJDOE but lies squarely on system issues at SAM.gov and the FFATA Subaward Reporting System (FSRS) sites and until the issues listed below are corrected on these federal system sites, NJDOE will continue to be noncompliant with timely FFATA reporting.
Issues with the SAM.gov and FSRS sites:
• SAM.gov has approved NJDOE’s local education agency (LEA) registrations without a ZIP+4, but FSRS reporting system for FFATA uploads requires ZIP+4 for each LEA. The two systems use the same database, which means information registered on SAM.gov feeds directly into the FSRS system. However, because FSRS batch uploads require a ZIP+4, those LEAs that were approved by SAM.gov without a ZIP+4 during the registration process, are rejected from the FFATA report batch upload. There is an option to manually load each LEA and their details into the system, but the process becomes incredibly time consuming, given the 700+ LEAs in the state, the number of federal awards granted, and the steps for identifying & removing rejected LEAs from the batch upload.
• Issues NJDOE has with SAM.gov and FSRS have been shared with the federal helpdesk and a USED representative without avail, as the systematic issue remains unresolved and continues to delay our FFATA reporting process.
• There are several rural LEAs in the state that do not have a ZIP+4. These LEAs will continue to be rejected from the batch upload, delaying our FFATA reporting process, if SAM.gov and FSRS do not come up with a viable solution.
• There were a number of LEAs that were continuously rejected from the upload by FSRS for no obvious reasons. The error message received was the same exact error we receive for incorrect zip codes. After spending much time investigating the cause with the helpdesk support, it was identified that FSRS did not update their system to reflect the Congressional District code changes during New Jersey’s redistricting process.
• The FSRS system rejects batch uploads if a single lower-case SAM UEIs is entered in the batch file. However, SAM.gov search box and the FSRS manual uploads are not case sensitive. Batch uploads are the only place where SAM UEIs are case sensitive. Further, this information is not included in any of the FSRS User Guides or manuals. I have shared this with the FSRS helpdesk, but no solution was provided. Again, this discrepancy in their system affects and delays our FFATA reporting processes.
NJDOE dedicated personnel, including the director of OGM, continuously work with SAM.gov, FSRS system, and both system sites’ help desks, to bring to light the issues mentioned above in order to express the urgent need for corrective actions at the federal system sites to allow for timely FFATA reporting. In addition internal controls and procedures are in place at NJDOE related to FFATA reporting and corrective actions are constantly performed in real time to perform the below NJDOE Internal Controls and Procedures. Some of these procedures include reviewing internal SAM applications and troubleshooting with NJDOE’s local education agencies (LEAs) to correct data in the application and resubmit to the federal reporting system sites with more detail included below.
NJDOE Internal Controls and Procedures:
• Due to the large number of LEAs in the state (700+), each FFATA report must be submitted via batch upload, which saves an enormous amount of time it takes to input data manually for every single LEA, for every grant. To address this need and to expedite the process, our vendor has created a reporting tool that generates a FFATA batch report.
• We have been contacting the federal helpdesk to address the issues on their sites and asking for support. Some of those tickets were closed without providing any support and most were not helpful.
• We have created and implemented an in-house System for Award Management (SAM) application, mandatory for all of our federal grant recipients. This was done specifically for FFATA reporting purposes to ensure data in these applications are directly tied to the FFATA batch reports.
• The SAM applications go through a thorough review process, where data entered by the districts is compared with the data registered with SAM.gov (applicants are required to upload a copy of their Entity Overview Record, issued by SAM.gov).
• SAM applications are returned for changes whenever an applicant has entered data that is inconsistent with data on SAM.gov (i.e.. Incorrect SAM UEI, incorrect zip code, incorrect zip+4, incorrect City name).
• We have asked many of our districts to contact SAM.gov and update their physical address information to include the full 9-digit zip code, which was SAM.gov reviewers’ oversight. Our school districts have commented that this process can take months.
• We are communicating with our districts/applicants on a daily basis through the review summary checklist, outlining the changes that must be made, as well as by email and phone.
• We have implemented an automatic messaging system, where applicants are reminded to update their SAM registration expiration date, multiple times a month leading up to their expiration date.
Due to the system discrepancy in the FSRS system’s batch upload, we had to create a workaround pertaining to the district’s SAM UEIs. As stated above, SAM UEIs, in batch FFATA reports, are case sensitive while not case sensitive anywhere else in the two system sites. We have updated our instructions in NJDOE’s SAM application and have added another layer of application review, to ensure that all UEIs entered are in all capital letters. Because the federal helpdesk has ignored this discrepancy and did not resolve the issue, we are obligated to take additional steps and spend additional time on FFATA batch reports.
COMPLETION DATE/
CONTACT PERSON
Indeterminate – Completion based on federal implementation of fixes to SAM.gov and FSRS portal as noted in views.
Martin Egan, Director
NJDOE Office of Grants
(609) 376-9089
Martin.Egan@doe.nj.gov