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:

calendar

One calendar per reporting school.

Primary PowerSchool Source Data

SCHOOLS (sch),
S_TX_SCH_SCHOOLS_X (xt),
S_TX_SCH_SCHOOLS_C (xtc)

Selection Criteria

Records are published if the following criteria are met:

A calendar type must be selected.
The school must not be excluded from state reporting.
The Exclude School from Instructional Calendar checkbox is not selected.
Additionally, one calendar is published for each school track in S_TX_SCH_SCHOOLS_C where:
- xtc.instructional_program_type is not null

Resource Output

Data Element	TX Element	Description	Data Type	Stored in [Table]Field	Required?
schoolReference A reference to the related school resource.
calendarCode	E0975	INSTRUCTIONAL-TRACK-INDICATOR-CODE Blank/Default Track = 00 A = 01, B = 02, C = 03, D = 04, E = 05, F = 06 For the Additional School Days Program (currently reported in the Extended Year Summer School PEIMS Required?) Track is defaulted to 99 in all records.	Date	CalendarName	Required
/schoolID	E0266	CAMPUS-ID The school for which the calendar date is defined (state-assigned schoolId)	Integer	Derived from: [Calendar_Day]SchoolId	Required
schoolYearTypeReference A reference to the related schoolYearType resource.
SchoolYear	E1093	SCHOOL-YEAR Select the school year from the list.	Integer	SchoolNumberPrefix	Required
calendarTypeDescriptor	E1600	Each Track is required to have an INSTRUCTIONAL-PROGRAM-TYPE E1600 The calendar types: Student Specific Elementary Student Specific Secondary Student Specific Non-Compulsory	String	InstructionalProgramType	Required

Calendar Dates

This view captures basic information about current year calendar dates as published in the calendarDates resource within the Education Organization Calendar category. The layout includes the School Name, Date, Last Publish Date, Publishing ID, Resource ID.

calendarDates

This resource represents a day in the school calendar.

Primary PowerSchool Source Data

[Calendar_Day]

Selection Criteria

Records are published if the following criteria are met:

A record is reported for each in-session day for the school and each Track where the track is also checked.
Non-In-Session Days are published only if there is a non-NULL value in S_TX_CLD_X.Waiver_Event_Type_Code or S_TX_CLD_C.Waiver_Event_Type_Code
Otherwise non-in-session days are not published; for example, Holidays and Weekends are not published.
Dependency if corresponding school/track calendar is not published
The Event duration is more than one.
The school must not be excluded from state reporting.
The calendar date for the district or the school falls within the year for the Term selected in the PowerSchool UI.

Resource Output

A separate calendarDates record is published for each day for the district, and for each school within the year for the Term selected in the PowerSchool UI.
CalendarDates records include both instructional and non-instructional days.
As multiple events may occur on the same date, a separate calendar event is published for each unique combination of duration and eventDescriptor within the calendarEvent complex type.
The calendarDates resource is dependent on the prior publishing of Ed-Fi resources: schools.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real-time or on-demand (“Run Now” button).

Click Export to export the data collection results to a spreadsheet application.

Data Element	TX Element	Description	Data Type	Stored in [Table]Field	Required?
date	E1168	CALENDAR-DATE The month, day, and year of the CalendarDate.	Date	[CalendarDay]Date_Value	Required
calendarReference
calendarCode	E0975	INSTRUCTIONAL-TRACK-INDICATOR-CODE	Integer		Required
schoolID	E0266	CAMPUS-ID The school for which the calendar date is defined.	Integer	Derived from: [Calendar_Day]CampusID	Required
schoolYear	E1093	SCHOOL-YEAR	Integer
calendarEvents An unordered collection of calendarDateCalendarEvents.
/calendarEventDescriptor	E1582	SCHOOL-DAY-EVENT-CODE The type of scheduled or unscheduled event for the day, for example, Instructional day, Teacher only day, Holiday.	Descriptor descriptors include only 01 - Instructional Day and 02 - Waiver Day	S_TX_CLD_X.Waiver_Event_Type_Code S_TX_CLD_C.Waiver_Event_Type_Code Additional Logic for Operational Minutes vs. Instructional Minutes based on Instructional Program Type Code (E1600) S_TX_SCH_SCHOOLS_X.Instructional_Program_Type S_TX_SCH_SCHOOLS_C.Instructional_Program_Type	Required
TX extension
calendarWaiverEventTypeDescriptor	E1570	CALENDAR-WAIVER-EVENT-TYPE The school for which the calendar date is defined.	Integer	S_TX_CLD_X.Waiver_Event_Type_Code S_TX_CLD_C.Waiver_Event_Type_Code Additional Logic for Operational Minutes vs. Instructional Minutes based on Instructional Program Type Code (E1600) S_TX_SCH_SCHOOLS_X.Instructional_Program_Type S_TX_SCH_SCHOOLS_C.Instructional_Program_Type	Required
schoolDayOperationalMinutes	E1571	'SCHOOL-DAY-OPERATIONAL-MINUTES EITHER Operational OR Instructional Minutes are reported based on the Instructional Program Type (E1600) assigned to the blank/default track or to the Additional Tracks in Schools/School Info. A track cannot be reported with both types. In one case, no minutes are reported. Operational Minutes are reported for Instructional Program Types 01, 02, 14 (these are the most common) Instructional Minutes are reported for Instructional Program Types 03-12 and 15-16 No minutes are reported for Instructional Program Type 13 (JJAEP - Juvenile Justice	Integer	School Calendar Override Blank Track: S_TX_CLD_X.School_Day_Minutes Add'l Tracks: S_TX_CLD_C.Track and .School_Day_Minutes Bell Schedule Override Blank Track: S_TX_BSD_X.Default_Day_Minutes Add'l Tracks: S_TX_BSD_TRACK_C.Track and .Default_Day_Minutes Defaults Blank Track: S_TX_SCH_SCHOOLS_X.Default_Day_Minutes Add'l Tracks: S_TX_SCH_SCHOOLS_C.Track and .Default_Day_Minutes	Required
schoolDayInstructionalMinutes	E1599	SCHOOL-DAY-INSTRUCTIONAL-MINUTES	Integer	Same sources as OperationalMinutes above
schoolDayWaiverMinutes	E1572	SCHOOL-DAY-WAIVER-MINUTES	Integer	Blank Track: S_TX_CLD_X.Waiver_Minutes Add'l Tracks: S_TX_CLD_C.Track and .Waiver_Minutes	Required

