Calendars

This category represents information about sessions, grading periods, and calendars as published within the Education Organization Calendar category. The Organization Calendars category includes the following data views and resources:

eSP Source Data

Tables: REG_CALENDAR (cal), REG_BUILDING (rb)

Selection Criteria

One calendar is published for each school calendar in the current school year where:

building is not transfer building, not out-of-district
calendar has a valid TX CalendarType, C215

Resource Output

The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Resource	Data Element	Description	TX Element	TX Element Name	eSP Source	Required?	Comments
calendars
	code		E0975	INSTRUCTIONAL-TRACK-INDICATOR-CODE	reg_calendar.state_code_equiv	Y - key	Left-zero-pad to 2 chars - valid values are '00' - '99'
	schoolId		E0266	CAMPUS-ID	reg_calendar.building	Y - key
	schoolYear		E1093	SCHOOL-YEAR	reg_calendar.schoolYear	Y - key
	calendarTypeDescriptor		E1600	INSTRUCTIONAL-PROGRAM-TYPE	txtb_program_crosswalk.instructional_program where txtb_program_crosswalk.school_year = reg_calendar.school_year and txtb_program_crosswalk.building = reg_calendar.building and txtb_program_crosswalk.calendar_sce = reg_calendar.state_code_equiv. If no value found, default '01'	Y
	additional fields for display only
					reg_building.name		district view only
					TERMS.firstday		School year term
					TERMS.lastday		School year term
					Sum of cd.membershipvalue or 1 for all in-session days in track		Sum of cd.membershipvalue if > 0 else 1 for in-session dates between start and end of school year term; Same for track calendars but only include in-session dates where track is checked

calendarDates

eSP Source Data

Tables: REG_CAL_DAYS (rcd), REGTB_DAY_TYPE (rdt), REG_BUILDING (rb), TX_REG_CAL_DAYS (trcd)

Selection Criteria

One calendarDate is published for each rcd record for each school calendar in the current year where:

building is not transfer building, not out-of-district
calendar has a valid TX CalendarType, C215
date is in-session or waiver day - other days are not published (e.g. weekends, holidays, etc.)

Resource Output

The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Resource	Data Element	Description	TX Element	TX Element Name	eSP Source	Required?	Comments
calendarDates
	date		E1168	CALENDAR-DATE	rcd.cal_date	Y - key	All dates between start and end of school year term
	calendarReference				Parent element	Y - key
		calendarCode	E0975	INSTRUCTIONAL-TRACK-INDICATOR-CODE	rcd.calendar	Y - key	publish state_code_equiv from reg_calendar, left-zero-pad to 2 chars
		schoolId	E0266	CAMPUS-ID	rcd.building	Y - key
		schoolYear	E1093	SCHOOL-YEAR	rcd.school_year	Y - key
	calendarEvents				[Array]	Y	Multiple calendarEvents possible in model, only 1 for TX
		calendarEventDescriptor	E1582	SCHOOL-DAY-EVENT-CODE	default is '01' ; report '02' only if the not in-session (rcd.membership_day = 'N') and there is a value in trcd.waiver_type	Y	descriptors include only 01 - Instructional Day and 02 - Waiver Day
	TX extensions
		calendarWaiverEventTypeDescriptor	E1570	CALENDAR-WAIVER-EVENT-TYPE	trcd.waiver_type	TX
		schoolDayOperationalMinutes	E1571	SCHOOL-DAY-OPERATIONAL-MINUTES	If Instructional Program of the calendar being processed is in (01, 02,03, 13, 14) then rcd.intruct_time else null	TX	Instructional Program is stored in TXTB_PROGRAM_CROSSWALK. Need to link REG_CAL_DAYS to REG_CALENDAR(rc) by school_year, building, link rc to TXTB_PROGRAM_CROSSWALK on rc.school_year = TXTB_PROGRAM_CROSSWALK.school_year, rc.building = TXTB_PROGRAM_CROSSWALK.building and rc.state_code_equiv = TXTB_PROGRAM_CROSSWALK.calendar_sce
		schoolDayInstructionalMinutes	E1599	SCHOOL-DAY-INSTRUCTIONAL-MINUTES	If Instructional Program of the calendar being processed is not in (01, 02,03, 13, 14) then rcd.intruct_time else null	TX	Instructional Program is stored in TXTB_PROGRAM_CROSSWALK. Need to link REG_CAL_DAYS to REG_CALENDAR(rc) by school_year, building, link rc to TXTB_PROGRAM_CROSSWALK on rc.school_year = TXTB_PROGRAM_CROSSWALK.school_year, rc.building = TXTB_PROGRAM_CROSSWALK.building and rc.state_code_equiv = TXTB_PROGRAM_CROSSWALK.calendar_sce
		schoolDayWaiverMinutes	E1572	SCHOOL-DAY-WAIVER-MINUTES	trcd.waiver_minutes	TX	join trcd to rcd on school_year,building,school_year,summer_school,track,calendar,cal_date
	additional fields for display only
					reg_building.name		district view only

