select eo.EducationOrganizationId as SchoolId,eo.NameOfInstitution as School,eo2.EducationOrganizationId as DistrictId, eo2.NameOfInstitution as DistrictId
,s.StudentUniqueId,s.LastSurname,s.FirstName
,selpa.ProviderLicenseNumber, selpa.ECComment, ds.CodeValue as ECProgramCode, ds.Description as ECProgram, selpa.BeginDate as ECProgramStartDate
, dm.CodeValue as ECDeliveryMethodCode, dm.Description as ECDeliveryMethod, dsch.CodeValue as ECDeliveryScheduleCode, dsch.Description as ECDeliverySchedule
, dfpl.CodeValue as FederalPovertyLevelQuintileCode, dfpl.Description as FederalPovertyLevelQuintile
, daef.CodeValue as AdditionalEligibilityFactorCode, daef.Description as AdditionalEligibilityFactor
, gsp.EndDate as ECProgramEndDate, de.CodeValue as ECProgramExitReasonCode, de.Description as ECProgramExitReason
from mi.StudentEarlyLearningProgramAssociation selpa
left join edfi.Descriptor dm on dm.DescriptorId=selpa.DeliveryMethodDescriptorId
left join edfi.Descriptor dpt on dpt.DescriptorId=selpa.ProgramTypeDescriptorId
left join edfi.Descriptor dsch on dsch.DescriptorId=selpa.DeliveryScheduleDescriptorId
left join edfi.Descriptor dfpl on dfpl.DescriptorId=selpa.FederalPovertyLevelDescriptorId
left join edfi.GeneralStudentProgramAssociation gsp on gsp.StudentUSI=selpa.StudentUSI and gsp.ProgramEducationOrganizationId=selpa.ProgramEducationOrganizationId and gsp.ProgramName=selpa.ProgramName
and gsp.ProgramTypeDescriptorId=selpa.ProgramTypeDescriptorId
left join edfi.Student s on s.StudentUSI=selpa.StudentUSI
left join edfi.EducationOrganization eo on eo.EducationOrganizationId=selpa.EducationOrganizationId
left join edfi.EducationOrganization eo2 on eo2.EducationOrganizationId=selpa.ProgramEducationOrganizationId
left join mi.StudentEarlyLearningProgramAssociationECProgram selpp on selpp.StudentUSI=selpa.StudentUSI and selpp.ProgramEducationOrganizationId=selpa.ProgramEducationOrganizationId 
 and selpp.ProgramName=selpa.ProgramName
and selpp.ProgramTypeDescriptorId=selpa.ProgramTypeDescriptorId and selpp.BeginDate=selpa.BeginDate
left join edfi.Descriptor ds on ds.DescriptorId=selpp.ECProgramDescriptorId
left join mi.StudentEarlyLearningProgramAssociationAdditionalEligibilityFactor selaef on selaef.StudentUSI=selpa.StudentUSI and selaef.ProgramEducationOrganizationId=selaef.ProgramEducationOrganizationId 
 and selaef.ProgramName=selpa.ProgramName
left join edfi.Descriptor daef on daef.DescriptorId=selaef.AdditionalEligibilityFactorDescriptorId
left join edfi.Descriptor de on de.DescriptorId=gsp.ReasonExitedDescriptorId
order by s.LastSurname,s.FirstName