MN Early Education Extract

Contents

Selection Criteria

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

The report selects records based on the following criteria:

The Student must have an Early Education Enrollment for the selected Reporting year that is indicated to be included in the Early Education Extract.

Report Input

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

This report uses the State Reporting Platform to generate results. There may be some additional setup required to run this report. The additional setup required to will be to configure ReportWorks Preferences if you have not already done so.

If you have already configured ReportWorks Preferences, no additional setup is required.
If you have not configured ReportWorks Preferences, please refer to the "ReportWorks Preferences" section of the ReportWorks Setup Guide located on PowerSource. This section will provide steps for configuring the scheduler node for the report queue.
There is no Report Output file included because the output file is in XML format.

Note: This report can only be run for the entire district.

Field	Description
Report Parameters	Select Set All; this will store your selections for this report which is helpful when you need to submit a new file and you are unsure of how you created your last file.
Regular Enrollments or Scholarship	Choose whether you are running the report for Regular Enrollments or Scholarships
Academic Year	Select the appropriate academic year for which you want to run the report.
Scheduling – Run Now	Leave Run Now selected to run the report now and click submit.
Scheduling – Schedule (optional)	Click the Schedule button to schedule this report to run automatically at a scheduled time.
Please Select Schedule Settings	Enter the Start Date and Start Time.
Select to Run Once or Repeat	If selecting Repeat, you will be given the option of Daily, Weekly, Monthly, Yearly
Please select daily repeat cycle options	Click Weekdays only if you want this report to only run on weekdays
Please select end date range option	Select No End Date or enter the End Date you want to use.
Submit	Click the submit button. You will be taken to the Report Queue. Once your file is complete, click on the complete button and you will have a PDF file to assist you in compiling your spreadsheet for the State.

Back to Top

Report Output

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

The MCCC Student Extract is a XML file.

