FRN Line Items

This collection contains data about the FRN line items included within each Form 471.

Usage
GET https://data.usac.org/api/sl/form471/v1/frnLineItemCollection
 
{
"@odata.context": "$metadata#frnLineItemCollection",
"value": [{
"applicationNumber": 161015206,
"basicFirewallProtection": "No",
"ben": "125548",
"billedEntityName": "WARREN COUNTY SCHOOL DISTRICT",
"burstableSpeed": null,
"burstableSpeedUnits": null,
"connectionDirectlyToSchoolOrLibraryOrNIF": "No",
"connectionSupportsServiceToSchoolOrLibraryOrNIF": "Yes",
"connectionUsedBy": "All buildings/sites listed",
"contactEmail": "collopyb@wcsdpa.org",
"downloadSpeed": 1.0,
"downloadSpeedUnits": "Mbps",
"formView": "Original",
"frn": "1699048824",
"function": "Miscellaneous",
"installationPriceIncluded": "No",
"leaseOrNonPurchaseAgreement": "No",
"lineItem": "1699048824.003",
"make": null,
"model": null,
"monthlyQuantity": 1,
"monthlyRecurringUnitCost": 263.25,
"monthlyRecurringUnitEligibleCosts": 263.25,
"monthlyRecurringUnitIneligibleCosts": 0.0,
"monthsOfService": 12,
"oneTimeEligibleUnitCost": 0.0,
"oneTimeIneligibleUnitCosts": 0.0,
"oneTimeQuantity": 0,
"oneTimeUnitCost": 0.0,
"otherManufacture": null,
"preDiscountExtendedEligibleLineItemCost": 3159.0,
"purpose": "Data Connection between two or more sites entirely within the applicant¬タルs network",
"totalEligibleOneTimeCosts": 0.0,
"totalEligibleRecurringCosts": 3159.0,
"totalMonthlyEligibleRecurringCosts": 263.25,
"typeOfProduct": "Taxes and USF Fees",
"unit": null,
"uploadSpeed": 1.0,
"uploadSpeedUnits": "Mbps"
}, {
"applicationNumber": 161011428,
"basicFirewallProtection": "No",
"ben": "123522",
"billedEntityName": "FRENCHTOWN SCHOOL DISTRICT",
"burstableSpeed": null,
"burstableSpeedUnits": null,
"connectionDirectlyToSchoolOrLibraryOrNIF": "No",
"connectionSupportsServiceToSchoolOrLibraryOrNIF": "No",
"connectionUsedBy": null,
"contactEmail": "dbelden@eratespecialist.org",
"downloadSpeed": null,
"downloadSpeedUnits": null,
"formView": "Original",
"frn": "1699018324",
"function": "Voice",
"installationPriceIncluded": "No",
"leaseOrNonPurchaseAgreement": "No",
"lineItem": "1699018324.001",
"make": null,
"model": null,
"monthlyQuantity": 1,
"monthlyRecurringUnitCost": 235.0,
"monthlyRecurringUnitEligibleCosts": 235.0,
"monthlyRecurringUnitIneligibleCosts": 0.0,
"monthsOfService": 12,
"oneTimeEligibleUnitCost": 0.0,
"oneTimeIneligibleUnitCosts": 0.0,
"oneTimeQuantity": 0,
"oneTimeUnitCost": 0.0,
"otherManufacture": null,
"preDiscountExtendedEligibleLineItemCost": 2820.0,
"purpose": null,
"totalEligibleOneTimeCosts": 0.0,
"totalEligibleRecurringCosts": 2820.0,
"totalMonthlyEligibleRecurringCosts": 235.0,
"typeOfProduct": "Local/Long Distance Service",
"unit": null,
"uploadSpeed": null,
"uploadSpeedUnits": null
}]
}
Basic Information Collection Metadata
<EntityType Name="frnLineItem">
<Key>
<PropertyRef Name="formView"/>
<PropertyRef Name="applicationNumber"/>
<PropertyRef Name="frn"/>
<PropertyRef Name="lineItem"/>
</Key>
<Property Name="applicationNumber" Type="Edm.Int32"/>
<Property Name="basicFirewallProtection" Type="Edm.String"/>
<Property Name="ben" Type="Edm.String"/>
<Property Name="billedEntityName" Type="Edm.String"/>
<Property Name="burstableSpeed" Type="Edm.Double"/>
<Property Name="burstableSpeedUnits" Type="Edm.String"/>
<Property Name="connectionDirectlyToSchoolOrLibraryOrNIF" Type="Edm.String"/>
<Property Name="connectionSupportsServiceToSchoolOrLibraryOrNIF" Type="Edm.String"/>
<Property Name="connectionUsedBy" Type="Edm.String"/>
<Property Name="contactEmail" Type="Edm.String"/>
<Property Name="downloadSpeed" Type="Edm.Double"/>
<Property Name="downloadSpeedUnits" Type="Edm.String"/>
<Property Name="formView" Type="Edm.String"/>
<Property Name="frn" Type="Edm.String"/>
<Property Name="function" Type="Edm.String"/>
<Property Name="installationPriceIncluded" Type="Edm.String"/>
<Property Name="leaseOrNonPurchaseAgreement" Type="Edm.String"/>
<Property Name="lineItem" Type="Edm.String"/>
<Property Name="make" Type="Edm.String"/>
<Property Name="model" Type="Edm.String"/>
<Property Name="monthlyQuantity" Type="Edm.Int32"/>
<Property Name="monthlyRecurringUnitCost" Type="Edm.Double"/>
<Property Name="monthlyRecurringUnitEligibleCosts" Type="Edm.Double"/>
<Property Name="monthlyRecurringUnitIneligibleCosts" Type="Edm.Double"/>
<Property Name="monthsOfService" Type="Edm.Int32"/>
<Property Name="oneTimeEligibleUnitCost" Type="Edm.Double"/>
<Property Name="oneTimeIneligibleUnitCosts" Type="Edm.Double"/>
<Property Name="oneTimeQuantity" Type="Edm.Int32"/>
<Property Name="oneTimeUnitCost" Type="Edm.Double"/>
<Property Name="otherManufacture" Type="Edm.String"/>
<Property Name="preDiscountExtendedEligibleLineItemCost" Type="Edm.Double"/>
<Property Name="purpose" Type="Edm.String"/>
<Property Name="totalEligibleOneTimeCosts" Type="Edm.Double"/>
<Property Name="totalEligibleRecurringCosts" Type="Edm.Double"/>
<Property Name="totalMonthlyEligibleRecurringCosts" Type="Edm.Double"/>
<Property Name="typeOfProduct" Type="Edm.String"/>
<Property Name="unit" Type="Edm.String"/>
<Property Name="uploadSpeed" Type="Edm.Double"/>
<Property Name="uploadSpeedUnits" Type="Edm.String"/>
<NavigationProperty Name="RecipientsOfService"
Type="Collection(loc.usac.data.sl.form471.v1.recipientsOfService)"
Partner="FRNLineItem"/>
<NavigationProperty Name="FRN" Type="loc.usac.data.sl.form471.v1.frn">
<ReferentialConstraint Property="formView" ReferencedProperty="formView"/>
<ReferentialConstraint Property="applicationNumber" ReferencedProperty="applicationNumber"/>
<ReferentialConstraint Property="frn" ReferencedProperty="frn"/>
</NavigationProperty>
</EntityType>

