Student Enrollment
This resource publishes the student's enrollment information.
The students that are published must NOT be excluded from state reporting.
The school must not be excluded from reporting. No students will be published from a school that is excluded from reporting.
This resource is updated to support sub-district capabilities in MS MSIS 2.0 for charter schools and includes publishing of the correct District and School references across the system. For more information, refer to the Additional Setup for Charter Schools section. The resource is updated to ensure that the district number is propagated correctly.
Element Name | Submission | Definition | Code Set, if applicable | Technical Name | [Table]Field Mapping | Business Rules or Comments |
|---|---|---|---|---|---|---|
Category - Enrollment | ||||||
Directory Information Block Status | Yes | An indication of whether an individual requested a Family Education Rights and Privacy Act (FERPA) block to withhold the release of the person's directory information. | Block - Block | DirectoryInformationBlockStatus | [S_MS_STU_X]PII_Disclose_Directory_Info | Yes = RemoveBlock No = Block This is only available on the Students table. |
Enrollment Entry Date | Yes | The month, day, and year on which a person enters and begins to receive instructional services in a school, institution, program, or class section during a given session. | None | EnrollmentEntryDate | [Students]EntryDate | |
Enrollment Exit Date | Yes | The year, month, and day on which the student officially withdrew or graduated, i.e. the date on which the student's enrollment ended. For No-Show students, the exit date is now set to be the same as the entry date. Note: In a future update, a No-Show flag will be added to identify these records. | None | EnrollmentExitDate | [Students]ExitDate | Extract the last in-session day based on the Exit Date only if the Exit Type (Exit Code) has a value. Note: In PowerSchool SIS, the Exit Date is the day after the last in-session day. |
Enrollment Status | Yes | An indication as to whether a student's name was, is, or will be officially registered on the roll of a school or schools. | MDE Option Set 01811 - Currently enrolled | EnrollmentStatus | [Students]Enroll_Status | Enroll Status is only available on the Students table.
|
Entry Grade Level | Yes | The grade level or primary instructional level at which a student enters and receives services in a school or an educational institution during a given academic session. | Refer to Entry and Exit Grade Levels. | EntryGradeLevel | [Students]Grade_Level | |
Exit Grade Level | Yes | The grade level or primary instructional level at which a student exits a school, program, or educational institution. | Refer to Entry and Exit Grade Levels. | ExitGradeLevel | [Students]Grade_Level | Same as Entry Grade Level |
Gifted and Talented Indicator | Yes | An indication that the student is participating in and served by a Gifted/Talented program. | Yes | GiftedAndTalentedIndicator | [S_MS_STU_X]GiftedInd | Yes = Yes No = No Blank = Unknown |
Local Education Agency Identification System
| Yes | A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to a local education agency. | MDE Option Set SEA - State Education Agency assigned number | LEAIdentificationSystem Alternate Name: LEA Identification System | Default to SEA Note: This is a mandatory field. | |
Local Education Agency Identifier | Yes | A unique number or alphanumeric code assigned to a local education agency by a school system, a state, or other agency or entity. | None | LocalEducationAgencyIdentifier | [Prefs]Value where [Prefs]Name="DistrictNumber" | Extract the first 4 characters. This value will be the same for all students in the district. Note: This is a mandatory field. |
Program Gifted Eligibility Criteria | Yes | State/local code used to determine a student's eligibility for a Gifted/Talented program. | MDE Option Set 13452 - General Intellectual Aptitude only | ProgramGiftedEligibilityCriteria | [S_MS_STU_X]GiftedType | |
Responsible District Identifier | Yes | The district responsible for specific educational services and/or instruction of the student. | None | ResponsibleDistrictIdentifier | [Students]DistrictOfResidence | If the district of residence is not null then extract, else extract the current district ID. Note: This is a mandatory field. |
Responsible District Type | Yes | The type of responsibility the district has for the student. The default is set to Attendance. | MDE Option Set Accountability - Accountability Attendance - Attendance Transportation - Transportation Assessment - Assessment Resident - Resident | ResponsibleDistrictType | The Responsible District Type is related to the Responsible District Identifier. This field will extract value based on where the data is pulled from: Resident when reporting District of Residence. Accountability when reporting the district ID. Note: This is a mandatory field. | |
Responsible School Identifier | Yes | The school responsible for specific education services and/or instruction of the student. | None | ResponsibleSchoolIdentifier | [Prefs]Value where [Prefs]Name="DistrictNumber" concatenated with | Format: School ID (0000-000) 4 character district number + - + 3 character school number. Note: This is a mandatory field. |
Responsible School Type | Yes | The type of services/instruction the school is responsible for providing to the student. Note: The default is set to Attendance. | MDE Option Set Accountability - Accountability Attendance - Attendance Transportation - Transportation Assessment - Assessment Resident - Resident | ResponsibleSchoolType | The Responsible School Type is related to the Responsible School Identifier. Derived based on the Enrollment school ID. Currently, default it to Accountability. Note: This is a mandatory field. | |
Role | No | A description of how a person relates to an organization. | AEStaff - AE Staff | Role | NA | Not Applicable |
School Identification System | Yes | A coding scheme that is used for identification and record-keeping purposes by schools, social services, or other agencies to refer to an institution. | Refer to School Identification System. | SchoolIdentificationSystem | Default to SEA Note: This is a mandatory field. | |
School Identifier | Yes | A unique number or alphanumeric code assigned to an institution by a school, a school system, a state, or other agency or entity. | None | SchoolIdentifier | [Students]SchoolID Translated to the correct format. | Format: School ID (0000-000) 4 character district number + - + 3 character school number. [Prefs]Value where [Prefs]Name="DistrictNumber" concatenated with [Schools]School_Number Note: This is a mandatory field. RECENTLY UPDATED |
Truant Status | No | An indication that a student is identified as a truant as defined by state rules. | Yes | TruantStatus | NA | Not Applicable |
Entry Type | Yes | The process by which a student enters a school during a given academic session. | Refer to the new Entry Type codes. | EntryType | [Students]EntryCode | Refer to the Old vs New Entry Type Code Mapping page. |
Exit or Withdrawal Type | Yes | The circumstances under which the student exited from membership in an educational institution. | Refer to the new Exit or Withdrawal Type codes. | ExitOrWithdrawalType | [Students]ExitCode | Refer to the Old vs New Exit Type Code Mapping page. |