FPDS Query Library
About Us
Contact Us

CCR Exception

Boolean or coded indicator showing whether the vendor record has a Central Contractor Registration (CCR) exception on the award. It is a vendor-level compliance/status flag stored under the award's vendor information and may be represented as a code rather than a simple true/false value.

Family: Award
Category: General
Data Type: boolean_or_code_flag
Semantic Type: flag
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__vendor__CCRException
Title
CCR Exception
FPDS Path
award/vendor/CCRException
Description
Boolean or coded indicator showing whether the vendor record has a Central Contractor Registration (CCR) exception on the award. It is a vendor-level compliance/status flag stored under the award's vendor information and may be represented as a code rather than a simple true/false value.
Business Meaning
This field matters because CCR registration status affects vendor eligibility, award validation, and compliance review. Analysts use it to identify awards involving vendors that were exempt from standard registration requirements or to isolate records that may warrant closer data-quality or policy scrutiny.
Example Value
5
Observed Non-Null Count
258,415

FPDS Compare

FPDS Query Variable
content__award__vendor__CCRException
FPDS XML Path
award/vendor/CCRException
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/vendor/CCRException' into the SQL-ready variable 'content__award__vendor__CCRException'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Contractor profiling and competitor analysis

Common Usage

  • Filter awards where the vendor had a CCR exception
  • Segment compliance or validation exceptions in vendor data
  • Review outlier records for policy or reporting exceptions

Common Mistakes

  • Assuming every non-null value means the same thing as a boolean true
  • Interpreting the field as contractor performance or responsibility status

Query Guidance

Use this field in WHERE clauses to isolate exception records, but first confirm the actual stored codes or literals in your dataset. If the value is coded, map each observed code to its meaning before aggregating; if it behaves like a flag, test for the exception value rather than relying on generic truthy comparisons.

SQL Examples

Preview values

SELECT
    content__award__vendor__CCRException AS c_c_r_exception
FROM fpds.data
WHERE content__award__vendor__CCRException IS NOT NULL
LIMIT 25

Flag distribution

SELECT
    content__award__vendor__CCRException AS flag_value,
    count() AS record_count
FROM fpds.data
WHERE content__award__vendor__CCRException IS NOT NULL
GROUP BY flag_value
ORDER BY record_count DESC

Each dictionary item includes SQL-ready examples generated alongside the variable metadata, allowing immediate use in FPDS Query for filtering, aggregation, and analysis.