Tool Search: TN State Reporting > EIS Batch Transmission File
The 010 200 Day Calendar extract is used to upload district calendar information to EIS. District calendars function as a template for school calendars, defining scheduled days and day types.
This extract must be uploaded to EIS prior to any other records, usually the spring prior to the beginning of the next school year.
See the EIS Batch Transmission article for an overview of the EIS Batch Transmission File, logic that applies to all extracts, and generation instructions.
Report Logic
A record reports for each district calendar; a district may have more than one.
District calendars are designated with a Type of D (System Administration > Calendar > Calendar > Type). Records are not reported for calendars marked as Exclude. Calendars with a Number of null, 0, or greater than 2 digits are not reported and display in the warning report. If a record was previously reported and then marked as exclude, a delete record will be sent to EIS for each record.
The Record Key, which helps determine the Type of record sent (New, Edit, or Delete), is comprised of the Record ID, Record Version, District ID, School Year, and Calendar Number.
Calendar Setup
Campus recommends considering the following:
- Calendar names should be unique and easily distinguishable.
- District calendars must have a Type of D. Calendars must have a Number greater than 0.
- Durations must be entered as follows:
- 100 = 1 day
- 050 = 1/2 day
- 033 = 1/3 day
- Use the Print option on the Days tab to review and audit information.
- If districts add Day Events to calendar days, a value must be entered in the Day Event Inst. Minutes field to calculate Total Instructional Minutes correctly.
- Calendar dates constrain enrollment dates.
010 200 Day Calendar Extract Layout
Element Name | Description | Type, Format and Length | Campus Database | Campus Application |
|---|---|---|---|---|
Record ID | Identifies the extract - reports as "010" | Numeric (3) | N/A | N/A |
| Record Version | Identifies the extract version - reports as "01" | Numeric (2) | N/A | N/A |
| Record Type | Identifies the type of extract:
| Character (1) | N/A | N/A |
| Filler | N/A | N/A | N/A | N/A |
| District ID | Reports the TN Department of Education assigned District Number. | Numeric (2) | District.number | System Administration > Resources > District Information > State District Number |
| School Year | Reports the start year of the school calendar. | Date (CCYY) | SchoolYear.startYear | System Administration > Calendar > School Years > Start Year |
| Calendar Number | Reports the identifying number of the calendar. | Numeric, (2) | Calendar.number | System Administration > Calendar > Calendar > Number |
| Instructional Calendar | Defines how the District Calendar operates during the school year. If the date of the first day with a Day Event Type of AS is before August 1st, reports as Y. Otherwise reports as T. | Character (1) | Day.date DayEvent.Type | System Administration > Calendar > Calendar > Days > Day Event Type |
| Scheduled Days | Identifies the days of the week that students will be attending school. Holidays are identified with Day Event Types of OH, CH, and SH. The date window is established using the first and last days of the calendar marked as instructional. If a calendar day is marked as instructional and scheduled every Saturday, reports as 2. Otherwise reports as 1. | Numeric (1) | Day.date Day.instruction DayEvent.type | System Administration > Calendar > Calendar > Day |
| Stockpile Inclement Weather Days | Identifies the number of stockpile days that have been designated for inclement weather. Reports the SP Inclement Weather days entered on the calendar. | Numeric (2) | Calendar.track | System Administration > Calendar > Calendar > SP Inclement Weather |
| Stockpile Professional Development Days | Identifies the number of stockpile days that have been designated for professional development. Calculated by summing the Day Event Duration of all days with a Type of SP. If the sum cannot be divided evenly by 100, reports as blank. Otherwise reports the sum divided by 100. | Numeric (2) | DayEvent.duration DayEvent.type | System Administration > Calendar > Calendar > Days > Day Event Type |
| In Service Days | Identifies the number of days designated as discretionary In-Service days. Calculated by summing the Day Event Duration of all days with a Type of IS. If the sum is not evenly divisible by 100, reports the sum divided by 100. This field reports with an implied decimal. For example, 1.33 days reports as 0133. | Numeric (4) | DayEvent.duration DayEvent.type | System Administration > Calendar > Calendar > Days > Day Event Type |
| Optional In Service Days | Identifies the number of days allocated for individual choice of professional development activities. Calculated by summing the Day Event Duration of all days with a Type of IO. If the sum is not evenly divisible by 100, reports the sum divided by 100. This field reports with an implied decimal. For example, 1.33 days reports as 0133. | Numeric (4) | DayEvent.duration DayEvent.type | System Administration > Calendar > Calendar > Days > Day Event Type |
| Parent Teacher Conference Days | Identifies the number of days allocated for parent and teachers to meet. Calculated by summing the Day Event Duration of all days with a Type of PT. If the sum cannot be divided evenly by 100, reports as blank. Otherwise reports the sum divided by 100. | Numeric (1) | DayEvent.duration DayEvent.type | System Administration > Calendar > Calendar > Days > Day Event Type |
| Teacher Vacation Days | Identifies the number of days allocated for teacher paid vacation. Calculated by summing the Day Event Duration of all days with a Type of TV, CH, SH, or OH. If the sum is not evenly divisible by 100, reports the sum divided by 100. | Numeric (2) | DayEvent.duration DayEvent.type | System Administration > Calendar > Calendar > Days > Day Event Type |
| Abbreviated Days | Identifies the number of instructional days shortened to less than the state minimum of 6.5 hours. Calculated by summing the Day Event Duration of all days with a Type of AD. If the sum cannot be divided evenly by 100, reports as blank. Otherwise reports the sum divided by 100. | Numeric (1) | DayEvent.duration DayEvent.type | System Administration > Calendar > Calendar > Days > Day Event Type |
| Discretionary Teacher Vacation Days | Identifies the number of days designated as discretionary Teacher Vacation days. Calculated by summing the Day Event Duration of all days with a Type of OV. If the sum is not evenly divisible by 100, reports the sum divided by 100. This field reports with an implied decimal. For example, 1.33 days reports as 0133. | Numeric (4) | DayEvent.duration DayEvent.type | System Administration > Calendar > Calendar > Days > Day Event Type |
| Discretionary In Service Days | Identifies the number of days designated as discretionary In-Service days. Calculated by summing the Day Event Duration of all days with a Type of OS. If the sum is not evenly divisible by 100, reports the sum divided by 100. This field reports with an implied decimal. For example, 1.33 days reports as 0133. | Numeric (4) | DayEvent.duration DayEvent.type | System Administration > Calendar > Calendar > Days > Day Event Type |
| Discretionary Administrative Days | Identifies the number of days designated as discretionary administrative days. Calculated by summing the Day Event Duration of all days with a Type of OA. If the sum is not evenly divisible by 100, reports the sum divided by 100. This field reports with an implied decimal. For example, 1.33 days reports as 0133. | Numeric (4) | DayEvent.duration DayEvent.type | System Administration > Calendar > Calendar > Days > Day Event Type |
| Discretionary Instructional Days | Identifies the number of days designated as discretionary instructional days. Calculated by summing the Day Event Duration of all days with a Type of OI. If the sum is not evenly divisible by 100, reports the sum divided by 100. This field reports with an implied decimal. For example, 1.33 days reports as 0133. | Numeric (4) | DayEvent.duration DayEvent.type | System Administration > Calendar > Calendar > Days > Day Event Type |
| Discretionary Other Days | Identifies the number of days designated as discretionary other days. Calculated by summing the Day Event Duration of all days with a Type of OO. If the sum is not evenly divisible by 100, reports the sum divided by 100. This field reports with an implied decimal. For example, 1.33 days reports as 0133. | Numeric (4) | DayEvent.duration DayEvent.type | System Administration > Calendar > Calendar > Days > Day Event Type |
| Instructional Days | Identifies the number of days of classroom instruction. The date window is established using the first day with a Type of CS and the last day with a Tye of CE. Calculated by summing the following two values:
| Numeric (3) | Day.date Day.instruction DayEvent.duration DayEvent.type | System Administration > Calendar > Calendar > Day |
| Filler | N/A | N/A | N/A | N/A |
