Generic String10
Free-text generic tag value stored in the IDV Generic Tags section as the 10th generic string slot. It is not a standardized government-wide code and its meaning depends on the specific agency or reporting workflow that populated it.
FPDS Compare
Use Cases
- Dictionary lookup and field explanation
- SQL filtering and grouping
- Analytical reporting and reusable query building
Common Usage
- agency-specific categorization
- custom filtering or grouping
- workflow or report tag lookup
Common Mistakes
- assuming it is a government-wide standard code
- aggregating values without first validating agency-specific meaning
Query Guidance
Use equality, IN lists, or pattern searches on the raw string value only after confirming its local meaning; when building analytics, group by this field cautiously and exclude nulls or placeholder text explicitly. If you need a business classification, join or map it to a reference table maintained for the specific agency or dataset.
SQL Examples
Preview values
SELECT
content__IDV__genericTags__genericStrings__genericString10 AS generic_string10
FROM fpds.data
WHERE content__IDV__genericTags__genericStrings__genericString10 IS NOT NULL
LIMIT 25
Top values
SELECT
content__IDV__genericTags__genericStrings__genericString10 AS value,
count() AS record_count
FROM fpds.data
WHERE content__IDV__genericTags__genericStrings__genericString10 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.