Calendar Report (Kentucky)

PATH: KY State Reporting > Calendar Report

The Calendar Report is used to prove compliance with minimum number of instructional days and hours per year per school board approved calendar. This report also helps the Kentucky Department of Education audit instructional time, district holidays, weather related days and student attendance days.

Image 1: Calendar Report Editor

Report Editor

Editor Field

Description

Is Amended Calendar

Indicates whether the calendar was amended within the report.

Calendar Type

Indicates whether the reported calendar(s) is a regular or alternative calendar.

Board Approval Date

The date the School board approved the reporting calendar(s).

Exclude Calendars with State Exclude

If set to Yes, all calendars marked as State Exclude will not be included within the report.

Override NTI Instructional Minutes

Checking this means the value in the Override NTI Instructional Minutes field will report as the Instructional Time for days with a Day Event of N: Non-Traditional Instruction. 

 

Reported NTI Instructional Minutes can be longer than the Standard Day for the calendar.

If the Kentucky Department of Education has determined NTI days should be counted as a specific number of minutes, use this field to set the number of Instructional Minutes that will be reported.

Format

The format of the generated report. For submission to the state, select the State Format (Fixed Width).

Calendars

The calendar(s) reporting data.

Generating the Report

  1. Select whether or not the reporting calendar Is an Amended Calendar
  2. Select the Calendar Type
  3. Enter the Board Approval Date of the reporting calendar.
  4. Determine whether or not State Excluded calendars should be included within report data by selecting a Exclude Calendars with State Exclude value.
  5. If the Kentucky Department of Education has determined NTI days should be counted as a specific number of minutes, mark the Override NTI Instructional Minutes checkbox and enter the number of instructional minutes reported.
  6. Select the Format. To review data prior to submission to the state, select HTML or PDF. When submitting data to the state, select the State Format (Fixed Width).
  7. Select which Calendar(s) to report data.
  8. Click the Generate Extract button. 

Image 2: Calendar Report - HTML Format

Report Logic and Calculations

The following describes field-level logic and calculations used in the Calendar Report.

Calendar Days

  • A calendar day is any day that outputs on the report, regardless of information for that day.
  • Includes all Calendar Days on the report.
  • A day is not considered a calendar day if School Day, Instruction, and Attendance checkboxes are unmarked on the Days tab (where Day.instruction, Day.attendance, and Day.SchoolDay = 0 or NULL) AND no day event exists.
    • These days are excluded and are not output on the report.
    • Include all other days as calendar days if they do not meet this criteria.

 School Days

  • School Days are those days considered to be school month days.
  • Increment the Day of School Atten Month field in the report if day is considered to be a school day.
    • If a day is determined to not be a school day, this field would output as 00 if the day is determined to be a calendar day, but not a school day.
  • If Day Event = R: Regular, or no day event exists, the following logic will apply:
    • If the School Day checkbox is marked on the Days tab, the day counts as a school day.
    • If the Instructional Day checkbox is marked but the School Day checkbox is unmarked, the day counts as a school day.
  • The following Day Events are not considered school days and will not increment the Days of School Atten Month column (column would output as 00):
    • W: Weather Day
    • K: Break
    • U: Make Up
    • M: Other
    • I: Closed Due to Illness
  • The following Day Events are considered School Days and will increment the Days of School Atten Month column:
    • C: Closing

    • D: Disaster

    • E: Teacher Equivalency

    • G: Planning

    • H: Holiday

    • L: Low Attn Weather (SAAR)

    • N: Non-traditional Instruction

    • O: Opening

    • P: Professional

    • R: Regular

    • Z: Health and Safety Low Attn (No longer allowed to be selected as a value after Release Pack .1721. Users can still report on historical data). 

 Instructional Days

  • Instructional days are calculated and reported in the Instructional Time column.
  • If Instructional Day is marked on the Days tab, the day is considered an instructional day. 
  • Instructional minutes are calculated for any day where Day.instruction = 1 and the Day Event is:
    • R: Regular

    • L: Low Attn Weather (SAAR)

    • N: Non-traditional Instruction

    • Z: Health and Safety Low Attn

Non - Instructional Days

  • Instructional time is reported as 000, even if Day.instruction = 1, for the following Day Events:
    • H: Holiday
    • W: Weather Day
    • D: Disaster
    • K: Break
    • U: Make Up
    • O: Opening
    • C: Closing
    • G: Planning
    • P: Professional
    • E: Teacher Equivalency

Lowest Yearly Aggregate Calculation and Logic

The Lowest Year Aggregate is calculated when the selected calendar contains more than one schedule structure.

Before reporting calculated days on the report, logic first determines which schedule structure for the reporting calendar has the lowest number of minutes for the year and uses the days from the schedule structure with the lowest yearly aggregate minutes for reporting data.

First, logic will calculate instructional time for each instructional day of the year by period schedule if the day falls within a school month. Once this is complete, a calculation totaling the sum of all days within a period schedule will take place.

Second, logic will calculate a sum of minutes for each schedule structure. The schedule structure with the fewest yearly minutes is identified and School Months and Day information is used from this schedule structure within the calendar.

If schedule structure does not include one of the following grade levels (stateGrade), this schedule structure is excluded from the logic above when calculating lowest yearly aggregate: 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, or 12.

 Instructional Time Calculation and Logic

