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.
| Field | Description |
|---|---|
| Current Selection Students* | Indicate which students to include in the report by selecting one of the following options:
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 Element | Description | [Table]FieldName |
|---|---|---|---|
| 1 | District ID | This contains the District ID. | [Prefs]DistrictNumber |
| 2 | Local District Student | This contains the PowerSchool student ID number. | [Students]Student_Number |
| 3 | State Student ID | This contains the student's Unique Identification Code (UIC). Note: This field may contain leading zeroes. | [Students]State_StudentNumber |
| 4 | School 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 |
| 5 | Student First Name | This contains the student's first name. | [StudentCoreFields]PSCORE_LEGAL_FIRST_NAME OR [Students]First_Name |
| 6 | Student Middle Name | This contains the student's middle name. | [StudentCoreFields]PSCORE_LEGAL_MIDDLE_NAME OR [Students]Middle_Name |
| 7 | Student Last Name | This contains the student's last name. | [StudentCoreFields]PSCORE_LEGAL_LAST_NAME OR [Students]Last_Name |
| 8 | Student Date of Birth | This contains the students date of birth. | [Students]DOB |
| 9 | Race | This 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 |
| 10 | Gender | This contains the student's race. | [Students]Gender OR [STUDENTCOREFIELDS]PSCore_Legal_Gender |
| 11 | Prior Care – Great Start | This indicates Prior Care type of Great Start Readiness Program (GSRP) | [S_MI_STU_KRA_X]pc_GSRP |
| 12 | Prior Care – Head Start | This indicates Prior Care type of Head Start. | [S_MI_STU_KRA_X]pc_head_start |
| 13 | Prior Care – Early | This indicates Prior Care type of Early Childhood Special Education Classroom (ECSE). | [S_MI_STU_KRA_X]pc_ECSE |
| 14 | Prior Care – Young | This indicates Prior Care type of Young Fives / Developmental Kindergarten. | [S_MI_STU_KRA_X]pc_young_fives |
| 15 | Prior Care – Child Care / | This indicates Prior Care type of Child Care / home based. | [S_MI_STU_KRA_X]pc_cc_home |
| 16 | Prior Care – Child Care / Center | This indicates Prior Care type of Child Care / Center. | [S_MI_STU_KRA_X]pc_cc_center |
| 17 | Prior Care – Registered Family / Relative Care | This indicates Prior Care type of Registered Family / Relative Care. | [S_MI_STU_KRA_X]pc_rfrc |
| 18 | Prior Care – TuitionBased Preschool | This indicates Prior Care type of TuitionBased Preschool. | [S_MI_STU_KRA_X]pc_tuition_preschool |
| 19 | No Prior Care / Program | This indicates no prior care program. | [S_MI_STU_KRA_X]no_pc |
| 20 | Prior Care – Child has been retained for a second year of kindergarten | This indicates the child has been retained for a second year of kindergarten. | [S_MI_STU_KRA_X]pc_kindergarten |
| 21 | Previous School Year Mode of Learning | This indicates the previous school year mode of learning. Valid options: I = In person | [S_MI_STU_KRA_X]previous_mode_learning |
| 22 | IEP | This 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' |
| 23 | Disability Code | This 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 |
| 24 | Economically Disadvantaged | This indicates the student's economically disadvantaged status. | [Students]LunchStatus ='P' or blank THEN N Else 'Y' |
| 25 | English Learner | This indicates the student's EL status. | [S_MI_STU_GC_X]flagLEP ' 1' THEN 'Y' ELSE 'N' |
| 26 | Kindergarten Classroom Type | This indicates the kindergarten classroom type. | [S_MI_CRS_X]KRA_KGclassType [S_MI_SEC_X]KRA_KGclassType |