Good point regarding ownership better belonging to the fiscal calendar. There's currently a link from actor.org_unit to acq.fiscal_calendar, although it doesn't have ownership semantics per se.
The fiscal calendar is meant to be a container for one or more fiscal years, and as such, I don't think the label for a given fiscal year goes on the calendar. As such, I disagree that "year" should always be a number.
Given the nature of the changes being contemplated, we could also consider a renaming of the acq.fiscal_year table to acq.fiscal_period.
Good point regarding ownership better belonging to the fiscal calendar. There's currently a link from actor.org_unit to acq.fiscal_ calendar, although it doesn't have ownership semantics per se.
The fiscal calendar is meant to be a container for one or more fiscal years, and as such, I don't think the label for a given fiscal year goes on the calendar. As such, I disagree that "year" should always be a number.
Given the nature of the changes being contemplated, we could also consider a renaming of the acq.fiscal_year table to acq.fiscal_period.