Non Traditional Government Contractor Participation Description
Human-readable description for the coded Non Traditional Government Contractor Participation field within an Other Transaction IDV record. It labels the participation classification used in the contract data and typically reflects the source value in plain language.
FPDS Compare
Paired Field
Use Cases
- Dictionary lookup and field explanation
- SQL filtering and grouping
- Analytical reporting and reusable query building
Common Usage
- Validate the meaning of the associated participation code
- Group records by participation category for reporting
- Review contractor participation patterns in Other Transactions
Common Mistakes
- Using the description as if it were the underlying coded value
- Assuming identical wording across agencies or time periods
Query Guidance
Use this field for display, filtering by text, or joining to the paired code when available. For analysis, prefer the coded field for aggregation and use this description to label results, with NULL checks and value normalization if comparing across records.
SQL Examples
Preview values
SELECT
content__OtherTransactionIDV__contractDetail__contractData__nonTraditionalGovernmentContractorParticipation__description AS non_traditional_government_contractor_participation_description
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__contractData__nonTraditionalGovernmentContractorParticipation__description IS NOT NULL
LIMIT 25
Top values
SELECT
content__OtherTransactionIDV__contractDetail__contractData__nonTraditionalGovernmentContractorParticipation__description AS value,
count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__contractData__nonTraditionalGovernmentContractorParticipation__description 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.