select 'CalendarDateCalendarEvent' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(CreateDate) as Updated,count(*) as RecordCount from edfi.CalendarDateCalendarEvent union select 'Course' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.Course union select 'CourseOffering' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.CourseOffering union select 'DisciplineAction' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.DisciplineAction union select 'DisciplineActionDiscipline' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(CreateDate) as Updated,count(*) as RecordCount from edfi.DisciplineActionDiscipline union select 'DisciplineActionDisciplineIncident' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(CreateDate) as Updated,count(*) as RecordCount from [edfi].[DisciplineActionStudentDisciplineIncidentAssociation] union select 'DisciplineIncident' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.DisciplineIncident union select 'DisciplineIncidentBehavior' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(CreateDate) as Updated,count(*) as RecordCount from edfi.DisciplineIncidentBehavior union select 'EducationOrganization' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.EducationOrganization union select 'Intervention' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.Intervention union select 'Section' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.Section union select 'Session' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.Session union select 'Staff' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.Staff union select 'StaffSchoolAssociation' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StaffSchoolAssociation union select 'StaffSectionAssociation' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StaffSectionAssociation union select 'Student' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.Student union select 'StudentDisability' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(CreateDate) as Updated,count(*) as RecordCount from [edfi].[StudentEducationOrganizationAssociationDisability] union select 'StudentDisciplineIncidentAssociation' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StudentDisciplineIncidentAssociation union select 'StudentEducationOrganizationAssociation' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StudentEducationOrganizationAssociation union select 'StudentProgramParticipation' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(CreateDate) as Updated,count(*) as RecordCount from [edfi].[StudentEducationOrganizationAssociationProgramParticipation] union select 'StudentRace' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(CreateDate) as Updated,count(*) as RecordCount from [edfi].[StudentEducationOrganizationAssociationRace] union select 'StudentSchoolAssociation' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StudentSchoolAssociation union select 'StudentSchoolAttendanceEvent' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StudentSchoolAttendanceEvent union select 'StudentSectionAssociation' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StudentSectionAssociation union select 'StudentSectionAttendanceEvent' as Category, min (CreateDate) as Since, max(CreateDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StudentSectionAttendanceEvent union select 'Student Characteristic: Homeless' as Category, min (LastModifiedDate) as Since, max(LastModifiedDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StudentEducationOrganizationAssociationStudentCharacteristic sic left join edfi.Descriptor d on d.DescriptorId=sic.StudentCharacteristicDescriptorId where d.CodeValue='Homeless' or d.ShortDescription like '%homeless%' union select 'Student Characteristic: Migrant' as Category, min (LastModifiedDate) as Since, max(LastModifiedDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StudentEducationOrganizationAssociationStudentCharacteristic sic left join edfi.Descriptor d on d.DescriptorId=sic.StudentCharacteristicDescriptorId where d.CodeValue='Migrant' union select 'Student Characteristic: Economic Disadvantaged' as Category, min (LastModifiedDate) as Since, max(LastModifiedDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StudentEducationOrganizationAssociationStudentCharacteristic sic left join edfi.Descriptor d on d.DescriptorId=sic.StudentCharacteristicDescriptorId where d.CodeValue='Economic Disadvantaged' or d.ShortDescription like '%economic%' union select 'Student Characteristic: Special Education' as Category, min (LastModifiedDate) as Since, max(LastModifiedDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StudentEducationOrganizationAssociationStudentCharacteristic sic left join edfi.Descriptor d on d.DescriptorId=sic.StudentCharacteristicDescriptorId where d.CodeValue='Special Education' or d.ShortDescription like '%special%' union select 'Student Characteristic: Other' as Category, min (LastModifiedDate) as Since, max(LastModifiedDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StudentEducationOrganizationAssociationStudentCharacteristic sic left join edfi.Descriptor d on d.DescriptorId=sic.StudentCharacteristicDescriptorId where d.CodeValue='Other' union select 'Student Characteristic: '+d.CodeValue as Category, min (LastModifiedDate) as Since, max(LastModifiedDate) as Created, max(LastModifiedDate) as Updated,count(*) as RecordCount from edfi.StudentEducationOrganizationAssociationStudentCharacteristic sic left join edfi.Descriptor d on d.DescriptorId=sic.StudentCharacteristicDescriptorId group by d.CodeValue union select 'Student Program: '+spa.ProgramName as Category, min (spa.BeginDate) as Since, max(spa.BeginDate) as Created, max(spa.BeginDate) as Updated,count(*) as RecordCount from edfi.StudentProgramAssociation spa group by spa.ProgramName union select 'Program Participation Status: '+d.ShortDescription as Category, min (spa.CreateDate) as Since, max(spa.CreateDate) as Created, max(spa.CreateDate) as Updated,count(*) as RecordCount from mi.StudentEducationOrganizationAssociationProgramParticipationStatus spa left join edfi.Descriptor d on d.DescriptorId=spa.ProgramParticipationStatusDescriptorId group by d.ShortDescription union select 'Program Participation Status: Title I' as Category, min (spa.CreateDate) as Since, max(spa.CreateDate) as Created, max(spa.CreateDate) as Updated,count(*) as RecordCount from mi.StudentEducationOrganizationAssociationProgramParticipationStatus spa left join edfi.Descriptor d on d.DescriptorId=spa.ProgramParticipationStatusDescriptorId where d.ShortDescription like '%Title I%' union select 'Program Participation Status: 31a At-Risk Factors' as Category, min (spa.CreateDate) as Since, max(spa.CreateDate) as Created, max(spa.CreateDate) as Updated,count(*) as RecordCount from mi.StudentEducationOrganizationAssociationProgramParticipationStatus spa left join edfi.Descriptor d on d.DescriptorId=spa.ProgramParticipationStatusDescriptorId where d.ShortDescription like '%31a%'