FPDS Query Library
About Us
Contact Us

Generic String07

A free-text generic tag field stored in the FPDS IDV record. It is one of several reusable generic string slots and may contain program-specific, agency-specific, or analysis-supporting text rather than a standardized FPDS code.

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__genericString07
Title
Generic String07
FPDS Path
IDV/genericTags/genericStrings/genericString07
Description
A free-text generic tag field stored in the FPDS IDV record. It is one of several reusable generic string slots and may contain program-specific, agency-specific, or analysis-supporting text rather than a standardized FPDS code.
Business Meaning
This field can capture supplemental information that helps analysts filter, group, or interpret indefinite delivery vehicle records when standard FPDS fields are not sufficient. It is useful for identifying custom categorization used by a contracting office, but its meaning depends on how the submitting entity populated it.
Example Value
Example value

FPDS Compare

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

Use Cases

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

Common Usage

  • custom filtering of IDV records
  • grouping records by local tag values
  • supporting exploratory analysis of agency-entered metadata

Common Mistakes

  • assuming the field has a government-wide standardized meaning
  • using it as a reliable analytical category without reviewing observed values

Query Guidance

Use it as a text filter or grouping field only after profiling distinct values and frequency. In SQL, normalize case and trim whitespace, then apply exact-match or pattern-based conditions based on the observed agency convention; avoid joining it to coded reference tables unless you have a validated mapping.

SQL Examples

Preview values

SELECT
    content__IDV__genericTags__genericStrings__genericString07 AS generic_string07
FROM fpds.data
WHERE content__IDV__genericTags__genericStrings__genericString07 IS NOT NULL
LIMIT 25

Top values

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