Uploaded image for project: 'Ed-Fi Data Standard'
  1. Ed-Fi Data Standard
  2. DATASTD-1068

Extend School Year Type values

    XMLWordPrintable

Details

    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

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              sbrunetjones Silvia Jones (old account) (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Salesforce