Grading Periods

This view captures the grading periods defined at each school within the district as published in the gradingPeriods resource within the Education Organization Calendar category. The layout provides the School Name, Name of Term, Descriptor, First Day of Term, Last Day of Term, Total Instruction Days, Period Sequence, Last Publish Date, Publishing ID, and Resource ID.

gradingPeriods

This resource represents the time span for which grades are reported.

Primary PowerSchool Source Data

TERMS (t), TERMBINS (tb)
Uses mapping for Terms and misc mapping for TermBins

Selection Criteria

Records are published if the following criteria are met:

One record published for each mapped terms record where the school must not be excluded from state reporting.
The term or term portion associated with the grading period exists within the year for the Term selected in the PowerSchool UI.
One record also published for each mapped TermBins storecode where Storecode does not match a term abbreviation and School is not excluded from reporting

Resource Output

The gradingPeriods resource is dependent on the prior publishing of the following resources: calendarDate.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).

Click Export to export the data collection results to a spreadsheet application.

Data Element	Description	Data Type	Stored in [Table]Field	Required?
schoolReference A reference to the related school's resource.
gradingPeriodDescriptor	GradingPeriodDescriptor - The name of the period that grades are reported	Descriptor	Derived from: [Terms]Portion [Terms]Abbreviation	Required
periodSequence	The sequential order of this period relative to other periods.	Integer	When [GradingPeriods]Portion = 1: '1' Otherwise derived from: [Terms]Abbreviation	Required
/schoolID	The school for which the grading period is defined.	Integer	Derived from: [Terms]SchoolID	Required
beginDate	Month, day, and year of the first day of the grading period.	Date	[Terms]FirstDay Format:'YYYY-MM-DD'	Required
totalInstructionalDays	Total days available for educational instruction during the grading period.	Integer	Derived from: [Calendar_Day]Date_Value Count of distinct in-session days that fall between the first day and last day of term record for the school	Required
endDate	Month, day, and year of the last day of the grading period.	Date	[Terms]LastDay Format:'YYYY-MM-DD'	Required

Sessions (Terms)

This view captures the sessions/terms defined at each school within the district as published in the sessions resource within the Education Organization Calendar category. Ed-Fi sessions are the equivalent of PowerSchool terms. The layout provides the School Name, Name of Term, Descriptor, Year, First Day of Term, Last Day of Term, Last Publish Date, Publishing ID, and Resource ID.

sessions

This resource represents the prescribed span of time when an education institution is open, instruction is provided, and students are under the direction and guidance of teachers and/or educational institution administration. A session may be interrupted by one or more vacations.

Primary PowerSchool Source Data

[Terms]

Selection Criteria

Records are published if the following criteria are met:

The school must not be excluded from state reporting.
The term or term portion exists within the year for the Term selected in the PowerSchool UI.

Resource Output

