The General Settings tab contains the set up for the dates and many of the code values used in the Civil Rights Data Collection calculations. The information for these fields will need to be manually entered prior to processing the Civil Rights report.
User-Defined Codes and Locations
Use the dropdowns to select the table, field and values for the LEP, 504 Plan and GATE codes. Alternately, if you are familiar with the table and field names used in Query you can type the information into each dropdown and press the TAB key to move to the next one.
- LEP - Limited English Proficient or English Learner - the STU.LF field is used to store the English Learner designation, also enter the code value used to designate which students are English Learners
- 504 Plan - The CRDC calculations will first use the 504 Plans (FOF) table to identify any students that had an active 504 record during the 2017-18 school year. If no FOF records can be found for the student, then it will also use the information defined in this area to identify the 504 students. Typically the Programs table with Code value 101 (PGM.CD = 101) is the alternate table that stores 504 program records.
- GATE - The CRDC calculations will first use the Gate (GTE) table to to identify any students that had an active GATE record during the 2017-18 school year. If no GTE records can be found for the student, then it will also use the information defined in this area to identify the GATE students. Typically the Programs table with Code value 127 (PGM.CD = 127) is the alternate table that stores GATE program records.
The Student Next Grade (STU.NG) field can be used to identify if a student was retained at the end of the 2017-18 school year, or the Retentions (RET) table code values can be used.
If retained students are identified through the Student Data Next Grade (STU.NG) field, then select this option in the Retention Codes setting. The Civil Rights calculations will compare the grade (STU.GR) to the next grade (STU.NG) to determine if the students were retained at the end of the school year.
All Retention codes set up in the Code (COD) table (where COD.TC = 'RET' and COD.FC = 'CD' ) will be available to choose from. Select all codes used to tag students as Retained. The Civil Rights calculations will use the Retention records that fall within the 2017-18 school year to determine if students were retained during the school year.
NOTE: Either the STU.NG field or the Retention codes can be used as the method to identify the retained students, both methods cannot be used at the same time.
No Show Codes
The Student Tag (STU.TG) field is used to identify the student's status. All Student Tag codes set up in the Code (COD) table (where COD.TC = 'STU' and COD.FC = 'TG' ) will be available to choose from. Select the code(s) used to identify the No Show students. These student records will not be included in any Civil Rights calculations.
The Reporting Dates section contains all dates needed to run the report. It includes the Reporting Dates for Fall and Spring, the Term End Dates for Fall and Spring, and the Special Ed Reporting Date.
- Per CRDC Guidelines the Fall snapshot date must be a date when schools were in session on or near October 1.
- The Spring date will only be used if there are sections with Block Scheduling (MST.BL > 1). Per CRDC Guidelines the Spring snapshot date must be a date when schools were in session near March 1.
- The End dates for Fall and Spring are used to determine the Algebra I student enrollment counts. The dates need to be a date near the end of each term when all schools were in session.
- The Special Ed Reporting Date is used to determine if a student was enrolled in the Special Ed program on that date. If so, they are included in the Special Ed counts.
NOTE: Please review the information available on the CRDC Resource Center for more information on the Reporting Dates and any other reporting requirements/definitions.
Single-Sex Academic Class Definition
The Civil Rights calculations will use either the Master Schedule Sex (MST.SX) field or the Courses Traditional Gender (CRS.TGN) field that is selected on the General Settings tab to determine the number of Single-Sex academic classes offered at the schools.
After all selections have been made on the General Settings tab click on the Save General Setting button. A green message will display in the upper right corner once the settings are saved. Click on the Next button to go to the Courses tab.