FPDS Query Library
About Us
Contact Us

Generic Boolean02

Numeric flag in the Award > Generic Tags > Generic Booleans section. It stores one of the generic boolean values used on the FPDS award record, typically representing a yes/no indicator rather than a continuous measure.

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__genericBoolean02
Title
Generic Boolean02
FPDS Path
award/genericTags/genericBooleans/genericBoolean02
Description
Numeric flag in the Award > Generic Tags > Generic Booleans section. It stores one of the generic boolean values used on the FPDS award record, typically representing a yes/no indicator rather than a continuous measure.
Business Meaning
This field can support segmentation, filtering, and workflow-specific analysis when agencies use generic boolean tags to mark awards with a particular attribute. It is useful for identifying subsets of contracts that share an operational or reporting characteristic.
Example Value
0
Observed Non-Null Count
15,520,720

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter awards by a tagged yes/no attribute
  • Group records for reusable reporting logic
  • Join with other award attributes to isolate a workflow-specific subset

Common Mistakes

  • Assuming the tag has a universal business meaning across all datasets
  • Interpreting 0 as missing instead of a valid coded value

Query Guidance

Use equality filters and cast only if needed by the warehouse schema, for example WHERE content__award__genericTags__genericBooleans__genericBoolean02 = 1. Check the distribution of observed values first; if the field is sparsely populated or inconsistently encoded, normalize it before aggregating.

SQL Examples

Preview values

SELECT
    content__award__genericTags__genericBooleans__genericBoolean02 AS generic_boolean02
FROM fpds.data
WHERE content__award__genericTags__genericBooleans__genericBoolean02 IS NOT NULL
LIMIT 25

Aggregate total

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

Distribution overview

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