Details
-
Bug
-
Resolution: Done
-
Major
-
None
-
None
-
None
Description
Newly enrolled PK and K this year 2017-2018 will start having expected graduation year beyond the current schoolyeartype enumaration values.
Please add to the enumerations, data templates for the ods the subsequent values needed after 2030
Suggestion:
INSERT INTO [edfi].[SchoolYearType]
([SchoolYear]
,[SchoolYearDescription]
,[CurrentSchoolYear])
SELECT SchoolYear + 40 AS [SchoolYear], CONVERT(Varchar(4), SchoolYear + 39) + '-' + CONVERT(Varchar(4), SchoolYear + 40) AS [SchoolYearDescription], 0 AS [CurrentSchoolYear]
FROM edfi.SchoolYearType
order by SchoolYear