FPDS Query Library
About Us
Contact Us

Fiscal Year

Numeric fiscal year associated with the award's relevant contract dates. It identifies the government fiscal year in which the record's contract timing is classified for FPDS reporting and analysis.

Family: Other Transaction Award
Category: Dates
Data Type: numeric
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionAward__contractDetail__relevantContractDates__fiscalYear
Title
Fiscal Year
FPDS Path
OtherTransactionAward/contractDetail/relevantContractDates/fiscalYear
Description
Numeric fiscal year associated with the award's relevant contract dates. It identifies the government fiscal year in which the record's contract timing is classified for FPDS reporting and analysis.
Business Meaning
This field is essential for time-series analysis, annual obligation reporting, and fiscal-year-based compliance reviews. Analysts use it to align awards with government budgeting cycles rather than calendar years, which affects spend trends, award counts, and year-over-year comparisons.
Example Value
2022
Observed Non-Null Count
38,894

FPDS Compare

FPDS Query Variable
content__OtherTransactionAward__contractDetail__relevantContractDates__fiscalYear
FPDS XML Path
OtherTransactionAward/contractDetail/relevantContractDates/fiscalYear
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionAward/contractDetail/relevantContractDates/fiscalYear' into the SQL-ready variable 'content__OtherTransactionAward__contractDetail__relevantContractDates__fiscalYear'.

Use Cases

  • Dictionary lookup and field explanation
  • SQL filtering and grouping
  • Analytical reporting and reusable query building
  • Timeline, cohort, and period analysis

Common Usage

  • Fiscal-year spend and award counts
  • Year-over-year procurement trend analysis
  • Filtering awards for annual reporting and dashboards

Common Mistakes

  • Interpreting the value as a calendar year instead of a federal fiscal year
  • Using it interchangeably with signed date, obligation date, or award date

Query Guidance

Filter with equality or fiscal-year ranges, e.g., WHERE fiscalYear = 2022 or WHERE fiscalYear BETWEEN 2021 AND 2023. When aggregating, group by this field to produce fiscal-year reporting, and avoid deriving fiscal year from a calendar date unless you have verified the transformation rules.

SQL Examples

Preview values

SELECT
    content__OtherTransactionAward__contractDetail__relevantContractDates__fiscalYear AS fiscal_year
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__relevantContractDates__fiscalYear IS NOT NULL
LIMIT 25

Aggregate total

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

Distribution overview

SELECT
    min(content__OtherTransactionAward__contractDetail__relevantContractDates__fiscalYear) AS min_value,
    avg(content__OtherTransactionAward__contractDetail__relevantContractDates__fiscalYear) AS avg_value,
    max(content__OtherTransactionAward__contractDetail__relevantContractDates__fiscalYear) AS max_value,
    count() AS record_count
FROM fpds.data
WHERE content__OtherTransactionAward__contractDetail__relevantContractDates__fiscalYear 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.