MI General/SRM/Early Childhood

Introduction

This will create the MI General / SRM / Early Childhood export file. Use this to generate the submission files for the Michigan General Collection, the Michigan Student Record Maintenance Collection, or the Michigan Early Childhood Collection.

For Discipline records, this report pulls a summary for a specific date range for students who have a discipline record for the number of days specified below. Discipline records are grouped by student, not by the school they are enrolled in at the time of the incident.

Michigan General Collection

This is used to collect pupil membership and participation data for the school district or ISD to report to CEPI.

Refer to the following link for additional information on the Michigan General Collection: http://www.mi.gov/cepi/0,4546,7-113-986_50502_53580---,00.html

Michigan Student Record Maintenance Collection

The SRM Collection is an optional collection that may be used to update student data throughout the school year, including:

Graduation Rate Appeals
Submitting Enrollment and Exit Records
Updating Demographics/Program Data for Assessment and Accountability
Submitting Section 23a Dropout Recovery Program Claims
Submitting Section 25e FTE Transfer Requests

Refer to the following link for additional information on the Michigan Student Record Maintenance Collection:
http://www.mi.gov/cepi/0,1607,7-113-986_50502_53650---,00.html

Michigan Early Childhood Collection

Early Childhood Collections are used to report specific programs in which early childhood students are participating. Data submitting in the Fall Early Childhood Collection are used with other MSDS data to report fall preschool student headcounts. The Michigan Department of Education (MDE) plans to use the Great Start Readiness (GSRP) data reported in the spring collection. Data collected in early childhood collections are also reported to the U.S. Department of Education.

Refer to the following link for additional information on the Michigan Early Childhood Collection:
http://www.mi.gov/cepi/0,1607,7-113-986_50502_52382—,00.html

Back to Top

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.

Michigan General Collection Student Selection

Student records are selected based on the following criteria:

The student is included in state reporting. ([Students]State_ExcludeFromReporting=0)
The student is not enrolled at a school that is excluded from state reporting.
The student had a school enrollment record between the Previous Count Date and Current Count Date entered in the report parameters.
When the student's Entry Date and Exit Date are the same the following rules apply:
- When the previous school enrollment Exit Code = “19” the student record is in the file.
- When the previous school enrollment Exit Code is anything other than “19” the student record is not in the file. This includes a blank exit code.
- When there is no previous enrollment the student record is not in the file.
The student’s exit date is greater than the Previous Count Date entered in the report parameters.
The student is in Grade Level or Student Grade or Setting of 0-12 or 14 or any of the following are true:
- The student is in Grade Level 13.
  - Although this is not an accepted grade level in MSDS, the grade is included for those districts that mark their EMC students as Grade 13 and manipulate the file to change the grade level before uploading to MSDS. If this grade level is used for students who should not be in the General or SRM collections, the Exclude Student from MSDS Reporting should be selected for those students.
- The student is in *any grade level and the Include Early On Data in MSDS Reporting flag is selected.
- The student is in *any grade level and the Include Special Education Data in MSDS Reporting flag is selected.
- The student is in *any grade level and the Initial IEP > Determination Date is within the report parameters and:
  - The Timeliness of Initial IEP = 22 or
  - The Date of Parental Consent is not blank.

*If the student is an early childhood student the Grade Level or Student Grade or Setting should be 30, if not the student will be included in the report with a blank grade that will cause an error in the MSDS upload.

If the student does not have the criteria listed above, they will not report in the file. For example, a Grade Level 30 student who is not in Early On, Special Education or has an Initial IEP Component will not generate in the file and does not need to have the Exclude From State Reporting flag selected. The same student would report in the Early Childhood Collection if they have a valid Early Childhood Program, Start Date, and Delivery Method.

Information about Discipline:

Discipline will be reported from one of the report parameter options of only Log Entries, only Incident Management or both Log Entries and Incident Management.
Discipline will be reported from one of the report parameters options of all student disciplines that are state reportable or only special education and expelled student disciplines that are state reportable.

Michigan Student Record Maintenance Collection Student Selection

Student records are selected based on the following criteria:

The student is included in state reporting. ([Students]State_ExcludeFromReporting=0)
The student had a school enrollment record between the Previous Count Date and Current Count Date entered in the report parameters.
The student’s exit date is greater than the Previous Count Date entered in the report parameters.
The student’s Entry Date and Exit Date are not the same date.
The student is in Grade Level or Student Grade or Setting of 0-12 or 14 or any of the following are true:
- The student is in Grade Level 13.
  - Although this is not an accepted grade level in MSDS, the grade is included for those districts that mark their EMC students as Grade 13 and manipulate the file to change the grade level before uploading to MSDS. If this grade level is used for students who should not be in the General or SRM collections, the Exclude Student from MSDS Reporting should be selected for those students.
- The student is in *any grade level and the Include Early On Data in MSDS Reporting flag is selected.
- The student is in *any grade level and the Include Special Education Data in MSDS Reporting flag is selected.
- The student is in *any grade level and the Initial IEP > Determination Date is within the report parameters and:
  - The Timeliness of Initial IEP = 22 or
  - The Date of Parental Consent is not blank.

*If the student is an early childhood student the Grade Level or Student Grade or Setting should be 30, if not the student will be included in the report with a blank grade that will cause an error in the MSDS upload.

If the student does not have the criteria listed above, they will not report in the file. For example, a Grade Level 30 student who is not in Early On, Special Education or has an Initial IEP Component will not generate in the file and does not need to have the Exclude From State Reporting flag selected. The same student would report in the Early Childhood Collection if they have a valid Early Childhood Program, Start Date, and Delivery Method.

Information about Discipline:

Discipline will be reported from one of the report parameter options of only Log Entries, only Incident Management or both Log Entries and Incident Management.
Discipline will be reported from one of the report parameters options of all student disciplines that are state reportable or only special education and expelled student disciplines that are state reportable.

Michigan Early Childhood Collection Student Selection

Student records are selected based on the following criteria:

The student is included in state reporting. ([Students]State_ExcludeFromReporting=0)
The student’s Early Childhood record has a valid Early Childhood program, start date, and delivery method.
The student had a school enrollment record between the Previous Count Date and Current Count Date entered in the report parameters.
The student must have a Grade Level or Student Grade or Setting of '30 - Early Childhood/Early On' (Select Student > State/Province - MI > School Demographics tab).

Back to Top

Report Input

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

Field	Description
Current Selection Students	Select whether to run the export file for the selected number of students or all students.
Collection Type	Select the collection that should be used to create the export file.
Entity Type Code	Select the entity type code.
Entity Code	Enter the entity code.
Reporting District’s State Assigned 5-digit District Number	Enter the reporting district’s state-assigned 5-digit district number.
First Day of School	Enter the date of the first day of school.
Previous Count Date	Enter the previous count date.
Current Count Date	Enter the current count date.
Select schools to export	Select which schools to export if applicable.
Include attendance for all students	Select Yes to report all attendance or No to report only exited student attendance. If the Collection Type is the General Collection EOY then all student attendance is reported whether Yes or No is selected.
Include Discipline from	Select from the following: Log Entries - to report state reportable discipline from Log Entries records Incident Management - to report state reportable discipline from Incident Management records Both - to report state reportable discipline from both Log Entries and Incident Management records
Limit Discipline for Special Education, Foster, and Expelled Students	Select Yes to limit the discipline to special education, foster and all expelled students. Select No to report discipline on all students.

Back to Top

Report Output

