FPDS Query Library
About Us
Contact Us

Is Sba Certified Small Disadvantaged Business

Boolean or coded flag indicating whether the vendor is identified in the record as an SBA-certified Small Disadvantaged Business (SDB). It is a vendor certification attribute stored under vendor site details for the Other Transaction IDV record. The value typically signals presence/absence of this certification rather than a narrative description.

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__vendorCertifications__isSBACertifiedSmallDisadvantagedBusiness
Title
Is Sba Certified Small Disadvantaged Business
FPDS Path
OtherTransactionIDV/contractDetail/vendor/vendorSiteDetails/vendorCertifications/isSBACertifiedSmallDisadvantagedBusiness
Description
Boolean or coded flag indicating whether the vendor is identified in the record as an SBA-certified Small Disadvantaged Business (SDB). It is a vendor certification attribute stored under vendor site details for the Other Transaction IDV record. The value typically signals presence/absence of this certification rather than a narrative description.
Business Meaning
This field supports socioeconomic vendor analysis, set-aside and preference tracking, and reporting on participation by disadvantaged businesses in federal procurement. Analysts use it to measure award distribution, assess compliance with socioeconomic goals, and segment vendor populations by certification status.
Example Value
0
Observed Non-Null Count
13,417

FPDS Compare

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

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 SBA-certified small disadvantaged businesses
  • Calculate counts or dollar value associated with SDB-certified vendors
  • Segment procurement activity by socioeconomic certification

Common Mistakes

  • Treating a 0 value as missing instead of false
  • Assuming the flag alone confirms active certification beyond the record snapshot

Query Guidance

Use explicit logic for true, false, and null values, for example `WHERE isSBACertifiedSmallDisadvantagedBusiness = 1` for positive matches. If the column is stored as text or mixed codes, normalize observed values before filtering and consider joining to related vendor certification fields only when needed for validation or richer segmentation.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorCertifications__isSBACertifiedSmallDisadvantagedBusiness AS is_sba_certified_small_disadvantaged_business
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__vendor__vendorSiteDetails__vendorCertifications__isSBACertifiedSmallDisadvantagedBusiness IS NOT NULL
LIMIT 25

Flag distribution

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