FPDS Query Library
About Us
Contact Us

Contracting Office Id Name

Human-readable name of the contracting office associated with the award's contracting office identifier. It functions as the descriptive label for the coded office value stored in the purchaser information segment.

Family: Award
Category: Purchaser Information
Data Type: string
Semantic Type: label
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__purchaserInformation__contractingOfficeID__name
Title
Contracting Office Id Name
FPDS Path
award/purchaserInformation/contractingOfficeID/name
Description
Human-readable name of the contracting office associated with the award's contracting office identifier. It functions as the descriptive label for the coded office value stored in the purchaser information segment.
Business Meaning
This field helps analysts identify which federal contracting office issued or managed the award, supporting organizational attribution, workload analysis, and office-level spend reporting. It is useful for grouping awards by office name when code values alone are not analyst-friendly.
Example Value
OAK RIDGE OFFICE (OFFICE OF SCIENCE)
Observed Non-Null Count
111,115,935

FPDS Compare

FPDS Query Variable
content__award__purchaserInformation__contractingOfficeID__name
FPDS XML Path
award/purchaserInformation/contractingOfficeID/name
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/purchaserInformation/contractingOfficeID/name' into the SQL-ready variable 'content__award__purchaserInformation__contractingOfficeID__name'.

Use Cases

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

Common Usage

  • Group obligations by contracting office name
  • Display office labels in dashboards and reports
  • Validate or interpret the coded contracting office identifier

Common Mistakes

  • Using the name as a unique identifier instead of the office code
  • Assuming one office name always maps to one immutable organization

Query Guidance

Use this field for presentation, grouping, and filtering by office label; for joins or exact matching, prefer the underlying office ID and use the name as a descriptive attribute. In SQL, standardize with TRIM/UPPER only for reporting consistency, not for surrogate-key logic.

SQL Examples

Preview values

SELECT
    content__award__purchaserInformation__contractingOfficeID__name AS contracting_office_id_name
FROM fpds.data
WHERE content__award__purchaserInformation__contractingOfficeID__name IS NOT NULL
LIMIT 25

Top values

SELECT
    content__award__purchaserInformation__contractingOfficeID__name AS value,
    count() AS record_count
FROM fpds.data
WHERE content__award__purchaserInformation__contractingOfficeID__name 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.