FPDS Query Library
About Us
Contact Us

Fiscal Year

Stores the fiscal year associated with the relevant contract date in an Other Transaction IDV record. It is a string-valued date attribute used to identify the reporting year for that contract timing element.

Family: Other Transaction IDV
Category: Dates
Data Type: string
Semantic Type: attribute
Mapping: flattened_fpds_xml_field
AI Confidence: high

Variable Overview

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__relevantContractDates__fiscalYear
Title
Fiscal Year
FPDS Path
OtherTransactionIDV/contractDetail/relevantContractDates/fiscalYear
Description
Stores the fiscal year associated with the relevant contract date in an Other Transaction IDV record. It is a string-valued date attribute used to identify the reporting year for that contract timing element.
Business Meaning
This field supports year-based aggregation, trend analysis, and period alignment for Other Transaction IDVs. Analysts use it to compare obligations, awards, and activity across fiscal years without relying only on calendar dates.
Example Value
2021
Observed Non-Null Count
13,417

FPDS Compare

FPDS Query Variable
content__OtherTransactionIDV__contractDetail__relevantContractDates__fiscalYear
FPDS XML Path
OtherTransactionIDV/contractDetail/relevantContractDates/fiscalYear
Mapping Type
flattened_fpds_xml_field
Comparison Summary
FPDS Query flattens the original nested FPDS XML path 'OtherTransactionIDV/contractDetail/relevantContractDates/fiscalYear' into the SQL-ready variable 'content__OtherTransactionIDV__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 grouping of Other Transaction IDVs
  • Filtering contract activity by reporting year
  • Building trend lines for procurement analysis

Common Mistakes

  • Assuming it is a calendar year
  • Casting without checking for nonstandard or missing values

Query Guidance

Use this field in WHERE and GROUP BY clauses to segment records by fiscal year, for example filtering to '2021' or aggregating counts and amounts by fiscal-year label. If comparing to transaction dates, normalize dates to the same fiscal-year logic before joining or summarizing.

SQL Examples

Preview values

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

Top values

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