FPDS Query Library
About Us
Contact Us

Generic Boolean04

Numeric generic boolean flag in the Award-level Generic Tags section of the FPDS record. It represents a reusable indicator field that can store a binary or code-like value, with the example value showing 0.

Family: Award
Category: Generic Tags
Data Type: numeric
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__genericTags__genericBooleans__genericBoolean04
Title
Generic Boolean04
FPDS Path
award/genericTags/genericBooleans/genericBoolean04
Description
Numeric generic boolean flag in the Award-level Generic Tags section of the FPDS record. It represents a reusable indicator field that can store a binary or code-like value, with the example value showing 0.
Business Meaning
This field matters because FPDS generic boolean flags are often used to segment awards into analysis-ready groups without relying on more complex joins or text parsing. Analysts may use it to support filtering, cohorting, validation, or workflow-specific procurement reviews when the flag has been assigned a programmatic meaning in the source data.
Example Value
0
Observed Non-Null Count
15,520,842

FPDS Compare

FPDS Query Variable
content__award__genericTags__genericBooleans__genericBoolean04
FPDS XML Path
award/genericTags/genericBooleans/genericBoolean04
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/genericTags/genericBooleans/genericBoolean04' into the SQL-ready variable 'content__award__genericTags__genericBooleans__genericBoolean04'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building

Common Usage

  • Filter awards into a predefined analysis cohort
  • Group records for reporting or validation checks
  • Support reusable logic in procurement dashboards or SQL views

Common Mistakes

  • Assuming 0 always means false without confirming source-specific semantics
  • Using the field as a descriptive business measure instead of a code or flag

Query Guidance

Use explicit value tests in SQL, such as WHERE genericBoolean04 = 0 or = 1, and add NULL handling when needed. If the field is undocumented in a given extract, validate its meaning by comparing values against known award subsets before using it in production queries.

SQL Examples

Preview values

SELECT
    content__award__genericTags__genericBooleans__genericBoolean04 AS generic_boolean04
FROM fpds.data
WHERE content__award__genericTags__genericBooleans__genericBoolean04 IS NOT NULL
LIMIT 25

Aggregate total

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

Distribution overview

SELECT
    min(content__award__genericTags__genericBooleans__genericBoolean04) AS min_value,
    avg(content__award__genericTags__genericBooleans__genericBoolean04) AS avg_value,
    max(content__award__genericTags__genericBooleans__genericBoolean04) AS max_value,
    count() AS record_count
FROM fpds.data
WHERE content__award__genericTags__genericBooleans__genericBoolean04 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.