Tool Search: Enrollments
The Enrollments tool lists all current and historical enrollments for each student in the district. By default, enrollment records are listed first by grade level, then by enrollment start date. To reorder the list of enrollments, click the blue hyperlinked headers in the Enrollments Editor list. The list of enrollments can be sorted by Grade, Calendar, Start Date, or End Date. The following information details the enrollment fields specific to Delaware.
For additional information, including setting system preferences and guidance on adding and printing Enrollment records, see the core Enrollments article.
Delaware Enrollments ToolGeneral Enrollment Information
The table below provides definitions for each data element on the General Enrollment editor.
Data Element | Definition | Location | Report(s) |
|---|---|---|---|
| Enrollment ID | Displays the unique identification number of the enrollment record from the database. This is a read-only field and is for informational purposes only. | Database Location: Enrollment.enrollmentID Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > enrollmentID | |
Calendar | Lists the name of the school and the school year in which the student is enrolled. | Database Location: Enrollment.calendarID Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > calendarID | |
Schedule | Displays the schedule structure of the calendar into which the student is enrolled. | Database Location: Enrollment.structureID | |
Grade | Indicates the grade level of the enrollment record. Grade levels should be mapped to state grade levels for proper reporting. | Database Location: Enrollment.grade | Student School Associations |
Class Rank Exclude | Indicates this enrollment record is not included in class rank calculations. This is often selected for foreign exchange students or special education students. | Database Location: Enrollment.classRankExclude | |
| External LMS Exclude | When marked, the enrollment is not included in shared Campus data with an external learning management system. | Database Location: Enrollment.externalLMSExclude Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > externalLMSExclude | |
Start Date | Lists the first day of instruction for this enrollment record. When a start date is changed on an enrollment record, a warning displays indicating that any previously entered attendance that may have occurred prior to the new start date is not deleted, unless the student's start date in course sections is also adjusted. If the student's enrollment already has an end date (or where an end date is entered when the start date is adjusted), attendance that is outside of the start/end dates is deleted. | Database Location: Enrollment.startDate Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > startDate | Student School Associations |
No Show | Indicates the student never attended the school during the allotted time period determined by the district. State and/or district policies determine when a student's enrollment is actually ended. | Database Location: Enrollment.noShow Ad hoc Inquiries: N/A | |
End Date | Lists the last day of instruction for this enrollment record. When an enrollment ends and there are no more enrollments for the student, the student's schedule also ends. If the student's enrollment already has an end date (or where an end date is entered when the start date is adjusted), attendance outside of the start/end dates is deleted. | Database location: Enrollment.endDate Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > endDate | Student School Associations |
End Action | Indicates the action of promoting, retaining, or demoting a student to the next, same, or previous grade level for the next school year. | Database Location: Enrollment.endAction Ad hoc Inquiries: Student > Learner > Active Enrollment > Core elements > endAction | Student School Associations |
Service Type | Indicates the type of enrollment and the intended service the student receives. Service Types include (P) Primary, (S) Partial, and (N) Special Education Services. | Database Location: Enrollment.serviceType Ad hoc Inquiries: Student > Learner > Active Enrollment > Core elements > serviceType | |
Local Start Status | Lists the local enrollment start code for the student. | Database Location: Enrollment.localStartStatusTypeID Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > localStartStatusTypeID | Student School Associations |
Local End Status | Lists the local enrollment end code for the student. | Database Location: Enrollment.localEndStatusTypeID Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > localEndStatusTypeID | Student School Associations |
| State Start Status | Displays the state start status mapped to the assigned local start status. | Database Location: Enrollment.startStatus Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > startStatus | |
| State End Status | Displays the state end status mapped to the assigned local end status. | Database Location: Enrollment.endStatus Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > endStatus | |
Start Comments | Comments about the start of the enrollment - who entered the enrollment, verified information, etc. | Database Location: Enrollment.starComments Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > startComments | |
End Comments | Comments about the end of the enrollment. | Database Location: Enrollment.endComments Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > endComments | |
| CRDC School of Accountability | School the student should report under for the CRDC results, regardless of the school in which their enrollment is aligned. | Database Location: Enrollment.schoolOfAccountability Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > schoolOfAccountability | |
| School Choice | Indicates school choice was applied for the enrollment. | Database Location: Enrollment.schoolChoiceProgram Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > schoolChoiceProgram | Student School Associations |
| Choice Basis Reason | Indicates why the School Choice was made at the enrollment level.
| Ad hoc Inquiries: Student > Learner > Active Enrollment > Core Elements > choiceBasisReason Database Location: Enrollment.choiceBasisReason | Student Education Organization Associations Student School Associations |
State Reporting Fields
The following fields appear in the Delaware State Reporting Fields section of the Enrollments tool.. The "Reports" column indicates which state reports draw from each field.
Field | Description | Database Location | Reports |
|---|---|---|---|
State Exclude | Excludes the enrollment record from reporting on all state reporting extracts that honor state exclude functionality. | Database Location: Enrollment.stateExclude Ad hoc Inquiries: Student > Learner > Active Enrollment > State Reporting elements > stateExclude |
|
Resident District (Read-Only) | District in which the student lives. | Database Location: enrollment.residentDistrict Ad hoc Inquiries: Student > Learner > Active Enrollment > State Reporting Elements > residentDistrict | |
| Resident School (Read-Only) | School the student would attend based on the permanent or other home address. | Database Location: Enrollment.residentSchool Ad hoc Inquiries: Student > Learner > Active Enrollment > State Reporting elements > residentSchool | Student Education Organization Associations |
Accountability School | School where a student's academic performance is assigned for the purpose of evaluating Adequate Yearly Progress (AYP) and determining school performance ratings. | Student Education Organization Associations | |
Funding School | School that receives funding for the student. | Student Education Organization Associations | |
Assessment School | Associated school in terms of the Delaware System of Student Assessment (DeSSA). |
