eSchoolPlus Texas
eSchoolPlus Texas
Breadcrumbs

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

  1. 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

  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.

    • Does not include summer sections, will have remote sections for fall

    • Remote sections for summer from TX_305 (staff assignments)

  1. 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

  1. 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)

  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)

  1. 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