This article serves as a guide to where the data elements for Michigan State Reporting can be found in Illuminate.
Each component is listed and described below. Where appropriate, logic is provided in an effort to help users understand how data is pulled into extracts for state reporting.
Please refer to the MSDS Collection Details Manual for specific information about components, characteristics, and submission rules.
If you have additional questions about where data is extracted from for state reporting you can reach us via e-mail at help@illuminateed.com.
Adult Ed Funding
Support coming soon.
Adult Ed Count Period
Support coming soon.
Adult FTE
Support coming soon.
Adult FTE Program Code
Support coming soon.
Diploma Status
Support coming soon.
Eligibility Exception
Support coming soon.
Days Attended
Days Attended is a sum of all of the "Present" attendance flags during the count period.
If a student has at least one "Present" flag during a day he/she will be reported as "Present" for the full day.
Total Possible Attendance
Total Possible Attendance is a sum of all the "In Session" days during the count period.
Incident ID
The Incident ID is an automatically generated ID associated with the incident. This value is not editable.
Date of Incident
The Date of Incident is reported from the "Date" field associated with the Incident.
Incident Type
The Incident Type is reported from the "Ed Code Violations" field associated with the Incident.
Note: The Incident that gets reported is based off severity of the violation. Lower values indicate higher severity. If multiple incidents exist with the same severity then assignment for state reporting will be random.
Serious Bodily Injury
The Serious Bodily Injury flag is generated for a discipline incident that indicates serious bodily injury.
Note: Incident Type must = code "60" for this to be pulled.
Sexual Assault
The Sexual Assault flag is generated for a discipline incident that indicates Sexual Assault.
Note: Incident Type must = "60" or "61" for this to be pulled.
Initial Consequence Type
The Initial Consequence Type is generated from the "Type" when a consequence is added to an incident.
Note: Only consequence "Type" values with a state code mapping will be included for state reporting.
Initial Days
Initial Days is generated from the "Days" field when adding a consequence.
Initial Start Date
The Initial Start Date is generated from the "From" date field when adding a consequence.
Secondary Consequence Type
The Secondary Consequence Type is generated the same way as the Initial Consequence Type.
Note: The Secondary Consequence Type that is pulled in the extract is the second sequential consequence added to an incident. Only consequence "Type" values with a state code mapping will be included for state reporting.
Secondary Days
Secondary Days are generated the same way as Initial Days only they are pulled from the second sequential consequence added to an incident.
Secondary Start Date
The Secondary Start Date is generated the same way as Initial Start Date only it is pulled from the second sequential consequence added to an incident.
Other Consequence Type
The Other Consequence Type is generated the same way as the Initial Consequence Type.
Note: The Other Consequence Type that is pulled in the extract is the third sequential consequence added to an incident. Only consequence "Type" values with a state code mapping will be included for state reporting.
Other Days
Other Days are generated the same way as Initial Days only they are pulled from the third sequential consequence added to an incident.
Other Start Date
The Other Start Date is generated the same way as Initial Start Date only it is pulled from the third sequential consequence added to an incident.
Follow Up
Follow Up is generated from the Follow-Up Service associated with an Incident.
Note: Only Follow-UP Services with a state code mapping will be reported.
Fiscal Entity Type Code
Support coming soon.
Fiscal Entity Code
Support coming soon.
School Facility Number
The School Facility Number = "State Site ID" under Admin Gear-> Site Management
EC Program
EC Program is generated from the "Enrollment" field in Special Ed tab-> Early Childhood Programs
Note: Only Programs with a state code mapping will be reported
EC Program Start Date
EC Program Start Date is generated from the Enrollment field in Special Ed tab-> Early Childhood Programs
EC Delivery Method
EC Delivery Method is generated from the "Delivery Method" field in Special Ed tab-> Early Childhood Programs
Note: Only programs with a state code mapping will be reported.
EC Delivery Schedule
EC Delivery Schedule is generated from the "Delivery Schedule" field in Special Ed tab-> Early Childhood Programs
Note: Only schedules with a state code mapping will be reported.
EC Program End Date
EC Program End Date is generated from the "End Date" field in Special Ed tab-> Early Childhood Programs
EC Program Exit Reason
EC Exit Reason is generated from the "Exit Reason" field in Special Ed tab-> Early Childhood Programs
Note: Only reasons with a state code mapping will be reported.
EC Funding Type
Assessment Tool
The Assessment Tool can be found under Special Ed Tab-> Early Childhood Assessment (3-5 yr olds).
Note: Only tools with a state code mapping will be reported.
Other Tool Comments
Other Tool Comments are reported from the "Other Description" field in an Early Childhood Assessment.
Note: This field will only be available if "Other" is selected in the "Assessment Tool" field.
Entry Assessment Date
The Entry Assessment Date is generated from the "Entry Assessment Date" field on an Early Childhood Entry Assessment.
Exit Assessment Date
The Exit Assessment Date is generated from the "Exit Assessment Date" field associated with the Early Childhood Exit Assessment.
Outcome 1A
Outcome 1B
Outcome 2A
Outcome 2B
Outcome 3A
Outcome 3B
Service Coord Agency
The Service Coord Agency is generated from the "Service Coordinating Agency" field under the Special Ed Tab-> Early On
Note: Only agencies with a state code mapping will be reported.
Primary Service Setting
The Primary Service Setting is generated from the "Primary Service Setting" field under the Special Ed Tab-> Early On
Service Code
Service Codes are generated by publishing IFSPs. Early On services that overlap the count window will be reported.
Current IFSP Date
The Current IFSP Date is listed in the Special Ed Tab-> Early On.
Note: This date is updated by publishing IFSPs in Illuminate. IF you are using the electronic IFSP, the IFSP Date from the most recently published IFSP will ALWAYS supersede the IFSP Date under Special Ed Tab-> Early On as seen in this screenshot.
Timely Start of Service
Timely Start of Service is generated from the "Timely Start of Service" field under the Special Ed Tab-> Early On link.
Note: Untimely services is the default setting.
Part C Exit Reason
The Part C Exit Reason is generated from the "Early On Exit Reason" field under the Special Ed Tab-> Early On link.
Note: Only reasons with a state code mapping will be reported.
Part C Exit Date
The Part C Exit Date characteristic is generated from the "Early On Exit Date" field under the Special Ed Tab-> Early On link.
Transition IFSP
The Transition IFSP characteristic is generated from the "Transition IFSP Timeliness" field under the Special Ed Tab-> Early On Transition link.
Transition Conference
The Transition Conference characteristic is generated from the "Transition Conference Timeliness" field under the Special Ed Tab-> Early On Transition link.
Enrollment Date
The Enrollment Date characteristic is generated by comparing the "District Enter Date" in Students-> Demographic Details to the student's enrollment history.
The date that will be submitted for reporting will be the oldest record.
Ex 1. If the District Enter Date is less than the oldest enrollment record for the district then the District Enter Date will be reported.
Ex 2. If the student's Enrollment History reflects an enrollment at the district that is less than the District Enter Date then the date on the enrollment record will be reported.
District Exit Status
Rules for determining Exit Status characteristic are as follows:
1. Does student have overlapping district enrollment w/exit outside selected date range? If true, no exit will be reported.
2. Did student exit during date range selected? If Yes, report exit code and date from enrollment history.
3. Was student flagged as no show during date range? If Yes, exit code from no show record and report first day of school year as exit date.
4. If student had prior district enrollment on "Enrollment look back" use exit date and code from that enrollment record.
5. If all rules are gone through and exit is blank, code "19" expected to continue is assumed.
District Exit Date
Rules for determining District Exit Date characteristic are as follows:
1. Does student have overlapping district enrollment w/exit outside selected date range? If true, no exit will be reported.
2. Did student exit during date range selected? If Yes, report exit code and date from enrollment history.
3. Was student flagged as no show during date range? If Yes, exit code from no show record and report first day of school year as exit date.
4. If student had prior district enrollment on "Enrollment look back" use exit date and code from that enrollment record.
5. If all rules are gone through and exit is blank, code "19" expected to continue is assumed.
General Ed FTE
The Gen Ed FTE characteristic can be found on the Special Ed Tab-> Student FTE Details.
The General Ed FTE is generated by comparing the students time in general education with the time (if any) in special education programs to the total number of clock hours and instructional weeks at a school.
Note: Total Building Clock Hours and Instructional Weeks must be set under Admin Gear-> Site Management
Homeless
The Homeless characteristic is generated from the "Homeless Dwelling Type" under Special Ed Tab-> Student Demographics.
Note: The dwelling type must have a state code to be reported.
Unaccompanied Youth
The Unaccompanied Youth characteristic is generated from the Students Tab-> Homeless Details link.
Date of Parental Consent
The Date of Parent Consent characteristic is generated from the "Parental Consent Date" field on the Special Ed Tab-> Student Status link.
Date of Parental Consent
The Date of Parent Consent characteristic is generated from the "Parental Consent Date" field on the Special Ed Tab-> Student Status link.
Initial IEP Completion Date
The Initial IEP Completion Date is generated from the "Publish Date" on an Initial IEP on the IEP Details screen.
Timeliness of Initial IEP
Timeliness of Initial IEP is generated from the "Referral Parental Consent" field on the Special Ed Tab-> Student Status link.
Result of Initial IEP
The Result of Initial IEP characteristic is generated from the "IEP Result" field under the Special Ed Tab-> Student Status link.
Days Beyond Timeline
The Days Beyond Timeline characteristic is generated from the "Number of Days Past Consent/Extension Date" field under the Special Ed Tab-> Student Status link.
Part C Transition Timeliness
The Part C Transition Timeliness characteristic is generated fromt the "Early On Transition Timeliness" field under the Special Ed Tab-> Student Status link.
Referral Date
The Referral Date is generated from the "Referral Date" field under the Special Ed Tab-> Initial IFSP link.
Referral Agency
The Referral Agency is generated from the "Referral Source" field under the Special Ed Tab-> Initial IFSP link.
IFSP Timeliness
The IFSP Timeliness characteristic is generated from the "Timeliness" field under the Special Ed Tab-> Initial IFSP link.
Result of Initial IFSP
The Result of Initial IFSP characteristic is generated from the "IFSP Result" field under the Special Ed Tab-> Initial IFSP link.
Initial IFSP Date
The Initial IFSP Date is generated from the "Initial IFSP Date" field under the Special Ed Tab-> Important Dates link.
LEP Funding Participation
The LEP Funding Participation characteristic is generated from the "EL Program Participation" field under the Language Tab-> Language Details link.
LEP Instructional Program
The LEP Instructional Program characteristic is generated from the "English Proficiency" field under the Language Tab-> Language Details link.
Home Language
The Home Language characteristic has two sources. Data for this characteristic is pulled from both the "Home Language" field under the Language Tab-> Language Details and the "Primary Language" field under the Students Tab-> Demographic Details.
Note: Both will be reported if both are populated.
LEP Exit Reason
Support coming soon.
LEP Exit Date
The LEP Exit Date characteristic is drawn from the "Reclassification Date" field under the Language Tab-> Language Details link.
LEP Re-Entry Date
The LEP Re-Entry Date is generated from the "LEP Date" under the Language Tab-> Language Details link; however, this date is only reported when the "LEP Date" is greater than the "Reclassification Date."
Date of Count
The Date of Count = the "End Date" when generating the extract under Reports Tab-> State Reporting-> Select an extract by clicking on the respective link.
Student Residency
The Student Residency characteristic is drawn from the "Residential Status" field under the Special Ed Tab-> Student Demographics link.
Ten 30 Day Rule
Support coming soon.
Math Test Type
The Math Test Type is drawn from the "Math Test Type" field under the Students Tab-> OEAA Assessment link.
Math Group Code
The Math Group Code is drawn from the "Math Group Code" field under the Students Tab-> OEAA Assessment link.
Math Research Code 1
The Math Research Code 1 is drawn from the "Math Research Code 1" field under the Students Tab-> OEAA Assessment link.
Math Research Code 2
The Math Research Code 2 is drawn from the "Math Research Code 2" field under the Students Tab-> OEAA Assessment link.
Reading Test Type
The Reading Test Type is drawn from the "Reading Test Type" field under the Students Tab-> OEAA Assessment link.
Reading Group Code
The Reading Group Code is generated from the "Reading Group Code" field under the Students Tab-> OEAA Assessment link.
Reading Research Code 1
The Reading Research Code 1 is generated from the "Reading Research Code 1" field under the Students Tab-> OEAA Assessment link.
Reading Research Code 2
The Reading Research Code 1 is generated from the "Reading Research Code 1" field under the Students Tab-> OEAA Assessment link.
Writing Test Type
The Writing Test Type is generated from the "Writing Test Type" field under the Students Tab-> OEAA Assessment link.
Writing Group Code
The Writing Group Code is generated from the "Writing Group Code" field under the Students Tab-> OEAA Assessment link.
Writing Research Code 1
The Writing Research Code 1 is generated from the "Writing Writing Research Code 1" field under the Students Tab-> OEAA Assessment link.
Writing Research Code 2
The Writing Research Code 2 is generated from the "Writing Writing Research Code 2" field under the Students Tab-> OEAA Assessment link.
Science Test Type
The Science Test Type is generated from the "Science Test Type" field under the Students Tab-> OEAA Assessment link.
Science Test Code
The Science Test Type is generated from the "Science Test Type" field under the Students Tab-> OEAA Assessment link.
Science Research Code 1
The Science Research Code 1 is generated from the "Science Research Code 1" field under the Students Tab-> OEAA Assessment link.
Science Research Code 2
The Science Research Code 2 is generated from the "Science Research Code 2" field under the Students Tab-> OEAA Assessment link.
Social Studies Test Type
The Social Studies Test Type is generated from the "Social Studies Test Type" field under the Students Tab-> OEAA Assessment link.
Social Studies Test Code
The Social Studies Test Code is generated from the "Social Studies Test Code" field under the Students Tab-> OEAA Assessment link.
Social Studies Research Code 1
The Social Studies Research Code 1 is generated from the "Social Studies Research Code 1" field under the Students Tab-> OEAA Assessment link.
Social Studies Research Code 2
The Social Studies Research Code 2 is generated from the "Social Studies Research Code 2" field under the Students Tab-> OEAA Assessment link.
ELA Test Type
The ELA Test Type is generated from the "ELA Test Type" field under the Students Tab-> OEAA Assessment link.
ELA Group Code
The ELA Test Code is generated from the "ELA Test Code" field under the Students Tab-> OEAA Assessment link.
ELA Research Code 1
The ELA Research Code 1 is generated from the "ELA Research Code 1" field under the Students Tab-> OEAA Assessment link.
ELA Research Code 2
The ELA Research Code 2 is generated from the "ELA Research Code 2" field under the Students Tab-> OEAA Assessment link.
SEA Notification
The SEA Notification characteristic is generated from the "State (SEA) Notification" flag under the Special Ed Tab-> Early On Transition link.
LEA Notification
The LEA Notification characteristic is generated from the "Local (LEA) Notification" flag under the Special Ed Tab-> Early On Transition link.
Parent Last Name
Parent First Name
Parent Street Address
Parent Street Address 2
Parent City
Parent State
Parent Zip Code
Parent Phone Number
Parent Address Unknown
Support coming soon.
Parent Phone Unknown
Support coming soon.
Data Source
The Data Source can be found under Special Ed Tab-> Early On Assessment (birth-2 yr olds).
Note: Only sources with a state code mapping will be reported.
Other Source Comments
The Other Source Comments can be found under Special Ed Tab-> Early On Assessment (birth-2 yr olds).
Note: This characteristic is ONLY available when "Other" has been selected as a "Data Source."
Assessment Date
The Assessment Date can be found under Special Ed Tab-> Early On Assessment (birth-2 yr olds).
Assessment Type
The Assessment Type can be found under Special Ed Tab-> Early On Assessment (birth-2 yr olds).
Parent Input
The Parent Input characteristic can be found under Special Ed Tab-> Early On Assessment (birth-2 yr olds).
Parent Input Date
The Parent Input Date can be found under Special Ed Tab-> Early On Assessment (birth-2 yr olds).
Social Relationships
The Social Relationships characteristic can be found under Special Ed Tab-> Early On Assessment (birth-2 yr olds).
New Social Relationships
The New Social Relationships characteristic can be found under Special Ed Tab-> Early On Assessment (birth-2 yr olds).
Knowledge Skills
The Knowledge Skills characteristic can be found under Special Ed Tab-> Early On Assessment (birth-2 yr olds).
New Knowledge Skills
The New Knowledge Skills characteristic can be found under Special Ed Tab-> Early On Assessment (birth-2 yr olds).
Actions
The Actions characteristic can be found under Special Ed Tab-> Early On Assessment (birth-2 yr olds).
New Actions
The New Actions characteristic can be found under Special Ed Tab-> Early On Assessment (birth-2 yr olds).
UIC
The UIC is drawn from the "SSID" field under the Students Tab-> Demographic Details link.
Student Last Name
The Student Last Name is drawn from the "SSID" field under the Students Tab-> Demographic Details link.
Student First Name
The Student First Name is drawn from the "SSID" field under the Students Tab-> Demographic Details link.
Student Middle Name
The Student Middle Name is drawn from the "SSID" field under the Students Tab-> Demographic Details link.
Student Suffix
The Student Suffix is drawn from the "SSID" field under the Students Tab-> Demographic Details link.
Date of Birth
The Student Date of Birth is drawn from the "SSID" field under the Students Tab-> Demographic Details link.
Multiple Birth Order
The Multiple Birth Order characteristic is drawn from the "SSID" field under the Students Tab-> Demographic Details link.
Gender Code
The Gender Code characteristic is drawn from the "SSID" field under the Students Tab-> Demographic Details link.
Personal Curriculum Credit Modification
The Personal Curriculum Credit Modification characteristic is generated from the "Personal Curriculum Subject Area" field under the Students Tab-> Personal Curriculum link.
Personal Curriculum Type
The Personal Curriculum Credit Modification characteristic is generated from the "Personal Curriculum Subject Area" field under the Students Tab-> Personal Curriculum link.
Resident LEA Number
The Resident LEA Number is pulled from the "Resident District" field under the Special Ed Tab-> Student Demographics link.
Student Resident County
The Student Resident County is pulled from the "Resident County" field under the Students Tab-> Demographic Details link.
Country of Birth
The Country of Birth is pulled from the "Birth Country" field under the Students Tab-> Demographic Details link.
Year of Entry
Street Address
Street Address 2
City
State
Zip Code
Racial Ethnic Code
Phone Number
Grabs phone number from contact associated with primary household in contacts - phone type has to be flagged as "H" for home \
Program Eligibility Participation
The Program Eligibility Participation characteristic is generated from the programs in which a student is participating.
Programs can be found under the Students Tab-> Programs
Note: Program dates must overlap the count period and only sources with a state code mapping will be reported. A record will be produced in the extract for each program in which the student participates. Title I is not included in the Program Eligibility Participation characteristic.
Operating ISD ESA Number
The Operating ISD ESA Number is pulled from the "State Site ID" field for the ISD "Site Type" under the Admin Gear-> Site Management
Operating District Number
The Operating District Number pulls the "State Site ID" associated with the district for which the extract is being run. This will cross reference enrollment looking for an enrollment record that overlaps the count period.
School Facility Number
The School Facility Number pulls the "State Site ID" associated with the district for which the extract is being run. This will cross reference enrollment looking for an enrollment record that overlaps the count period and will report the State Site ID associated with that building.
Local Student ID
The Local Student ID characteristic is generated from the "Student Id" field under the Students Tab-> Demographic Details link.
Grade Setting
The Grade Setting characteristic is pulled from the enrollment record associated with the site at which the extract is being run.
Enrollment records can be found under Students Tab-> Student Enrollment History
Note: The enrollment record must overlap the count period.
S2E2 Code
The S2E2 Code characteristic is generated from the "S2E2 Code" field under Admin Gear-> Site Management.
Month Claimed
Support coming soon.
Program Start Date
Support coming soon.
First Day In Attendance
Support coming soon.
Supplemental Nutrition Eligibility
Supplemental Nutrition Eligibility is reported from lunch programs with dates overlapping the count period.
Primary Disability
The Primary Disability characteristic is pulled from the Special Ed Tab-> Student Primary Disability View link.
Note: These values are automatically generated as IEPs are created in Illuminate.
Secondary Disability
The Secondary Disability characteristic is pulled from the Special Ed Tab-> Student Secondary Disability View link.
Note: These values are automatically generated as IEPs are created in Illuminate.
IEP Date
The IEP Date = the "Publish Date" of the most recently published IEP.
Support Services
Support Services are reported from the Special Ed Tab-> Student Support Service Details link.
Only services that overlap the count period will be reported.
Note: Support Services are automatically generated by publishing an IEP and only programs with a state code will be reported.
Program Service Code
The Program Service Code characteristic is reported from the Special Ed Tab-> Student Program Code Details link.
Only programs that overlap the count period will be reported.
Note: Programs are automatically generated by publishing an IEP and only programs with a state code will be reported.
Primary Educational Setting
The Primary Educational Setting is pulled from the "Instructional Setting" field under the Special Ed Tab-> Student Demographics link.
Placed By Another District IEP
The Placed by Another District IEP characteristic is generated from the "Placed by Another District IEP" field under the Special Ed Tab-> Student Demographics link.
SpecEd Exit Reason
The SpecEd Exit Reason is generated based on the following rules:
If a student has an ineligible IEP or IFSP during the count period = True, then Code "30"
If a student has a parent revocation of an IEP or IFSP during the count period = True, then Code "30"
If both of the above = False, then no SpecEd Exit Reason is reported.
SpecEd Exit Date
The SpecEd Exit Date = Date of Ineligible IEP/IFSP or Date of Parent Revocation
Section 52 FTE
Section 52 FTE is reported if the "Section 53" field is flagged "No" under the Special Ed Tab-> Student Demographics link.
The FTE is determined by dividing the sum of the program hours by the ratio of clock hours to instructional weeks (i.e., Sum of Program Hours/(Total Building Clock Hours/Instructional Weeks).
Section 53 FTE
Section 53 FTE is reported if the "Section 53" field is flagged "Yes" under the Special Ed Tab-> Student Demographics link.
The FTE is determined by dividing the sum of the program hours by the ratio of clock hours to instructional weeks (i.e., Sum of Program Hours/(Total Building Clock Hours/Instructional Weeks).
Below is an attachment of the Student Course schema:
Subject Area Code
Course Identifier Code
Support coming soon.
Local Course ID
Local Course Title
Course Section ID
This is an internally generated course ID. This is not editable.
Course Type
All courses are currently being reported as 01 "Regular" courses.
Academic Year
The Academic Year characteristic is generated from the Academic Year in which the course was offered (this is inferred from start/end dates selected when generating the extract).
Credits Granted
Support coming soon.
Course Grade
Support coming soon.
Completion Status
The Completion Status characteristic inferred from the student's end date in the course, and whether student was "Ungraded."
PIC
The PIC is pulled from the "State Educator ID" field under the Admin Gear-> User Management
Virtual Method
The "Virtual Method" characteristic will no longer be pulling from the section, but at the course level. This will be populating from the "Course Designation." The values accepted by the state have already been added.
While you are still able to use the course designation field, please note the only values pulled into the state extract will be those with the "msds" system_key.
Mentor Teacher
The Mentor Teacher characteristic is drawn from the "Mentor Teacher" flag associated with a section offered during the count period.
As of Date
As of Date is generated based on the following rules:
If a student has exited, the As of Date = the Exit Date for the student under Students-> Enrollment History
If a student does not have an exit date, the As of Date = the "End Date" selected when generating the extract.\
Submitting Entity Type Code
The Submitting Entity Type Code = the "Site Type" of the site selected when generating the extract.
Note: "B" is generated for buildings, "D" is generated for districts.
Submitting Entity Code
The Submitting Entity Code = the "State Site ID" of the site selected when generating the extract.
TAS Instructional Services
The TAS Instructional Services characteristic is pulled from the Sub Program assigned to a student under Students Tab-> Programs
Note: Only sources with a state code mapping will be reported. The Value of the sub-program code determines which characteristic the data appears under. Only codes 6011 and 6017 are treated as Instructional Services. All others are treated as Support Services.
TAS Support Services
The TAS Support Services characteristic is generated from the Sub Program assigned to a student under the Students Tab-> Programs.
Note: Only sources with a state code mapping will be reported. The Value of the sub-program code determines which characteristic the data appears under.
Next Steps
If you have questions about specific data in each component please refer to the MSDS Collection Details Manual available at http://www.michigan.gov/cepi/0,1607,7-113-986_50502---,00.html
If you have additional questions about where data is extracted from for state reporting you can reach us via e-mail at help@illuminateed.com or by telephone at (517) 224-4499.
Comments
0 comments
Please sign in to leave a comment.