MI Early Roster/Nonpublic School Student Roster

Introduction

This will create the MI Early Roster or Nonpublic School Student Roster export file. Use this to submit projected student enrollment for the following school year.

The MI Early Roster is not a certified collection, so it does not impact accountability, nor does the submitted data become part of students' official records. Data are used for the creation of direct certification reports. The Division of Accountability Services (DAS) may also use Early Roster data for Kindergarten Entry Assessment (KEA) and Interim assessments.

The Nonpublic School Student Roster is for Nonpublic schools participating in the National School Lunch Program. Nonpublic schools participating in the National School Lunch Program are required to submit their entire student enrollment, including new enrollees and existing students, in the MSDS Nonpublic School Student Roster Collection. These data are used to update the direct certification report of children who are automatically certified for free school meals. The report is refreshed throughout the school year. For more information, visit CEPI's Direct Certification Report page.

Refer to the following links for additional information on the Early Roster Collection: http://www.mi.gov/cepi/0,1607,7-113-986_50502_53551---,00.html or Nonpublic School Student Roster Collection: https://www.michigan.gov/cepi/nonpub

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to the selection criteria for analysis when the report does not return the correct records.

Student Selection

Student records are selected based on the following criteria:

The student is included in state reporting. ([Students]State_ExcludeFromReporting=0)
The student's exit date is greater than the Previous Count Date entered in the report parameters. ([Students]ExitDate>Previous Count Date)

Report Input

For help with navigation and running the report, see How to Find and Generate a Report.

Field	Description
Current Selection Students	Select whether to run the export file for the selected number of students or for all students.
Collection Type	Select the collection that should be used to create the export file.
Entity Type Code	Select the entity type code.
Entity Code	Enter the entity code.
Reporting District's State Assigned 5-digit District Number	Enter the reporting district's state-assigned, five-digit district number.
First Day of School	Enter the date of the first day of school.
Previous Count Date	Enter the previous count date.
Current Count Date	Enter the current count date.
Select schools to export.	Select which schools to export if applicable.

Back to Top

Report Output

Early Roster

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName
<SubmittingEntity>
1	<SubmittingEntityTypeCode>	This contains the submitting entity type code value selected on the report interface.	N/A
2	<SubmittingEntityCode>	This contains the submitting entity code value entered on the report interface.	N/A
<PersonalCore>
3	<UIC>	This contains the student's Unique Identification Code (UIC).	[Students]State_StudentNumber
4	<LastName>	This contains the student's last name.	[Students]Last_Name
5	<FirstName>	This contains the student's first name.	[Students]First_Name
6	<MiddleName>	This contains the student's middle name.	[Students]Middle_Name
7	<StudentSuffix>	This contains the student's suffix.	[S_MI_STU_GC_X]stuNameSuffix
8	<DateOfBirth>	This contains the student's date of birth.	[Students]DOB
9	<MultipleBirthOrder>	This identifies the birth order of the student if the student is part of a multiple birth.	[S_MI_STU_GC_X]multipleBirth
10	<Gender>	This contains the student's gender code. Note: If the student's preferred gender is not M or F, the legal gender is reported.	[Students]Gender [STUDENTCOREFIELDS]PSCore_Legal_Gender
<SchoolDemographics>
11	<OperatingDistrictNumber>	This contains the operating district number value entered on the report interface.	N/A
12	<SchoolFacilityNumber>	This contains the school or facility number for the student's school.	[S_MI_SCH_TSDL_X]adminUnit [S_MI_STU_GC_X]adminUnit
13	<StudentIdNumber>	This contains the PowerSchool student ID number.	[Students]Student_Number
14	<GradeOrSetting>	This contains the grade level in which the student is enrolled.	[Students]Grade_Level [ReEnrollments]Grade_Level [S_MI_STU_GC_X]educSetting
15	<S2E2Code>	This contains the school or relationship code (Educational Entity Master S2E2 code) for the student.	[S_MI_STU_GC_X]S2E2code
16	<BldgOtherwiseAttend>	This is the five-digit code that represents the school or facility building where the student would otherwise attend as specified in Sec. 104b (16).	[S_MI_STU_GC_X]bldgOtherwiseAttend
<PersonalDemographics>
17	<ResidentLEANumber>	This contains the student's resident LEA number.	[S_MI_STU_GC_X]residentLEA
18	<StudentResidentCounty>	This contains the student's resident county code.	[S_MI_STU_GC_X]residentCounty
19	<Ethnicity>	This contains the student's ethnicity.	[S_MI_STU_GC_X]ethnicIndian [S_MI_STU_GC_X]ethnicAsian [S_MI_STU_GC_X]ethnicBlack [S_MI_STU_GC_X]ethnicPacific [S_MI_STU_GC_X]ethnicWhite [S_MI_STU_GC_X]ethnicHispanic
<Contacts>
20	<AddressTypeDescriptor>	This contains the type of address being reported.	[S_MI_STU_GC_X]AddressType_Physical [S_MI_STU_GC_X]AddressType_Mailing [S_MI_STU_GC_X]AddressType_Override [S_MI_STU_GC_X]AddressType_Additional
21	<StreetNumberName>	This contains the number and name of the location of the address for the reported Address Type	[Students]street [Students]mailing_street [S_MI_STU_GC_X]pdStreetAddress [S_MI_STU_GC_X]eoParentAddr1
22	<ApartmentRoomSuiteNumber>	This contains the additional street address information such as apartment, room, suite or lot number that refers to the reported Address Type.	[S_MI_STU_GC_X]pdStreetAddress2 [S_MI_STU_GC_X]eoParentAddr2
23	<City>	This contains the name of the city or town where the address is located.	[Students]city [Students]mailing_city [S_MI_STU_GC_X]pdCity [S_MI_STU_GC_X]eoParentCity
24	<StateAbbreviationDescriptor>	This contains the abbreviation for the state (within the United States) or outlying area in which the address is located.	[Students]state [Students]mailing_state [S_MI_STU_GC_X]pdState [S_MI_STU_GC_X]eoParentState
25	<PostalCode>	This contains the five- or nine-digit ZIP code of the location where the address is located.	[Students]zip [Students]mailing_zip [S_MI_STU_GC_X]pdZipCode [S_MI_STU_GC_X]eoParentZip
26	<TelephoneNumber>	This contains the primary telephone number given by the student’s parent or guardian.	[Students]HomePhone [S_MI_STU_GC_X]eoParentPhone