Data Dictionary

Field

Description

applicationNumber

Unique number assigned to the FCC Form 471

basicFirewallProtection

Does the service include Basic Firewall Protection

ben

Billed Entity Number

billedEntityName

The name of the Billed Entity

burstableSpeed

Burstable Speed

burstableSpeedUnits

Burstable Speed Units

connectionDirectlyToSchoolOrLibraryOrNIF

Connection Directly to a school a library or a NIF

connectionSupportsServiceToSchoolOrLibraryOrNIF

Connection Supports Service to a school, library or NIF

connectionUsedBy

Connection Used by: all school/libraries, some schools/libraries, or just one school/library

contactEmail

Contact E-mail

downloadSpeed

Download speed

downloadSpeedUnits

Download speed units (Mbps or Gbps)

formView

indicates if the form is the Original or Current version

frn

Unique number assigned to the Funding Request

function

Service or product function

installationPriceIncluded

Is installation included in Price?

leaseOrNonPurchaseAgreement

Lease or Non-Purchase Agreement?

lineItem

Unique number assigned to the Funding Request Line Item

make

Make

model

Model number

monthlyQuantity

This is the number of connections/products that have an associated monthly cost.

monthlyRecurringUnitCost

This is the monthly amount charged by the service provider for each connection included in the Monthly Quantity field.

monthlyRecurringUnitEligibleCosts

This amount is calculated by removing the ineligible monthly recurring costs from the monthly cost charged by the service provider.

monthlyRecurringUnitIneligibleCosts

Indicate any portion of the Monthly Recurring Costs that is not eligible for E-rate support.

monthsOfService

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

oneTimeEligibleUnitCost

This amount is calculated by removing the ineligible one-time cost from the one-time cost charged by the service provider.

oneTimeIneligibleUnitCosts

Indicate any portion of the One-time Cost that is not eligible for E-rate support.

oneTimeQuantity

This is the number of connections/products that have an associated one-time cost.

oneTimeUnitCost

This is the one-time amount charged by the service provider for each connection included in the One-Time Quantity field.

otherManufacture

Other Manufacturer if not included in the drop down list

preDiscountExtendedEligibleLineItemCost

This amount is calculated by summing the Total Monthly Eligible Recurring Costs and the Total Eligible One-time Costs.

purpose

Purpose

totalEligibleOneTimeCosts

This amount is calculated by multiplying the One-time Eligible Cost times the One-time Quantity.

totalEligibleRecurringCosts

This amount is calculated by multiplying the Total Monthly Eligible Recurring Costs times the Months of Service.

totalMonthlyEligibleRecurringCosts

This amount is calculated by multiplying the Monthly Recurring Eligible Costs times the Monthly Quantity.

typeOfProduct

Type of product

unit

Unit (e.g. per foot)

uploadSpeed

Upload speed for service

uploadSpeedUnits

Upload speed units (Mbps or Gbps)