FPDS Query Library
About Us
Contact Us

Solicitation Issue Date

The date the NASA solicitation was issued for the IDV action. It records when the agency formally released the solicitation under the NASA-specific IDV elements, typically as a timestamp-like string value.

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__solicitationIssueDate
Title
Solicitation Issue Date
FPDS Path
IDV/agencySpecificIDVElements/NASASpecificIDVElements/solicitationIssueDate
Description
The date the NASA solicitation was issued for the IDV action. It records when the agency formally released the solicitation under the NASA-specific IDV elements, typically as a timestamp-like string value.
Business Meaning
This date helps analysts measure procurement timing, compare solicitation-to-award intervals, and segment NASA IDV activity by issuance period. It is useful for pipeline analysis, fiscal-year reporting, and identifying solicitation patterns across reusable contracting vehicles.
Example Value
2013-02-11 00:00:00
Observed Non-Null Count
11,646

FPDS Compare

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

Use Cases

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

Common Usage

  • Calculate time from solicitation release to award or base period start
  • Group NASA IDVs by month, quarter, or fiscal year of solicitation issuance
  • Filter records to a specific solicitation window for pipeline analysis

Common Mistakes

  • Confusing solicitation issue date with award date or contract effective date
  • Using the raw string without converting it to a proper date or timestamp

Query Guidance

Cast or parse the field to a date in SQL before filtering, sorting, or computing intervals. Example pattern: WHERE CAST(solicitationIssueDate AS DATE) BETWEEN ...; then use date truncation or EXTRACT for period-based analysis.

SQL Examples

Preview values

SELECT
    content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__solicitationIssueDate AS solicitation_issue_date
FROM fpds.data
WHERE content__IDV__agencySpecificIDVElements__NASASpecificIDVElements__solicitationIssueDate IS NOT NULL
LIMIT 25

Top values

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