Third Grade Retention Extract (Michigan)

 PATH:   MI State Reporting > MSDS Extracts > Extract Type: Third Grade Retention

The Third Grade Retention extract captures retention decisions for student targeted for retention according to the Read by Grade Three law (MCL 380.1280f).

 

This extract was removed with the release of Campus.2140 and reinstated with the release of Campus.2215.

Report Logic

A record reports for student who have a 3rd Grade Reading Retention program record with a Decision Date within the extract date range. Data reports from the student's most recent Enrollment with a Service Type of P. 

Enrollments marked as State Exclude or No Show, or those in a Calendar or Grade Leve marked as Exclude are not reported.

Generating the Extract

  1. Select the  Extract Type of Third Grade Retention.
  2. Enter the  Count Date in mmddyyyy format or by clicking the calendar icon and selecting a date. A snapshot of data is taken as it exists on this date. Defaults to today's date.
  3. Enter the Previous Count Date in mmddyyyy format or by clicking the calendar icon and selecting a date. This date correlates with the Count Date entered. Student data will report within the date range entered in these two fields.
  4. Check the Student w/o UICs checkbox, if desired. Checking this checkbox means only those students within the selected calendar(s) that do not have a State ID assigned will be reported. Not checking this checkbox means all students within the selected calendar(s) are eligible for reporting.
  5. Select the Submitting Entity, which is the entity submitting the extract to the state.
  6. Select the Format. For submission to the state, use the State Format (XML).
  7. Select an Ad hoc Filter to limit records reported. When an Ad hoc Filter is selected, records report based on the options selected in the editor, not the Campus toolbar.
  8. Check the  Validate  checkbox, if desired. Checking this checkbox means Infinite Campus will run a check on the XML data to validate that it is correct. If errors are found, the extract will list these errors for correction based on the schema. 

    For guidance in validating the XML file against your state's schema using a free, third-party program, see the Validating an XML File Against a Schema File articl

  9. Mark Include Protected Identity Info to report student Demographic data from the Protected Identity Information area of Identities.
  10. Select which Calendar(s) to include within the report.
  11. Click Generate Extract to generate the report in the indicated format or Submit to Batch to schedule when the report will generate.

Users have the option of submitting a report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.

Extract Layout

Element

Description

Campus Location

Submitting Entity

Submitting Entity Type Code 

A code used by the system to identify which type of entity code will be reported in the Submitting Entity Code characteristic. Entity codes in EEM are unique within type categories. This characteristic identifies which category the system uses for validation of the submitting entity and to confirm user entity permissions.

Options are A: Agreement Number, B: Building, or D: District.


Alphanumeric, 1 character

MI State Reporting > MSDS Extracts > Submitting Entity

Submitting Entity Code 

The entity responsible for the certification of the collection (if applicable). Generally this is the entity receiving funding from the state. It may or may not be the entity that is directly providing education services to the student.
   
If Submitting Entity = D, the State District Number is reported. If Submitting Entity = B, the School Override is reported. If School Override is null, the State School Number is reported.


Alphanumeric, 10 characters

Student Information > General > Enrollments > State Reporting Fields > School Override


Enrollment.schoolOverride 

System Administration > Resources > School > State School Number

School.schoolID
Personal Core

UIC

The Unique Identification Code (UIC) produced by the Center for Educational Performance and Information.


Numeric, 10 digits

Census > People > Demographics > Person Identifiers > State ID


Person.stateID

Last Name

The student's legal last name.


Alphanumeric, 25 characters

Census > People > Demographics > Last Name


Identity.lastName

First Name

The student's first name.


Alphanumeric, 15 characters

Census > People > Demographics > First Name


Identity.firstName

Middle Name

The student's middle name.
     
Students are not required to report a middle name. Users may submit a middle initial or the full middle name.


Alphanumeric, 25 characters

Census > People > Demographics > Middle Name


Identity.middleName

Suffix

The abbreviated name suffix that follows the student's full name and provides additional information about the student.


Alphanumeric, 9 characters

Census > People > Demographics > Suffix


Identity.suffix

Date Of Birth

The student's date of birth.


Date field, YYYY-MM-DD



Census > People > Demographics > Date of Birth


Identity.birthDate

Multiple Birth Order

Indicates the student was part of a multiple birth.
       
This field is intended to prove some distinguishing data for cases where the cultural practice is to provide twins (triplets, etc) of the same gender with the same first name or where children of the same gender have similar first names.

If null, reports as 1.


Numeric, 1 digit

Census > People > Demographics

Gender

The student's gender.


Alphanumeric, 1 character

Census > Peoples > Demographics > Person Information > Gender


Identity.gender

School Demographics
Operating District NumberThe Stat-assigned identification number of the submitting district.
Numeric, 5 digits
System Administration > Resources > District Information > State District Number

District.number

School Facility Number 

State-assigned numbers in the official Educational Entity Master (EEM).


Numeric, 5 digits

Student Information > General > Enrollments > State Reporting Fields > School Override; System Administration > Calendar > Calendar > Grade Levels > State Grade Level Code


School.number

Student ID Number 

The student's local student number.


Alphanumeric, 20 characters

Census > People > Demographics > Person Identifier > Student Number


Person.studentNumber

Grade Or Setting 

The student's grade level or the education setting in which the student is enrolled.


Alphanumeric, 2 characters

Student Information > General > Enrollments > Grade; System Administration > Calendar > Calendar > Grade Levels > State Grade Level Code


Enrollment.grade

S2E2 Code

The code from the Educational Entity Master (EEM) for the student being educated through a Specialized Shared Educational Entity (S2E2).


Alphanumeric, 5 characters

Student Information > General > Enrollments > State Reporting Fields > S2E2 Code


EnrollmentMI.s2e2Code

Bldg Otherwise AttendThis field reports the Building Otherwise Attend value selected on the student's enrollment, indicating the school that the student would have otherwise attended other than the enrolled school.

Numeric, 5 digits
Student Information > General > Enrollments > State Reporting Fields > Building Otherwise Attend

Enrollment.facilityCode
Third Grade Retention Decision
End of Term StatusThe nature of the student's progress at the end of the given school term. Reports the End of Term Status.

Alphanumeric
Student Information > Program Participation > State Programs > Third Grade Retention > End of Term Status

ThirdGradeRetention.endStatus
Promotion ReasonThe nature of the student's promotion or progress at the end of the given school year. If the End of Term Status is Promotion, reports the Promotion Reason.

Alphanumeric
Student Information > Program Participation > State Programs > Third Grade Retention > Promotion Reason

ThirdGradeRetention.promotionReason

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save

Save