FPDS Query Library
About Us
Contact Us

Non Governmental Dollars

Amount of funding or value reported as coming from non-governmental sources within an Other Transaction IDV contract detail. It is a numeric dollar value recorded at the contract-detail level in the FPDS record.

Family: Other Transaction IDV
Category: Dollar Values
Data Type: numeric
Semantic Type: financial
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__dollarValues__nonGovernmentalDollars
Title
Non Governmental Dollars
FPDS Path
OtherTransactionIDV/contractDetail/dollarValues/nonGovernmentalDollars
Description
Amount of funding or value reported as coming from non-governmental sources within an Other Transaction IDV contract detail. It is a numeric dollar value recorded at the contract-detail level in the FPDS record.
Business Meaning
This field helps analysts identify how much of an agreement is financed outside the federal government, which is important for assessing partner contribution, market leverage, and the overall composition of an Other Transaction award. It supports spend analysis and comparisons between government-funded and externally funded portions of awards.
Example Value
0
Observed Non-Null Count
13,417

FPDS Compare

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__dollarValues__nonGovernmentalDollars
FPDS XML Path
OtherTransactionIDV/contractDetail/dollarValues/nonGovernmentalDollars
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionIDV/contractDetail/dollarValues/nonGovernmentalDollars' into the SQL-ready variable 'content__OtherTransactionIDV__contractDetail__dollarValues__nonGovernmentalDollars'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Spending aggregation and trend analysis

Common Usage

  • Measure non-federal contribution in OT IDVs
  • Compare funding mix across awards or vendors
  • Summarize dollar totals for spend and trend analysis

Common Mistakes

  • Assuming zero always means no non-governmental funding rather than possibly unreported data
  • Using this field alone without comparing it to total or government-funded dollar amounts

Query Guidance

Use as a numeric measure in SUM, AVG, and range filters, and cast/clean nulls as needed before aggregation. For funding-share analysis, divide by total contract dollars only after confirming the record contains comparable dollar components at the same detail level.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__dollarValues__nonGovernmentalDollars AS non_governmental_dollars
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__dollarValues__nonGovernmentalDollars IS NOT NULL
LIMIT 25

Aggregate total

SELECT
    sum(content__OtherTransactionIDV__contractDetail__dollarValues__nonGovernmentalDollars) AS total_value
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__dollarValues__nonGovernmentalDollars IS NOT NULL

Distribution overview

SELECT
    min(content__OtherTransactionIDV__contractDetail__dollarValues__nonGovernmentalDollars) AS min_value,
    avg(content__OtherTransactionIDV__contractDetail__dollarValues__nonGovernmentalDollars) AS avg_value,
    max(content__OtherTransactionIDV__contractDetail__dollarValues__nonGovernmentalDollars) AS max_value,
    count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__dollarValues__nonGovernmentalDollars IS NOT NULL

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.