FPDS Query Library
About Us
Contact Us

Is State Controlled Institutionof Higher Learning

Boolean or coded flag indicating whether the vendor site is identified as a state-controlled institution of higher learning. It is part of the vendor site detail attributes under the award record and represents a specific educational-entity classification rather than a general vendor characteristic.

Family: Award
Category: Vendor Site Details
Data Type: boolean_or_code_flag
Semantic Type: flag
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__isStateControlledInstitutionofHigherLearning
Title
Is State Controlled Institutionof Higher Learning
FPDS Path
award/vendor/vendorSiteDetails/typeOfEducationalEntity/isStateControlledInstitutionofHigherLearning
Description
Boolean or coded flag indicating whether the vendor site is identified as a state-controlled institution of higher learning. It is part of the vendor site detail attributes under the award record and represents a specific educational-entity classification rather than a general vendor characteristic.
Business Meaning
This field helps analysts identify awards tied to public higher-education institutions, which may be relevant for socioeconomic segmentation, recipient-type analysis, and oversight of university-based contracting. It can also support reporting on institutional recipients that may follow different procurement, audit, or policy patterns than commercial vendors.
Example Value
0
Observed Non-Null Count
111,509,025

FPDS Compare

FPDS Query Variable
content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__isStateControlledInstitutionofHigherLearning
FPDS XML Path
award/vendor/vendorSiteDetails/typeOfEducationalEntity/isStateControlledInstitutionofHigherLearning
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/vendor/vendorSiteDetails/typeOfEducationalEntity/isStateControlledInstitutionofHigherLearning' into the SQL-ready variable 'content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__isStateControlledInstitutionofHigherLearning'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Contractor profiling and competitor analysis

Common Usage

  • Filter awards associated with public colleges and universities
  • Segment vendor site population by educational institution type
  • Support compliance or institutional-recipient reporting

Common Mistakes

  • Assuming 0 always means no instead of possibly unknown or unreported
  • Using the flag as a proxy for all educational entities rather than only state-controlled institutions

Query Guidance

In SQL, filter on the positive coded value or true-equivalent value used in your dataset, and explicitly test for nulls when distinguishing false from missing. When aggregating, group this field with related vendor-site classification flags to avoid overcounting institutions across overlapping categories.

SQL Examples

Preview values

SELECT
    content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__isStateControlledInstitutionofHigherLearning AS is_state_controlled_institutionof_higher_learning
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__isStateControlledInstitutionofHigherLearning IS NOT NULL
LIMIT 25

Flag distribution

SELECT
    content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__isStateControlledInstitutionofHigherLearning AS flag_value,
    count() AS record_count
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__isStateControlledInstitutionofHigherLearning IS NOT NULL
GROUP BY flag_value
ORDER BY record_count DESC

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.