Discount Calculations

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

Usage
GET https://data.usac.org/api/sl/form471/v1/discountCalculationCollection
 
{
"@odata.context": "$metadata#discountCalculationCollection",
"value": [{
"alternativeDiscount": null,
"applicationNumber": 161055411,
"attributes": "Public School District;",
"categoryOneDiscountRate": 90,
"categoryTwoDiscountRate": 85,
"childAlternativeDiscount": null,
"childAnnexName": "CENTRAL HIGH/TOLAND WAY",
"childAttributes": "Public School;",
"childBEN": "100520",
"childCEPPercentage": null,
"childEndowment": null,
"childEntityType": "School",
"childFSCSCode": " - ",
"childLocaleCode": null,
"childNCESCode": " ",
"childName": "CENTRAL CONTINUATION HIGH SCHOOL",
"childNumberOfStudents": 566,
"childSchoolDistrict": null,
"childSchoolDistrictNumber": null,
"childStateLEAID": "",
"childStateSchoolID": "",
"childStudentCountsBasedOnEstimates": null,
"childTotalSquareFootage": null,
"childUrbanOrRural": "Urban",
"endowment": null,
"formView": "Current",
"parentAnnexName": null,
"parentBEN": "143454",
"parentCEPPercentage": null,
"parentEntityType": "School District",
"parentFSCSCode": " - ",
"parentLocaleCode": null,
"parentNCESCode": " ",
"parentName": "LOS ANGELES UNIFIED SCHOOL DISTRICT",
"parentNumberOfStudents": null,
"parentSchoolDistrict": null,
"parentSchoolDistrictNumber": null,
"parentStateLEAID": "",
"parentStateSchoolID": "",
"parentTotalSquareFootage": null,
"parentUrbanOrRural": "Urban",
"studentCountBasedOnEstimates": null,
"voiceDiscountRate": 50
}, {
"alternativeDiscount": null,
"applicationNumber": 161055411,
"attributes": "Public School District;",
"categoryOneDiscountRate": 90,
"categoryTwoDiscountRate": 85,
"childAlternativeDiscount": "None",
"childAnnexName": null,
"childAttributes": "Pre-K;Public School;",
"childBEN": "100525",
"childCEPPercentage": null,
"childEndowment": null,
"childEntityType": "School",
"childFSCSCode": " - ",
"childLocaleCode": null,
"childNCESCode": " ",
"childName": "PEREZ SPECIAL EDUCATION CENTER",
"childNumberOfStudents": 280,
"childSchoolDistrict": null,
"childSchoolDistrictNumber": null,
"childStateLEAID": "",
"childStateSchoolID": "",
"childStudentCountsBasedOnEstimates": null,
"childTotalSquareFootage": null,
"childUrbanOrRural": "Urban",
"endowment": null,
"formView": "Current",
"parentAnnexName": null,
"parentBEN": "143454",
"parentCEPPercentage": null,
"parentEntityType": "School District",
"parentFSCSCode": " - ",
"parentLocaleCode": null,
"parentNCESCode": " ",
"parentName": "LOS ANGELES UNIFIED SCHOOL DISTRICT",
"parentNumberOfStudents": null,
"parentSchoolDistrict": null,
"parentSchoolDistrictNumber": null,
"parentStateLEAID": "",
"parentStateSchoolID": "",
"parentTotalSquareFootage": null,
"parentUrbanOrRural": "Urban",
"studentCountBasedOnEstimates": null,
"voiceDiscountRate": 50
}]
}
Basic Information Collection Metadata
<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>

Data Dictionary

Field

Description

alternativeDiscount

Indicates the alternative discount mechanism used for the child entity, if one is used at all

applicationNumber

Unique number assigned to the FCC Form 471

attributes

Indicates the subtype characteristics of the parent entity

categoryOneDiscountRate

Discount rate applied to category 1 services (except for voice services) for the entity.

categoryTwoDiscountRate

Discount rate applied to category 1 services for the entity.

childAlternativeDiscount

Indicates the alternative discount mechanism used for the child entity, if one is used at all

childAnnexName

Name of the annex associated with the school or library

childAttributes

Indicates the subtype characteristics of the child entity

childBEN

Child billed entity number

childCEPPercentage

% of students in the child entity that are eligible for Community Eligibility Program (CEP)

childEndowment

Indicates the endowment of the child entity, if applicable

childEntityType

Entity type for the child (school, library, non-instructional facility or NIF)

childFSCSCode

The Federal-State Cooperative System (FSCS) code for public libraries. In this case, for the child entity, if it is a library.

childLocaleCode

Code assigned by the Institute of Museum and Library Services (ILMS) based on the population served by a library. In this case, for the child entity, if it is a library.

childName

Child entity name

childNCESCode

School code assigned by the National Center for Education Statistics (NCES).

childNumberOfStudents

Number of fulltime students for the child entity.

childSchoolDistrict

If the child library is designated as a main branch, this is the school district entity name for in which it is located.

childSchoolDistrictNumber

If the library is designated as a main branch, this is the school district entity name for the main branch.

childStateLEAID

Local Education Association number assigned to a school

childStateSchoolID

Number assigned to a school by the state

childStudentCountsBasedOnEstimates

Indicates if the student count provided is based on an estimation method as opposed to actual

childTotalSquareFootage

Square footage for libraries, if the child is a library.

childUrbanOrRural

Every school or library in the United States is located in either a rural or an urban area, based on U.S. Census data. In this case, for the child entity.

endowment

Indicates the endowment of the parent entity, if applicable

formView

indicates if the form is the Original or Current version

parentAnnexName

Name of the annex associated with the school or library

parentBEN

Entity number

parentCEPPercentage

% of students in the parent entity that are eligible for Community Eligibility Program (CEP)

parentEntityType

School district, school, library system, library, or NIF (non-instructional facility)

parentFSCSCode

Applicable to libraries only.The Federal-State Cooperative System (FSCS) code for public libraries

parentLocaleCode

Code assigned by the Institute of Museum and Library Services (ILMS) based on the population served by a library.

parentName

Entity name

parentNCESCode

School code assigned by the National Center for Education Statistics (NCES).

parentNumberOfStudents

Number of fulltime students for the parent entity.

parentSchoolDistrict

If the library is designated as a main branch, this is the school district entity name for the main branch.

parentSchoolDistrictNumber

If the library is designated as a main branch, this is the school district entity name for the main branch.

parentStateLEAID

Local Education Association number assigned to a school

parentStateSchoolID

Number assigned to a school by the state

parentTotalSquareFootage

Applicable to libraries and library systems only. Field is blank if the parent is a library system. The only value for which it is not blank is if the parent is an independent library in which case the applicant is that independent library, for which this field will show the total square footage of that independent library.

parentUrbanOrRural

Every school or library in the United States is located in either a rural or an urban area, based on U.S. Census data.

studentCountBasedOnEstimates

Indicates if the student count provided is based on an estimation method as opposed to actual

voiceDiscountRate

Discount rate applied to voice services for the entity.