Skip to main content
Skip table of contents

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 studentsSelect 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 and Expelled StudentsSelect Yes to limit the discipline to special education 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.

[Students]ExitCode

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

<ThirdGradeRetentionDecision>


144<EndofTermStatus>This contains the nature of the student's progress at the end of a given school term. Reported for Fall and EOY Collections. [S_MI_STU_GC_X]EndofTermStatus
145<PromotionReason>This contains the nature of the student's promotion at the end of the given school year. Reported for Fall and EOY Collections. [S_MI_STU_GC_X]PromotionReason

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

<ThirdGradeRetentionDecision>
136<EndofTermStatus>This contains the nature of the student's progress at the end of a given school term.[S_MI_STU_GC_X]EndofTermStatus
137<PromotionReason>This contains the nature of the student's promotion at the end of the given school year[S_MI_STU_GC_X]PromotionReason

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



JavaScript errors detected

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

If this problem persists, please contact our support.