FPDS Query Library
About Us
Contact Us

Is Historically Black College or University

Boolean flag indicating whether the vendor site is identified as a Historically Black College or University (HBCU) in the Other Transaction IDV record. A value such as 1/true means the site is marked as HBCU; 0/false means it is not, or the record does not indicate that status.

Family: Other Transaction IDV
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__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__isHistoricallyBlackCollegeOrUniversity
Title
Is Historically Black College or University
FPDS Path
OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/typeOfEducationalEntity/isHistoricallyBlackCollegeOrUniversity
Description
Boolean flag indicating whether the vendor site is identified as a Historically Black College or University (HBCU) in the Other Transaction IDV record. A value such as 1/true means the site is marked as HBCU; 0/false means it is not, or the record does not indicate that status.
Business Meaning
This field supports socioeconomic, institutional, and diversity-focused analysis of award recipients and vendor participation. Analysts use it to identify procurement activity involving HBCUs, assess outreach or inclusion outcomes, and segment awards for reporting tied to educational institution categories.
Example Value
0
Observed Non-Null Count
13,417

FPDS Compare

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__isHistoricallyBlackCollegeOrUniversity
FPDS XML Path
OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/typeOfEducationalEntity/isHistoricallyBlackCollegeOrUniversity
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/typeOfEducationalEntity/isHistoricallyBlackCollegeOrUniversity' into the SQL-ready variable 'content__OtherTransactionIDV__contractDetail__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 involving HBCU vendor sites
  • Count or sum obligations tied to HBCU participation
  • Segment vendor analysis by educational institution status

Common Mistakes

  • Treating a false or null value as proof the vendor is not an HBCU
  • Using the flag as a contractor-wide attribute instead of a vendor-site attribute

Query Guidance

Use the field as a boolean filter, e.g. WHERE isHistoricallyBlackCollegeOrUniversity = 1, and handle nulls explicitly if you need to distinguish unknown from no. For rollups, aggregate after normalizing the field to a consistent boolean or numeric representation, and pair it with vendor/site identifiers to avoid double counting.

SQL Examples

Preview values

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

Flag distribution

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