FPDS Query Library
About Us
Contact Us

Destroy Date

Stores the scheduled destruction date for the contract record or related NASA-specific data element. It is a date attribute used to indicate when the record is expected to be removed or archived according to retention rules.

Family: IDV
Category: NASA Specific Fields
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__destroyDate
Title
Destroy Date
FPDS Path
IDV/agencySpecificIDVElements/NASASpecificIDVElements/destroyDate
Description
Stores the scheduled destruction date for the contract record or related NASA-specific data element. It is a date attribute used to indicate when the record is expected to be removed or archived according to retention rules.
Business Meaning
This field matters because it helps analysts identify record-retention timing, understand when data may no longer be available for future review, and assess lifecycle management of NASA procurement records. It can also support compliance checks and data governance analysis around document preservation and disposal schedules.
Example Value
2025-04-08 00:00:00
Observed Non-Null Count
2,009

FPDS Compare

FPDS Query Variable
content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__destroyDate
FPDS XML Path
IDV/agencySpecificIDVElements/NASASpecificIDVElements/destroyDate
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'IDV/agencySpecificIDVElements/NASASpecificIDVElements/destroyDate' into the SQL-ready variable 'content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__destroyDate'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • NASA-specific IDV record interpretation

Common Usage

  • Identify records scheduled for archival or destruction
  • Support retention and records-management reporting
  • Filter datasets by data lifecycle status

Common Mistakes

  • Interpreting it as the contract end date or modification date
  • Comparing the raw string without converting it to a date type

Query Guidance

Parse the value to a date/timestamp before comparison, then use it in WHERE clauses, date ranges, or retention-window logic. Example patterns: CAST(... AS DATE), DATE_TRUNC, or BETWEEN for scheduled-destruction analysis.

SQL Examples

Preview values

SELECT
    content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__destroyDate AS destroy_date
FROM fpds.data
WHERE content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__destroyDate IS NOT NULL
LIMIT 25

Top values

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