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