FPDS Query Library
About Us
Contact Us

Generic String05

Arbitrary text value stored in the fifth generic string slot within the Other Transaction Award record's generic tags. It is a free-form attribute rather than a standardized FPDS-coded measure, so its meaning depends on how the awarding organization populated the field.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__genericTags__genericStrings__genericString05
Title
Generic String05
FPDS Path
OtherTransactionAward/genericTags/genericStrings/genericString05
Description
Arbitrary text value stored in the fifth generic string slot within the Other Transaction Award record's generic tags. It is a free-form attribute rather than a standardized FPDS-coded measure, so its meaning depends on how the awarding organization populated the field.
Business Meaning
This field can carry program-specific identifiers, categorization labels, or other supplementary award metadata that supports filtering and segmented analysis when standard FPDS fields are insufficient. Analysts use it to trace internal tagging schemes, isolate subsets of awards, or connect FPDS records to agency-specific workflows and external reference data.
Example Value
GJW3N2QVAUX8
Observed Non-Null Count
4,318

FPDS Compare

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

Use Cases

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

Common Usage

  • Agency-specific classification or tracking
  • Filtering awards by custom tags
  • Joining to external lookup tables

Common Mistakes

  • Assuming a government-wide standard meaning
  • Using the field without checking for agency-specific coding or inconsistent population

Query Guidance

Use exact or normalized string comparisons for filtering, and inspect distinct values before building logic. In SQL, apply TRIM/UPPER when matching on text patterns, and group by the field only after confirming that repeated values represent a stable business category rather than free-form entry.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__genericTags__genericStrings__genericString05 AS generic_string05
FROM fpds.data
WHERE content__OtherTransactionAward__genericTags__genericStrings__genericString05 IS NOT NULL
LIMIT 25

Top values

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