Skip to main content
Skip table of contents

MI KRA Student Export

Introduction

This will create the MI KRA Student Export file.


When opening this CVS file in Excel or Google Sheets, the leading zeroes in the State Student ID and School ID Number will be removed. This will cause issues in the import into the KReady Online system.

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 start date of the class must be before the Report End Date entered.
  • The end date of the class must be after the Report Start Date entered.
  • If using a current student selection, the student must be in the current student selection.
  • The student must have 'Include in KRA Reporting?' selected on the State/Province - MI > KRA tab.
  • The student must be currently enrolled in a course or section that has a Kindergarten Classroom Type set to '01', '02' or '03'.
  • The student cannot be set to be excluded from State Reporting.

Report Input

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

FieldDescription
Current Selection Students*

Indicate which students to include in the report by selecting one of the following options:

  • The Selected [number] Students Only
  • All Students

Note: If running the report for a single student, or group of students, select the students prior to running report.

Start Date

Enter the start date for the date range.

End Date

Enter the end date for the date range.

Select schools to export.

Select which schools to export if applicable.

Report Output

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 ElementDescription

[Table]FieldName

1District IDThis contains the District ID.[Prefs]DistrictNumber
2

Local District Student
Number

This contains the PowerSchool student ID number.[Students]Student_Number
3State Student ID

This contains the student's Unique Identification Code (UIC).

Note: This field may contain leading zeroes.

[Students]State_StudentNumber
4School ID Number

This contains the state school ID Number.

Note: This field may contain leading zeroes.

[S_MI_STU_GC_X]adminunit OR

[S_MI_SCH_TSDL_X]adminunit

5Student First NameThis contains the student's first name.[StudentCoreFields]PSCORE_LEGAL_FIRST_NAME OR [Students]First_Name
6Student Middle NameThis contains the student's middle name.[StudentCoreFields]PSCORE_LEGAL_MIDDLE_NAME OR [Students]Middle_Name
7Student Last NameThis contains the student's last name.[StudentCoreFields]PSCORE_LEGAL_LAST_NAME OR [Students]Last_Name
8Student Date of BirthThis contains the students date of birth.[Students]DOB
9RaceThis contains the student's race.

[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

10GenderThis contains the student's race.

[Students]Gender OR

[STUDENTCOREFIELDS]PSCore_Legal_Gender

11

Prior Care – Great Start
Readiness Program
(GSRP)

This indicates Prior Care type of Great Start
Readiness Program
(GSRP)
[S_MI_STU_KRA_X]pc_GSRP
12Prior Care – Head StartThis indicates Prior Care type of Head Start.[S_MI_STU_KRA_X]pc_head_start
13

Prior Care – Early
Childhood Special
Education Classroom
(ECSE)

This indicates Prior Care type of Early
Childhood Special
Education Classroom
(ECSE).
[S_MI_STU_KRA_X]pc_ECSE
14

Prior Care – Young
Fives / Developmental
Kindergarten

This indicates Prior Care type of Young
Fives / Developmental
Kindergarten.
[S_MI_STU_KRA_X]pc_young_fives
15

Prior Care – Child Care /
home based

This indicates Prior Care type of Child Care /
home based.
[S_MI_STU_KRA_X]pc_cc_home
16Prior Care – Child Care / CenterThis indicates Prior Care type of Child Care / Center.[S_MI_STU_KRA_X]pc_cc_center
17Prior Care – Registered Family / Relative CareThis indicates Prior Care type of Registered Family / Relative Care.[S_MI_STU_KRA_X]pc_rfrc
18Prior Care – TuitionBased PreschoolThis indicates Prior Care type of TuitionBased Preschool.[S_MI_STU_KRA_X]pc_tuition_preschool
19No Prior Care / ProgramThis indicates no prior care program.[S_MI_STU_KRA_X]no_pc
20Prior Care – Child has been retained for a second year of kindergartenThis indicates the child has been retained for a second year of kindergarten.[S_MI_STU_KRA_X]pc_kindergarten
21Previous School Year Mode of Learning

This indicates the previous school year mode of learning.

Valid options:

I = In person
V = Virtual /Online
H = Hybrid
NA = Did not attend due to pandemic

[S_MI_STU_KRA_X]previous_mode_learning
22IEPThis indicates that the student has an IEP.[S_MI_STU_GC_X]flagSpecEd = '1' AND [S_MI_STU_GC_X]SEPriDisability IS NOT NULL THEN 'Y' else 'N'
23Disability CodeThis indicates the student's primary disability code.[S_MI_STU_GC_X]flagSpecEd = '1' AND [S_MI_STU_GC_X]SEPriDisability IS NOT NULL THEN [S_MI_STU_GC_X]SEPriDisability
24Economically DisadvantagedThis indicates the student's economically disadvantaged status.[Students]LunchStatus ='P' or blank THEN N Else 'Y'
25English LearnerThis indicates the student's EL status.[S_MI_STU_GC_X]flagLEP ' 1' THEN 'Y' ELSE 'N'
26Kindergarten Classroom TypeThis indicates the kindergarten classroom type.

[S_MI_CRS_X]KRA_KGclassType

[S_MI_SEC_X]KRA_KGclassType

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.