Tool Search: DF21 Transiency Report
The DF21 Transiency Report captures students actively enrolled, re-enrolled, or withdrawn in the current school year. The report calculates an aggregate of students by school and displays the total in the report.
DF21 Transiency Report Editor
Report Logic
To report, the following Standard Code must be entered on the student's Start Status or End Status:
| Standard Code | Description | Status |
|---|---|---|
| 01 | New Enrollment | Start Status |
| 02 | Re-Enrollment | Start Status |
| 03 | Withdrawn | End Status |
Students are NOT included if:
- their enrollment record is marked as No Show;
- their Grade Level of enrollment is marked as State Exclude; or
- their Calendar of enrollment is marked as State Exclude.
Calendars marked as State Exclude are not included.
Report Editor
Option | Description |
|---|---|
Snapshot Date & End Date | These dates are used to report students, in the selected school year, according to the following logic:
Enter a date by typing in mmddyy format or by using the calendar icon to choose a date. |
| Report Type | The following options are available:
|
| Format | Determines the format for the report. Use the State Format (CSV) when submitting the final data. Use HTML for data review and testing. |
| District-Wide | Marking this checkbox automatically selects all schools in the active school year. |
| Ad Hoc Filter | Selection includes only those students included in the filter. |
| Calendar | Selected calendar indicates which students will be included in the report. Multiple calendars can be selected at one time; it is recommended that all calendars in a district not be selected as this will increase the amount of time it takes to generate the extract. The calendar chosen in the Campus toolbar is already selected. |
| Generate Report | Displays the selected calendar information and extract immediately for review and printing in the selected format. |
| Submit to Batch | Delays the extract generation to a designated time. See the Batch Queue article for more information. |
School Summary Extract Layout
Column | Description | Campus Location |
|---|---|---|
| District Number | The state-assigned code that identifies the district and its schools. Alphanumeric, 8 characters | School & District Settings > District > District Information > State District Number
|
| District Name | The name of the school district. Alphanumeric, 40 characters | School & District Settings > District > District Information > Name District.name |
| School Number | The state school number. Alphanumeric, 7 characters | School & District Settings > Schools > School Information > State School Number School.number |
| School Name | The school's name. Alphanumeric, 40 characters | School & District Settings > Schools > School Information > Name School.name |
| Count Day Enrollments | The number of students actively enrolled on the Snapshot Date and on or before the End Date. Numeric | Student Information > General > Enrollments > Start Status; Start Date; End Date Not dynamically stored |
| New Enrollments | The number of new enrollments occurring after the Snapshot Date and on or before the End Date. To be included, the start status Standard Code must be 01. Numeric | Student Information > General > Enrollments > Start Status; Start Date; End Date Not dynamically stored |
| ReEnrollments | The number of students re-enrolled after the Snapshot Date and on or before the End Date. To be included, the start status Standard Code must be 02. Numeric | Student Information > General > Enrollments > Start Status; Start Date; End Date Not dynamically stored |
| Withdrawals | The number of students withdrawn after the Snapshot Date and on or before the End Date. To be included, the end status Standard Code must be 03. Numeric | Student Information > General > Enrollments > Start Status; Start Date; End Date Not dynamically stored |
Detail Extract Example and Layout
The following report types generate the same layout:
- Count Day Enrollment Detail. Students actively enrolled on the Snapshot Date and on or before the End Date.
- New Enrollment Detail. New enrollments occurring after the Snapshot Date on or before the End Date.
- Re-Enrollment Detail. Students re-enrolled after the Snapshot Date on or before the End Date.
- Withdrawal Detail. Students withdrawn after the Snapshot Date on or before the End Date.
Column | Description | Location | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| School Number | The state school number. Alphanumeric, 7 characters | School & District Settings > Schools > School Information > State School Number School.number | ||||||||||||||||
| Last Name | The student's last name. Alphanumeric, 40 characters | Census > People > Demographics > Last Name Identity.lastName | ||||||||||||||||
| First Name | The student's first name. Alphanumeric, 35 characters | Census > People > Demographics > First Name Identity.firstName | ||||||||||||||||
| Student Number | The unique ID assigned to the student. Alphanumeric, 15 characters | Census > People > Demographics > Local Student Number Person.studentNumber | ||||||||||||||||
| Grade | The student's grade level. Alphanumeric,4 characters | Student Information > General > Enrollments > Grade Enrollment.grade | ||||||||||||||||
| Gender | The student's gender. This field reports M or F. Alphanumeric, 1 character | Census > People > Demographics > Gender Identity.gender | ||||||||||||||||
| Ethnicity | The student's ethnicity. The following codes report:
Alphanumeric, 1 character | Census > People > Race/Ethnicity Identity.raceEthnicity | ||||||||||||||||
| Start Date | The student's enrollment start date. Date, 10 characters MMDDCCYY | Student Information > General > Enrollments > Start Date Enrollment.startDate | ||||||||||||||||
| Start Status | The student's enrollment start status. The following Standard Codes report: 01 - New Enrollment 02 - Re-Enrollment Numeric, 2 digits | Student Information > General > Enrollments > Start Status Enrollment.startStatus | ||||||||||||||||
| End Date | The student's enrollment end date. Date, 10 characters MMDDCCYY | Student Information > General > Enrollments > End Date Enrollment.endDate | ||||||||||||||||
| End Status | The student's enrollment end status. The following Standard Code reports: 03 - Withdrawn. Numeric, 2 digits | Student Information > General > Enrollments > End Status Enrollment.endStatus |
