FPDS Query Library
About Us
Contact Us

Generic Boolean02

Numeric custom boolean flag in the IDV Generic Tags area. It is a reusable internal tagging field that typically stores a boolean-like value such as 0/1 to mark whether a record meets a specific locally defined condition.

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

Variable Overview

FPDS Query Variable
content__IDV__genericTags__genericBooleans__genericBoolean02
Title
Generic Boolean02
FPDS Path
IDV/genericTags/genericBooleans/genericBoolean02
Description
Numeric custom boolean flag in the IDV Generic Tags area. It is a reusable internal tagging field that typically stores a boolean-like value such as 0/1 to mark whether a record meets a specific locally defined condition.
Business Meaning
This field matters because agencies or data pipelines can use it to apply consistent cross-record tags for filtering, grouping, or downstream analysis. In procurement analysis, it can support cohort creation, special-case identification, or workflow-specific segmentation when the tag definition is known.
Example Value
0
Observed Non-Null Count
695,693

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter records into a tagged analysis cohort
  • Group IDVs by a custom internal classification
  • Flag records for reusable reporting rules

Common Mistakes

  • Assuming the flag has a universal FPDS meaning
  • Using the field without confirming whether 0/1 or another coding scheme is in effect

Query Guidance

Use this field in WHERE clauses for simple inclusion or exclusion logic, and test for both numeric and null values explicitly. Example: WHERE content__IDV__genericTags__genericBooleans__genericBoolean02 = 1; if the dataset uses strings or nonstandard coding, inspect distinct values first before applying filters.

SQL Examples

Preview values

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

Aggregate total

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

Distribution overview

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