The following logic is used when determining a day to be an instructional day.

  • Regular Instructional Days
  • Low Attn Weather (SAAR)
    • These are treated as regular days and output as R or Regular on the report.
  • N: Non-traditional Instruction

    • Treat as regular days – output as N and Nontraditional on the calendar report.

    • Instructional minutes will report the value in the Override NTI Instructional Minutes field on the extract editor when populated.
      • The reported NTI Instructional Minutes can be longer than the Standard Day for the calendar.
  • Z: Health and Safety Low Attn

    • Treat as regular days – output as R and Regular on the calendar report 

      No longer allowed to be selected as a value after Release Pack .1721. Users can still report on historical data.

  • Shortened Days
    • If DayEvent.instructionalMinutes > 0, then:
      • If DayEvent.instructionalMinutes > DayDetail.DayDuration, DayDetail.DayDuration is used.
      • Otherwise, DayEvent.instructionalMinutes is used.
    • If end time or start time exists and DayEvent.instructionalMinutes is null, logic subtracts Day Duration from non-instructional time in instructional periods from the period schedule to determine instructional minutes.
  • If day instruction is unmarked, Instructional Time on the report will report as 000 if the day is included in the report.

The following describes logic for including days:

Calendar Report Layout

Element Name

Description

Type, Format and Length

Campus Location

Campus Interface

District Number

The District Number of the district reporting data.

Numeric, 3 digits
 
###

District.number

System Administration > Resources > District Information > State District Number

School Number

The State School Number of the school reporting data.

Numeric, 3 digits
   
###

School.number

System Administration > Resources > School > Location Number

School Year

The school year reporting data. The end year of the school year is reported. For example, 2012 is the end year of the 2011-2012 school year.

Numeric, 4 digits
 
YYYY

N/A

System Administration > Calendar > School Years

School Month

The district school month reporting data. Reported values correspond to each month's numeric value (i.e., June would report as 06).

Numeric, 2 digits
 
##

N/A

System Administration > Calendar > Calendar > School Months > Name

Day of School Atten Month

The day of the month reporting data. Reported values correspond to each day's numeric value (i.e., the 5th day of the month would report as 05).
 
If Day.schoolDay = 0, the day is excluded. If Day.instruction = 0 or DayEvent.type = K, W or H, a value of 00 is reported.
 
See the School Days logic section for more information about how this field is calculated.

Numeric, 2 digits
 
##

Calculated, not dynamically stored

Calculated, not dynamically stored

Calendar Date

The calendar date being reported. Reported values correspond to the numeric value of the day being reported (i.e., May 30th, 2012 would report as 053012).
 
If Instructional Day, School Day and Attendance Day is unmarked for the reported date and no events occur on this date, then the date is not reported.

Numeric, 6 digits
 
MMDDYY

N/A

System Administration > Calendar > Calendar > Days > Day Detail > Date

Day of Week

Indicates the reporting date's day of the week. 

  • 1 = Monday
  • 2 = Tuesday
  • 3 = Wednesday
  • 4 = Thursday
  • 5 = Friday
  • 6 = Saturday
  • 7 = Sunday

Numeric, 1 digit

Calculated, not dynamically stored

Calculated, not dynamically stored

Calendar Code

Indicates the report date's day type code.
 
See the Day Types table for more information.

Alphanumeric, 1 character

N/A

System Administration > Calendar > Calendar > Days > Day Event > Type

Calendar Code Description

The description of the day type code reported for the calendar.
 
See the Day Types table for more information.

Alphanumeric, 20 characters

N/A

System Administration > Calendar > Calendar > Days > Day Event > Type

Student Attend Day

Indicates whether or not attendance is taken on the reporting day.

Alphanumeric, 1 character
 
Y or N

N/A

System Administration > Calendar > Calendar > Days > Day Detail > Attendance

Occasion

Lists any Comments entered in the Day Event editor. If Comments are left blank, the day of the week is filled in.

Alphanumeric, 20 characters

N/A

System Administration > Calendar > Calendar > Days > Day Event > Comments

Day Type

Indicates the report date's day type.
 
See the Day Types table for more information.


N/A

System Administration > Calendar > Calendar > Days > Day Event > Type

Instructional Time

Indicates the amount of Instructional minutes per day.
 
See the Instructional Days Logic and Instructional Time Calculation and Logic sections for more information.

Numeric, 3 digits
 
###

N/A

Calculated from System Administration > Calendar > Calendar > Periods

Is Amended Calendar

Indicates if the reporting calendar has been amended.

Alphanumeric, 1 character
 
Y or N

N/A

Based on the value selected in the Is Amended field on the report editor.

Calendar Type

Indicates the type of calendar reporting data. 

  • R = Regular
  • A = Alternative

Alphanumeric, 1 character

N/A

Based on the value selected in the Calendar Type field on the report editor.

Board Approved Date

The date the school board approved the calendar. Reported values correspond to the numeric value of the day being reported (i.e., May 30th, 2012 would report as 053012).

Numeric, 6 digits

N/A

Based on the value entered in the Board Approved Date field on the report editor.

 Day Type Values

Description

Day Type Code

Closing Day

C

Disaster Day

D

Equivalent Day (teacher)

E

Planning Day

G

Holiday

H

Break Day

K

Other

M

Opening Day

O

Professional Development Day

P

Regular

R

Make Up

U

Weather Day

W