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.

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.

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.

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.

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 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).

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.

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


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.

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.