Tool Search: KECS LEAD Extract
The Kentucky Educator Credentialing System (KECS) Local Educator Assignment Data (LEAD) Extract includes data on classes, staff, schoolwide, and caseload with student counts and individual data on staff. There is also an issues report that details any issues with the data used in the other reports. The data format produced by Campus (CSV or HTML) will be provided to users for further analysis and use. The data collected allows users to detect data issues before sending their data to the state.KECS LEAD Extract
Available KECS LEAD Extract Reports
The following reports are available. Follow the link to see specific report logic and instructions on generating individual extracts:
Report Population and Business Rules
# | Requirements |
---|---|
R1 | The report can be run against a district’s active year as well as any prior year. |
R2 | The report can be run in District Editions. |
R3 | The report will be generated in CSV or HTML format. |
R4 | The report will be produced with a custom name. |
R4.BR1 | The file name will be produced in the following format: KECS_LEAD_ReportName.csv |
R5 | The report will generate a detail list for other reports to pull information from (DETAIL). |
R5.BR1 | Enrollments must be active AND student must be rostered on the last day of the section to be included in the report. |
R5.BR2 | Courses must be active to be included in the report. |
R5.BR3 | Calendar year should overlap the Extract Editor date ranges. |
R5.BR4 | Schools must have a State Classification of A1, A2, A3, A4, A5, A6, A7, A8, B1, B2, C1, C2, or D1 to be included in the report. |
R5.BR5 | Calendars and Grade Levels marked as ‘exclude’ within Infinite Campus are still included in this report. |
R5.BR6 | Enrollments marked as ‘exclude’ within Infinite Campus are still included in this report. |
R5.BR7 | Exclude all enrollments marked as no shows. |
R5.BR8 | Exclude all calendars marked as summer school. |
R5.BR9 | If a student has multiple active enrollments, use the last (most recent) enrollment. If there are multiple active enrollments with the same start dates and same end dates (or all end dates null), look at Service Type P, then highest enrollmentID |
R6 | The report will generate an aggregated list of course sections for a given calendar (CLASSES). |
R6.BR1 | CLASSES will pull all records from the DETAIL report. |
R6.BR2 | CLASSES should contain courses that have no students assigned to them. |
R6.BR3 | CLASSES will group 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 |
R6.BR4 | CLASSES will sort by the following in ascending order:
|
R7 | The report will generate a list of active staff for a given calendar (STAFF). |
R7.BR1 | Staff must have both a District Assignment and District Employment record that overlap reported school year (7/1-6/30) to be considered active staff. |
R7.BR2 | STAFF will sort by the following in ascending order:
|
R8 | The report will generate an aggregated list of information for the school (SCHOOLWIDE). |
R8.BR1 | SCHOOLWIDE will select records from DETAIL where:
|
R8.BR2 | SCHOOLWIDE will group by: End Year, District Number, District Name, School Number, School Name, State Classification |
R8.BR3 | SCHOOLWIDE will sort by the following in ascending order:
|
R9 | The report will generate an aggregated list of information for each case manager (CASELOAD). |
R9.BR1 | CASELOAD will select records from DETAIL where:
|
R9.BR2 | CASELOAD will group by: End Year, District Number, District Name, Case Manager Person ID |
R9.BR3 | CASELOAD will sort by the following in ascending order:
|
R10 | The report will generate a list of issues with the data used in other reports (ISSUES). |
Report Editor
LEAD Extract Editor Options
Field | Description |
---|---|
Date Range | Determines a date range for the report. Dates are entered in mmddyyyy format or used the calendar icon to select a date. The Start Date field may be left blank in order to pull data from the beginning of the selected school year. The End Date field can have an end date of the last day of the school year, or the current date. |
Format | Determines how the report will be generated. Options include CSV and HTML to review data prior to submission. |
Exclude Cross-Site Data | When marked checkbox is marked, the report does not include cross-site homeroom data. Cross-site must be enabled at the district level for this checkbox to display. This checkbox defaults to marked. |
Report(s) |
|
Select Calendar | Determines the Calendars to include on the report. Calendars can be sorted by Active Year, List by School or List by Year. Multiple calendars can be chosen by using the CTRL and SHIFT keys. |
Generate the KECS LEAD Extract
- Enter a Date Range for the report.
- Select the Format of the report.
- When applicable, mark the Exclude Cross-Site Data checkbox.
- Choose which Report(s) to include.
- Select the Calendars to include on the report.
- Click Generate Extract or Submit to Batch.