FRN

This collection contains data about the FRNs included within each Form 471.

Usage
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
}]
}
Basic Information Collection Metadata
<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