eSchoolPlus Texas
eSchoolPlus Texas
Breadcrumbs

Attendance

studentSchoolAttendanceEvents

eSP Source Data

Tables: ATT_STU_DAY_TOTALS (asdt), ATT_CODE (ac), REG_ENTRY_WITH (rew), REG_BUILDING (rb)

Selection Criteria

ATT_STU_DAY_TOTALS is a summary table updated nightly by eSchoolPlus.


One attendance event published for each entry in ATT_STU_DAY_TOTALS where:

  • ac.state_code_equiv is not null (set only for state codes).

  • The student is enrolled in school on the attendance date.

Notes:

  • Only negative attendance is published

  • Base Profile uses attendance code mapping; expect State_Code_Equiv will be suitable for TX.

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

studentSchoolAttendanceEvents









attendanceEventCategoryDescriptor

E3008

N/A

att_stu_day_totals.attendance_code, att_code.state_code_equiv 

Y

N/A


eventDate

E3027

N/A

att_stu_day_totals.attendance_date

Y

N/A


schoolId


N/A

N/A

att_stu_day_totals.building

Y

N/A


sessionReference

N/A

N/A


Y

Q: Does TEA need Reporting Period reference, or do we publish for whole school year?



schoolId

N/A

N/A

att_stu_day_totals.building

Y

N/A



schoolYear

N/A

N/A

att_stu_day_totals.school_year

Y

N/A



sessionName

N/A

N/A


Y

N/A


studentUniqueId

N/A

N/A

deroved from att_stu_day_totals.student_id

Y

N/A


attendanceEventReason

N/A

N/A

max(substring(att_bottomline.att_comment, 1, 40))

N

where att_bottomline is for same date, student, building, attendance_code


eventDuration

E3053

N/A

att_stu_day_totals.att_code_value

TX

percentage of day


additional fields for display only

N/A

N/A





N/A

N/A

N/A

N/A

N/A

N/A

district view only - from sp.schoolid


N/A

N/A

N/A

N/A

N/A

N/A



N/A

N/A

N/A

N/A

N/A

N/A



N/A

N/A

N/A

N/A

N/A

N/A

grade level from most recent enrollment in selected year


studentSectionAttendanceEvents

eSP Source Data

Tables: ATT_BOTTOMLINE (ab), ATT_CODE (ac), ATT_CFG (cfg), ATT_PERIOD (ap), SCHD_PERIOD (sp), REG_BUILDING (rb),
SCHD_STU_CRS (sc), SCHD_STU_CRS_DATES (scd), SCHD)MS (ms), SCHD_MS_SESSION (mss),
SCHD_MS_MP (smp), REG_MP_DATES (mpd)

Selection Criteria

One section attendance event published for each attendance event descriptor per student section in ATT_BOTTOMLINE where:

  • ac.state_code_equiv is not null (valid state code)

  • The student is enrolled in school and section on attendance date

  • Attendance date is during a section marking period

  • Attendance period is valid class period for the section

Section attendance is published per student per section per descriptor:

  • grouped by period, multiple periods reflected in duration
    Note: only negative attendance is published

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


Resource

Data Element

Description

TX Element

TX Element Name

eSP Source

Required?

Comments

studentSectionAttendanceEvents









attendanceEventCategoryDescriptor

N/A

N/A

coalesce(ac.state_code_equiv, ac.state_group) from ab.attendance_code

Y

where ac.attendance_code = ab.attendance_code for same school and year
trim(coalesce(ac.STATE_CODE_EQUIV, ac.STATE_GROUP))


eventDate

N/A

N/A

ab.attendance_date

Y



classPeriods

N/A

N/A

[Array]

N

Include all class periods to which the attendanceEventCategoryDescriptor applies (not collected by TEA)



classPeriodName

N/A

N/A

ap.period_value from ab.attendance_period and sp.code

Y

where ap.attendance_period = ab.attendance_period and ap.period_value = sp.code, for same school, year,and summer_school flag
replace(trim(ap.PERIOD_VALUE), ' ', '')



schoolId

N/A

N/A

att_bottomline.building

Y



sectionReference

N/A

N/A


Y

derived from att_bottomline.attendance_period and student section schedule



localCourseCode

N/A

N/A

schd_ms.course + '-' + schd_ms.course_section, add '-S' summer_school = 'Y'

Y

from schd_stu_course, schd_ms
same as Base Profile rules; for remote sections use schd_ms record where section was taken.



schoolId

N/A

N/A

att_bottomline.building

Y




schoolYear

N/A

N/A

att_bottomline.school_year

Y




sectionIdentifier

N/A

N/A

ms.section_key

Y

from schd_stu_course, schd_ms
publish multiple MSS as single section, sections correspond 1:1 to courseOfferings
for remote sections use schd_ms record where section was taken



sessionName

N/A

N/A

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.


studentUniqueId

N/A

N/A

ru.field_value where ru.screen_number = 10165, ru.field_number = 1

Y

from ab.student_id


attendanceEventReason

N/A

N/A

substring(ab.att_comment, 1, 40)

N



additional fields for display only

N/A

N/A

N/A

N/A





N/A

N/A

N/A

N/A

district view only - most recent enrolled school in selected year




N/A

N/A

N/A

N/A





N/A

N/A

N/A

N/A





N/A

N/A

N/A

N/A

grade level from most recent enrollment in selected year




N/A

N/A

N/A

N/A