Local Course Catalog

courses

eSP Source Data

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

Selection Criteria

One record published for each local course that is not in the downloaded set of state courses where:

Course is not excluded from Ed-Fi or otherwise excluded from publishing

Minimal set needed for TEA:

Series 8 courses - state course code begins with 8
The first 5 characters should match a downloaded state course code
State course code beginning with SA, SE, SR, or SS if not in course downloads

Current local course selection:

Publishes all courses with state course code spedified but not in downloads, not excluded from publishing

Future local course selection:

Also publish courses with no state course code specified, not excluded from publishing.

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
courses
	courseCode				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
	identificationCodes				[Array]	Y	Publish local and state identifiers
		courseIdentificationSystemDescriptor	E1089		'LEA course code'; 'State course code'	Y	core Ed-Fi descriptors
		identificationCode - LEA Code	E1194		SCHD_COURSE.COURSE	Y
		identificationCode - State Code	E0724		mr_crsequ_det.state_id where mr_crsequ_det.school_year = schd_ms.school_year and mr_crsequ_det.building = schd_ms.building and mr_crsequ_det.course = schd_ms.course and mr_crsequ_det.course_section = '0'	C
	educationOrganizationId		E0266		schd_course.building if > 0 else schd_course.district	Y	format for publishing
	academicSubjectDescriptor				regtb_department.state_code_equiv from schd_course.department	N	Existing state_code_equiv values not TX descriptors; Options: 1 - Map regtb_department.code values to downloaded descriptors; 2 - Publish regtb_department.code values as local descriptors 3 - Skip, not required (recommended for now)
	courseTitle				SCHD_COURSE.DESCRIPTION	Y
	levelCharacteristics				[Array]	N	Not collected by TEA, no descriptors defined, skip for now
		courseLevelCharacteristicDescriptor			no eSP source identified	Y	Base Profile uses MR_LEVEL_HDR.Level_Number, mapped to descriptors
	maxAvailableCredits				crs.maxcredit	O
	minAvailableCredits				crs.credit_hours	O
	numberOfParts				no eSP source, publish '1'	Y	Publish '1' if no eSP source