FPDS Query Library
About Us
Contact Us

Contingency Humanitarian Peacekeeping Operation Description

Human-readable text that describes the contingency, humanitarian, or peacekeeping operation associated with the IDV record. It is the descriptive companion to the coded "Contingency Humanitarian Peacekeeping Operation" field in FPDS.

Family: IDV
Category: Contract Data
Data Type: string
Semantic Type: description
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__contractData__contingencyHumanitarianPeacekeepingOperation__description
Title
Contingency Humanitarian Peacekeeping Operation Description
FPDS Path
IDV/contractData/contingencyHumanitarianPeacekeepingOperation/description
Description
Human-readable text that describes the contingency, humanitarian, or peacekeeping operation associated with the IDV record. It is the descriptive companion to the coded "Contingency Humanitarian Peacekeeping Operation" field in FPDS.
Business Meaning
This field helps analysts interpret whether an award is tied to an operational context such as contingency, humanitarian, or peacekeeping activity. It supports categorization, reporting, and validation when assessing acquisition activity linked to special operational authorities or mission-driven contracting.
Example Value
CONTINGENCY OPERATION AS DEFINED IN 10 U.S.C. 101(A)(13)
Observed Non-Null Count
2,282,678

FPDS Compare

FPDS Query Variable
content__IDV__contractData__contingencyHumanitarianPeacekeepingOperation__description
FPDS XML Path
IDV/contractData/contingencyHumanitarianPeacekeepingOperation/description
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/contractData/contingencyHumanitarianPeacekeepingOperation/description' into the SQL-ready variable 'content__IDV__contractData__contingencyHumanitarianPeacekeepingOperation__description'.

Use Cases

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

Common Usage

  • Mapping coded contingency indicators to readable categories
  • Filtering or grouping IDVs associated with special operations contexts
  • Validating whether an award record reflects humanitarian or peacekeeping activity

Common Mistakes

  • Treating the description as an independent analytical variable instead of the text label for a code
  • Using the text alone to infer legal or mission status without checking the paired coded field or related context

Query Guidance

In SQL, use this field for display, validation, or text-based grouping after joining or selecting the paired coded field. Prefer exact matches or normalized text comparisons where possible, and do not rely on partial text searches for authoritative categorization.

SQL Examples

Preview values

SELECT
    content__IDV__contractData__contingencyHumanitarianPeacekeepingOperation__description AS contingency_humanitarian_peacekeeping_operation_description
FROM fpds.data
WHERE content__IDV__contractData__contingencyHumanitarianPeacekeepingOperation__description IS NOT NULL
LIMIT 25

Top values

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