Organization 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:

courseOfferings

eSP Source Data

Tables: SCHD_MS (ms), SCHD_COURSE (crs), REG_BUILDING (rb)

Selection Criteria

Sections taken at same building as enrollment or building with same state Id (diff from DE/Base Profile):
A CourseOffering is published for each SCHD_MS course section record in current school year where:

Building is not transfer building, not out-of-district
State course code is defined for course (see below)
- State course codes not in downloads are published locally
- Course not excluded from publsihing

Sections taken at building with different or no state id - Similar handling of remote sections to PS

Created during 'download' processing. See section on staff responsibilities, TX_090 table.
- Does not include summer sections, will have remote sections for fall
- Remote sections for summer from TX_305 (staff assignments)

Hand-entered grades (e.g. college course) - goes to student's Transcript record.

Creates new section of course in SCHD_MS for student's enrollment, relatively straightforward
Does not have period or teacher (because not at building), but almost like regularly scheduled course.

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
courseOfferings
	schoolId		E0266	CAMPUS-ID	schd_ms.building	Y - key	for remote sections use building of student enrollment
	localCourseCode		E1194	LOCAL-COURSE-CODE	schd_ms.course + '-' + schd_ms.course_section; add '-S' summer_school = 'Y'	Y - key	same as Base Profile rules; for remote sections use schd_ms record where section was taken.
	courseReference					Y
		courseCode	E0724	SERVICE-ID	mr_crsequ_det.state_id where mr_crsequ_det.school_year = schd_ms.school_year and (mr_crsequ_det.building = schd_ms.building or mr_crsequ_det.building = -1) and mr_crsequ_det.course = schd_ms.course and mr_crsequ_det.course_section = '0' (state course code) if null, then not published; future: if null then SCHD_COURSE.COURSE	Y	TEA plans to have districts publish courses with Service ID's beginning in SA, SE, SR, SS, or 8 locally
		educationOrganizationId			downloaded courses (state): 1 local courses (if published): schd_course.building if > 0 else schd_course.district	Y	TEA-specified EducationOrganizationId for State courses local courses with state course code not in download are published publishing courses without a state course code planned for later enhancement
	sessionReference					Y - key
		schoolId	E0266	CAMPUS-ID	schd_ms.building	Y	building where section was taught - for remote sections will be different schoolid from courseOffering schoolid
		schoolYear	E1498	SCHOOL-YEAR	schd_ms.school_year	Y
		sessionName	E3057		term descriptor short description	Y	calculated from marking periods for section using logic in Sessions resource. Terms from REG_MP_WEEKS (mpw) linked to SCHD_MS (ms) via SCHD_MS_MP (msmp) msmp.section_key = ms.section_key mpw.marking_period = msmp.marking_period and mpw.building = ms.building and mpw.school_year = ms.school_year Note that a trimester calendar may have 4 marking periods but only 3 terms, with 2 marking periods having the same term number.
	localCourseTitle				schd_ms.description	N
	additional fields for display only
					sch.school_name		district view only
					TERMS.abbreviation

sections

eSP Source Data

Tables: SCHD_MS (ms), SCHD_MS_SESSION (mss), REG_BUILDING (rb), SCHD_PERIOD (sp), SCHD_MS_MP (smp), SCHD_MS_SUBJ (sub)

Selection Criteria

Sections taken at same building as enrollment or building with same state Id (diff from DE/Base Profile):
One section record is published for each SCHD_MS course section record in current school year where:

building is not transfer building, not out-of-district
state course code is defined for course (see below)
excluded if no students enrolled
Multiple SCHD_MS_SESSION records are included in the same section
period array is optional, not collected by TEA
- if published, include unique periods from all SCHD_MS_SESSION records for section
location is optional, not collected by TEA
- if published, use one location (min, max, rownum=1)

Sections taken at building with different or no state id - Similar handling of remote sections to PS

created during 'download' processing. See section on staff responsibilities, TX_090 table.
- doesn't include summer sections, will have remote sections for fall
- remote sections for summer from TX_305 (staff assignments)

Hand-entered grades (e.g. college course) - goes to student's Transcript record.

