Tool Search: KECS LEAD Extract
KECS LEAD Extract Classes (Aggregate) Report
Classes (Aggregate) Logic
The report generates an aggregated list of course sections for a given calendar and pulls all records from the Detail report. It contains courses that have no students assigned to them grouped by: End Year, District Number, District Name, School Number, School Name, State Classification, Calendar, Schedule Structure Name, Course Number, Course Name, Section Number, Section ID, Course Code, Core Content, Teaching Method, Instructional Setting, Section Special Type, KTSExchange, Responsive, Person ID, Section Start Date, Section End Date.
The report sorts by the following in ascending order: End Year, District Name, School Name, Calendar Name, Schedule Structure Name, Course Number, Section Number.
Classes (Aggregate) Report Layout
| Data Element | Descriptions | Location |
|---|---|---|
| Date Time Generated | Date and time the extract was generated.
MM/DD/YYYY HH:MM |
N/A |
| EndYear | Reports the end year for a reported school session.
XXXX 4-digit number (e.g. 2022 for SY 21-22) |
Calendar Information > School Year > End Year |
| District Number | Reports the unique number or alphanumeric code assigned to the reporting district.
XXX 3-digit number |
District Information > State District Number |
| District Name | Reports the name of the reporting district.
Alphanumeric |
District Information > Name |
| School Number | Reports the unique number or alphanumeric code assigned to the reporting school.
XXX 3-digit number |
School Information > Location Number |
| School Name | Reports the name of the reporting school.
Alphanumeric |
School Information > Select School > Name |
| State Classification | Reports the state-assigned school classification. See Appendix A for possible values.
Code (e.g. A1) |
School Information > State Classification |
| Calendar Name | Reports the name of the calendar.
Alphanumeric |
Calendar Information > Name |
| Schedule Structure Name | Reports the calendar’s schedule structure name.
Alphanumeric |
Calendar Information > Schedule Structure > Name |
| Course Number | Reports the local course number.
Alphanumeric |
Course Information > Number |
| Course Name | Reports the course name.
Alphanumeric |
Course Information > Name |
| Section Number | Reports the section number for the course.
Integer |
Course Information > Section > Number |
| SectionID | Reports the ID for a reported school session.
Integer |
Course Information > Section > SectionID |
| State Course Code | Reports the state’s course code.
XXXXXX Char(6) |
Course Information > State Code |
| Core Content | Reports section level content indicator.
Code (e.g. 100) |
Course Information > Section > Core Content |
| Teaching Method | Reports the course’s teaching method. Options include:
Code (e.g. 01) |
Course Information > Teaching Method |
| Instructional Setting | Reports the course’s instructional setting. Options include:
Instructional Setting is determined by the value set on the section in the Instructional Setting (Override) field.
Code (e.g. 01) |
Scheduling > Courses > Course > Section > Instructional Setting (Override)
IF NULL: Scheduling > Courses > Course > Instructional Setting |
| Section Special Type | Reports the section’s special classroom type. Options are:
Code (e.g. 01) |
Course Information > Section > Special Type |
| KTS Exchange | Reports the legacyKeyKTS field for the course. Possible values are:
|
courseMaster.legacyKeyKTS is not null for the corresponding course Course and CourseMaster left join on courseMasterID |
| Cross Site Enrollment | Indicates that the course is a Cross-Site Enrollment course in the home school.
Reports as 1 when it is a Cross-Site Enrollment. Otherwise, reports as 0. |
Course Information > Section Information > Cross-Site Enrollment |
| Responsive | Reports the course’s Responsive checkbox value. Possible values are:
|
Course Information > Responsive |
| Type | The course type. Options include:
|
Course Information > Course Type |
| Difficulty Level | The honors code associated with the course. Options include:
Code (e.g. AP) |
Course Information > Difficulty Level |
| Primary Teacher PersonID | Reports the active or most recent primary teacher’s personID for the section.
When there is a current active primary teacher for the section, use the active primary teacher’s personID.
When there is no currently active primary teacher for the section, but there was a previous primary teacher, this report uses the most recent primary teacher’s personID.
Integer |
Demographics > PersonID |
| Primary Teacher First Name | Reports the primary teacher’s preferred first name.
When there is a Primary Teacher PersonID for the section, reports this person’s preferred first name.
Alphanumeric |
Demographics > Identities > First Name |
| Primary Teacher Last Name | Reports the primary teacher’s preferred last name.
When there is a Primary Teacher PersonID for the section, report this person’s preferred last name. When 0 for the section, reports as NULL. Alphanumeric |
Demographics > Identities > Last Name |
| Low Grade | Reports the lowest grade level of enrollment for the section identified on each record.
Possible values are grade levels 95 through 20. Reports the lowest grade level of enrollment for the section. When there are no active students (Grades are NULL), reports the lowest defined state grade level for the selected calendar’s schedule structure where excludeEnrollment = 0. Code (e.g. 00) |
Course Information > Section > Roster |
| High Grade | Reports the highest grade level of enrollment for the section identified on each record.
Possible values are grade levels 95 through 20. Reports the highest grade level of enrollment for the section. When there are no active students (Grades are NULL), reports the highest defined state grade level for the selected calendar’s schedule structure where excludeEnrollment = 0. Code (e.g. 08) |
Course Information > Section > Roster |
| Total Count | Reports the count of distinct students on the roster. Counts the distinct StateIDs in the roster for the section.
Integer |
Course Information > Section > Roster |
| General Count | Reports the count of all students on the roster without a disability and who are not English Learners or Gifted and Talented.
Counts the distinct StateIDs in the roster for the section where:
Integer |
Roster: Course Information > Section > Roster
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability EL: Program Participation > English Learners (EL) > Program Status Gifted: Program Participation > Gifted & Talented > KY Gifted & Talented Editor > Gifted Category or Gifted Declined Services |
| SPED 13: Autism Count | Count of students on the roster with primary disability of 13: Autism.
Counts the distinct StateIDs in the roster for the section where Primary Disability Section = 13. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| SPED 11: Deaf Blind Count | Count of students on the roster with a primary disability of 11: Deaf-Blind.
Counts the distinct StateIDs in the roster for the section where Primary Disability Section = 11. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| SPED 15: Developmentally Delayed Count | Count of students on the roster with a primary disability of 15: Developmentally Delayed.
Counts the distinct StateIDs in the roster for the section where Primary Disability Section = 15. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| SPED 07: Emotional Behavior Disability Count | Count of students on the roster with a primary disability of 07: Emotional Behavior Disability.
Counts the distinct StateIDs in the roster for the section where Primary Disability Section = 07. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| SPED 02: Functional Mental Disability Count | Count of students on the roster with a primary disability of 02: Functional Mental Disability.
Counts the distinct StateIDs in the roster for the section where Primary Disability Section = 02. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| SPED 04: Hearing Impaired Count | Count of students on the roster with a primary disability of 04: Hearing Impaired.
Counts the distinct StateIDs in the roster for the section where Primary Disability Section = 04. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| SPED 01: Mild Mental Disability Count | Count of students on the roster with a primary disability of 01: Mild Mental Disability.
Counts the distinct StateIDs in the roster for the section where Primary Disability Section = 01. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| SPED 12: Multiple Disabilities Count | Count of distinct StateIDs on the roster for the school where Primary Disability Section = 01.
Count of distinct StateIDs in the roster for the section where Primary Disability Section = 12. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| SPED 08: Orthopedically Impaired Count | Count of students on the roster with a primary disability of 08: Orthopedic Impairment.
Counts the distinct StateIDs in the roster for the section where Primary Disability Section = 08. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| SPED 09: Other Health Impaired Count | Count of students on the roster with a primary disability of 09: Other Health Impaired.
Counts the distinct StateIDs in the roster for the section where Primary Disability Section = 09. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| SPED 10: Specific Learning Disability Count | Count of students on the roster with a primary disability of 10: Specific Learning Disability.
Counts the distinct StateIDs in the roster for the section where Primary Disability Section = 10. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| SPED 05: Speech Language Count | Count of students on the roster with a primary disability of 05: Speech Language.
Counts the distinct StateIDs in the roster for the section where Primary Disability Section = 05. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| SPED 14: Traumatic Brain Injury Count | Count of students on the roster with a primary disability of 14: Traumatic Brian Injury.
Counts the distinct StateIDs in the roster for the section where Primary Disability Section = 14. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| SPED 06: Visually Impaired Count | Count of students on the roster with a primary disability of 06: Visually Impaired.
Counts the students in the roster for the section with primary disability of 06: Visually Impaired. Integer |
Primary IDEA: Special Ed Documents > KY IEP > Enrollment Status > Primary Disability |
| English Learner Count | Reports the count of English Learners.
Counts the distinct StateIDs in the roster for the section where EL = 1. Integer |
EL: Program Participation > English Learners (EL) > Program Status |
| Gifted Count | Reports the count of Gifted/Talented students.
Counts the of distinct StateIDs in the roster for the section where Gifted = 1. Integer |
Gifted: Program Participation > Gifted & Talented > KY Gifted & Talented Editor > Gifted Category or Gifted Declined Services |
| Migrant Count | Reports the count of students designated as migrants.
Counts the distinct StateIDs in the roster for the section where Migrant = 1. Integer |
Program Participation > Migrant |
| Preschool Count | Reports the count of students in grades 95, 96, 97, 98, and 99.
Counts the distinct StateIDs in the roster for the section where Grade = 95, 96, 97, 98, or 99. Integer |
Course Information > Section > Roster |
| Hospital Attendance Group Home Count | Reports the count of students in Home/Hospital.
Counts the distinct StateIDs in the roster for the section where Home Hospital = 1. Integer |
Attendance Groups |
| ILPA Count | Reports the count of students with a locked ILPA.
Counts the distinct StateIDs in the roster for the section where ILPA = 1. Integer |
ILPA Documents |
| Section Start Date | Reports the month, day, and year on which a section begins.
Integer |
Course Information > Section |
| Section End Date | Reports the month, day, and year on which a section ends.
Integer |
Course Information > Section |
| Male Count | Reports the count of male students.
Counts the distinct StateIDs in the roster for the section where Gender = M. Integer |
Course Information > Section > Roster |
| Female Count | Reports the count of female students.
Count of distinct StateIDs in the roster for the section where Gender = F. Integer |
Course Information > Section > Roster |
| Hispanic or Latino Ethnicity Count | Reports the count of students with a Race Ethnicity of 1: Hispanic or Latino.
Counts the distinct StateIDs in the roster for the section where State Race/Ethnicity = 1. Integer |
Demographics > Race/Ethnicity > State Race/Ethnicity |
| American Indian or Alaska Native Count | Reports the count of students with a Race Ethnicity of 2: American Indian or Alaska Native.
Counts the distinct StateIDs in the roster for the section where State Race/Ethnicity = 2. Integer |
Demographics > Race/Ethnicity > State Race/Ethnicity |
| Asian Count | Reports a count of students with a Race Ethnicity of 3: Asian.
Counts the of distinct StateIDs in the roster for the section where State Race/Ethnicity = 3. Integer |
Demographics > Race/Ethnicity > State Race/Ethnicity |
| Black or African American Count | Reports a count of students with a Race Ethnicity of 4: Black or African American.
Counts the distinct StateIDs in the roster for the section where State Race/Ethnicity = 4. Integer |
Demographics > Race/Ethnicity > State Race/Ethnicity |
| Two or More Races Count | Reports the count of students with a Race Ethnicity of 7: Two or More Races.
Counts the distinct StateIDs in the roster for the section where State Race/Ethnicity = 7. Integer |
Demographics > Race/Ethnicity > State Race/Ethnicity |
| Native Hawaiian or Other Pacific Islander Count | Reports a count of students with a Race Ethnicity of 5: Native Hawaiian or Other Pacific Islander.
Counts the distinct StateIDs in the roster for the section where State Race/Ethnicity = 5. Integer |
Demographics > Race/Ethnicity > State Race/Ethnicity |
| White Count | Reports the count of students with a Race Ethnicity of 6: White.
Counts the distinct StateIDs in the roster for the section where State Race/Ethnicity = 6. Integer |
Demographics > Race/Ethnicity > State Race/Ethnicity |
| Eco Non-Dis Count | Reports the count of students who are not eligible to participate in the National School Lunch Program.
Counts the distinct StateIDs in the roster for the section where Economically Disadvantaged = 0. Integer |
Roster: Course Information > Section > Roster
FRAM: FRAM > Eligibility > Eligibility Editor > State Eligibility Code |
| Eco Dis Count | Reports the count of students who are eligible to participate in the National School Lunch Program.
Counts the distinct StateIDs in the roster for the section where Economically Disadvantaged = 1. Integer |
Roster: Course Information > Section > Roster
FRAM: FRAM Eligibility > State Eligibility Code |
| Homeless Count | Reports the number of students lacking a fixed, regular, and adequate nighttime residence.
Counts the distinct StateIDs in the roster for the section where Homeless = 1. Integer |
Roster: Course Information > Section > Roster
Homeless: Program Participation > Homeless |
| Foster Care Count | Reports the count of students involved in the Foster Care System.
Counts the distinct StateIDs in the roster for the section where Foster Care = 1. Integer |
Roster: Course Information > Section > Roster
Foster Care: Program Participation > Foster Care |
| Military Connected Count | Reports the count of students with parents/guardians in Active Military Duty.
Counts the distinct StateIDs in the roster for the section where Military Connected = 1. Integer |
Roster: Course Information > Section > Roster
Military: Military Connections > Status |
| Grade Count | Count of students in grade level (95-99, 00-12, 14, 20)
Counts the distinct StateIDs in the roster for the section where Grade = (95-99, 00-12, 14, 20) Integer |
Course Information > Section > Roster |
Appendix A: State Classification Values
The possible values for State Classification are pulled from the locked dictionary within Campus. The current values in this locked dictionary are:
- A1: Principal or head teacher controlled school
- A2: District operated CTE Center (CTC)
- A3: District operated - special ed school
- A4: District operated-preschool program
- A5: District operated alternative program
- A6: KECSAC funded programs
- A7: Miscellaneous: Home/Hospital, Summer
- A8: District operated full-time enrolled online virtual and remote learning program
- B1: Laboratory/training school operated by college/university
- B2: Dual enrollment postsecondary/college-level course program operated by college/university
- C1: University Operated CTE Center
- C2: State Operated CTE Center (ATC)
- D1: State Dept. of Ed operated (Blind & Deaf)
- F1: Fed. Dependent School (Ft. Knox & Ft. Campbell)
- F2: Federal Job Corps
- F3: Federally funded stand-alone Head Start
- J1: Roman Catholic
- M1: Other religion
- M2: 7th Day Adventist
- R1: Private, non-public schools/programs
- C3: State operated vocational program-college
- C4: State operated-voc. health occupation school
- C5: State vocational program
