Skip to main content
Skip table of contents

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.

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
RemoveBlock - Remove 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
[Reenrollments]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
[Reenrollments]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
01810 - Previously enrolled
01813 - Transferring (will enroll)

EnrollmentStatus

[Students]Enroll_Status

Enroll Status is only available on the Students table.

  • If Enroll_Status = 0 then 01811

  • If Enroll_Status = 1, 3, and 4 then 01810

  • If Enroll_Status = 2 then extract 01813

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
[Reenrollments]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
[Reenrollments]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
No
Unknown

GiftedAndTalentedIndicator

[S_MS_STU_X]GiftedInd
[S_MS_REN_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

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.

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
13453 - Specific Academic Aptitude only
13454 - Visual/Performing Arts only

ProgramGiftedEligibilityCriteria

[S_MS_STU_X]GiftedType
[S_MS_REN_X]GiftedType

Responsible District Identifier

Yes

The district responsible for specific educational services and/or instruction of the student.

None

ResponsibleDistrictIdentifier

[Students]DistrictOfResidence
[Reenrollments]DistrictOfResidence

If the district of residence is not null then extract, else extract the current district ID.

Responsible District Type

Yes

The type of responsibility the district has for the student.

Note: 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.

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
[Schools]School_Number

Format: School ID (0000-000)

4 character district number + - + 3 character school number.

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.

Role

No

A description of how a person relates to an organization.

AEStaff - AE Staff
AEStudent - AE Student
CTEStaff - CTE Staff
CTEStudent - CTE Student
ELChild - EL Child
ELStaff - EL Staff
K12Staff - K12 Staff
K12Student - K12 Student
ParentGuardian - Parent/Guardian
PSApplicant - PS Applicant
PSStaff - PS Staff
PSStudent - PS Student
WorkforceProgramParticipant - Workforce Program Participant

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

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
[Reenrollments]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

Truant Status

No

An indication that a student is identified as a truant as defined by state rules.

Yes
No

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
[Reenrollments]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
[Reenrollments]ExitCode

Refer to the Old vs New Exit Type Code Mapping page.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.