FPDS Query Library
About Us
Contact Us

A76 Action Description

Human-readable description for the FPDS coded field "A76 Action" on an IDV competition record. It conveys the textual label or explanation associated with the underlying action code, rather than the code itself.

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

Variable Overview

FPDS Query Variable
content__IDV__competition__A76Action__description
Title
A76 Action Description
FPDS Path
IDV/competition/A76Action/description
Description
Human-readable description for the FPDS coded field "A76 Action" on an IDV competition record. It conveys the textual label or explanation associated with the underlying action code, rather than the code itself.
Business Meaning
This field helps analysts interpret competition-related IDV data without relying solely on abbreviated or coded values. It is useful for validating how an A76 action was recorded and for translating source codes into readable procurement terms in reporting and review.
Example Value
NO
Observed Non-Null Count
5,542,188

FPDS Compare

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

Paired Field

Relationship
description_of
Variable
A76 Action

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Competition and sole-source analysis

Common Usage

  • Decode or label A76 action values in reports
  • Validate competition-related IDV records
  • Group records by human-readable action description

Common Mistakes

  • Using the description as a substitute for the underlying code in joins or filters
  • Assuming a short value like "NO" is the full business meaning without checking the paired code

Query Guidance

Use this field for display, validation, and text-based grouping. In SQL, filter or join on the underlying A76 Action code when available; use this description field to label results or to audit whether coded values map to the expected human-readable text.

SQL Examples

Preview values

SELECT
    content__IDV__competition__A76Action__description AS a76_action_description
FROM fpds.data
WHERE content__IDV__competition__A76Action__description IS NOT NULL
LIMIT 25

Top values

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