Schedules

This category carries the education course offerings and the related course sections for each school. The Organization Schedules category includes the following data views and resources:

Course Offerings

This view captures the detailed list of Course Offerings as published in the CourseOffering resource within the Organization Schedules category. The layout includes the School Name, Course Number, Course Name, Section Number, Term, Last Publish Date, and the Publishing ID.

courseOffering

This resource represents an entry in the course catalog of available courses offered by the school during a session.

Primary PowerSchool Source Data

[Courses]
[Sections]
[Terms]
SECTIONS (sec), COURSES (crs), TERMS (t), COURSESCOREFIELDS (ccf),
S_TX_USR_RESP_C, S_TX_SEC_X, STOREDGRADES (sgr), S_TX_SGR_X (sgrx)

Four sources for Course Offerings and Sections:
1. Sections taught at selected school
- Standard case
2. Sections taken by students enrolled in selected school that are taught at a reportable school with a different State Id
- Publish section record at selected school
3. Sections taken by students enrolled in selected school that are taught at a non-reportable school
- School is excluded from state reporting
- S_TX_SCH_SCHOOLS_X.Non_Reportable_Campus = 1
- Publish section record at selected school
4. Manually-entered Stored Grades
- StoredGrades.SectionId = 0
- Courses completed in current year at a reportable school in the district
- sgrx begin_date and end_date not null and during school year
- Course Sequence sgrx.E0948 is not null

Selection Criteria

Records are published if the following criteria are met:

One CourseOffering per term for each downloaded or published course that has at least one section taught.
- Courses excluded if:
  - alt_course_number is null (courses or sections/grades overrides)
  - and not found in published local courses
  - dependency options TBD
- Series 8 courses included and any other courses published locally
- Courses excluded if flagged to exlude from PEIMS/TSDS
  - flag found in extension on Courses, Sections, StoredGrades
  - Courses and Sections flag is Exclude_From_090 = 1
  - StoredGrades flag is sgrx.Exclude_From_415 = 1
- Sections excluded if:
  - sec.Exclude_State_Rpt_YN = 1
  - sch.State_ExcludeFromReporting = 1 (see exceptions, case 3 above)
Some course sequence codes require publishing multiple Course Offerings from the same section record
- S_TX_SEC_X.E0948_Course_Seq_Calc
- Calc value in 'Y2', 'Y3', 'Y4', 'X1', 'X2', may have 'D' prefix
- Ignore override value in S_TX_SEC_X.E0948
- See Course Sequence field in Sections

Resource Output

A separate courseOffering record is published for each unique combination of course and section scheduled at each school based on the year for the Term selected in the PowerSchool UI.
Note: In PowerSchool, section records and courseOffering records are essentially the same; the ensuing Ed-Fi section record within the Organization Schedules category adds location and period information.
The courseOffering resource is dependent on the prior publishing of the following resources: session.
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.

