FPDS Query Library
About Us
Contact Us

Department Id

Numeric identifier for the department of the funding requesting agency associated with the purchase request. It identifies which federal department is supplying or requesting funds for the Other Transaction award record.

Family: Other Transaction Award
Category: Purchaser Information
Data Type: numeric
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__departmentID
Title
Department Id
FPDS Path
OtherTransactionAward/contractDetail/purchaserInformation/fundingRequestingAgencyID/departmentID
Description
Numeric identifier for the department of the funding requesting agency associated with the purchase request. It identifies which federal department is supplying or requesting funds for the Other Transaction award record.
Business Meaning
This field helps analysts attribute obligations and request activity to the correct department-level organization for funding source analysis, portfolio reporting, and interagency trend comparisons. It is useful for separating activity by department when the purchasing entity and funding requester differ.
Example Value
9700
Observed Non-Null Count
38,062

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__departmentID
FPDS XML Path
OtherTransactionAward/contractDetail/purchaserInformation/fundingRequestingAgencyID/departmentID
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/purchaserInformation/fundingRequestingAgencyID/departmentID' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__departmentID'.

Use Cases

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

Common Usage

  • Group awards by funding department
  • Filter records by department-level funding source
  • Join to agency reference tables for reporting

Common Mistakes

  • Assuming the number is a department name or hierarchy code
  • Using it interchangeably with awarding or contracting agency identifiers

Query Guidance

Use exact numeric comparisons or IN lists for filtering, and join to a reference table to translate the code into a department name. When building rollups, group on this field only after confirming the business definition matches the analysis question.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__departmentID AS department_id
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__departmentID IS NOT NULL
LIMIT 25

Aggregate total

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

Distribution overview

SELECT
    min(content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__departmentID) AS min_value,
    avg(content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__departmentID) AS avg_value,
    max(content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__departmentID) AS max_value,
    count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__purchaserInformation__fundingRequestingAgencyID__departmentID 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.