E-Rate Request for Discount on Services: FRN Status (FCC Form 471 and Related Information)
datahub.usac.org | Last Updated 29 Feb 2024This dataset contains information about the Funding Request Number (FRN) listed within each FCC Form 471 and related information from the E-Rate Productivity Center (EPC).
This dataset has the following 80 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Application Number | application_number | text | Unique application number is generated at the time an applicant begins to file FCC Form 471. Applicants can request funding for multiple services under the same application number. | 231029656 221019976 171028244 161059475 191017910 view top 100 |
| Funding Year | funding_year | text | Funding year for the application. | 2016 2017 2020 2018 2019 view top 100 |
| Billed Entity State | state | text | Applicant's state. | CA TX NY IL OH view top 100 |
| Form Version | form_version | text | Indicates whether the form version of the application is "current" or "original." It can be used to aggregate the data between current and original applications. "Current" is the view of the form processed by USAC. "Original" is the view of the form originally submitted by the applicant upon certification. | Original Current view top 100 |
| Window Status | is_certified_in_window | text | Indicates whether the application has been certified in the window. | In Window Out Of Window view top 100 |
| Billed Entity Number | ben | text | Unique number assigned to the billed entity/ applicant. | 17000574 225495 152265 150246 198892 view top 100 |
| Applicant's Organization Name | organization_name | text | Applicant organization name. | The Catholic Bishop Of Chicago Cenic-Corporation For Education Network Initiatives In California Missouri Research And Education Network Alabama Supercomputer Authority Utah Education And Telehealth Network view top 100 |
| Contact Email | cnct_email | text | Email Address of the main contact provided by the applicant on the FCC Form 471. | erate@erateexchange.com kweiss@erategroup.com rsenturia@erateprogram.com clewis@erateprogram.com ben@erateadvantage.com view top 100 |
| Funding Request Number | funding_request_number | text | Unique funding request number associated with the FCC Form 471. | 1899070624 2399053339 1799100359 1699070407 1699079517 view top 100 |
| Funding Request Status | form_471_frn_status_name | text | Status of the funding request. It includes pending, funded, denied or cancelled. | Pending Funded Cancelled Denied As yet unfunded view top 100 |
| FRN Nickname | nickname | text | Nickname given to an FRN by an applicant when filling their FCC Form 471. | Internet Access Internet Wan Mibs Internal Connections view top 100 |
| Service Type | form_471_service_type_name | text | FRN service type including voice, data transmission and/or Internet access, basic maintenance of internal connections, internal connections, or managed internal broadband services. | Data Transmission and/or Internet Access Internal Connections Voice Basic Maintenance of Internal Connections Managed Internal Broadband Services view top 100 |
| Contract Number | contract_number | text | Contract number for the FRN. It can used to filter records related to a specific contract number. | N/A NA n/a 4000-1 C60910081 view top 100 |
| Type of Contract | contract_type_name | text | Contract type for the FRN including Month-to-Month, Contract or Tariff. | Contract Month-to-Month Tariff view top 100 |
| Number of Bids Received | bid_count | number | Number of bids received by the applicant from service providers in the competitive bidding process. | 1 2 3 4 5 view top 100 |
| Award based on State Master Contract | is_based_on_state_master_contract | text | Indicates whether the contract for the FRN is based on a state master contract. | No Yes view top 100 |
| Based on Multiple Award Schedule? | is_multiple_award | text | Indicates whether a Funding Request is tied to a contract with a multiple award schedule. | No Yes view top 100 |
| FCC Form 470 Application | establishing_form_470 | text | FCC Form 470 application number for the FRN submitted in EPC (FY2016 and later). | 200000716 190000216 160017344 160012458 180001798 view top 100 |
| Old FCC Form 470 Number | old_470_number | text | FCC Form 470 application number for the FRN submitted in the legacy system (FY2015 and earlier). | 855450001286650 335470001069064 755030001093658 629450000542568 562280001348742 view top 100 |
| Was FCC Form 470 Posted? | was_fcc_form_470_posted | text | Indicates whether an FCC Form 470 was posted for the services/products associated with the FRN. | Yes No view top 100 |
| Contract Award Date | award_date | calendar_date | The date the contract was awarded by the applicant to service provider. | 2019-03-26T00:00:00.000 2018-03-22T00:00:00.000 2019-03-27T00:00:00.000 2018-03-21T00:00:00.000 2021-03-24T00:00:00.000 view top 100 |
| Extended Contract Expiration Date | extended_expiration_date | calendar_date | Contract expiration date for contracts that can be extended. | 2025-06-30T00:00:00.000 2026-06-30T00:00:00.000 2020-06-30T00:00:00.000 2023-06-30T00:00:00.000 2024-06-30T00:00:00.000 view top 100 |
| Service Delivery Deadline | service_delivery_deadline | calendar_date | Services must be installed or product must be delivered on or before this date. | 2017-06-30T00:00:00.000 2018-06-30T00:00:00.000 2021-09-30T00:00:00.000 2019-06-30T00:00:00.000 2023-09-30T00:00:00.000 view top 100 |
| Billing Account Number | account_number | text | Billing account number for the billed entity. | N/A Na Tbd New Tba view top 100 |
| Service Provider Name | spin_name | text | Service provider name for the FRN. | Comcast Business Communications CDW Government LLC Charter Communications Operating, LLC AT&T Corp. Verizon Wireless (Cellco Partnership) view top 100 |
| SPAC Filed? | spac_filed | text | Indicates if an FCC Form 473 Service Provider Annual Certification (SPAC) was filed for the Funding Year associated with the FCC Form 471. | Yes No view top 100 |
| Service Provider Number | epc_organization_id | text | A unique nine-digit number assigned to identify the service provider. | 143003990 143005588 143050436 143001192 143000677 view top 100 |
| Voluntary Contract Extension | has_voluntary_extension | text | Indicates whether the contact has voluntary extensions that can be exercised by the applicant for the FRN. | No Yes view top 100 |
| Remaining Contract Extension | remaining_extension_count | number | Remaining number of contract extensions for the FRN. | 2 1 4 3 5 view top 100 |
| Total Remaining Contract Length | total_remaining_months_count | number | Number of months left on the contract for the FRN. | 60 48 36 24 120 view top 100 |
| Pricing Confidentiality | pricing_confidentiality | text | Indicates whether the FRN pricing must be kept confidential and not disclosed to the public. | No Yes view top 100 |
| Pricing Confidentiality Restriction Type | epc_contract_restriction_type_name | text | Type of restriction that enable applicants to make pricing information confidential such as State Law or Statute, Local Rule, Court Order, Contract Executed with Restrictive Terms. | Contract Executed with Restrictive Terms State Law or Statute Local Rule view top 100 |
| Pricing Publication Restriction Citation | restriction_citation | text | Reference to a local law or contract to support pricing confidentiality requests. | Bids are redacted to exclude any references, for both vendors and on any included resumes, financial and trade secrets. Per W.S. 16-4-201 through 16-4-205. In addition, each vendor who has labeled their proposal CONFIDENTIAL will be notifiedand given five (5) business days to either provide a newly redacted version or explain howeach section is confidential according to W.S. 16-4-201 through 16-4-205. contract labeled confidential Item #16 - Nondisclosure (relating to confidential information) Confidentiality Notice: This document including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. contract is marked confidential view top 100 |
| Previous unique FRN | old_funding_request_number | text | Funding Request Number from a previous fund year that is related to the FRN. | 2099071921 1699052171 230012801 2800449 1699138787 view top 100 |
| FCC Form 471 Service Start Date | service_start_date | calendar_date | Current start date of services on FCC Form 471. Updates to the service start date will be reflected in this field. Service start dates impact commitment amounts because they adjust the months of services. | 2016-07-01T00:00:00.000 2017-07-01T00:00:00.000 2020-07-01T00:00:00.000 2018-07-01T00:00:00.000 2019-07-01T00:00:00.000 view top 100 |
| Contract Expiration Date | contract_expiration_date | calendar_date | Contract expiration date for the FRN. If the FRN is for a tariff or month-to-month service this field displays the service end date. This field can be used to filter the 471 applications that have active contracts. | 2017-06-30T00:00:00.000 2018-06-30T00:00:00.000 2019-06-30T00:00:00.000 2021-06-30T00:00:00.000 2020-06-30T00:00:00.000 view top 100 |
| Funding Request Narrative | narrative | text | Narrative for the FRN describing the products and services. | Internet Access Internet Internal Connections Internet access Internet Service view top 100 |
| FRN Total Monthly Recurring Costs | total_monthly_recurring_cost | number | Total pre-discount monthly recurring charges of a funding request. This field can be aggregated at an FRN level to generate metrics across service type, status or entities. This field should not be used to generate metrics at FRN line item level. | 0 1000 500 1500 600 view top 100 |
| FRN Total Monthly Recurring Ineligible Costs | total_monthly_recurring_ineligible_costs | number | Total pre-discount ineligible monthly recurring charges of a funding request. This field can be aggregated at an FRN level to generate metrics across service type or entities. This field should not be used to generate metrics at FRN line Item level. | 0 40 1 30 14.95 view top 100 |
| FRN Total Monthly Recurring Eligible Costs | total_monthly_recurring_eligible_costs | number | Total pre-discount eligible monthly recurring charges of a funding request. This field can be aggregated at an FRN level to generate metrics across service type or entities. This field should not be used to generate metrics at FRN line Item level. | 0 1000 1500 500 1200 view top 100 |
| Months of Service | months_of_service | number | Number of months a service is provided during a funding year for an FRN based on the service start date and end date. | 12 8 9 3 11 view top 100 |
| FRN Total Pre-Discount Eligible Recurring Cost | total_pre_discount_eligible_recurring_costs | number | Total pre-discounted eligible recurring charges of a funding request. It is derived by multiplying the month of service and the pre-discounted monthly recurring charges. | 0 12000 18000 6000 7200 view top 100 |
| FRN Total One-Time Costs | total_one_time_costs | number | Total one-time/non-recurring charge of a funding request. This field can be aggregated at an FRN level to generate metrics across service type or entities. This field should not be used to generate metrics at FRN line Item level. | 0 500 1000 250 200 view top 100 |
| FRN Total Ineligible One-Time Cost | total_ineligible_one_time_costs | number | Total ineligible one-time costs for the FRN level. | 0 1 200 300 500 view top 100 |
| FRN Total Pre-Discount Eligible One-Time Costs | total_pre_discount_eligible_one_time_costs | number | Total pre-discount eligible non-recurring/one-time charges of a funding request. | 0 500 1000 250 750 view top 100 |
| FRN Total Pre-Discount Costs | total_pre_discount_costs | number | Total pre-discount charges of a funding request. This field can be aggregated at an FRN level to generate metrics across service type or entities. This field should not be used to generate metrics at FRN line Item level. | 12000 6000 18000 14400 7200 view top 100 |
| Discount Percentage | dis_pct | number | Discount rate applied to service or equipment for the FRN. | 0.8 0.9 0.5 0.4 0.85 view top 100 |
| Funding Commitment Request | funding_commitment_request | number | The total amount for the Funding Request (FRN) after discount. | 0 7200 10800 8640 4800 view top 100 |
| Fiber Type | form_471_frn_fiber_type_name | text | Fiber type for fiber FRNs including Lit Fiber, Dark Fiber, or Self Provisioned Fiber. | Self Provisioned Dark Fiber Lit Fiber Wireless view top 100 |
| Fiber Sub Type | form_471_frn_fiber_sub_type_name | text | Fiber subtypes for fiber FRNs. Options include maintenance and operation, network equipment, network equipment and maintenance, or special construction. | Maintenance And Operation Special Construction Network Equipment Network Equipment And Maintenance & Operations Microwave view top 100 |
| Equipment Leased | is_lease | text | Indicates whether FRN is for leased dark fiber or IRU (Indefensible Right of Use). | Leased Dark Fiber IRU view top 100 |
| Total Project Plant Route Feet | total_proj_plant_route_feet | number | Total distance between a demark point at an applicant’s location and a service provider’s switching facility or point of presence measured in feet. | 1 1000 750 1500 2000 view top 100 |
| Fiber Average Cost per Foot | avg_cost_per_ft_of_plant | number | Average cost of cabling, infrastructure, and associated hardware divided by the total project plant route feet. | 1 2.7 0 10 2 view top 100 |
| Total Strands Quantity | total_strands_qty | number | Number of actual glass optical fibers inside the cable sheath. | 12 2 6 24 4 view top 100 |
| Number of Eligible Fiber Strands | eligible_strands_qty | number | Number of eligible fiber strands. | 2 12 4 6 24 view top 100 |
| Special Construction State/Tribal Match Amount | state_tribe_match_amt | number | Program provides 1 to 1 dollar match amount in extra Category One fiber special construction funding up to an additional ten percent discount. | 0 1 2500 15000 30000 view top 100 |
| Source of Matching fund | source_of_matching_funds_desc | text | Funding source when the applicant is seeking a state match for fiber FRNs. The E-rate program will provide additional Category One funding (up to 10%) to match state funding for special construction to connect schools and libraries to high-speed broadband services that meet the FCC's long-term capacity broadband goals. | Section 83 of Senate Bill (SB) 75 (Chapter No. 51, Statutes of 2019) allocated seven million five hundred thousand dollars ($7,500,000) from the General Fund for the Broadband Infrastructure Grant (BIG) Program to improve broadband connectivity at California local educational agencies. It required the California Department of Education (CDE) to contract directly with the Corporation for Education Network Initiatives in California (CENIC) to identify external broadband connectivity solutions that provide fiber broadband connectivity to the most poorly connected school sites to allow digital learning opportunities for pupils. In June 2015, the Connecticut legislature passed SB No. 1501, an Act authorizing bonds for capital improvements, including grants-in-aid to public libraries for high-speed connections to the Connecticut Education Network. Full documentation at http://libguides.ctstatelibrary.org/dld/erate/clfcdocs. State of Michigan, Department of Education Arizona Universal Service Fund ARIZONA STATE MATCH FUNDING view top 100 |
| Fiber Installation Cost | total_financed_amt | number | Amount financed for fiber FRNs. | 200 0 2000 400 600 view top 100 |
| Period of Fiber installation financing | number_of_terms | number | Number of months for financing related to fiber FRNs. | 48 36 12 0 24 view top 100 |
| Annual Fiber Interest Rate | annual_interest_rate | number | Annual Interest Rate Associated with a Fiber Application. | 0 0.05 0.04 0.02 0.06 view top 100 |
| Balloon Payment | balloon_payment_desc | text | Balance due payment made at the end of the financing period for fiber installation. | $5000 the last year 50% of outstanding balance plus $1.00. $9500 for the last year view top 100 |
| Special Construction State/Tribal Match Percentage | sc_rate | number | Percentage of discount that is matched by USAC for fiber FRNs under the state matching provision. | 0 0.1 0.05 0.085 0.06 view top 100 |
| Pending Reason | pending_reason | text | Indicates the review status of the Funding request. Pending Reason is limited to Current (Committed) forms. | FCDL Issued Assigned to IR Applicant Documentation Received Returned for Additional Review 15 Day Notice view top 100 |
| Organization Entity Type | organization_entity_type_name | text | Applicant's organization type. | School District School Consortium Library System Library view top 100 |
| Service Start Date | actual_start_date | calendar_date | Service start date from the approved FCC Form 486. Further updates to the service start date are not reflected in this field. | 2016-07-01T00:00:00.000 2017-07-01T00:00:00.000 2020-07-01T00:00:00.000 2018-07-01T00:00:00.000 2019-07-01T00:00:00.000 view top 100 |
| FCC Form 486 Application Number | form_486_no | text | Unique # assigned to the FCC Form 486 | 273482 294356 295239 332810 275598 view top 100 |
| FCC Form 486 Status | f486_case_status | text | Form status for the FCC Form 486 including:- Approved: FCC Form 486 and FRN is approved so invoicing may begin- Partially Approved: FCC Form 486 and FRN is partially approved so invoicing may begin for those FRNs approved. | Approved Partially Approved In Review Denied Cancelled view top 100 |
| Invoicing Ready? | invoicing_ready | text | Invoicing may begin for the FRN as there is an approved FCC Form 486. | Yes No view top 100 |
| Last Date to Invoice | last_date_to_invoice | calendar_date | Last date an Invoice (BEAR or SPI) can be received or postmarked | 2017-10-30T00:00:00.000 2022-01-28T00:00:00.000 2018-10-29T00:00:00.000 2024-01-29T00:00:00.000 2024-10-28T00:00:00.000 view top 100 |
| Wave Sequence Number | wave_sequence_number | number | A number that indicates which wave sequence the funding commitment was issued in. | 1 2 6 3 7 view top 100 |
| Wave Date | fcdl_letter_date | calendar_date | The date of the wave that a funding commitment was issued in. | 2022-04-23T00:00:00.000 2023-04-29T00:00:00.000 2024-04-27T00:00:00.000 2020-05-09T00:00:00.000 2019-04-27T00:00:00.000 view top 100 |
| Date User Generated FCDL | user_generated_fcdl_date | calendar_date | Date a user associated with the BEN clicked on the file in the Newsfeed in EPC to generate the FCDL | 2017-05-26T00:00:00.000 2016-12-12T00:00:00.000 2016-12-19T00:00:00.000 2017-06-09T00:00:00.000 2017-08-11T00:00:00.000 view top 100 |
| FCDL Comment for FCC Form 471 Application | fcdl_comment_app | text | Explanation of FCDL decision at the form level. MR: management reason; CR: cancelled reason; DR: denial reason. | MR1:The applicant did not submit any RAL corrections. MR1:FRN(s) modified in accordance with a RAL request. MR1:The applicant did not submit any RAL corrections.||MR2:The applicant did not submit any RAL corrections. MR1:FRN modified in accordance with a RAL request. MR1:FRN(s) modified in accordance with a RAL request.||MR2:The applicant did not submit any RAL corrections. view top 100 |
| FCDL Comment for FRN | fcdl_comment_frn | text | Explanation of FCDL decision at the FRN level. MR: management reason; CR: cancelled reason; DR: denial reason. | MR1:Approved as submitted. CR1:FRN canceled in consultation with the applicant. MR1:The applicant did not submit any RAL corrections. MR1:Data Transmission and/or Internet Access Services requested in FRN are connected to eligible schools, libraries, and/or NIFs. As a result, the Connection Information questions were modified from “No” to “Yes” on this FRN since services connected to eligible schools, libraries, and/or NIFs are eligible for support. MR1:FRN modified in accordance with a RAL request. view top 100 |
| Appeal Wave Number | appeal_wave_number | text | A number that indicates which appeal wave the revised funding decision was issued in. | 74 136 21 30 7 view top 100 |
| Revised FCDL Date | revised_fcdl_date | calendar_date | Date the applicant FCDL was revised | 2020-04-06T00:00:00.000 2019-01-17T00:00:00.000 2018-06-23T00:00:00.000 2017-09-13T00:00:00.000 2023-10-10T00:00:00.000 view top 100 |
| Invoicing Mode | invoicing_mode | text | Type of invoice to be processed for FRN (SPI: Service Provider Invoice – FCC Form 474, BEAR: Billed Entity Applicant Reimbursement Form – FCC Form 472, or NOT SET (when no form has been received yet for the FY and therefore no invoicing mode has been set). | SPI BEAR NOT SET view top 100 |
| Total Disbursement Amount | total_authorized_disbursement | number | Total net amount disbursed to a service provider or applicant. | 0 7200 10800 8640 4800 view top 100 |
| Post Commitment Rationale | post_commitment_rationale | text | Explanation for the funding request decision made for a post commitment transaction. | 136-The appellant included this FRN in this appeal case in error; therefore, this FRN is dismissed. 187-The Global SPIN Change requested by your Service Provider has been approved. Your FRN funding decision remains the same. 122-The appeal of the FRN was canceled at your request during review of the appeal. 3-Your Service Substitution has been approved. 180-The Global SPIN Change requested by your Service Provider has been approved. Your FRN funding decision remains the same. view top 100 |
| Revised FCDL Comment | revised_fcdl_comment | text | Explanation of RFCDL decision at the form level. | 21-CR1:FRN canceled in consultation with the applicant. 30-CR1:FRN canceled in consultation with the applicant. 32-CR1:FRN canceled in consultation with the applicant. 35-CR1:FRN canceled in consultation with the applicant. 29-CR1:FRN canceled in consultation with the applicant. view top 100 |