FPDS Query Library
About Us
Contact Us

Is Domestic Shelter

Boolean or coded indicator showing whether the vendor’s site is classified as a domestic shelter in the award record. It is a vendor line-of-business attribute captured under vendor site details, not a contract action outcome or performance measure.

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__vendorLineOfBusiness__isDomesticShelter
Title
Is Domestic Shelter
FPDS Path
award/vendor/vendorSiteDetails/vendorLineOfBusiness/isDomesticShelter
Description
Boolean or coded indicator showing whether the vendor’s site is classified as a domestic shelter in the award record. It is a vendor line-of-business attribute captured under vendor site details, not a contract action outcome or performance measure.
Business Meaning
This field helps analysts identify awards associated with domestic shelter vendors for segmentation, socioeconomic review, and compliance-oriented analysis. It can support filtering award populations when assessing awards to specialized nonprofit or service organizations.
Example Value
0
Observed Non-Null Count
111,509,025

FPDS Compare

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

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Contractor profiling and competitor analysis

Common Usage

  • Filtering awards to vendors identified as domestic shelters
  • Segmenting vendor population by organizational type
  • Supporting compliance or policy reviews of specialized vendor categories

Common Mistakes

  • Interpreting the flag as a contract eligibility or award outcome field
  • Assuming all extracts use only binary values without checking the actual code set

Query Guidance

Filter on the indicator value explicitly, for example WHERE content__award__vendor__vendorSiteDetails__vendorLineOfBusiness__isDomesticShelter = 1 or the equivalent true-like code in your extract. If the source stores the flag as a character or coded value, inspect distinct values first and normalize them before analysis.

SQL Examples

Preview values

SELECT
    content__award__vendor__vendorSiteDetails__vendorLineOfBusiness__isDomesticShelter AS is_domestic_shelter
FROM fpds.data
WHERE content__award__vendor__vendorSiteDetails__vendorLineOfBusiness__isDomesticShelter IS NOT NULL
LIMIT 25

Flag distribution

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