A76 Action Description

Human-readable description associated with the coded A76 Action field. It gives the plain-language label for the action value stored in the award/competition/A76Action structure.

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

Variable Overview

FPDS Query Variable
content__award__competition__A76Action__description
Title
A76 Action Description
FPDS Path
award/competition/A76Action/description
Description
Human-readable description associated with the coded A76 Action field. It gives the plain-language label for the action value stored in the award/competition/A76Action structure.
Business Meaning
This field helps analysts interpret procurement records that use abbreviated or coded values for competition-related A76 actions. It is useful for grouping, validating, and explaining contract award data without relying on the source code alone.
Example Value
NO
Observed Non-Null Count
105,593,025

FPDS Compare

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

Paired Field

Relationship
description_of
Variable

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 codes in reports
  • Validate competition-related award records
  • Support descriptive filters and mappings in analytics

Common Mistakes

  • Using the description as if it were the authoritative coded value
  • Analyzing this field without checking the paired A76 Action code

Query Guidance

Use this field for display, grouping labels, or joins to code descriptions, but keep the paired A76 Action code as the primary analytic key. In SQL, filter on the code field where possible and select this description field for presentation or validation of observed values.

SQL Examples

Preview values

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

Top values

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