Form 471 Dataset (beta)
E-rate Program applicants file the FCC Form 471 to tell USAC about the costs and details of the services they are requesting from their service provider and the discount percentage for which they are eligible.
The data provided on the FCC Form 471 includes applicant location information, who the services are being delivered to (specific school, school district, or library), the discount rate and discounted costs for requested services, the name of the selected service provider, and detailed descriptions of the services and products requested (e.g., dark or lit fiber, high-speed Ethernet, internal connections, access points, switches, or cables).
The data is organized into collections (e.g., Basic Information). Each collection has its own URL and data dictionary. You can explore these collections with the links on the left navigation on this page. The Data Dictionary for each collection is at the bottom of the collection page.
Please note that our APIs are currently in beta for the purpose of gathering feedback from potential users. By “beta” we mean that the application has the set of features we expect to deliver, but may contain some known or unknown bugs. In this case, the data that is contained in these APIs may not be up to date or may be missing certain fields. It may not reflect similar sources of data from USAC, including search tools for USAC programs.
We are extremely interested in the feedback of users of our beta tools. If you have feedback, please submit to opendata@usac.org.
GET
https://data.usac.org/api/sl/form471/v1/
<
app
:service
xmlns:atom
=
"http://www.w3.org/2005/Atom"
xmlns:app
=
"http://www.w3.org/2007/app"
xmlns:metadata
=
"http://docs.oasis-open.org/odata/ns/metadata"
metadata:context
=
"$metadata"
>
<
app
:workspace>
<
atom
:title>loc.usac.data.sl.form471.v1.container</
atom
:title>
<
app
:collection
href
=
"basicInformationCollection"
metadata:name
=
"basicInformationCollection"
>
<
atom
:title>basicInformationCollection</
atom
:title>
</
app
:collection>
<
app
:collection
href
=
"connectivityInformationCollection"
metadata:name
=
"connectivityInformationCollection"
>
<
atom
:title>connectivityInformationCollection</
atom
:title>
</
app
:collection>
<
app
:collection
href
=
"consultantCollection"
metadata:name
=
"consultantCollection"
>
<
atom
:title>consultantCollection</
atom
:title>
</
app
:collection>
<
app
:collection
href
=
"discountCalculationCollection"
metadata:name
=
"discountCalculationCollection"
>
<
atom
:title>discountCalculationCollection</
atom
:title>
</
app
:collection>
<
app
:collection
href
=
"frnCollection"
metadata:name
=
"frnCollection"
>
<
atom
:title>frnCollection</
atom
:title>
</
app
:collection>
<
app
:collection
href
=
"frnLineItemCollection"
metadata:name
=
"frnLineItemCollection"
>
<
atom
:title>frnLineItemCollection</
atom
:title>
</
app
:collection>
<
app
:collection
href
=
"recipientsOfServiceCollection"
metadata:name
=
"recipientsOfServiceCollection"
>
<
atom
:title>recipientsOfServiceCollection</
atom
:title>
</
app
:collection>
</
app
:workspace>
</
app
:service>
GET
https://data.usac.org/api/sl/form471/v1/
$metadata
<
edmx
:Edmx
xmlns:edmx
=
"http://docs.oasis-open.org/odata/ns/edmx"
Version
=
"4.0"
>
<
edmx
:DataServices>
<
Schema
xmlns
=
"http://docs.oasis-open.org/odata/ns/edm"
Namespace
=
"loc.usac.data.sl.form471.v1"
>
<
EntityType
Name
=
"basicInformation"
>
<
Key
>
<
PropertyRef
Name
=
"formView"
/>
<
PropertyRef
Name
=
"applicationNumber"
/>
</
Key
>
<
Property
Name
=
"applicantType"
Type
=
"Edm.String"
/>
<
Property
Name
=
"applicationNumber"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"authorizedAddress1"
Type
=
"Edm.String"
/>
<
Property
Name
=
"authorizedAddress2"
Type
=
"Edm.String"
/>
<
Property
Name
=
"authorizedCity"
Type
=
"Edm.String"
/>
<
Property
Name
=
"authorizedEmail"
Type
=
"Edm.String"
/>
<
Property
Name
=
"authorizedEmployer"
Type
=
"Edm.String"
/>
<
Property
Name
=
"authorizedLastName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"authorizedPersonMiddleName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"authorizedPersonName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"authorizedPhone"
Type
=
"Edm.String"
/>
<
Property
Name
=
"authorizedPhoneExtension"
Type
=
"Edm.String"
/>
<
Property
Name
=
"authorizedState"
Type
=
"Edm.String"
/>
<
Property
Name
=
"authorizedTitle"
Type
=
"Edm.String"
/>
<
Property
Name
=
"authorizedZipcode"
Type
=
"Edm.String"
/>
<
Property
Name
=
"authorizedZipcodeExt"
Type
=
"Edm.String"
/>
<
Property
Name
=
"billedEntityAddress1"
Type
=
"Edm.String"
/>
<
Property
Name
=
"billedEntityAddress2"
Type
=
"Edm.String"
/>
<
Property
Name
=
"billedEntityCity"
Type
=
"Edm.String"
/>
<
Property
Name
=
"billedEntityEmail"
Type
=
"Edm.String"
/>
<
Property
Name
=
"billedEntityName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"billedEntityNumber"
Type
=
"Edm.String"
/>
<
Property
Name
=
"billedEntityPhone"
Type
=
"Edm.String"
/>
<
Property
Name
=
"billedEntityPhoneExt"
Type
=
"Edm.String"
/>
<
Property
Name
=
"billedEntityState"
Type
=
"Edm.String"
/>
<
Property
Name
=
"billedEntityZipcode"
Type
=
"Edm.String"
/>
<
Property
Name
=
"billedEntityZipcodeExt"
Type
=
"Edm.String"
/>
<
Property
Name
=
"categoryOfService"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"categoryOneDiscountRate"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"categoryTwoDiscountRate"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"certifiedTimestamp"
Type
=
"Edm.DateTimeOffset"
/>
<
Property
Name
=
"contactEmail"
Type
=
"Edm.String"
/>
<
Property
Name
=
"contactFirstName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"contactLastName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"contactMiddleName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"contactPhone"
Type
=
"Edm.String"
/>
<
Property
Name
=
"contactPhoneExt"
Type
=
"Edm.String"
/>
<
Property
Name
=
"fccForms471ListedByServiceProvider"
Type
=
"Edm.String"
/>
<
Property
Name
=
"fccRegistrationNumber"
Type
=
"Edm.String"
/>
<
Property
Name
=
"fileURL"
Type
=
"Edm.String"
/>
<
Property
Name
=
"formView"
Type
=
"Edm.String"
/>
<
Property
Name
=
"fulltimeEnrollment"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"fundingYear"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"holidayOrSummerContactInformation"
Type
=
"Edm.String"
/>
<
Property
Name
=
"lastUpdatedDate"
Type
=
"Edm.DateTimeOffset"
/>
<
Property
Name
=
"nickname"
Type
=
"Edm.String"
/>
<
Property
Name
=
"nslpCount"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"nslpPercentage"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"receivingFundsDirectlyFromServiceProvider"
Type
=
"Edm.String"
/>
<
Property
Name
=
"status"
Type
=
"Edm.String"
/>
<
Property
Name
=
"totalApplicantNonDiscountShare"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"totalFundingCommitmentRequestAmount"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"totalFundingYearPreDiscountEligibleAmount"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"urbanOrRuralStatus"
Type
=
"Edm.String"
/>
<
Property
Name
=
"voiceDiscountRate"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"windowStatus"
Type
=
"Edm.String"
/>
<
NavigationProperty
Name
=
"Connectivity"
Type
=
"loc.usac.data.sl.form471.v1.connectivityInformation"
Partner
=
"Form471"
/>
<
NavigationProperty
Name
=
"Consultants"
Type
=
"loc.usac.data.sl.form471.v1.consultant"
Partner
=
"Form471"
/>
<
NavigationProperty
Name
=
"DiscountCalculations"
Type
=
"Collection(loc.usac.data.sl.form471.v1.discountCalculation)"
Partner
=
"Form471"
/>
<
NavigationProperty
Name
=
"FRNs"
Type
=
"Collection(loc.usac.data.sl.form471.v1.frn)"
Partner
=
"Form471"
/>
</
EntityType
>
<
EntityType
Name
=
"connectivityInformation"
>
<
Key
>
<
PropertyRef
Name
=
"formView"
/>
<
PropertyRef
Name
=
"applicationNumber"
/>
<
PropertyRef
Name
=
"childEntityNumber"
/>
</
Key
>
<
Property
Name
=
"aggregateInternetAccessForEntireDistrict"
Type
=
"Edm.String"
/>
<
Property
Name
=
"applicationNumber"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"biggestBarriers"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childBiggestbarriers"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childConnectiontype"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childDownloadSpeed"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"childDownloadSpeedUnits"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childEntityName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childEntityNumber"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childUploadSpeed"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"childUploadSpeedUnits"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childWiFi"
Type
=
"Edm.String"
/>
<
Property
Name
=
"connectionType"
Type
=
"Edm.String"
/>
<
Property
Name
=
"contactEmail"
Type
=
"Edm.String"
/>
<
Property
Name
=
"downloadSpeed"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"downloadSpeedUnits"
Type
=
"Edm.String"
/>
<
Property
Name
=
"entityName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"entityNumber"
Type
=
"Edm.String"
/>
<
Property
Name
=
"formView"
Type
=
"Edm.String"
/>
<
Property
Name
=
"other"
Type
=
"Edm.String"
/>
<
Property
Name
=
"uploadSpeed"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"uploadSpeedUnits"
Type
=
"Edm.String"
/>
<
Property
Name
=
"wifi"
Type
=
"Edm.String"
/>
<
NavigationProperty
Name
=
"Form471"
Type
=
"loc.usac.data.sl.form471.v1.basicInformation"
>
<
ReferentialConstraint
Property
=
"formView"
ReferencedProperty
=
"formView"
/>
<
ReferentialConstraint
Property
=
"applicationNumber"
ReferencedProperty
=
"applicationNumber"
/>
</
NavigationProperty
>
</
EntityType
>
<
EntityType
Name
=
"consultant"
>
<
Key
>
<
PropertyRef
Name
=
"formView"
/>
<
PropertyRef
Name
=
"applicationNumber"
/>
<
PropertyRef
Name
=
"consultantRegistrationNumber"
/>
</
Key
>
<
Property
Name
=
"applicationNumber"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"ben"
Type
=
"Edm.String"
/>
<
Property
Name
=
"billedEntityName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"city"
Type
=
"Edm.String"
/>
<
Property
Name
=
"consultantRegistrationNumber"
Type
=
"Edm.String"
/>
<
Property
Name
=
"contactEmail"
Type
=
"Edm.String"
/>
<
Property
Name
=
"email"
Type
=
"Edm.String"
/>
<
Property
Name
=
"formView"
Type
=
"Edm.String"
/>
<
Property
Name
=
"name"
Type
=
"Edm.String"
/>
<
Property
Name
=
"phoneNumber"
Type
=
"Edm.String"
/>
<
Property
Name
=
"phoneNumberExtension"
Type
=
"Edm.String"
/>
<
Property
Name
=
"state"
Type
=
"Edm.String"
/>
<
Property
Name
=
"zipCode"
Type
=
"Edm.String"
/>
<
NavigationProperty
Name
=
"Form471"
Type
=
"loc.usac.data.sl.form471.v1.basicInformation"
>
<
ReferentialConstraint
Property
=
"formView"
ReferencedProperty
=
"formView"
/>
<
ReferentialConstraint
Property
=
"applicationNumber"
ReferencedProperty
=
"applicationNumber"
/>
</
NavigationProperty
>
</
EntityType
>
<
EntityType
Name
=
"discountCalculation"
>
<
Key
>
<
PropertyRef
Name
=
"formView"
/>
<
PropertyRef
Name
=
"applicationNumber"
/>
<
PropertyRef
Name
=
"childBEN"
/>
</
Key
>
<
Property
Name
=
"alternativeDiscount"
Type
=
"Edm.String"
/>
<
Property
Name
=
"applicationNumber"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"attributes"
Type
=
"Edm.String"
/>
<
Property
Name
=
"categoryOneDiscountRate"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"categoryTwoDiscountRate"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"childAlternativeDiscount"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childAnnexName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childAttributes"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childBEN"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childCEPPercentage"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"childEndowment"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"childEntityType"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childFSCSCode"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childLocaleCode"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"childNCESCode"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childNumberOfStudents"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"childSchoolDistrict"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childSchoolDistrictNumber"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childStateLEAID"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childStateSchoolID"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childStudentCountsBasedOnEstimates"
Type
=
"Edm.String"
/>
<
Property
Name
=
"childTotalSquareFootage"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"childUrbanOrRural"
Type
=
"Edm.String"
/>
<
Property
Name
=
"endowment"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"formView"
Type
=
"Edm.String"
/>
<
Property
Name
=
"parentAnnexName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"parentBEN"
Type
=
"Edm.String"
/>
<
Property
Name
=
"parentCEPPercentage"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"parentEntityType"
Type
=
"Edm.String"
/>
<
Property
Name
=
"parentFSCSCode"
Type
=
"Edm.String"
/>
<
Property
Name
=
"parentLocaleCode"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"parentNCESCode"
Type
=
"Edm.String"
/>
<
Property
Name
=
"parentName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"parentNumberOfStudents"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"parentSchoolDistrict"
Type
=
"Edm.String"
/>
<
Property
Name
=
"parentSchoolDistrictNumber"
Type
=
"Edm.String"
/>
<
Property
Name
=
"parentStateLEAID"
Type
=
"Edm.String"
/>
<
Property
Name
=
"parentStateSchoolID"
Type
=
"Edm.String"
/>
<
Property
Name
=
"parentTotalSquareFootage"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"parentUrbanOrRural"
Type
=
"Edm.String"
/>
<
Property
Name
=
"studentCountBasedOnEstimates"
Type
=
"Edm.String"
/>
<
Property
Name
=
"voiceDiscountRate"
Type
=
"Edm.Int32"
/>
<
NavigationProperty
Name
=
"Form471"
Type
=
"loc.usac.data.sl.form471.v1.basicInformation"
>
<
ReferentialConstraint
Property
=
"formView"
ReferencedProperty
=
"formView"
/>
<
ReferentialConstraint
Property
=
"applicationNumber"
ReferencedProperty
=
"applicationNumber"
/>
</
NavigationProperty
>
</
EntityType
>
<
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
>
<
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
>
<
EntityType
Name
=
"recipientsOfService"
>
<
Key
>
<
PropertyRef
Name
=
"formView"
/>
<
PropertyRef
Name
=
"applicationNumber"
/>
<
PropertyRef
Name
=
"frn"
/>
<
PropertyRef
Name
=
"lineItem"
/>
<
PropertyRef
Name
=
"benNo"
/>
</
Key
>
<
Property
Name
=
"amount"
Type
=
"Edm.Double"
/>
<
Property
Name
=
"applicationNumber"
Type
=
"Edm.Int32"
/>
<
Property
Name
=
"benNo"
Type
=
"Edm.String"
/>
<
Property
Name
=
"billedEntityName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"contactEmail"
Type
=
"Edm.String"
/>
<
Property
Name
=
"entityName"
Type
=
"Edm.String"
/>
<
Property
Name
=
"entityNumber"
Type
=
"Edm.String"
/>
<
Property
Name
=
"formView"
Type
=
"Edm.String"
/>
<
Property
Name
=
"frn"
Type
=
"Edm.String"
/>
<
Property
Name
=
"lineItem"
Type
=
"Edm.String"
/>
<
Property
Name
=
"quantity"
Type
=
"Edm.Double"
/>
<
NavigationProperty
Name
=
"FRNLineItem"
Type
=
"loc.usac.data.sl.form471.v1.frnLineItem"
>
<
ReferentialConstraint
Property
=
"formView"
ReferencedProperty
=
"formView"
/>
<
ReferentialConstraint
Property
=
"applicationNumber"
ReferencedProperty
=
"applicationNumber"
/>
<
ReferentialConstraint
Property
=
"frn"
ReferencedProperty
=
"frn"
/>
<
ReferentialConstraint
Property
=
"lineItem"
ReferencedProperty
=
"lineItem"
/>
</
NavigationProperty
>
</
EntityType
>
</
Schema
>
<
Schema
xmlns
=
"http://docs.oasis-open.org/odata/ns/edm"
Namespace
=
"loc.usac.data.sl.form471.v1.Collections"
>
<
EntityContainer
Name
=
"container"
>
<
EntitySet
Name
=
"basicInformationCollection"
EntityType
=
"loc.usac.data.sl.form471.v1.basicInformation"
>
<
NavigationPropertyBinding
Path
=
"Connectivity"
Target
=
"connectivityInformationCollection"
/>
<
NavigationPropertyBinding
Path
=
"Consultants"
Target
=
"consultantCollection"
/>
<
NavigationPropertyBinding
Path
=
"DiscountCalculations"
Target
=
"discountCalculationCollection"
/>
<
NavigationPropertyBinding
Path
=
"FRNs"
Target
=
"frnCollection"
/>
</
EntitySet
>
<
EntitySet
Name
=
"connectivityInformationCollection"
EntityType
=
"loc.usac.data.sl.form471.v1.connectivityInformation"
>
<
NavigationPropertyBinding
Path
=
"Form471"
Target
=
"basicInformationCollection"
/>
</
EntitySet
>
<
EntitySet
Name
=
"consultantCollection"
EntityType
=
"loc.usac.data.sl.form471.v1.consultant"
>
<
NavigationPropertyBinding
Path
=
"Form471"
Target
=
"basicInformationCollection"
/>
</
EntitySet
>
<
EntitySet
Name
=
"discountCalculationCollection"
EntityType
=
"loc.usac.data.sl.form471.v1.discountCalculation"
>
<
NavigationPropertyBinding
Path
=
"Form471"
Target
=
"basicInformationCollection"
/>
</
EntitySet
>
<
EntitySet
Name
=
"frnCollection"
EntityType
=
"loc.usac.data.sl.form471.v1.frn"
>
<
NavigationPropertyBinding
Path
=
"FRNLineItem"
Target
=
"frnLineItemCollection"
/>
<
NavigationPropertyBinding
Path
=
"Form471"
Target
=
"basicInformationCollection"
/>
</
EntitySet
>
<
EntitySet
Name
=
"frnLineItemCollection"
EntityType
=
"loc.usac.data.sl.form471.v1.frnLineItem"
>
<
NavigationPropertyBinding
Path
=
"RecipientsOfService"
Target
=
"recipientsOfServiceCollection"
/>
<
NavigationPropertyBinding
Path
=
"FRN"
Target
=
"frnCollection"
/>
</
EntitySet
>
<
EntitySet
Name
=
"recipientsOfServiceCollection"
EntityType
=
"loc.usac.data.sl.form471.v1.recipientsOfService"
>
<
NavigationPropertyBinding
Path
=
"FRNLineItem"
Target
=
"frnLineItemCollection"
/>
</
EntitySet
>
</
EntityContainer
>
</
Schema
>
</
edmx
:DataServices>
</
edmx
:Edmx>