gradingPeriods

eSP Source Data

Tables: REG_MP_DATES (mpd), REG_MP_WEEKS (mpw), REG_CALENDAR (cal), REG_CAL_DAYS (rcd), REG_BUILDING (rb)

Selection Criteria

Not collected by TEA. Publish per Base Profile.
Reporting periods published for each school where:

building is not transfer building, not out-of-district
marking period is mapped to gradingPeriod descriptor

Resource Output

The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Resource	Data Element	Description	TX Element	TX Element Name	eSP Source	Required?	Comments
gradingPeriods
	gradingPeriodDescriptor		N/A	N/A	mapped value from reg_mp_weeks.marking_period	Y - key	Default values or as mapped.
	periodSequence		N/A	N/A	reg_mp_weeks.mp_order	Y - key	marking period last char numeric value, otherwise 1
	schoolId		N/A	N/A	reg_mp_weeks.building	Y - key	N/A
	schoolYear		N/A	N/A	reg_mp_weeks.school_year	Y - key	N/A
	beginDate		N/A	N/A	reg_mp_dates.start_date	Y	N/A
	endDate		N/A	N/A	reg_mp_dates.end_date	Y	N/A
	totalInstructionalDays		N/A	N/A	reg_cal_days.cal_date and membership_day - sum dates for marking period where membership_day = 'Y'	Y	N/A
	additional fields for display only		N/A	N/A	N/A	N/A	N/A
	N/A		N/A	N/A	N/A	N/A	district view only

sessions - scheduling

eSP Source Data

Tables: REG_CALENDAR (cal), REG_CAL_DAYS (rcd), REG_BUILDING (rb), REG_MP_WEEKS (mpw), REG_MP_DATES (mpd)

Selection Criteria

Required by TEA as part of Ed-Fi data model; different from Base profile
Minimal whole-year session record plus terms from REG_MP_WEEKS.TERM

Published for each school for the current year where:

building is not transfer building, not out-of-district
rb.calendar = cal.calendar or rb.calendar is null and cal.calendar is max calendar for building for year
associated rcd has dates with membership_day = 'Y'

For other terms use REG_MP_WEEKS.TERM:

1 and 2 included - publish Semester 1 and Semester 2
1, 2, 3 included - publish Trimester 1 - Trimester 3
1, 2, 3, 4 included - publish Semesters and Quarters

Resource Output

