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 | 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 | Y | TEA-specified EducationOrganizationId for State courses | ||||
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.
| |||
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 sectionperiod 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. | ||
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.
| |||
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 | ||
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
| ||
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)
| ||
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 | TX | Changed from array to single element Jul 2023 spec
| ||
additional fields for display only | |||||||
district view only |