FPDS Query Library
About Us
Contact Us

Individual Order Limit

Numeric or text value that records the maximum amount allowed for a single order placed under an IDV. It represents the per-order ceiling established in the contract marketing data for that vehicle.

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

Variable Overview

FPDS Query Variable
content__IDV__contractMarketingData__individualOrderLimit
Title
Individual Order Limit
FPDS Path
IDV/contractMarketingData/individualOrderLimit
Description
Numeric or text value that records the maximum amount allowed for a single order placed under an IDV. It represents the per-order ceiling established in the contract marketing data for that vehicle.
Business Meaning
This field helps analysts evaluate ordering flexibility, contract scope, and the size of transactions expected under an IDV. It is useful for comparing ordering thresholds across vehicles, identifying market structure, and assessing whether awarded orders align with the vehicle's intended use.
Observed Non-Null Count
3,644,458

FPDS Compare

FPDS Query Variable
content__IDV__contractMarketingData__individualOrderLimit
FPDS XML Path
IDV/contractMarketingData/individualOrderLimit
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/contractMarketingData/individualOrderLimit' into the SQL-ready variable 'content__IDV__contractMarketingData__individualOrderLimit'.

Use Cases

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

Common Usage

  • Compare ordering limits across IDVs
  • Filter vehicles by small-order or high-value ordering capacity
  • Support classification of contract structure and procurement strategy

Common Mistakes

  • Confusing individual order limit with total obligated or ceiling value
  • Using the raw string without casting or cleaning in numeric analysis

Query Guidance

In SQL, trim the field and convert it to a numeric type when values are standardized, for example with CAST or TRY_CAST, before filtering, grouping, or summarizing. Exclude or separately flag blanks, zeros, and nonnumeric strings, and do not use it as a measure of awarded dollars unless it has been validated against the source semantics.

SQL Examples

Preview values

SELECT
    content__IDV__contractMarketingData__individualOrderLimit AS individual_order_limit
FROM fpds.data
WHERE content__IDV__contractMarketingData__individualOrderLimit IS NOT NULL
LIMIT 25

Top values

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