The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Resource	Data Element	Description	TX Element	TX Element Name	eSP Source	Required?	Comments
sessions - scheduling
	sessionName		E3057		term descriptor short description	Y - key
	schoolId		E0266	CAMPUS-ID	reg_calendar.building	Y - key
	schoolYear		E1093	SCHOOL-YEAR	reg_calendar.school_year	Y - key
	beginDate				year term: rcd.cal_date - earliest date for calendar where membership_day = 'Y' other terms: earliest date from mpd for mpw having specified term where rcd.membership_day = 'Y'	Y	multiple reg_mp_weeks records may have same term value
	endDate				year term: rcd.cal_date - last day for calendar where membership_day = 'Y' other terms: latest date from mpd for mpw having specified term where rcd.membership_day = 'Y'	Y	multiple reg_mp_weeks records may have same term value
	termDescriptor				'24' (Year round'), others derived from REG_MP_WEEKS.TERM verify codeValue	Y	For terms from REG_MP_WEEKS.TERM, descriptor determined by term values included in mpw records for building and year: 1 and 2 included - publish Fall & Spring Semester - use core Ed-Fi codeValues 1, 2, 3 included - publish First, Second, Third Trimester - use core Ed-Fi codeValues 1, 2, 3, 4 included - publish semesters & quarters - use core Ed-Fi codeValues
	totalInstructionalDays		E0935	NUMBER-DAYS-TAUGHT	reg_cal_days.cal_date - sum days where membership_day = 'Y'	Y	where rcd.membership_day = 'Y'
	gradingPeriods				[Array]	N	optional, could include if gradingPeriods published; secondary query selecting all marking periods for school during year
		schoolId			mpw.building	Y
		gradingPeriodDescriptor			mpw.marking_period, as mapped to gradingPeriodDescriptors	Y	Include default 'End of Year' gradingPeriod
		periodSequence			mpw.period_order , 1 for 'End of Year' gradingPeriod	Y
		schoolYear			mpw.school_year	Y	where t.yearid = p_yearid
	additional fields for display only
					reg_building.name		district view only

reportingPeriodExts

eSP Source Data

Tables: ATT_INTERVAL (atti), REG_MP_DATES (mpd), REG_CAL_DAYS (rcd), TX_REG_CAL_DAYS (trcd)

Selection Criteria

TEA extension resource for TX Attendance Reporting Periods
Reporting period sessions published for each school where:

building is not transfer building, not out-of-district
ATT_Interval.State_Code_Equiv in (1,2,3,4,5,6,9)

Resource Output

The localEducationAgencies resource is not dependent on the prior publishing of other Ed-Fi resources.
LEAs and Schools may upload (publish) data to the ODS in real time or on-demand ("Run Now" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

Resource	Data Element	Description	TX Element	TX Element Name	eSP Source	Required?	Comments
reportingPeriodExts
	reportingPeriodDescriptor		E0934	REPORTING-PERIOD-INDICATOR-CODE	atti.state_code_equiv	Y - key	'01' - '06', '09' (left-zero-pad to 2 chars)
	calendarDateReference					Y
		calendarCode	E0975	INSTRUCTIONAL-TRACK-INDICATOR-CODE	rcd.calendar	Y - key
		date			rcd.date	Y - key	Need guidance from TEA
		schoolId	E0266	CAMPUS-ID	atti.building	Y - key
		schoolYear	E1093	SCHOOL-YEAR	atti.school_year	Y - key
	beginDate		E1568	REPORTING-PERIOD-BEGIN-DATE	derived from atti.begin_span	Y	atti.begin_span if value is date. Otherwise use mpd.start_date where mpd matches atti on district, school_year and building, and atti.begin_span = mpd.marking_period.
	endDate		E1569	REPORTING-PERIOD-END-DATE	derived from atti.end_span	Y	atti.end_span if value is date. Otherwise use mpd.end_date where mpd matches atti on district, school_year and building, and atti.end_span = mpd.marking_period.
	totalInstructionalDays		E0935	NUMBER-DAYS-TAUGHT	reg_cal_days.cal_date and membership_day - sum dates for reporting period where membership_day = 'Y'	Y	Fred: No records for reporting period 9 in sample data - where applicable, is a separate record created for each ASDY date? A: Yes, where day_type = 'ADSY' (actual value entered)