Non Traditional Government Contractor Participation
This field captures the non-traditional government contractor participation indicator recorded for an Other Transaction Award contract. It appears to be a coded or abbreviated attribute rather than a free-text narrative, and the example value "NSP" suggests analysts should treat it as a standardized status or category value.
FPDS Compare
Paired Field
Use Cases
- Dictionary lookup and field explanation
- SQL filtering and grouping
- Analytical reporting and reusable query building
Common Usage
- Filter Other Transaction Awards involving nontraditional participants
- Group awards by participation status for reporting
- Identify coded participation patterns for portfolio analysis
Common Mistakes
- Assuming the field contains free-text contractor descriptions
- Using the value without validating the underlying code meaning
Query Guidance
Use the field as a categorical filter or GROUP BY dimension in SQL, and compare against observed code values or lookup tables before labeling results. If the dataset provides a companion description field, join or inspect it to translate abbreviations such as "NSP" into analyst-friendly categories.
SQL Examples
Preview values
SELECT
content__OtherTransactionAward__contractDetail__contractData__nonTraditionalGovernmentContractorParticipation AS non_traditional_government_contractor_participation
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__contractData__nonTraditionalGovernmentContractorParticipation IS NOT NULL
LIMIT 25
Top values
SELECT
content__OtherTransactionAward__contractDetail__contractData__nonTraditionalGovernmentContractorParticipation AS value,
count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__contractData__nonTraditionalGovernmentContractorParticipation 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.