FPDS Query Library
About Us
Contact Us

Generic String05

A free-text generic string field within the Other Transaction IDV record's generic tag set. It stores an analyst- or system-populated value in the fifth generic string slot and does not by itself define a standard procurement concept.

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

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__genericTags__genericStrings__genericString05
Title
Generic String05
FPDS Path
OtherTransactionIDV/genericTags/genericStrings/genericString05
Description
A free-text generic string field within the Other Transaction IDV record's generic tag set. It stores an analyst- or system-populated value in the fifth generic string slot and does not by itself define a standard procurement concept.
Business Meaning
This field matters because agencies sometimes use generic tag fields to carry reusable identifiers, classification labels, workflow markers, or other local metadata needed for downstream procurement analysis. It can support filtering, grouping, and custom reporting when standard FPDS fields do not capture the required detail.
Example Value
GFJNNNA72UN4
Observed Non-Null Count
294

FPDS Compare

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

Use Cases

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

Common Usage

  • Custom filtering on agency-defined metadata
  • Grouping records by a locally assigned label or identifier
  • Supporting reusable ETL, dashboard, or exception logic

Common Mistakes

  • Assuming the field has a standard government-wide semantic meaning
  • Aggregating values without first validating agency-specific code definitions

Query Guidance

Use this field as a string filter or grouping key only after confirming the agency or dataset-specific meaning. In SQL, compare exact values when the field is used as an identifier, and normalize or trim whitespace if the source is inconsistently formatted; avoid joining on it unless it is documented as a stable key.

SQL Examples

Preview values

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

Top values

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