Item	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	SchemaVersion	Schema Version of the file. This set to 1.14 by the report application.		Numeric	1
Header The following 5 items are present in the Header Section.
1	UnitNumber	The Org Unit ID number of a district. This will be District Number from PowerSchool. From the District Office > District > District Info	[Prefs]DISTRICTNUMBER	Numeric	4
2	UnitType	District Type from MDE-Org From the District Office > District > District Info.	[Prefs]DISTRICTTYPE	Numeric	2
3	SchoolYear	This field contains the school year for the report 2016-2017 = 17	Report Parameter	Numeric	4
4	IsScholarship	This value is set at report runtime. Reported Values: 0 - If the user selects Regular Enrollment 1 – If the user selects Scholarship		Numeric	1
5	RegistrationType	This is set to EE at report runtime.		Alpha	2
StudentProgramRegistrationRecord The following 18 items are present in the StudentProgramRegistrationRecordSection.
1	StateStudentId	This field contains the student's MARSS Number. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN.	[Students]State_StudentNumber	Numeric	13
2	LastName	This field contains the student's last name. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN or From the Start Page > Select a Student > Demographics.	[S_MN_STU_X]State_Last_Name or [Students]Last_name	Alpha	40
3	FirstName	This field contains the student's first name. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN or From the Start Page > Select a Student > Demographics.	[S_MN_STU_X]State_First_Name or [Students]First_name	Alpha	40
4	MiddleName	This field contains the student's middle name. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN or From the Start Page > Select a Student > Demographics.	[S_MN_STU_X]State_Middle_Name or [Students]Middle_name	Alpha	40
5	Suffix	This field contains the student's name suffix. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN.	[S_MN_STU_X]State_Suffix	Alpha	5
6	Gender	This field contains the student's legal gender.	[StudentCoreFields]PSCore_Legal_Gender	Alpha	1
7	BirthDate	This field contains the student's date of birth. This field value is extracted from the Students table. From the Start Page > Select a Student > Demographics.	[Students]DOB	Date Format YYYY-MM-DD	10
8	HispanicLatino	This field indicates if the student is Hispanic or Latino. This field value is extracted from the Students table. From the Start Page > Select a Student > Demographics. Reported Values: 0 – False 1 – True	[Students]FedEthnicity	Numeric	1
9	AmericanIndianorAlaskaNative	This field indicates if the student is American Indian or an Alaska Native. This field value is extracted from the StudentRace table. From the Start Page > Select a Student > Demographics. Reported Values: If RaceCd = Begins with "I" then 1 – True else 0 – False	[StudentRace]RaceCd	Numeric	1
10	Asian	This field indicates if the student is Asian. This field value is extracted from the StudentRace table. From the Start Page > Select a Student > Demographics. Reported Values: If RaceCd = Begins with "A" then 1 – True else 0 – False	[StudentRace]RaceCd	Numeric	1
11	BlackorAfricanAmerican	This field indicates if the student is Black or African American. This field value is extracted from the StudentRace table. From the Start Page > Select a Student > Demographics. Reported Values: If RaceCd = Begins with "B" then 1 – True else 0 – False	[StudentRace]RaceCd	Numeric	1
12	NativeHawaiianorOtherPacificIslander	This field indicates if the student is Native Hawaiian or Other Pacific Islander. This field value is extracted from the StudentRace table. From the Start Page > Select a Student > Demographics. Reported Values: If RaceCd = Begins with "P" then 1 – True else 0 – False	[StudentRace]RaceCd	Numeric	1
13	White	This field indicates if the student is White. This field value is extracted from the StudentRace table. From the Start Page > Select a Student > Demographics. Reported Values: If RaceCd = Begins with "W" then 1 – True else 0 – False	[StudentRace]RaceCd	Numeric	1
14	Migrant	This field indicates if the student is a migrant. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments > Early Education Enrollments or Start Page > Select a Student > State/Province – MN > MARSS Information > Select an enrollment record > Additional Information. Reported Values: If MIG_IND = Y then 1 – True else 0 – False	[Students]MIG_IND	Numeric	1
15	PrimaryLanguage	The language first spoken by students when they began speaking, the language spoken most of the time, or the language usually spoken in the home. From the Start Page > Select a Student > State/Province – MN > MARSS Information.	[Students]PrimaryLanguage	Numeric	3
16	McKinneyVentoHomeless	This field indicates if the student is homeless. This field value is extracted from the Students table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments. Reported Values: If Homeless = Y then 1 – True else 0 – False	[S_MN_STU_X]Homeless	Numeric	1
17	ImmunizationsUptoDate	This field indicates if the student's immunizations are up to date. This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments. Reported Values: 0 – False 1 – True	[S_MN_STU_EARLYED_C]Immunizations_Up_To_Date	Numeric	1
18	CountyOfResidence	This field indicates the student's county of residence. This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments.	[S_MN_STU_EARLYED_C]County_Of_Residence	Numeric	2
RegistrationRecord The following 11 items are present in the RegistrationRecord Section. This field indicates if the student's County of Residence. This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments.
1	ProgramName	This field indicates the program the student is participating in. This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments. Reported Values: 01 – School Readiness (SR) 02 – Early Childhood Family Education (ECFE 03 – Early Childhood Family Education/Adult Basic Education joint Registration (ECFE/ABE) 04 – School Readiness/Adult Basic Education joint Registration (SR/ABE 99 – Other Preschool 203 – Other ECFE 204 - Other School Readiness 200 - Private Preschool 201 - Child Care Center 202 - Family Child Care	[S_MN_STU_EARLYED_C]ProgramName	Numeric	3
2	ProgramReferralTo Repeated for each funding source.	This field indicates the services/programs the student was referred to. This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments. Reported Values: 01 – School Readiness (SR) 02 – Early Childhood Family Education (ECFE 03 – Early Childhood Family Education/Adult Basic Education joint Registration (ECFE/ABE) 04 – School Readiness/Adult Basic Education joint Registration (SR/ABE 99 – Other Preschool 203 – Other ECFE 204 - Other School Readiness 200 - Private Preschool 201 - Child Care Center 202 - Family Child Care	[S_MN_STU_EARLYED_C]Referred_To	Numeric	3
3	ProgramReferralsFrom Repeated for each funding source.	This field indicates the services/programs the student was referred to. This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments. Reported Values: 01 – School Readiness (SR) 02 – Early Childhood Family Education (ECFE 03 – Early Childhood Family Education/Adult Basic Education joint Registration (ECFE/ABE) 04 – School Readiness/Adult Basic Education joint Registration (SR/ABE 99 – Other Preschool 203 – Other ECFE 204 - Other School Readiness 200 - Private Preschool 201 - Child Care Center 202 - Family Child Care	[S_MN_STU_EARLYED_C]Referred_From	Numeric	3
4	ProgramRegistrationDate	This field indicates the date of the student's registration. This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments.	[S_MN_STU_EARLYED_C]Registration_Date	Date Format YYYY-MM-DD	10
5	CountOfClasses	This field indicates the count of the same programs registered on that registration date. This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments.	[S_MN_STU_EARLYED_C]Count_of_Classes	Numeric	1
6	HoursAttended	If the district has elected to submit hours attended instead of days attended. This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments.	[S_MN_STU_EARLYED_C]Hours_Attended	Numeric	3
7	DaysAttended	If the district has elected to submit days attended instead of hours attended. This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments.	[S_MN_STU_EARLYED_C]Days_Attended	Numeric	3
8	FeeStatus	This field indicates the student's fee status. This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments. Reported Values: 01 – Full Fee 02 – Reduced Fee 03 - No Fee	[S_MN_STU_EARLYED_C]Fee_Status	Numeric	2
9	FundingSources Repeated for each funding source.	This field indicates the student's funding source(s). This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments. Reported Values: P1 - Pathway 1 P2 - Pathway 2 01 - Parent Fee 02 – SR 03 - ECFE - Early Childhood Family Education 04 – ECSE - Early Childhood Special Education 05 – Head Start 06 – Early Head Start 07 – Title 1 08 - – Non DHS Funded Childcare 09 - Other District 10 - Other Count 12 - Community Scholarship 13 - Private Foundation Grant	[S_MN_STU_EARLYED_C]Funding_Source	Alpha	2
10	ChildSpecialNeedsFlag	This field indicates the teacher identified flag for children who have either a) been evaluated for Early Intervention or Early Childhood Special Education and did not qualify, or b) have equivalent levels of need and have not yet been evaluated. This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments. Reported Values: 0 – False 1 – True	[S_MN_STU_EARLYED_C]Special_Needs_Delay	Numeric	1
11	IEPStatus	This field indicates student's IEP status. This field value is extracted from the Early Education Enrollment Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments. Reported Values: 1 – IEP/IFSP is Current 2 – No IEP/IFSP 3 - Developmental Concerns	[S_MN_STU_EARLYED_C]IEP_Status	Numeric	1
RegisteringPersons The following 10 items are present in the RegistrationRecord Section for each registering person.
1	LastName	This field contains the registering person's last name. This field value is extracted from the Early Education Registering Person Information table From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments > Registering Person Information.	[S_MN_STU_EARLYED_RegPerson_C]Last_Name	Alpha	100
2	FirstName	This field contains the registering person's first name. This field value is extracted from the Early Education Registering Person Information table From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments > Registering Person Information.	[S_MN_STU_EARLYED__RegPerson_C]First_Name	Alpha	100
3	DateOfBirth	This field contains the registering person's date of birth. This field value is extracted from the Early Education Registering Person Information table From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments > Registering Person Information.	[S_MN_STU_EARLYED_RegPerson_C]DOB	Date Format YYYY-MM-DD	10
4	RegisteringPersonType	This field contains the registering person's type. This field value is extracted from the Early Education Registering Person Information table From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments > Registering Person Information. Reported Values: 1727 – Father 1735 – Mother 1726 – Foster Father 1734 – Foster Mother 1798 – Guardian - Male 1799 – Guardian - Female 9991– Other Relative - Male 9992 - Other Relative - Female	[S_MN_STU_EARLYED_RegPerson_C]Person_Type	Numeric	4
5	EducationBackground	This field contains the registering person's education background. This field value is extracted from the Early Education Registering Person Information table From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments > Registering Person Information. Reported Values: 0798 – 8th Grade 1809 – 12th Grade 1044 – HS Diploma 2409 – GED 1049 – Some College - No Degree 1050 – Associate Degree 1051 – Bachelor Degree 1054 - Master's Degree 1057 - PHD	[S_MN_STU_EARLYED_RegPerson_C] Education_Background	Numeric	4
6	EmploymentStatus	This field contains the registering person's employment status. This field value is extracted from the Early Education Registering Person Information table From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments > Registering Person Information. Reported Values: 01 – Works > 25 hrs 02 – Works < 25 hrs 03 – Unemployed Seeking 04 – Unemployed Not Seeking	[S_MN_STU_EARLYED_RegPerson_C] Employment_Status	Numeric	2
7	HouseholdIncome	This field contains the registering person's household income. This field value is extracted from the Early Education Registering Person Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments > Registering Person Information.	[S_MN_STU_EARLYED_RegPerson_C]Household_Income	Numeric	7
8	NoOfPeopleInHousehold	This field contains the number of people in the household of the registering person of the student for which this information is being reported. This field value is extracted from the Early Education Registering Person Information table. From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments > Registering Person Information.	[S_MN_STU_EARLYED_RegPerson_C] People_In_Household	Numeric	2
9	ReceivingInterpreterAsst	This field contains the interpreter assistance services flag of the registering person. This field value is extracted from the Early Education Registering Person Information table From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments > Registering Person Information. Reported Values: 0 – False 1 – True	[S_MN_STU_EARLYED_RegPerson_C] Interpreter_Assistance	Numeric	1
10	ClassRoomVolunteerType	This field contains the classroom volunteer type. This field value is extracted from the Early Education Registering Person Information table From the Start Page > Select a Student > State/Province – MN > Other Functions/Enrollments > Registering Person Information. Reported Values: 01 – Not volunteering 02 – Classroom volunteer 03 – Parent Advisory Council Volunteer 99 – Other as district identified	[S_MN_STU_EARLYED_RegPerson_C] Classroom_Participation	Numeric	2

Back to Top