A separate sessions record is published for each unique term record at each school based on [Terms]Portion and [Terms]Abbreviation.
The gradingPeriodReference complex type includes a reference to each unique grading period associated with the session (refer to the Organization Calendars#gradingPeriods resource for additional information).
The sessions resource is dependent on the prior publishing of the following resources: schools.
LEAs and Schools may upload (publish) data to the Ed-Fi ODS in real time or on-demand (“Run Now” button).

Click Export to export the data collection results to a spreadsheet application.

Data Element	Description	Data Type	Stored in [Table]Field	Required?
schoolReference A reference to the related schools resource.
/schoolID	Relates the session to the school.	Integer	Derived from: [Terms]SchoolID	Required
schoolYearTypeReference A reference to the related schoolYearType resource.
/schoolYear	The identifier for the school year.	Integer	[Terms]YearID	Required
termDescriptor	The term for the session during the school year.	Descriptor	Derived from: [Terms]Portion [Terms]Abbreviation	Required
SessionName	The identifier for the calendar for the academic session, for example, 2010/11, 2011 Summer.	String	[Terms]Name	Required
beginDate	Month, day, and year of the first day of the session.	Date	[Terms]FirstDay Format:'YYYY-MM-DD'	Required
endDate	Month, day, and year of the last day of the session.	Date	[Terms]LastDay Format:'YYYY-MM-DD'	Required
totalInstructionalDays	The total number of instructional days in the school calendar for the session.	Integer	Derived from: [Calendar_Day]Date_Value Count of distinct in-session days that fall between the first day and last day of term record for the school	Required
sessionGradingPeriods An unordered collection of sessionGradingPeriods. Grading periods associated with the session calendar.
/gradingPeriodReference A reference to the related gradingPeriods resource.
//schoolId	The school for which the grading period is defined.	Integer	Derived from: [Terms]SchoolID	Required
// grading perioddescriptor	The name of the grading period during the school year in which the grade is offered (e.g., 1st cycle, 1st semester)	Descriptor	Derived from: [Terms]Portion [Terms]Abbreviation	Required
periodSequence	The sequential order of this period relative to other periods.	Integer	When [GradingPeriods]Portion = 1: '1' Otherwise derived from: [Terms]Abbreviation	Required
/schoolYear	The identifier for the school year.	Integer	[Terms]YearID	Required
beginDate	Month, day, and year of the first day of the session.	Date	[Terms]FirstDay Format:'YYYY-MM-DD'	Required

reportingPeriodExts

TEA extension resource for TX Attendance Reporting Periods.

Primary PowerSchool Source Data

CALENDAR_DAY (cd)
TERMS (t)
SCHOOLS (sch)
PREFS (p)
S_TX_CLD_X (cdx) (ADSY_DAY = 0 for normal, ADSY_DAY = 1 for ADSY)
S_TX_SCH_SCHOOLS_C(sch_c)

Selection Criteria

One session record is published for each TERM defined for a school where:

School is not excluded from state reporting
Term portion = 6
Required in TX school setup to use as reporting periods
These term records are also published as regular scheduling terms

Publishes ADSY reporting periods:

For each school having ADSY days for current school year
ReportingdPeriod descriptor '9'
Separate record for each combination of school, date, and calendar

Additional guidance needed from TEA

Note: For multiple schools reporting as one: Identify the main school / select one school

'Main School' has the official CDC number in the School Number field
Additional schools reporting under the same CDC number have this populated in the Alternate School Number field
In this scenario, any track calendars in common among the schools must match exactly
Track calendars do not need to match if only 1 school is using the Track

Report Output

Data Element	TX Element	Description	Data Type	Stored in [Table]Field	Required?
reportingPeriodDescriptor	E0934	REPORTING-PERIOD-INDICATOR-CODE Reporting Period descriptor code values: '1' - '6' - regular TX reporting periods published from Terms table '7' & '8' - OFSDP credit recover, first & second session - not used in any PS districts '9' - Additional School Year Days (ADSY)	Integer	Derived in code based on t.portion and t.abbreviation '9' for ADSY session	Required
calendarDateReference
Calendar Code	E0975	INSTRUCTIONAL-TRACK-INDICATOR-CODE Blank/Default Track = 00 A = 01, B = 02, C = 03, D = 04, E = 05, F = 06 For the Additional School Days Program (currently reported in the Extended Year Summer School PEIMS Required?) Track is defaulted to 99 in all records.	Integer	Integer	Required
date	N/A	Reporting Periods 1-6 - calendar days where insession = 1 Reporting Period 9 - S_TX_CLD_X.ADSY_Day	date	Date	Required
schoolId	E0266	CAMPUS-ID State-assigned value based on t.schoolid	schoolId	Integer	Required
schoolYear	E1093	SCHOOL-YEAR	schoolYear	Integer	Required
beginDate	E1568	t.firstday; earliest ADSY date / In Session Day in year from xt for term descriptor '09' / 1-6 REPORTING-PERIOD-BEGIN-DATE	t.firstday; earliest ADSY date in year from xt for term descriptor '09'	Date	Required
endDate	E1569	t.lastday; last ADSY date / In Session Day in year from xt for term descriptor '09' / 1-6 REPORTING-PERIOD-END-DATE	t.lastday; last ADSY date in year from xt for term descriptor '09'	Date	Required
totalInstructionalDays	E0935	NUMBER-DAYS-TAUGHT	Sum of insession days between t.firstday and t.lastday total ADSY days for from xt for term descriptor '9'	Integer	Required
additional fields for display only
	sch.school_name	district view only		N/A