FPDS Query Library
About Us
Contact Us

Is Veterinary College

Boolean or coded indicator showing whether the vendor site is identified as a veterinary college. It is a specific subtype within the vendor's educational-entity classification in the award record.

Family: Other Transaction 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__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__isVeterinaryCollege
Title
Is Veterinary College
FPDS Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/typeOfEducationalEntity/isVeterinaryCollege
Description
Boolean or coded indicator showing whether the vendor site is identified as a veterinary college. It is a specific subtype within the vendor's educational-entity classification in the award record.
Business Meaning
This field helps analysts identify awards associated with veterinary colleges for set-aside, education-sector, and specialized institutional spending analysis. It can support market research, eligibility review, and segmentation of awards to higher-education subcategories.
Example Value
0
Observed Non-Null Count
38,894

FPDS Compare

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

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 veterinary colleges
  • Segment educational vendors by institution type
  • Support compliance or eligibility checks for specialized procurement categories

Common Mistakes

  • Assuming a missing value means the vendor is not a veterinary college
  • Using the flag without checking the broader educational-entity classification

Query Guidance

Use this field as a boolean filter or coded equality test, for example `WHERE is_veterinary_college = 1` or the dataset-specific equivalent. If the field stores coded text, first verify the actual observed values and include null handling explicitly when identifying non-matches.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__isVeterinaryCollege AS is_veterinary_college
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__isVeterinaryCollege IS NOT NULL
LIMIT 25

Flag distribution

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