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.

Screenshot of the LCS K-3 Class Size Violations editor.

NC LCS - K-3 Class Size Violations

Report 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.

Teachers

Lead Teachers must have a Staff State ID to report.

All Teachers entered as a PRIMARY on the Section Staff History are Lead Teachers. They must be active on the Snapshot Date (based on the teacher's Start Date/End Dates on the Section Staff History.

Teachers entered as SECONDARY on Section Staff History MUST have a ROLE of Secondary Lead Teacher and must be active on the Snapshot Date to count as a Lead Teachers.

Teachers who exit before the date selected but within the submission window are not counted.

Teachers who start after the date selected but within the submission window are not counted.

The active Lead Teacher on the Snapshot Date reports. In the case of multiple active, the last entered Primary Teacher reports.

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 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

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 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

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.
Grade Level Grouping	Indicates which grade levels are included. For this instance, select K-3.
Violation Type	Indicates which type of violation reports. Over the Individual Class Size Maximum Over the PSU-wide Maximum Average 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 does not display for State Edition.
Snapshot Date	Indicates the date the report was generated.
Output Options
Report Processing	To generate the report immediately, select the Generate Now option. To choose when the report generates, use the Submit to Batch option. Submit to Batch is useful when generating the report for several calendars or for reporting more significant amounts of data being reported. 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.
Select the Grade Level Grouping of K-3
Select the desired Violation Type.
Do NOT mark the Only return classes with 0 students checkbox to return class records where at least one student is rostered on the Snapshot Date.
Mark the Only return classes with 0 students checkbox to return class records where NO students are rostered on the Snapshot Date.
Select the desired Snapshot 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. For Pullout classes, reports the Lead Teacher active on the extract editor Snapshot Date from the original section (section the record reports to). For Combined classes, the record reports to the section with the most rostered students (else lowest grade level if tied) - the Lead Teacher active on the extract editor Snapshot Date entered on the reporting section - reports.	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. All teachers entered as Primary are lead Teachers & only those Teachers entered as secondary that are marked with a Role of Secondary Lead Teacher are Lead Teachers. Combined classes count all active Lead Teachers on both the original section and the combined section. 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. When the roster start date = snapshot date, count student. If roster end date = snapshot date, count student. Combination classes return a total of all reportable rostered students from both the original section and the combined section. This is NOT a unique student count. NOTE: Reportable students have a Student State ID and are not marked as No Show or State Exclude.	Calculated Value

K-3 Class Size Violations (LCS)