FPDS Query Library
About Us
Contact Us

Generic String02

A free-text generic string stored in the Other Transaction IDV generic tags block. It is not a standard FPDS business field and its meaning is determined by the agency or reporting system that populated it.

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__genericString02
Title
Generic String02
FPDS Path
OtherTransactionIDV/genericTags/genericStrings/genericString02
Description
A free-text generic string stored in the Other Transaction IDV generic tags block. It is not a standard FPDS business field and its meaning is determined by the agency or reporting system that populated it.
Business Meaning
This field can carry agency-specific identifiers, labels, or workflow markers that support filtering, grouping, and reuse in procurement analysis. It matters when analysts need to reconcile records to internal systems, segment nonstandard awards, or retain custom metadata that is not captured elsewhere in FPDS.
Example Value
CKV2L9GZKJK3
Observed Non-Null Count
13,417

FPDS Compare

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

Use Cases

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

Common Usage

  • agency-specific tracking
  • custom grouping or tagging
  • record reconciliation to internal systems

Common Mistakes

  • assuming the value has a universal FPDS meaning
  • using it as a stable cross-agency code without validation

Query Guidance

Filter or group on exact string matches only after confirming the source agency's definition. In SQL, compare normalized values carefully and avoid substring logic unless you have validated the tag format and reporting conventions.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__genericTags__genericStrings__genericString02 AS generic_string02
FROM fpds.data
WHERE content__OtherTransactionIDV__genericTags__genericStrings__genericString02 IS NOT NULL
LIMIT 25

Top values

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