creates new section of course in SCHD_MS for student's enrollment, relatively straightforward
doesn't have period or teacher (because not at building), but almost like regularly scheduled course.

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
sections
	sectionIdentifier		E1056	CLASS-ID-NUMBER	schd_ms_session.section_key, left zero-padded to 14 chars	Y - key	Needs to be 14 chars, currently using section key left-padded to 14 chars. publish multiple MSS as single section, sections correspond 1:1 to courseOfferings for remote sections use schd_ms record where section was taken.
	courseOfferingReference					Y - key
		localCourseCode	E1194	LOCAL-COURSE-CODE	schd_ms.course + '-' + schd_ms.course_section; add '-S' summer_school = 'Y'	Y	same as Base Profile rules; for remote sections use schd_ms record where section was taken.
		schoolId	E0266	CAMPUS-ID	schd_ms.building	Y	for remote sections use building of student enrollment
		schoolYear	E1093	SCHOOL-YEAR	schd_ms.school_year	Y
		sessionName	E3057		term descriptor short description	Y	calculated from marking periods for section using logic in Sessions resource. Terms from REG_MP_WEEKS (mpw) linked to SCHD_MS (ms) via SCHD_MS_MP (msmp) msmp.section_key = ms.section_key mpw.marking_period = msmp.marking_period and mpw.building = ms.building and mpw.school_year = ms.school_year Note that a trimester calendar may have 4 marking periods but only 3 terms, with 2 marking periods having the same term number.
	locationReference					N	Ed-Fi v3 does not require room info on sections, not collected by TEA.
		classroomIdentificationCode			schd_ms_session.room_id	Y
		schoolId			schd_ms.building	Y	building where section was taught - for remote sections will be different schoolid from section locationSchoolReference
	locationSchoolReference					N
		schoolId			schd_ms.building	Y	for remote sections use building of student enrollment
	classPeriods				[Array]	N
		classPeriodName			schd_ms_session.start_period, schd_ms_session.end_period	Y	start_period and end_period used to find start and end period_order, all periods published between start and end period_order
		schoolId			schd_ms.building	Y	building where section was taught - for remote sections will be different schoolid from section locationSchoolReference
	availableCredits				schd_ms_session.credit	N
	sequenceOfCourse				schd_ms_session.course_session	Y
	TX extensions					TX
		sets/sectionSet			[Array]	TX
		beginDate	E3010		session beginDate	TX
		endDate	E3020		day after session endDate	TX
		courseSequenceDescriptor	E0948	COURSE-SEQUENCE-CODE	schd_ms_user.field_value where screen_number = '100' and field_number = '8'	TX	join to schd_ms on schd_ms.section_key; multiple entries not currently supported for screen_number 100 screen_type 'C'
		nonCampusBasedInstructionDescriptor	E1072	NON-CAMPUS-BASED-INSTRUCTION-CODE	schd_ms_user.field_value where screen_number = '100' and field_number = '16'	TX	join to schd_ms on schd_ms.section_key
		pkCurriculaDescriptor	E1579	PK-CURRICULA	schd_ms_user.field_value where screen_number = '100' and field_number = '21'	TX	join to schd_ms on schd_ms.section_key Convert to state_code_equiv from TXTB_C206 (UI validation table)
		pkSchoolTypeDescriptor	E1555	PK-SCHOOL-TYPE	schd_ms_user.field_value where screen_number = '100' and field_number = '22'	TX	join to schd_ms on schd_ms.section_key
		pkStudentInstructionDescriptor	E1558	STUDENT-INSTRUCTION	schd_ms_user.field_value where screen_number = '100' and field_number = '25'	TX	join to schd_ms on schd_ms.section_key Publish default only on ECDS Homeroom section: ECDS: Service Id for section (CourseOffering.CourseCode) = 01010000 (PK) Homeroom section: SCHD_MS_USER.field_value = 'Y' where SCHD_MS_USER.section_key = ms.section_key and SCHD_MS_USER.screen_number = 100, field_number = 24
		populationServedDescriptor	E0747	POPULATION-SERVED-CODE	schd_ms_user.field_value where screen_number = '100' and field_number = '1'	TX	join to schd_ms on schd_ms.section_key
		gradeLevelDescriptor	E0017	GRADE-LEVEL-CODE	schd_ms_grade.restrict_grade	TX	Reverted to old model - grade level assigned to a given section_key (SPED students) eSP districts create separate sections in SIS for PK and non-PK SPED students, no special processing needed Asked TEA to calculate on their side since they have enrolled students and their DOB TEA is reviewing for possible 2024-25 implementation
		highQualityPKProgram	E1580	HIGH-QUALITY-PK-PROGRAM-INDICATOR	schd_ms_user.field_value where screen_number = '100' and field_number = '23'	TX	join to schd_ms on schd_ms.section_key
		classTypeDescriptor	E1055	CLASS-TYPE-CODE	schd_ms_user.field_value where screen_number = '100' and field_number = '10'	TX
		cteHours	E3011		schd_ms_user.field_value where screen_number = '100' and field_number = '6'	TX	Publish only if value > 0.
		childCareOperationNumber	E1726	CHILD-CARE-OPERATION-NUMBER	SCHD_MS_USER.field_value where screen_number = 100 and field_number = 28 If blank, then REG_USER_BUILDING where screen_number = 101 and field_number = 28	TX	Changed from array to single element Jul 2023 spec Publish from REG_USER_BUILDING only on ECDS Homeroom section: ECDS: Service Id for section (CourseOffering.CourseCode) = 01010000 (PK) Homeroom section: SCHD_MS_USER.field_value = 'Y' where SCHD_MS_USER.section_key = ms.section_key and SCHD_MS_USER.screen_number = 100, field_number = 24 Validation table: TXTB_CHILD_CARE_FACILITIES
	additional fields for display only
							district view only