Tool Search: Detention Center Report
The Detention Center Report collects a list of students in grade 6-12 who have been receiving services in a county detention center.
Detention Center Report
Report Logic
A student must have an active enrollment in a state grade level of 06-12 during the Start and End Dates on the Report Editor, as well as the Detention Center checkbox marked on that active enrollment record.
Students are not included when:
- The Enrollment record is marked as No Show or as State Exclude.
- The Calendar of enrollment is marked as State Exclude.
- The Grade Level of enrollment is marked as State Exclude.
Report Editor
The following fields are available for selection.
| Field | Description |
|---|---|
| File Identifier | Indicates the number attached to the end of the file name and is used to differentiate the file from other files generated. |
Start Date End Date | The Start Date populates with the start date of the selected calendar. The End Date populates with the end date of the selected calendar. If multiple calendars are selected, the latest start and end dates are used. |
| Report Protected Identities | When marked, student identity information (last name, first name, etc.) reports from the Protected Identity Information fields. |
| Format | Determines how the report generates. Use the Comma Separate (CSV) (State format) when submitting the report to the state. Use the HTML or Tab Delimited options when reviewing data prior to state submission. |
| Ad hoc Filter | Select a saved ad hoc filter to use when generating this report. Only those students included in the filter will be returned on the report if they meet the reporting requirements. |
| Strip Apostrophes | When marked, the following marks are removed from student names and other reported data:
When not marked, these marks are not removed. |
| Calendar Selection | At least one calendar needs to be selected for the report to generate. Calendars can be chosen by Active Year, by School or by Year. If a calendar is selected in the Campus toolbar, that calendar is automatically selected. |
| Report Generation | The report can be generated immediately using the Generate Extract button. When there is a larger amount of data chosen (several calendars, large date range, etc.), use the Submit to Batch button, which allows the user to choose when the report is generated. See the Batch Queue article for more information. |
Generate the Report
- Enter the File Identifier value.
- Enter the Start Date and End Date required for the report.
- If desired, mark the Report Protected identifies checkbox.
- Select the desired Format for the report.
- If desired, select an Ad hoc Filter from the dropdown list.
- If desired, mark the Strip Apostrophes checkbox.
- Select the desired Calendar(s).
- Click the Generate Report button to display the results of the report immediately; click the Submit to Batch button to determine when the report generates.
Detention Center Report - HTML Format
Detention Center Report - State Format (Comma Delimited)
Detention Center Report - Tab Delimited Format
Report Layout
Report Header
| Data Element | Description | Location |
|---|---|---|
| Report Name | Reports the name of the extract being generated. Always report a value of Detention Center. | N/A |
| Student Count | Reports the total number of records that appear on the report. | N/A |
| File Name | Detention_Center_ + RCDT or District Name + _ + Date (mmddyyy)_File Identifier (i.e.,Detention_Center_310453000260_01302015_001.txt) | N/A |
| Date | Reports the date the extract was generated. Date field, 10 characters (MM/DD/YYY) | N/A |
| RCDTS Code | The Region-County-District-Type-School code that uniquely identifies the school generating the extract. RRCCCDDDDDTTSSSS, 15 characters | School & District Settings > District Information > State District Number, Type, Region Number, County District.districtID District.county District.region School & District Settings > School Information > State School Number School.number |
Report Layout
| Data Element | Description | Location |
|---|---|---|
| State ID | Reports the student's locally assigned identification number. Numeric,9 digits | Census > People > Demographics > Person Identifiers > Student State ID Person.stateID |
| Student ID | Reports the student's state-assigned identification number. Numeric, 6 digits | Census > People > Demographics > Person Identifiers > Local Student Number Person.studentID |
| Student Last Name | Reports the student's last name. When the Report Protected Identities checkbox is marked on the report editor, the student's last name reports from the Legal Last Name field if populated. Alphanumeric, 30 characters | Census > People > Identities > Last Name Identity.lastName Census > People > Identities > Protected Identity Information > Legal Last Name Identity.legalLastName |
| Student First Name | Reports the student's first name. When the Report Protected Identities checkbox is marked on the report editor, the student's first name reports from the Legal First Name field if populated. Alphanumeric, 30 characters | Census > People > Identities > First Name Identity.firstName Census > People > Identities > Protected Identity Information > Legal First Name Identity.LegalfirstName |
| Student Birth Date | Reports the student's date of birth. Date field, 10 characters (YYYY-MM-DD) | Census > People > Demographics > Person Information > Birth Date Identity.birthDate |
| Detention Center RCDTS | The Region-County-District-Type-School code that uniquely identifies the Detention Center where the student is receiving services. RRCCCDDDDDTTSSSS, 15 characters | Student Information > General > Enrollments > State Reporting Fields > Home School, Home District District.districtID District.county District.region School.number Enrollment.residentSchool Enrollment.residentDistrict |
| Grade | Reports the grade level of enrollment Only students in grades 06-12 are included in the report. Numeric, 2 digits | Student Information > General > Enrollments > General Enrollment Information > Grade Enrollment.grade Student Information > General > Enrollments > State Reporting Fields > Detention Center Enrollment.detentionCenter |
| School Year | Reports the school year associated with the reporting enrollment record. Numeric, 4 years | Scheduling & Courses > Calendar Setup > School Year Setup SchoolYear.active |
| Service Start Date | Reports the start date of enrollment for the student receiving services at the Detention Center. Date field, 10 characters (MM/DD/YYYY) | Student Information > General > Enrollments > General Enrollment Information > Start Date Enrollment.startDate |
| Service End Date | Reports the end date of the enrollment for the student receiving services at the Detention Center. Date field, 10 characters (MM/DD/YYYY) | Student Information > General > Enrollments > General Enrollment Information > End Date Enrollment.endDate |
| Delete Record | Reports a value of 99 and is used to delete the Detention Center record. Numeric 2 digits | N/A |
