dbo.PB_DateDim

Info Generated by scripts/Generate-DataDictionary.ps1 - do not edit by hand. Edit descriptions in schemas/tables/dbo.PB_DateDim.json and regenerate.

Columns

#	Column	Type	Nullable	Flags	Description
1	date	date	yes		Calendar date represented by this date-dimension row, used for reporting joins in Power BI.
2	year	int	yes		Calendar year of the date.
3	month	int	yes		Calendar month number (1-12).
4	monthName	varchar(20)	yes		Full calendar month name (e.g. "January").
5	monthNameShort	varchar(20)	yes		Abbreviated calendar month name (e.g. "Jan").
6	quarter	int	yes		Calendar quarter number (1-4).
7	weekOfYear	int	yes		ISO/calendar week number within the year.
8	weekOfMonth	int	yes		Week number within the calendar month.
9	dayOfWeek	int	yes		Day of week as a number (e.g. 1=Sunday, per SQL Server default).
10	dayName	varchar(20)	yes		Full day-of-week name (e.g. "Monday").
11	day	varchar(20)	yes		Day of month, stored as text.
12	financialPeriod	int	yes		Sequential financial period number (Australian FY, July-June) used for reporting rollups.
13	finYearShort	varchar(20)	yes		Abbreviated financial year label (e.g. "FY24").
14	financialQuarter	varchar(20)	yes		Financial quarter label, based on an Australian July-June financial year.
15	financialYear	varchar(20)	yes		Full financial year label (e.g. "2023-2024").
16	finYear	varchar(20)	yes		Financial year label variant (e.g. "FY2024").
17	finYearQtr	varchar(20)	yes		Combined financial year and quarter label (e.g. "FY24-Q2").
18	finYearMonth	varchar(20)	yes		Combined financial year and month label used for monthly reporting rollups.
19	yearMonth	varchar(20)	yes		Combined calendar year and month label (e.g. "2024-01") used for monthly reporting rollups.