FPDS Query Library
About Us
Contact Us

Type of Agreement

Human-readable agreement type associated with the Other Transaction IDV record. It identifies the agreement category recorded in contract data and may reflect a coded or standardized value such as a prototype agreement type.

Family: Other Transaction IDV
Category: Contract Data
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__contractData__typeOfAgreement
Title
Type of Agreement
FPDS Path
OtherTransactionIDV/contractDetail/contractData/typeOfAgreement
Description
Human-readable agreement type associated with the Other Transaction IDV record. It identifies the agreement category recorded in contract data and may reflect a coded or standardized value such as a prototype agreement type.
Business Meaning
This field helps analysts classify and compare Other Transaction IDVs by agreement structure, which is important for understanding award authorities, portfolio composition, and how OT actions are organized across programs. It supports filtering and grouping in reusable analysis workflows when segmenting procurement activity by agreement type.
Example Value
PROTOTYPE
Observed Non-Null Count
13,417

FPDS Compare

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

Use Cases

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

Common Usage

  • Filter Other Transaction IDVs by agreement type
  • Group awards by agreement category for portfolio analysis
  • Compare volume or obligation patterns across agreement types

Common Mistakes

  • Assuming the field is a full contract description instead of a category label
  • Aggregating coded values without checking for distinct spellings or standardized enumerations

Query Guidance

Use this field in WHERE clauses for agreement-type filtering and in GROUP BY for categorical analysis. In SQL, normalize values if the dataset contains mixed casing, whitespace, or multiple representations of the same agreement type, and join to a reference mapping only if you need human-readable rollups.

SQL Examples

Preview values

SELECT
    content__OtherTransactionIDV__contractDetail__contractData__typeOfAgreement AS type_of_agreement
FROM fpds.data
WHERE content__OtherTransactionIDV__contractDetail__contractData__typeOfAgreement IS NOT NULL
LIMIT 25

Top values

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