• Applicants
  • Step 1: Determine Eligibility
  • Step 2: Develop a Technology Plan
  • Step 3: Open a Competitive Bidding Process
  • Step 4: Select a Service Provider
  • Step 5: Calculate the Discount Level
  • Step 6: Determine Your Eligible Services
  • Step 7: Submit Your Application for Program Support
  • Step 8: Undergo Application Review
  • Step 9: Receive Your Funding Decision
  • Step 10: Begin Receipt of Services
  • Step 11: Invoice USAC
• Service Providers
  • Step 1: Obtain a Service Provider Identification Number
  • Step 2: Search Applicant Requests for Service
  • Step 3: Respond to Applicant Requests
  • Step 4: Applicants Select Service Provider
  • Step 5: Assist Applicants with Application Review
  • Step 6: Receive Funding Commitment Decision Letter
  • Step 7: Begin Providing Services
  • Step 8: File Annual Certification
  • Step 9: Invoice USAC

About the Schools and Libraries Program:

• Overview of the Program
• Overview of the Process
• Outreach and Training
• Site Visits
• Filing Appeals
• Understanding Audits

Schools and Libraries Tools:

• Apply Online
• Commitments
• Submit a Question
• Latest News
• Calendar/Reminders
• Required Forms
• Reference Area
• Search Tools
• Search Commitments
• Data Retrieval Tool
• Deadlines Tool
• Form 470 Search Posted
• Form 470 Download Reports
• Form 471 Application Display
• Form 471 Application Status
• FRN Extension Table
• Billed Entity Number Search
• Service Provider Info by SPIN
• SPIN Contact Search
• Tech Plan Approver Locator
• Two-in-Five Tool
• Eligible Products Database
• Eligible Services List
• Applicant PIN System
• Changes and Corrections
• Suspensions and Debarments
• Program Compliance - Whistleblower Hotline
• Submitting A Complaint

Data Retrieval Tool - Applications, Funding Commitments & Disbursements

Data Retrieval Tool

This tool allows searches for information related to applications, funding commitments, and disbursements.

Data Requests Instructions

The Funding Request Data Retrieval Tool can be accessed by clicking here.  More information about the tool is located below.
The three-step tool beginning on the next screen provides access to expanded Services Ordered and Certification Form (Form 471) and Funding Request Number (FRN) data.  The steps are as follows:

Step 1:  Enter the criteria for your data search

This screen allows you to define the parameters of your search.
Required Criteria
These fields must be entered to produce a file.  You will only be allowed to choose one option from each drop down list.

• Funding Year - The Funding Year for which you are requesting data.

*(At least one of State, BEN and SPIN is required)

• *State - The state for which you are requesting data. 
• *Billed Entity Number - This limits your results to the BEN you enter. The result will include all FRNs associated with that BEN.
• *SPIN - This limits your results to all FRNs featuring that SPIN for the FY and State selected.

Optional Criteria
These fields can be entered to limit the results of your query by returning only data matching your selected criteria.

1. FRN Service Type - The category (or categories) of service for which you are requesting data.
2. Type of 471 Application - The type of application(s) for which you are requesting data.
3. 471 Application Number - This limits your results to the Form 471 Application Number you enter.  The result will include all FRNs associated with that Application Number.
4. FRN - This limits your results to a single FRN.
5. Wave Number - This limits your results to funding decisions issued in the Funding Year and Wave Number you indicate. You must enter a three character Wave Number. For example, for Wave 4, enter "004". For Wave 10B, enter "10B".
6. Appeal Wave Number - This limits your results to funding decisions issued in the Funding Year and Wave Number you indicate. You must enter a three character Wave Number. For example, for Wave 4, enter "004". For Wave 10B, enter "10B".

The default criteria for "FRN Service Type" and "Type of 471 Application" are "All of the above". 
Once you've entered the desired criteria, choose ">>Select Data Points" or ">>Select Standard Report".

Step 2:  Select your data points (This step will be skipped if you select the standard report in step 1)

This screen allows you to select the data points you want to view in your data file.  If you want to select all the data points, simply click the check box next to the "SELECT ALL" option.  Otherwise, select checkboxes next to the data points you want in the data file.
Please note that the 471 Application Number and the FRN will ALWAYS appear in the data file, regardless of what other data points you choose.
A complete list of field names and descriptions can be viewed on the Field Names and Descriptions page.
When finished selecting data points, scroll to the bottom and click on the "Build Data File!" button.

Step 3:  Download data file

If Report Type of "Excel" was selected in Step 1:

The Excel file will be displayed in a separate window.

If Report Type of "Text" was selected in Step 1:

This screen incorporates the data file download process.  Simply follow the instructions on the screen to download the text file to your computer.  The data will be returned to you in a tab-delimited file.  For help with importing the tab-delimited file into Excel 2000, instructions are available here.

Special Notes

1. If an FCDL has not been issued for an FRN, the following conditions apply:
   1. Total amount Committed by USAC, Commitment Status, Commitment Status Text and Date of FCDL will be blank in the results and
   2. Item 23 results will reflect data featured on the original Form 471, whether entered by the Applicant online or by USAC from a paper Form 471.  These will appear in the columns prefixed by "ORIG".   The columns prefixed by "COMM" will be blank.

2. If an FCDL has been issued for an FRN:
   1. Data will appear for FRNs that have been committed or denied,
   2. FRNs with a Pending Status will not appear,
   3. Committed data reflects what is stored in USAC's Commitment Database today (i.e., data reflects any commitments for meritorious appeals, as well as Form 486 and Form 500 adjustments and other funding adjustments, if applicable to that FRN),
   4. Both committed and original data will be shown if a committed FRN is different than the FRN as originally entered into USAC's system and
   5. Results prefixed by "ORIG" will be blank if a committed FRN is the same as the original data.
   6. Commitment data will appear one day after the date of the FCDL.

 

3. If an Applicant has not yet submitted a Form 486 to USAC, the "FRN service start date as shown on the Form 486" field will be blank.

 

4. The database used by this tool contains only non-canceled applications that meet the window filing requirements for that funding year.

 

5. The data request will show by funding request number (FRN) the funding that has been AUTHORIZED FOR DISBURSEMENT to date. It is possible that an authorization for an amount was approved, but no disbursement has yet been made for that amount. If you have questions about an amount, please contact the service provider on that FRN.

 

6. If the authorized to disbursed amount is greater than the committed amount for a specific FRN, this indicates that USAC reduced the funding commitment after it had authorized an amount for disbursement. If funds were disbursed in excess of the adjusted commitment for that FRN, USAC seeks recovery of those funds.

Support

Although USAC has thoroughly tested this data retrieval system with regard to functionality and data integrity, please contact us if:

• You experience technical problems with the filter and/or download process
• You identify a discrepancy between the data in the downloaded file and an official correspondence from USAC.

You may call USAC's Client Service Bureau at 1-888-203-8100 or submit an email via our Data Retrieval Help Form.