FPDS Query Library
About Us
Contact Us

Generic String07

A free-text generic string attribute stored in the Award record under the Generic Tags section. It is not a standard procurement code or core award datum, but a reusable text slot that may contain analyst-defined, system-defined, or program-specific labels depending on the source implementation.

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

Variable Overview

FPDS Query Variable
content__award__genericTags__genericStrings__genericString07
Title
Generic String07
FPDS Path
award/genericTags/genericStrings/genericString07
Description
A free-text generic string attribute stored in the Award record under the Generic Tags section. It is not a standard procurement code or core award datum, but a reusable text slot that may contain analyst-defined, system-defined, or program-specific labels depending on the source implementation.
Business Meaning
This field can support local tagging, filtering, and grouping when standard FPDS fields do not capture a specific analytic dimension. In procurement analysis, it is useful for segmenting awards by custom business logic, exception handling, or implementation-specific metadata that accompanies the award record.
Example Value
Example value

FPDS Compare

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

Use Cases

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

Common Usage

  • Custom award segmentation
  • Filtering records by implementation-specific tags
  • Grouping awards for reusable analytic workflows

Common Mistakes

  • Assuming the field has a government-wide standard meaning
  • Using it without first checking observed values and tagging conventions

Query Guidance

Use as a string filter or grouping column after profiling distinct values and null rates. In SQL, apply exact matches for controlled tag values, pattern matching for free-text labels, and avoid joining on it unless the dataset owner has documented a stable key-value convention.

SQL Examples

Preview values

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

Top values

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