FPDS Query Library
About Us
Contact Us

Is1994 Land Grant College

Numeric indicator showing whether the vendor site is identified as a 1994 Land Grant College. In FPDS this is a vendor-site attribute tied to the educational-entity classification for the award record, typically represented as a coded yes/no value such as 1 or 0.

Family: Other Transaction Award
Category: Vendor Site Details
Data Type: numeric
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1994LandGrantCollege
Title
Is1994 Land Grant College
FPDS Path
OtherTransactionAward/contractDetail/vendor/vendorSiteDetails/typeOfEducationalEntity/is1994LandGrantCollege
Description
Numeric indicator showing whether the vendor site is identified as a 1994 Land Grant College. In FPDS this is a vendor-site attribute tied to the educational-entity classification for the award record, typically represented as a coded yes/no value such as 1 or 0.
Business Meaning
This field helps analysts identify awards involving a specific class of Tribal-serving higher education institutions, which can be relevant for socioeconomic and institutional targeting analyses, award distribution reviews, and reporting on support to educational entities. It also supports segmentation of procurement activity by institution type when assessing program reach or compliance with policy goals.
Example Value
0
Observed Non-Null Count
38,894

FPDS Compare

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

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 1994 Land Grant College vendors
  • Group procurement activity by educational institution type
  • Support reporting on awards to Tribal-serving colleges

Common Mistakes

  • Assuming 0 means the value is missing rather than explicitly negative
  • Using the field alone without checking related educational-entity flags

Query Guidance

Use direct equality tests on the coded value, for example WHERE is1994LandGrantCollege = 1 for affirmative records, and confirm whether 0, NULL, or other codes represent non-applicable or unknown cases in your extract. When joining or aggregating, combine this field with the broader vendor-site education classification to avoid misclassification.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1994LandGrantCollege AS is1994_land_grant_college
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1994LandGrantCollege IS NOT NULL
LIMIT 25

Aggregate total

SELECT
    sum(content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1994LandGrantCollege) AS total_value
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1994LandGrantCollege IS NOT NULL

Distribution overview

SELECT
    min(content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1994LandGrantCollege) AS min_value,
    avg(content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1994LandGrantCollege) AS avg_value,
    max(content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1994LandGrantCollege) AS max_value,
    count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__vendor__vendorSiteDetails__typeOfEducationalEntity__is1994LandGrantCollege IS NOT NULL

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