Data Element	TX Element	Description	Data Type	Stored in [Table]Field	Required?
SchoolId	E0266	CAMPUS-ID SchoolId – The school for the class period.	Integer	SchoolId downloaded from State Derived from: [Sections]SchoolID Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases	Required
localCourseCode	E1194	LOCAL-COURSE-CODE The local code assigned by the School that identifies the course offering provided for the instruction of students.	Varchar(20)	COURSES.course_number - cases 1-3 case 4 - StoredGrades.course_number if not null otherwise S_TX_SGR_X.Alt_course_Number	Required
courseReference
courseCode	E0724	SERVICE-ID Publishes CourseOfferings for sections of published courses. Includes sections of courses with alt_course_number includes sections with alt_course_number override includes any of the above taught at remote school includes storedgrades with alt_course_number override All state course numbers are 8 characters State course codes beginning with 8 not in downloads possibly others, e.g. beginning with SA, SE, SR, SS courses with alt_course_number not in downloads are published locally where not excluded from publishing Special Handling - Andrew Classes taught at a school that shares the reportable School ID of another school Remote classes taught at reportable schools Remote classes taught at specific non-reportable schools (which are also set as Exclude from State Reporting) Manual entry StoredGrades for courses completed in current year at a reportable school in the district. SGR ext has dates and other required data. Class ID is unique for each kid. ODS state courses use C022 SERVICE_ID as state course codes.		Legacy source varies by the TSDS or PEIMS Collection Fall PEIMS and PEIMS Extended Year from Staff Responsibilites: S_TX_USR_RESP_C.E0724_Service_ID Staff course reference, not used for publishing Schedule resources) Class Roster and Summer PEIMS (Schedule resources): Stored Grades Override: S_TX_SGR_X.Alt_Course_Number (if populated) Section Override: S_TX_SEC_X.Alt_Course_Number (if populated) Course Default: COURSESCOREFIELDS.alt_course_number Courses/StoredGrades Course_Number is not used as a state course code future: when general local courses are added to publishing then course_number will be used as course_code for local couses where: no alt_course_number exists course or section is not otherwise excluded from publishing	Required
educationOrganizationId		1 or district number for locally-published courses	Integer	TEA-specified EducationOrganizationId for State courses = '1'	Required
sessionReference
/schoolReference/schoolIdentity	E0266	Campus ID SchoolId - The school for which the session is defined.	Integer	SchoolId downloaded from State Derived from: [Sections]SchoolID	Required
/schoolYear	E1093	SCHOOL-YEAR SchoolYearType - The identifier for the school year.	Enumerated List	[Terms]YearID	Required
sessionName	E3057	Session Name		[Sections]TermID [Terms]Portion [Terms]Abbreviat	Required
localCourseTitle	N/A	The descriptive name given to a course of study offered in the school, if different from the courseTitle.	Varchar(60)	[Courses]Course_Name	Optional

Sections

This view captures the course sections offered at each school as published in the Section resource of the Organization Schedules category. The layout includes the School Name, Course Number, Course Name, Section Number, Period Number, Last Publish Date, and the Publishing ID.

section

This resource represents a setting in which organized instruction of course content is provided, in-person or otherwise, to one or more students for a given period of time. In Ed-Fi, a course offering may be scheduled for more than one section, but for PowerSchool there is a one-to-one correspondence between each course offering and its corresponding section.

Primary PowerSchool Source Data

Tables: SECTIONS (sec), COURSES (crs), TERMS (t)
S_TX_USR_RESP_C
S_TX_SGR_X
S_TX_SEC_X
S_TX_CRS_X

Selection Criteria

One record published for each section scheduled during the school year where:

School not excluded from state reporting
CourseOffering is published (see CourseOffering seleciton criteria)
Section is scheduled
Excluded if S_CRS_X.excludefromEdFi = 1 or sec.exclude_state_rpt_YN = 1
Excluded if corresponding courseOffering excluded
Excluded if S_TX_SEC_X.Exclude_From_090 = 1
Excluded if no students enrolled

Special Handling - see also selection criteria for Course Offerings

Classes taught at a school that shares the reportable School ID of another school
Remote classes taught at reportable schools
Remote classes taught at specific non-reportable schools (which are also set as Exclude from State Reporting).
For scenarios 2 & 3 above, we report remote classes under the Home School ID's of the students enrolled in the class. We "fabricate" as many section records as needed: if a class has 5 students from 5 different schools, we report 5 records - each with a different School ID.
Publish scheduled section as multiple sections in terms contained in scheduling term, as specified by course sequence (see below)

Resource Output

A section record is published for each unique combination of school, course, and section based on the year for the Term selected in the PowerSchool UI.
Each section record will also contain mandatory references to the courseOffering, location, and classPeriod resources as contained in the Education Organization and Organization Schedules categories.
Note: In PowerSchool, section records and courseOffering records are essentially the same; the Ed-Fi section record adds location and period information.
The section resource is dependent on the prior publishing of the following resources: courseOffering, session, location, and classPeriod.
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.