Report Output

Nonpublic School Student Roster

Each of the fields displayed in the output of the report is described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName
<SubmittingEntity>
1	<SubmittingEntityTypeCode>	This contains the submitting entity type code value selected on the report interface.	N/A
2	<SubmittingEntityCode>	This contains the submitting entity code value entered on the report interface.	N/A
<PersonalCore>
3	<UIC>	This contains the student's Unique Identification Code (UIC).	[Students]State_StudentNumber
4	<LastName>	This contains the student's last name.	[Students]Last_Name
5	<FirstName>	This contains the student's first name.	[Students]First_Name
6	<MiddleName>	This contains the student's middle name.	[Students]Middle_Name
7	<StudentSuffix>	This contains the student's suffix.	[S_MI_STU_GC_X]stuNameSuffix
8	<DateOfBirth>	This contains the student's date of birth.	[Students]DOB
9	<MultipleBirthOrder>	This identifies the birth order of the student if the student is part of a multiple birth.	[S_MI_STU_GC_X]multipleBirth
10	<Gender>	This contains the student's gender code. Note: If the student's preferred gender is not M or F, the legal gender is reported.	[Students]Gender [STUDENTCOREFIELDS]PSCore_Legal_Gender
<SchoolDemographics>
11	<OperatingDistrictNumber>	This contains the operating district number value entered on the report interface.	N/A
12	<SchoolFacilityNumber>	This contains the school or facility number for the student's school.	[S_MI_SCH_TSDL_X]adminUnit [S_MI_STU_GC_X]adminUnit
13	<StudentIdNumber>	This contains the PowerSchool student ID number.	[Students]Student_Number
14	<GradeOrSetting>	This contains the grade level in which the student is enrolled.	[Students]Grade_Level [ReEnrollments]Grade_Level [S_MI_STU_GC_X]educSetting
15	<S2E2Code>	This contains the school or relationship code (Educational Entity Master S2E2 code) for the student.	[S_MI_STU_GC_X]S2E2code
16	<BldgOtherwiseAttend>	This is the five-digit code that represents the school or facility building where the student would otherwise attend as specified in Sec. 104b (16).	[S_MI_STU_GC_X]bldgOtherwiseAttend
<PersonalDemographics>
17	<ResidentLEANumber>	This contains the student's resident LEA number.	[S_MI_STU_GC_X]residentLEA
18	<StudentResidentCounty>	This contains the student's resident county code.	[S_MI_STU_GC_X]residentCounty
19	<Ethnicity>	This contains the student's ethnicity.	[S_MI_STU_GC_X]ethnicIndian [S_MI_STU_GC_X]ethnicAsian [S_MI_STU_GC_X]ethnicBlack [S_MI_STU_GC_X]ethnicPacific [S_MI_STU_GC_X]ethnicWhite [S_MI_STU_GC_X]ethnicHispanic
<Contacts>
20	<AddressTypeDescriptor>	This contains the type of address being reported.	[S_MI_STU_GC_X]AddressType_Physical [S_MI_STU_GC_X]AddressType_Mailing [S_MI_STU_GC_X]AddressType_Override [S_MI_STU_GC_X]AddressType_Additional
21	<StreetNumberName>	This contains the number and name of the location of the address for the reported Address Type	[Students]street [Students]mailing_street [S_MI_STU_GC_X]pdStreetAddress [S_MI_STU_GC_X]eoParentAddr1
22	<ApartmentRoomSuiteNumber>	This contains the additional street address information such as apartment, room, suite or lot number that refers to the reported Address Type.	[S_MI_STU_GC_X]pdStreetAddress2 [S_MI_STU_GC_X]eoParentAddr2
23	<City>	This contains the name of the city or town where the address is located.	[Students]city [Students]mailing_city [S_MI_STU_GC_X]pdCity [S_MI_STU_GC_X]eoParentCity
24	<StateAbbreviationDescriptor>	This contains the abbreviation for the state (within the United States) or outlying area in which the address is located.	[Students]state [Students]mailing_state [S_MI_STU_GC_X]pdState [S_MI_STU_GC_X]eoParentState
25	<PostalCode>	This contains the five- or nine-digit ZIP code of the location where the address is located.	[Students]zip [Students]mailing_zip [S_MI_STU_GC_X]pdZipCode [S_MI_STU_GC_X]eoParentZip
26	<TelephoneNumber>	This contains the primary telephone number given by the student’s parent or guardian.	[Students]HomePhone [S_MI_STU_GC_X]eoParentPhone
<HomelessDemographics>
27	<Homeless>	This identifies if the student is considered homeless.	[S_MI_STU_GC_X]homelessStatus
28	<UnaccompaniedYouth>	This identifies if the student is considered an unaccompanied youth.	[S_MI_STU_GC_X]flagUnacYouth
<SNE>
29	<SupplementalNutritionEligibility>	This contains the student’s lunch status eligibility.	[Students]LunchStatus [S_MI_STU_GC_X]lunchStatus_Override

Back to Top