FPDS Query Library
About Us
Contact Us

Security Code

Numeric NASA-specific award flag indicating whether the Security Code attribute is present or asserted for the award record. The coded values are 0 for false and 1 for true.

Family: Award
Category: General
Data Type: numeric
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__award__agencySpecificAwardElements__NASASpecificAwardElements__securityCode
Title
Security Code
FPDS Path
award/agencySpecificAwardElements/NASASpecificAwardElements/securityCode
Description
Numeric NASA-specific award flag indicating whether the Security Code attribute is present or asserted for the award record. The coded values are 0 for false and 1 for true.
Business Meaning
This field helps analysts identify awards subject to NASA-specific security-related processing or reporting logic. It supports segmentation of award populations when evaluating compliance, sensitivity, or workflow rules tied to NASA-specific security handling.
Example Value
1
Observed Non-Null Count
826,778

FPDS Compare

FPDS Query Variable
content__award__agencySpecificAwardElements__NASASpecificAwardElements__securityCode
FPDS XML Path
award/agencySpecificAwardElements/NASASpecificAwardElements/securityCode
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'award/agencySpecificAwardElements/NASASpecificAwardElements/securityCode' into the SQL-ready variable 'content__award__agencySpecificAwardElements__NASASpecificAwardElements__securityCode'.

Use Cases

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

Common Usage

  • Filter NASA awards with security code enabled
  • Group awards by security-related flag status
  • Validate NASA-specific award element completeness

Common Mistakes

  • Interpreting 0 as missing rather than false
  • Using the field as a descriptive security classification instead of a boolean flag

Query Guidance

Use equality predicates such as `= 1` or `= 0` for binary filtering, and include `IS NULL` checks when measuring data completeness. If joining to other award attributes, apply the filter at the award level and avoid aggregating nulls with false values.

SQL Examples

Preview values

SELECT
    content__award__agencySpecificAwardElements__NASASpecificAwardElements__securityCode AS security_code
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__securityCode IS NOT NULL
LIMIT 25

Aggregate total

SELECT
    sum(content__award__agencySpecificAwardElements__NASASpecificAwardElements__securityCode) AS total_value
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__securityCode IS NOT NULL

Distribution overview

SELECT
    min(content__award__agencySpecificAwardElements__NASASpecificAwardElements__securityCode) AS min_value,
    avg(content__award__agencySpecificAwardElements__NASASpecificAwardElements__securityCode) AS avg_value,
    max(content__award__agencySpecificAwardElements__NASASpecificAwardElements__securityCode) AS max_value,
    count() AS record_count
FROM fpds.data
WHERE content__award__agencySpecificAwardElements__NASASpecificAwardElements__securityCode IS NOT NULL

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