Data Element	TX Element	Description	Data Type	Stored in [Table]Field	Submission
sectionIdentifier	E1056	A unique identifier for the section that is defined by the classroom, the subjects taught, and the instructors that are assigned.	Varchar(255)	Scheduled Sections: S_TX_SEC_X.E1056_SectionIden_Calc Sections generated from manually-entered Stored Grades (sectionid = 0): S_TX_SGR_X.E1056_SectionIden_Calc Use calc fields in every case Replaces legacy CLASS-ID-NUMBER E1056 - 14-char code, left-zero-padded if necessary, calculated for scheduled sections based on District Setup with overrides available in Section & Stored Grades First segment of section identifier is legacy Class-ID-Number.	Required
courseOfferingReference/courseOfferingIdentity The course offering taught in the section.
/localCourseCode	E1194	LOCAL-COURSE-CODE The local code assigned by the LEA or Campus that identifies the organization of subject matter and related learning experiences provided for the instruction of students. This must match localCourseCode in corresponding courseOffering.	Varchar(20)	crs.course_number	Required
/schoolID	E0266	CAMPUS-ID – The school offering the course. This must match schoolID in corresponding courseOffering.	Integer	SchoolId downloaded from State Derived from: [Sections]SchoolID Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases	Required
/schoolYear	E1093	SchoolYearType - The identifier for the school year, for example, 2010-2011. This must match schoolYear in corresponding courseOffering.	Integer	[Terms]YearID	Required
sessionName	E3057	The identifier for the calendar for the academic session, for example, 2010/11, 2011 Summer.	Integer	[Terms]Name	Required
locationReference/locationIdentity The location, typically a classroom, where the section meets.
/classroomIdentificationCode	Not collected by TEA.	A unique number or alphanumeric code assigned to a room by a school, school system, state, or other agency or entity.	Varchar(20)	Classes taught at a school that shares the reportable School ID of another school Remote classes taught at reportable schools Remote classes taught at specific non-reportable schools (which are also set as Exclude from State Reporting). FORMAT: substr(to_char(sec.schoolid) \|\| '-' \|\| coalesce(trim(sec.room), 'Open'), 1, 20) Special Handling: also include a default room of "00" (used when reporting report manual entry stored grades (00) and a default room of "99"(used when reporting remote classes (99)	Required
/SchoolId		SchoolId – The school for the section's classroom.	Integer	SchoolId downloaded from State Derived from: [Sections]SchoolID Note: [Sections]WhereTaught is not currently implemented in Ed-Fi; [Sections]SchoolID is currently used in all cases	Required
availableCredits The amount of credit available to a student who successfully meets the objectives of the course. Available credits are measured in Carnegie units. A course meeting every day for one period of the school day over the span of a school year offers one Carnegie unit.					Required
/credit		The value of credits or units of value awarded for the completion of a course.	Decimal (9,2)	[Courses]Credit_Hours	Required

TX extensions

TEA extension resource for course offerings and sessions.

Data Element	TX Element	Description	Data Type	Stored in [Table]Field	Required?
sets/sectionSet	N/A			[Array]
beginDate	E3010	TEA: first day after last day of applicability	Date	t.FirstDay	Required
endDate	E3020	The day after last day.	Date	day after t.LastDay	Required
courseSequenceDescriptor	E0948	COURSE-SEQUENCE-CODE	Descriptor	S_TX_SEC_X.E0948_Course_Seq_Calc calculated value based on: value in Courses - S_TX_CRS_X.Course_Sequence plus scheduled term(s) for the section or user override - S_TX_SEC_X.E0948_Course_Seq_Override Manually-entered StoredGrades (SectionId = 0): S_TX_SGR_X.E0948 (use section calc value if sectionid > 0) if blank use course value in S_TX_CRS_X.Course_Sequence Dual Credit Courses are automatically output with a "D" prefix in the Course Sequence Code if the course is flagged as Dual Credit (value of 1) based on these sources: Stored Grades: S_TX_SGR_X.Dual_Credit Sections: S_TX_SEC_X.E1011_Dual_Credit Courses: S_TX_CRS_X.E1011_Dual_Credit These additions are included in the calculated value Calculated value stored in S_TX_SEC_X.E0948_Course_Seq_Calc values A, 0, 1, 2, 6, 7, 8, 9 publish as entered (TX descriptor values) may have prefix 'D' for Dual Credit flag other values rquire publishing section record as multiple sections same section identifieer but different session references Y2 - Full year section, publish as 2 semester sections Y3 - Full year section, publish as 3 trimester sections Y4 - Full year section, publish as 4 quarter sections X1 - S1 section, publish as Q1 and Q2 sections X2 - S2 section, publish as Q3 and Q4 sections	Required
nonCampusBasedInstructionDescriptor	E1072	NON-CAMPUS-BASED-INSTRUCTION-CODE	Descriptor	S_TX_SGR_X.Non_Campus_Based_Instr Sections: S_TX_SEC_X.E1072_Non_Campus_Based_Instr Courses: S_TX_CRS_X.E1072	Required
pkCurriculaDescriptor	E1579	PK-CURRICULA	Descriptor	S_TX_SEC_X.E1579_PK_Curricula S_TX_CRS_X.E1579_PK_Curricula S_TX_SCH_SCHOOLS_X.E1579_PK_Curricula District Default: Prefs where name = 'E1579' If S_TX_XEC_X.EE1579_PK_Curricula blank, publish from other sources only if: state course code = '01010000' and E1440_Homeroom_section = 1 in S_TX_SEC_X or S_TX_CRS_X	Required
pkSchoolTypeDescriptor	E1555	PK-SCHOOL-TYPE	Descriptor	Section Level: S_TX_SEC_X.E1555_PK_SCHOOL_TYPE School Level: S_TX_SCH_SCHOOLS_X.E1555 District: Prefs where name = 'E1555' If S_TX_SEC_X.E1555_PK_SCHOOL_TYPE blank, publish from other sources only if: state course code = '01010000' and E1440_Homeroom_section = 1 in S_TX_SEC_X or S_TX_CRS_X	Required
pkStudentInstructionDescriptor	E1558	STUDENT-INSTRUCTION	Descriptor	STUDENT-INSTRUCTION E1558 S_TX_SEC_X.E1558_Student_Instruction If blank, default of 01 - Full Day is reported. If S_TX_SEC_X.E1558_Student_Instruction blank, publish from other sources or default only if: state course code = '01010000' and E1440_Homeroom_section = 1 in S_TX_SEC_X or S_TX_CRS_X	Required
populationServedDescriptor	E0747	POPULATION-SERVED-CODE	Descriptor	Section Override: S_TX_SEC_X.E0747_Population_Served Course: S_TX_CRS_X.E0747_Population_Served
gradeLevelDescriptor	E0017	GRADE-LEVEL-CODE	Descriptor	S_TX_USR_RESP_C.E0017_Grade_Level_Code PK sections are required to contain only PK students (PS grade_level < 0) For multiple grade levels above PK, use the highest.
highQualityPKProgram	E1580	HIGH-QUALITY-PK-PROGRAM-INDICATOR	VARCHAR	S_TX_SEC_X.E1580_High_Qual_PK_Prog S_TX_SCH_SCHOOLS_X.E1580_High_Qual_PK_Prog District Default: Prefs where name = 'E1580' If S_TX_SEC_X.E1580_High_Qual_PK_Prog blank, publish from other sources only if: state course code = '01010000' and E1440_Homeroom_section = 1 in S_TX_SEC_X or S_TX_CRS_X	Required
classTypeDescriptor	E1055	CLASS-TYPE-CODE	Descriptor	S_TX_USR_RESP_C.E1055_Class_Type S_TX_SEC_X.E1055_Class_Type S_TX_CRS_X.E1055_Class_Type	Required
cteHours	E3011	CTEHours	Integer	S_TX_SEC_X.Vocational_Contact_Hours S_TX_CRS_X.Vocational_Contact_Hours	Required
childCareOperationNumber	E1726	CHILD-CARE-OPERATION-NUMBER	Integer	LEA level: S_TX_ChildCareOps_S.ChildCareOpNum School override: S_TX_CRS_X.E1726_Child_Care_Operator Section override: S_TX_SEC_X.E1726_Child_Care_Operator If S_TX_SEC_X.E1726_Child_Care_Operator blank, publish from other sources only if: state course code = '01010000' and E1440_Homeroom_section = 1 in S_TX_SEC_X or S_TX_CRS_X	Required
Additional fields for display only
				sch.school_name
				COURSES.course_name
				SECTIONS.section_number
				TERMS.abbreviation