FPDS Query Library
About Us
Contact Us

Generic String04

A free-text generic string attribute stored in the IDV Generic Tags section of the FPDS record. It serves as a reusable custom text field rather than a standardized procurement code or canonical description.

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

Variable Overview

FPDS Query Variable
content__IDV__genericTags__genericStrings__genericString04
Title
Generic String04
FPDS Path
IDV/genericTags/genericStrings/genericString04
Description
A free-text generic string attribute stored in the IDV Generic Tags section of the FPDS record. It serves as a reusable custom text field rather than a standardized procurement code or canonical description.
Business Meaning
This field can support agency-specific tagging, segmentation, or supplemental classification in indefinite delivery vehicle analysis. Analysts may use it to separate records into operational groupings when standard FPDS fields do not capture the needed business dimension.
Example Value
Example value

FPDS Compare

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

Use Cases

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

Common Usage

  • custom tagging for internal analysis
  • grouping records in exploratory reporting
  • supplementing filters when standard FPDS fields are insufficient

Common Mistakes

  • assuming a government-wide standard code set
  • using the field for direct comparisons without normalizing text

Query Guidance

Use exact match, LIKE, or regex logic only after validating the observed values and their formatting. If the field is used as a label for another coded attribute, pair it with the related code field in WHERE clauses and GROUP BY logic rather than relying on the text alone.

SQL Examples

Preview values

SELECT
    content__IDV__genericTags__genericStrings__genericString04 AS generic_string04
FROM fpds.data
WHERE content__IDV__genericTags__genericStrings__genericString04 IS NOT NULL
LIMIT 25

Top values

SELECT
    content__IDV__genericTags__genericStrings__genericString04 AS value,
    count() AS record_count
FROM fpds.data
WHERE content__IDV__genericTags__genericStrings__genericString04 IS NOT NULL
GROUP BY value
ORDER BY record_count DESC
LIMIT 25

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.