FRN Line Items
This collection contains data about the FRN line items included within each Form 471.
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
}]
}
<
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) |