FRN
This collection contains data about the FRNs included within each Form 471.
GET https:
//data.usac.org/api/sl/form471/v1/frnCollection
{
"@odata.context"
:
"$metadata#frnCollection"
,
"value"
: [{
"accountNumber"
:
"DA16471 USCellular"
,
"annualInterestRate"
:
null
,
"applicationNumber"
: 161037973,
"averageCostPerFootofOutsidePlant"
:
null
,
"awardDate"
:
"04/22/2016"
,
"baloonPayment"
:
null
,
"ben"
:
"209589"
,
"bidCount"
: 1,
"billedEntityName"
:
"DILLARD ACADEMY"
,
"contactEmail"
:
"eratetechnology@carolina.rr.com"
,
"contractExpiryDate"
:
"06/30/2017"
,
"contractNumber"
:
"na"
,
"contractType"
:
"Contract"
,
"discountRate"
: 90.0,
"establishingFCCForm470"
:
"160036386"
,
"expirationDate"
:
null
,
"fccForm470Posted"
:
"Yes"
,
"fiberSubtype"
:
null
,
"fiberType"
:
null
,
"formView"
:
"Current"
,
"frn"
:
"1699088946"
,
"frnNumberPreviousYear"
:
"2767573"
,
"frnStatus"
:
"Funded"
,
"fundingCommitmentRequest"
: 29915.57,
"fundingRequestNickname"
:
"EarthLink"
,
"includesVoluntaryExtensions"
:
"No"
,
"isBasedOnStateMasterContract"
:
"No"
,
"isLease"
:
null
,
"isMultipleAward"
:
"No"
,
"matchAmount"
:
null
,
"narrative"
:
"US Cellular, 8 lines"
,
"numberofERateEligibleStrands"
:
null
,
"pricingConfidentiality"
:
"No"
,
"pricingConfidentialityType"
:
null
,
"remainingVoluntaryExtensions"
:
null
,
"restrictionCitation"
:
null
,
"serviceProviderName"
:
"USCOC of Greater North Carolina, LLC"
,
"serviceProviderNumber"
:
"143000555"
,
"serviceStartDate"
:
"07/01/2016"
,
"serviceType"
:
"Data Transmission and/or Internet Access"
,
"sourceOfMatchingFunds"
:
null
,
"specialConstructionStateOrTribalMatchPercentage"
:
null
,
"totalAmountFinanced"
:
null
,
"totalEligiblePreDiscountOneTimeCharges"
: 0.0,
"totalEligiblePreDiscountRecurringCharges"
: 33239.52,
"totalIneligibleOneTimeCharges"
: 0.0,
"totalMonthlyEligibleCharges"
: 2769.96,
"totalMonthlyIneligibleCharges"
: 0.0,
"totalMonthlyRecurringCharges"
: 2769.96,
"totalNumberOfTerms"
:
null
,
"totalNumberofMonthsofService"
: 12,
"totalOneTimeCharges"
: 0.0,
"totalPreDiscountCharges"
: 33239.52,
"totalProjectPlantRouteFeet"
:
null
,
"totalRemainingContractLength"
:
null
,
"totalStrands"
:
null
,
"userEnteredEstablishingFCCForm470"
:
null
}, {
"accountNumber"
:
null
,
"annualInterestRate"
:
null
,
"applicationNumber"
: 161037978,
"averageCostPerFootofOutsidePlant"
:
null
,
"awardDate"
:
null
,
"baloonPayment"
:
null
,
"ben"
:
"5703"
,
"bidCount"
: 0,
"billedEntityName"
:
"GREENS FARMS ACADEMY"
,
"contactEmail"
:
"kweiss@erategroup.com"
,
"contractExpiryDate"
:
"06/30/2017"
,
"contractNumber"
:
null
,
"contractType"
:
"Tariff"
,
"discountRate"
: 10.0,
"establishingFCCForm470"
:
"160033727"
,
"expirationDate"
:
null
,
"fccForm470Posted"
:
"Yes"
,
"fiberSubtype"
:
null
,
"fiberType"
:
null
,
"formView"
:
"Current"
,
"frn"
:
"1699081249"
,
"frnNumberPreviousYear"
:
null
,
"frnStatus"
:
"Funded"
,
"fundingCommitmentRequest"
: 302.4,
"fundingRequestNickname"
:
"SNET - Tel "
,
"includesVoluntaryExtensions"
:
"No"
,
"isBasedOnStateMasterContract"
:
"No"
,
"isLease"
:
null
,
"isMultipleAward"
:
"No"
,
"matchAmount"
:
null
,
"narrative"
:
"Local/Long Distance Service includes eligible monthly charges plus eligible taxes & surcharges"
,
"numberofERateEligibleStrands"
:
null
,
"pricingConfidentiality"
:
"No"
,
"pricingConfidentialityType"
:
null
,
"remainingVoluntaryExtensions"
:
null
,
"restrictionCitation"
:
null
,
"serviceProviderName"
:
"The Southern New England Telephone Company"
,
"serviceProviderNumber"
:
"143001305"
,
"serviceStartDate"
:
"07/01/2016"
,
"serviceType"
:
"Voice"
,
"sourceOfMatchingFunds"
:
null
,
"specialConstructionStateOrTribalMatchPercentage"
:
null
,
"totalAmountFinanced"
:
null
,
"totalEligiblePreDiscountOneTimeCharges"
: 0.0,
"totalEligiblePreDiscountRecurringCharges"
: 3024.0,
"totalIneligibleOneTimeCharges"
: 0.0,
"totalMonthlyEligibleCharges"
: 252.0,
"totalMonthlyIneligibleCharges"
: 0.0,
"totalMonthlyRecurringCharges"
: 252.0,
"totalNumberOfTerms"
:
null
,
"totalNumberofMonthsofService"
: 12,
"totalOneTimeCharges"
: 0.0,
"totalPreDiscountCharges"
: 3024.0,
"totalProjectPlantRouteFeet"
:
null
,
"totalRemainingContractLength"
:
null
,
"totalStrands"
:
null
,
"userEnteredEstablishingFCCForm470"
:
null
}]
}
<
EntityType
Name
=
"frn"
>
<
Key
>
<
PropertyRef
Name
=
"formView"
/>
<
PropertyRef
Name
=
"applicationNumber"
/>
<
PropertyRef
Name
=
"frn"
/>
</
Key
>
<
Property
Name
=
"accountNumber"
Type
=
"Edm.String"
/>
<
Property
Name
=
"annualInterestRate"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"applicationNumber"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"averageCostPerFootofOutsidePlant"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"awardDate"
Type
=
"Edm.String"
/>
<
Property
Name
=
"baloonPayment"
Type
=
"Edm.String"
/>
<
Property
Name
=
"ben"
Type
=
"Edm.String"
/>
<
Property
Name
=
"bidCount"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"billedEntityName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"contactEmail"
Type
=
"Edm.String"
/>
<
Property
Name
=
"contractExpiryDate"
Type
=
"Edm.String"
/>
<
Property
Name
=
"contractNumber"
Type
=
"Edm.String"
/>
<
Property
Name
=
"contractType"
Type
=
"Edm.String"
/>
<
Property
Name
=
"discountRate"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"establishingFCCForm470"
Type
=
"Edm.String"
/>
<
Property
Name
=
"expirationDate"
Type
=
"Edm.String"
/>
<
Property
Name
=
"fccForm470Posted"
Type
=
"Edm.String"
/>
<
Property
Name
=
"fiberSubtype"
Type
=
"Edm.String"
/>
<
Property
Name
=
"fiberType"
Type
=
"Edm.String"
/>
<
Property
Name
=
"formView"
Type
=
"Edm.String"
/>
<
Property
Name
=
"frn"
Type
=
"Edm.String"
/>
<
Property
Name
=
"frnNumberPreviousYear"
Type
=
"Edm.String"
/>
<
Property
Name
=
"frnStatus"
Type
=
"Edm.String"
/>
<
Property
Name
=
"fundingCommitmentRequest"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"fundingRequestNickname"
Type
=
"Edm.String"
/>
<
Property
Name
=
"includesVoluntaryExtensions"
Type
=
"Edm.String"
/>
<
Property
Name
=
"isBasedOnStateMasterContract"
Type
=
"Edm.String"
/>
<
Property
Name
=
"isLease"
Type
=
"Edm.String"
/>
<
Property
Name
=
"isMultipleAward"
Type
=
"Edm.String"
/>
<
Property
Name
=
"matchAmount"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"narrative"
Type
=
"Edm.String"
/>
<
Property
Name
=
"numberofERateEligibleStrands"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"pricingConfidentiality"
Type
=
"Edm.String"
/>
<
Property
Name
=
"pricingConfidentialityType"
Type
=
"Edm.String"
/>
<
Property
Name
=
"remainingVoluntaryExtensions"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"restrictionCitation"
Type
=
"Edm.String"
/>
<
Property
Name
=
"serviceProviderName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"serviceProviderNumber"
Type
=
"Edm.String"
/>
<
Property
Name
=
"serviceStartDate"
Type
=
"Edm.String"
/>
<
Property
Name
=
"serviceType"
Type
=
"Edm.String"
/>
<
Property
Name
=
"sourceOfMatchingFunds"
Type
=
"Edm.String"
/>
<
Property
Name
=
"specialConstructionStateOrTribalMatchPercentage"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"totalAmountFinanced"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"totalEligiblePreDiscountOneTimeCharges"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"totalEligiblePreDiscountRecurringCharges"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"totalIneligibleOneTimeCharges"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"totalMonthlyEligibleCharges"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"totalMonthlyIneligibleCharges"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"totalMonthlyRecurringCharges"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"totalNumberOfTerms"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"totalNumberofMonthsofService"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"totalOneTimeCharges"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"totalPreDiscountCharges"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"totalProjectPlantRouteFeet"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"totalRemainingContractLength"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"totalStrands"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"userEnteredEstablishingFCCForm470"
Type
=
"Edm.String"
/>
<
NavigationProperty
Name
=
"FRNLineItem"
Type
=
"Collection(loc.usac.data.sl.form471.v1.frnLineItem)"
Partner
=
"FRN"
/>
<
NavigationProperty
Name
=
"Form471"
Type
=
"loc.usac.data.sl.form471.v1.basicInformation"
>
<
ReferentialConstraint
Property
=
"formView"
ReferencedProperty
=
"formView"
/>
<
ReferentialConstraint
Property
=
"applicationNumber"
ReferencedProperty
=
"applicationNumber"
/>
</
NavigationProperty
>
</
EntityType
>
Data Dictionary
Field |
Description |
accountNumber |
Account number for applicant with the Service Provider for the FRN |
annualInterestRate |
Special Construction Annual Interest Rate |
applicationNumber |
Unique number assigned to the FCC Form 471 |
averageCostPerFootofOutsidePlant |
Fiber average cost per foot outside the plant |
awardDate |
Award date |
baloonPayment |
If the installment agreement includes a balloon payment. |
ben |
Billed Entity Number |
bidCount |
How many bids were received for this contract? |
billedEntityName |
The name of the Billed Entity |
contactEmail |
Contact E-mail |
contractExpiryDate |
Contract Expiration Date |
contractNumber |
Contract number for FRN |
contractType |
Contract type |
discountRate |
Discount rate for the service |
establishingFCCForm470 |
FCC Form 470 for the FRN |
expirationDate |
Contract expiration date |
fccForm470Posted |
Was an FCC Form 470 posted for the product and/or services you are requesting? |
fiberSubtype |
Maintenance and operation, network equipment, network equipment and maintenance, or special construction. |
fiberType |
Lit fiber, dark fiber, or self-provisioned fiber. |
formView |
indicates if the form is the Original or Current version |
frn |
Unique number assigned to the Funding Request |
frnNumberPreviousYear |
Funding Request Number from a previous Funding Year. |
frnStatus |
FRN Status |
fundingCommitmentRequest |
Amount requested for the FRN |
fundingRequestNickname |
Applicant created name for the FRN |
includesVoluntaryExtensions |
Does the agreement include voluntary extensions? |
isBasedOnStateMasterContract |
Based on State Master Contract? |
isLease |
Leased or IRU |
isMultipleAward |
Based on a multiple award schedule? |
matchAmount |
State or tribal match amount for your E-rate special construction funding request |
narrative |
Narrative describing the Funding Request. |
numberofERateEligibleStrands |
Number of E-rate Eligible Strands |
pricingConfidentiality |
Does the pricing for this service need to remain private so it is not shared with the public |
pricingConfidentialityType |
Price is confidential due to one of the following reasons: State Law or Statue, Local Rule, Court Order, Contract Executed with Restrictive Terms. |
Remaining Voluntary Extensions |
How many remaining extensions exist |
restrictionCitation |
Narrative citing the law or statue or contract. |
serviceProviderName |
Service Provider Name |
serviceProviderNumber |
Service Provider Number |
serviceStartDate |
Service Start Date |
serviceType |
Service type for the FRN: Voice, Data Transmission and/or Internet Access, Basic Maintenance of Internal Connections, or Internal Connections Managed Internal Broadband Services |
sourceOfMatchingFunds |
Source of matching funds (e.g. state, tribal) |
specialConstructionStateOrTribalMatchPercentage |
% of state or tribal match for special construction for fiber |
totalAmountFinanced |
Amount financed for fiber installation |
totalEligiblePreDiscountOneTimeCharges |
This amount is calculated by multiplying the One-time Eligible Cost times the One-time Quantity |
totalEligiblePreDiscountRecurringCharges |
This amount is calculated by multiplying the Total Monthly Eligible Recurring Costs times the Months of Service. |
totalIneligibleOneTimeCharges |
Total ineligible charges for FRNB line items |
totalMonthlyEligibleCharges |
Total monthly charges eligible for support. |
totalMonthlyIneligibleCharges |
Total monthly ineligible charges for FRN line items |
totalMonthlyRecurringCharges |
Total monthly amount charged by your service provider for FRN line items |
totalNumberofMonthsofService |
This was calculated based on the dates you entered on the FRN. If this FRN is based on a contract, this is the number of months between the Service Start Date and the Contract Expiration Date. If this FRN is either Tariff or Month-to-Month, this is the number of months between the Service Start Date and the Service End Date. In both cases, the number of months is always rounded up and cannot exceed 12 months. |
totalNumberOfTerms |
Total Number of Terms (In Months) for financing of fiber installation |
totalOneTimeCharges |
This is the one-time amount charged by your service provider for FRN lines items |
totalPreDiscountCharges |
This amount is calculated by summing the Total Monthly Eligible Recurring Costs and the Total Eligible One-time Costs |
totalProjectPlantRouteFeet |
Fiber total project plant route feet |
totalRemainingContractLength |
Total Remaining Contract Length |
totalStrands |
Total number of fiber strands |
userEnteredEstablishingFCCForm470 |
User-entered establishing FCC Form 470 |