FPDS Query Library
About Us
Contact Us

Generic String06

A free-text generic tag stored on the award record in FPDS. It is not a standardized coded element, but a reusable string field that can carry a label, flag, or short descriptor such as an acquisition approach or evaluation term.

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__genericString06
Title
Generic String06
FPDS Path
award/genericTags/genericStrings/genericString06
Description
A free-text generic tag stored on the award record in FPDS. It is not a standardized coded element, but a reusable string field that can carry a label, flag, or short descriptor such as an acquisition approach or evaluation term.
Business Meaning
This field matters because agencies may use it to support custom procurement analytics, segmentation, or internal reporting where core FPDS fields are insufficient. It can help identify recurring patterns across awards when the same tag is applied consistently.
Example Value
LPTA
Observed Non-Null Count
20,299,592

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter awards by an agency-specific tag value
  • Group awards into reusable analysis buckets
  • Search for tags associated with acquisition strategy or award characteristics

Common Mistakes

  • Assuming the value has government-wide standard meaning
  • Using the field without validating how the reporting agency populated it

Query Guidance

Use exact-match or case-normalized text filters when the tag values are known, and apply DISTINCT to profile observed values before analysis. For example, compare against trimmed uppercased strings and avoid aggregating it as a standardized code unless you have a confirmed mapping.

SQL Examples

Preview values

SELECT
    content__award__genericTags__genericStrings__genericString06 AS generic_string06
FROM fpds.data
WHERE content__award__genericTags__genericStrings__genericString06 IS NOT NULL
LIMIT 25

Top values

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