Skip to main content
Skip table of contents

General Collection – EOY

General Collection - EOY Prerequisites

  1. If you use specific Entry codes to designate entry into your district, list the appropriate codes in the MI SDS Download Options district-level page.
  2. Calculate Attendance Day Totals for each building using the View that you use for State Reporting. (Attendance > All > Utilities > Day Totals Calculation)
  3. Make sure that all students who have left your district since the Spring General Collection have correct Entry/Withdrawal records.
  4. To report the Early On, Initial IFSP, Part C Assessment, and Part B Referral components, your district needs an EEM Entity Type value of ISD on the MI EEM Entity Type district district-defined page. This is the default value. (Administration > General Setup > District District Defined > MI EEM Entity Type)
  5. Data for the Early On, Initial IFSP, and Part B Referral components is entered on the MI Early On/IFSP/Part B Referral Page.
    • The Early On component is required for a student if he or she has the Initial IFSP or Part B Referral component reported.
    • Early On is also required for a child under the age of 2 years, 6 months if that student is reported in the EOY General Collection's Special Education component.
    • The student gets a Part B Referral record only if at least one of the following fields has an entry:  SEA Notification and LEA Notification.  If you are reporting Part B Referral, you would typically select a value for both fields.
    • For a particular Referral Date, an Initial IFSP record is reported once.  After you report a Referral Date once, the SDS Download will not report that same date again.  You will get a warning in the error log noting when an Initial IFSP component record is not created because a date had already been reported.
  6. Part C Assessment information is entered on the MI Part C Assessment Page. The three most recent records are reported for a single student in a particular collection, based on Assessment Date.
  7. If you need to exclude any student from the submission, use the MI Exclude from Submission Page.

Creating the General Collection - EOY Files

Select Regulatory > MI SDS Reporting > MI SDS Reporting > SDS Downloads and run the SDS Download using the following recommended prompts to find out if there are any data errors that you need to correct. 

Prompt

Value for EOY- General Collection File

School Year

Ending year of current school year

Submitting Entity

District

Building List

Select All by clicking Asterisk to select all codes

Submission Type

General Collection – End of Year

Date of Count

Refer to the CEPI Calendar.

Start Date

Refer to the CEPI Calendar.

End Date

Select a date that is on or after the last of the school year and also is before the Date of Count

View Type

Select your State Reporting View

Absence Codes

Select the Attendance Code(s) you want to use for absences in the Attendance Component.

Run with Student UIC

Select All Students

Scan for Data Errors

Checked

Scan for Setup Errors

Checked

Run Download

Checked to populate the download table.  When you check this, the Clear Existing box is checked automatically for you and you cannot uncheck it.

Clear Existing

Checked if you want to clear the download table.

Clear Overrides

Checked if you want to overwrite manual changes made to the download table data entered on the download summary page. Unchecked to retain overrides set within the download records.

Log File Type

Select CSV to get an Excel file of errors or PDF to get the errors in a pdf file.

  1. Review the error log (MI SDS Download Log) and fix data as necessary. 
  2. Re-run the download using the same prompts as in Step 1 as many times as you need to make sure that all errors are resolved.
  3. Use the SDS Student Summary or MI State Download Search pages to view the data that will be sent to the State to spot-check some students and review students that may have exceptions in their data.
  4. Run the download using the prompts above, making sure that you have the Run Download checkbox selected.
  5. Select Regulatory > MI SDS Reporting > MI SDS Reporting > SDS Submission Files to create submission files using the following prompts in the table below.
  6. The system performs an attendance calculation for two-way interactions, which are any attendance codes of Present:
    • 5 = Two or more two-way interactions.
    • 3 = One two-way interaction.
    • 0 = Zero two-way interactions.
  7. You will get a file called "MI SDS GeneralCollectionEOY….xml".  Click on the file and save it to your PC. The file name will include the School Year and the Date/Time you ran the file before the xml extension.
  8. Upload the file to the MSDS website and follow their instructions.

Prompt

Value for  EOY - General Collection File

School Year

Ending year of current school year

Submitting Entity

District

Building List

Select All by clicking Asterisk to select all codes

Submission Type

General Collection – End of Year

Date of Count

Refer to the CEPI Calendar.

Run with Student UIC

Select All Students

Log File Type

Select CSV to get an Excel file of errors or PDF to get the errors in a pdf file..

XML Components Included in the General Collection - EOY

Refer to the Michigan Component File Layout document for information about the fields included in a component. For help accessing this file, refer to eSchoolPlus Michigan State Reporting Documentation.

XML Components Included

Required

Adult Education Component

Retired

Attendance Component

Conditional

Discipline Component

Conditional

Early Childhood Special Education Assessment Component

Optional

Early On Component

Conditional

Enrollment Component

Required

General Education FTE Component

Optional

Homeless Demographics Component

Conditional

Initial IEP Component

Optional

Initial IFSP Component

Optional

Title III LEP and Immigrant Component

Optional

Membership Component

Required

Part B Referral Component

Optional

Part C Assessment Component

Optional

Personal Core Component

Required

Personal Curriculum Component

Optional

Personal Demographics Component

Required

Program Participation Component

Conditional

School Demographics Component

Required

SNE Component

Optional

Special Education Component

Conditional

Submitting Entity Component

Required

Title I TAS Component

Conditional

JavaScript errors detected

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

If this problem persists, please contact our support.