FPDS Query Library
About Us
Contact Us

Is Historically Black College or University

Boolean or coded flag indicating whether the vendor site is identified as a Historically Black College or University (HBCU) in the award record. It represents the educational entity type classification stored under vendor site details, not the award action itself.

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__isHistoricallyBlackCollegeOrUniversity
Title
Is Historically Black College or University
FPDS Path
award/vendor/vendorSiteDetails/typeOfEducationalEntity/isHistoricallyBlackCollegeOrUniversity
Description
Boolean or coded flag indicating whether the vendor site is identified as a Historically Black College or University (HBCU) in the award record. It represents the educational entity type classification stored under vendor site details, not the award action itself.
Business Meaning
This field supports analysis of awards to HBCU-affiliated entities, including diversity, equity, and outreach reporting, as well as institutional participation tracking in federal procurement. It can help analysts segment spending, assess supplier inclusion patterns, and support compliance or policy reviews tied to educational institutions.
Example Value
0
Observed Non-Null Count
111,509,025

FPDS Compare

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

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 to HBCU vendors or vendor sites
  • Measure obligations to HBCU-affiliated entities over time
  • Segment supplier diversity or institutional participation analyses

Common Mistakes

  • Assuming the flag identifies the prime awardee rather than the vendor site record
  • Treating missing, null, or zero values as confirmed negative responses without checking source encoding

Query Guidance

Use explicit value checks against the observed encoding, for example `WHERE isHistoricallyBlackCollegeOrUniversity = 1` for true-like values or `= 'Y'` if the dataset stores coded text. When possible, join or inspect companion description fields and normalize null, zero, and false-equivalent values before aggregating.

SQL Examples

Preview values

SELECT
    content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__isHistoricallyBlackCollegeOrUniversity AS is_historically_black_college_or_university
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__isHistoricallyBlackCollegeOrUniversity IS NOT NULL
LIMIT 25

Flag distribution

SELECT
    content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__isHistoricallyBlackCollegeOrUniversity AS flag_value,
    count() AS record_count
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__typeOfEducationalEntity__isHistoricallyBlackCollegeOrUniversity 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.