Tool Search: NC LCS Collection
As part of the Legislative Class Size Collection, the K-3 Class Size Violations Report examines the records reported in K-3 Class Size to return class records that have exceeded state-defined class size maximums.
This report is available in both District Edition and State Edition.
See the NC Legislative Class Size article for information on required data setup, report logic, tool rights, and more.
NC LCS - K-3 Class Size ViolationsReport Logic
See the NC LCS article for global report logic that applies to all report types. See the following for details on the Class Size Average Report.
This report uses the Combined and Pull-out Class Logic.
The K-3 Class Size Violations takes the result set as generated in K-3 Class Size on the Snapshot Date/Calendar selection. Then per record:
- Divide the Student Count by the Lead Teacher Count.
- That calculated value is compared to the maximum class size allowed based on the Violation Type selected on the Extract Editor and Class Grade Level.
- ONLY WHEN that record returns a student count over the max allowed, that record reports.
- WHEN that record returns a student count that is less than or equal to the maximum allowed class size, the record DOES NOT report.
State Course Codes
One record reports per unique State Course Code in the selected School/District. The Course Section must have a State Course Code of one of the following:
- 10502Z0 (Kindergarten courses)
- 10512Z0 (First grade courses)
- 10522Z0 (Second grade courses)
- 10532Z0 (Third grade courses)
- 10542Z0 (Fourth grade courses)
- 10552Z0 (Fifth grade courses)
- 10562Y0 (Sixth grade courses)
- 10572Y0 (Seventh grade courses)
- 10582Y0 (Eighth grade courses)
Combined and pullout classes concatenate to the State Course Code value derived. Section records when the Course of the section contains a valid State Course Code. Sections where the State Course Code is blank or the code value is not in the valid set, do not report.
Course Sections
To report, the Course Section must be actively scheduled on the Snapshot Date selected on the Extract Editor. For Class Grade Levels K-3, when the Instructional Provider field on the Section Information tool has a value of 20: Dual Language Immersion, the section does not report.
Lead Teachers
Class sections must have at least one Lead Teacher active on the Effective Date selected in the Extract Editor to report.
- Lead Teachers must have a Staff State ID to report/count.
- All active teachers marked as a Primary Teacher on Section Staff History (dbo.SectionStaffHistory.staffType = P) report as Lead Teachers.
- Teachers entered as Secondary Staff History ONLY report/count as Lead Teachers when they are marked with a Role of Secondary Lead Teacher.
To Qualify as a Lead Teacher:
- An active teacher is marked as a Primary Teacher on Section Staff History (dbo.SectionStaffHistory.staffType = P) OR
- An active teacher is selected on Section Staff History (dbo.SectionStaffHistory.staffType = T OR SS) AND they are assigned one of the following roles:
- TOR: Teacher of Record
- SLT: Secondary Lead Teacher
For LCS Reports that display one qualifying lead teacher per reportable section (regardless of the total number of qualifying lead teachers), the following logic is used to determine which lead teacher is chosen to report:
- All active teachers marked as a Primary Teacher on the Section Staff History (dbo.SectionStaffHistory.staffType = P) report as Lead Teachers.
- When there is no active Primary Teacher on the Section Staff History record, then an active Teacher on Section Staff History (dbo.SectionStaffHistory.staffType = T OR SS) reports as a Lead Teacher when they are assigned one of the following roles (dbo.SectionStaffHistory.role):
- TOR: Teacher of Record
- SLT: Secondary Lead Teacher
- When multiple active Teachers exist on Section Staff History (dbo.SectionStaffHistory.staffType = T OR SS), then the reported Lead Teacher is the Teacher with the role of TOR: Teacher of Record (dbo.SectionStaffHistory.role).
- When multiple active Teachers exist on Section Staff History (dbo.SectionStaffHistory.staffType = T OR SS) with the same roles (dbo.SectionStaffHistory.role), then the teacher with the most recent start date (dbo.SectionStaffHistory.startDate) reports as the Lead Teacher.
Student Count
Students do NOT count when:
- They do not have a State Student ID.
- Their Enrollment record is marked as No Show or State Exclude as of the Snapshot Date.
- They are enrolled in a Calendar marked as Exclude as of the Snapshot Date.
- They are enrolled in a Grade Level marked as Exclude as of the Snapshot Date.
Students who exit prior to the date selected but within the submission window are not counted.
Students who start after the date selected but within the submission window are not counted.
Violation Types
When the Violation Type of Over the PSU-wide maximum average is selected, ONLY those classes over the PSU-wide maximum average based on Class Grade Level report.
- Kindergarten - classes where student count is over 21
- Grade 1 - classes where student count is over 19
- Grade 2 - classes where student count is over 20
- Grade 3 - classes where student count is over 20
When the Violation Type of Over the Individual Class Size Maximum is selected, ONLY those classes over the Individual class size maximum based on Class Grade Level report.
- Kindergarten - classes where student count is over 18
- Grade 1 - classes where student count is over 16
- Grade 2 - classes where student count is over 17
- Grade 3 - classes where student count is over 17
Report Editor
| Data Element | Description |
|---|---|
| Setup | |
| Search Calendars | Search field to narrow the list of calendars to select. Use the Expand All/Collapse All. Place a checkbox next to the desired school and calendars. |
| Show Active Year Only |
When set to ON, only those calendars for the current school year are available for selection. When set to OFF, all calendars from all school years are available for selection. |
| Report Options | |
| Report Type | Indicates which LCS report generates. For this instance, select Class Size Violations. |
| Snapshot Period | Indicates for what period the report was generated. For the Class Size Violations Report, the only Snapshot Period available is No Snapshot (Unofficial). |
| Grade Level Grouping | Indicates which grade levels are included. For the Class Size Violations Report, the only option available is K-3. |
| Violation Type | Indicates which type of violation reports.
See the Report Logic section for details. |
| Exclude Cross-Site Data | When marked, Cross-Site Enrollment courses are not included in the report. This option displays when the Cross-Site Enrollment Participation field on the District Information record is set to an option other than Disable. This option does not display for State Edition. |
| Effective Date | Indicates the date used to determine which students appear in the report. When the Snapshot Period field is set to No Snapshot (Unofficial), a date can be entered manually for the Effective Date. |
| Output Options | |
| Report Processing | Select the Generate Now option to generate the report immediately. Use the Submit to Batch option to choose when the report generates. Submit to Batch is useful when generating the report for several calendars or for reporting larger amounts of data. See the Batch Queue article for more information.
Due to the amount of data collected in this report, use the Batch Queue option. |
| Format Type | Determines in which format the report generates - CSV or HTML. |
Unofficial File Generation Procedures
To generate an unofficial K-3 Class Size Violations Report.
- Select the Report Type of Class Size Violations.
- Select the Snapshop Period of No Snapshot (Unofficial).
- Select the Grade Level Grouping of K-3
- Select the desired Violation Type.
- Mark the Exclude Cross-Site Data checkbox, if desired.
- Select the desired Effective Date.
- Select Generate.
Report Layout
| Data Element | Description | Location |
|---|---|---|
| End Year | Reports the end year of the school year selected for report generation.
For the school year 2024-2025, a value of 2025 reports. Numeric, 4 digits |
School Year Setup > School Year Detail > End Year
Calendar.endYear |
| PSU Number | Reports the State District Number.
Numeric, 3 digits |
District Information > District Detail > State District Number
District.number |
| LEA Name | Reports the Name of the district.
Alphanumeric, 15 characters |
District Information > District Detail > Name
District.name |
| School Number | Reports the State School Number.
Numeric, 6 digits |
School Information > School Detail State School Number
School.number |
| School Name | Reports the Name of the school.
Alphanumeric, 15 characters |
School Information > School Detail > Name
School.name |
| Class Grade Level | Reports the State Grade Level Code reflecting the majority of students scheduled into the class on the Snapshot Date selected on the extract editor.
When an equal number of multiple grade level students are scheduled, the lowest state grade level code reports. |
Grade Level Setup
gradeLevel.stateCode Course Information > State Code Course.statecode |
| Department Name | Reports the Department of the course for the reporting section of record. | Course Information > Department
Course.department |
| Teacher Duties | Returns a concatenated value of the Department Name plus the Class Grade Level. | N/A |
| Course State ID |
Reports the assigned State Course Code.
Alphanumeric, 7 characters |
Course Information > State Code
Course.stateCode |
| Course Name | Reports the name of the course based on the assigned State Course.
This returns the name of the course from the Course Code Mapping tool. |
Course Code Setup |
| Section Number | Report the Number of the section for the reporting section of record. | Section Information > Number
Section.number |
| StaffUID | Reports the Staff State ID of the Lead Teacher for the reporting section of record that is active on the Snapshot Date selected on the Extract Editor.
All teachers entered as Primary are lead Teachers and only those Teachers entered as Secondary that are marked with a Role of Secondary Lead Teacher are Lead Teachers.
|
Demographics > Person Identifiers
person.staffStateID |
| Lead Teacher |
Report the concatenated Last Name (+) space (+) Middle Initial (+) First Name of the teacher reported in field 12: StaffUID.
|
Demographics > Last Name, Middle Name, First Name
Person.lastName Person.middleName Person.firstName |
| Teacher Count | Reports the number of Lead Teachers present on the section of record on the Snapshot Date selected on the extract editor.
See the Data Setup information for information on Lead Teachers. |
Calculated Value |
| Student Count | Reports the number of (reportable) studentsscheduled in the section of record on the Snapshot Date selected on the extract Editor.
NOTE: Reportable students have a Student State ID and are not marked as No Show or State Exclude. |
Calculated Value |
