Tool Search: MSDS
The Early Childhood Extract reports any student receiving services through an agency or program funded by the State of Michigan.
MSDS Early Childhood EditorSnapshot / Certification Dates
The following table describes the due dates for taking a snapshot of data and certifying it before submission to the state.
Snapshot Due Date | Data Certified Date |
|---|---|
November 17th | December 8th |
February 9th | February 23rd |
June 30th | July 13th |
August 24th | August 31 |
Report Logic
The following describes reporting logic:
- A record will be reported for any student with an active enrollment record within the date range entered on the extract editor. The most recent enrollment record before the Count Date is used.
- Students must have an active Early Childhood program within the date range entered on the extract editor.
- The fields in the EC Programs component will report for each active program during the date range.
- Students whose program End Date is before the Previous Count Date will not be included in the extract.
- Students with an Early Childhood Program of 11 do not report.
Generating the Report
- Select the Early Childhood Extract Type.
- Enter the Count Date in mmddyyyy format or by clicking the calendar icon and selecting a date. A data snapshot will be taken as it exists on the date entered.
- Enter the Previous Count Date in mmddyyyy format or by clicking the calendar icon and selecting a date. This date correlates with the Count Date entered. Student data will report within the date range entered in these two fields.
- Check the Students w/o UICs checkbox, if desired. Checking this checkbox means only those students within the selected calendar(s) who do not have a State ID assigned will be reported. Leaving this checkbox unmarked means all students within the selected calendar will be eligible for reporting.
- Select the Submitting Entity. This describes the entity submitting the extract to the state.
- Select the Format. For submission to the state, use the State Format (XML).
- Select an Ad hoc Filter to limit records reported. When an Ad hoc Filter is selected, the report is based on the options selected in the editor, not the Campus toolbar.
- Check the Validate checkbox, if desired. Checking this checkbox means Infinite Campus will run a check on the XML data to validate that it is correct. If errors are found, the extract will list these errors for correction based on the schema.
For guidance in validating the XML file against your state's schema using a free, third-party program, see the Validating an XML File Against a Schema File article.
- Select which Calendar(s) to include within the extract.
- Click Generate Extract to generate the report in the indicated format, or click Submit to Batch to schedule when the report will be generated.
Users can submit a report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to be generated in the background without disrupting the use of Campus. See the Batch Queue article for more information about submitting a report to the batch queue.
Early Childhood Extract Layout
Element | Description & Format | Location |
|---|---|---|
| Submitting Entity | ||
Submitting Entity Type Code | A code used by the system to identify which type of entity code will be reported in the Submitting Entity Code column. Alphanumeric, 1 character | MSDS Extracts > Submitting Entity Not dynamically stored |
Submitting Entity Code | The entity responsible for the certification of the collection (if applicable). Alphanumeric, 10 characters | Enrollments > State Reporting Fields > School Override Scool Information > School > State School Number District.districtID |
| Personal Core | ||
UIC | The student's Unique Identification Code (UIC), also known as the State ID. Numeric, 10 characters | Demographics > Person Identifiers > Student State ID Person.stateID |
Last Name | The student's legal last name. Alphanumeric, 25 characters | Demographics > Last Name Identity.lastName |
First Name | The student's legal first name. Alphanumeric, 15 characters | Demographics > First Name Identity.firstName |
Middle Name | The student's middle name or initial. Alphanumeric, 25 characters | Demographics > Middle Name Identity.middleName |
Suffix | The abbreviated name suffix that follows a student's full name and provides additional information about the student. Alphanumeric, 9 characters | Demographics > Suffix Identity.suffix |
Date of Birth | The student's date of birth. Date field, 10 characters | Demographics > Person Information > Birth Date Identity.birthDate |
Multiple Birth Order | Indicates the student is part of a multiple birth. This field is intended to provide some distinguishing data for cases where the cultural practice is to provide twins (triplets, etc) of the same gender with the same first name, or where children of the same gender have similar first names. Alphanumeric, 1 character | MSDS > Multiple Birth Order Enrollment.multipleBirth |
Gender | The student's gender. Alphanumeric, 1 character | Demographics > Person Information > Gender Identity.gender |
| Personal Demographics | ||
Resident LEA Number | State assigned, five digit code for the district in which the student resides. Numeric, 5 digits | Enrollments > State Reporting Fields > Resident District Enrollment.residentDistrict |
Student Resident County Code | Primary county code in which the child resides. Numeric, 2 digits | Addresses > Address Info > County Address.county |
Ethnicity | The student's race ethnicity.
Numeric, 6 digits | Demographics > Race Ethnicity Identity.raceEthnicity |
| Contacts | This component is not reported if the Homeless component is reported for a student. An address is reported if the student has an active Household address prior to the Count Date that is marked as Physical and is not marked as Secondary. An address is also reported if the student has an active household address with Secondary and Mailing marked. If more than one address that meets report criteria is found, reports the address that includes a household relationship to the student with Guardian marked and the lowest Emergency Priority number. If multiple Guardians or no Guardians are found, reports the address with the highest record ID. Additionally, reports any Physical Address that have a relationship of Mother, Father, or Other if the student has a locked IFSP active during the extract date range. | |
| Address Type Descriptor | The type of address being reported. Reports as Physical if the student has an active household address with Physical marked. Reports as Mailing if the student has an active household address with Secondary and Mailing marked. Alphanumeric | Household > Address > Physical, Mailing Address.physical Address.mailing |
| Street Number Name | The number and name of the address being reported. Reports Number + Prefix + Street + Tag + Direction. Alphanumeric,100 characters | Households > Address Info Address.number |
| Apartment Room Suite Number | Reports additional address information, such as apartment, room, suite, or lot number. | Households > Addresses > Apt Address.apt |
| City | The city or town of the address. Alphanumeric, 50 characters | Households > Address Info > City Address.city |
| State Abbreviation Descriptor | The abbreviation of the state of the address. Alphanumeric, 2 characters | Households > Address Info > State Address.state |
| Postal Code | The 5 or 9 digit zip code of the address. Numeric, 10 digits | Households > Address Info > Zip Address.zip |
| Telephone Number | The primary telephone number of the student's parent or guardian. Reports the household Phone Number | Households > Phone Address.phone |
| Electronic Mail Address | The email address of the student's parent or guardian. Only reports if the record has a relationship of Mother, Father, or Other and the student has a locked IFSP active during the extract date range. Alphanumeric | Demographics > Personal Contact Information > Email Contact.email |
Fiscal Entity Type Code | Entity type as indicated in SCM/EEM for the Fiscal Entity Code. Will always report as D. Alphanumeric, 1 character | Not dynamically stored |
Fiscal Entity Code | Reports the Fiscal Entity Code, which is the state-assigned code identifying the entity receiving funds from the state to provide services to this student. If null, reports the State District Number. Numeric, 10 characters | Program Participation > Early Childhood > Fiscal Entity Code; System Administration > Resources > District Information > State District Number MIEarlyChildhood.fiscalEntity1 |
| Fiscal Entity Code 2 | Reports the Fiscal Entity Code 2, if entered. If null, this field does not report. | Program Participation > Early Childhood > Fiscal Entity Code2 MIEarlyChildhood.fiscalEntity2 |
| EC Programs | ||
School Facility Number | The state-assigned number in the official Educational Entity Master (EEM). Numeric, 5 digits | Enrollments > State Reporting Fields > School Override; System Administration > Resources > School > State School Number School.schoolNumber |
| Provider License Number | Reports the Provider License Number Override entered on the student's Early Childhood tab, if entered. Otherwise reports the EC Provider License Number. Numeric, 11 digits | Program Participation > Early Childhood > Provider License Number Override; System Administration > Resources > School > EC Provider License Number MIEarlyChildhood.licenseNumber School.providerNumber |
| EC Comment | Reports the EC Comment entered on the Early Childhood tab, or as null if blank. Alphanumeric, 50 characters | Program Participation > Early Childhood > EC Comment MIEarlyChildhood.comment |
EC Program | Indicates the early childhood program(s) in which the child is participating in.
Numeric, 2 digits | Program Participation > Early Childhood > Program MIEarlyChildhood.program |
EC Program Start Date | Date child first received services with this program. Date field, 10 characters | Program Participation > Early Childhood > Start Date MIEarlyChildhood.startDate |
EC Delivery Method | Primary location where services are provided.
Numeric, 1 digit | Program Participation > Early Childhood > Delivery Method MIEarlyChildhood.deliveryMethod |
EC Delivery Schedule | Indicates when the student receives programming.
Numeric, 2 digits | Program Participation > Early Childhood > Delivery Schedule MIEarlyChildhood.daysPerWeek |
| Federal Poverty Level Quintile | Indicates the Federal Poverty Level quintile to which the student belongs. Numeric, 2 digits | Program Participation > Early Childhood > Federal Poverty Level Quintile MIEarlyChildhood.povertyLevel |
| Additional Eligibility Factor | Additional factors used to determine a child’s eligibility for a Great Start Readiness Program, along with income information collected in the Federal Poverty Level Quintile (FPLQ) characteristic. Reports Additional Eligibility Factors selected on the student's Early Childhood tab. Numeric, 2 digits | Program Participation > Early Childhood > Additional Eligibility Factors MIEarlyChildhood.addEligFactors |
| Qualifying Factor | Additional factors used to determine a child’s eligibility for a Great Start Readiness Program, along with income information collected in the Federal Poverty Level Quintile (FPLQ) characteristic. Reports the Qualifying Factors selected for the student. Alphanumeric, 1 character | Program Participation > Early Childhood > Qualifying Factors MIEarlyChildhood.qualFactors |
EC Program End Date | Date child last received services with this program, and exited the program. Date field, 10 characters | Program Participation > Early Childhood > End Date MIEarlyChildhood.endDate |
EC Program Exit Reason | Reason child exited the program.
Numeric, 3 digits | Program Participation > Early Childhood > Exit Reason MIEarlyChildhood.exitReason |
| Homeless Demographics | Reports if the student has an active homeless record on or between the Count Date and Previous Count Date with a Primary Nighttime Residence selected. | |
Homeless | Indicates student's Primary Nighttime Residence. Numeric, 2 digits | Program Participation > Homeless Homeless.primaryNightTimeResidence |
Unaccompanied Youth | Indicates the student meets Federal requirements for unaccompanied youth status. This field will only report if the student is reported as Homeless. Bit character, 1 digit | Enrollment > State Reporting Fields > Unaccompanied Youth Enrollment.mvUnaccompaniedYouth |
| SNE | ||
Supplemental Nutrition Eligibility | The student's eligibility status for free or reduced-price meal/milk program for the current school year. Reports the lowest number from any eligibility status tied to the reported calendar year. If Eligibility = paid or null, reports as null. Bit character, 1 digit | FRAM > Eligibility > Eligibility POSEligibility.eligibility |
| Program Participation | ||
| Program Eligibility Participation | Identifies the type of categorical program or service which the student is eligible for or participates in. Program Reporting
Title I Programs Reporting If the Title 1 Program is active on or between the Count Date and Previous Count Date and has at least one Instructional Service or Support Service, reports '6010'.
Military Connections Military Connections Reporting If the student has a relationship with a Guardian with an active Military Connections record on or between the Previous Count Date and Count Date, report '9140'.
Numeric, 4 digits
| Student Information > Program Participation > Programs Program Admin > Programs > Code, State Reported People > Military Connections Calculated |
| Seclusion and Restraint | This component reports if the student has any incidents between the Previous Count Date and the Count Date with a Response Type of Seclusion or Restraint marked. | |
| Date Occurred | Reports the date of the Incident. Datefield, 10 characters | Behavior Management > Incident > Date of Incident BehaviorIncident.date |
| Number Secluded | Reports the total number of times the student has a behavior response of Seclusion. Numeric | Behavior Management > Behavior Response BehaviorResponseType.responseType |
| Number Restrained | Reports the total number of times the student has a behavior response of Physical Restraint. Numeric | Behavior Management > Behavior Response BehaviorResponseType.responseType |
