Skip to main content

Actual year group missing

In this article, we explore why the actual year group field may be empty, missing from the list, or not populating correctly in Mosaic.

Y
Written by Yusef Abulaynain
Updated over 4 months ago

Adding school years

This article contains instructions on how to configure the school year feature in Mosaic. The school year feature displays a child's school year under the education summary and it needs to be activated using some database scripts.


For hosted customers please raise a new case online and reference the title of this article. Please provide the name or URL of the affected Mosaic instances.
​
For non-hosted customers, follow the steps below:

  1. Run the following query.

    INSERT INTO MO_EDUCATION_YEAR_START_DAY
               (ENFORCE_SINGLE_ROW
               ,START_DAY
               ,START_MONTH)
         VALUES
               (1
               ,1
               ,9);

  2. Next, run the following query. 

    INSERT INTO MO_EDUCATION_YEARS
               (YEAR_CODE
               ,DESCRIPTION
               ,EXPECTED_AGE_AT_START)
         VALUES
               ('R', 'Reception',4),('Y1', 'Year 1',5),('Y2', 'Year 2',6),
               ('Y3', 'Year 3',7),('Y4', 'Year 4',8),('Y5', 'Year 5',9),
               ('Y6', 'Year 6',10),('Y7', 'Year 7',11),('Y8', 'Year 8',12),
               ('Y9', 'Year 9',13),('Y10', 'Year 10',14),('Y11', 'Year 11',15),
               ('Y12', 'Year 12',16),('Y13', 'Year 13',17);

  3. Restart Mosaic so that the changes take effect.


​

Did this answer your question?