E.3.2 Using a Calendar Year Configuration

Under the default calendar year configuration, the FSI_FISCAL_YEAR_INFO/ LEDGER_CCY_AND_FISCAL_YR_INFO table contains a Fiscal Period value of 12 and a Start Month value of 1. For the following calendar year example, calendar months for 2020 correspond to the monthly buckets as shown in the following table:

Table E-4 Monthly Data for Calendar Year 2020

Month 01 Month 02 Month 03 Month 04 Month 05 Month 06 Month 07 Month 08 Month 09 Month 10 Month 11 Month 12
Jan2020 Feb2020 Mar2020 Apr2020 May2020 Jun2020 Ju2020 Aug2020 Sep2020 Oct2020 Nov2020 Dec2020

If you have set your As-of-Date to June 2020, then any OFSAA process will insert the Balance for the sixth month into the Management Ledger table with FISCAL_MONTH as 06.

Continuing with this calendar year example, the 12 YTD buckets correspond to 2020 calendar month ranges as shown in the following table:

Table E-5 Year-to-Date Data for Calendar Year 2020

YTD as of Month 01 YTD as of Month 02 YTD as of Month 03 YTD as of Month 04 YTD as of Month 05 YTD as of Month 06 YTD as of Month 07 YTD as of Month 08 YTD as of Month 09 YTD as of Month 10 YTD as of Month 11 YTD as of Month 12
Jan2020 Jan to Feb 2020 Jan to Mar 2020 Jan to April 2020 Jan to May 2020 Jan to June 2020 Jan to July 2020 Jan to Aug 2020 Jan to Sep 2020 Jan to Oct 2020 Jan to Nov 2020 Jan to Dec 2020

For details on the relationships between Month-to-Date columns and Year-to-Date columns, see Management Ledger.