FPDS Query Library
About Us
Contact Us

Is Private University or College

Boolean or coded flag indicating whether the vendor site is identified as a private university or college in the Other Transaction IDV record. It captures a specific educational-entity classification at the vendor-site level, not a general vendor ownership or mission attribute.

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__isPrivateUniversityOrCollege
Title
Is Private University or College
FPDS Path
OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/typeOfEducationalEntity/isPrivateUniversityOrCollege
Description
Boolean or coded flag indicating whether the vendor site is identified as a private university or college in the Other Transaction IDV record. It captures a specific educational-entity classification at the vendor-site level, not a general vendor ownership or mission attribute.
Business Meaning
This field helps analysts isolate awards involving private higher-education institutions for policy, compliance, and portfolio reviews. It is useful for segmenting educational performers, assessing use of academic institutions in R&D or specialized efforts, and comparing private versus public or non-educational recipients.
Example Value
0
Observed Non-Null Count
13,417

FPDS Compare

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__isPrivateUniversityOrCollege
FPDS XML Path
OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/typeOfEducationalEntity/isPrivateUniversityOrCollege
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/typeOfEducationalEntity/isPrivateUniversityOrCollege' into the SQL-ready variable 'content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__isPrivateUniversityOrCollege'.

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 Other Transaction IDVs involving private universities or colleges
  • Segment awards to higher-education performers for compliance or portfolio analysis
  • Compare private versus public educational recipients across FPDS records

Common Mistakes

  • Using it to infer that the entire vendor is a university rather than the specific vendor site classification
  • Assuming the field applies to all award types or is equivalent to nonprofit status

Query Guidance

Use explicit value checks appropriate to the extract, such as = 1, = 'Y', or = 'true', after confirming the stored coding. When possible, join or inspect related educational-entity fields to validate the classification and avoid misreading nulls or nonstandard codes as false.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__isPrivateUniversityOrCollege AS is_private_university_or_college
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__isPrivateUniversityOrCollege IS NOT NULL
LIMIT 25

Flag distribution

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