Michigan General Collection

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
<SubmittingEntity>
1	<SubmittingEntityTypeCode>	This contains the submitting entity type code value selected on the report interface.	N/A
2	<SubmittingEntityCode>	This contains the submitting entity code value entered on the report interface.	N/A
<PersonalCore>
3	<UIC>	This contains the student’s Unique Identification Code (UIC).	[Students]State_StudentNumber
4	<LastName>	This contains the student’s last name.	[Students]Last_Name
5	<FirstName>	This contains the student’s first name.	[Students]First_Name
6	<MiddleName>	This contains the student’s middle name.	[Students]Middle_Name
7	<StudentSuffix>	This contains the student’s suffix.	[S_MI_STU_GC_X]stuNameSuffix
8	<DateOfBirth>	This contains the student’s date of birth.	[Students]DOB
9	<MultipleBirthOrder>	This identifies the birth order of the student if the student is part of a multiple birth.	[S_MI_STU_GC_X]multipleBirth
10	<Gender>	This contains the student’s gender code. Note: If the student's preferred gender is not M or F, the legal gender is reported.	[Students]Gender [STUDENTCOREFIELDS]PSCore_Legal_Gender
<SchoolDemographics>
11	<OperatingDistrictNumber>	This contains the operating district number value entered on the report interface.	N/A
12	<SchoolFacilityNumber>	This contains the school or facility number for the student’s school.	[S_MI_SCH_TSDL_X]adminUnit [S_MI_STU_GC_X]adminUnit [S_MI_REN_GC_X]adminUnit
13	<StudentIdNumber>	This contains the PowerSchool student ID number.	[Students]Student_Number
14	<GradeOrSetting>	This contains the grade level in which the student is enrolled.	[Students]Grade_Level [ReEnrollments]Grade_Level [S_MI_STU_GC_X]educSetting
15	<S2E2Code>	This contains the school or relationship code (Educational Entity Master S2E2 code) for the student.	[S_MI_STU_GC_X]S2E2code
16	<BldgOtherwiseAttend>	This is the five-digit code that represents the school or facility building where the student would otherwise attend as specified in Sec. 104b (16).	[S_MI_STU_GC_X]bldgOtherwiseAttend
<PersonalDemographics>
17	<ResidentLEANumber>	This contains the student’s resident LEA number.	[S_MI_STU_GC_X]residentLEA
18	<StudentResidentCounty>	This contains the student’s resident county code.	[S_MI_STU_GC_X]residentCounty
19	<Ethnicity>	This contains the student’s ethnicity.	[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
<Contacts>
20	<AddressTypeDescriptor>	This contains the type of address being reported.	[S_MI_STU_GC_X]AddressType_Physical [S_MI_STU_GC_X]AddressType_Mailing [S_MI_STU_GC_X]AddressType_Override [S_MI_STU_GC_X]AddressType_Additional
21	<StreetNumberName>	This contains the number and name of the location of the address for the reported Address Type	[Students]street [Students]mailing_street [S_MI_STU_GC_X]pdStreetAddress [S_MI_STU_GC_X]eoParentAddr1
22	<ApartmentRoomSuiteNumber>	This contains the additional street address information such as apartment, room, suite or lot number that refers to the reported Address Type.	[S_MI_STU_GC_X]pdStreetAddress2 [S_MI_STU_GC_X]eoParentAddr2
23	<City>	This contains the name of the city or town where the address is located.	[Students]city [Students]mailing_city [S_MI_STU_GC_X]pdCity [S_MI_STU_GC_X]eoParentCity
24	<StateAbbreviationDescriptor>	This contains the abbreviation for the state (within the United States) or outlying area in which the address is located.	[Students]state [Students]mailing_state [S_MI_STU_GC_X]pdState [S_MI_STU_GC_X]eoParentState
25	<PostalCode>	This contains the five- or nine-digit ZIP code of the location where the address is located.	[Students]zip [Students]mailing_zip [S_MI_STU_GC_X]pdZipCode [S_MI_STU_GC_X]eoParentZip
26	<TelephoneNumber>	This contains the primary telephone number given by the student’s parent or guardian.	[Students]HomePhone [S_MI_STU_GC_X]eoParentPhone
27	<ElectronicMailAddress>	This contains the contact's electronic email address (email).	[S_MI_STU_GC_X]email_Additional [S_MI_STU_GC_X]email_Mailing [S_MI_STU_GC_X]email_Override [S_MI_STU_GC_X]email_Physical
<Enrollment>
28	<EnrollmentDate>	This contains the student’s district entry date. Note: If the Student > State/Province - MI > Enrollment > 'District Entry Date' is blank, then the Student > Transfer Info > Current/Previous 'Entry Date' is reported as the Enrollment Date.	[Students]DistrictEntryDate OR [Students]EntryDate OR [ReEnrollments]EntryDate
29	<ExitStatus>	This contains the student’s exit code. When data is in the Reported Value field of the ExitCode Code Sets (System Management > Data > Code Sets > ExitCode) that data reports as the student's exit status, if the field is blank, the ExitCode is reported.	[Students]ExitCode or [Codeset]ExitCode [Codeset]ReportedValue
30	<ExitDate>	This contains the student’s exit date.	[Students]ExitDate
31	<addGradAward>	This contains the student's additional graduation award.	[S_MI_STU_GC_X]addGradAward
<Membership>
32	<StudentResidency>	This contains the student’s resident membership code.	[S_MI_STU_GC_X]residentMembership
33	<TuitionFundedEnrollment>	This indicates tuition funded enrollment for a student.	[S_MI_STU_GC_X]TutionFundedEnroll
<GeneralEducationFTE>
34	<GeneralEdFTE>	This contains the amount of General Ed FTE for the student.	[S_MI_STU_GC_X]FTE
<ProgramParticipation>
35	<ProgramEligibilityParticipation>	This contains all of the program eligibility codes for the student.	[S_MI_STU_GC_X]flagTitle1 [S_MI_STU_GC_X]flagSection504 [S_MI_STU_GC_X]flagAlternateEd [S_MI_STU_GC_X]flagDevRedKinder [S_MI_STU_GC_X]flagOutOfState [S_MI_STU_GC_X]flag21CCLC [S_MI_STU_GC_X]flagInternational [S_MI_STU_GC_X]flagExchangeStu [S_MI_STU_GC_X]flagImmFunding [S_MI_STU_GC_X]flagEarlyCollege [S_MI_STU_GC_X]flagSeatTimeWaiver [S_MI_STU_GC_X]flagAtRisk [S_MI_STU_GC_X]homelessSchool
<PersonalCurriculum>
36	<PersonalCurriculumCreditModification>	This contains the personal curriculum credit modifications.	[S_MI_STU_GC_X]pcCredMod1 [S_MI_STU_GC_X]pcCredMod2 [S_MI_STU_GC_X]pcCredMod3 [S_MI_STU_GC_X]pcCredMod4 [S_MI_STU_GC_X]pcCredMod5 [S_MI_STU_GC_X]pcCredMod6 [S_MI_STU_GC_X]pcCredMod7
37	<PersonalCurriculumType>	This contains the personal curriculum types.	[S_MI_STU_GC_X]pcCurrType1 [S_MI_STU_GC_X]pcCurrType2 [S_MI_STU_GC_X]pcCurrType3 [S_MI_STU_GC_X]pcCurrType4
<HomelessDemographics>
38	<Homeless>	This identifies if the student is considered homeless.	[S_MI_STU_GC_X]homelessStatus
39	<UnaccompaniedYouth>	This identifies if the student is considered an unaccompanied youth.	[S_MI_STU_GC_X]flagUnacYouth
<LEP>
40	<LEPInstructionalProgram>	This contains the LEP instructional program.	[S_MI_STU_GC_X]lepProg
41	<PrimaryLanguage>	This contains the primary language.	[S_MI_STU_GC_X]lepLangPrimary
42	<HomeLanguage>	This contains the home language.	[S_MI_STU_GC_X]lepLangHome [S_MI_STU_GC_X]lepLangAdult
43	<LEPExitDate>	This contains the LEP exit date.	[S_MI_STU_GC_X]lepExitDate
44	<LEPReEntryDate>	This contains the LEP re-entry date.	[S_MI_STU_GC_X]lepReEntryDate
<TitleITAS>
45	<TASInstructionalServices>	This contains the Title I instructional services.	[S_MI_STU_GC_X]t1ELA [S_MI_STU_GC_X]t1ESL [S_MI_STU_GC_X]t1Math [S_MI_STU_GC_X]t1Science [S_MI_STU_GC_X]t1SocialStudies [S_MI_STU_GC_X]t1Vocation [S_MI_STU_GC_X]t1OtherIS
46	<TASSupportServices>	This contains the Title I support services.	[S_MI_STU_GC_X]t1Counsel [S_MI_STU_GC_X]t1SocialWork [S_MI_STU_GC_X]t1Prevention [S_MI_STU_GC_X]t1Health [S_MI_STU_GC_X]t1Dental [S_MI_STU_GC_X]t1EyeCare [S_MI_STU_GC_X]t1Transportation [S_MI_STU_GC_X]t1OtherSS
<InitialIEP> Included if the Determination Date ([S_MI_STU_GC_X]seInitialResultDate) Needs to be between the Count Date and the Previous Count and one of the following needs to be true: Timeliness of Initial IEP ([S_MI_STU_GC_X]seInitialTimely) = 22 or Date of Parental Consent ([S_MI_STU_GC_X]seConsentDate) is not blank.
47	<DateOfParentalConsent>	This contains the date of parental consent.	[S_MI_STU_GC_X]seConsentDate
48	<InitialIEPCompletionDate>	This contains the initial IEP completion date.	[S_MI_STU_GC_X]seFAPEDate
49	<TimelinessOfInitialIEP>	This contains the timeliness of the Initial IEP.	[S_MI_STU_GC_X]seInitialTimely
50	<ResultOfInitialIEP>	This contains the result of the Initial IEP.	[S_MI_STU_GC_X]seInitialResult
51	<DaysBeyondTimeline>	This contains the number of days.	[S_MI_STU_GC_X]seInitialDays
52	<PartCTransitionTimeliness>	This contains the Part C Transition Timeliness.	[S_MI_STU_GC_X]seInitialTimePC
<SpecialEducation>
53	<PrimaryDisabiltiy>	This contains the primary disability.	[S_MI_STU_GC_X]sePriDisability
54	<SecondaryDisability>	This contains the secondary disability.	[S_MI_STU_GC_X]seAddDisability
55	<IEPDate>	This contains the IEP date.	[S_MI_STU_GC_X]seIEPDate
56	<TypeofPlan>	This contains the plan type.	[S_MI_STU_GC_X]sePlanType
57	<AddPlanDate>	This contains additional plan dates.	[S_MI_STU_GC_X]seAddPlanDate1 [S_MI_STU_GC_X]seAddPlanDate2 [S_MI_STU_GC_X]seAddPlanDate3
58	<SupportServices>	This contains the support services.	[S_MI_STU_GC_X]seService1 [S_MI_STU_GC_X]seService2 [S_MI_STU_GC_X]seService3 [S_MI_STU_GC_X]seService4 [S_MI_STU_GC_X]seService5
59	<ProgramServiceCode>	This contains the program service codes.	[S_MI_STU_GC_X]sePrgm1 [S_MI_STU_GC_X]sePrgm2 [S_MI_STU_GC_X]sePrgm3
60	<PrimaryEducationalSetting>	This contains the primary educational setting.	[S_MI_STU_GC_X]sePriSetting
61	<PlacedByAnotherDistIEP>	This identifies if the student was placed in the district by another district IEP.	[S_MI_STU_GC_X]seIEPAnotherDist
62	<SpecEdExitReason>	This contains the special ed exit reason.	[S_MI_STU_GC_X]seExitCode
63	<SpecEdExitDate>	This contains the special ed exit date.	[S_MI_STU_GC_X]seExitDate
64	<Section52FTE>	This contains the amount of Section 52 FTE for the student.	[S_MI_STU_GC_X]FTE52
65	<Section53FTE>	This contains the amount of Section 53 FTE for the student.	[S_MI_STU_GC_X]FTE53
<ECSpecialEdAssessment>
66	<EntryAssessmentDate>	This contains the assessment entry date.	[S_MI_STU_GC_X]ecaEntryDate1 [S_MI_STU_GC_X]ecaEntryDate2
67	<ExitAssessmentDate>	This contains the assessment exit date.	[S_MI_STU_GC_X]ecaExitDate1 [S_MI_STU_GC_X]ecaExitDate2
68	<Outcome1A>	This contains the Social Emotional Skills outcome.	[S_MI_STU_GC_X]ecaOutcome1A1 [S_MI_STU_GC_X]ecaOutcome1A2
69	<Outcome1B>	This identifies if there were skills for outcome 1.	[S_MI_STU_GC_X]ecaOutcome1B1 [S_MI_STU_GC_X]ecaOutcome1B2
70	<Outcome2A>	This contains the Acquire/Use of Knowledge Skills outcome.	[S_MI_STU_GC_X]ecaOutcome2A1 [S_MI_STU_GC_X]ecaOutcome2A2
71	<Outcome2B>	This identifies if there were new skills for outcome 2.	[S_MI_STU_GC_X]ecaOutcome2B1 [S_MI_STU_GC_X]ecaOutcome2B2
72	<Outcome3A>	This contains the Takes actions to meet needs outcome.	[S_MI_STU_GC_X]ecaOutcome3A1 [S_MI_STU_GC_X]ecaOutcome3A2
73	<Outcome3B>	This determines if there were new skills for outcome 3.	[S_MI_STU_GC_X]ecaOutcome3B1 [S_MI_STU_GC_X]ecaOutcome3B2
<Discipline> Discipline records are grouped by student, not by the school they are enrolled in at the time of the incident.
Log Entries Reported Discpline:
74	<IncidentID>	This contains the incident ID.	[S_MI_LOG_GC_X]incidentNbr
75	<DateOfIncident>	This contains the date of the incident.	[Log]Discipline_IncidentDate
76	<IncidentType>	This contains the incident type code.	[S_MI_LOG_GC_X]incidentType
77	<SeriousBodilyInjury>	This identifies if the incident involved serious bodily injury.	[S_MI_LOG_GC_X]bodilyInjury
78	<SexualAssault>	This identifies if the incident involved sexual assault.	[S_MI_LOG_GC_X]sexualAssault
79	<InitialConsequenceType>	This contains the initial consequence type.	[S_MI_LOG_GC_X]actionTaken1
80	<InitialDays>	This contains the initial consequence days.	[S_MI_LOG_GC_X]disciplineDays1
81	<InitialStartDate>	This contains the start date of the initial consequence.	[S_MI_LOG_GC_X]disciplineDate1
82	<SecondaryConsequenceType>	This contains the secondary consequence type.	[S_MI_LOG_GC_X]actionTaken2
83	<SecondaryDays>	This contains secondary consequence days.	[S_MI_LOG_GC_X]disciplineDays2
84	<SecondaryStartDate>	This contains the start date of the secondary consequence.	[S_MI_LOG_GC_X]disciplineDate2
85	<OtherConsequenceType>	This contains the other consequence type.	[S_MI_LOG_GC_X]actionTaken3
86	<OtherDays>	This contains the other consequence days.	[S_MI_LOG_GC_X]disciplineDays3
87	<OtherStartDate>	This contains the start date of the other consequence	[S_MI_LOG_GC_X]disciplineDate3
88	<FollowUp>	This contains the follow up code for the consequences.	[S_MI_LOG_GC_X]incidentExpel
Incident Management Reported Discpline:
89	<IncidentID>	This contains the incident ID.	[Incident_Person_Role]Incident_Person_Role_ID
90	<DateOfIncident>	This contains the date of the incident.	[Incident]Incident_TS
90	<IncidentType>	This contains the incident type code.	[Incident_LU_Code]Code_Type=behaviorcode [Incident_LU_Code] State_aggregate_rpt_code=IncidentType [Inincident_lu_sub_codec] state_detail_report_code
92	<SeriousBodilyInjury>	This identifies if the incident involved serious bodily injury.	[Incident_LU_Code]Code_Type=behaviorcode [Incident_LU_Code] State_aggregate_rpt_code=IncidentType [Inincident_lu_sub_codec] state_detail_report_code = 60B or 60SBI
93	<SexualAssault>	This identifies if the incident involved sexual assault.	[Incident_LU_Code]Code_Type=behaviorcode [Incident_LU_Code] State_aggregate_rpt_code=IncidentType [Inincident_lu_sub_codec] state_detail_report_code = 61SA, 60SA, 60B
94	<InitialConsequenceType>	This contains the initial consequence type.	[Incident_LU_Code]Code_Type=actioncode [Incident_LU_Code] State_aggregate_rpt_code=InitialConsequence [Inincident_lu_sub_codec] state_detail_report_code
95	<InitialDays>	This contains the initial consequence days.	[Incident_action]duration_actual Or [Incident_action]duration_assigned
96	<InitialStartDate>	This contains the start date of the initial consequence.	[Incident_action]action_plan_begin_dt
97	<SecondaryConsequenceType>	This contains the secondary consequence type.	[Incident_LU_Code]Code_Type=actioncode [Incident_LU_Code] State_aggregate_rpt_code=SecondaryConsequence [Inincident_lu_sub_codec] state_detail_report_code
98	<SecondaryDays>	This contains secondary consequence days.	[Incident_action]duration_actual Or [Incident_action]duration_assigned
99	<SecondaryStartDate>	This contains the start date of the secondary consequence.	[Incident_action]action_plan_begin_dt
100	<OtherConsequenceType>	This contains the other consequence type.	[Incident_LU_Code]Code_Type=actioncode [Incident_LU_Code] State_aggregate_rpt_code=OtherConsequence [Inincident_lu_sub_codec] state_detail_report_code
101	<OtherDays>	This contains the other consequence days.	[Incident_action]duration_actual Or [Incident_action]duration_assigned
102	<OtherStartDate>	This contains the start date of the other consequence	[Incident_action]action_plan_begin_dt
103	<FollowUp>	This contains the follow up code for the consequences.	[Incident_LU_Code]Code_Type=actioncode [Incident_LU_Code] State_aggregate_rpt_code=FollowUp [Inincident_lu_sub_codec] state_detail_report_code
<Attendance>
104	<DaysAttended>	This contains the number of days the student attended. If the Days Attended on the Attendance tab of the student's State/Province-MI page is populated this overrides the calculation of Days Attended.	Calculated OR [S_MI_STU_GC_X]attDays
105	<TotalPossibleAttendance>	This contains the number of days the student was possible to be in attendance. If the Total Possible Attendance of the Attendance tab on the student's State/Province-MI page is populated this overrides the calculation of Total Possible Attendance.	Calculated OR [S_MI_STU_GC_X]attDaysEnroll
<EarlyReadingDeficiency> Included on the report when the Include Early Reading Deficiency Data in MSDS reporting is checked ([S_MI_STU_GC_X]flagReadDef) and student is in grade K-3. On the Fall and Spring collections only reported for students that have exited. Reported for all students in grades K-3 on the End-of-Year file.
106	<ReadingDeficiencyIdentified>	This contains the student's Early Reading Deficiency iIdentified.	[S_MI_STU_GC_X]readDefIndentified
107	<ReadingDeficiencyContinuation>	This contains the student's Early Reading Deficiency Continuation.	[S_MI_STU_GC_X]readDefContinue
108	<ReadingDeficiencyActivities>	This contains the student's Early Reading Deficiency Activities.	[S_MI_STU_GC_X]readDefActivites
<SNE>
109	<SupplementalNutritionEligibility>	This contains the student’s lunch status eligibility.	[Students]LunchStatus [S_MI_STU_GC_X]lunchStatus_Override
<EarlyOn>
110	<ServiceCoordAgency>	This contains the service agency.	[S_MI_STU_GC_X]eoAgency
111	<PrimaryServiceSetting>	This contains the primary service setting.	[S_MI_STU_GC_X]eoSetting
112	<CurrentIFSPDate>	This contains the current IFSP date.	[S_MI_STU_GC_X]eoIFSPDate
113	<TimelyStartOfService>	This contains the service timeliness.	[S_MI_STU_GC_X]eoTimely
114	<EligibilityReason>	This contains the eligibility reason.	[S_MI_STU_GC_X]eligibilityReason
115	<PartCExitReason>	This contains the Part C exit reason.	[S_MI_STU_GC_X]eoExitCode
116	<PartCExitDate>	This contains the Part C exit date.	[S_MI_STU_GC_X]eoExitDate
117	<TransitionIFSP>	This contains the transition IFSP timeliness.	[S_MI_STU_GC_X]eoTransIFSP
118	<TransitionConference>	This identifies the Early On transition conference.	[S_MI_STU_GC_X]eoTransConf
<InitialIFSP>
119	<ReferralDate>	This contains the referral date.	[S_MI_STU_GC_X]eoInitialReferDate
120	<ReferralAgency>	This contains the referral agency.	[S_MI_STU_GC_X]eoInitialReferral
121	<IFSPTimeliness>	This contains the IFSP timeliness.	[S_MI_STU_GC_X]eoInitialTimely
122	<ResultOfInitialIFSP>	This contains the result of the initial IFSP.	[S_MI_STU_GC_X]eoInitialResult
123	<InitialIFSPDate>	This contains the IFSP date.	[S_MI_STU_GC_X]eoInitialIFSPDate
<PartBReferral>
124	<SEANotification>	This identifies SEA notification 90 days to 9 months before age of 3.	[S_MI_STU_GC_X]eoSEAnotify
125	<LEANotification>	This identifies LEA notification 90 days to 9 months before age of 3.	[S_MI_STU_GC_X]eoLEAnotify
126	<ParentLastName>	This contains the parent last name.	[S_MI_STU_GC_X]eoParentLast
127	<ParentFirstName>	This contains the parent first name.	[S_MI_STU_GC_X]eoParentFirst
128	<ParentAddressUnknown>	This identifies if the parent address is unknown.	[S_MI_STU_GC_X]eoUnknownAddress
129	<ParentPhoneUnknown>	This identifies if the parent phone number is unknown.	[S_MI_STU_GC_X]eoUnknownPhone
<PartCAssessment>
130	<AssessmentDate>	This contains the assessment date.	[S_MI_STU_GC_X]eoaDate1 [S_MI_STU_GC_X]eoaDate2 [S_MI_STU_GC_X]eoaDate3
131	<AssessmentType>	This contains the assessment type.	[S_MI_STU_GC_X]eoaType1 [S_MI_STU_GC_X]eoaType2 [S_MI_STU_GC_X]eoaType3
132	<SocialRelationships>	This contains the assessment rating.	[S_MI_STU_GC_X]eoaSocial1 [S_MI_STU_GC_X]eoaSocial2 [S_MI_STU_GC_X]eoaSocial3
133	<NewSocialRelationships>	This identifies if new skills were shown.	[S_MI_STU_GC_X]eoaSocialNew1 [S_MI_STU_GC_X]eoaSocialNew2 [S_MI_STU_GC_X]eoaSocialNew3
134	<KnowledgeSkills>	This contains the assessment rating.	[S_MI_STU_GC_X]eoaKnowledge1 [S_MI_STU_GC_X]eoaKnowledge2 [S_MI_STU_GC_X]eoaKnowledge3
135	<NewKnowledgeSkills>	This identifies if new skills were shown.	[S_MI_STU_GC_X]eoaKnowledgeNew1 [S_MI_STU_GC_X]eoaKnowledgeNew2 [S_MI_STU_GC_X]eoaKnowledgeNew3
136	<Actions>	This contains the assessment rating.	[S_MI_STU_GC_X]eoaActions1 [S_MI_STU_GC_X]oaActions2 [S_MI_STU_GC_X]oaActions3
137	<NewActions>	This identifies if new skills were shown.	[S_MI_STU_GC_X]eoaActionsNew1 [S_MI_STU_GC_X]eoaActionsNew2 [S_MI_STU_GC_X]eoaActionsNew3
<SeclusionandRestraint>
138	<DateOccurred>	This contains the date of seclusion and restraint for the student.	[S_MI_STU_SECREST_C]SecRestDate
139	<NumberSecluded>	This contains the number of times the student was secluded.	[S_MI_STU_SECREST_C]secludedcount
140	<NumberRestrained>	This contains the number of times the student was restrained.	[S_MI_STU_SECREST_C]restrainedCount
<EarlyOnServices>
141	<Service Codes>	This contains the service code(s) for services the student is receiving (up to 5).	[S_MI_STU_GC_X]eoService1 [S_MI_STU_GC_X]eoService2 [S_MI_STU_GC_X]eoService3 [S_MI_STU_GC_X]eoService4 [S_MI_STU_GC_X]eoService5
142	<Length in Minutes>	This contains the length in minutes for each service.	[S_MI_STU_GC_X]eoServiceMinutes1 [S_MI_STU_GC_X]eoServiceMinutes2 [S_MI_STU_GC_X]eoServiceMinutes3 [S_MI_STU_GC_X]eoServiceMinutes4 [S_MI_STU_GC_X]eoServiceMinutes5
143	<Frequency of Services>	This contains the frequency of services.	[S_MI_STU_GC_X]eoServiceFreq1 [S_MI_STU_GC_X]eoServiceFreq2 [S_MI_STU_GC_X]eoServiceFreq3 [S_MI_STU_GC_X]eoServiceFreq4 [S_MI_STU_GC_X]eoServiceFreq5

Back to Top

Michigan Student Record Maintenance Collection

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.

Item #	Data Element	Description	[Table]FieldName
<SubmittingEntity>
1	<SubmittingEntityTypeCode>	This contains the submitting entity type code value selected on the report interface.	N/A
2	<SubmittingEntityCode>	This contains the submitting entity code value entered on the report interface.	N/A
<PersonalCore>
3	<UIC>	This contains the student’s Unique Identification Code (UIC).	[Students]State_StudentNumber
4	<LastName>	This contains the student’s last name.	[Students]Last_Name
5	<FirstName>	This contains the student’s first name.	[Students]First_Name
6	<MiddleName>	This contains the student’s middle name.	[Students]Middle_Name
7	<StudentSuffix>	This contains the student’s suffix.	[S_MI_STU_GC_X]stuNameSuffix
8	<DateOfBirth>	This contains the student’s date of birth.	[Students]DOB
9	<MultipleBirthOrder>	This identifies the birth order of the student if the student is part of a multiple birth.	[S_MI_STU_GC_X]multipleBirth
10	<Gender>	This contains the student’s gender code. Note: If the student's preferred gender is not M or F, the legal gender is reported.	[Students]Gender [STUDENTCOREFIELDS]PSCore_Legal_Gender
<StudentRecordMaintenance>
11	<AsOfDate>	This contains the SRM date. Note: If there is no date in the Student > State/Province - MI > Student Record Maintenance > 'As Of Date' this element is populated with the 'Current Count Date' entered in the report parameters. If the student exited during the count period and there is no 'As of Date' this element is populated with the student's current/previous Exit Date.	[S_MI_STU_GC_X]SRMDate OR [Students]ExitDate OR [ReEnrollments]ExitDate
<SchoolDemographics>
12	<OperatingDistrictNumber>	This contains the operating district number value entered on the report interface.	N/A
13	<SchoolFacilityNumber>	This contains the school or facility number for the student’s school.	[S_MI_SCH_TSDL_X]adminUnit [S_MI_STU_GC_X]adminUnit [S_MI_REN_GC_X]adminUnit
14	<StudentIdNumber>	This contains the PowerSchool student ID number.	[Students]Student_Number
15	<GradeOrSetting>	This contains the grade level in which the student is enrolled.	[Students]Grade_Level [ReEnrollments]Grade_Level [S_MI_STU_GC_X]educSetting
16	<S2E2Code>	This contains the school or relationship code (Educational Entity Master S2E2 code) for the student.	[S_MI_STU_GC_X]S2E2code
17	<BldgOtherwiseAttend>	This is the five-digit code that represents the school or facility building where the student would otherwise attend as specified in Sec. 104b (16).	[S_MI_STU_GC_X]bldgOtherwiseAttend
<PersonalDemographics>
18	<ResidentLEANumber>	This contains the student’s resident LEA number.	[S_MI_STU_GC_X]residentLEA
19	<StudentResidentCounty>	This contains the student’s resident county code.	[S_MI_STU_GC_X]residentCounty
20	<Ethnicity>	This contains the student’s ethnicity.	[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
<Contacts>
21	<AddressTypeDescriptor>	This contains the type of address being reported.	[S_MI_STU_GC_X]AddressType_Physical [S_MI_STU_GC_X]AddressType_Mailing [S_MI_STU_GC_X]AddressType_Override [S_MI_STU_GC_X]AddressType_Additional
22	<StreetNumberName>	This contains the number and name of the location of the address for the reported Address Type	[Students]street [Students]mailing_street [S_MI_STU_GC_X]pdStreetAddress [S_MI_STU_GC_X]eoParentAddr1
23	<ApartmentRoomSuiteNumber>	This contains the additional street address information such as apartment, room, suite or lot number that refers to the reported Address Type.	[S_MI_STU_GC_X]pdStreetAddress2 [S_MI_STU_GC_X]eoParentAddr2
24	<City>	This contains the name of the city or town where the address is located.	[Students]city [Students]mailing_city [S_MI_STU_GC_X]pdCity [S_MI_STU_GC_X]eoParentCity
25	<StateAbbreviationDescriptor>	This contains the abbreviation for the state (within the United States) or outlying area in which the address is located.	[Students]state [Students]mailing_state [S_MI_STU_GC_X]pdState [S_MI_STU_GC_X]eoParentState
26	<PostalCode>	This contains the five- or nine-digit ZIP code of the location where the address is located.	[Students]zip [Students]mailing_zip [S_MI_STU_GC_X]pdZipCode [S_MI_STU_GC_X]eoParentZip
27	<TelephoneNumber>	This contains the primary telephone number given by the student’s parent or guardian.	[Students]HomePhone [S_MI_STU_GC_X]eoParentPhone
28	<ElectronicMailAddress>	This contains the contact's electronic email address (email).	[S_MI_STU_GC_X]email_Additional [S_MI_STU_GC_X]email_Mailing [S_MI_STU_GC_X]email_Override [S_MI_STU_GC_X]email_Physical
<Enrollment>
29	<EnrollmentDate>	This contains the student’s entry date. Note: If the Student > State/Province - MI > Enrollment > 'District Entry Date' is blank, then the Student > Transfer Info > Current/Previous 'Entry Date' is reported as the Enrollment Date.	[Students]DistrictEntryDate OR [Students]EntryDate OR [ReEnrollments]EntryDate
30	<ExitStatus>	This contains the student’s exit code.	[Students]ExitCode
31	<ExitDate>	This contains the student’s exit date.	[Students]ExitDate
32	<addGradAward>	This contains the student's additional graduation award.	[S_MI_STU_GC_X]addGradAward
<Membership>
33	<StudentResidency>	This contains the student’s resident membership code.	[S_MI_STU_GC_X]residentMembership
34	<TuitionFundedEnrollment>	This indicates tuition funded enrollment for a student.	[S_MI_STU_GC_X]TutionFundedEnroll
<GeneralEducationFTE>
35	<GeneralEdFTE>	This contains the amount of General Ed FTE for the student.	[S_MI_STU_GC_X]FTE
<ProgramParticipation>
36	<ProgramEligibilityParticipation>	This contains all of the program eligibility codes for the student.	[S_MI_STU_GC_X]flagTitle1 [S_MI_STU_GC_X]flagSection504 [S_MI_STU_GC_X]flagAlternateEd [S_MI_STU_GC_X]flagDevRedKinder [S_MI_STU_GC_X]flagOutOfState [S_MI_STU_GC_X]flag21CCLC [S_MI_STU_GC_X]flagInternational [S_MI_STU_GC_X]flagExchangeStu [S_MI_STU_GC_X]flagImmFunding [S_MI_STU_GC_X]flagEarlyCollege [S_MI_STU_GC_X]flagSeatTimeWaiver [S_MI_STU_GC_X]flagAtRisk [S_MI_STU_GC_X]homelessSchool
<PersonalCurriculum>
37	<PersonalCurriculumCreditModification>	This contains the personal curriculum credit modifications.	[S_MI_STU_GC_X]pcCredMod1 [S_MI_STU_GC_X]pcCredMod2 [S_MI_STU_GC_X]pcCredMod3 [S_MI_STU_GC_X]pcCredMod4 [S_MI_STU_GC_X]pcCredMod5 [S_MI_STU_GC_X]pcCredMod6 [S_MI_STU_GC_X]pcCredMod7
38	<PersonalCurriculumType>	This contains the personal curriculum types.	[S_MI_STU_GC_X]pcCurrType1 [S_MI_STU_GC_X]pcCurrType2 [S_MI_STU_GC_X]pcCurrType3 [S_MI_STU_GC_X]pcCurrType4
<HomelessDemographics>
39	<Homeless>	This identifies if the student is considered homeless.	[S_MI_STU_GC_X]homelessStatus
40	<UnaccompaniedYouth>	This identifies if the student is considered an unaccompanied youth.	[S_MI_STU_GC_X]flagUnacYouth
<LEP>
41	<LEPInstructionalProgram>	This contains the LEP instructional program.	[S_MI_STU_GC_X]lepProg
42	<PrimaryLanguage>	This contains the primary language.	[S_MI_STU_GC_X]lepLangPrimary
43	<HomeLanguage>	This contains the home language.	[S_MI_STU_GC_X]lepLangHome [S_MI_STU_GC_X]lepLangAdult
44	<LEPExitDate>	This contains the LEP exit date.	[S_MI_STU_GC_X]lepExitDate
45	<LEPReEntryDate>	This contains the LEP re-entry date.	[S_MI_STU_GC_X]lepReEntryDate
<TitleITAS>
46	<TASInstructionalServices>	This contains the Title I instructional services.	[S_MI_STU_GC_X]t1ELA [S_MI_STU_GC_X]t1ESL [S_MI_STU_GC_X]t1Math [S_MI_STU_GC_X]t1Science [S_MI_STU_GC_X]t1SocialStudies [S_MI_STU_GC_X]t1Vocation [S_MI_STU_GC_X]t1OtherIS
47	<TASSupportServices>	This contains the Title I support services.	[S_MI_STU_GC_X]t1Counsel [S_MI_STU_GC_X]t1SocialWork [S_MI_STU_GC_X]t1Prevention [S_MI_STU_GC_X]t1Health [S_MI_STU_GC_X]t1Dental [S_MI_STU_GC_X]t1EyeCare [S_MI_STU_GC_X]t1Transportation [S_MI_STU_GC_X]t1OtherSS
<InitialIEP> Included if the Determination Date ([S_MI_STU_GC_X]seInitialResultDate) Needs to be between the Count Date and the Previous Count and one of the following needs to be true: Timeliness of Initial IEP ([S_MI_STU_GC_X]seInitialTimely) = 22 or Date of Parental Consent ([S_MI_STU_GC_X]seConsentDate) is not blank.
48	<DateOfParentalConsent>	This contains the date of parental consent.	[S_MI_STU_GC_X]seConsentDate
49	<InitialIEPCompletionDate>	This contains the initial IEP completion date.	[S_MI_STU_GC_X]seFAPEDate
50	<TimelinessOfInitialIEP>	This contains the timeliness of the Initial IEP.	[S_MI_STU_GC_X]seInitialTimely
51	<ResultOfInitialIEP>	This contains the result of the Initial IEP.	[S_MI_STU_GC_X]seInitialResult
52	<DaysBeyondTimeline>	This contains the number of days.	[S_MI_STU_GC_X]seInitialDays
53	<PartCTransitionTimeliness>	This contains the Part C Transition Timeliness.	[S_MI_STU_GC_X]seInitialTimePC
<SpecialEducation>
54	<PrimaryDisabiltiy>	This contains the primary disability.	[S_MI_STU_GC_X]sePriDisability
55	<SecondaryDisability>	This contains the secondary disability.	[S_MI_STU_GC_X]seAddDisability
56	<IEPDate>	This contains the IEP date.	[S_MI_STU_GC_X]seIEPDate
57	<TypeofPlan>	This contains the plan type.	[S_MI_STU_GC_X]sePlanType
58	<AddPlanDate>	This contains additional plan dates.	[S_MI_STU_GC_X]seAddPlanDate1 [S_MI_STU_GC_X]seAddPlanDate2 [S_MI_STU_GC_X]seAddPlanDate3
59	<SupportServices>	This contains the support services.	[S_MI_STU_GC_X]seService1 [S_MI_STU_GC_X]seService2 [S_MI_STU_GC_X]seService3 [S_MI_STU_GC_X]seService4 [S_MI_STU_GC_X]seService5
60	<ProgramServiceCode>	This contains the program service codes.	[S_MI_STU_GC_X]sePrgm1 [S_MI_STU_GC_X]sePrgm2 [S_MI_STU_GC_X]sePrgm3
61	<PrimaryEducationalSetting>	This contains the primary educational setting.	[S_MI_STU_GC_X]sePriSetting
62	<PlacedByAnotherDistIEP>	This identifies if the student was placed in the district by another district IEP.	[S_MI_STU_GC_X]seIEPAnotherDist
63	<SpecEdExitReason>	This contains the special ed exit reason.	[S_MI_STU_GC_X]seExitCode
64	<SpecEdExitDate>	This contains the special ed exit date.	[S_MI_STU_GC_X]seExitDate
65	<Section52FTE>	This contains the amount of Section 52 FTE for the student.	[S_MI_STU_GC_X]FTE52
66	<Section53FTE>	This contains the amount of Section 53 FTE for the student.	[S_MI_STU_GC_X]FTE53
<ECSpecialEdAssessment>
67	<AssessmentTool>	This contains the assessment tool used.	[S_MI_STU_GC_X]ecaTool1 [S_MI_STU_GC_X]ecaTool2
68	<OtherToolComments>	This contains any assessment tool comments.	[S_MI_STU_GC_X]ecaComment1 [S_MI_STU_GC_X]ecaComment2
69	<EntryAssessmentDate>	This contains the assessment entry date.	[S_MI_STU_GC_X]ecaEntryDate1 [S_MI_STU_GC_X]ecaEntryDate2
70	<ExitAssessmentDate>	This contains the assessment exit date.	[S_MI_STU_GC_X]ecaExitDate1 [S_MI_STU_GC_X]ecaExitDate2
71	<Outcome1A>	This contains the Social Emotional Skills outcome.	[S_MI_STU_GC_X]ecaOutcome1A1 [S_MI_STU_GC_X]ecaOutcome1A2
72	<Outcome1B>	This identifies if there were skills for outcome 1.	[S_MI_STU_GC_X]ecaOutcome1B1 [S_MI_STU_GC_X]ecaOutcome1B2
73	<Outcome2A>	This contains the Acquire/Use of Knowledge Skills outcome.	[S_MI_STU_GC_X]ecaOutcome2A1 [S_MI_STU_GC_X]ecaOutcome2A2
74	<Outcome2B>	This identifies if there were new skills for outcome 2.	[S_MI_STU_GC_X]ecaOutcome2B1 [S_MI_STU_GC_X]ecaOutcome2B2
75	<Outcome3A>	This contains the Takes actions to meet needs outcome.	[S_MI_STU_GC_X]ecaOutcome3A1 [S_MI_STU_GC_X]ecaOutcome3A2
76	<Outcome3B>	This determines if there were new skills for outcome 3.	[S_MI_STU_GC_X]ecaOutcome3B1 [S_MI_STU_GC_X]ecaOutcome3B2
<Discipline> Discipline records are grouped by student, not by the school they are enrolled in at the time of the incident.
Log Entries Reported Discpline:
77	<IncidentID>	This contains the incident ID.	[S_MI_LOG_GC_X]incidentNbr
78	<DateOfIncident>	This contains the date of the incident.	[Log]Discipline_IncidentDate
79	<IncidentType>	This contains the incident type code.	[S_MI_LOG_GC_X]incidentType
80	<SeriousBodilyInjury>	This identifies if the incident involved serious bodily injury.	[S_MI_LOG_GC_X]bodilyInjury
81	<SexualAssault>	This identifies if the incident involved sexual assault.	[S_MI_LOG_GC_X]sexualAssault
82	<InitialConsequenceType>	This contains the initial consequence type.	[S_MI_LOG_GC_X]actionTaken1
83	<InitialDays>	This contains the initial consequence days.	[S_MI_LOG_GC_X]disciplineDays1
84	<InitialStartDate>	This contains the start date of the initial consequence.	[S_MI_LOG_GC_X]disciplineDate1
85	<SecondaryConsequenceType>	This contains the secondary consequence type.	[S_MI_LOG_GC_X]actionTaken2
86	<SecondaryDays>	This contains secondary consequence days.	[S_MI_LOG_GC_X]disciplineDays2
87	<SecondaryStartDate>	This contains the start date of the secondary consequence.	[S_MI_LOG_GC_X]disciplineDate2
88	<OtherConsequenceType>	This contains the other consequence type.	[S_MI_LOG_GC_X]actionTaken3
89	<OtherDays>	This contains the other consequence days.	[S_MI_LOG_GC_X]disciplineDays3
90	<OtherStartDate>	This contains the start date of the other consequence	[S_MI_LOG_GC_X]disciplineDate3
91	<FollowUp>	This contains the follow up code for the consequences.	[S_MI_LOG_GC_X]incidentExpel
Incident Management Reported Discpline:
77	<IncidentID>	This contains the incident ID.	[Incident_Person_Role]Incident_Person_Role_ID
78	<DateOfIncident>	This contains the date of the incident.	[Incident]Incident_TS
79	<IncidentType>	This contains the incident type code.	[Incident_LU_Code]Code_Type=behaviorcode [Incident_LU_Code] State_aggregate_rpt_code=IncidentType [Inincident_lu_sub_codec] state_detail_report_code
80	<SeriousBodilyInjury>	This identifies if the incident involved serious bodily injury.	[Incident_LU_Code]Code_Type=behaviorcode [Incident_LU_Code] State_aggregate_rpt_code=IncidentType [Inincident_lu_sub_codec] state_detail_report_code = 60B or 60SBI
81	<SexualAssault>	This identifies if the incident involved sexual assault.	[Incident_LU_Code]Code_Type=behaviorcode [Incident_LU_Code] State_aggregate_rpt_code=IncidentType [Inincident_lu_sub_codec] state_detail_report_code = 61SA, 60SA, 60B
82	<InitialConsequenceType>	This contains the initial consequence type.	[Incident_LU_Code]Code_Type=actioncode [Incident_LU_Code] State_aggregate_rpt_code=InitialConsequence [Inincident_lu_sub_codec] state_detail_report_code
83	<InitialDays>	This contains the initial consequence days.	[Incident_action]duration_actual Or [Incident_action]duration_assigned
84	<InitialStartDate>	This contains the start date of the initial consequence.	[Incident_action]action_plan_begin_dt
85	<SecondaryConsequenceType>	This contains the secondary consequence type.	[Incident_LU_Code]Code_Type=actioncode [Incident_LU_Code] State_aggregate_rpt_code=SecondaryConsequence [Inincident_lu_sub_codec] state_detail_report_code
86	<SecondaryDays>	This contains secondary consequence days.	[Incident_action]duration_actual Or [Incident_action]duration_assigned
87	<SecondaryStartDate>	This contains the start date of the secondary consequence.	[Incident_action]action_plan_begin_dt
88	<OtherConsequenceType>	This contains the other consequence type.	[Incident_LU_Code]Code_Type=actioncode [Incident_LU_Code] State_aggregate_rpt_code=OtherConsequence [Inincident_lu_sub_codec] state_detail_report_code
89	<OtherDays>	This contains the other consequence days.	[Incident_action]duration_actual Or [Incident_action]duration_assigned
90	<OtherStartDate>	This contains the start date of the other consequence	[Incident_action]action_plan_begin_dt
91	<FollowUp>	This contains the follow up code for the consequences.	[Incident_LU_Code]Code_Type=actioncode [Incident_LU_Code] State_aggregate_rpt_code=FollowUp [Inincident_lu_sub_codec] state_detail_report_code
<Attendance>
92	<DaysAttended>	This contains the number of days the student attended. If the Days Attended on the Attendance tab of the student's State/Province-MI page is populated this overrides the calculation of Days Attended.	Calculated OR [S_MI_STU_GC_X]attDays
93	<TotalPossibleAttendance>	This contains the number of days the student was possible to be in attendance. If the Total Possible Attendance of the Attendance tab on the student's State/Province-MI page is populated this overrides the calculation of Total Possible Attendance.	Calculated OR [S_MI_STU_GC_X]attDaysEnroll
<EarlyReadingDeficiency> Included on report when the Include Early Reading Deficiency Data in MSDS reporting is checked ([S_MI_STU_GC_X]flagReadDef) and student is in grade K-3 and the student has exited.
94	<ReadingDeficiencyIdentified>	This contains the student's Early Reading Deficiency Identified.	[S_MI_STU_GC_X]readDefIndentified
95	<ReadingDeficiencyContinuation>	This contains the student's Early Reading Deficiency Continuation.	[S_MI_STU_GC_X]readDefContinue
96	<ReadingDeficiencyActivities>	This contains the student's Early Reading Deficiency Activities.	[S_MI_STU_GC_X]readDefActivites
<SNE>
97	<SupplementalNutritionEligibility>	This contains the student’s lunch status eligibility.	[Students]LunchStatus [S_MI_STU_GC_X]lunchStatus_Override
<Section23a>
98	<MonthClaimed>	This contains the month claimed.	[S_MI_STU_GC_X]s23ADateClaimed01 [S_MI_STU_GC_X]s23ADateClaimed02 [S_MI_STU_GC_X]s23ADateClaimed03 [S_MI_STU_GC_X]s23ADateClaimed04 [S_MI_STU_GC_X]s23ADateClaimed05 [S_MI_STU_GC_X]s23ADateClaimed06 [S_MI_STU_GC_X]s23ADateClaimed07 [S_MI_STU_GC_X]s23ADateClaimed08 [S_MI_STU_GC_X]s23ADateClaimed09 [S_MI_STU_GC_X]s23ADateClaimed10 [S_MI_STU_GC_X]s23ADateClaimed11 [S_MI_STU_GC_X]s23ADateClaimed12
99	<ProgramStartDate>	This contains the program start date.	[S_MI_STU_GC_X]s23ADate
<Section25>
100	<FirstDayInAttendance>	This contains the first day in attendance.	[S_MI_STU_GC_X]firstAttendDate
<EarlyOn>
101	<Service Coordination Agency>	This indicates the service coordination agency.	[S_MI_STU_GC_X]eoAgency1
102	<Primary Service Setting>	This indicates the primary service setting.	[S_MI_STU_GC_X]eoSetting
103	<Current IFSP Date>	This indicates the current IFSP date.	[S_MI_STU_GC_X]eoIFSPDate
104	<Timely Start of Service>	This indicates the start of service code.	[S_MI_STU_GC_X]eoTimely
105	<Eligibility Reason>	This contains the eligibility reason.	[S_MI_STU_GC_X]eligibilityReason
106	<Part C Exit Reason>	This indicates the Part C exit reason.	[S_MI_STU_GC_X]eoExitCode
107	<Part C Exit Date>	This contains the Part C exit date.	[S_MI_STU_GC_X]eoExitDate
108	<Transition IFSP>	This indicates the transition IFSP code.	[S_MI_STU_GC_X]eoTransIFSP
109	<Transition Conference>	This indicates the transition conference code.	[S_MI_STU_GC_X]eoTransConf
<InitialIFSP>
110	<ReferralDate>	This contains the referral date.	[S_MI_STU_GC_X]eoInitialReferDate
111	<ReferralAgency>	This contains the referral agency.	[S_MI_STU_GC_X]eoInitialReferral
112	<IFSPTimeliness>	This contains the IFSP timeliness.	[S_MI_STU_GC_X]eoInitialTimely
113	<ResultOfInitialIFSP>	This contains the result of the initial IFSP.	[S_MI_STU_GC_X]eoInitialResult
114	<InitialIFSPDate>	This contains the initial IFSP Date.	[S_MI_STU_GC_X]eoInitialIFSPDate
<PartBRefferal>
115	<SEANotification>	This identifies SEA notification 90 days to 9 months before age of 3.	[S_MI_STU_GC_X]eoSEAnotify
116	<LEANotification>	This identifies LEA notification 90 days to 9 months before age of 3.	[S_MI_STU_GC_X]eoLEAnotify
117	<ParentLastName>	This contains the parent last name.	[S_MI_STU_GC_X]eoParentLast
118	<ParentFirstName>	This contains the parent first name.	[S_MI_STU_GC_X]eoParentFirst
119	<ParentAddressUnknown>	This identifies if the parent address is unknown.	[S_MI_STU_GC_X]eoUnknownAddress
120	<ParentPhoneUnknown>	This identifies if the parent phone number is unknown.	[S_MI_STU_GC_X]eoUnknownPhone
<PartCAssessment>
121	<DataSource>	This contains the assessment record data source.	[S_MI_STU_GC_X]eoaSource1 [S_MI_STU_GC_X]eoaSource2 [S_MI_STU_GC_X]eoaSource3
122	<OtherSourceComments>	This contains the assessment comments.	[S_MI_STU_GC_X]eoaComment1 [S_MI_STU_GC_X]eoaComment2 [S_MI_STU_GC_X]eoaComment3
123	<AssessmentDate>	This contains the assessment date.	[S_MI_STU_GC_X]eoaDate1 [S_MI_STU_GC_X]eoaDate2 [S_MI_STU_GC_X]eoaDate3
124	<AssessmentType>	This contains the assessment type.	[S_MI_STU_GC_X]eoaType1 [S_MI_STU_GC_X]eoaType2 [S_MI_STU_GC_X]eoaType3
125	<ParentInput>	This contains the type of parent input.	[S_MI_STU_GC_X]eoaParentInput1 [S_MI_STU_GC_X]eoaParentInput2 [S_MI_STU_GC_X]eoaParentInput3
126	<ParentInputDate>	This contains the date of the parent input.	[S_MI_STU_GC_X]eoaParentDate1 [S_MI_STU_GC_X]eoaParentDate2 [S_MI_STU_GC_X]eoaParentDate3
127	<SocialRelationships>	This contains the assessment rating.	[S_MI_STU_GC_X]eoaSocial1 [S_MI_STU_GC_X]eoaSocial2 [S_MI_STU_GC_X]eoaSocial3
128	<NewSocialRelationships>	This identifies if new skills were shown.	[S_MI_STU_GC_X]eoaSocialNew1 [S_MI_STU_GC_X]eoaSocialNew2 [S_MI_STU_GC_X]eoaSocialNew3
129	<KnowledgeSkills>	This contains the assessment rating.	[S_MI_STU_GC_X]eoaKnowledge1 [S_MI_STU_GC_X]eoaKnowledge2 [S_MI_STU_GC_X]eoaKnowledge3
130	<NewKnowledgeSkills>	This identifies if new skills were shown.	[S_MI_STU_GC_X]eoaKnowledgeNew1 [S_MI_STU_GC_X]eoaKnowledgeNew2 [S_MI_STU_GC_X]eoaKnowledgeNew3
131	<Actions>	This contains the assessment rating.	[S_MI_STU_GC_X]eoaActions1 [S_MI_STU_GC_X]oaActions2 [S_MI_STU_GC_X]oaActions3
132	<NewActions>	This identifies if new skills were shown.	[S_MI_STU_GC_X]eoaActionsNew1 [S_MI_STU_GC_X]eoaActionsNew2 [S_MI_STU_GC_X]eoaActionsNew3
<EarlyOnServices>
133	<Service Codes>	This contains the service codes the student is receiving (up to 5).	[S_MI_STU_GC_X]eoService1 [S_MI_STU_GC_X]eoService2 [S_MI_STU_GC_X]eoService3 [S_MI_STU_GC_X]eoService4 [S_MI_STU_GC_X]eoService5
134	<Length In Minutes>	This contains the length in minutes for each service.	[S_MI_STU_GC_X]eoServiceMinutes1 [S_MI_STU_GC_X]eoServiceMinutes2 [S_MI_STU_GC_X]eoServiceMinutes3 [S_MI_STU_GC_X]eoServiceMinutes4 [S_MI_STU_GC_X]eoServiceMinutes5
135	<Frequency of Services>	This contains the frequency of services.	[S_MI_STU_GC_X]eoServiceFreq1 [S_MI_STU_GC_X]eoServiceFreq2 [S_MI_STU_GC_X]eoServiceFreq3 [S_MI_STU_GC_X]eoServiceFreq4 [S_MI_STU_GC_X]eoServiceFreq5

Back to Top

Michigan Early Childhood Collection

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
<SubmittingEntity>
1	<SubmittingEntityTypeCode>	This contains the submitting entity type code value selected on the report interface.	N/A
2	<SubmittingEntityCode>	This contains the submitting entity code value entered on the report interface.	N/A
<PersonalCore>
3	<UIC>	This contains the student’s Unique Identification Code (UIC).	[Students]State_StudentNumber
4	<LastName>	This contains the student’s last name.	[Students]Last_Name
5	<FirstName>	This contains the student’s first name.	[Students]First_Name
6	<MiddleName>	This contains the student’s middle name.	[Students]Middle_Name
7	<StudentSuffix>	This contains the student’s suffix.	[S_MI_STU_GC_X]stuNameSuffix
8	<DateOfBirth>	This contains the student’s date of birth.	[Students]DOB
9	<MultipleBirthOrder>	This identifies the birth order of the student if the student is part of a multiple birth.	[S_MI_STU_GC_X]multipleBirth
10	<Gender>	This contains the student’s gender code. Note: If the student's preferred gender is not M or F, the legal gender is reported.	[Students]Gender [STUDENTCOREFIELDS]PSCore_Legal_Gender
<PersonalDemographics>
11	<ResidentLEANumber>	This contains the student’s resident LEA number.	[S_MI_STU_GC_X]residentLEA
12	<StudentResidentCounty>	This contains the student’s resident county code.	[S_MI_STU_GC_X]residentCounty
13	<Ethnicity>	This contains the student’s ethnicity.	[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
<Contacts>
14	<AddressTypeDescriptor>	This contains the type of address being reported.	[S_MI_STU_GC_X]AddressType_Physical [S_MI_STU_GC_X]AddressType_Mailing [S_MI_STU_GC_X]AddressType_Override [S_MI_STU_GC_X]AddressType_Additional
15	<StreetNumberName>	This contains the number and name of the location of the address for the reported Address Type	[Students]street [Students]mailing_street [S_MI_STU_GC_X]pdStreetAddress [S_MI_STU_GC_X]eoParentAddr1
16	<ApartmentRoomSuiteNumber>	This contains the additional street address information such as apartment, room, suite or lot number that refers to the reported Address Type.	[S_MI_STU_GC_X]pdStreetAddress2 [S_MI_STU_GC_X]eoParentAddr2
17	<City>	This contains the name of the city or town where the address is located.	[Students]city [Students]mailing_city [S_MI_STU_GC_X]pdCity [S_MI_STU_GC_X]eoParentCity
18	<StateAbbreviationDescriptor>	This contains the abbreviation for the state (within the United States) or outlying area in which the address is located.	[Students]state [Students]mailing_state [S_MI_STU_GC_X]pdState [S_MI_STU_GC_X]eoParentState
19	<PostalCode>	This contains the five- or nine-digit ZIP code of the location where the address is located.	[Students]zip [Students]mailing_zip [S_MI_STU_GC_X]pdZipCode [S_MI_STU_GC_X]eoParentZip
20	<TelephoneNumber>	This contains the primary telephone number given by the student’s parent or guardian.	[Students]HomePhone [S_MI_STU_GC_X]eoParentPhone
21	<ElectronicMailAddress>	This contains the contact's electronic email address (email).	[S_MI_STU_GC_X]email_Additional [S_MI_STU_GC_X]email_Mailing [S_MI_STU_GC_X]email_Override [S_MI_STU_GC_X]email_Physical
<ECPrograms>
22	<FiscalEntityTypeCode>	This contains the fiscal entity type code.	[S_MI_STU_GC_X]ecEntityType1 [S_MI_STU_GC_X]ecEntityType2 [S_MI_STU_GC_X]ecEntityType3 [S_MI_STU_GC_X]ecEntityType4 [S_MI_STU_GC_X]ecEntityType5
23	<FiscalEntityCode>	This contains the fiscal entity code.	[S_MI_STU_GC_X]ecEntity1 [S_MI_STU_GC_X]ecEntity2 [S_MI_STU_GC_X]ecEntity3 [S_MI_STU_GC_X]ecEntity4 [S_MI_STU_GC_X]ecEntity5
24	<FiscalEntityCode2>	This contains the second fiscal entity code.	[S_MI_STU_GC_X]ecEntity21 [S_MI_STU_GC_X]ecEntity22 [S_MI_STU_GC_X]ecEntity23 [S_MI_STU_GC_X]ecEntity24 [S_MI_STU_GC_X]ecEntity25
25	<SchoolFacilityNumber>	This contains the school or facility number.	[S_MI_STU_GC_X]ecAdminUnit1 [S_MI_STU_GC_X]ecAdminUnit2 [S_MI_STU_GC_X]ecAdminUnit3 [S_MI_STU_GC_X]ecAdminUnit4 [S_MI_STU_GC_X]ecAdminUnit5
26	<ProviderLicenseNumber>	This contains the provider license number	[S_MI_STU_GC_X]ecProviderLicense1 [S_MI_STU_GC_X]ecProviderLicense2 [S_MI_STU_GC_X]ecProviderLicense3 [S_MI_STU_GC_X]ecProviderLicense4 [S_MI_STU_GC_X]ecProviderLicense5
27	<ECComment>	This contains the early childhood comment	[S_MI_STU_GC_X]ecComment1 [S_MI_STU_GC_X]ecComment2 [S_MI_STU_GC_X]ecComment3 [S_MI_STU_GC_X]ecComment4 [S_MI_STU_GC_X]ecComment5
28	<ECProgram>	This contains the early childhood enrollment placement.	[S_MI_STU_GC_X]ecProgram1 [S_MI_STU_GC_X]ecProgram2 [S_MI_STU_GC_X]ecProgram3 [S_MI_STU_GC_X]ecProgram4 [S_MI_STU_GC_X]ecProgram5
29	<ECProgramStartDate>	This contains the early childhood program start date.	[S_MI_STU_GC_X]ecStartDate1 [S_MI_STU_GC_X]ecStartDate2 [S_MI_STU_GC_X]ecStartDate3 [S_MI_STU_GC_X]ecStartDate4 [S_MI_STU_GC_X]ecStartDate5
30	<ECDeliveryMethod>	This contains the early childhood delivery method.	[S_MI_STU_GC_X]ecMethod1 [S_MI_STU_GC_X]ecMethod2 [S_MI_STU_GC_X]ecMethod3 [S_MI_STU_GC_X]ecMethod4 [S_MI_STU_GC_X]ecMethod5
31	<ECDeliverySchedule>	This contains the early childhood delivery schedule.	[S_MI_STU_GC_X]ecSchedule1 [S_MI_STU_GC_X]ecSchedule2 [S_MI_STU_GC_X]ecSchedule3 [S_MI_STU_GC_X]ecSchedule4 [S_MI_STU_GC_X]ecSchedule5
32	<FederalPovertyLevelQuintile>	This contains the federal poverty level quintile.	[S_MI_STU_GC_X]federalpovertylevelquintile1 [S_MI_STU_GC_X]federalpovertylevelquintile2 [S_MI_STU_GC_X]federalpovertylevelquintile3 [S_MI_STU_GC_X]federalpovertylevelquintile4 [S_MI_STU_GC_X]federalpovertylevelquintile5
33	<AdditionalEligibilityFactor>	This contains the additional eligibility factors.	[S_MI_STU_GC_X]ecAddEligibilityFactor1 [S_MI_STU_GC_X]ecAddEligibilityFactor2 [S_MI_STU_GC_X]ecAddEligibilityFactor3 [S_MI_STU_GC_X]ecAddEligibilityFactor4 [S_MI_STU_GC_X]ecAddEligibilityFactor5
34	<QualifyingFactor>	This contains the qualifying factor.	[S_MI_STU_GC_X]ecQualifyingFactor1 [S_MI_STU_GC_X]ecQualifyingFactor2 [S_MI_STU_GC_X]ecQualifyingFactor3 [S_MI_STU_GC_X]ecQualifyingFactor4 [S_MI_STU_GC_X]ecQualifyingFactor5
35	<ECProgramEndDate>	This contains the early childhood program end date.	[S_MI_STU_GC_X]ecEndDate1 [S_MI_STU_GC_X]ecEndDate2 [S_MI_STU_GC_X]ecEndDate3 [S_MI_STU_GC_X]ecEndDate4 [S_MI_STU_GC_X]ecEndDate5
36	<ECProgramExitReason>	This contains the early childhood program exit/completion reason.	[S_MI_STU_GC_X]ecExitCode1 [S_MI_STU_GC_X]ecExitCode2 [S_MI_STU_GC_X]ecExitCode3 [S_MI_STU_GC_X]ecExitCode4 [S_MI_STU_GC_X]ecExitCode5
<HomelessDemographics>
37	<Homeless>	This identifies if the student is considered homeless.	[S_MI_STU_GC_X]homelessStatus
38	<UnaccompaniedYouth>	This identifies if the student is considered an unaccompanied youth.	[S_MI_STU_GC_X]flagUnacYouth
<SNE>
39	<SupplementalNutritionEligibility>	This contains the student’s lunch status eligibility.	[Students]LunchStatus [S_MI_STU_GC_X]lunchStatus_Override
<ProgramParticipation>
40	<ProgramEligibilityParticipation>	This contains all of the program eligibility codes for the student.	[S_MI_STU_GC_X]flagTitle1 [S_MI_STU_GC_X]flagSection504 [S_MI_STU_GC_X]flagAlternateEd [S_MI_STU_GC_X]flagDevRedKinder [S_MI_STU_GC_X]flagOutOfState [S_MI_STU_GC_X]flag21CCLC [S_MI_STU_GC_X]flagInternational [S_MI_STU_GC_X]flagExchangeStu [S_MI_STU_GC_X]flagImmFunding [S_MI_STU_GC_X]flagEarlyCollege [S_MI_STU_GC_X]flagSeatTimeWaiver [S_MI_STU_GC_X]flagAtRisk [S_MI_STU_GC_X]homelessSchool
<SeclusionandRestraint>
41	<DateOccurred>	This contains of seclusion and restraint for the student.	[S_MI_STU_SECREST_C]SecRestDate
42	<NumberSecluded>	This contains the number of times the student was secluded.	[S_MI_STU_SECREST_C]secludedcount
43	<NumberRestrained>	This contains the number of times the student was restrained.	[S_MI_STU_SECREST_C]restrainedCount

Back to Top