text: -- SPDX-License-Identifier: Apache-2.0
  -- Licensed to the Ed-Fi Alliance under one or more agreements.
  -- The Ed-Fi Alliance licenses this file to you under the Apache License, Version 2.0.
  -- See the LICENSE and NOTICES files in the project root for more information.
  
  CREATE TABLE reporting.StudentFallMembership
  (
      DATAYEARS NVARCHAR(9),
      DISTRICT_CODE NVARCHAR(7),
      SCHOOL_CODE NVARCHAR(60),
      STUDENT_ID NVARCHAR(10),
      LOCAL_STUDENT_ID NVARCHAR(25),
      DISTRICT_CODE_RESIDENCE NVARCHAR(7),
      SCHOOL_CODE_RESIDENCE NVARCHAR(60),
      STUDENT_NAME NVARCHAR(42),
      STUDENT_LAST_NM NVARCHAR(60),
      STUDENT_FIRST_NM NVARCHAR(60),
      STUDENT_MID_INIT NVARCHAR(1),
      GRADE_LEVEL NVARCHAR(50),
      BIRTHDATE DATE,
      GENDER_CODE NVARCHAR(1),
      ETHNIC_CODE NVARCHAR(50),
      ETHNIC_DESC NVARCHAR(1024),
      SPECIAL_EDUCATION_CODE NVARCHAR(1),
      SPECIAL_EDUCATION_DESC NVARCHAR(3),
      LEP_ELIGIBILITY_CODE NVARCHAR(1),
      LEP_ELIGIBILITY_DESC NVARCHAR(3),
      LEP_PARTICIPATION_CODE NVARCHAR(1),
      LEP_PARTICIPATION_DESC NVARCHAR(3),
      LEP_DURATION_CODE INT,
      LEP_DURATION_DESC INT,
      ENGLISH_PROFICIENCY_CODE NVARCHAR(2),
      ENGLISH_PROFICIENCY_DESC NVARCHAR(30),
      HOME_LANGUAGE_CODE NVARCHAR(50),
      HOME_LANGUAGE_DESC NVARCHAR(100),
      TARGETED_ASSISTANCE_NONPUBLIC_CODE NVARCHAR(1),
      TARGETED_ASSISTANCE_NONPUBLIC_DESC NVARCHAR(2),
      EXPECTED_GRADUATION_YEAR smallINT,
      STUD_SINGLE_PARENT_CODE NVARCHAR(1),
      STUD_SINGLE_PARENT_DESC NVARCHAR(3),
      IMMIGRANT_CODE NVARCHAR(50),
      IMMIGRANT_DESC NVARCHAR(1024),
      FTE_PERCENT INT,
      HISPANIC_IND NVARCHAR(3),
      PRIMARY_RACE_IND INT,
      ETHNIC_CODE_2 INT,
      ETHNIC_DESC_2 INT,
      RACE1_SHORT_DESC NVARCHAR(1024),
      RACE2_CODE NVARCHAR(50),
      RACE2_SHORT_DESC NVARCHAR(1024),
      RACE3_CODE NVARCHAR(50),
      RACE3_SHORT_DESC NVARCHAR(1024),
      RACE4_CODE NVARCHAR(50),
      RACE4_SHORT_DESC NVARCHAR(1024),
      RACE5_CODE NVARCHAR(50),
      RACE5_SHORT_DESC NVARCHAR(1024),
      UNACCOMPANIED_HOMELESS_YOUTH_CODE NVARCHAR(1),
      UNACCOMPANIED_HOMELESS_YOUTH_DESC NVARCHAR(3),
      MILITARY_FAMILY_CODE NVARCHAR(1),
      MILITARY_FAMILY_DESC NVARCHAR(3),
      RESIDENCE_STATUS_CODE NVARCHAR(50),
      RESIDENCE_STATUS_DESCRIPTION NVARCHAR(75),
      BATCH_ID INT,
      STUDENT_KEY INT,
      SCHOOL_YEAR NVARCHAR(10)
  )
  GO
  
  CREATE TABLE reporting.SpecialEducationChildCount
  (
      Datayears VARCHAR(9),
      StudentUniqueId NVARCHAR(32),
      AgencyId NVARCHAR(60),
      DistrictOfResidence NVARCHAR(7),
      SchoolOfResidence VARCHAR(1),
      LastName NVARCHAR(75),
      FirstName NVARCHAR(75),
      MiddleName NVARCHAR(75),
      Birthdate DATE,
      Age INT,
      DisabilityCode NVARCHAR(50),
      DisabilityDescription NVARCHAR(75),
      SpeechLanguageTherapyServices NVARCHAR(1),
      OccupationalTherapyServices NVARCHAR(1),
      SettingCode NVARCHAR(50),
      SettingDescription NVARCHAR(75),
      PartBC NVARCHAR(75),
      SpecialEducationPercentage int,
      AlternateAssessment VARCHAR(1),
      RaceCode NVARCHAR(50),
      RaceDescription NVARCHAR(1024),
      GradeLevel NVARCHAR(50),
      GenderCode NVARCHAR(1),
      GenderDescription NVARCHAR(75),
      EnglishLearnerCode VARCHAR(2),
      EnglishLearnerDescription VARCHAR(42),
      ResidenceStatusCode NVARCHAR(50),
      ResidenceStatusDescription NVARCHAR(75),
      UpdateDate DATETIME
  )
  GO
  