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
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.
- The student is in Grade Level 13.
*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.
- The student is in Grade Level 13.
*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).
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:
|
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. |
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 |
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 |
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 |