Calendar

Prev Next

Fiscal calendar definitions for each legal entity, with one row per calendar date per legal entity.

Before querying this table, complete Snowflake Data Share setup. See Snowflake Data Share Setup for step-by-step instructions.

Column reference

Column

Type

Description

tenant_id

NUMBER(38,0)

Customer's account identifier within the R365 platform.

id

VARCHAR

Unique identifier for the calendar record.

name

VARCHAR

Name for the calendar record.

calendar_day

NUMBER(38,0)

Day of the month (1 to 31) for the date. Blank on current calendars; filled only for dates from 2006 to 2017.

calendar_month

NUMBER(38,0)

Month number (1 to 12) for the date. Blank on current calendars; filled only for dates from 2006 to 2017.

calendar_year

VARCHAR

Calendar year of the date, as text (for example 2012). Blank on current calendars; filled only for dates from 2006 to 2017.

combined_reporting_day

NUMBER(38,0)

Fiscal day number (1 to 371) of this date in the company's main reporting calendar, so legal entities with different calendars can be reported together. Filled only for dates from 2006 to 2017.

combined_reporting_day_year

VARCHAR

The combined reporting day and year as text in the form 'day,year' (for example 99,2017). Filled only for dates from 2006 to 2017.

combined_reporting_period

NUMBER(38,0)

Fiscal period number of this date in the company's main reporting calendar. Filled only for dates from 2006 to 2017.

combined_reporting_period_name

VARCHAR

The name of the fiscal period in the company's primary reporting calendar for this date, so periods from different legal entities can be lined up. It is only filled for dates from 2006 to 2017 and is blank for later dates.

combined_reporting_period_year

VARCHAR

The combined reporting period and year as text in the form 'period,year'. Filled only for dates from 2006 to 2017.

combined_reporting_quarter

NUMBER(38,0)

Fiscal quarter number of this date in the company's main reporting calendar. Filled only for dates from 2006 to 2017.

combined_reporting_quarter_year

VARCHAR

The combined reporting quarter and year as text in the form 'quarter,year'. Filled only for dates from 2006 to 2017.

combined_reporting_week

NUMBER(38,0)

Fiscal week number of this date in the company's main reporting calendar. Filled only for dates from 2006 to 2017.

combined_reporting_week_year

VARCHAR

The combined reporting week and year as text in the form 'week,year'. Filled only for dates from 2006 to 2017.

combined_reporting_year1

VARCHAR

Fiscal year of this date in the company's main reporting calendar. Filled only for dates from 2006 to 2017.

date

DATE

Calendar date for this fiscal calendar record.

date_text

VARCHAR

The date as text in MM/DD/YYYY format.

day_name

NUMBER(38,0)

The number of the day within the week, from 1 to 7, for this calendar date.

days_back

NUMBER(38,0)

Number of days between this date and yesterday as of the last nightly refresh. 0 is yesterday, 1 is the day before. 999999 means the date is today or later; blank means not yet calculated.

fiscal_date_type

NUMBER(38,0)

The type of fiscal calendar used by this legal entity (such as Monthly, 4-4-5 Weekly, or Period-based).

fiscal_day

NUMBER(38,0)

Day number within the fiscal year, starting at 1.

fiscal_day_and_year

VARCHAR

Fiscal day number and fiscal year as text in the form 'day,year' (for example 149,2022).

fiscal_period

NUMBER(38,0)

The fiscal period number within the fiscal year to which this date belongs.

fiscal_period_and_year

VARCHAR

Fiscal period number and fiscal year as text in the form 'period,year' (for example 3,2026).

fiscal_quarter

NUMBER(38,0)

The fiscal quarter number (1-4) within the fiscal year to which this date belongs.

fiscal_quarter_and_year

VARCHAR

Fiscal quarter number and fiscal year as text in the form 'quarter,year' (for example 4,2026).

fiscal_week

NUMBER(38,0)

The fiscal week number within the fiscal year to which this date belongs.

fiscal_week_and_year

VARCHAR

Fiscal week number and fiscal year as text in the form 'week,year' (for example 17,2025).

fiscal_year1

VARCHAR

The fiscal year to which this date belongs.

period_name

VARCHAR

Name for the period.

periods_back

NUMBER(38,0)

Number of fiscal periods between this date's period and the period containing yesterday, as of the last nightly refresh. 0 is the current period. 999999 means the date is today or later.

quarters_back

NUMBER(38,0)

Number of fiscal quarters between this date's quarter and the quarter containing yesterday, as of the last nightly refresh. 0 is the current quarter. 999999 means the date is today or later.

week_name

VARCHAR

Name for the week.

weeks_back

NUMBER(38,0)

Number of fiscal weeks between this date's week and the week containing yesterday, as of the last nightly refresh. 0 is the current week. 999999 means the date is today or later.

years_back

NUMBER(38,0)

Number of fiscal years between this date's fiscal year and the fiscal year containing yesterday, as of the last nightly refresh. 0 is the current fiscal year. 999999 means the date is today or later.

legal_entity_id

VARCHAR

Unique identifier for the legal entity whose fiscal calendar this record belongs to.

created_on

TIMESTAMP_NTZ

Timestamp when the record was created.

created_by_id

VARCHAR

Identifier for the user who created the record.

modified_on

TIMESTAMP_NTZ

Timestamp when the record was last modified.

modified_by_id

VARCHAR

Identifier for the user who last modified the record.

is_deleted

BOOLEAN

Flag indicating whether the record is currently deleted. Derived from the latest event for the entity.